Name: Water Meters

Display Field: StreetName

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-01Receiver Source - Manual PS Field Verify was Paratum Solutions field verification method performed in Spring 2024.

Service Item Id: fdbe8c48749d44afa9c1031fd880e63c

Copyright Text: Grapevine Public Works GIS

Default Visibility: true

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 8000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.0812297180659827E7
YMin: 3879434.8186333473
XMax: -1.0800076787967948E7
YMax: 3893918.843283035
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: AccountType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: Unknown
UniqueValueInfos:
• Value: CG
  Label: City of Grapevine
  Description: N/A
  Symbol:
  
• Value: A
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: AL
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: AU
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: BA
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: C
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: CH
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: CP
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: CV
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: DP
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: FF
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: GM
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: HD
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: HM
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: IN
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: MD
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: MP
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: NH
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: OG
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: RR
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: SC
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: SL
  Label: Commercial
  Description: N/A
  Symbol:
  
• Value: R
  Label: Residential
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: N/A

Fields:

• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• EAMID ( nullable: true, length: 50, alias: OpenGOV ID, type: esriFieldTypeString )
• STWStatus ( nullable: true, length: 20, alias: STW Status, type: esriFieldTypeString , Coded Values: [Active: Active] , [Archived: Archived] , [Inactive: Inactive] , ...2 more... )
• Route ( nullable: true, alias: Route, type: esriFieldTypeSmallInteger )
• ServiceAddress ( nullable: true, length: 100, alias: Service Address, type: esriFieldTypeString )
• AddressNumber ( nullable: true, length: 10, alias: Service Address Number, type: esriFieldTypeString )
• StreetName ( nullable: true, length: 50, alias: Service Address Street Name, type: esriFieldTypeString )
• AccountNumber ( nullable: true, length: 50, alias: Service Account Number, type: esriFieldTypeString )
• MeterNumber ( nullable: true, length: 50, alias: Meter Number, type: esriFieldTypeString )
• MeterBodyNumber ( nullable: true, length: 50, alias: Meter Body Number, type: esriFieldTypeString )
• MeterManufacturer ( nullable: true, length: 25, alias: Meter Manufacturer, type: esriFieldTypeString , Coded Values: [3G: 3G Fixed Base Meters] , [CP: Capestone] , [HA: Hersey Allegro] , ...7 more... )
• MeterSize ( nullable: true, length: 20, alias: Meter Size, type: esriFieldTypeString , Coded Values: [5/8: 5/8"] , [2: 1"] , [3: 1 1/2"] , ...7 more... )
• ServiceDate ( nullable: true, length: 8, alias: Meter In Service Date, type: esriFieldTypeDate )
• ConstructionDate ( nullable: true, length: 8, alias: Original Construction Date, type: esriFieldTypeDate )
• SprinklerSystem ( nullable: true, length: 3, alias: Sprinkler System?, type: esriFieldTypeString , Coded Values: [1: Yes] , [2: No] )
• SDUSMeter ( nullable: true, length: 3, alias: SDUS Meter?, type: esriFieldTypeString , Coded Values: [1: Yes] , [2: No] )
• SDUSPWGrid ( nullable: true, length: 25, alias: SDUS Grid, type: esriFieldTypeString )
• SDUSPolygonID ( nullable: true, length: 150, alias: SDUS Polygon Identifier, type: esriFieldTypeString )
• SDUSFeeHistoric ( nullable: true, alias: SDUS Fee Historic, type: esriFieldTypeDouble )
• SDUSFee ( nullable: true, alias: SDUS Fee, type: esriFieldTypeDouble )
• ChangeOutType ( nullable: true, length: 10, alias: Change Out Type, type: esriFieldTypeString , Coded Values: [F: Full] , [R: Retrofit] , [U: Unknown] )
• ChangeOutDate ( nullable: true, length: 8, alias: Change Out Date, type: esriFieldTypeDate )
• AccountType ( nullable: true, length: 50, alias: Account Type, type: esriFieldTypeString , Coded Values: [A: Apartments] , [AL: Assisted Living] , [AU: Automotive] , ...20 more... )
• Symbology ( nullable: true, length: 25, alias: Symbology Account Type, type: esriFieldTypeString , Coded Values: [City: City] , [Commercial: Commercial] , [Residential: Residential] )
• MaterialCity ( nullable: true, length: 25, alias: Service Line Material - City, type: esriFieldTypeString , Coded Values: [Copper: Copper] , [Galvanized: Galvanized] , [Iron Pipe: Iron Pipe] , ...4 more... )
• TCEQCity ( nullable: true, length: 50, alias: TCEQ Value City, type: esriFieldTypeString , Coded Values: [Lead: Lead] , [Galvanized Requiring Replacement: Galvanized Requiring Replacement] , [Non-Lead: Non-Lead] , ...9 more... )
• MaterialCustomer ( nullable: true, length: 25, alias: Service Line Material - Customer, type: esriFieldTypeString , Coded Values: [Copper: Copper] , [Galvanized: Galvanized] , [Iron Pipe: Iron Pipe] , ...4 more... )
• TCEQCustomer ( nullable: true, length: 50, alias: TCEQ Value Customer, type: esriFieldTypeString , Coded Values: [Lead: Lead] , [Galvanized Requiring Replacement: Galvanized Requiring Replacement] , [Non-Lead: Non-Lead] , ...9 more... )
• TCEQDateRange ( nullable: true, length: 50, alias: TCEQ Install Date Range, type: esriFieldTypeString , Coded Values: [Before 1989: Before 1989] , [Between 1989 and 2014: Between 1989 and 2014] , [After 2014: After 2014] , ...1 more... )
• ServiceLineCarteID ( nullable: true, length: 50, alias: Service Line Carte ID, type: esriFieldTypeString )
• FieldNotes ( nullable: true, length: 1000, alias: Field Notes, type: esriFieldTypeString )
• SourceUpdateDate ( nullable: true, length: 8, alias: Source Update Date, type: esriFieldTypeDate )
• UpdateSource ( nullable: true, length: 50, alias: Update Source, type: esriFieldTypeString )
• MaterialDocumentation ( nullable: true, length: 50, alias: Material Documentation (Source), type: esriFieldTypeString , Coded Values: [As Built: As Built] , [New Install: New Install] , [Repair: Repair] , ...5 more... )
• CreatedDate ( nullable: true, length: 8, alias: Created Date, type: esriFieldTypeDate )
• CreatedBy ( nullable: true, length: 255, alias: Created By, type: esriFieldTypeString )
• LastEditor ( nullable: true, length: 255, alias: Last Editor, type: esriFieldTypeString )
• LastEdit ( nullable: true, length: 8, alias: Last Edit Date, type: esriFieldTypeDate )
• ESRIGNSS_POSITIONSOURCETYPE ( nullable: true, alias: Position source type, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...3 more... )
• ESRIGNSS_RECEIVER ( nullable: true, length: 50, alias: Receiver Name, type: esriFieldTypeString )
• ESRIGNSS_LATITUDE ( nullable: true, alias: Latitude, type: esriFieldTypeDouble )
• ESRIGNSS_LONGITUDE ( nullable: true, alias: Longitude, type: esriFieldTypeDouble )
• ESRIGNSS_ALTITUDE ( nullable: true, alias: Altitude, type: esriFieldTypeDouble )
• ESRIGNSS_FIXDATETIME ( nullable: true, length: 8, alias: Fix Time, type: esriFieldTypeDate )
• ESRIGNSS_AVG_H_RMS ( nullable: true, alias: Average Horizontal Accuracy (m), type: esriFieldTypeDouble )
• ESRIGNSS_AVG_V_RMS ( nullable: true, alias: Average Vertical Accuracy (m), type: esriFieldTypeDouble )
• ESRIGNSS_AVG_POSITIONS ( nullable: true, alias: Averaged Positions, type: esriFieldTypeSmallInteger )
• ESRIGNSS_H_STDDEV ( nullable: true, alias: Standard Deviation (m), type: esriFieldTypeDouble )
• Shape ( nullable: true, alias: SHAPE, type: esriFieldTypeGeometry )
• UtilityBillingJoinInfo ( nullable: true, length: 255, alias: UtilityBillingJoinInfo, type: esriFieldTypeString )
• MeterServiceType ( nullable: true, length: 50, alias: MeterServiceType, type: esriFieldTypeString )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata