Dr Helen Roberts, Senior Analyst at the UK National Audit Office, created this visualisation showing journey times to good and outstanding acute hospital trusts in England. Here she discusses why the visualisation was created, the technique she used and the impact it has had.
This image is taken from an interactive data visualisation mapping tool published by the National Audit Office (NAO). It shows journey times to good and outstanding acute hospital trusts in England (as of 2017 – the most recent data available) and highlights the difference in time taken to reach hospital services across the country. Good quality services are not evenly spread across the country; long public transport journey times may compound this unevenness, putting better services out of reach of some users. For the first time, our analysis considered service quality alongside travel time to the service, giving decision-makers more information on equity so they can decide how best to improve outcomes for users and, therefore, overall value for money.
The NAO has a unique position and is independent from government. We produced this image and our wider visualisation tool to demonstrate new insights available to government through innovative analysis, and to facilitate discussion across government about the links between local transport and the equitable access, quality, and value for money of public services.
We used journey time modelling and analysis to calculate journey times, by public transport, from thousands of Output Area centroids across England to public service locations. In the case of this image the service locations are acute hospital trusts in England. Our journey time calculations were based on modelling undertaken by the Department for Transport, using the most recent data they make available (journey times as of 2017).
We also included public service quality data from the Care Quality Commission (CQC) which enabled us to calculate journey times to good and outstanding services only. The CQC provided us with ratings to best represent the situation in 2017 to match the time period of the journey time data. We recognise that some ratings of locations may now be different to the ones used in our analysis.
We then compared our calculated journey times with the English Index of Multiple Deprivation (IMD) and the Rural-Urban Classification to explore relationships between journey times, deprivation and rurality.
We see several different ways the insights presented in our published outputs could be used across central and local government – for example, in planning decisions, funding allocation and service delivery. Our insights could also provide an evidence base to inform select committee inquires and help MPs understand the local contexts of their constituencies. We also want to build a community of interest in the work beyond government to include academia, research bodies, charities and relevant third sector groups.
Our work also provides a case study for the Department for Transport to understand the utility, relevance and usability of the journey time data the Department makes publicly available.
The image above is taken from our interactive data visualisation mapping tool. The interactivity of our tool allows a user to customise the data and analysis they view depending on their interests. Through the different filters and options provided, users can view our journey time analysis to multiple or individual services, choose to see the locations and metadata of the services and select different geographic boundaries to overlay. This flexibility makes our tool accessible and useful for multiple types of users and has proved to be more engaging than a series of static map images.
The analysis included in our data visualisation aims to generate and facilitate discussions around provision of local transport services and equity in access to local services. Our analysis cuts across government departmental boundaries so it can be used to support cross-government working and improve the understanding of outcomes associated with spending in different parts of government. The complete findings from our analysis can be found in our insights document.
Our analysis has also helped the Department for Transport understand the utility of the journey time data they publish, and we are feeding our experience into their consultation on how they might develop their journey time statistics for future use.
As well as providing new insights for central government departments, we are excited by the possibility our analysis and tool presents for local authorities, who often have control of and deliver public transport services in local areas. Local authorities have told us the tool offers an opportunity for supporting evidence-based decision making in the allocation of funds. Visualising public transport accessibility to local services in specific local contexts enables local authorities to better identify possible areas of need and target funding in such a way as to deliver higher value for money. By identifying communities or areas which may be less well served, funds can be allocated to specific services or improvements to help increase the equity of service accessibility in an area as a whole.
Our visualisation demonstrates the potential and opportunity for new insights to be derived from innovative use of the datasets that government already collects and publishes. We encourage government and others to do more with the data already available and to combine and share datasets to produce useful information to inform decision making. For our visualisation, additional service locations (for example, libraries or job centres) could be included, journey times could be population weighted by service users or consideration of the financial cost of a journey could be incorporated.
For anyone wishing to replicate or build on the NAO's analysis, they have published a comprehensive technical guide detailing their methodology and would be happy to speak to anyone interested in finding out more. A good starting point would be to familiarise yourself with the different approaches used to build journey time models and explore the different types of geolocated data required to build these models. The NAO analysis and interactive tool were created and published in R shiny, which is an open access programming language which anyone can learn to use.
Dr Helen Roberts is a Senior Analyst on the Transport Value for Money team at the National Audit Office. She also leads the NAO’s analytical mapping discipline. Through both these roles, Helen has extensive experience of journey time analysis and examining its utility and application in supporting decision making across government.
You can find out more about Helen’s work in her Geography Directions post.
Featured card image: Dr Helen Roberts/National Audit Office
Featured banner image: David Becker/Unsplash
Robin Lovelace explains how and why he created this interactive map-based web tool to help identify promising locations for new cycleways in England
As England emerged from its second national lockdown in early December, Boris Johnson, the UK prime minister, faced an onslaught of questions from MPs on both sides of the House of Commons.
Learn how Leila Donn created a visualisation to predict where caves could be found at several Mayan archaeological sites
Owen Powell created this visualisation of the Isle of Dogs in London using aerial lidar which he has turned into a 3D model.
By placing a booking, you are permitting us to store and use your (and any other attendees) details in order to fulfil the booking.
We will not use your details for marketing purposes without your explicit consent.
You must be a member holding a valid Society membership to view the content you are trying to access. Please login to continue.
Join us today, Society membership is open to anyone with a passion for geography
Cookies on the RGS website