1.What dataset will you use for your final project? (include a link to
the
dataset and claim it at the URL above).
311 Case Location
2.
Describe the dataset. What kind of data
does it contain?
This dataset contains records of 3-1-1 calls made in Vancouver. The
data details the date of the call, what the call was in regards to, and what
street the call was made from.
3.
How will you use this data as the basis
for a news story?
I sorted the data and found out that for almost every month, missed
garbage disposal has had the most complaints. Over 700 complaints were
registered for missed garbage, recyclables, or organics waste in the last month
alone. I have been removing this data from the monthly datasets in order to
compile a massive dataset that focusses directly on complaints about missed disposal
pick-ups. Using a pivot table, I plan on finding out whether the complaints
have had any effect on lowering the amount of missed pickups by using a line
graph to compare each month. I also hope to make a map detailing which areas featured
the most missed pick-ups throughout the year.
4.
Is there anything about your data that
you don’t understand? (i.e.
what a column heading means). How will you find this out?
The dataset did not require any cleaning and the headings were easy to
understand. All the headers had an in-depth explanation on the website.
5.
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 street has
the most missed pick-ups?
Which month has the
most missed pick-ups?
Have the complaints
made by Vancouver citizens had any effect on decreasing missed pick-ups?
I've never even heard of 3-1-1... so I'm interested to know more about what that's about. I think I've got an idea about what it is based on what you've talked about in your blog post, but elaborating on it a little bit in your final story, i don't think, would be a bad thing. It will be interesting to find out what was the most common complaint, however, I'm not entirely sure that you'll be able to say if the complaints have effected change or not.
ReplyDeleteAs someone who has had to call the city of Burnaby multiple times for missed garbage pick ups (their fault, not mine), this is a story that is near and dear to my heart.
ReplyDeleteYour plan sounds great. I would love to see an interactive map too if you could manage it: your data lends itself well to those lovely little map markers. Can't wait to see the finished product.
That's really interesting that the number one complaint is missed garbage disposal. I wouldn't have thought of that, but it makes sense. I think the questions you mentioned at the end are ones that people would be interested in having answered. I wonder if there's any sort of trend...
ReplyDelete