Data visualization & location analysis to locate a hospital

by Niharika Sisodia
on Sep 5, 2018

The NHS wanted to involve local citizens in the decision to choose a location for a new community hospital in the Forest of Dean, a decision affecting over 80,000 people and costing £11 million. There were three locations under consideration: Coleford, Cinderford and Lydney.

data-visualization

To make this decision, they called on the expertise of Citizens Juries CIC. Their task was to recruit a cross-section of people from across the Forest of Dean to be members of a citizens’ jury and then to identify the evidence that the citizens needed to choose a recommended town. One important factor that the jury needed to take into account was the time it would take for people across the Forest of Dean District to travel to the hospital by car and public transport if the hospital was built in Cinderford, Coleford or Lydney.  

Citizens Juries CIC used TravelTime data to create location analysis maps. These maps included drive time and public transport catchment areas from the hospital locations. Citizens Juries CIC picked 8 places spread across the Forest and used the travel time maps to reach conclusions on which of these 8 places could be reached in 30 minutes by car, and by 90 minutes by public transport.  This illustrates how TravelTime data can be used to inform large-scale developments, such as the decision of where to build a new hospital.

The maps gave a clear picture of local access to the new development, providing the members of the jury with the travel time information they needed to make an informed recommendation to the NHS.

Citizens Juries CIC chose TravelTime to:

  • Simplify location decision-making
  • Help people understand location accessibility using visualisations
  • Inform a judgement by the citizens’ jury on which location is best suited for the population.

Using the Traveltime data visualization along with other relevant evidence such as population data and healthcare needs, the jury worked together over four-and-a-half days to reach a recommendation. They concluded that Cinderford should be the location of the new community hospital. On 30 August 2018, the Boards of Gloucestershire Community Services NHS Trust and NHS Gloucestershire Clinical Commissioning Group unanimously backed the jury recommendation, confirming that the new hospital would be built in or near Cinderford.  

The panel was made up of 18 local people. Using TravelTime allowed the members of the jury to:

  • Judge how easily accessible each of the three hospital locations would be by car
  • Identify which hospital would be the easiest to reach for the local population by public transport
  • View maps that were named, colour coded and easy to understand.

data-visualizationdata-visualization

location-analysis

location-analysis

 

 

 

 

 

 

 

 

 

 

TravelTime helped Citizens Juries CIC by allowing them to:

  • Frame the hospital location decision using the local council district area - the catchment area of patients for the new hospital
  • Present the information graphically in a way that was easy for the general public to understand and could be reviewed by a group on printed out maps, rather than tables of figures, and without needing GIS (geographic information system software skills) or computing skills.

How to select a hospital location

Selecting a location for a business, office or service, such as a hospital can be difficult and costly. You need to determine:

The best location for the building

Large-scale developments, like hospitals, need to be accessible for staff and the public. If the building is not accessible by public transport, for example, this could create an issue with parking and put further strain on already stretched hospital transport services.

The financial implications

Selecting a location for a development is incredibly costly. It’s important that the decision is correct the first time.

The effect the move will have on employees and service users

Sensitive decisions need public support. By not taking public opinion you could risk making the wrong decision.

Citizens Juries CIC have used TravelTime Analytics to:

Map public transport & drive times

Citizens Juries CIC created travel time maps for driving and public transport. This allowed them to visualise how easy it would be for the public to reach the potential hospital locations. The example below shows the drive time map for 30 minutes from the proposed Lydney hospital.

data-visualization

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Exporting maps (via KML)

What is a KML?

A KML is a file that is readable by a map program. Using TravelTime it’s possible to create a travel time shape, such as a 30 minute drive time area, and export it as a KML file. This file can then be imported onto another mapping program such as Google My Maps or Google Earth. This means anyone can view the travel time shape easily. 

Exporting maps allowed the jury to visualise demographic information in relation to the potential hospital locations. The image below displays the 30 minute drive area from Coleford. To get this shape TravelTime exported the KML file and imported it onto a Google Map.

data-visualization

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Visualize district boundaries

Creating maps of district boundaries allowed the jury to consider whether the location of the hospital would be suitable today and in the future. The data visualization below shows where you could travel from in the Forest of Dean to get to one of the three towns (Coleford) by 08.30 on a weekday for a hospital appointment if the hospital was in Coleford.

data-visualization

 

Malcolm OswaldMalcolm Oswald, Director of Citizens Juries CIC

“Using TravelTime Analytics to create data and travel time maps allowed for a detailed analysis of the three hospital locations, and for information to be presented to the jury for their consideration in a way that was easy to understand. This aided the decision-making process for the jury and was an important factor in informing their recommendation to the NHS of Cinderford as the hospital location.

Citizens Juries CIC have used TravelTime Analytics to create mapping tools that provide powerful visualisations of information, allowing members of the Forest of Dean Citizens Jury to gain a greater understanding of their community, and make a logical decision about which location to recommend to the NHS decision-makers."

 

Click

 

 

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

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 launch with TravelTime, increase conversions 10%

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

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