Name: Water Laterals - City (Service Lateral Status)

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Water Lateral were originally created using a Geometric Network tool that created a perpendicular line to the water main and connected the later to water meters (May 2023). Water lateral locations will continue to be edited based on field reports and as-built entries into the GIS system.

Service Item Id: 8d54cc08d7a34206810b20b7d0a8d49a

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: 8000

Tile Max Record Count: 4000

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.0812297303763757E7
YMin: 3879425.3450151817
XMax: -1.0800076787967948E7
YMax: 3893918.843283035
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: TCEQValue
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Lead
  Label: Lead
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 1
• Value: Galvanized Requiring Replacement
  Label: Galvanized Requiring Replacement
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 1
• Value: Galvanized
  Label: Galvanized Requiring Replacement
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 1
• Value: Lead-lined galvanized
  Label: Galvanized Requiring Replacement
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 1
• Value: Non-Lead
  Label: Non-Lead
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 197, 255, 255]
  Width: 1
• Value: Non-Lead - Copper
  Label: Non-Lead
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 197, 255, 255]
  Width: 1
• Value: Non-Lead - Other
  Label: Non-Lead
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 197, 255, 255]
  Width: 1
• Value: Non-Lead - Plastic
  Label: Non-Lead
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 197, 255, 255]
  Width: 1
• Value: Unknown
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [78, 78, 78, 255]
  Width: 1
• Value: Unknown - Likely Lead
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [78, 78, 78, 255]
  Width: 1
• Value: Unknown - Material Unknown
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [78, 78, 78, 255]
  Width: 1
• Value: Unknown - Unlikely Lead
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [78, 78, 78, 255]
  Width: 1
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 )
• ProjectName ( nullable: true, length: 100, alias: Project Name, type: esriFieldTypeString )
• ProjectID ( nullable: true, alias: Project ID, type: esriFieldTypeInteger )
• Address ( nullable: true, length: 150, alias: Address, type: esriFieldTypeString )
• AddressNumber ( nullable: true, length: 10, alias: Address Number, type: esriFieldTypeString )
• StreetName ( nullable: true, length: 50, alias: Street Name, type: esriFieldTypeString )
• Diameter ( nullable: true, alias: Diameter, type: esriFieldTypeSmallInteger )
• MaterialType ( nullable: true, length: 100, alias: Material Type, type: esriFieldTypeString , Coded Values: [Copper: Copper] , [Galvanized: Galvanized] , [Iron Pipe: Iron Pipe] , ...4 more... )
• TCEQValue ( nullable: true, length: 100, alias: TCEQ Value, type: esriFieldTypeString , Coded Values: [Lead: Lead] , [Galvanized Requiring Replacement: Galvanized Requiring Replacement] , [Non-Lead: Non-Lead] , ...9 more... )
• MaterialTypePrivate ( nullable: true, length: 100, alias: Material Type (Private), type: esriFieldTypeString , Coded Values: [Copper: Copper] , [Galvanized: Galvanized] , [Iron Pipe: Iron Pipe] , ...4 more... )
• TCEQValuePrivate ( nullable: true, length: 50, alias: TCEQ Value (Private), type: esriFieldTypeString , Coded Values: [Lead: Lead] , [Galvanized Requiring Replacement: Galvanized Requiring Replacement] , [Non-Lead: Non-Lead] , ...9 more... )
• DateInstalled ( nullable: true, length: 8, alias: Date Installed, type: esriFieldTypeDate )
• Owner ( nullable: true, length: 20, alias: Owner, type: esriFieldTypeString , Coded Values: [TRA: TRA] , [SL: Southlake] , [CL: Colleyville] , ...8 more... )
• WaterMainCarteID ( nullable: true, length: 50, alias: Water Main Carte ID, type: esriFieldTypeString )
• WaterMeterCarteID ( nullable: true, length: 50, alias: Water Meter Carte ID, type: esriFieldTypeString )
• FieldVerified ( nullable: true, length: 25, alias: Field Verified?, type: esriFieldTypeString , Coded Values: [1: Yes] , [2: No] )
• Comments ( nullable: true, length: 500, alias: Comments, type: esriFieldTypeString )
• 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 )
• Shape.STLength() ( nullable: true, alias: Length (ft), type: esriFieldTypeDouble )

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

  Iteminfo   Thumbnail   Metadata