Did you see the above infographic and wonder what went into it? Well wonder no more.
The infographic seen on above and on page seven of the May 7th AV News was compiled from the financial documents of the three cities compared, Port Alberni, Squamish and Salmon Arm.
Behind the scenes, that information was gathered in a Google spreadsheet that you can take a look at here. All stats are the latest available; that’s 2013 for the financials and 2011 for the population.
Wondering how to use that database?
This is a database of civic manager salaries for the city of Port Alberni, the district of Squamish and the city of Salmon Arm. Tabs at the bottom allow you to jump between city manager/CAO, engineering & public works, planning & development, finance, parks, recreation and heritage, corporate services & HR and a summary.
Green represents Port Alberni, yellow represents Squamish and blue represents Salmon Arm. Department heads are a bolder green, yellow and blue respectively and their employees are a more faded tone. Averages are in grey at the bottom.
To sort by highest to lowest or vice versa, mouse over the colum heads (A, B, C, etc) at the top, click on the arrow that appears and choose A-Z for low to high and Z-A for high to low.
To filter which people you want and which you don’t, the same menu used for sorting will have an option to check and uncheck different data points. Want only Port Alberni? Mouse over ‘A’ and uncheck Squamish and Salmon Arm. Same with other categories
Questions or concerns? This database was compiled by the AV News as part of our series on city management. Here is part one, part two and part three. If you have more questions, feel free to email email@example.com or call 1-778-689-4238.
Editorial note: An error was made in the infographic above that stated that city manager Ken Watson earned three per cent, or $4,746 more than average. Upon redoing our math, we realized that he makes only $505 more than average, effectively zero per cent.