Layers:

Layer: PGISREF.DBO.WAT_ControlValve (0)


Name: PGISREF.DBO.WAT_ControlValve

Display Field: DATACAPTUREMETHOD

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 598356.621702783
YMin: 4802572.83058199
XMax: 611044.271432198
YMax: 4819349.98088328
Spatial Reference: 26917 (26917)


Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SUBTYPE","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"defaultLabel":"","uniqueValueGroups":[{"heading":"SUBTYPE","classes":[{"label":"System","description":"System","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,199,182,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["1"]]},{"label":"Zone","description":"Zone","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[192,182,252,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["2"]]},{"label":"SystemDP","description":"SystemDP","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[179,252,210,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["3"]]},{"label":"ZoneDP","description":"ZoneDP","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[194,236,252,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["4"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,199,182,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"1","label":"System"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[192,182,252,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"2","label":"Zone"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[179,252,210,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"3","label":"SystemDP"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[194,236,252,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"4","label":"ZoneDP"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,252,252,255],"toColor":[202,252,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,250,255],"toColor":[252,182,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,206,184,255],"toColor":[252,206,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[180,252,179,255],"toColor":[180,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,203,252,255],"toColor":[187,203,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,244,179,255],"toColor":[252,244,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,240,255],"toColor":[252,215,240,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[219,252,202,255],"toColor":[219,252,202,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,190,255],"toColor":[252,179,190,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[199,182,252,255],"toColor":[199,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,232,252,255],"toColor":[184,232,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,221,255],"toColor":[187,252,221,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,240,204,255],"toColor":[252,240,204,255]}]}}},"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, Coded Values: [VBOX: Valve Box], [BBOX: Buffalo Box], [NA: Not Applicable])
• MAINTENANCERESPONSIBILITY (type: esriFieldTypeString, alias: Maintenanceresponsibility, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• 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)
• MAPTILES2000NUM (type: esriFieldTypeString, alias: Maptiles2000num, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• SLKEY (type: esriFieldTypeInteger, alias: Slkey, SQL Type: sqlTypeOther, 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)

Types:

ID: 1
Name: System
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
  Inherited
  
Templates:

Name: System
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

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

---

ID: 2
Name: Zone
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
  Inherited
  
Templates:

Name: Zone
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

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

---

ID: 3
Name: SystemDP
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
  Inherited
  
Templates:

Name: SystemDP
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

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

---

ID: 4
Name: ZoneDP
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
  Inherited
  
Templates:

Name: ZoneDP
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

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

---


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/19/2024 7:40:32 PM

Schema Last Edit Date: 12/19/2024 7:40:32 PM

Data Last Edit Date: 12/19/2024 7:40:32 PM