Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Release notes listed here provide information about the current release of AddressBase Core and the previous nine releases.
This release note provides information about the 19 November 2024 release of AddressBase Core.
This release note provides information about the 12 November 2024 release of AddressBase Core.
This release note provides information about the 05 November 2024 release of AddressBase Core.
This release note provides information about the 29 October 2024 release of AddressBase Core.
This release note provides information about the 22 October 2024 release of AddressBase Core.
This release note provides information about the 15 October 2024 release of AddressBase Core.
This release note provides information about the 08 October 2024 release of AddressBase Core.
This release note provides information about the 01 October 2024 release of AddressBase Core.
This release note provides information about the 24 September 2024 release of AddressBase Core.
This release note provides information about the 17 September 2024 release of AddressBase Core.
This release note provides information about the release of the AddressBase Core product on 19 November 2024.
Product | Full Supply record count0F[*] | Change-Only Update record count |
---|---|---|
*These counts are based on a Managed Great Britain Set (MGBS). If you ordered your national coverage via the online ordering system using a polygon outline, your counts may differ.
There is a difference in record counts between taking a national Managed Great Britain Set (MGBS) and the national 5km-tile supply. This is because the two supplies use different selection criteria. The difference in record counts is shown in the following table, allowing you to validate your data holdings once you have loaded the latest release of AddressBase Core.
Product | MGBS Full Count | National 5km tiled supply | Difference |
---|---|---|---|
A small difference in record counts is expected due to there being several features supplied in the MGBS which fall outside of the tiled area.
If you receive a Change-Only Update (COU) supply for your AddressBase Core product, you will receive Insert, Update and Delete records within the supplied file. The following table details the numbers of these records which can be expected in the COU supply of the product:
Change type | Count |
---|---|
The following information relates to the currency of the source data used in the creation of this release of AddressBase Core:
This release note provides information about the release of the AddressBase Core product on 05 November 2024.
Product | Full Supply record count[*] | Change-Only Update record count |
---|
*These counts are based on a Managed Great Britain Set (MGBS). If you ordered your national coverage via the online ordering system using a polygon outline, your counts may differ.
There is a difference in record counts between taking a national Managed Great Britain Set (MGBS) and the national 5km-tile supply. This is because the two supplies use different selection criteria. The difference in record counts is shown in the following table, allowing you to validate your data holdings once you have loaded the latest release of AddressBase Core.
Product | MGBS Full Count | National 5km tiled supply | Difference |
---|
A small difference in record counts is expected due to there being several features supplied in the MGBS which fall outside of the tiled area.
If you receive a Change-Only Update (COU) supply for your AddressBase Core product, you will receive Insert, Update and Delete records within the supplied file. The following table details the numbers of these records which can be expected in the COU supply of the product:
Change type | Count |
---|
There has been one new issue identified in this release of AddressBase Core. A Scottish record has been incorrectly matched to a Royal Mail record. As a result of this, the Scottish record (UPRN = 35030393) has been incorrectly assigned a ‘POST_TOWN’ value of ‘NEWCASTLE’ and incorrect ‘POSTCODE’ of ‘BT33 0GT’. The nine other addresses on this street remain unaffected.
The following information relates to the currency of the source data used in the creation of this release of AddressBase Core:
Local Authority data is at the heart of AddressBase Core. This data provides you with a complete address product; access to over 33 million addresses each unique referenced with the Unique Property Reference Number (UPRN) and property level coordinates.
This product is updated weekly
AddressBase Core is a new addition to the addressing portfolio, which was released in July 2020.
AddressBase Core takes many of the important elements from the other AddressBase products, such as coordinates, classification and cross-references to connect address information to other products via key identifiers.
AddressBase Core's primary source of addressing information is Local Authority data from the National Land and Property Gazetteer (NLPG) and One Scotland Gazetteer (OSG). They have the legal responsibility to capture and maintain address data for Great Britain, so you are assured of its authenticity and legal nature.
Address information is provided in an easy-to-use format alongside a single line attribute which concatenates all the address elements into what you would expect to see on an envelope. It is updated weekly and is offered in an easier to digest format to make the product as easy to access and use as possible.
Customers have asked for easy file formats, so CSV and GeoPackage are available for this product, with headers included – removing the need for any post-processing. Simply load, or drag and drop into a GIS package to start analysing.
AddressBase Core provides approved addressing records for England, Wales and Scotland based on Local Authority holdings of the National Land and Property Gazetteer (NLPG) and One Scotland Address Gazetteer (OSG). Other attribution includes property-level coordinates and secondary level classifications (detailing the use and type of an address).
Through property classification attributes, you can quickly understand, locate and perform analysis on the type of addresses you want to interact with.
AddressBase Core's primary source of addressing information is local authority data. They have the legal responsibility to capture and maintain address data for Great Britain, so you can be sure of its authenticity and legal nature.
AddressBase Core is released weekly, keeping you more up to date with changes.
Making the most of the property classification attributes, you can quickly understand, locate and perform analysis on the type of addresses you want to interact with.
AddressBase Core makes it easier to locate, match and gain insights from other location data with the benefit of having  key identifiers referenced throughout. The Unique Property Reference Number (UPRN), Unique Street Reference Number (USRN) and Topographic Identifier (TOID) allow users to reference to other OS products.
Access: Download
Data theme: Address
Data structure: Vector - Points
Coverage: Great Britain
Scale: 1:1 250 to 1:10 000
Format: CSV, GML 3.2.1
Ordering area: All of Great Britain or customisable area (5km2 tiles or user-defined polygon)
OS Data Hub plan: Public Sector Plan, Premium Plan, Energy & Infrastructure Plan
AddressBase Core takes many of the high importance items from the other AddressBase products, such as coordinates, classifications (type of address) and links to other important identifiers; but it also includes a single attribute for an address line, is updated weekly, and is offered in an easier to digest format to make the product as easy to access and use as possible.
Properties yet to be built, or those which have been demolished, do not appear in AddressBase Core. In order to keep AddressBase Core as simple as possible, these records are not present. If these are critical to you, please look at AddressBase Premium.
AddressBase Core is released weekly and has a different data extraction date compared to the 6-weekly release schedule of the other AddressBase products. Due to these differences, AddressBase Core will not correspond to any of the epochs.
AddressBase Core covers Great Britain only. This is England, Wales and Scotland. It does not include Northern Ireland and the Channel Islands.
The database is a vital component of the single address gazetteer database and is in each of the AddressBase products where there has been a match confirming the address to the LLPG address.
This release note provides information about the release of the AddressBase Core product on 12 November 2024.
Product | Full Supply record count[*] | Change-Only Update record count |
---|
*These counts are based on a Managed Great Britain Set (MGBS). If you ordered your national coverage via the online ordering system using a polygon outline, your counts may differ.
There is a difference in record counts between taking a national Managed Great Britain Set (MGBS) and the national 5km-tile supply. This is because the two supplies use different selection criteria. The difference in record counts is shown in the following table, allowing you to validate your data holdings once you have loaded the latest release of AddressBase Core.
Product | MGBS Full Count | National 5km tiled supply | Difference |
---|
A small difference in record counts is expected due to there being several features supplied in the MGBS which fall outside of the tiled area.
If you receive a Change-Only Update (COU) supply for your AddressBase Core product, you will receive Insert, Update and Delete records within the supplied file. The following table details the numbers of these records which can be expected in the COU supply of the product:
The following information relates to the currency of the source data used in the creation of this release of AddressBase Core:
Data source | Date |
---|---|
Data source | Date |
---|
Access to this product is free for PSGA members. Find out if you are a PSGA member or download a sample of AddressBase Core data by with links to all of the relevant resources. Alternatively, you can try out the full product by applying for .
Data source | Date |
---|
Royal Mail Postcode Address File (PAF)
15 November 2024
National Land and Property Gazetteer
15 November 2024
One Scotland Gazetteer
28 October 2024
OS MasterMap Topography Layer
05 September 2024
Royal Mail Postcode Address File (PAF) | 01 November 2024 |
National Land and Property Gazetteer | 01 November 2024 |
One Scotland Gazetteer | 28 October 2024 |
OS MasterMap Topography Layer | 05 September 2024 |
Royal Mail Postcode Address File (PAF) | 08 November 2024 |
National Land and Property Gazetteer | 08 November 2024 |
One Scotland Gazetteer | 28 October 2024 |
OS MasterMap Topography Layer | 05 September 2024 |
The AddressBase Core product is distributed as a Comma Separated Value (CSV) file or GeoPackage (GPKG). CSV files can be supplied as a Full Supply or Change Only Update (COU) when taking Managed Great Britain Sets (MGBS); or Full Supply or changed tiles when taking tile supplies. GPKG is only available as Full Supply for both MGBS and tile supplies.
The CSV format of AddressBase Core means:
Column headers are included in the file.
There is one record per line in each file.
Fields are separated by commas.
No comma is placed at the end of each row in the file.
Records are terminated by carriage return/line feed.
For MGBS orders, one file containing all records is produced.
GPKG is an open, standards-based, platform-independent data format for transferring geospatial information as defined by the Open Geospatial Consortium (OGC). It is designed to be a lightweight format that can contain large amounts of varied and complex data in a single, easy-to-distribute and ready-to-use file.
GPKG offers the following benefits:
The single file is easy to transfer and offers the end-user a rich experience.
Attribute names are not limited in length making it customer friendly.
No file size limit, so lots of data can be easily accommodated.
Supports raster, vector and database formats making it a highly versatile solution.
Conforms to OGC standard.
In most cases, it is a Plug and Play format.
For both MGBS and tile supplies, GeoPackage supplies will be provided as one file.
AddressBase Core
34 530 184
28 008
AddressBase Core
34 530 184
34 530 177
7
Inserts
6 365
Updates
19 317
Deletes
2 326
COU populated 5km tile count
2 760
It is important that COUs are processed with Deletes first, then Inserts and Updates. This is to ensure that updates are applied in the correct order. Guidance on this can be found in the .
AddressBase Core | 34 518 399 | 54 822 |
AddressBase Core | 34 518 399 | 34 518 392 | 7 |
Inserts | 6 952 |
Updates | 36 796 |
Deletes | 11 074 |
COU populated 5km tile count | 4 362 |
It is important that COUs are processed with Deletes first, then Inserts and Updates. This is to ensure that updates are applied in the correct order. Guidance on this can be found in the .
AddressBase Core | 34 526 145 | 88 612 |
AddressBase Core | 34 526 145 | 34 526 138 | 7 |
Change type | Count |
Inserts | 10 471 |
Updates | 75 416 |
Deletes | 11 074 |
COU populated 5km tile count | 2 725 |
It is important that COUs are processed with Deletes first, then Inserts and Updates. This is to ensure that updates are applied in the correct order. Guidance on this can be found in the .
This release note provides information about the release of the AddressBase Core product on 29 October 2024.
Product | Full Supply record count[*] | Change-Only Update record count |
---|---|---|
*These counts are based on a Managed Great Britain Set (MGBS). If you ordered your national coverage via the online ordering system using a polygon outline, your counts may differ.
There is a difference in record counts between taking a national Managed Great Britain Set (MGBS) and the national 5km-tile supply. This is because the two supplies use different selection criteria. The difference in record counts is shown in the following table, allowing you to validate your data holdings once you have loaded the latest release of AddressBase Core.
Product | MGBS Full Count | National 5km tiled supply | Difference |
---|---|---|---|
A small difference in record counts is expected due to there being several features supplied in the MGBS which fall outside of the tiled area.
If you receive a Change-Only Update (COU) supply for your AddressBase Core product, you will receive Insert, Update and Delete records within the supplied file. The following table details the numbers of these records which can be expected in the COU supply of the product:
Change type | Count |
---|---|
It is important that COUs are processed with Deletes first, then Inserts and Updates. This is to ensure that updates are applied in the correct order. Guidance on this can be found in the .
The following information relates to the currency of the source data used in the creation of this release of AddressBase Core:
This release note provides information about the release of the AddressBase Core product on 22 October 2024.
Product | Full Supply record count[*] | Change-Only Update record count |
---|---|---|
*These counts are based on a Managed Great Britain Set (MGBS). If you ordered your national coverage via the online ordering system using a polygon outline, your counts may differ.
There is a difference in record counts between taking a national Managed Great Britain Set (MGBS) and the national 5km-tile supply. This is because the two supplies use different selection criteria. The difference in record counts is shown in the following table, allowing you to validate your data holdings once you have loaded the latest release of AddressBase Core.
Product | MGBS Full Count | National 5km tiled supply | Difference |
---|---|---|---|
A small difference in record counts is expected due to there being several features supplied in the MGBS which fall outside of the tiled area.
If you receive a Change-Only Update (COU) supply for your AddressBase Core product, you will receive Insert, Update and Delete records within the supplied file. The following table details the numbers of these records which can be expected in the COU supply of the product:
Change type | Count |
---|---|
It is important that COUs are processed with Deletes first, then Inserts and Updates. This is to ensure that updates are applied in the correct order. Guidance on this can be found in the .
The following information relates to the currency of the source data used in the creation of this release of AddressBase Core:
This release note provides information about the release of the AddressBase Core product on 01 October 2024.
Product | Full Supply record count[*] | Change-Only Update record count |
---|---|---|
*These counts are based on a Managed Great Britain Set (MGBS). If you ordered your national coverage via the online ordering system using a polygon outline, your counts may differ.
There is a difference in record counts between taking a national Managed Great Britain Set (MGBS) and the national 5km-tile supply. This is because the two supplies use different selection criteria. The difference in record counts is shown in the following table, allowing you to validate your data holdings once you have loaded the latest release of AddressBase Core.
Product | MGBS Full Count | National 5km tiled supply | Difference |
---|---|---|---|
A small difference in record counts is expected due to there being several features supplied in the MGBS which fall outside of the tiled area.
If you receive a Change-Only Update (COU) supply for your AddressBase Core product, you will receive Insert, Update and Delete records within the supplied file. The following table details the numbers of these records which can be expected in the COU supply of the product:
Change type | Count |
---|---|
It is important that COUs are processed with Deletes first, then Inserts and Updates. This is to ensure that updates are applied in the correct order. Guidance on this can be found in the .
The following information relates to the currency of the source data used in the creation of this release of AddressBase Core:
This release note provides information about the release of the AddressBase Core product on 08 October 2024.
Product | Full Supply record count[*] | Change-Only Update record count |
---|---|---|
*These counts are based on a Managed Great Britain Set (MGBS). If you ordered your national coverage via the online ordering system using a polygon outline, your counts may differ.
There is a difference in record counts between taking a national Managed Great Britain Set (MGBS) and the national 5km-tile supply. This is because the two supplies use different selection criteria. The difference in record counts is shown in the following table, allowing you to validate your data holdings once you have loaded the latest release of AddressBase Core.
Product | MGBS Full Count | National 5km tiled supply | Difference |
---|---|---|---|
A small difference in record counts is expected due to there being several features supplied in the MGBS which fall outside of the tiled area.
If you receive a Change-Only Update (COU) supply for your AddressBase Core product, you will receive Insert, Update and Delete records within the supplied file. The following table details the numbers of these records which can be expected in the COU supply of the product:
Change type | Count |
---|---|
It is important that COUs are processed with Deletes first, then Inserts and Updates. This is to ensure that updates are applied in the correct order. Guidance on this can be found in the .
The following information relates to the currency of the source data used in the creation of this release of AddressBase Core:
This release note provides information about the release of the AddressBase Core product on 24 September 2024.
Product | Full Supply record count[*] | Change-Only Update record count |
---|---|---|
*These counts are based on a Managed Great Britain Set (MGBS). If you ordered your national coverage via the online ordering system using a polygon outline, your counts may differ.
There is a difference in record counts between taking a national Managed Great Britain Set (MGBS) and the national 5km-tile supply. This is because the two supplies use different selection criteria. The difference in record counts is shown in the following table, allowing you to validate your data holdings once you have loaded the latest release of AddressBase Core.
Product | MGBS Full Count | National 5km tiled supply | Difference |
---|---|---|---|
A small difference in record counts is expected due to there being several features supplied in the MGBS which fall outside of the tiled area.
If you receive a Change-Only Update (COU) supply for your AddressBase Core product, you will receive Insert, Update and Delete records within the supplied file. The following table details the numbers of these records which can be expected in the COU supply of the product:
Change type | Count |
---|---|
It is important that COUs are processed with Deletes first, then Inserts and Updates. This is to ensure that updates are applied in the correct order. Guidance on this can be found in the .
The following information relates to the currency of the source data used in the creation of this release of AddressBase Core:
This release note provides information about the release of the AddressBase Core product on 15 October 2024.
Product | Full Supply record count[*] | Change-Only Update record count |
---|---|---|
*These counts are based on a Managed Great Britain Set (MGBS). If you ordered your national coverage via the online ordering system using a polygon outline, your counts may differ.
There is a difference in record counts between taking a national Managed Great Britain Set (MGBS) and the national 5km-tile supply. This is because the two supplies use different selection criteria. The difference in record counts is shown in the following table, allowing you to validate your data holdings once you have loaded the latest release of AddressBase Core.
Product | MGBS Full Count | National 5km tiled supply | Difference |
---|---|---|---|
A small difference in record counts is expected due to there being several features supplied in the MGBS which fall outside of the tiled area.
If you receive a Change-Only Update (COU) supply for your AddressBase Core product, you will receive Insert, Update and Delete records within the supplied file. The following table details the numbers of these records which can be expected in the COU supply of the product:
Change type | Count |
---|---|
It is important that COUs are processed with Deletes first, then Inserts and Updates. This is to ensure that updates are applied in the correct order. Guidance on this can be found in the .
The following information relates to the currency of the source data used in the creation of this release of AddressBase Core:
This release note provides information about the release of the AddressBase Core product on 17 September 2024.
Product | Full Supply record count[*] | Change-Only Update record count |
---|
*These counts are based on a Managed Great Britain Set (MGBS). If you ordered your national coverage via the online ordering system using a polygon outline, your counts may differ.
There is a difference in record counts between taking a national Managed Great Britain Set (MGBS) and the national 5km-tile supply. This is because the two supplies use different selection criteria. The difference in record counts is shown in the following table, allowing you to validate your data holdings once you have loaded the latest release of AddressBase Core.
Product | MGBS Full Count | National 5km tiled supply | Difference |
---|
A small difference in record counts is expected due to there being several features supplied in the MGBS which fall outside of the tiled area.
If you receive a Change-Only Update (COU) supply for your AddressBase Core product, you will receive Insert, Update and Delete records within the supplied file. The following table details the numbers of these records which can be expected in the COU supply of the product:
Change type | Count |
---|
The following information relates to the currency of the source data used in the creation of this release of AddressBase Core:
This is not an extensive list of the applications AddressBase Core can be used in; many other GIS software applications and/or databases can be used to load the product.
Ordnance Survey does not recommend specific suppliers or software products, as the most appropriate system will depend on many factors, for example, the amount of data being taken, resources available within the organisation, the existing and planned information technology infrastructure and the applications that AddressBase products can be used for
This section provides step-by-step instructions on how to load the GPKG format of AddressBase Core into commonly-used GIS software.
This getting started guide provides instructions for using AddressBase Core in different software applications. Users with limited technical knowledge will be able to follow this guide.
AddressBase Core is an easy-to-use, accessible addressing data product that gives plug-and-play access to complete and accurate address data. It combines key elements from existing AddressBase products into a simplified product.
AddressBase Core's primary source of addressing information is Local Authorities who have the statutory responsibility to capture and maintain Great Britain's address data. This ensures that the data is both authentic and authoritative in nature. Records are supplemented with Royal Mail Postal Address File (PAF) information and additional Ordnance Survey information on the usage of the address and unique identifiers that allow links to other OS and third-party datasets. Please read Data sources in AddressBase general for further details.
Access to AddressBase Core data via a Public Sector Plan, Premium Plan, or Energy & Infrastructure plan.
Basic technical knowledge of Geographic Information Systems (GIS) and databases.
These instructions show you how to use AddressBase Core and include:
This section of the getting started guide takes you through the process of downloading and extracting your AddressBase Core supply.
AddressBase Core is supplied in two optional offerings:
As a Managed Great Britain Set (MGBS) which provides national Great Britain data in one of two formats: Comma Separated Values (CSV) and GeoPackage (GPKG).
In 5km tiles in one of two formats: CSV and GPKG. CSVs are supplied as individual tiles where multiples are selected, whereas GPKG are only ever supplied as one file.
We recommend that you copy your data supply to a backup medium, particularly if you take a COU supply to keep an archive of records. Please read for more Information on how to do this.
For reading purposes, we recommend you store the data on a single hard disc. This speeds up your computer's ability to read the data.
Unzipped file sizes for a full supply of the product are as follows:
CSV 8GB
GPKG 12GB
Unzipped file sizes of the COU will vary upon each release as this will be dependent on the number of changes or records within a given tile.
PSGA customers can download full supply and COU of AddressBase Core via our download service.
If you have ordered your data from our online portal, you will be sent an email with a link to a download page.
Within the PSGA members’ area, you can order and download the data that you require by clicking on Order Data, which is found under the Map Data heading.
Once you have selected Order Data, you will be presented with the Order page. From here, you can manage all your orders, including those for AddressBase products.
When you have placed an order for a product, the data will become available as a zipped data file.
The CSV and GPKG data are supplied in a compressed form (zip
). Some software can access these files directly, while others will require it to be unzipped.
To unzip the zipped data files (.zip
extension), use an unzipping utility found on most PCs, for example, WinZip. Alternatively, open-source zipping/unzipping software can be downloaded from the Internet, for example, 7-Zip.
The first level zip folder will contain the following:
Order Details.txt
– a summary of the order including order type, format and information on files supplied.
Zipped folder with the product inside – this will be named as follows: AddressBaseCore_{variant}_{order_date_YYYY-MM-DD}_{file_number_NNN}.{format}.zip
variant: FULL
or COU
order_date: Date the order was received, for example, 2020-02-11
file_number: Three-digit zero padded file number, for example, 001
format: csv
, gpkg
Example:
AddressBaseCore_FULL_2020-01-30_001.gpkg.zip
or
AddressBaseCore_COU_2020-01-30_001.csv.zip
The product within the ZIP folder will use the same naming convention as above but without the .zip
at the end.
All AddressBase products are available as a full supply or a Change Only Update (COU).
A COU means you will only be supplied with the features which have changed since your last supply.
The following sub-sections provide guidance on how you could potentially manage a COU supply of AddressBase Core using PostgreSQL.
Where angle brackets (<>) are used, you should be replace the entire string with your content. For example:
Becomes:
If referencing a schema, <schema_name>, can be placed in front of any <table_name>, for example:
At a high level, there are three types of change found within COU:
Deletes (CHANGE_TYPE ‘D’) are objects that have ceased to exist in the product since the last product refresh.
Inserts (CHANGE_TYPE ‘I’) are objects that have been newly inserted into the product since the last product refresh.
Updates (CHANGE_TYPE ‘U’) are objects that have been updated in the product since the last product refresh.
Before a COU is applied, there may be a business requirement to archive existing address records. The diagram below shows how to implement archiving with an AddressBase Core COU within a database.
Within AddressBase Core there will be no records with the same UPRN. You can test this by checking the number of records that have the same UPRN. The following SQL query notifies you of any duplicates.
This query should return 0 rows, and this confirms that there are no duplicates. As there are no duplicate records, we can use the UPRN to apply the COU.
Where there is a business requirement to keep the records that are being Updated and Deleted in a separate archive table, the following SQL will create an Archive Table. It will populate with records that are being Updated and Deleted from the live AddressBase Core table.
The following commands create an archive table of the records that are being updated and deleted from the existing table, for example, addressbase_core_archive
.
If this table already exists, you can use INSERT INTO <
abcore_archive_table_name
>
, rather than CREATE TABLE <
abcore_archive_table_name
> AS
.
The following commands deletes the records from the existing table, which are either updates or deletions.
The following command inserts the new insert records and the new updated records into the live BLPU table.
You can check that this has been successful by re-checking that there are no duplicate UPRNs.
If there is no requirement for archiving, follow these steps:
Now, delete the existing records that will be updated, for example, Updates and Deletions.
Insert the new updated records.
You can check that this has been successful by re-checking that there are no duplicate UPRNs.
This is not an extensive list of the applications AddressBase Core can be used in; many other GIS software applications and/or databases can be used to load the product.
Ordnance Survey does not recommend specific suppliers or software products, as the most appropriate system will depend on many factors, for example, the amount of data being taken, resources available within the organisation, the existing and planned information technology infrastructure and the applications that AddressBase products can be used for.
This section provides step-by-step instructions on how to load the CSV format of AddressBase Core into commonly-used GIS software.
BIGINT/NUMBER: The ESRI products, ArcMap, ArcGIS Desktop and ArcGIS Server, do not support the BIGINT/NUMBER
data type as an Object ID. Bear this in mind if the expectation is to use this data type directly with these products. As an alternative method to facilitate using ESRI software, you can store this data as a string and add a new Serial ID to act as the Object ID.
Column length: If you are loading AddressBase Core data directly into a database, you may need to increase the column length to accommodate language characters such as ^
. Some databases treat this as an additional character and therefore if you define the column length according to our specification there is a chance the load may fail. Please bear in mind such adjustments may be required depending on the database you use to load the data.
UPRN deletions: It is important to note if a UPRN is deleted and then reinserted, this does not compromise the integrity of the UPRN and its use as a primary key. If a delete is issued for a UPRN, this does not mean it will not reappear in subsequent supplies. There are several reasons this may happen:
The record has moved in location more than once, moving it out of your area of interest (AOI; therefore the record is deleted) but then back into your AOI in the future. This could also occur if you alter your AOI.
A record has failed data validation upon a change being made. This can result dependent on the change being made in the record being deleted and then reintroduced when the error is fixed by the data supplier.
If a UPRN is deleted, it will not be reallocated to a different property and it therefore remains the unique identifier for a property.
The following sections describes how to load AddressBase Core into two popular databases.
Data source | Date |
---|---|
Data source | Date |
---|---|
Data source | Date |
---|---|
Data source | Date |
---|---|
Data source | Date |
---|---|
Data source | Date |
---|---|
Data source | Date |
---|
In the click Download data, you will be required to enter a password to access the PSGA members’ area. On successful entry to the download service, you will be able to view all your orders in the members’ area and download your data.
Use the steps in to load the COU CSV into a new or existing table, for example, addressbase_core_cou
.
Use the steps in to load the COU CSV into a new or existing table, for example, addressbase_core_cou
.
Warning - In PostgreSQL version 11 or above, there is currently a glitch which does not allow a bulk load using a CSV. If this affects you, please follow the steps in to load the data into a GIS package and then retrospectively add it to your database.
Download PostgreSQL_AddressBase_Core_CreateTable.sql
from the AddressBase_Core
folder at
For each column of data you are loading, you need to specify a Data Type. The Microsoft SQL Server loader defaults each column to a String. The correct Data Types for each column are given in the .
Royal Mail Postcode Address File (PAF)
25 October 2024
National Land and Property Gazetteer
25 October 2024
One Scotland Gazetteer
07 October 2024
OS MasterMap Topography Layer
05 September 2024
Royal Mail Postcode Address File (PAF)
18 October 2024
National Land and Property Gazetteer
18 October 2024
One Scotland Gazetteer
07 October 2024
OS MasterMap Topography Layer
05 September 2024
Royal Mail Postcode Address File (PAF)
27 September 2024
National Land and Property Gazetteer
27 September 2024
One Scotland Gazetteer
16 September 2024
OS MasterMap Topography Layer
05 September 2024
Royal Mail Postcode Address File (PAF)
04 October 2024
National Land and Property Gazetteer
04 October 2024
One Scotland Gazetteer
16 September 2024
OS MasterMap Topography Layer
05 September 2024
Royal Mail Postcode Address File (PAF)
20 September 2024
National Land and Property Gazetteer
20 September 2024
One Scotland Gazetteer
16 September 2024
OS MasterMap Topography Layer
25 July 2024
Royal Mail Postcode Address File (PAF)
11 October 2024
National Land and Property Gazetteer
11 October 2024
One Scotland Gazetteer
07 October 2024
OS MasterMap Topography Layer
05 September 2024
Royal Mail Postcode Address File (PAF) | 13 September 2024 |
National Land and Property Gazetteer | 13 September 2024 |
One Scotland Gazetteer | 27 August 2024 |
OS MasterMap Topography Layer | 25 July 2024 |
AddressBase Core
34 522 521
31 545
AddressBase Core
34 522 521
34 522 514
7
Inserts
7 035
Updates
22 671
Deletes
1 839
COU populated 5km tile count
2 586
AddressBase Core
34 517 325
32 059
AddressBase Core
34 517 325
34 517 318
7
Inserts
6 966
Updates
22 919
Deletes
2 174
COU populated 5km tile count
2 735
AddressBase Core
34 502 183
71 215
AddressBase Core
34 502 183
34 502 176
7
Inserts
8 096
Updates
60 821
Deletes
2 298
COU populated 5km tile count
3 419
AddressBase Core
34 507 189
40 859
AddressBase Core
34 507 189
34 507 182
7
Inserts
8 252
Updates
29 361
Deletes
3 246
COU populated 5km tile count
3 039
AddressBase Core
34 496 385
30 516
AddressBase Core
34 496 385
34 496 378
7
Inserts
7 480
Updates
20 604
Deletes
2 432
COU populated 5km tile count
2 719
AddressBase Core
34 512 533
35 379
AddressBase Core
34 512 533
34 512 526
7
Inserts
7 684
Updates
25 355
Deletes
2 340
COU populated 5km tile count
3 442
AddressBase Core | 34 491 337 | 35 700 |
AddressBase Core | 34 491 337 | 34 491 330 | 7 |
Inserts | 8 395 |
Updates | 24 876 |
Deletes | 2 429 |
COU populated 5km tile count | 2 981 |
It is important that COUs are processed with Deletes first, then Inserts and Updates. This is to ensure that updates are applied in the correct order. Guidance on this can be found in the 'Working with COU data' page in the AddressBase Core Getting Started Guide.
The primary supply mechanism of AddressBase Core is a Managed Great Britain Set (MGBS). A MGBS supply is a supply of data for the whole of Great Britain; it is provided as a single file containing all records with headers already included (CSV) or the structure already defined (GPKG).
Public Sector Geospatial Agreement (PSGA) customers are also able to order individual or multiple 5km tiles of interest rather than a MGBS if they wish. This can be ordered as a Full Supply (GKPG and CSV formats) or Changed Tiles (CSV format only).
OS Partners are also able to access tile supplies.
If you receive your data as a MGBS; the filename will be constructed as (unzipped):
productName_supply_ccyy-mm-dd_vvv.format
Where:
productName: AddressBaseCore supply is defined as FULL
or COU
ccyy-mm-dd: The date the file was generated
vvv: The volume number of the file
format: The format of the files received, for example, csv
or gkpg
For example:
AddressBaseCore_FULL_2020-07-01_001.gkpg
(GKPG full supply)
AddressBaseCore_COU_2020-07-01_001.csv
(CSV COU supply)
If the data has been provided in a ZIP file the following convention will be followed:
productName_supply_ccyy-mm-dd_vv.format.zip
For example:
AddressBaseCore_FULL_2020-07-01_001.csv.zip
(CSV full supply zipped)
If you order a CSV format for one tile or a selection tiles, the filename of each tile will be:
ngxxyy.format
Where:
ngxxyy: The four-digit grid reference belonging to the 1 km south-west corner of the 5 km chunk.
format: The format of the files received, i.e. csv
.
For example:
NC4040.csv
(CSV Tile supply)
If the data has been provided in a ZIP file the following convention will be followed for each tile:
ngxxyy.zip
For example:
NC4040.zip
(Tile supply zipped)
If you order a GPKG format for one tile or a selection tiles, the filename will be constructed as:
OrderID.format
Where:
OrderID: The ID that is assigned to each order
format: The format of the files received, that is, gkpg
For example:
1002-1700-RAND-1000.gpkg
(CSV Tile Supply)
If the data has been provided in a ZIP file the following convention will be followed:
OrderID.format.zip
For example:
1002-1700-RAND-1000.gpkg.zip
(Tile supply zipped)
AddressBase Core is available as a Full Supply or Change Only Update (COU) for MGBS supplies. A COU supply of data contains records or files that have changed between product refresh cycles. The primary benefit in supplying data in this way is that volumes are smaller reducing the amount of data that requires processing when compared to a Full Supply.
COU data enables you to identify three types of change if they are using the Managed Great Britain Sets of data:
Deletes (CHANGE_TYPE ‘D’) are objects that have ceased to exist in your area of interest since the last product refresh.
Inserts (CHANGE_TYPE ‘I’) are objects that have been newly inserted into your area of interest since the last product refresh.
Updates (CHANGE_TYPE ‘U’) are objects that have been updated in your area of interest since the last product refresh.
A COU file for MGBS data can be identified by its naming convention as detailed in previous sections.
Any change record will be provided as a full record with the appropriate change type, as listed above.
A tile-based COU is supplied differently to the MGBS supplies. If a single address record has changed within a specified 5km tile, the entire 5km tile containing all features will be supplied. This means the user will need to remove all features that previously existed in the provided tile(s) and insert the entire new tile(s) in its place.
When users are Deleting, Inserting or Updating features it is up to the user to consider their archiving requirements. If deleted records are important to your business requirements you must take appropriate action to archive previous records.
A code list or enumeration is a controlled set of values which can be used to populate a specific column.
AddressBase Core code lists an enumerations:
This technical specification provides detailed technical information about AddressBase Core. It is targeted at technical users and software developers.
AddressBase Core is a simple, accessible addressing data product giving Plug and Play access to Great Britain addressing data and additional attribution, without being time-consuming or complex. It provides live addressing records for England, Wales and Scotland based on Local Authority holdings of the Local Land and Property Gazetteer (LLPG). Other attribution includes secondary level classifications (detailing the use and type of an address) and a representative point code describing the positional quality of coordinates.
This technical specification includes the following sections:
All AddressBase products include the Unique Property Reference Number (UPRN) and are based on same coordinate reference systems.
Please see the General AddressBase information section for additional information that applies across all AddressBase products.
The following sub-sections provide details about the attributes included in AddressBase Core, their data types in the different output formats, and other important metadata about them.
A non-persistent integer which is autogenerated and is required within the OGC GPKG format.
Attribute Name: Not provided (CSV), fid (GKPG)
Data Type: Integer
Multiplicity: [1]
Unique Property Reference Number (UPRN) assigned by the LLPG Custodian or Ordnance Survey.
Attribute Name: UPRN (CSV), uprn (GKPG)
Data Type: Integer
Size: 12
Multiplicity: [1]
UPRN of the parent Record if a parent-child relationship exists.
Attribute Name: PARENT_UPRN (CSV), parent_uprn (GKPG)
Data Type: Integer
Size: 12
Multiplicity: [0..1]
Royal Mail’s Unique Delivery Point Reference Number (UDPRN).
Attribute Name: UDPRN (CSV), udprn (GKPG)
Data Type: Integer
Size: 8
Multiplicity: [0..1]
Unique Street Reference Number assigned by the Street Name and Numbering Custodian OR Ordnance Survey depending on the address record.
Attribute Name: USRN (CSV), usrn (GKPG)
Data Type: Integer
Size: 8
Multiplicity: [1]
The Topographic Identifier taken from OS MasterMap Topography Layer. This TOID is assigned to the UPRN by performing a spatial intersection between the two identifiers. It consists of the letters ‘osgb’ and is followed by up to sixteen digits.
Attribute Name: TOID (CSV), toid (GKPG)
Data Type: varchar
Size: 20
Multiplicity: [0..1]
A code that describes the classification of the address record to a maximum of a secondary level.
Attribute Name: CLASSIFICATION_CODE (CSV), classification_code (GKPG)
Data Type: varchar
Size: 4
Multiplicity: [1]
You can download a complete list of classification codes at Classification codes.
A value in metres defining the x location in accordance with the British National Grid.
Attribute Name: EASTING (CSV), easting (GKPG)
Data Type: Float
Size: (precision, scale) – (8, 2)
Multiplicity: [1]
A value in metres defining the y location in accordance with the British National Grid.
Attribute Name: NORTHING (CSV), northing (GKPG)
Data Type: Float
Size: (precision, scale) – (9, 2)
Multiplicity: [1]
A value defining the Latitude location in accordance with the ETRS89 coordinate reference system.
Attribute Name: LATITUDE (CSV), latitude (GKPG)
Data Type: Float
Size: (precision, scale) – (9, 7)
Multiplicity: [1]
A value defining the Longitude location in accordance with the ETRS89 coordinate reference system.
Attribute Name: LONGITUDE (CSV), longitude (GKPG)
Data Type: Float
Size: (precision, scale) – (8, 7)
Multiplicity: [1]
Representative Point Code: this describes the accuracy of the coordinate that has been allocated to the UPRN as indicated by the Local Authority and enhanced using large scale OS data.
Attribute Name: RPC (CSV), rpc (GKPG)
Code List Name: RPCCode
Data Type: Integer
Size: 1
Multiplicity: [1]
The latest date on which any of the attributes on this record were last changed in CCYY-MM-DD format.
Attribute Name: LAST_UPDATE_DATE (CSV), last_update_date (GKPG)
Data Type: Date
Multiplicity: [1]
A single attribute containing text concatenation of the address elements separated by a comma.
Attribute Name: SINGLE_LINE_ADDRESS (CSV), single_line_address (GKPG)
Data Type: varchar
Size: 500
Multiplicity: [1]
Text concatenation of ‘PO BOX’ and the Post Office Box (PO Box) number or ‘BFPO’ and the British Forces Post Office number.
Attribute Name: PO_BOX (CSV), po_box (GKPG)
Data Type: varchar
Size: 13
Multiplicity: [0..1]
The organisation name is the business name given, when appropriate, to an address record.
Attribute Name: ORGANISATION (CSV), organisation (GKPG)
Data Type: varchar
Size: 100
Multiplicity: [0..1]
The sub-building name and/or number for the address record.
Attribute Name: SUB_BUILDING (CSV), sub_building (GKPG)
Data Type: varchar
Size: 110
Multiplicity: [0..1]
The building name is a description applied to a single address or a group of addresses.
Attribute Name: BUILDING_NAME (CSV), building_name (GKPG)
Data Type: varchar
Size: 110
Multiplicity: [0..1]
The building number is a number or range of numbers given to a single address or a group of addresses.
Attribute Name: BUILDING_NUMBER (CSV), building_number (GKPG)
Data Type: varchar
Size: 13
Multiplicity: [0..1]
Street/Road name for the address record.
Attribute Name: STREET_NAME (CSV), street_name (GKPG)
Data Type: varchar
Size: 100
Multiplicity: [0..1]
A locality defines an area or geographical identifier within a town, village or hamlet. Locality represents the lower level geographical area. The locality field should be used in conjunction with the town name and street description fields to uniquely identify geographic area where there may be more than one within an administrative area.
Attribute Name: LOCALITY (CSV), locality (GKPG)
Data Type: varchar
Size: 35
Multiplicity: [0..1]
Geographical town name assigned by the Local Authority. Please note this can be different from the Post Town value assigned by Royal Mail.
Attribute Name: TOWN_NAME (CSV), town_name (GKPG)
Data Type: varchar
Size: 35
Multiplicity: [0..1]
The town or city in which the Royal Mail sorting office is located which services this address record.
Attribute Name: POST_TOWN (CSV), post_town (GKPG)
Condition: POST_TOWN is not populated if this is the same as TOWN_NAME
Data Type: varchar
Size: 30
Multiplicity: [0..1]
Third level of geographic area name to record island names where appropriate.
Attribute Name: ISLAND (CSV), island (GKPG)
Data Type: varchar
Size: 50
Multiplicity: [0..1]
Third level of geographic area name to record island names where appropriate.
Attribute Name: POSTCODE (CSV), postcode (GKPG)
Data Type: varchar
Size: 8
Multiplicity: [1]
A two-character code uniquely identifying an individual delivery point within a postcode, assigned by Royal Mail.
Attribute Name: DELIVERY_POINT_SUFFIX (CSV), delivery_point-suffix (GKPG)
Data Type: varchar
Size: 2
Multiplicity: [0..1]
The Office for National Statistics Governmental Statistical Service (GSS) code representing the contributing Local Authority.
Attribute Name: GSS_CODE (CSV), gss_code (GKPG)
Data Type: varchar
Size: 9
Multiplicity: [0..1]
You can download a complete list of GSS codes at Government Statistical Services codes.
Type of record change.
Attribute Name: CHANGE_CODE (CSV), change_code (GKPG)
Code List Name: ChangeTypeCode
Data Type: varchar
Size: 1
Multiplicity: [1]
The Government Statistical Services (GSS) code is a nine character unique identifier for each local authority maintained by the Office for National Statistics.
A list of codes which describe the type of address contained within AddressBase Core.
Tiled orders allow you to select a small region of Great Britain (GB), rather than having to order the whole of GB. Ordering tiles, as opposed to full GB coverage, reduces the amount of data supplied. This reduces data storage size and the time it takes to process the data.
AddressBase Core tiles can be downloaded through Ordnance Survey’s download service. See Downloading a dataset for full details about accessing this service. To order tiles:
Access the OS orders site and select AddressBase Core – 5km DOWNLOAD.
Select either a self-drawn polygon, a rectangle or a postcode/place. These options are available in the toolbar above the map. Once you have selected your area of interest (AOI), you can proceed to place your order.
Dependent on whether you are a PSGA customer or an OS Partner, the tiles are supplied as either GKPG or CSV.
You are provided with all 5km tiles that intersect the drawn polygon. The diagram below shows what is supplied when completing a tile order. An area of interest is drawn (blue lines) and a tile is provided for anywhere the drawn area of interest intersects (green lines).
For a GPKG download, you receive tiled data incorporated into one single GKPG file. For CSV tile supplies, individual 5km tiles are supplied for each tile which intersects your AOI.
The diagram below illustrates the format, coverage and supply type of AddressBase Core, specifically highlighting the tile supply options.
Each supply type is covered in the sections that follow.
Both GB coverage and tiled supply of GKPG is produced as a full supply only. Both product variants result in you receiving one consolidated GPKG file for your order.
To use this in your GIS software, please refer to Getting started with AddressBase Core > GPKG data, which provides instructions to load GPKG into ArcGIS Pro, ArcMap, QGIS, MapInfo Professional and CadCorp Map Modeller.
Tiled orders are also an option for CSV supplies of AddressBase Core. The CSV is divided into 5km tiles with an individual CSV produced for each tile. This is the case for both full supply and COU. Each CSV is also be provided with a header, which needs to be considered if you want to consolidate multiple individual tiles into one single file.
One use case for taking tiled coverage is if you only need a small subset of addresses within GB, as this provides you with a smaller data holding than taking all of GB .
If you are planning on using the tile supplies for COU purposes, you need to understand the data structure of the full supply and COU files you will download.
If you select to receive COU tile supplies, if any record within a selected 5km tile is changed between two releases of data (each week), you will receive the entire 5km tile in your next supply containing all of the latest live records for that tile.
For example, as demonstrated in the table below, the original full supply contains the address 17 THE BROADS, PAMPHILL, WIMBORNE, BH21 4DR, and the next COU data does not . However, the full supply does include an additional record, 37 THE BADGERS, PAMPHILL, BH21 4SH. This means that the 17 THE BROADS address has been deleted between the two releases, and 37 THE BADGERS is a new address.
To implement COU, we recommend that you process the full supply and the COU data files into a common structure to be used in conjunction with SQL. You can do this by appending a tilename
column onto the full supply and COU data when the CSVs are merged, as shown in the table below.
AddressBaseCore_COU_2020-01-30_SU2075.csv.zip
Ordnance Survey provides FME Workbench and NodeJS scripts to help to pre-process the data as described in the sections that follow. You can access these scripts in our GitHub repository:
A README file with usage instructions is provided for both scripts.
You do not need you to unzip the data before processing.
The data, either full supply or COU, should now be combined in one CSV file, under one header, with an appended tilename
column. Once the data has been pre-processed, it can be loaded into any database. The next sub-sections will detail the different loads of full supply and COU.
Once the full supply CSV has been pre-processed, the COPY load method can be used to load the data into your primary database table:
In this example, addressbase_core
is the name of the table. You may use a different name. To use this table in a geospatial setting, geometry columns will need to be inserted using the following SQL:
A similar method can be used to insert the COU data into a database. Similarly, addressbase_core_cou
is the name given to the database table. You may use a different name.
If you are applying COU to your primary table, you should now have two tables in your selected database:
A primary table which contains some out-of-date data.
A COU table with the live data.
To update your primary table, there are two basic steps to follow using SQL commands:
Delete all rows that contain tilenames that match the tilenames of the incoming COU.
Insert all rows from the COU table to the primary table.
The following SQL commands will complete the application of COU into the primary table:
Index the tilename column on to the primary table:
Index the tilename column on to the COU table: CREATE INDEX ON addressbase_core_cou (tilename);
Delete from the primary table any records which have a tilename that matches a tilename from your COU table:
Insert the live COU data into the primary table:
Original full supply | COU records | COU change type |
---|---|---|
POST_TOWN | ISLAND | POSTCODE | DELIVERY_POINT_SUFFIX | GSS_CODE | CHANGE_CODE | TILENAME |
---|---|---|---|---|---|---|
BUNGALOW, BLANDFORD ROAD, WIMBORNE MINSTER, BH21 4DS
BUNGALOW, BLANDFORD ROAD, WIMBORNE MINSTER, BH21 4DS
I (INSERT)
17 THE BROADS, PAMPHILL, WIMBORNE, BH21 4DR
No data supplied
Not applicable
33 THE BROADS, PAMPHILL, WIMBORNE, BH21 4DR
33 THE BROADS, PAMPHILL, WIMBORNE, BH21 4DR
I (INSERT)
No data supplied
37 THE BADGERS, PAMPHILL, BH21 4SH
I (INSERT)
SN4 0HJ
1A
E06000030
I
SU2075
MARLBOROUGH
SN8 1SZ
1A
E06000054
I
SU2075
MARLBOROUGH
SN8 1SZ
1B
E06000054
I
SU2075