Name: hydrants_flushed

Display Field: VALVE_ON_H

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="margin:0 0 14 0;"><SPAN>Originally created by Claunch &amp; 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.</SPAN></P><P STYLE="margin:0 0 14 0;"><SPAN><SPAN>Field breakdown: The unique identifier for the fhs, which consists of the fire district number* and a base number, is in the </SPAN></SPAN><SPAN STYLE="font-style:italic;">FHNUMBER [FH ID] </SPAN><SPAN><SPAN>field. The individual components of the identifier are in the </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>FHNOPREFIX [FH Prefix] </SPAN></SPAN><SPAN><SPAN>and </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>FH_NO [FH Number] </SPAN></SPAN><SPAN><SPAN>fields. The fire district to which the fh is associated is listed in the </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>DISTRICT [Fire District] </SPAN></SPAN><SPAN><SPAN>field, and the associated Council District is listed in </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>CouncilDist [Council District]</SPAN></SPAN><SPAN><SPAN>. The </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>MANUFACTUR [Model]</SPAN></SPAN><SPAN><SPAN>field uses the FireManu domain to list the fh</SPAN></SPAN><SPAN><SPAN>’</SPAN></SPAN><SPAN><SPAN>s model, and the </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>MANUFACTU2 [Model Year]</SPAN></SPAN><SPAN><SPAN>field contains the year the fh was made. </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>STATUS [Status] </SPAN></SPAN><SPAN><SPAN>contains the fh</SPAN></SPAN><SPAN><SPAN>’</SPAN></SPAN><SPAN>s current repair status via the FHStatus domain (the status updates were provided via a weekly email from a designated Public Works Administrative Assistant but stopped after January 5, 2018, due to the implementation of a new work order system) while the </SPAN><SPAN STYLE="font-style:italic;"><SPAN>DATEINSTAL [Update Date]</SPAN></SPAN><SPAN><SPAN>field contains the date of the status update email. The </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>VALVE_ON_H [Has Valve]</SPAN></SPAN><SPAN><SPAN>field uses the YesNo domain to indicate whether the fh has a water valve. The </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>GPS_DATE [GPS Date] </SPAN></SPAN><SPAN><SPAN>and </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>GPS_TIME [GPS Time]</SPAN></SPAN><SPAN>fields contain information about when the feature was originally shot into the system. </SPAN><SPAN><SPAN>The </SPAN></SPAN><SPAN><SPAN>NORTHING [Northing (Y)]</SPAN></SPAN><SPAN><SPAN>, </SPAN></SPAN><SPAN><SPAN>EASTING [Easting (X)] Z [Elevation (Z)] </SPAN></SPAN><SPAN><SPAN>fields contain coordinate data.</SPAN></SPAN></P><P STYLE="margin:0 0 14 0;"><SPAN><SPAN>All Z values are in feet. All Elevation data is Surface Elevation.</SPAN></SPAN></P><P STYLE="margin:0 0 14 0;"><SPAN><SPAN>Due to VUEWorks (Public Works</SPAN></SPAN><SPAN><SPAN>’</SPAN></SPAN><SPAN>work order system), 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: 239, 1072, and 1703.</SPAN></P><P STYLE="margin:0 0 14 0;"><SPAN><SPAN>* Two of the fire district borders changed sometime before 2013 but </SPAN></SPAN><SPAN STYLE="font-style:italic;"><SPAN>after</SPAN></SPAN><SPAN>the fh numbering system was implemented, resulting in a situation where some fhs have numbers that do not match their district.</SPAN></P></DIV></DIV></DIV>

Service Item Id: c5e16246db654c0ea6ffe6f8b0353d40

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

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: 3209905.857271239
YMin: 1.3602029396505713E7
XMax: 3327082.911630571
YMax: 1.369391077639088E7
Spatial Reference: 102740  (2278)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: FLUSHEDSTATUS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [0, 92, 230, 0]
Size: 7.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[230, 152, 0, 0] Width: 0
Default Label:
UniqueValueInfos:
• Value: Complete
  Label: Flushing is complete
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [38, 115, 0, 255]
  Size: 7.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Flushing Needed
  Label: Flushing Needed
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 115, 255]
  Size: 7.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
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: false
Supports Query With Current User: true

HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FLUSHEDSTATUS ( type: esriFieldTypeString, alias: Flushed Status, length: 255 , Coded Values: [Flushing Needed: Flushing Needed] , [Complete: Flushing is Complete] )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspector, length: 100 )
• LOCATION ( type: esriFieldTypeString, alias: Location Description, length: 255 )
• Z ( type: esriFieldTypeDouble, alias: Z )
• PHOTO ( type: esriFieldTypeString, alias: Image, length: 255 )
• ASSETID ( type: esriFieldTypeSmallInteger, alias: Asset ID )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: Last Edited Date, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• CREATED_USER ( type: esriFieldTypeString, alias: Created By, length: 255 )
• DATEINSPECTED ( type: esriFieldTypeDate, alias: Date Inspected, length: 8 )
• STATICPRESSURE ( type: esriFieldTypeDouble, alias: Static Pressure )
• NUMBER_OF_TURNS ( type: esriFieldTypeDouble, alias: Number of Turns )
• FHNUMBER ( type: esriFieldTypeString, alias: FH ID, length: 20 )
• FH_NO ( type: esriFieldTypeSmallInteger, alias: FH Number )
• RESIDUALPRESSURE ( type: esriFieldTypeDouble, alias: Residual Pressure )
• YEARINSTAL ( type: esriFieldTypeDate, alias: Installation Year, length: 8 )
• EASTING ( type: esriFieldTypeDouble, alias: Easting (X) )
• NORTHING ( type: esriFieldTypeDouble, alias: Northing (Y) )
• GPS_TIME ( type: esriFieldTypeString, alias: GPS Time, length: 10 )
• GPS_DATE ( type: esriFieldTypeDate, alias: GPS Date, length: 8 )
• MANUFACTU2 ( type: esriFieldTypeSmallInteger, alias: Model Year )
• FLOW ( type: esriFieldTypeString, alias: Flow, length: 25 )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• DATEINSTAL ( type: esriFieldTypeDate, alias: Update Date, length: 8 )
• BONNETCOLOR ( type: esriFieldTypeString, alias: Bonnet Color, length: 25 , Coded Values: [Red: Red] , [Orange: Orange] , [Green: Green] , ...1 more... )
• COUNCILDIST ( type: esriFieldTypeSmallInteger, alias: Council District , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...3 more... )
• STATUS ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Functional: Functional] , [Needs Repaired: Hydrant Needing Repairs] , [Needs Replaced: Hydrant Needing Replacement] , ...9 more... )
• DISTRICT ( type: esriFieldTypeSmallInteger, alias: Fire District , Coded Values: [1: 1] , [2: 2] , [4: 4] , ...3 more... )
• FHNOPREFIX ( type: esriFieldTypeSmallInteger, alias: FH Prefix , Coded Values: [1: 1] , [2: 2] , [4: 4] , ...3 more... )
• MANUFACTUR ( type: esriFieldTypeString, alias: Model, length: 20 , Coded Values: [Amer Darl B-62B: Amer Darl B-62B] , [Amer Darl B-84B: Amer Darl B-84B] , [Clow Challenger: Clow Challenger] , ...20 more... )
• VALVE_ON_H ( type: esriFieldTypeString, alias: Has Valve, length: 20 , Coded Values: [Yes: Yes] , [No: No] , [UNK: Unknown] )

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

  Iteminfo   Thumbnail   Metadata