Which area of England has the densest network of off-road cycle routes? Until recently, I would have had no idea how to answer this question. But with Overpass API, Datawrapper, and an LLM, I found it surprisingly easy to whip up some results.

I enjoy cycling off-road and like to plot routes that avoid roads as much as possible. Will this help me find the ideal place to live?

Map Takeaways

  • The map counts bridleways, cycleways, shared used paths, and more (see below)
  • East London and Cambridge have the highest concentration of off-road cycle routes
  • Devon has the lowest concentration
  • The map doesn’t reflect the quality of the routes in any way
  • The data correlates with population density, as urban areas tend to have more cycle infrastructure

Technology Takeaways

  • Overpass API is a powerful tool for querying geographical data
  • ChatGPT is impressively good at writing queries for it
  • Datawrapper produces beautiful chloropeth maps with minimal effort
  • OpenStreetMaps tagging has a lot of inconsistencies

Analysis

This was a fun exercise but I don’t think I would use it in deciding where to live or cycle. Ultimately there is little comparison between a mountain bike trail, a picturesque bridleway, and an urban cycleway. Although all are off-road cycle routes, each serves a completely different purpose.

Further, even if we limit our search to just one type of cyclable route, the quality of them varies hugely - even within the same area. Some bridleways are excellent, others are virtually unrideable. And I would prefer to cycle on a quiet road rather than a busy, interrupted, debris-strewn shared use path.

The Strava heatmap is the most valuable data in my opinion, as it shows where people actually ride:

Process

The rest of the blog documents how I produced the map. Here’s a link to the data.

Bridleways

The closest previous work was a site called bridleways.uk. Bridleways are horse-riding routes which cyclists have also been allowed to ride on since 1968. My initial idea was to grab the per-county bridleway length calculations from that site, but I wanted to go to the source of the data. This would allow me to include all off-road cycle routes, and show the availability of those routes in smaller areas across the country.

Bridleways.uk gets some of its data from rowmaps and the rest from OpenStreetMap, a community-driven map database that is particularly good for outdoor mapping like hiking trails and cycling routes. OpenStreetMap data is used by platforms like Strava and Komoot.

Overpass Turbo

I found Overpass Turbo, a resource for freely querying OpenStreetMap data. Overpass has a tricky query language which ChatGPT was awesome at assisting with.

OpenStreetMap uses the term “highway” as a catch-all for roads, paths, and tracks. Highways are tagged with information about their designation and who is permitted to use them. By navigating to a part of the map you know well and running the following query, you can view the tags on all the highways:

Inconsistent Data

Exploring the OpenStreetMap tagged data, I discovered it was often inconsistent and confusing in terms of how it indicated cycle access. Partly I think this is due to it being a community map with different users adding different tags to represent the same information. It’s also probably to do with how complicated the access situation is in England (and the rest of the UK, besides Scotland). The following are places where you can usually ride your bike:

  • bridleways
  • restricted byways
  • BOATS (byways open to all traffic)
  • shared used paths
  • permissive paths
  • cycle tracks
  • canal towpaths

The following is marked as a bridleway but (presumably incorrectly) with a designation of public_footpath:

Meanwhile the following is a bridleway, but a local bylaw prohibits cycling, and the tags correctly show this:

The following is a track, a kind of miscellaneous highway, which is on private land, but with permissive bicycle access:

That’s one of the best cycle routes in the area, and if you are just looking at bridleways or cycle paths, you’ll miss it. So writing a query to capture all these highways is not immediately straightforward.

Length Query

Bearing that in mind, I enumerated all the ways that off-road cycle routes are represented and summed the length of them in a given area. The resulting Overpass query is not perfect but provides a close enough approximation.

I tested on the county of Surrey, and the query returned 11190 cyclable ways with a total length of 2070 kilometres.

Ceremonial Counties Density

ChatGPT helped me with a small script to run this query for each of the 48 ceremonial counties in England. I fetched a list of counties together with their areas from here.

I had some trouble with the OpenStreetMap data, since Hertfordshire, Norfolk, Suffolk, Worcestershire, Warwickshire, Shropshire, Northumberland, Greater Manchester, and the City of London were not marked as ceremonial counties, so those areas had to be selected using an administrative boundaries tag.

I also got a surprisingly low density result for Tyne and Wear. It turns out that the area figure reported on the website above was missing a zero, and after correcting that Tyne and Wear is one of the top counties.

I then plotted the results using Datawrapper:

Cool! Datawrapper helps you make really nice visualisations with relatively little effort. However…

Density Limitation

An obvious issue with the Cyclable Density metric is the strong correlation it has with population density (r/peopleliveincities). Urban areas are more likely to have cycle infrastructure, therefore the map ends up resembling a population density map:

Nevertheless, there’s still some observations that can be drawn. For instance, Essex, Kent, and East Sussex are clearly behind the rest of the Home Counties for off-road cycle routes. Wiltshire and Dorset on the other hand are doing pretty well.

Per capita

Attempting to compensate for the urban density effect, I divided the cyclable length by population instead, to get the per-capita provision of off-road cycle routes:

This completely changes the map, with urban areas now having the lowest scores. This map highlights that Cumbria is the place to go if you want cycle routes all to yourself!

Local Authority Districts

The county area data is not really granular enough, so I went a level deeper by mapping local authority districts. There are 296 local authority districts in England.

Learning my lesson from before on inconsistent OpenStreetMaps tagging, I found what appeared to be a definitive way to query districts using GSS codes. I pulled a list of the districts mapped to GSS codes from here and joined that up with areas from Wikipedia.

Once again however I had to special-case some districts with an administrative boundaries tag selector. OpenStreetMaps does not seem to have up-to-date GSS codes tags for East Staffordshire, Lichfield, Stafford, Staffordshire Moorlands, Tamworth, North Warwickshire, Nuneaton and Bedworth, Rugby, and Warwick.

Link to script used to produce the map at the top of the blog.

Large Area Limitation

Even breaking the areas down into local authority districts, there’s an enormous variation in areas of the districts - from North Yorkshire at 8037km2 to City of London at 3km2. Adding to the urban area skew, the larger areas may contain great off-road cycling areas that are diluted by large empty areas of farmland.

The formal term for this seems to Modifiable Areal Unit Problem (MAUP): referring to statistical distortions that appear when spatial data are aggregated into areas that differ greatly in size or shape.

Why only England?

What about cyclable density in the rest of the UK? Since 2003 Scotland has been way ahead of England, with broad access rights for non-motorised vehicles over the countryside. Looking at the official routes in Scotland doesn’t capture the far greater density of legally accessible land for cycling. Disappointingly, although England implemented a limited right-to-roam over moorland in 2000, this applied to walking only.

I didn’t look at Wales and Northern Ireland because they use different administrative boundaries and it was easier to focus on England for this initial analysis. A look at bridleways.uk shows that Northern Ireland has very few bridleways, while Mid Wales seems to have a good network of them.

Future Work

It shouldn’t be too difficult to adapt the scripts here to produce maps for footpaths and other amenities.

I would like to break the data down further to be more granular than just local authority districts - the next lowest administrative division in England is civil parishes.