What is it?
We have created an infographic that provides a graphical ‘snapshot’ of how well integrated core systems within your authority are with the Unique Property Reference Number (UPRN).
What information has been used to create this?
The infographic utilises your authority’s responses to the GeoPlace Address Improvement Schedule Questionnaire 2023/24 as well as previous years. It draws on the information submitted specifically around system integrations to create the visuals that you see.
What systems are included?
The 11 key service areas are listed on the left.
What information does the infographic show?
The infographic displays the name of the software being used for each of the 11 service areas.
A colour coded system (red, amber green) using a series of 3 circles (inner, middle outer) also depicts measures across 3x areas as captured within the Improvement Schedule questionnaire.
Measure 1: the system’s reliance on the UPRN (inner circle)
Measure 2: the address data currency within the system (middle circle)
Measure 3: the method used to update the system with address data (outer circle)
Measure 1: System reliance on the UPRN
What do we mean by "reliance"? The ability of the software system to solely rely on the UPRN and official address and not permit the entry of manual, unvalidated addresses.
What to aim for: Software systems which mandate the usage of the UPRN and implement a lookup drawing “official addresses" from a definitive source.
Further guidance on definitive data sources can be found in the below guide:
Why reliance on the UPRN is important:
How you can improve :
Determine if the software system can utilise address data and the UPRN and mandate its use. You may need to ask your I.T dept or system supplier directly.
A list of key questions can be found in the below guide which can help you determine what is possible:
If manually entered addresses are present and permitted, then they will need to be periodically matched to a UPRN and retrospectively updated and corrected in the system if required. This is key to ensuring address data remains trustworthy and accurate.
Further guidance on dealing with manually entered addresses can be found in the below guides:
Measure 2: Currency of address data
What do we mean by "currency"? How frequently address data is updated and kept current in the system
What to aim for: Address data should be updated as frequently as possible in departmental systems in order to support their day to day tasks and functions.
This could mean daily or weekly frequencies, but in some cases real-time. Knowing how current the data should be all depends on what the service area requires. The answer to this question involves discussing their address requirements with them.
Why currency of data is so important:
How you can improve:
Speak with the department who owns the system and determine how frequently they require addresses to be updated. A key question could be to ask them:
"What is the longest amount of time you are prepared to wait for an address to be updated or added to the system?"
Determine how frequently the system can actually load and consume address data. You may need to ask your I.T dept or the system supplier directly to obtain this answer.
A list of key questions can be found in the below guide which can help you determine what is possible:
Once you know the departments requirements, plus the capability of the system (how frequently it can load address data), then the next step is to ensure that you are using the correct data product which supports that currency.
Further guidance on definitive data sources can be found in the below guide:
Aim to implement the most frequent option possible to support the departments service's needs.
Measure 3: Method of update
What do we mean by "method" of update? How automated the mechanism is to update address data and the UPRN within the consuming software system.
What to aim for: As automated and “hands off” as possible
Why is "method" of update important?
How you can improve
Suppliers often utilise one of the below "methods" of update but may support others:
Method of Update | Details | Desirability / Automation |
|---|---|---|
Manual entry | Relies on addresses being inserted and updated manually one-by-one with their UPRN. | Lowest |
Custom, bespoke processes | The authority's own developed processes such as scripts and scheduled tasks on a server to load address data. | Low |
Suppliers own utility / loader | A specific utility or module created by the supplier requiring manual usage to load address data. | Moderate |
DB link / API | System is capable of consuming address data via an API such as the OS Places API or is able to link directly to your LLPG database in real-time. Requires no manual intervention. | Highest |
Determine what method of update the software system currently uses to load address data and also those methods which the supplier can also support (such as consuming an address API). You may need to ask your I.T. dept or system supplier directly.
A list of key questions can be found in the below guide which can help you determine what is possible:
Aim to implement the most automated, "desirable" option possible (indicated in the table above).
How the scores are calculated
Step 1:
Each response is categorised and scored on a scale of 0 – 10:
0 = Immediate improvement required
For example:
System is not reliant on the UPRN in any way
Currency of data is very low or not updated
Method of update is manual or not updated
10 = Best possible response
For example:
System is completely reliant on the UPRN
Currency of data is the highest it can be
Method of update is real-time
Step 2:
The total “score” for each of the 3x measures across all systems / services that are provided by the authority is calculated.
Systems and services that are marked as “Service not provided” are excluded.
Step 3:
The respective total for each measure is divided by the number of systems / services provided by the authority (maximum is 11).
The figure is denoted to 1 decimal place and rounded up to obtain the “score” for the specific measure.
The maximum score that can be obtained is 10.
Calculation of the “Overall Integration Score”
This is simply the average of the scores obtained for the 3x measures.
The overall figure is denoted to 1 decimal place and rounded up.
The maximum score that can be obtained is 10.
Calculation of the “National Averages”
A national average for each of the 3x measures has been calculated to provide context to each authority on how they compare to other authorities at a national level.
The “National Average” is the average of all authority averages for that measure, denoted to 1 decimal place and rounded up. 1 decimal place and rounded up.