← All datasets

# curated.infra_fire_hydrant
Fire hydrants (61,955 rows; category: Infrastructure & drainage; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 51145; 43602; 57933
- attrs->>'ADDRESS' | string | 5000/4924 | e.g.: ; 9185 GULF FWY; 9498 DR JOHN E CODWELL DR
- attrs->>'ADDRESS_ID' | number | 5000/4931 | e.g.: 0; 1921725; 76317
- attrs->>'ANCILLARYROLE' | number | 5000/1 | values: 0
- attrs->>'BARRELDIAMETER' | number | 4990/1 | values: 4
- attrs->>'BONNETCOLOR' | string | 507/4 | values: 306; 303; 307; 304
- attrs->>'CASTYEAR' | null | 509/57 | e.g.: 2007; 2002; 2006
- attrs->>'COMPKEY' | number | 5000/4967 | e.g.: 23513; 55126; 39453
- attrs->>'COMPTYPE' | number | 5000/1 | values: 12
- attrs->>'COUNCILDISTRICT' | string | 4940/12 | values: B; D; C; A; H; I; G; K; E; F; J; 
- attrs->>'CREATIONSOURCE' | null | 781/5 | values: CIP; DPC; COMMERCIAL; DEVELOPER; FVW
- attrs->>'DATASOURCEREFNUM' | number | 3822/63 | e.g.: 0; 5442; 2559
- attrs->>'DATASOURCETYPE' | null | 4991/6 | values: U; AB; P; FV; TM; O
- attrs->>'ENABLED' | number | 5000/1 | values: 1
- attrs->>'FACILITYADDRESS' | null | 3897/531 | e.g.:  ; <Null>; 7325 Boyce
- attrs->>'FACILITYID' | string | 4999/4999 | e.g.: 6003468; 7395745; 530566
- attrs->>'FACILITYNAME' | null | 3801/2 | values:  ; <Null>
- attrs->>'FISCAL_YEAR' | string | 876/12 | values: FY13; FY15; FY14; FY16; FY19; FY17; FY10; FY18; FY11; FY20; FY12; N/A
- attrs->>'GFSORWBS' | null | 672/2 | values: WBS; GFS
- attrs->>'GFSWBSNUMBER' | null | 672/176 | e.g.: S-0035-70-3; S-000035-0205-4; S-000035-0183-4
- attrs->>'HFD_DELIVERY' | number | 3818/1 | values: 1235952000000
- attrs->>'HYDRANT_INSPECTED_DATE' | null | 96/2 | values: -2209161600000; 1197590400000
- attrs->>'HYDRANTLEADDIAMETER' | number | 5000/1 | values: 6
- attrs->>'HYDRANTNUMBER' | null | 4999/1 | values: HFD??
- attrs->>'ILMSNUMBER' | null | 130/101 | e.g.: 13117979; 12024227; 12026314
- attrs->>'IMSNO' | null | 108/107 | e.g.: 12913975; 13138990; 12279545
- attrs->>'INSERVICEDATE' | number | 2216/839 | e.g.: 1458259200000; 1080691200000; 1396915200000
- attrs->>'INSPECTIONDATE' | null | 640/166 | e.g.: -2209161600000; 1423785600000; 1423440000000
- attrs->>'IPSSUBTYPE' | string | 5000/1 | values: 8
- attrs->>'KEYMAP' | string | 5000/931 | e.g.: 493Q      ; 450W      ; 529J      
- attrs->>'LIFECYCLESTATUS' | string | 5000/2 | values: E; A
- attrs->>'LINESIZE' | null | 4670/13 | e.g.: 8; 12; 6
- attrs->>'MAINDIAMETER' | string | 4999/15 | e.g.: 8; 12; 6
- attrs->>'MANUFACTURER' | null | 528/14 | e.g.: MUE; DAR; CLO
- attrs->>'NOTES' | string | 114/56 | e.g.: Inservice Date: Assumed for Modeling; Project Number: Unknown; Will be assigned THD number when as-builts are submitted
- attrs->>'NOZZLECOLOR' | string | 512/1 | values: 302
- attrs->>'NOZZLEDIAMETER1' | number | 4990/1 | values: 4
- attrs->>'NOZZLEDIAMETER2' | number | 4990/1 | values: 2.5
- attrs->>'NOZZLEDIAMETER3' | number | 4990/1 | values: 2.5
- attrs->>'OWNER' | string | 5000/2 | values: C; P
- attrs->>'PLANDATE' | number | 2366/775 | e.g.: 1307404800000; 891388800000; 944006400000
- attrs->>'PLANNUMBER' | null | 4955/1012 | e.g.:  ; 37706; 48582
- attrs->>'PLANTYPE' | null | 2406/4 | values: P; WD; THD; UN
- attrs->>'PROJECTNUMBER' | null | 4241/633 | e.g.:  ; Unknown; <Null>
- attrs->>'PROJECTTYPE' | null | 1370/11 | values: WA; PJ; JOB; C; GFS; UNKNOWN; SB; CSJ; SM; WBS; PN
- attrs->>'QCVERIFIED' | null | 3912/1 | values: Y
- attrs->>'SERVICEADDRESS' | null | 8/8 | values: 4415 SHINGLE OAK; 6000 HOOTON STREET; 402 ELM LAKE RD; 6019 RAPID CREEK; 7335 BEECHNUT ST; 203 CEDAR LAKE RD; 923 MALCOLMS WAY; 412 WOODLAKE DR
- attrs->>'SUBDIVISION_NAME' | string | 166/56 | e.g.: Garden Villas West Area; Regency Square Area; WALNUT BEND
- attrs->>'SUBTYPECD' | number | 5000/1 | values: 8
- attrs->>'SYMBOLROTATION' | number | 5000/4961 | e.g.: 90; 0; 67.14469045
- attrs->>'UFID' | number | 5000/5000 | e.g.: 6194828; 6003468; 7395745
- attrs->>'UNITID' | string | 5000/5000 | e.g.: 6194828; 6003468; 7395745
- attrs->>'WATERTRACEWEIGHT' | null | 3815/1 | values: 0
- attrs->>'ZONE' | null | 4988/7 | values: NW; SW; NE; SE; GNEHSA; IAH; 
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.