How does your borough fare at clearing snow?
Organisation: Montreal Gazette (Canada)
Publication Date: 03/22/2016
Size of team/newsroom:large
DescriptionThe City of Montreal kept a simple dashboard showing the progress of snow removal crews for each city borough. It detailed when operations began and when they were scheduled to end. I scraped this dashboard for 14 months, over seven major snowstorms. I then calculated when the operations hit 100%, and compared it to the official estimates. I found that some boroughs were better at estimating removal times than others. When compared with the snow removal budgets, I was also able to see which boroughs were more efficient and which were wasteful.
What makes this project innovative? What was its impact?It was the first time this kind of long-term, numbers-driven analysis was done with snow removal, which is a big topic of gripes among residents.
Technologies used for this project:ScraperWiki to scrape the city's snow removal dashboard as well as snowfall data from Environment Canada. Excel for number crunching. Tableau for visualizing the data.
You have to be connected to contribute
You have to be connected to follow
Leave this project and no longer be informed about this project
By joining this project, you will be informed by email when an update or a new contribution is posted on the website.
Thank you for your active participation !
The GEN Community Team