IntroductionLinking free-text addresses to unique identifiers in a structural address database [the Ordnance Survey unique property reference number (UPRN) in the United Kingdom (UK)] is a necessary step for downstream geospatial analysis in many digital health systems, e.g., for identification of care home residents, understanding housing transitions in later life, and informing decision making on geographical health and social care resource distribution. However, there is a lack of open-source tools for this task with performance validated in a test data set.MethodsIn this article, we propose a generalisable solution (A Framework for Linking free-text Addresses to Ordnance Survey UPRN database, FLAP) based on a machine learning–based matching classifier coupled with a fuzzy aligning algorithm for feature generation with better performance than existing tools. The framework is implemented in Python as an Open Source tool (available at Link). We tested the framework in a real-world scenario of linking individual’s (n=771,588) addresses recorded as free text in the Community Health Index (CHI) of National Health Service (NHS) Tayside and NHS Fife to the Unique Property Reference Number database (UPRN DB).ResultsWe achieved an adjusted matching accuracy of 0.992 in a test data set randomly sampled (n=3,876) from NHS Tayside and NHS Fife CHI addresses. FLAP showed robustness against input variations including typographical errors, alternative formats, and partially incorrect information. It has also improved usability compared to existing solutions allowing the use of a customised threshold of matching confidence and selection of top n candidate records. The use of machine learning also provides better adaptability of the tool to new data and enables continuous improvement.DiscussionIn conclusion, we have developed a framework, FLAP, for linking free-text UK addresses to the UPRN DB with good performance and usability in a real-world task.

This file contains the ONS UPRN Directory (ONSUD) for Great Britain as at April 2025. The ONSUD relates the Unique Property Reference Number (UPRN) for each GB address from AddressBase® Epoch 117 to a range of current statutory administrative, electoral, health and other statistical geographies. The ONSUD is produced by ONS Geography, who provide geographic support to the Office for National Statistics (ONS) and geographic services used by other organisations. The ONSUD is issued every 6 weeks and is designed to complement the Ordnance Survey AddressBase® product. For further technical information about this file, please refer to the User Guide document contained within the downloadable zip file. Please note that this product contains Royal Mail, Gridlink, Ordnance Survey and ONS Intellectual Property Rights. (File Size - 492 MB)

This file contains the National Statistics UPRN Lookup (NSUL) for Great Britain as at April 2025. The NSUL relates the Unique Property Reference Number (UPRN) for each GB address from AddressBase® Epoch 117 to a range of current statutory administrative, electoral, health and other statistical geographies via 'best-fit' allocation from 2021 Census output areas (National Parks and Workplace Zones are exempt from 'best-fit' and use 'exact-fit' allocations). The NSUL is produced by ONS Geography, who provide geographic support to the Office for National Statistics (ONS) and geographic services used by other organisations. The NSUL is issued every 6 weeks and is designed to complement the Ordnance Survey AddressBase® product. For further technical information about this file, please refer to the User Guide document contained within the downloadable zip file. Please note that this product contains Royal Mail, Gridlink, Ordnance Survey and ONS Intellectual Property Rights. (File Size – 476 MB)Version 1.1 to correct missing RUC21IND values. [Updated 22/04/2025 16:38]

WARNINGThis data is provided here for specialist users only. The same information is available in a much more user-friendly format in the Services near me page on the main council website, and anyone interested in enrolling a child in school should see the page on Enrolment in Primary and Secondary Schools in DundeePurposeThese files are intended to be downloaded and used within systems such as SEEMIS that have access to a separate source of address information such as the Council's Corporate Address Gazetteer (CAG), One Scotland Gazetteer (OSG) or Ordnance Survey AddressBase.DescriptionThis collection includes the following files:Dundee_UPRN_SEED_lookup_all.csvDundee_UPRN_SEED_lookup_all_primary.csv - required for use in SEEMISDundee_UPRN_SEED_lookup_all_secondary.csv - required for use in SEEMISDundee_UPRN_SEED_lookup_denom_primary.csvDundee_UPRN_SEED_lookup_denom_secondary.csvDundee_UPRN_SEED_lookup_non_denom_primary.csvDundee_UPRN_SEED_lookup_non_denom_secondary.csvSchema.ini - explicitly sets UPRN datatype to text (with preceding zeroes) for use in excelOnly files 2 & 3 are required for use in SEEMIS. The other files are produced by the same process and are provided here in case they are useful. The combined files (1-3) will contain multiple records for each address. The remaining files (4-7) contain just one record for each address. Each file contains just two columnsUPRN - the Unique Property Reference Number of each address in DundeeSEED - the seedcode of the school catchment that the address is within Both columns are qualified with double quotes and separated with a comma. UPRNs are Unique Property Reference Numbers, as used in the Council's Corporate Address Gazetteer (CAG), the One Scotland Gazetteer (OSG) Or the Ordnance Survey AddressBase products.. For more information please see www.osg.scotSeedcodes are unique identifiers for Scottish Schools. A full list can be found at https://www.gov.scot/publications/school-contact-details/This collection is updated each night with the latest UPRNs from the Council's Corporate Address Gazetteer (CAG). SEED codes are taken from the Council's current catchment boundaries layer ("SchoolsAndCatchments - Current") which is updated as required. This typically happens around October or November before enrolment starts for the next school year each year. The data may therefore reflect the catchments that are due to take effect at the start of the next school year. For more details on the catchment data please see the the Council's current catchment boundaries layer ("SchoolsAndCatchments - Current") This data can be combined with Ordnance Survey OpenUPRN data to visualise it on a map in GIS software such as ArcGIS or QGIS. Or alternatively see the separate "UPRNs with school catchments" layer.

(File Size – 376 MB) Click on the title for more details and to download the file.

This is the User Guide for the ONS UPRN Directory (ONSUD) for Great Britain as at March 2019. The ONSUD relates the Unique Property Reference Number (UPRN) for each GB address to a range of current geographies. (File Size - 281 KB)

This is the User Guide for the National Statistics UPRN Lookup (NSUL) for Great Britain as at July 2017. The NSUL relates the Unique Property Reference Number (UPRN) for each GB address to a range of current geographies via 'best-fit' allocation from 2011 output areas. (File Size - 304 KB)

This is the User Guide for the National Statistics UPRN Lookup (NSUL) for Great Britain as at November 2019. The NSUL relates the Unique Property Reference Number (UPRN) for each GB address to a range of current geographies via 'best-fit' allocation from 2011 output areas. (File Size - 197 KB)

This is the User Guide for the National Statistics UPRN Lookup (NSUL) for Great Britain as at May 2018. The NSUL relates the Unique Property Reference Number (UPRN) for each GB address to a range of current geographies via 'best-fit' allocation from 2011 output areas. (File Size - 281 KB)

This file contains the National Statistics UPRN Lookup (NSUL) for Great Britain as at May 2025. The NSUL relates the Unique Property Reference Number (UPRN) for each GB address from AddressBase® Epoch 118 to a range of current statutory administrative, electoral, health and other statistical geographies via 'best-fit' allocation from 2021 Census output areas (National Parks and Workplace Zones are exempt from 'best-fit' and use 'exact-fit' allocations). The NSUL is produced by ONS Geography, who provide geographic support to the Office for National Statistics (ONS) and geographic services used by other organisations. The NSUL is issued every 6 weeks and is designed to complement the Ordnance Survey AddressBase® product. For further technical information about this file, please refer to the User Guide document contained within the downloadable zip file. Please note that this product contains Royal Mail, Gridlink, Ordnance Survey and ONS Intellectual Property Rights. (File Size – 486 MB)

This file contains the ONS UPRN Directory (ONSUD) for Great Britain as at April 2023. The ONSUD relates the Unique Property Reference Number (UPRN) for each GB address from AddressBase® Epoch 100 to a range of current statutory administrative, electoral, health and other statistical geographies. The ONSUD is produced by ONS Geography, who provide geographic support to the Office for National Statistics (ONS) and geographic services used by other organisations. The ONSUD is issued every 6 weeks and is designed to complement the Ordnance Survey AddressBase® product. For further technical information about this file, please refer to the User Guide document contained within the downloadable zip file. Please note that this product contains Royal Mail, Gridlink, Ordnance Survey and ONS Intellectual Property Rights. (File Size - 489 MB)

This User Guide contains information about the NSUL including: directory content; data currency; the methodology for assigning areas to postcodes; data formats; data quality and limitations and details of recent changes that have impacted on the data. Various annexes and tables provide more detailed supporting information. The download includes PDF and ODT versions of the user guide. (File size - 386 KB)

This file contains the National Statistics UPRN Lookup (NSUL) for Great Britain as at July 2024. The NSUL relates the Unique Property Reference Number (UPRN) for each GB address from AddressBase® Epoch 111 to a range of current statutory administrative, electoral, health and other statistical geographies via 'best-fit' allocation from 2021 Census output areas (National Parks and Workplace Zones are exempt from 'best-fit' and use 'exact-fit' allocations). The NSUL is produced by ONS Geography, who provide geographic support to the Office for National Statistics (ONS) and geographic services used by other organisations. The NSUL is issued every 6 weeks and is designed to complement the Ordnance Survey AddressBase® product. For further technical information about this file, please refer to the User Guide document contained within the downloadable zip file. Please note that this product contains Royal Mail, Gridlink, Ordnance Survey and ONS Intellectual Property Rights. (File Size – 467 MB)

🇬🇧 영국

This file contains the ONS UPRN Directory (ONSUD) for Great Britain as at June 2024. The ONSUD relates the Unique Property Reference Number (UPRN) for each GB address from AddressBase® Epoch 110 to a range of current statutory administrative, electoral, health and other statistical geographies. The ONSUD is produced by ONS Geography, who provide geographic support to the Office for National Statistics (ONS) and geographic services used by other organisations. The ONSUD is issued every 6 weeks and is designed to complement the Ordnance Survey AddressBase® product. For further technical information about this file, please refer to the User Guide document contained within the downloadable zip file. Please note that this product contains Royal Mail, Gridlink, Ordnance Survey and ONS Intellectual Property Rights. (File Size - 499 MB)

Heat makes up around half of all the energy we use and so efficient heat management is a major national focus for tackling fuel poverty, meeting environmental challenges and supporting our economy , for more background see Scotland's Heat Map (and the related item tab). Total annual energy consumption (kWh) and 5 year average for the corrected usage for open buildings in GCC estate from 2008 to 2012 .The fuel can be gas, electricity, gas-oil or coal and the year is calendar year. Location covers address, postcode and UPRN (Notes: except air quality units & heat pumps; also Cathkin landfill which is located outside GCC boundary has been assigned a temporary UPRN).For properties with 2 heating sources e.g. Daldowie Training Centre, only the primary source has been included. Data supplied: 2014-03-21 by Glasgow District Council Licence: None

This file contains the National Statistics UPRN Lookup (NSUL) for Great Britain as at May 2022. The NSUL relates the Unique Property Reference Number (UPRN) for each GB address from AddressBase® Epoch 92 to a range of current statutory administrative, electoral, health and other statistical geographies via 'best-fit' allocation from 2011 Census output areas (National Parks and Workplace Zones are exempt from 'best-fit' and use 'exact-fit' allocations). The NSUL is produced by ONS Geography, who provide geographic support to the Office for National Statistics (ONS) and geographic services used by other organisations. The NSUL is issued every 6 weeks and is designed to complement the Ordnance Survey AddressBase® product. For further technical information about this file, please refer to the User Guide document contained within the downloadable zip file. Please note that this product contains Royal Mail, Gridlink, Ordnance Survey and ONS Intellectual Property Rights. (File Size – 521 MB)

This file contains the ONS UPRN Directory (ONSUD) for Great Britain as at January 2024. The ONSUD relates the Unique Property Reference Number (UPRN) for each GB address from AddressBase® Epoch 106 to a range of current statutory administrative, electoral, health and other statistical geographies. The ONSUD is produced by ONS Geography, who provide geographic support to the Office for National Statistics (ONS) and geographic services used by other organisations. The ONSUD is issued every 6 weeks and is designed to complement the Ordnance Survey AddressBase® product. For further technical information about this file, please refer to the User Guide document contained within the downloadable zip file. Please note that this product contains Royal Mail, Gridlink, Ordnance Survey and ONS Intellectual Property Rights. (File Size - 495 MB)

This is the User Guide for the National Statistics UPRN Lookup (NSUL) for Great Britain as at December 2017. The NSUL relates the Unique Property Reference Number (UPRN) for each GB address to a range of current geographies via 'best-fit' allocation from 2011 output areas. (File Size - 202 KB)

This is the User Guide for the National Statistics UPRN Lookup (NSUL) for Great Britain as at May 2017. The NSUL relates the Unique Property Reference Number (UPRN) for each GB address to a range of current geographies via 'best-fit' allocation from 2011 output areas. (File Size - 306 KB)