Name: Hamilton Water Mains (Risk)

Display Field: Material

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Digitized by Noah Taylor in Spring 2026. Based on 5A_Existing_Water_System-2018.png as well as City of Hamilton input, and segmented based on 8A_Existing_Street_Conditions_2018.pdf. Fields: Diameter, Material, Install Year (Inst_Yr), Number of Repairs (Num_Repair), Source, Street Condition (St_Cndtn), Number of Service Orders (Num_SrvOrd), Distance to Nearest Water Tank (WtrTnk_Ft), Nearest Tank (Near_Tank), Distance to Nearest Critical Facility (CrtFcl_Ft), Nearest Critical Facility (Near_CF), SoilType, LandUse, People Per Line Segment (PplPerLine) and Sum of Repairs & Service Orders (SumRepairs). There are also fields for each of the previously listed fields' risk score (S), weight (W) and Overall Score (Ovr_Score)

Service Item Id: 6f2aa02799ef41f9b70e8642d5c642fc

Copyright Text: City of Hamilton, Noah Taylor, Blake West, Kai McDonald  

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 2978978.3416214287
YMin: 1.0584140377537668E7
XMax: 2993672.3046875
YMax: 1.0597554847427845E7
Spatial Reference: 102739  (2277)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Class Breaks Renderer:
Field: Ovr_Score
Min. Value: 0.9
ClassBreakInfos:
• Class Maximum Value: 1.5210091472069966
  Label: < -1.5 Std. Dev.
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [11, 44, 122, 255]
  Width: 2
• Class Maximum Value: 2.157430173683706
  Label: -1.5 - -0.50 Std. Dev.
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [27, 168, 124, 255]
  Width: 2
• Class Maximum Value: 2.793851200160415
  Label: -0.50 - 0.50 Std. Dev.
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [119, 237, 0, 255]
  Width: 2
• Class Maximum Value: 3.430272226637124
  Label: 0.50 - 1.5 Std. Dev.
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [240, 180, 14, 255]
  Width: 2
• Class Maximum Value: 4.31
  Label: > 1.5 Std. Dev.
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 2
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• Id ( type: esriFieldTypeInteger, alias: Id )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter )
• Material ( type: esriFieldTypeString, alias: Material, length: 254 )
• Inst_Yr ( type: esriFieldTypeDouble, alias: Install Year )
• Num_Repair ( type: esriFieldTypeDouble, alias: Number of Repairs )
• Source ( type: esriFieldTypeString, alias: Source, length: 254 )
• St_Cndtn ( type: esriFieldTypeString, alias: Street Condition, length: 254 )
• Num_SrvOrd ( type: esriFieldTypeDouble, alias: Number of Service Orders )
• WtrTnk_Ft ( type: esriFieldTypeDouble, alias: Distance to Nearest Water Tank (ft) )
• Near_Tank ( type: esriFieldTypeString, alias: Nearest Water Tank, length: 254 )
• CrtFcl_Ft ( type: esriFieldTypeDouble, alias: Distnce to Nearest Critical Facility (ft) )
• Near_CF ( type: esriFieldTypeString, alias: Nearest Critical Facility, length: 254 )
• SoilType ( type: esriFieldTypeString, alias: Soil Type, length: 254 )
• LandUse ( type: esriFieldTypeString, alias: Land Use, length: 254 )
• PplPerLine ( type: esriFieldTypeDouble, alias: People Per Line )
• Mat_S ( type: esriFieldTypeInteger, alias: Material Score )
• InstYr_S ( type: esriFieldTypeInteger, alias: Install Year Score )
• Repair_S ( type: esriFieldTypeInteger, alias: Repairs & Service Orders Score )
• CityPrty_S ( type: esriFieldTypeInteger, alias: City Priority Score )
• StCndtn_S ( type: esriFieldTypeInteger, alias: Street Condition Score )
• SoilType_S ( type: esriFieldTypeInteger, alias: Soil Type Score )
• Diam_S ( type: esriFieldTypeInteger, alias: Diamater Score )
• LandUse_S ( type: esriFieldTypeInteger, alias: Land Use Score )
• PPL_S ( type: esriFieldTypeInteger, alias: People Per Line Score )
• NearTank_S ( type: esriFieldTypeInteger, alias: Distance to Nearest Water Tank Score )
• NearCF_S ( type: esriFieldTypeInteger, alias: Distance to Nearest Critical Facility Score )
• SumRepairs ( type: esriFieldTypeInteger, alias: Sum of Repairs & Service Orders )
• Mat_W ( type: esriFieldTypeDouble, alias: Material Weight )
• InstYr_W ( type: esriFieldTypeDouble, alias: Install Year Weight )
• Repair_W ( type: esriFieldTypeDouble, alias: Repairs & Service Orders Weight )
• CityPrty_W ( type: esriFieldTypeDouble, alias: City Priority Weight )
• StCndtn_W ( type: esriFieldTypeDouble, alias: Street Condition Weight )
• SoilType_W ( type: esriFieldTypeDouble, alias: Soil Type Weight )
• Diam_W ( type: esriFieldTypeDouble, alias: Diameter Weight )
• LandUse_W ( type: esriFieldTypeDouble, alias: Land Use Weight )
• PPL_W ( type: esriFieldTypeDouble, alias: People Per Line Weight )
• NearTank_W ( type: esriFieldTypeDouble, alias: Distance to Nearest Water Tank Weight )
• NearCF_W ( type: esriFieldTypeDouble, alias: Distance to Nearest Critical Facility Weight )
• Ovr_Score ( type: esriFieldTypeDouble, alias: Overall Risk Weight )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• OBJECTID ( type: esriFieldTypeOID, alias: Object ID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• Map_ID ( type: esriFieldTypeInteger, alias: Map ID )
• Shape_Leng ( type: esriFieldTypeDouble, alias: Segment Length (ft) )
• NEAR_DIST ( type: esriFieldTypeDouble, alias: NEAR_DIST )

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

  Iteminfo   Thumbnail   Metadata