The Telegraph use 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

TravelTime Spatial Analysis Alteryx Macros

The TravelTime suite of macros takes spatial analysis to the next level, enriching Alteryx data with directions, travel cost and journey time information. Geocoding, isochrones, distance matrix & more.

Chris Hutchinson Apr 10, 2020
READ

5 ways to do geocoding for free

Discover solutions that do geocoding for free. Find out which free geocoders have the best functionality. Convert addresses and postcodes into coordinates.

Evelina Bezubec Sep 9, 2019
READ

Find smart city technology examples to help you innovate

Learn about smart city technology. See how different cities use smart city technology to improve the efficiency of the city and the services it provides.

Evelina Bezubec Aug 1, 2019
READ

TravelTime platform releases isochrone QGIS plugin

Create a QGIS isochrone using the TravelTime platform API. API keys are free to use for non-commercial purposes. You can also calculate a distance matrix and routing using the plugin.

Louisa Bainbridge Jun 12, 2019
READ

Isochrone analysis made easy

Isochrone analysis simplified. Learn how to use isochrone analysis in mapping. Improve customer service, logistics or plan an office relocation using isochrones analysis techniques. Save time and costs, and retain staff using the TravelTime platform.

Niharika Sisodia Mar 25, 2019
READ

5 retail web design tips for a store locator page

Reimagine your retail web design. Improve the user experience of your store locator page and convert site visitors into customers using these top 5 tips.

Niharika Sisodia Jan 30, 2019
READ