{ "currentVersion" : 12, "id" : 551, "name" : "Water Service", "type" : "Feature Layer", "serviceItemId" : "c492d27c97c343418ad442ea515b8c91", "cacheMaxAge" : 30, "displayField" : "assetid", "description" : "Water Line", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creationdate", "creatorField" : "creator", "editDateField" : "lastupdate", "editorField" : "updatedby" }, "editingInfo" : { "lastEditDate" : 1726692524499, "schemaLastEditDate" : 1726692524499, "dataLastEditDate" : 1726692524499 }, "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", "units" : "esriFeet" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 5000, "maxScale" : 0, "extent" : { "xmin" : 1565122.9290063083, "ymin" : 516393.60298489034, "xmax" : 1574371.300601393, "ymax" : 522186.18720023334, "spatialReference" : { "wkid" : 102700, "latestWkid" : 102700 } }, "spatialReference" : { "wkid" : 102700, "latestWkid" : 102700 }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"ASSETTYPE","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,178,255,255],"width":1},"defaultLabel":"Other","uniqueValueGroups":[{"heading":"Asset type","classes":[{"label":"Residential Service","description":"Residential Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":1},"values":[["11"]]},{"label":"Institutional Service","description":"Institutional Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,38,115,255],"width":1},"values":[["21"]]},{"label":"Industrial Service","description":"Industrial Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,132,168,255],"width":1},"values":[["13"]]},{"label":"Fire Service","description":"Fire Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":1},"values":[["14"]]},{"label":"Hydrant Service","description":"Hydrant Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[168,0,0,255],"width":1.5},"values":[["15"]]},{"label":"Irrigation Service","description":"Irrigation Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":1},"values":[["16"]]},{"label":"Commercial Service","description":"Commercial Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[68,137,112,255],"width":1},"values":[["12"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":1},"value":"11","label":"Residential Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,38,115,255],"width":1},"value":"21","label":"Institutional Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,132,168,255],"width":1},"value":"13","label":"Industrial Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":1},"value":"14","label":"Fire Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[168,0,0,255],"width":1.5},"value":"15","label":"Hydrant Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":1},"value":"16","label":"Irrigation Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[68,137,112,255],"width":1},"value":"12","label":"Commercial Service"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[0,76,168,255],"toColor":[0,76,168,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : 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" : "material", "type" : "esriFieldTypeSmallInteger", "alias" : "Material", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "designtype", "type" : "esriFieldTypeSmallInteger", "alias" : "Water Type", "sqlType" : "sqlTypeOther", "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" : "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" : "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" : "installdate", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "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" : "adddetails", "type" : "esriFieldTypeSmallInteger", "alias" : "Additional Details", "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" : "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" : "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" : "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" : "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" : "FROMDEVICETERMINAL", "type" : "esriFieldTypeSmallInteger", "alias" : "From device terminal", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "MSU_WaterUN_274_TerminalNames", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "The terminal names in the utility network.", "codedValues" : [ { "name" : "None", "code" : 0 }, { "name" : "Single Terminal", "code" : 1 }, { "name" : "High Pressure In", "code" : 2 }, { "name" : "Low Pressure Out", "code" : 3 }, { "name" : "Low Pressure In", "code" : 4 }, { "name" : "High Pressure Out", "code" : 5 }, { "name" : "Inlet Port", "code" : 6 }, { "name" : "Outlet Port", "code" : 7 }, { "name" : "Port One", "code" : 8 }, { "name" : "Port Two", "code" : 9 }, { "name" : "Terminal One", "code" : 10 }, { "name" : "Terminal Two", "code" : 11 }, { "name" : "Terminal Three", "code" : 12 }, { "name" : "Terminal Four", "code" : 13 }, { "name" : "Terminal Five", "code" : 14 }, { "name" : "Terminal Six", "code" : 15 }, { "name" : "Terminal Seven", "code" : 16 }, { "name" : "Terminal Eight", "code" : 17 }, { "name" : "Terminal One", "code" : 18 }, { "name" : "Terminal Two", "code" : 19 }, { "name" : "Terminal Three", "code" : 20 }, { "name" : "Terminal Four", "code" : 21 }, { "name" : "Terminal Five", "code" : 22 }, { "name" : "Terminal Six", "code" : 23 }, { "name" : "Terminal Seven", "code" : 24 }, { "name" : "Terminal Eight", "code" : 25 }, { "name" : "Upstream", "code" : 26 }, { "name" : "Upstream 2", "code" : 27 }, { "name" : "Downstream", "code" : 28 }, { "name" : "Downstream 2", "code" : 29 }, { "name" : "Inlet Port", "code" : 30 }, { "name" : "Outlet Port", "code" : 31 }, { "name" : "Port One", "code" : 32 }, { "name" : "Port Two", "code" : 33 } ] }, "defaultValue" : 0 }, { "name" : "TODEVICETERMINAL", "type" : "esriFieldTypeSmallInteger", "alias" : "To device terminal", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "MSU_WaterUN_274_TerminalNames", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "The terminal names in the utility network.", "codedValues" : [ { "name" : "None", "code" : 0 }, { "name" : "Single Terminal", "code" : 1 }, { "name" : "High Pressure In", "code" : 2 }, { "name" : "Low Pressure Out", "code" : 3 }, { "name" : "Low Pressure In", "code" : 4 }, { "name" : "High Pressure Out", "code" : 5 }, { "name" : "Inlet Port", "code" : 6 }, { "name" : "Outlet Port", "code" : 7 }, { "name" : "Port One", "code" : 8 }, { "name" : "Port Two", "code" : 9 }, { "name" : "Terminal One", "code" : 10 }, { "name" : "Terminal Two", "code" : 11 }, { "name" : "Terminal Three", "code" : 12 }, { "name" : "Terminal Four", "code" : 13 }, { "name" : "Terminal Five", "code" : 14 }, { "name" : "Terminal Six", "code" : 15 }, { "name" : "Terminal Seven", "code" : 16 }, { "name" : "Terminal Eight", "code" : 17 }, { "name" : "Terminal One", "code" : 18 }, { "name" : "Terminal Two", "code" : 19 }, { "name" : "Terminal Three", "code" : 20 }, { "name" : "Terminal Four", "code" : 21 }, { "name" : "Terminal Five", "code" : 22 }, { "name" : "Terminal Six", "code" : 23 }, { "name" : "Terminal Seven", "code" : 24 }, { "name" : "Terminal Eight", "code" : 25 }, { "name" : "Upstream", "code" : 26 }, { "name" : "Upstream 2", "code" : 27 }, { "name" : "Downstream", "code" : 28 }, { "name" : "Downstream 2", "code" : 29 }, { "name" : "Inlet Port", "code" : 30 }, { "name" : "Outlet Port", "code" : 31 }, { "name" : "Port One", "code" : 32 }, { "name" : "Port Two", "code" : 33 } ] }, "defaultValue" : 0 }, { "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" : "cpsubnetworkname", "type" : "esriFieldTypeString", "alias" : "CP 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" : "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" : "VALIDATIONSTATUS", "type" : "esriFieldTypeSmallInteger", "alias" : "Validation status", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : false, "domain" : { "type" : "codedValue", "name" : "Validation Status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "The current record's validation status.", "codedValues" : [ { "name" : "No calculation required, no validation required, no error", "code" : 0 }, { "name" : "No calculation required, no validation required, has error(s)", "code" : 1 }, { "name" : "No calculation required, validation required, no error", "code" : 2 }, { "name" : "No calculation required, validation required, has error(s)", "code" : 3 }, { "name" : "Calculation required, no validation required, no error", "code" : 4 }, { "name" : "Calculation required, no validation required, has error(s)", "code" : 5 }, { "name" : "Calculation required, validation required, no error", "code" : 6 }, { "name" : "Calculation required, validation required, has error(s)", "code" : 7 } ] }, "defaultValue" : 6 }, { "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 }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__UN_SIMPL__F4B70D85C54942DD", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_74890.UN_SIMPLE_NETWORK_WATER_WATER_LINE_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "I223GLOBALID", "fields" : "GLOBALID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "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" : 11, "name" : "Residential Service", "domains" : { "lifecyclestatus" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "accesstype" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "11", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "FROMDEVICETERMINAL" : 0, "ASSETGROUP" : 0, "ASSETTYPE" : 11, "assetid" : null, "diameter" : null, "material" : null, "designtype" : null, "measuredlength" : null, "lifecyclestatus" : 0, "ownedby" : 1, "maintby" : 1, "installdate" : null, "inservicedate" : null, "retireddate" : null, "spatialsource" : null, "spatialconfidence" : null, "adddetails" : null, "notes" : null, "bondedinsulated" : null, "cptraceability" : 0, "cpoverride" : null, "accesstype" : 0, "TODEVICETERMINAL" : 0 } } } ] }, { "id" : 21, "name" : "Institutional Service", "domains" : { "lifecyclestatus" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "accesstype" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "21", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "FROMDEVICETERMINAL" : 0, "ASSETGROUP" : 0, "ASSETTYPE" : 21, "assetid" : null, "diameter" : null, "material" : null, "designtype" : null, "measuredlength" : null, "lifecyclestatus" : 0, "ownedby" : 1, "maintby" : 1, "installdate" : null, "inservicedate" : null, "retireddate" : null, "spatialsource" : null, "spatialconfidence" : null, "adddetails" : null, "notes" : null, "bondedinsulated" : null, "cptraceability" : 0, "cpoverride" : null, "accesstype" : 0, "TODEVICETERMINAL" : 0 } } } ] }, { "id" : 13, "name" : "Industrial Service", "domains" : { "lifecyclestatus" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "accesstype" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "13", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "FROMDEVICETERMINAL" : 0, "ASSETGROUP" : 0, "ASSETTYPE" : 13, "assetid" : null, "diameter" : null, "material" : null, "designtype" : null, "measuredlength" : null, "lifecyclestatus" : 0, "ownedby" : 1, "maintby" : 1, "installdate" : null, "inservicedate" : null, "retireddate" : null, "spatialsource" : null, "spatialconfidence" : null, "adddetails" : null, "notes" : null, "bondedinsulated" : null, "cptraceability" : 0, "cpoverride" : null, "accesstype" : 0, "TODEVICETERMINAL" : 0 } } } ] }, { "id" : 14, "name" : "Fire Service", "domains" : { "lifecyclestatus" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "accesstype" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "14", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "FROMDEVICETERMINAL" : 0, "ASSETGROUP" : 0, "ASSETTYPE" : 14, "assetid" : null, "diameter" : null, "material" : null, "designtype" : null, "measuredlength" : null, "lifecyclestatus" : 0, "ownedby" : 1, "maintby" : 1, "installdate" : null, "inservicedate" : null, "retireddate" : null, "spatialsource" : null, "spatialconfidence" : null, "adddetails" : null, "notes" : null, "bondedinsulated" : null, "cptraceability" : 0, "cpoverride" : null, "accesstype" : 0, "TODEVICETERMINAL" : 0 } } } ] }, { "id" : 15, "name" : "Hydrant Service", "domains" : { "lifecyclestatus" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "accesstype" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "15", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "FROMDEVICETERMINAL" : 0, "ASSETGROUP" : 0, "ASSETTYPE" : 15, "assetid" : null, "diameter" : null, "material" : null, "designtype" : null, "measuredlength" : null, "lifecyclestatus" : 0, "ownedby" : 1, "maintby" : 1, "installdate" : null, "inservicedate" : null, "retireddate" : null, "spatialsource" : null, "spatialconfidence" : null, "adddetails" : null, "notes" : null, "bondedinsulated" : null, "cptraceability" : 0, "cpoverride" : null, "accesstype" : 0, "TODEVICETERMINAL" : 0 } } } ] }, { "id" : 16, "name" : "Irrigation Service", "domains" : { "lifecyclestatus" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "accesstype" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "16", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "FROMDEVICETERMINAL" : 0, "ASSETGROUP" : 0, "ASSETTYPE" : 16, "assetid" : null, "diameter" : null, "material" : null, "designtype" : null, "measuredlength" : null, "lifecyclestatus" : 0, "ownedby" : 1, "maintby" : 1, "installdate" : null, "inservicedate" : null, "retireddate" : null, "spatialsource" : null, "spatialconfidence" : null, "adddetails" : null, "notes" : null, "bondedinsulated" : null, "cptraceability" : 0, "cpoverride" : null, "accesstype" : 0, "TODEVICETERMINAL" : 0 } } } ] }, { "id" : 12, "name" : "Commercial Service", "domains" : { "lifecyclestatus" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "accesstype" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "12", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "FROMDEVICETERMINAL" : 0, "ASSETGROUP" : 0, "ASSETTYPE" : 12, "assetid" : null, "diameter" : null, "material" : null, "designtype" : null, "measuredlength" : null, "lifecyclestatus" : 0, "ownedby" : 1, "maintby" : 1, "installdate" : null, "inservicedate" : null, "retireddate" : null, "spatialsource" : null, "spatialconfidence" : null, "adddetails" : null, "notes" : null, "bondedinsulated" : null, "cptraceability" : 0, "cpoverride" : null, "accesstype" : 0, "TODEVICETERMINAL" : 0 } } } ] } ], "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" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query", "definitionQuery" : "ASSETGROUP = 2" }