{ "tables": [], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 4001783.9519999996, "xmin": -1.2463935263799999E7, "ymax": 4008677.315700002, "xmax": -1.24537272862E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Complete", "allowTrueCurvesUpdates": false, "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "assistance", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assistance", "length": 255, "alias": "Assistance", "type": "esriFieldTypeString" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r4674_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4198_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "3e8531e219c5404db0d768eeb7498933", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [ { "templates": [ { "name": "", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": {"assistance": null} } } ], "name": "", "domains": {}, "id": null }, { "templates": [ { "name": "Yes", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": {"assistance": "Yes"} } } ], "name": "Yes", "domains": {}, "id": "Yes" } ], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "assistance", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "uniqueValueGroups": [ { "heading": "Assistance", "classes": [ { "symbol": { "outline": { "color": [ 110, 110, 110, 255 ], "width": 0.7, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 200, 179, 252, 0 ], "style": "esriSFSSolid", "type": "esriSFS" }, "values": [ [ "" ] ], "description": "", "label": "" }, { "symbol": { "outline": { "color": [ 245, 122, 122, 255 ], "width": 2, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 230, 152, 0, 255 ], "style": "esriSFSBackwardDiagonal", "type": "esriSFS" }, "values": [ [ "Yes" ] ], "description": "Yes", "label": "Yes" } ] } ], "field1": "assistance", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 212, 210, 252, 255 ], "fromColor": [ 212, 210, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 183, 252, 182, 255 ], "fromColor": [ 183, 252, 182, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 216, 184, 255 ], "fromColor": [ 252, 216, 184, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 184, 251, 252, 255 ], "fromColor": [ 184, 251, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 182, 205, 255 ], "fromColor": [ 252, 182, 205, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 233, 252, 212, 255 ], "fromColor": [ 233, 252, 212, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 232, 182, 252, 255 ], "fromColor": [ 232, 182, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 250, 252, 179, 255 ], "fromColor": [ 250, 252, 179, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 212, 214, 255 ], "fromColor": [ 252, 212, 214, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 189, 252, 220, 255 ], "fromColor": [ 189, 252, 220, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 179, 179, 252, 255 ], "fromColor": [ 179, 179, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 215, 237, 252, 255 ], "fromColor": [ 215, 237, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 199, 244, 255 ], "fromColor": [ 252, 199, 244, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" } }, "defaultSymbol": { "outline": { "color": [ 110, 110, 110, 255 ], "width": 0.7, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 130, 130, 130, 255 ], "style": "esriSFSSolid", "type": "esriSFS" }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "outline": { "color": [ 110, 110, 110, 255 ], "width": 0.7, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 200, 179, 252, 0 ], "style": "esriSFSSolid", "type": "esriSFS" }, "label": "", "value": "" }, { "symbol": { "outline": { "color": [ 245, 122, 122, 255 ], "width": 2, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 230, 152, 0, 255 ], "style": "esriSFSBackwardDiagonal", "type": "esriSFS" }, "label": "Yes", "value": "Yes" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 3999915.3445999995, "xmin": -1.24639062166E7, "ymax": 4009648.3369000033, "xmax": -1.24530601772E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 14, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "PlanRef_2023", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "comments": null, "planref": null, "planlink": null, "planref_1": null, "source": null, "designer": null, "project_name": null, "type": null, "approved_date": null, "cdrom": null, "sheet_count": null, "number": null, "as_built_date": null, "plan_title": null, "t_r_s": null, "planset": null, "location": null, "comments_1": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "PlanRef_2023", "allowTrueCurvesUpdates": false, "displayField": "project_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "PLANREF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "planref", "length": 50, "alias": "PLANREF", "type": "esriFieldTypeString" }, { "modelName": "PlanLink", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "planlink", "length": 100, "alias": "PlanLink", "type": "esriFieldTypeString" }, { "modelName": "Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 50, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "Source", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source", "length": 50, "alias": "Source", "type": "esriFieldTypeString" }, { "modelName": "number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "number", "alias": "Number", "type": "esriFieldTypeDouble" }, { "modelName": "planref_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "planref_1", "length": 255, "alias": "Planref_1", "type": "esriFieldTypeString" }, { "modelName": "project_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_name", "length": 255, "alias": "Project_Name", "type": "esriFieldTypeString" }, { "modelName": "plan_title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "plan_title", "length": 255, "alias": "Plan_Title", "type": "esriFieldTypeString" }, { "modelName": "type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "type", "length": 255, "alias": "Type", "type": "esriFieldTypeString" }, { "modelName": "sheet_count", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sheet_count", "alias": "Sheet_Count", "type": "esriFieldTypeDouble" }, { "modelName": "designer", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "designer", "length": 255, "alias": "Designer", "type": "esriFieldTypeString" }, { "modelName": "as_built_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "as_built_date", "length": 29, "alias": "As_built_Date", "type": "esriFieldTypeDate" }, { "modelName": "approved_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "approved_date", "length": 29, "alias": "Approved_Date", "type": "esriFieldTypeDate" }, { "modelName": "comments_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments_1", "length": 255, "alias": "Comments_1", "type": "esriFieldTypeString" }, { "modelName": "location", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 255, "alias": "Location", "type": "esriFieldTypeString" }, { "modelName": "cdrom", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cdrom", "length": 255, "alias": "CDROM", "type": "esriFieldTypeString" }, { "modelName": "t_r_s", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "t_r_s", "length": 255, "alias": "T_R_S", "type": "esriFieldTypeString" }, { "modelName": "planset", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "planset", "length": 255, "alias": "Planset", "type": "esriFieldTypeString" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g8434planref", "isUnique": false, "description": "", "fields": "planref", "isAscending": true }, { "name": "r4675_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4199_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "3e8531e219c5404db0d768eeb7498933", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": false, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 204, 204, 204, 255 ], "width": 1, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 130, 130, 130, 0 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4001880.3233999982, "xmin": -1.2463899351E7, "ymax": 4008349.896899998, "xmax": -1.24537409674E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 13, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Carefree_Service_Area", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": {"juris": null} } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": { "name": "Water System", "id": 0 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Carefree_Service_Area", "allowTrueCurvesUpdates": false, "displayField": "juris", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "JURIS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "juris", "length": 20, "alias": "JURIS", "type": "esriFieldTypeString" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r4676_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4200_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "3e8531e219c5404db0d768eeb7498933", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 1, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 130, 130, 130, 0 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4001849.539099999, "xmin": -1.24638726142E7, "ymax": 4008685.3783000037, "xmax": -1.2453812164E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "definitionQuery": "OWNEDBY = 4", "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 6, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "wServiceConnection", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "operatingdistrict": null, "datasourcetype": null, "pressurezonehgl": null, "facilityid": null, "installdate": null, "critical": 0, "meterroute": null, "pof": null, "metservice": "Yes", "readtype": null, "criticalcustomertype": null, "enabled": 1, "parcelid": null, "accountid": null, "operatingcompany": null, "gpscollectiontype": null, "bre": null, "safetyrequirements": null, "warrantydate": null, "watertype": "Potable", "gpsdate": null, "ownedby": 1, "projectid": null, "elevation": null, "mastermeter": "No", "lifecyclestatuschangedate": null, "premiseid": null, "metersize": null, "activeflag": "Active", "gpsfieldnotes": null, "servicetype": "Domestic", "system": null, "locationid": null, "datasourcereference": null, "pressurezonename": null, "gpsestacc": null, "location": null, "maintby": 1, "cof": null, "operatingdivision": null } } } ], "supportsAdvancedQueries": true, "parentLayer": { "name": "Water System", "id": 0 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "wServiceConnection", "allowTrueCurvesUpdates": false, "displayField": "pressurezonename", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 20, "alias": "Facility Identifier", "type": "esriFieldTypeString" }, { "modelName": "ACCOUNTID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accountid", "length": 30, "alias": "Account Number", "type": "esriFieldTypeString" }, { "modelName": "METSERVICE", "nullable": true, "editable": true, "defaultValue": "Yes", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "metservice", "length": 5, "alias": "Metered Service", "type": "esriFieldTypeString" }, { "modelName": "SERVICETYPE", "nullable": true, "editable": true, "defaultValue": "Domestic", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "wServicePointType", "description": "The type of service point", "type": "codedValue", "codedValues": [ { "code": "Domestic", "name": "Domestic" }, { "code": "Commercial", "name": "Commercial" }, { "code": "Industrial", "name": "Industrial" }, { "code": "Fire", "name": "Fire" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "servicetype", "length": 50, "alias": "Service Type", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "WARRANTYDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "warrantydate", "length": 29, "alias": "Warranty Date", "type": "esriFieldTypeDate" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 200, "alias": "Location Description", "type": "esriFieldTypeString" }, { "modelName": "LOCATIONID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "locationid", "length": 20, "alias": "Location Identifier", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LifeCycleStatus_94", "description": "Status of an asset", "type": "codedValue", "codedValues": [ { "code": "Abandoned", "name": "Abandoned" }, { "code": "Active", "name": "Active" }, { "code": "Cancelled", "name": "Cancelled" }, { "code": "Out of Service", "name": "Out of Service" }, { "code": "Pending", "name": "Pending" }, { "code": "Proposed", "name": "Proposed" }, { "code": "Retired / Scrapped", "name": "Retired / Scrapped" }, { "code": "Retired in Place", "name": "Retired in Place" }, { "code": "Transferred", "name": "Transferred" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "length": 20, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetOwner_75", "description": "The owner of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Unknown" }, { "code": 1, "name": "Town of Cave Creek" }, { "code": 2, "name": "City Of Phoenix" }, { "code": 3, "name": "Liberty Utilities" }, { "code": 4, "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetManager_33", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" }, { "code": 1, "name": "Cave Creek Utilities" }, { "code": 2, "name": "City of Phoenix" }, { "code": 3, "name": "Liberty Utilities" }, { "code": 4, "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintby", "alias": "Managed By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OPERATINGCOMPANY", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingCompany_27", "description": "Operating Company", "type": "codedValue", "codedValues": [ { "code": "-1", "name": "Unknown" }, { "code": "1", "name": "Cave Creek utilities" }, { "code": "2", "name": "Liberty Utilities" }, { "code": "3", "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingcompany", "length": 32, "alias": "OperatingCompany", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDIVISION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingDivision_27", "description": "Division with Operating Company", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingdivision", "length": 32, "alias": "OperatingDivision", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDISTRICT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingDistrict_38", "description": "Operating District within Operating Division", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingdistrict", "length": 32, "alias": "OperatingDistrict", "type": "esriFieldTypeString" }, { "modelName": "SYSTEM", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PWSIDNumber", "description": "Public Water System Number", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "system", "length": 20, "alias": "System", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUSCHANGEDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lifecyclestatuschangedate", "length": 29, "alias": "LifeCycleStatusChangeDate", "type": "esriFieldTypeDate" }, { "modelName": "PROJECTID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectid", "length": 15, "alias": "Project ID", "type": "esriFieldTypeString" }, { "modelName": "WATERTYPE", "nullable": true, "editable": true, "defaultValue": "Potable", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wWaterType", "description": "The type of water flowing through pipe", "type": "codedValue", "codedValues": [ { "code": "Potable", "name": "Potable Water" }, { "code": "Raw", "name": "Raw Water" }, { "code": "Reclaimed", "name": "Reclaimed Water" }, { "code": "Storm", "name": "Storm Runoff" }, { "code": "Treated", "name": "Treated Water" }, { "code": "Well", "name": "Well Water" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "watertype", "length": 50, "alias": "WaterType", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "DataSourceType", "description": "Data source of feature", "type": "codedValue", "codedValues": [ { "code": "Asbuilt", "name": "As-built Record Plan" }, { "code": "Construction", "name": "Construction Plan" }, { "code": "Conventional Survey", "name": "Conventional Survey" }, { "code": "Estimated", "name": "Estimated Feature Location" }, { "code": "Existing", "name": "Existing Records" }, { "code": "Field Measured", "name": "Field Measured" }, { "code": "Field Notes", "name": "Field Notes" }, { "code": "GPSCM", "name": "Subcentimeter GPS" }, { "code": "GPSM", "name": "Submeter GPS" }, { "code": "Markup", "name": "Markup" }, { "code": "Overall", "name": "Overall System Map" }, { "code": "Planimetric Landbase", "name": "Planimetric Landbase" }, { "code": "Record Drawing", "name": "Record Drawing" }, { "code": "Sketch", "name": "Sketch" }, { "code": "SubFoot GPS", "name": "SubFoot GPS" }, { "code": "TaxMap", "name": "Tax Map" }, { "code": "VRS Collected", "name": "VRS Collected" }, { "code": "AutoCAD Drawing", "name": "AutoCAD Drawing" }, { "code": "KML", "name": "Google Earth kml sketch" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasourcetype", "length": 20, "alias": "DataSourceType", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCEREFERENCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datasourcereference", "length": 50, "alias": "DataSourceReference", "type": "esriFieldTypeString" }, { "modelName": "ELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevation", "alias": "Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "PRESSUREZONENAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressurezonename", "length": 50, "alias": "PressureZoneName", "type": "esriFieldTypeString" }, { "modelName": "PRESSUREZONEHGL", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressurezonehgl", "alias": "PressureZoneHGL", "type": "esriFieldTypeInteger" }, { "modelName": "METERROUTE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "meterroute", "length": 30, "alias": "Meter Route", "type": "esriFieldTypeString" }, { "modelName": "PREMISEID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "premiseid", "alias": "PremiseID", "type": "esriFieldTypeInteger" }, { "modelName": "PARCELID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parcelid", "length": 32, "alias": "ParcelID", "type": "esriFieldTypeString" }, { "modelName": "READTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ReadType", "description": "Meter reading technology type", "type": "codedValue", "codedValues": [ { "code": "AMI", "name": "AMI" }, { "code": "AMR", "name": "AMR" }, { "code": "Manual Electronic", "name": "Manual Electronic" }, { "code": "Manual Paper", "name": "Manual Paper" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "readtype", "length": 20, "alias": "ReadType", "type": "esriFieldTypeString" }, { "modelName": "METERSIZE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "MeterSize", "description": "Diameter of water meter", "type": "codedValue", "codedValues": [ { "code": 0.625, "name": "5/8\"" }, { "code": 0.75, "name": "3/4\"" }, { "code": 1, "name": "1\"" }, { "code": 1.5, "name": "1 1/2\"" }, { "code": 2, "name": "2\"" }, { "code": 3, "name": "3\"" }, { "code": 4, "name": "4\"" }, { "code": 6, "name": "6\"" }, { "code": 8, "name": "8\"" }, { "code": 10, "name": "10\"" }, { "code": 12, "name": "12\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "metersize", "alias": "MeterSize", "type": "esriFieldTypeDouble" }, { "modelName": "CRITICAL", "nullable": true, "editable": true, "defaultValue": 0, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "critical", "alias": "CriticalCustomer", "type": "esriFieldTypeSmallInteger" }, { "modelName": "CRITICALCUSTOMERTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "CriticalCustomer", "description": "Customer types that require advanced or urgent outage notification", "type": "codedValue", "codedValues": [ { "code": "Dialysis", "name": "Dialysis" }, { "code": "Hospital", "name": "Hospital" }, { "code": "School", "name": "School" }, { "code": "Industrial", "name": "Industrial" }, { "code": "BulkSales", "name": "Bulk Sales" }, { "code": "BulkPurchase", "name": "Bulk Purchase" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "criticalcustomertype", "length": 20, "alias": "CriticalCustomerType", "type": "esriFieldTypeString" }, { "modelName": "MASTERMETER", "nullable": true, "editable": true, "defaultValue": "No", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "mastermeter", "length": 4, "alias": "MasterMeter", "type": "esriFieldTypeString" }, { "modelName": "GPSCOLLECTIONTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpscollectiontype", "length": 25, "alias": "GPSCollectionType", "type": "esriFieldTypeString" }, { "modelName": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPS_Date", "type": "esriFieldTypeDate" }, { "modelName": "GPSESTACC", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsestacc", "alias": "GPSEstAcc", "type": "esriFieldTypeDouble" }, { "modelName": "GPSFIELDNOTES", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsfieldnotes", "length": 100, "alias": "GPSFieldNotes", "type": "esriFieldTypeString" }, { "modelName": "SAFETYREQUIREMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "safetyrequirements", "length": 30, "alias": "Safety Requirements", "type": "esriFieldTypeString" }, { "modelName": "COF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cof", "alias": "Consequence of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "POF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pof", "alias": "Probability of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "BRE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bre", "alias": "Business Risk Exposure", "type": "esriFieldTypeInteger" }, { "modelName": "CREATEEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "createeditor", "length": 20, "alias": "Creation User", "type": "esriFieldTypeString" }, { "modelName": "CREATEDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "createdate", "length": 29, "alias": "Date Created", "type": "esriFieldTypeDate" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "Enabled", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r4679_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4203_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "lastupdate", "editorField": "lasteditor", "creationDateField": "createdate", "creatorField": "createeditor" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 10000, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "3e8531e219c5404db0d768eeb7498933", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABfElEQVQ4jZWTMYvCUAzH/086iC4KIgjCgRURB4fipCAWDlxdHJxcXJz1K4ibiF+ja6GgdRAdxYo43FS4URQHB4UKciTeFfEq2D+EpuHlx0vyIuGu2K/50YFMosRUKmUqivLhJ3u1Wn3btv3JAErWNC3iB1Cv12HbdowArmazGXRdRzweR6fTQSAQ4LhhGJhMJkin02i32xBCuDnSI6Db7WK5XLJfKBSgqiputxuazSb2+z3Hq9UqZFn2BlyvVwSDQTiOg/F4zADLsjg5FArhfD7zmUdJz7WFw2Fks1mYpol+v89fUqlU4jKeJXk1qFKpYDQa4Xg8YjqdIpFIIJPJ+AMMh0Nu3mKxQK1W8zr2GlAul3kCvV4Pl8uFgZvN5n1ANBpFPp/Her12b/QWQAjhzpgmQIBkMsn1/8Uf38A/gKqq2O127LdaLR4lPRxSsVjEfD5n4EvAYDBw/Vwuh+126/43Gg02rxIOtBj0tv3odDpxUxhAW0WL4Ytw19cP0LGO3u5yyMAAAAAASUVORK5CYII=", "yoffset": 0, "width": 12, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "2c11705483aaccb46ee6cd83a3167216", "height": 12 }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4001878.0867, "xmin": -1.24638823267E7, "ymax": 4008643.970899999, "xmax": -1.2453765601300001E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 5, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "wHydrant", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "datasourcetype": null, "in_service": null, "merge_src": null, "facilityid": null, "notes": null, "comments": null, "hydrant_id": null, "hydranttype": "Fire", "fieldpointstatus": null, "gis_source": null, "activeflag": "Active", "assessment_nameid": null, "install_yr": null, "static_press": null, "datasourcereference": null, "size_": null, "location": null, "fh_valve": null, "gpsdate": null, "make": null, "status": null } } } ], "supportsAdvancedQueries": true, "parentLayer": { "name": "Water System", "id": 0 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "wHydrant", "allowTrueCurvesUpdates": false, "displayField": "facilityid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 20, "alias": "Hydrant ID", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": null, "name": "activeflag", "length": 20, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datasourcetype", "length": 20, "alias": "DataSourceType", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCEREFERENCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datasourcereference", "length": 50, "alias": "DataSourceReference", "type": "esriFieldTypeString" }, { "modelName": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPS_Date", "type": "esriFieldTypeDate" }, { "modelName": "HYDRANTTYPE", "nullable": true, "editable": true, "defaultValue": "Fire", "domain": null, "name": "hydranttype", "length": 10, "alias": "HydrantType", "type": "esriFieldTypeString" }, { "modelName": "FieldPointStatus", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fieldpointstatus", "length": 255, "alias": "FieldPointStatus", "type": "esriFieldTypeString" }, { "modelName": "Assessment_NameID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assessment_nameid", "alias": "Assessment_NameID", "type": "esriFieldTypeInteger" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 50, "alias": "Location", "type": "esriFieldTypeString" }, { "modelName": "SIZE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "size_", "alias": "Size", "type": "esriFieldTypeDouble" }, { "modelName": "MAKE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "make", "length": 25, "alias": "Make", "type": "esriFieldTypeString" }, { "modelName": "INSTALL_YR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "install_yr", "alias": "Install Year", "type": "esriFieldTypeInteger" }, { "modelName": "FH_VALVE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fh_valve", "length": 3, "alias": "FH Valve", "type": "esriFieldTypeString" }, { "modelName": "STATIC_PRESS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "static_press", "alias": "Static Pressure", "type": "esriFieldTypeInteger" }, { "modelName": "IN_SERVICE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "in_service", "length": 3, "alias": "In Service", "type": "esriFieldTypeString" }, { "modelName": "STATUS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 15, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "NOTES", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 250, "alias": "Notes", "type": "esriFieldTypeString" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 250, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "Hydrant_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hydrant_id", "length": 20, "alias": "Hydrant ID", "type": "esriFieldTypeString" }, { "modelName": "MERGE_SRC", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "merge_src", "length": 255, "alias": "MERGE_SRC", "type": "esriFieldTypeString" }, { "modelName": "GIS_Source", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gis_source", "length": 255, "alias": "GIS_Source", "type": "esriFieldTypeString" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r4680_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4204_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 10000, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "3e8531e219c5404db0d768eeb7498933", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAASCAYAAABSO15qAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABzUlEQVQ4jc2RT0iTcRjHP8+21z+juTWE2ZKwawWBq4FHhUGXDqIQGEQMY8nsYqAgGMFkeKpLF0O85OiQ6AsVhMeCkKEXD512eY05E5UtsslW7y9eI5l7XxHx0hd+h+/ze57P73l+j4czyvN/AhRoe6lUSmlan8vv92udnTktGn0qIksnAvJw+1sgMGdOTLRYviEafbOv69cR+VCen7/X3N8/dyxgA+4Cr8xiUf7FfmWzz9pgubKyslyKx19swMcwrNsA6xAGXgKHxbXSIpE77o6Oa9W1NSvnlg3ggTjgPe6zRMQAjAL0FeDKBfhSP8INp0Lv+Hi6tLU1W56ZyVnehE2BmzgAGoHnTb29Xa5gMORqbb1c1vXtH+l0N2CdQylI2EYQyCnIBBcXR5RSMWBpf2HhHXC/visX5GwAE14LjPB3E5eA0m/D2HaY6msIPtkAF+FzAQY3fb4HwCPgCZWKtZkj3StIClRtAEu78LCtp8coDgyEvMPDj5sTCd/P6emDO9G06rnJyaxvbOwtNfLUmqtQUbr+vpzJNHwfGjpv7uyEtUhktzEWa/Emk253e/ueGh0NiEjREXDwksjgkUA+D6urMDVVn+oMOK3ODPgDq7iKrliFHyQAAAAASUVORK5CYII=", "yoffset": 0, "width": 12, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "345ba392e32ebeabe729c10329053c1a", "height": 13 }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4002012.4399000034, "xmin": -1.24634005445E7, "ymax": 4008039.2468999997, "xmax": -1.24572532887E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "SurveyValves", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "image": null, "easting": null, "elev": null, "photo": null, "id_1": null, "type": null, "northing": null } } } ], "supportsAdvancedQueries": true, "parentLayer": { "name": "Water System", "id": 0 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "SurveyValves", "allowTrueCurvesUpdates": false, "displayField": "type", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "northing", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "northing", "alias": "NORTHING", "type": "esriFieldTypeDouble" }, { "modelName": "easting", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "easting", "alias": "EASTING", "type": "esriFieldTypeDouble" }, { "modelName": "elev", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elev", "alias": "ELEV", "type": "esriFieldTypeDouble" }, { "modelName": "type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "type", "length": 254, "alias": "TYPE", "type": "esriFieldTypeString" }, { "modelName": "image", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "image", "length": 50, "alias": "Image", "type": "esriFieldTypeString" }, { "modelName": "id_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "id_1", "length": 50, "alias": "ID_1", "type": "esriFieldTypeString" }, { "modelName": "Photo", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "photo", "length": 200, "alias": "Photo", "type": "esriFieldTypeString" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "i8447id_1", "isUnique": false, "description": "", "fields": "id_1", "isAscending": true }, { "name": "r4687_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4211_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "3e8531e219c5404db0d768eeb7498933", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": false, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABlklEQVQoka2SsUsCURzHf3Zn6OJwd3BDDrmEf0IcEthgOSg01HbQoOI5iJv3XHqTOjSIIAdNiU6B1NjBkXJDEDe0iShoiG3XDTfIYZhxglJpEdF3+b0H38/7fd/vPRL+KPJfwWw2u2ea5iFBEAbDMJcYY/1HECG0o2na3Xg83uI4DgzDAFmWCzzPX9dqtZO1IMZ4Q1XVe6/XS5fL5aUhEomQ4XD4mOf5q4/wEhwOhxeJRIKeTCaQyWSgVCpBv9+HVCoFrVYL4vH4EcaYWcRegoPB4CAajYLb7YbpdAqxWAxGoxFUq1VgWRZCoRDZ7XZPAeD8E+hwOJwul2u+DgQCYMe1qw3ZoijKPpBaierxeJ46nQ5LEASk02l7KNBoNCCXy0E+nwdN02zP7Qro9/sFhNCDZVnOer0ODMNAMpmESqUyv2ev13tWFEVdAYvF4qMgCAVd10Vd1zdpmgbLsuYR2+32C8dx+4qirH9HSZLORFG8QQhJpmluz2azV5/PJweDwQTG+O3bD7DoDAC7i32z2fxqWQ/+Vu9EeqMYrnG6zwAAAABJRU5ErkJggg==", "yoffset": 0, "width": 10, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "0a1bee80669df527ea6c1331a68e57b4", "height": 10 }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4001849.5151999965, "xmin": -1.2463755819899999E7, "ymax": 4008055.4940000027, "xmax": -1.24556724882E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "wControlValve", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "operatingdistrict": null, "operable": 1, "datasourcetype": null, "pressurezonehgl": null, "facilityid": null, "serialnum": null, "installdate": null, "staticpressure": null, "pof": null, "legacyid2": null, "normalposition": null, "enabled": 1, "manufacturer": null, "operatingcompany": null, "gpscollectiontype": null, "bre": null, "diameter": null, "valvetype": null, "pressuresetting": null, "safetyrequirements": null, "warrantydate": null, "watertype": "Potable", "gpsdate": null, "ownedby": 1, "projectid": null, "vault": null, "direction": null, "elevation": null, "lifecyclestatuschangedate": null, "modelnum": null, "currentposition": null, "turnstoclose": null, "activeflag": "Active", "gpsfieldnotes": null, "valvefunction": null, "downstreampipe": null, "automated": null, "system": null, "inmodel": null, "datasourcereference": null, "pressurezonename": null, "gpsestacc": null, "legacyid": null, "location": null, "maintby": 1, "cof": null, "operatingdivision": null } } } ], "supportsAdvancedQueries": true, "parentLayer": { "name": "Water System", "id": 0 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "wControlValve", "allowTrueCurvesUpdates": false, "displayField": "pressurezonename", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 20, "alias": "Valve ID", "type": "esriFieldTypeString" }, { "modelName": "SERIALNUM", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "serialnum", "length": 20, "alias": "Serial Number", "type": "esriFieldTypeString" }, { "modelName": "MODELNUM", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "modelnum", "length": 20, "alias": "Model Number", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "WARRANTYDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "warrantydate", "length": 29, "alias": "Warranty Date", "type": "esriFieldTypeDate" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 200, "alias": "Location Description", "type": "esriFieldTypeString" }, { "modelName": "DIAMETER", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "piPipeDiameter", "description": "A list of pipe diameters", "type": "codedValue", "codedValues": [ { "code": 0.75, "name": "3/4\"" }, { "code": 1, "name": "1\"" }, { "code": 1.25, "name": "1 1/4\"" }, { "code": 1.5, "name": "1 1/2\"" }, { "code": 1.75, "name": "1 3/4\"" }, { "code": 2, "name": "2\"" }, { "code": 2.5, "name": "2 1/2\"" }, { "code": 3, "name": "3\"" }, { "code": 4, "name": "4\"" }, { "code": 6, "name": "6\"" }, { "code": 8, "name": "8\"" }, { "code": 10, "name": "10\"" }, { "code": 12, "name": "12\"" }, { "code": 14, "name": "14\"" }, { "code": 15, "name": "15\"" }, { "code": 16, "name": "16\"" }, { "code": 18, "name": "18\"" }, { "code": 20, "name": "20\"" }, { "code": 21, "name": "21\"" }, { "code": 24, "name": "24\"" }, { "code": 27, "name": "27\"" }, { "code": 30, "name": "30\"" }, { "code": 33, "name": "33\"" }, { "code": 36, "name": "36\"" }, { "code": 40, "name": "40\"" }, { "code": 42, "name": "42\"" }, { "code": 48, "name": "48\"" }, { "code": 54, "name": "54\"" }, { "code": 60, "name": "60\"" }, { "code": 66, "name": "66\"" }, { "code": 72, "name": "72\"" }, { "code": 75, "name": "75\"" }, { "code": 0, "name": "Unknown" }, { "code": 2.75, "name": "2 3/4\"" }, { "code": 22, "name": "22\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "diameter", "alias": "Diameter", "type": "esriFieldTypeDouble" }, { "modelName": "VALVETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "piControlValveType_31", "description": "List of infrastructure control valve types", "type": "codedValue", "codedValues": [ { "code": "Altitude", "name": "Altitude" }, { "code": "Blowoff", "name": "Blowoff" }, { "code": "Combination", "name": "Combination" }, { "code": "Vacuum", "name": "Vacuum" }, { "code": "Air Release", "name": "Air Release" }, { "code": "Backflow Control", "name": "Backflow Control" }, { "code": "Double Check", "name": "Double Check" }, { "code": "Pressure Reducer", "name": "Pressure Reducer" }, { "code": "Simple Check", "name": "Simple Check" }, { "code": "CLA", "name": "CLA" }, { "code": "RPZ", "name": "Reduced Pressure Zone" }, { "code": "Reduced Pressure Backflow", "name": "Reduced Pressure Backflow" }, { "code": "Unknown", "name": "Unknown" }, { "code": "Pressure Sustaining", "name": "Pressure Sustaining" }, { "code": "Telescopic", "name": "Telescopic" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "valvetype", "length": 30, "alias": "Valve Type", "type": "esriFieldTypeString" }, { "modelName": "VALVEFUNCTION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ValveFunction", "description": "Functions of valve", "type": "codedValue", "codedValues": [ { "code": "Distribution in Grid", "name": "Distribution in Grid" }, { "code": "Dist Dead End", "name": "Dist Dead End" }, { "code": "Blow-off", "name": "Blow-off" }, { "code": "Zone Separation", "name": "Zone Separation" }, { "code": "Transmission", "name": "Transmission" }, { "code": "Service Line", "name": "Service Line" }, { "code": "Plant", "name": "Plant" }, { "code": "Plant Discharge", "name": "Plant Discharge" }, { "code": "Booster Discharge", "name": "Booster Discharge" }, { "code": "Raw Water", "name": "Raw Water" }, { "code": "Crossover", "name": "Crossover" }, { "code": "Hyd Aux", "name": "Hyd Aux" }, { "code": "Fire Service", "name": "Fire Service" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "valvefunction", "length": 30, "alias": "Valve Function", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LifeCycleStatus_94", "description": "Status of an asset", "type": "codedValue", "codedValues": [ { "code": "Abandoned", "name": "Abandoned" }, { "code": "Active", "name": "Active" }, { "code": "Cancelled", "name": "Cancelled" }, { "code": "Out of Service", "name": "Out of Service" }, { "code": "Pending", "name": "Pending" }, { "code": "Proposed", "name": "Proposed" }, { "code": "Retired / Scrapped", "name": "Retired / Scrapped" }, { "code": "Retired in Place", "name": "Retired in Place" }, { "code": "Transferred", "name": "Transferred" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "length": 20, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetOwner_75", "description": "The owner of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Unknown" }, { "code": 1, "name": "Town of Cave Creek" }, { "code": 2, "name": "City Of Phoenix" }, { "code": 3, "name": "Liberty Utilities" }, { "code": 4, "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetManager_33", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" }, { "code": 1, "name": "Cave Creek Utilities" }, { "code": 2, "name": "City of Phoenix" }, { "code": 3, "name": "Liberty Utilities" }, { "code": 4, "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintby", "alias": "Managed By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OPERATINGCOMPANY", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingCompany_27", "description": "Operating Company", "type": "codedValue", "codedValues": [ { "code": "-1", "name": "Unknown" }, { "code": "1", "name": "Cave Creek utilities" }, { "code": "2", "name": "Liberty Utilities" }, { "code": "3", "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingcompany", "length": 32, "alias": "OperatingCompany", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDIVISION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingDivision_27", "description": "Division with Operating Company", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingdivision", "length": 32, "alias": "OperatingDivision", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDISTRICT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingDistrict_38", "description": "Operating District within Operating Division", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingdistrict", "length": 32, "alias": "OperatingDistrict", "type": "esriFieldTypeString" }, { "modelName": "OPERABLE", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "operable", "alias": "Operable", "type": "esriFieldTypeSmallInteger" }, { "modelName": "DIRECTION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ValveDirToOpen", "description": "Direction to open valve", "type": "codedValue", "codedValues": [ { "code": "Clockwise", "name": "Clockwise" }, { "code": "Counter-clockwise", "name": "Counter-clockwise" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "direction", "length": 20, "alias": "Open Direction", "type": "esriFieldTypeString" }, { "modelName": "TURNSTOCLOSE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "turnstoclose", "alias": "Turns to Close", "type": "esriFieldTypeDouble" }, { "modelName": "NORMALPOSITION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ValveStatus", "description": "Status of valve", "type": "codedValue", "codedValues": [ { "code": "Opened", "name": "Opened" }, { "code": "Closed", "name": "Closed" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "normalposition", "length": 6, "alias": "Normal Position", "type": "esriFieldTypeString" }, { "modelName": "CURRENTPOSITION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ValveStatus", "description": "Status of valve", "type": "codedValue", "codedValues": [ { "code": "Opened", "name": "Opened" }, { "code": "Closed", "name": "Closed" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "currentposition", "length": 6, "alias": "Current Position", "type": "esriFieldTypeString" }, { "modelName": "VAULT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "vault", "length": 4, "alias": "In Vault", "type": "esriFieldTypeString" }, { "modelName": "MANUFACTURER", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ValveManufacturer", "description": "A list of valve manufacturers", "type": "codedValue", "codedValues": [ { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "manufacturer", "length": 20, "alias": "Manufacturer", "type": "esriFieldTypeString" }, { "modelName": "SYSTEM", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PWSIDNumber", "description": "Public Water System Number", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "system", "length": 20, "alias": "System", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUSCHANGEDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lifecyclestatuschangedate", "length": 29, "alias": "LifeCycleStatusChangeDate", "type": "esriFieldTypeDate" }, { "modelName": "PROJECTID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectid", "length": 15, "alias": "Project ID", "type": "esriFieldTypeString" }, { "modelName": "WATERTYPE", "nullable": true, "editable": true, "defaultValue": "Potable", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wWaterType", "description": "The type of water flowing through pipe", "type": "codedValue", "codedValues": [ { "code": "Potable", "name": "Potable Water" }, { "code": "Raw", "name": "Raw Water" }, { "code": "Reclaimed", "name": "Reclaimed Water" }, { "code": "Storm", "name": "Storm Runoff" }, { "code": "Treated", "name": "Treated Water" }, { "code": "Well", "name": "Well Water" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "watertype", "length": 50, "alias": "Water Type", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "DataSourceType", "description": "Data source of feature", "type": "codedValue", "codedValues": [ { "code": "Asbuilt", "name": "As-built Record Plan" }, { "code": "Construction", "name": "Construction Plan" }, { "code": "Conventional Survey", "name": "Conventional Survey" }, { "code": "Estimated", "name": "Estimated Feature Location" }, { "code": "Existing", "name": "Existing Records" }, { "code": "Field Measured", "name": "Field Measured" }, { "code": "Field Notes", "name": "Field Notes" }, { "code": "GPSCM", "name": "Subcentimeter GPS" }, { "code": "GPSM", "name": "Submeter GPS" }, { "code": "Markup", "name": "Markup" }, { "code": "Overall", "name": "Overall System Map" }, { "code": "Planimetric Landbase", "name": "Planimetric Landbase" }, { "code": "Record Drawing", "name": "Record Drawing" }, { "code": "Sketch", "name": "Sketch" }, { "code": "SubFoot GPS", "name": "SubFoot GPS" }, { "code": "TaxMap", "name": "Tax Map" }, { "code": "VRS Collected", "name": "VRS Collected" }, { "code": "AutoCAD Drawing", "name": "AutoCAD Drawing" }, { "code": "KML", "name": "Google Earth kml sketch" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasourcetype", "length": 20, "alias": "DataSourceType", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCEREFERENCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datasourcereference", "length": 50, "alias": "DataSourceReference", "type": "esriFieldTypeString" }, { "modelName": "ELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevation", "alias": "Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "PRESSUREZONENAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressurezonename", "length": 50, "alias": "PressureZoneName", "type": "esriFieldTypeString" }, { "modelName": "PRESSUREZONEHGL", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressurezonehgl", "alias": "PressureZoneHGL", "type": "esriFieldTypeInteger" }, { "modelName": "STATICPRESSURE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "staticpressure", "alias": "Static Pressure", "type": "esriFieldTypeInteger" }, { "modelName": "LEGACYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid", "length": 20, "alias": "LEGACYID", "type": "esriFieldTypeString" }, { "modelName": "LEGACYID2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid2", "length": 20, "alias": "LegacyID2", "type": "esriFieldTypeString" }, { "modelName": "GPSCOLLECTIONTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpscollectiontype", "length": 25, "alias": "GPSCollectionType", "type": "esriFieldTypeString" }, { "modelName": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPS_Date", "type": "esriFieldTypeDate" }, { "modelName": "GPSESTACC", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsestacc", "alias": "GPSEstAcc", "type": "esriFieldTypeDouble" }, { "modelName": "GPSFIELDNOTES", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsfieldnotes", "length": 100, "alias": "GPSFieldNotes", "type": "esriFieldTypeString" }, { "modelName": "AUTOMATED", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "automated", "length": 4, "alias": "Automated", "type": "esriFieldTypeString" }, { "modelName": "PRESSURESETTING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressuresetting", "length": 20, "alias": "PressureSetting", "type": "esriFieldTypeString" }, { "modelName": "DOWNSTREAMPIPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "downstreampipe", "length": 16, "alias": "DownstreamPipe", "type": "esriFieldTypeString" }, { "modelName": "INMODEL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "inmodel", "length": 4, "alias": "InModel", "type": "esriFieldTypeString" }, { "modelName": "SAFETYREQUIREMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "safetyrequirements", "length": 30, "alias": "Safety Requirements", "type": "esriFieldTypeString" }, { "modelName": "COF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cof", "alias": "Consequence of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "POF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pof", "alias": "Probability of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "BRE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bre", "alias": "Business Risk Exposure", "type": "esriFieldTypeInteger" }, { "modelName": "CREATEEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "createeditor", "length": 20, "alias": "Creation User", "type": "esriFieldTypeString" }, { "modelName": "CREATEDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "createdate", "length": 29, "alias": "Date Created", "type": "esriFieldTypeDate" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "Enabled", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r4677_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4201_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "lastupdate", "editorField": "lasteditor", "creationDateField": "createdate", "creatorField": "createeditor" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 5000, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "3e8531e219c5404db0d768eeb7498933", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABlklEQVQoka2SsUsCURzHf3Zn6OJwd3BDDrmEf0IcEthgOSg01HbQoOI5iJv3XHqTOjSIIAdNiU6B1NjBkXJDEDe0iShoiG3XDTfIYZhxglJpEdF3+b0H38/7fd/vPRL+KPJfwWw2u2ea5iFBEAbDMJcYY/1HECG0o2na3Xg83uI4DgzDAFmWCzzPX9dqtZO1IMZ4Q1XVe6/XS5fL5aUhEomQ4XD4mOf5q4/wEhwOhxeJRIKeTCaQyWSgVCpBv9+HVCoFrVYL4vH4EcaYWcRegoPB4CAajYLb7YbpdAqxWAxGoxFUq1VgWRZCoRDZ7XZPAeD8E+hwOJwul2u+DgQCYMe1qw3ZoijKPpBaierxeJ46nQ5LEASk02l7KNBoNCCXy0E+nwdN02zP7Qro9/sFhNCDZVnOer0ODMNAMpmESqUyv2ev13tWFEVdAYvF4qMgCAVd10Vd1zdpmgbLsuYR2+32C8dx+4qirH9HSZLORFG8QQhJpmluz2azV5/PJweDwQTG+O3bD7DoDAC7i32z2fxqWQ/+Vu9EeqMYrnG6zwAAAABJRU5ErkJggg==", "yoffset": 0, "width": 10, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "0a1bee80669df527ea6c1331a68e57b4", "height": 10 }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4001803.4503000006, "xmin": -1.24639643328E7, "ymax": 4008669.6246000007, "xmax": -1.2453828918200001E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "wFitting", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "operatingdistrict": null, "datasourcetype": null, "pressurezonehgl": null, "facilityid": null, "installdate": null, "staticpressure": null, "pof": null, "legacyid2": null, "enabled": 1, "operatingcompany": null, "gpscollectiontype": null, "bre": null, "safetyrequirements": null, "warrantydate": null, "watertype": "Potable", "gpsdate": null, "ownedby": 1, "projectid": null, "elevation": null, "lifecyclestatuschangedate": null, "activeflag": "Active", "gpsfieldnotes": null, "system": null, "fittingtype": null, "datasourcereference": null, "pressurezonename": null, "gpsestacc": null, "legacyid": null, "location": null, "maintby": 1, "cof": null, "operatingdivision": null } } } ], "supportsAdvancedQueries": true, "parentLayer": { "name": "Water System", "id": 0 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "wFitting", "allowTrueCurvesUpdates": false, "displayField": "pressurezonename", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 20, "alias": "Facility Identifier", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "WARRANTYDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "warrantydate", "length": 29, "alias": "Warranty Date", "type": "esriFieldTypeDate" }, { "modelName": "FITTINGTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "piFittingType", "description": "List of infrastructure Fitting Types", "type": "codedValue", "codedValues": [ { "code": "11.25 Degree Bend", "name": "11.25 Degree Bend" }, { "code": "22.5 Degree Bend", "name": "22.5 Degree Bend" }, { "code": "45 Degree Bend", "name": "45 Degree Bend" }, { "code": "90 Degree Bend", "name": "90 Degree Bend" }, { "code": "Cap", "name": "Cap" }, { "code": "Cross", "name": "Cross" }, { "code": "Coupling", "name": "Coupling" }, { "code": "ExpansionJoint", "name": "Expansion Joint" }, { "code": "Reducer", "name": "Reducer" }, { "code": "Plug", "name": "Plug" }, { "code": "Riser", "name": "Riser" }, { "code": "Sleeve", "name": "Sleeve" }, { "code": "TapCorp", "name": "TapCorp" }, { "code": "TappingSleeve", "name": "TappingSleeve" }, { "code": "Tee", "name": "Tee" }, { "code": "Wye", "name": "Wye" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "fittingtype", "length": 50, "alias": "Fitting Type", "type": "esriFieldTypeString" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 200, "alias": "Location Description", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LifeCycleStatus_94", "description": "Status of an asset", "type": "codedValue", "codedValues": [ { "code": "Abandoned", "name": "Abandoned" }, { "code": "Active", "name": "Active" }, { "code": "Cancelled", "name": "Cancelled" }, { "code": "Out of Service", "name": "Out of Service" }, { "code": "Pending", "name": "Pending" }, { "code": "Proposed", "name": "Proposed" }, { "code": "Retired / Scrapped", "name": "Retired / Scrapped" }, { "code": "Retired in Place", "name": "Retired in Place" }, { "code": "Transferred", "name": "Transferred" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "length": 20, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetOwner_75", "description": "The owner of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Unknown" }, { "code": 1, "name": "Town of Cave Creek" }, { "code": 2, "name": "City Of Phoenix" }, { "code": 3, "name": "Liberty Utilities" }, { "code": 4, "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetManager_33", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" }, { "code": 1, "name": "Cave Creek Utilities" }, { "code": 2, "name": "City of Phoenix" }, { "code": 3, "name": "Liberty Utilities" }, { "code": 4, "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintby", "alias": "Managed By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OPERATINGCOMPANY", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingCompany_27", "description": "Operating Company", "type": "codedValue", "codedValues": [ { "code": "-1", "name": "Unknown" }, { "code": "1", "name": "Cave Creek utilities" }, { "code": "2", "name": "Liberty Utilities" }, { "code": "3", "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingcompany", "length": 32, "alias": "OperatingCompany", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDIVISION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingDivision_27", "description": "Division with Operating Company", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingdivision", "length": 32, "alias": "OperatingDivision", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDISTRICT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingDistrict_38", "description": "Operating District within Operating Division", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingdistrict", "length": 32, "alias": "OperatingDistrict", "type": "esriFieldTypeString" }, { "modelName": "SYSTEM", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PWSIDNumber", "description": "Public Water System Number", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "system", "length": 20, "alias": "System", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUSCHANGEDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lifecyclestatuschangedate", "length": 29, "alias": "LifeCycleStatusChangeDate", "type": "esriFieldTypeDate" }, { "modelName": "PROJECTID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectid", "length": 15, "alias": "Project ID", "type": "esriFieldTypeString" }, { "modelName": "WATERTYPE", "nullable": true, "editable": true, "defaultValue": "Potable", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wWaterType", "description": "The type of water flowing through pipe", "type": "codedValue", "codedValues": [ { "code": "Potable", "name": "Potable Water" }, { "code": "Raw", "name": "Raw Water" }, { "code": "Reclaimed", "name": "Reclaimed Water" }, { "code": "Storm", "name": "Storm Runoff" }, { "code": "Treated", "name": "Treated Water" }, { "code": "Well", "name": "Well Water" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "watertype", "length": 50, "alias": "Water Type", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "DataSourceType", "description": "Data source of feature", "type": "codedValue", "codedValues": [ { "code": "Asbuilt", "name": "As-built Record Plan" }, { "code": "Construction", "name": "Construction Plan" }, { "code": "Conventional Survey", "name": "Conventional Survey" }, { "code": "Estimated", "name": "Estimated Feature Location" }, { "code": "Existing", "name": "Existing Records" }, { "code": "Field Measured", "name": "Field Measured" }, { "code": "Field Notes", "name": "Field Notes" }, { "code": "GPSCM", "name": "Subcentimeter GPS" }, { "code": "GPSM", "name": "Submeter GPS" }, { "code": "Markup", "name": "Markup" }, { "code": "Overall", "name": "Overall System Map" }, { "code": "Planimetric Landbase", "name": "Planimetric Landbase" }, { "code": "Record Drawing", "name": "Record Drawing" }, { "code": "Sketch", "name": "Sketch" }, { "code": "SubFoot GPS", "name": "SubFoot GPS" }, { "code": "TaxMap", "name": "Tax Map" }, { "code": "VRS Collected", "name": "VRS Collected" }, { "code": "AutoCAD Drawing", "name": "AutoCAD Drawing" }, { "code": "KML", "name": "Google Earth kml sketch" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasourcetype", "length": 20, "alias": "DataSourceType", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCEREFERENCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datasourcereference", "length": 50, "alias": "DataSourceReference", "type": "esriFieldTypeString" }, { "modelName": "ELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevation", "alias": "Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "PRESSUREZONENAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressurezonename", "length": 50, "alias": "PressureZoneName", "type": "esriFieldTypeString" }, { "modelName": "PRESSUREZONEHGL", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressurezonehgl", "alias": "PressureZoneHGL", "type": "esriFieldTypeInteger" }, { "modelName": "STATICPRESSURE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "staticpressure", "alias": "Static Pressure", "type": "esriFieldTypeInteger" }, { "modelName": "LEGACYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid", "length": 20, "alias": "LEGACYID", "type": "esriFieldTypeString" }, { "modelName": "LEGACYID2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid2", "length": 20, "alias": "LegacyID2", "type": "esriFieldTypeString" }, { "modelName": "GPSCOLLECTIONTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpscollectiontype", "length": 25, "alias": "GPSCollectionType", "type": "esriFieldTypeString" }, { "modelName": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPS_Date", "type": "esriFieldTypeDate" }, { "modelName": "GPSESTACC", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsestacc", "alias": "GPSEstAcc", "type": "esriFieldTypeDouble" }, { "modelName": "GPSFIELDNOTES", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsfieldnotes", "length": 100, "alias": "GPSFieldNotes", "type": "esriFieldTypeString" }, { "modelName": "SAFETYREQUIREMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "safetyrequirements", "length": 30, "alias": "Safety Requirements", "type": "esriFieldTypeString" }, { "modelName": "COF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cof", "alias": "Consequence of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "POF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pof", "alias": "Probability of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "BRE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bre", "alias": "Business Risk Exposure", "type": "esriFieldTypeInteger" }, { "modelName": "CREATEEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "createeditor", "length": 20, "alias": "Creation User", "type": "esriFieldTypeString" }, { "modelName": "CREATEDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "createdate", "length": 29, "alias": "Date Created", "type": "esriFieldTypeDate" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "Enabled", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r4686_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4210_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "lastupdate", "editorField": "lasteditor", "creationDateField": "createdate", "creatorField": "createeditor" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 5000, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "3e8531e219c5404db0d768eeb7498933", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0 }, "color": [ 0, 92, 230, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4001803.030299999, "xmin": -1.24639040715E7, "ymax": 4008643.132799998, "xmax": -1.24538223388E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "definitionQuery": "OWNEDBY = 4", "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 8, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "wSystemValve", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "operable": 1, "pressurezonehgl": null, "facilityid": null, "installdate": null, "legacyid2": null, "bre": null, "diameter": null, "safetyrequirements": null, "watertype": "Potable", "gpsdate": null, "ownedby": 1, "vault": null, "modelnum": null, "currentposition": null, "hydrflag": 0, "turnstoclose": null, "activeflag": "Active", "valvefunction": null, "system": null, "operatingnuttype": null, "datasourcereference": null, "gpsestacc": null, "legacyid": null, "operationsmaintained": 0, "operatingdistrict": null, "datasourcetype": null, "serialnum": null, "staticpressure": null, "pof": null, "normalposition": "Opened", "enabled": 1, "manufacturer": null, "operatingcompany": null, "gpscollectiontype": null, "valvetype": null, "warrantydate": null, "depthtonut": null, "projectid": null, "elevation": null, "lifecyclestatuschangedate": null, "gpsfieldnotes": null, "clocktoclose": 1, "bypassvalve": 0, "inmodel": null, "qsec": null, "pressurezonename": null, "location": null, "maintby": 1, "cof": null, "operatingdivision": null } } } ], "supportsAdvancedQueries": true, "parentLayer": { "name": "Water System", "id": 0 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "wSystemValve", "allowTrueCurvesUpdates": false, "displayField": "pressurezonename", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 20, "alias": "Valve ID", "type": "esriFieldTypeString" }, { "modelName": "SERIALNUM", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "serialnum", "length": 20, "alias": "Serial Number", "type": "esriFieldTypeString" }, { "modelName": "MODELNUM", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "modelnum", "length": 20, "alias": "Model Number", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "WARRANTYDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "warrantydate", "length": 29, "alias": "Warranty Date", "type": "esriFieldTypeDate" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 200, "alias": "Location", "type": "esriFieldTypeString" }, { "modelName": "DIAMETER", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "piPipeDiameter", "description": "A list of pipe diameters", "type": "codedValue", "codedValues": [ { "code": 0.75, "name": "3/4\"" }, { "code": 1, "name": "1\"" }, { "code": 1.25, "name": "1 1/4\"" }, { "code": 1.5, "name": "1 1/2\"" }, { "code": 1.75, "name": "1 3/4\"" }, { "code": 2, "name": "2\"" }, { "code": 2.5, "name": "2 1/2\"" }, { "code": 3, "name": "3\"" }, { "code": 4, "name": "4\"" }, { "code": 6, "name": "6\"" }, { "code": 8, "name": "8\"" }, { "code": 10, "name": "10\"" }, { "code": 12, "name": "12\"" }, { "code": 14, "name": "14\"" }, { "code": 15, "name": "15\"" }, { "code": 16, "name": "16\"" }, { "code": 18, "name": "18\"" }, { "code": 20, "name": "20\"" }, { "code": 21, "name": "21\"" }, { "code": 24, "name": "24\"" }, { "code": 27, "name": "27\"" }, { "code": 30, "name": "30\"" }, { "code": 33, "name": "33\"" }, { "code": 36, "name": "36\"" }, { "code": 40, "name": "40\"" }, { "code": 42, "name": "42\"" }, { "code": 48, "name": "48\"" }, { "code": 54, "name": "54\"" }, { "code": 60, "name": "60\"" }, { "code": 66, "name": "66\"" }, { "code": 72, "name": "72\"" }, { "code": 75, "name": "75\"" }, { "code": 0, "name": "Unknown" }, { "code": 2.75, "name": "2 3/4\"" }, { "code": 22, "name": "22\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "diameter", "alias": "Diameter", "type": "esriFieldTypeDouble" }, { "modelName": "VALVETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "piSystemValveType", "description": "List of system valves types", "type": "codedValue", "codedValues": [ { "code": "Ball", "name": "Ball" }, { "code": "Butterfly", "name": "Butterfly" }, { "code": "Cone", "name": "Cone" }, { "code": "Gate", "name": "Gate" }, { "code": "Plug", "name": "Plug" }, { "code": "Roundway", "name": "Roundway" }, { "code": "Tapping", "name": "Tapping" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "valvetype", "length": 30, "alias": "Valve Type", "type": "esriFieldTypeString" }, { "modelName": "VALVEFUNCTION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ValveFunction", "description": "Functions of valve", "type": "codedValue", "codedValues": [ { "code": "Distribution in Grid", "name": "Distribution in Grid" }, { "code": "Dist Dead End", "name": "Dist Dead End" }, { "code": "Blow-off", "name": "Blow-off" }, { "code": "Zone Separation", "name": "Zone Separation" }, { "code": "Transmission", "name": "Transmission" }, { "code": "Service Line", "name": "Service Line" }, { "code": "Plant", "name": "Plant" }, { "code": "Plant Discharge", "name": "Plant Discharge" }, { "code": "Booster Discharge", "name": "Booster Discharge" }, { "code": "Raw Water", "name": "Raw Water" }, { "code": "Crossover", "name": "Crossover" }, { "code": "Hyd Aux", "name": "Hyd Aux" }, { "code": "Fire Service", "name": "Fire Service" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "valvefunction", "length": 30, "alias": "Valve Function", "type": "esriFieldTypeString" }, { "modelName": "BYPASSVALVE", "nullable": true, "editable": true, "defaultValue": 0, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "bypassvalve", "alias": "Bypass Valve", "type": "esriFieldTypeSmallInteger" }, { "modelName": "CLOCKTOCLOSE", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "clocktoclose", "alias": "Clockwise To Close", "type": "esriFieldTypeSmallInteger" }, { "modelName": "TURNSTOCLOSE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "turnstoclose", "alias": "Turns To Close", "type": "esriFieldTypeInteger" }, { "modelName": "NORMALPOSITION", "nullable": true, "editable": true, "defaultValue": "Opened", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ValveStatus", "description": "Status of valve", "type": "codedValue", "codedValues": [ { "code": "Opened", "name": "Opened" }, { "code": "Closed", "name": "Closed" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "normalposition", "length": 6, "alias": "Normal Position", "type": "esriFieldTypeString" }, { "modelName": "CURRENTPOSITION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ValveStatus", "description": "Status of valve", "type": "codedValue", "codedValues": [ { "code": "Opened", "name": "Opened" }, { "code": "Closed", "name": "Closed" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "currentposition", "length": 6, "alias": "Current Position", "type": "esriFieldTypeString" }, { "modelName": "VAULT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "vault", "length": 4, "alias": "In Vault", "type": "esriFieldTypeString" }, { "modelName": "OPERABLE", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "operable", "alias": "Operable", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MANUFACTURER", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ValveManufacturer", "description": "A list of valve manufacturers", "type": "codedValue", "codedValues": [ { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "manufacturer", "length": 20, "alias": "Manufacturer", "type": "esriFieldTypeString" }, { "modelName": "DEPTHTONUT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "depthtonut", "alias": "DepthToNut", "type": "esriFieldTypeDouble" }, { "modelName": "HYDRFLAG", "nullable": true, "editable": true, "defaultValue": 0, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "hydrflag", "alias": "Hydrant Valve", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LifeCycleStatus_94", "description": "Status of an asset", "type": "codedValue", "codedValues": [ { "code": "Abandoned", "name": "Abandoned" }, { "code": "Active", "name": "Active" }, { "code": "Cancelled", "name": "Cancelled" }, { "code": "Out of Service", "name": "Out of Service" }, { "code": "Pending", "name": "Pending" }, { "code": "Proposed", "name": "Proposed" }, { "code": "Retired / Scrapped", "name": "Retired / Scrapped" }, { "code": "Retired in Place", "name": "Retired in Place" }, { "code": "Transferred", "name": "Transferred" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "length": 20, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetOwner_75", "description": "The owner of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Unknown" }, { "code": 1, "name": "Town of Cave Creek" }, { "code": 2, "name": "City Of Phoenix" }, { "code": 3, "name": "Liberty Utilities" }, { "code": 4, "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetManager_33", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" }, { "code": 1, "name": "Cave Creek Utilities" }, { "code": 2, "name": "City of Phoenix" }, { "code": 3, "name": "Liberty Utilities" }, { "code": 4, "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintby", "alias": "Managed By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OPERATINGCOMPANY", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "operatingcompany", "length": 32, "alias": "OperatingCompany", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDIVISION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "operatingdivision", "length": 32, "alias": "OperatingDivision", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDISTRICT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "operatingdistrict", "length": 32, "alias": "OperatingDistrict", "type": "esriFieldTypeString" }, { "modelName": "QUARTERSECTION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "qsec", "length": 20, "alias": "Quartersection", "type": "esriFieldTypeString" }, { "modelName": "SYSTEM", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "system", "length": 20, "alias": "System", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUSCHANGEDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lifecyclestatuschangedate", "length": 29, "alias": "LifeCycleStatusChangeDate", "type": "esriFieldTypeDate" }, { "modelName": "PROJECTID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectid", "length": 15, "alias": "Project ID", "type": "esriFieldTypeString" }, { "modelName": "WATERTYPE", "nullable": true, "editable": true, "defaultValue": "Potable", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wWaterType", "description": "The type of water flowing through pipe", "type": "codedValue", "codedValues": [ { "code": "Potable", "name": "Potable Water" }, { "code": "Raw", "name": "Raw Water" }, { "code": "Reclaimed", "name": "Reclaimed Water" }, { "code": "Storm", "name": "Storm Runoff" }, { "code": "Treated", "name": "Treated Water" }, { "code": "Well", "name": "Well Water" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "watertype", "length": 50, "alias": "Water Type", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "DataSourceType", "description": "Data source of feature", "type": "codedValue", "codedValues": [ { "code": "Asbuilt", "name": "As-built Record Plan" }, { "code": "Construction", "name": "Construction Plan" }, { "code": "Conventional Survey", "name": "Conventional Survey" }, { "code": "Estimated", "name": "Estimated Feature Location" }, { "code": "Existing", "name": "Existing Records" }, { "code": "Field Measured", "name": "Field Measured" }, { "code": "Field Notes", "name": "Field Notes" }, { "code": "GPSCM", "name": "Subcentimeter GPS" }, { "code": "GPSM", "name": "Submeter GPS" }, { "code": "Markup", "name": "Markup" }, { "code": "Overall", "name": "Overall System Map" }, { "code": "Planimetric Landbase", "name": "Planimetric Landbase" }, { "code": "Record Drawing", "name": "Record Drawing" }, { "code": "Sketch", "name": "Sketch" }, { "code": "SubFoot GPS", "name": "SubFoot GPS" }, { "code": "TaxMap", "name": "Tax Map" }, { "code": "VRS Collected", "name": "VRS Collected" }, { "code": "AutoCAD Drawing", "name": "AutoCAD Drawing" }, { "code": "KML", "name": "Google Earth kml sketch" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasourcetype", "length": 20, "alias": "DataSourceType", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCEREFERENCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datasourcereference", "length": 50, "alias": "DataSourceReference", "type": "esriFieldTypeString" }, { "modelName": "ELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevation", "alias": "Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "PRESSUREZONENAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressurezonename", "length": 50, "alias": "PressureZoneName", "type": "esriFieldTypeString" }, { "modelName": "PRESSUREZONEHGL", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressurezonehgl", "alias": "PressureZoneHGL", "type": "esriFieldTypeInteger" }, { "modelName": "STATICPRESSURE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "staticpressure", "alias": "Static Pressure", "type": "esriFieldTypeInteger" }, { "modelName": "LEGACYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid", "length": 20, "alias": "LEGACYID", "type": "esriFieldTypeString" }, { "modelName": "LEGACYID2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid2", "length": 20, "alias": "LegacyID2", "type": "esriFieldTypeString" }, { "modelName": "GPSCOLLECTIONTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpscollectiontype", "length": 25, "alias": "GPSCollectionType", "type": "esriFieldTypeString" }, { "modelName": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPS_Date", "type": "esriFieldTypeDate" }, { "modelName": "GPSESTACC", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsestacc", "alias": "GPSEstAcc", "type": "esriFieldTypeDouble" }, { "modelName": "GPSFIELDNOTES", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsfieldnotes", "length": 100, "alias": "GPSFieldNotes", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGNUTTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "operatingnuttype", "length": 12, "alias": "OperatingNutType", "type": "esriFieldTypeString" }, { "modelName": "INMODEL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "inmodel", "length": 4, "alias": "InModel", "type": "esriFieldTypeString" }, { "modelName": "OPERATIONSMAINTAINED", "nullable": true, "editable": true, "defaultValue": 0, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "operationsmaintained", "alias": "Operations Maintained", "type": "esriFieldTypeSmallInteger" }, { "modelName": "SAFETYREQUIREMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "safetyrequirements", "length": 30, "alias": "Safety Requirements", "type": "esriFieldTypeString" }, { "modelName": "COF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cof", "alias": "Consequence of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "POF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pof", "alias": "Probability of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "BRE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bre", "alias": "Business Risk Exposure", "type": "esriFieldTypeInteger" }, { "modelName": "CREATEEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "createeditor", "length": 20, "alias": "Creation User", "type": "esriFieldTypeString" }, { "modelName": "CREATEDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "createdate", "length": 29, "alias": "Date Created", "type": "esriFieldTypeDate" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "Enabled", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r4684_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4208_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "lastupdate", "editorField": "lasteditor", "creationDateField": "createdate", "creatorField": "createeditor" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 5000, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "3e8531e219c5404db0d768eeb7498933", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABlklEQVQoka2SsUsCURzHf3Zn6OJwd3BDDrmEf0IcEthgOSg01HbQoOI5iJv3XHqTOjSIIAdNiU6B1NjBkXJDEDe0iShoiG3XDTfIYZhxglJpEdF3+b0H38/7fd/vPRL+KPJfwWw2u2ea5iFBEAbDMJcYY/1HECG0o2na3Xg83uI4DgzDAFmWCzzPX9dqtZO1IMZ4Q1XVe6/XS5fL5aUhEomQ4XD4mOf5q4/wEhwOhxeJRIKeTCaQyWSgVCpBv9+HVCoFrVYL4vH4EcaYWcRegoPB4CAajYLb7YbpdAqxWAxGoxFUq1VgWRZCoRDZ7XZPAeD8E+hwOJwul2u+DgQCYMe1qw3ZoijKPpBaierxeJ46nQ5LEASk02l7KNBoNCCXy0E+nwdN02zP7Qro9/sFhNCDZVnOer0ODMNAMpmESqUyv2ev13tWFEVdAYvF4qMgCAVd10Vd1zdpmgbLsuYR2+32C8dx+4qirH9HSZLORFG8QQhJpmluz2azV5/PJweDwQTG+O3bD7DoDAC7i32z2fxqWQ/+Vu9EeqMYrnG6zwAAAABJRU5ErkJggg==", "yoffset": 0, "width": 10, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "0a1bee80669df527ea6c1331a68e57b4", "height": 10 }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4003040.2271, "xmin": -1.24607142742E7, "ymax": 4004202.931400001, "xmax": -1.24556214224E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 9, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "wTank", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "operatingdistrict": null, "datasourcetype": null, "facilityid": null, "installdate": null, "dischargeelevation": null, "pof": null, "createdate": null, "enabled": 1, "operatingcompany": null, "bre": null, "safetyrequirements": null, "warrantydate": null, "watertype": null, "ownedby": 1, "projectid": null, "bottomelevation": null, "lifecyclestatuschangedate": null, "measuredlength": null, "cathodicprotection": null, "lasteditor": null, "activeflag": "Active", "tanktype": null, "volume": null, "system": null, "overflowelevation": null, "createeditor": null, "cipnumber": null, "datasourcereference": null, "name": null, "facilityidsecondary": null, "location": null, "maintby": 1, "cof": null, "lastupdate": null, "operatingdivision": null } } } ], "supportsAdvancedQueries": true, "parentLayer": { "name": "Water System", "id": 0 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "wTank", "allowTrueCurvesUpdates": false, "displayField": "name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 20, "alias": "Facility Identifier", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "WARRANTYDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "warrantydate", "length": 29, "alias": "Warranty Date", "type": "esriFieldTypeDate" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 200, "alias": "Location Description", "type": "esriFieldTypeString" }, { "modelName": "NAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name", "length": 50, "alias": "Name", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LifeCycleStatus_1", "description": "Status of an asset", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Out of Service", "name": "Out of Service" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Under Construction", "name": "Under Construction" }, { "code": "Abandoned", "name": "Abandoned" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "length": 20, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetOwner_1", "description": "The owner of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Unknown" }, { "code": 1, "name": "Town of Cave Creek" }, { "code": 2, "name": "City Of Phoenix" }, { "code": 3, "name": "Liberty Utilities" }, { "code": 4, "name": "Carefree Water Company" }, { "code": 5, "name": "Private" }, { "code": 6, "name": "Public" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetManager_1_20", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" }, { "code": 1, "name": "Cave Creek Utilities" }, { "code": 2, "name": "City of Phoenix" }, { "code": 3, "name": "Liberty Utilities" }, { "code": 4, "name": "Carefree Water Company" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintby", "alias": "Managed By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OPERATINGCOMPANY", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingCompany_1_6", "description": "Operating Company", "type": "codedValue", "codedValues": [ { "code": "-1", "name": "Unknown" }, { "code": "2", "name": "Liberty Utilities" }, { "code": "1", "name": "Cave Creek Utilities" }, { "code": "3", "name": "City of Phoenix" }, { "code": "4", "name": "Carefree Water" }, { "code": "5", "name": "Private" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingcompany", "length": 32, "alias": "OperatingCompany", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDIVISION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingDivision_1_6", "description": "Division with Operating Company", "type": "codedValue", "codedValues": [ { "code": "-1", "name": "Unknown" }, { "code": "1", "name": "Cave Creek" }, { "code": "2", "name": "Desert Hills" }, { "code": "3", "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingdivision", "length": 32, "alias": "OperatingDivision", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDISTRICT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingDistrict_1_20", "description": "Operating District within Operating Division", "type": "codedValue", "codedValues": [ { "code": "CC", "name": "Cave Creek" }, { "code": "DH", "name": "Desert Hills" }, { "code": "CS", "name": "Cahava Springs" }, { "code": "CF", "name": "Carefree" }, { "code": "PX", "name": "Phoenix" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingdistrict", "length": 32, "alias": "OperatingDistrict", "type": "esriFieldTypeString" }, { "modelName": "SYSTEM", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PWSIDNumber_1", "description": "Public Water System Number", "type": "codedValue", "codedValues": [ { "code": "CC", "name": "Cave Creek" }, { "code": "DH", "name": "Desert Hills" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "system", "length": 20, "alias": "System", "type": "esriFieldTypeString" }, { "modelName": "CATHODICPROTECTION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "cathodicprotection", "length": 3, "alias": "CathodicProtection", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUSCHANGEDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lifecyclestatuschangedate", "length": 29, "alias": "LifeCycleStatusChangeDate", "type": "esriFieldTypeDate" }, { "modelName": "MEASUREDLENGTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "measuredlength", "alias": "MeasuredLength", "type": "esriFieldTypeDouble" }, { "modelName": "PROJECTID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectid", "length": 15, "alias": "Project ID", "type": "esriFieldTypeString" }, { "modelName": "WATERTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wWaterType", "description": "The type of water flowing through pipe", "type": "codedValue", "codedValues": [ { "code": "Potable", "name": "Potable Water" }, { "code": "Raw", "name": "Raw Water" }, { "code": "Reclaimed", "name": "Reclaimed Water" }, { "code": "Storm", "name": "Storm Runoff" }, { "code": "Treated", "name": "Treated Water" }, { "code": "Well", "name": "Well Water" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "watertype", "length": 50, "alias": "Water Type", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "DataSourceType", "description": "Data source of feature", "type": "codedValue", "codedValues": [ { "code": "Asbuilt", "name": "As-built Record Plan" }, { "code": "Construction", "name": "Construction Plan" }, { "code": "Conventional Survey", "name": "Conventional Survey" }, { "code": "Estimated", "name": "Estimated Feature Location" }, { "code": "Existing", "name": "Existing Records" }, { "code": "Field Measured", "name": "Field Measured" }, { "code": "Field Notes", "name": "Field Notes" }, { "code": "GPSCM", "name": "Subcentimeter GPS" }, { "code": "GPSM", "name": "Submeter GPS" }, { "code": "Markup", "name": "Markup" }, { "code": "Overall", "name": "Overall System Map" }, { "code": "Planimetric Landbase", "name": "Planimetric Landbase" }, { "code": "Record Drawing", "name": "Record Drawing" }, { "code": "Sketch", "name": "Sketch" }, { "code": "SubFoot GPS", "name": "SubFoot GPS" }, { "code": "TaxMap", "name": "Tax Map" }, { "code": "VRS Collected", "name": "VRS Collected" }, { "code": "AutoCAD Drawing", "name": "AutoCAD Drawing" }, { "code": "KML", "name": "Google Earth kml sketch" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasourcetype", "length": 20, "alias": "DataSourceType", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCEREFERENCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datasourcereference", "length": 50, "alias": "DataSourceReference", "type": "esriFieldTypeString" }, { "modelName": "CIPNUMBER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cipnumber", "length": 15, "alias": "CIP Number", "type": "esriFieldTypeString" }, { "modelName": "FACILITYIDSECONDARY", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityidsecondary", "length": 20, "alias": "FacilityIDSecondary", "type": "esriFieldTypeString" }, { "modelName": "TANKTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TankType", "description": "Type of water storage vessel", "type": "codedValue", "codedValues": [ { "code": "Buried Storage", "name": "Buried Storage" }, { "code": "Elevated", "name": "Elevated" }, { "code": "Ground Storage", "name": "Ground Storage" }, { "code": "Hydropneumatic", "name": "Hydropneumatic" }, { "code": "Standpipe", "name": "Standpipe" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "tanktype", "length": 20, "alias": "TankType", "type": "esriFieldTypeString" }, { "modelName": "VOLUME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "volume", "alias": "Volume (MG)", "type": "esriFieldTypeDouble" }, { "modelName": "DISCHARGEELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dischargeelevation", "alias": "Discharge Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "OVERFLOWELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "overflowelevation", "alias": "OverflowElevation", "type": "esriFieldTypeDouble" }, { "modelName": "BOTTOMELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bottomelevation", "alias": "Bottom Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "SAFETYREQUIREMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "safetyrequirements", "length": 30, "alias": "Safety Requirements", "type": "esriFieldTypeString" }, { "modelName": "COF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cof", "alias": "Consequence of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "POF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pof", "alias": "Probability of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "BRE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bre", "alias": "Business Risk Exposure", "type": "esriFieldTypeInteger" }, { "modelName": "CREATEEDITOR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "createeditor", "length": 20, "alias": "Creation User", "type": "esriFieldTypeString" }, { "modelName": "CREATEDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "createdate", "length": 29, "alias": "Date Created", "type": "esriFieldTypeDate" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "Enabled", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r4678_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4202_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "3e8531e219c5404db0d768eeb7498933", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABm0lEQVQ4jc2UPU7DQBCF35qloUGUNlIEZzAXSJ+kRlFoKJyKK0ByAfq4oAGh9ByAC2BxBBDFRkJIhAYh2WSjGTvsLjGJowjBk7ZZaz/PvPmR+CXJvwG3VQhPNyFEAxoBAJ/vBRJoJMiyPoY1VR18+BRAyjMAEVGgv33XCAGEkDJCR8W4CrrLwW0VQugegAaqKcKRCpFmLTt6ORep0D1OnULa31xITB5Sk4GUdwDbVQKWnD5Do/oWBsfbC8EHpy8GTv531GBmi3QsAHlaRPP49WAVRWirGNdBYsCebnKhrDR3T57h73gcPR1S6/wVavzpWmFrgwtrgQW3lCMC0En2UqBu7kqBdtRAbMDaGL+W8lZ0iufjn4/0yAULHlNOYy1pnbhgDbpYHyyEcsFZ1ufZL9FoPKkOniB2wcOa4oViDclMN/cf6F688Q+WtBoPhwsm0TjSQinxOr59x0JRjS7NlpvvijRrFQulevsRlN5ZmgcPefUFvFBKbClRbEf6M3gmsoUWSj77kWXPiFuKqk+FKjytDiblj+hwpVfRFH3km7Sh7qpLAAAAAElFTkSuQmCC", "yoffset": 0, "width": 16, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "afb969362872e2ddff6fbe59d0a90617", "height": 16 }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4003856.938500002, "xmin": -1.24585510096E7, "ymax": 4005830.042000003, "xmax": -1.2454725524E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 10, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "wWell", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "operatingdistrict": null, "datasourcetype": null, "facilityid": null, "installdate": null, "serialnum": null, "legacyid1": null, "staticpressure": null, "pof": null, "legacyid2": null, "createdate": null, "opdate": null, "capacity": null, "manufacturer": null, "gpscollectiontype": null, "bre": null, "safetyrequirements": null, "warrantydate": null, "watertype": null, "adwr_number": null, "gpsdate": null, "ownedby": 1, "dailymaxallocationmgd": null, "conditiondate": null, "elevation": null, "address": null, "lifecyclestatuschangedate": null, "rotation": null, "modelnum": null, "cathodicprotection": null, "cadastral": null, "wellname": null, "lasteditor": null, "activeflag": "Active", "gpsfieldnotes": null, "condition": null, "system": null, "qsec": null, "createeditor": null, "cipnumber": null, "datasourcereference": null, "gpsestacc": null, "statepermitnumber": null, "location": null, "maintby": 1, "cof": null, "lastupdate": null, "welltype": null } } } ], "supportsAdvancedQueries": true, "parentLayer": { "name": "Water System", "id": 0 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "wWell", "allowTrueCurvesUpdates": false, "displayField": "wellname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 20, "alias": "AssetID", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 200, "alias": "Location Description", "type": "esriFieldTypeString" }, { "modelName": "ROTATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rotation", "alias": "Rotation", "type": "esriFieldTypeDouble" }, { "modelName": "WELLNAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "wellname", "length": 50, "alias": "Name", "type": "esriFieldTypeString" }, { "modelName": "WELLTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "welltype", "length": 25, "alias": "Type", "type": "esriFieldTypeString" }, { "modelName": "OPDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "opdate", "length": 29, "alias": "Operational Date", "type": "esriFieldTypeDate" }, { "modelName": "STATICPRESSURE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "staticpressure", "alias": "Static Pressure", "type": "esriFieldTypeInteger" }, { "modelName": "CAPACITY", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "capacity", "alias": "Maximum Pumping Capacity", "type": "esriFieldTypeInteger" }, { "modelName": "DAILYMAXALLOCATIONMGD", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dailymaxallocationmgd", "alias": "Daily Max Allocation (MGD)", "type": "esriFieldTypeInteger" }, { "modelName": "ELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevation", "alias": "Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "MODELNUM", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "modelnum", "length": 20, "alias": "Model Number", "type": "esriFieldTypeString" }, { "modelName": "SERIALNUM", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "serialnum", "length": 20, "alias": "Serial Number", "type": "esriFieldTypeString" }, { "modelName": "MANUFACTURER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "manufacturer", "length": 10, "alias": "Manufacturer", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LifeCycleStatus_1", "description": "Status of an asset", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Out of Service", "name": "Out of Service" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Under Construction", "name": "Under Construction" }, { "code": "Abandoned", "name": "Abandoned" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "length": 20, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUSCHANGEDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lifecyclestatuschangedate", "length": 29, "alias": "LifeCycleStatusChangeDate", "type": "esriFieldTypeDate" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": null, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetManager_1_20", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" }, { "code": 1, "name": "Cave Creek Utilities" }, { "code": 2, "name": "City of Phoenix" }, { "code": 3, "name": "Liberty Utilities" }, { "code": 4, "name": "Carefree Water Company" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintby", "alias": "Managed By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OPERATINGDISTRICT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingDistrict_1_20", "description": "Operating District within Operating Division", "type": "codedValue", "codedValues": [ { "code": "CC", "name": "Cave Creek" }, { "code": "DH", "name": "Desert Hills" }, { "code": "CS", "name": "Cahava Springs" }, { "code": "CF", "name": "Carefree" }, { "code": "PX", "name": "Phoenix" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingdistrict", "length": 32, "alias": "OperatingDistrict", "type": "esriFieldTypeString" }, { "modelName": "SYSTEM", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "system", "length": 20, "alias": "System", "type": "esriFieldTypeString" }, { "modelName": "CATHODICPROTECTION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cathodicprotection", "length": 3, "alias": "CathodicProtection", "type": "esriFieldTypeString" }, { "modelName": "WATERTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wWaterType", "description": "The type of water flowing through pipe", "type": "codedValue", "codedValues": [ { "code": "Potable", "name": "Potable Water" }, { "code": "Raw", "name": "Raw Water" }, { "code": "Reclaimed", "name": "Reclaimed Water" }, { "code": "Storm", "name": "Storm Runoff" }, { "code": "Treated", "name": "Treated Water" }, { "code": "Well", "name": "Well Water" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "watertype", "length": 50, "alias": "Water Type", "type": "esriFieldTypeString" }, { "modelName": "LEGACYID1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid1", "length": 20, "alias": "LEGACYID1", "type": "esriFieldTypeString" }, { "modelName": "LEGACYID2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid2", "length": 20, "alias": "LEGACYID2", "type": "esriFieldTypeString" }, { "modelName": "ADDRESS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 100, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "CONDITION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "condition", "alias": "Condition", "type": "esriFieldTypeDouble" }, { "modelName": "CONDITIONDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "conditiondate", "length": 29, "alias": "Condition Date", "type": "esriFieldTypeDate" }, { "modelName": "WARRANTYDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "warrantydate", "length": 29, "alias": "Warranty Date", "type": "esriFieldTypeDate" }, { "modelName": "SAFETYREQUIREMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "safetyrequirements", "length": 30, "alias": "Safety Requirements", "type": "esriFieldTypeString" }, { "modelName": "COF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cof", "alias": "Consequence of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "POF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pof", "alias": "Probability of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "BRE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bre", "alias": "Business Risk Exposure", "type": "esriFieldTypeInteger" }, { "modelName": "GPSCOLLECTIONTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpscollectiontype", "length": 25, "alias": "GPSCollectionType", "type": "esriFieldTypeString" }, { "modelName": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPSDate", "type": "esriFieldTypeDate" }, { "modelName": "GPSESTACC", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsestacc", "alias": "GPSEstAcc", "type": "esriFieldTypeDouble" }, { "modelName": "GPSFIELDNOTES", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsfieldnotes", "length": 100, "alias": "GPSFieldNotes", "type": "esriFieldTypeString" }, { "modelName": "QSEC", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "qsec", "length": 20, "alias": "Quartersection", "type": "esriFieldTypeString" }, { "modelName": "CIPNUMBER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cipnumber", "length": 15, "alias": "CIP Number", "type": "esriFieldTypeString" }, { "modelName": "STATEPERMITNUMBER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "statepermitnumber", "length": 20, "alias": "StatePermitNumber", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "DataSourceType", "description": "Data source of feature", "type": "codedValue", "codedValues": [ { "code": "Asbuilt", "name": "As-built Record Plan" }, { "code": "Construction", "name": "Construction Plan" }, { "code": "Conventional Survey", "name": "Conventional Survey" }, { "code": "Estimated", "name": "Estimated Feature Location" }, { "code": "Existing", "name": "Existing Records" }, { "code": "Field Measured", "name": "Field Measured" }, { "code": "Field Notes", "name": "Field Notes" }, { "code": "GPSCM", "name": "Subcentimeter GPS" }, { "code": "GPSM", "name": "Submeter GPS" }, { "code": "Markup", "name": "Markup" }, { "code": "Overall", "name": "Overall System Map" }, { "code": "Planimetric Landbase", "name": "Planimetric Landbase" }, { "code": "Record Drawing", "name": "Record Drawing" }, { "code": "Sketch", "name": "Sketch" }, { "code": "SubFoot GPS", "name": "SubFoot GPS" }, { "code": "TaxMap", "name": "Tax Map" }, { "code": "VRS Collected", "name": "VRS Collected" }, { "code": "AutoCAD Drawing", "name": "AutoCAD Drawing" }, { "code": "KML", "name": "Google Earth kml sketch" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasourcetype", "length": 20, "alias": "DataSourceType", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCEREFERENCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datasourcereference", "length": 50, "alias": "DataSourceReference", "type": "esriFieldTypeString" }, { "modelName": "CREATEEDITOR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "createeditor", "length": 20, "alias": "Creation User", "type": "esriFieldTypeString" }, { "modelName": "CREATEDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "createdate", "length": 29, "alias": "Date Created", "type": "esriFieldTypeDate" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "Cadastral", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cadastral", "length": 15, "alias": "Cadastral", "type": "esriFieldTypeString" }, { "modelName": "ADWR_Number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "adwr_number", "length": 15, "alias": "ADWR_Number", "type": "esriFieldTypeString" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r4682_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4206_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "3e8531e219c5404db0d768eeb7498933", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAADVklEQVRIic2W30tTYRjHv6hTs9VYrjYN/BU568IfrYJZIcwyEKUbIepCL4p1JwTRRRTkVX9AV6777MKLahIYiDkJIuYkf2T+mi2bm2nOOcvpUON5z3uOx53jmhXSFw6Hnb3v+znP8z7v9zlp2EOl/Y+wegAWAHX8LioAwAnAAaDvb2F2flmQqQd0hWB3ukhBTw7CXnEMwVo4fNcwmlQHXRFgbgCMp5QjihuEu68LGGu3IBp6CaCDZyJpmAAiiLhgIuVXC9dYOzDaTql2AzidDEwAnb2rHk0iFTcAGXpg4AntayuAW4lgdimi3YJEUYSrIYrQHl84ShjtEU9dVkYq9Np0+L+vSAMOZmnY82AoKj3TZqYhXZOChcia8IDmBz1A2EtZylWDCeVNUXE9vWNFZYkBOU0vsL6xyUDjrbXsBcqaOzEyvcTGOR9cQJFJi/wbskIsuwm47uXwo9IXDxPKW5a+8I8YDusyUFGkh3tiAZcrTDiiy2T/XT2fh4dtQ9iXnopzJw0YmApvzxFlSMwW3zs5rI6dI5lcw3NotBXAWpLNYJfKTViNbWB6/idqKkwMdub4IWhSU+Aa/ha3IxBefNYjmYAyMpl6hoQFKk8Y8LhjHBfLjXg7MocPU4tori+GLkvD/iP1DM1BIWE9VdiWM3BNBJZZcVjN2Thm0qLQuB+OzkkGu33FDFuZkUW9uQn0ftwRlrw3UnTXq/LRVF3Afr/uD+LT1yWWzppyE6xmAwY+L25VolIBNViAeV2cY1B6CEZpm19aRb83xCKhdF6rymOpbHP51DFU/sCMGszJTVURGYkWfdb7hYGECGdhKzVKL6QqOtw7HGo67XZmquQCXKP+CCaDy2zPnr/zS89fuWfwqLEU0dg6ugdVKpHWiYbEdRUweoM+5t4yGKm2xQXz0QNwvpcygkFfGLb73YisxBBaXlOHiWuqwEgtrE2Qe8v2bswfYVe83qhFRKL5YS94f8NOMPKbDtYmyL3jIkxKsx4yYTF9zt+VPnmkm7UJ2uBk+pkooZ+BN9Bt7SXROaPG18raBJUvmeqW16nvj69LTJ1DDZQIBj7BwdqE4N6C123/BhHKOyqV+B9/g4gL5HJ/s3NTtcicYYaP+SdfV3Koamp2oz39SP0F0p87iSbhFfEAAAAASUVORK5CYII=", "yoffset": 0, "width": 20, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "31c31346e63a0003122a8bec77d52304", "height": 20 }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4001873.9337000027, "xmin": -1.24638836997E7, "ymax": 4008685.3783000037, "xmax": -1.24537653599E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "definitionQuery": "OWNEDBY = 4", "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 11, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "wLateralLine", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "operatingdistrict": null, "datasourcetype": null, "facilityid": null, "installdate": null, "pof": null, "enabled": 1, "operatingcompany": null, "bre": null, "diameter": null, "safetyrequirements": null, "warrantydate": null, "watertype": "Potable", "ownedby": 1, "projectid": null, "address": null, "lifecyclestatuschangedate": null, "lateraltype": null, "activeflag": "Active", "depth": null, "system": null, "material": null, "cipnumber": null, "datasourcereference": null, "pipeaccesstype": "Public", "location": null, "maintby": 1, "cof": null, "operatingdivision": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": { "name": "Water System", "id": 0 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "wLateralLine", "allowTrueCurvesUpdates": false, "displayField": "facilityid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 20, "alias": "Service ID", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "WARRANTYDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "warrantydate", "length": 29, "alias": "Warranty Date", "type": "esriFieldTypeDate" }, { "modelName": "MATERIAL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "type": "codedValue", "codedValues": [ { "code": "ABS", "name": "Acrylonitrile Butadiene Styrene" }, { "code": "AC", "name": "Asbestos Cement" }, { "code": "BR", "name": "Brass" }, { "code": "CI", "name": "Cast Iron" }, { "code": "CIPP", "name": "Cured In Place Pipe" }, { "code": "CP", "name": "Concrete (Non-Reinforced)" }, { "code": "CU", "name": "Copper" }, { "code": "DI", "name": "Ductile Iron" }, { "code": "FRP", "name": "Fiberglass Reinforced" }, { "code": "GALV", "name": "Galvanized Pipe" }, { "code": "HDPE", "name": "High Density Polyethylene" }, { "code": "PCCP", "name": "Prestressed Concrete Cylindrical Pipe" }, { "code": "PE", "name": "Polyethylene" }, { "code": "PP", "name": "Polypropylene" }, { "code": "PVC", "name": "Polyvinyl Chloride" }, { "code": "RCP", "name": "Reinforced Concrete" }, { "code": "ST", "name": "Steel" }, { "code": "UNK", "name": "Unknown" }, { "code": "VCP", "name": "Vitrified Clay" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "material", "length": 20, "alias": "Material", "type": "esriFieldTypeString" }, { "modelName": "LATERALTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wLateralType", "description": "The type of water lateral line", "type": "codedValue", "codedValues": [ { "code": "Commercial", "name": "Commercial" }, { "code": "Domestic", "name": "Domestic" }, { "code": "Fire", "name": "Fire" }, { "code": "Hydrant", "name": "Hydrant" }, { "code": "Industrial", "name": "Industrial" }, { "code": "Irrigation", "name": "Irrigation" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lateraltype", "length": 20, "alias": "Lateral Type", "type": "esriFieldTypeString" }, { "modelName": "ADDRESS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 50, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 50, "alias": "Location\\Cross Street", "type": "esriFieldTypeString" }, { "modelName": "DIAMETER", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "piPipeDiameter", "description": "A list of pipe diameters", "type": "codedValue", "codedValues": [ { "code": 0.75, "name": "3/4\"" }, { "code": 1, "name": "1\"" }, { "code": 1.25, "name": "1 1/4\"" }, { "code": 1.5, "name": "1 1/2\"" }, { "code": 1.75, "name": "1 3/4\"" }, { "code": 2, "name": "2\"" }, { "code": 2.5, "name": "2 1/2\"" }, { "code": 3, "name": "3\"" }, { "code": 4, "name": "4\"" }, { "code": 6, "name": "6\"" }, { "code": 8, "name": "8\"" }, { "code": 10, "name": "10\"" }, { "code": 12, "name": "12\"" }, { "code": 14, "name": "14\"" }, { "code": 15, "name": "15\"" }, { "code": 16, "name": "16\"" }, { "code": 18, "name": "18\"" }, { "code": 20, "name": "20\"" }, { "code": 21, "name": "21\"" }, { "code": 24, "name": "24\"" }, { "code": 27, "name": "27\"" }, { "code": 30, "name": "30\"" }, { "code": 33, "name": "33\"" }, { "code": 36, "name": "36\"" }, { "code": 40, "name": "40\"" }, { "code": 42, "name": "42\"" }, { "code": 48, "name": "48\"" }, { "code": 54, "name": "54\"" }, { "code": 60, "name": "60\"" }, { "code": 66, "name": "66\"" }, { "code": 72, "name": "72\"" }, { "code": 75, "name": "75\"" }, { "code": 0, "name": "Unknown" }, { "code": 2.75, "name": "2 3/4\"" }, { "code": 22, "name": "22\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "diameter", "alias": "Diameter", "type": "esriFieldTypeDouble" }, { "modelName": "DEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "depth", "alias": "Depth", "type": "esriFieldTypeDouble" }, { "modelName": "WATERTYPE", "nullable": true, "editable": true, "defaultValue": "Potable", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wWaterType", "description": "The type of water flowing through pipe", "type": "codedValue", "codedValues": [ { "code": "Potable", "name": "Potable Water" }, { "code": "Raw", "name": "Raw Water" }, { "code": "Reclaimed", "name": "Reclaimed Water" }, { "code": "Storm", "name": "Storm Runoff" }, { "code": "Treated", "name": "Treated Water" }, { "code": "Well", "name": "Well Water" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "watertype", "length": 30, "alias": "Water Type", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LifeCycleStatus_94", "description": "Status of an asset", "type": "codedValue", "codedValues": [ { "code": "Abandoned", "name": "Abandoned" }, { "code": "Active", "name": "Active" }, { "code": "Cancelled", "name": "Cancelled" }, { "code": "Out of Service", "name": "Out of Service" }, { "code": "Pending", "name": "Pending" }, { "code": "Proposed", "name": "Proposed" }, { "code": "Retired / Scrapped", "name": "Retired / Scrapped" }, { "code": "Retired in Place", "name": "Retired in Place" }, { "code": "Transferred", "name": "Transferred" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "length": 20, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetOwner_75", "description": "The owner of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Unknown" }, { "code": 1, "name": "Town of Cave Creek" }, { "code": 2, "name": "City Of Phoenix" }, { "code": 3, "name": "Liberty Utilities" }, { "code": 4, "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetManager_33", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" }, { "code": 1, "name": "Cave Creek Utilities" }, { "code": 2, "name": "City of Phoenix" }, { "code": 3, "name": "Liberty Utilities" }, { "code": 4, "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintby", "alias": "Managed By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OPERATINGCOMPANY", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingCompany_27", "description": "Operating Company", "type": "codedValue", "codedValues": [ { "code": "-1", "name": "Unknown" }, { "code": "1", "name": "Cave Creek utilities" }, { "code": "2", "name": "Liberty Utilities" }, { "code": "3", "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingcompany", "length": 32, "alias": "OperatingCompany", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDIVISION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingDivision_27", "description": "Division with Operating Company", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingdivision", "length": 32, "alias": "OperatingDivision", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDISTRICT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingDistrict_38", "description": "Operating District within Operating Division", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingdistrict", "length": 32, "alias": "OperatingDistrict", "type": "esriFieldTypeString" }, { "modelName": "SYSTEM", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PWSIDNumber", "description": "Public Water System Number", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "system", "length": 20, "alias": "System", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUSCHANGEDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lifecyclestatuschangedate", "length": 29, "alias": "LifeCycleStatusChangeDate", "type": "esriFieldTypeDate" }, { "modelName": "PROJECTID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectid", "length": 15, "alias": "Project ID", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "DataSourceType", "description": "Data source of feature", "type": "codedValue", "codedValues": [ { "code": "Asbuilt", "name": "As-built Record Plan" }, { "code": "Construction", "name": "Construction Plan" }, { "code": "Conventional Survey", "name": "Conventional Survey" }, { "code": "Estimated", "name": "Estimated Feature Location" }, { "code": "Existing", "name": "Existing Records" }, { "code": "Field Measured", "name": "Field Measured" }, { "code": "Field Notes", "name": "Field Notes" }, { "code": "GPSCM", "name": "Subcentimeter GPS" }, { "code": "GPSM", "name": "Submeter GPS" }, { "code": "Markup", "name": "Markup" }, { "code": "Overall", "name": "Overall System Map" }, { "code": "Planimetric Landbase", "name": "Planimetric Landbase" }, { "code": "Record Drawing", "name": "Record Drawing" }, { "code": "Sketch", "name": "Sketch" }, { "code": "SubFoot GPS", "name": "SubFoot GPS" }, { "code": "TaxMap", "name": "Tax Map" }, { "code": "VRS Collected", "name": "VRS Collected" }, { "code": "AutoCAD Drawing", "name": "AutoCAD Drawing" }, { "code": "KML", "name": "Google Earth kml sketch" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasourcetype", "length": 20, "alias": "DataSourceType", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCEREFERENCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datasourcereference", "length": 50, "alias": "DataSourceReference", "type": "esriFieldTypeString" }, { "modelName": "CIPNUMBER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cipnumber", "length": 15, "alias": "CIP Number", "type": "esriFieldTypeString" }, { "modelName": "PIPEACCESSTYPE", "nullable": true, "editable": true, "defaultValue": "Public", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PipeLocation", "description": "The legal location of an asset", "type": "codedValue", "codedValues": [ { "code": "Easement", "name": "Easement" }, { "code": "EPCOR", "name": "EPCOR" }, { "code": "Private", "name": "Private ROW" }, { "code": "Public", "name": "Public ROW" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "pipeaccesstype", "length": 15, "alias": "Pipe Access Type", "type": "esriFieldTypeString" }, { "modelName": "SAFETYREQUIREMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "safetyrequirements", "length": 30, "alias": "Safety Requirements", "type": "esriFieldTypeString" }, { "modelName": "COF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cof", "alias": "Consequence of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "POF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pof", "alias": "Probability of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "BRE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bre", "alias": "Business Risk Exposure", "type": "esriFieldTypeInteger" }, { "modelName": "CREATEEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "createeditor", "length": 20, "alias": "Creation User", "type": "esriFieldTypeString" }, { "modelName": "CREATEDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "createdate", "length": 29, "alias": "Date Created", "type": "esriFieldTypeDate" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "Enabled", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r4685_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4209_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "lastupdate", "editorField": "lasteditor", "creationDateField": "createdate", "creatorField": "createeditor" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "3e8531e219c5404db0d768eeb7498933", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "color": [ 0, 92, 230, 255 ], "width": 1, "style": "esriSLSSolid", "type": "esriSLS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 3986859.6520000026, "xmin": -1.24785957412E7, "ymax": 4012728.8170000017, "xmax": -1.24537391591E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "definitionQuery": "OWNEDBY = 4", "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 12, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "wMain", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "operatingdistrict": null, "pressureclass": null, "datasourcetype": null, "pressurezonehgl": null, "facilityid": null, "installdate": null, "planref": null, "pof": null, "globalid": null, "createdate": null, "enabled": 1, "operatingcompany": null, "gpscollectiontype": null, "diameter": null, "exteriorprotectionorwrap": null, "bre": null, "safetyrequirements": null, "differentthannormaldepth": "No", "warrantydate": null, "watertype": "Potable", "gpsdate": null, "ownedby": 1, "projectid": null, "conditiondate": null, "lifecyclestatuschangedate": null, "measuredlength": null, "cathodicprotection": null, "lasteditor": null, "activeflag": "Active", "gpsfieldnotes": null, "condition": null, "depth": null, "system": null, "inmodel": null, "material": null, "createeditor": null, "cipnumber": null, "datasourcereference": null, "pressurezonename": null, "gpsestacc": null, "liningtype": null, "pipeaccesstype": "Public", "restrained": null, "maintby": 1, "cof": null, "lastupdate": null, "operatingdivision": null, "pipetype": "Distribution" } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": { "name": "Water System", "id": 0 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "wMain", "allowTrueCurvesUpdates": false, "displayField": "pressurezonename", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 20, "alias": "Facility Identifier", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "WARRANTYDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "warrantydate", "length": 29, "alias": "Warranty Date", "type": "esriFieldTypeDate" }, { "modelName": "MATERIAL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "type": "codedValue", "codedValues": [ { "code": "ABS", "name": "Acrylonitrile Butadiene Styrene" }, { "code": "AC", "name": "Asbestos Cement" }, { "code": "BR", "name": "Brass" }, { "code": "CI", "name": "Cast Iron" }, { "code": "CIPP", "name": "Cured In Place Pipe" }, { "code": "CP", "name": "Concrete (Non-Reinforced)" }, { "code": "CU", "name": "Copper" }, { "code": "DI", "name": "Ductile Iron" }, { "code": "FRP", "name": "Fiberglass Reinforced" }, { "code": "GALV", "name": "Galvanized Pipe" }, { "code": "HDPE", "name": "High Density Polyethylene" }, { "code": "PCCP", "name": "Prestressed Concrete Cylindrical Pipe" }, { "code": "PE", "name": "Polyethylene" }, { "code": "PP", "name": "Polypropylene" }, { "code": "PVC", "name": "Polyvinyl Chloride" }, { "code": "RCP", "name": "Reinforced Concrete" }, { "code": "ST", "name": "Steel" }, { "code": "UNK", "name": "Unknown" }, { "code": "VCP", "name": "Vitrified Clay" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "material", "length": 20, "alias": "Material", "type": "esriFieldTypeString" }, { "modelName": "DIAMETER", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "piPipeDiameter", "description": "A list of pipe diameters", "type": "codedValue", "codedValues": [ { "code": 0.75, "name": "3/4\"" }, { "code": 1, "name": "1\"" }, { "code": 1.25, "name": "1 1/4\"" }, { "code": 1.5, "name": "1 1/2\"" }, { "code": 1.75, "name": "1 3/4\"" }, { "code": 2, "name": "2\"" }, { "code": 2.5, "name": "2 1/2\"" }, { "code": 3, "name": "3\"" }, { "code": 4, "name": "4\"" }, { "code": 6, "name": "6\"" }, { "code": 8, "name": "8\"" }, { "code": 10, "name": "10\"" }, { "code": 12, "name": "12\"" }, { "code": 14, "name": "14\"" }, { "code": 15, "name": "15\"" }, { "code": 16, "name": "16\"" }, { "code": 18, "name": "18\"" }, { "code": 20, "name": "20\"" }, { "code": 21, "name": "21\"" }, { "code": 24, "name": "24\"" }, { "code": 27, "name": "27\"" }, { "code": 30, "name": "30\"" }, { "code": 33, "name": "33\"" }, { "code": 36, "name": "36\"" }, { "code": 40, "name": "40\"" }, { "code": 42, "name": "42\"" }, { "code": 48, "name": "48\"" }, { "code": 54, "name": "54\"" }, { "code": 60, "name": "60\"" }, { "code": 66, "name": "66\"" }, { "code": 72, "name": "72\"" }, { "code": 75, "name": "75\"" }, { "code": 0, "name": "Unknown" }, { "code": 2.75, "name": "2 3/4\"" }, { "code": 22, "name": "22\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "diameter", "alias": "Diameter", "type": "esriFieldTypeDouble" }, { "modelName": "DEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "depth", "alias": "Depth", "type": "esriFieldTypeDouble" }, { "modelName": "WATERTYPE", "nullable": true, "editable": true, "defaultValue": "Potable", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wWaterType", "description": "The type of water flowing through pipe", "type": "codedValue", "codedValues": [ { "code": "Potable", "name": "Potable Water" }, { "code": "Raw", "name": "Raw Water" }, { "code": "Reclaimed", "name": "Reclaimed Water" }, { "code": "Storm", "name": "Storm Runoff" }, { "code": "Treated", "name": "Treated Water" }, { "code": "Well", "name": "Well Water" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "watertype", "length": 30, "alias": "Water Type", "type": "esriFieldTypeString" }, { "modelName": "PIPETYPE", "nullable": true, "editable": true, "defaultValue": "Distribution", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "piPipeType", "description": "Water pipe type", "type": "codedValue", "codedValues": [ { "code": "Distribution", "name": "Distribution" }, { "code": "Plant", "name": "Plant" }, { "code": "Transmission", "name": "Transmission" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "pipetype", "length": 15, "alias": "Pipe Type", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": null, "name": "activeflag", "length": 20, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": null, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": null, "name": "maintby", "alias": "Managed By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "CONDITION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Condition_58", "description": "The condition of the asset", "type": "codedValue", "codedValues": [ { "code": "1", "name": "Excellent" }, { "code": "0", "name": "Unknown" }, { "code": "2", "name": "Good" }, { "code": "3", "name": "Fair" }, { "code": "4", "name": "Poor" }, { "code": "5", "name": "Immediate Attention" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "condition", "length": 1, "alias": "Condition", "type": "esriFieldTypeString" }, { "modelName": "CONDITIONDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "conditiondate", "length": 29, "alias": "Condition Date", "type": "esriFieldTypeDate" }, { "modelName": "OPERATINGCOMPANY", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "operatingcompany", "length": 32, "alias": "OperatingCompany", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDIVISION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "operatingdivision", "length": 32, "alias": "OperatingDivision", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDISTRICT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "operatingdistrict", "length": 32, "alias": "OperatingDistrict", "type": "esriFieldTypeString" }, { "modelName": "SYSTEM", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PWSIDNumber", "description": "Public Water System Number", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "system", "length": 20, "alias": "System", "type": "esriFieldTypeString" }, { "modelName": "CATHODICPROTECTION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "cathodicprotection", "length": 3, "alias": "CathodicProtection", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUSCHANGEDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lifecyclestatuschangedate", "length": 29, "alias": "LifeCycleStatusChangeDate", "type": "esriFieldTypeDate" }, { "modelName": "MEASUREDLENGTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "measuredlength", "alias": "MeasuredLength", "type": "esriFieldTypeDouble" }, { "modelName": "PROJECTID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectid", "length": 15, "alias": "Project ID", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "DataSourceType", "description": "Data source of feature", "type": "codedValue", "codedValues": [ { "code": "Asbuilt", "name": "As-built Record Plan" }, { "code": "Construction", "name": "Construction Plan" }, { "code": "Conventional Survey", "name": "Conventional Survey" }, { "code": "Estimated", "name": "Estimated Feature Location" }, { "code": "Existing", "name": "Existing Records" }, { "code": "Field Measured", "name": "Field Measured" }, { "code": "Field Notes", "name": "Field Notes" }, { "code": "GPSCM", "name": "Subcentimeter GPS" }, { "code": "GPSM", "name": "Submeter GPS" }, { "code": "Markup", "name": "Markup" }, { "code": "Overall", "name": "Overall System Map" }, { "code": "Planimetric Landbase", "name": "Planimetric Landbase" }, { "code": "Record Drawing", "name": "Record Drawing" }, { "code": "Sketch", "name": "Sketch" }, { "code": "SubFoot GPS", "name": "SubFoot GPS" }, { "code": "TaxMap", "name": "Tax Map" }, { "code": "VRS Collected", "name": "VRS Collected" }, { "code": "AutoCAD Drawing", "name": "AutoCAD Drawing" }, { "code": "KML", "name": "Google Earth kml sketch" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasourcetype", "length": 20, "alias": "DataSourceType", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCEREFERENCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datasourcereference", "length": 50, "alias": "DataSourceReference", "type": "esriFieldTypeString" }, { "modelName": "PRESSUREZONENAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressurezonename", "length": 50, "alias": "PressureZoneName", "type": "esriFieldTypeString" }, { "modelName": "PRESSUREZONEHGL", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressurezonehgl", "alias": "PressureZoneHGL", "type": "esriFieldTypeInteger" }, { "modelName": "CIPNUMBER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cipnumber", "length": 15, "alias": "CIP Number", "type": "esriFieldTypeString" }, { "modelName": "PIPEACCESSTYPE", "nullable": true, "editable": true, "defaultValue": "Public", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PipeLocation", "description": "The legal location of an asset", "type": "codedValue", "codedValues": [ { "code": "Easement", "name": "Easement" }, { "code": "EPCOR", "name": "EPCOR" }, { "code": "Private", "name": "Private ROW" }, { "code": "Public", "name": "Public ROW" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "pipeaccesstype", "length": 15, "alias": "Pipe Access Type", "type": "esriFieldTypeString" }, { "modelName": "GPSCOLLECTIONTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpscollectiontype", "length": 25, "alias": "GPSCollectionType", "type": "esriFieldTypeString" }, { "modelName": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPS_Date", "type": "esriFieldTypeDate" }, { "modelName": "GPSESTACC", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsestacc", "alias": "GPSEstAcc", "type": "esriFieldTypeDouble" }, { "modelName": "GPSFIELDNOTES", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsfieldnotes", "length": 100, "alias": "GPSFieldNotes", "type": "esriFieldTypeString" }, { "modelName": "DIFFERENTTHANNORMALDEPTH", "nullable": true, "editable": true, "defaultValue": "No", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "differentthannormaldepth", "length": 10, "alias": "DifferentThanNormalDepth", "type": "esriFieldTypeString" }, { "modelName": "EXTERIORPROTECTIONORWRAP", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ExteriorProtection", "description": "External pipe protection type", "type": "codedValue", "codedValues": [ { "code": "CathodicProtection", "name": "CathodicProtection" }, { "code": "Polywrapped", "name": "Polywrapped" }, { "code": "Tracer", "name": "Tracer" }, { "code": "Wrapped", "name": "Wrapped" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "exteriorprotectionorwrap", "length": 20, "alias": "ExteriorProtectionorWrap", "type": "esriFieldTypeString" }, { "modelName": "LININGTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LiningType", "description": "Internal pipe lining type", "type": "codedValue", "codedValues": [ { "code": "Cement", "name": "Cement Mortar Lining" }, { "code": "Epoxy", "name": "Epoxy Spray Lining" }, { "code": "Glass", "name": "Glass Fiber" }, { "code": "PE", "name": "Polyethylene" }, { "code": "PVC", "name": "Fusible PVC" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "liningtype", "length": 20, "alias": "LiningType", "type": "esriFieldTypeString" }, { "modelName": "PRESSURECLASS", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PressureClass", "description": "Pipe pressure class", "type": "codedValue", "codedValues": [ { "code": "DI-150", "name": "DI-150" }, { "code": "DI-200", "name": "DI-200" }, { "code": "DI-250", "name": "DI-250" }, { "code": "DI-300", "name": "DI-300" }, { "code": "DI-350", "name": "DI-350" }, { "code": "RCP-III", "name": "RCP-III" }, { "code": "RCP-IV", "name": "RCP-IV" }, { "code": "RCP-V", "name": "RCP-V" }, { "code": "RCP-VI", "name": "RCP-VI" }, { "code": "Schedule40", "name": "Schedule40" }, { "code": "Schedule80", "name": "Schedule80" }, { "code": "SDR-14", "name": "SDR-14" }, { "code": "SDR-18", "name": "SDR-18" }, { "code": "SDR-21", "name": "SDR-21" }, { "code": "SDR-25", "name": "SDR-25" }, { "code": "SDR-26", "name": "SDR-26" }, { "code": "SDR-32.5", "name": "SDR-32.5" }, { "code": "SDR-41", "name": "SDR-41" }, { "code": "SDR-51", "name": "SDR-51" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "pressureclass", "length": 20, "alias": "PressureClass", "type": "esriFieldTypeString" }, { "modelName": "RESTRAINED", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "restrained", "length": 4, "alias": "Restrained", "type": "esriFieldTypeString" }, { "modelName": "INMODEL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "inmodel", "length": 4, "alias": "InModel", "type": "esriFieldTypeString" }, { "modelName": "SAFETYREQUIREMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "safetyrequirements", "length": 30, "alias": "Safety Requirements", "type": "esriFieldTypeString" }, { "modelName": "COF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cof", "alias": "Consequence of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "POF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pof", "alias": "Probability of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "BRE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bre", "alias": "Business Risk Exposure", "type": "esriFieldTypeInteger" }, { "modelName": "CREATEEDITOR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "createeditor", "length": 20, "alias": "Creation User", "type": "esriFieldTypeString" }, { "modelName": "CREATEDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "createdate", "length": 29, "alias": "Date Created", "type": "esriFieldTypeDate" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "Enabled", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "modelName": "PlanRef", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "planref", "length": 255, "alias": "PlanRef", "type": "esriFieldTypeString" }, { "modelName": "GlobalID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGUID" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r4681_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4205_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "3e8531e219c5404db0d768eeb7498933", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "color": [ 0, 92, 230, 255 ], "width": 2, "style": "esriSLSSolid", "type": "esriSLS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 7, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "wSystemInterconnection", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "operatingdistrict": null, "datasourcetype": null, "facilityid": null, "installdate": null, "interconnectiontype": null, "lifecyclestatuschangedate": null, "pof": null, "metersize": null, "enabled": 1, "activeflag": "Active", "operatingcompany": null, "system": null, "bre": null, "cipnumber": null, "datasourcereference": null, "safetyrequirements": null, "name": null, "warrantydate": null, "location": null, "maintby": 1, "watertype": "Potable", "cof": null, "ownedby": 1, "operatingdivision": null } } } ], "supportsAdvancedQueries": true, "parentLayer": { "name": "Water System", "id": 0 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "wSystemInterconnection", "allowTrueCurvesUpdates": false, "displayField": "name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 20, "alias": "Facility Identifier", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "WARRANTYDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "warrantydate", "length": 29, "alias": "Warranty Date", "type": "esriFieldTypeDate" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 200, "alias": "Location Description", "type": "esriFieldTypeString" }, { "modelName": "NAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name", "length": 50, "alias": "Name", "type": "esriFieldTypeString" }, { "modelName": "ENABLED", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LifeCycleStatus_94", "description": "Status of an asset", "type": "codedValue", "codedValues": [ { "code": "Abandoned", "name": "Abandoned" }, { "code": "Active", "name": "Active" }, { "code": "Cancelled", "name": "Cancelled" }, { "code": "Out of Service", "name": "Out of Service" }, { "code": "Pending", "name": "Pending" }, { "code": "Proposed", "name": "Proposed" }, { "code": "Retired / Scrapped", "name": "Retired / Scrapped" }, { "code": "Retired in Place", "name": "Retired in Place" }, { "code": "Transferred", "name": "Transferred" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "length": 20, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetOwner_75", "description": "The owner of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Unknown" }, { "code": 1, "name": "Town of Cave Creek" }, { "code": 2, "name": "City Of Phoenix" }, { "code": 3, "name": "Liberty Utilities" }, { "code": 4, "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetManager_33", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" }, { "code": 1, "name": "Cave Creek Utilities" }, { "code": 2, "name": "City of Phoenix" }, { "code": 3, "name": "Liberty Utilities" }, { "code": 4, "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintby", "alias": "Managed By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OPERATINGCOMPANY", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingCompany_27", "description": "Operating Company", "type": "codedValue", "codedValues": [ { "code": "-1", "name": "Unknown" }, { "code": "1", "name": "Cave Creek utilities" }, { "code": "2", "name": "Liberty Utilities" }, { "code": "3", "name": "Carefree" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingcompany", "length": 32, "alias": "OperatingCompany", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDIVISION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingDivision_27", "description": "Division with Operating Company", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingdivision", "length": 32, "alias": "OperatingDivision", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGDISTRICT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingDistrict_38", "description": "Operating District within Operating Division", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "operatingdistrict", "length": 32, "alias": "OperatingDistrict", "type": "esriFieldTypeString" }, { "modelName": "SYSTEM", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PWSIDNumber", "description": "Public Water System Number", "type": "codedValue", "codedValues": [], "mergePolicy": "esriMPTDefaultValue" }, "name": "system", "length": 20, "alias": "System", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUSCHANGEDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lifecyclestatuschangedate", "length": 29, "alias": "LifeCycleStatusChangeDate", "type": "esriFieldTypeDate" }, { "modelName": "WATERTYPE", "nullable": true, "editable": true, "defaultValue": "Potable", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wWaterType", "description": "The type of water flowing through pipe", "type": "codedValue", "codedValues": [ { "code": "Potable", "name": "Potable Water" }, { "code": "Raw", "name": "Raw Water" }, { "code": "Reclaimed", "name": "Reclaimed Water" }, { "code": "Storm", "name": "Storm Runoff" }, { "code": "Treated", "name": "Treated Water" }, { "code": "Well", "name": "Well Water" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "watertype", "length": 50, "alias": "Water Type", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "DataSourceType", "description": "Data source of feature", "type": "codedValue", "codedValues": [ { "code": "Asbuilt", "name": "As-built Record Plan" }, { "code": "Construction", "name": "Construction Plan" }, { "code": "Conventional Survey", "name": "Conventional Survey" }, { "code": "Estimated", "name": "Estimated Feature Location" }, { "code": "Existing", "name": "Existing Records" }, { "code": "Field Measured", "name": "Field Measured" }, { "code": "Field Notes", "name": "Field Notes" }, { "code": "GPSCM", "name": "Subcentimeter GPS" }, { "code": "GPSM", "name": "Submeter GPS" }, { "code": "Markup", "name": "Markup" }, { "code": "Overall", "name": "Overall System Map" }, { "code": "Planimetric Landbase", "name": "Planimetric Landbase" }, { "code": "Record Drawing", "name": "Record Drawing" }, { "code": "Sketch", "name": "Sketch" }, { "code": "SubFoot GPS", "name": "SubFoot GPS" }, { "code": "TaxMap", "name": "Tax Map" }, { "code": "VRS Collected", "name": "VRS Collected" }, { "code": "AutoCAD Drawing", "name": "AutoCAD Drawing" }, { "code": "KML", "name": "Google Earth kml sketch" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasourcetype", "length": 20, "alias": "DataSourceType", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCEREFERENCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datasourcereference", "length": 50, "alias": "DataSourceReference", "type": "esriFieldTypeString" }, { "modelName": "CIPNUMBER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cipnumber", "length": 15, "alias": "CIP Number", "type": "esriFieldTypeString" }, { "modelName": "INTERCONNECTIONTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "InterconnectionType", "description": "Purpose of water connection between EPCOR and another entity", "type": "codedValue", "codedValues": [ { "code": "Buy", "name": "Buy" }, { "code": "Sell", "name": "Sell" }, { "code": "Resale", "name": "Resale" }, { "code": "Emergency", "name": "Emergency" }, { "code": "Wheeling", "name": "Wheeling" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "interconnectiontype", "length": 20, "alias": "InterconnectionType", "type": "esriFieldTypeString" }, { "modelName": "SAFETYREQUIREMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "safetyrequirements", "length": 30, "alias": "Safety Requirements", "type": "esriFieldTypeString" }, { "modelName": "COF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cof", "alias": "Consequence of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "POF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pof", "alias": "Probability of Failure", "type": "esriFieldTypeInteger" }, { "modelName": "BRE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bre", "alias": "Business Risk Exposure", "type": "esriFieldTypeInteger" }, { "modelName": "CREATEEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "createeditor", "length": 20, "alias": "Creation User", "type": "esriFieldTypeString" }, { "modelName": "CREATEDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "createdate", "length": 29, "alias": "Date Created", "type": "esriFieldTypeDate" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "METERSIZE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "MeterSize", "description": "Diameter of water meter", "type": "codedValue", "codedValues": [ { "code": 0.625, "name": "5/8\"" }, { "code": 0.75, "name": "3/4\"" }, { "code": 1, "name": "1\"" }, { "code": 1.5, "name": "1 1/2\"" }, { "code": 2, "name": "2\"" }, { "code": 3, "name": "3\"" }, { "code": 4, "name": "4\"" }, { "code": 6, "name": "6\"" }, { "code": 8, "name": "8\"" }, { "code": 10, "name": "10\"" }, { "code": 12, "name": "12\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "metersize", "alias": "MeterSize", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r4683_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4207_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "lastupdate", "editorField": "lasteditor", "creationDateField": "createdate", "creatorField": "createeditor" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "3e8531e219c5404db0d768eeb7498933", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 0, 92, 230, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }