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?
Hi Sunny,
ReplyDeleteThat looks like an interesting data set. It seems like you are off to a good start with your description and questions so far. I think you may have a tough time trying to answer questions 1 and 2 from your data set, but I am definitely interested to see your findings in the final report!
Hi Sunny,
ReplyDeleteI like the dataset you've chosen, considering that looking at camera tickets offers a lot of different data points to choose from. I also like your format, the question and answer labeling makes things clear and concise.
The only issue I'd say is the questions, asking why is something that's hard for the data itself to show, but that doesn't make the question bad.
Hi Sunny,
ReplyDeleteI like the way you formatted your blog post, it was clear and easy to read. The dataset you have chosen is quite interesting and you have included a very detailed description which made it easy to understand without having to visit the website. For your first questioning, I am wondering how you would answer why there's a higher amount of tickets just from the dataset. Would you need to get in touch with the geek for this dataset for more research and information? Overall, you did a great job on this post.