I now know that the ward who receives the most noise complaints (at least in the year 2015), is Ward 12 or Rideau-Vanier. After acquiring the 311 service requests data from data.ottawa.ca, I downloaded the values for the first nine months of the year, January to September. I then used a pivot table for each month’s file, sorting the rows by ward and the values by the number of complaints received. After the pivot table was created, I took each table and put them into one document. Next, I added up all the values for each month by ward and sorted them into a final table of their own, adding the total number of noise complaint calls together. Finally, I used rapidtables.com to pull my findings up on a bar graph to better represent the data.
The total number of 311 calls regarding noise amounted to 8106 for the first nine months of the year. Rideau-Vanier took the crown with 1717 complaints, with Somerset ward coming in at 1172.
Ward_# | Total_#_of_noise_complaints_Jan-Sept_2015 |
1 | 177 |
2 | 143 |
3 | 287 |
4 | 127 |
5 | 57 |
6 | 117 |
7 | 309 |
8 | 409 |
9 | 259 |
10 | 266 |
11 | 246 |
12 | 1717 |
13 | 444 |
14 | 1172 |
15 | 389 |
16 | 455 |
17 | 535 |
18 | 280 |
19 | 159 |
20 | 93 |
21 | 96 |
22 | 156 |
23 | 213 |
TOTAL | 8061 |