← All datasets

# curated.facility_police_storefront
HPD storefront offices (26 rows; category: Facilities; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 26/26 | e.g.: 18; 2; 4
- attrs->>'ADDRESS' | string | 26/26 | e.g.: 1127 North Shepherd; 5330 Griggs; 4410 Navigation
- attrs->>'Beat' | string | 26/26 | e.g.: 6B60; 9C20; 9C40
- attrs->>'Council_Di' | string | 26/8 | values: D; B; I; A; C; F; H; E
- attrs->>'LEGEND' | string | 26/26 | e.g.: Richmond - 6308 Richmond Avenue 77057; Telephone Road - 10201 Telephone Road 77075; East Freeway -12001 East Freeway 77015
- attrs->>'Match_addr' | string | 26/26 | e.g.: 105 GREENSPOINT MALL; 3711 SOUTHMORE BLVD; 10966 NORTH FWY
- attrs->>'NAME' | string | 26/26 | e.g.: Independence Heights; Fifth Ward; Aldine
- attrs->>'X' | number | 26/26 | e.g.: 3132680.527003; 3133556.031625; 3099189.162476
- attrs->>'Y' | number | 26/26 | e.g.: 13846739.3375; 13804763.013891; 13791222.057015
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.