{ "layers" : [ { "currentVersion" : 12, "id" : 510022, "name" : "WaterMain", "type" : "Feature Layer", "serviceItemId" : "a2bf939eb8064879b98c3859743ce7cc", "cacheMaxAge" : 900, "displayField" : "ASSETTYPE", "description" : "These are the lines which deliver your utility resource. Lines can be connected to other lines, junctions, and devices. Lines can be contained within assemblies. Types include Transmission Main, Distribution Main, Production Main, Drain Line and Overflow Main.", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1777397285647, "schemaLastEditDate" : 1777397285647, "dataLastEditDate" : 1777148431393 }, "relationships" : [ { "id" : 0, "name" : "Get As Built", "relatedTableId" : 315004, "cardinality" : "esriRelCardinalityOneToOne", "role" : "esriRelRoleOrigin", "keyField" : "recordnumber", "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, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "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" : 2311162.217155, "maxScale" : 0, "extent" : { "xmin" : 471310.18894541264, "ymin" : 977021.76745315641, "xmax" : 566417.58534441143, "ymax" : 1111653.6825719923, "spatialReference" : { "wkid" : 2882, "latestWkid" : 2882 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"ASSETTYPE","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":2},"defaultLabel":"","uniqueValueGroups":[{"heading":"Asset type","classes":[{"label":"Unknown","description":"Unknown","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":2},"values":[["0"]]},{"label":"Transmission Main","description":"Transmission Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":2},"values":[["1"]]},{"label":"Distribution Main","description":"Distribution Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":2},"values":[["2"]]},{"label":"Production Main","description":"Production Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":2},"values":[["3"]]},{"label":"Drain Line","description":"Drain Line","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,115,223,255],"width":2},"values":[["4"]]},{"label":"Overflow Main","description":"Overflow Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[169,0,230,255],"width":2},"values":[["5"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":2},"value":"0","label":"Unknown"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":2},"value":"1","label":"Transmission Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":2},"value":"2","label":"Distribution Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":2},"value":"3","label":"Production Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,115,223,255],"width":2},"value":"4","label":"Drain Line"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[169,0,230,255],"width":2},"value":"5","label":"Overflow Main"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[118,115,201,255],"toColor":[118,115,201,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[52,59,250,255],"toColor":[52,59,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,201,242,255],"toColor":[194,201,242,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[68,73,207,255],"toColor":[68,73,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[128,142,194,255],"toColor":[128,142,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[97,121,242,255],"toColor":[97,121,242,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[175,179,250,255],"toColor":[175,179,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[52,85,250,255],"toColor":[52,85,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[52,52,217,255],"toColor":[52,52,217,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[118,143,245,255],"toColor":[118,143,245,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[160,160,250,255],"toColor":[160,160,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[90,106,250,255],"toColor":[90,106,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[162,173,222,255],"toColor":[162,173,222,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"var wlm = $feature.material;\nvar wlmlbl = When(wlm == 0, 'Unknown', wlm == 79, 'Non-Lead Unknown', wlm == 80, 'ABS Plastic', wlm == 81, 'Asbestos Cement', wlm == 83, 'Cast Iron', wlm == 84, 'Copper', wlm == 88, 'Ductile Iron', wlm == 89, 'Galvanized Pipe', wlm == 92, 'Polyethylene', wlm == 93, 'Polypropylene', wlm == 94, 'Polyvinyl Chloride', wlm == 102, 'High Density Polyethylene', wlm == 109, 'Lead', wlm == 110, 'Cross-linked Polyethylene', wlm);\n\nvar wld = $feature.diameter;\nvar wldlbl = When(wld == '0', 'Unknown', wld == 0.375, '3/8\"', wld == 0.5, '1/2\"', wld == 0.625, '5/8\"', wld == 0.75, '3/4\"', wld == 1, '1\"', wld == 1.25, '1 1/4\"', wld == 1.5, '1 1/2\"', wld == 2, '2\"', wld == 2.25, '2 1/4\"', wld == 2.5, '2 1/2\"', wld == 3, '3\"', wld == 4, '4\"', wld == 4.5, '4 1/2\"', wld == 5.25, '5 1/4\"\"', wld == 6, '6\"', wld == 8, '8\"', wld == 10, '10\"', wld == 12, '12\"', wld == 16, '16\"', wld == 24, '24\"', wld);\n\nvar retlbl = wldlbl + ' - ' + wlmlbl;\nreturn retlbl;\n","title":"Custom"},"lineOrientation":"unconstrained","labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"followFeature","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","useClippedGeometry":true,"allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":1128.497176,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,76,115,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Tahoma","size":8,"style":"normal","weight":"normal","decoration":"none"}}}]}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GLOBALID", "typeIdField" : "ASSETTYPE", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "ASSETGROUP", "type" : "esriFieldTypeInteger", "alias" : "Asset group", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : 1, "required" : true }, { "name" : "ASSETTYPE", "type" : "esriFieldTypeSmallInteger", "alias" : "Asset type", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Asset_Type_Water_Line_Water_Main", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "The Asset Types for the Water Line's Asset Group Water Main", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Transmission Main", "code" : 1 }, { "name" : "Distribution Main", "code" : 2 }, { "name" : "Production", "code" : 3 }, { "name" : "Drain", "code" : 4 }, { "name" : "Overflow", "code" : 5 } ] }, "defaultValue" : 0, "required" : true }, { "name" : "ASSOCIATIONSTATUS", "type" : "esriFieldTypeSmallInteger", "alias" : "Association status", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WaterUN_293_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, "required" : true }, { "name" : "ISCONNECTED", "type" : "esriFieldTypeSmallInteger", "alias" : "Is connected", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WaterUN_293_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, "required" : true }, { "name" : "FROMDEVICETERMINAL", "type" : "esriFieldTypeSmallInteger", "alias" : "From device terminal", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WaterUN_293_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" : "Port One", "code" : 18 }, { "name" : "Port Two", "code" : 19 }, { "name" : "Port Three", "code" : 20 } ] }, "defaultValue" : 0, "required" : true }, { "name" : "TODEVICETERMINAL", "type" : "esriFieldTypeSmallInteger", "alias" : "To device terminal", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WaterUN_293_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" : "Port One", "code" : 18 }, { "name" : "Port Two", "code" : 19 }, { "name" : "Port Three", "code" : 20 } ] }, "defaultValue" : 0, "required" : true }, { "name" : "cpsubnetworkname", "type" : "esriFieldTypeString", "alias" : "CP Subnetwork Name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : "Unknown", "required" : true }, { "name" : "SUPPORTEDSUBNETWORKNAME", "type" : "esriFieldTypeString", "alias" : "Supported subnetwork name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : "Unknown", "required" : true }, { "name" : "SUPPORTINGSUBNETWORKNAME", "type" : "esriFieldTypeString", "alias" : "Supporting subnetwork name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : "Unknown", "required" : true }, { "name" : "SystemSubnetworkName", "type" : "esriFieldTypeString", "alias" : "System Subnetwork Name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : "Unknown", "required" : true }, { "name" : "PressureSubnetworkName", "type" : "esriFieldTypeString", "alias" : "Pressure Subnetwork Name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : "Unknown", "required" : true }, { "name" : "IsolationSubnetworkName", "type" : "esriFieldTypeString", "alias" : "Isolation Subnetwork Name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : "Unknown", "required" : true }, { "name" : "DMASubnetworkName", "type" : "esriFieldTypeString", "alias" : "DMA Subnetwork Name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : "Unknown", "required" : true }, { "name" : "FLOWDIRECTION", "type" : "esriFieldTypeSmallInteger", "alias" : "Flow direction", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WaterUN_293_FlowDirection", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Indicates how the feature flows in network.", "codedValues" : [ { "name" : "With digitized", "code" : 1 }, { "name" : "Against digitized", "code" : 2 }, { "name" : "Indeterminate", "code" : 3 } ] }, "defaultValue" : 1, "required" : true }, { "name" : "installdate", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "assetid", "type" : "esriFieldTypeString", "alias" : "Asset ID", "sqlType" : "sqlTypeOther", "length" : 64, "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" : "Water_Asset_Owner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "The owner of the asset", "codedValues" : [ { "name" : "Sarasota County", "code" : 1 }, { "name" : "Private", "code" : 2 }, { "name" : "Bee Ridge Utility", "code" : 7 }, { "name" : "City of North Port", "code" : 8 }, { "name" : "City of Sarasota", "code" : 9 }, { "name" : "City of Venice", "code" : 10 }, { "name" : "Englewood Water District", "code" : 11 }, { "name" : "Pluris Southgate", "code" : 12 }, { "name" : "Sproat-Kiney", "code" : 13 }, { "name" : "Sylvan Lea", "code" : 14 }, { "name" : "Braden River Utilities", "code" : 15 }, { "name" : "Manatee County", "code" : 16 }, { "name" : "Peace River Authority", "code" : 17 }, { "name" : "Other", "code" : 100 } ] }, "defaultValue" : null }, { "name" : "maintby", "type" : "esriFieldTypeSmallInteger", "alias" : "Maintained By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Water_Asset_Manager", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "The manager of the asset", "codedValues" : [ { "name" : "Utilities", "code" : 1 }, { "name" : "Private", "code" : 2 }, { "name" : "Facilities", "code" : 3 }, { "name" : "Parks", "code" : 4 }, { "name" : "School Board", "code" : 5 }, { "name" : "Solid Waste", "code" : 6 }, { "name" : "Bee Ridge Utility", "code" : 7 }, { "name" : "City of North Port", "code" : 8 }, { "name" : "City of Sarasota", "code" : 9 }, { "name" : "City of Venice", "code" : 10 }, { "name" : "Englewood Water District", "code" : 11 }, { "name" : "Pluris Southgate", "code" : 12 }, { "name" : "Sproat-Kiney", "code" : 13 }, { "name" : "Sylvan Lea", "code" : 14 }, { "name" : "Braden River Utilities", "code" : 15 }, { "name" : "Manatee County", "code" : 16 }, { "name" : "Peace River Authority", "code" : 17 }, { "name" : "Other", "code" : 100 } ] }, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "diameter", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Water_Main_Diameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "List of transmission main sizes, in Imperial units", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 } ] }, "defaultValue" : null }, { "name" : "pipelocation", "type" : "esriFieldTypeSmallInteger", "alias" : "Pipe Location", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Pipe_Location", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Pipe location - Above or Below Ground", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Below Ground Buried", "code" : 1 }, { "name" : "Below Ground Vault", "code" : 2 }, { "name" : "Below Ground Directional Drill", "code" : 3 }, { "name" : "Above Ground Bridge Mounted", "code" : 4 }, { "name" : "Above Ground Trestle Supported", "code" : 5 }, { "name" : "Above Ground Wall Mounted", "code" : 6 }, { "name" : "Above Ground Stanchion Supported", "code" : 7 }, { "name" : "Above Ground Self Supported", "code" : 8 } ] }, "defaultValue" : null }, { "name" : "measuredlength", "type" : "esriFieldTypeDouble", "alias" : "Measured Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "adddetails", "type" : "esriFieldTypeSmallInteger", "alias" : "adddetails: Color Code, Tracer Wire", "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_1", "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 }, { "name" : "Not Found", "code" : 512 } ] }, "defaultValue" : 0 }, { "name" : "bondedinsulated", "type" : "esriFieldTypeSmallInteger", "alias" : "Bonded/Insulated", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Bonded_Insulated_1", "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_1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Valid Yes, No values", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "No", "code" : 2 } ] }, "defaultValue" : null }, { "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" : "material", "type" : "esriFieldTypeSmallInteger", "alias" : "Material", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Water_Main_Material_1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Materials for water mains", "codedValues" : [ { "name" : "ABS Plastic - ABS", "code" : 80 }, { "name" : "Asbestos Cement - AC", "code" : 81 }, { "name" : "Brick - BR", "code" : 82 }, { "name" : "Cast Iron - CAS", "code" : 83 }, { "name" : "Concrete (Non-Reinforced) - CP", "code" : 85 }, { "name" : "Concrete Segments (Bolted) - CSB", "code" : 86 }, { "name" : "Concrete Segments (Unbolted) - CSU", "code" : 87 }, { "name" : "Copper - COP", "code" : 84 }, { "name" : "Corrugated Pipe - CORR", "code" : 106 }, { "name" : "Ductile Iron - DIP", "code" : 88 }, { "name" : "Fiberglass Reinforced Pipe - FRP", "code" : 104 }, { "name" : "Galvanized Pipe - GP", "code" : 89 }, { "name" : "High Density Polyethylene - HDPE", "code" : 102 }, { "name" : "Non-Lead Unknown - NL", "code" : 79 }, { "name" : "Non-Plastic - NPLA", "code" : 108 }, { "name" : "Pitch Fiber (Orangeburg) - OB", "code" : 90 }, { "name" : "Plastic - PLA", "code" : 107 }, { "name" : "Plastic/Steel Composite - PSC", "code" : 91 }, { "name" : "Polyethylene - PE", "code" : 92 }, { "name" : "Polypropylene - PP", "code" : 93 }, { "name" : "Polyvinyl Chloride - PVC", "code" : 94 }, { "name" : "Pre-stressed Concrete Cylinder Pipe - PCCP", "code" : 98 }, { "name" : "Pre-stressed Concrete Embedded Cylinder Pipe AWWA C-301 - PCPE", "code" : 99 }, { "name" : "Pre-stressed Concrete Lined Cylinder Pipe AWWA C-301 - PCPL", "code" : 100 }, { "name" : "Reinforced Concrete Pipe - RCP", "code" : 105 }, { "name" : "Steel - SP", "code" : 95 }, { "name" : "Steel Cylinder Reinforced Concrete Pipe - SRC", "code" : 101 }, { "name" : "Transite - TTE", "code" : 96 }, { "name" : "Unknown - UNK", "code" : 0 }, { "name" : "Unreinforced Concrete Pipe - URC", "code" : 103 }, { "name" : "Wood - WD", "code" : 97 } ] }, "defaultValue" : null }, { "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" : "designtype", "type" : "esriFieldTypeSmallInteger", "alias" : "Water Type", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Water_Type", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "List of water types", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Potable", "code" : 1 }, { "name" : "Irrigation", "code" : 2 }, { "name" : "Fire", "code" : 3 }, { "name" : "Raw", "code" : 4 }, { "name" : "Intermediate", "code" : 5 }, { "name" : "Finished", "code" : 6 }, { "name" : "Reclaimed", "code" : 7 }, { "name" : "Reject", "code" : 8 }, { "name" : "Treated", "code" : 11 } ] }, "defaultValue" : null }, { "name" : "spatialsource", "type" : "esriFieldTypeSmallInteger", "alias" : "Spatial Source", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Spatial_Source_3", "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" : "Half Section Maps", "code" : 6 }, { "name" : "System Master Map", "code" : 7 }, { "name" : "Surveyed", "code" : 8 }, { "name" : "Valve Mark-up Maps", "code" : 9 }, { "name" : "TV Logs", "code" : 10 }, { "name" : "SUD Billing Data", "code" : 11 }, { "name" : "Field Verified", "code" : 12 } ] }, "defaultValue" : null }, { "name" : "spatialconfidence", "type" : "esriFieldTypeSmallInteger", "alias" : "Spatial Confidence", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Spatial_Confidence_2", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Confidence values for the data", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Survey-Grade", "code" : 1 }, { "name" : "Sub-Foot", "code" : 2 }, { "name" : "Sub-Meter", "code" : 3 } ] }, "defaultValue" : null }, { "name" : "referencedoc", "type" : "esriFieldTypeString", "alias" : "Reference Document", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "recordnumber", "type" : "esriFieldTypeString", "alias" : "Record Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "recordsheetnumber", "type" : "esriFieldTypeString", "alias" : "Record Sheet Number", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "lastupdate", "type" : "esriFieldTypeDate", "alias" : "Last update", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "required" : true, "precision" : 1 }, { "name" : "GLOBALID", "type" : "esriFieldTypeGlobalID", "alias" : "Global ID", "sqlType" : "sqlTypeOther", "length" : 38, "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__WATERDIS__F4B70D855451852B", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_20852.WATERDISTRIBUTIONLINECOLLECTION_WATERMAIN_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GLOBALID", "fields" : "GLOBALID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G51recordnumber", "fields" : "recordnumber", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "designtype_Index", "fields" : "designtype", "isAscending" : true, "isUnique" : false, "description" : "designtype_Index", "indexType" : "Attribute" }, { "name" : "lifecyclestatus_Index", "fields" : "lifecyclestatus", "isAscending" : true, "isUnique" : false, "description" : "lifecyclestatus_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : 0, "name" : "Unknown", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Unknown", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 0, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "pipelocation" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "referencedoc" : null, "recordnumber" : null, "recordsheetnumber" : null } } } ] }, { "id" : 1, "name" : "Transmission Main", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Transmission Main", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 1, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "pipelocation" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "referencedoc" : null, "recordnumber" : null, "recordsheetnumber" : null } } } ] }, { "id" : 2, "name" : "Distribution Main", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Distribution Main", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 2, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "pipelocation" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "referencedoc" : null, "recordnumber" : null, "recordsheetnumber" : null } } } ] }, { "id" : 3, "name" : "Production Main", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Production", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 3, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "pipelocation" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "referencedoc" : null, "recordnumber" : null, "recordsheetnumber" : null } } } ] }, { "id" : 4, "name" : "Drain Line", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Drain", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 4, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "pipelocation" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "referencedoc" : null, "recordnumber" : null, "recordsheetnumber" : null } } } ] }, { "id" : 5, "name" : "Overflow Main", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Overflow", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 5, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "pipelocation" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "referencedoc" : null, "recordnumber" : null, "recordsheetnumber" : 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" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract", "subtypeField" : "ASSETGROUP", "defaultSubtypeCode" : 1, "subtypes" : [ { "code" : 1, "name" : "Water Main", "defaultValues" : { "ASSETGROUP" : 1, "ASSETTYPE" : null, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 2, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : "Unknown", "SUPPORTEDSUBNETWORKNAME" : "Unknown", "SUPPORTINGSUBNETWORKNAME" : "Unknown", "SystemSubnetworkName" : "Unknown", "PressureSubnetworkName" : "Unknown", "IsolationSubnetworkName" : "Unknown", "DMASubnetworkName" : "Unknown", "FLOWDIRECTION" : 1, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "pipelocation" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 8, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "referencedoc" : null, "recordnumber" : null, "recordsheetnumber" : null, "lastupdate" : null }, "domains" : { "ASSETTYPE" : { "type" : "codedValue", "name" : "Asset_Type_Water_Line_Water_Main", "description" : "The Asset Types for the Water Line's Asset Group Water Main", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Transmission Main", "code" : 1 }, { "name" : "Distribution Main", "code" : 2 }, { "name" : "Production", "code" : 3 }, { "name" : "Drain", "code" : 4 }, { "name" : "Overflow", "code" : 5 } ] }, "ASSOCIATIONSTATUS" : { "type" : "codedValue", "name" : "WaterUN_293_AssociationStatus", "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 } ] }, "ISCONNECTED" : { "type" : "codedValue", "name" : "WaterUN_293_IsConnected", "description" : "Indicates if the feature is connected to a subnetwork controller.", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "FROMDEVICETERMINAL" : { "type" : "codedValue", "name" : "WaterUN_293_TerminalNames", "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" : "Port One", "code" : 18 }, { "name" : "Port Two", "code" : 19 }, { "name" : "Port Three", "code" : 20 } ] }, "TODEVICETERMINAL" : { "type" : "codedValue", "name" : "WaterUN_293_TerminalNames", "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" : "Port One", "code" : 18 }, { "name" : "Port Two", "code" : 19 }, { "name" : "Port Three", "code" : 20 } ] }, "FLOWDIRECTION" : { "type" : "codedValue", "name" : "WaterUN_293_FlowDirection", "description" : "Indicates how the feature flows in network.", "codedValues" : [ { "name" : "With digitized", "code" : 1 }, { "name" : "Against digitized", "code" : 2 }, { "name" : "Indeterminate", "code" : 3 } ] }, "ownedby" : { "type" : "codedValue", "name" : "Water_Asset_Owner", "description" : "The owner of the asset", "codedValues" : [ { "name" : "Sarasota County", "code" : 1 }, { "name" : "Private", "code" : 2 }, { "name" : "Bee Ridge Utility", "code" : 7 }, { "name" : "City of North Port", "code" : 8 }, { "name" : "City of Sarasota", "code" : 9 }, { "name" : "City of Venice", "code" : 10 }, { "name" : "Englewood Water District", "code" : 11 }, { "name" : "Pluris Southgate", "code" : 12 }, { "name" : "Sproat-Kiney", "code" : 13 }, { "name" : "Sylvan Lea", "code" : 14 }, { "name" : "Braden River Utilities", "code" : 15 }, { "name" : "Manatee County", "code" : 16 }, { "name" : "Peace River Authority", "code" : 17 }, { "name" : "Other", "code" : 100 } ] }, "maintby" : { "type" : "codedValue", "name" : "Water_Asset_Manager", "description" : "The manager of the asset", "codedValues" : [ { "name" : "Utilities", "code" : 1 }, { "name" : "Private", "code" : 2 }, { "name" : "Facilities", "code" : 3 }, { "name" : "Parks", "code" : 4 }, { "name" : "School Board", "code" : 5 }, { "name" : "Solid Waste", "code" : 6 }, { "name" : "Bee Ridge Utility", "code" : 7 }, { "name" : "City of North Port", "code" : 8 }, { "name" : "City of Sarasota", "code" : 9 }, { "name" : "City of Venice", "code" : 10 }, { "name" : "Englewood Water District", "code" : 11 }, { "name" : "Pluris Southgate", "code" : 12 }, { "name" : "Sproat-Kiney", "code" : 13 }, { "name" : "Sylvan Lea", "code" : 14 }, { "name" : "Braden River Utilities", "code" : 15 }, { "name" : "Manatee County", "code" : 16 }, { "name" : "Peace River Authority", "code" : 17 }, { "name" : "Other", "code" : 100 } ] }, "diameter" : { "type" : "codedValue", "name" : "Water_Main_Diameter", "description" : "List of transmission main sizes, in Imperial units", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 } ] }, "pipelocation" : { "type" : "codedValue", "name" : "Pipe_Location", "description" : "Pipe location - Above or Below Ground", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Below Ground Buried", "code" : 1 }, { "name" : "Below Ground Vault", "code" : 2 }, { "name" : "Below Ground Directional Drill", "code" : 3 }, { "name" : "Above Ground Bridge Mounted", "code" : 4 }, { "name" : "Above Ground Trestle Supported", "code" : 5 }, { "name" : "Above Ground Wall Mounted", "code" : 6 }, { "name" : "Above Ground Stanchion Supported", "code" : 7 }, { "name" : "Above Ground Self Supported", "code" : 8 } ] }, "lifecyclestatus" : { "type" : "codedValue", "name" : "Lifecycle_Status_1", "description" : "Valid lifecycle states for the assets.", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Proposed", "code" : 1 }, { "name" : "Approved", "code" : 2 }, { "name" : "Under Construction", "code" : 4 }, { "name" : "In Service", "code" : 8 }, { "name" : "To Be Retired", "code" : 16 }, { "name" : "Abandoned", "code" : 32 }, { "name" : "Retired", "code" : 64 }, { "name" : "Removed", "code" : 128 }, { "name" : "Out of Service", "code" : 256 }, { "name" : "Not Found", "code" : 512 } ] }, "bondedinsulated" : { "type" : "codedValue", "name" : "Bonded_Insulated_1", "description" : "Values to indicate if a feature is bonded or insulated", "codedValues" : [ { "name" : "Bonded", "code" : 1 }, { "name" : "Insulated", "code" : 2 } ] }, "cptraceability" : { "type" : "codedValue", "name" : "Yes_No_1", "description" : "Valid Yes, No values", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "No", "code" : 2 } ] }, "material" : { "type" : "codedValue", "name" : "Water_Main_Material_1", "description" : "Materials for water mains", "codedValues" : [ { "name" : "ABS Plastic - ABS", "code" : 80 }, { "name" : "Asbestos Cement - AC", "code" : 81 }, { "name" : "Brick - BR", "code" : 82 }, { "name" : "Cast Iron - CAS", "code" : 83 }, { "name" : "Concrete (Non-Reinforced) - CP", "code" : 85 }, { "name" : "Concrete Segments (Bolted) - CSB", "code" : 86 }, { "name" : "Concrete Segments (Unbolted) - CSU", "code" : 87 }, { "name" : "Copper - COP", "code" : 84 }, { "name" : "Corrugated Pipe - CORR", "code" : 106 }, { "name" : "Ductile Iron - DIP", "code" : 88 }, { "name" : "Fiberglass Reinforced Pipe - FRP", "code" : 104 }, { "name" : "Galvanized Pipe - GP", "code" : 89 }, { "name" : "High Density Polyethylene - HDPE", "code" : 102 }, { "name" : "Non-Lead Unknown - NL", "code" : 79 }, { "name" : "Non-Plastic - NPLA", "code" : 108 }, { "name" : "Pitch Fiber (Orangeburg) - OB", "code" : 90 }, { "name" : "Plastic - PLA", "code" : 107 }, { "name" : "Plastic/Steel Composite - PSC", "code" : 91 }, { "name" : "Polyethylene - PE", "code" : 92 }, { "name" : "Polypropylene - PP", "code" : 93 }, { "name" : "Polyvinyl Chloride - PVC", "code" : 94 }, { "name" : "Pre-stressed Concrete Cylinder Pipe - PCCP", "code" : 98 }, { "name" : "Pre-stressed Concrete Embedded Cylinder Pipe AWWA C-301 - PCPE", "code" : 99 }, { "name" : "Pre-stressed Concrete Lined Cylinder Pipe AWWA C-301 - PCPL", "code" : 100 }, { "name" : "Reinforced Concrete Pipe - RCP", "code" : 105 }, { "name" : "Steel - SP", "code" : 95 }, { "name" : "Steel Cylinder Reinforced Concrete Pipe - SRC", "code" : 101 }, { "name" : "Transite - TTE", "code" : 96 }, { "name" : "Unknown - UNK", "code" : 0 }, { "name" : "Unreinforced Concrete Pipe - URC", "code" : 103 }, { "name" : "Wood - WD", "code" : 97 } ] }, "cpoverride" : { "type" : "codedValue", "name" : "CP_Traceability", "description" : "Valid cathodic protection status values", "codedValues" : [ { "name" : "Traceable", "code" : 1 }, { "name" : "Not Traceable", "code" : 2 } ] }, "designtype" : { "type" : "codedValue", "name" : "Water_Type", "description" : "List of water types", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Potable", "code" : 1 }, { "name" : "Irrigation", "code" : 2 }, { "name" : "Fire", "code" : 3 }, { "name" : "Raw", "code" : 4 }, { "name" : "Intermediate", "code" : 5 }, { "name" : "Finished", "code" : 6 }, { "name" : "Reclaimed", "code" : 7 }, { "name" : "Reject", "code" : 8 }, { "name" : "Treated", "code" : 11 } ] }, "spatialsource" : { "type" : "codedValue", "name" : "Spatial_Source_3", "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" : "Half Section Maps", "code" : 6 }, { "name" : "System Master Map", "code" : 7 }, { "name" : "Surveyed", "code" : 8 }, { "name" : "Valve Mark-up Maps", "code" : 9 }, { "name" : "TV Logs", "code" : 10 }, { "name" : "SUD Billing Data", "code" : 11 }, { "name" : "Field Verified", "code" : 12 } ] }, "spatialconfidence" : { "type" : "codedValue", "name" : "Spatial_Confidence_2", "description" : "Confidence values for the data", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Survey-Grade", "code" : 1 }, { "name" : "Sub-Foot", "code" : 2 }, { "name" : "Sub-Meter", "code" : 3 } ] } } } ] }, { "currentVersion" : 12, "id" : 510023, "name" : "ServiceLine", "type" : "Feature Layer", "serviceItemId" : "a2bf939eb8064879b98c3859743ce7cc", "cacheMaxAge" : 900, "displayField" : "ASSETTYPE", "description" : "Water Service Lines provide service to the Water Devices. They can be connected to other lines, junctions, and devices. Lines can be contained within assemblies. Types include Residential, Commercial, Industrial, Fire, Hydrant, Irrigation, Sampling, Blow Off and Air and Vacuum.", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1777397260399, "schemaLastEditDate" : 1777397260399, "dataLastEditDate" : 1777148468088 }, "relationships" : [ { "id" : 1, "name" : "Get As Built", "relatedTableId" : 315004, "cardinality" : "esriRelCardinalityOneToOne", "role" : "esriRelRoleOrigin", "keyField" : "recordnumber", "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, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "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" : 36111.909643, "maxScale" : 0, "extent" : { "xmin" : 471363.07269791141, "ymin" : 977021.0811028257, "xmax" : 565040.58481757715, "ymax" : 1110925.3438055739, "spatialReference" : { "wkid" : 2882, "latestWkid" : 2882 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"ASSETTYPE","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":1},"defaultLabel":"","uniqueValueGroups":[{"heading":"Asset type","classes":[{"label":"Unknown","description":"Unknown","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[66,66,66,255],"width":1},"values":[["0"]]},{"label":"Residential Service","description":"Residential Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":1},"values":[["11"]]},{"label":"Commercial Service","description":"Commercial Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":1},"values":[["12"]]},{"label":"Industrial Service","description":"Industrial Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,0,169,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":[230,152,0,255],"width":1},"values":[["15"]]},{"label":"Irrigation Service","description":"Irrigation Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":1},"values":[["16"]]},{"label":"Sampling Service","description":"Sampling Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[125,125,125,255],"width":1},"values":[["17"]]},{"label":"Blow Off Service","description":"Blow Off Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[176,174,174,255],"width":1},"values":[["18"]]},{"label":"Air Release Service","description":"Air Release Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[170,102,205,255],"width":1},"values":[["19"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[66,66,66,255],"width":1},"value":"0","label":"Unknown"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":1},"value":"11","label":"Residential Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":1},"value":"12","label":"Commercial Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,0,169,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":[230,152,0,255],"width":1},"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":[125,125,125,255],"width":1},"value":"17","label":"Sampling Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[176,174,174,255],"width":1},"value":"18","label":"Blow Off Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[170,102,205,255],"width":1},"value":"19","label":"Air Release Service"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[145,144,144,255],"toColor":[145,144,144,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[38,38,38,255],"toColor":[38,38,38,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[250,250,250,255],"toColor":[250,250,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[87,87,87,255],"toColor":[87,87,87,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,194,194,255],"toColor":[194,194,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[59,59,59,255],"toColor":[59,59,59,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[117,117,117,255],"toColor":[117,117,117,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[168,168,168,255],"toColor":[168,168,168,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[222,220,220,255],"toColor":[222,220,220,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[48,48,48,255],"toColor":[48,48,48,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[74,73,73,255],"toColor":[74,73,73,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[99,99,99,255],"toColor":[99,99,99,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,179,179,255],"toColor":[179,179,179,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"var wlm = $feature.material;\nvar wlmlbl = When(wlm == 0, 'Unknown', wlm == 79, 'Non-Lead Unknown', wlm == 80, 'ABS Plastic', wlm == 81, 'Asbestos Cement', wlm == 83, 'Cast Iron', wlm == 84, 'Copper', wlm == 88, 'Ductile Iron', wlm == 89, 'Galvanized Pipe', wlm == 92, 'Polyethylene', wlm == 93, 'Polypropylene', wlm == 94, 'Polyvinyl Chloride', wlm == 102, 'High Density Polyethylene', wlm == 109, 'Lead', wlm == 110, 'Cross-linked Polyethylene', wlm);\n\nvar wld = $feature.diameter;\nvar wldlbl = When(wld == 0, 'Unknown', wld == 0.375, '3/8\"', wld == 0.5, '1/2\"', wld == 0.625, '5/8\"', wld == 0.75, '3/4\"', wld == 1, '1\"', wld == 1.25, '1 1/4\"', wld == 1.5, '1 1/2\"', wld == 2, '2\"', wld == 2.25, '2 1/4\"', wld == 2.5, '2 1/2\"', wld == 3, '3\"', wld == 4, '4\"', wld == 4.5, '4 1/2\"', wld == 5.25, '5 1/4\"\"', wld == 6, '6\"', wld == 8, '8\"', wld == 10, '10\"', wld == 12, '12\"', wld == 16, '16\"', wld == 24, '24\"', wld);\n\nvar retlbl = wldlbl + ' - ' + wlmlbl;\nreturn retlbl;","title":"Custom"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","useClippedGeometry":true,"stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":282.124294,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Tahoma","size":8,"style":"normal","weight":"normal","decoration":"none"}}}]}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GLOBALID", "typeIdField" : "ASSETTYPE", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "ASSETGROUP", "type" : "esriFieldTypeInteger", "alias" : "Asset group", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : 2, "required" : true }, { "name" : "ASSETTYPE", "type" : "esriFieldTypeSmallInteger", "alias" : "Asset type", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Asset_Type_Water_Line_Service_1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "The Asset Types for the Water Line's Asset Group Service", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Residential Service", "code" : 11 }, { "name" : "Commercial Service", "code" : 12 }, { "name" : "Industrial Service", "code" : 13 }, { "name" : "Fire Service", "code" : 14 }, { "name" : "Hydrant Service", "code" : 15 }, { "name" : "Irrigation Service", "code" : 16 }, { "name" : "Sampling Service", "code" : 17 }, { "name" : "Blow Off Service", "code" : 18 }, { "name" : "Air Release Service", "code" : 19 } ] }, "defaultValue" : 0, "required" : true }, { "name" : "ASSOCIATIONSTATUS", "type" : "esriFieldTypeSmallInteger", "alias" : "Association status", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WaterUN_293_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, "required" : true }, { "name" : "ISCONNECTED", "type" : "esriFieldTypeSmallInteger", "alias" : "Is connected", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WaterUN_293_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, "required" : true }, { "name" : "FROMDEVICETERMINAL", "type" : "esriFieldTypeSmallInteger", "alias" : "From device terminal", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WaterUN_293_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" : "Port One", "code" : 18 }, { "name" : "Port Two", "code" : 19 }, { "name" : "Port Three", "code" : 20 } ] }, "defaultValue" : 0, "required" : true }, { "name" : "TODEVICETERMINAL", "type" : "esriFieldTypeSmallInteger", "alias" : "To device terminal", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WaterUN_293_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" : "Port One", "code" : 18 }, { "name" : "Port Two", "code" : 19 }, { "name" : "Port Three", "code" : 20 } ] }, "defaultValue" : 0, "required" : true }, { "name" : "cpsubnetworkname", "type" : "esriFieldTypeString", "alias" : "CP Subnetwork Name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : "Unknown", "required" : true }, { "name" : "SUPPORTEDSUBNETWORKNAME", "type" : "esriFieldTypeString", "alias" : "Supported subnetwork name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : "Unknown", "required" : true }, { "name" : "SUPPORTINGSUBNETWORKNAME", "type" : "esriFieldTypeString", "alias" : "Supporting subnetwork name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : "Unknown", "required" : true }, { "name" : "SystemSubnetworkName", "type" : "esriFieldTypeString", "alias" : "System Subnetwork Name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : "Unknown", "required" : true }, { "name" : "PressureSubnetworkName", "type" : "esriFieldTypeString", "alias" : "Pressure Subnetwork Name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : "Unknown", "required" : true }, { "name" : "IsolationSubnetworkName", "type" : "esriFieldTypeString", "alias" : "Isolation Subnetwork Name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : "Unknown", "required" : true }, { "name" : "DMASubnetworkName", "type" : "esriFieldTypeString", "alias" : "DMA Subnetwork Name", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : "Unknown", "required" : true }, { "name" : "FLOWDIRECTION", "type" : "esriFieldTypeSmallInteger", "alias" : "Flow direction", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WaterUN_293_FlowDirection", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Indicates how the feature flows in network.", "codedValues" : [ { "name" : "With digitized", "code" : 1 }, { "name" : "Against digitized", "code" : 2 }, { "name" : "Indeterminate", "code" : 3 } ] }, "defaultValue" : 1, "required" : true }, { "name" : "installdate", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "assetid", "type" : "esriFieldTypeString", "alias" : "Asset ID", "sqlType" : "sqlTypeOther", "length" : 64, "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" : "Water_Asset_Owner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "The owner of the asset", "codedValues" : [ { "name" : "Sarasota County", "code" : 1 }, { "name" : "Private", "code" : 2 }, { "name" : "Bee Ridge Utility", "code" : 7 }, { "name" : "City of North Port", "code" : 8 }, { "name" : "City of Sarasota", "code" : 9 }, { "name" : "City of Venice", "code" : 10 }, { "name" : "Englewood Water District", "code" : 11 }, { "name" : "Pluris Southgate", "code" : 12 }, { "name" : "Sproat-Kiney", "code" : 13 }, { "name" : "Sylvan Lea", "code" : 14 }, { "name" : "Braden River Utilities", "code" : 15 }, { "name" : "Manatee County", "code" : 16 }, { "name" : "Peace River Authority", "code" : 17 }, { "name" : "Other", "code" : 100 } ] }, "defaultValue" : null }, { "name" : "maintby", "type" : "esriFieldTypeSmallInteger", "alias" : "Maintained By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Water_Asset_Manager", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "The manager of the asset", "codedValues" : [ { "name" : "Utilities", "code" : 1 }, { "name" : "Private", "code" : 2 }, { "name" : "Facilities", "code" : 3 }, { "name" : "Parks", "code" : 4 }, { "name" : "School Board", "code" : 5 }, { "name" : "Solid Waste", "code" : 6 }, { "name" : "Bee Ridge Utility", "code" : 7 }, { "name" : "City of North Port", "code" : 8 }, { "name" : "City of Sarasota", "code" : 9 }, { "name" : "City of Venice", "code" : 10 }, { "name" : "Englewood Water District", "code" : 11 }, { "name" : "Pluris Southgate", "code" : 12 }, { "name" : "Sproat-Kiney", "code" : 13 }, { "name" : "Sylvan Lea", "code" : 14 }, { "name" : "Braden River Utilities", "code" : 15 }, { "name" : "Manatee County", "code" : 16 }, { "name" : "Peace River Authority", "code" : 17 }, { "name" : "Other", "code" : 100 } ] }, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 2000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "diameter", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Water_Service_Diameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "General list of service sizes, in Imperial units", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "3/8\"", "code" : 0.375 }, { "name" : "1/2\"", "code" : 0.5 }, { "name" : "5/8\"", "code" : 0.625 }, { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "4 1/2\"", "code" : 4.5 }, { "name" : "5 1/4\"", "code" : 5.25 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "16\"", "code" : 16 }, { "name" : "24\"", "code" : 24 } ] }, "defaultValue" : null }, { "name" : "measuredlength", "type" : "esriFieldTypeDouble", "alias" : "Measured Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "adddetails", "type" : "esriFieldTypeSmallInteger", "alias" : "adddetails: Color Code, Tracer Wire", "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_1", "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 }, { "name" : "Not Found", "code" : 512 } ] }, "defaultValue" : 0 }, { "name" : "bondedinsulated", "type" : "esriFieldTypeSmallInteger", "alias" : "Bonded/Insulated", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Bonded_Insulated_1", "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_1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Valid Yes, No values", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "No", "code" : 2 } ] }, "defaultValue" : null }, { "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" : "material", "type" : "esriFieldTypeSmallInteger", "alias" : "Material", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Water_Service_Material_1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Materials for water service lines", "codedValues" : [ { "name" : "ABS Plastic - ABS", "code" : 80 }, { "name" : "Asbestos Cement - AC", "code" : 81 }, { "name" : "Cast Iron - CAS", "code" : 83 }, { "name" : "Copper - COP", "code" : 84 }, { "name" : "Cross-linked Polyethylene - PEX", "code" : 110 }, { "name" : "Ductile Iron - DIP", "code" : 88 }, { "name" : "Galvanized Pipe - GP", "code" : 89 }, { "name" : "High Density Polyethylene - HDPE", "code" : 102 }, { "name" : "Lead - LP", "code" : 109 }, { "name" : "Non-Lead Unknown - NL", "code" : 79 }, { "name" : "Polyethylene - PE", "code" : 92 }, { "name" : "Polypropylene - PP", "code" : 93 }, { "name" : "Polyvinyl Chloride - PVC", "code" : 94 }, { "name" : "Unknown - UNK", "code" : 0 } ] }, "defaultValue" : null }, { "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" : "designtype", "type" : "esriFieldTypeSmallInteger", "alias" : "Water Type", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Water_Type", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "List of water types", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Potable", "code" : 1 }, { "name" : "Irrigation", "code" : 2 }, { "name" : "Fire", "code" : 3 }, { "name" : "Raw", "code" : 4 }, { "name" : "Intermediate", "code" : 5 }, { "name" : "Finished", "code" : 6 }, { "name" : "Reclaimed", "code" : 7 }, { "name" : "Reject", "code" : 8 }, { "name" : "Treated", "code" : 11 } ] }, "defaultValue" : null }, { "name" : "spatialsource", "type" : "esriFieldTypeSmallInteger", "alias" : "Spatial Source", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Spatial_Source_3", "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" : "Half Section Maps", "code" : 6 }, { "name" : "System Master Map", "code" : 7 }, { "name" : "Surveyed", "code" : 8 }, { "name" : "Valve Mark-up Maps", "code" : 9 }, { "name" : "TV Logs", "code" : 10 }, { "name" : "SUD Billing Data", "code" : 11 }, { "name" : "Field Verified", "code" : 12 } ] }, "defaultValue" : null }, { "name" : "spatialconfidence", "type" : "esriFieldTypeSmallInteger", "alias" : "Spatial Confidence", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Spatial_Confidence_2", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Confidence values for the data", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Survey-Grade", "code" : 1 }, { "name" : "Sub-Foot", "code" : 2 }, { "name" : "Sub-Meter", "code" : 3 } ] }, "defaultValue" : null }, { "name" : "pipelocation", "type" : "esriFieldTypeSmallInteger", "alias" : "Pipe Location", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Pipe_Location", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Pipe location - Above or Below Ground", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Below Ground Buried", "code" : 1 }, { "name" : "Below Ground Vault", "code" : 2 }, { "name" : "Below Ground Directional Drill", "code" : 3 }, { "name" : "Above Ground Bridge Mounted", "code" : 4 }, { "name" : "Above Ground Trestle Supported", "code" : 5 }, { "name" : "Above Ground Wall Mounted", "code" : 6 }, { "name" : "Above Ground Stanchion Supported", "code" : 7 }, { "name" : "Above Ground Self Supported", "code" : 8 } ] }, "defaultValue" : null }, { "name" : "recordnumber", "type" : "esriFieldTypeString", "alias" : "Record Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "recordsheetnumber", "type" : "esriFieldTypeString", "alias" : "Record Sheet Number", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "lastupdate", "type" : "esriFieldTypeDate", "alias" : "Last update", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "required" : true, "precision" : 1 }, { "name" : "GLOBALID", "type" : "esriFieldTypeGlobalID", "alias" : "Global ID", "sqlType" : "sqlTypeOther", "length" : 38, "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__WATERDIS__F4B70D8539B13FFD", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_20852.WATERDISTRIBUTIONLINECOLLECTION_SERVICELINE_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GLOBALID", "fields" : "GLOBALID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G56recordnumber", "fields" : "recordnumber", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "designtype_Index", "fields" : "designtype", "isAscending" : true, "isUnique" : false, "description" : "designtype_Index", "indexType" : "Attribute" }, { "name" : "lifecyclestatus_Index", "fields" : "lifecyclestatus", "isAscending" : true, "isUnique" : false, "description" : "lifecyclestatus_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : 0, "name" : "Unknown", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Unknown", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 0, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "pipelocation" : null, "recordnumber" : null, "recordsheetnumber" : null } } } ] }, { "id" : 11, "name" : "Residential Service", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Residential Service", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 11, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "pipelocation" : null, "recordnumber" : null, "recordsheetnumber" : null } } } ] }, { "id" : 12, "name" : "Commercial Service", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Commercial Service", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 12, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "pipelocation" : null, "recordnumber" : null, "recordsheetnumber" : null } } } ] }, { "id" : 13, "name" : "Industrial Service", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Industrial Service", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 13, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "pipelocation" : null, "recordnumber" : null, "recordsheetnumber" : null } } } ] }, { "id" : 14, "name" : "Fire Service", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Fire Service", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 14, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "pipelocation" : null, "recordnumber" : null, "recordsheetnumber" : null } } } ] }, { "id" : 15, "name" : "Hydrant Service", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Hydrant Service", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 15, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "pipelocation" : null, "recordnumber" : null, "recordsheetnumber" : null } } } ] }, { "id" : 16, "name" : "Irrigation Service", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Irrigation Service", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 16, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "pipelocation" : null, "recordnumber" : null, "recordsheetnumber" : null } } } ] }, { "id" : 17, "name" : "Sampling Service", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Sampling Service", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 17, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "pipelocation" : null, "recordnumber" : null, "recordsheetnumber" : null } } } ] }, { "id" : 18, "name" : "Blow Off Service", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Blow Off Service", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 18, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "pipelocation" : null, "recordnumber" : null, "recordsheetnumber" : null } } } ] }, { "id" : 19, "name" : "Air Release Service", "domains" : { "ASSETTYPE" : {"type" : "inherited"}, "ASSOCIATIONSTATUS" : {"type" : "inherited"}, "ISCONNECTED" : {"type" : "inherited"}, "FROMDEVICETERMINAL" : {"type" : "inherited"}, "TODEVICETERMINAL" : {"type" : "inherited"}, "FLOWDIRECTION" : {"type" : "inherited"}, "ownedby" : {"type" : "inherited"}, "maintby" : {"type" : "inherited"}, "diameter" : {"type" : "inherited"}, "lifecyclestatus" : {"type" : "inherited"}, "bondedinsulated" : {"type" : "inherited"}, "cptraceability" : {"type" : "inherited"}, "material" : {"type" : "inherited"}, "cpoverride" : {"type" : "inherited"}, "designtype" : {"type" : "inherited"}, "spatialsource" : {"type" : "inherited"}, "spatialconfidence" : {"type" : "inherited"}, "pipelocation" : {"type" : "inherited"}, "VALIDATIONSTATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Air and Vacuum Service", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "ASSETGROUP" : 0, "lastupdate" : null, "ASSETTYPE" : 19, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 0, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : " ", "SUPPORTEDSUBNETWORKNAME" : " ", "SUPPORTINGSUBNETWORKNAME" : " ", "SystemSubnetworkName" : " ", "PressureSubnetworkName" : " ", "IsolationSubnetworkName" : " ", "DMASubnetworkName" : " ", "FLOWDIRECTION" : null, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 0, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "pipelocation" : null, "recordnumber" : null, "recordsheetnumber" : 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" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract", "subtypeField" : "ASSETGROUP", "defaultSubtypeCode" : 2, "subtypes" : [ { "code" : 2, "name" : "Service", "defaultValues" : { "ASSETGROUP" : 2, "ASSETTYPE" : null, "ASSOCIATIONSTATUS" : 0, "ISCONNECTED" : 2, "FROMDEVICETERMINAL" : 0, "TODEVICETERMINAL" : 0, "cpsubnetworkname" : "Unknown", "SUPPORTEDSUBNETWORKNAME" : "Unknown", "SUPPORTINGSUBNETWORKNAME" : "Unknown", "SystemSubnetworkName" : "Unknown", "PressureSubnetworkName" : "Unknown", "IsolationSubnetworkName" : "Unknown", "DMASubnetworkName" : "Unknown", "FLOWDIRECTION" : 1, "installdate" : null, "assetid" : null, "ownedby" : null, "maintby" : null, "notes" : null, "diameter" : null, "measuredlength" : null, "adddetails" : null, "lifecyclestatus" : 8, "bondedinsulated" : null, "cptraceability" : null, "inservicedate" : null, "retireddate" : null, "material" : null, "cpoverride" : null, "designtype" : null, "spatialsource" : null, "spatialconfidence" : null, "pipelocation" : null, "recordnumber" : null, "recordsheetnumber" : null, "lastupdate" : null }, "domains" : { "ASSETTYPE" : { "type" : "codedValue", "name" : "Asset_Type_Water_Line_Service_1", "description" : "The Asset Types for the Water Line's Asset Group Service", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Residential Service", "code" : 11 }, { "name" : "Commercial Service", "code" : 12 }, { "name" : "Industrial Service", "code" : 13 }, { "name" : "Fire Service", "code" : 14 }, { "name" : "Hydrant Service", "code" : 15 }, { "name" : "Irrigation Service", "code" : 16 }, { "name" : "Sampling Service", "code" : 17 }, { "name" : "Blow Off Service", "code" : 18 }, { "name" : "Air Release Service", "code" : 19 } ] }, "ASSOCIATIONSTATUS" : { "type" : "codedValue", "name" : "WaterUN_293_AssociationStatus", "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 } ] }, "ISCONNECTED" : { "type" : "codedValue", "name" : "WaterUN_293_IsConnected", "description" : "Indicates if the feature is connected to a subnetwork controller.", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 }, { "name" : "Unknown", "code" : 2 } ] }, "FROMDEVICETERMINAL" : { "type" : "codedValue", "name" : "WaterUN_293_TerminalNames", "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" : "Port One", "code" : 18 }, { "name" : "Port Two", "code" : 19 }, { "name" : "Port Three", "code" : 20 } ] }, "TODEVICETERMINAL" : { "type" : "codedValue", "name" : "WaterUN_293_TerminalNames", "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" : "Port One", "code" : 18 }, { "name" : "Port Two", "code" : 19 }, { "name" : "Port Three", "code" : 20 } ] }, "FLOWDIRECTION" : { "type" : "codedValue", "name" : "WaterUN_293_FlowDirection", "description" : "Indicates how the feature flows in network.", "codedValues" : [ { "name" : "With digitized", "code" : 1 }, { "name" : "Against digitized", "code" : 2 }, { "name" : "Indeterminate", "code" : 3 } ] }, "ownedby" : { "type" : "codedValue", "name" : "Water_Asset_Owner", "description" : "The owner of the asset", "codedValues" : [ { "name" : "Sarasota County", "code" : 1 }, { "name" : "Private", "code" : 2 }, { "name" : "Bee Ridge Utility", "code" : 7 }, { "name" : "City of North Port", "code" : 8 }, { "name" : "City of Sarasota", "code" : 9 }, { "name" : "City of Venice", "code" : 10 }, { "name" : "Englewood Water District", "code" : 11 }, { "name" : "Pluris Southgate", "code" : 12 }, { "name" : "Sproat-Kiney", "code" : 13 }, { "name" : "Sylvan Lea", "code" : 14 }, { "name" : "Braden River Utilities", "code" : 15 }, { "name" : "Manatee County", "code" : 16 }, { "name" : "Peace River Authority", "code" : 17 }, { "name" : "Other", "code" : 100 } ] }, "maintby" : { "type" : "codedValue", "name" : "Water_Asset_Manager", "description" : "The manager of the asset", "codedValues" : [ { "name" : "Utilities", "code" : 1 }, { "name" : "Private", "code" : 2 }, { "name" : "Facilities", "code" : 3 }, { "name" : "Parks", "code" : 4 }, { "name" : "School Board", "code" : 5 }, { "name" : "Solid Waste", "code" : 6 }, { "name" : "Bee Ridge Utility", "code" : 7 }, { "name" : "City of North Port", "code" : 8 }, { "name" : "City of Sarasota", "code" : 9 }, { "name" : "City of Venice", "code" : 10 }, { "name" : "Englewood Water District", "code" : 11 }, { "name" : "Pluris Southgate", "code" : 12 }, { "name" : "Sproat-Kiney", "code" : 13 }, { "name" : "Sylvan Lea", "code" : 14 }, { "name" : "Braden River Utilities", "code" : 15 }, { "name" : "Manatee County", "code" : 16 }, { "name" : "Peace River Authority", "code" : 17 }, { "name" : "Other", "code" : 100 } ] }, "diameter" : { "type" : "codedValue", "name" : "Water_Service_Diameter", "description" : "General list of service sizes, in Imperial units", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "3/8\"", "code" : 0.375 }, { "name" : "1/2\"", "code" : 0.5 }, { "name" : "5/8\"", "code" : 0.625 }, { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "4 1/2\"", "code" : 4.5 }, { "name" : "5 1/4\"", "code" : 5.25 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "16\"", "code" : 16 }, { "name" : "24\"", "code" : 24 } ] }, "lifecyclestatus" : { "type" : "codedValue", "name" : "Lifecycle_Status_1", "description" : "Valid lifecycle states for the assets.", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Proposed", "code" : 1 }, { "name" : "Approved", "code" : 2 }, { "name" : "Under Construction", "code" : 4 }, { "name" : "In Service", "code" : 8 }, { "name" : "To Be Retired", "code" : 16 }, { "name" : "Abandoned", "code" : 32 }, { "name" : "Retired", "code" : 64 }, { "name" : "Removed", "code" : 128 }, { "name" : "Out of Service", "code" : 256 }, { "name" : "Not Found", "code" : 512 } ] }, "bondedinsulated" : { "type" : "codedValue", "name" : "Bonded_Insulated_1", "description" : "Values to indicate if a feature is bonded or insulated", "codedValues" : [ { "name" : "Bonded", "code" : 1 }, { "name" : "Insulated", "code" : 2 } ] }, "cptraceability" : { "type" : "codedValue", "name" : "Yes_No_1", "description" : "Valid Yes, No values", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Yes", "code" : 1 }, { "name" : "No", "code" : 2 } ] }, "material" : { "type" : "codedValue", "name" : "Water_Service_Material_2", "description" : "Materials for water service lines", "codedValues" : [ { "name" : "ABS Plastic - ABS", "code" : 80 }, { "name" : "Asbestos Cement - AC", "code" : 81 }, { "name" : "Cast Iron - CAS", "code" : 83 }, { "name" : "Copper - COP", "code" : 84 }, { "name" : "Cross-linked Polyethylene - PEX", "code" : 110 }, { "name" : "Ductile Iron - DIP", "code" : 88 }, { "name" : "Galvanized Pipe - GP", "code" : 89 }, { "name" : "High Density Polyethylene - HDPE", "code" : 102 }, { "name" : "Lead - LP", "code" : 109 }, { "name" : "Non-Lead Unknown - NL", "code" : 79 }, { "name" : "Polyethylene - PE", "code" : 92 }, { "name" : "Polypropylene - PP", "code" : 93 }, { "name" : "Polyvinyl Chloride - PVC", "code" : 94 }, { "name" : "Unknown - UNK", "code" : 0 }, { "name" : "Brass - BRAS", "code" : 111 }, { "name" : "Copper Tube Size - CTS", "code" : 112 } ] }, "cpoverride" : { "type" : "codedValue", "name" : "CP_Traceability", "description" : "Valid cathodic protection status values", "codedValues" : [ { "name" : "Traceable", "code" : 1 }, { "name" : "Not Traceable", "code" : 2 } ] }, "designtype" : { "type" : "codedValue", "name" : "Water_Type", "description" : "List of water types", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Potable", "code" : 1 }, { "name" : "Irrigation", "code" : 2 }, { "name" : "Fire", "code" : 3 }, { "name" : "Raw", "code" : 4 }, { "name" : "Intermediate", "code" : 5 }, { "name" : "Finished", "code" : 6 }, { "name" : "Reclaimed", "code" : 7 }, { "name" : "Reject", "code" : 8 }, { "name" : "Treated", "code" : 11 } ] }, "spatialsource" : { "type" : "codedValue", "name" : "Spatial_Source_3", "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" : "Half Section Maps", "code" : 6 }, { "name" : "System Master Map", "code" : 7 }, { "name" : "Surveyed", "code" : 8 }, { "name" : "Valve Mark-up Maps", "code" : 9 }, { "name" : "TV Logs", "code" : 10 }, { "name" : "SUD Billing Data", "code" : 11 }, { "name" : "Field Verified", "code" : 12 } ] }, "spatialconfidence" : { "type" : "codedValue", "name" : "Spatial_Confidence_2", "description" : "Confidence values for the data", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Survey-Grade", "code" : 1 }, { "name" : "Sub-Foot", "code" : 2 }, { "name" : "Sub-Meter", "code" : 3 } ] }, "pipelocation" : { "type" : "codedValue", "name" : "Pipe_Location", "description" : "Pipe location - Above or Below Ground", "codedValues" : [ { "name" : "Unknown", "code" : 0 }, { "name" : "Below Ground Buried", "code" : 1 }, { "name" : "Below Ground Vault", "code" : 2 }, { "name" : "Below Ground Directional Drill", "code" : 3 }, { "name" : "Above Ground Bridge Mounted", "code" : 4 }, { "name" : "Above Ground Trestle Supported", "code" : 5 }, { "name" : "Above Ground Wall Mounted", "code" : 6 }, { "name" : "Above Ground Stanchion Supported", "code" : 7 }, { "name" : "Above Ground Self Supported", "code" : 8 } ] } } } ] } ], "tables" : [ { "currentVersion" : 12, "id" : 315004, "name" : "UtilityAsBuiltTable", "type" : "Table", "serviceItemId" : "a2bf939eb8064879b98c3859743ce7cc", "cacheMaxAge" : 900, "displayField" : "ProjectName", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1777148498558, "schemaLastEditDate" : 1777148498558, "dataLastEditDate" : 1777148468527 }, "relationships" : [ { "id" : 0, "name" : "Get Water Main", "relatedTableId" : 510022, "cardinality" : "esriRelCardinalityOneToOne", "role" : "esriRelRoleDestination", "keyField" : "ABIS_NUMBER", "composite" : false }, { "id" : 1, "name" : "Get Water Lateral", "relatedTableId" : 510023, "cardinality" : "esriRelCardinalityOneToOne", "role" : "esriRelRoleDestination", "keyField" : "ABIS_NUMBER", "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, "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, "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" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "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 }, { "name" : "ABIS_ID", "type" : "esriFieldTypeInteger", "alias" : "ABIS_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ABIS_NUMBER", "type" : "esriFieldTypeString", "alias" : "ABIS_NUMBER", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ProjectName", "type" : "esriFieldTypeString", "alias" : "ProjectName", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LowestHalf", "type" : "esriFieldTypeString", "alias" : "LowestHalf", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AllHalf", "type" : "esriFieldTypeString", "alias" : "AllHalf", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HalfTownships", "type" : "esriFieldTypeString", "alias" : "HalfTownships", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PermitNumber", "type" : "esriFieldTypeString", "alias" : "PermitNumber", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ABISDate", "type" : "esriFieldTypeDate", "alias" : "ABIS Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "WaterSupplierID", "type" : "esriFieldTypeInteger", "alias" : "WaterSupplierID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SewerSupplierID", "type" : "esriFieldTypeInteger", "alias" : "SewerSupplierID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SubdivisionBusiness", "type" : "esriFieldTypeString", "alias" : "SubdivisionBusiness", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SectionTownship", "type" : "esriFieldTypeString", "alias" : "SectionTownship", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EOR", "type" : "esriFieldTypeString", "alias" : "EOR", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pages", "type" : "esriFieldTypeString", "alias" : "Pages", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FranchiseID", "type" : "esriFieldTypeInteger", "alias" : "FranchiseID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Created", "type" : "esriFieldTypeDate", "alias" : "Created", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "COMPLETED", "type" : "esriFieldTypeString", "alias" : "COMPLETED", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "dBoolean_3", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Yes/No", "codedValues" : [ { "name" : "NO", "code" : "0" }, { "name" : "YES", "code" : "1" }, { "name" : "HOLD", "code" : "2" }, { "name" : "UPDATES NEEDED", "code" : "3" } ] }, "defaultValue" : "0" } ], "indexes" : [ { "name" : "PK__WATERDIS__F4B70D8549F00B88", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G52ABIS_NUMBER", "fields" : "ABIS_NUMBER", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "UtilityAsBuiltTable", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Created" : null, "COMPLETED" : "0", "ABIS_ID" : null, "ABIS_NUMBER" : null, "ProjectName" : null, "LowestHalf" : null, "AllHalf" : null, "HalfTownships" : null, "PermitNumber" : null, "ABISDate" : null, "WaterSupplierID" : null, "SewerSupplierID" : null, "SubdivisionBusiness" : null, "SectionTownship" : null, "EOR" : null, "Pages" : null, "Notes" : null, "FranchiseID" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract" } ] }