{ "tables": [], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 5105419.710469641, "xmin": -9846915.6576265, "ymax": 5115331.723718569, "xmax": -9839559.760124642, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.4.0", "isDataArchived": false, "id": 0, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "B_Box_Points", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "date": null, "bargraph": null, "gpsmode": null, "locateview": null, "tiltmerged": null, "utilitytyp": null, "roll": null, "battery": null, "current_": null, "sattelites": null, "community_status": null, "frequency": null, "gain": null, "community_id": null, "fix": null, "accumulate": null, "offset_": null, "refstation": null, "sdlon": null, "pitch": null, "automode": null, "direction": null, "pdop": null, "comments": null, "geoidsepar": null, "hdop": null, "sdlat": null, "gpsvalid": null, "sdaltitude": null, "locateerr": null, "depth": null, "altitudems": null, "compass": null, "lognumber": null, "incrementa": null, "vdop": null, "survey": null, "agediff": null, "bargraphmo": null, "time": null, "gpstime": null, "f2drms": null, "fixdimensi": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "B_Box_Points", "allowTrueCurvesUpdates": false, "displayField": "survey", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "lognumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lognumber", "alias": "LogNumber", "type": "esriFieldTypeInteger" }, { "modelName": "survey", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "survey", "length": 100, "alias": "Survey", "type": "esriFieldTypeString" }, { "modelName": "date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "date", "length": 10, "alias": "Date", "type": "esriFieldTypeString" }, { "modelName": "time", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time", "length": 8, "alias": "Time", "type": "esriFieldTypeString" }, { "modelName": "utilitytyp", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "UtilityTyp", "description": "UtilityTyp", "type": "codedValue", "codedValues": [ { "code": "Potable water", "name": "Portable water" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "utilitytyp", "length": 100, "alias": "UtilityTyp", "type": "esriFieldTypeString" }, { "modelName": "incrementa", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "incrementa", "alias": "Incrementa", "type": "esriFieldTypeDouble" }, { "modelName": "accumulate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accumulate", "alias": "Accumulate", "type": "esriFieldTypeDouble" }, { "modelName": "current_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "current_", "alias": "Current", "type": "esriFieldTypeDouble" }, { "modelName": "direction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "direction", "length": 100, "alias": "Direction", "type": "esriFieldTypeString" }, { "modelName": "depth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "depth", "alias": "Depth", "type": "esriFieldTypeDouble" }, { "modelName": "frequency", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "frequency", "alias": "Frequency", "type": "esriFieldTypeInteger" }, { "modelName": "locateview", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "locateview", "length": 100, "alias": "LocateView", "type": "esriFieldTypeString" }, { "modelName": "bargraphmo", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bargraphmo", "length": 100, "alias": "BargraphMo", "type": "esriFieldTypeString" }, { "modelName": "gain", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gain", "alias": "Gain", "type": "esriFieldTypeDouble" }, { "modelName": "bargraph", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bargraph", "alias": "Bargraph", "type": "esriFieldTypeDouble" }, { "modelName": "battery", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "battery", "alias": "Battery", "type": "esriFieldTypeDouble" }, { "modelName": "offset_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "offset_", "alias": "Offset", "type": "esriFieldTypeDouble" }, { "modelName": "locateerr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "locateerr", "alias": "LocateErr", "type": "esriFieldTypeDouble" }, { "modelName": "pitch", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pitch", "alias": "Pitch", "type": "esriFieldTypeDouble" }, { "modelName": "roll", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "roll", "alias": "Roll", "type": "esriFieldTypeDouble" }, { "modelName": "compass", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "compass", "alias": "Compass", "type": "esriFieldTypeDouble" }, { "modelName": "gpsvalid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsvalid", "length": 10, "alias": "GPSValid", "type": "esriFieldTypeString" }, { "modelName": "gpstime", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpstime", "length": 19, "alias": "GPSTime", "type": "esriFieldTypeString" }, { "modelName": "fix", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fix", "length": 100, "alias": "Fix", "type": "esriFieldTypeString" }, { "modelName": "sattelites", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sattelites", "alias": "Sattelites", "type": "esriFieldTypeInteger" }, { "modelName": "pdop", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pdop", "alias": "PDOP", "type": "esriFieldTypeDouble" }, { "modelName": "hdop", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hdop", "alias": "HDOP", "type": "esriFieldTypeDouble" }, { "modelName": "vdop", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "vdop", "alias": "VDOP", "type": "esriFieldTypeDouble" }, { "modelName": "altitudems", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "altitudems", "alias": "AltitudeMs", "type": "esriFieldTypeDouble" }, { "modelName": "geoidsepar", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "geoidsepar", "alias": "GeoidSepar", "type": "esriFieldTypeDouble" }, { "modelName": "automode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "automode", "length": 10, "alias": "AutoMode", "type": "esriFieldTypeString" }, { "modelName": "gpsmode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpsmode", "length": 100, "alias": "GPSMode", "type": "esriFieldTypeString" }, { "modelName": "fixdimensi", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fixdimensi", "length": 100, "alias": "FixDimensi", "type": "esriFieldTypeString" }, { "modelName": "agediff", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "agediff", "alias": "AgeDiff", "type": "esriFieldTypeInteger" }, { "modelName": "refstation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "refstation", "alias": "RefStation", "type": "esriFieldTypeInteger" }, { "modelName": "sdlat", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sdlat", "alias": "sdLat", "type": "esriFieldTypeDouble" }, { "modelName": "sdlon", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sdlon", "alias": "sdLon", "type": "esriFieldTypeDouble" }, { "modelName": "f2drms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "f2drms", "alias": "F2DRMS", "type": "esriFieldTypeDouble" }, { "modelName": "sdaltitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sdaltitude", "alias": "sdAltitude", "type": "esriFieldTypeDouble" }, { "modelName": "comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 200, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "tiltmerged", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tiltmerged", "length": 30, "alias": "TiltMerged", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "community_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "community_id", "length": 50, "alias": "Community_ID", "type": "esriFieldTypeString" }, { "modelName": "community_status", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Status_11", "description": "Network Status", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Unknown", "name": "Unknown" }, { "code": "Proposed", "name": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "community_status", "length": 255, "alias": "Community_Status", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "B_Box_Points", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "i12579community_", "isUnique": false, "description": "", "fields": "community_status", "isAscending": true }, { "name": "r4318_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_4318", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a3465_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 144448, "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": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "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": "353659e2cc2041b8a121168afe09be85", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 116, 142, 71, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 5102555.794052362, "xmin": -9850514.824241417, "ymax": 5118164.556820191, "xmax": -9839565.293734055, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.4.0", "isDataArchived": false, "id": 1, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Hydrants", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "elevation": null, "created_fr": null, "pressure_z": null, "notes": null, "adjusted": null, "fireflow": null, "accepted": null, "gps": null, "project_na": null, "benchmark": null, "community_status": null, "manufacturer": null, "community_id": null, "w_hydrant_": null, "install_year": null, "atlas_id": null, "project_id": null, "hydrant_ye": null, "date_edite": null, "ownership_": "COY", "edited_by": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid_1", "supportsQuantizationEditMode": true, "name": "Hydrants", "allowTrueCurvesUpdates": false, "displayField": "w_hydrant_", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid_1", "domain": null, "name": "objectid_1", "alias": "OBJECTID_1" }, { "modelName": "w_hydrant_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "w_hydrant_", "length": 15, "alias": "W_Hydrant_", "type": "esriFieldTypeString" }, { "modelName": "atlas_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "atlas_id", "length": 15, "alias": "Atlas_Id", "type": "esriFieldTypeString" }, { "modelName": "elevation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevation", "alias": "Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "pressure_z", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressure_z", "length": 100, "alias": "Pressure_Z", "type": "esriFieldTypeString" }, { "modelName": "benchmark", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "benchmark", "length": 200, "alias": "Benchmark", "type": "esriFieldTypeString" }, { "modelName": "fireflow", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fireflow", "length": 100, "alias": "Fireflow", "type": "esriFieldTypeString" }, { "modelName": "gps", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gps", "alias": "GPS", "type": "esriFieldTypeSmallInteger" }, { "modelName": "project_na", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_na", "length": 100, "alias": "Project_Na", "type": "esriFieldTypeString" }, { "modelName": "project_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_id", "length": 20, "alias": "Project_Id", "type": "esriFieldTypeString" }, { "modelName": "created_fr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_fr", "length": 100, "alias": "Created_Fr", "type": "esriFieldTypeString" }, { "modelName": "edited_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "edited_by", "length": 5, "alias": "Edited_By", "type": "esriFieldTypeString" }, { "modelName": "date_edite", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "date_edite", "length": 29, "alias": "Date_Edite", "type": "esriFieldTypeDate" }, { "modelName": "notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 254, "alias": "Notes", "type": "esriFieldTypeString" }, { "modelName": "adjusted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "adjusted", "length": 5, "alias": "Adjusted", "type": "esriFieldTypeString" }, { "modelName": "hydrant_ye", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hydrant_ye", "length": 4, "alias": "Hydrant_Ye", "type": "esriFieldTypeString" }, { "modelName": "accepted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accepted", "length": 50, "alias": "Accepted", "type": "esriFieldTypeString" }, { "modelName": "manufacturer", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "HYDMFG", "description": "Hydrant Manufacture", "type": "codedValue", "codedValues": [ { "code": "Clow", "name": "Clow" }, { "code": "East Jordan", "name": "East Jordan" }, { "code": "Eddy ", "name": "Eddy" }, { "code": "Ludlow", "name": "Ludlow" }, { "code": "Mueller", "name": "Mueller" }, { "code": "US Pipe", "name": "US. Pipe" }, { "code": "Waterous", "name": "Waterous" }, { "code": "Traverse City ", "name": "Tranverse City" }, { "code": "Kennedy", "name": "Kennedy" }, { "code": "Amercian Flow Control", "name": "American Flow Control" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "manufacturer", "length": 255, "alias": "Manufacturer", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "ownership_", "nullable": true, "editable": true, "defaultValue": "COY", "domain": null, "name": "ownership_", "length": 50, "alias": "Ownership_", "type": "esriFieldTypeString" }, { "modelName": "community_status", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Status_11", "description": "Network Status", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Unknown", "name": "Unknown" }, { "code": "Proposed", "name": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "community_status", "length": 50, "alias": "Community_Status", "type": "esriFieldTypeString" }, { "modelName": "community_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "community_id", "length": 50, "alias": "Community_ID", "type": "esriFieldTypeString" }, { "modelName": "install_year", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Year Installed", "description": "Year Installed", "type": "codedValue", "codedValues": [ { "code": 2000, "name": "2000" }, { "code": 2001, "name": "2001" }, { "code": 2002, "name": "2002" }, { "code": 2003, "name": "2003" }, { "code": 2004, "name": "2004" }, { "code": 2005, "name": "2005" }, { "code": 2006, "name": "2006" }, { "code": 2007, "name": "2007" }, { "code": 2008, "name": "2008" }, { "code": 2009, "name": "2009" }, { "code": 2010, "name": "2010" }, { "code": 2011, "name": "2011" }, { "code": 2012, "name": "2012" }, { "code": 2013, "name": "2013" }, { "code": 2014, "name": "2014" }, { "code": 2015, "name": "2015" }, { "code": 2016, "name": "2016" }, { "code": 2017, "name": "2017" }, { "code": 2018, "name": "2018" }, { "code": 2019, "name": "2019" }, { "code": 2020, "name": "2020" }, { "code": 2021, "name": "2021" }, { "code": 2022, "name": "2022" }, { "code": 2023, "name": "2023" }, { "code": 2024, "name": "2024" }, { "code": 2025, "name": "2025" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "install_year", "alias": "Install_Year", "type": "esriFieldTypeSmallInteger" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "Hydrants", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g12580community_", "isUnique": false, "description": "", "fields": "community_id", "isAscending": true }, { "name": "i12580community_", "isUnique": false, "description": "", "fields": "community_status", "isAscending": true }, { "name": "r4319_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid_1", "isAscending": true }, { "name": "uuid_4319", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a3466_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 288896, "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": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "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": "353659e2cc2041b8a121168afe09be85", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 142, 65, 133, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 5103609.290955089, "xmin": -9850444.320569858, "ymax": 5117653.258569039, "xmax": -9840143.710792718, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.4.0", "isDataArchived": false, "id": 2, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Water_Main_Facilities", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "created_fr": null, "pressure_z": null, "notes": null, "address": null, "typ": null, "gps": null, "type": null, "project_na": null, "project_id": null, "name": null, "date_edite": null, "objectid": null, "edited_by": null, "year_insta": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid_1", "supportsQuantizationEditMode": true, "name": "Water_Main_Facilities", "allowTrueCurvesUpdates": false, "displayField": "name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid_1", "domain": null, "name": "objectid_1", "alias": "OBJECTID_1" }, { "modelName": "objectid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeInteger" }, { "modelName": "type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "type", "alias": "Type", "type": "esriFieldTypeSmallInteger" }, { "modelName": "name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name", "length": 150, "alias": "Name", "type": "esriFieldTypeString" }, { "modelName": "address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 150, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "pressure_z", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressure_z", "length": 100, "alias": "Pressure_Z", "type": "esriFieldTypeString" }, { "modelName": "gps", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gps", "alias": "GPS", "type": "esriFieldTypeSmallInteger" }, { "modelName": "project_na", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_na", "length": 100, "alias": "Project_Na", "type": "esriFieldTypeString" }, { "modelName": "project_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_id", "length": 20, "alias": "Project_Id", "type": "esriFieldTypeString" }, { "modelName": "year_insta", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_insta", "length": 10, "alias": "Year_Insta", "type": "esriFieldTypeString" }, { "modelName": "created_fr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_fr", "length": 100, "alias": "Created_Fr", "type": "esriFieldTypeString" }, { "modelName": "date_edite", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "date_edite", "length": 29, "alias": "Date_Edite", "type": "esriFieldTypeDate" }, { "modelName": "edited_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "edited_by", "length": 5, "alias": "Edited_By", "type": "esriFieldTypeString" }, { "modelName": "notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 50, "alias": "Notes", "type": "esriFieldTypeString" }, { "modelName": "typ", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "typ", "length": 255, "alias": "Typ", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "Water_Main_Facilities", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r4320_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid_1", "isAscending": true }, { "name": "uuid_4320", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a3467_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, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "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": "353659e2cc2041b8a121168afe09be85", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 145, 58, 36, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 5102501.06669192, "xmin": -9850512.729889525, "ymax": 5118157.274083555, "xmax": -9839512.640073648, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.4.0", "isDataArchived": false, "id": 3, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Water_Main_Valves", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "created_fr": null, "pressure_z": null, "notes": null, "valve_type_name": null, "year_install": null, "adjusted": null, "valve_diam": null, "gps": null, "maindiameter": null, "project_na": null, "community_status": "Active", "community_id": null, "atlas_id": null, "material": null, "project_id": null, "w_valve_id": null, "ownership_": "COY", "date_edite": null, "edited_by": null, "rim_elev": null, "service_ad": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid_1", "supportsQuantizationEditMode": true, "name": "Water_Main_Valves", "allowTrueCurvesUpdates": false, "displayField": "valve_type_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid_1", "domain": null, "name": "objectid_1", "alias": "OBJECTID_1" }, { "modelName": "w_valve_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "w_valve_id", "length": 15, "alias": "W_Valve_Id", "type": "esriFieldTypeString" }, { "modelName": "atlas_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "atlas_id", "length": 15, "alias": "Atlas_Id", "type": "esriFieldTypeString" }, { "modelName": "maindiameter", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Size", "description": "Size", "type": "codedValue", "codedValues": [ { "code": "1\"", "name": "1\"" }, { "code": "2\"", "name": "2\"" }, { "code": "4\"", "name": "4\"" }, { "code": "6\"", "name": "6\"" }, { "code": "8\"", "name": "8\"" }, { "code": "10\"", "name": "10\"" }, { "code": "12\"", "name": "12\"" }, { "code": "16\"", "name": "16\"" }, { "code": "18\"", "name": "18\"" }, { "code": "20\"", "name": "20\"" }, { "code": "24\"", "name": "24\"" }, { "code": "36\"", "name": "36\"" }, { "code": "42\"", "name": "42\"" }, { "code": "60\"", "name": "60\"" }, { "code": "72\"", "name": "72\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maindiameter", "length": 15, "alias": "Diameter", "type": "esriFieldTypeString" }, { "modelName": "material", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Vault Material", "description": "Vault Material", "type": "codedValue", "codedValues": [ { "code": "Block", "name": "Block" }, { "code": "Brick", "name": "Brick" }, { "code": "Concrete", "name": "Concrete" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "material", "length": 25, "alias": "Material", "type": "esriFieldTypeString" }, { "modelName": "rim_elev", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rim_elev", "alias": "Rim_Elev", "type": "esriFieldTypeDouble" }, { "modelName": "pressure_z", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressure_z", "length": 100, "alias": "Pressure_Z", "type": "esriFieldTypeString" }, { "modelName": "gps", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gps", "alias": "GPS", "type": "esriFieldTypeSmallInteger" }, { "modelName": "project_na", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_na", "length": 100, "alias": "Project_Na", "type": "esriFieldTypeString" }, { "modelName": "project_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_id", "length": 20, "alias": "Project_Id", "type": "esriFieldTypeString" }, { "modelName": "created_fr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_fr", "length": 100, "alias": "Created_Fr", "type": "esriFieldTypeString" }, { "modelName": "edited_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "edited_by", "length": 5, "alias": "Edited_By", "type": "esriFieldTypeString" }, { "modelName": "date_edite", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "date_edite", "length": 29, "alias": "Date_Edite", "type": "esriFieldTypeDate" }, { "modelName": "notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 254, "alias": "Notes", "type": "esriFieldTypeString" }, { "modelName": "adjusted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "adjusted", "length": 5, "alias": "Adjusted", "type": "esriFieldTypeString" }, { "modelName": "service_ad", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "service_ad", "length": 150, "alias": "Service_Ad", "type": "esriFieldTypeString" }, { "modelName": "valve_diam", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Vault Diameter", "description": "Vault Diameter", "type": "codedValue", "codedValues": [ { "code": "48\"", "name": "48\"" }, { "code": "60\"", "name": "60\"" }, { "code": "36\"", "name": "36\"" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "valve_diam", "length": 15, "alias": "Valve_Diam", "type": "esriFieldTypeString" }, { "modelName": "valve_type_name", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Valve Type", "description": "Water Main Valve Type", "type": "codedValue", "codedValues": [ { "code": "Box", "name": "Valve Box" }, { "code": "Vault", "name": "Valve Vault" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "valve_type_name", "length": 50, "alias": "Valve Type Name", "type": "esriFieldTypeString" }, { "modelName": "community_status", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Status_11", "description": "Network Status", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Unknown", "name": "Unknown" }, { "code": "Proposed", "name": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "community_status", "length": 255, "alias": "Community_Status", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "ownership_", "nullable": true, "editable": true, "defaultValue": "COY", "domain": null, "name": "ownership_", "length": 50, "alias": "Ownership_", "type": "esriFieldTypeString" }, { "modelName": "year_install", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Year Installed", "description": "Year Installed", "type": "codedValue", "codedValues": [ { "code": 2000, "name": "2000" }, { "code": 2001, "name": "2001" }, { "code": 2002, "name": "2002" }, { "code": 2003, "name": "2003" }, { "code": 2004, "name": "2004" }, { "code": 2005, "name": "2005" }, { "code": 2006, "name": "2006" }, { "code": 2007, "name": "2007" }, { "code": 2008, "name": "2008" }, { "code": 2009, "name": "2009" }, { "code": 2010, "name": "2010" }, { "code": 2011, "name": "2011" }, { "code": 2012, "name": "2012" }, { "code": 2013, "name": "2013" }, { "code": 2014, "name": "2014" }, { "code": 2015, "name": "2015" }, { "code": 2016, "name": "2016" }, { "code": 2017, "name": "2017" }, { "code": 2018, "name": "2018" }, { "code": 2019, "name": "2019" }, { "code": 2020, "name": "2020" }, { "code": 2021, "name": "2021" }, { "code": 2022, "name": "2022" }, { "code": 2023, "name": "2023" }, { "code": 2024, "name": "2024" }, { "code": 2025, "name": "2025" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "year_install", "alias": "Year_Install", "type": "esriFieldTypeSmallInteger" }, { "modelName": "community_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "community_id", "length": 25, "alias": "Community_ID", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "Water_Main_Valves", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "i12582community_", "isUnique": false, "description": "", "fields": "community_status", "isAscending": true }, { "name": "r4321_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid_1", "isAscending": true }, { "name": "uuid_4321", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a3468_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 288896, "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": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "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": "353659e2cc2041b8a121168afe09be85", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 68, 163, 161, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 5105293.346555546, "xmin": -9850514.776128909, "ymax": 5115356.162682474, "xmax": -9839561.636753986, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.4.0", "isDataArchived": false, "id": 4, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "WaterFitting_Point", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "esrignss_avg_h_rms": null, "enclosuremeasurement1": null, "installdate": null, "dateabandoned": null, "description": null, "esrignss_avg_v_rms": null, "maintaineddescription": null, "enclosuremeasurement2": null, "fieldverificationnotes": null, "lifecyclestatus": "Active", "manufacturer": "UNK", "esrignss_longitude": null, "esrignss_latitude": null, "enclosureframematerial": "UNK", "enclosurerimelevation": null, "esrignss_altitude": null, "subtype": 0, "angle": null, "qanotes": null, "watertype": "POTABLE", "diameter1": null, "maintained": "COY", "diameter2": null, "enclosureinstalldate": null, "diameter3": null, "esrignss_fixtype": null, "diameter4": null, "elevation": null, "enclosuretype": 0, "enclosurecovertype": "UNK", "esrignss_v_rms": null, "fieldverificationstatus": null, "enclosurecovermaterial": "UNK", "qastatus": null, "enclosureframetype": null, "locationdescription": null, "jointtype": null, "depth": null, "ownershipdescription": null, "material": "Unknown", "ownership": "COY", "enclosureinvertelevation": null, "communityid": null, "featureid": null, "esrignss_h_rms": null, "enclosuredescription": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "WaterFitting_Point", "allowTrueCurvesUpdates": false, "displayField": "featureid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "featureid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "featureid", "length": 15, "alias": "FEATUREID", "type": "esriFieldTypeString" }, { "modelName": "installdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "InstallDate", "type": "esriFieldTypeDate" }, { "modelName": "locationdescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "locationdescription", "length": 200, "alias": "LocationDescription", "type": "esriFieldTypeString" }, { "modelName": "lifecyclestatus", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Status_11", "description": "Network Status", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Unknown", "name": "Unknown" }, { "code": "Proposed", "name": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lifecyclestatus", "length": 20, "alias": "LifecycleStatus", "type": "esriFieldTypeString" }, { "modelName": "subtype", "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "subtype", "alias": "Subtype", "type": "esriFieldTypeInteger" }, { "modelName": "elevation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevation", "alias": "Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "watertype", "nullable": true, "editable": true, "defaultValue": "POTABLE", "domain": null, "name": "watertype", "length": 255, "alias": "WaterType", "type": "esriFieldTypeString" }, { "modelName": "jointtype", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Joint Type", "description": "Joint Type", "type": "codedValue", "codedValues": [ { "code": "Tee 8x8", "name": "Tee 8x8" }, { "code": "Tee 8x10", "name": "Tee 8x10" }, { "code": "Tee 8x12", "name": "Tee 8x12" }, { "code": "Tee 8x16", "name": "Tee 8x16" }, { "code": "Bend 45", "name": "Bend 45 Degrees" }, { "code": "Bend 22.5", "name": "Bend 22.5" }, { "code": "Bend 11.5", "name": "Bend 11.5 Degrees" }, { "code": "Reducer", "name": "Reducer" }, { "code": "Cap", "name": "Cap" }, { "code": "Tee 8x6", "name": "Tee 8x6" }, { "code": "Tee 12x6", "name": "Tee 12x6" }, { "code": "Corp Stop", "name": "Corp Stop" }, { "code": "Tee 8x4", "name": "Tee 8x4" }, { "code": "Tee 16x6", "name": "Tee 16x6" }, { "code": "Tee 16x12", "name": "Tee 16x12" }, { "code": "Tee 12x12", "name": "Tee 12x12" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "jointtype", "length": 20, "alias": "JointType", "type": "esriFieldTypeString" }, { "modelName": "material", "nullable": true, "editable": true, "defaultValue": "Unknown", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Material", "description": "Pipe Material", "type": "codedValue", "codedValues": [ { "code": "DIP", "name": "DIP" }, { "code": "CIP", "name": "CIP" }, { "code": "PVC", "name": "PVC" }, { "code": "RCP", "name": "RCP" }, { "code": "Copper", "name": "Copper" }, { "code": "Lead", "name": "Lead" }, { "code": "Clay", "name": "Clay" }, { "code": "Unknown", "name": "Unknown" }, { "code": "PEX", "name": "PEX" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "material", "length": 20, "alias": "Material", "type": "esriFieldTypeString" }, { "modelName": "diameter1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "diameter1", "alias": "Diameter1", "type": "esriFieldTypeDouble" }, { "modelName": "diameter2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "diameter2", "alias": "Diameter2", "type": "esriFieldTypeDouble" }, { "modelName": "diameter3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "diameter3", "alias": "Diameter3", "type": "esriFieldTypeDouble" }, { "modelName": "diameter4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "diameter4", "alias": "Diameter4", "type": "esriFieldTypeDouble" }, { "modelName": "communityid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "communityid", "length": 20, "alias": "CommunityID", "type": "esriFieldTypeString" }, { "modelName": "ownership", "nullable": true, "editable": true, "defaultValue": "COY", "domain": null, "name": "ownership", "length": 9, "alias": "Ownership", "type": "esriFieldTypeString" }, { "modelName": "maintained", "nullable": true, "editable": true, "defaultValue": "COY", "domain": null, "name": "maintained", "length": 9, "alias": "Maintained", "type": "esriFieldTypeString" }, { "modelName": "description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 255, "alias": "Description", "type": "esriFieldTypeString" }, { "modelName": "angle", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "angle", "alias": "ANGLE", "type": "esriFieldTypeDouble" }, { "modelName": "manufacturer", "nullable": true, "editable": true, "defaultValue": "UNK", "domain": null, "name": "manufacturer", "length": 3, "alias": "Manufacturer", "type": "esriFieldTypeString" }, { "modelName": "dateabandoned", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dateabandoned", "length": 29, "alias": "DATEABANDONED", "type": "esriFieldTypeDate" }, { "modelName": "ownershipdescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownershipdescription", "length": 50, "alias": "OWNERSHIPDESCRIPTION", "type": "esriFieldTypeString" }, { "modelName": "maintaineddescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "maintaineddescription", "length": 50, "alias": "MAINTAINEDDESCRIPTION", "type": "esriFieldTypeString" }, { "modelName": "esrignss_altitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_altitude", "alias": "Altitude", "type": "esriFieldTypeDouble" }, { "modelName": "esrignss_longitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_longitude", "alias": "Longitude", "type": "esriFieldTypeDouble" }, { "modelName": "qanotes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "qanotes", "length": 255, "alias": "QA Notes", "type": "esriFieldTypeString" }, { "modelName": "esrignss_avg_v_rms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_avg_v_rms", "alias": "Average Vertical Accuracy (m)", "type": "esriFieldTypeDouble" }, { "modelName": "esrignss_v_rms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_v_rms", "alias": "Vertical Accuracy (m)", "type": "esriFieldTypeDouble" }, { "modelName": "fieldverificationstatus", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fieldverificationstatus", "length": 10, "alias": "Field Verification Status", "type": "esriFieldTypeString" }, { "modelName": "esrignss_latitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_latitude", "alias": "Latitude", "type": "esriFieldTypeDouble" }, { "modelName": "esrignss_fixtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_fixtype", "alias": "Fix Type", "type": "esriFieldTypeSmallInteger" }, { "modelName": "esrignss_avg_h_rms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_avg_h_rms", "alias": "Average Horizontal Accuracy (m)", "type": "esriFieldTypeDouble" }, { "modelName": "qastatus", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "qastatus", "length": 10, "alias": "QA Status", "type": "esriFieldTypeString" }, { "modelName": "esrignss_h_rms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_h_rms", "alias": "Horizontal Accuracy (m)", "type": "esriFieldTypeDouble" }, { "modelName": "fieldverificationnotes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fieldverificationnotes", "length": 255, "alias": "Field Verification Notes", "type": "esriFieldTypeString" }, { "modelName": "enclosuretype", "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "enclosuretype", "alias": "ENCLOSURETYPE", "type": "esriFieldTypeSmallInteger" }, { "modelName": "enclosureinstalldate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "enclosureinstalldate", "length": 29, "alias": "ENCLOSUREINSTALLDATE", "type": "esriFieldTypeDate" }, { "modelName": "enclosuredescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "enclosuredescription", "length": 255, "alias": "ENCLOSUREDESCRIPTION", "type": "esriFieldTypeString" }, { "modelName": "enclosurecovermaterial", "nullable": true, "editable": true, "defaultValue": "UNK", "domain": null, "name": "enclosurecovermaterial", "length": 20, "alias": "ENCLOSURECOVERMATERIAL", "type": "esriFieldTypeString" }, { "modelName": "enclosurecovertype", "nullable": true, "editable": true, "defaultValue": "UNK", "domain": null, "name": "enclosurecovertype", "length": 20, "alias": "ENCLOSURECOVERTYPE", "type": "esriFieldTypeString" }, { "modelName": "enclosureframematerial", "nullable": true, "editable": true, "defaultValue": "UNK", "domain": null, "name": "enclosureframematerial", "length": 20, "alias": "ENCLOSUREFRAMEMATERIAL", "type": "esriFieldTypeString" }, { "modelName": "enclosureframetype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "enclosureframetype", "length": 20, "alias": "ENCLOSUREFRAMETYPE", "type": "esriFieldTypeString" }, { "modelName": "enclosurerimelevation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "enclosurerimelevation", "alias": "ENCLOSURERIMELEVATION", "type": "esriFieldTypeDouble" }, { "modelName": "enclosureinvertelevation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "enclosureinvertelevation", "alias": "ENCLOSUREINVERTELEVATION", "type": "esriFieldTypeDouble" }, { "modelName": "enclosuremeasurement1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "enclosuremeasurement1", "alias": "ENCLOSUREMEASUREMENT1", "type": "esriFieldTypeSmallInteger" }, { "modelName": "enclosuremeasurement2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "enclosuremeasurement2", "alias": "ENCLOSUREMEASUREMENT2", "type": "esriFieldTypeSmallInteger" }, { "modelName": "depth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "depth", "alias": "DEPTH", "type": "esriFieldTypeDouble" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "WaterFitting_Point", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "i12583lifecycles", "isUnique": false, "description": "", "fields": "lifecyclestatus", "isAscending": true }, { "name": "r4322_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_4322", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a3469_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 144448, "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": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "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": "353659e2cc2041b8a121168afe09be85", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 135, 32, 114, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 5113083.444224276, "xmin": -9841932.490866054, "ymax": 5115263.771468066, "xmax": -9840146.473914525, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.4.0", "isDataArchived": false, "id": 5, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Raw_Water_Main", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "created_fr": null, "pressure_z": null, "notes": null, "adjusted": null, "globalid": null, "objectid_1": null, "type": null, "shape_leng": null, "project_na": null, "ownership": null, "diameter": null, "material": null, "polywrap": null, "project_id": null, "w_pipe_id": null, "date_edite": null, "service_ty": null, "edited_by": null, "status": null, "year_insta": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Raw_Water_Main", "allowTrueCurvesUpdates": false, "displayField": "w_pipe_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "objectid_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "objectid_1", "alias": "OBJECTID", "type": "esriFieldTypeInteger" }, { "modelName": "type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "type", "alias": "Type", "type": "esriFieldTypeSmallInteger" }, { "modelName": "service_ty", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "service_ty", "alias": "Service_Ty", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ownership", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownership", "alias": "Ownership", "type": "esriFieldTypeSmallInteger" }, { "modelName": "w_pipe_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "w_pipe_id", "length": 15, "alias": "W_Pipe_Id", "type": "esriFieldTypeString" }, { "modelName": "diameter", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "diameter", "length": 15, "alias": "Diameter", "type": "esriFieldTypeString" }, { "modelName": "material", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "material", "length": 25, "alias": "Material", "type": "esriFieldTypeString" }, { "modelName": "pressure_z", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressure_z", "length": 100, "alias": "Pressure_Z", "type": "esriFieldTypeString" }, { "modelName": "polywrap", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "polywrap", "alias": "Polywrap", "type": "esriFieldTypeSmallInteger" }, { "modelName": "project_na", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_na", "length": 100, "alias": "Project_Na", "type": "esriFieldTypeString" }, { "modelName": "project_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_id", "length": 20, "alias": "Project_Id", "type": "esriFieldTypeString" }, { "modelName": "year_insta", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_insta", "length": 10, "alias": "Year_Insta", "type": "esriFieldTypeString" }, { "modelName": "created_fr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_fr", "length": 100, "alias": "Created_Fr", "type": "esriFieldTypeString" }, { "modelName": "date_edite", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "date_edite", "length": 29, "alias": "Date_Edite", "type": "esriFieldTypeDate" }, { "modelName": "edited_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "edited_by", "length": 5, "alias": "Edited_By", "type": "esriFieldTypeString" }, { "modelName": "notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 254, "alias": "Notes", "type": "esriFieldTypeString" }, { "modelName": "globalid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeString" }, { "modelName": "adjusted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "adjusted", "length": 5, "alias": "Adjusted", "type": "esriFieldTypeString" }, { "modelName": "status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "alias": "Status", "type": "esriFieldTypeSmallInteger" }, { "modelName": "shape_leng", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape_leng", "alias": "SHAPE_Leng", "type": "esriFieldTypeDouble" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid_1", "domain": null, "name": "globalid_1", "alias": "GlobalID_1" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid_1", "description": "Raw_Water_Main", "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": "r4324_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_4324", "isUnique": true, "description": "", "fields": "globalid_1", "isAscending": true }, { "name": "a3471_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": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "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": "353659e2cc2041b8a121168afe09be85", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "color": [ 30, 27, 130, 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": 5102501.06669192, "zmin": -1.9999999494757503E-4, "xmin": -9850514.824241417, "ymax": 5118165.190315679, "zmax": 2064.0239, "xmax": -9839510.602716839, "mmax": 0, "mmin": 0, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.4.0", "isDataArchived": false, "id": 6, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Water_Main_Lines", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "pressure_z": null, "notes": null, "mi_len": null, "main_type": null, "project_na": null, "shape_leng": null, "wm_replace_year_2021_plan": null, "community_status": null, "diameter": null, "polywrap": null, "project_id": null, "w_pipe_id": null, "ownership_": "COY", "date_edite": null, "diam": null, "created_fr": null, "calc_year_install": null, "adjusted": null, "accepted": null, "material": null, "ft_len": null, "year_decade": "2020-Present", "wm_replace_year": null, "edited_by": null, "year_insta": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": true, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid_1", "supportsQuantizationEditMode": true, "name": "Water_Main_Lines", "allowTrueCurvesUpdates": false, "displayField": "w_pipe_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid_1", "domain": null, "name": "objectid_1", "alias": "OBJECTID_1" }, { "modelName": "w_pipe_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "w_pipe_id", "length": 15, "alias": "W_Pipe_Id", "type": "esriFieldTypeString" }, { "modelName": "diameter", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Size", "description": "Size", "type": "codedValue", "codedValues": [ { "code": "1\"", "name": "1\"" }, { "code": "2\"", "name": "2\"" }, { "code": "4\"", "name": "4\"" }, { "code": "6\"", "name": "6\"" }, { "code": "8\"", "name": "8\"" }, { "code": "10\"", "name": "10\"" }, { "code": "12\"", "name": "12\"" }, { "code": "16\"", "name": "16\"" }, { "code": "18\"", "name": "18\"" }, { "code": "20\"", "name": "20\"" }, { "code": "24\"", "name": "24\"" }, { "code": "36\"", "name": "36\"" }, { "code": "42\"", "name": "42\"" }, { "code": "60\"", "name": "60\"" }, { "code": "72\"", "name": "72\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "diameter", "length": 15, "alias": "Diameter", "type": "esriFieldTypeString" }, { "modelName": "material", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Material", "description": "Pipe Material", "type": "codedValue", "codedValues": [ { "code": "DIP", "name": "DIP" }, { "code": "CIP", "name": "CIP" }, { "code": "PVC", "name": "PVC" }, { "code": "RCP", "name": "RCP" }, { "code": "Copper", "name": "Copper" }, { "code": "Lead", "name": "Lead" }, { "code": "Clay", "name": "Clay" }, { "code": "Unknown", "name": "Unknown" }, { "code": "PEX", "name": "PEX" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "material", "length": 25, "alias": "Material", "type": "esriFieldTypeString" }, { "modelName": "pressure_z", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressure_z", "length": 100, "alias": "Pressure_Z", "type": "esriFieldTypeString" }, { "modelName": "polywrap", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "polywrap", "alias": "Polywrap", "type": "esriFieldTypeInteger" }, { "modelName": "project_na", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_na", "length": 100, "alias": "Project_Na", "type": "esriFieldTypeString" }, { "modelName": "project_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_id", "length": 20, "alias": "Project_Id", "type": "esriFieldTypeString" }, { "modelName": "year_insta", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_insta", "length": 10, "alias": "Year_Insta", "type": "esriFieldTypeString" }, { "modelName": "created_fr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_fr", "length": 100, "alias": "Created_Fr", "type": "esriFieldTypeString" }, { "modelName": "date_edite", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "date_edite", "length": 29, "alias": "Date_Edite", "type": "esriFieldTypeDate" }, { "modelName": "edited_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "edited_by", "length": 5, "alias": "Edited_By", "type": "esriFieldTypeString" }, { "modelName": "notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 254, "alias": "Notes", "type": "esriFieldTypeString" }, { "modelName": "adjusted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "adjusted", "length": 5, "alias": "Adjusted", "type": "esriFieldTypeString" }, { "modelName": "shape_leng", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape_leng", "alias": "SHAPE_Leng", "type": "esriFieldTypeDouble" }, { "modelName": "ft_len", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ft_len", "alias": "FT_Len", "type": "esriFieldTypeDouble" }, { "modelName": "mi_len", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mi_len", "alias": "MI_Len", "type": "esriFieldTypeDouble" }, { "modelName": "accepted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accepted", "length": 50, "alias": "Accepted", "type": "esriFieldTypeString" }, { "modelName": "main_type", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Main Type", "description": "Main Type", "type": "codedValue", "codedValues": [ { "code": "Class 52 Main", "name": "Class 52 Main" }, { "code": "Class 54 Main", "name": "Class 54 Main" }, { "code": "Class 55 Main", "name": "Class 55 Main" }, { "code": "Hydrant Lead", "name": "Hydrant Lead" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "main_type", "length": 50, "alias": "Main_Type", "type": "esriFieldTypeString" }, { "modelName": "wm_replace_year", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "wm_replace_year", "alias": "Water Main Replace Year", "type": "esriFieldTypeSmallInteger" }, { "modelName": "wm_replace_year_2021_plan", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "wm_replace_year_2021_plan", "length": 10, "alias": "WM_Replace_Year_2021_Plan", "type": "esriFieldTypeString" }, { "modelName": "community_status", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Status_11", "description": "Network Status", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Unknown", "name": "Unknown" }, { "code": "Proposed", "name": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "community_status", "length": 20, "alias": "Community Status", "type": "esriFieldTypeString" }, { "modelName": "year_decade", "nullable": true, "editable": true, "defaultValue": "2020-Present", "domain": null, "name": "year_decade", "length": 25, "alias": "Year_Decade", "type": "esriFieldTypeString" }, { "modelName": "calc_year_install", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "calc_year_install", "alias": "Calc_Year_Install", "type": "esriFieldTypeDouble" }, { "modelName": "ownership_", "nullable": true, "editable": true, "defaultValue": "COY", "domain": null, "name": "ownership_", "length": 50, "alias": "Ownership_", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "diam", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "diam", "alias": "DIAM", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "Water_Main_Lines", "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": "i12586community_", "isUnique": false, "description": "", "fields": "community_status", "isAscending": true }, { "name": "r4325_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid_1", "isAscending": true }, { "name": "uuid_4325", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a3472_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 288896, "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": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "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": "353659e2cc2041b8a121168afe09be85", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportsVCSProjection": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "color": [ 137, 76, 56, 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": 5105414.72516381, "xmin": -9846926.03183568, "ymax": 5115331.723718569, "xmax": -9839559.760124642, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.4.0", "isDataArchived": false, "id": 7, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "WaterServicePublic", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "esrignss_avg_h_rms": null, "serviceaddress": null, "installdate": null, "dateverified": null, "dateabandoned": null, "description": null, "esrignss_avg_v_rms": null, "maintaineddescription": null, "fieldverificationnotes": null, "lifecyclestatus": null, "esrignss_longitude": null, "esrignss_latitude": null, "esrignss_altitude": null, "diameter": null, "subtype": 0, "qanotes": null, "watertype": "POTABLE", "maintained": "COY", "esrignss_fixtype": null, "esrignss_v_rms": null, "fieldverificationstatus": null, "qastatus": null, "locationdescription": null, "measurelength": null, "ownershipdescription": null, "material": null, "ownership": "COY", "flowmeasurementid": null, "communityid": null, "featureid": null, "esrignss_h_rms": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "WaterServicePublic", "allowTrueCurvesUpdates": false, "displayField": "featureid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "featureid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "featureid", "length": 15, "alias": "FEATUREID", "type": "esriFieldTypeString" }, { "modelName": "installdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "InstallDate", "type": "esriFieldTypeDate" }, { "modelName": "lifecyclestatus", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Status_11", "description": "Network Status", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Unknown", "name": "Unknown" }, { "code": "Proposed", "name": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lifecyclestatus", "length": 20, "alias": "LifecycleStatus", "type": "esriFieldTypeString" }, { "modelName": "subtype", "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "subtype", "alias": "Subtype", "type": "esriFieldTypeInteger" }, { "modelName": "flowmeasurementid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "flowmeasurementid", "length": 255, "alias": "FlowMeasurementID", "type": "esriFieldTypeString" }, { "modelName": "watertype", "nullable": true, "editable": true, "defaultValue": "POTABLE", "domain": null, "name": "watertype", "length": 255, "alias": "WaterType", "type": "esriFieldTypeString" }, { "modelName": "material", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Material", "description": "Pipe Material", "type": "codedValue", "codedValues": [ { "code": "DIP", "name": "DIP" }, { "code": "CIP", "name": "CIP" }, { "code": "PVC", "name": "PVC" }, { "code": "RCP", "name": "RCP" }, { "code": "Copper", "name": "Copper" }, { "code": "Lead", "name": "Lead" }, { "code": "Clay", "name": "Clay" }, { "code": "Unknown", "name": "Unknown" }, { "code": "PEX", "name": "PEX" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "material", "length": 255, "alias": "Material", "type": "esriFieldTypeString" }, { "modelName": "locationdescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "locationdescription", "length": 50, "alias": "LocationDescription", "type": "esriFieldTypeString" }, { "modelName": "diameter", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "diameter", "alias": "Diameter", "type": "esriFieldTypeDouble" }, { "modelName": "communityid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "communityid", "length": 20, "alias": "CommunityID", "type": "esriFieldTypeString" }, { "modelName": "ownership", "nullable": true, "editable": true, "defaultValue": "COY", "domain": null, "name": "ownership", "length": 9, "alias": "Ownership", "type": "esriFieldTypeString" }, { "modelName": "maintained", "nullable": true, "editable": true, "defaultValue": "COY", "domain": null, "name": "maintained", "length": 9, "alias": "Maintained", "type": "esriFieldTypeString" }, { "modelName": "description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 255, "alias": "Description", "type": "esriFieldTypeString" }, { "modelName": "measurelength", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "measurelength", "alias": "MeasureLength", "type": "esriFieldTypeDouble" }, { "modelName": "dateabandoned", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dateabandoned", "length": 29, "alias": "DATEABANDONED", "type": "esriFieldTypeDate" }, { "modelName": "ownershipdescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownershipdescription", "length": 50, "alias": "OWNERSHIPDESCRIPTION", "type": "esriFieldTypeString" }, { "modelName": "maintaineddescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "maintaineddescription", "length": 50, "alias": "MAINTAINEDDESCRIPTION", "type": "esriFieldTypeString" }, { "modelName": "esrignss_altitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_altitude", "alias": "Altitude", "type": "esriFieldTypeDouble" }, { "modelName": "esrignss_longitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_longitude", "alias": "Longitude", "type": "esriFieldTypeDouble" }, { "modelName": "qanotes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "qanotes", "length": 255, "alias": "QA Notes", "type": "esriFieldTypeString" }, { "modelName": "esrignss_avg_v_rms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_avg_v_rms", "alias": "Average Vertical Accuracy (m)", "type": "esriFieldTypeDouble" }, { "modelName": "esrignss_v_rms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_v_rms", "alias": "Vertical Accuracy (m)", "type": "esriFieldTypeDouble" }, { "modelName": "fieldverificationstatus", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fieldverificationstatus", "length": 10, "alias": "Field Verification Status", "type": "esriFieldTypeString" }, { "modelName": "esrignss_latitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_latitude", "alias": "Latitude", "type": "esriFieldTypeDouble" }, { "modelName": "esrignss_fixtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_fixtype", "alias": "Fix Type", "type": "esriFieldTypeSmallInteger" }, { "modelName": "esrignss_avg_h_rms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_avg_h_rms", "alias": "Average Horizontal Accuracy (m)", "type": "esriFieldTypeDouble" }, { "modelName": "qastatus", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "qastatus", "length": 10, "alias": "QA Status", "type": "esriFieldTypeString" }, { "modelName": "esrignss_h_rms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esrignss_h_rms", "alias": "Horizontal Accuracy (m)", "type": "esriFieldTypeDouble" }, { "modelName": "fieldverificationnotes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fieldverificationnotes", "length": 255, "alias": "Field Verification Notes", "type": "esriFieldTypeString" }, { "modelName": "dateverified", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dateverified", "length": 29, "alias": "DATEVERIFIED", "type": "esriFieldTypeDate" }, { "modelName": "serviceaddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "serviceaddress", "length": 100, "alias": "SERVICEADDRESS", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "WaterServicePublic", "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": "i12584lifecycles", "isUnique": false, "description": "", "fields": "lifecyclestatus", "isAscending": true }, { "name": "r4323_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_4323", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a3470_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 144448, "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": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "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": "353659e2cc2041b8a121168afe09be85", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "color": [ 132, 66, 114, 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 } ] }