← All datasets

# curated.streets_speed_study_pre
Speed studies before traffic calming (829 rows; category: Streets & traffic; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 829/829 | e.g.: 27377; 26900; 25683
- attrs->>'ADDRESS' | string | 829/823 | e.g.: 12300 FROSTWOOD; 3400 SHADOWBRIAR; 1700 14TH W
- attrs->>'COLLECTIONTYPE' | string | 829/1 | values: PRE-NTMP
- attrs->>'Notes' | null | 1/1 | values: 
- attrs->>'REGION' | string | 829/5 | values: SW; NW; SE; NE; MMD
- attrs->>'SEGMENT' | string | 829/542 | e.g.: SHERMAN TO HARRISBURG; ATWELL TO BRAESMONT; BRADY TO CANAL
- attrs->>'StationID' | number | 829/828 | e.g.: 31137138355; 30766138554; 30768138541
- attrs->>'Subdivision' | null | 826/90 | e.g.: WOODLAND HEIGHTS; Braeswood Place; BARKLEY CIRCLE
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.