Data Update #1

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

URL: http://data.vancouver.ca/datacatalogue/311caseLocationDetails.htm

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?