{ "currentVersion" : 12, "id" : 511, "name" : "Well", "type" : "Feature Layer", "serviceItemId" : "c492d27c97c343418ad442ea515b8c91", "cacheMaxAge" : 30, "displayField" : "assetid", "description" : "Water Device", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creationdate", "creatorField" : "creator", "editDateField" : "lastupdate", "editorField" : "updatedby" }, "editingInfo" : { "lastEditDate" : 1726692524499, "schemaLastEditDate" : 1726692524499, "dataLastEditDate" : 1726692524499 }, "relationships" : [ { "id" : 5, "name" : "ValveInspection", "relatedTableId" : 594, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GLOBALID", "composite" : false }, { "id" : 4, "name" : "HydrantMaintenanceInspection", "relatedTableId" : 595, "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" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 24000, "maxScale" : 0, "extent" : { "xmin" : 1563474.7302029729, "ymin" : 514225.27989372611, "xmax" : 1575007.7278062254, "ymax" : 522128.28410081565, "spatialReference" : { "wkid" : 102700, "latestWkid" : 102700 } }, "spatialReference" : { "wkid" : 102700, "latestWkid" : 102700 }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"ASSETTYPE","uniqueValueGroups":[{"heading":"Asset type","classes":[{"label":"Well","description":"Well","symbol":{"type":"esriPMS","url":"d713449edd8f7792ed24d4919d1227cc","imageData":"iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAADq0lEQVRIic2WP2gbZxjGf5c4DU1BiR051BdoOKRFQwr1udBFHpRBGSSXOh09FjXgqUPnysRTU0iWQiUKXbw4UCdwhshDPLRDA80tbqFLgklAJ6gdJwTiUop75fnuLtafU9wQU/rAcadP3/c+9/573hvhP8TI/4/sdHiWEcYIsfmbsRfrIX8Abf7iAc+sndcjGw/zWOQMwV7K/xZvAnneIM+ZcIc9fuWx1X51svFwmpCzhEAFhyKTOExynFMcZ9TsecYmW2zyDd/ziyGfZjxss2X98O/JEqLzjHKZS+Qope7L4JjrKiUesM4835pzZ8Iyv1trB5MlRPLmYy7xNpNmfaUJN5uw1YHtALI2FFyYrUGxgnmhGzhc4Svj5enwfR5bPw8nU44SjxKi33xoLsCPntli2ydoeGU87xHNphetF1y45kF2wmGRRT5kHos8mbCncHrJVAzK0eUuos9mIk8A183SaEybe6Vyjmr1HarVNcy+iza05PHEKF/ziQnpMaaBW4NkKm9VncKX5EgexUS1WoFGo9jzbiK8d2+WmZkWQbALc1PQakchrXCHVTbJhGOJd/tkI3F5F7tyFIfO88rGcBrkZbs9x9TUCr4fROeUx/M4huwYOaCPTA0rqLyVm7tLBHGO+ol8f5vV1YeRNzFs+y2zbopIZO9xAVjn6L4I7JMlyqA+ErY7pEEGFxZ8PO9h6v8of4JaottuaunHDRts3Dc/9faW1UwNX73u9rxEvR4TvaqCuOV38dc2zLNCmSAJncLmuuODB7NRNviTJ1362UemRWmdJCiD0zlVADYMkQogQaeza4pBYUwNZSH29gmb5n40jUzqLVGV1ineH9VgeXnA1sTECVPu1WrLEPd7bNREeM5Tc9+LKrGXTGNC6i1RvUopyJdw58r4S2um8vrRna+E7NPru1ElCre588LuAJkaT2NCuiZRzVHqfL6MvW5HKnEQCi7U6tGzzqvHjrAzXK40jzQmJDU3cILMSce+HVC9fhHvu7svJbK/+BJFw+Rc5xN7Xegl0+DTPJIYS70XWQw4ORrM/4RbWcF9dBN/qRU1b9bGvlA0OQo+mDMCYIh0Tgi53z9IB0tfg0/zSOGUektUc5T8c7PookseI9WMkcwzwaLNdu94Gd5nGnyaRxoTMiBRldZJghJlUB+pvJ/z1BSDcpR4lEI0nEzQ4NM80piQocjY+tD9R3iNbxAhqqRbZkxIvSWqidZJBNSwe+wcztdVL+mBxg6H7JDwD8tKgBYb2YKmAAAAAElFTkSuQmCC","contentType":"image/png","width":20,"height":20,"angle":0,"xoffset":0,"yoffset":0},"values":[["602"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"d713449edd8f7792ed24d4919d1227cc","imageData":"iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAADq0lEQVRIic2WP2gbZxjGf5c4DU1BiR051BdoOKRFQwr1udBFHpRBGSSXOh09FjXgqUPnysRTU0iWQiUKXbw4UCdwhshDPLRDA80tbqFLgklAJ6gdJwTiUop75fnuLtafU9wQU/rAcadP3/c+9/573hvhP8TI/4/sdHiWEcYIsfmbsRfrIX8Abf7iAc+sndcjGw/zWOQMwV7K/xZvAnneIM+ZcIc9fuWx1X51svFwmpCzhEAFhyKTOExynFMcZ9TsecYmW2zyDd/ziyGfZjxss2X98O/JEqLzjHKZS+Qope7L4JjrKiUesM4835pzZ8Iyv1trB5MlRPLmYy7xNpNmfaUJN5uw1YHtALI2FFyYrUGxgnmhGzhc4Svj5enwfR5bPw8nU44SjxKi33xoLsCPntli2ydoeGU87xHNphetF1y45kF2wmGRRT5kHos8mbCncHrJVAzK0eUuos9mIk8A183SaEybe6Vyjmr1HarVNcy+iza05PHEKF/ziQnpMaaBW4NkKm9VncKX5EgexUS1WoFGo9jzbiK8d2+WmZkWQbALc1PQakchrXCHVTbJhGOJd/tkI3F5F7tyFIfO88rGcBrkZbs9x9TUCr4fROeUx/M4huwYOaCPTA0rqLyVm7tLBHGO+ol8f5vV1YeRNzFs+y2zbopIZO9xAVjn6L4I7JMlyqA+ErY7pEEGFxZ8PO9h6v8of4JaottuaunHDRts3Dc/9faW1UwNX73u9rxEvR4TvaqCuOV38dc2zLNCmSAJncLmuuODB7NRNviTJ1362UemRWmdJCiD0zlVADYMkQogQaeza4pBYUwNZSH29gmb5n40jUzqLVGV1ineH9VgeXnA1sTECVPu1WrLEPd7bNREeM5Tc9+LKrGXTGNC6i1RvUopyJdw58r4S2um8vrRna+E7NPru1ElCre588LuAJkaT2NCuiZRzVHqfL6MvW5HKnEQCi7U6tGzzqvHjrAzXK40jzQmJDU3cILMSce+HVC9fhHvu7svJbK/+BJFw+Rc5xN7Xegl0+DTPJIYS70XWQw4ORrM/4RbWcF9dBN/qRU1b9bGvlA0OQo+mDMCYIh0Tgi53z9IB0tfg0/zSOGUektUc5T8c7PookseI9WMkcwzwaLNdu94Gd5nGnyaRxoTMiBRldZJghJlUB+pvJ/z1BSDcpR4lEI0nEzQ4NM80piQocjY+tD9R3iNbxAhqqRbZkxIvSWqidZJBNSwe+wcztdVL+mBxg6H7JDwD8tKgBYb2YKmAAAAAElFTkSuQmCC","contentType":"image/png","width":20,"height":20,"angle":0,"xoffset":0,"yoffset":0},"value":"602","label":"Well"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,192,252,255],"toColor":[187,192,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[188,252,179,255],"toColor":[188,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,192,182,255],"toColor":[252,192,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,252,250,255],"toColor":[212,252,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,231,255],"toColor":[252,182,231,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,247,192,255],"toColor":[252,247,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[242,212,252,255],"toColor":[242,212,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,231,212,255],"toColor":[252,231,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,252,214,255],"toColor":[204,252,214,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,224,252,255],"toColor":[179,224,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,204,221,255],"toColor":[252,204,221,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[238,179,252,255],"toColor":[238,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,222,179,255],"toColor":[252,222,179,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : true, "allowUpdateWithoutMValues" : true, "hasZ" : true, "enableZDefaults" : true, "zDefault" : 0, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "ASSETTYPE", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "ASSETGROUP", "type" : "esriFieldTypeInteger", "alias" : "Asset group", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : 0, "required" : true }, { "name" : "ASSETTYPE", "type" : "esriFieldTypeSmallInteger", "alias" : "Asset type", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : 0, "required" : true }, { "name" : "assetid", "type" : "esriFieldTypeString", "alias" : "Asset ID", "sqlType" : "sqlTypeOther", "length" : 64, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "diameter", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "secondarydiameter", "type" : "esriFieldTypeDouble", "alias" : "Secondary Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "pressure", "type" : "esriFieldTypeDouble", "alias" : "Pressure", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "designtype", "type" : "esriFieldTypeSmallInteger", "alias" : "Design Type", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "normalstatus", "type" : "esriFieldTypeSmallInteger", "alias" : "Normal Status", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Pipeline_Valve_Status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "The state of a device", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "presentstatus", "type" : "esriFieldTypeSmallInteger", "alias" : "Present Status", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Pipeline_Valve_Status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "The state of a device", "codedValues" : [ { "name" : "Closed", "code" : 0 }, { "name" : "Open", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "additionaldetails", "type" : "esriFieldTypeSmallInteger", "alias" : "Additional Details", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "designinfo", "type" : "esriFieldTypeDouble", "alias" : "Design Info", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "accesstype", "type" : "esriFieldTypeSmallInteger", "alias" : "Access Type", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Access_Type", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Access Types", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Surface", "code" : 1 }, { "name" : "Tunnel", "code" : 2 }, { "name" : "Building", "code" : 3 } ] }, "defaultValue" : 0 }, { "name" : "operable", "type" : "esriFieldTypeSmallInteger", "alias" : "Operable", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Boolean", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "True or False", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : 1 }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 64, "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" : "accountid", "type" : "esriFieldTypeString", "alias" : "Account ID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ownedby", "type" : "esriFieldTypeSmallInteger", "alias" : "Owned By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Asset_Owner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "The owner of an asset.", "codedValues" : [ { "name" : "Private", "code" : 2 }, { "name" : "Other", "code" : 100 }, { "name" : "MSU", "code" : 1 }, { "name" : "City", "code" : 3 } ] }, "defaultValue" : 1 }, { "name" : "maintby", "type" : "esriFieldTypeSmallInteger", "alias" : "Maintained By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Asset_Manager", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "The manager of an asset.", "codedValues" : [ { "name" : "Private", "code" : 2 }, { "name" : "Other", "code" : 100 }, { "name" : "MSU", "code" : 1 }, { "name" : "City", "code" : 3 } ] }, "defaultValue" : 1 }, { "name" : "additionaldevice", "type" : "esriFieldTypeSmallInteger", "alias" : "Additional Device", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "symbolrotation", "type" : "esriFieldTypeSmallInteger", "alias" : "Symbol Rotation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "range", "name" : "Symbol_Rotation", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "The rotation of an asset's symbol.", "range" : [ 0, 359 ] }, "defaultValue" : null }, { "name" : "lastmaint", "type" : "esriFieldTypeDate", "alias" : "Last Maintenance", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "lifecyclestatus", "type" : "esriFieldTypeSmallInteger", "alias" : "Lifecycle Status", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Lifecycle_Combined", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Bitwise combination of lifecycle states for subnetwork management", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Proposed", "code" : 1 }, { "name" : "Approved", "code" : 2 }, { "name" : "Proposed and Approved", "code" : 3 }, { "name" : "Under Construction", "code" : 4 }, { "name" : "Approved and Under Construction", "code" : 6 }, { "name" : "Proposed, Approved and Under Construction", "code" : 7 }, { "name" : "In Service", "code" : 8 }, { "name" : "In Service and Under Construction", "code" : 12 }, { "name" : "In Service, Under Construction, and Approved", "code" : 14 }, { "name" : "In Service, Under Construction, Approved and Proposed", "code" : 15 }, { "name" : "To Be Retired", "code" : 16 }, { "name" : "In Service and To Be Retired", "code" : 24 }, { "name" : "Abandoned", "code" : 32 }, { "name" : "Retired", "code" : 64 }, { "name" : "Removed", "code" : 128 }, { "name" : "Out of Service", "code" : 256 } ] }, "defaultValue" : 0 }, { "name" : "inservicedate", "type" : "esriFieldTypeDate", "alias" : "In-Service Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "retireddate", "type" : "esriFieldTypeDate", "alias" : "Retired Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "spatialsource", "type" : "esriFieldTypeSmallInteger", "alias" : "Spatial Source", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Spatial_Source", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Source of the data", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "As-Built", "code" : 1 }, { "name" : "CAD", "code" : 2 }, { "name" : "Digitized", "code" : 3 }, { "name" : "GPS/GNSS", "code" : 4 }, { "name" : "Field Sketch", "code" : 5 }, { "name" : "GIS Import", "code" : 6 } ] }, "defaultValue" : null }, { "name" : "spatialconfidence", "type" : "esriFieldTypeSmallInteger", "alias" : "Spatial Confidence", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Spatial_Confidence", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Confidence values for the data", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "High", "code" : 1 }, { "name" : "Medium", "code" : 2 }, { "name" : "Low", "code" : 3 } ] }, "defaultValue" : null }, { "name" : "manufacturer", "type" : "esriFieldTypeSmallInteger", "alias" : "Manufacturer", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "operator", "type" : "esriFieldTypeSmallInteger", "alias" : "Postindicator Valve", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "bondedinsulated", "type" : "esriFieldTypeSmallInteger", "alias" : "Bonded/Insulated", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Bonded_Insulated", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Values to indicate if a feature is bonded or insulated.", "codedValues" : [ { "name" : "Bonded", "code" : 1 }, { "name" : "Insulated", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "cptraceability", "type" : "esriFieldTypeSmallInteger", "alias" : "Cathodic Protection Traceability", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes_No", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "A yes/no indicator", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "No", "code" : 2 } ] }, "defaultValue" : 0 }, { "name" : "cpoverride", "type" : "esriFieldTypeSmallInteger", "alias" : "Cathodic Protection Override", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "CP_Traceability", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Valid cathodic protection status values", "codedValues" : [ { "name" : "Traceable", "code" : 1 }, { "name" : "Not Traceable", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "ASSOCIATIONSTATUS", "type" : "esriFieldTypeSmallInteger", "alias" : "Association status", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : { "type" : "codedValue", "name" : "MSU_WaterUN_274_AssociationStatus", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Indicates how the feature participates in associations.", "codedValues" : [ { "name" : "None", "code" : 0 }, { "name" : "Container", "code" : 1 }, { "name" : "Structure", "code" : 2 }, { "name" : "Content", "code" : 4 }, { "name" : "Content and Container", "code" : 5 }, { "name" : "Content and Structure", "code" : 6 }, { "name" : "Attachment", "code" : 8 }, { "name" : "Attachment and Container", "code" : 9 }, { "name" : "Attachment and Structure", "code" : 10 }, { "name" : "Attachment and Content", "code" : 12 }, { "name" : "Attachment and Content and Container", "code" : 13 }, { "name" : "Attachment and Content and Structure", "code" : 14 }, { "name" : "Visible Content", "code" : 16 }, { "name" : "Visible Content and Container", "code" : 17 }, { "name" : "Visible Content and Structure", "code" : 18 }, { "name" : "Visible Content and Attachment", "code" : 24 }, { "name" : "Visible Content and Attachment and Container", "code" : 25 }, { "name" : "Visible Content and Attachment and Structure", "code" : 26 }, { "name" : "Connectivity", "code" : 32 }, { "name" : "Connectivity and Container", "code" : 33 }, { "name" : "Connectivity and Structure", "code" : 34 }, { "name" : "Connectivity and Content", "code" : 36 }, { "name" : "Connectivity and Content and Container", "code" : 37 }, { "name" : "Connectivity and Content and Structure", "code" : 38 }, { "name" : "Connectivity and Attachment", "code" : 40 }, { "name" : "Connectivity and Attachment and Container", "code" : 41 }, { "name" : "Connectivity and Attachment and Structure", "code" : 42 }, { "name" : "Connectivity and Attachment and Content", "code" : 44 }, { "name" : "Connectivity and Attachment and Content and Container", "code" : 45 }, { "name" : "Connectivity and Attachment and Content and Structure", "code" : 46 }, { "name" : "Connectivity and Visible Content", "code" : 48 }, { "name" : "Connectivity and Visible Content and Container", "code" : 49 }, { "name" : "Connectivity and Visible Content and Structure", "code" : 50 }, { "name" : "Connectivity and Visible Content and Attachment", "code" : 56 }, { "name" : "Connectivity and Visible Content and Attachment and Container", "code" : 57 }, { "name" : "Connectivity and Visible Content and Attachment and Structure", "code" : 58 } ] }, "defaultValue" : 0 }, { "name" : "ISSUBNETWORKCONTROLLER", "type" : "esriFieldTypeSmallInteger", "alias" : "Is subnetwork controller", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : { "type" : "codedValue", "name" : "MSU_WaterUN_274_IsSubnetworkController", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Indicates if a device feature is a subnetwork controller.", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : 0 }, { "name" : "ISCONNECTED", "type" : "esriFieldTypeSmallInteger", "alias" : "Is connected", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : { "type" : "codedValue", "name" : "MSU_WaterUN_274_IsConnected", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Indicates if the feature is connected to a subnetwork controller.", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "defaultValue" : 2 }, { "name" : "SystemSubnetworkName", "type" : "esriFieldTypeString", "alias" : "System Subnetwork Name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "Unknown" }, { "name" : "SUBNETWORKCONTROLLERNAME", "type" : "esriFieldTypeString", "alias" : "Subnetwork controller name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "Unknown" }, { "name" : "TIERNAME", "type" : "esriFieldTypeSmallInteger", "alias" : "Tier name", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : { "type" : "codedValue", "name" : "MSU_WaterUN_274_TierName", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "The tier names in the utility network.", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Water Cathodic Protection", "code" : 1 }, { "name" : "Water System", "code" : 2 }, { "name" : "Water Pressure", "code" : 3 }, { "name" : "Water Isolation", "code" : 4 }, { "name" : "Water District Metered Areas (DMAs)", "code" : 5 }, { "name" : "Sewer Cathodic Protection", "code" : 6 }, { "name" : "Sewer Collection System", "code" : 7 }, { "name" : "Pump Zone", "code" : 8 }, { "name" : "Sewershed", "code" : 9 }, { "name" : "Stormwater Management Area", "code" : 10 } ] }, "defaultValue" : 0 }, { "name" : "TIERRANK", "type" : "esriFieldTypeInteger", "alias" : "Tier rank", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : 0 }, { "name" : "TERMINALCONFIGURATION", "type" : "esriFieldTypeString", "alias" : "Terminal path", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : "Default" }, { "name" : "SUPPORTEDSUBNETWORKNAME", "type" : "esriFieldTypeString", "alias" : "Supported subnetwork name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "Unknown" }, { "name" : "SUPPORTINGSUBNETWORKNAME", "type" : "esriFieldTypeString", "alias" : "Supporting subnetwork name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "Unknown" }, { "name" : "IsolationSubnetworkName", "type" : "esriFieldTypeString", "alias" : "Isolation Subnetwork Name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "Unknown" }, { "name" : "PressureSubnetworkName", "type" : "esriFieldTypeString", "alias" : "Pressure Subnetwork Name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "Unknown" }, { "name" : "DMASubnetworkName", "type" : "esriFieldTypeString", "alias" : "DMA Subnetwork Name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "Unknown" }, { "name" : "cpsubnetworkname", "type" : "esriFieldTypeString", "alias" : "CP Subnetwork Name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "Unknown" }, { "name" : "creationdate", "type" : "esriFieldTypeDate", "alias" : "Creation date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "lastupdate", "type" : "esriFieldTypeDate", "alias" : "Last update", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "updatedby", "type" : "esriFieldTypeString", "alias" : "Updated by", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "GLOBALID", "type" : "esriFieldTypeGUID", "alias" : "Global ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "{00000000-0000-0000-0000-000000000000}" }, { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "Object ID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__UN_SIMPL__F4B70D85A48B2CD6", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_74890.UN_SIMPLE_NETWORK_WATER_WATER_ASSEMBLY_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "I224GLOBALID", "fields" : "GLOBALID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "creationdateIndex", "fields" : "creationdate", "isAscending" : true, "isUnique" : false, "description" : "creationdate Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "lastupdateIndex", "fields" : "lastupdate", "isAscending" : true, "isUnique" : false, "description" : "lastupdate Field index", "indexType" : "Attribute" }, { "name" : "updatedbyIndex", "fields" : "updatedby", "isAscending" : false, "isUnique" : false, "description" : "updatedby Field index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : 602, "name" : "Well", "domains" : { "normalstatus" : {"type" : "inherited"}, "presentstatus" : {"type" : "inherited"}, "accesstype" : {"type" : "inherited"}, "operable" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "symbolrotation" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISSUBNETWORKCONTROLLER" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "TIERNAME" : {"type" : "inherited"} }, "templates" : [ { "name" : "Well", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "maintby" : 1, "cpoverride" : null, "installdate" : null, "additionaldevice" : null, "symbolrotation" : null, "lifecyclestatus" : 0, "cptraceability" : 0, "operator" : null, "inservicedate" : null, "TERMINALCONFIGURATION" : "Default", "manufacturer" : null, "notes" : null, "spatialsource" : null, "spatialconfidence" : null, "retireddate" : null, "accesstype" : 0, "accountid" : null, "ownedby" : 1, "lastmaint" : null, "bondedinsulated" : null, "designinfo" : null, "ASSETTYPE" : 602, "assetid" : null, "diameter" : null, "secondarydiameter" : null, "pressure" : null, "designtype" : null, "normalstatus" : null, "presentstatus" : null, "additionaldetails" : null, "operable" : 1, "name" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query", "definitionQuery" : "ASSETGROUP = 15" }