These pages describe the two data types available for the OS Emergency Services Gazetteer (OS ESG):
The attributes associated with each data type are listed on the following pages. The following information can be found about each attribute:
The name of the attribute and what it is describing.
The values the attribute can take. For example, a numeric value or a string. This is provided for both data formats – GeoPackage and CSV.
The maximum total number of decimal digits to be stored. This number includes both the left and the right sides of the decimal point. The precision must be a value from 1 through the maximum precision of 38. The SQL Server default precision is 18.
Scale (s) is the number of decimal digits that are stored to the right of the decimal point. This number is subtracted from precision (p) to determine the maximum number of digits to the left of the decimal point. Scale must be a value from 0 through p, and can only be specified if precision is specified. The default scale is 0 and so 0 <= s <= p. Maximum storage sizes vary, based on the precision.
The name of the code list used in association with the attribute (if applicable) and a hyperlink to the page displaying that code list.
Values are given here to indicate the maximum length that you will find in the attribute, to aid in developing applications.
A True or False value to denote whether the attribute always has to be populated with a value (False) or can be NULL (True).
The schema version the data above applies to.
The Classification (Type 32 Record) Data Type defines a structured entry that provides the code for the type of feature.
The earliest date on which you can request a one-off snapshot of a date in the past for data in this data type is 27 March 2024.
The following sub-sections provide details about the attributes included with this data type, their 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 GeoPackage format.
Attribute Name: fid (GKPG), Not provided (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Nullable: false
Data Schema Version: 1.0
Identifies this record as a Classification Record (type 32).
Attribute Name: Not provided (GKPG), RECORD_IDENTIFIER (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Size: 2
Nullable: false
Data Schema Version: 1.0
The type of record change.
Attribute Name: change_type (GKPG), CHANGE_TYPE (CSV)
Size: 1
Nullable: false
Data Schema Version: 1.0
The order in which the records were processed to create the data supply.
Attribute Name: Not provided (GKPG), PRO_ORDER (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Size: 16
Nullable: false
Data Schema Version: 1.0
The Unique Property Reference Number (UPRN). This is a foreign key used to reference the classification records to the corresponding BLPU.
Attribute Name: uprn (GKPG), UPRN (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Size: 12
Nullable: false
Data Schema Version: 1.0
The unique key for the classification record and primary key for this table.
Attribute Name: class_key (GKPG), CLASS_KEY (CSV)
Data Types: String (GKPG), String (CSV)
Max Length: 14
Nullable: false
Data Schema Version: 1.0
Alphanumeric code used to classify the feature.
Attribute Name: classification_code (GKPG), CLASSIFICATION_CODE (CSV)
Data Types: String (GKPG) , String (CSV)
Max Length: 6
Nullable: false
Data Schema Version: 1.0
The name of the classification scheme used for this record.
Attribute Name: class_scheme (GKPG), CLASS_SCHEME (CSV)
Data Types: String (GKPG), String (CSV)
Max Length: 60
Nullable: false
Data Schema Version: 1.0
The classification scheme version number.
Attribute Name: scheme_version (GKPG), SCHEME_VERSION (CSV)
Data Types: float (GKPG), Real (CSV)
Precision: 2
Scale: 1
Nullable: false
Data Schema Version: 1.0
The date on which this classification record was first loaded into the database.
Attribute Name: start_date (GKPG), START_DATE (CSV)
Data Types: Date (GKPG), Date (CSV)
Nullable: false
Data Schema Version: 1.0
The date on which this classification record ceased to exist.
Attribute Name: end_date (GKPG), END_DATE (CSV)
Data Types: Date (GKPG), Date (CSV)
Nullable: true
Data Schema Version: 1.0
The date on which an attribute on this record was last changed.
Attribute Name: last_update_date (GKPG), LAST_UPDATE_DATE (CSV)
Data Types: Date (GKPG), Date (CSV)
Nullable: false
Data Schema Version: 1.0
The date on which the record associated with this classification record was inserted into the database.
Attribute Name: entry_date (GKPG), ENTRY_DATE (CSV)
Data Types: Date (GKPG), Date (CSV)
Nullable: false
Data Schema Version: 1.0
Please see the for more information.
Code List Name:
The Land Property Identifier (LPI) Data Type defines a structured entry that identifies a BLPU. The AddressBase Premium data structure provides the facility to describe a BLPU by more than one LPI. In England and Scotland there is one Approved LPI (English), whereas in Wales there are two Approved LPIs (English and Welsh).
The earliest date on which you can request a one-off snapshot of a date in the past for data in this data type is 27 March 2024.
The following sub-sections provide details about the attributes included with this data type, their types in the different output formats, and other important metadata about them.
Please note, the following attributes will not be populated within the OS ESG: SAO Start Number, SAO Start Suffix, SAO End Number, SAO End Suffix, SAO Text, PAO Start Number, PAO Start Suffix, PAO End Number, and PAO End Suffix.
A non-persistent integer which is autogenerated and is required within the OGC GeoPackage format.
Attribute Name: fid (GKPG), Not provided (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Nullable: false
Data Schema Version: 1.0
Identifies this Record as an LPI Record (type 24).
Attribute Name: Not provided (GKPG), RECORD_IDENTIFIER (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Size: 2
Nullable: false
Data Schema Version: 1.0
The type of record change.
Please see the 'Available formats' section in the OS ESG Overview for more information.
Attribute Name: change_type (GKPG), CHANGE_TYPE (CSV)
Code List Name: ChangeTypeCode
Size: 1
Nullable: false
Data Schema Version: 1.0
The order in which the records were processed to create the data supply.
Attribute Name: Not provided (GKPG), PRO_ORDER (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Size: 16
Nullable: false
Data Schema Version: 1.0
The Unique Property Reference Number (UPRN). This is a foreign key used to reference the LPI to the corresponding BLPU.
Attribute Name: uprn (GKPG), UPRN (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Size: 12
Nullable: false
Data Schema Version: 1.0
The unique key for the LPI and primary key for this table. A 14-character string, prefixed with '7655L' then a nine-digit sequential number.
Attribute Name: lpi_key (GKPG), LPI_KEY (CSV)
Data Types: String (CSV), String (GKPG)
Max Length: 14
Nullable: false
Data Schema Version: 1.0
A code that identifies the language used for the LPI record (the names and / or descriptions in PAO_text and SAO_text).
Attribute Name: language (GKPG), LANGUAGE (CSV)
Code List Name: LanguageCode
Size: 3
Nullable: false
Data Schema Version: 1.0
The logical status of this record.
Attribute Name: logical_status (GKPG), LOGICAL_STATUS (CSV)
Code List Name: LogicalStatusCode
Size: 1
Nullable: false
Data Schema Version: 1.0
The date on which this LPI record was inserted into the database.
Attribute Name: start_date (GKPG), START_DATE (CSV)
Data Types: Date (GKPG), Date (CSV)
Nullable: false
Data Schema Version: 1.0
The date on which this record ceased to exist in the database.
Attribute Name: end_date (GKPG), END_DATE (CSV)
Data Types: Date (GKPG), Date (CSV)
Nullable: true
Data Schema Version: 1.0
The date on which any of the attributes on this record were last changed.
Attribute Name: last_update_date (GKPG), LAST_UPDATE_DATE (CSV)
Data Types: Date (GKPG), Date (CSV)
Nullable: false
Data Schema Version: 1.0
The date on which the record was inserted into the database.
Attribute Name: entry_date (GKPG), ENTRY_DATE (CSV)
Data Types: Date (GKPG), Date (CSV)
Nullable: false
Data Schema Version: 1.0
The number of the secondary addressable object (SAO) or the start of the number range.
Attribute Name: sao_start_number (GKPG), SAO_START_NUMBER (CSV),
Data Types: Integer (GKPG), Integer (CSV)
Size: 4
Nullable: true
Data Schema Version: 1.0
The suffix to the SAO_START_NUMBER.
Attribute Name: sao_start_suffix (GKPG), SAO_START_SUFFIX (CSV)
Data Types: String (GKPG) , String (CSV)
Max Length: 2
Nullable: true
Data Schema Version: 1.0
The end of the number range for the SAO, where the SAO_START_NUMBER contains the first number in the range.
Attribute Name: sao_end_number (GKPG), SAO_END_NUMBER (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Size: 4
Nullable: true
Data Schema Version: 1.0
The suffix to the SAO_END_NUMBER.
Attribute Name: sao_end_suffix (GKPG), SAO_END_SUFFIX (CSV)
Data Types: String (GKPG) , String (CSV)
Max Length: 2
Nullable: true
Data Schema Version: 1.0
Additional location information where transport or water networks interact with the feature to provide the names and / or numbers of those networks. The pipe symbol (|) is used to separate multiple names.
Please note, SAO Text will be in alphanumeric order. Where names are known to be Gaelic in origin, these will appear first in records in Scotland. In Wales, the known Welsh names will be on the Welsh LPI (CYM), and the known English names will be on the English LPI (ENG). Where it is not known, or the name in use is in both languages, the same name may appear on both the English and Welsh LPI.
Attribute Name: sao_text (GKPG), SAO_TEXT (CSV)
Data Types: String (GKPG) , String (CSV)
Max Length: 400
Nullable: true
Data Schema Version: 1.0
The number of the primary addressable object (PAO) or the start of the number range.
Attribute Name: pao_start_number (GKPG), PAO_START_NUMBER (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Size: 4
Nullable: true
Data Schema Version: 1.0
The suffix to the PAO_START_NUMBER.
Attribute Name: pao_start_suffix (GKPG), PAO_START_SUFFIX (CSV)
Data Types: String (GKPG), String (CSV)
Max Length: 2
Nullable: true
Data Schema Version: 1.0
The end of the number range for the PAO where the PAO_START_NUMBER contains the first number in the range.
Attribute Name: pao_end_number (GKPG), PAO_END_NUMBER (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Size: 4
Nullable: true
Data Schema Version: 1.0
The suffix to the PAO_END_NUMBER.
Attribute Name: pao_end_suffix (GKPG), PAO_END_SUFFIX (CSV)
Data Types: String (GKPG), String (CSV)
Max Length: 2
Nullable: true
Data Schema Version: 1.0
The proper name(s) used to identify the feature. Where the official name is not known, a default value is given based on the classification. The pipe symbol (|) is used to separate multiple names.
Please note, PAO text will be in alphanumeric order. Where names are known to be Gaelic in origin, these will appear first in records in Scotland. In Wales, the known Welsh names will be on the Welsh LPI (CYM), and the known English names will be on the English LPI (ENG). Where it is not known, or the name in use is in both languages, the same name may appear on both the English and Welsh LPI.
Attribute Name: pao_text (GKPG), PAO_TEXT (CSV)
Data Types: String (GKPG), String (CSV)
Max Length: 90
Nullable: true
Data Schema Version: 1.0
The Unique Street Reference Number (USRN). This is a foreign key linking the Street record to the LPI record.
Unique Street Reference Number (USRN) for a Street intersecting or near a junction. BLPUs will be assigned a USRN; these only refer to the USRNs published in AddressBase Premium.
Attribute Name: usrn (GKPG), USRN (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Size: 8
Nullable: false
Data Schema Version: 1.0
This field indicates how the feature 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: usrn_match_indicator (GKPG), USRN_MATCH_INDICATOR (CSV)
Code List Name: USRNMatchIndicatorCode
Size: 1
Nullable: false
Data Schema Version: 1.0
Additional location information indicating, for example, a city or town and any relevant other named urban areas. In non-urban areas, the Lower Tier Local Authority is provided. Where a BLPU is located on an island, the name of the island is additionally returned. (NEAR) indicates either within 1km of a settlement onshore, or within 500m of a named island or 1km from a Lower Tier Local Authority offshore. Where a BLPU does not meet this case, this value will be NULL.
Please note, settlement boundaries and islands used are an OS geographic depiction of the extent of settlements and should not be mistaken for official administrative or electoral boundaries. Please see the OS National Geographic Database (OS NGD) Named Features Collection for further information. Lower Tier Local Authority Areas used are from the OS National Geographic Database (OS NGD) Boundaries Collection.
Attribute Name: area_name (GKPG), AREA_NAME (CSV)
Data Types: String (GKPG), String (CSV)
Max Length: 100
Nullable: true
Data Schema Version: 1.0
Detail on the vertical position of the property, if known and provided by the authority.
Attribute Name: level (GKPG), LEVEL (CSV)
Data Types: String (GKPG), String (CSV)
Max Length: 30
Nullable: true
Data Schema Version: 1.0
The status of the feature.
Attribute Name: official_flag (GKPG), OFFICIAL_FLAG (CSV)
Code List Name: OfficialFlagCode
Size: 1
Nullable: true
Data Schema Version: 1.0