Name: Water Service

Display Field: locname

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: 1923432.47757964
YMin: 635133.926043898
XMax: 1967435.12809122
YMax: 690296.721229896
Spatial Reference: 102749 (2286)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[150,60,97,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

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)
• meterno (type: esriFieldTypeString, alias: Meter Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• accountno (type: esriFieldTypeString, alias: Account Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• locaddress (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• locname (type: esriFieldTypeString, alias: Location Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• svctype (type: esriFieldTypeString, alias: Service Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Single Family Residential: Single Family Residential], [Duplex Residential: Duplex Residential], [Multifamily Residential: Multifamily Residential], ... 7 more ...)
• accttype (type: esriFieldTypeString, alias: Account Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [00: 00], [01: 01], [02: 02], ... 1 more ...)
• billcode (type: esriFieldTypeString, alias: Billing Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• msize (type: esriFieldTypeSmallInteger, alias: Meter Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 3/4"], [2: 1"], [3: 1 1/2"], ... 8 more ...)
• metersize (type: esriFieldTypeString, alias: metersize, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [3/4": 3/4"], [1": 1"], [1 1/2": 1 1/2"], ... 9 more ...)
• svcsize (type: esriFieldTypeSmallInteger, alias: Service Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 3/4"], [2: 1"], [3: 1 1/2"], ... 8 more ...)
• material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [PVC: PVC], [Ductile Iron/Cast Iron: Ductile Iron/Cast Iron], [Copper: Copper], ... 9 more ...)
• depth (type: esriFieldTypeString, alias: Depth, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• grndcover (type: esriFieldTypeString, alias: Groundcover, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Grass: Grass], [Dirt: Dirt], [Gravel: Gravel], ... 3 more ...)
• minstdate (type: esriFieldTypeDate, alias: Meter Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• make (type: esriFieldTypeString, alias: Make, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Badger: Badger], [Hersey: Hersey], [Hersey & Badger: Hersey & Badger], ... 3 more ...)
• model (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Disc: Disc], [Turbo: Turbo], [Other: Other], ... 2 more ...)
• regtype (type: esriFieldTypeString, alias: Register Type High, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ADE: ADE], [HR E LCD: HR E LCD], [HR: HR E])
• regmodel (type: esriFieldTypeString, alias: Register Model High, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [T-200: T-200], [II Turbo: II Turbo], [CS4000: CS400], ... 14 more ...)
• regsize (type: esriFieldTypeSmallInteger, alias: Register Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 3/4"], [2: 1"], [3: 1 1/2"], ... 8 more ...)
• regstazero (type: esriFieldTypeDouble, alias: Stationary Zeros, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2], ... 1 more ...)
• reg (type: esriFieldTypeInteger, alias: Registration, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 000000.00], [1: 0000000.0], [2: 00000000], ... 3 more ...)
• reglow (type: esriFieldTypeInteger, alias: Register Display Low, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 000000.00], [1: 0000000.0], [2: 00000000], ... 3 more ...)
• regbeg (type: esriFieldTypeDouble, alias: Register Beginning Read, SQL Type: sqlTypeOther, nullable: true, editable: true)
• regend (type: esriFieldTypeDouble, alias: Register End Read, SQL Type: sqlTypeOther, nullable: true, editable: true)
• erttypelow (type: esriFieldTypeString, alias: Low-ERT Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bypass: Bypass], [Recordall: Recordall], [Other: Other], ... 5 more ...)
• ertnumlow (type: esriFieldTypeDouble, alias: Low-ERT Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ertinstlow (type: esriFieldTypeDate, alias: Low-ERT Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• erttypehigh (type: esriFieldTypeString, alias: High-ERT Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bypass: Bypass], [Recordall: Recordall], [Other: Other], ... 5 more ...)
• ertnumhigh (type: esriFieldTypeDouble, alias: High-ERT Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ertinsthigh (type: esriFieldTypeDate, alias: High-ERT Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• erttypemain (type: esriFieldTypeString, alias: Main-ERT Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bypass: Bypass], [Recordall: Recordall], [Other: Other], ... 5 more ...)
• ertnummain (type: esriFieldTypeDouble, alias: Main-ERT Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ertinstmain (type: esriFieldTypeDate, alias: Main-ERT Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• irr (type: esriFieldTypeString, alias: Irrigation, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• bypass (type: esriFieldTypeSmallInteger, alias: Bypass Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 3/4"], [2: 1"], [3: 1 1/2"], ... 8 more ...)
• presszone (type: esriFieldTypeString, alias: Pressure Zone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CT: Central], [KV: Knolls Vista], [LV: Lakeview], ... 4 more ...)
• maintby (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Moses Lake: Moses Lake], [Grant County: Grant County], [Port of Moses Lake: Port of Moses Lake], ... 3 more ...)
• activeflag (type: esriFieldTypeString, alias: Turned On, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• attachid (type: esriFieldTypeSmallInteger, alias: Attachment ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: globalid, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• globalholder (type: esriFieldTypeGUID, alias: Global Holder, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• regdigitcount (type: esriFieldTypeString, alias: Register Digit Count, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [No Value: No Value], [6: 6], [7: 7], ... 1 more ...)
• reghigh (type: esriFieldTypeInteger, alias: Register Display High, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 000000.00], [1: 0000000.0], [2: 00000000], ... 3 more ...)
• regdigitcounthigh (type: esriFieldTypeString, alias: regdigitcountlow, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [No Value: No Value], [6: 6], [7: 7], ... 1 more ...)
• regbeghigh (type: esriFieldTypeDouble, alias: regbeghigh, SQL Type: sqlTypeOther, nullable: true, editable: true)
• aefacilityid (type: esriFieldTypeString, alias: AEFacilityID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• lastmaintdate (type: esriFieldTypeDate, alias: Last Maintenance Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• hasacct (type: esriFieldTypeString, alias: Has Account Num, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
• enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• ancillaryrole (type: esriFieldTypeSmallInteger, alias: ancillaryrole, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Source], [2: Sink])
• critical (type: esriFieldTypeSmallInteger, alias: Critical Customer, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• lastregread (type: esriFieldTypeString, alias: Last Register Read, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• lidtype (type: esriFieldTypeString, alias: Lid Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Cast Iron: Cast Iron], [Plastic: Plastic], [Stainless Steel: Stainless Steel])
• propnum (type: esriFieldTypeString, alias: Property Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Proposed: Proposed], [Active: Active], [Abandoned: Abandoned], ... 3 more ...)
• regmodlow (type: esriFieldTypeString, alias: Register Model Low, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [T-200: T-200], [II Turbo: II Turbo], [CS4000: CS400], ... 14 more ...)
• regtypelow (type: esriFieldTypeString, alias: Register Type Low, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ADE: ADE], [HR E LCD: HR E LCD], [HR: HR E])
• route (type: esriFieldTypeString, alias: Route, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• eru (type: esriFieldTypeDouble, alias: Number of ERUs, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

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

Attributes:

• svcsize: 2
• enabled: 0
• ancillaryrole: 0
• critical: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/10/2026 11:04:22 PM

Schema Last Edit Date: 7/10/2026 11:04:22 PM

Data Last Edit Date: 7/10/2026 11:04:22 PM

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