Houston Open Data Explorer

← All datasets

# curated.facility_hcpl_libraries
Harris County Public Library (HCPL) branches (29), incl. Kingwood and Clear Lake (Freeman) inside Houston (29 rows; category: Facilities; geometry column `geom` (Point, EPSG:4326))
Notes: attrs->>'BRANCH' name. attrs->>'SelectedCoolingCenter' = '1' marks branches the county uses as cooling centers. attrs->>'COH' = 'Yes' means the branch is inside Houston city limits. Complements curated.facility_libraries (city HPL).

Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 29/29 | e.g.: 18; 2; 9
- attrs->>'ADDRESS' | string | 29/29 | e.g.: 930 Corbindale; 15741 Wallisville Road; 1500 Keene Street
- attrs->>'BRANCH' | string | 29/29 | e.g.: Baldwin Boettcher Branch Library @ Mercer Park; Galena Park Branch Library; North Channel Branch Library
- attrs->>'BRANCH_URL' | string | 29/29 | e.g.: https://www.hcpl.net/branch/harris-county-law-library; https://www.hcpl.net/branch/aldine-branch-library; https://www.hcpl.net/branch/texas-medical-center-library
- attrs->>'CITY' | string | 29/14 | e.g.: Houston; Humble; Katy
- attrs->>'Closures' | string | 29/1 | values: May 29th/30th, July 3rd/4th, September 4th/5th (2022)
- attrs->>'COH' | string | 29/2 | values: No; Yes
- attrs->>'CommPct' | number | 29/4 | values: 3; 2; 1; 4
- attrs->>'Note' | string | 29/1 | values: The libraries will be closed on the following holidays (as w
- attrs->>'SelectedCoolingCenter' | number | 29/2 | values: 0; 1
- attrs->>'STATE' | string | 29/1 | values: Texas
- attrs->>'URL' | string | 29/1 | values: https://www.hcpl.net/locations
- attrs->>'X' | number | 29/29 | e.g.: -95.64374077; -95.733261963; -95.54113273
- attrs->>'Y' | number | 29/29 | e.g.: 29.902262008; 29.757685996; 29.671156006
- attrs->>'ZIP' | number | 29/28 | e.g.: 77338; 77089; 77375
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.