For my final data assignment, I decided to do it on noise complaints in the city. I live in a fairy isolated and suburban family neighborhood so I’ve been fortunate enough to never have to deal with noise complaints but always wondered about noise complaints in other parts of the city.
Before I could start this assignment I needed some data. Noise complaints go through bylaw services so to retrieve this information I needed to look at the city’s 311 data. To find this I went to http://data.ottawa.ca/ and searched for noise complaints. Immediately this brought up 311 calls by year and in each of those individual year tabs the data was separated by month with the type of calls made each month and at what time. But I only needed the data on noise complaints.
To start I downloaded the 311 data in excel sheet form from January 2015-September 2015. Then I went into each individual excel sheet and filtered the information to only show me noise complaints. After I filtered each month to see only the noise complaints I filtered and grouped the information by ward. This way I could easily see the amount of noise complaints were filed per ward. And I did this process to every month from January 2015- September 2015.
Once I filtered each of the months to only display noise complaints I added each of the wards noise complaints totals together and put them in a chart on meta-chart.com to show the total umber of calls by ward from January 2015-September 2015.
The result was:
After I filtered the nine months of data for this year and put it in a chart I quickly and easily noticed that every single month Ward 12, Rideau-Vanier, had the most amount of noise complaints, sometimes having more than double the amount then the other wards for that month. This raised my question of whether or not this was because the Rideau-Vanier ward is a very student populated area.
I wanted to see if this was a noticeable trend so I looked at the data from June 2013-September 2013 and June 2014-September 2014 to see if this has been a reoccurring trend.
So I took one month from each year and put the data into bar graphs on meta-chart.com.
The results were:
Looking at each of these graphs it is extremely obvious that ward 12, Rideau-Vanier has consistently had the most noise complaints each year. It is also easy to notice that Ward 14, Somerset had the second most noise complaint calls. But even being the ward with the second largest of calls it still didnt come remotely close to the large number of noise complaints made in the Rideau-Vanier ward.
Looking and comparing each of these charts its also easy to notice that while the noise complaints in Rideau-Vanier are always in the high 200’s they have been coming down each year. Showing that maybe the number of call complaints are having an imact on the noise residents make in the Rideau Vanier ward.
SOURCES
http://data.ottawa.ca/en/dataset/2014-311-monthly-service-request-submissions
http://data.ottawa.ca/en/dataset/311-monthly-service-request-submissions
http://data.ottawa.ca/en/dataset/2015-311-monthly-service-request-submissions
http://ottawa.ca/en/city-hall/your-city-government/city-wards
https://www.meta-chart.com/bar