Economic Deprivation in London

I've recently been doing some analysis of the Economic Deprivation Index for England, focusing on a number of different cities. This is part of some research I'm doing into concentrated disadvantage more generally so I thought I'd just post a map showing the data for London in 2005.

The map below shows data for the EDI in London in 2005. It's pretty similar to what you'd expect but it does make interesting viewing... If you click the image it will open up full size in your web browser.


That's all for now, but I plan to post more like this in future.

Save as DBF in Excel 2007

One common problem for ArcGIS users over the past few years has been the decision of Microsoft not to allow users the option of saving files in dbf format from Excel 2007. It's not a problem if you are still using Excel 2003 but if you only have Excel 2007 it makes what was previously quite simple a lot more difficult.


One tool I've recently used is an Excel Add-In produced by Gyula Gulyas from theXLwiz blog. There are some useful dbf videos on his youtube channel which is, possibly, the only one in the world to combine videos about dbase file formats and videos of cheerleading!

Anyway, I have the tool. It cost me £17.34 ($25 USD) but it has been worth every penny. I know there are other options and I've tried some of them, but the Gulyas tool is so simple and effective and results in very compact file sizes. I highly recommend it!

A Nearest Neighbour Index of Multiple Deprivation

I've blogged before about my attempts to add a more spatial dimension to the existing Indices of Deprivation for England. In this post, I have decided to share the data for my calculations on a Nearest Neighbour Index of Multiple Deprivation, following the method described in this paper.

The image below shows the IMD2007 (left) and NNIMD2007 (right) for Birmngham, with red most deprived and blue least deprived.

I have put together a spreadsheet containing the original IMD data plus my NNIMD data for all 32,482 LSOAs in England. If you click on the links below you can access the data - you'll need to click the 'download' link to get the data.

NNIMD dataset - Excel 2003 version (.xls)

NNIMD dataset - Excel 2007 version (.xlsx)

Creating Cartograms - Some Options

One of the most difficult things to do properly with GIS is to create cartograms. They can be very powerful visually (e.g. Worldmapper, see below) but producing accurate representations is not simple. I've been experimenting with this over the years, and have now come to some conclusions...


You could use something like MAPresso to create cartograms but it's not necessarily the easiest application to get into. If you're an ArcGIS user you could try the CartogramCreator extension.

However, I've recently experimented with ScapeToad and have found it to be the best tool. It's stand-alone software for producing cartograms (despite the funny name) and it works really well and there are many useful options for creating cartograms. It's very easy to use as well.

European Geodata - NUTS, etc.

Need to find digital boundaries for the European Union? Tried googling but no success? They are of course available via UKBorders in the UK but if you can't get them this way then you can find them via search but it's not that easy.

The first thing you need to do is go to the Eurostat Geodata pages. Then from the menu on the left you can select 'Reference' or 'Archive' to get to the download section. Once you're there you just need to click on the kind of data you want (e.g. 'Administrative units/statistical units') and you are taken to the download page where there are lots of links...

And that's it.

Some interesting datasets, including:

• Corine Land Cover
• Urban Morphological Zones
• Degree of urbanisation
• NUTS boundaries (down to NUTS3)
• Elevation
• Settlement names

Centre for Cities - Private Sector Growth

A quick post today about some recent work published by the Centre for Cities. The report, called 'Private sector cities: A new geography of opportunity' looks at the question of private sector growth in England and the issue of whether any spatial 'rebalancing' is needed in relation to fostering private sector growth.

It was written by the Centre for Cities' Chris Webber and Paul Swinney and has had quite lot of media attention (e.g. this Financial Times article) since its publication. Worth a look - and not just because of the fancy graphics!

Sheffield Demolition

Quiet on the blogging front recently, but yesterday I had the chance to see a Sheffield Building toppled. The old Osborne Mushets on Penistone road (in street view below), was demolished to make way for new development. More changes to Sheffield's old industrial landscape.


View Larger Map

I took some photos and a video of the event...