Name: Water Meter

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Water meters in the O'Fallon, Illinois water system.

Copyright Text: O'Fallon, Illinois Public Works

Min. Scale: 2048

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2331051.24796583
YMin: 681646.741117157
XMax: 2389797.99103641
YMax: 723911.646088488
Spatial Reference: 102672 (3436)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"547c579ee0d1b952b972c62cb63ef138","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAASpJREFUKJGd0DFLA0EQhuF3wsmCISA5C0EEQRERFYVUIohg4V8JFkGwTGNlZaGlja1WAYtgo1hIRElhFGKjjVhvYfBwMdmxSOBivBBxmoVhn51vNuCfFQBkC5r7K7DD1NmTKACwUDLo6SDkkLVsRN5CNej0XpzKA+g+QiMJGSUyoucgcVQAIzrj4IIv2TIBsw5q7T45B09O9Mb07thVTQKGNkJKZ0U9brYYX9+VzUqDyc6gvhCA6RB7+yjzLc/YXMhrJSF8IpwIuSxXWRjN8InqM73j+sGdO+p4qqRwxrOcdOc3TPOe/eDaHso9ANv6RmsglBUiPbICFDwAzisIeZRMd+IYpuTKeE1K1X4AKYMu9sIl5ykmfUIchlWHTKXhJIYHMtJf/CzbOb8BwtxeEr346pEAAAAASUVORK5CYII=","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"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:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: LifeCycleStatus, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PRP: Proposed], [ACT: Active], [ABN: Abandoned], ... 5 more ...)
• SUBTYPE (type: esriFieldTypeInteger, alias: SUBTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADMINISTRATIVEAREA (type: esriFieldTypeString, alias: Administrative Area, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [OFAL: City of O'Fallon], [MADI: Madison County], [SHIL: Village of Shiloh], ... 5 more ...)
• OPERATIONALAREA (type: esriFieldTypeString, alias: Operational Area, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [UNK: Unknown], [O'Fallon: O'Fallon, IL], [Fairview Heights: Fairview Heights, IL], ... 6 more ...)
• MANUFACTURER (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 3/4 Inch], [1: 1 Inch], [99: 1 1/2 Inch], ... 21 more ...)
• MODEL (type: esriFieldTypeString, alias: Meter Register Info, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SERIALNUMBER (type: esriFieldTypeString, alias: Serial Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• WATERACCOUNT (type: esriFieldTypeString, alias: WaterAccount, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• METERNUMBER (type: esriFieldTypeString, alias: Water Meter Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ERT_NUMBER (type: esriFieldTypeDouble, alias: ERT ID Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMPOUND (type: esriFieldTypeInteger, alias: Compound, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• APARTMENT (type: esriFieldTypeString, alias: Apartment, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Y: True], [N: False])
• COMMERCIAL (type: esriFieldTypeString, alias: Commercial, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Y: True], [N: False])
• IRRIGATION (type: esriFieldTypeString, alias: Irrigation Meter, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [UNK: Unknown], ... 1 more ...)
• MAINTISSUE (type: esriFieldTypeString, alias: Maintenance Issue, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Y: True], [N: False])
• PARCELID (type: esriFieldTypeString, alias: PARCEL ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PARCELMATCHDATE (type: esriFieldTypeDate, alias: Parcel Match Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PARCELMATCHMETHOD (type: esriFieldTypeString, alias: Parcel Match Method, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ZIPCODE (type: esriFieldTypeString, alias: ZIP code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ZIP4CODE (type: esriFieldTypeString, alias: ZIP plus 4 code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• INSTALLDATE (type: esriFieldTypeDate, alias: INSTALL DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_STATIONID (type: esriFieldTypeSmallInteger, alias: GNSS Station ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_RECEIVER (type: esriFieldTypeString, alias: GNSS Receiver Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ESRIGNSS_FIXTYPE (type: esriFieldTypeSmallInteger, alias: GNSS Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_LONGITUDE (type: esriFieldTypeDouble, alias: GNSS Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_LATITUDE (type: esriFieldTypeDouble, alias: GNSS Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_ALTITUDE (type: esriFieldTypeDouble, alias: GNSS Altitude (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_NUMSATS (type: esriFieldTypeSmallInteger, alias: GNSS Number of Satellites, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_FIXDATETIME (type: esriFieldTypeDate, alias: GNSS Fix Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ESRIGNSS_CORRECTIONAGE (type: esriFieldTypeDouble, alias: GNSS Correction Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_PDOP (type: esriFieldTypeDouble, alias: GNSS PDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_HDOP (type: esriFieldTypeDouble, alias: GNSS HDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_VDOP (type: esriFieldTypeDouble, alias: GNSS VDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_H_RMS (type: esriFieldTypeDouble, alias: GNSS Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_V_RMS (type: esriFieldTypeDouble, alias: GNSS Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_AVG_POSITIONS (type: esriFieldTypeInteger, alias: GNSS Number of Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CREATE_BY (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• CREATE_DATE (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• EDIT_BY (type: esriFieldTypeString, alias: Edited By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• EDIT_DATE (type: esriFieldTypeDate, alias: Last Updated Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• FLAG_FOLLOWUP (type: esriFieldTypeDate, alias: Flag for Followup, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Water Meter
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• LIFECYCLESTATUS: ACT
• SUBTYPE: 0
• FACILITYID: WM_
• ADMINISTRATIVEAREA: OFAL
• IRRIGATION: NO
• ENABLED: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/16/2026 11:36:50 PM

Schema Last Edit Date: 6/16/2026 11:36:50 PM

Data Last Edit Date: 6/16/2026 11:36:50 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat