Name: Water Mains

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: <DIV STYLE="text-align:Left;"><P><SPAN>A main pipe or conduit in a system for conveying water.</SPAN></P><P><SPAN>Distribution - Distribution mains are typically smaller in diameter than the transmission mains and generally follow the city streets.</SPAN></P><P><SPAN>Fire Line - to be removed.</SPAN></P><P><SPAN>Hydrant Lead - Leading from a water main to a fire hydrant.</SPAN></P><P><SPAN>Purge Line - Potentially used to flush water main. </SPAN></P><P><SPAN>Transmission - Transmission mains are larger pipes (16” in diameter and larger) which are designed to move large quantities of water from the source of supply, such as a treatment plant or groundwater well, and provide water to the smaller distribution mains.</SPAN></P></DIV>

Copyright Text: Originally created by Woolpert Inc. in 1997. Edited by Battle Creek DPW Records Division.

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 20000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -9498540.903529586
YMin: 5197555.323858744
XMax: -9462488.313820502
YMax: 5216703.376056987
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUB_TYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 1
Default Label:
UniqueValueInfos:
• Value: 1
  Label: Distribution
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 77, 168, 255]
  Width: 3
• Value: 2
  Label: Transmission
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 2
• Value: 3
  Label: Hydrant Lead
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 197, 255, 255]
  Width: 1
• Value: 5
  Label: Purge Line
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [182, 251, 252, 255]
  Width: 1
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [DIAMETER] CONCAT "''"
Use Coded Values: true
Symbol:
Color: [115, 178, 255, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SUB_TYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, length: 20 )
• SUB_TYPE ( type: esriFieldTypeInteger, alias: Sub Type )
• OVER_DIAM ( type: esriFieldTypeDouble, alias: Oversize Diameter )
• MATERIAL ( type: esriFieldTypeString, alias: Material, length: 30 , Coded Values: [Cast Iron: Cast Iron] , [Copper: Copper] , [Ductile Iron: Ductile Iron] , ...6 more... )
• INSTALL_YR ( type: esriFieldTypeSmallInteger, alias: Year Installed , Range: [1940, 2030] )
• CONTRACTOR ( type: esriFieldTypeString, alias: Contractor, length: 50 , 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, length: 10 , Coded Values: [Public: Public] , [Private: Private] , [Unknown: Unknown] )
• RECORD_LEN ( type: esriFieldTypeDouble, alias: Recorded Length )
• EASEMENT ( type: esriFieldTypeString, alias: Easement, length: 5 , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• Pressure ( type: esriFieldTypeString, alias: Pressure, length: 10 , Coded Values: [High: High] , [High ET: High ET] , [High GETH: High GETH] , ...5 more... )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 100 )
• Duplicate ( type: esriFieldTypeSmallInteger, alias: Duplicate )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• Municipality ( type: esriFieldTypeString, alias: Municipality, length: 50 , 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, length: 50 , 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, length: 150 )
• CreatedByDate ( type: esriFieldTypeDate, alias: Created By Date, length: 8 )
• EditedBy ( type: esriFieldTypeString, alias: Edited By, length: 150 )
• EditedByDate ( type: esriFieldTypeDate, alias: Edited By Date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• MaintainedBy ( type: esriFieldTypeString, alias: Maintained By, length: 75 , Coded Values: [Bedford Township: Bedford Township] , [City of Battle Creek: City of Battle Creek] , [City of Springfield: City of Springfield] , ...7 more... )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Diameter ( type: esriFieldTypeSmallInteger, alias: Diameter )
• Hyperlink ( type: esriFieldTypeString, alias: Hyperlink, length: 255 )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• Asset_Length ( type: esriFieldTypeDouble, alias: Asset_Length )

Types:

ID: 1
Name: Distribution
Domains:
• MATERIAL:
  Inherited
• INSTALL_YR:
  Inherited
• CONTRACTOR:
  Inherited
• PUBLIC_PVT:
  Inherited
• EASEMENT:
  Inherited
• Pressure:
  Inherited
• Enabled:
  Inherited
• Municipality:
  Inherited
• Ownership:
  Inherited
• MaintainedBy:
  Inherited
• Diameter:
  Coded Values: [2: 2"] , [4: 4"] , [6: 6"] , ...2 more...

---

ID: 2
Name: Transmission
Domains:
• MATERIAL:
  Inherited
• INSTALL_YR:
  Inherited
• CONTRACTOR:
  Inherited
• PUBLIC_PVT:
  Inherited
• EASEMENT:
  Inherited
• Pressure:
  Inherited
• Enabled:
  Inherited
• Municipality:
  Inherited
• Ownership:
  Inherited
• MaintainedBy:
  Inherited
• Diameter:
  Coded Values: [12: 12"] , [14: 14"] , [16: 16"] , ...8 more...

---

ID: 3
Name: Hydrant Lead
Domains:
• MATERIAL:
  Coded Values: [Cast Iron Cast Iron: Cast Iron] , [Ductile Iron: Ductile Iron] , [PVC: PVC]
• INSTALL_YR:
  Inherited
• CONTRACTOR:
  Inherited
• PUBLIC_PVT:
  Inherited
• EASEMENT:
  Inherited
• Pressure:
  Inherited
• Enabled:
  Inherited
• Municipality:
  Inherited
• Ownership:
  Inherited
• MaintainedBy:
  Inherited
• Diameter:
  Coded Values: [4: 4"] , [6: 6"]

---

ID: 5
Name: Purge Line
Domains:
• MATERIAL:
  Inherited
• INSTALL_YR:
  Inherited
• CONTRACTOR:
  Inherited
• PUBLIC_PVT:
  Inherited
• EASEMENT:
  Inherited
• Pressure:
  Inherited
• Enabled:
  Inherited
• Municipality:
  Inherited
• Ownership:
  Inherited
• MaintainedBy:
  Inherited
• Diameter:
  Coded Values: [2: 2"] , [4: 4"] , [6: 6"] , ...6 more...

---

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata