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:
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.
Hi Sunny,
ReplyDeleteThat is an interesting data set that you found. I like that you have it split out into tickets at specific intersections too. One potential improvement could be to give your lead a bit more depth, maybe through comparing the tickets in Vancouver to one of the other cities in your data set.
Hey Sunny,
ReplyDeleteThis is a rather in depth update, helps to see exactly what you are doing and seeing with this data. I think the sub headings to explain each field really help with showing your analysis thus far. Could have maybe written a little more about the article, but that's very much a personal thing, as the summary is pretty well done as is.
Hi Sunny,
ReplyDeleteThis data update is very detailed! It sounds like you've got a good understanding of your data. The article you've chosen also does a good job of providing context for your data analysis. My one suggestion is to perhaps rework your lead because it doesn't quite provide enough information for me, as a reader, to want to read the article. As a reader, I'm wondering "does this mean that Vancouver gives the most tickets per year every year?" or "does this mean that Vancouver gave the most tickets within the last year?" I'm also wondering, "Vancouver gives the most tickets as opposed to what other city?" Perhaps rework your lead, so it's more specific and answers more questions.
Hi Sunny,
ReplyDeleteI think this is an interesting dataset that you've chosen and I appreciate your lead as I understand what I'm expecting, but I do think it could be better if we could also see to what magnitude Vancouver is number 1. Other than that, good work!