The Great British Bike to Work

cycle_thumbnail

Here’s a little visualisation created with the DataShine platform. It’s the DataShine Commute map, adapted to show online cycle flows, but all of them at once – so you don’t need to click on a location to see the flow lines. I’ve also added colour to show direction. Flows in both directions will “cancel out” the colour, so you’ll see grey.

London sees a characteristic flow into the centre, while other cities, like Oxford, Cambridge, York and Hull, see flows throughout the city. Other cities are notable for their student flows, typically to campus from the nearby town, such as Lancaster and Norwich. The map doesn’t show intra-zone (i.e. short distance) flows, or ones where there are fewer than 25 cyclists (13 in Scotland as the zone populations are half those in England/Wales) going between each origin/destination zone pair – approximately 0.15% of the combined population.

Visit the Great British Bike to Work Map.

DataShine Papers!

ds_paper

If you are looking to name-check DataShine in a paper, then we now have the citation for you!

  1. Interactive mapping for large, open demographic data sets using familiar geographical features is our paper (authors Oliver O’Brien and James Cheshire), published in Journal of Maps, as open access, so you can read it right now.  
     
    DOI: 10.1080/17445647.2015.1060183

    Citation: O’Brien, OGT; Cheshire, J; (2015) Interactive Mapping for Large, Open Demographic Datasets using Familiar Geographical Features. Journal of Maps (in press, published online)

  2. There is also a paper published by a colleague at the UCL Centre for Advanced Spatial Analysis (CASA), Duncan Smith – Online interactive thematic mapping: Applications and techniques for socio-economic research. It’s published in Computers, Environment and Urban Systems. Duncan reviews DataShine as well as a number of other ways of mapping large demographic datasets. It includes statistics on our user-base that you won’t have seen announced/published anywhere else. This paper is also open access. 
     
    DOI: 10.1016/j.compenvurbsys.2016.01.002

    Citation: Duncan A. Smith, (2016) Online interactive thematic mapping: Applications and techniques for socio-economic research. Computers, Environment and Urban Systems 57:, pages 106-117.

DataShine Wins the BCS Avenza Award for Electronic Mapping

bcsavenza

DataShine Census has won the British Cartography Society’s Avenza Award for Electronic Mapping, for 2015. The glass trophy and certificate were presented to DataShine creator Oliver O’Brien at the award ceremony and gala dinner for the combined BCS/Society of Cartographers conference “Mapping Together” which took place in York, earlier this September. The prize was presented by Peter Jones MBE, the BCS President.

Additionally, DataShine Election was Highly Commended for the Google Award for mapping of the UK General Election 2015.

The book “London: The Information Capital” which DataShine PI James Cheshire co-authored with Oliver Uberti, won three awards at the same ceremony, the Stanfords Award for Printed Mapping, the John C. Bartholomew Award for Thematic Mapping (for Chapter 3 of the book), and the meeting’s grand prize, the BCS Trophy. Dr Cheshire was on hand to receive the trophies and certificates.

The awards cap a successful year for the DataShine project which has seen hundreds of thousands of viewers, several key media articles and four key websites launched, along with a number of variants, most recently including DataShine Scotland Commute which was commissioned by the National Records of Scotland. Full details of the project can be found on the project blog.

bcs_datashinecertificates

Demographics of the Borders Railway

bordersrailway

The Borders Railway opened last week – a 30 mile new railway running between Edinburgh and the Scottish Borders, which was for the last fifty years the largest populated region in the UK without a railway connection. The railway largely follows the route of the Waverley Line, which used to connect Edinburgh to Carlisle via the Borders (Galashiels and Hawick) before it was axed in the 1960s. The new line is highlighted in the map above, as are the small stations that lead to central Edinburgh at the end of the route. Galashiels is the penultimate station, with Tweedbank, a suburb of Galashiels, being the terminus.

This post looks at the pre-opening (i.e. Census 2011) commuting patterns between the western Borders towns, both those now connected to the new railway and those nearby but not linked, and Edinburgh. It’s a commute pattern that is personally interesting to me as I have childhood memories of waiting various “Munros” buses to come over the hills from the Borders, to get into Edinburgh. It also looks at the relative deprivation scores and potentially related census characteristics, between the towns.

The graphics here are from our newly launched DataShine Scotland Commute which shows travel-to-work flows as straight-line origin/destination maps – it should be noted they don’t include any transnational commutes, e.g. from the Borders towns into Carlisle in England. For that, you need the DataShine Region Commute. The Borders council area is shaded in blue.

Here are four maps from towns (and surrounding areas), in the Borders region, near each other and approximately equidistant to Edinburgh, showing the flows out to work from people living in those areas (red) and flows in to work there from people living outside (blue). The four places I’m showing are, from west to east, Peebles, Innerleithen, Galashiels and Earlston.

Peebles:
peebles

Innerleithen:
innerleithen

Galashiels North:
galashiels

Earlston & surrounding area:
earlston

Notice the odd one out?

Galashiels, the one of the four to which the new Borders Railway now connects Edinburgh to shows a significantly smaller level of commuting activity (as of the 2011 Census) to Edinburgh, than the other three areas, all statistical areas having approximately equal populations, and which are approximately the same distance from Edinburgh (an 45-minute drive or an hour-long bus journey). You can see an interactive version for all four, and indeed anywhere else in Scotland, here. Instead, it shows most commuting activity remaining within the Border valleys. It has a much weaker social connection to Scotland’s capital city.

N.B. In Earlston’s case, the small population in the town means that local rural communities are also included in its data point. Conversely, Galashiels’ large population is split into three, I’ve chosen the northern one which is a little closer to Edinburgh and also likely includes Stow, a small village to the north and the next stop on the new Borders Railway. The other Galashiels areas are broadly similar in terms of their commuting patterns.

Looking at DataShine Scotland which looks instead at the “static” aggregated small-area Census data rather than the flows above, we can begin to understand more about the demographics of each of the four towns and why Galashiels Edinburgh links are weaker. Galashiels’ population is generally younger and less likely to be married. People of Galashiels are also less likely to declare themselves of being of “very good health” than the other three areas. A younger, less healthy population is potentially indicative of a more deprived area, this is confirmed via mapping the Scottish Index of Multiple Deprivation (SIMD) 2011. Galashiels has both more and less deprived areas (red and green), but stands out against Peebles, Innerleithen and Earlston, who are generally green/yellow and so do not have a significant deprived area.

So perhaps poorer Galashiels, having little existing interaction with affluent Edinburgh, stands more to gain from the new, regular and fast connection to Scotland’s capital city, and that the new connection will, if it is used well, likely have a significant social impact on Galashiels and its fortunes, more so than would be gained from improving the other Borders towns. Renewed railway lines, as a method to transform the wealth of areas, is likely demonstrated by the dramatic effect on fortunes and house prices along the East London line in north-east London, following the reinstatement of the railway line there, and perhaps Galashiels and the surrounding areas will also see a step-change in the years to come?

Map data Copyright OpenStreetMap contributors 2015. Census data from NRS, Crown Copyright and database right 2015.

Extra Detail in DataShine Commute

scotlandcommute_detailed

We’ve made three changes to the DataShine Commute websites:

  1. For DataShine Scotland Commute we have made use of a new table, WU03BSC_IZ2011_Scotland, published recently on the Scotland’s Census website, which breaks out small-area journeys by mode of transport, in the same way that the England/Wales data does.
    The small-area geography used, Intermediate Geography “IG”, is broadly equivalent to the MSOAs used in England/Wales although the average population is half the size, so we show the lines twice as thickly. There is some additional grouping in the Scotland data – metro services (i.e. Glasgow’s Clockwork Orange) are combined with rail, and commutes by taxi and motorbike are moved into “Other”.

    Looking at the data reveals some characteristic patterns which might be expected, for example, on the edge of Edinburgh, the commute to that point is from outside of the city, and from that point to closer in to the city centre. This effect is strongly also seen around London.

  2. For DataShine Commute (England/Wales) we now include numbers, in the summary table for each area, for commuters living in that area who work in Scotland, in Northern Ireland, outside the UK, at home, in no fixed location or on offshore installations.
    These numbers, along with those for people who work elsewhere within the area, are shown in grey in the table. None of these seven special categories are shown as lines on the map.

  3. Finally, we have expanded and renamed, to DataShine Region Commute, the previous map of commuting flows in Scotland which we introduced last month alongside DataShine Scotland. The previous map was at a coarse level (showing only flows between local authorities) and was intended to be a stop-gap until the above more granular data was released. Rather than removing this website, we have decided to expand it to include the data from England, Wales and Northern Ireland too, and show flows between these places as well. This was generally straightforward to do as the Office for National Statistics published a UK-wide table at local-authority level. Constructing the Northern Ireland part of the map was less trivial as the local authority boundary files there are not straightforward to obtain, and needed to be derived.For visual clarity, we have colour coded the different nations within the UK.

We have also taken the opportunity to upgrade almost all the DataShine websites (see list on the left!) to use OpenLayers 3.8.2, the most recent release of the rapidly evolving mapping library. The new version has a lot of changes, which we’ve tried to work with (such as ol.format.TopoJSON() and ol.View.fit()) but may have missed something, so if you see any new bugs on a DataShine website let us know in the comments.

Announcing DataShine Scotland

dsscotland4

We are delighted to announce the launch of DataShine Scotland! Using data from Scotland’s Census 2011, we have mapped over 1000 metrics (covering 70 topics) for Scotland’s 46,351 census output areas.

While many of Scotland’s Census questions (and the resulting data) were harmonised with the England/Wales census (mapped here), there are some differences. For example DataShine Scotland maps Gaelic-speakers, those who stated their religion as Church of Scotland, and provides Travel to Study data. We have also included some additional metrics, such as the distance travelled to work.

dsscotland3The website is based on the DataShine platform so it offers the same functionality as our England and Wales mapping (including PDF map export and custom colour palettes), but with a number of customisations like quick links to a selection of eight Scottish cities (these appear in the panel at the bottom of the website). We’ve added a few innovations too, such as using specimen postcodes to identify a “real world” name for each output area. The selected census data on each area, and its specimen postcode, are displayed automatically when “mousing over” the map.

We have also taken the opportunity to slightly simplify the user interface, allowing the map itself to continue to be the dominant feature of the website. The website takes full advantage of the DataShine “look”, with the census choropleth maps shining through the detailed building shapes across the country. Roads, railways, rivers and seas, along with area labels, are then added for context. The Ordnance Survey has provided the building shapes and other geographical detail that we use, through their Open Data suite of products.

We are additionally now launching DataShine Scotland Commute. This website maps the travel-to-work flows between the 32 council areas of Scotland as well as to/from England/Wales (see here for the within England/Wales flows). The flows can be split out by 10 different modes of transport. We hope to include finer-grained commuting patterns for Scotland, should the relevant metrics become available in the future.

DataShine Scotland and Scotland Commute were part-funded by National Records of Scotland (NRS) in consultation with Scotland’s Census. Further information about DataShine Scotland and DataShine Scotland Commute can be found on our dedicated page and we welcome feedback via our comments page.

dsscotland2

Images: Top – Just under 5% of journeys to work in Edinburgh by bicycle. DataShine Scotland highlights the areas where those people live. Middle – A view of the dynamic colour ramp and constantly updating metadata display, in the Key panel. Bottom – The volume of commutes into, and out of, Glasgow, from neighbouring council areas.

DataShine Scotland, and the screenshots here, include imagery that is CC-By OpenStreetMap contributors, Crown Copyright and Database right Ordnance Survey, and Crown Copyright National Records of Scotland.

DataShine and GeoJSON

A recent addition to DataShine’s functionality is the ability to drag and drop geoJSON (and KML) files onto the web map. This video tutorial shows how you can use the excellent geoJSON.io website to create a file for use on DataShine. I created the tutorial for a first year undergraduate field class (so I refer to fieldwork in it) but I thought it would be of wider use to the DataShine user community.

OpenLayers 3

ds_ol3

This post is cross-posted from oobrien.com.

OpenLayers is a powerful web mapping API that DataShine uses to display full-page “slippy” maps. DataShine: Census has recently been upgraded to use OpenLayers 3. Previously it was powered by OpenLayers 2, so it doesn’t sound like a major change, but OL3 is a major rewrite and as such it was quite an effort to migrate to it. In due course, we plan to migrate the other DataShine websites to OpenLayers 3 too, although each website is quite different under the covers so will prove a challenege too.

Here are some new features, now in DataShine, which are made possible by the move to OpenLayers 3.

Drag-and-drop shapes

One of the nicest new features of OL3 is drag-and-dropping of KMLs, GeoJSONs and other geo-data files onto the map (simple example). This adds the features pans and zooms the map to the appropriate area. This is likely most useful for showing political/administrative boundaries, allowing for easier visual comparisons. For example, download and drag this file onto DataShine to see the GLA boundary appear. New buttons at the bottom allow for removal or opacity variation of the overlay files. If the added features include a “name” tag this appears on the key on the left, as you “mouse over” them. I modified the simple example to keep track of files added in this way, in an ol.layer.Group, initially empty when added to the map during initialisation. Note: The file you drag on should be in WGS84 lat/lon format (aka EPSG:4326) or WebMercator (aka ESPG:900913 or EPSG:3857). It will not work with the British National Grid projection (aka EPSG:27700).

Nice printing

Another key feature of OL3 that I was keen to make use of is much better looking printing of the map. With the updated library, this required only a few tweaks to CSS. Choosing the “background colours” option when printing is recommended. Printing also hides a couple of the panels you see on the website.

Better looking controls and smoother zooming

OL3 also has much smoother zooming, and nicer looking controls. Try moving the slider on the bottom right up and down, to see the smooth zooming effect. The scale control also changes smoothly. Finally, data attributes and credits are now contained in an expandable control on the bottom left.

A bonus update, unrelated to OL3, is that I’ve recreated the placename labels with the same font as the DataShine UI, Cabin Condensed. The previous font I was using was a bit ugly.

For notes on UTF Grids and Permalinks, both of which required a lot of work to reimplement so that DataShine with OL3 behaves like the version with OL2, see the developer blog post.

ds_ol3overlay2

Above: GeoJSON-format datafiles for tube lines and stations (both in blue), added onto a DataShine map of commuters (% by tube) in south London.

How do England & Wales Stay Warm?

centralheating_1

One of the more spatially interesting datasets on DataShine: Census is about central heating – do houses have it, and what is the fuel source? The table is QS415EW and here’s what one of the categories – proportion of houses with gas central heating – looks like on DataShine (and above). You’ll notice a distinctive pattern, with city centres and the countryside having low proportions of houses with gas central heating (yellow), while city suburbs and towns have much higher proportions (red). City centres may have these low values because they contain either very old houses (which never had it) – and/or very new houses that use more modern forms of central heating, are much more highly insulated, or are blocks of flats where gas central heating systems are perhaps considered dangerous now. In rural areas, some of these places maybe never had a connection to the gas main anyway. It’s the city suburbs, the big expansion of the 60s/70s, where gas central heating was always put in by default.

Oil central heating, being more expensive, is rare in urban areas but a practical necessity in the countryside, such as in rural Wales. Solid fuel is popular in Northumberland.

Barrow Island in the Lake District and Aberdaron in Wales are the two wards that have the highest proportion of households with no central heating at all. Many of the houses in the area at least are holiday houses, which are presumably mostly populated in the summer. It could be a bit chilly there in the winter!

See the live map on DataShine now. Change the fuel type at the No. 3 drop-down on the top right.