Edmonton 2009 Neighbourhood Census Data – Extended!

Today, the city released their 2009 Municipal Census data which can be accessed from the City of Edmonton website here.

There was some online discussion about the city’s choice to release the information in .pdf form instead of the more accessible .csv format.  While .pdf is probably more than sufficient enough for most people, check out links to the .csv versions below.

The one thing that the .pdf versions lacked were any pretty graphs.  As an accountant, a pretty graph is about the only way I can express my deep-rooted love for spreadsheets, and as such, have included some for you to enjoy below.

First up, we have a breakdown of the percentage of population by age and by year.  Note that these numbers become significantly altered when we include those who did not report their age, as 2008 saw a disproportionate number of people choose to remain ageless.
That disclaimer aside, it’s interesting to see age groups shift through the demographic spectrum.

Next up is a breakdown of population by Ward.  As you can see, Ward 5 is the largest – tho not by much.

Here’s a look at the population in each Ward broken up by Gender.  As you can see, in all but two wards, the men outnumber the women! I wouldn’t have guessed.

Lastly, I thought it would be interesting to look at how each Ward is broken up between people who own their home and those who are renting.

Thanks for stopping by. And props to the great people at the City of Edmonton for putting this information together.  It’s amazing to see how our great city has grown.

.CSV files:

Ward1 Ward2 Ward3 Ward4 Ward5 Ward6

Map of the Wards in Edmonton