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
2. Property Assessment Value
3. Road and Sidewalk Conditions
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
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
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
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.
27 comments:
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.
Very interesting, though I think you need to expand your maps to include the area south of Ellerslie road.
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".
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.
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.
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.
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.
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.
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.
cool maps, would love to have seen my are in there...Hamptons/Glastonbury
You could always find a strong correlation between school achievement scores and proximity to river valley and ravines. It's about income.
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?
Thanks for naming Donsdale the best neighborhood in Edmonton. I completely agree!
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!
Is your spreadsheet data used to make the maps available?
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!
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.
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 .....
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.
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
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
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/
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 ) //
[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
Its a miracle that I am alive today. I encounter HERPES SIMPLEX VIRUS (HSV1/2) for good four (4) years, six (6) months and twelve (12) day with my calculations, before I meet the great Dr Sambola. I am Randy empiral from Fresno California, united state of America and I was affected with herpes virus.Herpes is a viral infection cause by the Herpes simplex virus, marked by painful, watery blister in the skin or mucous membrane or on the genitals. This was what I suffered for good four years. I have visited CVS Pharmacy in Fresno for treatment but no improvement. I meet Dr Sambola online while I was searching for herpes cure I read a testimony about his work. I give a try that now becomes a testimony in my life. I contacted him through WhatsApp +2347011451611 email sambolaherbal@gmail.com
Reputable Cryptocurrency Recovery expert// PRO RECOVERY WIZARD SAM BANK MAN CYBER SECURITY SERVICES.
Most frequently asked question by investors after losing Bitcoins to fraudsters, is how possible is it to recover the lost Funds. I happened to become a scam victim last summer. I became interested in Cryptocurrency trading last summer and decided to trade $750,000 worth of crypto through an online software company which promised huge returns. Everything went wrong after they transferred all my funds from my coin base wallet to an unknown wallet address. I immediately had a search out on a reliable option to recover the funds back. I came across PRO RECOVERY WIZARD SAM BANK MAN CYBER SECURITY SERVICES, a specialized Expert in Cryptocurrency Recovery services. I must say I have good fortune, all my lost funds have been recovered back all thanks to PRO RECOVERY WIZARD SAM BANK MAN CYBER SECURITY SERVICES. To any victim who has lost Crypto to fraudsters I will recommend you to retrieve your lost funds.
CONTACT INFO; Email..Recoverywizardsambankman@cyberservices.com
(recoveryhacker101@gmailcom) is a skilled crypto retrieving agency.
Post a Comment