Name: Water - Service Valve

Display Field: DATACAPTUREMETHOD

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 6000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 598336.852300754
YMin: 4802546.84343192
XMax: 611116.813700851
YMax: 4819622.43985676
Spatial Reference: 26917 (26917)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SUBTYPE","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[135,0,168,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[148,54,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"1","label":"CurbStop"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[128,0,21,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"3","label":"PropertyLine"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[51,0,145,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"2","label":"Secondary"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[138,32,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"4","label":"TappingValve"}],"fieldDelimiter":","},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GLOBALID

Type ID Field: SUBTYPE

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• RMOHID (type: esriFieldTypeInteger, alias: RMOHID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• DATACAPTUREMETHOD (type: esriFieldTypeString, alias: DATACAPTUREMETHOD, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• ADMINISTRATIVEAREA (type: esriFieldTypeString, alias: AdministrativeArea, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [HALTON: Regional Municipality of Halton], [BURLINGTON: City of Burlington], [HAMILTON: City of Hamilton], ... 7 more ...)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: LifecycleStatus, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [INSRV: In Service], [OUTSRV: Out Of Service], [PROP: Proposed], ... 1 more ...)
• LOCATIONDESCRIPTION (type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• PROJECTNUMBER (type: esriFieldTypeString, alias: PROJECTNUMBER, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• OPERATIONALAREA (type: esriFieldTypeString, alias: OPERATIONALAREA, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [OAKVILLE: Town of Oakville], [MILTON: Town of Milton], [HALTON HILLS: Town of Halton Hills], ... 4 more ...)
• ROTATION (type: esriFieldTypeDouble, alias: ROTATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DIAMETER (type: esriFieldTypeSmallInteger, alias: DIAMETER, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [12: 12], [15: 15], [19: 19], ... 23 more ...)
• MODELNO (type: esriFieldTypeString, alias: MODELNO, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• DEMAND (type: esriFieldTypeDouble, alias: DEMAND, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GROUNDELEVATION (type: esriFieldTypeDouble, alias: GROUNDELEVATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SUBTYPE (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BYPASSVALVE (type: esriFieldTypeString, alias: ByPassValve, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
• DEPTHTONUT (type: esriFieldTypeDouble, alias: DEPTHTONUT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NORMALLYOPEN (type: esriFieldTypeString, alias: NormallyOpen, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
• OPENS (type: esriFieldTypeString, alias: Opens, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [CW: Clockwise], [CCW: Counterclockwise], [UNKN: Unknown])
• STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [CLOS: Closed], [OPEN: Open], [UNKN: Unknown])
• TURNSNUMBER (type: esriFieldTypeSmallInteger, alias: TURNSNUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VALVETYPE (type: esriFieldTypeString, alias: VALVETYPE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [BAV: Ball], [BTV: Butterfly], [GTV: Gate], ... 1 more ...)
• CHAMBERID (type: esriFieldTypeInteger, alias: CHAMBERID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VALVEBOXTYPE (type: esriFieldTypeString, alias: ValveBoxType, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• MAINTENANCERESPONSIBILITY (type: esriFieldTypeString, alias: MAINTENANCERESPONSIBILITY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LOOPEDSERVICE (type: esriFieldTypeString, alias: LOOPEDSERVICE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [UNKN: Unknown])
• GPS_XCOORD (type: esriFieldTypeDouble, alias: GPS_XCOORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS_YCOORD (type: esriFieldTypeDouble, alias: GPS_YCOORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS_ZCOORD (type: esriFieldTypeDouble, alias: GPS_ZCOORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONSTRUCTIONSTARTDATE (type: esriFieldTypeDate, alias: CONSTRUCTIONSTARTDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DEVELOPMENTNUMBER (type: esriFieldTypeString, alias: DEVELOPMENTNUMBER, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• CONTRACTNUMBER (type: esriFieldTypeString, alias: CONTRACTNUMBER, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• SLKEY (type: esriFieldTypeInteger, alias: SLKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINKEY (type: esriFieldTypeInteger, alias: MAINKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADDRKEY (type: esriFieldTypeInteger, alias: ADDRKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAPNO (type: esriFieldTypeString, alias: MAPNO, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• UNITTYPE (type: esriFieldTypeString, alias: UNITTYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• URL (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Types:

ID: 1
Name: CurbStop
Domains:

• Field Name: ADMINISTRATIVEAREA
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: OPERATIONALAREA
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: BYPASSVALVE
  Inherited
  
• Field Name: NORMALLYOPEN
  Inherited
  
• Field Name: OPENS
  Inherited
  
• Field Name: STATUS
  Inherited
  
• Field Name: VALVETYPE
  Inherited
  
• Field Name: VALVEBOXTYPE
  Coded Values:[CBOX: Curb Box], [VBOX: Valve Box]
  
• Field Name: LOOPEDSERVICE
  Inherited
  
Templates:

Name: CurbStop
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• LIFECYCLESTATUS: INSRV
• STATUS: OPEN
• ADMINISTRATIVEAREA: HALTON
• SUBTYPE: 1
• BYPASSVALVE: NO
• NORMALLYOPEN: YES
• OPENS: CCW
• VALVEBOXTYPE: VBOX

---

ID: 3
Name: PropertyLine
Domains:

• Field Name: ADMINISTRATIVEAREA
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: OPERATIONALAREA
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: BYPASSVALVE
  Inherited
  
• Field Name: NORMALLYOPEN
  Inherited
  
• Field Name: OPENS
  Inherited
  
• Field Name: STATUS
  Inherited
  
• Field Name: VALVETYPE
  Inherited
  
• Field Name: VALVEBOXTYPE
  Coded Values:[CBOX: Curb Box], [VBOX: Valve Box]
  
• Field Name: LOOPEDSERVICE
  Inherited
  
Templates:

Name: PropertyLine
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• LIFECYCLESTATUS: INSRV
• STATUS: OPEN
• ADMINISTRATIVEAREA: HALTON
• SUBTYPE: 3
• BYPASSVALVE: NO
• NORMALLYOPEN: YES
• OPENS: CCW
• VALVEBOXTYPE: VBOX

---

ID: 2
Name: Secondary
Domains:

• Field Name: ADMINISTRATIVEAREA
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: OPERATIONALAREA
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: BYPASSVALVE
  Inherited
  
• Field Name: NORMALLYOPEN
  Inherited
  
• Field Name: OPENS
  Inherited
  
• Field Name: STATUS
  Inherited
  
• Field Name: VALVETYPE
  Inherited
  
• Field Name: VALVEBOXTYPE
  Coded Values:[CBOX: Curb Box], [VBOX: Valve Box]
  
• Field Name: LOOPEDSERVICE
  Inherited
  
Templates:

Name: Secondary
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• LIFECYCLESTATUS: INSRV
• STATUS: OPEN
• ADMINISTRATIVEAREA: HALTON
• SUBTYPE: 2
• BYPASSVALVE: NO
• NORMALLYOPEN: YES
• OPENS: CCW
• VALVEBOXTYPE: VBOX

---

ID: 4
Name: TappingValve
Domains:

• Field Name: ADMINISTRATIVEAREA
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: OPERATIONALAREA
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: BYPASSVALVE
  Inherited
  
• Field Name: NORMALLYOPEN
  Inherited
  
• Field Name: OPENS
  Inherited
  
• Field Name: STATUS
  Inherited
  
• Field Name: VALVETYPE
  Inherited
  
• Field Name: VALVEBOXTYPE
  Coded Values:[CBOX: Curb Box], [VBOX: Valve Box]
  
• Field Name: LOOPEDSERVICE
  Inherited
  
Templates:

Name: TappingValve
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• LIFECYCLESTATUS: INSRV
• STATUS: OPEN
• ADMINISTRATIVEAREA: HALTON
• SUBTYPE: 4
• BYPASSVALVE: NO
• NORMALLYOPEN: YES
• OPENS: CCW
• VALVEBOXTYPE: VBOX

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/8/2023 5:12:39 PM

Schema Last Edit Date: 12/8/2023 5:12:39 PM

Data Last Edit Date: 12/8/2023 5:12:39 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat