Local authorities across Great Britain have come under great pressure to record COVID-19 outbreaks so they can better identify and manage areas of concentrated infection. By doing this they’ll be able to quickly respond by implementing pop-up testing centres to minimise the spread, as well as better support vulnerable residents and help save lives.
As Warwickshire and Coventry local authorities share adjoining boundaries, they decided to collaborate to better coordinate their efforts in managing outbreaks of COVID-19 across their two regions.
Their teams manage the outbreaks at both the setting and individual level, and use the location data to identify clusters and hot-spots. With each council using their own systems for location data, they needed to find a way to unify these so information could be properly validated and shared. As a result, they agreed to use Ordnance Survey’s AddressBase Unique Property Reference Numbers (UPRNs) as the common property / organisation reference to ensure the accuracy of outbreak location data across both regions.
The first task was to upload historic outbreak actions against the locations. This was straight forward for Coventry City Council because they were already using the UPRNs as the key identifier as a result of using our LLPG gazetteer, iManage, to manage and maintain their address data. However, that wasn’t the case for Warwickshire. Their address data management was devolved to the district and borough authorities within the county which meant various disparate systems were being used.
‘As we were already using the Aligned Assets LLPG, we asked them what they could do to validate Warwickshire’s address data with the UPRNs before loading them into a new shared system. This turned out to be a quick and easy process, saving a considerable amount of time and effort.’ David Lloyd ICT project manager Coventry City Council.
‘To help the two local authorities unify their address data, we used AddressBase Premium data to validate Warwickshire’s addresses with the UPRNs. We were able to supply this in a simple lucene index format, ie one that can be searched against, and using our matching and cleansing solution, iMatch, connected Warwickshire’s data to the index allowing them to match the data with the UPRNs. These were then returned as cleansed addresses.’ Dinesh Thanigasalam, Aligned Assets.
‘It’s critical for us to be able to identify infection clusters and hotspots so we can quickly contain the spread of the virus. It also means we can quickly identify any vulnerable residents with COVID-19 who may need extra assistance. So for us, it’s about improving the safeguarding of our residents through containment of the spread, as well as support for the most vulnerable.’ Nadia Inglis Consultant in Public Health Warwickshire County and Coventry City Councils.
‘By using the UPRNs to unify the two councils’ address data on the new system, we have a much quicker and easier way to jointly manage the COVID-19 outbreaks across the combined region. And should we find ourselves having to manage other communicable diseases in the future, we’re much better placed to respond immediately.’ Nadia Inglis Consultant in Public Health Warwickshire County and Coventry City Councils.
Drop us a line to find out more about how we can utilise the UPRNs to unify your systems in the drive for efficiency.