Name: WaterMeters_OLD

Display Field: ServiceAddressStreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Water meters are updated from various sources including utility billing software, laserfiche change out report, and meter software. Water meters are updated manually by Public Works GIS. Last update: 2022-08-01

Copyright Text: Grapevine Public Works GIS

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: -10812297.1806598
YMin: 3879434.89857046
XMax: -10800082.4439301
YMax: 3893918.84328303
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[79,153,168,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: 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)
• CarteID (type: esriFieldTypeString, alias: Cartegraph ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ConstructionDate (type: esriFieldTypeDate, alias: Original Construction Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Route (type: esriFieldTypeSmallInteger, alias: Route, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ServiceAddress (type: esriFieldTypeString, alias: Service Address, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ServiceAddressNumber (type: esriFieldTypeString, alias: Service Address Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ServiceAddressStreetName (type: esriFieldTypeString, alias: Service Address Street Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ServiceAccountNumber (type: esriFieldTypeString, alias: Service Account Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MeterNumber (type: esriFieldTypeString, alias: Meter Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MeterBodyNumber (type: esriFieldTypeString, alias: Meter Body Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MeterManufacturer (type: esriFieldTypeString, alias: Meter Manufacturer, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [3G: 3G Fixed Base Meters], [CP: Capestone], [HA: Hersey Allegro], ... 7 more ...)
• MeterSize (type: esriFieldTypeString, alias: Meter Size, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [5/8: 5/8"], [2: 1"], [3: 1 1/2"], ... 7 more ...)
• ServiceLineCarteID (type: esriFieldTypeString, alias: Service Line Carte ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ServiceLineMaterialCity (type: esriFieldTypeString, alias: Service Line Material - City, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Copper: Copper], [Galvanized: Galvanized], [Iron Pipe: Iron Pipe], ... 4 more ...)
• TCEQValueCity (type: esriFieldTypeString, alias: TCEQ Value City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Lead: Lead], [Galvanized Requiring Replacement: Galvanized Requiring Replacement], [Non-Lead: Non-Lead], ... 9 more ...)
• ServiceLineMaterialCustomer (type: esriFieldTypeString, alias: Service Line Material - Customer, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Copper: Copper], [Galvanized: Galvanized], [Iron Pipe: Iron Pipe], ... 4 more ...)
• TCEQValueCustomer (type: esriFieldTypeString, alias: TCEQ Value Customer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Lead: Lead], [Galvanized Requiring Replacement: Galvanized Requiring Replacement], [Non-Lead: Non-Lead], ... 9 more ...)
• SDUSMeter (type: esriFieldTypeString, alias: SDUS Meter?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• SprinklerSystem (type: esriFieldTypeString, alias: Sprinkler System?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• MeterInServiceDate (type: esriFieldTypeDate, alias: Meter In Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ChangeOutType (type: esriFieldTypeString, alias: Change Out Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [F: Full], [R: Retrofit], [U: Unknown])
• ChangeOutDate (type: esriFieldTypeDate, alias: Change Out Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AccountType (type: esriFieldTypeString, alias: Account Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [A: Apartments], [AL: Assisted Living], [AU: Automotive], ... 20 more ...)
• SymbologyAccountType (type: esriFieldTypeString, alias: Symbology Account Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [City: City], [Commercial: Commercial], [Residential: Residential])
• FieldNotes (type: esriFieldTypeString, alias: Field Notes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• MaterialDocumentation (type: esriFieldTypeString, alias: Material Documentation (Source), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [As Built: As Built], [New Install: New Install], [Repair: Repair], ... 5 more ...)
• UpdateSource (type: esriFieldTypeString, alias: Update Source, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SourceUpdateDate (type: esriFieldTypeDate, alias: Source Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• STWStatus (type: esriFieldTypeString, alias: STW Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Active: Active], [Archived: Archived], [Inactive: Inactive], ... 2 more ...)
• Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: Created User, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: Last User, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edit Date, SQL Type: sqlTypeOther, length: 8, 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)

Templates:

Name: WaterMeters_OLD
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/23/2025 8:15:11 PM

Schema Last Edit Date: 7/23/2025 8:15:11 PM

Data Last Edit Date: 7/23/2025 8:15:11 PM

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