{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "WaterHydrant", "type" : "Feature Layer", "serviceItemId" : "8f2fa40f4e6347e88fc739d6a99e58e2", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "DATECREATED", "creatorField" : "CREATIONUSER", "editDateField" : "DATEMODIFIED", "editorField" : "LASTUSER" }, "editingInfo" : { "lastEditDate" : 1699990329201, "schemaLastEditDate" : 1698434475608, "dataLastEditDate" : 1699990329201 }, "relationships" : [ { "id" : 0, "name" : "WaterHydrant_InspectionHydrant", "relatedTableId" : 4, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false } ], "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" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "supportsOBACForAnonymousUsers" : true, "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, "supportsQueryBoxplots" : true, "supportsDefaultSR" : true, "supportsTranslations" : true, "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" ] }, "queryBoxplotsCapabilities" : { "supportsAsync" : true, "standardMaxCategoryCount" : 10000, "standardMaxSeriesCount" : 100 }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : true, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 288896, "maxScale" : 0, "extent" : { "xmin" : -10258125.044778656, "ymin" : 5884033.3451332478, "xmax" : -10241356.926638538, "ymax" : 5900946.5434821472, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"RedSphere.png","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15}}}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "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, "required" : true }, { "name" : "ANCILLARYROLE", "type" : "esriFieldTypeSmallInteger", "alias" : "ANCILLARYROLE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ENABLED", "type" : "esriFieldTypeSmallInteger", "alias" : "ENABLED", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : 1 }, { "name" : "CREATIONUSER", "type" : "esriFieldTypeString", "alias" : "Creation User", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "DATECREATED", "type" : "esriFieldTypeDate", "alias" : "Date Created", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "DATEMODIFIED", "type" : "esriFieldTypeDate", "alias" : "Date Modified", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LASTUSER", "type" : "esriFieldTypeString", "alias" : "Last User", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "LOCATION", "type" : "esriFieldTypeString", "alias" : "LOCATION", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDITION", "type" : "esriFieldTypeString", "alias" : "CONDITION", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDITIONDATE", "type" : "esriFieldTypeDate", "alias" : "Condition Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "INSTALLDATE", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LIFECYCLESTATUS", "type" : "esriFieldTypeString", "alias" : "Lifecycle Status", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wLifecycle Status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Proposed", "code" : "PROP" }, { "name" : "Active", "code" : "ACT" }, { "name" : "Abandoned", "code" : "ABN" }, { "name" : "Removed", "code" : "REM" } ] }, "defaultValue" : "ACT" }, { "name" : "WORKORDERID", "type" : "esriFieldTypeString", "alias" : "Work Order ID", "sqlType" : "sqlTypeOther", "length" : 20, "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" : "WATERTYPE", "type" : "esriFieldTypeString", "alias" : "Water Type", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Dw_WaterType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Potable Water", "code" : "POT" }, { "name" : "Raw Water", "code" : "RAW" } ] }, "defaultValue" : "POT" }, { "name" : "SYMBOLROTATION", "type" : "esriFieldTypeDouble", "alias" : "SymbolRotation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 0 }, { "name" : "WATERTRACEWEIGHT", "type" : "esriFieldTypeInteger", "alias" : "Water Trace Weight", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BARRELDIAMETER", "type" : "esriFieldTypeDouble", "alias" : "Barrel Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDistribution Main Diameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "0.75\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1.5\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2.5\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "5\"", "code" : 5 }, { "name" : "5.25\"", "code" : 5.25 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "Unknown", "code" : -1 }, { "name" : "Other", "code" : 0 }, { "name" : "1.25\"", "code" : 1.25 } ] }, "defaultValue" : 5.25 }, { "name" : "NOZZLEDIAMETER1", "type" : "esriFieldTypeDouble", "alias" : "Nozzle Diameter 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDistribution Main Diameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "0.75\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1.5\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2.5\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "5\"", "code" : 5 }, { "name" : "5.25\"", "code" : 5.25 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "Unknown", "code" : -1 }, { "name" : "Other", "code" : 0 }, { "name" : "1.25\"", "code" : 1.25 } ] }, "defaultValue" : 4 }, { "name" : "NOZZLEDIAMETER2", "type" : "esriFieldTypeDouble", "alias" : "Nozzle Diameter 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDistribution Main Diameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "0.75\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1.5\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2.5\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "5\"", "code" : 5 }, { "name" : "5.25\"", "code" : 5.25 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "Unknown", "code" : -1 }, { "name" : "Other", "code" : 0 }, { "name" : "1.25\"", "code" : 1.25 } ] }, "defaultValue" : 2.5 }, { "name" : "NOZZLEDIAMETER3", "type" : "esriFieldTypeDouble", "alias" : "Nozzle Diameter 3", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDistribution Main Diameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "0.75\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1.5\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2.5\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "5\"", "code" : 5 }, { "name" : "5.25\"", "code" : 5.25 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "Unknown", "code" : -1 }, { "name" : "Other", "code" : 0 }, { "name" : "1.25\"", "code" : 1.25 } ] }, "defaultValue" : 2.5 }, { "name" : "NOZZLEDIAMETER4", "type" : "esriFieldTypeDouble", "alias" : "Nozzle Diameter 4", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDistribution Main Diameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "0.75\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1.5\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2.5\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "5\"", "code" : 5 }, { "name" : "5.25\"", "code" : 5.25 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "Unknown", "code" : -1 }, { "name" : "Other", "code" : 0 }, { "name" : "1.25\"", "code" : 1.25 } ] }, "defaultValue" : null }, { "name" : "OUTLETCONFIGURATION", "type" : "esriFieldTypeString", "alias" : "Outlet Configuration", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wOutletConfiguration", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Standard Configuration", "code" : "Standard" }, { "name" : "Double Head Configuration", "code" : "DoubleHead" }, { "name" : "Two Hole Configuration", "code" : "TwoHole" } ] }, "defaultValue" : null }, { "name" : "SEATDIAMETER", "type" : "esriFieldTypeInteger", "alias" : "Seat Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MANUFACTURER", "type" : "esriFieldTypeString", "alias" : "MANUFACTURER", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Dw_HydrantManufacturer", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "RD Wood", "code" : "RDW" }, { "name" : "Kennedy", "code" : "KEN" }, { "name" : "South Park", "code" : "SPK" }, { "name" : "Waterous", "code" : "WAT" }, { "name" : "Evered Foundary", "code" : "EVF" }, { "name" : "Northern Eng Co", "code" : "NRE" } ] }, "defaultValue" : null }, { "name" : "WETDRY", "type" : "esriFieldTypeString", "alias" : "Wet/Dry", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUBTYPECD", "type" : "esriFieldTypeInteger", "alias" : "Subtype", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 1 }, { "name" : "MAPNUM", "type" : "esriFieldTypeString", "alias" : "MAPNUM", "sqlType" : "sqlTypeOther", "length" : 16, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BADGENUMBER", "type" : "esriFieldTypeInteger", "alias" : "BADGENUMBER", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PURCHASEDATE", "type" : "esriFieldTypeDate", "alias" : "PURCHASEDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LENGTH", "type" : "esriFieldTypeInteger", "alias" : "Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wHydrantLength", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "7 Feet 6 Inches", "code" : 76 }, { "name" : "8 Feet 6 Inches", "code" : 86 } ] }, "defaultValue" : null }, { "name" : "LABELTEXT", "type" : "esriFieldTypeString", "alias" : "LABELTEXT", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OWNER", "type" : "esriFieldTypeString", "alias" : "Owner", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wOwner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "SWL&P", "code" : "SWL&P" }, { "name" : "Private", "code" : "Private" } ] }, "defaultValue" : null }, { "name" : "GPS_DATE", "type" : "esriFieldTypeDate", "alias" : "GPS_DATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ENG_PLUG", "type" : "esriFieldTypeString", "alias" : "ENG_PLUG", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wYes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "GPS_LAT", "type" : "esriFieldTypeDouble", "alias" : "GPS_LAT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GPS_LONG", "type" : "esriFieldTypeDouble", "alias" : "GPS_LONG", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DRAIN", "type" : "esriFieldTypeString", "alias" : "DRAIN", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "FIREDEPTID", "type" : "esriFieldTypeString", "alias" : "FIREDEPTID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIRE_DIST", "type" : "esriFieldTypeString", "alias" : "Fire District", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MAINTENANCEDATE", "type" : "esriFieldTypeDate", "alias" : "Maintenance Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LINKEDDOC", "type" : "esriFieldTypeString", "alias" : "Linked Documents", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SLAMSCLOSED", "type" : "esriFieldTypeString", "alias" : "Slams Closed", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : "N" }, { "name" : "RVANTIFREEZE", "type" : "esriFieldTypeString", "alias" : "RV Antifreeze Added", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : "N" }, { "name" : "RVANTIFREEZEDATE", "type" : "esriFieldTypeDate", "alias" : "RV Antifreeze Added Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "OPERABLE", "type" : "esriFieldTypeString", "alias" : "Operable", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "INSPECTED", "type" : "esriFieldTypeString", "alias" : "INSPECTED", "sqlType" : "sqlTypeOther", "length" : 3, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "ServerOID", "type" : "esriFieldTypeInteger", "alias" : "ServerOID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "required" : true }, { "name" : "FLUSHDAYS", "type" : "esriFieldTypeInteger", "alias" : "Days since flushed", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LASTINSPGUID", "type" : "esriFieldTypeGUID", "alias" : "LASTINSPGUID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FLUSHBY", "type" : "esriFieldTypeString", "alias" : "Flushed by", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "I18ServerOID", "fields" : "ServerOID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "PK__DATA_WAT__F4B70D85A4580496", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_79414.DATA_WATERHYDRANT_SHAPE_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "ANCILLARYROLE" : null, "ENABLED" : 1, "LOCATION" : null, "CONDITION" : null, "CONDITIONDATE" : null, "INSTALLDATE" : null, "LIFECYCLESTATUS" : "ACT", "WORKORDERID" : null, "ELEVATION" : null, "WATERTYPE" : "POT", "SYMBOLROTATION" : 0, "WATERTRACEWEIGHT" : null, "BARRELDIAMETER" : 5.25, "NOZZLEDIAMETER1" : 4, "NOZZLEDIAMETER2" : 2.5, "NOZZLEDIAMETER3" : 2.5, "NOZZLEDIAMETER4" : null, "OUTLETCONFIGURATION" : null, "SEATDIAMETER" : null, "MANUFACTURER" : null, "WETDRY" : null, "SUBTYPECD" : 1, "MAPNUM" : null, "BADGENUMBER" : null, "PURCHASEDATE" : null, "LENGTH" : null, "LABELTEXT" : null, "OWNER" : null, "GPS_DATE" : null, "ENG_PLUG" : null, "GPS_LAT" : null, "GPS_LONG" : null, "DRAIN" : null, "FIREDEPTID" : null, "FIRE_DIST" : null, "MAINTENANCEDATE" : null, "LINKEDDOC" : null, "SLAMSCLOSED" : "N", "RVANTIFREEZE" : "N", "RVANTIFREEZEDATE" : null, "OPERABLE" : null, "INSPECTED" : null, "ServerOID" : null, "FLUSHDAYS" : null, "LASTINSPGUID" : null, "FLUSHBY" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF, Parquet", "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" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 100000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query", "subtypeField" : "SubtypeCD", "defaultSubtypeCode" : 1, "subtypes" : [ { "code" : 1, "name" : "Hydrant", "defaultValues" : { "ANCILLARYROLE" : null, "ENABLED" : 1, "CREATIONUSER" : null, "DATECREATED" : null, "DATEMODIFIED" : null, "LASTUSER" : null, "LOCATION" : null, "CONDITION" : null, "CONDITIONDATE" : null, "INSTALLDATE" : null, "LIFECYCLESTATUS" : "ACT", "WORKORDERID" : null, "ELEVATION" : null, "WATERTYPE" : "POT", "SYMBOLROTATION" : 0, "WATERTRACEWEIGHT" : null, "BARRELDIAMETER" : 5.25, "NOZZLEDIAMETER1" : 5, "NOZZLEDIAMETER2" : 5, "NOZZLEDIAMETER3" : null, "NOZZLEDIAMETER4" : null, "OUTLETCONFIGURATION" : null, "SEATDIAMETER" : null, "MANUFACTURER" : null, "WETDRY" : null, "SUBTYPECD" : 1, "MAPNUM" : null, "BADGENUMBER" : null, "PURCHASEDATE" : null, "LENGTH" : null, "LABELTEXT" : null, "OWNER" : null, "GPS_DATE" : null, "ENG_PLUG" : null, "GPS_LAT" : null, "GPS_LONG" : null, "DRAIN" : null, "FIREDEPTID" : null, "FIRE_DIST" : null, "MAINTENANCEDATE" : null, "LINKEDDOC" : null, "SLAMSCLOSED" : null, "RVANTIFREEZE" : null, "RVANTIFREEZEDATE" : null, "OPERABLE" : null, "INSPECTED" : null, "ServerOID" : null, "FLUSHDAYS" : null, "LASTINSPGUID" : null, "FLUSHBY" : null }, "domains" : { "ENABLED" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "wLifecycle Status", "codedValues" : [ { "name" : "Proposed", "code" : "PROP" }, { "name" : "Active", "code" : "ACT" }, { "name" : "Abandoned", "code" : "ABN" }, { "name" : "Removed", "code" : "REM" } ] }, "WATERTYPE" : { "type" : "codedValue", "name" : "wWater Type", "codedValues" : [ { "name" : "Potable", "code" : "POT" }, { "name" : "Non-Potable", "code" : "NOP" } ] }, "BARRELDIAMETER" : { "type" : "codedValue", "name" : "wDistribution Main Diameter", "codedValues" : [ { "name" : "0.75\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1.5\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2.5\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "5\"", "code" : 5 }, { "name" : "5.25\"", "code" : 5.25 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "Unknown", "code" : -1 }, { "name" : "Other", "code" : 0 }, { "name" : "1.25\"", "code" : 1.25 } ] }, "NOZZLEDIAMETER1" : { "type" : "codedValue", "name" : "wDistribution Main Diameter", "codedValues" : [ { "name" : "0.75\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1.5\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2.5\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "5\"", "code" : 5 }, { "name" : "5.25\"", "code" : 5.25 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "Unknown", "code" : -1 }, { "name" : "Other", "code" : 0 }, { "name" : "1.25\"", "code" : 1.25 } ] }, "NOZZLEDIAMETER2" : { "type" : "codedValue", "name" : "wDistribution Main Diameter", "codedValues" : [ { "name" : "0.75\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1.5\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2.5\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "5\"", "code" : 5 }, { "name" : "5.25\"", "code" : 5.25 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "Unknown", "code" : -1 }, { "name" : "Other", "code" : 0 }, { "name" : "1.25\"", "code" : 1.25 } ] }, "NOZZLEDIAMETER3" : { "type" : "codedValue", "name" : "wDistribution Main Diameter", "codedValues" : [ { "name" : "0.75\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1.5\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2.5\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "5\"", "code" : 5 }, { "name" : "5.25\"", "code" : 5.25 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "Unknown", "code" : -1 }, { "name" : "Other", "code" : 0 }, { "name" : "1.25\"", "code" : 1.25 } ] }, "NOZZLEDIAMETER4" : { "type" : "codedValue", "name" : "wDistribution Main Diameter", "codedValues" : [ { "name" : "0.75\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1.5\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2.5\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "5\"", "code" : 5 }, { "name" : "5.25\"", "code" : 5.25 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "Unknown", "code" : -1 }, { "name" : "Other", "code" : 0 }, { "name" : "1.25\"", "code" : 1.25 } ] }, "OUTLETCONFIGURATION" : { "type" : "codedValue", "name" : "wOutletConfiguration", "codedValues" : [ { "name" : "Standard Configuration", "code" : "Standard" }, { "name" : "Double Head Configuration", "code" : "DoubleHead" }, { "name" : "Two Hole Configuration", "code" : "TwoHole" } ] }, "LENGTH" : { "type" : "codedValue", "name" : "wHydrantLength", "codedValues" : [ { "name" : "7 Feet 6 Inches", "code" : 76 }, { "name" : "8 Feet 6 Inches", "code" : 86 } ] } } } ] }, { "currentVersion" : 12, "id" : 1, "name" : "WaterValve", "type" : "Feature Layer", "serviceItemId" : "8f2fa40f4e6347e88fc739d6a99e58e2", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "DATECREATED", "creatorField" : "CREATIONUSER", "editDateField" : "DATEMODIFIED", "editorField" : "LASTUSER" }, "editingInfo" : { "lastEditDate" : 1699990329201, "schemaLastEditDate" : 1698434479708, "dataLastEditDate" : 1699990329201 }, "relationships" : [ { "id" : 1, "name" : "WaterValve_InspectionValve", "relatedTableId" : 5, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false } ], "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" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "supportsOBACForAnonymousUsers" : true, "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, "supportsQueryBoxplots" : true, "supportsDefaultSR" : true, "supportsTranslations" : true, "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" ] }, "queryBoxplotsCapabilities" : { "supportsAsync" : true, "standardMaxCategoryCount" : 10000, "standardMaxSeriesCount" : 100 }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : true, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 288896, "maxScale" : 0, "extent" : { "xmin" : -10257614.312634053, "ymin" : 5884047.9832174592, "xmax" : -10241100.556363096, "ymax" : 5900895.9217669545, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"OrangeSphere.png","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAABv9JREFUeF7tl31UVVUaxk/34uXCBeTjqqXQoA1oGgqOOprlFwKKOpqCCq4IyEJL1CEmyxUijkjDOBAGFgM6qSz8KPEbCQQFP2JQhmwmhmlVSwvTIbgIJOLl7vPMc8U/5v+Ll382az1rn7PP3ft9n99+9z4HRZF/koAkIAlIApKAJCAJSAKSgCQgCUgCkoAkIAlIApKAJCAJPH4CrqtHKN7bntX5pY7R+a8drvgwpNvjDzuwEbTpzyovHgvRp5ye73Tm6jJDU9Mq19tWXVtuaDoRbigtCXXekhGgzGCaDgObaj9HXzxYCawId9r7nxiXNvzBA0jxgiXVC72PZEkxAu8NAZKN+PZl97byeYZ9q55SJvZzGgMzXepYJboxyvCd+rYH1G1G9GQMg/kDb6i7R0L9+Jk+5Y5Cb9av0LN9OLDlKYikofhmpduNnRM0qwYm636K+sexStx3cW7tSPOGOcsPlsJA4OBvgU+nAiXUsenUi8BR6hBVNB0ifxLMmeNYEb5ojjV2ZARoVvdTOvad5tWRSsj38cY7oBlzPk0X0+zRF4CTNFo6GygPAT6fC5ydyftZwKlg4Dh1ZA6wbxbMufxt+gT8FDvs53f8lHD7Zm9jtHkuypC6COMV7PwNHuQ/32e+hMbPUFWLgNoEoD4ZuJoI1EQCFTRdRihnCOQEwRxhu28OHuSyL30K6pcZ62I8lRE2pmW/4e8HOa3r2MyVz6PxA1bzM4DTNF8Z3mf8273AjyeB74uBr9IIYRkrgpVQxgooDWUlhHGrsN1DCNmz0fP7Mdg9Wf+W/RzYFslwPdL9ssicDFFI84dp/iRLvIztpWigaRfQegW4/wPUuw1Qb+yDWr+OlUHD1io4ywo4NZ/bhbCKwtCbx+rYEoSr4Yb6UDfF07bU7DB6povyQnO8Vxv+MgHqfpo+ai3tRwBq42i4EKKzDkL8CNFzHaLlMMQ3qRDXYqBeXsrtsIDVMo9VwPYgIewJgznlObRFOPYk+ioz7WDBthBZ4x0Sb672EmqGL7Cf+/8493PpHKjn50NcXwtxcxdE6wlCqIZoL4No/itE0yaIL1+lXoOoI6TKCI7jWXFkMVAQDMvb3miN0GLHWCXJtuzsMPpssNP7pjeHQk3nOz3fj6+8aVzVcIj6WIivEmj2XYgb2X3Gb+Zy9bewfw1EQxz1OsQ/3iSENVBLeTgWEV7OeFiSvHA3UouDU5QcO1iwLcT5UOeczsRhUHd4A3kjeQiO4erPY4lHUdE0SRD/osmvk6gNrApCsZqvp67FP6wAURsL9RwPxr1TgJ2jITa4o2O5BiXTlQLbsrPD6PJgpz+1v0EA232AD0dBPTwJonoBxGVWwRXqC17XLoL4+++oxdQS6iX2U1eoi7yvZlsVCbWIZ8eOZyDWOOHuCg0OPf/Eh3awYFuIvCBN0s04o4o0AsgmgJKZNERTF2n40kKC4FnwUGGPxOqw3l/kM+tvapZCnI+EqFwJ9RDfDClPojdOi9aVDtgZ6PCObdnZYfQiTyXkhyi3DmweAWTye59vAXGeK1rN1X4IgatvBXGJlfBQ1mv21fB5Nc1fiKD55RDlBHCA3wYbnfEgRoO2aEfzhtHaMDtYsDmE+78X6hp61xkh0nwhiqfCfC4E5iqqei7MNcEwX/w/We9r2F8dCjPPCnPVApgrFsLMT2NLrj8sq7Xojdfh66WOjYtGGobZnJ09JsgNUDZ3Relh3jgEvR+NRnfpRHSXT0J35WR0X2BrVfUjXbD2TUF31VQ+n4buCupkILqLfWHe6oKe+EGwJDjjk1m6VOausUf+NscI9VB8GoKVf+IVR9zfZMQvxaPQeXocOs9OQGd5IDorgtBZSZ2b2KcKqpwq5fOSX6PzwFB05bngfqIOWGfAlyv1jbGjFD+bE7PnBBnjlGV3Fj7RpcYMQud7g2Ha/zRMn46G6VgATKcCYToTBNPpiRSvj7PvM3+YinxgKvSEabcrxzhDrDegda3TvYLZmmh75t5fsbRZ45Xklpc0PXhZg/ZNzvhvrhEthcPR8ren0bLft0+f+LDvSbTke6Elzx13dg1G+1Y3iGQXmDY4mwvCHN5lQtr+Ssre8zhkB2rWNy9x+NkS44DujXrc3uaK5j+741a2B259QOVQvG7O8sDtTA/cSxsMy2ZX3FqvN+0J1Vj/Axxk76T7Pd4b/kpw7fxBZc0rHH9RE5ygbnJF11Zui+0eMO3wRFeGJ0S6O9/5LvjpLed7dfG68uQAZW6/JzLAExq2BWgjGpboCupX6L+oj3JsbozRdzTGOXU0xOlvXU3Q115/Xbcnc5o2knm6DHCujz38iNf8lck5M7SzrVrLa0b0fuxRZQBJQBKQBCQBSUASkAQkAUlAEpAEJAFJQBKQBCQBSUAS+B/qhLD6M6wGWAAAAABJRU5ErkJggg==","contentType":"image/png","width":15,"height":15}}}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "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, "required" : true }, { "name" : "ANCILLARYROLE", "type" : "esriFieldTypeSmallInteger", "alias" : "ANCILLARYROLE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ENABLED", "type" : "esriFieldTypeSmallInteger", "alias" : "ENABLED", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : 1 }, { "name" : "CREATIONUSER", "type" : "esriFieldTypeString", "alias" : "Creation User", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "DATECREATED", "type" : "esriFieldTypeDate", "alias" : "Date Created", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "DATEMODIFIED", "type" : "esriFieldTypeDate", "alias" : "Date Modified", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LASTUSER", "type" : "esriFieldTypeString", "alias" : "Last User", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "LOCATION", "type" : "esriFieldTypeString", "alias" : "LOCATION", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDITION", "type" : "esriFieldTypeString", "alias" : "CONDITION", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDITIONDATE", "type" : "esriFieldTypeDate", "alias" : "Condition Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "INSTALLDATE", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LIFECYCLESTATUS", "type" : "esriFieldTypeString", "alias" : "Lifecycle Status", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wLifecycle Status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Proposed", "code" : "PROP" }, { "name" : "Active", "code" : "ACT" }, { "name" : "Abandoned", "code" : "ABN" }, { "name" : "Removed", "code" : "REM" } ] }, "defaultValue" : "ACT" }, { "name" : "WORKORDERID", "type" : "esriFieldTypeString", "alias" : "Work Order ID", "sqlType" : "sqlTypeOther", "length" : 20, "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" : "WATERTYPE", "type" : "esriFieldTypeString", "alias" : "Water Type", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Dw_WaterType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Potable Water", "code" : "POT" }, { "name" : "Raw Water", "code" : "RAW" } ] }, "defaultValue" : "POT" }, { "name" : "SYMBOLROTATION", "type" : "esriFieldTypeDouble", "alias" : "SymbolRotation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 0 }, { "name" : "WATERTRACEWEIGHT", "type" : "esriFieldTypeInteger", "alias" : "Water Trace Weight", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUBTYPECD", "type" : "esriFieldTypeInteger", "alias" : "Subtype", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 6 }, { "name" : "VALVENUMBER", "type" : "esriFieldTypeString", "alias" : "VALVENUMBER", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BONDEDINDICATOR", "type" : "esriFieldTypeString", "alias" : "Bonded Indicator", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wYes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "CPSYSTEMSTATUS", "type" : "esriFieldTypeInteger", "alias" : "CP System Status", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wCP System Status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "defaultValue" : 1 }, { "name" : "EMERISOLATIONSYSSTATUS", "type" : "esriFieldTypeString", "alias" : "Emergency Isolation System Status", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MATERIAL", "type" : "esriFieldTypeString", "alias" : "MATERIAL", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Dw_FittingMaterial", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Ductile Iron", "code" : "DI" }, { "name" : "Cast Iron", "code" : "CI" }, { "name" : "Polyvinylchloride", "code" : "PVC" }, { "name" : "Galvanized", "code" : "GALV" }, { "name" : "Poly Pipe PE (Black)", "code" : "PEB" }, { "name" : "Poly Pipe PB (Blue)", "code" : "PB" }, { "name" : "Unknown", "code" : "UNK" }, { "name" : "HDPE Polyethylene", "code" : "PE" }, { "name" : "Copper", "code" : "CU" }, { "name" : "Brass", "code" : "BR" } ] }, "defaultValue" : null }, { "name" : "NORMALPOSITION", "type" : "esriFieldTypeInteger", "alias" : "Normal Position", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wNormal Position", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "defaultValue" : 1 }, { "name" : "OPERATINGCLASSIFICATION", "type" : "esriFieldTypeString", "alias" : "Operating Classification", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wOperating Classification", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Critical/Inspection Required", "code" : "CIR" }, { "name" : "Critical/Inspection Not Required", "code" : "CINR" }, { "name" : "Non-Critical", "code" : "NC" } ] }, "defaultValue" : null }, { "name" : "WATERPRESSURESYSTEMSTATUS", "type" : "esriFieldTypeInteger", "alias" : "Water Pressure System Status", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wWater Pressure System Status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Not Barrier", "code" : 0 }, { "name" : "Barrier", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "WATERSYSTEMSTATUS", "type" : "esriFieldTypeString", "alias" : "Water System Status", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CROSSOVERVALVE", "type" : "esriFieldTypeInteger", "alias" : "Cross Over Valve Indicator", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "defaultValue" : 0 }, { "name" : "CLOCKWISETOCLOSEINDICATOR", "type" : "esriFieldTypeInteger", "alias" : "Clockwise to Close Indicator", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "defaultValue" : 1 }, { "name" : "MOTORIZEDINDICATOR", "type" : "esriFieldTypeInteger", "alias" : "Motorized Indicator", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "defaultValue" : 0 }, { "name" : "PRESSURESETTING", "type" : "esriFieldTypeString", "alias" : "Pressure Setting", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSULATEDINDICATOR", "type" : "esriFieldTypeString", "alias" : "InsulatedIndicator", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "STATUS", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Station Status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Offline", "code" : "OFF" }, { "name" : "Online", "code" : "ONL" }, { "name" : "Unknown", "code" : "UNK" } ] }, "defaultValue" : null }, { "name" : "MAPNUM", "type" : "esriFieldTypeString", "alias" : "MAPNUM", "sqlType" : "sqlTypeOther", "length" : 16, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HYDRANTVALVE", "type" : "esriFieldTypeString", "alias" : "HydrantValve", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "FLUSHVALVE", "type" : "esriFieldTypeString", "alias" : "FlushValve", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "CURBSTOP", "type" : "esriFieldTypeString", "alias" : "CurbStop", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "MAINLINE", "type" : "esriFieldTypeString", "alias" : "MainLine", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "TAPPING", "type" : "esriFieldTypeString", "alias" : "Tapping", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "CORPORATION", "type" : "esriFieldTypeString", "alias" : "Corporation", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "VALVEACCESS", "type" : "esriFieldTypeString", "alias" : "ValveAccess", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Dw_ValveAccess", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "In Vault", "code" : "VAULT" }, { "name" : "In Manhole", "code" : "MANH" }, { "name" : "Valve Box", "code" : "BOX" }, { "name" : "Direct Buried", "code" : "DB" } ] }, "defaultValue" : null }, { "name" : "LABELTEXT", "type" : "esriFieldTypeString", "alias" : "LABELTEXT", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OPERABLE", "type" : "esriFieldTypeString", "alias" : "Operable", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "DIAMETER", "type" : "esriFieldTypeDouble", "alias" : "DIAMETER", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Dw_MainLineDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "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" : "16''", "code" : 16 }, { "name" : "18''", "code" : 18 }, { "name" : "20''", "code" : 20 }, { "name" : "24''", "code" : 24 }, { "name" : "30''", "code" : 30 }, { "name" : "36''", "code" : 36 }, { "name" : "42\"", "code" : 42 }, { "name" : "Unknown", "code" : 0 }, { "name" : "3/4\"", "code" : 0.75 } ] }, "defaultValue" : null }, { "name" : "TURNSTOCLOSE", "type" : "esriFieldTypeString", "alias" : "TURNSTOCLOSE", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SYSTEMVALVETYPE", "type" : "esriFieldTypeString", "alias" : "SystemValveType", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "System Valve Type", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Ball Valve", "code" : "Ball" }, { "name" : "Butterfly", "code" : "Butterfly" }, { "name" : "Globe", "code" : "Globe" }, { "name" : "Gate", "code" : "Gate" }, { "name" : "Hydrant", "code" : "Hydrant" }, { "name" : "LineStopper", "code" : "LineStopper" } ] }, "defaultValue" : null }, { "name" : "GPS_LAT", "type" : "esriFieldTypeDouble", "alias" : "GPS_LAT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GPS_LONG", "type" : "esriFieldTypeDouble", "alias" : "GPS_LONG", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LINKEDDOC", "type" : "esriFieldTypeString", "alias" : "Linked Documents", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSPECTIONDATE", "type" : "esriFieldTypeDate", "alias" : "Inspection Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "INSPECTED", "type" : "esriFieldTypeString", "alias" : "INSPECTED", "sqlType" : "sqlTypeOther", "length" : 3, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "ServerOID", "type" : "esriFieldTypeInteger", "alias" : "ServerOID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "required" : true }, { "name" : "INSPDAYS", "type" : "esriFieldTypeInteger", "alias" : "Days since inspection", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LASTINSPGUID", "type" : "esriFieldTypeGUID", "alias" : "LASTINSPGUID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSPBY", "type" : "esriFieldTypeString", "alias" : "Inspected by", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "I33ServerOID", "fields" : "ServerOID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "PK__DATA_WAT__F4B70D8532DA8DD0", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_79414.DATA_WATERVALVE_SHAPE_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "ANCILLARYROLE" : null, "ENABLED" : 1, "LOCATION" : null, "CONDITION" : null, "CONDITIONDATE" : null, "INSTALLDATE" : null, "LIFECYCLESTATUS" : "ACT", "WORKORDERID" : null, "ELEVATION" : null, "WATERTYPE" : "POT", "SYMBOLROTATION" : 0, "WATERTRACEWEIGHT" : null, "SUBTYPECD" : 6, "VALVENUMBER" : null, "BONDEDINDICATOR" : null, "CPSYSTEMSTATUS" : 1, "EMERISOLATIONSYSSTATUS" : null, "MATERIAL" : null, "NORMALPOSITION" : 1, "OPERATINGCLASSIFICATION" : null, "WATERPRESSURESYSTEMSTATUS" : null, "WATERSYSTEMSTATUS" : null, "CROSSOVERVALVE" : 0, "CLOCKWISETOCLOSEINDICATOR" : 1, "MOTORIZEDINDICATOR" : 0, "PRESSURESETTING" : null, "INSULATEDINDICATOR" : null, "STATUS" : null, "MAPNUM" : null, "HYDRANTVALVE" : null, "FLUSHVALVE" : null, "CURBSTOP" : null, "MAINLINE" : null, "TAPPING" : null, "CORPORATION" : null, "VALVEACCESS" : null, "LABELTEXT" : null, "OPERABLE" : null, "DIAMETER" : null, "TURNSTOCLOSE" : null, "SYSTEMVALVETYPE" : null, "GPS_LAT" : null, "GPS_LONG" : null, "LINKEDDOC" : null, "INSPECTIONDATE" : null, "INSPECTED" : null, "ServerOID" : null, "INSPDAYS" : null, "LASTINSPGUID" : null, "INSPBY" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF, Parquet", "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" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 100000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query", "subtypeField" : "SubtypeCD", "defaultSubtypeCode" : 6, "subtypes" : [ { "code" : 5, "name" : "Hydrant Valve", "defaultValues" : { "ANCILLARYROLE" : null, "ENABLED" : 1, "CREATIONUSER" : null, "DATECREATED" : null, "DATEMODIFIED" : null, "LASTUSER" : null, "LOCATION" : null, "CONDITION" : null, "CONDITIONDATE" : null, "INSTALLDATE" : null, "LIFECYCLESTATUS" : "ACT", "WORKORDERID" : null, "ELEVATION" : null, "WATERTYPE" : "POT", "SYMBOLROTATION" : 0, "WATERTRACEWEIGHT" : null, "SUBTYPECD" : 5, "VALVENUMBER" : null, "BONDEDINDICATOR" : null, "CPSYSTEMSTATUS" : 1, "EMERISOLATIONSYSSTATUS" : null, "MATERIAL" : null, "NORMALPOSITION" : 1, "OPERATINGCLASSIFICATION" : null, "WATERPRESSURESYSTEMSTATUS" : null, "WATERSYSTEMSTATUS" : null, "CROSSOVERVALVE" : 0, "CLOCKWISETOCLOSEINDICATOR" : 1, "MOTORIZEDINDICATOR" : 0, "PRESSURESETTING" : null, "INSULATEDINDICATOR" : null, "STATUS" : null, "MAPNUM" : null, "HYDRANTVALVE" : null, "FLUSHVALVE" : null, "CURBSTOP" : null, "MAINLINE" : null, "TAPPING" : null, "CORPORATION" : null, "VALVEACCESS" : null, "LABELTEXT" : null, "OPERABLE" : null, "DIAMETER" : null, "TURNSTOCLOSE" : null, "SYSTEMVALVETYPE" : null, "GPS_LAT" : null, "GPS_LONG" : null, "LINKEDDOC" : null, "INSPECTIONDATE" : null, "INSPECTED" : null, "ServerOID" : null, "INSPDAYS" : null, "LASTINSPGUID" : null, "INSPBY" : null }, "domains" : { "ENABLED" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "wLifecycle Status", "codedValues" : [ { "name" : "Proposed", "code" : "PROP" }, { "name" : "Active", "code" : "ACT" }, { "name" : "Abandoned", "code" : "ABN" }, { "name" : "Removed", "code" : "REM" } ] }, "WATERTYPE" : { "type" : "codedValue", "name" : "wWater Type", "codedValues" : [ { "name" : "Potable", "code" : "POT" }, { "name" : "Non-Potable", "code" : "NOP" } ] }, "BONDEDINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CPSYSTEMSTATUS" : { "type" : "codedValue", "name" : "wCP System Status", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "MATERIAL" : { "type" : "codedValue", "name" : "Dw_FittingMaterial", "codedValues" : [ { "name" : "Ductile Iron", "code" : "DI" }, { "name" : "Cast Iron", "code" : "CI" }, { "name" : "Polyvinylchloride", "code" : "PVC" }, { "name" : "Galvanized", "code" : "GALV" }, { "name" : "Poly Pipe PE (Black)", "code" : "PEB" }, { "name" : "Poly Pipe PB (Blue)", "code" : "PB" }, { "name" : "Unknown", "code" : "UNK" }, { "name" : "HDPE Polyethylene", "code" : "PE" }, { "name" : "Copper", "code" : "CU" }, { "name" : "Brass", "code" : "BR" } ] }, "NORMALPOSITION" : { "type" : "codedValue", "name" : "wNormal Position", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "OPERATINGCLASSIFICATION" : { "type" : "codedValue", "name" : "wOperating Classification", "codedValues" : [ { "name" : "Critical/Inspection Required", "code" : "CIR" }, { "name" : "Critical/Inspection Not Required", "code" : "CINR" }, { "name" : "Non-Critical", "code" : "NC" } ] }, "WATERPRESSURESYSTEMSTATUS" : { "type" : "codedValue", "name" : "wWater Pressure System Status", "codedValues" : [ { "name" : "Not Barrier", "code" : 0 }, { "name" : "Barrier", "code" : 1 } ] }, "CROSSOVERVALVE" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "CLOCKWISETOCLOSEINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "MOTORIZEDINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "INSULATEDINDICATOR" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "STATUS" : { "type" : "codedValue", "name" : "Station Status", "codedValues" : [ { "name" : "Offline", "code" : "OFF" }, { "name" : "Online", "code" : "ONL" }, { "name" : "Unknown", "code" : "UNK" } ] }, "HYDRANTVALVE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "FLUSHVALVE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CURBSTOP" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "MAINLINE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "TAPPING" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CORPORATION" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "VALVEACCESS" : { "type" : "codedValue", "name" : "Dw_ValveAccess", "codedValues" : [ { "name" : "In Vault", "code" : "VAULT" }, { "name" : "In Manhole", "code" : "MANH" }, { "name" : "Valve Box", "code" : "BOX" }, { "name" : "Direct Buried", "code" : "DB" } ] }, "OPERABLE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] } } }, { "code" : 4, "name" : "Gate", "defaultValues" : { "ANCILLARYROLE" : null, "ENABLED" : 1, "CREATIONUSER" : null, "DATECREATED" : null, "DATEMODIFIED" : null, "LASTUSER" : null, "LOCATION" : null, "CONDITION" : null, "CONDITIONDATE" : null, "INSTALLDATE" : null, "LIFECYCLESTATUS" : "ACT", "WORKORDERID" : null, "ELEVATION" : null, "WATERTYPE" : "POT", "SYMBOLROTATION" : 0, "WATERTRACEWEIGHT" : null, "SUBTYPECD" : 4, "VALVENUMBER" : null, "BONDEDINDICATOR" : null, "CPSYSTEMSTATUS" : 1, "EMERISOLATIONSYSSTATUS" : null, "MATERIAL" : null, "NORMALPOSITION" : 1, "OPERATINGCLASSIFICATION" : null, "WATERPRESSURESYSTEMSTATUS" : null, "WATERSYSTEMSTATUS" : null, "CROSSOVERVALVE" : 0, "CLOCKWISETOCLOSEINDICATOR" : 1, "MOTORIZEDINDICATOR" : 0, "PRESSURESETTING" : null, "INSULATEDINDICATOR" : null, "STATUS" : null, "MAPNUM" : null, "HYDRANTVALVE" : null, "FLUSHVALVE" : null, "CURBSTOP" : null, "MAINLINE" : null, "TAPPING" : null, "CORPORATION" : null, "VALVEACCESS" : null, "LABELTEXT" : null, "OPERABLE" : null, "DIAMETER" : null, "TURNSTOCLOSE" : null, "SYSTEMVALVETYPE" : null, "GPS_LAT" : null, "GPS_LONG" : null, "LINKEDDOC" : null, "INSPECTIONDATE" : null, "INSPECTED" : null, "ServerOID" : null, "INSPDAYS" : null, "LASTINSPGUID" : null, "INSPBY" : null }, "domains" : { "ENABLED" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "wLifecycle Status", "codedValues" : [ { "name" : "Proposed", "code" : "PROP" }, { "name" : "Active", "code" : "ACT" }, { "name" : "Abandoned", "code" : "ABN" }, { "name" : "Removed", "code" : "REM" } ] }, "WATERTYPE" : { "type" : "codedValue", "name" : "wWater Type", "codedValues" : [ { "name" : "Potable", "code" : "POT" }, { "name" : "Non-Potable", "code" : "NOP" } ] }, "BONDEDINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CPSYSTEMSTATUS" : { "type" : "codedValue", "name" : "wCP System Status", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "MATERIAL" : { "type" : "codedValue", "name" : "Dw_FittingMaterial", "codedValues" : [ { "name" : "Ductile Iron", "code" : "DI" }, { "name" : "Cast Iron", "code" : "CI" }, { "name" : "Polyvinylchloride", "code" : "PVC" }, { "name" : "Galvanized", "code" : "GALV" }, { "name" : "Poly Pipe PE (Black)", "code" : "PEB" }, { "name" : "Poly Pipe PB (Blue)", "code" : "PB" }, { "name" : "Unknown", "code" : "UNK" }, { "name" : "HDPE Polyethylene", "code" : "PE" }, { "name" : "Copper", "code" : "CU" }, { "name" : "Brass", "code" : "BR" } ] }, "NORMALPOSITION" : { "type" : "codedValue", "name" : "wNormal Position", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "OPERATINGCLASSIFICATION" : { "type" : "codedValue", "name" : "wOperating Classification", "codedValues" : [ { "name" : "Critical/Inspection Required", "code" : "CIR" }, { "name" : "Critical/Inspection Not Required", "code" : "CINR" }, { "name" : "Non-Critical", "code" : "NC" } ] }, "WATERPRESSURESYSTEMSTATUS" : { "type" : "codedValue", "name" : "wWater Pressure System Status", "codedValues" : [ { "name" : "Not Barrier", "code" : 0 }, { "name" : "Barrier", "code" : 1 } ] }, "CROSSOVERVALVE" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "CLOCKWISETOCLOSEINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "MOTORIZEDINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "INSULATEDINDICATOR" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "STATUS" : { "type" : "codedValue", "name" : "Station Status", "codedValues" : [ { "name" : "Offline", "code" : "OFF" }, { "name" : "Online", "code" : "ONL" }, { "name" : "Unknown", "code" : "UNK" } ] }, "HYDRANTVALVE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "FLUSHVALVE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CURBSTOP" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "MAINLINE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "TAPPING" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CORPORATION" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "VALVEACCESS" : { "type" : "codedValue", "name" : "Dw_ValveAccess", "codedValues" : [ { "name" : "In Vault", "code" : "VAULT" }, { "name" : "In Manhole", "code" : "MANH" }, { "name" : "Valve Box", "code" : "BOX" }, { "name" : "Direct Buried", "code" : "DB" } ] }, "OPERABLE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] } } }, { "code" : 6, "name" : "LineStopper", "defaultValues" : { "ANCILLARYROLE" : null, "ENABLED" : 1, "CREATIONUSER" : null, "DATECREATED" : null, "DATEMODIFIED" : null, "LASTUSER" : null, "LOCATION" : null, "CONDITION" : null, "CONDITIONDATE" : null, "INSTALLDATE" : null, "LIFECYCLESTATUS" : "ACT", "WORKORDERID" : null, "ELEVATION" : null, "WATERTYPE" : "POT", "SYMBOLROTATION" : 0, "WATERTRACEWEIGHT" : null, "SUBTYPECD" : 6, "VALVENUMBER" : null, "BONDEDINDICATOR" : null, "CPSYSTEMSTATUS" : 1, "EMERISOLATIONSYSSTATUS" : null, "MATERIAL" : null, "NORMALPOSITION" : 1, "OPERATINGCLASSIFICATION" : null, "WATERPRESSURESYSTEMSTATUS" : null, "WATERSYSTEMSTATUS" : null, "CROSSOVERVALVE" : 0, "CLOCKWISETOCLOSEINDICATOR" : 1, "MOTORIZEDINDICATOR" : 0, "PRESSURESETTING" : null, "INSULATEDINDICATOR" : null, "STATUS" : null, "MAPNUM" : null, "HYDRANTVALVE" : null, "FLUSHVALVE" : null, "CURBSTOP" : null, "MAINLINE" : null, "TAPPING" : null, "CORPORATION" : null, "VALVEACCESS" : null, "LABELTEXT" : null, "OPERABLE" : null, "DIAMETER" : null, "TURNSTOCLOSE" : null, "SYSTEMVALVETYPE" : null, "GPS_LAT" : null, "GPS_LONG" : null, "LINKEDDOC" : null, "INSPECTIONDATE" : null, "INSPECTED" : null, "ServerOID" : null, "INSPDAYS" : null, "LASTINSPGUID" : null, "INSPBY" : null }, "domains" : { "ENABLED" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "wLifecycle Status", "codedValues" : [ { "name" : "Proposed", "code" : "PROP" }, { "name" : "Active", "code" : "ACT" }, { "name" : "Abandoned", "code" : "ABN" }, { "name" : "Removed", "code" : "REM" } ] }, "WATERTYPE" : { "type" : "codedValue", "name" : "wWater Type", "codedValues" : [ { "name" : "Potable", "code" : "POT" }, { "name" : "Non-Potable", "code" : "NOP" } ] }, "BONDEDINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CPSYSTEMSTATUS" : { "type" : "codedValue", "name" : "wCP System Status", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "MATERIAL" : { "type" : "codedValue", "name" : "Dw_FittingMaterial", "codedValues" : [ { "name" : "Ductile Iron", "code" : "DI" }, { "name" : "Cast Iron", "code" : "CI" }, { "name" : "Polyvinylchloride", "code" : "PVC" }, { "name" : "Galvanized", "code" : "GALV" }, { "name" : "Poly Pipe PE (Black)", "code" : "PEB" }, { "name" : "Poly Pipe PB (Blue)", "code" : "PB" }, { "name" : "Unknown", "code" : "UNK" }, { "name" : "HDPE Polyethylene", "code" : "PE" }, { "name" : "Copper", "code" : "CU" }, { "name" : "Brass", "code" : "BR" } ] }, "NORMALPOSITION" : { "type" : "codedValue", "name" : "wNormal Position", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "OPERATINGCLASSIFICATION" : { "type" : "codedValue", "name" : "wOperating Classification", "codedValues" : [ { "name" : "Critical/Inspection Required", "code" : "CIR" }, { "name" : "Critical/Inspection Not Required", "code" : "CINR" }, { "name" : "Non-Critical", "code" : "NC" } ] }, "WATERPRESSURESYSTEMSTATUS" : { "type" : "codedValue", "name" : "wWater Pressure System Status", "codedValues" : [ { "name" : "Not Barrier", "code" : 0 }, { "name" : "Barrier", "code" : 1 } ] }, "CROSSOVERVALVE" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "CLOCKWISETOCLOSEINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "MOTORIZEDINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "INSULATEDINDICATOR" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "STATUS" : { "type" : "codedValue", "name" : "Station Status", "codedValues" : [ { "name" : "Offline", "code" : "OFF" }, { "name" : "Online", "code" : "ONL" }, { "name" : "Unknown", "code" : "UNK" } ] }, "HYDRANTVALVE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "FLUSHVALVE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CURBSTOP" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "MAINLINE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "TAPPING" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CORPORATION" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "VALVEACCESS" : { "type" : "codedValue", "name" : "Dw_ValveAccess", "codedValues" : [ { "name" : "In Vault", "code" : "VAULT" }, { "name" : "In Manhole", "code" : "MANH" }, { "name" : "Valve Box", "code" : "BOX" }, { "name" : "Direct Buried", "code" : "DB" } ] }, "OPERABLE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] } } }, { "code" : 2, "name" : "Butterfly", "defaultValues" : { "ANCILLARYROLE" : null, "ENABLED" : 1, "CREATIONUSER" : null, "DATECREATED" : null, "DATEMODIFIED" : null, "LASTUSER" : null, "LOCATION" : null, "CONDITION" : null, "CONDITIONDATE" : null, "INSTALLDATE" : null, "LIFECYCLESTATUS" : "ACT", "WORKORDERID" : null, "ELEVATION" : null, "WATERTYPE" : "POT", "SYMBOLROTATION" : 0, "WATERTRACEWEIGHT" : null, "SUBTYPECD" : 2, "VALVENUMBER" : null, "BONDEDINDICATOR" : null, "CPSYSTEMSTATUS" : 1, "EMERISOLATIONSYSSTATUS" : null, "MATERIAL" : null, "NORMALPOSITION" : 1, "OPERATINGCLASSIFICATION" : null, "WATERPRESSURESYSTEMSTATUS" : null, "WATERSYSTEMSTATUS" : null, "CROSSOVERVALVE" : 0, "CLOCKWISETOCLOSEINDICATOR" : 1, "MOTORIZEDINDICATOR" : 0, "PRESSURESETTING" : null, "INSULATEDINDICATOR" : null, "STATUS" : null, "MAPNUM" : null, "HYDRANTVALVE" : null, "FLUSHVALVE" : null, "CURBSTOP" : null, "MAINLINE" : null, "TAPPING" : null, "CORPORATION" : null, "VALVEACCESS" : null, "LABELTEXT" : null, "OPERABLE" : null, "DIAMETER" : null, "TURNSTOCLOSE" : null, "SYSTEMVALVETYPE" : null, "GPS_LAT" : null, "GPS_LONG" : null, "LINKEDDOC" : null, "INSPECTIONDATE" : null, "INSPECTED" : null, "ServerOID" : null, "INSPDAYS" : null, "LASTINSPGUID" : null, "INSPBY" : null }, "domains" : { "ENABLED" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "wLifecycle Status", "codedValues" : [ { "name" : "Proposed", "code" : "PROP" }, { "name" : "Active", "code" : "ACT" }, { "name" : "Abandoned", "code" : "ABN" }, { "name" : "Removed", "code" : "REM" } ] }, "WATERTYPE" : { "type" : "codedValue", "name" : "wWater Type", "codedValues" : [ { "name" : "Potable", "code" : "POT" }, { "name" : "Non-Potable", "code" : "NOP" } ] }, "BONDEDINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CPSYSTEMSTATUS" : { "type" : "codedValue", "name" : "wCP System Status", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "MATERIAL" : { "type" : "codedValue", "name" : "Dw_FittingMaterial", "codedValues" : [ { "name" : "Ductile Iron", "code" : "DI" }, { "name" : "Cast Iron", "code" : "CI" }, { "name" : "Polyvinylchloride", "code" : "PVC" }, { "name" : "Galvanized", "code" : "GALV" }, { "name" : "Poly Pipe PE (Black)", "code" : "PEB" }, { "name" : "Poly Pipe PB (Blue)", "code" : "PB" }, { "name" : "Unknown", "code" : "UNK" }, { "name" : "HDPE Polyethylene", "code" : "PE" }, { "name" : "Copper", "code" : "CU" }, { "name" : "Brass", "code" : "BR" } ] }, "NORMALPOSITION" : { "type" : "codedValue", "name" : "wNormal Position", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "OPERATINGCLASSIFICATION" : { "type" : "codedValue", "name" : "wOperating Classification", "codedValues" : [ { "name" : "Critical/Inspection Required", "code" : "CIR" }, { "name" : "Critical/Inspection Not Required", "code" : "CINR" }, { "name" : "Non-Critical", "code" : "NC" } ] }, "WATERPRESSURESYSTEMSTATUS" : { "type" : "codedValue", "name" : "wWater Pressure System Status", "codedValues" : [ { "name" : "Not Barrier", "code" : 0 }, { "name" : "Barrier", "code" : 1 } ] }, "CROSSOVERVALVE" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "CLOCKWISETOCLOSEINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "MOTORIZEDINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "INSULATEDINDICATOR" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "STATUS" : { "type" : "codedValue", "name" : "Station Status", "codedValues" : [ { "name" : "Offline", "code" : "OFF" }, { "name" : "Online", "code" : "ONL" }, { "name" : "Unknown", "code" : "UNK" } ] }, "HYDRANTVALVE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "FLUSHVALVE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CURBSTOP" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "MAINLINE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "TAPPING" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CORPORATION" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "VALVEACCESS" : { "type" : "codedValue", "name" : "Dw_ValveAccess", "codedValues" : [ { "name" : "In Vault", "code" : "VAULT" }, { "name" : "In Manhole", "code" : "MANH" }, { "name" : "Valve Box", "code" : "BOX" }, { "name" : "Direct Buried", "code" : "DB" } ] }, "OPERABLE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] } } }, { "code" : 1, "name" : "Ball", "defaultValues" : { "ANCILLARYROLE" : null, "ENABLED" : 1, "CREATIONUSER" : null, "DATECREATED" : null, "DATEMODIFIED" : null, "LASTUSER" : null, "LOCATION" : null, "CONDITION" : null, "CONDITIONDATE" : null, "INSTALLDATE" : null, "LIFECYCLESTATUS" : "ACT", "WORKORDERID" : null, "ELEVATION" : null, "WATERTYPE" : "POT", "SYMBOLROTATION" : 0, "WATERTRACEWEIGHT" : null, "SUBTYPECD" : 1, "VALVENUMBER" : null, "BONDEDINDICATOR" : null, "CPSYSTEMSTATUS" : 1, "EMERISOLATIONSYSSTATUS" : null, "MATERIAL" : null, "NORMALPOSITION" : 1, "OPERATINGCLASSIFICATION" : null, "WATERPRESSURESYSTEMSTATUS" : null, "WATERSYSTEMSTATUS" : null, "CROSSOVERVALVE" : 0, "CLOCKWISETOCLOSEINDICATOR" : 1, "MOTORIZEDINDICATOR" : 0, "PRESSURESETTING" : null, "INSULATEDINDICATOR" : null, "STATUS" : null, "MAPNUM" : null, "HYDRANTVALVE" : null, "FLUSHVALVE" : null, "CURBSTOP" : null, "MAINLINE" : null, "TAPPING" : null, "CORPORATION" : null, "VALVEACCESS" : null, "LABELTEXT" : null, "OPERABLE" : null, "DIAMETER" : null, "TURNSTOCLOSE" : null, "SYSTEMVALVETYPE" : null, "GPS_LAT" : null, "GPS_LONG" : null, "LINKEDDOC" : null, "INSPECTIONDATE" : null, "INSPECTED" : null, "ServerOID" : null, "INSPDAYS" : null, "LASTINSPGUID" : null, "INSPBY" : null }, "domains" : { "ENABLED" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "wLifecycle Status", "codedValues" : [ { "name" : "Proposed", "code" : "PROP" }, { "name" : "Active", "code" : "ACT" }, { "name" : "Abandoned", "code" : "ABN" }, { "name" : "Removed", "code" : "REM" } ] }, "WATERTYPE" : { "type" : "codedValue", "name" : "wWater Type", "codedValues" : [ { "name" : "Potable", "code" : "POT" }, { "name" : "Non-Potable", "code" : "NOP" } ] }, "BONDEDINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CPSYSTEMSTATUS" : { "type" : "codedValue", "name" : "wCP System Status", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "MATERIAL" : { "type" : "codedValue", "name" : "Dw_FittingMaterial", "codedValues" : [ { "name" : "Ductile Iron", "code" : "DI" }, { "name" : "Cast Iron", "code" : "CI" }, { "name" : "Polyvinylchloride", "code" : "PVC" }, { "name" : "Galvanized", "code" : "GALV" }, { "name" : "Poly Pipe PE (Black)", "code" : "PEB" }, { "name" : "Poly Pipe PB (Blue)", "code" : "PB" }, { "name" : "Unknown", "code" : "UNK" }, { "name" : "HDPE Polyethylene", "code" : "PE" }, { "name" : "Copper", "code" : "CU" }, { "name" : "Brass", "code" : "BR" } ] }, "NORMALPOSITION" : { "type" : "codedValue", "name" : "wNormal Position", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "OPERATINGCLASSIFICATION" : { "type" : "codedValue", "name" : "wOperating Classification", "codedValues" : [ { "name" : "Critical/Inspection Required", "code" : "CIR" }, { "name" : "Critical/Inspection Not Required", "code" : "CINR" }, { "name" : "Non-Critical", "code" : "NC" } ] }, "WATERPRESSURESYSTEMSTATUS" : { "type" : "codedValue", "name" : "wWater Pressure System Status", "codedValues" : [ { "name" : "Not Barrier", "code" : 0 }, { "name" : "Barrier", "code" : 1 } ] }, "CROSSOVERVALVE" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "CLOCKWISETOCLOSEINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "MOTORIZEDINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "INSULATEDINDICATOR" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "STATUS" : { "type" : "codedValue", "name" : "Station Status", "codedValues" : [ { "name" : "Offline", "code" : "OFF" }, { "name" : "Online", "code" : "ONL" }, { "name" : "Unknown", "code" : "UNK" } ] }, "HYDRANTVALVE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "FLUSHVALVE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CURBSTOP" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "MAINLINE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "TAPPING" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CORPORATION" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "VALVEACCESS" : { "type" : "codedValue", "name" : "Dw_ValveAccess", "codedValues" : [ { "name" : "In Vault", "code" : "VAULT" }, { "name" : "In Manhole", "code" : "MANH" }, { "name" : "Valve Box", "code" : "BOX" }, { "name" : "Direct Buried", "code" : "DB" } ] }, "OPERABLE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] } } }, { "code" : 3, "name" : "Globe", "defaultValues" : { "ANCILLARYROLE" : null, "ENABLED" : 1, "CREATIONUSER" : null, "DATECREATED" : null, "DATEMODIFIED" : null, "LASTUSER" : null, "LOCATION" : null, "CONDITION" : null, "CONDITIONDATE" : null, "INSTALLDATE" : null, "LIFECYCLESTATUS" : "ACT", "WORKORDERID" : null, "ELEVATION" : null, "WATERTYPE" : "POT", "SYMBOLROTATION" : 0, "WATERTRACEWEIGHT" : null, "SUBTYPECD" : 3, "VALVENUMBER" : null, "BONDEDINDICATOR" : null, "CPSYSTEMSTATUS" : 1, "EMERISOLATIONSYSSTATUS" : null, "MATERIAL" : null, "NORMALPOSITION" : 1, "OPERATINGCLASSIFICATION" : null, "WATERPRESSURESYSTEMSTATUS" : null, "WATERSYSTEMSTATUS" : null, "CROSSOVERVALVE" : 0, "CLOCKWISETOCLOSEINDICATOR" : 1, "MOTORIZEDINDICATOR" : 0, "PRESSURESETTING" : null, "INSULATEDINDICATOR" : null, "STATUS" : null, "MAPNUM" : null, "HYDRANTVALVE" : null, "FLUSHVALVE" : null, "CURBSTOP" : null, "MAINLINE" : null, "TAPPING" : null, "CORPORATION" : null, "VALVEACCESS" : null, "LABELTEXT" : null, "OPERABLE" : null, "DIAMETER" : null, "TURNSTOCLOSE" : null, "SYSTEMVALVETYPE" : null, "GPS_LAT" : null, "GPS_LONG" : null, "LINKEDDOC" : null, "INSPECTIONDATE" : null, "INSPECTED" : null, "ServerOID" : null, "INSPDAYS" : null, "LASTINSPGUID" : null, "INSPBY" : null }, "domains" : { "ENABLED" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "wLifecycle Status", "codedValues" : [ { "name" : "Proposed", "code" : "PROP" }, { "name" : "Active", "code" : "ACT" }, { "name" : "Abandoned", "code" : "ABN" }, { "name" : "Removed", "code" : "REM" } ] }, "WATERTYPE" : { "type" : "codedValue", "name" : "wWater Type", "codedValues" : [ { "name" : "Potable", "code" : "POT" }, { "name" : "Non-Potable", "code" : "NOP" } ] }, "BONDEDINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CPSYSTEMSTATUS" : { "type" : "codedValue", "name" : "wCP System Status", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "MATERIAL" : { "type" : "codedValue", "name" : "Dw_FittingMaterial", "codedValues" : [ { "name" : "Ductile Iron", "code" : "DI" }, { "name" : "Cast Iron", "code" : "CI" }, { "name" : "Polyvinylchloride", "code" : "PVC" }, { "name" : "Galvanized", "code" : "GALV" }, { "name" : "Poly Pipe PE (Black)", "code" : "PEB" }, { "name" : "Poly Pipe PB (Blue)", "code" : "PB" }, { "name" : "Unknown", "code" : "UNK" }, { "name" : "HDPE Polyethylene", "code" : "PE" }, { "name" : "Copper", "code" : "CU" }, { "name" : "Brass", "code" : "BR" } ] }, "NORMALPOSITION" : { "type" : "codedValue", "name" : "wNormal Position", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "OPERATINGCLASSIFICATION" : { "type" : "codedValue", "name" : "wOperating Classification", "codedValues" : [ { "name" : "Critical/Inspection Required", "code" : "CIR" }, { "name" : "Critical/Inspection Not Required", "code" : "CINR" }, { "name" : "Non-Critical", "code" : "NC" } ] }, "WATERPRESSURESYSTEMSTATUS" : { "type" : "codedValue", "name" : "wWater Pressure System Status", "codedValues" : [ { "name" : "Not Barrier", "code" : 0 }, { "name" : "Barrier", "code" : 1 } ] }, "CROSSOVERVALVE" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "CLOCKWISETOCLOSEINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "MOTORIZEDINDICATOR" : { "type" : "codedValue", "name" : "wYes/No Indicator - Integer", "codedValues" : [ { "name" : "No", "code" : 0 }, { "name" : "Yes", "code" : 1 } ] }, "INSULATEDINDICATOR" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "STATUS" : { "type" : "codedValue", "name" : "Station Status", "codedValues" : [ { "name" : "Offline", "code" : "OFF" }, { "name" : "Online", "code" : "ONL" }, { "name" : "Unknown", "code" : "UNK" } ] }, "HYDRANTVALVE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "FLUSHVALVE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CURBSTOP" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "MAINLINE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "TAPPING" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "CORPORATION" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "VALVEACCESS" : { "type" : "codedValue", "name" : "Dw_ValveAccess", "codedValues" : [ { "name" : "In Vault", "code" : "VAULT" }, { "name" : "In Manhole", "code" : "MANH" }, { "name" : "Valve Box", "code" : "BOX" }, { "name" : "Direct Buried", "code" : "DB" } ] }, "OPERABLE" : { "type" : "codedValue", "name" : "Yes/No Indicator", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] } } } ] }, { "currentVersion" : 12, "id" : 2, "name" : "WaterService", "type" : "Feature Layer", "serviceItemId" : "8f2fa40f4e6347e88fc739d6a99e58e2", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "CreationDate", "creatorField" : "Creator", "editDateField" : "EditDate", "editorField" : "Editor" }, "editingInfo" : { "lastEditDate" : 1699990329201, "schemaLastEditDate" : 1698434486963, "dataLastEditDate" : 1699990329201 }, "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, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "SHAPE__Length" }, "supportsOBACForAnonymousUsers" : true, "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, "supportsQueryBoxplots" : true, "supportsDefaultSR" : true, "supportsTranslations" : true, "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" ] }, "queryBoxplotsCapabilities" : { "supportsAsync" : true, "standardMaxCategoryCount" : 10000, "standardMaxSeriesCount" : 100 }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : true, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 288896, "maxScale" : 0, "extent" : { "xmin" : -10257626.608207446, "ymin" : 5884029.5378474835, "xmax" : -10241057.028836291, "ymax" : 5900958.50535052, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[165,83,183,255],"width":1}},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "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, "required" : true }, { "name" : "ENABLED", "type" : "esriFieldTypeSmallInteger", "alias" : "ENABLED", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 1 }, { "name" : "CREATIONUSER", "type" : "esriFieldTypeString", "alias" : "Creation User", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATECREATED", "type" : "esriFieldTypeDate", "alias" : "Date Created", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "DATEMODIFIED", "type" : "esriFieldTypeDate", "alias" : "Date Modified", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LASTUSER", "type" : "esriFieldTypeString", "alias" : "Last User", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOCATION", "type" : "esriFieldTypeString", "alias" : "LOCATION", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDITION", "type" : "esriFieldTypeString", "alias" : "CONDITION", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDITIONDATE", "type" : "esriFieldTypeDate", "alias" : "Condition Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "SUBTYPECD", "type" : "esriFieldTypeInteger", "alias" : "Subtype", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 7 }, { "name" : "MATERIAL", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "DI" }, { "name" : "WATERTYPE", "type" : "esriFieldTypeString", "alias" : "Water Type", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "POT" }, { "name" : "OPERATINGPRESSURE", "type" : "esriFieldTypeDouble", "alias" : "OPERATINGPRESSURE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRESSUREZONE", "type" : "esriFieldTypeString", "alias" : "PRESSUREZONE", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BONDEDINDICATOR", "type" : "esriFieldTypeString", "alias" : "Bonded Indicator", "sqlType" : "sqlTypeOther", "length" : 5, "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" : "LIFECYCLESTATUS", "type" : "esriFieldTypeString", "alias" : "Lifecycle Status", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "ACT" }, { "name" : "CPSYSTEMSTATUS", "type" : "esriFieldTypeInteger", "alias" : "CP System Status", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 1 }, { "name" : "WORKORDERID", "type" : "esriFieldTypeString", "alias" : "Work Order ID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MEASUREDLENGTH", "type" : "esriFieldTypeDouble", "alias" : "Measured Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WATERTRACEWEIGHT", "type" : "esriFieldTypeInteger", "alias" : "Water Trace Weight", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CPSYSTEMOBJECTID", "type" : "esriFieldTypeInteger", "alias" : "CP System ObjectID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DIAMETER", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 8 }, { "name" : "INSULATEDINDICATOR", "type" : "esriFieldTypeString", "alias" : "InsulatedIndicator", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATUS", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WATERSENSITIVE", "type" : "esriFieldTypeString", "alias" : "WaterSensitive", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HYDRANTLEADNUMBER", "type" : "esriFieldTypeString", "alias" : "HYDRANTLEADNUMBER", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LABELTEXT", "type" : "esriFieldTypeString", "alias" : "LABELTEXT", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MAPNUM", "type" : "esriFieldTypeString", "alias" : "MAPNUM", "sqlType" : "sqlTypeOther", "length" : 16, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SHOWANNOTATION", "type" : "esriFieldTypeString", "alias" : "ShowAnnotation", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSTALLYEAR", "type" : "esriFieldTypeString", "alias" : "INSTALLYEAR", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LINKEDDOC", "type" : "esriFieldTypeString", "alias" : "Linked Documents", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WCPSYSTEMSTATUS_GLOBALID", "type" : "esriFieldTypeGUID", "alias" : "WCPSYSTEMSTATUS_GLOBALID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ServerOID", "type" : "esriFieldTypeInteger", "alias" : "ServerOID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GLOBALID", "type" : "esriFieldTypeGUID", "alias" : "GLOBALID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CreationDate", "type" : "esriFieldTypeDate", "alias" : "CreationDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "EditDate", "type" : "esriFieldTypeDate", "alias" : "EditDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Editor", "type" : "esriFieldTypeString", "alias" : "Editor", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "SHAPE__Length", "type" : "esriFieldTypeDouble", "alias" : "SHAPE__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "SHAPE__Length_Index", "fields" : "SHAPE__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "PK__DATA_WAT__F4B70D852233918E", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_79414.DATA_WATERSERVICE_SHAPE_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ENABLED" : 1, "CREATIONUSER" : null, "DATECREATED" : null, "DATEMODIFIED" : null, "LASTUSER" : null, "LOCATION" : null, "CONDITION" : null, "CONDITIONDATE" : null, "SUBTYPECD" : 7, "MATERIAL" : "DI", "WATERTYPE" : "POT", "OPERATINGPRESSURE" : null, "PRESSUREZONE" : null, "BONDEDINDICATOR" : null, "INSTALLDATE" : null, "LIFECYCLESTATUS" : "ACT", "CPSYSTEMSTATUS" : 1, "WORKORDERID" : null, "MEASUREDLENGTH" : null, "WATERTRACEWEIGHT" : null, "CPSYSTEMOBJECTID" : null, "DIAMETER" : 8, "INSULATEDINDICATOR" : null, "STATUS" : null, "WATERSENSITIVE" : null, "HYDRANTLEADNUMBER" : null, "LABELTEXT" : null, "MAPNUM" : null, "SHOWANNOTATION" : null, "INSTALLYEAR" : null, "LINKEDDOC" : null, "WCPSYSTEMSTATUS_GLOBALID" : null, "ServerOID" : null, "GLOBALID" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF, Parquet", "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" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 100000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 3, "name" : "WaterMain", "type" : "Feature Layer", "serviceItemId" : "8f2fa40f4e6347e88fc739d6a99e58e2", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "CreationDate", "creatorField" : "Creator", "editDateField" : "EditDate", "editorField" : "Editor" }, "editingInfo" : { "lastEditDate" : 1699990329201, "schemaLastEditDate" : 1698434488386, "dataLastEditDate" : 1699990329201 }, "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, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "SHAPE__Length" }, "supportsOBACForAnonymousUsers" : true, "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, "supportsQueryBoxplots" : true, "supportsDefaultSR" : true, "supportsTranslations" : true, "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" ] }, "queryBoxplotsCapabilities" : { "supportsAsync" : true, "standardMaxCategoryCount" : 10000, "standardMaxSeriesCount" : 100 }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : true, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 288896, "maxScale" : 0, "extent" : { "xmin" : -10257587.134540828, "ymin" : 5884050.5523464037, "xmax" : -10241100.536791865, "ymax" : 5900943.896909968, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[241,152,60,255],"width":1}},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "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, "required" : true }, { "name" : "ENABLED", "type" : "esriFieldTypeSmallInteger", "alias" : "ENABLED", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 1 }, { "name" : "CREATIONUSER", "type" : "esriFieldTypeString", "alias" : "Creation User", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATECREATED", "type" : "esriFieldTypeDate", "alias" : "Date Created", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "DATEMODIFIED", "type" : "esriFieldTypeDate", "alias" : "Date Modified", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LASTUSER", "type" : "esriFieldTypeString", "alias" : "Last User", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOCATION", "type" : "esriFieldTypeString", "alias" : "LOCATION", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDITION", "type" : "esriFieldTypeString", "alias" : "CONDITION", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDITIONDATE", "type" : "esriFieldTypeDate", "alias" : "Condition Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "SUBTYPECD", "type" : "esriFieldTypeInteger", "alias" : "Subtype", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 4 }, { "name" : "MATERIAL", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "DI" }, { "name" : "WATERTYPE", "type" : "esriFieldTypeString", "alias" : "Water Type", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "POT" }, { "name" : "OPERATINGPRESSURE", "type" : "esriFieldTypeDouble", "alias" : "OPERATINGPRESSURE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRESSUREZONE", "type" : "esriFieldTypeString", "alias" : "PRESSUREZONE", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BONDEDINDICATOR", "type" : "esriFieldTypeString", "alias" : "Bonded Indicator", "sqlType" : "sqlTypeOther", "length" : 5, "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" : "LIFECYCLESTATUS", "type" : "esriFieldTypeString", "alias" : "Lifecycle Status", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "ACT" }, { "name" : "CPSYSTEMSTATUS", "type" : "esriFieldTypeInteger", "alias" : "CP System Status", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 1 }, { "name" : "WORKORDERID", "type" : "esriFieldTypeString", "alias" : "Work Order ID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MEASUREDLENGTH", "type" : "esriFieldTypeDouble", "alias" : "Measured Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WATERTRACEWEIGHT", "type" : "esriFieldTypeInteger", "alias" : "Water Trace Weight", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CPSYSTEMOBJECTID", "type" : "esriFieldTypeInteger", "alias" : "CP System ObjectID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EXTERIORCOATING", "type" : "esriFieldTypeString", "alias" : "Exterior Coating", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LININGTYPE", "type" : "esriFieldTypeString", "alias" : "Lining Type", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PIPECLASS", "type" : "esriFieldTypeString", "alias" : "Pipe Class", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ROUGHNESS", "type" : "esriFieldTypeDouble", "alias" : "ROUGHNESS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CFACTOR", "type" : "esriFieldTypeString", "alias" : "C-Factor", "sqlType" : "sqlTypeOther", "length" : 20, "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" : "PIPESTATUSINDICATOR", "type" : "esriFieldTypeInteger", "alias" : "Pipe Status Indicator", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 1 }, { "name" : "PIPETYPE", "type" : "esriFieldTypeString", "alias" : "Pipe Type", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRESSURERATING", "type" : "esriFieldTypeString", "alias" : "Pressure Rating", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSULATEDINDICATOR", "type" : "esriFieldTypeString", "alias" : "InsulatedIndicator", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MAPNUM", "type" : "esriFieldTypeString", "alias" : "MAPNUM", "sqlType" : "sqlTypeOther", "length" : 16, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LABELTEXT1", "type" : "esriFieldTypeString", "alias" : "LABELTEXT1", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LABELTEXT2", "type" : "esriFieldTypeString", "alias" : "LABELTEXT2", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "JOINTTYPE", "type" : "esriFieldTypeString", "alias" : "JointType", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEPTH", "type" : "esriFieldTypeString", "alias" : "DEPTH", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LINED", "type" : "esriFieldTypeString", "alias" : "Lined", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSTALLYEAR", "type" : "esriFieldTypeString", "alias" : "INSTALLYEAR", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SHOWANNOTATION", "type" : "esriFieldTypeString", "alias" : "SHOWANNOTATION", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "Y" }, { "name" : "DIAMETER", "type" : "esriFieldTypeDouble", "alias" : "DIAMETER", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LINKEDDOC", "type" : "esriFieldTypeString", "alias" : "Linked Documents", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WCPSYSTEMSTATUS_GLOBALID", "type" : "esriFieldTypeGUID", "alias" : "WCPSYSTEMSTATUS_GLOBALID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ServerOID", "type" : "esriFieldTypeInteger", "alias" : "ServerOID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GLOBALID", "type" : "esriFieldTypeGUID", "alias" : "GLOBALID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CreationDate", "type" : "esriFieldTypeDate", "alias" : "CreationDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "EditDate", "type" : "esriFieldTypeDate", "alias" : "EditDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Editor", "type" : "esriFieldTypeString", "alias" : "Editor", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "SHAPE__Length", "type" : "esriFieldTypeDouble", "alias" : "SHAPE__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "SHAPE__Length_Index", "fields" : "SHAPE__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "PK__DATA_WAT__F4B70D85C32D8698", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_79414.DATA_WATERMAIN_SHAPE_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ENABLED" : 1, "CREATIONUSER" : null, "DATECREATED" : null, "DATEMODIFIED" : null, "LASTUSER" : null, "LOCATION" : null, "CONDITION" : null, "CONDITIONDATE" : null, "SUBTYPECD" : 4, "MATERIAL" : "DI", "WATERTYPE" : "POT", "OPERATINGPRESSURE" : null, "PRESSUREZONE" : null, "BONDEDINDICATOR" : null, "INSTALLDATE" : null, "LIFECYCLESTATUS" : "ACT", "CPSYSTEMSTATUS" : 1, "WORKORDERID" : null, "MEASUREDLENGTH" : null, "WATERTRACEWEIGHT" : null, "CPSYSTEMOBJECTID" : null, "EXTERIORCOATING" : null, "LININGTYPE" : null, "PIPECLASS" : null, "ROUGHNESS" : null, "CFACTOR" : null, "ELEVATION" : null, "PIPESTATUSINDICATOR" : 1, "PIPETYPE" : null, "PRESSURERATING" : null, "INSULATEDINDICATOR" : null, "MAPNUM" : null, "LABELTEXT1" : null, "LABELTEXT2" : null, "JOINTTYPE" : null, "DEPTH" : null, "LINED" : null, "INSTALLYEAR" : null, "SHOWANNOTATION" : "Y", "DIAMETER" : null, "LINKEDDOC" : null, "WCPSYSTEMSTATUS_GLOBALID" : null, "ServerOID" : null, "GLOBALID" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF, Parquet", "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" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 100000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ], "tables" : [ { "currentVersion" : 12, "id" : 4, "name" : "InspectionHydrant", "type" : "Table", "serviceItemId" : "8f2fa40f4e6347e88fc739d6a99e58e2", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "DATECREATED", "creatorField" : "CREATIONUSER", "editDateField" : "DATEMODIFIED", "editorField" : "LASTUSER" }, "editingInfo" : { "lastEditDate" : 1699990329201, "schemaLastEditDate" : 1698434490700, "dataLastEditDate" : 1699990329201 }, "relationships" : [ { "id" : 0, "name" : "WaterHydrant_InspectionHydrant", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "WHYDRANT_GLOBALID", "composite" : false } ], "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" : true, "supportsOBACForAnonymousUsers" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "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" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsQueryBoxplots" : true, "supportsDefaultSR" : true, "supportsTranslations" : true, "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" ] }, "queryBoxplotsCapabilities" : { "supportsAsync" : true, "standardMaxCategoryCount" : 10000, "standardMaxSeriesCount" : 100 }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : true, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "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, "required" : true }, { "name" : "CREATIONUSER", "type" : "esriFieldTypeString", "alias" : "Creation User", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "DATECREATED", "type" : "esriFieldTypeDate", "alias" : "Date Created", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "DATEMODIFIED", "type" : "esriFieldTypeDate", "alias" : "Date Modified", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LASTUSER", "type" : "esriFieldTypeString", "alias" : "Last User", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "HYDRANTOBJECTID", "type" : "esriFieldTypeInteger", "alias" : "Hydrant ObjectID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CHECKEDBY", "type" : "esriFieldTypeString", "alias" : "Checked By", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "GasWaterDistributionCrew", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Andrew Serre", "code" : "ASERRE" }, { "name" : "Colton Krivinchuk", "code" : "CKRIVINCHUK" }, { "name" : "Craig Peterson", "code" : "CLPETERSON" }, { "name" : "Dallas Starkey", "code" : "DSTARKEY" }, { "name" : "Eric Frostman", "code" : "EFROSTMAN" }, { "name" : "Grant Miller", "code" : "GMILLER" }, { "name" : "Jason Macdonald", "code" : "JDMACDONALD" }, { "name" : "Jim Glonek", "code" : "JGLONEK" }, { "name" : "Joe Kujawa", "code" : "JKUJAWA" }, { "name" : "Keith Kellerhuis", "code" : "KKELLERHUIS" }, { "name" : "Ryan Brennan", "code" : "RBRENNAN" }, { "name" : "Steve Anderson", "code" : "SANDERSON" }, { "name" : "Tucker Abernethy", "code" : "TABERNETHY" }, { "name" : "Tony Burkhart", "code" : "TBURKHART" }, { "name" : "Matt Tonn", "code" : "MTONN" }, { "name" : "Brent Anderson", "code" : "BTANDERSON" }, { "name" : "Mike Hedin", "code" : "MHEDIN" }, { "name" : "Andy Strand", "code" : "ASTRAND" } ] }, "defaultValue" : null }, { "name" : "DATECHECKED", "type" : "esriFieldTypeDate", "alias" : "Date Checked", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "MINUTESFLUSHED", "type" : "esriFieldTypeInteger", "alias" : "Minutes Flushed", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 5 }, { "name" : "FLOWRATE", "type" : "esriFieldTypeInteger", "alias" : "Flow Rate PSI", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEADENDMAIN", "type" : "esriFieldTypeString", "alias" : "Dead End Main", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "BACKFLUSH", "type" : "esriFieldTypeString", "alias" : "Back Flush", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "OILED", "type" : "esriFieldTypeString", "alias" : "Oiled", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "FROZENDATE", "type" : "esriFieldTypeDate", "alias" : "Frozen Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "COMMENTS", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 140, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATICBADGENUM", "type" : "esriFieldTypeInteger", "alias" : "Static Badge Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FLOWBADGENUM", "type" : "esriFieldTypeInteger", "alias" : "Flow Badge Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATICSTARTPSI", "type" : "esriFieldTypeInteger", "alias" : "Static Start PSI", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATICDURINGPSI", "type" : "esriFieldTypeInteger", "alias" : "Static During PSI", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FLOWHYDPSI", "type" : "esriFieldTypeInteger", "alias" : "Flow Hydrant PSI", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "THAWEDDATE", "type" : "esriFieldTypeDate", "alias" : "Thawed Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "HYDRANTSTATUS", "type" : "esriFieldTypeString", "alias" : "Hydrant Status", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wHydrantStatus", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Describes status of Hydrant", "codedValues" : [ { "name" : "In Service", "code" : "IS" }, { "name" : "Out of Service", "code" : "OOS" } ] }, "defaultValue" : "IS" }, { "name" : "WHYDRANT_GLOBALID", "type" : "esriFieldTypeGUID", "alias" : "WHYDRANT_GLOBALID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FLUSHPORT", "type" : "esriFieldTypeString", "alias" : "Flushed out of", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "FlushPort", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Big ear", "code" : "BIGEAR" }, { "name" : "Small ear", "code" : "SMALLEAR" }, { "name" : "Two small ears", "code" : "TWOSMALLEARS" }, { "name" : "All ears", "code" : "ALLEARS" } ] }, "defaultValue" : null }, { "name" : "DIFFUSED", "type" : "esriFieldTypeString", "alias" : "Diffuser used", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "INSPECTIONTYPE", "type" : "esriFieldTypeString", "alias" : "Inspection Type", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wHydrantInspectionType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Routine Flushing", "code" : "ROUTINEFLUSH" }, { "name" : "Used in Shutdown", "code" : "USEDINSHUTDOWN" }, { "name" : "Maintenance or Repair", "code" : "MAINTREPAIR" } ] }, "defaultValue" : null }, { "name" : "CLRESIDUAL", "type" : "esriFieldTypeDouble", "alias" : "Chlorine Residual", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ServerOID", "type" : "esriFieldTypeInteger", "alias" : "ServerOID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "required" : true } ], "indexes" : [ { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "I19ServerOID", "fields" : "ServerOID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G19WHYDRANT_GLOB", "fields" : "WHYDRANT_GLOBALID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "PK__DATA_INS__F4B70D859FF1B391", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF, Parquet", "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", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 100000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 5, "name" : "InspectionValve", "type" : "Table", "serviceItemId" : "8f2fa40f4e6347e88fc739d6a99e58e2", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "DATECREATED", "creatorField" : "CREATIONUSER", "editDateField" : "DATEMODIFIED", "editorField" : "LASTUSER" }, "editingInfo" : { "lastEditDate" : 1699990329201, "schemaLastEditDate" : 1698434491091, "dataLastEditDate" : 1699990329201 }, "relationships" : [ { "id" : 1, "name" : "WaterValve_InspectionValve", "relatedTableId" : 1, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "WSYSTEMVALVE_GLOBALID", "composite" : false } ], "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" : true, "supportsOBACForAnonymousUsers" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "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" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsQueryBoxplots" : true, "supportsDefaultSR" : true, "supportsTranslations" : true, "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" ] }, "queryBoxplotsCapabilities" : { "supportsAsync" : true, "standardMaxCategoryCount" : 10000, "standardMaxSeriesCount" : 100 }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : true, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "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, "required" : true }, { "name" : "CREATIONUSER", "type" : "esriFieldTypeString", "alias" : "CREATIONUSER", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "DATECREATED", "type" : "esriFieldTypeDate", "alias" : "DATECREATED", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "DATEMODIFIED", "type" : "esriFieldTypeDate", "alias" : "DATEMODIFIED", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LASTUSER", "type" : "esriFieldTypeString", "alias" : "LASTUSER", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "CHECKEDBY", "type" : "esriFieldTypeString", "alias" : "CHECKEDBY", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "GasWaterDistributionCrew", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Andrew Serre", "code" : "ASERRE" }, { "name" : "Colton Krivinchuk", "code" : "CKRIVINCHUK" }, { "name" : "Craig Peterson", "code" : "CLPETERSON" }, { "name" : "Dallas Starkey", "code" : "DSTARKEY" }, { "name" : "Eric Frostman", "code" : "EFROSTMAN" }, { "name" : "Grant Miller", "code" : "GMILLER" }, { "name" : "Jason Macdonald", "code" : "JDMACDONALD" }, { "name" : "Jim Glonek", "code" : "JGLONEK" }, { "name" : "Joe Kujawa", "code" : "JKUJAWA" }, { "name" : "Keith Kellerhuis", "code" : "KKELLERHUIS" }, { "name" : "Ryan Brennan", "code" : "RBRENNAN" }, { "name" : "Steve Anderson", "code" : "SANDERSON" }, { "name" : "Tucker Abernethy", "code" : "TABERNETHY" }, { "name" : "Tony Burkhart", "code" : "TBURKHART" }, { "name" : "Matt Tonn", "code" : "MTONN" }, { "name" : "Brent Anderson", "code" : "BTANDERSON" }, { "name" : "Mike Hedin", "code" : "MHEDIN" }, { "name" : "Andy Strand", "code" : "ASTRAND" } ] }, "defaultValue" : null }, { "name" : "DATEOPERATED", "type" : "esriFieldTypeDate", "alias" : "DATEOPERATED", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "VALVEBOXALIGNED", "type" : "esriFieldTypeString", "alias" : "VALVEBOXALIGNED", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ValveBoxAlignment", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Acceptable", "code" : "Acceptable" }, { "name" : "Unacceptable", "code" : "Unacceptable" } ] }, "defaultValue" : null }, { "name" : "TOPNUTCOND", "type" : "esriFieldTypeString", "alias" : "Top Nut Condition", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TopNutCondition", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Good", "code" : "Good" }, { "name" : "Fair", "code" : "Fair" }, { "name" : "Poor", "code" : "Poor" }, { "name" : "Needs Repair", "code" : "Needs Repair" } ] }, "defaultValue" : null }, { "name" : "LEAKSWHENOFF", "type" : "esriFieldTypeString", "alias" : "Leaks When Off", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes/No Indicator", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null }, { "name" : "COMMENTS", "type" : "esriFieldTypeString", "alias" : "COMMENTS", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SYSTEMVALVEOBJECTID", "type" : "esriFieldTypeInteger", "alias" : "SYSTEMVALVEOBJECTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WSYSTEMVALVE_GLOBALID", "type" : "esriFieldTypeGUID", "alias" : "WSYSTEMVALVE_GLOBALID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ServerOID", "type" : "esriFieldTypeInteger", "alias" : "ServerOID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "required" : true } ], "indexes" : [ { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "I34ServerOID", "fields" : "ServerOID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G34WSYSTEMVALVE_", "fields" : "WSYSTEMVALVE_GLOBALID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "PK__DATA_INS__F4B70D8582745FC0", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF, Parquet", "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", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 100000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ] }