Layer: Water Main (ID:9)

View In: Map Viewer

Name: Water Main

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 15000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":3},"value":"2","label":"Transmission"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,169,230,255],"width":2},"value":"1","label":"Distribution"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,223,255,255],"width":1},"value":"3","label":"Hydrant Lead"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,168,132,255],"width":1},"value":"5","label":"Purge Line"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,238,199,255],"toColor":[252,238,199,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[180,179,252,255],"toColor":[180,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,236,252,255],"toColor":[182,236,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,206,255],"toColor":[252,184,206,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,182,255],"toColor":[179,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[249,184,252,255],"toColor":[249,184,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[220,215,252,255],"toColor":[220,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,252,228,255],"toColor":[207,252,228,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,199,179,255],"toColor":[252,199,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[239,252,182,255],"toColor":[239,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,218,255],"toColor":[252,215,218,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,210,241,255],"toColor":[252,210,241,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,216,252,255],"toColor":[179,216,252,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpression":"[DIAMETER]","labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"(SUB_TYPE = 2 )","useCodedValues":true,"maxScale":0,"minScale":0,"name":"Transmission","priority":44,"symbol":{"type":"esriTS","color":[115,178,255,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[0,0,0,255],"haloSize":2,"font":{"family":"Arial","size":8.5,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpression":"[DIAMETER]","labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"(SUB_TYPE = 1 )","useCodedValues":true,"maxScale":0,"minScale":0,"name":"Distribution","priority":45,"symbol":{"type":"esriTS","color":[115,178,255,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[0,0,0,255],"haloSize":2,"font":{"family":"Arial","size":8.5,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpression":"[DIAMETER]","labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"(SUB_TYPE = 3 )","useCodedValues":true,"maxScale":0,"minScale":0,"name":"Hydrant Lead","priority":46,"symbol":{"type":"esriTS","color":[0,169,230,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[0,0,0,255],"haloSize":2,"font":{"family":"Arial","size":8.5,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpression":"[DIAMETER]","labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"(SUB_TYPE = 4 )","useCodedValues":true,"maxScale":0,"minScale":0,"name":"Fire Line","priority":47,"symbol":{"type":"esriTS","color":[255,85,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[0,0,0,255],"haloSize":2,"font":{"family":"Arial","size":8.5,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpression":"[DIAMETER]","labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"(SUB_TYPE = 5 )","useCodedValues":true,"maxScale":0,"minScale":0,"name":"Purge Line","priority":48,"symbol":{"type":"esriTS","color":[0,168,132,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[0,0,0,255],"haloSize":2,"font":{"family":"Arial","size":8.5,"style":"normal","weight":"bold","decoration":"none"}}}]}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: SUB_TYPE

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
SUB_TYPE (type: esriFieldTypeInteger, alias: SUB_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
Diameter (type: esriFieldTypeSmallInteger, alias: DIAMETER, SQL Type: sqlTypeOther, nullable: true, editable: true)
OVER_DIAM (type: esriFieldTypeDouble, alias: OVERSIZE DIAMETER, SQL Type: sqlTypeOther, nullable: true, editable: true)
MATERIAL (type: esriFieldTypeString, alias: MATERIAL, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Cast Iron: Cast Iron], [Copper: Copper], [Ductile Iron: Ductile Iron], ... 6 more ...)
INSTALL_YR (type: esriFieldTypeSmallInteger, alias: YEAR INSTALLED, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1940 - 2030])
CONTRACTOR (type: esriFieldTypeString, alias: CONTRACTOR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [City of Battle Creek: City of Battle Creek], [Crest Construction: Crest Construction], [Hoffman Brothers: Hoffman Brothers], ... 10 more ...)
PUBLIC_PVT (type: esriFieldTypeString, alias: PUBLIC or PRIVATE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Public: Public], [Private: Private], [Unknown: Unknown])
RECORD_LEN (type: esriFieldTypeDouble, alias: RECORDED LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
EASEMENT (type: esriFieldTypeString, alias: EASEMENT, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [N/A: N/A])
Pressure (type: esriFieldTypeString, alias: Pressure, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [High: High], [High ET: High ET], [High GETH: High GETH], ... 5 more ...)
COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
Hyperlink (type: esriFieldTypeString, alias: Hyperlink, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Duplicate (type: esriFieldTypeSmallInteger, alias: Duplicate, SQL Type: sqlTypeOther, nullable: true, editable: true)
Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
Municipality (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bedford Township: Bedford Township], [City of Battle Creek: City of Battle Creek], [City of Springfield: City of Springfield], ... 7 more ...)
Ownership (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bedford Township: Bedford Township], [City of Battle Creek: City of Battle Creek], [City of Springfield: City of Springfield], ... 7 more ...)
CreatedBy (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: false)
CreatedByDate (type: esriFieldTypeDate, alias: Created By Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
EditedBy (type: esriFieldTypeString, alias: Edited By, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: false)
EditedByDate (type: esriFieldTypeDate, alias: Edited By Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
MaintainedBy (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [Bedford Township: Bedford Township], [City of Battle Creek: City of Battle Creek], [City of Springfield: City of Springfield], ... 7 more ...)
Asset_Length (type: esriFieldTypeDouble, alias: Asset_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

Field Name: Diameter
Coded Values:[12: 12"], [14: 14"], [16: 16"], More
Field Name: MATERIAL
Inherited
Field Name: INSTALL_YR
Inherited
Field Name: CONTRACTOR
Inherited
Field Name: PUBLIC_PVT
Inherited
Field Name: EASEMENT
Inherited
Field Name: Pressure
Inherited
Field Name: Enabled
Inherited
Field Name: Municipality
Inherited
Field Name: Ownership
Inherited
Field Name: MaintainedBy
Inherited

SUB_TYPE: 2
Enabled: 1

Field Name: Diameter
Coded Values:[2: 2"], [4: 4"], [6: 6"], More
Field Name: MATERIAL
Inherited
Field Name: INSTALL_YR
Inherited
Field Name: CONTRACTOR
Inherited
Field Name: PUBLIC_PVT
Inherited
Field Name: EASEMENT
Inherited
Field Name: Pressure
Inherited
Field Name: Enabled
Inherited
Field Name: Municipality
Inherited
Field Name: Ownership
Inherited
Field Name: MaintainedBy
Inherited

SUB_TYPE: 1
Enabled: 1

Field Name: Diameter
Coded Values:[4: 4"], [6: 6"]
Field Name: MATERIAL
Coded Values:[Cast Iron Cast Iron: Cast Iron], [Ductile Iron: Ductile Iron], [PVC: PVC]
Field Name: INSTALL_YR
Inherited
Field Name: CONTRACTOR
Inherited
Field Name: PUBLIC_PVT
Inherited
Field Name: EASEMENT
Inherited
Field Name: Pressure
Inherited
Field Name: Enabled
Inherited
Field Name: Municipality
Inherited
Field Name: Ownership
Inherited
Field Name: MaintainedBy
Inherited

SUB_TYPE: 3
Enabled: 1

Field Name: Diameter
Coded Values:[2: 2"], [4: 4"], [6: 6"], More
Field Name: MATERIAL
Inherited
Field Name: INSTALL_YR
Inherited
Field Name: CONTRACTOR
Inherited
Field Name: PUBLIC_PVT
Inherited
Field Name: EASEMENT
Inherited
Field Name: Pressure
Inherited
Field Name: Enabled
Inherited
Field Name: Municipality
Inherited
Field Name: Ownership
Inherited
Field Name: MaintainedBy
Inherited

SUB_TYPE: 5
Enabled: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/27/2026 8:58:41 PM

Schema Last Edit Date: 5/27/2026 8:58:41 PM

Data Last Edit Date: 5/27/2026 8:58:41 PM

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