What it does

WinTrafficData has two main features. The first is to display aggregate graphs of the given traffic data for the Huron Church Street intersections with Dorchester Road, Tottem Street, and Malden Road as well as to post our analysis and recommendations based on both the aggregate and individual data sets. The second is an intersections dashboard, which allows the user to choose the intersection, travel direction, and type of vehicle and displays the average daily traffic flow graph based on the user's selection. A copy of our analysis can be found below.

Traffic Data Analysis

Current Situation

Based on the given Operations & Timing Report, the current configuration of traffic light signals at Heron Church Street intersections with Dorchester Road, Totten Street, and Malden Road is static in regards to its phases and patterns. However, by examining not only the graphs above but also the graphs in the Intersections Dashboard, it can be seen that there is a lot of variation in the amount of traffic between peak and off-hours due to Huron Church St. being a large main road. Consequently, it becomes difficult to create static signal patterns that can accommodate for busy traffic without creating excessive wait times during off-hours.

Analysis and Recommendations

Traffic Along Destination Routes

As it turns out, traffic flowing northbound along Huron Church St. is extremely busy in the morning, which is visualized in the graph in the top-left. However, all three intersections experience traffic peaks at 8:00AM with approximately the same amount of traffic (around 350 vehicles), indicating that there exists, understandably, a high number of cars on the road as a result of the rush hour. However, these numbers are consistent, and this peak in traffic drops off rapidly, implying that there isn't any back-up occurring. Because of this, the signal lengths at these intersections and times are likely sufficient. As well, the graph of destination routes shows that traffic peaks in the afternoon, with many routes having heavy traffic. In particular, there is a high volume of traffic flowing southbound along Huron Church St. (likely due to workers travelling from the US back to Canada). However, in contrast to the morning rush hour, the Dorchester intersection peaks at volume about 50 vehicles less than at the Totten and Malden intersections, which peak at over 350 vehicles every 15 minutes. Since vehicles travelling southbound down Huron Church St. pass through Dorchester before reaching Totten and Malden, the increasing volume of traffic at later intersections indicates that traffic may be building up further down the road. As well, traffic at Totten and Malden remains at over 300 vehicles for several hours (approximately 3:00PM-6:00PM), indicating that there is higher and longer lasting congestion than in the morning peak. To reduce this congestion, the minimum and maximum green times for the SBT signal should be increased at Totten and Malden during afternoon peak hours to allow traffic to pass through.

N-S vs. E-W Traffic

Between the hours of 11:00PM and 5:30AM, the levels of traffic are extremely low, with fewer than 100 vehicles travelling either northbound or southbound. The recommendation, then, is to decrease NBT and SBT traffic signal lengths during off-hours to reduce wait times for the smaller residential streets. Later in the day, from 9:00AM to 1:00PM, moderate levels of traffic are observed within the aforementioned graphs, with fewer than 250 vehicles along Huron Church St. As such, it is optimal to maintain the current signals for this time frame. Eastbound and westbound traffic is generally low throughout the average day with typically less than or approximately 50 vehicles as seen in the three N-S vs. E-W Traffic graphs. Because the three roads running east to west are smaller roads in comparison to Huron Church St., they experience less traffic overall. Because there are few vehicles on the road (approximately ten) between midnight and 5:00AM, signal times may be reduced to marginally improve traffic flow within these hours. It can also be observed that Dorchester Rd. has the lowest eastbound and westbound traffic flow overall, likely due to its proximity to the Canada - United States border. As such, the signal length of through northbound/southbound traffic can be increased to yield higher traffic flow. Finally, the Totten St. and Malden Rd. intersections are seen to experience minor increases in eastbound and westbound traffic around both rush hours; longer turn signals and more frequent signal changes would improve efficiency at these times.


Through our analysis of traffic along Huron Church Street, it is clear that traffic and wait times can be reduced by modifying signals according to different times of day. In particular, we have three suggestions: First, the minimum and maximum green light times should be increased on southbound through signals for Totten St. and Malden Rd. during afternoon rush hours (3:00PM - 6:00PM). Second, during off-hours (11:00PM - 5:30PM), traffic signal lengths should be dramatically reduced due to an extremely low volume of vehicles on the road. Third, turn signals could be increased and signal changes could be more frequent in the east and west directions during peak hours in order to improve efficiency in the east and westbound directions. Our analysis has shown that there are clear patterns indicating times at which backups are most prominent. Ultimately, by implementing our suggestions, traffic will flow more smoothly both along the corridor and on local streets.

How we built it

We primarily used the Python Pandas to read, interpret, and format the data given in the csv files. The data was then visualized with both the matplotlib and Pandas-Bokeh libraries as visual graphs. These graphs were then outputted to a web application built using HTML, CSS, Javascript, and the Python Flask framework.

Challenges we ran into

Since it was the first time any of us had worked with large amounts of data or even attempted to perform any sort of data analysis, we had a difficult time passing the initial learning curve of setting up. Afterwards, it took us a while to understand the data in the context of the intersections' geography and functions. We also faced challenges in displaying the graphs we generated in an interactive manner.

Accomplishments that we're proud of

What we learned

This was definitely a great step into the world of data science and analytics, and we also learned how to use a number of libraries and frameworks as well.

What's next for WinTrafficData

In the future, we look forward to fleshing out and expanding the functionality of the dashboard in the hopes of adding features such as more intractability and additional graphs to provide even deeper insights into Windsor's traffic.

Built With

Share this project: