Question 1. "What dataset will you use for your final report? (title of your dataset, include a link to it and claim it at the URL above)."
Answer: For the final project I will be using the dataset "Intersection Safety Camera Violation Tickets by Location". This dataset is from the BC Data Catalogue. The link to access the data is listed below: https://catalogue.data.gov.bc.ca/dataset/intersection-safety-camera-violation-tickets-by-locationa Catalogue (gov.bc.ca)
Question 2. Describe the dataset. What kind of data does it contain?
Answer: The dataset includes the intersection location for the traffic camera. The data is also split into two different types of tickets. The first one being "Red Light Violations" and the other being "Speed Violation". The dataset finally includes the municipality of where the intersection is located. The data is broken into numbers, which showcases the number of tickets that have been given at that location. This dataset begins in 2019.
Question 3: Is there anything about the dataset that you don't understand? (i.e. what a column heading means). How will you find this out?
Answer: Currently the dataset is very clear, the column headings are very clear. The headings clearly show what data is in that column. The only issue I have is that I am unsure if the totals for the tickets include both a speeding ticket and a red light violation. I will look into ICBC's website to see if you get tickets for both or just one. This is the only concern with the data I have at the moment.
Question 4: What are some questions you hope to answer with your data? List at least three. (you don't need the answers at this point.)
- Which intersection has the most red-light tickets. Why is that intersection?
- Since the speed cameras are fairly new, why did they choose only those intersections to place them in?
- Which municipalities have the most offenses?
