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...
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...
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...
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 for the AddressBase products
This release note provides information about the September 2024 (Epoch 113) release of AddressBase products.
This release note provides information about the August 2024 (Epoch 112) release of AddressBase products.
This release note provides information about the June 2024 (Epoch 111) release of AddressBase products.
This release note provides information about the May 2024 (Epoch 110) release of AddressBase products.
This release note provides information about the April 2024 (Epoch 109) release of AddressBase products.
The following AddressBase core principles pages provide an overview of the 'family' of AddressBase products. They cover core elements of design for AddressBase products, including data formats, coordinate reference systems, currency, precision, and data sources, amongst other topics.
These pages should be used in conjunction with the detailed technical specifications found under the top-level product guide page for each individual product.
This release note provides information about the August 2024 release of the AddressBase products. These products were released to customers on 15th August 2024.
Product | Full Supply Record Count[1] | Change-Only Update Record Count[2] |
---|---|---|
There is a difference in product counts between taking a national Managed Great Britain Set (MGBS) and a national Area of Interest (AOI). This is because the two supplies use different selection criteria. The differences are shown in the following table, allowing for you to validate your data holdings once you have loaded the latest release of AddressBase data.
The national AOI refers to the pre-selection GB polygon from our download store. Therefore, if you have drawn your own AOI, the count will vary.
If you are unsure of your supply type, please check this with your OS Relationship Manager.
If you receive a Change-Only Update (COU) supply for your AddressBase product, you will receive Insert, Update and Delete records within the supplied file. The following tables detail the numbers of these records which can be expected in an MGBS supply,and also how many tiles are affected if you take your supply as Changed Chunks.
The following information relates to the currency of the source data used in the creation of Epoch 112:
Affected output formats: CSV and GML
There are 5 675 Unique Property Reference Numbers (UPRNs) which reference a Parent UPRN which cannot be found in the product. This is because the Parent UPRN is either provisional or historic and is not matched to the Royal Mail Postcode Address File (PAF) or Valuation Office Agency (VOA) record, meaning that it is not included in the AddressBase Plus product as per the existing background logic rules.
There are 220 records with a sao_start_no or sao_text that have no Parent UPRN in the product. This is because the Parent UPRN is a historical record which is included as part of the logic for record inclusion in the AddressBase Plus product.
The match rates for Council Tax and Non-Domestic Rates for Epoch 112 are detailed as follows based on Valuation Office Agency (VOA) records up to 8th July 2024. The match rate is applicable to the AddressBase Premium product.
Work is being undertaken to improve the classifications of records within the AddressBase products. This work has resulted in 48 610 more tertiary classifications present in Epoch 112 compared to Epoch 111. Indeed, 88.72% of these tertiary classification improvements are against residential codes.
The following graph shows the number of Postcode Address File (PAF) matched records in AddressBase by epoch:
The next release of AddressBase products, Epoch 113, is scheduled for 26th September 2024.
These counts are based on a Managed Great Britain Set (MGBS). If you have ordered your national coverage via the online ordering system using a polygon outline, then your counts may differ.
Change-Only Updates are not available for the OS Open UPRN product.
This release note provides information about the September 2024 release of the AddressBase products. These products were released to customers on 26 September 2024.
Product | Full Supply Record Count[1] | Change-Only Update Record Count[2] |
---|---|---|
There is a difference in product counts between taking a national Managed Great Britain Set (MGBS) and a national Area of Interest (AOI). This is because the two supplies use different selection criteria. The differences are shown in the following table, allowing for you to validate your data holdings once you have loaded the latest release of AddressBase data.
The national AOI refers to the pre-selection GB polygon from our download store. Therefore, if you have drawn your own AOI, the count will vary.
If you are unsure of your supply type, please check this with your OS Relationship Manager.
If you receive a Change-Only Update (COU) supply for your AddressBase product, you will receive Insert, Update and Delete records within the supplied file. The following tables detail the numbers of these records which can be expected in an MGBS supply,and also how many tiles are affected if you take your supply as Changed Chunks.
The following information relates to the currency of the source data used in the creation of Epoch 113:
Affected output formats: CSV and GML
There are 6 504 Unique Property Reference Numbers (UPRNs) which reference a Parent UPRN that cannot be found in the product. This is because the Parent UPRN is either provisional or historic and is not matched to the Royal Mail Postcode Address File (PAF) or Valuation Office Agency (VOA) record, meaning that it is not included in the AddressBase Plus product as per the existing background logic rules.
There are 227 records with a sao_start_no or sao_text that have no Parent UPRN in the product. This is because the Parent UPRN is a historical record which is included as part of the logic for record inclusion in the AddressBase Plus products.
The match rates for Council Tax and Non-Domestic Rates for Epoch 113 are detailed as follows based on Valuation Office Agency (VOA) records up to 19 August 2024. The match rate is applicable to the AddressBase Premium product.
Work is being undertaken to improve the classifications of records within the AddressBase products. This work has resulted in 37 159 more tertiary classifications present in Epoch 113 compared to Epoch 112. Indeed, 88.71% of these tertiary classification improvements are against residential codes.
The following graph shows the number of Postcode Address File (PAF) matched records in AddressBase by epoch:
The next release of AddressBase products, Epoch 114, is scheduled for 07 November 2024.
These counts are based on a Managed Great Britain Set (MGBS). If you have ordered your national coverage via the online ordering system using a polygon outline, then your counts may differ.
Change-Only Updates are not available for the OS Open UPRN product.
This code list is used in association with the attribute addressbasePostalCode/ADDRESSBASE_POSTAL_CODE found on the BLPU table. The code list describes the record as postal or not as defined by Addressbase logic.
Value | Description |
---|
AddressBase, AddressBase Plus, AddressBase Premium and AddressBase Islands are updated every six weeks. This six week period of time is known as an epoch.
Our AddressBase products are currently available as a full supply or Change-Only Update (COU) for each epoch.
Future dates are provided as an indication only and are subject to change. Data cut dates are estimates; these are given to provide an indication of the last point at which changes will reach the epoch.
As we approach the publication date and prepare to release a new epoch, any new requests placed for data will be paused to ensure data integrity. These requests will be processed as soon as this pause is lifted.
The AddressBase product family is made up of four products:
AddressBase products are created by bringing together different address sources:
Local Authority Gazetteers for England, Wales and Scotland
Royal Mail PAF data
References to Valuation Office Agency (VOA) data
Additional addresses and coordinates from Ordnance Survey
This information is managed by under a joint venture partnership between Local Government Association and Ordnance Survey (OS). Scottish Local Authority address information is supplied to GeoPlace under licence between Ordnance Survey and the Improvement Service supported by the Scottish Government.
Ordnance Survey is responsible for customer management, sales, marketing and distribution of the AddressBase products.
This comparison table highlights the similarities and differences between the AddressBase products
AddressBase | AddressBase Core | AddressBase Plus | AddressBase Premium |
---|
The four AddressBase products have been designed to meet distinct customer requirements. The source data is collated, verified and quality assured by GeoPlace.
AddressBase Premium provides the most detailed view of an address and its life cycle for England, Wales and Scotland. It has approximately 40 million addresses as it records an address from creation through to retirement. All address records are provided with a Unique Property Reference Number (UPRN).
There are over 100 million cross-references which include references to VOA data and products such as OS MasterMap Topography Layer and OS Highways Layer are also included.
The product contains Local Authority, Ordnance Survey and Royal Mail addresses. This includes alternative addresses for current records where available, indicating variations on the official addresses and/or addresses in different languages (Welsh or Gaelic); as well as including provisional addresses (proposed planning developments), and historic information (demolished properties) where available. Other addresses known as Objects Without a Postal Address (OWPAs) are also included in AddressBase Premium, these include places of worship, community centres and utilities.
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 Plus contains current properties using addresses sourced from Local Authorities, Ordnance Survey and Royal Mail for England, Wales and Scotland. The product currently contains approximately 37 million records.
The product contains all current addresses validated from Local Custodians and non-postal addresses such as ponds, electricity sub-stations and telephone boxes are also included.
The product enables the end-user to locate an address or property on a map using either X, Y coordinates supplied on a British National Grid or Latitude and Longitude coordinates provided on an ETRS89 projection, and display the Local Authority address elements or the Royal Mail address elements where matched.
This product will provide you with a single view of an address, allow you to locate this address on a map to give you a geographic view and carry out primary analysis on the function of the address to determine, for example, residential from commercial properties.
This release note provides information about the April 2024 release of the AddressBase products. These products were released to customers on 05 April 2024.
Product | Full Supply Record Count[1] | Change-Only Update Record Count[2] |
---|
There is a difference in product counts between taking a national Managed Great Britain Set (MGBS) and a national Area of Interest (AOI). This is because the two supplies use different selection criteria. The differences are shown in the following table, allowing for you to validate your data holdings once you have loaded the latest release of AddressBase data.
The national AOI refers to the pre-selection GB polygon from our download store. Therefore, if you have drawn your own AOI, the count will vary.
If you are unsure of your supply type, please check this with your OS Relationship Manager.
If you receive a Change-Only Update (COU) supply for your AddressBase product, you will receive Insert, Update and Delete records within the supplied file. The following tables detail the numbers of these records which can be expected in an MGBS supply,and also how many tiles are affected if you take your supply as Changed Chunks.
The following information relates to the currency of the source data used in the creation of Epoch 109:
Affected output formats: CSV and GML
There are 5 021 Unique Property Reference Numbers (UPRNs) which reference a Parent UPRN which cannot be found in the product. This is because the Parent UPRN is either provisional or historic and is not matched to the Royal Mail Postcode Address File (PAF) or Valuation Office Agency (VOA) record, meaning that it is not included in the AddressBase Plus product as per the existing background logic rules.
There are 254 records with a sao_start_no or sao_text that have no Parent UPRN in the product. This is because the Parent UPRN is a historical record which is included as part of the logic for record inclusion in the AddressBase Plus product.
The match rates for Council Tax and Non-Domestic Rates for Epoch 109 are detailed as follows based on Valuation Office Agency (VOA) records up to 26 February 2024. The match rate is applicable to the AddressBase Premium product.
Work is being undertaken to improve the classifications of records within the AddressBase products. This work has resulted in 47 161 more tertiary classifications present in Epoch 109 compared to Epoch 108. Indeed, 88.77% of these tertiary classification improvements are against residential codes.
The following graph shows the number of Postcode Address File (PAF) matched records in AddressBase by epoch:
Notification of Epoch 109’s Improvement in Historic BLPU State Code Completeness and Large Release Size
This release includes an enhancement in the clarity and consistency of life cycle representation within product.
A conformance improvement has been delivered for BLPU State attribute for records where the BLPU Logical Status was 8 (historic) and BLPU State was null, for increased completeness BLPU State Code has been populated with value 4 (no longer existing) and date stamped for the change applied.
The BLPU state identifies the current life cycle stage of a property (or object) and is additional to the mandatory LOGICAL_ STATUS field.
The BLPU code is an optional attribute for Local Authority Custodians to complete and therefore this attribute may be NULL in product.
An improvement to the completeness of the BLPU State Code was identified as a quality enhancement for life cycle information as values for BLPU state code 4 can be accurately inferred from a Logical Status of 8. This enhancement allows the data to be interpreted more easily by removing conflict between addresses with a historic logical status and no BLPU state.
All nations within GB and the Islands product regions will benefit from this improvement, as such it impacts approximately 1.2 million records for a full supply.
This quality improvement means a larger than usual supply of COUs.
The next release of AddressBase products, Epoch 110, is scheduled for 16th May 2024.
These counts are based on a Managed Great Britain Set (MGBS). If you have ordered your national coverage via the online ordering system using a polygon outline, then your counts may differ.
Change-Only Updates are not available for the OS Open UPRN product.
The AddressBase classification scheme provides varying levels of classification for addressable objects which are captured and maintained by the Local Authorities and Ordnance Survey. This allows searches to be limited on residential or commercial addresses or be more specific to find all the flats or all fast-food outlets. The varying levels of classification are as follows:
Primary Level Classification R: Residential C: Commercial
Secondary Level Classification RD: Residential Dwelling CH: Hotel/Motel/ Boarding/ Guest House
Tertiary Level Classification RD02: Detached House CH01: Boarding/Guest House/ Bed And Breakfast/Youth Hostel
Quaternary Level CH01YH: Youth Hostel
The level of classification varies across all addressable objects and across the different products.
There are only certain classification codes that extend to the quaternary classification level as shown above. A full list of the classification codes can be found on our page.
This release note provides information about the June 2024 release of the AddressBase products. These products were released to customers on 27th June 2024.
Product | Full Supply Record Count[1] | Change-Only Update Record Count[2] |
---|
There is a difference in product counts between taking a national Managed Great Britain Set (MGBS) and a national Area of Interest (AOI). This is because the two supplies use different selection criteria. The differences are shown in the following table, allowing for you to validate your data holdings once you have loaded the latest release of AddressBase data.
The national AOI refers to the pre-selection GB polygon from our download store. Therefore, if you have drawn your own AOI, the count will vary.
If you are unsure of your supply type, please check this with your OS Relationship Manager.
If you receive a Change-Only Update (COU) supply for your AddressBase product, you will receive Insert, Update and Delete records within the supplied file. The following tables detail the numbers of these records which can be expected in an MGBS supply,and also how many tiles are affected if you take your supply as Changed Chunks.
The following information relates to the currency of the source data used in the creation of Epoch 111:
Affected output formats: CSV and GML
There are 6 189 Unique Property Reference Numbers (UPRNs) which reference a Parent UPRN which cannot be found in the product. This is because the Parent UPRN is either provisional or historic and is not matched to the Royal Mail Postcode Address File (PAF) or Valuation Office Agency (VOA) record, meaning that it is not included in the AddressBase Plus product as per the existing background logic rules.
There are 254 records with a sao_start_no or sao_text that have no Parent UPRN in the product. This is because the Parent UPRN is a historical record which is included as part of the logic for record inclusion in the AddressBase Plus product.
The match rates for Council Tax and Non-Domestic Rates for Epoch 111 are detailed as follows based on Valuation Office Agency (VOA) records up to 20th May 2024. The match rate is applicable to the AddressBase Premium product.
Work is being undertaken to improve the classifications of records within the AddressBase products. This work has resulted in 40 932 more tertiary classifications present in Epoch 111 compared to Epoch 110. Indeed, 88.74% of these tertiary classification improvements are against residential codes.
The following graph shows the number of Postcode Address File (PAF) matched records in AddressBase by epoch:
The next release of AddressBase products, Epoch 112, is scheduled for 15th August 2024.
These counts are based on a Managed Great Britain Set (MGBS). If you have ordered your national coverage via the online ordering system using a polygon outline, then your counts may differ.
Change-Only Updates are not available for the OS Open UPRN product.
Product | MGBS Full Count | National AOI Full Count | Difference |
---|---|---|---|
Change Type | Count |
---|---|
Change Type | Count |
---|---|
AddressBase Premium Table | Inserts | Updates | Deletes |
---|---|---|---|
Data Source | Date |
---|---|
Product | MGBS Full Count | National AOI Full Count | Difference |
---|---|---|---|
Change Type | Count |
---|---|
Change Type | Count |
---|---|
AddressBase Premium Table | Inserts | Updates | Deletes |
---|---|---|---|
Data Source | Date |
---|---|
Data Source | Records Received | % Matched |
---|---|---|
AddressBase provides a current view of all Royal Mail PAF addresses that have been matched to the NLPG and OSG . The product provides Royal Mail attribution as well as enhancing PAF with X and Y coordinates on the British National Grid and ETRS89 coordinate reference system and providing the classification of an address to a primary level (see the for further details on classification levels). It also provides a primary level classification.
Product | MGBS Full Count | National AOI Full Count | Difference |
---|
Change Type | Count |
---|
Change Type | Count |
---|
AddressBase Premium Table | Inserts | Updates | Deletes |
---|
Product | MGBS Full Count | National AOI Full Count | Difference |
---|
Change Type | Count |
---|
Change Type | Count |
---|
AddressBase Premium Table | Inserts | Updates | Deletes |
---|
Data Source | Date |
---|
Data Source | Records Received | % Matched |
---|
OS OpenUPRN
40 873 566
N/A
AddressBase
30 528 787
164 532
AddressBase Plus
38 125 445
864 998
AddressBase Premium
See rows below
See rows below
Street
1 508 646
7531
Street Descriptor
1 631 995
5970
BLPU
40 873 566
462 545
Classification
44 728 771
175 302
LPI
46 041 542
231 655
Organisation
1 421 542
25 452
Delivery Point Address
30 635 054
74 237
Application Cross Ref.
198 155 853
843 499
Successor
0
0
AddressBase
30 528 787
30 528 787
0
AddressBase Plus
38 125 445
38 125 425
20
AddressBase Premium
See rows below
See rows below
See rows below
Street
1 508 646
1 508 643
3
Street Descriptor
1 631 995
1 631 992
3
BLPU
40 873 566
40 873 542
24
Classification
44 728 771
44 728 747
24
LPI
46 041 542
46 041 517
25
Organisation
1 421 542
1 421 540
2
Delivery Point Address
30 635 054
30 635 054
0
Application Cross Ref.
198 155 853
198 155 829
24
Successor
0
0
0
Inserts
46 546
Updates
107 529
Deletes
10 457
COU Populated Tile Count
5 390
Inserts
58 383
Updates
791 040
Deletes
15 575
COU Populated Tile Count
7 931
Street
1 527
5 822
182
Street Descriptor
1 751
4 032
187
BLPU
51 831
406 735
3 979
Classification
64 820
89 524
20 958
LPI
67 711
159 116
4 828
Organisation
9 398
6 111
9 943
Delivery Point Address
46 773
17 519
9 945
Application Cross Ref.
237 145
560 552
45 802
Royal Mail PAF
11 July 2024
National Land and Property Gazetteer
11 July 2024
One Scotland Gazetteer
17 June 2024
VOA Non-Domestic Rates
08 July 2024
VOA Council Tax
08 July 2024
OS MasterMap Topography Layer
25 June 2024
OS MasterMap Highways Network
04 July 2024
Code-Point with Polygons
01 July 2024
Boundary-Line
24 June 2024
Data Source
Records Received
% Matched
Council Tax
27 116 559
99.92
Non-Domestic Rates
2 123 229
96.47
OS OpenUPRN
40 909 714
N/A
AddressBase
30 552 484
137 772
AddressBase Plus
38 156 204
677 294
AddressBase Premium
See rows below
See rows below
Street
1 509 895
5 780
Street Descriptor
1 633 461
2 501
BLPU
40 909 714
355 256
Classification
44 758 076
125 856
LPI
46 089 180
182 176
Organisation
1 422 866
14 505
Delivery Point Address
30 659 580
54 376
Application Cross Ref.
198 307 242
735 178
Successor
0
0
AddressBase
30 552 484
30 552 484
0
AddressBase Plus
38 156 204
38 156 184
20
AddressBase Premium
See rows below
See rows below
See rows below
Street
1 509 895
1 509 892
3
Street Descriptor
1 633 461
1 633 458
3
BLPU
40 909 714
40 909 690
24
Classification
44 758 076
44 758 052
24
LPI
46 089 180
46 089 155
25
Organisation
1 422 866
1 422 864
2
Delivery Point Address
30 659 580
30 659 580
0
Application Cross Ref.
198 307 242
198 307 218
24
Successor
0
0
0
Inserts
32 275
Updates
96 919
Deletes
8 578
COU Populated Tile Count
5 003
Inserts
43 451
Updates
621 151
Deletes
12 692
COU Populated Tile Count
7 088
Street
1 264
4 501
15
Street Descriptor
1 484
999
18
BLPU
39 273
312 858
3 125
Classification
47 617
59 927
18 312
LPI
51 254
127 306
3 616
Organisation
5 675
4 479
4 351
Delivery Point Address
32 839
13 224
8 313
Application Cross Ref.
183 150
520 267
31 761
Royal Mail PAF
22 August 2024
National Land and Property Gazetteer
22 August 2024
One Scotland Gazetteer
05 August 2024
VOA Non-Domestic Rates
19 August 2024
VOA Council Tax
19 August 2024
OS MasterMap Topography Layer
13 August 2024
OS MasterMap Highways Network
06 August 2024
Code-Point with Polygons
01 July 2024
Boundary-Line
24 June 2024
Council tax
27 145 616
99.92
Non-domestic rates
2 122 260
96.47
D | A record which is linked to PAF |
N | Not a postal address |
C | A record which is postal and has a parent record which is linked to PAF |
L | A record which is identified as postal based on Local Authority information |
OS OpenUPRN | 40 744 085 | N/A |
AddressBase | 30 440 058 | 141 664 |
AddressBase Plus | 38 013 634 | 641 116 |
AddressBase Premium | See rows below | See rows below |
Street | 1 504 346 | 5 403 |
Street Descriptor | 1 627 151 | 2 603 |
BLPU | 40 744 085 | 1 651 993 |
Classification | 44 612 110 | 167 219 |
LPI | 45 869 982 | 152 914 |
Organisation | 1 415 880 | 17 270 |
Delivery Point Address | 30 544 920 | 69 763 |
Application Cross Ref. | 197 640 540 | 614 650 |
Successor | 0 | 0 |
AddressBase | 30 440 058 | 30 440 058 | 0 |
AddressBase Plus | 38 013 634 | 38 013 615 | 19 |
AddressBase Premium | See rows below | See rows below | See rows below |
Street | 1 504 346 | 1 504 345 | 1 |
Street Descriptor | 1 627 151 | 1 627 150 | 1 |
BLPU | 40 744 085 | 40 744 062 | 23 |
Classification | 44 612 110 | 44 612 087 | 23 |
LPI | 45 869 982 | 45 869 958 | 24 |
Organisation | 1 415 880 | 1 415 878 | 2 |
Delivery Point Address | 30 544 920 | 30 544 920 | 0 |
Application Cross Ref. | 197 640 540 | 197 640 517 | 23 |
Successor | 0 | 0 | 0 |
Inserts | 38 002 |
Updates | 91 196 |
Deletes | 12 466 |
COU Populated Tile Count | 5 410 |
Inserts | 55 152 |
Updates | 571 494 |
Deletes | 14 470 |
COU Populated Tile Count | 7 157 |
Street | 1 560 | 3 826 | 17 |
Street Descriptor | 1 603 | 982 | 18 |
BLPU | 54 407 | 1 594 091 | 3 495 |
Classification | 68 978 | 75 921 | 22 320 |
LPI | 67 818 | 80 668 | 4 428 |
Organisation | 7 066 | 5 090 | 5 114 |
Delivery Point Address | 38 799 | 18 094 | 12 870 |
Application Cross Ref. | 225 972 | 348 380 | 40 298 |
Data Source | Date |
Royal Mail PAF | 01 March 2024 |
National Land and Property Gazetteer | 01 March 2024 |
One Scotland Gazetteer | 12 February 2024 |
VOA Non-Domestic Rates | 26 February 2024 |
VOA Council Tax | 26 February 2024 |
OS MasterMap Topography Layer | 20 February 2024 |
OS MasterMap Highways Network | 06 February 2024 |
Code-Point with Polygons | 04 January 2024 |
Boundary-Line | 03 October 2023 |
Data Source | Records Received | % Matched |
Council Tax | 27 033 727 | 99.95 |
Non-Domestic Rates | 2 120 769 | 96.58 |
OS OpenUPRN | 40 825 714 | N/A |
AddressBase | 30 492 698 | 123 335 |
AddressBase Plus | 38 082 637 | 2 269 935 |
AddressBase Premium | See rows below | See rows below |
Street | 1 507 301 | 5 983 |
Street Descriptor | 1 630 431 | 3 057 |
BLPU | 40 825 714 | 345 400 |
Classification | 44 684 909 | 124 243 |
LPI | 45 978 659 | 140 285 |
Organisation | 1 422 087 | 17 612 |
Delivery Point Address | 30 598 226 | 59 126 |
Application Cross Ref. | 197 964 510 | 4 430 729 |
Successor | 0 | 0 |
AddressBase | 30 492 698 | 30 492 698 | 0 |
AddressBase Plus | 38 082 637 | 38 082 617 | 20 |
AddressBase Premium | See rows below | See rows below | See rows below |
Street | 1 507 301 | 1 507 299 | 2 |
Street Descriptor | 1 630 431 | 1 630 429 | 2 |
BLPU | 40 825 714 | 40 825 690 | 24 |
Classification | 44 684 909 | 44 684 885 | 24 |
LPI | 45 978 659 | 45 978 634 | 25 |
Organisation | 1 422 087 | 1 422 085 | 2 |
Delivery Point Address | 30 598 226 | 30 598 226 | 0 |
Application Cross Ref. | 197 964 510 | 197 964 486 | 24 |
Successor | 0 | 0 | 0 |
Inserts | 33 506 |
Updates | 80 002 |
Deletes | 9 827 |
COU Populated Tile Count | 5 140 |
Inserts | 45 949 |
Updates | 2 210 934 |
Deletes | 13 052 |
COU Populated Tile Count | 7 162 |
Street | 1 515 | 4 445 | 23 |
Street Descriptor | 1 715 | 1 318 | 24 |
BLPU | 45 313 | 296 305 | 3 782 |
Classification | 54 659 | 51 341 | 18 243 |
LPI | 60 087 | 75 180 | 5 018 |
Organisation | 7 895 | 4 900 | 4 817 |
Delivery Point Address | 33 606 | 16 076 | 9 444 |
Application Cross Ref. | 2 114 566 | 373 554 | 1 942 609 |
Royal Mail PAF | 23 May 2024 |
National Land and Property Gazetteer | 23 May 2024 |
One Scotland Gazetteer | 06 May 2024 |
VOA Non-Domestic Rates | 20 May 2024 |
VOA Council Tax | 20 May 2024 |
OS MasterMap Topography Layer | 14 May 2024 |
OS MasterMap Highways Network | 07 May 2024 |
Code-Point with Polygons | 04 January 2024 |
Boundary-Line | 01 May 2023 |
Council Tax | 27 084 483 | 99.94 |
Non-Domestic Rates | 2 123 193 | 96.48 |
UPRN |
Local Authority current address |
PAF Address – Royal Mail addresses |
PAF UDPRN – Royal Mail’s delivery reference system |
Single line address |
Simple classification |
Advanced classification |
Cross-reference with third party datasets |
Alternate addresses |
Lifecycle data |
A critical step in the creation of an address is undertaken within each Local Authority by the dedicated Street Name and Numbering (SNN) custodian and the Scottish Local Street Gazetteer (LSG) custodians, who allocates the official street name and building information.
The SNN/LSG custodian has a statutory obligation to provide SNN/LSG information for all addresses within their administrative area. Once the SNN/LSG custodian has fulfilled their statutory obligation for initial capture, the LLPG/OSG custodian will maintain the address for the life of the address record.
The official street name and building information for new properties captured by the SNN/LSG custodians is provided to Royal Mail who then allocate a postcode to the address.
The Unique Property Reference Number (UPRN) is the persistent identifier providing consistency across the AddressBase products range.
Each address record has a UPRN, which provides a reference key to join related address records across different datasets.
Throughout its life cycle, information on the address of a property can change. This may be due to a change of name, change of use, or the eventual demolition of the property. All these changes are reflected against the same UPRN meaning that users are aware that it is the same physical property.
Please be aware that the UPRN is not the Primary Key for all tables within the AddressBase Premium and AddressBase Premium Islands supply. Please see the relational models in AddressBase Premium structure and AddressBase Premium Islands structure for more information.
AddressBase products has two coordinate reference systems (CRS) present within the data:
British National Grid (BNG)
European Terrestrial Reference System 89 (ETRS89)
BNG uses the OSGB36 geodetic datum and a single Transverse Mercator projection for the whole of Great Britain. Positions on this projection are described using Easting and Northing coordinates in units of metres. The BNG is a horizontal spatial reference system only; it does not specify a vertical (height) reference system.
ETRS89 is the EU-recommended frame of reference for European data and is represented as Latitude and Longitude values. ETRS89 is a horizontal spatial reference system only; it does not specify a vertical (height) reference system.
Updates are continuously made to the central spatial address data hub, which is managed by GeoPlace. These are used to produce the AddressBase Core product, which is supplied on a weekly basis. An extract is taken for the creation of AddressBase, AddressBase Plus and AddressBase Premium on a 6-weekly basis.
Quality control procedures are undertaken at all stages of production to ensure that the data is as accurate and complete as possible and conforms to the specification. These quality control checks include automated data testing against the product specification and visual checks by operators.
Coordinates for all addressable objects with each AddressBase product are published with geometry given to a precision of up to 2 decimal places for British National Grid coordinates, and up to 7 decimal places for ETRS89 coordinates.
A code list is a controlled set of allowable labels or codes represented as an alphanumeric attribute. The pages in this section show the code lists used within the OS Emergency Services Gazetteer (ESG). Some of the code lists apply to attributes of multiple feature types, whereas others will only apply to attributes of one feature type.
Through collaborative working between Ordnance Survey, GeoPlace, the Local Government Agency and Improvement Service, a single definitive spatial address database for Great Britain has been created and maintained since September 2011 for England and Wales, and April 2012 for Scotland.
This initiative supports the UK Location Strategy concept of a 'core reference geography', including the key principles of the European Union INSPIRE directive, that data should only be collected once and kept where it can be maintained most effectively.
The creation of AddressBase products brings together the best parts of:
The National Land and Property Gazetteer (NLPG) provides the most up-to-date addresses including street names and numbers from each Local Authority’s LLPG in England and Wales. This data also provides a Unique Property Reference Number (UPRN) for each address encompassing residential, commercial and public infrastructure such as fire stations.
One Scotland Address Gazetteer (OSG) provides the most up-to-date addresses including street names and numbers from each Scottish Local Authority’s CAG. This data also provides a Unique Property Reference Number (UPRN) for each address encompassing residential, commercial and public infrastructure such as fire stations.
Ordnance Survey provides a wide range of additional addresses including Objects Without a Postal Address (OWPAs) such as Telephone Exchanges, a wider spatial context by including references for both the OS MasterMap Topography Layer and OS MasterMap Highways Networks Layer which the address feature is related to and additional classification information.
PAF contains approximately 30 million Royal Mail addresses that are identified as receiving post in Great Britain. Addresses from the NLPG and OSG are matched to the PAF addresses to provide the Unique Delivery Point Reference Number (UDPRN) into product and supplement the Local Authority address with information such as organisation name, postal town and postcode.
The Valuation Office Agency (VOA) gives the government the valuations and property advice needed to support taxation and benefits within England and Wales. Addresses from the NLPG are matched to the VOA address to provide the Unique Address Reference Number (UARN), VOA Special Category and Primary Description classification codes in product.
GeoPlace is a limited liability partnership jointly owned by the Local Government Association and Ordnance Survey and is the centre of excellence for spatial address and street information in Great Britain. GeoPlace brings together local government's address and streets gazetteers with information from Ordnance Survey, Improvement Service, Royal Mail’s PAF dataset and VOA addresses into a central spatial address data hub. The database hub is updated by GeoPlace based upon the receipt of data from all the contributing data sources.
GeoPlace manage this hub and provide address and street information to be utilised in the AddressBase products.
At present, there are 314 local authorities in England and Wales, inputting updates to their Local Land and Property Gazetteers (LLPG). These changes are submitted to the GeoPlace Hub daily, weekly or monthly as part of their update schedule.
On receipt of these updates, they are checked to ensure that they have been produced in accordance with the NLPG Data Entry Conventions and they are in compliance with the national standard for the representation of address information – BS 7666 Parts 1 and 2.
There are currently 32 local authorities in Scotland which update their local address gazetteers on a daily, weekly or monthly as part of their update schedule to the OSG. The Improvement Service check each
update to ensure compliance with the national standard for addressing (BS7666.2006) and the Scottish Gazetteer Conventions 1-3.
One of the key strengths of AddressBase products is the collection and verification of data at the local level. A real benefit is the capture of addresses at the earliest point in their lifecycle, and then this address being maintained by the local authority.
To do this the Local Custodians will utilise the wealth of information at their disposal until the address is demolished (when it becomes a historical record).
Local Custodians will use information such as:
Building and Development control
Planning and Land Charges
Waste Collection
Electoral Roll
LLPG custodians (England and Wales) are allocated sequential batches of UPRNs by GeoPlace, which are assigned by the LLPG custodian at the creation of a new address.
The OSG (Scotland) custodians are allocated sequential batches of UPRNs by the Improvement Service, which are assigned by the OSG custodian at the creation of a new address.
Welcome to the OS Download Products' documentation platform!
This is a self-serve portal containing documentation and guides relating to OS Premium and OpenData Download products available to download through the OS Data Hub. It is one of several key platforms that support OS data and services, including:
Ordnance Survey provides two types of Download data product – OS Premium and OS OpenData.
When we refer to Premium products we mean paid-for datasets – whether they’re paid for by businesses, purchased through an OS Partner, or accessed free at the point of use under the Public Sector Mapping Agreement (PSGA).
The OS Premium Download data products are available to download in a range of formats, with a variety of ordering options, through the OS Data Hub on our Premium, Public Sector and Energy and Infrastructure plans.
Our Premium Download data products work in a range of software, including ESRI ArcGIS, QGIS, Mapbox, Cadcorp SIS, MapInfo, Tableau, Kepler.gl and many more.
OS OpenData Download products are free to use by anyone for any purpose – including for services from which you make a profit.
The OS OpenData Download products are available to download in a variety of formats, with a variety of ordering options, through the OS Data Hub.
The terms and conditions on which the OS Premium Download data products are made available can be found via the applicable links on the legal information pages of the OS Data Hub.
The terms and conditions on which the OS OpenData Download products are made available are contained within the Open Government Licence and can be found via the applicable links on the legal information pages of the OS Data Hub.
This release note provides information about the May 2024 release of the AddressBase products. These products were released to customers on 16 May 2024.
Product | Full Supply Record Count[1] | Change-Only Update Record Count[2] |
---|---|---|
There is a difference in product counts between taking a national Managed Great Britain Set (MGBS) and a national Area of Interest (AOI). This is because the two supplies use different selection criteria. The differences are shown in the following table, allowing for you to validate your data holdings once you have loaded the latest release of AddressBase data.
The national AOI refers to the pre-selection GB polygon from our download store. Therefore, if you have drawn your own AOI, the count will vary.
If you are unsure of your supply type, please check this with your OS Relationship Manager.
If you receive a Change-Only Update (COU) supply for your AddressBase product, you will receive Insert, Update and Delete records within the supplied file. The following tables detail the numbers of these records which can be expected in an MGBS supply,and also how many tiles are affected if you take your supply as Changed Chunks.
The following information relates to the currency of the source data used in the creation of Epoch 110:
Affected output formats: CSV and GML
There are 5 420 Unique Property Reference Numbers (UPRNs) which reference a Parent UPRN which cannot be found in the product. This is because the Parent UPRN is either provisional or historic and is not matched to the Royal Mail Postcode Address File (PAF) or Valuation Office Agency (VOA) record, meaning that it is not included in the AddressBase Plus product as per the existing background logic rules.
There are 240 records with a sao_start_no or sao_text that have no Parent UPRN in the product. This is because the Parent UPRN is a historical record which is included as part of the logic for record inclusion in the AddressBase Plus product.
The match rates for Council Tax and Non-Domestic Rates for Epoch 110 are detailed as follows based on Valuation Office Agency (VOA) records up to 08 April 2024. The match rate is applicable to the AddressBase Premium product.
Work is being undertaken to improve the classifications of records within the AddressBase products. This work has resulted in 38 568 more tertiary classifications present in Epoch 110 compared to Epoch 109. Indeed, 88.75% of these tertiary classification improvements are against residential codes.
The following graph shows the number of Postcode Address File (PAF) matched records in AddressBase by epoch:
The next release of AddressBase products, Epoch 111, is scheduled for 27th June 2024.
These counts are based on a Managed Great Britain Set (MGBS). If you have ordered your national coverage via the online ordering system using a polygon outline, then your counts may differ.
Change-Only Updates are not available for the OS Open UPRN product.
This enumeration is used in association with the stateCode/STATE_CODE attribute. This enumeration describes the physical nature of the address record.
Value | Description |
---|
This enumeration is used in association with the attribute ChangeType/CHANGE_TYPE. This enumeration identifies the type of change that has been made to a feature.
Value | Description |
---|
This code list is used in association with the attribute country/COUNTRY found on the BLPU table. The code list describes within which country the address feature falls within.
Value | Description |
---|
This enumeration is used in association with the attribute blpuState/BLPU_STATE. This enumeration describes the physical nature of the address record.
Value | Description |
---|
All four of the AddressBase products are available as Comma-Separated Value (CSV) files. AddressBase, AddressBase Plus and AddressBase Premium are also available as Geography Markup Language (GML). AddressBase Core is also available as a GeoPackage.
Comma-separated value (CSV) files are a delimited text file that use commas or other characters to separate individual elements of a feature. It is used to store data, often in the form of a table. These tables can be freely loaded into databases and programs allowing for the easy loading and updating of data holdings.
The supply of AddressBase products in the CSV format means:
There will be one record per line in each file.
Fields will be separated by commas.
Character strings will be encapsulated with double quotation marks.
No comma will be placed at the end of each row in the file.
Records will be terminated by Carriage Return/Line Feed.
For AddressBase Core the first line of the CSV file will be the Header row. Other AddressBase products have a separate Header file that is available on the product support page and can be combined with the data to give a structure tabular view. Instructions to do this are provided in the relevant Getting Started Guides on the Product Support pages.
The Geography Markup Language (GML) Encoding standard is an Extensible Markup Language (XML) grammar for expressing geographical features. XML schemas are used to define and validate the format and content of GML. The XML specifications that GML is based on are available from the World Wide Web Consortium (W3C) website: More information can be found in the Open Geospatial Consortium (OGC) document, Geography Markup Language v3.2.1.
The GML 3.2 specification provides a set of schemas that define the GML feature constructs and geometric types. These are designed to be used as a basis for building application-specific schemas, which define the data content.
More information on the XML schemas can be found in the product technical specification.
GeoPackage (GPKG) is an open, standards-based data format 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. Please be advised that older versions of GIS software may need updating before being able to display and interact with GeoPackage files.
GeoPackage 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 user-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.
It is an OGC Standard.
In most cases, it is a Plug and Play format.
AddressBase products incorporate a web-based ordering system that allows customers to order initial data supply and updates, obtain price estimates and view details of their data holdings on demand.
AddressBase Core is provided as a single file which will contain all records regardless of format and supply option: full supply or COU.
The AddressBase, AddressBase Plus and AddressBase Premium products have been split into chunks of smaller data. The primary supply mechanism is referred to as non-geographic chunks. This is the main mechanism for the delivery of data.
Public Sector Geospatial Agreement (PSGA) customers are able to order all AddressBase products via geographic chunks (5km tiles). Address records are provided in individual files, which represent each 5km tile ordered.
Non-geographic chunking is a way of dividing up data into chunks that are supplied in separate volumes that have a fixed maximum number of records, as opposed to a given geographic National Grid area. For this reason, it is possible for features from various geographic locations to appear in one volume and for adjacent features to appear in different volumes.
Non-geographic chunk volumes are designed to be loaded into spatial databases, but can be used in a file format as long as all chunks are translated or imported into the system at the same time.
CSV files can supply a maximum of one million complete address records within one volume, when this limit is reached, a new volume will be started.
For the GML supply a maximum of 200 000 features will be provided in one volume before the next one is started.
For data that is supplied in 5km-by-5km chunks, the file name will reference the 1km tile in the south-west corner of the 5km tile.
Based on your area of interest (AOI), for example the boundary of your local authority, a 5km-by-5km grid covering the area of interest is generated.
All features within each 5km grid that intersects the AOI are added to a geographic chunk file. Geographic chunking is performed using the standard Ordnance Survey National Grid.
AddressBase products provide address data for England, Wales and Scotland.
A national set of AddressBase, known as a Managed GB Set (MGBS) service is a way of processing identical orders faster, which improves delivery times. All records within England, Wales and Scotland will be provided. If you are signed up to an MGBS service you will benefit from:
Data arriving faster and in a more predictable manner.
Seeing the same version of features as other organisations.
Easier data management – no need to manage your order beyond signing up.
For PSGA customers, MGBS will be supplied as geographic or non-geographic chunks. For non-PSGA users, MGBS will be supplied as non-geographic chunks.
Customers may provide their own area of interest (AOI) in any standard GIS format.
You can supply us with a polygon or you can digitise a polygon within our online ordering service.
Customers are able to take a full supply for all AddressBase products. An easier way to manage the addressing data which each product release is to take change-only updates (COU)
A Full Supply is a resupply of all addressable features in each product each time it is released. This may require you to delete to current holding and replace this with the newly supplied product on each product refresh.
AddressBase Core in GeoPackage format is only available as a Full Supply each week.
Change-only update (COU) is a supply of features which have been created, changed or deleted in a customer’s area of interest since their last supply.
Any feature which has not undergone one of the above changes since a customer’s last supply will not be supplied as part of a COU.
COU will be supplied on a weekly basis for AddressBase Core CSV or a six-weekly basis for AddressBase, AddressBase Plus and AddressBase Premium.
A Geographic chunked COU is not supplied as per the Non-Geographic chunked COU outlined above. For a specified 5km tile, all features within the tile will be supplied should any of the individual features change.
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.
Product | MGBS Full Count | National AOI Full Count | Difference |
---|---|---|---|
Change Type | Count |
---|---|
Change Type | Count |
---|---|
AddressBase Premium Table | Inserts | Updates | Deletes |
---|---|---|---|
Data Source | Date |
---|---|
AddressBase products can be ordered via DVD or Secure File Transfer Protocol (SFTP).
OS OpenUPRN
40 784 183
N/A
AddressBase
30 469 019
134 626
AddressBase Plus
38 049 740
578 629
AddressBase Premium
See rows below
See rows below
Street
1 505 809
7 967
Street Descriptor
1 628 740
2 522
BLPU
40 784 183
324 106
Classification
44 648 493
127 133
LPI
45 923 590
137 049
Organisation
1 419 009
16 669
Delivery Point Address
30 574 064
69 329
Application Cross Ref.
197 792 553
716 937
Successor
0
0
AddressBase
30 469 019
30 469 019
0
AddressBase Plus
38 049 740
38 049 721
19
AddressBase Premium
See rows below
See rows below
See rows below
Street
1 505 809
1 505 808
1
Street Descriptor
1 628 740
1 628 739
1
BLPU
40 784 183
40 784 160
23
Classification
44 648 493
44 648 470
23
LPI
45 923 590
45 923 566
24
Organisation
1 419 009
1 419 007
2
Delivery Point Address
30 574 064
30 574 064
0
Application Cross Ref.
197 792 553
197 792 530
23
Successor
0
0
0
Inserts
40 382
Updates
82 823
Deletes
11 421
COU Populated Tile Count
5 315
Inserts
49 477
Updates
515 781
Deletes
13 371
COU Populated Tile Count
7 232
Street
1 489
6 452
26
Street Descriptor
1 615
881
26
BLPU
43 791
276 622
3 693
Classification
57 868
47 780
21 485
LPI
57 875
74 907
4 267
Organisation
7 721
4 356
4 592
Delivery Point Address
40 777
16 919
11 633
Application Cross Ref.
197 994
472 962
45 981
Royal Mail PAF
11 April 2024
National Land and Property Gazetteer
11 April 2024
One Scotland Gazetteer
25 March 2024
VOA Non-Domestic Rates
08 April 2024
VOA Council Tax
08 April 2024
OS MasterMap Topography Layer
03 April 2024
OS MasterMap Highways Network
06 March 2024
Code-Point with Polygons
04 January 2024
Boundary-Line
03 October 2023
Data Source
Records Received
% Matched
Council Tax
27 058 858
99.92
Non-Domestic Rates
2 123 768
96.44
1 | Under construction |
2 | In use |
3 | Unoccupied / vacant / derelict |
4 | No longer existing |
6 | Planning permission granted |
I | Insert |
U | Update |
D | Delete |
E | This record is within England |
W | This record is within Wales |
S | This record is within Scotland |
N | This record is within Northern Ireland |
L | This record is within the Channel Islands |
M | This record is within the Isle of Man |
J | This record is not assigned to a country as it falls outside of the land boundaries used. |
1 | under construction |
2 | In use |
3 | Unoccupied /vacant/derelict |
4 | No longer existing |
6 | Planning permission granted |
This enumeration is used in association with the logicalStatus/LOGICAL_STATUS attribute found in the BLPU and LPI table. This enumeration provides a value to show the lifecycle stage of the address record.
Value | Description |
---|---|
BLPU records will not have a logical status value of 3, whereas LPI records can have all of the values expressed above.
This enumeration is used in association with the attribute fileType/FILE_TYPE found in the Header record. This enumeration allows the identification of either a change-only update (COU) supply or a full supply.
Value | Description |
---|---|
This enumeration is used in association with the officialFlag/OFFICIAL_FLAG attribute. This enumeration is an indicator of whether an address record corresponds to an entry in the official Street Name and Numbering register.
Value | Description |
---|---|
This enumeration is used in association with the postcodeType/POSTCODE_TYPE attribute. This enumeration identifies the code used by Royal Mail to describe the user as a small or large user. This is defined for postal services based on the number of letters delivered to that user.
Value | Description |
---|---|
There are many Date columns within the AddressBase product. Where a type format of Date has been used in the above attribute tables, the data will be defined in the following format.
Value | Type | Notes |
---|---|---|
The AddressBase products provide a variety of data fields, allowing you to construct different forms of an address for a given addressable object, dependent on how the address is to be used.
AddressBase contains the Delivery Point Address which is sourced from Royal Mail’s Postcode Address File (PAF) – a non-geocoded list of addresses. These addresses are used primarily as a ‘mailing list’ for postal purposes.
There are two types of address contained in the AddressBase Plus products:
Delivery Point Address
Geographic Address
These two address types come from different sources and are matched together by GeoPlace.
As noted above, the Delivery Point Address is sourced from Royal Mail’s PAF data. Geographic Addresses are maintained by contributing Local Authorities. The structure of a Geographic Address is based on the British Standard BS7666. These addresses are used to provide an accurate geographic locator for an object to support, for example, service delivery, asset management, or command and control operations. They also represent the legal form of addresses as created under street naming and numbering legislation.
Each UPRN in AddressBase Plus provides the Geographic Address and, where matched, the Delivery Point Address in a one-to-one relationship. If there is no match, then the following fields will be left empty:
DEPARTMENT_NAME |
---|
A common requirement for customers using the AddressBase products is to build a single address label from core address elements.
There are two types of address label. The simplest is a full address on a single line with different elements separated by commas and spaces. This type of label is suited for displaying a full address within a tabular display, such as within an on-screen data grid or spreadsheet, or where a single-line printed address is most appropriate (such as within the text, header or footer of a letter):
ROSE COTTAGE, 5 MAIN STREET, ADDRESSVILLE, LONDON, SE99 9EX
The other type of formatted address is a multi-line address label. These are most often used on envelopes or at the tops of letters, where different parts of an address are separated onto different lines:
This guide outlines a methodology for structuring and layering a single address label, providing suggested logic to build both the Delivery Point and Geographic Address. The logic in Delivery Point Address is applicable to AddressBase, AddressBase Plus and AddressBase Plus Islands. The logic in Geographic Address is only applicable to AddressBase Plus and AddressBase Plus Islands.
The rules in this guide are suggestions only and can be used for visual display of full addresses. It is strongly recommended that address components are stored in the format in which they are provided in order to allow maximum flexibility of use and derived value.
A Delivery Point Address contains information sourced from Royal Mail (PAF). Stringent rules are used to match these addresses to the Geographic Address and assign a common UPRN to link addresses from the two addressing sources together in the data model.
To construct a single address label based purely on the Royal Mail PAF address fields, the following attributes can be used to build a Delivery Point Address label.
The table below provides details of the Delivery Point Address Components.
These address components are listed in the correct order in which they should appear on an address label. There may be a business need to replace the thoroughfare, locality and post_town attributes with the Welsh equivalent. The following examples use the English version of these attributes only.
It should be noted that most of the PAF fields are optional and may contain null values (or zero, in the cases of ‘BUILDING NUMBER’ and ‘PO BOX NUMBER’). In these cases, those fields should be omitted.
The following (entirely fictional) example shows all of the PAF fields filled in (apart from the PO Box number) and indicates how they should be ordered in a single address label.
In cases where a PO BOX NUMBER is present, it will only be described in the data as an integer. In order to properly format these addresses when generating an address label, these integers should be prefixed with the text ‘PO BOX’, as shown in the following example:
Where null or empty, string values exist (for character fields) or zeros or nulls (for integer fields), those fields should be entirely omitted from the output. However, the order in which the fields should be concatenated always remains the same.
Building a single-line, formatted address for a Delivery Point is relatively straightforward. All the fields should be checked in the order shown previously in Table 1, and those that have values should be concatenated together into a single line. Generally, address components should be separated by a comma followed by a single space (‘, ’), although sometimes only a space is used between a building number and a thoroughfare name. You can use your preference.
An example of SQL logic to create a single-line Delivery Point Address is on our GitHub repository https://github.com/OrdnanceSurvey/AddressBase/tree/master/SQL, which should be used under the following considerations:
The SQL operator for concatenating text is a double pipe (‘||’).
CASE blocks have been used to test each of the fields for null values before concatenating its contents (along with a suitable separator – either ‘, ’ or ‘ ’).
The field names and table names used are illustrative and may vary between databases.
Depending on the database schema and data loading method used, it may be necessary to test some fields for empty strings (‘’) or zero values (for integer fields) instead of, or as well as, testing for NULLs.
If you are using PostGres (PostGIS), it might be beneficial to substitute the ‘IS NOT NULL’ with != ‘’. This should improve the overall appearance of the output.
Splitting a Delivery Point Address into multiple lines is more complicated. There are several rules to consider in order to avoid having very short lines (for example, just a building number) or very long lines within the formatted address. A summary of these rules is as follows:
Generally, if there is a building number, it should appear on the same line as the thoroughfare (or dependent thoroughfare) name. If there is no thoroughfare name information, it should appear on the same line as the first locality name.
In cases where building numbers have been placed in the building name field due to the presence of a letter suffix (for example, ‘11A’) or a number range separator (for example, ‘3–5’), these should be detected and placed on the same line as the thoroughfare name in the same way as a building number (or on the first locality line if no thoroughfare name is present).
In most other cases, the building name, if present, should appear on a separate line above the thoroughfare (or dependent thoroughfare) name. If there is no thoroughfare name present, it should appear on the same line as the first locality name.
Similar tests should be applied to the SUB_BUILDING_NAME field: if this field contains a number, a number with a suffix, or a numeric range, it should precede the building name on the same line. In most other cases, it should appear on a separate line above the building name.
The structure of a Geographic Address is based on the British Standard BS7666 and is split into several components. This means that in order to construct a complete address label (for example, on an envelope, database form or GIS display), the components need to be constructed according to a set of rules.
Within the AddressBase Plus products, the core property level address information is stored within the Primary Addressable Object (PAO) and Secondary Addressable Object (SAO) fields. The additional attribution required to build a full address label are the la_organisation
, street_description
, locality
, town_name
, administrative_area
and postcode_locator
.
For a full description of PAOs and SAOs, and the complete set of AddressBase Plus fields, please refer to the Technical Specification on your respective product:
To construct a single address label based purely on the BS7666 address fields, the following attributes should be used to build a Geographic Address label.
*ADMINISTRATIVE_AREA is optional because it is common for this field to be the same as the TOWN_NAME. Sometimes, however, this field will help users construct a more complete address.
These address components are listed in the correct order in which they should appear on an address label. There may be a business need to use alternate language fields for the SAO_TEXT, PAO_TEXT and STREET_DESCRIPTION, which are also listed in the correct order above.
When building a single address label, it may be necessary to concatenate the various SAO fields and PAO fields together respectively. These fields contain any property names, numbers, number ranges or suffixes that apply to an address.
A PAO number/range string should be constructed from the PAO_START_NUMBER, PAO_START_SUFFIX, PAO_ END_NUMBER and PAO_END_SUFFIX fields, as illustrated in the following table.
Similarly, a SAO number/range string should be constructed from the SAO_START_NUMBER, SAO_START_SUFFIX, SAO_END_NUMBER and SAO_END_SUFFIX fields, as illustrated in the following table.
In addition to the numeric range fields described above, there are also PAO_text and SAO_text fields. These fields may be populated instead of, or as well as, the numeric range fields. In both cases, if both text and a numeric range string are present, the text should appear before the numeric range in any formatted address.
For PAOs, there will always be either a text entry or a numeric/range entry, or both. This is not the case for SAOs, which may be entirely absent for a given address.
The street description and administrative area names are always present, while the locality name and town name may be empty.
The ADMINISTRATIVE_AREA field always contains a value; however, this value will not always enhance an address, but in some cases it will. In particular, check that it is not the same as the value in the TOWN_NAME field, as this is often the case.
In other cases, the administrative area name will simply contain the local authority name, which would not traditionally form part of a single or multi-line address but can be included to add additional information to an address label. Its inclusion is largely down to business requirements or personal preference; however, it may also be useful to 'de-duplicate' some Geographic Addresses.
The following (entirely fictional) example shows all of the BS7666 Geographic Address fields filled in and how they should be ordered in a single address label.
*The number/range strings are built from the relevant PAO/SAO START_NUMBER, START_SUFFIX, END_NUMBER and END_SUFFIX fields, as described above, and formatted as character strings.
Where an administrative area matches the town name, it should always be omitted.
Where null or empty string values exist (for character fields) or zeros or nulls (for integer fields), those fields should be entirely omitted from the output; however, the order in which the fields should be concatenated always remains the same.
Building a single-line, formatted address for a Geographic Address is slightly more complicated than for a Delivery Point Address due to the need to preformat the SAO and PAO number/range strings. However, once this is done, the process is largely the same as before: the calculated fields should be checked in the order shown previously in Constructing a single address label from the Geographic Address fields, and those that have values should be concatenated together into a single line. Generally, address components should be separated by a comma followed by a single space (‘, ’), although sometimes only a space is used between a PAO number/range string and a street description. This is down to personal preference.
Example SQL logic to create a single-line Geographic Address can be found on our GitHub repository, which should be used under the following considerations:
The SQL operator for concatenating text is a double pipe (‘||’).
CASE blocks have been used to test each of the fields for null values before concatenating its contents (along with a suitable separator – either ‘, ’ or ‘ ’).
The field names and table names used are illustrative and may vary between databases.
Depending on the database schema and data loading method used, it may be necessary to test some fields for empty strings (‘’) or zero values (for integer fields) instead of or as well as testing for NULLs.
Splitting a Geographic Address into multiple lines is more complex. As with Delivery Point Addresses, there are several rules to consider in order to avoid having very short lines (for example, just a building number) or very long lines within the formatted address.
A summary of these rules is as follows:
Generally, if there is a PAO number/range string, it should appear on the same line as the Street Description. For example: 11A MAIN STREET
If there is a PAO_text value, it should always appear on the line above the Street Name (or on the line above the <PAO number string> + <Street Name> where there is a PAO number/range).
If there is a SAO_text value, it should appear on a separate line above the PAO_text line (or the PAO number/range + Street Name where there is no PAO_text value).
If there is a SAO number/range value, it should be inserted either on the same line as the PAO_text (if there is a PAO_text value), or on the same line as the PAO number/range + Street Name (if there is only a PAO number/range value and no PAO_text value). If there are both PAO_text and a PAO number/range, then the SAO number/range should appear on the same line as the PAO_text, and the PAO number/range should appear on the street line.
If there is a SAO_text value, it should always appear on its own line.
If there is an Organisation Name, it should always appear alone as the top line of the address.
The Locality (if present) should appear on a separate line beneath the Street Description, followed by the Town Name on the line below it. If there is no Locality, the Town Name should appear alone on the line beneath the Street Description.
If the Administrative Area name is required and it is not a duplicate of the Town Name, it can optionally be included on a separate line beneath the Town Name.
Finally, the Postcode Locator should be inserted on the final line of the address.
Given that AddressBase Plus contains two different types of address, a decision needs to be made as to whether to use the Geographic or Delivery Point Addresses, or a mixture.
The following two options should be considered:
Use Delivery Point Addresses whenever they are available, and when they are not, use a Geographic Address.
Use Geographic Addresses in all cases.
Depending on business requirements, in some user interfaces it may be worth considering displaying both forms of an address where possible, since this will provide the maximum information available about a given UPRN.
‘Mixing and matching’ components from the two different forms of address into a single address label is not recommended as this is likely to cause confusion in some instances.
AddressBase Plus offers other attributes that could be used in conjunction with address labels. For example, classification can be used to target certain types of property, or OS MasterMap Topography TOID cross references can be used to link address labels to Topographic objects and viewed in a GIS.
TOID cross references are not available in AddressBase Plus Islands.
This enumeration is used in association with the recordType/RECORD_TYPE attribute found in the Street table. This enumeration identifies the record type of the street record.
Value | Description |
---|---|
This enumeration is used in association with the LANGUAGE attribute found in the Street Descriptor and LPI tables; and also the Metadata table for CSV supply. This enumeration identifies the language of the address displayed.
This is not required for the GML supply as the Language is specified in the GML tag ‘xml:lang’.
Value | Description |
---|---|
This enumeration is used in association with the streetClassification/STREET_CLASSIFICATION attribute found in the Street table. The enumeration provides a value denoting the primary classification of the street record.
Value | Description |
---|---|
This enumeration is used in association with the state/STATE attribute found in the street table. This enumeration identifies at which point the street record is within its lifecycle.
Value | Description |
---|---|
This enumeration is used in association with the rpc/RPC attribute. This enumeration identifies the accuracy value of the coordinates allocated to the address.
Value | Description | Implementation notes |
---|---|---|
There are columns within the AddressBase product which provide a Time value. Where this is declared, the data will be provided in the following format.
Value | Type | Notes |
---|
AddressBase data is an addressing gazetteer that can be used within GIS and database systems. For details of Ordnance Survey’s licensed partners, who can incorporate the AddressBase products in their systems, please see the on the Ordnance Survey website.
Ordnance Survey does not recommend either suppliers or software products as the most appropriate system depends on many factors, such as 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.
However, as a minimum, the following elements will be required in any system:
A means of reading the data, either in its native format, or by translating it into a file format or for storage in a database.
A means of storing and distributing the data, perhaps in a database or through a web-based service.
A way of visualising and querying the data, typically a GIS.
You are advised to copy the supplied data to a backup medium.
For reading purposes, it is recommended to store the data on a single hard disc. This will speed up the ability of your computer to read the data. Unzipped file sizes for the full supply of each product are as follows:
Product | Unzipped CSV file size | Unzipped GML file size |
---|
This getting started guide provides instructions for using AddressBase in different software applications. Users with limited technical knowledge will be able to follow this guide.
These instructions show you how to get started with , and .
AddressBase products are created by bringing together different address sources:
Local Authority Gazetteers across Great Britain, Northern Ireland, the Channel Islands and the Isle of Man
Royal Mail PAF data
References to Valuation Office Agency (VOA) data
Additional addresses and coordinates from Ordnance Survey
The data is supplied as comma-separated values (CSV) or Geography Markup Language (GML).
This getting started guide shows you how to obtain a data supply, load and work with AddressBase data. It includes the following sections:
This enumeration is used in association with the streetSurface/STREET_SURFACE attribute found in the Street table. This enumeration identifies the surface finish of the street.
Value | Description |
---|
AddressBase provides a current view of all Royal Mail PAF addresses that have been matched to the NLPG and OSG . The product provides Royal Mail attribution as well as enhancing PAF with X and Y coordinates on the British National Grid and ETRS89 coordinate reference system and providing the classification of an address to a primary level. It also provides a primary level classification.
This product will provide you with a single view of an address, allow you to locate this address on a map to give you a geographic view and carry out primary analysis on the function of the address to determine, for example residential from commercial properties.
This product is updated every six weeks
Identify a property and locate it on a map with precision – using the X and Y coordinates we’ve assigned to the Royal Mail Postcode Address File (PAF)® data.
Every address geo data record provides Royal Mail address information from PAF, the Unique Delivery Point Reference Number (UDPRN) and X and Y coordinates.
Using the basic classifications in AddressBase you can quickly filter between residential and commercial addresses, which is ideal for marketing purposes.
Our basic classifications – residential or commercial – will reduce the costs and increase the effectiveness of your direct marketing.
In customer services, the need for accuracy is paramount. Have confidence in your front-line staff’s ability to look up addresses on a database of millions, quickly and efficiently
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 (5km² tiles or user-defined polygon)
OS Data Hub plan: Public Sector Plan, Premium Plan, Energy & Infrastructure Plan
To find out details such as houses that have been converted to flats, you'll need AddressBase Plus. it includes current properties and addresses sourced from local authorities, Ordnance Survey and Royal Mail. These are all matched to the UPRN and structured in a flat-file model.
AddressBase Plus has more records than AddressBase as it includes objects without postal addresses such as places of worship and community centres – as well as sub-divided properties. It lets you locate an address or property on a map, through the assigned X and Y coordinates.
Crucially, the cross-referencing information with OS MasterMap products via Topographic Identifiers (TOIDs) means you can view address data within a wider context.
Royal Mail royalties are included in the licence fee. A separate Royal Mail royalty fee applies if you license the AddressBase data on External Transaction Solution (ETS) terms.
If the file size of your order is smaller than 2Gb, you can get it from our FTP server. in addition, public sector customers can download 5km chunk orders via our download service.
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 enumeration is used in association with the usrnMatchIndicator/USRN_MATCH_INDICATOR attribute found in the LPI table. This enumeration identifies how the USRN has been allocated to an address record.
Value | Description |
---|
Delivery Point Address Component | Type |
---|---|
Delivery Point Address Component | Example |
---|---|
Delivery Point Address Component | Data Content | Formatted output |
---|---|---|
Delivery Point Address Component | Data content | Formatted output |
---|---|---|
Geographic Address Component | Type |
---|---|
Attribute | Example 1 | Example 2 | Example 3 | Example 4 |
---|---|---|---|---|
Attribute | Example 1 | Example 2 | Example 3 | Example 4 |
---|---|---|---|---|
Administrative area not included | vs | Administrative area included (BURY) |
---|---|---|
Geographic Address Component | Example |
---|---|
Delivery Point Address Component | Data content | Formatted output |
---|---|---|
Delivery Point Address Component | Data content | Formatted output |
---|---|---|
Please see for instructions on how to load and work with AddressBase data. This is a composite guide for , and .
Access to this product is free for PSGA members. Find out if you are a PSGA member or try out a sample of AddressBase data by with links to all of the relevant resources. Alternatively, you can try out the full product by applying for .
1
Approved
3
Alternative
6
Provisional
8
Historical
F
Signifies the supply is a full supply
C
Signifies the supply is a COU file
N
Unofficial Address
Y
Official Address
S
A small user, for example, a residential property
L
A large user, for example, a large commercial company
2024-10-24
Date
Date columns will follow the structure: CCYY-MM-DD
ORGANISATION_NAME
SUB_BUILDING_NAME
BUILDING_NAME
BUILDING_NUMBER
PO_BOX_NUMBER
DEPENDENT_THOROUGHFARE (and WELSH_DEPENDENT_THOROUGHFARE)
THOROUGHFARE (and WELSH_THOROUGHFARE)
DOUBLE_DEPENDENT_LOCALITY (and WELSH_DOUBLE_DEPENDENT_LOCALITY)
DEPENDENT_LOCALITY (and WELSH_DEPENDENT_LOCALITY)
POST_TOWN (and WELSH_POST_TOWN)
POSTCODE
ROSE COTTAGE
5 MAIN STREET
ADDRESSVILLE LONDON
SE99 9EX
DEPARTMENT_NAME
Character
ORGANISATION_NAME
Character
SUB_BUILDING_NAME
Character
BUILDING_NAME
Character
BUILDING_NUMBER
Integer
PO_BOX_NUMBER
Integer
DEPENDENT_THOROUGHFARE (or WELSH_DEPENDENT_THOROUGHFARE)
Character
THOROUGHFARE (or WELSH_THOROUGHFARE)
Character
DOUBLE_DEPENDENT_LOCALITY (or WELSH_DOUBLE_DEPENDENT_LOCALITY)
Character
DEPENDENT_LOCALITY (or WELSH_DEPENDENT_LOCALITY)
Character
POST_TOWN (or WELSH_POST_TOWN)
Character
POSTCODE
Character
DEPARTMENT_NAME
CUSTOMER SERVICE DEPARTMENT
ORGANISATION_NAME
JW SIMPSON LTD.
SUB_BUILDING_NAME
UNIT 3
BUILDING_NAME
THE OLD FORGE 7
BUILDING_NUMBER
7
PO_BOX_NUMBER
DEPENDENT_THOROUGHFARE
RICHMOND TERRACE
THOROUGHFARE
MAIN STREET
DOUBLE_DEPENDENT_LOCALITY
HOOK
DEPENDENT_LOCALITY
WARSASH
POST_TOWN
SOUTHAMPTON
POSTCODE
SO99 9ZZ
ORGANISATION_NAME
‘JWS CONSULTING’
JWS CONSULTING
PO_BOX_NUMBER
5422
PO BOX 5422
THOROUGHFARE
‘HIGH STREET’
HIGH STREET
POST_TOWN
'SPRINGFIELD’
SPRINGFIELD
POSTCODE
‘SP77 0SF’
SP77 0SF
DEPARTMENT_NAME
Null
ORGANISATION_NAME
‘TM MOTORS’
TM MOTORS
SUB_BUILDING_NAME
Null
BUILDING_NAME
‘THE OLD BARN’
THE OLD BARN
BUILDING_NUMBER
0 (or null)
PO_BOX_NUMBER
0 (or null)
DEPENDENT_THOROUGHFARE
Null
THOROUGHFARE
‘HORSHAM LANE’
HORSHAM LANE
DOUBLE_DEPENDENT_LOCALITY
Null
DEPENDENT_LOCALITY
Null
POST_TOWN
‘HORSHAM’
HORSHAM
POSTCODE
‘RH12 1EQ’
RH12 1EQ
LA_ORGANISATION
Character
SAO_TEXT (or ALT_LANGUAGE_SAO_TEXT)
Character
SAO_START_NUMBER
Integer
SAO_START_SUFFIX
Character
SAO_END_NUMBER
Integer
SAO_END_SUFFIX
Character
PAO_TEXT (or ALT_LANGUAGE_PAO_TEXT)
Character
PAO_START_NUMBER
Integer
PAO_START_SUFFIX
Character
PAO_END_NUMBER
Integer
PAO_END_SUFFIX
Character
STREET_DESCRIPTION (or ALT_LANGUAGE_STREET_DESCRIPTION)
Character
LOCALITY
Character
TOWN_NAME
Character
ADMINISTRATIVE_AREA*
Character
POSTCODE_LOCATOR
Character
PAO_START_NUMBER PAO_START_SUFFIX PAO_END_NUMBER PAO_END_SUFFIX
1
1
A
1
5
1
A 5 C
Rendered PAO range
1
1A
1-5
1A-5C
PAO (number string) PAO (text)
1
1A
1A
Rose Cottage
Rose Cottage
Rendered PAO (showing street name location)
1 <street>
1A <street>
Rose Cottage, 1A
<street>
Rose Cottage,
<street>
34, CROW LANE, RAMSBOTTOM, BL0 9BR
34, CROW LANE, RAMSBOTTOM, BURY, BL0 9BR
LA_ORGANISATION SAO_TEXT
SAO (number/range string)* PAO_TEXT
PAO (number/range string)* STREET_DESCRIPTION LOCALITY
TOWN_NAME ADMINISTRATIVE_AREA
POSTCODE_LOCATOR
JW SIMPSON LTD THE ANNEXE
1A
THE OLD MILL 7–9
MAIN STREET HOOK WARSASH SOUTHAMPTON
SO99 9ZZ
PAO_TEXT
‘HIGHBURY HOUSE’
HIGHBURY HOUSE
STREET_DESCRIPTION
‘HIGH STREET’
HIGH STREET
TOWN_NAME
‘SOUTHAMPTON’
SOUTHAMPTON
ADMINISTRATIVE_AREA
‘SOUTHAMPTON’
POSTCODE_LOCATOR
‘SO77 0SF’
SO77 0SF
ORGANISATION
‘TM MOTORS’
TM MOTORS
SAO_TEXT
null
SAO (number/range string)*
null
PAO_TEXT
‘THE OLD BARN’
THE OLD BARN
PAO (number/range string)*
‘1’
1
STREET_DESCRIPTION
‘HORSHAM LANE’
HORSHAM LANE
LOCALITY
null
TOWN_NAME
‘HORSHAM’
HORSHAM
ADMINISTRATIVE_AREA
‘HORSHAM’
* Duplicate name omitted
POSTCODE_LOCATOR
‘RH12 1EQ’
RH12 1EQ
PAO_text only
PAO_text and PAO number or range
ROSE COTTAGE, MAIN STREET
ROSE COTTAGE, 11A MAIN STREET
SAO_text value only, with PAO_text value only
SAO_text value only, with PAO number/range only
THE ANNEXE, ROSE COURT, MAIN STREET
THE ANNEXE, 11A MAIN STREET
SAO number/range value only, and PAO_text value only
SAO number/range value only, and PAO number/range value only
SAO number/range value only, and both PAO_text and PAO number/range values
1A ROSE COURT, MAIN STREET
1-3, 11A MAIN STREET
1A ROSE COURT,
11A MAIN STREET
SAO_text value only with PAO_text only
SAO_text and SAO number/range and PAO_text and PAO number/range
THE ANNEXE, ROSE COTTAGE, MAIN STREET
WARDEN’S FLAT,
1A ROSE COURT,
11A MAIN STREET
Organisation Name along with all PAO + SAO fields
COTTAGE INDUSTRY LTD, THE ANNEXE,
1A ROSE COURT,
11A MAIN STREET
Locality and Town Name present
Town Name only
[first part of address, formatted as described above] MAIN STREET,
HIGHFIELD, SOUTHAMPTON
[first part of address, formatted as described above] HIGH STREET,
SOUTHAMPTON
Administrative Area name included
[first part of address, formatted as described above] MAIN STREET,
WINDSOR,
ROYAL BOROUGH OF WINDSOR AND MAIDENHEAD
With Postcode_Locator on final line
[first part of address, formatted as described above] HIGH STREET,
MILTON, ML99 0WW
1
Official designated Street Name
2
Street Description
3
Numbered Street
4
Unofficial Street Description
9
Description used for LLPG Access
ENG
English
CYM
Welsh
GAE
Gaelic (Scottish)
BIL
Bilingual
4
Pedestrian way or footpath
6
Cycletrack or cycleway
8
All vehicles
9
Restricted byway
10
Bridleway
1
Under construction
2
Open
4
Permanently closed (STREET_END_DATE must be entered)
1
Central Internal Position
The address seed is contained within an OS MasterMap Topography Layer building and within 2.5m of its calculated centre.
Or
The seed is in the best possible position based on the nature of the premises, for example, Development Land, House Boat, Wind Farm.
2
General Internal Position
The address seed is contained within an OS MasterMap Topography Layer building but is more than 2.5m away from its calculated centre.
Or
The seed is in an internal position based on the nature of the premises, for example, Development Land, House Boat.
3
Transitional Position
The address seed has been changed from provisional to live in the last six months. It has been captured to a high level of positional accuracy, but the OS MasterMap Topography Layer feature is not yet captured.
Please note the address seed will only be moved pending any imminent mapping updates.
4
Street Location
The address seed is plotted in accordance with the declared street start or end coordinates.
Please note this is the highest accuracy possible for Street Records.
5
Postcode Unit Position
The address seed has been captured to Postcode Unit level. It will be updated when more information becomes available.
9
Low accuracy – marked for priority review
This address seed has been captured to a lower level of accuracy and will be updated as a priority over the coming releases.
14:11:15 | Time | Time will follow the structure of HH:MM:SS based on a 24-hour clock. |
1 | Metalled |
2 | UnMetalled |
3 | Mixed |
1 | Matched manually to the nearest accessible Street. |
2 | Matched spatially to the nearest USRN. Not necessarily the access street. |
AddressBase | 6Gb | 32Gb |
AddressBase Plus | 16Gb | 78Gb |
AddressBase Plus Islands | 450Mb | 2Gb |
GML is an XML dialect which can be used to model geographic features. It was designed by the Open Geospatial Consortium (OGC) as a means for people to share information regardless of the applications or technology that they use.
In the first instance, GML was used to overcome the differences between different GIS applications by providing a neutral file format as an alternative to proprietary formats. Because it is independent of applications, it can also be moved between databases or other types of application, which allows a wider application than just GIS data transfer.
GML data can be viewed and loaded into a database using software such as Safe FME: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/gml/gml.htm
When you receive an order via hard media (DVD), the following files will be supplied for the contracted area of interest (AOI):
Data
Doc
Order_Details.txt
Within the Data directory, data files will be found in their compressed format.
Within the Doc folder, a text file called Label Information.txt will contain information that is printed on the DVD.
The Order_Details text file will provide information about the order, including the order date, currency date and file structure.
When you receive an order of a Managed Great Britain Set (MGBS) via hard media (DVD), the following files will be supplied:
Data
Doc
Resources
readme.txt
There are several items contained within your supply:
Data folder – This folder contains all of your data supply.
Doc folder – This folder contains the Medialis.txt file, which outlines the contents of the data you have been supplied.
Resources folder – This folder contains lookup tables for the local custodian code and AddressBase classification scheme as well as the Header files for the product.
The readme text file – This document provides guidance notes on matters such as the filename referencing used and the directory structure of the DVD.
With a Secure File Transfer Protocol (SFTP) order, the same folder structure is supplied as in DVD Supply of area of interest. The filenames will be slightly different, reflecting the SFTP order number, and the Docs folder will be empty.
Public Sector Geospatial Agreement (PSGA) customers can download their geographic chunk data for AddressBase and AddressBase Plus as well as a full supply of AddressBase Plus Islands via our download service.
The data is supplied as chunked files that cover your selected area. These files are named according to the convention shown below.
When you open your data, you will see a series of zip folders:
Using AddressBase Plus and Islands as an example:
AddressBasePlus_FULL_2020-01-21_001_csv.zip
(Full supply of GB CSV)
AddressBasePlus_ISL_FULL_2020-01-21_001_csv.zip
(Full supply of Islands CSV) or
AddressBasePlus_COU_2020-01-21_001_gml.zip
(COU supply of GB GML)
AddressBasePlus_ISL_COU_2020-01-21_001_gml.zip
(COU supply of Islands GML)
Using AddressBase Plus as an example:
AddressBasePlus_FULL_2011-07-29_TQ2020_csv.zip
(Full supply of CSV) or
AddressBasePlus_COU_2011-07-29_TQ2020_gml.zip
(COU supply of GML)
The AddressBase Plus Islands product is not available in geographic chunks.
The GML and CSV data is supplied in a compressed form (ZIP). Some software can access these files directly, while other software will require the files 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.
When you unzip the files, the data will be extracted as CSV files, which are ready to use. For example, unzipping AddressBase Plus will extract files similar to the chunks below:
AddressBasePlus_FULL_2020-01-21_001.csv
AddressBasePlus_ISL_FULL_2020-01-21_001.csv
AddressBasePlus_2011-07-29_NC4040.csv
The primary supply mechanism of AddressBase data is referred to as non-geographic chunks. This is a way of dividing up the data into chunks that are supplied in separate volumes, which have a fixed maximum number of records. The supply is not supplied with any reference to the geographic position of records.
Public Sector Geospatial Agreement (PSGA) customers can order Geographic chunks (5km tiles) as well as non-geographic chunks, although geographic chunks are not considered the main form of supply.
All customers are also able to take a complete supply (referred to as a Managed Great Britain Set: MGBS) or an Area of Interest (AOI) as a full supply or a COU supply.
If you receive your data as non-geographic chunks, the filename will be constructed as follows:
productName_supply_ccyy-mm-dd_vvv.format
Where:
ProductName is AddressBase.
supply is defined as FULL
or COU
.
ccyy-mm-dd is the date the file was generated.
vvv is the volume number of the file.
format is the format of the files received, for example, csv
or gml
.
For example:
AddressBase_FULL_2013-05-28_001.gml
(GML full supply)
AddressBase_COU_2013-05-28_001.csv
(CSV COU supply)
If the data has been provided in a ZIP file, the filename will be constructed as follows:
productName_supply_ccyy-mm-dd_vvv_format.zip
For example:
AddressBase_FULL_2013-05-28_001_gml.zip
(GML full supply zipped)
If you receive your data as geographic chunks (PSGA customers only), the filename will be constructed as follows:
productName_supply_ccyy-mm-dd_ngxxyy.format
Where:
ProductName is AddressBase.
supply is defined as FULL
or COU
.
ccyy-mm-dd is the date the file was generated.
ngxxyy is the four-digit grid reference belonging to the 1km south-west corner of the 5km chunk.
format is the format of the files received, for example, csv
or gml
.
For example:
AddressBase_FULL_2013-05-28_NC4040.gml
(GML full supply)
AddressBase_COU_2013-05-28_NC4040.csv
(CSV COU supply)
If the data has been provided in a ZIP file, the filename will be constructed as follows:
productName_supply_ccyy-mm-dd_ngxxyy_format.zip
For example:
AddressBase_COU_2013-05-28_NC4040_csv.zip
(CSV COU supply zipped)
AddressBase is available as a full or COU supply.
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 data volumes are smaller therefore reducing the amount of data that requires processing when compared to a full supply.
COU data enables a user to identify three types of change:
Deletes (CHANGE_TYPE ‘D’) are objects that have ceased to exist in your AOI since the last product refresh.
Inserts (CHANGE_TYPE ‘I’) are objects that have been newly inserted into your AOI since the last product refresh.
Updates (CHANGE_TYPE ‘U’) are objects that have been updated in your AOI since the last product refresh.
A COU file for non-geographic chunked data can be identified by its naming convention. Any change record will be provided as a full record with the appropriate change type, as listed above.
A geographic chunked COU is not supplied as per the non-geographic chunked COU outlined above. Its file naming convention can be found above. If a single 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.
These instructions describe how to prepare the CSV format of AddressBase, AddressBase Plus and AddressBase Plus Islands data for processing.
These instructions describe how to load the CSV format of AddressBase, AddressBase Plus and AddressBase Plus Islands data. In these examples, AddressBase Plus data will be used to describe the procedures in various GI systems.
It is assumed that the preparation of the AddressBase, AddressBase Plus or AddressBase Plus Islands CSV data has been carried out as instructed in Preparing the CSV data before attempting to load the data. If it has not been done, the full set of data will not load, and data loaded will not contain header information.
AddressBase, AddressBase Plus and AddressBase Plus Islands are also available from Ordnance Survey as a supply in GML format. Loading GML into most GIS applications requires the use of third-party translation software, which is not covered in this guide. If more information is required in the loading of GML format, please contact Ordnance Survey.
This section describes how to load AddressBase products into a few common databases.
ArcMap, ArcGIS Desktop and ArcGIS Server software 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 ESRI products. An alternative method to facilitate using ESRI software is to store this data as a string and add a new Serial ID to act as the Object ID. If you are loading AddressBase 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 that the load may fail. Please bear in mind such adjustments may be required depending on the database you use to load the data.
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.
These are the reasons why this may happen:
The record has moved in location more than once, moving it out of your Area of Interest (AOI), hence the deletion, but then moved back into your AOI in the future. This would also occur if you altered 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.
This address record follows the lifecycle of a Postcode Address File (PAF) record matched to a Local Authority record. As a matched record is inserted, deleted and updated within PAF, these changes are incorporated into the AddressBase product. Similarly, if the matched Local Authority address record updates an attribute contained within the AddressBase product, this change will be reflected.
The following sub-sections provide details about the attributes included with this feature, their data types in the different output formats, and other important metadata about them.
The following sub-sections provide details about the attributes included with the Address feature type.
Unique Property Reference Number (UPRN) assigned by the LLPG Custodian or Ordnance Survey.
Attribute Name: uprn (GML), UPRN (CSV)
Data Type: Integer (GML), Integer (CSV)
Multiplicity: [1]
Size: 12
Source: Contributing Local Authority / Ordnance Survey
Unique identifier provided by Ordnance Survey.
Attribute Name: osAddressTOID (GML), OS_ADDRESS_TOID (CSV)
Data Type: LocalisedCharacterString (GML), char (CSV)
Multiplicity: [0..1]
Size: 20
Source: Ordnance Survey
Royal Mail’s Unique Delivery Point Reference Number (UDPRN).
Attribute Name: udprn (GML), UDPRN (CSV)
Data Type: Integer (GML), Integer (CSV)
Multiplicity: [1]
Size: 8
Source: Royal Mail
The organisation name is the business name given to a delivery point within a building or small group of buildings. For example: TOURIST INFORMATION CENTRE
This field could also include entries for churches, public houses and libraries.
Attribute Name: organisationName (GML), ORGANISATION_NAME (CSV)
Condition: Organisation Name or PO Box Number must be present if Building Name or Building Number are all not present.
Data Type: LocalisedCharacterString (GML), char (CSV)
Multiplicity: [0..1]
Size: 60
Source: Royal Mail
For some organisations, department name is indicated because mail is received by subdivisions of the main organisation at distinct delivery points. For example, Organisation Name: ABC COMMUNICATIONS or RM Department Name: MARKETING DEPARTMENT
Attribute Name: departmentName (GML), DEPARTMENT_NAME (CSV)
Condition: If a Department Name is present, an Organisation Name must also be present.
Data Type: LocalisedCharacterString (GML), char (CSV)
Multiplicity: [0..1]
Size: 60
Source: Royal Mail
Post Office Box (PO Box) number.
Attribute Name: poBoxNumber (GML), PO_BOX_NUMBER (CSV)
Condition: Organisation Name or PO Box Number must be present if Building Name or Building Number are all not present.
Data Type: CharacterString (GML), char (CSV)
Multiplicity: [0..1]
Size: 6
Source: Royal Mail
The sub-building name and/or number are identifiers for subdivisions of properties.
For example: Sub-building Name: FLAT 3, Building Name: POPLAR COURT, Thoroughfare: LONDON ROAD
If the above address is styled 3 POPLAR COURT, all the text will be shown in the Building Name attribute and the Sub-building Name will be empty. The building number will be shown in this field when it contains a range, decimal or non-numeric character (see Building Number).
Attribute Name: subBuildingName (GML), SUB_BUILDING_NAME (CSV)
Condition: If a Sub Building Name is present, a Building Name or Building Number must also be present.
Data Type: LocalisedCharacterString (GML), char (CSV)
Multiplicity: [0..1]
Size: 30
Source: Royal Mail
The building name is a description applied to a single building or a small group of buildings, such as Highfield House. This also includes those building numbers that contain non-numeric characters, such as 44A.
Some descriptive names, when included with the rest of the address, are sufficient to identify the property uniquely and unambiguously, for example, MAGISTRATES COURT.
Sometimes the building name will be a blend of distinctive and descriptive naming, for example, RAILWAY TAVERN (PUBLIC HOUSE) or THE COURT ROYAL (HOTEL).
Attribute Name: buildingName (GML), BUILDING_NAME (CSV)
Condition: Building Name must be present if Organisation Name or Building Number or PO Box Number are all not present.
Data Type: LocalisedCharacterString (GML), char (CSV)
Multiplicity: [0..1]
Size: 50
Source: Royal Mail
The building number is a number given to a single building or a small group of buildings, thus identifying it from its neighbours, for example, 44. Building numbers that contain a range, decimals or non-numeric characters do not appear in this field but will be found in the buildingName or the sub-BuildingName fields.
Attribute Name: buildingNumber (GML), BUILDING_NUMBER (CSV)
Condition: Building Number must be present if Organisation Name or Building Name or PO Box Number are all not present.
Data Type: Integer (GML), Integer (CSV)
Multiplicity: [0..1]
Size: 4
Source: Royal Mail
A thoroughfare in AddressBase is fundamentally a road, track or named access route on which there are Royal Mail delivery points, for example, HIGH STREET.
Attribute Name: thoroughfare (GML), THOROUGHFARE (CSV)
Data Type: LocalisedCharacterString (GML), char (CSV)
Multiplicity: [0..1]
Size: 80
Source: Royal Mail
The town or city in which the Royal Mail sorting office is located which services this record. There may be more than one, possibly several, sorting offices in a town or city.
Attribute Name: postTown (GML), POST_TOWN (CSV)
Data Type: LocalisedCharacterString (GML), char (CSV)
Multiplicity: [1]
Size: 30
Source: Royal Mail
This is used to distinguish between similar thoroughfares or the same thoroughfare within a dependent locality. For example, Millbrook Industrial Estate and Cranford Estate in this situation: BRUNEL WAY, MILLBROOK INDUSTRIAL ESTATE, MILLBROOK, SOUTHAMPTON and BRUNEL WAY, CRANFORD ESTATE, MILLBROOK, SOUTHAMPTON.
Attribute Name: doubleDependentLocality (GML), DOUBLE_DEPENDENT_LOCALITY (CSV)
Data Type: LocalisedCharacterString (GML), char (CSV)
Condition: If a Double Dependent Locality is present, a Dependent Locality must also be present.
Multiplicity: [0..1]
Size: 35
Source: Royal Mail
Dependent locality areas define an area within a post town. These are only necessary for postal purposes and are used to aid differentiation where there are thoroughfares of the same name in the same locality. For example, HIGH STREET in SHIRLEY and SWAYTHLING in this situation: HIGH STREET, SHIRLEY, SOUTHAMPTON and HIGH STREET, SWAYTHLING, SOUTHAMPTON.
Attribute Name: dependentLocality (GML), DEPENDENT_LOCALITY (CSV)
Data Type: LocalisedCharacterString (GML), char (CSV)
Multiplicity: [0..1]
Size: 35
Source: Royal Mail
A postcode is an abbreviated form of address made up of combinations of between five and seven alphanumeric characters. These are used by Royal Mail to help with the automated sorting of mail. A postcode may cover between 1 and 100 addresses.
There are two main components of a postcode, for example, NW6 4DP:
The outward code (or ‘outcode’). The first two–four characters of the postcode constituting the postcode area and the postcode district, for example, NW6. It is the part of the postcode that enables mail to be sent from the accepting office to the correct area for delivery.
The inward code (or ‘incode’). The last three characters of the postcode constituting the postcode sector and the postcode unit, example, 4DP. It is used to sort mail at the local delivery office.
Attribute Name: postcode (GML), POSTCODE (CSV)
Data Type: CharacterString (GML), char (CSV)
Multiplicity: [1]
Size: 8
Source: Royal Mail
Describes the address as a small or large user as defined by Royal Mail.
Attribute Name: postcodeType (GML), POSTCODE_TYPE (CSV)
Condition: If PO Box number is present Postcode Type must be ‘L’.
Multiplicity: [1]
Size: 1
Source: Royal Mail
A value in metres defining the x and y location in accordance with the British National Grid.
Attribute Name: position (GML), X_COORDINATE, Y_COORDINATE (CSV)
Data Type: GM_Point (GML), Float (CSV)
Multiplicity: [1]
Size: X_COORDINATE (precision, scale) – (8, 2), Y_COORDINATE (precision, scale) – (9, 2)
Source: Contributing Local Authority/Ordnance Survey
A value defining the Longitude and Latitude location in accordance with the ETRS89 coordinate reference system.
Attribute Name: positionLatLong (GML), LATITUDE, LONGITUDE (CSV)
Data Type: GM_Point (GML), Float (CSV)
Multiplicity: [1]
Size: LATITUDE (precision, scale) – (9, 7), LONGITUDE (precision, scale) – (8, 7)
Source: Ordnance Survey
Representative Point Code. This code is used to reflect positional accuracy.
Attribute Name: rpc (GML), RPC (CSV)
Multiplicity: [1]
Size: 1
Source: Contributing Local Authority
The country in which a record can be found.
Attribute Name: country (GML), COUNTRY (CSV)
Multiplicity: [1]
Size: 1
Type of Record Change – please see Section 4 for more information.
Attribute Name: changeType (GML), CHANGE_TYPE (CSV)
Multiplicity: [1]
Size: 1
The date on which the address record was inserted into the database in the CCYY-MM-DD format.
Attribute Name: laStartDate (GML), LA_START_DATE (CSV)
Data Type: Date (GML), Date (CSV)
Multiplicity: [1]
Source: Contributing Local Authority
Date on which the Royal Mail address was loaded into the NAG (National Address Gazetteer in the CCYY-MM-DD format – as maintained by Geoplace) hub.
Attribute Name: rmStartDate (GML), RM_START_DATE (CSV)
Data Type: Date (GML), Date (CSV)
Multiplicity: [1]
Source: Royal Mail
The date on which any of the attributes on this record were last changed in the CCYY-MM-DD format.
Attribute Name: lastUpdateDate (GML), LAST_UPDATE_DATE (CSV)
Data Type: Date (GML), Date (CSV)
Multiplicity: [1]
Primary classification of the address record. For example, identifying the record as commercial (value of ‘C’) or residential (value of ‘R’).
Attribute Name: class (GML), CLASS (CSV)
Data Type: CharacterString (GML), char (CSV)
Multiplicity: [1]
Size: 1
Source: Contributing Local Authority
This section describes the features (one for CSV and two for GML) which make up the AddressBase product, giving the following information about each attribute.
The name of the attribute and what it is describing.
A condition associated with this attribute (optional).
The nature of the attribute, for example a numeric value or a code list value.
Describes how many times this element is expected to be populated in the data. An attribute may be optional or mandatory within the AddressBase product. These are denoted by:
‘1’ – there must be a value.
‘0..1’ – population is optional but a maximum of one attribute will be returned These values may be used in combination.
All the AddressBase products are available as a full supply or a COU. A COU means you will only be supplied with the features which have changed since your last supply. The following sections provide guidance on how you could potentially manage a COU supply of AddressBase and AddressBase Plus data.
If you receive a tile supply, you will receive Change Chunks. This means if a record within your tile has changed, all of the records in that tile will be provided to you as inserts, and no updates or deletes will be issued.
Tiles are only available for GB supplies, so this does not apply to AddressBase Plus Islands.
At a high-level, there are three types of change found within a COU:
Deletes (CHANGE_TYPE ‘D’) are objects that have ceased to exist in your AOI since the last product refresh.
Inserts (CHANGE_TYPE ‘I’) are objects that have been newly inserted into your AOI since the last product refresh.
Updates (CHANGE_TYPE ‘U’) are objects that have been updated in your AOI since the last product refresh.
The diagram below shows how to implement an AddressBase, AddressBase Plus and AddressBase Plus Islands COU within a database.
Before a COU is applied, there may be a business requirement to archive existing address records. The table below shows how to implement archiving with an AddressBase COU within a database.
Within AddressBase and AddressBase Plus there will be no records with the same UPRN. This can be tested by checking the number of records that have the same UPRN. The following SQL code would notify 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.
Once confirmed, the following steps can be taken to apply the COU (without archiving):
Initially delete the existing records that will be updated and deleted:
Insert the new updated records and the new inserted records:
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 or AddressBase Plus table.
The following command creates an archive table of the records that are being updated and deleted from the existing table.
If this table already exists, you can simply use INSERT INTO rather than CREATE TABLE.
The following command then deletes the records from the existing table, which are either updates or deletions:
The following command then inserts the new insert records and the new updated records into the live table:
A common requirement for customers using the AddressBase products is to search for properties using full or partial addresses. Address searches may return a large number of addresses, a short list of possibilities, a single match or no results, depending on the search criteria.
There are many methods of implementing an address search, from free text queries through to structured address component searches. This guide will step through two such approaches that may be used when working with AddressBase and/or AddressBase Plus.
These methods are not intended as recommendations; they are merely examples of how to get maximum value out of the product when implementing an address search function.
One type of search implementation involves a single ‘search engine’ style text box, into which a user can type all or some of an address. For example:
Find address | Results |
---|---|
In this scenario, the user can choose to type anything in Find address, which may be just one component of an address (for example, a postcode, street name or building name), several parts of an address (for example, street name + town name, house name + postcode, etc.) or even (rarely) a complete address.
There may or may not be commas between search items, or address components can be entered with or without capitalised letters, etc. In short, with this search method, there is no structure to the user input and the search methodology must be designed with this in mind.
The other common type of implementation for address searches involves entering search criteria in a structured way (for example, with a different text box for each major address component).
This method guides the user to enter known components of an address and creates a predictable user input structure around which to build a search function. While generally simpler to use and implement, it can be less user-friendly, particularly in cases where it is not obvious which box to type an address component into, for example, is Richmond Terrace a building name or a street?
This guide suggests how to implement the two search methods described above. Both should be used alongside the instructions on formatting single address labels.
The methods described here may be adapted to work with both AddressBase Plus, AddressBase Plus Islands and AddressBase; however, in the case of AddressBase, only Delivery Point Addresses are searchable, so the geographic guidance will not apply to this product.
An address search operation typically requires two stages of interaction from a user and several processing steps from the underlying IT system. These steps can be summarised in the following diagram:
The second user interaction can be omitted if there is only one result returned from the query. In almost all cases, there should be an option to ‘search again’ at the second and third stages in case no results are returned, or if none of the options shown is the required address.
Of course, different applications require different approaches; however, the general principles of the above process apply in all cases where an address is searched for based on user-entered criteria.
Within an interface that accepts structured user input for an address search, it is necessary to ‘map’ the fields presented to the user with those found within AddressBase or AddressBase Plus. In particular, any query will need to test multiple fields for a given input and will need to combine result sets from the two different address formats of AddressBase Plus (or the single address format of AddressBase) in order to produce the most complete result set.
Generally, a search form will describe a simplified view of an address in order to keep the user interface tidy and intuitive. Users may be given a set of text boxes to fill in, generally including building name, building number, street name, locality name, town name and postcode. The relationships between some common search fields and the fields found in AddressBase Plus are as follows:
The above mapping is an example only, and it is possible to breakdown the search fields differently, in which case, a different mapping would be required. The important thing is to consider all possibilities for how data might be recorded. For example, a business name can sometimes appear as an organisation name or a building/PAO name depending on circumstances, so both must be checked when creating a search query.
Numbers need to be handled very carefully due to the presence of suffixes and ranges. There are two options for structuring the search input in these cases:
A single ‘number’ box can be used (as shown above in Flat/Subdivision Number and Building Number), which will then require some string manipulation to split the input into the appropriate numeric range and suffix components in order to search the geographic addresses; or
Four boxes can be provided for each number (start number, start suffix, end number and end suffix), which would then need to be combined into an appropriate string to search the Delivery Point Addresses.
The basic rules to adhere to when generating a search query from structured input are as follows:
Ignore any search boxes that are not filled in with values.
Where a value is entered, assume that a match on at least one of the mapped fields is essential.
In SQL query terms, this means that each search term should generate a sub-query that searches each of the mapped fields (using OR), and that these sub-queries should then be combined together (using AND) into a single search query. The following SQL code illustrates this (for the Delivery Point Address search only) for an example where a street, locality and town name have been entered by the user:
In the above example, streetsearchtext
, localitysearchtext
, and townsearchtext
represent user- entered search terms (which could be parameters within an SQL function) and the GetFormattedAddress(*)
function is a hypothetical user-defined function that returns the formatted address as a single string (suitable for display in the user interface). For more information on formatting addresses, please see Creating a single-line or multi-line address.
On top of this, for a complete query, the two different types of addresses should be queried separately (Geographic and Delivery Point Addresses), and the two result sets should be amalgamated into a single set using a UNION. The following example builds upon the previous example to include Geographic Addresses as well as Delivery Point Addresses.
The SQL UNION
operator will combine the two result sets, discarding any exact duplicates. (Retaining the exact duplicates requires the use of UNION ALL
, but that is not desirable in this example.)
The resulting output from this query will be a set of search results as formatted addresses along with their UPRN. Exact duplicates will be omitted, but all ‘variations’ of the same address will be output (one row for each variation, with the same UPRN repeated more than once potentially). It may be wise to return the Postal Address Flag values against each to enable further filtering, for example, to restrict the results to postal addresses only. Note that the Postal Address Flag is only available in AddressBase Plus. All records in AddressBase are deemed postal as they are from Royal Mail’s PAF data.
A flaw in the above examples is the use of equality operators. In practice, because people do not tend to be consistent with capitalisation of letters, the SQL ‘LIKE’ operator might work better, and depending on the nature of the application, a ‘%’ wildcard could be appended to the end of each search term to allow only the first few letters of an address component to be entered. For example:
Alternatively, if exact matches are required but case sensitivity is not, then the UPPER() or LOWER() SQL functions can be used on each side of the equals sign in comparisons (a solution that should work in all databases):
Finally, to combine all of the approaches, the following would work for maximum flexibility:
When offering a ‘search engine’ style search feature with just a single text box to enter search terms, a wholly different approach is required. No assumptions can be made about the order, format or style of the user input, and the data will need to be ‘indexed’ in a way that facilitates searches of this type.
Search engine style searches are likely to require the creation of an additional index/lookup table for addresses. Such a table is likely to consist of just two main columns: a key value (UPRN) and a formatted address string. Additional columns may be required to allow filtering of results (such as the AddressBase Postal flag values from AddressBase Plus, which would allow the results to be filtered by different address statuses).
The following table shows a possible address index table structure:
Note how the addresses have been formatted as a single text string with a single space between each word (although leaving commas in would do no harm). All forms of each address (both PAF and geographic) have been added to the index, so there can be several rows with the same UPRN. To speed up complex searching, an appropriate index could be added to the Address Text field, such as a full text search index.
Once a suitable search index is in place, the query itself can be put together. The basic idea is to split the user input into search terms by removing commas, double spaces, and other unnecessary whitespace and then splitting it at each single space, as follows:
User input: 4, High Street, westville, wv17
Capitalised, with commas and double-spaces removed:
4 HIGH STREET WESTVILLE WV17
Split into separate search terms:
4
HIGH
STREET
WESTVILLE
WV17
Once the user input has been pre-processed into separate search terms, a query can be generated. The key assumption in this example will be that ALL search terms must be matched against the index table to be considered as a result. This implies a query where each value is matched using an ‘AND’ operator. In order to search the whole index, the ‘LIKE’ operator will need to be used along with a ‘%’ wildcard on either side of the search text. A suitable search query for the above example would be as follows:
This query would return all rows from the index table that contain all of the search terms, along with the appropriate UPRNs. The following table shows how the index table would be used in the above example to return relevant results:
This result set can then be presented to the user, who can select the most appropriate record, which can then be retrieved in full using the UPRN.
Of course, in a practical implementation, the above query would need to be dynamically generated, with a separate condition added for each search term. This example is quite a strict search query that requires all search terms to be present. Many layers of complexity could be added to allow partial and ‘fuzzy’ matches, and to return confidence scores, for example, but such enhancements are beyond the scope of this guide.
This guide is intended as an introduction to implementing address search functionality using AddressBase, AddressBase Plus and AddressBase Plus Islands. The following list is a summary of the main points:
A user front-end for an address search may contain a single, search engine style text box or multiple text boxes representing different parts of an address.
A typical address search function takes place in three stages:
A user enters search text.
A query is run, returning a set of possible matches.
The user selects the address of interest and the full record is then returned.
With a structured search interface, the addresses can be queried directly by mapping the various address fields to the text boxes supplied.
For an unstructured (single text box) interface, it is necessary to create an index table with fully formatted address strings against each UPRN. Queries can then be run against this index table by splitting the user input into individual search terms and requiring them all to be present.
It is possible to filter results by status in AddressBase Plus (for example, postal or non-postal).
Any search function should search all forms of an address (both Geographic and Delivery Point Addresses).
Careful consideration should be given to the use of ‘fuzzy’ search algorithms (such as using wildcard or sound-alike searches).
This technical specification provides detailed technical information about AddressBase. It is targeted at technical users and software developers.
AddressBase provides an address product containing both residential and commercial addresses where a Local Authority address has been matched to a Royal Mail PAF address. This allows users to link additional information about a property to a single address. The product also provides enhancements to the Royal Mail PAF data by assigning an X and Y coordinate on British National Grid and an ETRS89 projection, as well as a primary level classification, and a representative point code describing the positional quality.
This technical specification includes the following sections:
All AddressBase products include the and are based on same .
Please see the section for additional information that applies across all AddressBase products.
AddressBase is structured as a flat file. The data structure in this document is described by means of Unified Modeling Language (UML) class diagrams.
The AddressBase product is constructed as per the following UML diagrams.
Definition: This address record follows the lifecycle of a Postcode Address File (PAF) record matched to a Local Authority record. As a matched record is inserted, deleted and updated within PAF, these changes are incorporated into the AddressBase product. Similarly, if the matched Local Authority address record updates an attribute contained within the AddressBase product, this change will be reflected.
The UML model of AddressBase in CSV format can be seen in the UML diagram below; classes from the Ordnance Survey product specification are coloured orange; all code lists are coloured blue, while enumerations are coloured green.
Definition: This address record follows the lifecycle of a Postcode Address File (PAF) record matched to a Local Authority record. As a matched record is inserted, deleted and updated within PAF, these changes are incorporated into the AddressBase product. Similarly, if the matched Local Authority address record updates an attribute contained within the AddressBase product, this change will be reflected.
The UML model of AddressBase in GML format can be seen in the diagram below. In the UML diagram, classes from the Ordnance Survey product specification are orange, all code lists are coloured blue and enumerations are green.
The AddressBase product will be distributed as a comma-separated values (CSV) file or Geography Markup Language (GML) version 3.2. Both of these formats can either be supplied as a full supply or a change-only update (COU) supply.
The CSV supply of AddressBase means:
There will be one record per line in each file.
Fields will be separated by commas.
String fields will be delimited by double quotes.
No comma will be placed at the end of each row in the file.
Records will be terminated by Carriage Return / Line Feed.
Double quotes inside strings will be escaped by doubling.
Where a field has no value in a record, two commas will be placed together in the record (one for the end of the previous field and one for the end of the null field). Where the null field is a text field double quotes will be included between the two commas, for example - , “”,
AddressBase CSV data will be transferred using Unicode encoded in UTF-8. Unicode includes all the characters in ISO-8859-14 (Welsh characters). Some accented characters are encoded differently.
The transfer will normally be in a single file, but the data can be split into multiple files using volume numbers. Most files will only be split where there are more than one million records.
The header row for the CSV is supplied separately and can be downloaded from the product support pages.
The GML Encoding standard is an Extensible Markup Language (XML) grammar for expressing geographical features. XML schemas are used to define and validate the format and content of GML. The XML specifications that GML is based on are available from the World Wide Web Consortium (W3C) website: More information can be found in the Open Geospatial Consortium (OGC) document, Geography Markup Language v3.2.1: The GML 3.2.1 specification provides a set of schemas that define the GML feature constructs and geometric types. These are designed to be used as a basis for building application-specific schemas, which define the data content.
A GML document is described using a GML Schema. The AddressBase schema document (addressbase.xsd), defines the features in AddressBase GML.
The application schema uses the following XML namespaces, for which definitions are available as given here:
Each feature within the AddressBaseSupplySet:FeatureCollection
is encapsulated in the following member element according to its feature type:
The UPRN of the feature is provided in the XML attribute of the gml:id
In the GML supply you can determine the extent of your supply by the <gml: Envelope>
. For example:
Change the Coordinate System to British_National_Grid by clicking the globe icon .
Click the edit icon .
Code List Name:
Code List Name:
Code List Name:
Code List Name:
Results |
---|
Search Box | Mapped Delivery Point fields | Mapped geographic fields |
---|---|---|
UPRN | Address Text | Statuses (multiple fields) |
---|---|---|
Address text | Statuses (multiple fields) | |
---|---|---|
It imports the GML 3.2.1 schemas which rely on XML as defined by W3C at:
Prefix | Namespace Identifier | Definition available at |
---|
Information about Unicode and UTF-8, the character encoding we have chosen, is available on the Unicode Consortium website:
Member Element | Feature Type |
---|
See for specific GML examples.
Rose Cottage, Main Street, Fieldtown, Addressville, SW99 9ZZ
Rose Cottage, Main Street, Ashford, AS45 9PP
Rose Cottage, Main Street, Buxtew, Monley, MO88 4TY
And so on...
Business Name
Organisation_Name
Organisation
PAO_Text
SAO_Text
Flat/Subdivision Name
Sub_Building_Name Department_Name
SAO_Text
Flat/Subdivision Number
Sub_Building_Name
SAO_StartNumber SAO_StartSuffix SAO_EndNumber
SAO_EndSuffix
Building Name
Building_Name
PAO_Text
Building Number
Building_Number
Building_Name (in cases where a suffix or range is present)
PAO_StartNumber PAO_StartSuffix PAO_EndNumber
PAO_EndSuffix
Street
Thoroughfare Dependent_Thoroughfare
Street PAO_Text
Locality
Dependent_Locality Double_Dependent_Locality
Locality Town Street
Town
Dependent_Locality Post_Town
Town Locality
Postcode
Postcode
Postcode_Locator
123456789012
4 THE MEADOWS HIGH STREET WALTHAMSDALE BURRIDGE BU27 9UB
Local Authority
123456789012
FLAT 4 THE MEADOWS HIGH STREET WALTHAMSDALE BURRIDGE BU27 9UB
PAF
123456789013
4 HIGH STREET WALTHAMSDALE BURRIDGE BU27 9UB
Non-postal
894756389092
4 HIGH STREET WESTVILLE SUNNYTOWN WV17 7HL
Geographic + PAF
894756389132
ROSE COTTAGE 4 HIGH STREET WESTVILLE SUNNYTOWN WV17 7HL
Geographic
274859037849
FLAT 4 HIGHBURY COURT HIGH STREET WESTVILLE SUNNYTOWN WV17 7HL
Geographic + PAF
482974769830
MAPS4U LTD HIGH STREET WESTVILLE SUNNYTOWN WV17 7HL
Geographic + PAF
|
|
This feature is formally known as the GML feature collection and is used to define a collection of features.
This is not supplied as part of the CSV supply. Please see Model Overview CSV and Model Overview GML for more information.
The following sub-sections provide details about the attributes included with this feature, their data types in the different output formats, and other important metadata about them.
Time the data was extracted from the database.
Attribute Name: queryTime (GML), Not provided (CSV)
Data Type: DateTime (GML)
Multiplicity: [1]
Size: 1
The date given as part of a change-only query.
Attribute Name: queryChangeSinceDate (GML), Not provided (CSV)
Data Type: Date (GML)
Multiplicity: [1]
Size: 1
The following section provides example records for both the CSV and GML supplies. Please note that the data given is to provide an example only and should not to be used as accurate data.
Please note how not all attributes are provided where the field is null.
gml |
xsi |
xlink |
CLOVER AVENUE, SW99 9ZZ
1, Clover Avenue, Fieldtown, Addressville, SW99 9ZZ
2, Clover Avenue, Fieldtown, Addressville, SW99 9ZZ
3, Clover Avenue, Fieldtown, Addressville, SW99 9ZZ
4, Clover Avenue, Fieldtown, Addressville, SW99 9ZZ
5, Clover Avenue, Fieldtown, Addressville, SW99 9ZZ
6, Clover Avenue, Fieldtown, Addressville, SW99 9ZZ
7, Clover Avenue, Fieldtown, Addressville, SW99 9ZZ
There are many Date columns within the AddressBase product. Where a type format of Date has been used in the above attribute tables the data will be defined in the following format.
Value | Type | Notes |
---|---|---|
The naming of attributes between GML and CSV will be different due to the requirements of the file formats. For convenience the following table maps the CSV attribute name to the GML attribute name.
CSV | GML |
---|---|
The header files and local custodian codes for AddressBase are available for download from the.
This release note provides information about the release of the AddressBase Core product on 29 October 2024.
Product | Full Supply record count0F[1] | Change-Only Update record count |
---|
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:
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.
Release notes for the AddressBase Core product
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 8 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 10 September 2024 release of AddressBase Core.
This release note provides information about the 02 September 2024 release of AddressBase Core.
This release note provides information about the 27 August 2024 release of AddressBase Core.
This release note provides information about the 19 August 2024 release of AddressBase Core.
This release note provides information about the 13 August 2024 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 count0F[1] | Change-Only Update record count |
---|
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:
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.
Built into XML –
Xlink –
Data source | Date |
---|
Data source | Date |
---|
2007-10-24
Date
Date columns will follow the structure: CCYY-MM-DD
UPRN
uprn
OS_ADDRESS_TOID
osAddressTOID
UDPRN
udprn
ORGANISATION_NAME
organisationName
DEPARTMENT_NAME
departmentName
PO_BOX_NUMBER
poBoxNumber
SUB_BUILDING_NAME
subBuildingName
BUILDING_NAME
buildingName
BUILDING_NUMBER
buildingNumber
DEPENDENT_THOROUGHFARE
dependentThoroughfare
THOROUGHFARE
thoroughfare
POST_TOWN
postTown
DOUBLE_DEPENDENT_LOCALITY
doubleDependentLocality
DEPENDENT_LOCALITY
dependentLocality
POSTCODE
postcode
POSTCODE_TYPE
postcodeType
X_COORDINATE
position
Y_COORDINATE
LATITUDE
positionLatLong
LONGITUDE
RPC
rpc
COUNTRY
country
CHANGE_TYPE
changeType
LA_START_DATE
laStartDate
RM_START_DATE
rmStartDate
LAST_UPDATE_DATE
lastUpdateDate
CLASS
class
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) | 01 November 2024 |
National Land and Property Gazetteer | 01 November 2024 |
One Scotland Gazetteer | 28 October 2024 |
OS MasterMap Topography Layer | 05 September 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 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 |
This release note provides information about the release of the AddressBase Core product on 15 October 2024.
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.
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:
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.
This release note provides information about the release of the AddressBase Core product on 24 September 2024.
Product | Full Supply record count0F[1] | Change-Only Update record count |
---|---|---|
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:
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.
This release note provides information about the release of the AddressBase Core product on 1 October 2024.
Product | Full Supply record count0F[1] | Change-Only Update record count |
---|---|---|
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:
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.
This release note provides information about the release of the AddressBase Core product on 22 October 2024.
Product | Full Supply record count0F[1] | Change-Only Update record count |
---|---|---|
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:
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.
This release note provides information about the release of the AddressBase Core product on 13 August 2024.
Product | Full Supply record count0F[1] | Change-Only Update record count |
---|---|---|
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:
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.
This release note provides information about the release of the AddressBase Core product on 10 September 2024.
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.
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:
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.
This release note provides information about the release of the AddressBase Core product on 8 October 2024.
Product | Full Supply record count0F[1] | Change-Only Update record count |
---|---|---|
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:
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.
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.
Access to this product is free for PSGA members. Find out if you are a PSGA member or try out a sample of AddressBase Core data by accessing the product page here with links to all of the relevant resources. Alternatively, you can try out the full product by applying for a Data Exploration license.
This release note provides information about the release of the AddressBase Core product on 19 August 2024.
Product | Full Supply record count0F[1] | Change-Only Update record count |
---|
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:
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.
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.
This release note provides information about the release of the AddressBase Core product on 17 September 2024.
Product | Full Supply record count0F[1] | Change-Only Update record count |
---|
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:
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.
This release note provides information about the release of the AddressBase Core product on 02 September 2024.
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.
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:
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.
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.
This release note provides information about the release of the AddressBase Core product on 27 August 2024.
Product | Full Supply record count0F[1] | Change-Only Update record count |
---|
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:
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.
Data source | Date |
---|---|
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.
Data source | Date |
---|
Data source | Date |
---|
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 .
Data source | Date |
---|
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)
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)
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)
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)
09 August 2024
National Land and Property Gazetteer
09 August 2024
One Scotland Gazetteer
06 August 2024
OS MasterMap Topography Layer
06 June 2024
Royal Mail Postcode Address File (PAF)
06 September 2024
National Land and Property Gazetteer
06 September 2024
One Scotland Gazetteer
27 August 2024
OS MasterMap Topography Layer
06 June 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) | 16 August 2024 |
National Land and Property Gazetteer | 16 August 2024 |
One Scotland Gazetteer | 06 August 2024 |
OS MasterMap Topography Layer | 25 July 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 |
Royal Mail Postcode Address File (PAF) | 30 August 2024 |
National Land and Property Gazetteer | 30 August 2024 |
One Scotland Gazetteer | 30 August 2024 |
OS MasterMap Topography Layer | 06 June 2024 |
Royal Mail Postcode Address File (PAF) | 23 August 2024 |
National Land and Property Gazetteer | 23 August 2024 |
One Scotland Gazetteer | 06 August 2024 |
OS MasterMap Topography Layer | 25 July 2024 |
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.
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 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.
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
.
Use the steps in Working with CSV data > Loading AddressBase Core into a database to load the COU CSV into a new or existing table, for example, addressbase_core_cou
.
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:
Use the steps in Working with CSV data > Loading AddressBase Core into a database to load the COU CSV into a new or existing table, for example, addressbase_core_cou
.
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.
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]
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]
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)
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]
Type of record change.
Attribute Name: CHANGE_CODE (CSV), change_code (GKPG)
Data Type: varchar
Size: 1
Multiplicity: [1]
Product
Full Supply record count0F[1]
Change-Only Update record count
AddressBase Core
34 512 533
35 379
Product
MGBS Full Count
National 5km tiled supply
Difference
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 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 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 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 465 132
33 864
AddressBase Core
34 465 132
34 465 125
7
Inserts
7 335
Updates
24 673
Deletes
1 856
COU populated 5km tile count
3 302
Product
Full Supply record count0F[1]
Change-Only Update record count
AddressBase Core
34 485 371
33 454
Product
MGBS Full Count
National 5km tiled supply
Difference
AddressBase Core
34 485 371
34 485 364
7
Inserts
7 169
Updates
22 690
Deletes
3 595
COU populated 5km tile count
2 889
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 469 855 | 80 390 |
AddressBase Core | 34 469 855 | 34 469 848 | 7 |
Inserts | 6 619 |
Updates | 71 875 |
Deletes | 1 896 |
COU populated 5km tile count | 3 552 |
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 |
Product | Full Supply record count0F[1] | Change-Only Update record count |
AddressBase Core | 34 481 797 | 31 875 |
Product | MGBS Full Count | National 5km tiled supply | Difference |
AddressBase Core | 34 481 797 | 34 481 790 | 7 |
Inserts | 8 924 |
Updates | 20 324 |
Deletes | 2 627 |
COU populated 5km tile count | 3 115 |
AddressBase Core | 34 465 132 | 33 864 |
AddressBase Core | 34 465 132 | 34 465 125 | 7 |
Inserts | 7 335 |
Updates | 24 673 |
Deletes | 1 856 |
COU populated 5km tile count | 2 584 |
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:
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.
AddressBase Plus contains current properties using addresses sourced from Local Authorities, Ordnance Survey and Royal Mail for England, Wales and Scotland. The product currently contains approximately 37 million records.
The product contains all current addresses validated from Local Custodians and non-postal addresses such as ponds, electricity sub-stations and telephone boxes are also included.
The product enables the end-user to locate an address or property on a map using either X, Y coordinates supplied on a British National Grid or Latitude and Longitude coordinates provided on an ETRS89 projection, and display the Local Authority address elements or the Royal Mail address elements where matched.
AddressBase Plus is structured in a flat file model - containing current properties and addresses sourced from local authorities, Ordnance Survey and Royal Mail matched to the UPRN.
The address information is sourced from 380 local authorities across Great Britain, our own large-scale mapping, Royal Mail and the Valuation Office Agency.
As well as 28 million defined properties, Ordnance Survey have included more than seven million local authority addresses, such as depots and church halls, places of worship and community centres.
Understanding the need to categorise properties, Ordnance Survey incorporated a four-level classification scheme that explains the function of each property.
Take your data analysis to the next level by referencing data to individual addresses (such as flats) rather than mail delivery points (houses divided into flats).
Understanding the need to categorise properties, Ordnance Survey incorporated a four-level classification scheme that explains the function of each property.
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 contains Royal Mail PAF addresses and assigns an x and y coordinate to every address. This lets you carry out only relatively basic analysis.
AddressBase Plus also includes current properties and addresses sourced from local authorities, Ordnance Survey and Royal Mail. Records are matched to the UPRN and structured in a flat-file model.
AddressBase Plus holds more records than AddressBase as it includes objects without postal addresses, such as subdivided properties, places of worship and community centres. It also allows the end-user to locate an address or property on a map, through the assigned x and y coordinates.
Crucially, cross-referencing the information with OS MasterMap products via the OS MasterMap Topography Layer and Integrated Transport Network (ITN) Layer Topographic Identifiers (TOIDs) lets you view address data within a wider geographic context.
Properties yet to be built do not appear in AddressBase Plus. You'd need AddressBase Premium for this information. It's ideal when you're planning the future provision of infrastructure services such as sewerage or high-speed broadband.
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 technical specification provides detailed technical information about AddressBase Plus. It is targeted at technical users and software developers.
AddressBase Plus contains current properties including addresses sourced from local authorities, Ordnance Survey and Royal Mail, all provided with a Unique Property Reference Number (UPRN). It has more records than AddressBase as it includes objects without postal addresses and live records captured by Local Authorities but not matched to Royal Mail PAF data.
The product enables the end-user to locate an address or property on a map using either X, Y coordinates supplied on a British National Grid or Latitude and Longitude coordinates provided on an ETRS89 projection.
The product also includes cross references to OS MasterMap products via OS MasterMap Topography Layer and OS MasterMap Highways Network Layer TOID references.
This technical specification includes the following sections:
All AddressBase products include the and are based on same .
Please see the section for additional information that applies across all AddressBase products.
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.
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:
The Topographic Identifier taken from . 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.
You can download a complete list of classification codes at .
Code List Name:
You can download a complete list of GSS codes at .
Code List Name:
Original full supply | COU records | COU change type |
---|---|---|
POST_TOWN | ISLAND | POSTCODE | DELIVERY_POINT_SUFFIX | GSS_CODE | CHANGE_CODE | TILENAME |
---|---|---|---|---|---|---|
Please see for instructions on how to load and work with AddressBase data. This is a composite guide for , and .
Access to this product is free for PSGA members. Find out if you are a PSGA member or try out a sample of AddressBase Plus data by with links to all of the relevant resources. Alternatively, you can try out the full product by applying for .
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
This feature is formally known as the GML feature collection and is used to define a collection of features.
This is not supplied as part of the CSV supply. Please see the model overviews in AddressBase Plus structure for more information.
The following page provides details about the attributes included with this feature, their data types in the different output formats, and other important metadata about them.
Time the data was extracted from the database.
Attribute Name: queryTime (GML), Not provided (CSV)
Data Type: DateTime
Multiplicity: [1]
The date given as part of a change-only query.
Attribute Name: queryChangeSinceDate (GML), Not provided (CSV)
Data Type: Date
Multiplicity: [0..1]
This section describes the features (one for CSV and two for GML) which make up the AddressBase Plus product, giving detailed information about each attribute.
The name of the attribute and what it is describing.
A condition associated with this attribute. (Optional).
The nature of the attribute, for example a numeric value or a code list value.
Describes how many times this element is expected to be populated in the data. An attribute may be optional or mandatory within the AddressBase Plus product. These are denoted by:
‘1’ there must be a value.
‘0..1’ population is optional but a maximum of one attribute will be returned.
These values may be used in combination.
The address of a property or object which is defined as the main/preferred address by the Local Land and Property Gazetteer (LLPG) custodian, Ordnance Survey or Royal Mail.
The following page provides details about the attributes included with this feature, their data types in the different output formats, and other important metadata about them.
Unique Property Reference Number (UPRN) assigned by the LLPG Custodian or Ordnance Survey.
Attribute Name: uprn (GML), UPRN (CSV)
Data Type: Integer
Size: 12
Multiplicity: [1]
Source: Contributing Local Authority / Ordnance Survey
Royal Mail’s Unique Delivery Point Reference Number (UDPRN).
Attribute Name: udprn (GML), UDPRN (CSV)
Data Type: Integer
Size: 8
Multiplicity: [0..1]
Source: Royal Mail
Type of Record Change – please see COU supply for more information.
Attribute Name: changeType (GML), CHANGE_TYPE (CSV)
Code List Name: ChangeTypeCode
Size: 1
Multiplicity: [1]
A code identifying the current state of the property.
Attribute Name: state (GML), STATE (CSV)
Code List Name: StateCode
Size: 1
Multiplicity: [0..1]
Source: Contributing Local Authority
Date on which the property achieved its current state in the real world in the CCYY-MM-DD format.
Attribute Name: stateDate (GML), STATE_DATE (CSV)
Condition: State Date must be present if State is present.
Data Type: Date
Size: 1
Multiplicity: [0..1]
Source: Contributing Local Authority
Classification of the address record.
Attribute Name: class (GML), CLASS (CSV)
Data Type: CharacterString (GML), char (CSV)
Size: 6
Multiplicity: [1]
Source: Contributing Local Authority
UPRN of the parent record if a parent child relationship exists.
Attribute Name: class (GML), CLASS (CSV)
Data Type: Integer
Size: 12
Multiplicity: [0..1]
Source: Contributing Local Authority
A value in metres defining the x and y location in accordance with the British National Grid.
Attribute Name: position (GML), X_COORDINATE, Y_COORDINATE (CSV)
Data Type: GM_Point (GML), Float (CSV)
Size: X_COORDINATE (precision, scale) – (8, 2), Y_COORDINATE (precision, scale) – (9, 2)
Multiplicity: [1]
Source: Contributing Local Authority/Ordnance Survey
A value defining the Longitude and Latitude location in accordance with the ETRS89 coordinate reference system.
Attribute Name: positionLatLong (GML), LATITUDE, LONGITUDE (CSV)
Data Type: GM_Point (GML), Float (CSV)
Size: LATITUDE (precision, scale) – (9, 7), LONGITUDE (precision, scale) – (8, 7)
Multiplicity: [1]
Source: Ordnance Survey
Representative Point Code. This code is used to reflect positional accuracy.
Attribute Name: rpc (GML), RPC (CSV)
Code List Name: RPCCode
Size: 1
Multiplicity: [1]
Source: Contributing Local Authority
Unique identifier of the LLPG Custodian.
Attribute Name: localCustodianCode (GML), LOCAL_CUSTODIAN_CODE (CSV)
Data Type: Integer
Size: 4
Multiplicity: [1]
The country in which a record can be found.
Attribute Name: country (GML), COUNTRY (CSV)
Code List Name: CountryCode
Size: 1
Multiplicity: [1]
The date on which the address record was inserted into the database in the CCYY-MM-DD format.
Attribute Name: laStartDate (GML), LA_START_DATE (CSV)
Data Type: Date
Multiplicity: [1]
Source: Contributing Local Authority
The date on which any of the attributes on this record were last changed in the CCYY-MM-DD format.
Attribute Name: lastUpdateDate (GML), LAST_UPDATE_DATE (CSV)
Data Type: Date
Multiplicity: [1]
The date on which the record was inserted into the Local Authority database in the CCYY-MM-DD format.
Attribute Name: entryDate (GML), ENTRY_DATE (CSV)
Data Type: Date
Multiplicity: [1]
Source: Contributing Local Authority.
The organisation name is the business name given to a delivery point within a building or small group of buildings. For example: TOURIST INFORMATION CENTRE
This field could also include entries for churches, public houses and libraries.
Attribute Name: rmOrganisationName (GML), RM_ORGANISATION_NAME (CSV)
Condition:
Organisation Name or PO Box Number must be present if Building Name or Building Number are all not present.
RM Organisation Name must be present if Department Name is present.
Data Type: LocalisedCharacterString (GML), char (CSV)
Size: 60
Multiplicity: [0..1]
Source: Royal Mail
Name of current occupier as provided by the Local Authority Custodian.
Attribute Name: laOrganisation (GML), LA_ORGANISATION (CSV)
Data Type: LocalisedCharacterString (GML), char (CSV)
Size: 100
Multiplicity: [0..1]
Source: Contributing Local Authority
For some organisations, department name is indicated because mail is received by subdivisions of the main organisation at distinct delivery points. For example, Organisation Name: ABC COMMUNICATIONS or RM Department Name: MARKETING DEPARTMENT
Attribute Name: departmentName (GML), DEPARTMENT_NAME (CSV)
Data Type: LocalisedCharacterString (GML), char (CSV)
Size: 60
Multiplicity: [0..1]
Source: Royal Mail
Registered legal name of the organisation.
Attribute Name: legaltName (GML), LEGAL_NAME (CSV)
Data Type: LocalisedCharacterString (GML), char (CSV)
Size: 60
Multiplicity: [0..1]
Source: Contributing Local Authority
The sub-building name and/or number are identifiers for subdivisions of properties.
For example:
Sub-building Name: FLAT 3 Building Name: POPLAR COURT Thoroughfare: LONDON ROAD
If the above address is styled 3 POPLAR COURT, all the text will be shown in the Building Name attribute and the Sub-building Name will be empty. The building number will be shown in this field when it contains a range, decimal or non-numeric character (see Building Number).
Attribute Name: subBuildingName (GML), SUB_BUILDING_NAME (CSV)
Condition: If a Sub Building Name is present, a Building Name or Building Number must also be present.
Data Type: LocalisedCharacterString (GML), char (CSV)
Size: 30
Multiplicity: [0..1]
Source: Royal Mail
The building name is a description applied to a single building or a small group of buildings, such as Highfield House. This also includes those building numbers that contain non-numeric characters, such as 44A.
Some descriptive names, when included with the rest of the address, are sufficient to identify the property uniquely and unambiguously, for example, MAGISTRATES COURT.
Sometimes the building name will be a blend of distinctive and descriptive naming, for example, RAILWAY TAVERN (PUBLIC HOUSE) or THE COURT ROYAL (HOTEL).
Attribute Name: buildingName (GML), BUILDING_NAME (CSV)
Condition: Building Name must be present if RM Organisation Name or Building Number or PO Box Number are all not present.
Data Type: LocalisedCharacterString (GML), char (CSV)
Size: 50
Multiplicity: [0..1]
Source: Royal Mail
The building number is a number given to a single building or a small group of buildings, thus identifying it from its neighbours, for example, 44. Building numbers that contain a range, decimals or non-numeric characters do not appear in this field but will be found in the buildingName or the sub-BuildingName fields.
Attribute Name: buildingNumber (GML), BUILDING_NUMBER (CSV)
Condition: Building Number must be present if Organisation Name or Building Name or PO Box Number are all not present.
Data Type: Integer
Size: 4
Multiplicity: [0..1]
Source: Royal Mail
The number of the secondary addressable object (SAO) or the start of the number range.
Attribute Name: saoStartNumber (GML), SAO_START_NUMBER (CSV)
Condition: If a SAO Start Number is present a PAO Start Number or PAO text must also be present.
Data Type: Integer
Size: 4
Multiplicity: [0..1]
The suffix to the SAO_START_NUMBER.
Attribute Name: saoStartSuffix (GML), SAO_START_SUFFIX (CSV)
Condition: If a SAO Start Suffix is present a SAO Start Number must also be present.
Data Type: CharacterString (GML), char (CSV)
Size: 2
Multiplicity: [0..1]
Source: Contributing Local Authority
The end of the number range for the SAO, where the SAO_START_NUMBER contains the first number in the range.
Attribute Name: saoEndNumber (GML), SAO_END_NUMBER (CSV)
Condition: If SAO End Number is present, a SAO Start Number must also be present.
Data Type: Integer
Size: 4
Multiplicity: [0..1]
Source: Contributing Local Authority
The suffix to the SAO_END_NUMBER.
Attribute Name: saoEndSuffix (GML), SAO_END_SUFFIX (CSV)
Condition: If a SAO End Suffix is present, a SAO End Number must also be present.
Data Type: CharacterString (GML), char (CSV)
Size: 2
Multiplicity: [0..1]
Source: Contributing Local Authority
Describes the SAO, such as Maisonette.
Attribute Name: saoText (GML), SAO_TEXT (CSV)
Condition: If SAO Text is present, a PAO Start Number or PAO Text must also be present.
Data Type: LocalisedCharacterString (GML), char (CSV)
Size: 90
Multiplicity: [0..1]
Source: Contributing Local Authority
Describes the SAO, such as Maisonette.
Attribute Name: altLanguageSAOText (GML), ALT_LANGUAGE_SAO_TEXT (CSV)
Data Type: LocalisedCharacterString (GML), char (CSV)
Size: 90
Multiplicity: [0..1]
Source: Contributing Local Authority
The number of the primary addressable object (PAO) or the start of the number range.
Attribute Name: paoStartNumber (GML), PAO_START_NUMBER (CSV)
Condition: PAO Start Number must be present if PAO Text is not present.
Data Type: Integer
Size: 4
Multiplicity: [0..1]
Source: Contributing Local Authority
The suffix to the PAO_START_NUMBER.
Attribute Name: paoStartSuffix (GML), PAO_START_SUFFIX (CSV)
Condition: If a PAO Start Suffix is present, a PAO Start Number must also be present.
Data Type: CharacterString (GML), char (CSV)
Size: 2
Multiplicity: [0..1]
Source: Contributing Local Authority
The end of the number range for the PAO where the PAO_START_NUMBER contains the first number in the range.
Attribute Name: paoEndNumber (GML), PAO_END_NUMBER (CSV)
Condition: If a PAO End Number is present, a PAO Start Number must also be present.
Data Type: Integer
Size: 4
Multiplicity: [0..1]
Source: Contributing Local Authority
The suffix to the PAO end number.
Attribute Name: paoEndSuffix (GML), PAO_END_SUFFIX (CSV)
Condition: If a PAO End Suffix is present, a PAO End Number must also be present.
Data Type: CharacterString (GML), char (CSV)
Size: 2
Multiplicity: [0..1]
Source: Contributing Local Authority
Name describing the PAO, such as Sunrise Towers.
Attribute Name: paoText (GML), PAO_TEXT (CSV)
Condition: PAO Text must be present if PAO Start Number is not present.
Data Type: LocalisedCharacterString (GML), char (CSV)
Size: 90
Multiplicity: [0..1]
Source: Contributing Local Authority
Name describing the PAO, such as Sunrise Towers, in an alternative language.
Attribute Name: altLanguagePAOText (GML), ALT_LANGUAGE_PAO_TEXT (CSV)
Data Type: LocalisedCharacterString (GML), char (CSV)
Size: 90
Multiplicity: [0..1]
Source: Contributing Local Authority
Unique Street Reference Number (USRN).
Attribute Name: usrn (GML), USRN (CSV)
Data Type: Integer
Size: 8
Multiplicity: [1]
Source: Contributing Local Authority
This field indicates how the item was matched to a Street. 1 is matched manually to the most accessible USRN and 2 is matched spatially to the nearest USRN, which may not be the nearest accessible street.
Attribute Name: usrnMatchIndicator (GML), USRN_MATCH_INDICATOR (CSV)
Code List Name: USRNMatchIndicatorCode
Size: 1
Multiplicity: [1]
Source: Contributing Local Authority/Ordnance Survey
Third level of geographic area name, for example, to record island names or property groups such as crofts.
Attribute Name: areaName (GML), AREA_NAME (CSV)
Data Type: CharacterString (GML), char (CSV)
Size: 40
Multiplicity: [0..1]
Source: Contributing Local Authority
Memorandum of the vertical position of the property.
Attribute Name: level (GML), LEVEL (CSV)
Data Type: CharacterString (GML), char (CSV)
Size: 30
Multiplicity: [0..1]
Source: Contributing Local Authority
Status of the Address.
Attribute Name: officialFlag (GML), OFFICIAL_FLAG (CSV)
Code List Name: OfficialFlagCode
Size: 1
Multiplicity: [0..1]
Source: Contributing Local Authority
Unique identifier provided by Ordnance Survey.
Attribute Name: osAddressTOID (GML), OS_ADDRESS_TOID (CSV)
Data Type: CharacterString (GML), char (CSV)
Size: 20
Multiplicity: [0..1]
Source: Ordnance Survey
The version of the OS Address TOID that the product relates to.
Attribute Name: osAddressTOIDVersion (GML), OS_ADDRESS_TOID_VERSION (CSV)
Condition: OS Address TOID Version must be present if OS Address TOID is present.
Data Type: Integer
Size: 3
Multiplicity: [0..1]
Source: Ordnance Survey
The OS MasterMap Highways Network road link that the addressable object refers to.
Attribute Name: osRoadLinkTOID (GML), OS_ROADLINK_TOID (CSV)
Data Type: CharacterString (GML), char (CSV)
Size: 20
Multiplicity: [0..1]
Source: Ordnance Survey
The version of the OS Road Link TOID the product relates to.
Attribute Name: osAddressTOIDVersion (GML), OS_ADDRESS_TOID_VERSION (CSV)
Condition: OS Roadlink TOID Version must be present if OS Road Link TOID is present.
Data Type: Integer
Size: 3
Multiplicity: [0..1]
Source: Ordnance Survey
The OS MasterMap Topography Layer TOID that the addressable object refers to.
Attribute Name: osTopoTOID (GML), OS_TOPO_TOID (CSV)
Data Type: CharacterString (GML), char (CSV)
Size: 20
Multiplicity: [0..1]
Source: Ordnance Survey
The version of the OS Topo TOID the product relates to.
Attribute Name: osTopoTOIDVersion (GML), OS_TOPO_TOID_VERSION (CSV)
Condition: OS Topo TOID Version must be present if OS Topo TOID is present.
Data Type: Integer
Size: 3
Multiplicity: [0..1]
Source: Ordnance Survey
The unique reference to the Valuation Office Agency (VOA) council tax record which the addressable object refers to.
Attribute Name: voaCTRecord (GML), VOA_CT_RECORD (CSV)
Data Type: Integer
Size: 50
Multiplicity: [0..1]
Source: Valuation Office Agency
The unique reference to the Valuation Office Agency (VOA) council tax record which the addressable object refers to.
Attribute Name: voaNDRRecord (GML), VOA_NDR_RECORD (CSV)
Data Type: Integer
Size: 50
Multiplicity: [0..1]
Source: Valuation Office Agency
Name taken from the Local Land and Property Gazetteer (LLPG) street name.
Attribute Name: streetDescription (GML), STREET_DESCRIPTION (CSV)
Data Type: LocalisedCharacterString (GML), char (CSV)
Size: 100
Multiplicity: [0..1]
Source: Contributing Local Authority
Name taken from the LLPG street name in an alternative language.
Attribute Name: altLanguageStreetDescription (GML), ALT_LANGUAGE_STREET_DESCRIPTION (CSV)
Data Type: LocalisedCharacterString (GML), char (CSV)
Size: 100
Multiplicity: [0..1]
Source: Contributing Local Authority
In certain places (for example, town centres), there are named thoroughfares within other named thoroughfares (for example, parades of shops on a high street where different parades have their own identity), for example, KINGS PARADE, HIGH STREET and QUEENS PARADE, HIGH STREET.
Attribute Name: dependentThoroughfare (GML), DEPENDENT_THOROUGHFARE (CSV)
Data Type: LocalisedCharacterString (GML), char (CSV)
Size: 80
Multiplicity: [0..1]
Source: Royal Mail
A thoroughfare in AddressBase is fundamentally a road, track or named access route on which there are Royal Mail delivery points, for example, HIGH STREET.
Attribute Name: thoroughfare (GML), THOROUGHFARE (CSV)
Condition: Thoroughfare must be present if dependent thoroughfare is present.
Data Type: LocalisedCharacterString (GML), char (CSV)
Size: 80
Multiplicity: [0..1]
Source: Royal Mail
The Welsh translation of DEPENDENT_THOROUGHFARE.
Attribute Name: welshDependentThoroughfare (GML), WELSH_DEPENDENT_THOROUGHFARE (CSV)
Condition: If a Welsh Dependent Thoroughfare is present, a Welsh Thoroughfare must also be present.
Data Type: LocalisedCharacterString (GML), char (CSV)
Size: 80
Multiplicity: [0..1]
Source: Royal Mail
The Welsh translation of THOROUGHFARE.
Attribute Name: welshThoroughfare (GML), WELSH_THOROUGHFARE (CSV)
Data Type: LocalisedCharacterString (GML), char (CSV)
Multiplicity: [0..1]
Size: 80
Source: Royal Mail
This is used to distinguish between similar thoroughfares or the same thoroughfare within a dependent locality. For example, Millbrook Industrial Estate and Cranford Estate in this situation: BRUNEL WAY, MILLBROOK INDUSTRIAL ESTATE, MILLBROOK, SOUTHAMPTON and BRUNEL WAY, CRANFORD ESTATE, MILLBROOK, SOUTHAMPTON.
Attribute Name: doubleDependentLocality (GML), DOUBLE_DEPENDENT_LOCALITY (CSV)
Condition: If a Double Dependent Locality is present, a Dependent Locality must also be present.
Data Types: LocalisedCharacterString (GML), char (CSV)
Size: 35
Multiplicity: [0..1]
Source: Royal Mail
Dependent locality areas define an area within a post town. These are only necessary for postal purposes and are used to aid differentiation where there are thoroughfares of the same name in the same locality. For example, HIGH STREET in SHIRLEY and SWAYTHLING in this situation: HIGH STREET, SHIRLEY, SOUTHAMPTON and HIGH STREET, SWAYTHLING, SOUTHAMPTON.
Attribute Name: dependentLocality (GML), DEPENDENT_LOCALITY (CSV)
Data Types: LocalisedCharacterString (GML), char (CSV)
Size: 35
Multiplicity: [0..1]
Source: Royal Mail
A locality defines an area or geographical identifier within a town, village or hamlet.
Attribute Name: locality (GML), LOCALITY (CSV)
Data Types: LocalisedCharacterString (GML), char (CSV)
Size: 35
Multiplicity: [0..1]
Source: Contributing Local Authority
The Welsh translation of DEPENDENT_LOCALITY.
Attribute Name: welshDependentLocality (GML), WELSH_DEPENDENT_LOCALITY (CSV)
Data Types: LocalisedCharacterString (GML), char (CSV)
Size: 35
Multiplicity: [0..1]
Source: Royal Mail
The Welsh translation of Double Dependent Locality.
Attribute Name: welshDoubleDependentLocality (GML), WELSH_DOUBLE_DEPENDENT_LOCALITY (CSV)
Condition: If a Welsh Double Dependent Locality is present, a Welsh Dependent Locality must also be present.
Data Types: LocalisedCharacterString (GML), char (CSV)
Size: 35
Multiplicity: [0..1]
Source: Royal Mail
The name of the town the address is within.
Attribute Name: townName (GML), TOWN_NAME (CSV)
Data Types: CharacterString (GML), char (CSV)
Size: 30
Multiplicity: [0..1]
Source: Contributing Local Authority
Local Highway Authority name.
Attribute Name: administrativeArea (GML), ADMINISTRATIVE_AREA (CSV)
Data Types: CharacterString (GML), char (CSV)
Size: 30
Multiplicity: [1]
Source: Contributing Local Authority
The town or city in which the Royal Mail sorting office is located which services this record. There may be more than one, possibly several, sorting offices in a town or city.
Attribute Name: postTown (GML), POST_TOWN (CSV)
Condition: Post Town must be present if Royal Mail’s Unique Delivery Point Reference Number (UDPRN) is present.
Data Types: LocalisedCharacterString (GML), char (CSV)
Size: 35
Multiplicity: [0..1]
Source: Royal Mail
The Welsh translation of post town value.
Attribute Name: welshPostTown (GML), WELSH_POST_TOWN (CSV).
Data Types: LocalisedCharacterString (GML), char (CSV)
Size: 30
Multiplicity: [0..1]
Source: Royal Mail
A postcode is an abbreviated form of address made up of combinations of between five and seven alphanumeric characters. These are used by Royal Mail to help with the automated sorting of mail. A postcode may cover between 1 and 100 addresses.
There are two main components of a postcode, for example, NW6 4DP:
The outward code (or ‘outcode’). The first two–four characters of the postcode constituting the postcode area and the postcode district, for example, NW6. It is the part of the postcode that enables mail to be sent from the accepting office to the correct area for delivery.
The inward code (or ‘incode’). The last three characters of the postcode constituting the postcode sector and the postcode unit, example, 4DP. It is used to sort mail at the local delivery office.
Attribute Name: postcode (GML), POSTCODE (CSV)
Condition: Postcode must be present if Royal Mail’s Unique Delivery Point Reference Number (UDPRN) is present.
Data Types: CharacterString (GML), char (CSV)
Size: 8
Multiplicity: [0..1]
Source: Royal Mail
This field contains the Royal Mail Postcode Address File (PAF) postcode where the local authority address has been matched to PAF, that is, the POSTCODE field. Where a match has not been made, the postcode information is sourced from the local authority in collaboration with Royal Mail. Where the local authority does not hold a current valid postcode, Code-Point with Polygons is used to spatially derive the postcode based on the position of the coordinates.
This field is always assigned the Code-Point with Polygons Postcode for Street Records (Classification “PS”).
This field must be used in conjunction with the RPC field to determine the accuracy of its position.
Attribute Name: postcodeLocator (GML), POSTCODE_LOCATOR (CSV)
Data Types: CharacterString (GML), char (CSV)
Size: 8
Multiplicity: [1]
Source: Royal Mail, Contributing Local Authority or Ordnance Survey
Describes the address as a small or large user as defined by Royal Mail.
Attribute Name: postcodeType (GML), POSTCODE_TYPE (CSV)
Condition:
Postcode Type must be present if Royal Mail’s Unique Delivery Point Reference Number (UDPRN) is present.
Postcode Type Code must equal ‘L’ if PO Box Number is present.
Code List Name: PostcodeTypeCode
Size: 1
Multiplicity: [0..1]
Source: Royal Mail
A two-character code uniquely identifying an individual delivery point within a postcode.
Attribute Name: deliveryPointSuffix (GML), DELIVERY_POINT_SUFFIX (CSV)
Condition: Delivery Point Suffix must be present if Royal Mail’s Unique Delivery Point Reference Number (UDPRN) is present.
Data Type: CharacterString (GML), char (CSV)
Size: 2
Multiplicity: [0..1]
Source: Royal Mail
Identifies addresses which are believed to be capable of receiving mail as defined specifically for the AddressBase product and details their relationship with other AddressBase Postal records.
This field identifies some addresses which the AddressBase product believes to be capable of receiving mail which are not contained within the Royal Mail PAF database, such as flats behind a front door which has a single letter box.
Attribute Name: addressbasePostal (GML), ADDRESSBASE_POSTAL (CSV)
Condition: If AddressBase Postal value is ‘D’, UDPRN must be present.
Code List Name: AddressbasePostalCode
Size: 1
Multiplicity: [1]
Source: Royal Mail
Post Office Box (PO Box) number.
Attribute Name: poBoxNumber (GML), PO_BOX_NUMBER (CSV)
Condition: Organisation Name or PO Box Number must be present if Building Name or Building Number are all not present.
Data Types: CharacterString (GML), char (CSV)
Size: 6
Multiplicity: [0..1]
Source: Royal Mail
The ONS GSS code of the electoral ward (England and Scotland) or the electoral division (Wales) name in which the property is situated, as assigned spatially from the latest Boundary-Line set. Boundary-Line ward boundary areas are produced directly from Statutory Instruments, which are authorised from the owning boundary changing bodies, namely, The Local Government and Parliamentary Boundary Commissions.
Attribute Name: wardCode (GML), WARD_CODE (CSV)
Condition: Organisation Name or PO Box Number must be present if Building Name or Building Number are all not present.
Data Types: CharacterString (GML), char (CSV)
Size: 9
Multiplicity: [0..1]
Source: Ordnance Survey
The ONS GSS code of the parish, town or community in which the property is situated, as assigned spatially from the latest Boundary-Line set. Boundary-Line parish boundary areas are produced directly from Statutory Instruments, which are authorised from the owning boundary changing bodies, namely, The Local Government and Parliamentary Boundary Commissions.
Attribute Name: parishCode (GML), PARISH_CODE (CSV)
Condition: Organisation Name or PO Box Number must be present if Building Name or Building Number are all not present.
Data Types: CharacterString (GML), char (CSV)
Size: 9
Multiplicity: [0..1]
Source: Ordnance Survey
Date on which the Royal Mail address was loaded into the NAG (National Address Gazetteer – as maintained by Geoplace) hub.
Attribute Name: rmStartDate (GML), RM_START_DATE (CSV)
Condition: RM Start Date must be present if Royal Mail’s Unique Delivery Point Reference Number (UDPRN) is present.
Data Types: Date
Multiplicity: [0..1]
Source: Royal Mail
This is a count of all the child UPRNs for this record if a parent-child relationship exists.
Attribute Name: multiOccCount (GML), MULTI_OCC_COUNT (CSV)
Data Type: Integer
Size: 4
Multiplicity: [0..1]
Source: Ordnance Survey
VOA non-domestic rates primary description code, for example, ‘IF2’.
The first letter is the primary category:
C = commercial
E = education
F = formula-assessed utility
I = industrial
L = leisure
M = miscellaneous
N = non-formula-assessed utility
T = Treasury (crown)
The second letter provides further detail, for example, O = office, F = factory.
The third and fourth digit is optional and occurs where further subdivision is required, for example, IF1 = mill, IF2 = works, IF3 = workshop and IF4 = business unit.
Attribute Name: voaNDRPDescCode (GML), VOA_NDR_DESC_CODE (CSV)
Data Type: CharacterString (GML), char (CSV)
Size: 5
Multiplicity: [0..1]
Source: Valuation Office Agency
VOA non-domestic rates special category code, for example, ‘016’.
While the Primary Description code above provides a general level of classification, there is a SCat code for every kind of premise that VOA rates. For example, within PDesc IF2 (industrial, factory, works) there are 009 (aluminium smelting works), 016 (artificial fibre works), 052 (cement works), 055 (chemical works), 110 (foundries), 142 (iron and/or steel works), 192 (motor vehicle works) and 198 (newspaper printing works).
Attribute Name: voaNDRPScatCode (GML), VOA_NDR_SCAT_CODE (CSV)
Data Type: CharacterString (GML), char (CSV)
Size: 4
Multiplicity: [0..1]
Source: Valuation Office Agency
Field describing the language of the alternative records.
Attribute Name: altLanguage (GML), ALT_LANGUAGE (CSV)
Code List Name: LanguageCode
Size: 3
Multiplicity: [0..1]
Source: Contributing Local Authority
The AddressBase product will be distributed as a comma-separated values (CSV) file or Geography Markup Language (GML) version 3.2. Both of these formats can either be supplied as a full supply or a change-only update (COU) supply.
The CSV supply of AddressBase means:
There will be one record per line in each file.
Fields will be separated by commas.
String fields will be delimited by double quotes.
No comma will be placed at the end of each row in the file.
Records will be terminated by Carriage Return / Line Feed.
Double quotes inside strings will be escaped by doubling.
Where a field has no value in a record, two commas will be placed together in the record (one for the end of the previous field and one for the end of the null field). Where the null field is a text field double quotes will be included between the two commas, for example:
AddressBase CSV data will be transferred using Unicode encoded in UTF-8. Unicode includes all the characters in ISO-8859-14 (Welsh characters). Some accented characters are encoded differently.
The transfer will normally be in a single file, but the data can be split into multiple files using volume numbers. Most files will only be split where there are more than one million records.
The header row for the CSV is supplied separately and can be downloaded from the product support pages.
The GML Encoding standard is an Extensible Markup Language (XML) grammar for expressing geographical features. XML schemas are used to define and validate the format and content of GML. The XML specifications that GML is based on are available from the World Wide Web Consortium (W3C) website: http://www.w3.org. More information can be found in the Open Geospatial Consortium (OGC) PDF document, Geography Markup Language v3.2.1: https://portal.ogc.org/files/?artifact_id=20509. The GML 3.2.1 specification provides a set of schemas that define the GML feature constructs and geometric types. These are designed to be used as a basis for building application-specific schemas, which define the data content.
A GML document is described using a GML Schema. The AddressBase schema document (addressbase.xsd), defines the features in AddressBase GML.
It imports the GML 3.2.1 schemas which rely on XML as defined by W3C at: http://www.w3.org/XML/1998/namespace.html.
The application schema uses the following XML namespaces, for which definitions are available as given here:
Information about Unicode and UTF-8, the character encoding we have chosen, is available on the Unicode Consortium website: http://www.unicode.org/.
Each feature within the AddressBaseSupplySet:FeatureCollection
is encapsulated in the following member element according to its feature type:
The UPRN of the feature is provided in the XML attribute of the gml:id
See Example records > GML for specific GML examples.
In the GML supply you can determine the extent of your supply by the <gml: Envelope>
. For example:
AddressBase Plus is structured as a flat file. The data structure in this document is described by means of Unified Modeling Language (UML) class diagrams.
The AddressBase Plus product is constructed as per the following UML diagrams.
Definition: The address of a property or object which is defined as the main/preferred address by the Local Land and Property Gazetteer (LLPG) custodian, Ordnance Survey or Royal Mail.
The diagram below shows the UML model of AddressBase Plus in CSV format: classes from the Ordnance Survey product specification are orange; code lists are blue and enumerations are green.
Definition: The address of a property or object which is defined as the main / preferred address by the Local Land and Property Gazetteer (LLPG) custodian, Ordnance Survey or Royal Mail.
The diagram below shows the UML model of AddressBase Plus in GML format: classes from the Ordnance Survey product specification are orange, code lists are blue and enumerations are green.
The naming of attributes between GML and CSV will be different due to the requirements of the file formats. The attributes are listed together in , but for convenience the following table maps the CSV attribute name to the GML attribute name.
CSV | GML |
---|
The following section provides example records for both the CSV and GML supplies. Please note the data given is to provide an example only and is not to be used as accurate data.
Prefix | Namespace Identifier | Definition available at |
---|---|---|
Member Element | Feature Type |
---|---|
gml
xsi
Built into XML – http://www.w3.org/TR/xmlschema-1/
xlink
Xlink – http://www.w3.org/1999/xlink
<abpl:addressMember>
Address
UPRN | uprn |
UDPRN | udprn |
CHANGE_TYPE | changeType |
STATE | state |
STATE_DATE | stateDate |
CLASS | class |
PARENT_UPRN | parentUPRN |
X_COORDINATE | position |
Y_COORDINATE |
LATITUDE | positionLatLong |
LONGITUDE |
RPC | rpc |
LOCAL_CUSTODIAN_CODE | localCustodianCode |
COUNTRY | country |
LA_START_DATE | laStartDate |
LAST_UPDATE_DATE | lastUpdateDate |
ENTRY_DATE | entryDate |
RM_ORGANISATION_NAME | rmOrganisationName |
LA_ORGANISATION | laOrganisation |
DEPARTMENT_NAME | departmentName |
LEGAL_NAME | legalName |
SUB_BUILDING_NAME | subBuildingName |
BUILDING_NAME | buildingName |
BUILDING_NUMBER | buildingNumber |
SAO_START_NUMBER | saoStartNumber |
SAO_START_SUFFIX | saoStartSuffix |
SAO_END_NUMBER | saoEndNumber |
SAO_END_SUFFIX | saoEndSuffix |
SAO_TEXT | saoText |
ALT_LANGUAGE_SAO_TEXT | altLanguageSAOText |
PAO_START_NUMBER | paoStartNumber |
PAO_START_SUFFIX | paoStartSuffix |
PAO_END_NUMBER | paoEndNumber |
PAO_END_SUFFIX | paoEndSuffix |
PAO_TEXT | paoText |
ALT_LANGUAGE_PAO_TEXT | altLanguagePAOText |
USRN | usrn |
USRN_MATCH_INDICATOR | usrnMatchIndicator |
AREA_NAME | areaName |
LEVEL | level |
OFFICIAL_FLAG | officialFlag |
OS_ADDRESS_TOID | osAddressTOID |
OS_ADDRESS_TOID_VERSION | osAddressTOIDVersion |
OS_ROADLINK_TOID | osRoadLinkTOID |
OS_ROADLINK_TOID_VERSION | osRoadLinkTOIDVersion |
OS_TOPO_TOID | osTopoTOID |
OS_TOPO_TOID_VERSION | osTopoTOIDVersion |
VOA_CT_RECORD | voaCTRecord |
VOA_NDR_RECORD | voaNDRRecord |
STREET_DESCRIPTION | streetDescription |
ALT_LANGUAGE_STREET_DESCRIPTION | altLanguageStreetDescription |
DEPENDENT_THOROUGHFARE | dependentThoroughfare |
THOROUGHFARE | thoroughfare |
WELSH_DEPENDENT_THOROUGHFARE | welshDependentThoroughfare |
WELSH_THOROUGHFARE | welshThoroughfare |
DOUBLE_DEPENDENT_LOCALITY | doubleDependentLocality |
DEPENDENT_LOCALITY | dependentLocality |
LOCALITY | locality |
WELSH_DEPENDENT_LOCALITY | welshDependentLocality |
WELSH_DOUBLE_DEPENDENT_LOCALITY | welshDoubleDependentLocality |
TOWN_NAME | townName |
ADMINISTRATIVE_AREA | administrativeArea |
POST_TOWN | postTown |
WELSH_POST_TOWN | welshPostTown |
POSTCODE | postcode |
POSTCODE_LOCATOR | postcodeLocator |
POSTCODE_TYPE | postcodeType |
DELIVERY_POINT_SUFFIX | deliveryPointSuffix |
ADDRESSBASE_POSTAL | addressbasePostal |
PO_BOX_NUMBER | poBoxNumber |
WARD_CODE | wardCode |
PARISH_CODE | parishCode |
RM_START_DATE | rmStartDate |
MULTI_OCC_COUNT | multiOccCount |
VOA_NDR_P_DESC_CODE | voaNDRPDescCode |
VOA_NDR_SCAT_CODE | voaNDRScatCode |
ALT_LANGUAGE | altLanguage |
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 Getting Started Guides for AddressBase, AddressBase Plus and AddressBase Plus Islands.
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 Getting Started Guides for AddressBase, AddressBase Plus and AddressBase Plus Islands.
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 Getting Started Guides for AddressBase, AddressBase Plus and AddressBase Plus Islands.
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 Getting Started Guides for AddressBase, AddressBase Plus and AddressBase Plus Islands.
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 Getting Started Guides for AddressBase, AddressBase Plus and AddressBase Plus Islands.
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 Getting Started Guides for AddressBase, AddressBase Plus and AddressBase Plus Islands.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
114
07 November 2024
03 October 2024
115
19 December 2024
14 November 2024
116
06 February 2025
03 Januaary 2025
117
20 March 2025
14 February 2025
118
01 May 2025
28 March 2025
OS APIs
Explore API references, getting started guides and code examples for developing with OS APIs.
OS Emergency Services Gazetteer
A new gazetteer which contains the locations of names, places and objects to support use cases related to the Protection of Life.
OS Multi-modal Routing Network
A new routable network product which integrates and connects OS road network and routing information, path network and rail network to create a multi-modal routing network.
The primary supply mechanism of AddressBase data is referred to as non-geographic chunks. This is a way of dividing up the data into chunks that are supplied in separate volumes, which have a fixed maximum number of records. The supply is not supplied with any reference to the geographic position of records.
Public Sector Geospatial Agreement (PSGA) customers can order Geographic chunks (5km tiles) as well as non-geographic chunks, although geographic chunks are not considered the main form of supply.
All customers are also able to take a complete supply (referred to as a Managed Great Britain Set: MGBS) or an Area of Interest (AOI) as a full supply or a COU supply.
If you receive your data as non-geographic chunks, the filename will be constructed as follows:
productName_supply_ccyy-mm-dd_vvv.format
Where:
ProductName is AddressBasePlus.
supply is defined as FULL
or COU
.
ccyy-mm-dd is the date the file was generated.
vvv is the volume number of the file.
format is the format of the files received, for example, csv
or gml
.
For example:
• AddressBasePlus_FULL_2013-05-28_001.gml
(GML full supply)
• AddressBasePlus_COU_2013-05-28_001.csv
(CSV COU supply)
If the data has been provided in a ZIP file, the filename will be constructed as follows:
productName_supply_ccyy-mm-dd_vvv_format.zip
For example:
AddressBasePlus_FULL_2013-05-28_001_gml.zip
(GML full supply zipped)
If you receive your data as geographic chunks (PSGA customers only), the filename will be constructed as follows:
productName_supply_ccyy-mm-dd_ngxxyy.format
Where:
ProductName is AddressBasePlus.
supply is defined as FULL
or COU
.
ccyy-mm-dd is the date the file was generated.
ngxxyy is the four-digit grid reference belonging to the 1km south-west corner of the 5km chunk.
format is the format of the files received, for example, csv
or gml
.
For example:
AddressBasePlus_FULL_2013-05-28_NC4040.gml
(GML full fupply)
AddressBasePlus_COU_2013-05-28_NC4040.csv
(CSV COU supply)
If the data has been provided in a ZIP file, the filename will be constructed as follows:
productName_supply_ccyy-mm-dd_ngxxyy_format.zip
For example:
AddressBasePlus_COU_2013-05-28_NC4040_csv.zip
(CSV COU supply zipped)
AddressBase Plus is available as a full or a COU supply.
A COU supply contains records or files that have changed between product refresh cycles. The primary benefit in supplying data in this way is that data volumes are smaller therefore reducing the amount of data that requires processing when compared to a full supply.
COU data enables a user to identify three types of change:
Deletes (CHANGE_TYPE ‘D’) are objects that have ceased to exist in your AOI since the last product refresh.
Inserts (CHANGE_TYPE ‘I’) are objects that have been newly inserted into your AOI since the last product refresh.
Updates (CHANGE_TYPE ‘U’) are objects that have been updated in your AOI since the last product refresh.
A COU file for non-geographic chunked data can be identified by its naming convention as highlighted above.
Any change record will be provided as a full record with the appropriate change type, as listed above.
A geographic chunked COU is not supplied as per the non-geographic chunked COU outlined above. Its file naming convention can be found above. If a single 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.