Name: Water - Service Lead

Display Field: DATACAPTUREMETHOD

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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.086700755
YMin: 4802543.49988192
XMax: 611116.813700852
YMax: 4819622.43983176
Spatial Reference: 26917 (26917)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SUBTYPE","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[143,148,0,255],"width":1},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[128,8,0,255],"width":1},"value":"2","label":"Hydrant"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,93,130,255],"width":1},"value":"1","label":"Service"}],"fieldDelimiter":","},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: true

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 ...)
• 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 ...)
• PROJECTNUMBER (type: esriFieldTypeString, alias: PROJECTNUMBER, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• SUBTYPE (type: esriFieldTypeInteger, alias: SUBTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CLASSSERIES (type: esriFieldTypeString, alias: CLASSSERIES, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [DR14: Class 200 DR-14], [DR18: Class 150 DR-18], [CL52: Class 52], ... 3 more ...)
• COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BLEEDER (type: esriFieldTypeString, alias: Bleeder, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [UNKN: Unknown])
• DEPTHTOBURY (type: esriFieldTypeDouble, alias: DEPTHTOBURY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: MATERIAL, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [AC: AsbestosCement], [CI: Cast Iron], [CCDI: Concrete Coated Ductile Iron], ... 14 more ...)
• PIPEDIAMETER (type: esriFieldTypeSmallInteger, alias: PIPEDIAMETER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WORKINGTRACINGWIRE (type: esriFieldTypeString, alias: WORKINGTRACINGWIRE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [UNKN: Unknown])
• SERVICETYPE (type: esriFieldTypeString, alias: SERVICETYPE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [RES: Residential], [ICI: Industrial, Commercial & Institutional], [MDU: Multi-Dwelling Unit], ... 2 more ...)
• MAINTENANCERESPONSIBILITY (type: esriFieldTypeString, alias: MAINTENANCERESPONSIBILITY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• MEASUREDLENGTH (type: esriFieldTypeDouble, alias: MEASUREDLENGTH, 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)
• REHABILITATIONDATE (type: esriFieldTypeDate, alias: REHABILITATIONDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ADDRKEY (type: esriFieldTypeInteger, alias: ADDRKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINKEY (type: esriFieldTypeInteger, alias: MAINKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VALVEKEY (type: esriFieldTypeInteger, alias: VALVEKEY, 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)
• 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)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: 2
Name: Hydrant
Domains:

• Field Name: ADMINISTRATIVEAREA
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: OPERATIONALAREA
  Inherited
  
• Field Name: CLASSSERIES
  Inherited
  
• Field Name: BLEEDER
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: WORKINGTRACINGWIRE
  Inherited
  
• Field Name: SERVICETYPE
  Inherited
  
Templates:

Name: Hydrant
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• LIFECYCLESTATUS: INSRV
• SUBTYPE: 2
• ADMINISTRATIVEAREA: HALTON
• BLEEDER: NO

---

ID: 1
Name: Service
Domains:

• Field Name: ADMINISTRATIVEAREA
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: OPERATIONALAREA
  Inherited
  
• Field Name: CLASSSERIES
  Inherited
  
• Field Name: BLEEDER
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: WORKINGTRACINGWIRE
  Inherited
  
• Field Name: SERVICETYPE
  Inherited
  
Templates:

Name: Service
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• LIFECYCLESTATUS: INSRV
• SUBTYPE: 1
• ADMINISTRATIVEAREA: HALTON
• BLEEDER: NO

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/8/2023 5:13:08 PM

Schema Last Edit Date: 12/8/2023 5:13:08 PM

Data Last Edit Date: 12/8/2023 5:13:08 PM

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