← All datasets

# curated.streets_speed_study_post
Speed studies after traffic calming (223 rows; category: Streets & traffic; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 223/223 | e.g.: 25823; 27394; 26029
- attrs->>'ADDRESS' | string | 223/223 | e.g.: 936 TEETSHORN; 706 WENDEL; 13907 PIPING ROCK
- attrs->>'COLLECTIONTYPE' | string | 223/1 | values: POST-NTMP
- attrs->>'REGION' | string | 223/3 | values: SW; NW; NE
- attrs->>'SEGMENT' | string | 223/149 | e.g.: ACADEMY TO STELLA LINK; BRAES BLVD TO EDLOE; CONRAD SAUER & SHADOWDALE
- attrs->>'StationID' | number | 223/223 | e.g.: 30352138413; 30974138181; 30348138316
- attrs->>'Subdivision' | string | 223/14 | e.g.: WOODLAND HEIGHTS; BRAESWOOD PLACE; SOUTHGATE
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.