Name: Valves

Display Field: LID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Originally created by Claunch & Miller, Inc. (part of HDR Engineering as of 2008) in 2002, this file has been maintained in-house since then. Updates are provided through a combination of as-builts, field verifications, and word of mouth from employees who have worked on a particular feature.Field breakdown: POINT_ID [Valve ID] contains the unique identifier for each valve, with the first digit references the fire district in which the valve is found. ASSETID [Asset ID] is the randomly assigned, unique identifier used by VUEWorks (Public Works' work order system)*. LID [Lid Condition]uses the ValveLid domain to rate the condition of the valve’s lid (note that this field has not been updated since the valves were originally entered). PHYS_LOCA [Physical Location]uses the ValveLocation domain to describe where the feature is located (e.g., street surface). TYPE [Type]uses the ValveType domain to denote the type of valve (e.g., gate valve). OPEN_DIREC [Open Direction] designates the direction (left or right) the valve must be turned to open it. DIAMETER [Diameter (in)]uses theWLineSize1 domain as a dropdown to record the diameter (in inches) of the valves. POSITIONTYPE [Position Type] categorizes the valves by their relation to other water infrastructure. The GPS_DATE [GPS Date] and GPS_TIME [GPS Time]fields contain information about when the feature was originally shot into the system. The NORTHING [Northing (Y)], EASTING [Easting (X)] Z [Elevation (Z)] fields contain coordinate data. DEPTH_HEIGHTis the below or above Z, the surface elevation. The following fields were populated by Data Transfer Solutions in 2017: IMAGE [Image]contains the file name of a picture of the feature; STREET [Street]contains the name of the street on which the feature is located; CONDITION [Condition] and CONDITIONINDEX [Condition Index] are condition ratings; and the INSTALLYEAR [Installation Year] and CONMMENTS [Comments] fields should be self-explanatory. To derive the actual elevation of a feature = Z + DEPTH_HEIGHTAll Z values are in feet. All Elevation data is Surface Elevation.Due to VUEWorks, care must be taken when deleting features. The IDs cannot be reused and must be retired after a deletion. The retired IDs for this feature class are: 1681, 1700, 1735, 2240, 2241, 3781, 5292, and 6871. (The retired Valve IDs are: 10640, 10812, 10863, 10864, 11229, 50502, 50503, and unknown.)* The reason for two different IDs is that VUEWorks uses randomly assigned IDs; it cannot handle IDs that have meaning.

Service Item Id: 997a62feffe648adb847b94829c20076

Copyright Text: Claunch and Miller, Inc. City of Galveston Data Transfer Solutions

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: 3209289.59013106
YMin: 1.36013442968261E7
XMax: 3328113.36823107
YMax: 1.3694026843744E7
Spatial Reference: 102740  (2278)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: POSITIONTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: Other Valves
UniqueValueInfos:
• Value: FH
  Label: Fire Hydrant Valve
  Description: N/A
  Symbol:
  
• Value: Main
  Label: Main Line Valve
  Description: N/A
  Symbol:
  
• Value: Meter
  Label: Meter Valve
  Description: N/A
  Symbol:
  
• Value: Blowoff
  Label: Blowoff
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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 Current User: true

HasZ: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: Object ID )
• LID ( type: esriFieldTypeString, alias: Lid Condition, length: 20 , Coded Values: [Broken: Broken] , [Missing: Missing] , [Sound: Sound] , ...3 more... )
• PHYS_LOCA ( type: esriFieldTypeString, alias: Physical Location, length: 20 , Coded Values: [Alley: Alley] , [Back of Curb: Back of Curb] , [Easement: Easement] , ...10 more... )
• TYPE ( type: esriFieldTypeString, alias: Type, length: 20 , Coded Values: [Square Nut: Square Nut] , [Stub: Stub] , [T-Stop: T-Stop] , ...8 more... )
• OPEN_DIREC ( type: esriFieldTypeString, alias: Open Direction, length: 20 , Coded Values: [Left: Left] , [Right: Right] , [Unk: Unknown] )
• DIAMETER ( type: esriFieldTypeSmallInteger, alias: Diameter (in) , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...12 more... )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 100 )
• GPS_DATE ( type: esriFieldTypeDate, alias: GPS Date, length: 8 )
• GPS_TIME ( type: esriFieldTypeString, alias: GPS Time, length: 10 )
• NORTHING ( type: esriFieldTypeDouble, alias: Northing (Y) )
• EASTING ( type: esriFieldTypeDouble, alias: Easting (X) )
• POINT_ID ( type: esriFieldTypeInteger, alias: Valve ID )
• PHOTO ( type: esriFieldTypeString, alias: Image, length: 50 )
• STREET ( type: esriFieldTypeString, alias: Street, length: 50 , Coded Values: [10 MILE RD: 10 Mile Rd] , [103RD ST: 103rd St] , [105TH ST: 105th St] , ...826 more... )
• CONDITION ( type: esriFieldTypeString, alias: Condition, length: 6 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] )
• CONDITIONINDEX ( type: esriFieldTypeSmallInteger, alias: Condition Index )
• INSTALLYEAR ( type: esriFieldTypeSmallInteger, alias: Installation Year )
• POSITIONTYPE ( type: esriFieldTypeString, alias: Position Type, length: 7 , Coded Values: [Main: Main Line Valve] , [Meter: Meter Valve] , [Blowoff: Blowoff] , ...4 more... )
• CREATED_USER ( type: esriFieldTypeString, alias: Created By, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: Last Edited Date, length: 8 )
• ASSETID ( type: esriFieldTypeSmallInteger, alias: Asset ID )
• COUNCILDIST ( type: esriFieldTypeSmallInteger, alias: Council District , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...3 more... )
• Z ( type: esriFieldTypeDouble, alias: Z )
• DEPTH_HEIGHT ( type: esriFieldTypeDouble, alias: Depth/Height )
• VALVE_POSITION ( type: esriFieldTypeInteger, alias: VALVE POSITION , Coded Values: [1: Open] , [2: Closed] )
• VALVE_STATUS ( type: esriFieldTypeSmallInteger, alias: VALVE_STATUS , Coded Values: [1: In-Service (Active)] , [2: Abandon (Not Active)] )
• INSPECTOR ( type: esriFieldTypeString, alias: INSPECTOR, length: 100 )
• INSPECTED_DATE ( type: esriFieldTypeDate, alias: INSPECTED_DATE, length: 8 )
• NO_OF_TURNS ( type: esriFieldTypeDouble, alias: NO_OF_TURNS )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )

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

  Iteminfo   Thumbnail   Metadata