← All datasets

# curated.safety_bike_dangerous_roads
Most dangerous roads for cyclists (174 rows; category: Traffic safety; geometry column `geom` (MultiLineString, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 174/174 | e.g.: 118; 123; 8
- attrs->>'bike_crash_count' | number | 174/3 | values: 1; 2; 3
- attrs->>'BikeCrashRate' | number | 174/78 | e.g.: 2.00000003; 2.00000007; 2.00000002
- attrs->>'bike_death_count' | number | 174/3 | values: 0; 1; 2
- attrs->>'car_crash_count' | number | 174/10 | values: 1; 2; 3; 4; 0; 5; 6; 7; 10; 8
- attrs->>'car_death_count' | number | 174/4 | values: 0; 1; 2; 3
- attrs->>'Full_Name' | string | 174/129 | e.g.: KIRBY DR; BELLAIRE BLVD; WESTHEIMER RD
- attrs->>'MilesLength' | number | 174/41 | e.g.: 0.49999999; 0.49999998; 0.5
- attrs->>'ORIG_FID' | number | 174/129 | e.g.: 53912; 73562; 37781
- attrs->>'ORIG_SEQ' | number | 174/34 | e.g.: 1; 6; 2
- attrs->>'ped_crash_count' | number | 174/11 | values: 0; 1; 2; 4; 5; 3; 8; 10; 7; 6; 13
- attrs->>'PedCrashRate' | number | 174/72 | e.g.: 0; 2.00000006; 2.00000002
- attrs->>'ped_death_count' | number | 174/7 | values: 0; 1; 7; 2; 5; 3; 4
- attrs->>'RoadID' | number | 174/174 | e.g.: 103254; 102967; 103474
- attrs->>'total_crash_count' | number | 174/14 | e.g.: 2; 3; 4
- attrs->>'TotalCrashRate' | number | 174/161 | e.g.: 4.00000014; 6.00000008; 6.00000022
- attrs->>'UID' | number | 174/174 | e.g.: 103254; 102967; 103474
- attrs->>'UIDTEXT' | string | 174/174 | e.g.: 103254; 102967; 103474
- attrs->>'VehCrashRate' | number | 174/133 | e.g.: 0; 4.00000005; 2
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.