Name: Hydrant (Private)

Display Field: HydrantPointID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 6000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 304633.79360000044
YMin: 4890657.4483
XMax: 313041.52130000014
YMax: 4897008.089299999
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: OBJECTID )
• HydrantPointID ( type: esriFieldTypeInteger, alias: HydrantPointID )
• QUADNUM ( type: esriFieldTypeString, alias: QUADNUM, length: 6 )
• Section ( type: esriFieldTypeString, alias: Section, length: 4 )
• OBJECTID_1 ( type: esriFieldTypeInteger, alias: OBJECTID_1 )
• CableCad_FH_ID ( type: esriFieldTypeDouble, alias: CableCad_FH_ID )
• ARCMAP_valve_ID_No_ ( type: esriFieldTypeDouble, alias: ARCMAP_valve_ID_No_ )
• ArcMap_Hyd_Point_No_ ( type: esriFieldTypeDouble, alias: ArcMap_Hyd_Point_No_ )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 255 )
• STREET ( type: esriFieldTypeString, alias: STREET, length: 255 )
• ADDRESS ( type: esriFieldTypeDouble, alias: ADDRESS )
• CROSS_STREET_1 ( type: esriFieldTypeString, alias: CROSS_STREET_1, length: 255 )
• CROSS_STREET__2 ( type: esriFieldTypeString, alias: CROSS_STREET__2, length: 255 )
• TOP_NUT_ELEVATION ( type: esriFieldTypeDouble, alias: TOP_NUT_ELEVATION )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 255 )
• YEAR ( type: esriFieldTypeDouble, alias: YEAR )
• INSTALL_DATE ( type: esriFieldTypeDouble, alias: INSTALL_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_ONE_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, length: 255 )
• DIRECTION_TO_OPEN ( type: esriFieldTypeString, alias: DIRECTION_TO_OPEN, length: 255 )
• BREAK_AWAY_FLANGE ( type: esriFieldTypeString, alias: BREAK_AWAY_FLANGE, length: 255 )
• LATERAL_SIZE ( type: esriFieldTypeDouble, alias: LATERAL_SIZE )
• ISOLATION_VALVE ( type: esriFieldTypeString, alias: ISOLATION_VALVE, 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: ANTI_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: PAINT_DATE, length: 255 )
• INSPECTION_DATE ( type: esriFieldTypeString, alias: INSPECTION_DATE, length: 255 )
• FLUSH_DATE ( type: esriFieldTypeString, alias: FLUSH_DATE, length: 255 )
• SHOVEL_DATE ( type: esriFieldTypeString, alias: SHOVEL_DATE, length: 255 )
• QUADRANT_NUMBER ( type: esriFieldTypeString, alias: QUADRANT_NUMBER, 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, length: 15 )
• CL_PROFILE ( type: esriFieldTypeString, alias: CL_PROFILE, length: 5 )
• date_out_of_serv ( type: esriFieldTypeString, alias: date_out_of_serv, length: 15 )
• date_in_serv ( type: esriFieldTypeString, alias: date_in_serv, length: 15 )
• HYD_MODEL ( type: esriFieldTypeString, alias: HYD_MODEL, length: 50 )
• HYD_MAKE_INT ( type: esriFieldTypeSmallInteger, alias: HYD_MAKE_INT )
• PUMPER ( type: esriFieldTypeString, alias: PUMPER, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• StreetName ( type: esriFieldTypeString, alias: Street Name, length: 200 )
• Segment_ID ( type: esriFieldTypeInteger, alias: Segment_ID )
• 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: 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: 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: 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:
  Inherited
• 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