Houston Open Data Explorer

← All datasets

# curated.safety_high_injury_network_2018
Vision Zero HIN, 2018 edition (906 rows; category: Traffic safety; geometry column `geom` (MultiLineString, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 906/906 | e.g.: 316; 48; 186
- attrs->>'BenSummaryJune8_csv_bike_crash_' | number | 906/3 | values: 0; 1; 2
- attrs->>'BenSummaryJune8_csv_bike_death_' | number | 906/2 | values: 0; 1
- attrs->>'BenSummaryJune8_csv_car_crash_c' | number | 906/14 | e.g.: 3; 2; 4
- attrs->>'BenSummaryJune8_csv_car_death_c' | number | 906/5 | values: 0; 1; 2; 3; 4
- attrs->>'BenSummaryJune8_csv_ped_crash_c' | number | 906/9 | values: 0; 1; 2; 3; 4; 6; 5; 13; 10
- attrs->>'BenSummaryJune8_csv_ped_death_c' | number | 906/6 | values: 0; 1; 2; 4; 3; 5
- attrs->>'BenSummaryJune8_csv_total_crash' | number | 906/15 | e.g.: 3; 4; 2
- attrs->>'BenSummaryJune8_csv_total_death' | number | 906/7 | values: 0; 1; 2; 3; 4; 7; 5
- attrs->>'BikeCrashRate' | number | 906/86 | e.g.: 0; 2; 2.00000012
- attrs->>'PedCrashRate' | number | 906/289 | e.g.: 0; 2.00000005; 2.00000004
- attrs->>'RegionalRoads_halfmile_Full_Nam' | string | 906/420 | e.g.: WESTHEIMER RD; MAIN ST; BELLAIRE BLVD
- attrs->>'RegionalRoads_halfmile_miles' | number | 906/236 | e.g.: 0.5; 0.49999999; 0.50000001
- attrs->>'RegionalRoads_halfmile_UIDText' | string | 906/906 | e.g.: 104945; 67671; 95071
- attrs->>'TotalCrashRate' | number | 906/701 | e.g.: 5.99999966; 6.00000022; 5.99999993
- attrs->>'VehCrashRate' | number | 906/684 | e.g.: 0; 6.00000022; 1.99999997
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.