Saturday 30 April 2011

Google Fusion Tables

A short post today about the wonderful Google Fusion Tables. It may sound baffling, but Fusion Tables are basically a service (provided by Google, obviously) that allows you to manage and map large databases 'in the cloud', as they say. In plain speak, you can upload large tables of data and display them and map them and share them. For someone like me who is into mapping data, this is great because all you need to do is get your data into kml format. This can be done with normal GIS software like ArcGIS but the best way I have found is to use shpescape.



The example above is just something I created a couple of years ago in ArcGIS and then recently uploaded to Fusion Tables. It's a 'tile finder' for Ordnance Survey data so you can figure out which 20km tile you need to get based on which area you are interested in. This is not the point here though - I'm just showing how you can get data into google map format very easily.

If you work with lots of data on a regular basis - and particularly any mappable data - you should take a look at Fusion Tables...

Tuesday 12 April 2011

The IMD in 3D

Before I move on from experimenting with the deprivation data from the new English Indices of Deprivation I thought I'd do a 3D version, just for fun. The images below are the results of my experiments. The first image has labels for various places. The second image does not and is also at a higher resolution.



When you add a third dimension certain places stand out more (e.g. coastal areas) but there is a balance to be struck here, as always... That's enough IMD mapping for now!


Friday 8 April 2011

The Domains of the IMD

What most people look at when they see the Indices of Deprivation is the combined Index of Deprivation score and rank for each area. I do this too, but it's always interesting to examine the individual domains to see how areas rank and what the spatial patterns look like. So, time for a map on all of this... (click to enlarge)



In the above image, you'll see that I've produced a raster map for each of the different domains of the English IMD 2010 and that each is sized according to the percentage weighting it gets in the final IMD. There are some interesting differences between domains which, by the way, are covered in Chapter 3 of the technical report.

Income and employment account for nearly half of the weighting for the final IMD score so these maps look pretty similar to the overall IMD map but there are interesting differences with other domains, in particular Barriers to Housing and Services. This picks up a lot of rural areas but also many in London and some other urban locations. Health deprivation and disability also differs from the final IMD map with a more obvious north-south / coalfield pattern. Finally, the most deprived LSOA on each domain is as follows...
  • Income: E01005482 in the Central and Falinge ward of Rochdale
  • Employment: E01005482 in the Central and Falinge ward of Rochdale
  • Health and Disability: E01005482 in the Central and Falinge ward of Rochdale
  • Education, Skills and Training: E01013640 in the Braunstone Park ward of Leicester
  • Barriers to Housing and Services: E01000604 in the Stonebridge ward of Brent
  • Crime: E01005454 in the Waterhead ward of Oldham
  • Living Environment: E01001780 in the Hoxton ward of Hackney
The fact that these domains are in different spreadsheets makes mapping it all a bit more time-consuming but since I combined them all anyway I decided to create raster versions just to provide a more fluid overview of the patterns across England. I'm sure I'll keep milking this data for a while!

Sunday 3 April 2011

Scottish Index of Multiple Deprivation 2009 - Google Map

Recently I've been experimenting with google fusion tables and the mapping and database opportunities they present. One dataset I used for this was the new English Indices of Deprivation for 2010 - something the Guardian picked up. This was only really a quick experiment (literally done over an hour or so) but I was impressed with the capabilities.

Since, I'm from Scotland I also did a Scottish version - click the image below to go to the test site. Again, this is only experimental but I find it useful for exploring the data in an easy to use manner.



Technical note: this also led me to discover the amazing shpescape aka Shape to Fusion for converting shapefiles to fusion format - code which was written by Josh Livni at google. Enough nerdspeak for now.