Skip to main content

Vehicles on busy road at night time

Can you predict wait times at major city intersections?

Last updated on August 21, 2024 in Data and Analytics by Renjie Mao |  2 minute read


Have you ever been running late to work, only to get stuck at every intersection? What if you were able to predict your wait time before setting off?

Geotab recently teamed up with Kaggle and BigQuery to host the BigQuery-Geotab Intersection Congestion competition using Geotab datasets to identify how to improve safety, optimize operations and identify infrastructure challenges.

Geotab Kaggle Project overview

Geotab provided data consisting of aggregated trip logging metrics from commercial vehicle telematics devices. The data was grouped by the intersection, month, hour of day, direction driven through the intersection and whether the day was on a weekend or not.

 

Each participant was required to make predictions and summarize the distribution of wait times and stop distances at each intersection.

The findings

The following is a summary of what was discovered about the four cities of Atlanta, Boston, Chicago and Philadelphia. Data was analyzed from over 4,500 intersections, including approximately 2,000 in Chicago, 1,250 in Philadelphia, 1,000 in Boston and around 400 in Atlanta.

 

Definitions:

  • Total time stopped is the amount of time spent at zero speed.
  • Time from first stop is the time from the first stop until the vehicle passes through the intersection.
  • Distance to first stop is the distance from the center of the intersection to the first stop, to give an idea of queue length.
number-of-intersections-graph

The number of intersections measured in each city.

 

Cities with longest stop times

 

Atlanta had the longest total time stopped, with vehicles waiting 9.74 seconds on average at intersections, as shown in the chart below. That was followed by Boston, with an average total time stopped of 8.60 seconds. Philadelphia had the shortest stop time.

 

Longest queues at intersections

 

Philadelphia had the longest average distance to first stop at 31.87 meters. Atlanta had the next longest distance with 30.86 meters. Chicago and Boston had lower average distance to first stop at 24.73 and 23.46 respectively.

 

 

average-stopping-time-graph

 

Total time stopped and distance to first stop correlation (weekdays)

  • Since Atlanta has fewer intersections, the data shows a wider distance to the first stop which causes long lines.
  • Philadelphia shows a short total time stopped but with a long distance to the first stop. As the city has the most traffic on the road, this could explain the longer lines at intersections.
  • Chicago has the shortest lines at the intersection (the data is more concentrated), due to the fact that Chicago has the most intersections and least traffic.

Total time stopped vs the distance to first stop correlation on weekdays:

 

 

time-stopped-vs-distance-graph

 

What does the traffic look like by hour during the weekday?

 

Atlanta deals with traffic jams for most of the day (7 a.m. - 7 p.m.), while Chicago only shows two peaks including one in the morning and one in the evening. This could be partly explained due to the fact that Atlanta has the least amount of intersections while Chicago has the most. Based on these datasets, an increase in the amount of intersections can reduce traffic issues in a city.

 

Stopped time hourly trend on weekdays:

 

time-stopped-hourly-trend-graph

 

For each city, what are the top 5 intersections during morning peak and evening peak on a weekday?

 

From the analysis, here are the most congested intersections from each city, morning and evening peak:

 

Atlanta

  • Krog Street NE and Edgewood Avenue NE (morning peak)
  • North Avenue NW and Centennial Olympic Park Drive NW (evening peak)
  • In Atlanta, the evening rush time traffic is 1.7 times congested compared to the morning rush.

Boston

  • Evening rush time traffic will be 1.2 times more congested in comparison to the morning rush time.

Chicago

  • Evening rush time traffic will be 1.3 times more congested compared to morning rush time.

Philadelphia

  • Evening rush time traffic will be 1.4 times more congested in comparison to morning rush time.

Top 5 congested intersections on weekday in seconds:

 

Atlanta-congested-intersection-graph

 

Boston-congested-intersection-graph

 

Chicago-congested-intersection-graph

 

Philadelphia-congested-intersection-graph

 

Conclusion

Clearly, data can be extremely powerful in terms of improving safety and operations. To learn more about connected vehicle insights for fleets and smart cities, visit data.geotab.com.


If you liked this post, let us know!


Disclaimer

Geotab's blog posts are intended to provide information and encourage discussion on topics of interest to the telematics community at large. Geotab is not providing technical, professional or legal advice through these blog posts. While every effort has been made to ensure the information in this blog post is timely and accurate, errors and omissions may occur, and the information presented here may become out-of-date with the passage of time.

Get industry tips and insights

Sign up for Geotab's monthly newsletter to stay updated on news and tips from the world of telematics. You can unsubscribe at any time.

Republish this article for free

Other posts you might like

Traffic in Paris France near Arc de Triomphe

Fleet Electrification: Time to Step Up For the Benefit of All!

Connectivity is the key to EV planning and greener fleets.

September 6, 2024

Illustration of an EV being charged

How long do electric car batteries last? What 10,000 electric vehicles tell us about EV battery life

Compare the average battery degradation for different vehicle makes and model years.

August 29, 2024

Data servers with blue lights

Integrating Sustainability into Responsible AI Frameworks: The Time is Now

Addressing the sustainability challenges of Gen AI requires a multifaceted approach.

July 31, 2024

Hands on a steering wheel

Four major benefits of telematics for risk management in the public sector

Data-powered decisions help fleet managers mitigate risk in the public sector, where safety and efficiency are paramount.

July 9, 2024

View last rendered: 09/19/2024 10:36:05