Name: Main Line Valves

Display Field: LEGACYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: b4e612f210de4cb2a63462bd626a6080

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 9029

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:
N/A
Default Label: null
UniqueValueInfos:
• Value: 1
  Label: Main
  Description:
  Symbol:
  
• Value: 2
  Label: Main
  Description:
  Symbol:
  
• Value: 3
  Label: Main
  Description:
  Symbol:
  
• Value: 4
  Label: Main
  Description:
  Symbol:
  
• Value: 5
  Label: Main
  Description:
  Symbol:
  
• Value: 6
  Label: Main
  Description:
  Symbol:
  
• Value: 10
  Label: Main
  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 to Close, 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

---

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata