Name: WaterMains
Display Field: FACILITYID
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description: This dataset contains a collection of features that represent the water distribution network in a community.
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: 1791585.03064513
YMin: 687060.822846055
XMax: 1811446.67497689
YMax: 703948.119123891
Spatial Reference: 102749 (2286)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"WATERTYPE","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[190,210,255,255],"width":2},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,169,230,255],"width":2},"value":"Potable","label":"Potable Water"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,255,255,255],"width":3.4},"value":"Raw","label":"Raw Water"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":3.4},"value":"Reclaimed","label":"Reclaimed Water"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3.4},"value":"Treated","label":"Treated Water"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[167,176,212,255],"toColor":[167,176,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[164,212,152,255],"toColor":[164,212,152,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,159,138,255],"toColor":[194,159,138,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[174,214,207,255],"toColor":[174,214,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[199,145,185,255],"toColor":[199,145,185,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[203,204,165,255],"toColor":[203,204,165,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[209,178,188,255],"toColor":[209,178,188,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[156,139,196,255],"toColor":[156,139,196,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[141,180,194,255],"toColor":[141,180,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[160,194,157,255],"toColor":[160,194,157,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,140,140,255],"toColor":[194,140,140,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[190,165,214,255],"toColor":[190,165,214,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,190,176,255],"toColor":[207,190,176,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: WATERTYPE
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- FACILITYID (type: esriFieldTypeString, alias: Facility Identifier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- INSTALLDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [ABS: ABS Plastic], [AC: Asbestos Cement], [ASP: Asphalt], ... 33 more ...)
- DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 3/4"], [1: 1"], [1.25: 1 1/4"], ... 27 more ...)
- WATERTYPE (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Potable: Potable Water], [Raw: Raw Water], [Reclaimed: Reclaimed Water], ... 3 more ...)
- TRANSMISS (type: esriFieldTypeString, alias: Transmission System, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- ACTIVEFLAG (type: esriFieldTypeSmallInteger, alias: Active Flag, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- OWNEDBY (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: City], [2: County], [3: Private], ... 1 more ...)
- MAINTBY (type: esriFieldTypeSmallInteger, alias: Managed By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [-1: Private], [-2: Other])
- LASTUPDATE (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- LASTEDITOR (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, 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)
- LATERALTYPE (type: esriFieldTypeString, alias: LATERALTYPE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Hydrant: Hydrant], [Irrigation: Irrigation], [Other: Other], ... 5 more ...)
- PIPECATEGORY (type: esriFieldTypeString, alias: PIPECATEGORY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Main: Main], [Lateral: Lateral])
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Types:
ID: Potable
Name: Potable Water
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISS
Inherited
- Field Name: ENABLED
Inherited
- Field Name: ACTIVEFLAG
Inherited
- Field Name: OWNEDBY
Inherited
- Field Name: MAINTBY
Inherited
- Field Name: LATERALTYPE
Inherited
- Field Name: PIPECATEGORY
Inherited
Templates:
Name: Water Mains
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- ACTIVEFLAG: 1
- ENABLED: 1
- OWNEDBY: 1
- DIAMETER: 12
- MATERIAL: PVC
- WATERTYPE: Potable
- MAINTBY: 1
ID: Raw
Name: Raw Water
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISS
Inherited
- Field Name: ENABLED
Inherited
- Field Name: ACTIVEFLAG
Inherited
- Field Name: OWNEDBY
Inherited
- Field Name: MAINTBY
Inherited
- Field Name: LATERALTYPE
Inherited
- Field Name: PIPECATEGORY
Inherited
Templates:
Name: Raw
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
ID: Reclaimed
Name: Reclaimed Water
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISS
Inherited
- Field Name: ENABLED
Inherited
- Field Name: ACTIVEFLAG
Inherited
- Field Name: OWNEDBY
Inherited
- Field Name: MAINTBY
Inherited
- Field Name: LATERALTYPE
Inherited
- Field Name: PIPECATEGORY
Inherited
Templates:
Name: Reclaimed
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- WATERTYPE: Reclaimed
- ENABLED: 0
ID: Treated
Name: Treated Water
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISS
Inherited
- Field Name: ENABLED
Inherited
- Field Name: ACTIVEFLAG
Inherited
- Field Name: OWNEDBY
Inherited
- Field Name: MAINTBY
Inherited
- Field Name: LATERALTYPE
Inherited
- Field Name: PIPECATEGORY
Inherited
Templates:
Name: Treated
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- WATERTYPE: Treated
- ENABLED: 0
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 1/23/2026 11:30:00 PM
Schema Last Edit Date: 1/23/2026 11:30:00 PM
Data Last Edit Date: 3/18/2026 3:50:47 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat