Thursday, January 16, 2014

Just your friendly neighborhood stats!

The city of Edmonton is very statistician-friendly. As well as having the marvelous open-data catalogue, they also have detailed data sheets on every single one of Edmonton's neighborhoods

Instead of having a big preamble about how much I like Sim City, I figured I'd just jump right into what I ended up doing with Edmonton's stats. Each of the following maps is based on one of the stats collected, and show some pretty cool patterns. (Note: for all maps apart from road conditions, red indicates high values and blue indicates low values)

1. Household Income
 Income Map for Edmonton



Household income ranges from $22,000 to $146,000 average per neighborhood, and the highest income tends to be mostly focused in the southwest of the city. In the southwest it spans across both sides of the river fairly evenly, though the above-average wealth extends farther down into Riverbend and Ellerslie. On the northeast end of the city, though, you can almost trace the river by the precipitous drop in incomes from south to north. Average incomes don't pick up again until about 153rd ave.

2. Property Assessment Value

Property Value Map for Edmonton
There is definitely a correlation between household income and property value, but it isn't necessarily always present. This is particularly noticeable around downtown and just south of downtown, where lots of young professionals are making a good income but are renting. Average neighborhood property values range from $201,000 to $836,000.

3. Road and Sidewalk Conditions

Road Conditions Map for Edmonton
Admittedly, I have no idea what scale is used to measure road and sidewalk conditions. It seems to peak at around 20, and my guess is that higher numbers are good, but that's about as far as I can figure out. (note, here good roads are blue, bad roads are red).

The map for road conditions shows a non-surprising trend where the roads in the outside of the city (the newest roads) are in the best condition, and the roads on the inside are quite a bit worse. Every now and then, though, an inside neighborhood has particularly good road conditions, likely the result of recent work to fix a problematic area. Note: these values are from 2010 data, so if you feel your neighborhood isn't quite as shown in the picture, it's not my fault.

4. Hospitalizations

Hospitalization Rate Map for Edmonton
My best guess for the meaning behind these numbers is that the represent the number of hospitalizations per 1,000 people per year. In Edmonton, they range from 35 to 180.

Unlike the previous maps, the rate of hospitalizations in Edmonton isn't quite so territorial. Most of the city is sitting comfortable around the average, with a notable exception being immediately north-east of downtown (and one bad neighborhood in Mill Woods).

5. People Older than 20 without Grade 9 Education
Missing Grade 9 Education Map for Edmonton
This stat was actually alarming. Likely because I've spent a lot of time on university campuses recently, I've forgotten that some people don't graduate high school. In Edmonton, this value ranges from 4.3% to 41.3%.

This stat correlates very highly with property values and average household income, which makes sense in a way. It's very interesting to see it laid out like this on a map, and I'll leave you to your own conclusions about the ties between wealth and education are.

6. Unemployment
Unemployment Map for Edmonton

2010 Edmonton unemployment was actually fairly impressive. Neighborhood data ranged from 0% to 7.46%, but with an average of 2.69%.

Certainly a lot of the rich areas have tremendously low unemployment, but the rest of the city appears to vary from the average only in certain neighborhoods downtown, with poorer neighborhoods alternating sometimes from high to low unemployment over a distance of only a couple blocks.



I purposefully didn't include statistics that weren't averages or normalized, because though comparing the number of violent crimes between neighborhoods would also have made for a cool map, the differences in size and population would have made straight comparison a bit more difficult. I also excluded rent costs because those were based on 2006 census data, and they were so low compared to today they almost made me cry.

Neighborhood Awards!
Best place to live: Donsdale
Worst place to live: McCauley
The average Edmonton experience: Keheewin
Silliest name: Gariepy (Gary-Epi? Gary-Pee? Silly Gary...)
Least original name: Anything with "West" in it.

24 comments:

Arundeep said...

I see a similar line in household incomes along Mill Creek in NE Mill Woods. Also, that one bad neighbourhood (hospitalizations) is the Mill Woods Town Centre mall and Grey Nuns hospital area. Lots of seniors in apartments—actually the only neighbourhood in Edmonton with no single family dwellings. The peak looks like Allen Gray Continuing Care Centre, on 50 St 38 Ave.

Anonymous said...

Very interesting, though I think you need to expand your maps to include the area south of Ellerslie road.

Anonymous said...

Cool maps! I noted that most of the areas with the highest hospitalization rates are centered around actual hospitals -- where there would likely be extended care residences. Or perhaps there was some issue with the reporting of residence addresses? e.g., people admitted by ambulance may not have had a home address noted at the time, and the reporting might default to the hospital address.

I also note that on the unemployment map, one of the red areas is in Griesbach -- surprising but there's probably an explanation I'm not thinking of.

As for silliest neighbourhood name -- I would vote for "Hairsine" myself. "Gariepy" is a French name and quite easy to pronounce -- "GAIR-eh-pee".

Michael Ross said...

Thanks!

-> The area outside south of the Henday had fairly patchy data (the indicators haven't been updated since 2010), so I didn't include them. Hopefully in the future I can do an update!

-> I suspect reporting errors around hospital do have an impact on that stat, for sure. I can't think of anything off the top of my head for Griesbach, but that's definitely worth looking into.

Anonymous said...

I suspect that the high hospitalization rate in Virginia Park is because of the low population in the area. Any hospitalization will have a large impact on the numbers.

Anonymous said...

Cool charts, but I would recommend placing a scale alongside the plots. Without scales there is no way for the reader to know if the property values range from 200,000 to 500,000 or 100,000 to 1,000,000.

Anonymous said...

To further the comment requesting a scale: it's impossible to tell what the median is. Is green low? High? Yellow? Logarithmic scale? Linear?

It's difficult to put much value in graphics that obscure/obliterate the source information.

daveberta said...

Fascinating maps. Thanks for posting them.

I suspect that the red area north east of downtown on the hospitalization map is the northlands fair grounds and is a result of major events that are held there like K-days/capital ex/Klondike Days.

Anonymous said...

In 2010 Griesbach had closed as a military installation of buildings and some housing,to building a brand new residential community where construction is ongoing at present,January 2014.

Unknown said...

cool maps, would love to have seen my are in there...Hamptons/Glastonbury

Anonymous said...

You could always find a strong correlation between school achievement scores and proximity to river valley and ravines. It's about income.

Evan Noble said...

Hi, very intersting data! I've been looking through the city's data and have not been able to find what I'm looking for. I would like a tabular data set for each specific neighbourhood showing address, assessed value, year of build, house size, lot size, etc. Does something like that exist?

Mark Ballermann said...

Thanks for naming Donsdale the best neighborhood in Edmonton. I completely agree!

Trevor said...

Hey Mike, Thanks for the data (you sent me your spreadsheet a while ago). I used it in my analysis of where in Edmonton to buy a house: http://blog.whiverwill.com/2014/11/we-bought-house.html

Thanks!

Kory Mathewson said...

Is your spreadsheet data used to make the maps available?

Anonymous said...

Cool maps! PLEASE do maps of when pedestrians are robbed (muggings) - this happened to me and I bet a lot of others would like to know where this is happening!

And I'd have to say Edmonton's silliest neighbourhood name is Rapperswill - it makes me think of some kind of cheap, ghetto beer!

Unknown said...

We need the scientist of data when we are facing the difficulties of managing the big data and its authentications, or when we want to co avert the big data into summarize or graphical form, the data scientist of this activewizards.com/ can easily manage your all data problems and they can also convert your big data into summarizing form for you.

Amanda Bella said...

I Want To Appreciate Dr.OYAGU for hs great deeds, I Was Diagnosed With type 2 Herpes Virus Last year,And Was Looking For Solution To Be Cured Luckily I Saw Testimonies On How Dr.OYAGU Cure Herpes Virus I Decided To Contact Dr.OYAGU I Contacted Him He Prepared A Herbal Medicine Portion And Sent It To Me,I Started The Herbal Medicine For My Health.He Gave Me Step By Step Instructions On How To Apply It, When I Applied It As Instructed, I Was Cured Of This Deadly Herpes Within 2 weeks, I Am Now Herpes Negative.My Brother And Sister I No That There Are So Many People That Have There Same Herpes Virus Please contact Dr OYAGU To Help You Too,And Help Me To Thank Dr.OYAGU For Cure Me, I’m Cured By Dr. OYAGU Herbal Medicine,His Contact Email:oyaguspellcaster@gmail.com

Or Cell Whatsapp Number +2348101755322 thank you .....

Teresa Halminton said...

Thank you for sharing the post, it's very easy to see with the maps.
But if you are a Gmail user, I think www.Gmail.com is the website you should bookmark, in case you have email problem or want to learn some helpful tips to use email more effectively.

Anonymous said...

I am so happy today and appreciate the genuine work done by the love spell caster and give me the right direction so today I got my wish fulfilled under the guidance of a love caster Dr Jumba .  Love is an important part of our relationship. I can understand this when my boyfriend has cheated on me and engaged with other girl’s affairs. At that time I was Broken and realized the importance of love in my life or relationship. My boyfriend did not give me importance and he always embarrasses me in front of his friends. Then I searched on the Internet and I found a spell caster who i trusted and he cheated me “one day a friend of mine told me about a real spell caster who helped her with a love spell  so I got the contact number of Dr Jumba spell caster ” then I dropped a message on WhatsApp and explained all my problems to him . So he  showed me previous work done by himself and guided me on how the work will be done. Then I start work and get my boyfriend back within 24 hours as Dr Jumba promised me  in a positive way. I want to use this time to show appreciation. That's why I am so happy and thankful to Dr Jumba. he can also help you below are his contact information email : wiccalovespelltools@yahoo.com  text or call him +19085174108    . 
website :https://drjumbaspellhome.wordpress.com

Eunice Garry said...

This testimony is worth sharing to the world. I am here to tell the world of the good works of  Dr BALBOSA. My name is Olivia Bolton am from the UK.. My man left me and my kids for another older woman. It was not so easy for me.. I love my husband so much and I did not lose hope and I kept praying and God finally answered my prayers...i searched online for a spell caster to help me unite me and my lover back forever and i saw so many testimonies of  how DR BALBOSA has helped so many people online and i decided to give him a trial … I contacted him and explained to him. He told me not to worry that he will bring back my man within 24 hours. He consulted his powers and assured me not to worry . He did his work and cast the spell and to my greatest surprise, my husband came back the same day begging and crying  just as  Dr BALBOSA said. He begged me for forgiveness and he promised never to leave me for any reason. We are happy and we live together as one. Contact Dr BALBOSA now and be happy forever. dont lose hope and good luck..

EMAIL on:: balbosasolutionhome@gmail.com

WHATSAPP AND CALL: +1(206)-485-3691

WEBSITE: https://balbosasolutionhome.com

Anonymous said...

DR EMU WHO HELP PEOPLE IN ANY TYPE OF LOTTERY NUMBERS

It is a very hard situation when playing the lottery and never won, or keep winning low fund not up to 100 bucks, i have been a victim of such a tough life, the biggest fund i have ever won was 100 bucks, and i have been playing lottery for almost 12 years now, things suddenly change the moment i came across a secret online, a testimony of a spell caster called DR EMU, who help people in any type of lottery numbers, i was not easily convinced, but i decided to give try, now i am a proud lottery winner with the help of DR EMU, i won $1,000.0000.00 and i am making this known to every one out there who have been trying all day to win the lottery, believe me this is the only way to win the lottery.

Contact him via email Emutemple@gmail.com
What's app +2347012841542
Https://emutemple.wordpress.com/

Anonymous said...

Are you having issues in your relationship, Or finding it difficult to have a child of your own or are you the type having any diseases in your body. I will advise you to contact Dr. Perfect of ( Perfectlovetemple@gmail.com ).The potency of his spell is so effective and can reunite broken relationships and can also make one get pregnant no matter the situation and not only that, He also has the power to cure all types of diseases within the period of 48hours.Contact him today and thank me later. Contact details :;( Perfectlovetemple@gmail.com ) //

Unknown said...

[Please let the author of this site authorize this post]

I bought a herbal medicine from Robinson buckler. I took the herbal medicine for 2 weeks and i went for a medical checkup and to my greatest surprise i was cured from Herpes. My heart is so filled with joy. If you are suffering from Herpes or any other disease you can contact this herbal doctor today on this Email address___________________robinsonbuckler11@gmail.com