Houston Open Data Explorer

← All datasets

# curated.facility_health_dept
facility_health_dept (32 rows; category: Facilities; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 32/32 | e.g.: 104; 2; 76
- attrs->>'ADDRESS' | string | 32/24 | e.g.: 1809 N MAIN; 7037 CAPITOL; 6402 MARKET ST
- attrs->>'ADMIN' | string | 30/1 | values: 1
- attrs->>'CITY' | string | 32/1 | values: HOUSTON
- attrs->>'CNCLDIST' | string | 32/9 | values: H; B; I; D; F; NON; J; C; A
- attrs->>'FAC_NO' | string | 32/28 | e.g.: COH W  2620; COH W  2612; COH W  2602
- attrs->>'KMAP' | null | 31/19 | e.g.: 573D; 494Z; 493G
- attrs->>'NAME' | string | 32/32 | e.g.: SOUTHWEST WIC CENTER; NORTHEAST WIC CENTER; HUNTING BAYOU WIC CENTER
- attrs->>'PHONE' | string | 32/26 | e.g.: 832-393-5427; 713-780-5650; 713-732-5000
- attrs->>'SQFT' | number | 30/11 | values: 0; 18300; 26000; 21074; 52000; 28780; 29000; 17066; 19000; 23250; 37000
- attrs->>'Status' | string | 32/1 | values: active
- attrs->>'TYPE' | number | 32/3 | values: 8; 1; 3
- attrs->>'ZIP' | string | 32/18 | e.g.: 77020; 77051; 77011
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.