Layers:

Layer: wHydrant (0)


Name: wHydrant

Display Field: FACILITYNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

This point feature class contains information about the geographic location and related attributes of the City of Houston’s owned and maintained hydrants.

The information in this layer is derived from the Plan and Profile Engineering Drawings that come from the following sources: Block Map, As-Built, Field Verified with Control Number, Taps and Meters, Metro, Field Verified Fire Department, Field Verified Fire Line, Construction Drawing (Layer), Fire Department, and Capital Improvement Project.

The GIS Services Group of Houston Water, Houston Public Works currently stores and maintains the dataset in a Relational Database Management System.

Geospatial or map data maintained by the Houston Public Works for informational purposes and may not have been prepared for or be suitable for legal, engineering, or surveying purposes. It does not represent an on-the-ground survey and only represents the approximate location of these assets.



Copyright Text: Originator: City of Houston, Houston Public Works, Houston Water, GIS Services Publication Date: 06/10/2021 Editors: Albert Lent / Myriam Wright Contact Person: Kirt Arthur / kirt.arthur@houstontx.gov

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: -10654305.9095525
YMin: 3442822.83309648
XMax: -10585246.7981686
YMax: 3517580.57600136
Spatial Reference: 102100 (3857)


Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SUBTYPECD","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[215,252,246,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"8","label":"Fire Hydrant"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,252,206,255],"toColor":[197,252,206,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,241,255],"toColor":[252,179,241,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,218,252,255],"toColor":[182,218,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,214,194,255],"toColor":[252,214,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[246,252,179,255],"toColor":[246,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,252,252,255],"toColor":[202,252,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[200,189,252,255],"toColor":[200,189,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,241,255],"toColor":[252,212,241,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,189,255],"toColor":[252,179,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,249,212,255],"toColor":[252,249,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[214,252,184,255],"toColor":[214,252,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[219,212,252,255],"toColor":[219,212,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[223,179,252,255],"toColor":[223,179,252,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field:

Type ID Field: SUBTYPECD

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: Ancillary Role, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Source], [2: Sink])
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• CREATIONUSER (type: esriFieldTypeString, alias: Employee Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• DATECREATED (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATEMODIFIED (type: esriFieldTypeDate, alias: Date Modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTUSER (type: esriFieldTypeString, alias: Last User, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CONDITIONDATE (type: esriFieldTypeDate, alias: Condition Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• UFID (type: esriFieldTypeInteger, alias: UFID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• QCVERIFIED (type: esriFieldTypeString, alias: QC Verified, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• PLANDATE (type: esriFieldTypeDate, alias: Plan Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATASOURCEREFNUM (type: esriFieldTypeInteger, alias: Field Verified Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSERVICEDATE (type: esriFieldTypeDate, alias: In Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CREATIONSOURCE (type: esriFieldTypeString, alias: Financial Assets, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CIP: CAPITAL IMPROVEMENT PROJECT], [COMMERCIAL: COMMERCIAL], [DPC: DEVELOPER PARTICIPATION CONTRACTOR], ... 2 more ...)
• SOURCEOFFUND (type: esriFieldTypeString, alias: Funding Source, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FACILITYNAME (type: esriFieldTypeString, alias: Facility Name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FACILITYADDRESS (type: esriFieldTypeString, alias: Facility Address, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [E: Features Being Used and Maintained], [P: Proposed], [A: Abandoned], ... 2 more ...)
• SYMBOLROTATION (type: esriFieldTypeDouble, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WATERTRACEWEIGHT (type: esriFieldTypeInteger, alias: Water Trace Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BARRELDIAMETER (type: esriFieldTypeDouble, alias: Barrel Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: 4"])
• NOZZLEDIAMETER1 (type: esriFieldTypeDouble, alias: Nozzle Diameter 1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2.5: 2.5"], [4: 4"])
• NOZZLEDIAMETER2 (type: esriFieldTypeDouble, alias: Nozzle DIameter 2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2.5: 2.5"], [4: 4"])
• NOZZLEDIAMETER3 (type: esriFieldTypeDouble, alias: Nozzle Diameter 3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2.5: 2.5"], [4: 4"])
• MANUFACTURER (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [AVK: AVK], [CLO: Clow], [DAR: Darling], ... 7 more ...)
• SUBTYPECD (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HFD_DELIVERY (type: esriFieldTypeDate, alias: HFD Delivery, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HYDRANT_INSPECTED_DATE (type: esriFieldTypeDate, alias: Inspected Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SUBDIVISION_NAME (type: esriFieldTypeString, alias: Subdivision Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LAND_BASE_REVIEWED (type: esriFieldTypeString, alias: Land Base Reviewed, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• NORTHING (type: esriFieldTypeDouble, alias: Northing, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERMITDATE (type: esriFieldTypeDate, alias: Permit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MOTIONDATE (type: esriFieldTypeDate, alias: Motion Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PRIVATEFUND (type: esriFieldTypeString, alias: Private Fund, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ILMSNUMBER (type: esriFieldTypeString, alias: ILMS Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• FISCAL_YEAR (type: esriFieldTypeString, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [FY10: FY10], [FY11: FY11], [FY12: FY12], ... 38 more ...)
• IMSNO (type: esriFieldTypeInteger, alias: IMS Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMPKEY (type: esriFieldTypeInteger, alias: COMPKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NOZZLECOLOR (type: esriFieldTypeString, alias: Nozzle Color, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [302: 302])
• BONNETCOLOR (type: esriFieldTypeString, alias: Bonnet Color, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [303: 303], [304: 304], [306: 306], ... 2 more ...)
• INSPECTIONDATE (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LINESIZE (type: esriFieldTypeDouble, alias: Line Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 0.75"], [1: 1"], [1.5: 1.5"], ... 38 more ...)
• CASTYEAR (type: esriFieldTypeString, alias: Cast Year, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• KEYMAP (type: esriFieldTypeString, alias: Key Map, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• COUNCILDISTRICT (type: esriFieldTypeString, alias: Council District, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [A: A], [B: B], [C: C], ... 8 more ...)
• PLANNUMBER (type: esriFieldTypeString, alias: Plan Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PROJECTNUMBER (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [C: City Owned/Maintained], [P: Privately Owned & Maintained], [CP: City Own & Privately Maintained], ... 1 more ...)
• HYDRANTLEADDIAMETER (type: esriFieldTypeDouble, alias: Hydrant Lead Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Unknown], [0: Other], [0.5: 0.5"], ... 40 more ...)
• IPSSUBTYPE (type: esriFieldTypeString, alias: IPS Subtype Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ZONE (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [GNEHSA: GNEHSA], [IAH: IAH], [NE: NE], ... 3 more ...)
• ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• MAINDIAMETER (type: esriFieldTypeString, alias: Main Size, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [1: 1"], [1.5: 1.5"], [2: 2"], ... 40 more ...)
• FACILITYID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• MOTIONNUMBER (type: esriFieldTypeString, alias: Motion Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PERMITNUMBER (type: esriFieldTypeString, alias: Permit Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• WCRNUMBER (type: esriFieldTypeString, alias: WCR Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• HYDRANTNUMBER (type: esriFieldTypeString, alias: Hydrant Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• COSTPERACRE (type: esriFieldTypeString, alias: Cost Per Acre, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• DATASOURCETYPE (type: esriFieldTypeString, alias: Data Source Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [BM: Block Map], [P: Plan and Profile], [AB: As Built], ... 10 more ...)
• PLANTYPE (type: esriFieldTypeString, alias: Plan Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [P: Plan and Profile], [THD: Texas Highway Department], [WD: Water Drawing], ... 5 more ...)
• PROJECTTYPE (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [BG: Budgeted Job], [C: Private Construction], [JOB: City Job], ... 10 more ...)
• ADDRESS_ID (type: esriFieldTypeDouble, alias: ADDRESS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GFSORWBS (type: esriFieldTypeString, alias: GFS or WBS, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [GFS: Government Financial System], [WBS: Work Business Structure])
• GFSWBSNUMBER (type: esriFieldTypeString, alias: GFS-WBS Number, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• UNITID (type: esriFieldTypeString, alias: UNITID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• COMPTYPE (type: esriFieldTypeSmallInteger, alias: COMPTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPATIALADJUSTNOTE (type: esriFieldTypeString, alias: Sptatial Adjustment Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SERVICEADDRESS (type: esriFieldTypeString, alias: Service Address, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REPLACEMENTPROJTYPE (type: esriFieldTypeString, alias: Replacement Project Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [BG: Budgeted Job], [C: Private Construction], [JOB: City Job], ... 10 more ...)
• WORKORDERNUMBER (type: esriFieldTypeString, alias: Work Order Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• REPLACEMENTPROJNUM (type: esriFieldTypeString, alias: Replacement Project Number, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• REPLACEMENTDATE (type: esriFieldTypeDate, alias: Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• QCDATE (type: esriFieldTypeDate, alias: QC Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PSCNUMBER (type: esriFieldTypeString, alias: PSC Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• DEMELEV2008 (type: esriFieldTypeDouble, alias: DEM Elevation 2008, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DEMELEV2018 (type: esriFieldTypeDouble, alias: DEM Elevation 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IPSEXPIREDATE (type: esriFieldTypeDate, alias: IPS Expire Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• IPSEXPIREDBY (type: esriFieldTypeString, alias: IPS Expired By, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ADDRKEY (type: esriFieldTypeInteger, alias: ADDRKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

ID: 8
Name: Fire Hydrant
Domains:

• Field Name: ANCILLARYROLE
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: QCVERIFIED
  Inherited
  
• Field Name: CREATIONSOURCE
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: BARRELDIAMETER
  Inherited
  
• Field Name: NOZZLEDIAMETER1
  Inherited
  
• Field Name: NOZZLEDIAMETER2
  Inherited
  
• Field Name: NOZZLEDIAMETER3
  Inherited
  
• Field Name: MANUFACTURER
  Inherited
  
• Field Name: LAND_BASE_REVIEWED
  Inherited
  
• Field Name: FISCAL_YEAR
  Inherited
  
• Field Name: NOZZLECOLOR
  Inherited
  
• Field Name: BONNETCOLOR
  Inherited
  
• Field Name: LINESIZE
  Inherited
  
• Field Name: COUNCILDISTRICT
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: HYDRANTLEADDIAMETER
  Inherited
  
• Field Name: ZONE
  Inherited
  
• Field Name: MAINDIAMETER
  Inherited
  
• Field Name: DATASOURCETYPE
  Inherited
  
• Field Name: PLANTYPE
  Inherited
  
• Field Name: PROJECTTYPE
  Inherited
  
• Field Name: GFSORWBS
  Inherited
  
• Field Name: REPLACEMENTPROJTYPE
  Inherited
  
Templates:

Name: Fire Hydrant
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ANCILLARYROLE: 0
• ENABLED: 1
• LIFECYCLESTATUS: E
• SYMBOLROTATION: 0
• BARRELDIAMETER: 4
• NOZZLEDIAMETER1: 4
• NOZZLEDIAMETER2: 2.5
• NOZZLEDIAMETER3: 2.5
• SUBTYPECD: 8
• OWNER: C
• HYDRANTLEADDIAMETER: 6
• HYDRANTNUMBER: HFD??
• COMPTYPE: 12

---


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/6/2025 10:28:33 PM

Schema Last Edit Date: 2/6/2025 10:28:33 PM

Data Last Edit Date: 2/6/2025 10:28:33 PM