Flow Map Layout

I've been experimenting with mapping flow data (again) and this time have been looking at Flow Map Layout, by Phan et al. at Stanford. There is a short paper on it, and a slideshare presentation, but basically it offers a slightly different approach to flow mapping.

I experimented using UK commuting data for 2001. I looked at the top 50 flows (by district) into Greater London. This equates to more than 550,000 commuters going in to London but it excludes intra-London moves obviously. It's a bit tricky at first when you are trying to get used to it but when you do you can produce some nice images... Click on the image below to see it full size.

You can move things around in the (basic) mapping interface and it is actually quite flexible. There are some display options for colours and edge routing, etc.

The largest inflow was from Epping Forest, with around 26,000 commuters.

Local Enterprise Partnerships in England

Some recent news from England, where the Government has announced that 56 proposals for Local Enterprise Partnerships have been received. Although they are not similar in scale to the previous regional structures, there is evidence that they have some functional basis.

Among the proposals are Liverpool City Region, Kent and Medway, 'Enterprise M3' (covering parts of Hampshire and Surrey), 'Gatwick Diamond' and Sheffield City Region. All this came about because of a letter Vince Cable and Eric Pickles sent to Local Authority and Business Leaders in June 2010.

Interesting snippets from the letter include 'separate arrangements will apply in London' and 'the Coalition Government is determined to rebalance the economy towards the private sector' and - interestingly - 'we wish to enable partnerships to better reflect the natural economic geography of the areas they serve and hence to cover real functional economic and travel to work areas'.

Given this last statement, the list of the proposals submitted begins to look more interesting...

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