View In:   ArcGIS.com Map

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: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 20000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: [115, 38, 0, 255]
Width: 1
Default Label:
UniqueValueInfos:
• Value: 2
  Label: Transmission
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 77, 168, 255]
  Width: 3
• Value: 1
  Label: Distribution
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 169, 230, 255]
  Width: 2
• Value: 3
  Label: Hydrant Lead
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [115, 223, 255, 255]
  Width: 1
• Value: 5
  Label: Purge Line
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 168, 132, 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: true
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, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• SUB_TYPE ( type: esriFieldTypeInteger, alias: Sub Type, editable: true, nullable: true, defaultValue: 1, modelName: SUB_TYPE )
• OVER_DIAM ( type: esriFieldTypeDouble, alias: Oversize Diameter, editable: true, nullable: true, defaultValue: null, modelName: OVER_DIAM )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MATERIAL , Coded Values: [Cast Iron: Cast Iron] , [Copper: Copper] , [Ductile Iron: Ductile Iron] , ...6 more... )
• INSTALL_YR ( type: esriFieldTypeSmallInteger, alias: Year Installed, editable: true, nullable: true, defaultValue: null, modelName: INSTALL_YR , Range: [1940, 2030] )
• CONTRACTOR ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTRACTOR , 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, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PUBLIC_PVT , Coded Values: [Public: Public] , [Private: Private] , [Unknown: Unknown] )
• RECORD_LEN ( type: esriFieldTypeDouble, alias: Recorded Length, editable: true, nullable: true, defaultValue: null, modelName: RECORD_LEN )
• EASEMENT ( type: esriFieldTypeString, alias: Easement, editable: true, nullable: true, length: 5, defaultValue: null, modelName: EASEMENT , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• Pressure ( type: esriFieldTypeString, alias: Pressure, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Pressure , Coded Values: [High: High] , [High ET: High ET] , [High GETH: High GETH] , ...5 more... )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• Duplicate ( type: esriFieldTypeSmallInteger, alias: Duplicate, editable: true, nullable: true, defaultValue: null, modelName: Duplicate )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• Municipality ( type: esriFieldTypeString, alias: Municipality, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Municipality , 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Ownership , 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, editable: false, nullable: true, length: 150, defaultValue: null, modelName: CreatedBy )
• CreatedByDate ( type: esriFieldTypeDate, alias: Created By Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedByDate )
• EditedBy ( type: esriFieldTypeString, alias: Edited By, editable: false, nullable: true, length: 150, defaultValue: null, modelName: EditedBy )
• EditedByDate ( type: esriFieldTypeDate, alias: Edited By Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditedByDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• MaintainedBy ( type: esriFieldTypeString, alias: Maintained By, editable: true, nullable: true, length: 75, defaultValue: null, modelName: MaintainedBy , Coded Values: [Bedford Township: Bedford Township] , [City of Battle Creek: City of Battle Creek] , [City of Springfield: City of Springfield] , ...7 more... )
• Diameter ( type: esriFieldTypeSmallInteger, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: Diameter )
• Hyperlink ( type: esriFieldTypeString, alias: Hyperlink, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Hyperlink )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STLength() )
• Asset_Length ( type: esriFieldTypeDouble, alias: Asset_Length, editable: true, nullable: true, defaultValue: null, modelName: Asset_Length )

Types:

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...
Templates:
• Name: Transmission
  Description:
  Prototype:
  FACILITYID: null
  Hyperlink: null
  SUB_TYPE: 2
  OVER_DIAM: null
  MATERIAL: null
  INSTALL_YR: null
  CONTRACTOR: null
  PUBLIC_PVT: null
  RECORD_LEN: null
  EASEMENT: null
  Pressure: null
  COMMENTS: null
  Duplicate: null
  Enabled: 1
  Municipality: null
  Ownership: null
  Diameter: null
  MaintainedBy: null
  Asset_Length: null
  
  Drawing Tool: esriFeatureEditToolLine

---

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...
Templates:
• Name: Distribution
  Description:
  Prototype:
  FACILITYID: null
  Hyperlink: null
  SUB_TYPE: 1
  OVER_DIAM: null
  MATERIAL: null
  INSTALL_YR: null
  CONTRACTOR: null
  PUBLIC_PVT: null
  RECORD_LEN: null
  EASEMENT: null
  Pressure: null
  COMMENTS: null
  Duplicate: null
  Enabled: 1
  Municipality: null
  Ownership: null
  Diameter: null
  MaintainedBy: null
  Asset_Length: null
  
  Drawing Tool: esriFeatureEditToolLine

---

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"]
Templates:
• Name: Hydrant Lead
  Description:
  Prototype:
  FACILITYID: null
  Hyperlink: null
  SUB_TYPE: 3
  OVER_DIAM: null
  MATERIAL: null
  INSTALL_YR: null
  CONTRACTOR: null
  PUBLIC_PVT: null
  RECORD_LEN: null
  EASEMENT: null
  Pressure: null
  COMMENTS: null
  Duplicate: null
  Enabled: 1
  Municipality: null
  Ownership: null
  Diameter: null
  MaintainedBy: null
  Asset_Length: null
  
  Drawing Tool: esriFeatureEditToolLine

---

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...
Templates:
• Name: Purge Line
  Description:
  Prototype:
  FACILITYID: null
  Hyperlink: null
  SUB_TYPE: 5
  OVER_DIAM: null
  MATERIAL: null
  INSTALL_YR: null
  CONTRACTOR: null
  PUBLIC_PVT: null
  RECORD_LEN: null
  EASEMENT: null
  Pressure: null
  COMMENTS: null
  Duplicate: null
  Enabled: 1
  Municipality: null
  Ownership: null
  Diameter: null
  MaintainedBy: null
  Asset_Length: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CreatedByDate
• Creator Field: CreatedBy
• Edit Date Field: EditedByDate
• Editor Field: EditedBy

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata