A national map of cycling to work

I've recently being doing some visualisation work with the newly released Census commuting data from 2011. I've produced maps of all travel to work, and travel by car, train and bus. I've now done a map of cycling to work (below). This map is particularly interesting in relation to the patterns it reveals but also in relation to the strange long-distance flows we can see. I'm certainly not saying that anyone actually commutes by bike between Manchester and Bristol, as the map may suggest. Click on the big version and have a look around to see if you can spot anything interesting or particularly unexpected. A version with some place name labels can be found here.

Go to the full size version

This data comes from Question 41 of the 2011 Census form, which asked people to say how they 'usually' travelled to work in relation to the mode of transport which accounted for the largest part, by distance, of their journey. The results can look quite beautiful on a map, but they can also be confusing. Look closely at the map above and you'll ask yourself why there are so many long distance cyclists in England and Wales. More seriously, you might begin to question the validity of the data, the honesty of respondents or some other aspect of the results. 

The ability to interrogate datasets in this way is one of the strengths of visualising large datasets in that we can often immediately identify anomalous patterns or results that confound expectations or are just plain wrong. I'm not entirely sure what's going on with the long-distance flows. Perhaps some people take their bike on a train so ticked the 'bike' option, despite the train journey being longer. Perhaps some people live in one part of the country during the week and cycle to work there but then live at their usual address during the weekend and this is registered as their residence on the Census forms. I'm only speculating but this could be one possible explanation. 

In the image below, I've filtered the data so that only flows of 2 or more are shown. This significantly reduces the visual clutter, but also draws out stronger long distance connections between places such as Bristol and Manchester, and indeed Manchester and lots of other places. Take a closer look by clicking the link below this map. I've added some place names to this map to help with orientation.

Go to the full size version

I'd be keen to hear different interpretations on the data. You get similar results when you map the 'walk to work' data so there's definitely something interesting going on with how people have answered the Census question and the data we have to work with. I'm certainly not saying it's 'wrong', more that we need to understand what exactly it tells us. For now, I'll leave it at that.

N.B. Why didn't I include Scotland and Northern Ireland? The data are not out yet. It's not some ploy to exclude anyone and I know the blog title says 'national' so forgive me if that threw you. I intend to expand the analysis in due course.

Toddlers, teens and yoofs - where are they?

I've been doing some work on child poverty and social mobility recently, and part of this has involved looking at simple stats like the percentage of people in each area who are under 18. This has given me a better insight into which areas might be most affected by children's issues and policies. I've been looking across Great Britain but focusing on England and Wales and so I thought I'd just post a couple of maps showing the % of children across London Boroughs and the core cities - see below.

Bigger version for London

The results are quite striking - and particularly interesting I think are the differences between and within the core cities. What is also very interesting is the spatial divides in terms of which areas have a high concentration of children and which don't. These data overlap with many other datasets - which is partly what I'm looking at in my research right now - but this post is simply about the two maps.

Bigger version for core cities

One academic-related thought on this, though. I've been looking at the literature on neighbourhood effects over the past few years and following with interest the debate on where people 'choose' to live. This got me thinking about who might not get to choose, and children is one obvious group. As you can see from the maps there are large areas where 25% or more of the residents are children, and some areas where it is nearly 50%. Also interesting for me is the extent to which city centres in (e.g.) Liverpool, Birmingham, Manchester and Leeds are largely child-free - possibly linked to the concentration of students and new city centre living. Anyway, that's enough for now.

Technical note: this is done at the lower super output area level and for the local authority boundaries of the English core cities, plus all of Greater London. The data are from 2011 Census table KS102EW.

Population growth in Manchester city centre, 2001 to 2011

Manchester city centre experienced a population explosion between 2001 and 2011. In the area covered by the map below the population increased by nearly 400% - from 5,957 to 23,295; a rise of 17,388 people.  In 1991, the same area (roughly) had a population of 2,887, as you can see here. Anyone who knows Manchester will know about this but possibly not about the scale of the change. A lot has been written about these changes (e.g. Centre for Cities in 2006, Manchester Evening News in 2012) but it is clear that much of the growth experienced in Manchester has been driven by a new phase of city centre living. Click an area on the map to find out more about it and zoom in to the larger version of the Google map to see it in more detail.

Click for larger version of this map

But who are these new residents? Chris Allen, writing in 2006, said they might be a mix of 'counter-culturalists' from the new middle class, 'city centre tourists' from the service class and 'successful agers', who tend to be over 50. Whoever they are, they're living in the new apartment buildings that began to sprout in the perforated urban landscape of central Manchester over a decade ago.

The map above contains a total of 15 small areas known as super output areas. If you click on any area you can find out how many people now live in each. The map also tells you the total land area of each small parcel and how many households are in it. You can find more of this kind of information via the Guardian datablog and also by clicking through to the raw data on the ONS web pages. It was only released on Friday but I've been looking at it now because I'm writing a short paper on small area population change in the English core cities. Central Manchester has grown the most but other cities have also experienced rapid expansions.

A note for spatial analysts: the 15 LSOAs you see in the map above are new. They are just 15 of the 229 new LSOAs across the core cities and this makes change over time analysis a little more tricky. Manchester's total population growth during this period was just under 20% (or 80,000) so the growth in the centre accounted for just over 21% of the increase.

ESRC Success Rates 2011/12

I'm currently in the process of thinking about submitting another ESRC grant proposal. To date, I have put in a few but without success. I'm not easily discouraged though and I have had a lot of good feedback (but no money!). Thankfully, I have been able to secure funding from other sources but the vital statistics from ESRC do suggest that I might need to up my game considerably - or switch to Socio-Legal Studies! What am I talking about? Success rates of course. The LSE Impact blog just did a post on this issue and the figures really are striking. So striking, in fact, that I felt the need to turn it into a chart. Just look at the data (click charts below). 39% success rate for Socio-Legal Studies and 0% success rate for Environmental Planning (among others).

Click chart to enlarge

Click chart to enlarge

In relation to the number of submitted grants, Psychology is the clear category leader with 185, though the success rate in this category is just slightly higher than the average (16% compared to 14% average). The highest number of grants to any one category is in Sociology, with 16 awards (19% success rate) during the 2011-12 period.

See the full ESRC report here, where you can also find a break down of the figures by institution.

Mapping Methods

I've done a lot of mapping on this blog in recent months. Much of this has been about deprivation and my attempts to make more widely available maps on deprivation for different parts of the UK. For this, I've often used Google's Fusion Tables. The most recent work I've done with this data using Fusion Tables is to update the Welsh Deprivation work to include the most recent release of the Welsh Index of Multiple Deprivation from 2011. There's a screenshot below which links to a full page Google map. If you click on an area the pop-up will tell you all about it in relation to the WIMD data. This post isn't about the data but the most deprived area is in West Rhyl and the least deprived in Cardiff (Llandaff area).

But this post is about methods, so more on that before I go... The steps below relate to any kind of data I've mapped using Fusion Tables (warning: technical content!).

1. First of all I usually have to join attribute data to spatial data. I do this in ArcGIS but it works well in MapInfo too. If you're a MapInfo user and want to follow the steps below, use Universal Translator in MapInfo to convert the file to a Shapefile first.

2. I don't like overly detailed boundaries because of the large file sizes and often this exceeds the Fusion Tables file limit. So, I simplify the boundaries. For this, I use mapshaper, a great online tool. You can also use other GIS methods.

3. Then I use something called shpescape. This is a really great tool because it allows you just to zip your shapefile (i.e. the shp, shx, dbf and prj files) and then upload directly to Fusion Tables without having to convert to KML as an intermediate step.

4. Once there, all you need to do is go to Visualize / Map and then go to work customising things. This includes map colours and what appears in the Info Window pop up when you click an area. I've blogged on the Info Window code bit before.

5. If you want others to see it you must make it public. Just click 'Share' in the top right of the Fusion Table screen.

That's about it. The Info Window code bit takes a while to figure out but you can do so much with it.