Capstone Project 2023:


Understanding Vancouver's Traffic, an exploratory data analysis for Simon Fraser University SDA 490 Spring 2023.



What is this:


This is an interactive tool designed to help you explore certain aspects of Vancouver BC traffic as well as byproducts of car ownership, alongside textual sentiment analysis based upon real opinions.



Our Project Direction


Our group aims to empower Lower Mainland residents with information to make better decisions about the city's infrastructure, with a focus on transportation education. Our goal is to influence policy makers in British Columbia to reduce traffic and optimize existing traffic by improving infrastructure. We will analyze data on current transportation patterns and infrastructure, as well as gather feedback from residents and stakeholders to better understand their needs and concerns.



What you should expect to see


  • Our inspiration and research question
  • Our hypotheses
  • A collection of interactive heatmaps
  • A collection of Various interactive plots
  • Interactive textual sentiment analysis and emotion classifier
  • Findings and explanations
  • Suggestions and cohesive conclusion



How will traffic calming driving penalties and its subsequent non-driving rewards affect Vancouver traffic?


This question is important to us as a group because as economics students we understand that most everything comes with costs associated with it.
Do you want to get downtown in the comfort of your own automobile? Well be prepared for the cost of traffic. Alternatively, if you want to get downtown quickly? Take the bus, but be prepared for abrupt stops, little personal space, and other costs of taking alternative forms of transportation.
This is just a simple example of our economic approach to thinking about how to both understand and alleviate traffic, while encouraging alternative forms of transportation

Some of our hypotheses include:

  1. Increasing the number of traffic controls will have a reduction on private motor vehicle usage.
  2. Reduction of motor vehicle usage changes with the severity of traffic control
  3. The size of roads/sidewalks will have an effect on the amount of foot and bicycle traffic with respect to car traffic and vice versa.
  4. The amount of traffic accidents is determined by the surrounding traffic infrastructure/lack of traffic controls.
As you will see as you explore this application, testing these hypotheses was of large importance for us.



How this R Shiny web app can help you.


This app was developed with the education of the user at the forefront of our minds. We think that the first step to solving traffic issues in Vancouver is through education in an interactive way to help users rethink their need for a vehicle.
Imperfect information causes inefficiency, and as economics students, where we see the ability for optimization, we will take it. Education is a barrier to entry for many, because “you don’t know what you don't know”. This fallacy in this case, leads to overpopulated streets, lower translink ridership, as well as increased crime, which will be highlighted in this exploratory data analysis.
We hope that you discover something new about the way Vancouver traffic and its byproducts affect the city.



Where did it come from?


Our team analyzed many types and styles of data from over a decade and transformed this information into what you will see and experience during the presentation of this R Shiny web app.


Data used during this project includes:


  • Census Data.
  • City of Vancouver intersection data.
  • ICBC collision and traffic violation data.
  • Traffic signal data.
  • City of Vancouver crime data.
  • Government of Canada job data.
  • Scraped text data from the internet (twitter, reddit, etc).



How does it fit into the big picture??


Building a clear path is just one part of effective infrastructure/city planning and development. You should also establish a city plan to outline how you will achieve these goals. This illustration hopes to provide you with a better understanding and a realistic path to help change the reality of lower mainland traffic

Intersection Crash Count

Illstration 1: Crash Data

This map provides an overview of traffic crashes in Vancouver between 2017 and 2021. It includes accidents with both casualties and without casualties. The map highlights areas of crash frequency. We can see the crash frequency is the highest particularly at intersections and exits/entrances of highways. By visualizing the crash data geographically, we can identify patterns and trends in areas that require attention and interventions. Overall, this map is an important tool for identifying areas where traffic safety improvements are needed and for supporting evidence-based decision making to reduce the number of traffic crashes and injuries in Vancouver.
(fyi: Crash Counts are sorted by percentile. For example, Crash amount greater than 600 is ~ 99.94 percentile.)

Intersection Crash Count (Clustered)

Illstration 2: Street-View Crash Data

This second map, which also uses traffic crashes data from Vancouver between 2017 and 2021, provides a more granular view of the information compared to the previous map. It uses hierarchical clustering algorithm to groups similar objects into clusters based on their distance. It allows users to explore the data at the street level, with the ability to click on specific intersections to see their corresponding crash information. This makes it easier to gain insights and identify patterns that may not have been visible in the previous map.

Heatmap By Years

Illstration 3: Heatmap of Crashes Sorted by Years.

The interactive map provides an overview of traffic crashes in Vancouver for each year. Similar to Illustration 1, this map displays areas of crash frequency from high (red) to low (yellow), but with the added benefit of allowing users to select different years and see how the patterns of crashes change over time. This makes the map especially useful for identifying trends and patterns based on time.

Traffic Signals

Share of Crime Across Vancouver Neighborhoods

Illustration 4:

This bar graph displays the number of vehicle thefts in a specific neighborhood. According to the number of thefts, the neighborhoods are arranged in decreasing order. The graph can be helpful to law enforcement in identifying neighborhoods where theft from vehicles occurs more frequently. Additionally, we may draw a connection between the increase in vehicles and the rise in crime.

Share of Crime Across Vancouver Neighborhoods Per Capita

Illustration 5:

This bar graph displays the number of vehicle thefts in a specific neighborhood per capita. According to the number of thefts, the neighborhoods are arranged in decreasing order. The graph can be helpful to law enforcement in identifying neighborhoods where theft from vehicles occurs more frequently. Additionally, we may draw a connection between the increase in vehicles and the rise in crime.

Vehicle Kilometer Travelled Per Capita

Illustration 6:

This bar graph shows the Vehicle Kilometer Travelled (VKT) per capita by city in a bar chart format. It helps us to compare the VKT per capita values for different cities in Metro Vancouver. The higher the bar, the higher the VKT per capita. The custom color palette based on the city names makes it easier to differentiate between the bars representing different cities. This information can be useful for understanding transportation pattern.

Employment Factors

Illustration 7:

The bar graph shows the percentage of jobs in different cities of Metro Vancouver in British Columbia, Canada. Each bar represents a city, and its length represents the percentage of jobs in that city. It provides valuable insights into which cities have more employment opportunities. Overall, this graph provides a quick and easy-to-understand overview of job distribution in Metro Vancouver.

Share of Vehicular Fatalities

Reddit Word Cloud


About our project


That's the end of our intectactive website. Thank you for checking this out! We hope that you'll enjoy exploring this interactive tool and that you'll discover something new about the way Vancouver's traffic and its byproducts affect the city.


Final Regards

This project is organized by Steven Weldon and Edana Beauvais from SFU, with collaboration from City of Vancouver and City Studio. Thank you for giving us this opportunity! And here is a little information about the project team!
Dustin
Visionary, Project Leader, Web Designer, Main Coder, Editor
Grateful for collaborating on a project with potential to positively impact our community.
Matt
Bibliographer/Editor, Texual Analyst/Web Scraper, Support Coder
Happy to have gained R Shiny experience and applied it in a meaningful way for the City of Vancouver
Amir
Data Collecter/Wrangler, Graph Builder, Visualization Specialist
Happy to have worked with real life data and applied it with a larger goal in mind.