DailyTrafficVolume

dateneighborhood_idtotal_traffic
(→ Neighborhood.id)
2022-01-0113000
2022-01-0224500
2022-01-0336000
2022-01-0445500
2022-01-0554200

Accidents

accident_dateneighborhood_idnum_accident
(→ Neighborhood.id)
2022-01-0112
2022-01-0224
2022-01-0333
2022-01-0445
2022-01-0552

WeatherConditions

condition_datetimeneighborhood_idrainfalltemperaturewindspeed
(→ Neighborhood.id)
2022-01-01 08:00:0010.210.55
2022-01-01 12:00:0010127
2022-01-01 16:00:001084
2022-01-01 20:00:001052
2022-01-02 08:00:0020.110.86

SpeedLimits

road_segment_idstreet_nameneighborhood_idstart_pointend_pointmax_limitmin_limit
(→ Neighborhood.id)
1Main St.1-79.999-79.9984030
2Elm St.2-79.995-79.9943020
3Oak St.3-79.993-79.9923020
4Maple St.4-79.989-79.9883020
5Pine St.5-79.987-79.9864030

Neighborhood

idnamepopulationCommute_Time
1Downtown800030.5
2Midtown950028.5
3Southside1100029.8
4Northside1200030.2
5Eastside850031.5