{ "tables": [], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 3869674.505599998, "xmin": -1.24285261208E7, "ymax": 3871353.7622999996, "xmax": -1.2426779604899999E7, "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": 16000, "isDataVersioned": false, "templates": [ { "name": "ssLiftStation", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "operatingdistrict": null, "datasourcetype": null, "installdate": null, "wastewatertype": null, "pof": null, "structureid": null, "createdate": null, "facilityname": null, "building": null, "enabled": 1, "liftstationtype": null, "operatingcompany": null, "subbasin": null, "bre": null, "safetyrequirements": null, "warrantydate": null, "projectid": null, "telemetryid": null, "assetlocation": "Public ROW", "address": null, "lifecyclestatuschangedate": null, "odorcontrol": null, "numberofpumps": null, "basin": null, "lasteditor": null, "activeflag": "Active", "system": null, "createeditor": null, "datasourcereference": null, "facilityidsecondary": null, "cof": null, "lastupdate": null, "operatingdivision": null } } } ], "supportsAdvancedQueries": true, "parentLayer": { "name": "Sewer", "id": 0 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": true, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "ssLiftStation", "allowTrueCurvesUpdates": false, "displayField": "facilityname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "OPERATINGCOMPANY", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingCompany", "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", "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_10", "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": "SystemName", "description": "Sewer System Name", "type": "codedValue", "codedValues": [ { "code": "Anthem", "name": "Anthem" }, { "code": "Arizona Gateway", "name": "Arizona Gateway" }, { "code": "Fort Mohave", "name": "Fort Mohave" }, { "code": "Luke 303", "name": "Luke 303" }, { "code": "NE AF", "name": "Northeast Agua Fria" }, { "code": "Russell Ranch", "name": "Russell Ranch" }, { "code": "Sun City", "name": "Sun City" }, { "code": "Sun City West", "name": "Sun City West" }, { "code": "Verrado", "name": "Verrado" }, { "code": "Rio Verde", "name": "Rio Verde" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "system", "length": 20, "alias": "System", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "InstallDate", "type": "esriFieldTypeDate" }, { "modelName": "WARRANTYDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "warrantydate", "length": 29, "alias": "Warranty Date", "type": "esriFieldTypeDate" }, { "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": "STRUCTUREID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structureid", "length": 25, "alias": "StructureID", "type": "esriFieldTypeString" }, { "modelName": "WASTEWATERTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ssWaterType_10", "description": "Sanitary sewer water type", "type": "codedValue", "codedValues": [ { "code": "Combined", "name": "Combined Wastewater" }, { "code": "IO Effluent", "name": "IO Effluent" }, { "code": "Raw", "name": "Raw Water" }, { "code": "Reclaimed", "name": "Reclaimed Water" }, { "code": "RO Effluent", "name": "RO Effluent" }, { "code": "Separate Sewer", "name": "Separate Sewer" }, { "code": "Storm", "name": "Storm Runoff" }, { "code": "Treated", "name": "Treated Water" }, { "code": "Wastewater", "name": "Wastewater" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "wastewatertype", "length": 50, "alias": "WasteWaterType", "type": "esriFieldTypeString" }, { "modelName": "BASIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "basin", "length": 50, "alias": "Basin", "type": "esriFieldTypeString" }, { "modelName": "SUBBASIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subbasin", "length": 50, "alias": "SubBasin", "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": "FACILITYNAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityname", "length": 50, "alias": "FacilityName", "type": "esriFieldTypeString" }, { "modelName": "FACILITYIDSECONDARY", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityidsecondary", "length": 20, "alias": "FacilityIDSecondary", "type": "esriFieldTypeString" }, { "modelName": "NUMBEROFPUMPS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numberofpumps", "alias": "NumberofPumps", "type": "esriFieldTypeInteger" }, { "modelName": "TELEMETRYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "telemetryid", "length": 25, "alias": "TelemetryID", "type": "esriFieldTypeString" }, { "modelName": "ODORCONTROL", "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": "odorcontrol", "length": 3, "alias": "OdorControl", "type": "esriFieldTypeString" }, { "modelName": "ADDRESS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 100, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "BUILDING", "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": "building", "length": 3, "alias": "Building", "type": "esriFieldTypeString" }, { "modelName": "ASSETLOCATION", "nullable": true, "editable": true, "defaultValue": "Public ROW", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetLocation", "description": "Location of feature", "type": "codedValue", "codedValues": [ { "code": "Private", "name": "Private" }, { "code": "Company", "name": "Company" }, { "code": "Easement", "name": "Easement" }, { "code": "Public ROW", "name": "Public ROW" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "assetlocation", "length": 50, "alias": "Asset Location", "type": "esriFieldTypeString" }, { "modelName": "LIFTSTATIONTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ssLSType", "description": "Lift Station Subtypes", "type": "codedValue", "codedValues": [ { "code": "Wet", "name": "Wet Well" }, { "code": "Dry", "name": "Dry Well" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "liftstationtype", "length": 4, "alias": "Lift Station Type", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LifeCycleStatus_73", "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": "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" } ], "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": "r4468_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a3993_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 2500, "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": "a3ea93a6456d471fbfb7937a40b932d4", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Uploads", "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, "supportsVCSProjection": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAdklEQVQ4jWNhoCJgoZVhUgwMDHZkmHGIgYHhGbphRgwMDMvJMMwXm2EUAxZsgo4MDAzqeDSdZ2BgOEmsYfFQjAt0kmIYuYBl1LBBGGY3GBgYDuLRdI8UwzqgmCouIxewILGPQ3MSqeAyNsPeMjAwHCDbWdT2JgDZ9g941es+dwAAAABJRU5ErkJggg==", "yoffset": 0, "width": 14, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "a29aa8628600b512206f1ff6b842c4a6", "height": 14 }, "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": 3869674.505599998, "xmin": -1.2428526741700001E7, "ymax": 3871360.9926000014, "xmax": -1.2426786513700001E7, "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": 2000, "isDataVersioned": false, "templates": [ { "name": "4\" PVC", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "exteriorcoating": "No", "operatingdistrict": null, "datasourcetype": null, "facilityid": null, "installdate": null, "pof": null, "planlink": null, "createdate": null, "enabled": 1, "lined": "No", "operatingcompany": null, "diameter": 4, "subbasin": null, "bre": null, "safetyrequirements": null, "abovegrade": "No", "warrantydate": null, "watertype": "Separate Sewer", "ownedby": 1, "projectid": null, "conditiondate": null, "lifecyclestatuschangedate": null, "measuredlength": null, "basin": null, "slope": null, "lasteditor": null, "activeflag": "Active", "lineddate": null, "condition": null, "depth": null, "system": null, "inmodel": null, "material": "PVC", "createeditor": null, "datasourcereference": null, "maintby": 1, "cof": null, "lastupdate": null, "operatingdivision": null } } }, { "name": "8\" PVC", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "exteriorcoating": "No", "operatingdistrict": null, "datasourcetype": null, "facilityid": null, "installdate": null, "pof": null, "planlink": null, "createdate": null, "enabled": 1, "lined": "No", "operatingcompany": null, "diameter": 8, "subbasin": null, "bre": null, "safetyrequirements": null, "abovegrade": "No", "warrantydate": null, "watertype": "Separate Sewer", "ownedby": 1, "projectid": null, "conditiondate": null, "lifecyclestatuschangedate": null, "measuredlength": null, "basin": null, "slope": null, "lasteditor": null, "activeflag": "Active", "lineddate": null, "condition": null, "depth": null, "system": null, "inmodel": null, "material": "PVC", "createeditor": null, "datasourcereference": null, "maintby": 1, "cof": null, "lastupdate": null, "operatingdivision": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": { "name": "Sewer", "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": "ssForceMain", "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": "Main 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": "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": "SLOPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "slope", "alias": "Slope", "type": "esriFieldTypeDouble" }, { "modelName": "EXTERIORCOATING", "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": "exteriorcoating", "length": 3, "alias": "Exterior Coating", "type": "esriFieldTypeString" }, { "modelName": "LINED", "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": "lined", "length": 3, "alias": "Lined", "type": "esriFieldTypeString" }, { "modelName": "LINEDDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lineddate", "length": 29, "alias": "Lined Date", "type": "esriFieldTypeDate" }, { "modelName": "WATERTYPE", "nullable": true, "editable": true, "defaultValue": "Separate Sewer", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ssWaterType_10", "description": "Sanitary sewer water type", "type": "codedValue", "codedValues": [ { "code": "Combined", "name": "Combined Wastewater" }, { "code": "IO Effluent", "name": "IO Effluent" }, { "code": "Raw", "name": "Raw Water" }, { "code": "Reclaimed", "name": "Reclaimed Water" }, { "code": "RO Effluent", "name": "RO Effluent" }, { "code": "Separate Sewer", "name": "Separate Sewer" }, { "code": "Storm", "name": "Storm Runoff" }, { "code": "Treated", "name": "Treated Water" }, { "code": "Wastewater", "name": "Wastewater" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "watertype", "length": 30, "alias": "Water Type", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LifeCycleStatus_73", "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_10", "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": "CONDITION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Condition_48", "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": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingCompany", "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", "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_10", "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": "SystemName", "description": "Sewer System Name", "type": "codedValue", "codedValues": [ { "code": "Anthem", "name": "Anthem" }, { "code": "Arizona Gateway", "name": "Arizona Gateway" }, { "code": "Fort Mohave", "name": "Fort Mohave" }, { "code": "Luke 303", "name": "Luke 303" }, { "code": "NE AF", "name": "Northeast Agua Fria" }, { "code": "Russell Ranch", "name": "Russell Ranch" }, { "code": "Sun City", "name": "Sun City" }, { "code": "Sun City West", "name": "Sun City West" }, { "code": "Verrado", "name": "Verrado" }, { "code": "Rio Verde", "name": "Rio Verde" } ], "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": "BASIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "basin", "length": 50, "alias": "Basin", "type": "esriFieldTypeString" }, { "modelName": "SUBBASIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subbasin", "length": 50, "alias": "SubBasin", "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": "MEASUREDLENGTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "measuredlength", "alias": "MeasuredLength", "type": "esriFieldTypeDouble" }, { "modelName": "ABOVEGRADE", "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": "abovegrade", "length": 3, "alias": "AboveGrade", "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": 3, "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": "planlink", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "planlink", "length": 255, "alias": "Planlink", "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": false, "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": "r4464_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a3989_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "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": "a3ea93a6456d471fbfb7937a40b932d4", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Uploads", "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": [ 230, 230, 0, 255 ], "width": 3, "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": 3869773.028999999, "xmin": -1.24752639461E7, "ymax": 4006900.9680999964, "xmax": -1.24255069754E7, "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": "WW_CleanOut", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "operatingdistrict": null, "datasourcetype": null, "facilityid": null, "serialnum": null, "installdate": null, "wastewatertype": "Separate Sewer", "pof": null, "createdate": null, "devicetype": "Cleanout", "enabled": 1, "quartersection": null, "accessmat": null, "operatingcompany": null, "subbasin": null, "bre": null, "safetyrequirements": null, "warrantydate": null, "gpsdate": null, "ownedby": 1, "projectid": null, "intdepth": null, "conditiondate": null, "accessdiam": null, "elevation": null, "accesstype": "Cover", "lifecyclestatuschangedate": null, "imagelink": null, "modelnum": null, "belowgrade": null, "facid": null, "basin": null, "lasteditor": null, "activeflag": "Active", "condition": null, "system": null, "createeditor": null, "datasourcereference": null, "maintby": 1, "cof": null, "lastupdate": null, "operatingdivision": null, "wye_type": null } } } ], "supportsAdvancedQueries": true, "parentLayer": { "name": "Sewer", "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": "WW_CleanOut", "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": "Cleanout 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": "ACCESSMAT", "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": "accessmat", "length": 20, "alias": "Access Material", "type": "esriFieldTypeString" }, { "modelName": "ACCESSTYPE", "nullable": true, "editable": true, "defaultValue": "Cover", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "piAccessType", "description": "List of infrastructure access types", "type": "codedValue", "codedValues": [ { "code": "Door", "name": "Door" }, { "code": "Grate", "name": "Grate" }, { "code": "Cover", "name": "Cover" }, { "code": "Hand", "name": "Hand" }, { "code": "Lid", "name": "Lid" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "accesstype", "length": 20, "alias": "Access Type", "type": "esriFieldTypeString" }, { "modelName": "ACCESSDIAM", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "piAccessDiameter", "description": "Valid range of infrastructure access diameters", "range": [ 0, 72 ], "type": "range", "mergePolicy": "esriMPTDefaultValue" }, "name": "accessdiam", "alias": "Access Diameter", "type": "esriFieldTypeDouble" }, { "modelName": "INTDEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "intdepth", "alias": "Interior Depth", "type": "esriFieldTypeDouble" }, { "modelName": "BELOWGRADE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "belowgrade", "length": 2, "alias": "Below Grade", "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": "DEVICETYPE", "nullable": true, "editable": true, "defaultValue": "Cleanout", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "piCleanoutTypes", "description": "List of infrastructure cleanout types", "type": "codedValue", "codedValues": [ { "code": "Cleanout", "name": "Cleanout" }, { "code": "Flushing Structure", "name": "Flushing Structure" }, { "code": "Lamp Hole", "name": "Lamp Hole" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "devicetype", "length": 30, "alias": "Cleanout Type", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LifeCycleStatus_73", "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_10", "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": "CONDITION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Condition_48", "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": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingCompany", "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", "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_10", "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": "QUARTERSECTION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "quartersection", "length": 20, "alias": "Quartersection", "type": "esriFieldTypeString" }, { "modelName": "SYSTEM", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SystemName", "description": "Sewer System Name", "type": "codedValue", "codedValues": [ { "code": "Anthem", "name": "Anthem" }, { "code": "Arizona Gateway", "name": "Arizona Gateway" }, { "code": "Fort Mohave", "name": "Fort Mohave" }, { "code": "Luke 303", "name": "Luke 303" }, { "code": "NE AF", "name": "Northeast Agua Fria" }, { "code": "Russell Ranch", "name": "Russell Ranch" }, { "code": "Sun City", "name": "Sun City" }, { "code": "Sun City West", "name": "Sun City West" }, { "code": "Verrado", "name": "Verrado" }, { "code": "Rio Verde", "name": "Rio Verde" } ], "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": "WASTEWATERTYPE", "nullable": true, "editable": true, "defaultValue": "Separate Sewer", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ssWaterType_10", "description": "Sanitary sewer water type", "type": "codedValue", "codedValues": [ { "code": "Combined", "name": "Combined Wastewater" }, { "code": "IO Effluent", "name": "IO Effluent" }, { "code": "Raw", "name": "Raw Water" }, { "code": "Reclaimed", "name": "Reclaimed Water" }, { "code": "RO Effluent", "name": "RO Effluent" }, { "code": "Separate Sewer", "name": "Separate Sewer" }, { "code": "Storm", "name": "Storm Runoff" }, { "code": "Treated", "name": "Treated Water" }, { "code": "Wastewater", "name": "Wastewater" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "wastewatertype", "length": 50, "alias": "WasteWaterType", "type": "esriFieldTypeString" }, { "modelName": "BASIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "basin", "length": 50, "alias": "Basin", "type": "esriFieldTypeString" }, { "modelName": "SUBBASIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subbasin", "length": 50, "alias": "SubBasin", "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": "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": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPSDATE", "type": "esriFieldTypeDate" }, { "modelName": "FacID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facid", "alias": "FacID", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Wye_Type", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "piCleanoutWye", "description": "Connection Type", "type": "codedValue", "codedValues": [ { "code": "0", "name": "Unknown" }, { "code": "1", "name": "One Way" }, { "code": "2", "name": "Two Way" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "wye_type", "length": 50, "alias": "Wye_Type", "type": "esriFieldTypeString" }, { "modelName": "imagelink", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "imagelink", "length": 255, "alias": "ImageLink", "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": "r4466_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a3991_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 3000, "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": "a3ea93a6456d471fbfb7937a40b932d4", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Uploads", "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/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABWUlEQVQ4jaWTPU7DQBCFv418gdA5JS2lKVNSWnSOOEE4Rpxr+ARRUjolLR1bQkmH3UEJ3aLnZBY7CT8ST3KzM/Pe/Dwn/BPJqccikAGZg0mA1MF2BH7laH4lmAXKAIt2C+8NfLSQ5szHWRdbrh3ltwRFoH715E9LaOqv98cSRDCtWRSBfOO4PCKYBUoV38XQEG8e6glcPZAp1zpJbGa17W+HRVK1YsP9NeQvLG4ClXaS7N8zzdxPnNbd7B2eKzBy7UW5aY6iVUegbSvQV7Zi4Xy+IzEB5aomjhAg1bb/CuWqJhI42OpU2rbNLEUpC4fjqTsHbSQYgVfb+ixRM4vkcImWF6COBCtHI5PozjqVoV9ouNh1WW0cfuCDtaOUSXRnnaq/VFNWcZrjN4548IET5TCZRHeWur69lc0TUh645ehfUCcyyTgjP8viz9RqZmv7RwLbidROxQ7xCXBAksv5takuAAAAAElFTkSuQmCC", "yoffset": 0, "width": 12, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "b91317527cf06941e0d2ce92e6a787ec", "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": 3869608.366899997, "xmin": -1.24288202922E7, "ymax": 3871558.635300003, "xmax": -1.2425503557500001E7, "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": "WW_Manhole", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "image": null, "yr_inst": null, "source": null, "type": null, "fm_basin": null, "ec_redev": null, "diameter": null, "gps_verified": null, "x": null, "asbuilt": null, "y": null, "z": null, "id_1": null, "descript": null, "abandoned": null, "cleanout": null, "yr_retire": null, "rim_elev": null } } } ], "supportsAdvancedQueries": true, "parentLayer": { "name": "Sewer", "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": "WW_Manhole", "allowTrueCurvesUpdates": false, "displayField": "id_1", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID_1", "domain": null, "name": "objectid", "alias": "OBJECTID_1" }, { "modelName": "ID_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "id_1", "length": 32, "alias": "ID_1", "type": "esriFieldTypeString" }, { "modelName": "DESCRIPT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "descript", "length": 60, "alias": "DESCRIPT", "type": "esriFieldTypeString" }, { "modelName": "TYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "type", "alias": "TYPE", "type": "esriFieldTypeDouble" }, { "modelName": "YR_INST", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "yr_inst", "alias": "YR_INST", "type": "esriFieldTypeDouble" }, { "modelName": "YR_RETIRE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "yr_retire", "alias": "YR_RETIRE", "type": "esriFieldTypeDouble" }, { "modelName": "FM_BASIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fm_basin", "alias": "FM_BASIN", "type": "esriFieldTypeDouble" }, { "modelName": "EC_REDEV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ec_redev", "alias": "EC_REDEV", "type": "esriFieldTypeDouble" }, { "modelName": "SOURCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source", "length": 50, "alias": "SOURCE", "type": "esriFieldTypeString" }, { "modelName": "ASBUILT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "asbuilt", "length": 50, "alias": "ASBUILT", "type": "esriFieldTypeString" }, { "modelName": "ABANDONED", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "abandoned", "alias": "ABANDONED", "type": "esriFieldTypeDouble" }, { "modelName": "CLEANOUT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cleanout", "alias": "CLEANOUT", "type": "esriFieldTypeDouble" }, { "modelName": "DIAMETER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "diameter", "alias": "DIAMETER", "type": "esriFieldTypeDouble" }, { "modelName": "RIM_ELEV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rim_elev", "alias": "RIM_ELEV", "type": "esriFieldTypeDouble" }, { "modelName": "X", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "x", "alias": "X", "type": "esriFieldTypeDouble" }, { "modelName": "Y", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "y", "alias": "Y", "type": "esriFieldTypeDouble" }, { "modelName": "Z", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "z", "alias": "Z", "type": "esriFieldTypeDouble" }, { "modelName": "IMAGE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "image", "length": 255, "alias": "IMAGE", "type": "esriFieldTypeString" }, { "modelName": "GPS_verified", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gps_verified", "length": 4, "alias": "GPS_verified", "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": "r4469_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a3994_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 3000, "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": "a3ea93a6456d471fbfb7937a40b932d4", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Uploads", "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": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACHUlEQVQ4ja2TsUsbYRjGnxi12mgVdbnUJhR0aClHwUUHF5cuFwLtJEiHUO4bMro51UXtH+BwIWTKYqEuujgIgjiZczihDi4mYDPEQiOtaY0x8nzJd0nMhYL4Lsd9992P93ne5+3GI1X3/y6YpvnZ5/PZlmVtPQgkhDDLk+fmbeFPsPLiQvv4dSbvzw/bvd9DCS9oC0gIEQGgXb/ORYrRb0YlfIH+7Sn5rWTYGgDDnx0zPo3M2ygERDKZtDt1pFWrVasUPQQhXtVVDKDr5+BU+W02E4vFnqdSqR9tIHZCyLOV97hc2myD9ThhDKy/w+/4Dsp6FoNr0QyAYAuInig5hBD2N2JjbmgBo8UJHKV3cb5/5UJYV/MHmjgTpmVZCRdEY1UHfBKyGEpB13V5ZsCAozv4gh23Q97jfwBqII6Y01HGstiJgqji+3Q6jkxuwz3z/euVP0kQc8IRu18BKcerXg6/Ao25XxLEXDAn9RHLoieUc7+Ofu2itOBOHbdPrvN8uh4xbNKK+nRoLD3Rm+Q5joPTcMMjefdk3AaOGyAmlmFjTtSIaex0Oi7lsBNCnqZncRMqSKP92TH+J1PugiiPiWXYmkecyW1IT5QcQlTO+vbecAcTLSBZhYBgYhXEqyr1nA2tfiB5GdiT5y0g7g5jz8QybF5rQjnshJDm5W3b/vruBJlYhk3lhNOhsfSkJqfWSUdQk2fULvU36rij5Dt6awuWbSRX4QAAAABJRU5ErkJggg==", "yoffset": 0, "width": 13, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "d940cbdda5ec53fd48da7a0e358b514a", "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": 3869603.578599997, "xmin": -1.2428832286899999E7, "ymax": 3871573.158200003, "xmax": -1.2425496744199999E7, "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": 2000, "isDataVersioned": false, "templates": [ { "name": "4\" Lateral", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "operatingdistrict": null, "datasourcetype": null, "facilityid": null, "installdate": null, "distance": null, "pof": null, "createdate": null, "enabled": 1, "operatingcompany": null, "diameter": 4, "subbasin": null, "bre": null, "safetyrequirements": null, "warrantydate": null, "watertype": "Separate Sewer", "ownedby": 1, "projectid": null, "assetlocation": "Public ROW", "lifecyclestatuschangedate": null, "measuredlength": null, "basin": null, "lateraltype": null, "lasteditor": null, "activeflag": "Active", "depth": null, "system": null, "material": "PVC", "createeditor": null, "datasourcereference": null, "location": null, "maintby": 1, "cof": null, "lastupdate": null, "operatingdivision": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": { "name": "Sewer", "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": "ssLateral", "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": "Lateral Line 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": null, "name": "lateraltype", "length": 20, "alias": "Lateral Type", "type": "esriFieldTypeString" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 50, "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": "DEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "depth", "alias": "Depth", "type": "esriFieldTypeDouble" }, { "modelName": "DISTANCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "distance", "alias": "Distance", "type": "esriFieldTypeInteger" }, { "modelName": "WATERTYPE", "nullable": true, "editable": true, "defaultValue": "Separate Sewer", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ssWaterType_10", "description": "Sanitary sewer water type", "type": "codedValue", "codedValues": [ { "code": "Combined", "name": "Combined Wastewater" }, { "code": "IO Effluent", "name": "IO Effluent" }, { "code": "Raw", "name": "Raw Water" }, { "code": "Reclaimed", "name": "Reclaimed Water" }, { "code": "RO Effluent", "name": "RO Effluent" }, { "code": "Separate Sewer", "name": "Separate Sewer" }, { "code": "Storm", "name": "Storm Runoff" }, { "code": "Treated", "name": "Treated Water" }, { "code": "Wastewater", "name": "Wastewater" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "watertype", "length": 30, "alias": "Water Type", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LifeCycleStatus_73", "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_10", "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": "ASSETLOCATION", "nullable": true, "editable": true, "defaultValue": "Public ROW", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AssetLocation", "description": "Location of feature", "type": "codedValue", "codedValues": [ { "code": "Private", "name": "Private" }, { "code": "Company", "name": "Company" }, { "code": "Easement", "name": "Easement" }, { "code": "Public ROW", "name": "Public ROW" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "assetlocation", "length": 15, "alias": "Asset Location", "type": "esriFieldTypeString" }, { "modelName": "OPERATINGCOMPANY", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OperatingCompany", "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", "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_10", "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": "SystemName", "description": "Sewer System Name", "type": "codedValue", "codedValues": [ { "code": "Anthem", "name": "Anthem" }, { "code": "Arizona Gateway", "name": "Arizona Gateway" }, { "code": "Fort Mohave", "name": "Fort Mohave" }, { "code": "Luke 303", "name": "Luke 303" }, { "code": "NE AF", "name": "Northeast Agua Fria" }, { "code": "Russell Ranch", "name": "Russell Ranch" }, { "code": "Sun City", "name": "Sun City" }, { "code": "Sun City West", "name": "Sun City West" }, { "code": "Verrado", "name": "Verrado" }, { "code": "Rio Verde", "name": "Rio Verde" } ], "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": "BASIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "basin", "length": 50, "alias": "Basin", "type": "esriFieldTypeString" }, { "modelName": "SUBBASIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subbasin", "length": 50, "alias": "SubBasin", "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": "MEASUREDLENGTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "measuredlength", "alias": "MeasuredLength", "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" }, { "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": "r4463_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a3988_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "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": "a3ea93a6456d471fbfb7937a40b932d4", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Uploads", "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": [ 76, 230, 0, 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": 3869756.8716999963, "xmin": -1.2428832286899999E7, "ymax": 3871573.158200003, "xmax": -1.2425496744199999E7, "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": 6, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "WW_Lateral", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "elevation": null, "color": null, "linetype": null, "objectid_1": null, "shape_leng": null, "layer": null, "refname": null, "enabled": null, "fid_": null, "shape_le_1": null, "linewt": null, "checked": null, "ufid": null, "category": null, "entity": null, "objectid": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": { "name": "Sewer", "id": 0 }, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid_12", "supportsQuantizationEditMode": true, "name": "WW_Lateral", "allowTrueCurvesUpdates": false, "displayField": "refname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID_12", "domain": null, "name": "objectid_12", "alias": "OBJECTID_12" }, { "modelName": "OBJECTID_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "objectid_1", "alias": "OBJECTID_1", "type": "esriFieldTypeDouble" }, { "modelName": "OBJECTID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeDouble" }, { "modelName": "FID_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fid_", "alias": "FID_", "type": "esriFieldTypeDouble" }, { "modelName": "entity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "length": 1, "name": "entity", "alias": "entity", "type": "esriFieldTypeString" }, { "modelName": "Layer", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "layer", "length": 1, "alias": "Layer", "type": "esriFieldTypeString" }, { "modelName": "Color", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "color", "alias": "Color", "type": "esriFieldTypeDouble" }, { "modelName": "Linetype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "linetype", "length": 1, "alias": "Linetype", "type": "esriFieldTypeString" }, { "modelName": "Elevation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevation", "alias": "Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "LineWt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "linewt", "alias": "LineWt", "type": "esriFieldTypeDouble" }, { "modelName": "RefName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "refname", "length": 1, "alias": "RefName", "type": "esriFieldTypeString" }, { "modelName": "Enabled", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeDouble" }, { "modelName": "Shape_Leng", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape_leng", "alias": "Shape_Leng", "type": "esriFieldTypeDouble" }, { "modelName": "Category", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "category", "alias": "Category", "type": "esriFieldTypeDouble" }, { "modelName": "ufid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ufid", "length": 36, "alias": "ufid", "type": "esriFieldTypeString" }, { "modelName": "Shape_Le_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape_le_1", "alias": "Shape_Le_1", "type": "esriFieldTypeDouble" }, { "modelName": "CHECKED", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "checked", "length": 5, "alias": "CHECKED", "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": false, "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": "r4465_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid_12", "isAscending": true }, { "name": "a3990_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 3000, "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": "a3ea93a6456d471fbfb7937a40b932d4", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Uploads", "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, 0, 0, 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": 3869608.366899997, "xmin": -1.24288202922E7, "ymax": 3871558.635300003, "xmax": -1.2425503557500001E7, "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": 2000, "isDataVersioned": false, "templates": [ { "name": "WW_Gravity_Main", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "slip_lined": null, "to_": null, "from_": null, "from_inv": null, "length": null, "yr_inst": null, "objectid_1": null, "type": null, "shape_leng": null, "nassco_score": null, "material": null, "diameter": null, "to_inv": null, "globalold": null, "ab_length": null, "id_1": null, "descript": null, "cleanout": null, "yr_retire": null, "coeff": null, "f_status": null } } }, { "name": "8\" PVC", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "slip_lined": null, "to_": null, "from_": null, "from_inv": null, "length": null, "yr_inst": null, "objectid_1": null, "type": null, "shape_leng": null, "nassco_score": null, "material": "PVC", "diameter": 8, "to_inv": null, "globalold": null, "ab_length": null, "id_1": null, "descript": null, "cleanout": null, "yr_retire": null, "f_status": null, "coeff": null } } }, { "name": "12\" PVC", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "slip_lined": null, "to_": null, "from_": null, "from_inv": null, "length": null, "yr_inst": null, "objectid_1": null, "type": null, "shape_leng": null, "nassco_score": null, "material": "PVC", "diameter": 12, "to_inv": null, "globalold": null, "ab_length": null, "id_1": null, "descript": null, "cleanout": null, "yr_retire": null, "f_status": null, "coeff": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": { "name": "Sewer", "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": "WW_Gravity_Main", "allowTrueCurvesUpdates": false, "displayField": "id_1", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID_1", "domain": null, "name": "objectid", "alias": "OBJECTID_1" }, { "modelName": "OBJECTID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "objectid_1", "alias": "OBJECTID", "type": "esriFieldTypeDouble" }, { "modelName": "ID_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "id_1", "length": 32, "alias": "ID_1", "type": "esriFieldTypeString" }, { "modelName": "DESCRIPT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "descript", "length": 60, "alias": "DESCRIPT", "type": "esriFieldTypeString" }, { "modelName": "TYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "type", "alias": "TYPE", "type": "esriFieldTypeDouble" }, { "modelName": "YR_INST", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "yr_inst", "alias": "YR_INST", "type": "esriFieldTypeDouble" }, { "modelName": "YR_RETIRE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "yr_retire", "alias": "YR_RETIRE", "type": "esriFieldTypeDouble" }, { "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": 32, "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": "CLEANOUT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cleanout", "alias": "CLEANOUT", "type": "esriFieldTypeDouble" }, { "modelName": "FROM_INV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "from_inv", "alias": "FROM_INV", "type": "esriFieldTypeDouble" }, { "modelName": "TO_INV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "to_inv", "alias": "TO_INV", "type": "esriFieldTypeDouble" }, { "modelName": "LENGTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "length", "alias": "LENGTH", "type": "esriFieldTypeDouble" }, { "modelName": "AB_LENGTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ab_length", "alias": "AB_LENGTH", "type": "esriFieldTypeDouble" }, { "modelName": "COEFF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "coeff", "alias": "COEFF", "type": "esriFieldTypeDouble" }, { "modelName": "FROM_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "from_", "length": 32, "alias": "FROM_", "type": "esriFieldTypeString" }, { "modelName": "Slip_Lined", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "slip_lined", "length": 5, "alias": "Slip_Lined", "type": "esriFieldTypeString" }, { "modelName": "Shape_Leng", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape_leng", "alias": "Shape_Leng", "type": "esriFieldTypeDouble" }, { "modelName": "NASSCO_Score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nassco_score", "alias": "NASSCO_Score", "type": "esriFieldTypeSmallInteger" }, { "modelName": "TO", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "to_", "length": 32, "alias": "TO", "type": "esriFieldTypeString" }, { "modelName": "_STATUS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "f_status", "alias": "_STATUS", "type": "esriFieldTypeDouble" }, { "modelName": "GlobalOld", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "globalold", "length": 38, "alias": "GlobalOld", "type": "esriFieldTypeGUID" }, { "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": false, "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": "r4467_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a3992_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "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": "a3ea93a6456d471fbfb7937a40b932d4", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Uploads", "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": [ 85, 255, 0, 255 ], "width": 7, "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 } ] }