Name: Water Mains
Display Field: Asset_Type
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description:
Copyright Text:
Min. Scale: 80000
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 16651712.975486
YMin: -2683391.92967839
XMax: 16791287.2532875
YMax: -2585522.06481035
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"Asset_Type","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1},"defaultLabel":"Unknown Main Type","uniqueValueGroups":[{"heading":"","classes":[{"label":"Trunk Main","description":"Trunk Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":2},"values":[["Trunk Main"]]},{"label":"Reticulation Main","description":"Reticulation Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1.3},"values":[["Reticulation Main"]]},{"label":"Raw Water Main","description":"Raw Water Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,178,255,255],"width":2},"values":[["Raw Water Main"]]},{"label":"Scour Line","description":"Scour Line","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1},"values":[["Scour Line"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":2},"value":"Trunk Main","label":"Trunk Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1.3},"value":"Reticulation Main","label":"Reticulation Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,178,255,255],"width":2},"value":"Raw Water Main","label":"Raw Water Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1},"value":"Scour Line","label":"Scour Line"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[62,176,174,255],"toColor":[62,176,174,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[161,34,38,255],"toColor":[161,34,38,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[34,31,128,255],"toColor":[34,31,128,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[156,173,45,255],"toColor":[156,173,45,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[173,68,131,255],"toColor":[173,68,131,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[54,82,135,255],"toColor":[54,82,135,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[161,115,77,255],"toColor":[161,115,77,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[34,130,64,255],"toColor":[34,130,64,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[131,67,163,255],"toColor":[131,67,163,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[148,72,84,255],"toColor":[148,72,84,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[57,173,47,255],"toColor":[57,173,47,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[38,62,150,255],"toColor":[38,62,150,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[125,128,52,255],"toColor":[125,128,52,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field: Asset_Type
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- GIS_ID (type: esriFieldTypeInteger, alias: GIS_ID, SQL Type: sqlTypeOther, nullable: false, editable: true)
- Asset_ID (type: esriFieldTypeInteger, alias: Asset_ID, SQL Type: sqlTypeOther, nullable: false, editable: true)
- Asset_Type (type: esriFieldTypeString, alias: Asset_Type, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true, Coded Values: [Reticulation Main: Reticulation Main], [Trunk Main: Trunk Main], [Scour Line: Scour Line], ... 1 more ...)
- Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true, Coded Values: [ABS: ABS], [AC: AC], [BR: BR], ... 22 more ...)
- Pipe_Class (type: esriFieldTypeString, alias: Pipe_Class, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true, Coded Values: [N/A: N/A], [1: 1], [2: 2], ... 38 more ...)
- Diameter (type: esriFieldTypeInteger, alias: Diameter, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: 0], [25: 25], [32: 32], ... 24 more ...)
- Measured_Length (type: esriFieldTypeDouble, alias: Measured_Length, SQL Type: sqlTypeOther, nullable: false, editable: true)
- Alignment (type: esriFieldTypeDouble, alias: Alignment, SQL Type: sqlTypeOther, nullable: false, editable: true)
- US_ID (type: esriFieldTypeString, alias: US_ID, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
- DS_ID (type: esriFieldTypeString, alias: DS_ID, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
- Joint_Type (type: esriFieldTypeString, alias: Joint_Type, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
- Op_Pressure (type: esriFieldTypeString, alias: Op_Pressure, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true)
- Drawing_No (type: esriFieldTypeString, alias: Drawing_No, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
- Install_Date (type: esriFieldTypeDate, alias: Install_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Comment_Description (type: esriFieldTypeString, alias: Comment_Description, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true)
- Potable (type: esriFieldTypeString, alias: Potable, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true, Coded Values: [Y: Y], [N: N])
- Network (type: esriFieldTypeString, alias: Network, SQL Type: sqlTypeOther, length: 3, nullable: false, editable: true)
- Usertext1 (type: esriFieldTypeString, alias: Usertext1, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
- Usertext2 (type: esriFieldTypeString, alias: Usertext2, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
- Usertext3 (type: esriFieldTypeString, alias: Usertext3, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
- Usertext4 (type: esriFieldTypeString, alias: Usertext4, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
- Userdate1 (type: esriFieldTypeDate, alias: Userdate1, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Userdate2 (type: esriFieldTypeDate, alias: Userdate2, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Data_Integrity (type: esriFieldTypeSmallInteger, alias: Data_Integrity, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
- Object_Integrity (type: esriFieldTypeSmallInteger, alias: Object_Integrity, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
- Old_Asset_ID (type: esriFieldTypeString, alias: Old_Asset_ID, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
- Private (type: esriFieldTypeString, alias: Private, SQL Type: sqlTypeOther, length: 5, nullable: false, editable: true, Coded Values: [Y: Y], [N: N])
- AMS_Status (type: esriFieldTypeString, alias: AMS_Status, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true, Coded Values: [Existing: Existing], [Add: Add], [Modify: Modify], ... 3 more ...)
- DevBnd_GIS_ID (type: esriFieldTypeInteger, alias: DevBnd_GIS_ID, SQL Type: sqlTypeOther, nullable: false, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Types:
ID: Trunk Main
Name: Trunk Main
Domains:
- Field Name: Asset_Type
Inherited
- Field Name: Material
Inherited
- Field Name: Pipe_Class
Inherited
- Field Name: Diameter
Inherited
- Field Name: Potable
Inherited
- Field Name: Data_Integrity
Inherited
- Field Name: Object_Integrity
Inherited
- Field Name: Private
Inherited
- Field Name: AMS_Status
Inherited
Templates:
Name: Trunk Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- Asset_ID: 0
- DevBnd_GIS_ID: 0
- GIS_ID: 0
- Asset_Type: Trunk Main
- Material:
- Pipe_Class:
- Diameter: 0
- Measured_Length: 0
- Alignment: 0
- US_ID:
- DS_ID:
- Joint_Type:
- Op_Pressure:
- Drawing_No:
- Comment_Description:
- Potable: Y
- Network:
- Usertext1:
- Usertext2:
- Usertext3:
- Usertext4:
- Data_Integrity: 5
- Object_Integrity: 5
- Old_Asset_ID:
- Private: N
- AMS_Status: Add
ID: Reticulation Main
Name: Reticulation Main
Domains:
- Field Name: Asset_Type
Inherited
- Field Name: Material
Inherited
- Field Name: Pipe_Class
Inherited
- Field Name: Diameter
Inherited
- Field Name: Potable
Inherited
- Field Name: Data_Integrity
Inherited
- Field Name: Object_Integrity
Inherited
- Field Name: Private
Inherited
- Field Name: AMS_Status
Inherited
Templates:
Name: Reticulation Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- Asset_ID: 0
- DevBnd_GIS_ID: 0
- GIS_ID: 0
- Asset_Type: Reticulation Main
- Material:
- Pipe_Class:
- Diameter: 0
- Measured_Length: 0
- Alignment: 0
- US_ID:
- DS_ID:
- Joint_Type:
- Op_Pressure:
- Drawing_No:
- Comment_Description:
- Potable: Y
- Network:
- Usertext1:
- Usertext2:
- Usertext3:
- Usertext4:
- Data_Integrity: 5
- Object_Integrity: 5
- Old_Asset_ID:
- Private: N
- AMS_Status: Add
ID: Raw Water Main
Name: Raw Water Main
Domains:
- Field Name: Asset_Type
Inherited
- Field Name: Material
Inherited
- Field Name: Pipe_Class
Inherited
- Field Name: Diameter
Inherited
- Field Name: Potable
Inherited
- Field Name: Data_Integrity
Inherited
- Field Name: Object_Integrity
Inherited
- Field Name: Private
Inherited
- Field Name: AMS_Status
Inherited
Templates:
Name: Raw Water Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- Asset_ID: 0
- DevBnd_GIS_ID: 0
- GIS_ID: 0
- Asset_Type: Raw Water Main
- Material:
- Pipe_Class:
- Diameter: 0
- Measured_Length: 0
- Alignment: 0
- US_ID:
- DS_ID:
- Joint_Type:
- Op_Pressure:
- Drawing_No:
- Comment_Description:
- Potable: Y
- Network:
- Usertext1:
- Usertext2:
- Usertext3:
- Usertext4:
- Data_Integrity: 5
- Object_Integrity: 5
- Old_Asset_ID:
- Private: N
- AMS_Status: Add
ID: Scour Line
Name: Scour Line
Domains:
- Field Name: Asset_Type
Inherited
- Field Name: Material
Inherited
- Field Name: Pipe_Class
Inherited
- Field Name: Diameter
Inherited
- Field Name: Potable
Inherited
- Field Name: Data_Integrity
Inherited
- Field Name: Object_Integrity
Inherited
- Field Name: Private
Inherited
- Field Name: AMS_Status
Inherited
Templates:
Name: Scour Line
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- Asset_ID: 0
- DevBnd_GIS_ID: 0
- GIS_ID: 0
- Asset_Type: Scour Line
- Material:
- Pipe_Class:
- Diameter: 0
- Measured_Length: 0
- Alignment: 0
- US_ID:
- DS_ID:
- Joint_Type:
- Op_Pressure:
- Drawing_No:
- Comment_Description:
- Potable: Y
- Network:
- Usertext1:
- Usertext2:
- Usertext3:
- Usertext4:
- Data_Integrity: 5
- Object_Integrity: 5
- Old_Asset_ID:
- Private: N
- AMS_Status: Add
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 8/12/2026 1:35:49 PM
Schema Last Edit Date: 8/12/2026 1:35:49 PM
Data Last Edit Date: 8/12/2026 1:35:49 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat