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.47757974
YMin: 635150.530013397
XMax: 1967435.12809134
YMax: 690296.721229985
Spatial Reference: 102749 (2286)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[255,255,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.Billed_Consumption","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":0,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[230,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Tahoma","size":14,"style":"normal","weight":"normal","decoration":"none"}}}]}

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)
• facilityid (type: esriFieldTypeSmallInteger, alias: Facility ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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)
• svcsize (type: esriFieldTypeSmallInteger, alias: Service Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 3/4"], [2: 1"], [3: 1 1/2"], ... 7 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], ... 1 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], [Compound: Compound], ... 3 more ...)
• msize (type: esriFieldTypeSmallInteger, alias: Meter Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 3/4"], [2: 1"], [3: 1 1/2"], ... 7 more ...)
• regtype (type: esriFieldTypeString, alias: Register Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ADE: ADE], [HR: HR], [HR E LCD: HR E LCD])
• regmodel (type: esriFieldTypeString, alias: Register Model, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [T-200: T-200], [II Turbo: II Turbo], [CS4000: CS400], ... 10 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"], ... 7 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 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"], ... 7 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: reglow, 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: [1: True], [0: False])
• 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)
• 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"], ... 7 more ...)
• 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])
• propnum (type: esriFieldTypeString, alias: Property Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)

Templates:

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

Attributes:

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

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/13/2023 9:06:25 PM

Schema Last Edit Date: 4/13/2023 9:06:25 PM

Data Last Edit Date: 4/13/2023 9:06:25 PM

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