Tag Archives: census

Edmonton Neighbourhood Census Data

By Mack D. Male ·

For a long time I’ve wanted to get the City of Edmonton’s neighbourhood census data in CSV format (or really any usable format other than PDF). Recently, with the help of Laura (and Sandra) at the City’s Election & Census Services department, who I met at the Open City Workshop, I finally got it. And now you can have it too!

Download the Edmonton Neighbourhood Census Data in CSV

I’ve also emailed this to the City’s open data team, so hopefully they can get it in the data catalogue soon.

Visualizing the Data

Why is having the census data in a format like CSV useful? Well for one thing, it enables creatives to do stuff with that data through code or other tools. For instance, I was able to generate a heat map for the City of Edmonton:

The darker sections are more heavily populated, the lighter yellow regions are less populated.

Not all neighbourhoods are reflected, as the City does not release details for neighbourhoods with a population between 1 and 49. Here are some other things we can learn from the data set:

  • Total population in the data set is 777,811, which means there are 4628 individuals unaccounted for (total for 2009 was 782,439).
  • The average neighbourhood population is 2424, or 3039 if you exclude neighbourhoods with a reported population of 0.
  • The median neighbourhood population is 2216.
  • Oliver and Downtown are the only two neighbourhoods with a population greater than 10,000.
  • More dwellings are owned (192,171) than rented (121,953).

ShareEdmonton

Another reason having this data in CSV is useful is because app developers can more easily integrate it into the things they are building. For example, all the census data is now available at ShareEdmonton! So when you view a neighbourhood, you’ll see the census data on the right side (see Alberta Avenue for example). You can also browse neighbourhoods by population. I’ve also fixed the neighbourhood search, so it works better now.

This is just the first of a few neighbourhood-related updates this month, so stay tuned for more!

Apps4Edmonton

Yesterday the City released more information on the Apps4Edmonton competition. The first phase, from now until May, is “accepting community ideas”. Basically they want you to tell them what data you want. Aside from the obvious “we don’t know what we don’t know” problem, I think the community has done a pretty good job of defining desired data sets already.

They City had a great start in January with the launch of the data catalogue, but we need more data. Especially data like the census data, which myself and many others have been asking for since the day the PDFs were released. There are clearly some internal issues that need to be worked out if I was able to acquire this before the open data team was. I hope they get everything resolved for the competition, because it’ll be a pretty boring one if we still only have twelve data sets (New York and other cities had dozens, maybe even hundreds, before their competitions).

That said, I know there are passionate, smart people working on it. Email opendata@edmonton.ca if you have data set requests or want to get involved in Apps4Edmonton.

In Edmonton, we like to drive

By Mack D. Male ·

Statistics Canada has released some new data from the last census that shouldn’t shock anyone who lives in Alberta’s capital city. Nearly 80% of us get to work in a vehicle:

The new data from the 2006 census found that 12.7 per cent of workers in the city of Edmonton get to work using public transit, while 79 per cent either drive or travel in a vehicle as a passenger.

Statistics Canada said the reliance on cars seems to increase with the age of the commuter. While those under the age of 25 travelled by vehicle 70.7 per cent of the time, that rate increased to 81.6 per cent for those aged 25 to 34. The rate was even higher for those aged over 35, at 87.2 per cent.

Cheap Gas?

The average Alberta commuter takes a car 84% of the time, so we’re slightly better than the rest of the province.

I guess Bob Boutilier, our city’s Transportation Department GM, wasn’t kidding at the ETS conference a few weeks ago when he said a big challenge is the “pickup truck and two car” mentality of most Albertans. Thanks to the census data, I now have a number to attach to that statement.

Some people like to suggest that we’ll never improve our public transit system until everyone experiences just how bad it is right now. Maybe there’s some truth to that after all. I wouldn’t be surprised to learn that the majority of that 80% have never been on a bus or LRT car.

That needs to change.