{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "Service Connection", "type" : "Feature Layer", "serviceItemId" : "bac6062b352d4035ba73367b7a6c6542", "cacheMaxAge" : 30, "displayField" : "FACILITYID", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 3000, "maxScale" : 0, "extent" : { "xmin" : -9816565.6903394144, "ymin" : 5125652.0859674439, "xmax" : -9809407.56253028, "ymax" : 5130591.2527824063, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"9f0df1320e3dfad3b6c58f41f9fee882","imageData":"iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAvVJREFUOI2tlG9I3WUUxz/n/n7yc9EaV01n/pkT01qwLVuw9JpvzK25sG1MfWNagWxjaLstQwmWRMpGGFch7cVQN4KxYrJ6MQsTprgNF0RE6Q1Sx8S5WWsJbfvNe+/pxfXnvTdl9GJfeF4855znw3PO9+ExeYQyH5r1arqlZCPE2UFm8eEHCf1/WJua3OJAnol3Qcn0uFkwXKo//i2PzXu594+G+uw4aeWEzD8c5tX01D/5ZleaZhzdK+6nM3EZBm4QVGH2FubJAdnd+hPVeLXSbpfvV4c1aEoqjLSX8vhrHklcY4HLFSkUgbQUzPeqyNmRz1RxD/2WV/dEA6NvdvpYoerrxZK0phGGa6Do+dg2/lqA1A/hh0NsHHqD0cJeztCom5yWTQCrXnfmWGx+u1xSAsHwwZ4hKNwKLonALv8M9tL4C7ZSuD+F776e12YbjizDbNHaD0pk0jRYht25D/4peDY7vA+FoHcYyp+MwD+q4o8vfVIN+i5IaKlNKdi+iRh3ajzQPxqBTUzDC5lwbzFSk5tFMhBHA3n4GHdmlpqwLhbm2QKV5+GtXbA+ES6MQdl2+GokxpR4C2YweMomAgsuBpkF8p1C9xPwSQEMjsFuD4xNw5EKIAqmqtdRSUZZjBgAk7/8zm8v5xOjspfg1Q4wXFBbFPtUAOwHMmQL+xAmIwagg3VniJ/Il+tAhlO8MQ3KsuDNb+FmC//VVOnH3LGUabtdZpZhIF3+B1z5dZK67HS+AAznRFMVHL4L69ZGt0dgMUjtyAKfYtDpxMMwn4xbDaHPn+uQd6bfp+boM/QhYWCSO7wcbUhSe+KaHHuxS/eAKMl0x8IAe700M8fZrOMcPr2TbYJWgJQDOYACfuDc5lzp3vaZtoC8gkExTRJYAaNJArRphTWnrdUDcrH6Aqcsk3ob/AQIJEDGbaEEuAoyARTQLjejhxj7azRJwIZGGrQH4SBBOoFsBOM23AC9ZKnU2R0ysMKOFTBHPhkH6u1VUqvFHP0LkRYBVgpPWrcAAAAASUVORK5CYII=","contentType":"image/png","width":14,"height":14,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "ACCOUNTID", "type" : "esriFieldTypeString", "alias" : "Account Identifier", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "METSERVICE", "type" : "esriFieldTypeString", "alias" : "Metered Service", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "SERVICETYPE", "type" : "esriFieldTypeString", "alias" : "Service Type", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wServicePointType", "codedValues" : [ { "name" : "Domestic", "code" : "Domestic" }, { "name" : "Commercial", "code" : "Commercial" }, { "name" : "Industrial", "code" : "Industrial" }, { "name" : "Fire", "code" : "Fire" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "INSTALLDATE", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LOCDESC", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "LOCATIONID", "type" : "esriFieldTypeString", "alias" : "Location Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CRITICAL", "type" : "esriFieldTypeSmallInteger", "alias" : "Critical Customer", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__WaterDis__F4B70D85DF82B6E0", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_12861.WaterDistributionNetwork_Service_Connection_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Domestic Connection", "description" : "A Domestic or House Service Connection.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "METSERVICE" : "Yes", "SERVICETYPE" : "Domestic", "CRITICAL" : 0, "LOCATIONID" : null, "INSTALLDATE" : null, "ACCOUNTID" : null } } }, { "name" : "Commercial Connection", "description" : "A Commercial Service Connection.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "METSERVICE" : "Yes", "SERVICETYPE" : "Commercial", "CRITICAL" : 0, "LOCATIONID" : null, "INSTALLDATE" : null, "ACCOUNTID" : null } } }, { "name" : "Industrial Connection", "description" : "A Industrial Service Connection.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "METSERVICE" : "Yes", "SERVICETYPE" : "Industrial", "CRITICAL" : 0, "LOCATIONID" : null, "INSTALLDATE" : null, "ACCOUNTID" : null } } }, { "name" : "Fire Connection with Lateral", "description" : "A Fire Service Connection.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "METSERVICE" : "Yes", "SERVICETYPE" : "Fire", "CRITICAL" : 0, "LOCATIONID" : null, "INSTALLDATE" : null, "ACCOUNTID" : null } } }, { "name" : "(Empty Values)", "description" : "A Water Serice Connection with no values set.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "METSERVICE" : "Yes", "SERVICETYPE" : null, "CRITICAL" : 0, "LOCATIONID" : null, "INSTALLDATE" : null, "ACCOUNTID" : null } } }, { "name" : "(Empty Values) with Lateral", "description" : "A Water Serice Connection with no values set.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "METSERVICE" : "Yes", "SERVICETYPE" : null, "CRITICAL" : 0, "LOCATIONID" : null, "INSTALLDATE" : null, "ACCOUNTID" : null } } }, { "name" : "Commercial Connection with Lateral", "description" : "A Commercial Service Connection.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "METSERVICE" : "Yes", "SERVICETYPE" : "Commercial", "CRITICAL" : 0, "LOCATIONID" : null, "INSTALLDATE" : null, "ACCOUNTID" : null } } }, { "name" : "Domestic Connection with Lateral", "description" : "A Domestic or House Service Connection.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "METSERVICE" : "Yes", "SERVICETYPE" : "Domestic", "CRITICAL" : 0, "LOCATIONID" : null, "INSTALLDATE" : null, "ACCOUNTID" : null } } }, { "name" : "Fire Connection", "description" : "A Fire Service Connection.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "METSERVICE" : "Yes", "SERVICETYPE" : "Fire", "CRITICAL" : 0, "LOCATIONID" : null, "INSTALLDATE" : null, "ACCOUNTID" : null } } }, { "name" : "Industrial Connection with Lateral", "description" : "A Industrial Service Connection.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "METSERVICE" : "Yes", "SERVICETYPE" : "Industrial", "CRITICAL" : 0, "LOCATIONID" : null, "INSTALLDATE" : null, "ACCOUNTID" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 1, "name" : "Hydrant", "type" : "Feature Layer", "serviceItemId" : "bac6062b352d4035ba73367b7a6c6542", "cacheMaxAge" : 30, "displayField" : "FACILITYID", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 5000, "maxScale" : 0, "extent" : { "xmin" : -9816530.7623042911, "ymin" : 5125684.7662219005, "xmax" : -9809431.3134679068, "ymax" : 5130564.9475809643, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"OPERABLE","field2":null,"field3":null,"fieldDelimiter":", ","defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"d9bf223eeb9b3fe823ebc002a8ff97f5","imageData":"iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAntJREFUSIm1lF9IU1Ecx7/K/uGWG3dXuqZMUxgDQzQlx0C4DgSZkBBKPpkYhJd60uo1ehD2ECFCjHzzMYXiCqMeVPwD4kDh2h9r0ItmDddlaHNsY+duPeTGdGd6Vfo+/fh+z+9zDj/OORr8R2nOWtDU1NSl1+v7aRnLso/8fv/hheEAbhBC7tECWZYfA7gU/MI6E26xWExWqxnV1WkYjcDeHiDLpQAAnU7HBgIB+ULwsbH7dxsbf/V3dKzAaIzk/FCIgSjasLHR6hEEwe7z+WbPBZ+YGBzo6fn83GYL1J7MKisjGB6OIJH4enVkZEgSBOE2bYMcvK2tjc3Wdnt1hdP58xkNnC+DIfnU633zfXT0jqmvr8+xs7MjAwDHcXFRFGM5OCHkd7ZuaEigpWX5NG6eYpPB4CcwDPeSEAIA2N3dfQ1gmDoWh4OgtDR5zIvHK7G05AQA8PwaDIYQAKC8PAmP5xBra4UcKtxsLvQWF10QxezknOjqepfLamuJeng6XehlMvQaAI6moQ6evcf54vl1ZDKtKCn5N5Z8bW3RLx3V3dzUoLdXf2zuZWXb6O7eLlgbCjFYWDCB406BK4ryJFuvrkZN8/Pugc7O99epRzpSOg1lebniVU1NzbVwOPxFUZTsPyMdg0uS9CK/0el88LGurv1hff2KmwZOpfSIxZjBubn2H1ar1jw9PV38EZ2U1zv59uBAIM3NFoPbve6qqopAq00iGmUQDF7B1BSLVKqZ1Wq1f879/AHA5/PN8jx/0++/5aLlOt3Bh5mZmW/F+s/8Fff39w+j0Si9WaMp+iOqgl9GauAEQLJIliniq4NLkjQOYFzFIc4Pv4z+AmU/3CS5irErAAAAAElFTkSuQmCC","contentType":"image/png","width":17,"height":17,"angle":0,"xoffset":0,"yoffset":0},"value":"0","label":"Out of Service","description":""},{"symbol":{"type":"esriPMS","url":"e417addd5623053b6b0bd6e229fe8435","imageData":"iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAoNJREFUSIm1lF1IU2EYx/87nXM23GxrHmmmuGVgQhFa0sZAWEIgBgXRyCuThPJUV33dRheBFxES1Mi7LnNQTBh1UVEK4cDglH0J3bhW0jqtre3odvaesy5k6vRs7oP+Vw//531+73sezvPQ+I+itzrQ2dnZp9frB7RyHMddCgaDqarhAPYTQs5oJURRvAqgJnjV2hJusVhMDWYzWigVRgr4qQKiSgEAWJblQqGQWBX81vnh0wdSPwaOpKdhpGIrJgUsylYEkq1429bdz/N8u8/nm6wIfnd4aPBE6sPNVjnkAFWYa2JjGGmIIZ34vPMyd1bgef641gWrcKfTyeXj9paWRpf8/UarHHKU+jIDMtdHo4++Xtlx0uT1ejvC4bAIADabbTkQCEircELIr3y8D2kcSk+V4q5Jlcbn5+ZgtdnuEEIAAJFI5AGAEc22dDAElJIp8JZ1TXhd5wIAeJZmYMgtAgC20xn0synMaHA04eZtAJRC75XRjQCb75wLfdKT1ZyDIeXDVQ0vVyQGAKIFKQYXFWqT55Fmkct1Q6dbact6fUrTQH2Z8HdZGqcoPSis9b0ut4Bj0sKms4uyFS8VE2ylXq4oyrV8/OZ30vSiuXfwqPx0t9bleakqlKmlxnt2u31XNBr9qChKfs8IBXBBEG6vL3RdOPe+LdFzcY883asFzkIPCdah5/aebw0MY56YmCg+RBs1en/8cYLnSdcfi6FXmnU3szEwyCCpWjGfrsfDFIfs3i6OYZi/FY8/APh8vkmPx3MwaD7sLvglWABWgE0knvn9/i/F6rfcivF4PJVMJrWLabroRiwLXovKgRMAmSK5jfNUGVwQhDEAY2U8onJ4LfoHdajg2kpeM7AAAAAASUVORK5CYII=","contentType":"image/png","width":17,"height":17,"angle":0,"xoffset":0,"yoffset":0},"value":"1","label":"In Service","description":""}]},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "OPERABLE", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSTALLDATE", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LOCDESC", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MANUFACTURER", "type" : "esriFieldTypeString", "alias" : "Manufacturer", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wHydrantManufacturer", "codedValues" : [ { "name" : "American Darling", "code" : "American Darling" }, { "name" : "Clow Corporation", "code" : "Clow Corporation" }, { "name" : "Corey", "code" : "Corey" }, { "name" : "Dresser", "code" : "Dresser" }, { "name" : "Eddy", "code" : "Eddy" }, { "name" : "Iowa Valve", "code" : "Iowa Valve" }, { "name" : "Kennedy Valve", "code" : "Kennedy Valve" }, { "name" : "M&H Valve", "code" : "M&H Valve" }, { "name" : "M&H Valve / Dresser", "code" : "M&H Valve / Dresser" }, { "name" : "Mueller Company", "code" : "Mueller Company" }, { "name" : "Traverse City", "code" : "Traverse City" }, { "name" : "US Pipe", "code" : "US Pipe" }, { "name" : "Waterous", "code" : "Waterous" }, { "name" : "Wood-Matthews", "code" : "Wood-Matthews" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "OPERABLE", "type" : "esriFieldTypeSmallInteger", "alias" : "Operable", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "LASTSERVICE", "type" : "esriFieldTypeDate", "alias" : "Last Service Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "FLOW", "type" : "esriFieldTypeDouble", "alias" : "Flow Rate (GPM)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__WaterDis__F4B70D85EBFE00D9", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_12861.WaterDistributionNetwork_Hydrant_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : 0, "name" : "Out of Service", "domains" : { "MANUFACTURER" : {"type" : "inherited"}, "OPERABLE" : {"type" : "inherited"}, "ENABLED" : {"type" : "inherited"}, "ACTIVEFLAG" : {"type" : "inherited"}, "OWNEDBY" : {"type" : "inherited"}, "MAINTBY" : {"type" : "inherited"} }, "templates" : [ { "name" : "Out of Service", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "FLOW" : null, "FACILITYID" : null, "INSTALLDATE" : null, "LOCDESC" : null, "MANUFACTURER" : null, "OPERABLE" : 0, "LASTSERVICE" : null } } } ] }, { "id" : 1, "name" : "In Service", "domains" : { "MANUFACTURER" : {"type" : "inherited"}, "OPERABLE" : {"type" : "inherited"}, "ENABLED" : {"type" : "inherited"}, "ACTIVEFLAG" : {"type" : "inherited"}, "OWNEDBY" : {"type" : "inherited"}, "MAINTBY" : {"type" : "inherited"} }, "templates" : [ { "name" : "In Service", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "FLOW" : null, "FACILITYID" : null, "INSTALLDATE" : null, "LOCDESC" : null, "MANUFACTURER" : null, "OPERABLE" : 1, "LASTSERVICE" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 2, "name" : "System Valve", "type" : "Feature Layer", "serviceItemId" : "bac6062b352d4035ba73367b7a6c6542", "cacheMaxAge" : 30, "displayField" : "FACILITYID", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 5000, "maxScale" : 0, "extent" : { "xmin" : -9816581.5295351669, "ymin" : 5125574.6394541971, "xmax" : -9809430.9094030354, "ymax" : 5130648.0893070986, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"CURROPEN","field2":null,"field3":null,"fieldDelimiter":", ","defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"7db1abbcfb6d71331a6ee50d39c6236f","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAnBJREFUSIm11l9o1WUcx/HX/rgfembaYQViJOaEJqJlNkNYG4FMcFMMbAPpJq0RCDJaGysauovu/IN448BRd9aFgnahqdhahIStQmRYF26iFzX6kdaQJzvqxe9snZNznO3kB348Px4ePu/v93n4fp+n3GNWeYHrSrE8iqJnUJ5KpcbiOB7GnWIBK9bR9QevX6UyhABCCBaRqeabQfbh1EwBUR0Hr9BWhU5KapBGGf7ENcq+oH6Q+vV89y1vYLQQwIIGBq6x+jPU4wbGMZaz6GlJ6G9jDy+/wOXr6fRrcRxfmg5QtoEvb7NqAEuyk59i7xSRZFCDfkp6mX8+ji/ErMzNJA/QwAdfU/tDjnkhSqEHI1RWcfwML00FWDjGh33ZqGaqFPZgBWvQLHvwk4AN7PieaPMszCf0PNpxk48+/y9gMW/WYWERgBI04a1ki+biziTgOtVbizCf0FKMUppOp2viOB6aBPzIvAX/A2B+dhwfH3+KnC1Kcz+TZFmUMv/+/pMHeJG/fuOJYgFxdgwh3MgDLOPnr1jbWiRgGHX8PcgveYAK+o6wtktyULPRXXyCV7k4yL08QC/929l/lMpeSX+eqQZwCc8m5SAPgEwtuzs5WouZFtwoduJdzvYwNBXAbvoPsHULTSexSWGZDGfNtzDWk7SJST3UrttpPszpbTR2YAe68P4UxrdxEu8kwf36ZNJJw7QA2MXGY1H03rkQPn6OijY0SO6AMtzCTziIVdw/xPE2WuSVwTQAaA1h3zEONUZR70gIredYfJE5MV7h3mp+38/5uXS0cPNRPtPeya3cFUI3unPnT2S/QlToq2LWegCAY6c+VaS6nAAAAABJRU5ErkJggg==","contentType":"image/png","width":18,"height":18,"angle":0,"xoffset":0,"yoffset":0},"value":"0","label":"Closed","description":""},{"symbol":{"type":"esriPMS","url":"8f65570d966a2a85fd9bf4bbd296404b","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAvRJREFUSIm1lmtIFFEYhh9Xa9BVk82V1GottItZhmtaQSmCJpqkRSaEFClZVHQFMSk1qCi6SD9KA6OCQBGkklC0C5rdJKVSs4s/2sp2zZwi3exUbv3YWne1ZHXpheEMZw7P8535YM648J/jYuc6BRAkSdJkwEWpVHbLstwO9DsqCPadT7boY6XcgbsQAgAhBJKKgUnTaNA1cRyoHK1A0mgpNLSS5amGqK04+c4ApRcoFCCM8F6Hc0sNUbomonzn06h/RCqgs0cwQRNJneE1oVkXYdYi+KiHr1+gt2dwkacaUgtgSTpcOcYC0U8L3aoYWZYfjiRwDlxCjbGXeXlXYaK/ebKhDKpODK+kqBP8gmBDIU6Xj+HRflO+hUyI9U5sBL5a9nY0EpFXOwi3J5IrJO8B+R3u432o0N1G+zeBl+gjd90R8Au0H24tWbELCqIIA5L43XiLQBNNhuEJUmj86OF/4hcEMZnQpWdf27UhAm816SEZoPQcuwBgbhzc2Y4WcAX6LYIPBgLDEx2DA/hoQOhRqFSq2bIsN1sEhjbc3DwcF0hK82g0GtVg9YqUHvw0DeDkqMBkstz+sBFMDaHv8wcc7AAYP5lHIcRbG4Faw4vn9whfmOyYQP8CNJF80z3gpY3AReLs3dOEJ24F7yljgw/8gLoyCF7Ifd0DTDaCqpOc067iRP0l3FOywWkM3Xh2D141gY+GnZbCrQuYHsr28oOUBIRBWNzo4D2dULwD4jKprTxK898ElO/n3Op8UorXs3zzeQiNtW8n7zrg/E6ISKC78ihJ1s+Gfa7L80lKO0j1mSyWLcuCpWshYRvEbxkO/tILj6vhQjbEZtDlNYEQQIwoACjNJT6jSNrdWi8O5UYyfnE6zFwEnt6gcDaD37bB9RKYFMTPtHwqSnNYAwwMZf3zyCzZJI7nlHJqbrR0oOeNSHvagP/LRsYZZQiMxBQwh57UfdxwU7KneCOd/+KMeCYfTuM7iBwgx3q+rcp82RN7/yrGnF9xpvGgBwyJBgAAAABJRU5ErkJggg==","contentType":"image/png","width":18,"height":18,"angle":0,"xoffset":0,"yoffset":0},"value":"1","label":"Opened","description":""}]},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "CURROPEN", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSTALLDATE", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LOCDESC", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DIAMETER", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 } ] }, "defaultValue" : null }, { "name" : "VALVETYPE", "type" : "esriFieldTypeString", "alias" : "Valve Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piSystemValveType", "codedValues" : [ { "name" : "Ball", "code" : "Ball" }, { "name" : "Butterfly", "code" : "Butterfly" }, { "name" : "Cone", "code" : "Cone" }, { "name" : "Gate", "code" : "Gate" }, { "name" : "Plug", "code" : "Plug" }, { "name" : "Roundway", "code" : "Roundway" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "BYPASSVALVE", "type" : "esriFieldTypeSmallInteger", "alias" : "Bypass Valve", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "CLOCKTOCLOSE", "type" : "esriFieldTypeSmallInteger", "alias" : "Clockwise To Close", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "NORMALLYOPEN", "type" : "esriFieldTypeSmallInteger", "alias" : "Normally Open", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "TURNSTOCLOSE", "type" : "esriFieldTypeInteger", "alias" : "Turns To Close", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OPERABLE", "type" : "esriFieldTypeSmallInteger", "alias" : "Operable", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "HYDRFLAG", "type" : "esriFieldTypeSmallInteger", "alias" : "Hydrant Valve", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "CURROPEN", "type" : "esriFieldTypeSmallInteger", "alias" : "Currently Open", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__WaterDis__F4B70D85E8EEB71D", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_12861.WaterDistributionNetwork_System_Valve_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : 0, "name" : "Closed", "domains" : { "DIAMETER" : {"type" : "inherited"}, "VALVETYPE" : {"type" : "inherited"}, "BYPASSVALVE" : {"type" : "inherited"}, "CLOCKTOCLOSE" : {"type" : "inherited"}, "NORMALLYOPEN" : {"type" : "inherited"}, "OPERABLE" : {"type" : "inherited"}, "HYDRFLAG" : {"type" : "inherited"}, "CURROPEN" : {"type" : "inherited"}, "ENABLED" : {"type" : "inherited"}, "ACTIVEFLAG" : {"type" : "inherited"}, "OWNEDBY" : {"type" : "inherited"}, "MAINTBY" : {"type" : "inherited"} }, "templates" : [ { "name" : "Closed", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "CURROPEN" : 0, "HYDRFLAG" : null, "FACILITYID" : null, "INSTALLDATE" : null, "LOCDESC" : null, "DIAMETER" : null, "VALVETYPE" : null, "BYPASSVALVE" : null, "CLOCKTOCLOSE" : null, "NORMALLYOPEN" : null, "TURNSTOCLOSE" : null, "OPERABLE" : null } } } ] }, { "id" : 1, "name" : "Opened", "domains" : { "DIAMETER" : {"type" : "inherited"}, "VALVETYPE" : {"type" : "inherited"}, "BYPASSVALVE" : {"type" : "inherited"}, "CLOCKTOCLOSE" : {"type" : "inherited"}, "NORMALLYOPEN" : {"type" : "inherited"}, "OPERABLE" : {"type" : "inherited"}, "HYDRFLAG" : {"type" : "inherited"}, "CURROPEN" : {"type" : "inherited"}, "ENABLED" : {"type" : "inherited"}, "ACTIVEFLAG" : {"type" : "inherited"}, "OWNEDBY" : {"type" : "inherited"}, "MAINTBY" : {"type" : "inherited"} }, "templates" : [ { "name" : "Opened", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "CURROPEN" : 1, "HYDRFLAG" : null, "FACILITYID" : null, "INSTALLDATE" : null, "LOCDESC" : null, "DIAMETER" : null, "VALVETYPE" : null, "BYPASSVALVE" : null, "CLOCKTOCLOSE" : null, "NORMALLYOPEN" : null, "TURNSTOCLOSE" : null, "OPERABLE" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 3, "name" : "Hydrant Valve", "type" : "Feature Layer", "serviceItemId" : "bac6062b352d4035ba73367b7a6c6542", "cacheMaxAge" : 30, "displayField" : "FACILITYID", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 2000, "maxScale" : 0, "extent" : { "xmin" : -9816581.5295351669, "ymin" : 5125574.6394541971, "xmax" : -9809430.9094030354, "ymax" : 5130648.0893070986, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"VALVETYPE","field2":null,"field3":null,"fieldDelimiter":", ","defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"d92839513f81b3d83ca98865a8c0f744","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAttJREFUOI2t1F1IU2EYB/D/2dk5W/tybup0usyVDjWTwA9QEQ0kFwhOcmC6bNCNF3pVOPVCLOhCxIskjQILhkKCMrA0DVd008fQMFC3CEzzA61M2Nz0zG1dxI4dW1LQc/W8z8P7g+fh5eXjPwX/iN6JsrJMU1ycqgiANBAIrk1Ovn+8tbU1DMD9N5DIZDp3PzVVU2o0lsYlJsaSNE3B4/HC6Vw+39//5Mba2tdb4+PTd4+CZCZT2au2tto0ne44p6dQyFBQcFqSn58hGR5+eSs6WpEzOPjsakTIbNaPtreb0pOT44lf68FgCDzezxJJ8mA0lkQTBC4ShH92YOBFDwcyGAr0en3u2TASDAZht8/A4ViAQECDYfZhMBRDp9MAAKqqiqOmpqbbADwE4GYhjUbVUV6eJw2fh4aeQ6tVw2KpA0EQYJh9WK1PAQA6nQYkyYPZrI/xen2XrVb7HRYSCPjJUqkIALC97YHb7UVeXjo7Hk3zYTKVo7v7ESyWWgBAamoSqVIpDQAOIJFIKAjnm5vfkZmZgsNB03zQNJ/dmUQiQiCwH8/ZUSAQDIVziUQEp3PpNygUCmFvj2EXzzB+CAQCHwdiGL/H7w/IKYpEQoIC8/OLKCw8A6VSxkIOhxO5uQfjrq5+gUwmfMeBkpJiRmZnPzbl5OhAEAQaGqrQ1zeCjIwUxMTIMTe3CKlUDKOxhIUmJt4yKysbXRyoqan3emvrpSvp6ckysViIqCgxmpvrsL6+BY/Hi+rqUsjlEhZxuT7D691709s7/oEDAWCysk7W9PSM2BobqyixWAiCIKBWKwEoObtaWtqA1Tr+zefz6cM1zsuuqbk5ZrO1Gzs7BwYrKoqOZWefAkWRbN/t9sJun8HCwuKntDR1fn19905ECAAqKztso6NdsS7X8r2xsdcXaJonJUmKt7vL+CmK3NBqE7taWh7cPnwv4jdSUXFtB0BtpN6f4qj/6J/iB2g48SSRCw7GAAAAAElFTkSuQmCC","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"Ball","label":"Ball","description":""},{"symbol":{"type":"esriPMS","url":"ec2669f25bd5011ce8be7ca544df2846","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAodJREFUOI2t1F9IU1EcB/Dv3O7u/jEZ/lm20ZJgpg8l5VomCjXaZnhRGVzczFwwBr3oS0+mNNFeJITCRtCFJlIwX5xMtFH5VjARFBQrDcUeKhoOxvTq3XXZQ2x4dY2Cfk/3nt+5n3PO73c5EvynkOTJnW5srG6tra3Wy+USaSyW2GaYtyvxeDwEIPk3kKK7u7Wfpq82mM2VF8RicXZOX597a2rqvWt8/E1wYiIayAeph4a8Y11dDjtJEtKjK6hU8qK2Nou9vv58ZVnZC6PfP9mTE/L5OkaMRj0FQJTnyNDpig09Pa5bLJtaDwRmGAHkcFyxu903bAqFTMQwYXg8FEiSyIOV6JqbL7sDgZkggGQWslpNboNBWwoANG0Bw4TR0WHHxsZXEASBigo9xGKxALNaay51dl5rHx2dfZqF9HqtMfNcUlKIpqY6lJY6wHEcAKC31wWf77YAUyjkhMlUaRJAMplUc3i1zc3vWQQABgdfwum8jqoqg2BXGo1aI6jRwcHP9OEJPL9/rC48zx8bS6eRFkDJ5O4PAGcy7zU1Z2GzVSMSWQQAkCSJ8vKTR5A0trbi3wRQLBZ/t729W6tSyQEAhYVKBIMDmJ//CIKQwGA4gbGxV4JuLi9vJtfWvowIIK/30T2ttoimqLpTIpEoi1ksF7M7yHTT46EAAAsLn2b9/plVAQQgxbL8nbm5D+Nmc5XyWDHwu5s0bUEkEsXeHv95aWm1PZMT/NlO58B0KHT/5vR09FlDw7nizDEPB8elwLLcYiq1axsentzJCQFAS0t/KBx++DoSiT5Rq5X1SqVMV1BQIOX5/WQiwa6zLPfc6Xzw+Oh3Oa8Rirq7A8CdK/enyHcf/VP8AmIc2OQ5JjDAAAAAAElFTkSuQmCC","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"Butterfly","label":"Butterfly","description":""},{"symbol":{"type":"esriPMS","url":"d97da3027da072febe368e1645ef2258","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAApBJREFUOI2t1F1IU2EYB/C/Zx/ubHMwtcaatEgQtAslWmuFQQU6s6FiiFNruxKCUC+60ZCU6EZCKWyECR2JCEVww6UXlXmhw3mjNjWcMuZXaQdPxXRjmye7KA+ebUlBz9U55/k/v/fl5fAK8Z9KeEjvRFFRXpnBkJdBkkIxTX/f7u5+N88wjB1A4G8gaX19WWtFxaWLen32aYFAwGWam61bTqerqq/vbe/AgJs6DFK0tdW+qKsrNyYni8QAEApFQJJiAIBcTqZVVl4x5ufnZqvVL7NsNkdTQqil5UZnQ8P1ayKRkNj/trCwgszMY0hJkXI5jSZd29RUdTMYjPgoaribB5WXnzdarVcLDyIA4PWuQiwWISdHy9u6RnNEU1JyzkpRw70AAhxUUKCzarWqo7EH5nbPQyaTxEG/Zs6ctVguV/f0jDzloIwMVVZsMByOgqKcSE1NQXGxIQ6SSkmRTpet40ESiVgZG1xfp8EwYfT3v0djYw0IgoiNQKlUKIEDZ7S394ONDfl8nwAA09PL2Nz8CrU6LQ5iWbA8KBAIfQGQeTA0M7PEPfv9G3EQy7LY2mI+8yCaZsa3t0MGuZz8vcM9OJ3j3JDXuwqD4RQPmp1dDiwurnTyoNraR3dVqrQKk+nC8aSkJND0N4yOznFDLtccLBYj9x4ORzE1tTBisw17eRCASDAYvTU5+bFPr8+R+f0bvNW7ul6jo+M2pNJkRKO7cDjGljweb/V+n/dnm833h+z2ezVDQ+5nubkn0/3+VzxMIBBgbY3G2NiH6UgkVNje7thJCAFAaWmrfXDw4ZuJibknCoUsXyaTaAiCEEejuwGPx+cLBsPPzeYHj2PnEl4jJtOdHQDWRL0/1WH30T/VT/xg66omM9s1AAAAAElFTkSuQmCC","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"Cone","label":"Cone","description":""},{"symbol":{"type":"esriPMS","url":"59817dae28138d36f7925e6cb73a6168","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAsNJREFUOI2t1F1Ik1EYB/C/29z2brwp0+Vsw2kpGbFG5Ez8gGDOKW5DEy+WmyGzO+0qLLww2VVfRLBUFC/Udy96UbpQUacI5Qd2IeouBBOSQnYRc46xTPehXYiTdy4p6Lk8zzm/c57nHA4H/yk45+TkWu11c2pqWjEAMhI5dDudrjGv1/seQOBvIMJs1nYrlZl3DIbiSzKZmM3lchAI/MLGxndtf//k060t9/OJieXu8yCytrZkpa3NJM/OljJySUlC5OdfI1WqXJKmZ56JRKI8mp5+EBdqaKgYs1jKLy8suBKystLBZrPOHNfv38Purj/ZYCioZbEiaxQ1+5YB1dQUlut0t28WFSkSMjMlsNudMJnKGJjPFwBFTcFi0YEguElLS+tPAPQBCEQhmSzNqtGoSACQSsUoLb0Fmnairu4Y8/kCGBiYRGOjHgIBDwBgNKolHs9uPUXNdkYhHi8xgySJ6O5SqRhq9TFWWVkImnYyEADIyZGxJZKUagCnkEBA8GP7IZWKoVRmo7r6McbHXzMQABAKCYTDYQmjR0dHh0exkNfrx/y8C729rRge/nimZ8FgCATB22dAoVDIH4kcJp9M9Hr9GBycgcWiA5/PhUDAh90+BZNJG8Xc7h2QpHCFAaWnixzr698eKhRZ2NnxY2joFDm+DDHU6jxQ1BTM5jKw2WzMza0dbG//fMmAmps7H1mt9+tTUsjkkZFPsFj04PMTGaXKZGJoNCpQlBMlJTfg8fg+d3QMbTIgAKGcHPm9pqY3Y319raxY5PQCUqFQXIHN9s4nEHArTsYZL9totE44HO13u7octF5fJMzNzQCLlRDN7++HsLjowvLy5leV6mqByfRiLy4EAFVV7R+mp20XV1e/9IyOLlQIhfwLHA6LHQyGD4LB8A+5XPKqpaXHFrsu7jei0TTvATDFre0Pcd5/9E/xGy0A7cQupy9IAAAAAElFTkSuQmCC","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"Gate","label":"Gate","description":""},{"symbol":{"type":"esriPMS","url":"ddfc79c8d936f8384108743275a6326d","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAidJREFUOI2t1EFoUnEcB/DvG1asmRt5cEagq9MOKwlGbWA9QnFDEpxvc+qtwTrMU/DwydZ0G7NOu3TKpClbkgPxMB6DHVIQhDEoKCqDBtMdVhak1Bak899hPLe3ZwrR9/b//eBz+PLjL8N/iqze0GajNSbT1cft7eeok7t8vvCVZYP3AJQbQlYrrbXb9QmGoXUURaFY/ImODnltv7f3ixwcVJUcF2KOYyLI5dJfslj0CYahr1AUhVzuC+z2B/D7xzAwcB0A0NbWSrnd1jsA4hwXsglYDXI69ZctFjoxPEz3HEc2Nj5hcNCLtbWHImxiwmomBHGv9xCrQQbDjbiA5PNHiJCTmFze2uJ2W80UhSccF7pbg7Ra1flDpACHwy9CGmEajUop6WhnpwCHw4dM5qME+RsmKXt39/sZn+9pQ6QRVoOSyVeKdLo5ImRhIYb+/h4pNDJy65tWq7o4NRVuihiNOoTDk1Aozkqh/f3fZZZ1AgAaYUajDpHIJNRqJQghKJV+iKHNzfePurouzLCss7NaJZiejjRFYrHUG55/fV8Ezc+/CBLSUhkdvT3v8bg6AYgwk0mHxcUjZGUl9TYaTQ2trqa3RBAABALRZzLZqSrD3Ax4PC41IYDPF6mDJN8tLb0c4vnMlqQjIbOzkTAhlUpvb/dMX1/36fFxs9JguFbKZnPlbDaH7e3PxfX1Dzaez4gutu43Mjf3fBnAsvAOBvn6zTeD/iV/AIg57kv7AlGIAAAAAElFTkSuQmCC","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"Plug","label":"Plug","description":""}]},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "VALVETYPE", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSTALLDATE", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LOCDESC", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ROTATION", "type" : "esriFieldTypeDouble", "alias" : "Rotation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DIAMETER", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 } ] }, "defaultValue" : null }, { "name" : "VALVETYPE", "type" : "esriFieldTypeString", "alias" : "Valve Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piSystemValveType", "codedValues" : [ { "name" : "Ball", "code" : "Ball" }, { "name" : "Butterfly", "code" : "Butterfly" }, { "name" : "Cone", "code" : "Cone" }, { "name" : "Gate", "code" : "Gate" }, { "name" : "Plug", "code" : "Plug" }, { "name" : "Roundway", "code" : "Roundway" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "BYPASSVALVE", "type" : "esriFieldTypeSmallInteger", "alias" : "Bypass Valve", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "CLOCKTOCLOSE", "type" : "esriFieldTypeSmallInteger", "alias" : "Clockwise To Close", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "NORMALLYOPEN", "type" : "esriFieldTypeSmallInteger", "alias" : "Normally Open", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "TURNSTOCLOSE", "type" : "esriFieldTypeInteger", "alias" : "Turns To Close", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OPERABLE", "type" : "esriFieldTypeSmallInteger", "alias" : "Operable", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "HYDRFLAG", "type" : "esriFieldTypeSmallInteger", "alias" : "Hydrant Valve", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "CURROPEN", "type" : "esriFieldTypeSmallInteger", "alias" : "Currently Open", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "ENABLED", "type" : "esriFieldTypeSmallInteger", "alias" : "Enabled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "ACTIVEFLAG", "type" : "esriFieldTypeSmallInteger", "alias" : "Active Flag", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "OWNEDBY", "type" : "esriFieldTypeSmallInteger", "alias" : "Owned By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetOwner", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "MAINTBY", "type" : "esriFieldTypeSmallInteger", "alias" : "Managed By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetManager", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "LASTUPDATE", "type" : "esriFieldTypeDate", "alias" : "Last Update Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LASTEDITOR", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__WaterDis__F4B70D85E8EEB71D", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_12861.WaterDistributionNetwork_System_Valve_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "Ball", "name" : "Ball", "domains" : { "DIAMETER" : {"type" : "inherited"}, "VALVETYPE" : {"type" : "inherited"}, "BYPASSVALVE" : {"type" : "inherited"}, "CLOCKTOCLOSE" : {"type" : "inherited"}, "NORMALLYOPEN" : {"type" : "inherited"}, "OPERABLE" : {"type" : "inherited"}, "HYDRFLAG" : {"type" : "inherited"}, "CURROPEN" : {"type" : "inherited"}, "ENABLED" : {"type" : "inherited"}, "ACTIVEFLAG" : {"type" : "inherited"}, "OWNEDBY" : {"type" : "inherited"}, "MAINTBY" : {"type" : "inherited"} }, "templates" : [ { "name" : "Ball", "description" : "Ball System Valve, Diameter is set from Attribute Assistant.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "VALVETYPE" : "Ball", "BYPASSVALVE" : 0, "CLOCKTOCLOSE" : 1, "NORMALLYOPEN" : 1, "OPERABLE" : 1, "HYDRFLAG" : 0, "CURROPEN" : 1, "LASTEDITOR" : null, "FACILITYID" : null, "INSTALLDATE" : null, "LOCDESC" : null, "ROTATION" : null, "DIAMETER" : null, "TURNSTOCLOSE" : null, "ENABLED" : null, "ACTIVEFLAG" : null, "OWNEDBY" : null, "MAINTBY" : null, "LASTUPDATE" : null } } } ] }, { "id" : "Cone", "name" : "Cone", "domains" : { "DIAMETER" : {"type" : "inherited"}, "VALVETYPE" : {"type" : "inherited"}, "BYPASSVALVE" : {"type" : "inherited"}, "CLOCKTOCLOSE" : {"type" : "inherited"}, "NORMALLYOPEN" : {"type" : "inherited"}, "OPERABLE" : {"type" : "inherited"}, "HYDRFLAG" : {"type" : "inherited"}, "CURROPEN" : {"type" : "inherited"}, "ENABLED" : {"type" : "inherited"}, "ACTIVEFLAG" : {"type" : "inherited"}, "OWNEDBY" : {"type" : "inherited"}, "MAINTBY" : {"type" : "inherited"} }, "templates" : [ { "name" : "Cone", "description" : "Cone System Valve, Diameter is set from Attribute Assistant.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "VALVETYPE" : "Cone", "BYPASSVALVE" : 0, "CLOCKTOCLOSE" : 1, "NORMALLYOPEN" : 1, "OPERABLE" : 1, "HYDRFLAG" : 0, "CURROPEN" : 1, "LASTEDITOR" : null, "FACILITYID" : null, "INSTALLDATE" : null, "LOCDESC" : null, "ROTATION" : null, "DIAMETER" : null, "TURNSTOCLOSE" : null, "ENABLED" : null, "ACTIVEFLAG" : null, "OWNEDBY" : null, "MAINTBY" : null, "LASTUPDATE" : null } } } ] }, { "id" : "Plug", "name" : "Plug", "domains" : { "DIAMETER" : {"type" : "inherited"}, "VALVETYPE" : {"type" : "inherited"}, "BYPASSVALVE" : {"type" : "inherited"}, "CLOCKTOCLOSE" : {"type" : "inherited"}, "NORMALLYOPEN" : {"type" : "inherited"}, "OPERABLE" : {"type" : "inherited"}, "HYDRFLAG" : {"type" : "inherited"}, "CURROPEN" : {"type" : "inherited"}, "ENABLED" : {"type" : "inherited"}, "ACTIVEFLAG" : {"type" : "inherited"}, "OWNEDBY" : {"type" : "inherited"}, "MAINTBY" : {"type" : "inherited"} }, "templates" : [ { "name" : "Plug", "description" : "Plug System Valve, Diameter is set from Attribute Assistant.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "VALVETYPE" : "Plug", "BYPASSVALVE" : 0, "CLOCKTOCLOSE" : 1, "NORMALLYOPEN" : 1, "OPERABLE" : 1, "HYDRFLAG" : 0, "CURROPEN" : 1, "LASTEDITOR" : null, "FACILITYID" : null, "INSTALLDATE" : null, "LOCDESC" : null, "ROTATION" : null, "DIAMETER" : null, "TURNSTOCLOSE" : null, "ENABLED" : null, "ACTIVEFLAG" : null, "OWNEDBY" : null, "MAINTBY" : null, "LASTUPDATE" : null } } } ] }, { "id" : "Gate", "name" : "Gate", "domains" : { "DIAMETER" : {"type" : "inherited"}, "VALVETYPE" : {"type" : "inherited"}, "BYPASSVALVE" : {"type" : "inherited"}, "CLOCKTOCLOSE" : {"type" : "inherited"}, "NORMALLYOPEN" : {"type" : "inherited"}, "OPERABLE" : {"type" : "inherited"}, "HYDRFLAG" : {"type" : "inherited"}, "CURROPEN" : {"type" : "inherited"}, "ENABLED" : {"type" : "inherited"}, "ACTIVEFLAG" : {"type" : "inherited"}, "OWNEDBY" : {"type" : "inherited"}, "MAINTBY" : {"type" : "inherited"} }, "templates" : [ { "name" : "Gate", "description" : "Gate System Valve, Diameter is set from Attribute Assistant.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "VALVETYPE" : "Gate", "BYPASSVALVE" : 0, "CLOCKTOCLOSE" : 1, "NORMALLYOPEN" : 1, "OPERABLE" : 1, "HYDRFLAG" : 0, "CURROPEN" : 1, "LASTEDITOR" : null, "FACILITYID" : null, "INSTALLDATE" : null, "LOCDESC" : null, "ROTATION" : null, "DIAMETER" : null, "TURNSTOCLOSE" : null, "ENABLED" : null, "ACTIVEFLAG" : null, "OWNEDBY" : null, "MAINTBY" : null, "LASTUPDATE" : null } } } ] }, { "id" : "Butterfly", "name" : "Butterfly", "domains" : { "DIAMETER" : {"type" : "inherited"}, "VALVETYPE" : {"type" : "inherited"}, "BYPASSVALVE" : {"type" : "inherited"}, "CLOCKTOCLOSE" : {"type" : "inherited"}, "NORMALLYOPEN" : {"type" : "inherited"}, "OPERABLE" : {"type" : "inherited"}, "HYDRFLAG" : {"type" : "inherited"}, "CURROPEN" : {"type" : "inherited"}, "ENABLED" : {"type" : "inherited"}, "ACTIVEFLAG" : {"type" : "inherited"}, "OWNEDBY" : {"type" : "inherited"}, "MAINTBY" : {"type" : "inherited"} }, "templates" : [ { "name" : "Butterfly", "description" : "Butterfly System Valve, Diameter is set from Attribute Assistant.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "VALVETYPE" : "Butterfly", "BYPASSVALVE" : 0, "CLOCKTOCLOSE" : 1, "NORMALLYOPEN" : 1, "OPERABLE" : 1, "HYDRFLAG" : 0, "CURROPEN" : 1, "LASTEDITOR" : null, "FACILITYID" : null, "INSTALLDATE" : null, "LOCDESC" : null, "ROTATION" : null, "DIAMETER" : null, "TURNSTOCLOSE" : null, "ENABLED" : null, "ACTIVEFLAG" : null, "OWNEDBY" : null, "MAINTBY" : null, "LASTUPDATE" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 4, "name" : "Control Valve", "type" : "Feature Layer", "serviceItemId" : "bac6062b352d4035ba73367b7a6c6542", "cacheMaxAge" : 30, "displayField" : "FACILITYID", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 5000, "maxScale" : 0, "extent" : { "xmin" : -9812286.7478926275, "ymin" : 5127030.4318053182, "xmax" : -9809838.39874079, "ymax" : 5129209.1940296991, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"15c79b7ecb8688a5d0ddd32109fda6e1","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAArVJREFUOI2t1F1Ik2EUB/D/u2/Zpjnd1K0xRzrLOVsik5TCDTUVUiRUTCzEEIqhXezGC/HCoLCbiC6E3IV32SyL0pCJGn4VFC5tVORCDTW/3jV06evm1oVtTHHqpHP5nOf8OOfh8DDwn4MRLGE2m2kztIlba461UhfllrE4TMYJAZ+UJUjfisRRRiWhsxwZbGqrN3QMGJtUmjO8RKUcvHAuPB4PyKXfksE3oyoChH5g3tQnihPWKIns2YNAZm1jZQ+Pz9fdbCygsTjMXUmhOApJ6lOwLzvwzNido72cNTnp7ctTETnv9wWv6otNFy5pdOqsFFqwpwCASGEEqg3l6Gh9GU6jEb1W72Cqr1M/mJGdVJKcrjgU8wWdQUdpbRFa77RHVBsqWgEUBoKEQBzXkl+m4x8F8wWTxUBRZR7GhycLrN5+tZLQWRgAIBAI0jN0aRx2GCsUDwAgU0jR83QAF/MzSgHsgCRJZqZqkiNC1gCAAOIVUqwu27OAfyOz2Wzxtwkbb3lh5Vjm7I85qNJPC/0gAJcsUUJJZLGc44AO+zoYLPq6H6Qoyrbh3FwQxETKjwNu/NmEIDryY2CH/ebnQw0a7bmQMbdrG26XC6ww5otAcObDsOX70txKrEgSHdLqjI9MIO28aioFOnMgiCnLjOGe4VF3S3sjn8GiHwmzrzhg+zrtKastriIIwrsLBPDF/GSo4YH08d365htyJjvoR+THOtteeUuu5+vP0nPf+c73VnW03zc556d/PaxrrhHFK6RcELsvbLu38WnMCsvI5428K9prWnF5Z2B+vzZem01DY85VsilGfrJInakKi5MKIwAva256cWvh56JTkZrQVViRrc+Nr9rcWxxsrtXRfmsdYL3dZeyVs9lsMZfL3SJJ0gbgwO0/+KEADwAbRVE2iqIOuboTfwH4yuo6n1r9OAAAAABJRU5ErkJggg==","contentType":"image/png","width":15,"height":15,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "INSTALLDATE", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LOCDESC", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DIAMETER", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 } ] }, "defaultValue" : null }, { "name" : "VALVETYPE", "type" : "esriFieldTypeString", "alias" : "Valve Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piControlValveType", "codedValues" : [ { "name" : "Altitude", "code" : "Altitude" }, { "name" : "Blowoff", "code" : "Blowoff" }, { "name" : "Combination", "code" : "Combination" }, { "name" : "Vacuum", "code" : "Vacuum" }, { "name" : "Air Control", "code" : "Air Control" }, { "name" : "Air Gap", "code" : "Air Gap" }, { "name" : "Air Release", "code" : "Air Release" }, { "name" : "Atmospheric Vacuum", "code" : "Atmospheric Vacuum" }, { "name" : "Backflow Control", "code" : "Backflow Control" }, { "name" : "Double Check", "code" : "Double Check" }, { "name" : "Pressure Vacuum", "code" : "Pressure Vacuum" }, { "name" : "Pressure Reducer", "code" : "Pressure Reducer" }, { "name" : "Simple Check", "code" : "Simple Check" }, { "name" : "Vacuum Breaker", "code" : "Vacuum Breaker" }, { "name" : "Vacuum Release", "code" : "Vacuum Release" }, { "name" : "Surge Relief", "code" : "Surge Relief" }, { "name" : "Snubber", "code" : "Snubber" }, { "name" : "CLA", "code" : "CLA" }, { "name" : "Reduced Pressure Zone", "code" : "RPZ" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__WaterDis__F4B70D854B36691C", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_12861.WaterDistributionNetwork_Control_Valve_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Air Release Control Valve", "description" : "An Air Release Water Control Valve, the diameter is set from the intersecting with a rule in the Attribute Assistant.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DIAMETER" : null, "VALVETYPE" : "Air Release", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "Reduced Pressure Zone Control Valve", "description" : "A Reduced Pressure Zone Control Valve, the diameter is set from the intersecting with a rule in the Attribute Assistant.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DIAMETER" : null, "VALVETYPE" : "RPZ", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "Snubber Control Valve", "description" : "A Snubber Zone Control Valve, the diameter is set from the intersecting with a rule in the Attribute Assistant.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DIAMETER" : null, "VALVETYPE" : "Snubber", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "Pressure Reducer Control Valve", "description" : "A Pressure Reducer Control Valve, the diameter is set from the intersecting with a rule in the Attribute Assistant.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DIAMETER" : null, "VALVETYPE" : "Pressure Reducer", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "Simple Check Control Valve", "description" : "A Simple Check Zone Control Valve, the diameter is set from the intersecting with a rule in the Attribute Assistant.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DIAMETER" : null, "VALVETYPE" : "Simple Check", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "(Empty Values)", "description" : "A Water Control Value with no values set. The diameter is set from the intersecting with a rule in the Attribute Assistant.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DIAMETER" : null, "VALVETYPE" : null, "INSTALLDATE" : null, "LOCDESC" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 5, "name" : "Curb Stop Valve", "type" : "Feature Layer", "serviceItemId" : "bac6062b352d4035ba73367b7a6c6542", "cacheMaxAge" : 30, "displayField" : "FACILITYID", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 2000, "maxScale" : 0, "extent" : { "xmin" : -9816596.3183451146, "ymin" : 5125639.21189391, "xmax" : -9809407.1332273446, "ymax" : 5130602.933646176, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"fd34047e69a17094627e06a29ad98143","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAA2RJREFUOI2t1G9IU3sYB/DvOXNtZ51yhf0Fl1HjGixcEC3WWjqy0iwp3J1zZotWZivU1IqB1goqtFq73iGba6VRXL1QrRVmvggMBaXQiJY2IyNzw+EfLrvSNo1eOTpOJaLn5Xm+z+f8fr8XTwx+c8XM0WMBSE9NFe/n8XjiiYlJKiaGNeLzDbd5PP57IyMjXT8NcjgcmVy+7p/BwdEVWVnbSKEwHlwuB4HAOF6+7NlsNN4q3bNH0upydagBDM4JpqVJdN3d3TaVSkFkZspBUWxGXyoVEWr1Dty40ShPTv6jt7f3P6nX630zIygWr9rldnusubl7CZ3uOnS663O8CGAwZNMk+abd6/UKAfimg/P5/EUNZnMhKZGIAABVVf/OijU0lEOpTIbJ1EgLBCsbb99ukTNApXKrPjaWpmWyJJAkgfJyLYaGxlBX1xKFWSwnkJWVDIIgoNWmQShUyQAkAuiJgDTNO6xSpZAkSQAAFiygcPXqcfh8fjQ3d0ew8+cP4MiRTEzlFi9eiFOn1ITfP1pgNjsLI2BfX3/C6tUrGCeJi4uFzXYG6eln8fbtJ+j1mTh9WgM2m8XIJSWtRWvraynjyp2d/WyK4kZdTyBYhurqk1AoSlFRkQeKmheV4fG4CIUmFjFAkSj+WygUZk0Pj40FUF19HwBQX9+M4uI/wWKRjEwwGAZFcYIMcMMG4fDAgH9pQsLySHB8PAiDoRYPHrQDAMrKbFiyhI+8vJ0gCCKS83g+g8+n3zPANWuWPX/2rFMlk60HAITDk6isvIeaGhfjNFptJeLi+Ni9e3PkpzbbE2g0qQ4G+OHDl9Kuro/K7OztZGKiALW1ThiNd6LeCwAyMgxoa/sLUqkIjx+3IyVFPGww2F0M0G5vGTCZCqxFReYCpTIFev3fM2JTpVCUweEoQVXVXRQVqXMBJxggABQX1xy/di1//dGjJpnDUQq5PGlGLBSahN3uwoULt1BRccio0Vx6OtWLWg4lJdatVmthvcXyMNft/khkZGxBfPxScDhsBAJf0dc3gJs3n4CmueFz53THcnIuOn6cn3F95eeb8+rqzl4OBkMWp/PFpo4ON6+np5+QSETfNm5MHN23T/5oaCh0Mifn4v/TZ2ddsAcPXnkHQPHjt6amV2hqejXbyNzgr9Z3UScoTUhQ6LIAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "INSTALLDATE", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LOCDESC", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DIAMETER", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 } ] }, "defaultValue" : null }, { "name" : "VALVETYPE", "type" : "esriFieldTypeString", "alias" : "Valve Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piSystemValveType", "codedValues" : [ { "name" : "Ball", "code" : "Ball" }, { "name" : "Butterfly", "code" : "Butterfly" }, { "name" : "Cone", "code" : "Cone" }, { "name" : "Gate", "code" : "Gate" }, { "name" : "Plug", "code" : "Plug" }, { "name" : "Roundway", "code" : "Roundway" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "NORMALLYOPEN", "type" : "esriFieldTypeSmallInteger", "alias" : "Normally Open", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "TURNSTOCLOSE", "type" : "esriFieldTypeInteger", "alias" : "Turns To Close", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OPERABLE", "type" : "esriFieldTypeSmallInteger", "alias" : "Operable", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "CURROPEN", "type" : "esriFieldTypeSmallInteger", "alias" : "Currently Open", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__WaterDis__F4B70D8595CB24EC", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_12861.WaterDistributionNetwork_Curb_Stop_Valve_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Roundway", "description" : "Roundway Curb Stop Valve, Diameter is set by Attribute Assistant.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DIAMETER" : null, "VALVETYPE" : "Roundway", "NORMALLYOPEN" : 1, "OPERABLE" : 1, "CURROPEN" : 1, "LOCDESC" : null, "INSTALLDATE" : null, "TURNSTOCLOSE" : null } } }, { "name" : "(Empty Values)", "description" : "Curb Stop Valve, Diameter is set by Attribute Assistant.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DIAMETER" : null, "VALVETYPE" : null, "NORMALLYOPEN" : 1, "OPERABLE" : 1, "CURROPEN" : 1, "LOCDESC" : null, "INSTALLDATE" : null, "TURNSTOCLOSE" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 6, "name" : "Water Pumps", "type" : "Feature Layer", "serviceItemId" : "bac6062b352d4035ba73367b7a6c6542", "cacheMaxAge" : 30, "displayField" : "NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -14842598.772436475, "ymin" : -30240971.958386172, "xmax" : -4823844.6010418683, "ymax" : 30240971.958386205, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"0d863bd15305c892d8f7823d47a6818d","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAPCAYAAADgbT9oAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAQRJREFUOI2t0L8rxHEYwPEX943OIcmPk58lxCCFgRhMShaDjfViNfgjDP4AFoNdyp8g64XlRCmXHBaJ0jllQI7Bycd7e+p5Xn36RD6b9X/tRUXDqq3D3iDu6fHU0nj0Hb7QMzgZBJPBNUQlFv9cafgmSyZNcyt9wxwfkH9ieAplAfDtJUMTnKS5OqcyTl0juQuSnQEwJGpJdlB4JpdlbJry2I8nv4N3NognmFnkpcD2OvPLVNcFwnMpYhF3NzS1s7DC2RH9o4HwRxVx9vdoaKGt+8fV0nDXALH3/6yqYWSKfP7t5UFwovbrXJ8sefI7+I8Vw5N2N8O0h/sB5L/DndZSYXBRrxMYNZ4vmMeZAAAAAElFTkSuQmCC","contentType":"image/png","width":16,"height":11,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "Facility ID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "INSTALLDATE", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "PUMPTYPE", "type" : "esriFieldTypeString", "alias" : "Pump Type", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wPumpType", "codedValues" : [ { "name" : "Axial Flow", "code" : "Axial Flow" }, { "name" : "Centrifugal", "code" : "Centrifugal" }, { "name" : "Jet", "code" : "Jet" }, { "name" : "Reciprocating", "code" : "Reciprocating" }, { "name" : "Rotary", "code" : "Rotary" }, { "name" : "Turbine", "code" : "Turbine" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "LOCDESC", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ELEVATION", "type" : "esriFieldTypeDouble", "alias" : "Elevation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INLETDIAM", "type" : "esriFieldTypeDouble", "alias" : "Inlet Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 } ] }, "defaultValue" : null }, { "name" : "DISCHDIAM", "type" : "esriFieldTypeDouble", "alias" : "Discharge Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 } ] }, "defaultValue" : null }, { "name" : "RATEDFLOW", "type" : "esriFieldTypeString", "alias" : "Rated Flow", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RATEDPRESS", "type" : "esriFieldTypeString", "alias" : "Rated Pressure", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DYNHEAD", "type" : "esriFieldTypeString", "alias" : "Total Dynamic Head", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SHUTHEAD", "type" : "esriFieldTypeDouble", "alias" : "Shutoff Head", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DESHEAD", "type" : "esriFieldTypeDouble", "alias" : "Design Head", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MAXOPHEAD", "type" : "esriFieldTypeDouble", "alias" : "Max Operating Head", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NAME", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DESIGNGPM", "type" : "esriFieldTypeDouble", "alias" : "Design GPM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MAXOPDISC", "type" : "esriFieldTypeDouble", "alias" : "Max Operating Discharge", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__WaterDis__F4B70D859A898590", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_12861.WaterDistributionNetwork_Water_Pumps_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Centrifugal", "description" : "Centrifugal Water Pump", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "PUMPTYPE" : "Centrifugal", "DESIGNGPM" : null, "NAME" : null, "MAXOPHEAD" : null, "DESHEAD" : null, "MAXOPDISC" : null, "SHUTHEAD" : null, "INSTALLDATE" : null, "LOCDESC" : null, "ELEVATION" : null, "INLETDIAM" : null, "DISCHDIAM" : null, "RATEDFLOW" : null, "RATEDPRESS" : null, "DYNHEAD" : null } } }, { "name" : "Jet", "description" : "Jet Water Pump", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "PUMPTYPE" : "Jet", "DESIGNGPM" : null, "NAME" : null, "MAXOPHEAD" : null, "DESHEAD" : null, "MAXOPDISC" : null, "SHUTHEAD" : null, "INSTALLDATE" : null, "LOCDESC" : null, "ELEVATION" : null, "INLETDIAM" : null, "DISCHDIAM" : null, "RATEDFLOW" : null, "RATEDPRESS" : null, "DYNHEAD" : null } } }, { "name" : "(Empty Values)", "description" : "Water Pump with no values set.", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "PUMPTYPE" : null, "DESIGNGPM" : null, "NAME" : null, "MAXOPHEAD" : null, "DESHEAD" : null, "MAXOPDISC" : null, "SHUTHEAD" : null, "INSTALLDATE" : null, "LOCDESC" : null, "ELEVATION" : null, "INLETDIAM" : null, "DISCHDIAM" : null, "RATEDFLOW" : null, "RATEDPRESS" : null, "DYNHEAD" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 7, "name" : "Network Structures", "type" : "Feature Layer", "serviceItemId" : "bac6062b352d4035ba73367b7a6c6542", "cacheMaxAge" : 30, "displayField" : "NAME", "description" : "Water Network Structures such as treatment plants and pump stations. \t", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -9811781.99011854, "ymin" : 5127618.0692668753, "xmax" : -9811056.1396066267, "ymax" : 5128155.3578838594, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"STRUCTTYPE","field2":null,"field3":null,"fieldDelimiter":", ","defaultSymbol":{"type":"esriPMS","url":"f33b7ab95e3ca93da9adc4b44b263cc5","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAASCAYAAABfJS4tAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAARRJREFUOI3t0CFLQ2EUxvH/mfc67sBpnDCUBZNBZH4KnUkMBuv1awjGJZO4YLDY3QwGLTIQ5SJqmGAQRaYgaBEMu/ceg0582XDeV9Z80uGB9/cejkOf4rQHVS2q6jwwaouJSEVEAgMGVm/epGSLZgYgl8ZX1RkRCb7DpY0nuD87toJnpyZZLgwBFAEDBuDu5IjpJT8R2gzqvL48wwcMmKcAYDDt4WWHE8GOl+nsem5zfkrYahndSH6MbC7/82e94Pr6GreHVaNb2N7/O2ybf/j38OLWbn9g23TAD1eXXB/sJUIeGxcwUegOq2qlPC5+eWfTYr+59hCEYVgz4FQqtRLHcc1C/UoURYHruk0D/sSr3Z8kzzsryUlW5tHj0wAAAABJRU5ErkJggg==","contentType":"image/png","width":16,"height":13,"angle":0,"xoffset":0,"yoffset":0},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"1d155206cad75c5e43e93e01d9f989d3","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAQCAYAAAAWGF8bAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAcVJREFUOI2tlE9IVFEchb+ZuXfeDOpkKegbQ0UiwYQ0lUKpRSIuYiqKAgVBgvDPQAvbCIIKLnUhSosUUcSdIIwRSOIqHEiakOgPjmBiMg80B8JcyDy6LpyGgqczDp3NPdx7z3fvb3MEccViMS9pSkoZ+eMFgFKqCngF6OkAlVKGaZrVUsqIiO/1A3rv5GxaP9RzL+gdvvqXgE/8fbAU/saNp11nBi5NDdPhqwfiIydkt2N3CKtMyrJM74Y/8aa/i8aBUeafP+Hu4Djz3e1cb/XzbmIENCeFVXXcetaD0+VODpQZWRjBRfYjW0RXg/z8vkk09BaXv5voapA7L2Z57X9E5eNWcoovJQc6M7IA2NtYB+DH5vEqPdkAHOztAmC32VIbWcs8BhqfP1DU+JCd8BcA3J5zAGyHlrnZO0xmfkFqQIeQ6LUNrAVmuN03yvJQH2ha4qFrLZ0UVtdaRa2BAHml5RjBRfKvVHAYNShquIfN4TjpenJgZUs7ZfebyC0tpzmwgnS50TznaQ6skH2x+OzAnJLLCe+9WmPpkwJ3vn5kbWHu1ICVfv/a/xdommabEOL9+tx0WuUAD0JKqbEEMF4/3v9RYUfxaX+VB9ZwPgAAAABJRU5ErkJggg==","contentType":"image/png","width":15,"height":12,"angle":0,"xoffset":0,"yoffset":0},"value":"Treatment Plant","label":"Treatment Plant","description":""},{"symbol":{"type":"esriPMS","url":"0227cd6c054abd65c431af24e7627774","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAhBJREFUKJGVk19IUwEUh797d73b7tiaN3UbG6xADbV0NtH+gNYIQrAIpBwRQQRhGtWDBCkY9iDicwn2KohED4VQVLYIwzdJStOalZEpM1m2Ze4unT1Ia6lhnrdz+H2c8zucI7F+SKqqFobDYZter49qmjYMzK0RrcpNbv+R5lzfvgp7mcemqFZLfCH2Y+blWOhzYGBsqKOrBQiuB2d5m+pv77lSW2a0mA0pdXVrznbXjmOHvba9npx3t7qaxvuH+lJh0dtY11PefKlibmKS9/efrvFhdjnYdaq6VBR17eP9l2uAoARQcOZ4bUnd6VKdLGN2OTCqVgCetXdQ3nAeQRQQ0lb65NUcLZ4ZGW0bbO2slgAyiwv8ZqfdBCArRmTFCIBBUTBmpCOKYnICUSfi2l9WNEinVQIw2TKc/9j6upGZl+3OPuAtkgDENFnZDKzTG6QtRR77ipGf8dhmYC0STXwPTU5IAPOz4SmWl7chCP8Ffxl+O/2m5+HgSuelxbbpFyN3HLt3yhuBsUiUrx8/PQcWJYDAxeu9vhstTyxOW6XJlpkU2vNzgT/TLMXjvO6+NzHQ0HoWUi4scOFalU6WH2WVFPocnnwBQSDvRFUSjE6FCPb2fUhokYPA/F8wkHh87uqhyp6bJ2dfjTYa0q1uSU4zJZYSWvxbZDquLdwN1DY1AInfwOrH4IG/vhvo3sg7wC+FWZ9giikktAAAAABJRU5ErkJggg==","contentType":"image/png","width":11,"height":11,"angle":0,"xoffset":0,"yoffset":0},"value":"Enclosed Storage Facility","label":"Enclosed Storage Facility","description":""}]},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "STRUCTTYPE", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSTALLDATE", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LOCDESC", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ROTATION", "type" : "esriFieldTypeDouble", "alias" : "Rotation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NAME", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OPDATE", "type" : "esriFieldTypeDate", "alias" : "Operational Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "STRUCTTYPE", "type" : "esriFieldTypeString", "alias" : "Structure Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wStructureType", "codedValues" : [ { "name" : "Enclosed Storage Facility", "code" : "Enclosed Storage Facility" }, { "name" : "Production Well", "code" : "Production Well" }, { "name" : "Pump Station", "code" : "Pump Station" }, { "name" : "Storage Basin", "code" : "Storage Basin" }, { "name" : "Treatment Plant", "code" : "Treatment Plant" }, { "name" : "Meter Station", "code" : "Meter Station" }, { "name" : "Other", "code" : "Other" } ] }, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__WaterDis__F4B70D855B97C65D", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_12861.WaterDistributionNetwork_Network_Structures_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "Treatment Plant", "name" : "Treatment Plant", "domains" : { "STRUCTTYPE" : {"type" : "inherited"}, "ENABLED" : {"type" : "inherited"}, "ACTIVEFLAG" : {"type" : "inherited"}, "OWNEDBY" : {"type" : "inherited"}, "MAINTBY" : {"type" : "inherited"}, "AncillaryRole" : {"type" : "inherited"} }, "templates" : [ { "name" : "Treatment Plant", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "STRUCTTYPE" : "Treatment Plant", "NAME" : null, "ROTATION" : null, "LOCDESC" : null, "INSTALLDATE" : null, "FACILITYID" : null, "OPDATE" : null } } } ] }, { "id" : "Enclosed Storage Facility", "name" : "Enclosed Storage Facility", "domains" : { "STRUCTTYPE" : {"type" : "inherited"}, "ENABLED" : {"type" : "inherited"}, "ACTIVEFLAG" : {"type" : "inherited"}, "OWNEDBY" : {"type" : "inherited"}, "MAINTBY" : {"type" : "inherited"}, "AncillaryRole" : {"type" : "inherited"} }, "templates" : [ { "name" : "Enclosed Storage Facility", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "STRUCTTYPE" : "Enclosed Storage Facility", "NAME" : null, "ROTATION" : null, "LOCDESC" : null, "INSTALLDATE" : null, "FACILITYID" : null, "OPDATE" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 8, "name" : "Main", "type" : "Feature Layer", "serviceItemId" : "bac6062b352d4035ba73367b7a6c6542", "cacheMaxAge" : 30, "displayField" : "FACILITYID", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 19000, "maxScale" : 0, "extent" : { "xmin" : -9816713.9843615387, "ymin" : 5125544.514651536, "xmax" : -9809230.9951091669, "ymax" : 5130683.977065092, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":4.5},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : true, "allowUpdateWithoutMValues" : true, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "INSTALLDATE", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "MATERIAL", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeMaterial", "codedValues" : [ { "name" : "ABS Plastic", "code" : "ABS" }, { "name" : "Asbestos Cement", "code" : "AC" }, { "name" : "Asphalt", "code" : "ASP" }, { "name" : "Brick", "code" : "BR" }, { "name" : "Cast Iron", "code" : "CAS" }, { "name" : "Clay Tile", "code" : "CT" }, { "name" : "Concrete (Non-Reinforced)", "code" : "CP" }, { "name" : "Concrete Segments (Bolted)", "code" : "CSB" }, { "name" : "Concrete Segments (Unbolted)", "code" : "CSU" }, { "name" : "Corrugated Metal", "code" : "CMP" }, { "name" : "Copper", "code" : "COP" }, { "name" : "Cured In Place", "code" : "CIPP" }, { "name" : "Ductile Iron", "code" : "DIP" }, { "name" : "Fiberglass Reinforced", "code" : "FRP" }, { "name" : "Earth & Geotextile", "code" : "EARGEO" }, { "name" : "Earthen", "code" : "EAR" }, { "name" : "Geotextile", "code" : "GEO" }, { "name" : "Galvanized Pipe", "code" : "GP" }, { "name" : "Glass Reinforced Cement", "code" : "GRC" }, { "name" : "Pitch Fiber (Orangeburg)", "code" : "OB" }, { "name" : "Plastic/Steel Composite", "code" : "PSC" }, { "name" : "Polyethylene", "code" : "PE" }, { "name" : "Polypropylene", "code" : "PP" }, { "name" : "Polyvinyl Chloride", "code" : "PVC" }, { "name" : "Pre-Stressed Concrete Cylinder", "code" : "PCCP" }, { "name" : "Reinforced Concrete", "code" : "RCP" }, { "name" : "Reinforced Plastic (Truss)", "code" : "RPM" }, { "name" : "Segmented Block", "code" : "SB" }, { "name" : "Steel", "code" : "SP" }, { "name" : "Transite", "code" : "TTE" }, { "name" : "Vitrified Clay", "code" : "VCP" }, { "name" : "Wood", "code" : "WD" }, { "name" : "Other", "code" : "OTH" }, { "name" : "Unknown", "code" : "UNK" }, { "name" : "Brick Masonry", "code" : "BMP" }, { "name" : "High Density Polyethylene", "code" : "HDPE" } ] }, "defaultValue" : null }, { "name" : "DIAMETER", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 } ] }, "defaultValue" : null }, { "name" : "WATERTYPE", "type" : "esriFieldTypeString", "alias" : "Water Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wWaterType", "codedValues" : [ { "name" : "Potable Water", "code" : "Potable" }, { "name" : "Raw Water", "code" : "Raw" }, { "name" : "Reclaimed Water", "code" : "Reclaimed" }, { "name" : "Salt Water", "code" : "Salt" }, { "name" : "Storm Runoff", "code" : "Storm" }, { "name" : "Treated Water", "code" : "Treated" } ] }, "defaultValue" : null }, { "name" : "TRANSMISS", "type" : "esriFieldTypeString", "alias" : "Transmission System", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__WaterDis__F4B70D8572C65EA9", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_12861.WaterDistributionNetwork_Main_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "6\" Ductile Iron", "description" : "A 6\" Ductile Iron Water Main", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "DIP", "DIAMETER" : 6, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "TRANSMISS" : null } } }, { "name" : "8\" Ductile Iron", "description" : "A 8\" Ductile Iron Water Main", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "DIP", "DIAMETER" : 8, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "TRANSMISS" : null } } }, { "name" : "10\" Ductile Iron", "description" : "A 10\" Ductile Iron Water Main", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "DIP", "DIAMETER" : 10, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "TRANSMISS" : null } } }, { "name" : "12\" Ductile Iron", "description" : "A 12\" Ductile Iron Water Main", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "DIP", "DIAMETER" : 12, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "TRANSMISS" : null } } }, { "name" : "Ductile Iron", "description" : "A Ductile Iron Water Main with no size set.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "DIP", "DIAMETER" : null, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "TRANSMISS" : null } } }, { "name" : "10\" PVC", "description" : "A 10\" PVC Water Main", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "PVC", "DIAMETER" : 10, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "TRANSMISS" : null } } }, { "name" : "12\" PVC", "description" : "A 12\" PVC Water Main", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "PVC", "DIAMETER" : 12, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "TRANSMISS" : null } } }, { "name" : "6\" PVC", "description" : "A 6\" PVC Water Main", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "PVC", "DIAMETER" : 6, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "TRANSMISS" : null } } }, { "name" : "8\" PVC", "description" : "A 8\" PVC Water Main", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "TRANSMISS" : null, "MATERIAL" : "PVC", "DIAMETER" : 8, "WATERTYPE" : "Potable", "INSTALLDATE" : null } } }, { "name" : "PVC", "description" : "A PVC Water Main with no size set.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "PVC", "DIAMETER" : null, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "TRANSMISS" : null } } }, { "name" : "(Empty Values)", "description" : "A PVC Water Main with no size set.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : null, "DIAMETER" : null, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "TRANSMISS" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 9, "name" : "Lateral", "type" : "Feature Layer", "serviceItemId" : "bac6062b352d4035ba73367b7a6c6542", "cacheMaxAge" : 30, "displayField" : "FACILITYID", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 3000, "maxScale" : 0, "extent" : { "xmin" : -9816596.3183451146, "ymin" : 5125639.21189391, "xmax" : -9809407.1288546268, "ymax" : 5130604.697377475, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":2.5},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : true, "allowUpdateWithoutMValues" : true, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "INSTALLDATE", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "MATERIAL", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeMaterial", "codedValues" : [ { "name" : "ABS Plastic", "code" : "ABS" }, { "name" : "Asbestos Cement", "code" : "AC" }, { "name" : "Asphalt", "code" : "ASP" }, { "name" : "Brick", "code" : "BR" }, { "name" : "Cast Iron", "code" : "CAS" }, { "name" : "Clay Tile", "code" : "CT" }, { "name" : "Concrete (Non-Reinforced)", "code" : "CP" }, { "name" : "Concrete Segments (Bolted)", "code" : "CSB" }, { "name" : "Concrete Segments (Unbolted)", "code" : "CSU" }, { "name" : "Corrugated Metal", "code" : "CMP" }, { "name" : "Copper", "code" : "COP" }, { "name" : "Cured In Place", "code" : "CIPP" }, { "name" : "Ductile Iron", "code" : "DIP" }, { "name" : "Fiberglass Reinforced", "code" : "FRP" }, { "name" : "Earth & Geotextile", "code" : "EARGEO" }, { "name" : "Earthen", "code" : "EAR" }, { "name" : "Geotextile", "code" : "GEO" }, { "name" : "Galvanized Pipe", "code" : "GP" }, { "name" : "Glass Reinforced Cement", "code" : "GRC" }, { "name" : "Pitch Fiber (Orangeburg)", "code" : "OB" }, { "name" : "Plastic/Steel Composite", "code" : "PSC" }, { "name" : "Polyethylene", "code" : "PE" }, { "name" : "Polypropylene", "code" : "PP" }, { "name" : "Polyvinyl Chloride", "code" : "PVC" }, { "name" : "Pre-Stressed Concrete Cylinder", "code" : "PCCP" }, { "name" : "Reinforced Concrete", "code" : "RCP" }, { "name" : "Reinforced Plastic (Truss)", "code" : "RPM" }, { "name" : "Segmented Block", "code" : "SB" }, { "name" : "Steel", "code" : "SP" }, { "name" : "Transite", "code" : "TTE" }, { "name" : "Vitrified Clay", "code" : "VCP" }, { "name" : "Wood", "code" : "WD" }, { "name" : "Other", "code" : "OTH" }, { "name" : "Unknown", "code" : "UNK" }, { "name" : "Brick Masonry", "code" : "BMP" }, { "name" : "High Density Polyethylene", "code" : "HDPE" } ] }, "defaultValue" : null }, { "name" : "LINETYPE", "type" : "esriFieldTypeString", "alias" : "Line Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wLateralType", "codedValues" : [ { "name" : "Hydrant", "code" : "Hydrant" }, { "name" : "Irrigation", "code" : "Irrigation" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Domestic", "code" : "Domestic" }, { "name" : "Fire", "code" : "Fire" }, { "name" : "Industrial", "code" : "Industrial" }, { "name" : "Commercial", "code" : "Commercial" } ] }, "defaultValue" : null }, { "name" : "LOCDESC", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DIAMETER", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 } ] }, "defaultValue" : null }, { "name" : "WATERTYPE", "type" : "esriFieldTypeString", "alias" : "Water Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wWaterType", "codedValues" : [ { "name" : "Potable Water", "code" : "Potable" }, { "name" : "Raw Water", "code" : "Raw" }, { "name" : "Reclaimed Water", "code" : "Reclaimed" }, { "name" : "Salt Water", "code" : "Salt" }, { "name" : "Storm Runoff", "code" : "Storm" }, { "name" : "Treated Water", "code" : "Treated" } ] }, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__WaterDis__F4B70D85B22B490F", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_12861.WaterDistributionNetwork_Lateral_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "1\" Copper Domestic", "description" : "A 1\" Copper Water Lateral.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "COP", "LINETYPE" : "Domestic", "DIAMETER" : 1, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "1 1/2\" Copper Domestic", "description" : "A 1 1/2\" Copper Water Lateral.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "COP", "LINETYPE" : "Domestic", "DIAMETER" : 1.5, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "2\" Copper Domestic", "description" : "A 2\" Copper Water Lateral.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "COP", "LINETYPE" : "Domestic", "DIAMETER" : 2, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "1 1/4\" Copper Domestic", "description" : "A 1 1/4\" Copper Water Lateral.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "COP", "LINETYPE" : "Domestic", "DIAMETER" : 1.25, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "6\" Ductile Iron Hydrant", "description" : "A 6\" Ductile Iron Hydrant Lateral.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "DIP", "LINETYPE" : "Hydrant", "DIAMETER" : 6, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "6\" Ductile Iron Fire", "description" : "A 6\" Ductile Iron Fire Lateral.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "DIP", "LINETYPE" : "Fire", "DIAMETER" : 6, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "8\" Ductile Iron Hydrant", "description" : "A 8\" Ductile Iron Hydrant Lateral.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "DIP", "LINETYPE" : "Hydrant", "DIAMETER" : 8, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "8\" Ductile Iron Fire", "description" : "A 8\" Ductile Iron Fire Lateral.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "DIP", "LINETYPE" : "Fire", "DIAMETER" : 8, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "2\" Copper Commerical", "description" : "A 2\" Copper Commerical Lateral.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "COP", "LINETYPE" : "Commercial", "DIAMETER" : 2, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "3\" Copper Commerical", "description" : "A 3\" Copper Commerical Lateral.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "COP", "LINETYPE" : "Commercial", "DIAMETER" : 3, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "2\" Copper Irrigation", "description" : "A 2\" Copper Irrigation Lateral.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "COP", "LINETYPE" : "Irrigation", "DIAMETER" : 2, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "1 1/2\" Copper Irrigation", "description" : "A 1 1/2\" Copper Irrigation Lateral.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "COP", "LINETYPE" : "Irrigation", "DIAMETER" : 1.5, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "(Empty Values)", "description" : "A Lateral Line with no values set.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : null, "LINETYPE" : null, "DIAMETER" : null, "WATERTYPE" : null, "INSTALLDATE" : null, "LOCDESC" : null } } }, { "name" : "3/4\" Copper Domestic", "description" : "A 3/4\" Copper Water Lateral.", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "MATERIAL" : "COP", "LINETYPE" : "Domestic", "DIAMETER" : 0.75, "WATERTYPE" : "Potable", "INSTALLDATE" : null, "LOCDESC" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 10, "name" : "Pressure Zones", "type" : "Feature Layer", "serviceItemId" : "bac6062b352d4035ba73367b7a6c6542", "cacheMaxAge" : 30, "displayField" : "ZONENAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 4622324.434309, "maxScale" : 36111.909643, "extent" : { "xmin" : -14842598.772436475, "ymin" : -30240971.958386172, "xmax" : -4823844.6010418683, "ymax" : 30240971.958386205, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,0,0,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":3}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "ZONEID", "type" : "esriFieldTypeString", "alias" : "Pressure Zone Identifier", "sqlType" : "sqlTypeOther", "length" : 3, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZONENAME", "type" : "esriFieldTypeString", "alias" : "Pressure Zone Name", "sqlType" : "sqlTypeOther", "length" : 3, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LASTUPDATE", "type" : "esriFieldTypeDate", "alias" : "Last Update Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LASTEDITOR", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__WaterDis__F4B70D85677B0E37", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_12861.WaterDistributionNetwork_Pressure_Zones_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Pressure Zones", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "LASTEDITOR" : null, "ZONEID" : null, "ZONENAME" : null, "LASTUPDATE" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ], "tables" : [] }