Houston Open Data Explorer

← All datasets

# curated.facility_county_community_centers
Harris County community centers (94), which also serve as cooling and warming sites (94 rows; category: Facilities; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 94/94 | e.g.: 75; 13; 93
- attrs->>'Address_1' | string | 94/90 | e.g.: 16003 Lorenzo St.; 4900 Providence St.; 709 Riley Fuzzel Rd.
- attrs->>'AssetNum' | string | 94/83 | e.g.:  ; HC0121001; HC0175001
- attrs->>'AssocPark' | string | 94/38 | e.g.:  ; Crosby Park; Bayland Park
- attrs->>'BDNUM' | string | 94/91 | e.g.: BDH98; BDC25; BD045
- attrs->>'bType' | string | 94/4 | values: COMM_CTR; LIBRARY; OFFICE; OTHER
- attrs->>'Comments' | string | 94/4 | values: ; May not be in use, awaiting verification; Was Pct1 North Service Center;  
- attrs->>'IDNo' | string | 94/3 | values:  ; 79; 1116
- attrs->>'Name' | string | 94/94 | e.g.: Leland Office "Annex 31"; La Porte Library; South Office & Natatorium
- attrs->>'OBJECTID_12' | number | 94/94 | e.g.: 75; 13; 93
- attrs->>'OBJECTID_2' | number | 94/85 | e.g.: 0; 79; 49
- attrs->>'OtherName' | string | 94/34 | e.g.:  ; NORTH CHANNEL BRANCH LIBRARY; E.H.C.
- attrs->>'OtherType' | string | 94/14 | e.g.:  ; Maint Camp; Annex
- attrs->>'Pct' | number | 94/4 | values: 2; 3; 1; 4
- attrs->>'PCTin2011' | string | 94/4 | values: 2; 1; 3; 4
- attrs->>'PCTin2021' | string | 94/4 | values: 2; 3; 1; 4
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.