Layers:

Layer: Water Main (10)


Name: Water Main

Display Field: cpsubnetworkname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 15686

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 4495865.52252296
YMin: 696280.848835308
XMax: 5108908.40168963
YMax: 1010660.68102035
Spatial Reference: 2270 (2270)


Drawing Info:

{"renderer":{"type":"uniqueValue","valueExpression":"//Arcade for wWaterMain\n//Pressure Zone: Zone 1, Zone 2, Zone 3, Zone 4, Zone 5, Zone 6, Zone 7\n//LifeCycleStatus: AB=Abandoned, D=Withdrawn, DC=Removed, I=Active, IN=Inactive, PROP=Proposed\nvar pressure = $feature.pressurezone\nvar subText = ''\nif (pressure == 'Zone 1') {\n subText = 'Zone 1'\n} else if (pressure == 'Zone 2'){\n subText = 'Zone 2'\n} else if (pressure == 'Zone 3') {\n subText = 'Zone 3'\n} else if (pressure == 'Zone 4') {\n subText = 'Zone 4'\n} else if (pressure == 'Zone 5') {\n subText = 'Zone 5'\n} else if (pressure == 'Zone 6') {\n subText = 'Zone 6'\n} else if (pressure == 'Zone 7') {\n subText = 'Zone 7'\n} else if (pressure == 'Airport'){\n subText = 'Airport'\n}\n\nvar lifeCycle = $feature.lifecyclestatus\nvar lifeText = ''\nif (lifeCycle == 32) {\n lifeText = 'Abandoned'\n} else if (lifeCycle == 8) {\n lifeText = 'Active'\n} else if (lifeCycle == 256) {\n lifeText = 'Inactive'\n} else if (lifeCycle == 1) {\n lifeText = 'Proposed'\n}\n\nvar newSubText = ''\nif (lifeText == 'Abandoned' || lifeText == 'Inactive' || lifetext == \"Proposed\"){\n newSubText = 'All'\n} else newSubText = subText \n\nreturn newSubText + \", \" + LifeText","valueExpressionTitle":"PressureZone & LifecycleStatus","uniqueValueGroups":[{"heading":"PressureZone & LifecycleStatus","classes":[{"label":"Zone 1, Active","description":"Zone 1, Active","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":1},"values":[["Zone 1, Active"]]},{"label":"Zone 2, Active","description":"Zone 2, Active","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1},"values":[["Zone 2, Active"]]},{"label":"Zone 3, Active","description":"Zone 3, Active","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":1},"values":[["Zone 3, Active"]]},{"label":"Zone 4, Active","description":"Zone 4, Active","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,0,169,255],"width":1},"values":[["Zone 4, Active"]]},{"label":"Zone 5, Active","description":"Zone 5, Active","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,152,0,255],"width":1},"values":[["Zone 5, Active"]]},{"label":"Zone 6, Active","description":"Zone 6, Active","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,115,0,255],"width":1},"values":[["Zone 6, Active"]]},{"label":"Zone 7, Active","description":"Zone 7, Active","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,255,223,255],"width":1},"values":[["Zone 7, Active"]]},{"label":"Airport, Active","description":"Airport, Active","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1},"values":[["Airport, Active"]]},{"label":"All, Proposed","description":"All, Proposed","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,255,0,255],"width":1},"values":[["All, Proposed"]]},{"label":"All, Inactive","description":"All, Inactive","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,255],"width":1},"values":[["All, Inactive"]]},{"label":"All, Abandoned","description":"All, Abandoned","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":1},"values":[["All, Abandoned"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":1},"value":"Zone 1, Active","label":"Zone 1, Active"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1},"value":"Zone 2, Active","label":"Zone 2, Active"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":1},"value":"Zone 3, Active","label":"Zone 3, Active"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,0,169,255],"width":1},"value":"Zone 4, Active","label":"Zone 4, Active"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,152,0,255],"width":1},"value":"Zone 5, Active","label":"Zone 5, Active"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,115,0,255],"width":1},"value":"Zone 6, Active","label":"Zone 6, Active"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,255,223,255],"width":1},"value":"Zone 7, Active","label":"Zone 7, Active"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1},"value":"Airport, Active","label":"Airport, Active"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,255,0,255],"width":1},"value":"All, Proposed","label":"All, Proposed"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,255],"width":1},"value":"All, Inactive","label":"All, Inactive"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":1},"value":"All, Abandoned","label":"All, Abandoned"}],"fieldDelimiter":";","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[248,252,210,255],"toColor":[248,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[222,179,252,255],"toColor":[222,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,228,252,255],"toColor":[179,228,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,188,255],"toColor":[252,179,188,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,252,179,255],"toColor":[184,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,252,240,255],"toColor":[184,252,240,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,199,252,255],"toColor":[179,199,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,210,240,255],"toColor":[252,210,240,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,209,182,255],"toColor":[252,209,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,220,252,255],"toColor":[212,220,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,252,208,255],"toColor":[204,252,208,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[226,202,252,255],"toColor":[226,202,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,234,212,255],"toColor":[252,234,212,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.AssetID + TextFormatting.NewLine + TextFormatting.NewLine + DomainName($feature, 'Diameter') + \" \" + Trim(First(Split(DomainName($feature, 'Material'), '-')))","title":"Custom"},"labelPlacement":"esriServerLinePlacementCenterAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","useClippedGeometry":true,"allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"all","removeDuplicatesDistance":150,"stackRowLength":24,"where":"lifecyclestatus = 8 Or lifecyclestatus = 1 Or lifecyclestatus = 256","useCodedValues":true,"maxScale":0,"minScale":1128,"name":"Default","priority":-1,"symbol":{"type":"esriTS","color":[0,92,230,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":2,"font":{"family":"Arial","size":9,"style":"normal","weight":"bold","decoration":"none"}}}]}

HasZ: true

HasM: true

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GLOBALID

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ASSETGROUP (type: esriFieldTypeInteger, alias: Asset group, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ASSETTYPE (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ASSOCIATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Association status, SQL Type: sqlTypeOther, nullable: false, editable: false, Coded Values: [0: None], [1: Container], [2: Structure], ... 33 more ...)
• ISCONNECTED (type: esriFieldTypeSmallInteger, alias: Is connected, SQL Type: sqlTypeOther, nullable: false, editable: false, Coded Values: [0: False], [1: True], [2: Unknown])
• FROMDEVICETERMINAL (type: esriFieldTypeSmallInteger, alias: From device terminal, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Single Terminal], [2: High Pressure In], ... 15 more ...)
• TODEVICETERMINAL (type: esriFieldTypeSmallInteger, alias: To device terminal, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Single Terminal], [2: High Pressure In], ... 15 more ...)
• GLOBALID (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• cpsubnetworkname (type: esriFieldTypeString, alias: CP Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
• SUPPORTEDSUBNETWORKNAME (type: esriFieldTypeString, alias: Supported subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
• SUPPORTINGSUBNETWORKNAME (type: esriFieldTypeString, alias: Supporting subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
• SystemSubnetworkName (type: esriFieldTypeString, alias: System Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
• PressureSubnetworkName (type: esriFieldTypeString, alias: Pressure Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
• IsolationSubnetworkName (type: esriFieldTypeString, alias: Isolation Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
• DMASubnetworkName (type: esriFieldTypeString, alias: DMA Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
• creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• diameter (type: esriFieldTypeDouble, alias: diameter: Cable Gauge, Diameter, Wire Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: 1"], [2: 2"], ... 22 more ...)
• measuredlength (type: esriFieldTypeDouble, alias: Measured Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• adddetails (type: esriFieldTypeSmallInteger, alias: adddetails: Color Code, Tracer Wire, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lifecyclestatus (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 14 more ...)
• bondedinsulated (type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Bonded], [2: Insulated])
• cptraceability (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• inservicedate (type: esriFieldTypeDate, alias: In-Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• retireddate (type: esriFieldTypeDate, alias: Retired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• material (type: esriFieldTypeSmallInteger, alias: Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [81: Asbestos Cement - AC], [82: Brick - BR], ... 26 more ...)
• cpoverride (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Traceable], [2: Not Traceable])
• designtype (type: esriFieldTypeSmallInteger, alias: Water Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spatialsource (type: esriFieldTypeSmallInteger, alias: Spatial Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: As-Built], [2: CAD], ... 3 more ...)
• spatialconfidence (type: esriFieldTypeSmallInteger, alias: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: High], [2: Medium], ... 1 more ...)
• GISOBJID (type: esriFieldTypeInteger, alias: GISOBJID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LocationDescription (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InforLifecycleStatus (type: esriFieldTypeString, alias: Infor Lifecycle Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• UPDATE_COUNT (type: esriFieldTypeSmallInteger, alias: UPDATE_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VALIDATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Validation status, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pressurezone (type: esriFieldTypeString, alias: Pressure Zone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Zone 4: Zone 4], [Zone 5: Zone 5], [Zone 6: Zone 6], ... 7 more ...)
• pressuresubzone (type: esriFieldTypeString, alias: Pressure Subzone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [2A: 2A], ... 29 more ...)
• ProjectNumber (type: esriFieldTypeString, alias: ProjectNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Clean_Route (type: esriFieldTypeString, alias: Clean_Route, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Water Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ASSETGROUP: 0
• ASSETTYPE: 0
• VALIDATIONSTATUS: 6
• FROMDEVICETERMINAL: 0
• TODEVICETERMINAL: 0
• ownedby: 1
• maintby: 1
• lifecyclestatus: 0
• cptraceability: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2026 10:33:50 AM

Schema Last Edit Date: 3/6/2026 2:38:23 PM

Data Last Edit Date: 8/13/2026 10:33:50 AM