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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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: true
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

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

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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: true
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSETID ( type: esriFieldTypeString, alias: CityWorks AssetID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetID )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: Subtype, editable: true, nullable: true, defaultValue: 1, modelName: SubtypeCD )
• BYPASSINDICATOR ( type: esriFieldTypeString, alias: Bypass Indicator, editable: true, nullable: true, length: 1, defaultValue: null, modelName: BypassIndicator , Coded Values: [Y: Yes] , [N: No] )
• DEVICEID ( type: esriFieldTypeString, alias: DEVICEID, editable: true, nullable: true, length: 32, defaultValue: null, modelName: DEVICEID )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 64, defaultValue: null, modelName: LocationDescription )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 15, defaultValue: null, modelName: OWNER , Coded Values: [CITY: City of Hamilton] , [OTH: Other] )
• PREMISE ( type: esriFieldTypeString, alias: PREMISE, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PREMISE )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: INSTALLATIONDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATIONDATE )
• SERVICE_STATUS ( type: esriFieldTypeString, alias: Service Status, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Service_Status , Coded Values: [A: Active] , [I: Inactive] )
• ACCOUNT ( type: esriFieldTypeString, alias: Water Account Number, editable: true, nullable: true, length: 32, defaultValue: null, modelName: ACCOUNT )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FACILITYID )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCATION )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Meter Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• WML_FAC ( type: esriFieldTypeString, alias: WML_FAC, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WML_FAC )
• CRTICAL ( type: esriFieldTypeString, alias: CRTICAL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CRTICAL , Coded Values: [Y: Yes] , [N: No] )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• PIPEID ( type: esriFieldTypeString, alias: PIPEID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PIPEID )
• LOCATIONID ( type: esriFieldTypeString, alias: Cayenta Location Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LOCATIONID )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADDRESS )
Templates:
• Name: Water Meter Location
  Description:
  Prototype:
  PIPEID: null
  ASSETID: null
  LOCATIONID: null
  SUBTYPECD: 1
  BYPASSINDICATOR: null
  DEVICEID: null
  LOCATIONDESCRIPTION: null
  OWNER: null
  PREMISE: null
  INSTALLATIONDATE: null
  SERVICE_STATUS: null
  ACCOUNT: null
  FACILITYID: null
  LOCATION: null
  INSTALLDATE: null
  WML_FAC: null
  CRTICAL: null
  ADDRESS: null
  
  Drawing Tool: esriFeatureEditToolPoint

Layer: Mainline Valve (60)

Name: Mainline 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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:
XMin: 1368837.20099473
YMin: 490084.0455916822
XMax: 1411274.7159142643
YMax: 534812.5435533375
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: true
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

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

Layer: Curb Valve (59)

Name: Curb 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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:
XMin: 1368837.20099473
YMin: 490084.0455916822
XMax: 1411274.7159142643
YMax: 534812.5435533375
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: true
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

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

Layer: Hydrant Valve (57)

Name: Hydrant 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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:
XMin: 1368837.20099473
YMin: 490084.0455916822
XMax: 1411274.7159142643
YMax: 534812.5435533375
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: true
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

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

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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: [255, 0, 197, 255]
  Width: 1
• 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: true
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, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSETID ( type: esriFieldTypeString, alias: CityWorks AssetID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetID )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEMODIFIED )
• LASTUSER ( type: esriFieldTypeString, alias: Last User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LastUser )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: Subtype, editable: true, nullable: true, defaultValue: 1, modelName: SubtypeCD )
• WADIA ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: Wadia , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...10 more... )
• WAMATL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Wamatl , Coded Values: [PE: Polyethylene] , [CI: Cast Iron] , [DI: Ductile Iron] , ...8 more... )
• PRESSZONE ( type: esriFieldTypeString, alias: Water Pressure System, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PressZone , Coded Values: [D: 817 System] , [T: 817 Transmission] , [G: 875 System] , ...10 more... )
• SERVICE_STATUS ( type: esriFieldTypeString, alias: Service Status, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Service_Status , Coded Values: [A: Active] , [I: Inactive] )
• FIELDMEASUREDLENGTH ( type: esriFieldTypeDouble, alias: Field Measured Length, editable: true, nullable: true, defaultValue: null, modelName: FieldMeasuredLength )
• WORKORDERID ( type: esriFieldTypeString, alias: Work Order ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: WorkOrderID )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: INSTALLATIONDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATIONDATE )
• CONDITIONCODE ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ConditionCode , Coded Values: [G: Good] , [A: Average] , [P: Poor] )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 64, defaultValue: null, modelName: LocationDescription )
• LOCATIONCONFIDENCELEVEL ( type: esriFieldTypeString, alias: Location Confidence, editable: true, nullable: true, length: 1, defaultValue: null, modelName: LocationConfidenceLevel , Coded Values: [H: High] , [M: Medium] , [L: Low] )
• BURIEDDEPTHINCHES ( type: esriFieldTypeInteger, alias: Buried Depth (Inches), editable: true, nullable: true, defaultValue: null, modelName: BuriedDepthInches )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 32, defaultValue: null, modelName: OWNER , Coded Values: [CITY: City of Hamilton] , [OTH: Other] )
• WAUSE ( type: esriFieldTypeString, alias: WAUSE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WAUSE )
• OPERATINGPRESSURE ( type: esriFieldTypeInteger, alias: Operating Pressure, editable: true, nullable: true, defaultValue: null, modelName: OPERATINGPRESSURE )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FACILITYID )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCATION )
• WS_FAC ( type: esriFieldTypeString, alias: WS_FAC, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WS_FAC )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• FROMVALVE ( type: esriFieldTypeString, alias: FROMVALVE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FROMVALVE )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADDRESS )
• CONTRACTNUMBER ( type: esriFieldTypeString, alias: Contract Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTRACTNUMBER )
• SERVICEADDRESS ( type: esriFieldTypeString, alias: Service Address, editable: true, nullable: true, length: 150, defaultValue: null, modelName: SERVICEADDRESS )
• MATERIALREPLACEDATE ( type: esriFieldTypeDate, alias: Material Replaced Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MATERIALREPLACEDATE )
• EPAMATERIAL ( type: esriFieldTypeString, alias: EPA Service Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EPAMATERIAL , Coded Values: [PE: Polyethylene] , [CI: Cast Iron] , [DI: Ductile Iron] , ...8 more... )
• MATERIALDOCUMENT ( type: esriFieldTypeString, alias: Material Documentation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATERIALDOCUMENT )
Types:
ID: 1
Name: CustomerService
Domains:
• WADIA:
  Inherited
• WAMATL:
  Inherited
• PRESSZONE:
  Inherited
• SERVICE_STATUS:
  Inherited
• CONDITIONCODE:
  Inherited
• LOCATIONCONFIDENCELEVEL:
  Inherited
• OWNER:
  Inherited
Templates:
• Name: Water Service
  Description:
  Prototype:
  MATERIALREPLACEDATE: null
  LASTUSER: null
  EPAMATERIAL: null
  ASSETID: null
  DATEMODIFIED: null
  SUBTYPECD: 1
  WADIA: null
  WAMATL: null
  PRESSZONE: null
  SERVICE_STATUS: null
  FIELDMEASUREDLENGTH: null
  WORKORDERID: null
  INSTALLATIONDATE: null
  CONDITIONCODE: null
  LOCATIONDESCRIPTION: null
  LOCATIONCONFIDENCELEVEL: null
  BURIEDDEPTHINCHES: null
  OWNER: null
  WAUSE: null
  OPERATINGPRESSURE: null
  FACILITYID: null
  LOCATION: null
  WS_FAC: null
  MATERIALDOCUMENT: null
  FROMVALVE: null
  SERVICEADDRESS: null
  CONTRACTNUMBER: null
  ADDRESS: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: StreetService
Domains:
• WADIA:
  Inherited
• WAMATL:
  Inherited
• PRESSZONE:
  Inherited
• SERVICE_STATUS:
  Inherited
• CONDITIONCODE:
  Inherited
• LOCATIONCONFIDENCELEVEL:
  Inherited
• OWNER:
  Inherited
Templates:
• Name: StreetService
  Description:
  Prototype:
  EPAMATERIAL: null
  MATERIALREPLACEDATE: null
  ASSETID: null
  DATEMODIFIED: null
  LASTUSER: null
  SUBTYPECD: 2
  WADIA: null
  WAMATL: null
  PRESSZONE: null
  SERVICE_STATUS: null
  FIELDMEASUREDLENGTH: null
  WORKORDERID: null
  INSTALLATIONDATE: null
  CONDITIONCODE: null
  LOCATIONDESCRIPTION: null
  LOCATIONCONFIDENCELEVEL: null
  BURIEDDEPTHINCHES: null
  OWNER: null
  WAUSE: null
  OPERATINGPRESSURE: null
  FACILITYID: null
  LOCATION: null
  WS_FAC: null
  MATERIALDOCUMENT: null
  FROMVALVE: null
  SERVICEADDRESS: null
  CONTRACTNUMBER: null
  ADDRESS: null
  
  Drawing Tool: esriFeatureEditToolLine

---

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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

---

ID: 5
Name: Lagoon/Decant
Domains:
• WADIA:
  Inherited
• WAMATL:
  Inherited
• PRESSZONE:
  Inherited
• SERVICE_STATUS:
  Inherited
• CONDITIONCODE:
  Inherited
• LOCATIONCONFIDENCELEVEL:
  Inherited
• CATHODICPROTECTIONIND:
  Inherited
• OWNER:
  Inherited
• BEDDING_TYPE:
  Inherited
• WRAPPED:
  Inherited
• LINED:
  Inherited
• FIREFLOWPROBLEM:
  Inherited
Templates:
• Name: Lagoon/Decant
  Description:
  Prototype:
  FROMVALVE: null
  ASSETID: null
  ADDRESS: null
  SUBTYPECD: 5
  WADIA: null
  WAMATL: null
  PRESSZONE: null
  SERVICE_STATUS: null
  FIELDMEASUREDLENGTH: null
  INSTALLATIONDATE: null
  CONDITIONCODE: null
  LOCATIONDESCRIPTION: null
  LOCATIONCONFIDENCELEVEL: null
  CATHODICPROTECTIONIND: null
  BURIEDDEPTHINCHES: null
  OWNER: null
  OPERATINGPRESSURE: null
  DRAWINGID_REF: null
  DRAWIG_ID_REF_ID: null
  SUBDIVISION_DRAWINGS: null
  COMMENTS: null
  FACILITYID: null
  LOCATION: null
  BEDDING_TYPE: null
  WRAPPED: null
  LINED: null
  REHABDATE: null
  FIREFLOWPROBLEM: null
  BREAKCOUNT: null
  PIPECLASSCONDITION: null
  BREAKRATECONDITION: null
  CRITICALITYREASON: null
  RISK: null
  PIPECLASS: null
  CRITICALITY: null
  REPLACEMENTYEAR: null
  WM_FAC: null
  CONTRACTNUMBER: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: Potable
Domains:
• WADIA:
  Inherited
• WAMATL:
  Inherited
• PRESSZONE:
  Inherited
• SERVICE_STATUS:
  Inherited
• CONDITIONCODE:
  Inherited
• LOCATIONCONFIDENCELEVEL:
  Inherited
• CATHODICPROTECTIONIND:
  Inherited
• OWNER:
  Inherited
• BEDDING_TYPE:
  Inherited
• WRAPPED:
  Inherited
• LINED:
  Inherited
• FIREFLOWPROBLEM:
  Inherited
Templates:
• Name: Potable
  Description:
  Prototype:
  FROMVALVE: null
  ASSETID: null
  ADDRESS: null
  SUBTYPECD: 1
  WADIA: null
  WAMATL: null
  PRESSZONE: null
  SERVICE_STATUS: null
  FIELDMEASUREDLENGTH: null
  INSTALLATIONDATE: null
  CONDITIONCODE: null
  LOCATIONDESCRIPTION: null
  LOCATIONCONFIDENCELEVEL: null
  CATHODICPROTECTIONIND: null
  BURIEDDEPTHINCHES: null
  OWNER: null
  OPERATINGPRESSURE: null
  DRAWINGID_REF: null
  DRAWIG_ID_REF_ID: null
  SUBDIVISION_DRAWINGS: null
  COMMENTS: null
  FACILITYID: null
  LOCATION: null
  BEDDING_TYPE: null
  WRAPPED: null
  LINED: null
  REHABDATE: null
  FIREFLOWPROBLEM: null
  BREAKCOUNT: null
  PIPECLASSCONDITION: null
  BREAKRATECONDITION: null
  CRITICALITYREASON: null
  RISK: null
  PIPECLASS: null
  CRITICALITY: null
  REPLACEMENTYEAR: null
  WM_FAC: null
  CONTRACTNUMBER: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Raw
Domains:
• WADIA:
  Inherited
• WAMATL:
  Inherited
• PRESSZONE:
  Inherited
• SERVICE_STATUS:
  Inherited
• CONDITIONCODE:
  Inherited
• LOCATIONCONFIDENCELEVEL:
  Inherited
• CATHODICPROTECTIONIND:
  Inherited
• OWNER:
  Inherited
• BEDDING_TYPE:
  Inherited
• WRAPPED:
  Inherited
• LINED:
  Inherited
• FIREFLOWPROBLEM:
  Inherited
Templates:
• Name: Raw
  Description:
  Prototype:
  FROMVALVE: null
  ASSETID: null
  ADDRESS: null
  SUBTYPECD: 2
  WADIA: null
  WAMATL: null
  PRESSZONE: null
  SERVICE_STATUS: null
  FIELDMEASUREDLENGTH: null
  INSTALLATIONDATE: null
  CONDITIONCODE: null
  LOCATIONDESCRIPTION: null
  LOCATIONCONFIDENCELEVEL: null
  CATHODICPROTECTIONIND: null
  BURIEDDEPTHINCHES: null
  OWNER: null
  OPERATINGPRESSURE: null
  DRAWINGID_REF: null
  DRAWIG_ID_REF_ID: null
  SUBDIVISION_DRAWINGS: null
  COMMENTS: null
  FACILITYID: null
  LOCATION: null
  BEDDING_TYPE: null
  WRAPPED: null
  LINED: null
  REHABDATE: null
  FIREFLOWPROBLEM: null
  BREAKCOUNT: null
  PIPECLASSCONDITION: null
  BREAKRATECONDITION: null
  CRITICALITYREASON: null
  RISK: null
  PIPECLASS: null
  CRITICALITY: null
  REPLACEMENTYEAR: null
  WM_FAC: null
  CONTRACTNUMBER: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: Sludge
Domains:
• WADIA:
  Inherited
• WAMATL:
  Inherited
• PRESSZONE:
  Inherited
• SERVICE_STATUS:
  Inherited
• CONDITIONCODE:
  Inherited
• LOCATIONCONFIDENCELEVEL:
  Inherited
• CATHODICPROTECTIONIND:
  Inherited
• OWNER:
  Inherited
• BEDDING_TYPE:
  Inherited
• WRAPPED:
  Inherited
• LINED:
  Inherited
• FIREFLOWPROBLEM:
  Inherited
Templates:
• Name: Sludge
  Description:
  Prototype:
  FROMVALVE: null
  ASSETID: null
  ADDRESS: null
  SUBTYPECD: 3
  WADIA: null
  WAMATL: null
  PRESSZONE: null
  SERVICE_STATUS: null
  FIELDMEASUREDLENGTH: null
  INSTALLATIONDATE: null
  CONDITIONCODE: null
  LOCATIONDESCRIPTION: null
  LOCATIONCONFIDENCELEVEL: null
  CATHODICPROTECTIONIND: null
  BURIEDDEPTHINCHES: null
  OWNER: null
  OPERATINGPRESSURE: null
  DRAWINGID_REF: null
  DRAWIG_ID_REF_ID: null
  SUBDIVISION_DRAWINGS: null
  COMMENTS: null
  FACILITYID: null
  LOCATION: null
  BEDDING_TYPE: null
  WRAPPED: null
  LINED: null
  REHABDATE: null
  FIREFLOWPROBLEM: null
  BREAKCOUNT: null
  PIPECLASSCONDITION: null
  BREAKRATECONDITION: null
  CRITICALITYREASON: null
  RISK: null
  PIPECLASS: null
  CRITICALITY: null
  REPLACEMENTYEAR: null
  WM_FAC: null
  CONTRACTNUMBER: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: Transmission
Domains:
• WADIA:
  Inherited
• WAMATL:
  Inherited
• PRESSZONE:
  Inherited
• SERVICE_STATUS:
  Inherited
• CONDITIONCODE:
  Inherited
• LOCATIONCONFIDENCELEVEL:
  Inherited
• CATHODICPROTECTIONIND:
  Inherited
• OWNER:
  Inherited
• BEDDING_TYPE:
  Inherited
• WRAPPED:
  Inherited
• LINED:
  Inherited
• FIREFLOWPROBLEM:
  Inherited
Templates:
• Name: Transmission
  Description:
  Prototype:
  FROMVALVE: null
  ASSETID: null
  ADDRESS: null
  SUBTYPECD: 4
  WADIA: null
  WAMATL: null
  PRESSZONE: null
  SERVICE_STATUS: null
  FIELDMEASUREDLENGTH: null
  INSTALLATIONDATE: null
  CONDITIONCODE: null
  LOCATIONDESCRIPTION: null
  LOCATIONCONFIDENCELEVEL: null
  CATHODICPROTECTIONIND: null
  BURIEDDEPTHINCHES: null
  OWNER: null
  OPERATINGPRESSURE: null
  DRAWINGID_REF: null
  DRAWIG_ID_REF_ID: null
  SUBDIVISION_DRAWINGS: null
  COMMENTS: null
  FACILITYID: null
  LOCATION: null
  BEDDING_TYPE: null
  WRAPPED: null
  LINED: null
  REHABDATE: null
  FIREFLOWPROBLEM: null
  BREAKCOUNT: null
  PIPECLASSCONDITION: null
  BREAKRATECONDITION: null
  CRITICALITYREASON: null
  RISK: null
  PIPECLASS: null
  CRITICALITY: null
  REPLACEMENTYEAR: null
  WM_FAC: null
  CONTRACTNUMBER: null
  
  Drawing Tool: esriFeatureEditToolLine

---