← All datasets
# curated.boundary_police_beat
HPD police beats (121); attrs->>'Beats' is the beat code, e.g. '12D10' (121 rows; category: Boundaries & demographics; geometry column `geom` (MultiPolygon, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 121/121 | e.g.: 75; 96; 13
- attrs->>'Area_sq_mi' | number | 121/121 | e.g.: 3.40013561; 10.40962341; 7.51878306
- attrs->>'Beats' | string | 121/121 | e.g.: 8C10; 12D60; 22B20
- attrs->>'Beats_0' | string | 121/121 | e.g.: 12D60; 22B20; 18F10
- attrs->>'District' | number | 121/25 | e.g.: 10; 20; 21
- attrs->>'Division' | string | 121/17 | e.g.: Northeast; Westside; Central
- attrs->>'Perimet_mi' | number | 121/121 | e.g.: 14.51439767; 7.75927571; 22.41560836
- attrs->>'Region' | string | 121/4 | values: 1; 3; 2; Homeland
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.