How The Telegraph Used TravelTime to Highlight Access to Hospitals Across the UK

by Louisa Bainbridge
on May 7, 2020

The project

The Telegraph used TravelTime analysis to identify how many people in the UK do not have access to a coronavirus test centre within 1 hour. To do this Data Journalist Ashley Kirk needed to use software that was capable of drawing various drive time catchment areas for 43 test centres available to the public on 28 April.

Data exporting with Alteryx

For this analysis we used Alteryx, a data analytics platform. This kind of analysis work can also be done with QGIS or ArcGIS – get in touch if you need help with this.

How it worked:

  1. Get the lat/long coordinate for each test centre
  2. Added these coordinates to an excel spreadsheet
  3. Find the Alteryx Isochrones macro 
  4. Configure the macros to get drive time shapes for all 43 test centres, the shapes assumed people would travel during off peak times
    • 15 minute drive time
    • 30 minute drive time
    • 45 minute drive time
    • 1 hour drive time
  5. Alteryx outputs the shape files

This shape file was then used to make a data visualisation by Ashley at The Telegraph. Using the shape file it was possible to cross reference these catchment areas with UK population data. This meant it was possible to find out that:

More than a million people in the UK live over an hour from their nearest coronavirus testing centre” .

The final data visualisation results

Traveltime-the-telegraphSource: The Telegraph 

Interested in using TravelTime for analysis? 

Get in touch with us to chat about your project. We have plugins for QGIS, Alteryx & ArcGIS. 


 

Related

Hatch Uses TravelTime for Urban Location Analysis

Discover how global management consultancy, Hatch, is using TravelTime’s QGIS plugin to perform urban location analysis

Victoria Akinsowon Oct 22, 2020
READ

How Knight Frank uses TravelTime Analytics to Improve Location Analysis

Knight Frank use TravelTime technology to give customers the best relocation advice. Used by their Geospatial team within ArcGIS and their search tool.

Evelina Bezubec Jul 15, 2020
READ

How TravelTime Data & ImmoScout24 are Helping You Find a New Home

Let’s take a look at how ImmoScout24 and TravelTime API can make house hunting easier. Case study with examples of how to implement TravelTime.

Evelina Bezubec Jul 13, 2020
READ

Totaljobs Increase Website Conversions by 10% with TravelTime Search

How one of the largest UK job portals, Totaljobs, implemented TravelTime on their website to increase conversions by 10%.

Evelina Bezubec Apr 22, 2020
READ

IKEA's Marketing Team Uses TravelTime Analytics to Create a Drive Time Map

IKEA uses TravelTime to build a drive time map. See how their marketing team use it to adjust messaging to their audience.

Evelina Bezubec Oct 9, 2019
READ

IFS Use TravelTime Analytics to Calculate 3.2 Billion Journey Times

How the IFS created a travel time matrix of 40,000 origins to 40,000 destinations for both driving and public transport using the TravelTime platform.

Louisa Bainbridge Apr 16, 2019
READ