Name: Water Mains - Public

Display Field: handle

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10220824.588389
YMin: 5353223.35106815
XMax: -10210094.3314621
YMax: 5362527.44569991
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"subtype","uniqueValueGroups":[{"heading":"","classes":[{"label":"Blowoff","description":"Blowoff","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,38,115,255],"width":1},"values":[["1"]]},{"label":"Bypass","description":"Bypass","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,56,147,255],"width":1},"values":[["2"]]},{"label":"Commercial","description":"Commercial","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[122,142,245,255],"width":1.5},"values":[["3"]]},{"label":"Domestic","description":"Domestic","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,255,255],"width":1.5},"values":[["4"]]},{"label":"Distribution","description":"Distribution","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":2.5},"values":[["5"]]},{"label":"Fire","description":"Fire","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[224,170,15,255],"width":1.5},"values":[["6"]]},{"label":"HydrantLateral","description":"HydrantLateral","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,76,0,255],"width":1.5},"values":[["7"]]},{"label":"Interconnection","description":"Interconnection","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3},"values":[["8"]]},{"label":"Irrigation","description":"Irrigation","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,255,197,255],"width":1},"values":[["9"]]},{"label":"Pipe Bridge","description":"Pipe Bridge","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3},"values":[["10"]]},{"label":"Transmission","description":"Transmission","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3},"values":[["11"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,38,115,255],"width":1},"value":"1","label":"Blowoff"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,56,147,255],"width":1},"value":"2","label":"Bypass"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[122,142,245,255],"width":1.5},"value":"3","label":"Commercial"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,255,255],"width":1.5},"value":"4","label":"Domestic"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":2.5},"value":"5","label":"Distribution"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[224,170,15,255],"width":1.5},"value":"6","label":"Fire"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,76,0,255],"width":1.5},"value":"7","label":"HydrantLateral"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3},"value":"8","label":"Interconnection"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,255,197,255],"width":1},"value":"9","label":"Irrigation"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3},"value":"10","label":"Pipe Bridge"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3},"value":"11","label":"Transmission"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,245,204,255],"toColor":[252,245,204,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[244,182,252,255],"toColor":[244,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,225,252,255],"toColor":[182,225,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,183,255],"toColor":[252,182,183,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[180,252,179,255],"toColor":[180,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,252,230,255],"toColor":[197,252,230,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[234,212,252,255],"toColor":[234,212,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,188,252,255],"toColor":[182,188,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,221,207,255],"toColor":[252,221,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,189,230,255],"toColor":[252,189,230,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[225,252,189,255],"toColor":[225,252,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,248,252,255],"toColor":[192,248,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,214,252,255],"toColor":[194,214,252,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"iif(!IsEmpty($feature.dia),$feature.dia + TextFormatting.DoubleQuote + ' ','') + iif(!IsEmpty($feature.material) && $feature.material != 'UNK',Replace($feature.material,'DI','DIP'),'WM')","title":"Custom"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"followFeature","deconflictionStrategy":"dynamic","allowOverrun":false,"repeatLabel":false,"lineConnection":"unambiguousLabels","useClippedGeometry":true,"allowOverlapOfFeatureInterior":"exclude","offsetDistance":3,"stackLabel":false,"removeDuplicates":"none","where":"subtype NOT IN (11, 7)","useCodedValues":true,"maxScale":0,"minScale":10000,"name":"Water Main","priority":-1,"symbol":{"type":"esriTS","color":[0,38,115,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":1,"font":{"family":"AvenirNext LT Pro Medium","size":9,"style":"normal","weight":"normal","decoration":"none"}}},{"labelExpressionInfo":{"expression":"iif(!IsEmpty($feature.dia),$feature.dia + TextFormatting.DoubleQuote + ' ','') + iif(!IsEmpty($feature.material) && $feature.material != 'UNK',Replace($feature.material,'DI','DIP') + ' TRANSMISSION MAIN','TRANSMISSION MAIN')","title":"Custom"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"followFeature","deconflictionStrategy":"dynamic","allowOverrun":false,"repeatLabel":false,"lineConnection":"none","multiPart":"labelPerFeature","useClippedGeometry":true,"allowOverlapOfFeatureInterior":"exclude","stackLabel":false,"removeDuplicates":"all","removeDuplicatesDistance":150,"where":"subtype = 11","useCodedValues":true,"maxScale":0,"minScale":10000,"name":"Transmission Main","priority":-1,"symbol":{"type":"esriTS","color":[115,76,0,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,127],"haloSize":1,"font":{"family":"AvenirNext LT Pro Medium","size":10,"style":"normal","weight":"normal","decoration":"none"}}},{"labelExpressionInfo":{"expression":"iif(!IsEmpty($feature.dia),$feature.dia + TextFormatting.DoubleQuote + ' ','') + iif(!IsEmpty($feature.material) && $feature.material != 'UNK',Replace($feature.material,'DI','DIP'),'HYD')","title":"Custom"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":false,"repeatLabel":false,"lineConnection":"minimizeLabels","useClippedGeometry":true,"allowOverlapOfFeatureInterior":"exclude","stackLabel":false,"removeDuplicates":"none","where":"subtype = 7","useCodedValues":true,"maxScale":0,"minScale":5000,"name":"Hydrant Laterals","priority":-1,"symbol":{"type":"esriTS","color":[168,56,0,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":1,"font":{"family":"AvenirNext LT Pro Medium","size":9,"style":"normal","weight":"normal","decoration":"none"}}}]}

HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field: subtype

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• dia (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 3/4"], [1: 1"], [1.25: 1-1/4"], ... 22 more ...)
• elevation (type: esriFieldTypeDouble, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• handle (type: esriFieldTypeString, alias: Handle, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lastupdate (type: esriFieldTypeDate, alias: Last Update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• lifecycle (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Abandoned: Abandoned], [Active: Active], [Destroyed: Destroyed], ... 2 more ...)
• material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CI: Cast Iron], [CL: Clay], [CONC: Concrete], ... 8 more ...)
• owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Freeport: Freeport], [Luther College: Luther College], [Private: Private], ... 2 more ...)
• posacc (type: esriFieldTypeString, alias: Positional Accuracy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Approximate: Approximate], [Field Measurements: Field Measurements], [GPS sub-cm: GPS sub-cm], ... 5 more ...)
• subtype (type: esriFieldTypeSmallInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
• docpath (type: esriFieldTypeString, alias: Document Path, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: 1
Name: Blowoff
Domains:

• Field Name: dia
  Inherited
  
• Field Name: lifecycle
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: owner
  Inherited
  
• Field Name: posacc
  Inherited
  
Templates:

Name: Blowoff
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• subtype: 1

---

ID: 2
Name: Bypass
Domains:

• Field Name: dia
  Inherited
  
• Field Name: lifecycle
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: owner
  Inherited
  
• Field Name: posacc
  Inherited
  
Templates:

Name: Bypass
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• subtype: 2

---

ID: 3
Name: Commercial
Domains:

• Field Name: dia
  Inherited
  
• Field Name: lifecycle
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: owner
  Inherited
  
• Field Name: posacc
  Inherited
  
Templates:

Name: Commercial
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• subtype: 3

---

ID: 4
Name: Domestic
Domains:

• Field Name: dia
  Inherited
  
• Field Name: lifecycle
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: owner
  Inherited
  
• Field Name: posacc
  Inherited
  
Templates:

Name: Domestic
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• subtype: 4

---

ID: 5
Name: Distribution
Domains:

• Field Name: dia
  Inherited
  
• Field Name: lifecycle
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: owner
  Inherited
  
• Field Name: posacc
  Inherited
  
Templates:

Name: Distribution
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• owner: Public
• subtype: 5

---

ID: 6
Name: Fire
Domains:

• Field Name: dia
  Inherited
  
• Field Name: lifecycle
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: owner
  Inherited
  
• Field Name: posacc
  Inherited
  
Templates:

Name: Fire
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• subtype: 6

---

ID: 7
Name: HydrantLateral
Domains:

• Field Name: dia
  Inherited
  
• Field Name: lifecycle
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: owner
  Inherited
  
• Field Name: posacc
  Inherited
  
Templates:

Name: HydrantLateral
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• posacc: GPS sub-m
• lifecycle: Active
• material: UNK
• owner: Public
• dia: 6
• subtype: 7

---

ID: 8
Name: Interconnection
Domains:

• Field Name: dia
  Inherited
  
• Field Name: lifecycle
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: owner
  Inherited
  
• Field Name: posacc
  Inherited
  
Templates:

Name: Interconnection
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• subtype: 8

---

ID: 9
Name: Irrigation
Domains:

• Field Name: dia
  Inherited
  
• Field Name: lifecycle
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: owner
  Inherited
  
• Field Name: posacc
  Inherited
  
Templates:

Name: Irrigation
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• subtype: 9

---

ID: 10
Name: Pipe Bridge
Domains:

• Field Name: dia
  Inherited
  
• Field Name: lifecycle
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: owner
  Inherited
  
• Field Name: posacc
  Inherited
  
Templates:

Name: Pipe Bridge
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• subtype: 10

---

ID: 11
Name: Transmission
Domains:

• Field Name: dia
  Inherited
  
• Field Name: lifecycle
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: owner
  Inherited
  
• Field Name: posacc
  Inherited
  
Templates:

Name: Transmission
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• owner: Public
• subtype: 11

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/20/2026 4:23:08 PM

Schema Last Edit Date: 5/20/2026 4:23:08 PM

Data Last Edit Date: 5/20/2026 4:23:08 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat