← All datasets
# curated.safety_county_high_injury
Harris County high-injury network (regional roads beyond the city's Vision Zero network) (3,152 rows; category: Traffic safety; geometry column `geom` (MultiLineString, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 3152/3152 | e.g.: 1597; 1740; 2679
- attrs->>'BenSummaryJune8_csv_bike_crash_' | number | 3152/3 | values: 0; 1; 2
- attrs->>'BenSummaryJune8_csv_bike_death_' | number | 3152/2 | values: 0; 1
- attrs->>'BenSummaryJune8_csv_car_crash_c' | number | 3152/16 | e.g.: 2; 1; 3
- attrs->>'BenSummaryJune8_csv_car_death_c' | number | 3152/5 | values: 0; 1; 2; 3; 4
- attrs->>'BenSummaryJune8_csv_ped_crash_c' | number | 3152/9 | values: 0; 1; 2; 3; 4; 6; 5; 13; 10
- attrs->>'BenSummaryJune8_csv_ped_death_c' | number | 3152/6 | values: 0; 1; 2; 4; 3; 5
- attrs->>'BenSummaryJune8_csv_total_crash' | number | 3152/17 | e.g.: 2; 3; 4
- attrs->>'BenSummaryJune8_csv_total_death' | number | 3152/7 | values: 0; 1; 2; 3; 4; 5; 7
- attrs->>'BikeCrashRate' | number | 3152/343 | e.g.: 0; 2.201975538158137; 2.185214542952806
- attrs->>'PedCrashRate' | number | 3152/1057 | e.g.: 0; 1.9999997616807286; 2.000000237073192
- attrs->>'RegionalRoads_halfmile_Full_Nam' | string | 3152/1286 | e.g.: SH 6 S; WESTHEIMER RD; FM 1960 W
- attrs->>'RegionalRoads_halfmile_miles' | number | 3152/3152 | e.g.: 0.49999993155497924; 0.4999999877311351; 0.4999999790999973
- attrs->>'RegionalRoads_halfmile_UIDText' | string | 3152/3152 | e.g.: 50955; 67712; 35250
- attrs->>'TotalCrashRate' | number | 3152/3152 | e.g.: 4.000000326613035; 3.999999802298098; 5.9999999273946
- attrs->>'VehCrashRate' | number | 3152/3013 | e.g.: 0; 13.999999448553769; 4.000000847157036
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.