Name: Houston Fire Hydrant

Display Field: FACILITYNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

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: 3014674.7035055
YMin: 13759518.0821537
XMax: 3205138.43746714
YMax: 13964859.3105101
Spatial Reference: 102740 (2278)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"76ba1d99225ad9b4d050840cdfa6b7bb","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAOCAYAAAAmL5yKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA7klEQVQokaXSMUoDQRTG8V+xd5Ck8wIBGUFIH7BIbhCwW7GxEdK6jU3AA8R6m9TbCOntFsErCAFvIY/syhKWaOLXzPBm3v+9+d5k/qnsl/PUrPWpgGJI2jI8BZDmTEdYkOPlKMCY1QPOsKaojwTkt6QvfOCJwTVFPOkvgJQoJrhpAO+Y8Lih2jc066t+z6DEpgnEfomLXQezQ4A0Jx811VstsEWYWu5GW/cCzinmeG5atweJLkpWuOwD5HdMw/VIji66iliYuiR1x/oDGJNH9dBrjzGt4k53rC1g9oarA1+2R2Fm1QJiPNXnEdmtvgEcsTLMdS/vlAAAAABJRU5ErkJggg==","contentType":"image/png","width":12,"height":10,"angle":0,"xoffset":0,"yoffset":0}},"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:

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])
• 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: [AUK: AUK], [AVK: AVK], [AVR: AVR], ... 8 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], ... 5 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], ... 1 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"], ... 17 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], ... 7 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: No - City Owned/Maintained], [P: Yes - Privately Owned & Maintained])
• 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"], ... 20 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)
• PCSNUMBER (type: esriFieldTypeString, alias: PCS 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], ... 8 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], ... 3 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], ... 6 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)

Templates:

Name: Houston 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

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/25/2025 1:39:16 PM

Schema Last Edit Date: 6/25/2025 1:39:16 PM

Data Last Edit Date: 6/25/2025 1:28:46 PM

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