Layers:

Layer: Water Fire Hydrant (54)

Name: Water Fire Hydrant

Display Field: LEGACYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 18055.954822

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: 1368836.7079387307
YMin: 491985.13007345796
XMax: 1405401.391236782
YMax: 534695.8279692233
Spatial Reference: 102723  (3735)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ASSETID ( type: esriFieldTypeString, alias: CityWorks AssetID, length: 20 )
• WFID ( type: esriFieldTypeString, alias: Fire Hydrant ID, length: 10 )
• WFMANUF ( type: esriFieldTypeString, alias: Manufacturer, length: 4 , Coded Values: [D: Darling] , [M: Meuller] , [OTH: Other] , ...8 more... )
• WFENGCAP ( type: esriFieldTypeString, alias: Cap Indicator, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• WFVALVE ( type: esriFieldTypeString, alias: Valve Indicator, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: INSTALLATIONDATE, length: 8 )
• SERVICE_STATUS ( type: esriFieldTypeString, alias: Service Status, length: 15 , Coded Values: [A: Active] , [I: Inactive] )
• WFFLOW ( type: esriFieldTypeDouble, alias: Flow )
• LOCATION ( type: esriFieldTypeString, alias: Location, length: 50 )
• MODEL ( type: esriFieldTypeString, alias: Model, length: 50 )
• MANUFACTUREDATE ( type: esriFieldTypeString, alias: Manufacture Date, length: 5 )
• GPS ( type: esriFieldTypeString, alias: Needs GPS?, length: 4 , Coded Values: [Y: Yes] , [N: No] )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 30 )
• ENGINECOMPANY ( type: esriFieldTypeInteger, alias: Engine Company )
• PIPEID ( type: esriFieldTypeString, alias: PIPEID, length: 30 )
• FH_FAC ( type: esriFieldTypeString, alias: FH_FAC, length: 10 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 255 )
• OperationalStatus ( type: esriFieldTypeString, alias: OperationalStatus, length: 255 )
• StaticPSI ( type: esriFieldTypeDouble, alias: StaticPSI )
• ResidualPSI ( type: esriFieldTypeDouble, alias: ResidualPSI )
• Pitot ( type: esriFieldTypeDouble, alias: Pitot )
• DeviceUsed ( type: esriFieldTypeDouble, alias: DeviceUsed )
• Coefficient ( type: esriFieldTypeDouble, alias: Coefficient )
• FlowMins ( type: esriFieldTypeDouble, alias: FlowMins )
• FlowBaseline ( type: esriFieldTypeDouble, alias: FlowBaseline )
• GallonsUsed ( type: esriFieldTypeDouble, alias: GallonsUsed )
• OperationComments ( type: esriFieldTypeString, alias: OperationComments, length: 255 )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• FlushDate ( type: esriFieldTypeDate, alias: FlushDate, length: 8 )
• FlowDate ( type: esriFieldTypeDate, alias: FlowDate, length: 8 )
• BarCode ( type: esriFieldTypeString, alias: Bar Code, length: 20 )
• Private ( type: esriFieldTypeString, alias: Private, length: 10 , Coded Values: [Y: Yes] , [N: No] )
• LDH ( type: esriFieldTypeString, alias: LDH Connection, length: 20 , Coded Values: [A: 4.5"] , [B: STORZ] , [C: Other] , ...1 more... )
• MAINTCONCERN ( type: esriFieldTypeString, alias: Maintenance Concern, length: 25 , Coded Values: [A: Does Not Come On] , [B: Cannot Turn Off] , [C: Too Hard to Operate] , ...5 more... )
• COMPLETED ( type: esriFieldTypeString, alias: Inspection Completed, length: 5 , Coded Values: [Y: Yes] , [N: No] )
• DATEINSPECTED ( type: esriFieldTypeDate, alias: Date Inspected, length: 8 )
• PrivateSymbol ( type: esriFieldTypeSmallInteger, alias: PrivateSymbol )
• INSPECTIONCOMMENTS ( type: esriFieldTypeString, alias: Inspection Comments, length: 50 )
• FlowPrevious ( type: esriFieldTypeDouble, alias: Previous Year Flow )
• SMALLHEADCONNECTION ( type: esriFieldTypeString, alias: Small Diameter Head Connection, length: 50 , Coded Values: [Hamilton: 2.5" Hamilton Threads] , [National: 2.5" National Pipe Threads] , [Other: Other] )
• INSPECTIONINITIALS ( type: esriFieldTypeString, alias: Inspected By Initials, length: 10 )
• PSIPrevious ( type: esriFieldTypeDouble, alias: Previous Year PSI )

Layer: Water Meter Location (53)

Name: Water Meter Location

Display Field: LEGACYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 18055.954822

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: 1368580.5818585008
YMin: 492651.9604740739
XMax: 1411274.7159142643
YMax: 532935.1214715838
Spatial Reference: 102723  (3735)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SubtypeCD

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• ASSETID ( type: esriFieldTypeString, alias: CityWorks AssetID, length: 20 )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: Subtype )
• BYPASSINDICATOR ( type: esriFieldTypeString, alias: Bypass Indicator, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• DEVICEID ( type: esriFieldTypeString, alias: DEVICEID, length: 32 )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: Location Description, length: 64 )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 15 , Coded Values: [CITY: City of Hamilton] , [OTH: Other] )
• PREMISE ( type: esriFieldTypeString, alias: PREMISE, length: 32 )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: INSTALLATIONDATE, length: 8 )
• SERVICE_STATUS ( type: esriFieldTypeString, alias: Service Status, length: 15 , Coded Values: [A: Active] , [I: Inactive] )
• ACCOUNT ( type: esriFieldTypeString, alias: Water Account Number, length: 32 )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 30 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 100 )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Meter Installation Date, length: 8 )
• WML_FAC ( type: esriFieldTypeString, alias: WML_FAC, length: 10 )
• CRTICAL ( type: esriFieldTypeString, alias: CRTICAL, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• PIPEID ( type: esriFieldTypeString, alias: PIPEID, length: 50 )
• LOCATIONID ( type: esriFieldTypeString, alias: Cayenta Location Number, length: 10 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 255 )
Types:
ID: 1
Name: Single-Meter
Domains:
• ENABLED:
  Inherited
• BYPASSINDICATOR:
  Inherited
• OWNER:
  Inherited
• INSTALLER:
  Inherited
• SERVICE_STATUS:
  Inherited

---

ID: 2
Name: Multi-Meter
Domains:
• ENABLED:
  Inherited
• BYPASSINDICATOR:
  Inherited
• OWNER:
  Inherited
• INSTALLER:
  Inherited
• SERVICE_STATUS:
  Inherited

---

Layer: Water Valve (57)

Name: Water Valve

Display Field: LEGACYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 18055.954822

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: 1368837.20099473
YMin: 490084.0455916822
XMax: 1411274.7159142643
YMax: 534812.5435533375
Spatial Reference: 102723  (3735)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: SUBTYPECD
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Default Label: Main Line Valve
UniqueValueInfos:
• Value: 3
  Label: Air Release Valve
  Description:
  Symbol:
  
• Value: 7
  Label: Curb Valve
  Description:
  Symbol:
  
• Value: 8
  Label: FH Valve
  Description:
  Symbol:
  
• Value: 5
  Label: PRV
  Description:
  Symbol:
  
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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SubtypeCD

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED , Coded Values: [0: False] , [1: True] )
• LEGACYID ( type: esriFieldTypeString, alias: CityWorks LegacyID, length: 20 )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: WARRANTYDATE, length: 8 )
• ASSETID ( type: esriFieldTypeString, alias: CityWorks AssetID, length: 20 )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: Subtype )
• WCVID ( type: esriFieldTypeString, alias: Valve ID, length: 10 )
• WCVTURN ( type: esriFieldTypeString, alias: Number of Turns, length: 10 )
• WCVTYP ( type: esriFieldTypeString, alias: Type, length: 2 , Coded Values: [BF: Butterfly Valve] , [GV: Gate Valve] , [BV: Ball Valve] , ...2 more... )
• WCVDIR ( type: esriFieldTypeString, alias: Turn Direction, length: 2 , Coded Values: [L: Left] , [R: Right] )
• WCVSERV ( type: esriFieldTypeString, alias: Valve Use, length: 15 )
• WCVDIA ( type: esriFieldTypeInteger, alias: Diameter , Coded Values: [2: 2"] , [3: 3"] , [6: 6"] , ...17 more... )
• VALVEACCESS ( type: esriFieldTypeString, alias: Access, length: 2 , Coded Values: [V: Vault] , [C: Curb Box] , [R: Roadway Box] )
• BURIEDDEPTHINCHES ( type: esriFieldTypeInteger, alias: Buried Depth in Inches )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, length: 32 )
• GENERALCOMMENTS ( type: esriFieldTypeString, alias: General Comments, length: 256 )
• JOINTTYPE ( type: esriFieldTypeString, alias: Joint Type, length: 15 , Coded Values: [M: Mechanical Joint] , [F: Flanged] , [P: Poured] , ...2 more... )
• RESTRAINTTYPE ( type: esriFieldTypeString, alias: Restraint Type, length: 15 , Coded Values: [F: Field Lock] , [R: Rodded] , [M: Mega Lug] , ...2 more... )
• ANGLE ( type: esriFieldTypeDouble, alias: Symbol Rotation )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: INSTALLATIONDATE, length: 8 )
• WORKORDERID ( type: esriFieldTypeString, alias: Work Order ID, length: 15 )
• INSTALLER ( type: esriFieldTypeString, alias: INSTALLER, length: 4 , Coded Values: [CITY: City of Hamilton] , [CONT: Contractor] , [OTH: Other] )
• SERVICE_STATUS ( type: esriFieldTypeString, alias: Service Status, length: 15 , Coded Values: [A: Active] , [I: Inactive] )
• WATERTRACEWEIGHT ( type: esriFieldTypeInteger, alias: Water Trace Weight )
• VALVEPOSITION ( type: esriFieldTypeInteger, alias: Valve Position , Coded Values: [0: Closed] , [1: Open] )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 30 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 100 )
• FHV_FAC ( type: esriFieldTypeString, alias: FHV_FAC, length: 10 )
• CV_FAC ( type: esriFieldTypeString, alias: CV_FAC, length: 10 )
• MV_FAC ( type: esriFieldTypeString, alias: MV_FAC, length: 10 )
• MAPGRID ( type: esriFieldTypeString, alias: Map Grid ID, length: 4 )
• MAPGRIDVC ( type: esriFieldTypeString, alias: MAPGRIDVC, length: 5 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 255 )
• HighTorque ( type: esriFieldTypeDouble, alias: HighTorque )
• ExerciseDate ( type: esriFieldTypeDate, alias: ExerciseDate, length: 8 )
• x ( type: esriFieldTypeDouble, alias: x )
• y ( type: esriFieldTypeDouble, alias: y )
• horizontalAccuracy ( type: esriFieldTypeDouble, alias: horizontalAccuracy )
• hdop ( type: esriFieldTypeDouble, alias: hdop )
• pdop ( type: esriFieldTypeDouble, alias: pdop )
• vdop ( type: esriFieldTypeDouble, alias: vdop )
• satellites ( type: esriFieldTypeInteger, alias: satellites )
• InspectionID ( type: esriFieldTypeString, alias: CW Inspection ID, length: 25 )
• Operable ( type: esriFieldTypeString, alias: Operable, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• UpdatedLocationGPS ( type: esriFieldTypeString, alias: Updated GIS to GPS?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
Types:
ID: 6
Name: Cone
Domains:
• ENABLED:
  Inherited
• WCVTYP:
  Inherited
• WCVDIR:
  Inherited
• WCVDIA:
  Inherited
• VALVEACCESS:
  Inherited
• JOINTTYPE:
  Inherited
• RESTRAINTTYPE:
  Inherited
• INSTALLER:
  Inherited
• SERVICE_STATUS:
  Inherited
• VALVEPOSITION:
  Inherited

---

ID: 5
Name: PressureReducer
Domains:
• ENABLED:
  Inherited
• WCVTYP:
  Inherited
• WCVDIR:
  Inherited
• WCVDIA:
  Inherited
• VALVEACCESS:
  Inherited
• JOINTTYPE:
  Inherited
• RESTRAINTTYPE:
  Inherited
• INSTALLER:
  Inherited
• SERVICE_STATUS:
  Inherited
• VALVEPOSITION:
  Inherited

---

ID: 3
Name: AirRelease
Domains:
• ENABLED:
  Inherited
• WCVTYP:
  Inherited
• WCVDIR:
  Inherited
• WCVDIA:
  Inherited
• VALVEACCESS:
  Inherited
• JOINTTYPE:
  Inherited
• RESTRAINTTYPE:
  Inherited
• INSTALLER:
  Inherited
• SERVICE_STATUS:
  Inherited
• VALVEPOSITION:
  Inherited

---

ID: 7
Name: Curb
Domains:
• ENABLED:
  Inherited
• WCVTYP:
  Inherited
• WCVDIR:
  Inherited
• WCVDIA:
  Inherited
• VALVEACCESS:
  Inherited
• JOINTTYPE:
  Inherited
• RESTRAINTTYPE:
  Inherited
• INSTALLER:
  Inherited
• SERVICE_STATUS:
  Inherited
• VALVEPOSITION:
  Inherited

---

ID: 2
Name: Gate
Domains:
• ENABLED:
  Inherited
• WCVTYP:
  Inherited
• WCVDIR:
  Inherited
• WCVDIA:
  Inherited
• VALVEACCESS:
  Inherited
• JOINTTYPE:
  Inherited
• RESTRAINTTYPE:
  Inherited
• INSTALLER:
  Inherited
• SERVICE_STATUS:
  Inherited
• VALVEPOSITION:
  Inherited

---

ID: 9
Name: Boundary
Domains:
• ENABLED:
  Inherited
• WCVTYP:
  Inherited
• WCVDIR:
  Inherited
• WCVDIA:
  Inherited
• VALVEACCESS:
  Inherited
• JOINTTYPE:
  Inherited
• RESTRAINTTYPE:
  Inherited
• INSTALLER:
  Inherited
• SERVICE_STATUS:
  Inherited
• VALVEPOSITION:
  Inherited

---

ID: 10
Name: Unknown Valve Type
Domains:
• ENABLED:
  Inherited
• WCVTYP:
  Inherited
• WCVDIR:
  Inherited
• WCVDIA:
  Inherited
• VALVEACCESS:
  Inherited
• JOINTTYPE:
  Inherited
• RESTRAINTTYPE:
  Inherited
• INSTALLER:
  Inherited
• SERVICE_STATUS:
  Inherited
• VALVEPOSITION:
  Inherited

---

ID: 4
Name: BlowOff
Domains:
• ENABLED:
  Inherited
• WCVTYP:
  Inherited
• WCVDIR:
  Inherited
• WCVDIA:
  Inherited
• VALVEACCESS:
  Inherited
• JOINTTYPE:
  Inherited
• RESTRAINTTYPE:
  Inherited
• INSTALLER:
  Inherited
• SERVICE_STATUS:
  Inherited
• VALVEPOSITION:
  Inherited

---

ID: 1
Name: Butterfly
Domains:
• ENABLED:
  Inherited
• WCVTYP:
  Inherited
• WCVDIR:
  Inherited
• WCVDIA:
  Inherited
• VALVEACCESS:
  Inherited
• JOINTTYPE:
  Inherited
• RESTRAINTTYPE:
  Inherited
• INSTALLER:
  Inherited
• SERVICE_STATUS:
  Inherited
• VALVEPOSITION:
  Inherited

---

ID: 8
Name: Fire Hydrant Valve
Domains:
• ENABLED:
  Inherited
• WCVTYP:
  Inherited
• WCVDIR:
  Inherited
• WCVDIA:
  Inherited
• VALVEACCESS:
  Inherited
• JOINTTYPE:
  Inherited
• RESTRAINTTYPE:
  Inherited
• INSTALLER:
  Inherited
• SERVICE_STATUS:
  Inherited
• VALVEPOSITION:
  Inherited

---

Layer: Water Service (51)

Name: Water Service

Display Field: LEGACYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 18055.954822

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: 1368556.9990104735
YMin: 492651.9604740739
XMax: 1411274.7159142643
YMax: 534812.5435533375
Spatial Reference: 102723  (3735)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: SUBTYPECD
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 1
  Label: Customer Service
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 255, 255]
  Width: 0
• Value: 2
  Label: Street Service
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 255, 255]
  Width: 1
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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SUBTYPECD

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ASSETID ( type: esriFieldTypeString, alias: CityWorks AssetID, length: 20 )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, length: 8 )
• LASTUSER ( type: esriFieldTypeString, alias: Last User, length: 50 )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: Subtype )
• WADIA ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...10 more... )
• WAMATL ( type: esriFieldTypeString, alias: Material, length: 4 , Coded Values: [PE: Polyethylene] , [CI: Cast Iron] , [DI: Ductile Iron] , ...8 more... )
• PRESSZONE ( type: esriFieldTypeString, alias: Water Pressure System, length: 10 , Coded Values: [D: 817 System] , [T: 817 Transmission] , [G: 875 System] , ...10 more... )
• SERVICE_STATUS ( type: esriFieldTypeString, alias: Service Status, length: 15 , Coded Values: [A: Active] , [I: Inactive] )
• FIELDMEASUREDLENGTH ( type: esriFieldTypeDouble, alias: Field Measured Length )
• WORKORDERID ( type: esriFieldTypeString, alias: Work Order ID, length: 15 )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: INSTALLATIONDATE, length: 8 )
• CONDITIONCODE ( type: esriFieldTypeString, alias: Condition, length: 1 , Coded Values: [G: Good] , [A: Average] , [P: Poor] )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: Location Description, length: 64 )
• LOCATIONCONFIDENCELEVEL ( type: esriFieldTypeString, alias: Location Confidence, length: 1 , Coded Values: [H: High] , [M: Medium] , [L: Low] )
• BURIEDDEPTHINCHES ( type: esriFieldTypeInteger, alias: Buried Depth (Inches) )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 32 , Coded Values: [CITY: City of Hamilton] , [OTH: Other] )
• WAUSE ( type: esriFieldTypeString, alias: WAUSE, length: 50 )
• OPERATINGPRESSURE ( type: esriFieldTypeInteger, alias: Operating Pressure )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 30 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 100 )
• WS_FAC ( type: esriFieldTypeString, alias: WS_FAC, length: 10 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• FROMVALVE ( type: esriFieldTypeString, alias: FROMVALVE, length: 25 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 255 )
• CONTRACTNUMBER ( type: esriFieldTypeString, alias: Contract Number, length: 50 )
• SERVICEADDRESS ( type: esriFieldTypeString, alias: Service Address, length: 150 )
• MATERIALREPLACEDATE ( type: esriFieldTypeDate, alias: Material Replaced Date, length: 8 )
• EPAMATERIAL ( type: esriFieldTypeString, alias: EPA Service Material, length: 50 , Coded Values: [PE: Polyethylene] , [CI: Cast Iron] , [DI: Ductile Iron] , ...8 more... )
• MATERIALDOCUMENT ( type: esriFieldTypeString, alias: Material Documentation, length: 50 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
Types:
ID: 1
Name: CustomerService
Domains:
• ENABLED:
  Inherited
• WADIA:
  Inherited
• WAMATL:
  Inherited
• PRESSZONE:
  Inherited
• SERVICE_STATUS:
  Inherited
• CONDITIONCODE:
  Inherited
• LOCATIONCONFIDENCELEVEL:
  Inherited
• INSTALLER:
  Inherited
• OWNER:
  Inherited

---

ID: 2
Name: StreetService
Domains:
• ENABLED:
  Inherited
• WADIA:
  Inherited
• WAMATL:
  Inherited
• PRESSZONE:
  Inherited
• SERVICE_STATUS:
  Inherited
• CONDITIONCODE:
  Inherited
• LOCATIONCONFIDENCELEVEL:
  Inherited
• INSTALLER:
  Inherited
• OWNER:
  Inherited

---

Layer: Water Main (50)

Name: Water Main

Display Field: LEGACYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 72225

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: 1368836.7079387307
YMin: 485318.7065152377
XMax: 1418513.4005929977
YMax: 534824.5545613468
Spatial Reference: 102723  (3735)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: SUBTYPECD
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 6
  Label: Fire Hydrant
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [255, 190, 190, 255]
  Width: 2
• Value: 5
  Label: Lagoon/Decant
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 132, 168, 255]
  Width: 2
• Value: 1
  Label: Potable
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 2
• Value: 2
  Label: Raw
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: 3
  Label: Sludge
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 168, 132, 255]
  Width: 2
• Value: 4
  Label: Transmission
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 38, 115, 255]
  Width: 2
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [WADIA] CONCAT " " CONCAT [WAMATL]
Use Coded Values: true
Symbol:
Color: [255, 255, 255, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 11
Font Family: Calibri
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 4515.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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SUBTYPECD

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ASSETID ( type: esriFieldTypeString, alias: CityWorks AssetID, length: 20 )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: Subtype )
• WADIA ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [2: 2"] , [3: 3"] , [6: 6"] , ...11 more... )
• WAMATL ( type: esriFieldTypeString, alias: Material, length: 4 , Coded Values: [PE: Polyethylene] , [CI: Cast Iron] , [CO: Concrete] , ...10 more... )
• PRESSZONE ( type: esriFieldTypeString, alias: Water Pressure System, length: 10 , Coded Values: [D: 817 System] , [T: 817 Transmission] , [G: 875 System] , ...10 more... )
• SERVICE_STATUS ( type: esriFieldTypeString, alias: Service Status, length: 15 , Coded Values: [A: Active] , [I: Inactive] )
• FIELDMEASUREDLENGTH ( type: esriFieldTypeDouble, alias: Field Measured Length )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: INSTALLATIONDATE, length: 8 )
• CONDITIONCODE ( type: esriFieldTypeString, alias: Condition, length: 1 , Coded Values: [G: Good] , [A: Average] , [P: Poor] )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: Location Description, length: 64 )
• LOCATIONCONFIDENCELEVEL ( type: esriFieldTypeString, alias: Location Confidence, length: 1 , Coded Values: [H: High] , [M: Medium] , [L: Low] )
• CATHODICPROTECTIONIND ( type: esriFieldTypeString, alias: Cathodic Protection Indicator, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• BURIEDDEPTHINCHES ( type: esriFieldTypeInteger, alias: Buried Depth (Inches) )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 15 , Coded Values: [CITY: City of Hamilton] , [OTH: Other] )
• OPERATINGPRESSURE ( type: esriFieldTypeInteger, alias: Operating Pressure )
• DRAWINGID_REF ( type: esriFieldTypeString, alias: DRAWING/REF_ID, length: 10 )
• DRAWIG_ID_REF_ID ( type: esriFieldTypeString, alias: DRAWING, length: 50 )
• SUBDIVISION_DRAWINGS ( type: esriFieldTypeString, alias: Subdivision Drawings, length: 75 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 250 )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 30 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 100 )
• BEDDING_TYPE ( type: esriFieldTypeString, alias: Bedding, length: 15 , Coded Values: [NATIVE: Native Soil] , [703 Modified: Modified Sand] , [SAND: Sand] )
• WRAPPED ( type: esriFieldTypeString, alias: Wrapped, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• LINED ( type: esriFieldTypeString, alias: Lined, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• REHABDATE ( type: esriFieldTypeDate, alias: REHAB DATE, length: 8 )
• FIREFLOWPROBLEM ( type: esriFieldTypeString, alias: Problematic Fire Flow, length: 3 , Coded Values: [Y: Yes] , [N: No] )
• BREAKCOUNT ( type: esriFieldTypeSmallInteger, alias: Break Count )
• PIPECLASSCONDITION ( type: esriFieldTypeSmallInteger, alias: Pipe Class Age Condition )
• BREAKRATECONDITION ( type: esriFieldTypeSmallInteger, alias: Break Rate Condition )
• CRITICALITYREASON ( type: esriFieldTypeString, alias: Criticality Reason, length: 50 )
• RISK ( type: esriFieldTypeDouble, alias: RISK FACTOR )
• PIPECLASS ( type: esriFieldTypeDouble, alias: PIPECLASS )
• CRITICALITY ( type: esriFieldTypeDouble, alias: CRITICALITY )
• REPLACEMENTYEAR ( type: esriFieldTypeInteger, alias: REPLACEMENT YEAR )
• WM_FAC ( type: esriFieldTypeString, alias: WM_FAC, length: 10 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• FROMVALVE ( type: esriFieldTypeString, alias: FROMVALVE, length: 25 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 255 )
• CONTRACTNUMBER ( type: esriFieldTypeString, alias: Contract Number, length: 50 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
Types:
ID: 2
Name: Raw
Domains:
• ENABLED:
  Inherited
• WADIA:
  Inherited
• WAMATL:
  Inherited
• PRESSZONE:
  Inherited
• SERVICE_STATUS:
  Inherited
• CONDITIONCODE:
  Inherited
• LOCATIONCONFIDENCELEVEL:
  Inherited
• CATHODICPROTECTIONIND:
  Inherited
• INSTALLER:
  Inherited
• OWNER:
  Inherited
• BEDDING_TYPE:
  Inherited
• WRAPPED:
  Inherited
• LINED:
  Inherited
• FIREFLOWPROBLEM:
  Inherited

---

ID: 3
Name: Sludge
Domains:
• ENABLED:
  Inherited
• WADIA:
  Inherited
• WAMATL:
  Inherited
• PRESSZONE:
  Inherited
• SERVICE_STATUS:
  Inherited
• CONDITIONCODE:
  Inherited
• LOCATIONCONFIDENCELEVEL:
  Inherited
• CATHODICPROTECTIONIND:
  Inherited
• INSTALLER:
  Inherited
• OWNER:
  Inherited
• BEDDING_TYPE:
  Inherited
• WRAPPED:
  Inherited
• LINED:
  Inherited
• FIREFLOWPROBLEM:
  Inherited

---

ID: 5
Name: Lagoon/Decant
Domains:
• ENABLED:
  Inherited
• WADIA:
  Inherited
• WAMATL:
  Inherited
• PRESSZONE:
  Inherited
• SERVICE_STATUS:
  Inherited
• CONDITIONCODE:
  Inherited
• LOCATIONCONFIDENCELEVEL:
  Inherited
• CATHODICPROTECTIONIND:
  Inherited
• INSTALLER:
  Inherited
• OWNER:
  Inherited
• BEDDING_TYPE:
  Inherited
• WRAPPED:
  Inherited
• LINED:
  Inherited
• FIREFLOWPROBLEM:
  Inherited

---

ID: 6
Name: Fire Hydrant
Domains:
• ENABLED:
  Inherited
• WADIA:
  Inherited
• WAMATL:
  Inherited
• PRESSZONE:
  Inherited
• SERVICE_STATUS:
  Inherited
• CONDITIONCODE:
  Inherited
• LOCATIONCONFIDENCELEVEL:
  Inherited
• CATHODICPROTECTIONIND:
  Inherited
• INSTALLER:
  Inherited
• OWNER:
  Inherited
• BEDDING_TYPE:
  Inherited
• WRAPPED:
  Inherited
• LINED:
  Inherited
• FIREFLOWPROBLEM:
  Inherited

---

ID: 1
Name: Potable
Domains:
• ENABLED:
  Inherited
• WADIA:
  Inherited
• WAMATL:
  Inherited
• PRESSZONE:
  Inherited
• SERVICE_STATUS:
  Inherited
• CONDITIONCODE:
  Inherited
• LOCATIONCONFIDENCELEVEL:
  Inherited
• CATHODICPROTECTIONIND:
  Inherited
• INSTALLER:
  Inherited
• OWNER:
  Inherited
• BEDDING_TYPE:
  Inherited
• WRAPPED:
  Inherited
• LINED:
  Inherited
• FIREFLOWPROBLEM:
  Inherited

---

ID: 4
Name: Transmission
Domains:
• ENABLED:
  Inherited
• WADIA:
  Inherited
• WAMATL:
  Inherited
• PRESSZONE:
  Inherited
• SERVICE_STATUS:
  Inherited
• CONDITIONCODE:
  Inherited
• LOCATIONCONFIDENCELEVEL:
  Inherited
• CATHODICPROTECTIONIND:
  Inherited
• INSTALLER:
  Inherited
• OWNER:
  Inherited
• BEDDING_TYPE:
  Inherited
• WRAPPED:
  Inherited
• LINED:
  Inherited
• FIREFLOWPROBLEM:
  Inherited

---