Assignment #4: Data Update 3

Datawrapper Chart

The below is my Datawrapper chart for my data visualization.

Unanswered Question

Currently, I have two questions that I cannot answer with the data that I currently have. I would need to gather another dataset to answer these questions, as with the data that I have it's currently unclear at the moment. The questions are below:

1. How were the locations chosen for the select speed-violation cameras?
2. Why does Vancouver have the most violations compared to other major cities of Surrey, Burnaby, and Richmond?

How would you get the data?

For me to answer the first question above, I would need to make an FOI request to RoadSaftey BC. Since I am dealing with a government department, it would be better for me to make an FOI request, rather me asking someone directly. Since the Intersection Saftey Camera program is done by RoadSaftey BC its the best to ask them. For me to answer the second question, I would need to ask ICBC to see why Vancouver is higher on the list. I would first try to ask ICBC public relations department directly, to see if I gather the data that way, if that does not work, I would need to make an FOI request to ICBC. 

JRNL 3165 - Assignment #2: Data Update 2

 Lead: 

According to the data gathered by the BC government, Vancouver has the most intersection traffic tickets issued in one year. 

Excel Workbook & Explanation

This is the link to my worksheet: https://drive.google.com/file/d/1wxWq9N5W-rLHzXDF4lS4RvbuWk3C6qfh/view?usp=sharing

It includes a total of  4 sheets within the workbook. The original data, a pivot table, the filtered data to analyze, and a small data slice. The original data is gathered from the BC data catalog.  The data has the following fields:

• Municipality - Which city the tickets belongs to 

•  Location - The intersection of where the traffic camera is located 

•  Speed VTs - Total amount of tickets issued to cars speeding through the intersection 

•  Red Light VTs - Total amount of tickets issued to cars running through the intersection while the traffic light is red 

•  Total VTs - Total tickets issued to that location. Includes both Speed and Red Light

NOTE: Some of the Speed VTs are blank, as those locations do not detect speeding infractions.  

I decided to get a pivot table that analyzes total tickets issued by the municipality.  This will give the reader a small insight into the data that is provided in my "Data Slice." This gives a good overall into what the data slice is going to show. 

My main data slices include the fields that are mentioned above. The only difference is that they only show the Total VTs for simplicity's sake. As per Update 1, I had to change some of the questions that I had presented due to the fact that they were more "Why" questions that would come from outside the data provided.

Original Dataset Link:

Link to the original dataset: https://catalogue.data.gov.bc.ca/dataset/intersection-safety-camera-violation-tickets-by-locationa Catalogue (gov.bc.ca)

News Story:

Link: https://www.cbc.ca/news/canada/british-columbia/cameras-speeders-red-light-violators-1.5517737 operational 

This article is from CBC news stating that now more red-light traffic cameras are being upgraded to catch speeders. This automated system sends out tickets to people that go above the posted limit through an intersection. Last year, only 35 cameras were active, this year that is going to increase a lot more to catch speeders.