Points of Interest – Methodology for populating the Unique Property Reference Number
In the December 2014 release of Points of Interest (POI) the Unique Property Reference Number (UPRN) attribute was populated to enable customers to link POI to the AddressBase® suite of products.
The approach for populating the UPRN values was as follows;
- The Ordnance Survey AddressPoint Reference (OSAPR) used in the production of POI was matched to the AddressBase UPRN.
- For those not matched in the first step, a lookup was created between the OS MasterMap® Topography Layer TOID® in POI and the Topography Layer TOID in AddressBase® products. This only uses the following records from AddressBase products;
Where there is only 1 AddressBase record with the same Topography Layer TOID as that in POI or,
Where a single Topography Layer TOID had multiple UPRN values associated in AddressBase Products, the UPRN of the main (parent) AddressBase record referencing that Topography Layer feature was used.
- The final part was to remove the UPRN value where there were more than 7 POI records matched to a single UPRN (based on tests to determine the most appropriate limit) or where the record was in the following POI classification because these classes should not have a UPRN:
020901410 Cash machines
020908110 Paypoint locations
031802540 Picnic areas
035808050 Lochs and lochans
035808060 Tarns, pools and meres
035808080 Settling, balancing and silt ponds
063404330 Electrical features
063404570 Letter boxes
063404600 Public telephones
063404610 Public toilets
063408020 Wi-Fi hotspots
073905210 Sheep dips and washes
074105360 Lime kilns
074105390 Tanks (generic)
10540733 Cattle grids
10540740 Signalling facilities
10550749 Stepping stones
10560755 Weirs, sluices and dams
10570758 Taxi ranks
10590732 Bus stops
Please give us your feedback on this methodology as well as the proposals to remove some attributes via the short online survey.
Location Analytics Portfolio Senior Product Manager