Name: Water Mains

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Waterlines including:TML - transmission lines: diameter>= 14" ML - main lines FHL - fire hydrant leadsRetired - waterlines that are abandoned or removed, but have maintenance history in the Cartegraph WO system.

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: -10812329.0387853
YMin: 3878375.5596912
XMax: -10799860.1932876
YMax: 3894085.45298568
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":1.4}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

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: 50, nullable: true, editable: true)
• ProjectName (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ProjectID (type: esriFieldTypeInteger, alias: Project ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MainTypeDesc (type: esriFieldTypeString, alias: Main Type Description, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Main Line: Main Line], [Fire Hydrant Lead: Fire Hydrant Lead], [Transmission Main Line: Transmission Main Line], ... 1 more ...)
• Diameter (type: esriFieldTypeSmallInteger, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MaterialType (type: esriFieldTypeString, alias: Material type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [VCP: VCP], [RCP: RCP], [RCCP: RCCP], ... 11 more ...)
• WaterType (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Potable: Potable], [Non-Potable: Non-Potable], [Unknown: Unknown], ... 1 more ...)
• DeadEnd (type: esriFieldTypeString, alias: Dead End?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• Owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [TRA: TRA], [SL: Southlake], [CL: Colleyville], ... 8 more ...)
• InstallDate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GISLength (type: esriFieldTypeDouble, alias: GIS Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LastEditor (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• LastEdit (type: esriFieldTypeDate, alias: Last Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: FHL
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• type: 3
• enabled: 1
• MainTypeDesc: Fire Hydrant Lead
• MaterialType: PVC
• WaterType: Potable
• DeadEnd: 2
• Owner: PUB
Name: ML
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• type: 2
• enabled: 1
• MainTypeDesc: Main Line
• MaterialType: PVC
• WaterType: Potable
• DeadEnd: 2
• Owner: PUB
Name: TML
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• type: 1
• enabled: 1
• MainTypeDesc: Transmission Main Line
• MaterialType: PVC
• WaterType: Potable
• DeadEnd: 2
• Owner: PUB

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

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

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

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

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