Using GIS to Create a Vaccination Route Modeling Tool

| |

How can GIS (Geographic Information Systems) help plan housebound patient vaccination programs? This case study from the NHS South Central and West Commissioning Support Unit explains.

  • NHS South, Central and West’s GIS team used its Esri UK mapping tool to model routes to reach as many patients as possible, in the least number of journeys. Taking into consideration factors such as location of vaccine and patients, and each vial has 11 doses and needs to be used within 6 hours
  • Journey times have been shortened and more doses are being given per day, so the vaccination program is taking less time
  • Primary Care Networks can now plan more thoroughly and communicate appointment times better with patients in advance
  • Maps show vaccinators visits in sequence and can include patients from multiple practices within the PCN, with GPs vaccinating each other’s patients to increase efficiency
  • The new approach was launched to the first PCN on the 4th February and is now being used to improve planning for second round of jabs
  • Innovative mapping techniques use Ordnance Survey address data, not postcode data, so the system is more accurate, while maintaining privacy of patient data

The Challenge 

How do you make sure housebound patients receive their Covid-19 vaccines in the most efficient way? Primary Care Networks (PCN) in Somerset pondered this question as they began to rapidly roll out their COVID-19 vaccination program. 

The approach for the first round of vaccinations had turned out to be quite hectic. Allison Nation, Associate Director of Digital Strategy for Somerset Clinical Commissioning Group (CCG) was approached by one of her PCN general practitioners, who asked, “Is there not some clever tech such as mapping?”

Allison immediately thought of Trevor Foster, associate director at SCW CSU and his GIS (Geographic Information System) mapping team and approached them for help with the project. Always ready to rise to a challenge, Trevor and his team said, “of course we can, that’s exactly what we can do” and rapidly started working on it. The need for speed was escalated as a second PCN in Somerset wanted the solution urgently for their 200 housebound patients. 

Optimizing a Vaccination Route Using GIS

In planning how vaccinators go out and see patients there were a few parameters to consider, including, where is the vaccine stored? What time of day do vaccinators start and finish? And once open, the vial contents last 6 hours and within this time up to 11 jabs need to be completed. 

Map with the optimized vaccination routes.  Map: SCW CSU.
Map with the optimized vaccination routes. Map: SCW CSU.

Trevor’s team were able to take all the patient addresses and plan the optimal routing to cover as many patients as possible, in as few journeys, so they can fit within the time window for the vial. This is achieved by modelling a structured data set which contains a unique patient identifier, such as NHS or EMIS system number, and the full address to pinpoint specific house locations. Using this data, the analysis creates the fewest number of trips needed over the time period.

Each route is sequenced from start to finish, giving the order in which the mapping tool recommends the visits be done. The sophisticated modelling also builds in other relevant factors. These include breaks, households with more than one patient, time taken to ring the doorbell, chat with the patient, give the jab and sit with patient for 15 minutes recovery. The journey data is supplied in a spreadsheet with a map providing a visualisation of the routes. Each location is shown as a dot on the map. These are then clustered into groupings to match the dosage and time requirement. Routes can include patients from multiple practices within the PCN with GPs vaccinating each other’s patients to increase efficiency. 

The GIS team was able to react extremely quickly to the original request. Using their expertise with Esri GIS software they were able to build the original model and procedures in less than 2 weeks from initial contact on 22 January, to launching a full solution to the PCN on 4 February. 

The Benefits 

Crucially, the solution minimizes wastage of the vaccine and PCNs can plan thoroughly and communicate with patients in advance. Patients in each cluster will know when to expect their visits and vaccinators can call patients to confirm an accurate time. The model also builds in contingency time for unexplained delays which maximizes the vaccination program success rate. 

The routing solution is saving the PCNs time and money. Before working with the GIS team, the PCNs planning was often not optimized and journeys quite chaotic. This resulted in increased journey times. Not only was it taking longer but fewer doses being given per day. This increased the number of days needed for vaccinations and consequently the cost of delivering the program. 

The mapping solution can be used to improve vaccination planning for the remaining first jab patients’ who are housebound, and to plan the second round of jabs and enable these to be managed more efficiently. 

Using their expertise to model the data and interpret requirements into logical solutions, the GIS team were able to deliver the initial development in less than 2 weeks. With development of all the procedures now complete, and any pitfalls already resolved, the solution is now ready to be set up for new PCNs within only 1-2 days, provided good patient data is supplied (templates are provided). 

Patient confidentiality is protected as no patient identifiable data is transferred from practices. Patient name and contact details are matched only within the practice and they follow up to make appointments. The solution has been developed using proprietary Esri commercial software which SCW owns, so the system is secure. 

The data used is the most accurate available. As an Ordnance Survey (OS) partner, SCW has access to specific OS products to deliver this accuracy. To calculate the routing, it using the OS national routing network dataset. It also uses the OS national official addresses of the UK, address base premium, to pinpoint specific households, minimizing time to find patients. 

About NHS South Central and West Commissiong Support Unit:

Based in the south of England, SCW’s team of 1,300 skilled professionals provides expert support for more than 80 NHS and non-NHS customers – nationally, regionally and locally. We are proud to be making a difference for 14 million people across an area of 15,600 square miles. As a delivery partner for 13 STPs (Sustainability and Transformation Partnerships), we have been at the heart of emerging Integrated Care Systems (ICSs) and the increasing adoption of population health management approaches.
https://www.scwcsu.nhs.uk/about-us/

Related

Share this article


Enter your email to receive the weekly GIS Lounge newsletter: