Name: Hydrant

Display Field: HydrantPointID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Both City owned and private hydrants exist in this layer, distinguished by the OWNER field. PVT is privately owned; City of Belleville is City-owned. Details of new hydrants to be verified with field inspector when digitized from Form 1 drawings.</SPAN></P><P><SPAN /></P><P><SPAN>MAKES (Subtypes)</SPAN></P><P><SPAN>1 - McAvity</SPAN></P><P><SPAN>2 - Mueller</SPAN></P><P><SPAN>3 - Unknown</SPAN></P><P><SPAN /></P><P><SPAN>MODELS (Domains)</SPAN></P><P><SPAN>1 - McAvity</SPAN></P><P><SPAN>M-67 (THREAD)</SPAN></P><P><SPAN>M-67-B BRIGADIER (BOLT)</SPAN></P><P><SPAN>Unknown</SPAN></P><P><SPAN /></P><P><SPAN>2 - Mueller</SPAN></P><P><SPAN>Canada Valve Century</SPAN></P><P><SPAN>Centurion</SPAN></P><P><SPAN>Darling B-50-B</SPAN></P><P><SPAN>Unknown</SPAN></P><P><SPAN /></P><P><SPAN>3 - Unknown</SPAN></P><P><SPAN>Unknown (not a domain, but unknown is the default value for the Unknown subtype)</SPAN></P></DIV></DIV></DIV>

Copyright Text: Make and model result of field survey by Dale Haskell and Steve Garrow in early 2020.

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: 0
YMin: 0
XMax: 313382.8092
YMax: 4898793.9311999995
Spatial Reference: 26918  (26918)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: System ID )
• HydrantPointID ( type: esriFieldTypeInteger, alias: Hydrant ID )
• QUADNUM ( type: esriFieldTypeString, alias: Quad Num ID, length: 6 )
• Section ( type: esriFieldTypeString, alias: Hydrant Flushing Section, length: 4 )
• OBJECTID_1 ( type: esriFieldTypeInteger, alias: OBJECTID_1 )
• CableCad_FH_ID ( type: esriFieldTypeDouble, alias: Cable CAD Hydrant ID )
• ARCMAP_valve_ID_No_ ( type: esriFieldTypeDouble, alias: ARCMAP_valve_ID_No_ )
• ArcMap_Hyd_Point_No_ ( type: esriFieldTypeDouble, alias: Hydrant ID (obsolete) )
• LOCATION ( type: esriFieldTypeString, alias: Hydrant Location, length: 255 )
• STREET ( type: esriFieldTypeString, alias: Location - Street Name, length: 255 )
• ADDRESS ( type: esriFieldTypeDouble, alias: Location - Civic Address )
• CROSS_STREET_1 ( type: esriFieldTypeString, alias: Location - Cross Street 1, length: 255 )
• CROSS_STREET__2 ( type: esriFieldTypeString, alias: Location - Cross Street 2, length: 255 )
• TOP_NUT_ELEVATION ( type: esriFieldTypeDouble, alias: Top Nut Elevation )
• OWNER ( type: esriFieldTypeString, alias: Ownership, length: 255 )
• YEAR ( type: esriFieldTypeDouble, alias: YEAR )
• INSTALL_DATE ( type: esriFieldTypeDouble, alias: Installation Date )
• INITIAL_STATIC_PRESSURE ( type: esriFieldTypeDouble, alias: INITIAL_STATIC_PRESSURE )
• INITIAL_FLOW ( type: esriFieldTypeDouble, alias: INITIAL_FLOW )
• RESIDUAL_FLOW_AT_20_PSI ( type: esriFieldTypeDouble, alias: RESIDUAL_FLOW_AT_20_PSI )
• TEST_DATE ( type: esriFieldTypeString, alias: TEST_DATE, length: 255 )
• SIZE ( type: esriFieldTypeDouble, alias: SIZE )
• NUMBER_OF_NOZZLES ( type: esriFieldTypeDouble, alias: Number of Nozzles )
• NOZZLE_ONE_SIZE ( type: esriFieldTypeDouble, alias: Nozzle 1 Size )
• NOZZLE_2_SIZE ( type: esriFieldTypeDouble, alias: Nozzle 2 Size )
• NOZZLE_3_SIZE ( type: esriFieldTypeDouble, alias: Nozzle 3 Size )
• SELF_DRAINING ( type: esriFieldTypeString, alias: Self Draining (Y/N), length: 255 )
• DIRECTION_TO_OPEN ( type: esriFieldTypeString, alias: Direction to Open, length: 255 )
• BREAK_AWAY_FLANGE ( type: esriFieldTypeString, alias: Breakaway Flange (Y/N), length: 255 )
• LATERAL_SIZE ( type: esriFieldTypeDouble, alias: Lateral Size )
• ISOLATION_VALVE ( type: esriFieldTypeString, alias: Isolation Valve (Y/N), length: 255 )
• MAIN_TO_VALVE_DISTANCE ( type: esriFieldTypeDouble, alias: Main to Valve Distance )
• VALVE_TO_HYDRANT_DISTANCE ( type: esriFieldTypeDouble, alias: Valve to Hydrant Distance )
• TIE_1 ( type: esriFieldTypeString, alias: TIE_1, length: 255 )
• TIE_2 ( type: esriFieldTypeString, alias: TIE_2, length: 255 )
• CATHODIC_PROTECTION ( type: esriFieldTypeString, alias: Cathodic Protection, length: 255 )
• CATHODIC_PROTECTION_INSTALL_DAT ( type: esriFieldTypeString, alias: Cathodic Protection Install Date, length: 255 )
• ANTI_TAMPER_DEVICE ( type: esriFieldTypeString, alias: Ant-Tamper Device, length: 255 )
• LOCATION_MARKER ( type: esriFieldTypeString, alias: Location Marker, length: 255 )
• COLOUR_CODED ( type: esriFieldTypeString, alias: Colour-Coded, length: 255 )
• PAINT_DATE ( type: esriFieldTypeString, alias: Date Painted, length: 255 )
• INSPECTION_DATE ( type: esriFieldTypeString, alias: INSPECTION_DATE, length: 255 )
• FLUSH_DATE ( type: esriFieldTypeString, alias: Date Flushed, length: 255 )
• SHOVEL_DATE ( type: esriFieldTypeString, alias: SHOVEL_DATE, length: 255 )
• QUADRANT_NUMBER ( type: esriFieldTypeString, alias: Quad Num ID, length: 255 )
• ArcMap_Hyd_Point_No_1 ( type: esriFieldTypeString, alias: ArcMap_Hyd_Point_No_1, length: 255 )
• I_O___DATE ( type: esriFieldTypeString, alias: I_O___DATE, length: 255 )
• Repair_comment ( type: esriFieldTypeString, alias: Repair Comment, length: 255 )
• GPM___psi_res ( type: esriFieldTypeString, alias: GPM___psi_res, length: 255 )
• Date_Tested ( type: esriFieldTypeString, alias: Date_Tested, length: 255 )
• Time_24hrs ( type: esriFieldTypeString, alias: Time_24hrs, length: 255 )
• BR_VLV ( type: esriFieldTypeString, alias: BR_VLV, length: 255 )
• INSTLLD ( type: esriFieldTypeString, alias: INSTLLD, length: 255 )
• SIZE1 ( type: esriFieldTypeString, alias: SIZE1, length: 255 )
• MAKE1 ( type: esriFieldTypeString, alias: MAKE1, length: 255 )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 255 )
• TIE ( type: esriFieldTypeString, alias: TIE, length: 255 )
• N_S_E_W_OF_FH ( type: esriFieldTypeString, alias: N_S_E_W_OF_FH, length: 255 )
• OPENS ( type: esriFieldTypeString, alias: OPENS, length: 255 )
• TURNS ( type: esriFieldTypeString, alias: TURNS, length: 255 )
• SET_IN ( type: esriFieldTypeString, alias: SET_IN, length: 255 )
• RECORD_REVSN_DATE ( type: esriFieldTypeString, alias: RECORD_REVSN_DATE, length: 255 )
• I_O_DATE ( type: esriFieldTypeString, alias: I_O_DATE, length: 255 )
• I_O ( type: esriFieldTypeString, alias: I_O, length: 255 )
• REMARK ( type: esriFieldTypeString, alias: Remark, length: 255 )
• out_of_service ( type: esriFieldTypeString, alias: Out of Service (Y/N), length: 15 )
• CL_PROFILE ( type: esriFieldTypeString, alias: Chlorine Profile (Y/N), length: 5 )
• date_out_of_serv ( type: esriFieldTypeString, alias: Date Out of Service, length: 15 )
• date_in_serv ( type: esriFieldTypeString, alias: Date Back In Service, length: 15 )
• HYD_MODEL ( type: esriFieldTypeString, alias: Hydrant Model, length: 50 )
• HYD_MAKE_INT ( type: esriFieldTypeSmallInteger, alias: Hydrant Make )
• PUMPER ( type: esriFieldTypeString, alias: Pumper Nozzle, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape Geometry )
• StreetName ( type: esriFieldTypeString, alias: StreetName, length: 200 )
• Segment_ID ( type: esriFieldTypeString, alias: Segment_ID, length: 255 )
• AM_ID ( type: esriFieldTypeString, alias: AM_ID, length: 20 )
• CRID ( type: esriFieldTypeString, alias: CRID, length: 20 )
• Project_Title ( type: esriFieldTypeString, alias: Project_Title, length: 200 )
• Responsible_Department ( type: esriFieldTypeString, alias: Responsible_Department, length: 100 )
• Service_Area ( type: esriFieldTypeString, alias: Service_Area, length: 50 )
• Project_Type ( type: esriFieldTypeString, alias: Project_Type, length: 50 )
• Project_Description ( type: esriFieldTypeString, alias: Project_Description, length: 250 )
• Project_Cost_2024 ( type: esriFieldTypeDouble, alias: Project_Cost_2024 )
• Project_Budget_Year ( type: esriFieldTypeString, alias: Project_Budget_Year, length: 20 )
• Project_Timing ( type: esriFieldTypeString, alias: Project_Timing, length: 20 )
• Risk_Score ( type: esriFieldTypeSmallInteger, alias: Risk_Score )
• Current_PoF ( type: esriFieldTypeSmallInteger, alias: Current_PoF )
• CoF ( type: esriFieldTypeSmallInteger, alias: CoF )
• Current_Replacement_Value ( type: esriFieldTypeDouble, alias: Current_Replacement_Value )
• Asset_Risk_Score ( type: esriFieldTypeSmallInteger, alias: Asset_Risk_Score )

Types:

ID: 1
Name: 1 - McAvity
Domains:
• STREET:
  Coded Values: [ABBOTT ST: ABBOTT ST] , [ADAM ST: ADAM ST] , [ADRIAN ST: ADRIAN ST] , ...603 more...
• HYD_MODEL:
  Coded Values: [M-67 (THREAD): M-67 (THREAD)] , [M-67-B BRIGADIER (BOLT): M-67-B BRIGADIER (BOLT)] , [Unknown: Unknown]
• PUMPER:
  Inherited
• StreetName:
  Coded Values: [ABBOTT ST: ABBOTT ST] , [ADAM ST: ADAM ST] , [ADRIAN ST: ADRIAN ST] , ...603 more...

---

ID: 2
Name: 2 - Mueller
Domains:
• STREET:
  Coded Values: [ABBOTT ST: ABBOTT ST] , [ADAM ST: ADAM ST] , [ADRIAN ST: ADRIAN ST] , ...603 more...
• HYD_MODEL:
  Coded Values: [Canada Valve Century: Canada Valve Century] , [Centurion: Centurion] , [Darling B-50-B: Darling B-50-B] , ...1 more...
• PUMPER:
  Inherited
• StreetName:
  Coded Values: [ABBOTT ST: ABBOTT ST] , [ADAM ST: ADAM ST] , [ADRIAN ST: ADRIAN ST] , ...603 more...

---

ID: 3
Name: 3 - Unknown
Domains:
• STREET:
  Coded Values: [ABBOTT ST: ABBOTT ST] , [ADAM ST: ADAM ST] , [ADRIAN ST: ADRIAN ST] , ...603 more...
• HYD_MODEL:
  Coded Values: [Unknown: Unknown]
• PUMPER:
  Coded Values: [Unknown: Unknown]
• StreetName:
  Coded Values: [ABBOTT ST: ABBOTT ST] , [ADAM ST: ADAM ST] , [ADRIAN ST: ADRIAN ST] , ...603 more...

---

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

  Iteminfo   Thumbnail   Metadata