← 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.: 59672; 21849; 24268
- attrs->>'ADDRESS' | string | 5000/4946 | e.g.: ; 6161 REIMS RD; 23775 KINGWOOD PLACE DR
- attrs->>'ADDRESS_ID' | number | 5000/4956 | e.g.: 0; 47770; 1906675
- attrs->>'ANCILLARYROLE' | number | 5000/1 | values: 0
- attrs->>'BARRELDIAMETER' | null | 4994/1 | values: 4
- attrs->>'BONNETCOLOR' | string | 504/4 | values: 306; 303; 307; 304
- attrs->>'CASTYEAR' | null | 504/57 | e.g.: 2003; 2007; 2012
- attrs->>'COMPKEY' | number | 4999/4970 | e.g.: 17810; 16849; 42713
- attrs->>'COMPTYPE' | number | 5000/1 | values: 12
- attrs->>'COUNCILDISTRICT' | string | 4944/12 | values: B; C; D; H; G; K; I; A; E; F; J; 
- attrs->>'CREATIONSOURCE' | string | 797/5 | values: CIP; DPC; COMMERCIAL; DEVELOPER; FVW
- attrs->>'DATASOURCEREFNUM' | number | 3805/55 | e.g.: 0; 8000; 7671
- attrs->>'DATASOURCETYPE' | null | 4996/6 | values: U; AB; P; FV; TM; O
- attrs->>'ENABLED' | number | 5000/1 | values: 1
- attrs->>'FACILITYADDRESS' | null | 3875/519 | e.g.:  ; <Null>; 4211 Elgin
- attrs->>'FACILITYID' | null | 4999/4999 | e.g.: 5883203; 770967; 145098
- attrs->>'FACILITYNAME' | null | 3789/2 | values:  ; <Null>
- attrs->>'FISCAL_YEAR' | null | 903/12 | values: FY14; FY15; FY13; FY16; FY18; FY17; FY19; FY10; FY11; FY20; FY12; N/A
- attrs->>'GFSORWBS' | string | 668/2 | values: WBS; GFS
- attrs->>'GFSWBSNUMBER' | null | 668/182 | e.g.: S-000035-0126-4; S-0035-70-3; S-000035-0200-4
- attrs->>'HFD_DELIVERY' | null | 3805/1 | values: 1235952000000
- attrs->>'HYDRANT_INSPECTED_DATE' | null | 100/2 | values: -2209161600000; 1197590400000
- attrs->>'HYDRANTLEADDIAMETER' | number | 5000/1 | values: 6
- attrs->>'HYDRANTNUMBER' | string | 5000/1 | values: HFD??
- attrs->>'ILMSNUMBER' | string | 146/110 | e.g.: 13117979; 15043389; 12046208
- attrs->>'IMSNO' | null | 100/99 | e.g.: 12327176; 12368046; 12254050
- attrs->>'INSERVICEDATE' | number | 2294/847 | e.g.: 1458259200000; 891302400000; 1404950400000
- attrs->>'INSPECTIONDATE' | number | 642/164 | e.g.: -2209161600000; 1421798400000; 1424217600000
- attrs->>'IPSSUBTYPE' | string | 5000/1 | values: 8
- attrs->>'KEYMAP' | string | 5000/936 | e.g.: 493Q      ; 534J      ; 453V      
- attrs->>'LIFECYCLESTATUS' | string | 5000/3 | values: E; P; A
- attrs->>'LINESIZE' | null | 4674/15 | e.g.: 8; 12; 6
- attrs->>'MAINDIAMETER' | string | 5000/17 | e.g.: 8; 12; 6
- attrs->>'MANUFACTURER' | string | 514/14 | e.g.: MUE; DAR; CLO
- attrs->>'NOTES' | null | 125/50 | e.g.: Inservice Date: Assumed for Modeling; Project Number: Unknown; Will be assigned THD number when as-builts are submitted
- attrs->>'NOZZLECOLOR' | null | 507/1 | values: 302
- attrs->>'NOZZLEDIAMETER1' | number | 4994/1 | values: 4
- attrs->>'NOZZLEDIAMETER2' | null | 4994/1 | values: 2.5
- attrs->>'NOZZLEDIAMETER3' | number | 4994/1 | values: 2.5
- attrs->>'OWNER' | string | 5000/2 | values: C; P
- attrs->>'PLANDATE' | number | 2461/791 | e.g.: 1307404800000; 946684800000; 891388800000
- attrs->>'PLANNUMBER' | null | 4950/1027 | e.g.:  ; 48229; 48519
- attrs->>'PLANTYPE' | null | 2503/4 | values: P; WD; THD; 
- attrs->>'PROJECTNUMBER' | null | 4236/657 | e.g.:  ; Unknown; <Null>
- attrs->>'PROJECTTYPE' | null | 1456/12 | values: WA; PJ; JOB; C; GFS; SB; UNKNOWN; CSJ; SM; WBS; PN; WW
- attrs->>'QCVERIFIED' | null | 3876/1 | values: Y
- attrs->>'SERVICEADDRESS' | null | 11/11 | values: 235 SHADY LAKE DR; 8302 Furlong Ln; 6019 RAPID CREEK; 11402 JUTLAND; 220 COVECREST DR; 1900 BERING DR; 3400 TRAVIS; 24405 E LAKE HOUSTON PKWY; 409 ELM LAKE DR; 9606 S RICE; 1829 BERING
- attrs->>'SUBDIVISION_NAME' | string | 181/61 | e.g.: Regency Square Area; Oak Forest Area; GULF MEADOWS
- attrs->>'SUBTYPECD' | number | 5000/1 | values: 8
- attrs->>'SYMBOLROTATION' | number | 5000/4957 | e.g.: 90; 0; 2.00000015
- attrs->>'UFID' | number | 5000/5000 | e.g.: 5883203; 770967; 145098
- attrs->>'UNITID' | string | 5000/5000 | e.g.: 5883203; 770967; 145098
- attrs->>'WATERTRACEWEIGHT' | null | 3803/2 | values: 0; 541065216
- attrs->>'ZONE' | null | 4982/7 | values: NW; SW; NE; SE; GNEHSA; IAH; 
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.