← All datasets

# curated.safety_ped_dangerous_roads
Most dangerous roads for pedestrians (602 rows; category: Traffic safety; geometry column `geom` (MultiLineString, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 602/602 | e.g.: 354; 537; 497
- attrs->>'bike_crash_count' | number | 602/4 | values: 0; 1; 2; 3
- attrs->>'BikeCrashRate' | number | 602/50 | e.g.: 0; 2.00000002; 2.00000007
- attrs->>'bike_death_count' | number | 602/3 | values: 0; 1; 2
- attrs->>'car_crash_count' | number | 602/14 | e.g.: 1; 2; 3
- attrs->>'car_death_count' | number | 602/6 | values: 0; 1; 2; 3; 4; 5
- attrs->>'Full_Name' | string | 602/307 | e.g.: WESTHEIMER RD; AIRLINE DR; TIDWELL RD
- attrs->>'MilesLength' | number | 602/124 | e.g.: 0.49999999; 0.49999998; 0.5
- attrs->>'ORIG_FID' | number | 602/307 | e.g.: 73562; 35214; 64169
- attrs->>'ORIG_SEQ' | number | 602/46 | e.g.: 1; 2; 3
- attrs->>'ped_crash_count' | number | 602/10 | values: 1; 2; 3; 4; 5; 7; 6; 10; 8; 13
- attrs->>'PedCrashRate' | number | 602/290 | e.g.: 2.00000004; 2.00000008; 2.00000006
- attrs->>'ped_death_count' | number | 602/8 | values: 0; 1; 2; 3; 4; 6; 7; 5
- attrs->>'RoadID' | number | 602/602 | e.g.: 94158; 55792; 95804
- attrs->>'total_crash_count' | number | 602/17 | e.g.: 3; 2; 4
- attrs->>'TotalCrashRate' | number | 602/462 | e.g.: 6.00000013; 5.99999991; 4.00000002
- attrs->>'UID' | number | 602/602 | e.g.: 94158; 55792; 95804
- attrs->>'UIDTEXT' | string | 602/602 | e.g.: 94158; 55792; 95804
- attrs->>'VehCrashRate' | number | 602/368 | e.g.: 0; 2.00000002; 2.00000012
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.