Name: Water - Customer Meter

Display Field: METERNAME

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: 598385.799100755
YMin: 4802583.42788192
XMax: 611134.223800851
YMax: 4819522.17758176
Spatial Reference: 26917 (26917)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SUBTYPE","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[117,0,176,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":[119,0,145,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"4","label":"Bulk"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[29,158,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"2","label":"ICI"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[44,0,176,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"3","label":"Multi-DwellingUnit"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[157,168,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"1","label":"Residential"}],"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 ...)
• CONSTRUCTIONSTARTDATE (type: esriFieldTypeDate, alias: CONSTRUCTIONSTARTDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• 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)
• COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 255, 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)
• METERNAME (type: esriFieldTypeString, alias: METERNAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ACCOUNTNO (type: esriFieldTypeString, alias: ACCOUNTNO, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• REMOTEREADER (type: esriFieldTypeString, alias: REMOTEREADER, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [UNKN: Unknown])
• SERIALNUMBER (type: esriFieldTypeString, alias: SERIALNUMBER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UNITOFMEASURE (type: esriFieldTypeString, alias: UNITOFMEASURE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [M3: Cubic Metre], [GAL: Gallon (Imperial)], [LTR: Litre])
• SERVICETYPE (type: esriFieldTypeString, alias: SERVICETYPE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [RES: Residential], [ICI: Industrial, Commercial & Institutional], [MDU: Multi-Dwelling Unit], ... 2 more ...)
• SERVICESIZE (type: esriFieldTypeSmallInteger, alias: SERVICESIZE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOCATIONOFMETER (type: esriFieldTypeString, alias: LOCATIONOFMETER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LOCATIONOFREMOTEMETER (type: esriFieldTypeString, alias: LOCATIONOFREMOTEMETER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BYPASS (type: esriFieldTypeString, alias: BYPASS, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
• STRAINER (type: esriFieldTypeString, alias: STRAINER, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
• FIRERATEDSTRAINER (type: esriFieldTypeString, alias: FIRERATEDSTRAINER, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
• FLANGETOFLANGEDISTANCE (type: esriFieldTypeInteger, alias: FLANGETOFLANGEDISTANCE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BACKFLOWPREVENTIONDEVICE (type: esriFieldTypeString, alias: BACKFLOWPREVENTIONDEVICE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
• CONFINEDSPACETYPE (type: esriFieldTypeString, alias: CONFINEDSPACETYPE, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [PIT: Pit], [VAULT: Vault], [CHAMBER: Chamber], ... 1 more ...)
• SANITARYSEWERCONNECTION (type: esriFieldTypeString, alias: SANITARYSEWERCONNECTION, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
• PAYMENTMETHOD (type: esriFieldTypeString, alias: PAYMENTMETHOD, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [BILLED: Billed], [CARD: Card], [COIN: Coin])
• ROLLNUM (type: esriFieldTypeString, alias: ROLLNUM, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• ROLLNUMSUB (type: esriFieldTypeString, alias: ROLLNUMSUB, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• MAINTENANCERESPONSIBILITY (type: esriFieldTypeString, alias: MAINTENANCERESPONSIBILITY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• STREETNUMBER (type: esriFieldTypeString, alias: STREETNUMBER, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• STREETNAME (type: esriFieldTypeString, alias: STREETNAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STREETTYPE (type: esriFieldTypeString, alias: STREETTYPE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• STREETSUFFIX (type: esriFieldTypeString, alias: STREETSUFFIX, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MUNICIPALITY (type: esriFieldTypeString, alias: MUNICIPALITY, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• COMMUNITY (type: esriFieldTypeString, alias: COMMUNITY, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• UNIT (type: esriFieldTypeString, alias: UNIT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SEASONAL (type: esriFieldTypeString, alias: SEASONAL, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
• LOTNUMBER (type: esriFieldTypeString, alias: LOTNUMBER, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• TENANTOWNER (type: esriFieldTypeString, alias: TENANTOWNER, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• NUMBEROFDIALS (type: esriFieldTypeInteger, alias: NUMBEROFDIALS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• METERMAKE (type: esriFieldTypeString, alias: METERMAKE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DEVELOPMENTNUMBER (type: esriFieldTypeString, alias: DEVELOPMENTNUMBER, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• ADDRESS_ID (type: esriFieldTypeDouble, alias: ADDRESS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POINT_ID (type: esriFieldTypeDouble, alias: POINT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADDRESSCOMPKEY (type: esriFieldTypeInteger, alias: ADDRESSCOMPKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• METERSIZE (type: esriFieldTypeDouble, alias: METERSIZE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [15: 15], [20: 20], [25: 25], ... 10 more ...)
• CONTRACTNUMBER (type: esriFieldTypeString, alias: CONTRACTNUMBER, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• NUMBEROFUNITSSERVED (type: esriFieldTypeDouble, alias: NUMBEROFUNITSSERVED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• METERNUMBEROFDIALS (type: esriFieldTypeDouble, alias: METERNUMBEROFDIALS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLKEY (type: esriFieldTypeInteger, alias: SLKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNITORIGINAL (type: esriFieldTypeString, alias: UNITORIGINAL, SQL Type: sqlTypeOther, length: 8, 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: 4
Name: Bulk
Domains:

• Field Name: ADMINISTRATIVEAREA
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: OPERATIONALAREA
  Inherited
  
• Field Name: REMOTEREADER
  Inherited
  
• Field Name: UNITOFMEASURE
  Inherited
  
• Field Name: SERVICETYPE
  Inherited
  
• Field Name: BYPASS
  Inherited
  
• Field Name: STRAINER
  Inherited
  
• Field Name: FIRERATEDSTRAINER
  Inherited
  
• Field Name: BACKFLOWPREVENTIONDEVICE
  Inherited
  
• Field Name: CONFINEDSPACETYPE
  Inherited
  
• Field Name: SANITARYSEWERCONNECTION
  Inherited
  
• Field Name: PAYMENTMETHOD
  Inherited
  
• Field Name: SEASONAL
  Inherited
  
• Field Name: METERSIZE
  Inherited
  
Templates:

Name: Bulk
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• LIFECYCLESTATUS: INSRV
• ADMINISTRATIVEAREA: HALTON
• SUBTYPE: 4

---

ID: 2
Name: ICI
Domains:

• Field Name: ADMINISTRATIVEAREA
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: OPERATIONALAREA
  Inherited
  
• Field Name: REMOTEREADER
  Inherited
  
• Field Name: UNITOFMEASURE
  Inherited
  
• Field Name: SERVICETYPE
  Inherited
  
• Field Name: BYPASS
  Inherited
  
• Field Name: STRAINER
  Inherited
  
• Field Name: FIRERATEDSTRAINER
  Inherited
  
• Field Name: BACKFLOWPREVENTIONDEVICE
  Inherited
  
• Field Name: CONFINEDSPACETYPE
  Inherited
  
• Field Name: SANITARYSEWERCONNECTION
  Inherited
  
• Field Name: PAYMENTMETHOD
  Inherited
  
• Field Name: SEASONAL
  Inherited
  
• Field Name: METERSIZE
  Inherited
  
Templates:

Name: ICI
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

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

---

ID: 3
Name: Multi-DwellingUnit
Domains:

• Field Name: ADMINISTRATIVEAREA
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: OPERATIONALAREA
  Inherited
  
• Field Name: REMOTEREADER
  Inherited
  
• Field Name: UNITOFMEASURE
  Inherited
  
• Field Name: SERVICETYPE
  Inherited
  
• Field Name: BYPASS
  Inherited
  
• Field Name: STRAINER
  Inherited
  
• Field Name: FIRERATEDSTRAINER
  Inherited
  
• Field Name: BACKFLOWPREVENTIONDEVICE
  Inherited
  
• Field Name: CONFINEDSPACETYPE
  Inherited
  
• Field Name: SANITARYSEWERCONNECTION
  Inherited
  
• Field Name: PAYMENTMETHOD
  Inherited
  
• Field Name: SEASONAL
  Inherited
  
• Field Name: METERSIZE
  Inherited
  
Templates:

Name: Multi-DwellingUnit
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• LIFECYCLESTATUS: INSRV
• ADMINISTRATIVEAREA: HALTON
• SUBTYPE: 3

---

ID: 1
Name: Residential
Domains:

• Field Name: ADMINISTRATIVEAREA
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: OPERATIONALAREA
  Inherited
  
• Field Name: REMOTEREADER
  Inherited
  
• Field Name: UNITOFMEASURE
  Inherited
  
• Field Name: SERVICETYPE
  Inherited
  
• Field Name: BYPASS
  Inherited
  
• Field Name: STRAINER
  Inherited
  
• Field Name: FIRERATEDSTRAINER
  Inherited
  
• Field Name: BACKFLOWPREVENTIONDEVICE
  Inherited
  
• Field Name: CONFINEDSPACETYPE
  Inherited
  
• Field Name: SANITARYSEWERCONNECTION
  Inherited
  
• Field Name: PAYMENTMETHOD
  Inherited
  
• Field Name: SEASONAL
  Inherited
  
• Field Name: METERSIZE
  Inherited
  
Templates:

Name: Residential
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

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

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

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

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

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

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