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

Knight Frank use TravelTime 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

Creating Isochrones using Alteryx & Tableau (Part 2)

Use isochrones for tableau spatial analysis. Create a polygon to see where's reachable within a travel time limit. Useful for site selection and more.

Chris Hutchinson May 25, 2020
READ

Creating Isochrones using Alteryx & Tableau (Part 1)

Tutorial of how to prepare isochrone data using Alteryx to visualise using Tableau. Useful for site selection, network analysis or field management.

Chris Hutchinson May 25, 2020
READ

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