Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
This technical specification provides detailed technical information about the OS ESG. It is targeted at technical users and software developers.
The OS Emergency Services Gazetteer (OS ESG) is a product that offers a national view for Great Britain (i.e. England, Wales and Scotland). The product was designed to support the Emergency Services with incident response, incident reporting and situational awareness by providing pivotal features such as road and motorway junctions.
The OS ESG is structured as a series of relational tables:
Basic Land and Property Unit (BLPU), which shows fixed locations.
Local Property Identifier (LPI), which identifies the BLPUs.
Classification, which provides feature codes.
This technical specification includes the following sections:
These pages describe the single feature type (BLPU (Type 21 Record)) available for the OS Emergency Services Gazetteer (OS ESG).
The attributes associated with the feature type are listed on the following page. 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.
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 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
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 code lists for the OS ESG.
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 (OS ESG). Some of the code lists only apply to attributes of the feature type and both structured data types, whereas others will only apply to attributes of either the feature type or one of the two structured data types.
The pages in this section display the code lists in alphabetical order, with one code list provided per page.
Please note, not all of the code lists listed will be populated within the OS ESG product.
The Basic Land and Property Unit (BLPU) Feature Type is a real-world object that is an area of land, property or structure of fixed location, having uniform occupation, ownership or function.
The earliest date on which you can request a one-off snapshot of a date in the past for data in this feature type is 27 March 2024.
The following sub-sections provide details about the attributes included with this feature type, their data 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: Parent_UPRN and Multi_Occ_Count.
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 BLPU Record (type 21).
Attribute Name: Not provided (GKPG), RECORD_IDENTIFIER (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Max Length: 2
Nullable: false
Data Schema Version: 1.0
The type of record change.
Attribute Name: change_type (GKPG), CHANGE_TYPE (CSV)
Max Length: 1
Nullable: false
Data Schema Version: 1.0
The order in which the records were processed in to create the data supply.
Attribute Name: Not provided (GKPG), PRO_ORDER (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Max Length: 16
Nullable: false
Data Schema Version: 1.0
Unique Property Reference Number (UPRN) assigned by Ordnance Survey.
Attribute Name: uprn (GKPG), UPRN (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Max Length: 12
Nullable: false
Data Schema Version: 1.0
Logical status of this record as given by Ordnance Survey. This attribute shows whether the record is currently live or historic.
Attribute Name: logical_status (GKPG), LOGICAL_STATUS (CSV)
Max Length: 1
Nullable: false
Data Schema Version: 1.0
A code identifying the current state of the BLPU.
Attribute Name: blpu_state_date (GPKG), BLPU_STATE_DATE (CSV)
Max Length: 1
Nullable: true
Data Schema Version: 1.0
Date at which the BLPU achieved its current state as defined in the BLPU State field.
Attribute Name: blpu_state_date (GKPG), BLPU_STATE_DATE (CSV)
Condition: BLPU State Date must be present if BLPU State is present.
Data Types: Date (GKPG), Date (CSV)
Nullable: true
Data Schema Version: 1.0
UPRN of the parent Record if a parent-child relationship exists.
Attribute Name: parent_uprn (GKPG), PARENT_UPRN (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Max Length: 12
Nullable: true
Data Schema Version: 1.0
A value in metres defining the x location in accordance with the British National Grid.
Attribute Name: x_coordinate (GKPG) , X_COORDINATE (CSV)
Data Types: Double (GKPG), Real (CSV)
Precision: X_COORDINATE 8
Scale: 2
Nullable: false
Data Schema Version: 1.0
A value in metres defining the y location in accordance with the British National Grid.
Attribute Name: y_coordinate (GKPG) , Y_COORDINATE (CSV)
Data Types: Double (GKPG), Real (CSV)
Precision: Y_COORDINATE 9
Scale: 2
Nullable: false
Data Schema Version: 1.0
A value defining the Latitude location in accordance with the ETRS89 coordinate reference system.
Attribute Name: latitude (GKPG), LATITUDE (CSV)
Data Types: Double (GKPG), Real (CSV)
Precision: LATITUDE 9
Scale: 7
Nullable: false
Data Schema Version: 1.0
A value defining the Longitude location in accordance with the ETRS89 coordinate reference system.
Attribute Name: longitude (GKPG), LONGITUDE (CSV)
Data Types: Double (GKPG), Real (CSV)
Precision: LONGITUDE 8
Scale: 7
Nullable: false
Data Schema Version: 1.0
Representative Point Code. This describes the accuracy of the coordinate that has been allocated to the BLPU as indicated by Ordnance Survey.
Attribute Name: rpc (GKPG), RPC (CSV)
Max Length: 1
Nullable: false
Data Schema Version: 1.0
Unique identifier of the authority responsible for the maintenance of this record.
Attribute Name: local_custodian_code (GKPG), LOCAL_CUSTODIAN_CODE (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Max Length: 4
Nullable: false
Data Schema Version: 1.0
The date on which the 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 the record was closed 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 this 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
A count of all of the child UPRNs for this record where a parent-child relationship exists.
Attribute Name: multi_occ_count (GKPG), MULTI_OCC_COUNT (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Max Length: 4
Nullable: false
Data Schema Version: 1.0
This field will be populated with ‘N’ within the OS ESG; all the BasicLandPropertyUnit features are considered as 'Not a postal address'.
Attribute Name: addressbase_postal (GKPG), ADDRESSBASE_POSTAL (CSV)
Max Length: 1
Nullable: false
Data Schema Version: 1.0
The Land Property Identifier (LPI) Data Type defines a structured entry that identifies a . 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.
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
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)
Size: 3
Nullable: false
Data Schema Version: 1.0
The logical status of this record.
Attribute Name: logical_status (GKPG), LOGICAL_STATUS (CSV)
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.
Attribute Name: usrn (GKPG), USRN (CSV)
Data Types: Integer (GKPG), Integer (CSV)
Size: 8
Nullable: false
Data Schema Version: 1.0
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.
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)
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. Where relevant, island names are included. In non-urban areas, the Lower Tier Local Authority is provided. (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.
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)
Size: 1
Nullable: true
Data Schema Version: 1.0
The code list describes the record as postal or not, as defined by AddressBase logic. This code list is used in association with the ADDRESSBASE_POSTAL (CSV) / addressbase_postal (GKPG) attribute on the table.
| Value | Description |
|---|
Please see the for more information.
Code List Name:
Code List Name:
Code List Name:
Code List Name:
Code List Name:
Please see the for more information
Code List Name:
The Unique Property Reference Number (UPRN). This is a foreign key used to reference the LPI to the corresponding .
Code List Name:
Code List Name:
Code List Name:
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 for further information. Lower Tier Local Authority Areas used are from .
Code List Name:
N | Record that is not a postal address. |
The following sub-sections provide details about the attributes included with this data type.
Please note, a header record is not provided in GPKG and the attributes that follow refer to only CSV.
Identifies the record as a Header Record (type 10).
Attribute Name: RECORD_IDENTIFIER (CSV)
Type: Integer
Size: 2
Nullable: false
Data Schema Version: 1.0
The name of the data provider organisation.
Attribute Name: CUSTODIAN_NAME (CSV)
Type: char
Size: 40
Nullable: false
Data Schema Version: 1.0
The unique identifier for the data provider code.
Attribute Name: LOCAL_CUSTODIAN_CODE (CSV)
Type: Integer
Size: 4
Nullable: false
Data Schema Version: 1.0
The date on which the data supply was generated.
Attribute Name: PROCESS_DATE (CSV)
Type: Date
Nullable: false
Data Schema Version: 1.0
The sequential number of the volume in the transfer set.
For geographic supplies, this number will always be zero (0).
Attribute Name: VOLUME_NUMBER (CSV)
Type: Integer
Size: 3
Nullable: false
Data Schema Version: 1.0
The date of data entry for this volume.
Attribute Name: ENTRY_DATE (CSV)
Type: Date
Nullable: false
Data Schema Version: 1.0
The time of file creation in HH:MM:SS format in a 24-hour clock.
Attribute Name: TIME_STAMP (CSV)
Type: Time
Nullable: false
Data Schema Version: 1.0
The version number of the product schema, for example, 1.0, 2.0.
Attribute Name: VERSION (CSV)
Type: char
Size: 7
Nullable: false
Data Schema Version: 1.0
Indicates whether the data supply is a Full Supply or a Change-Only Updates Supply.
Attribute Name: FILE_TYPE (CSV)
Size: 1
Nullable: false
Data Schema Version: 1.0
This code list identifies the type of change that has been made to a feature. Please see the 'Product supply' page in the OS ESG Overview for more information. This code list is used in association with the CHANGE_TYPE (CSV) / change_type (GKPG) attribute.
| Value | Description |
|---|---|
This code list describes the physical nature of the address record. This code list is used in association with the BLPU_STATE (CSV) / blpu_state (GKPG) attribute.
| Value | Description |
|---|---|
The code list describes within which country the feature falls (England, Wales or Scotland). This code list is used in association with the COUNTRY (CSV) / country (GKPG) attribute on the BLPU table.
| Value | Description |
|---|---|
This code list describes the classification code for each feature. The classification codes will be expanded as necessary for future releases.
The new bridge interaction classification codes that are due to be added to this code list in December 2024 are included (and clearly labelled) in the table below.
| Value | Description |
|---|---|
The OS Emergency Services Gazetteer Classification Scheme is available to download from the OS ESG Downloads page.
The new bridge interaction classification codes (listed in the Classification Code code list above) will be added to the OS Emergency Services Gazetteer Classification Scheme In December 2024. In the meantime, these codes are available from the OS ESG Downloads page as a separate file.
This code list allows the identification of either a Change-Only Update (COU) Supply or a Full Supply. This code list is used in association with the FILE_TYPE (CSV) attribute found in the Header record.
| Value | Description |
|---|---|
This code list identifies how the USRN has been allocated to a features record. This code list is used in association with the USRN_MATCH_INDICATOR (CSV) / usrn_match_indicator (GKPG) attribute found on the .
| Value | Description |
|---|
This code list is an indicator of whether a features record corresponds to an entry in the official Street Name and Numbering register. This code list is used in association with the OFFICIAL_FLAG (CSV) / official_flag (GKPG) attribute found on the table.
| Value | Description |
|---|
This code list provides a value to show the lifecycle stage of the features record. This code list is used in association with the LOGICAL_STATUS (CSV) / logical_status (GKPG) attribute found in the and tables.
| Value | Description |
|---|
The code list identifies the accuracy value of the coordinates allocated to the feature. This code list is used in association with the RPC (CSV) / rpc (GKPG) attribute found on the table.
| Value | Description | Implementation notes |
|---|
The sub-pages in this section define dataset metadata for the CSV format of OS Emergency Services Gazetteer (OS ESG) data:
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 nature of the attribute (for example, a numeric value or a code list value).
The maximum length of the values in the attribute.
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 version number relates to the product schema and not to this document.
Type:
I
Insert.
U
Update.
D
Delete.
2
In use.
E
England.
W
Wales.
S
Scotland.
CT18CA
Aqueduct Over Canal (Available from early December 2024).
CT18MU
Aqueduct Over Multiple (Available from early December 2024).
CT18NN
Aqueduct Over No Network (Available from early December 2024).
CT18PA
Aqueduct Over Path (Available from early December 2024).
CT18RA
Aqueduct Over Railway (Available from early December 2024).
CT18RO
Aqueduct Over Road (Available from early December 2024).
CT18WA
Aqueduct Over Water (Available from early December 2024).
CT16CA
Bridge Over Canal (Available from early December 2024).
CT16MU
Bridge Over Multiple (Available from early December 2024).
CT16NN
Bridge Over No Network (Available from early December 2024).
CT16PA
Bridge Over Path (Available from early December 2024).
CT16RA
Bridge Over Railway (Available from early December 2024).
CT16RO
Bridge Over Road (Available from early December 2024).
CT16WA
Bridge Over Water (Available from early December 2024).
CT19CA
Canal Aqueduct Over Canal (Available from early December 2024).
CT19MU
Canal Aqueduct Over Multiple (Available from early December 2024).
CT19NN
Canal Aqueduct Over No Network (Available from early December 2024).
CT19PA
Canal Aqueduct Over Path (Available from early December 2024).
CT19RA
Canal Aqueduct Over Railway (Available from early December 2024).
CT19RO
Canal Aqueduct Over Road (Available from early December 2024).
CT19WA
Canal Aqueduct Over Water (Available from early December 2024).
CT17CA
Footbridge Over Canal (Available from early December 2024).
CT17MU
Footbridge Over Multiple (Available from early December 2024).
CT17NN
Footbridge Over No Network (Available from early December 2024).
CT17PA
Footbridge Over Path (Available from early December 2024).
CT17RA
Footbridge Over Railway (Available from early December 2024).
CT17RO
Footbridge Over Road (Available from early December 2024).
CT17WA
Footbridge Over Water (Available from early December 2024).
CT14MJ
Motorway Junction.
CT20CA
Multi-Network Bridge Over Canal (Available from early December 2024).
CT20MU
Multi-Network Bridge Over Multiple (Available from early December 2024).
CT20NN
Multi-Network Bridge Over No Network (Available from early December 2024).
CT20PA
Multi-Network Bridge Over Path (Available from early December 2024).
CT20RA
Multi-Network Bridge Over Railway (Available from early December 2024).
CT20RO
Multi-Network Bridge Over Road (Available from early December 2024).
CT20WA
Multi-Network Bridge Over Water (Available from early December 2024).
LO02CR
Named Area Of Coastal Rock.
CT07RL
Named Area Of Railway Land.
LW04AS
Named Area Of Sea.
LW04BA
Named Bay.
LO02CH
Named Cirque Or Hollow.
LO02CS
Named Cliff Or Slope.
LO02HD
Named Coastal Headland.
LO02RA
Named Coastal Ravine.
LW04ES
Named Estuary.
LO02GI
Named Group Of Islands.
LW04HA
Named Harbour.
LO02HM
Named Hill Or Mountain.
LW04IM
Named Inland Water Marsh.
LO02IS
Named Island.
ZM05LS
Named Linear Structure.
LO02CL
Named Other Coastal Landform.
LO02GA
Named Other Geographic Area.
LO02OC
Named Other Land Cover.
LO02OL
Named Other Landform.
LO02RH
Named Range Of Hills Or Mountains.
LO02SH
Named Spot Height.
LW04IW
Named Stretch Of Inland Water.
LW04TW
Named Stretch Of Tidal Water.
LO02TC
Named Tidal Land Cover.
LO02NV
Named Valley.
LW04WF
Named Waterfall.
CT15CA
Railway Bridge Over Canal (Available from early December 2024).
CT15MU
Railway Bridge Over Multiple (Available from early December 2024).
CT15NN
Railway Bridge Over No Network (Available from early December 2024).
CT15PA
Railway Bridge Over Path (Available from early December 2024).
CT15RA
Railway Bridge Over Railway (Available from early December 2024).
CT15RO
Railway Bridge Over Road (Available from early December 2024).
CT15WA
Railway Bridge Over Water (Available from early December 2024).
CT11CA
Road Bridge Over Canal (Available from early December 2024).
CT11MU
Road Bridge Over Multiple (Available from early December 2024).
CT11NN
Road Bridge Over No Network (Available from early December 2024).
CT11PA
Road Bridge Over Path (Available from early December 2024).
CT11RA
Road Bridge Over Railway (Available from early December 2024).
CT11RO
Road Bridge Over Road (Available from early December 2024).
CT11WA
Road Bridge Over Water (Available from early December 2024).
CT14RJ
Road Junction.
CT14RD
Roundabout.
CT21CA
Underpass Under Canal (Available from early December 2024).
CT21MU
Underpass Under Multi-Network (Available from early December 2024).
CT21NN
Underpass Under No Network (Available from early December 2024).
CT21RA
Underpass Under Railway (Available from early December 2024).
CT21RO
Underpass Under Road (Available from early December 2024).
F
Signifies the supply is a Full Supply.
C
Signifies the supply is a COU file.
ENG
English.
CYM
Welsh.
2 | Matched spatially to the nearest USRN. Not necessarily the access street. |
N | Unofficial Address. |
1 | Approved. |
3 | Alternative. |
8 | Historical. |
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. |
The following sub-sections provide details about the attributes included with this data type.
Please note, a header record is not provided in GeoPackage and the attributes that follow refer to only CSV.
Identifies the record as a Trailer Record (type 99).
Attribute Name: RECORD_IDENTIFIER (CSV)
Type: Integer
Size: 2
Nullable: false
Data Schema Version: 1.0
The sequential number of the next volume in the transfer set.
For geographic supply, this will always be zero (0). For non-geographic supply, zero (0) denotes the last file in the transfer set.
Attribute Name: NEXT_VOLUME_NAME (CSV)
Type: Integer
Size: 3
Nullable: false
Data Schema Version: 1.0
A count of the number of records in the volume (excluding the header record, metadata and trailer records).
Attribute Name: RECORD_COUNT (CSV)
Type: Integer
Size: 16
Nullable: false
Data Schema Version: 1.0
The date of data entry.
Attribute Name: ENTRY_DATE (CSV)
Type: Date
Nullable: false
Data Schema Version: 1.0
The time of creation in HH:MM:SS format in a 24-hour clock.
Attribute Name: TIME_STAMP (CSV)
Type: Time
Nullable: false
Data Schema Version: 1.0
The following sub-sections provide details about the attributes included with this data type.
Please note, a header record is not provided in GeoPackage and the attributes that follow refer to only CSV.
Identifies the record as a Metadata Record (type 29).
Attribute Name: RECORD_IDENTIFIER (CSV)
Type: Integer
Size: 2
Nullable: false
Data Schema Version: 1.0
The name of the Gazetteer; this will most likely reflect the product name, for example, OS Emergency Services Gazetteer.
Attribute Name: GAZ_NAME (CSV)
Type: char
Size: 60
Nullable: false
Data Schema Version: 1.0
The geographic domain of the gazetteer, for example, England, Wales and Scotland.
Attribute Name: TER_OF_USE (CSV)
Type: char
Size: 60
Nullable: false
Data Schema Version: 1.0
A list of other datasets used to contribute to the creation of the product.
Attribute Name: LINKED_DATA (CSV)
Type: char
Size: 100
Nullable: false
Data Schema Version: 1.0
The organisation with overall responsibility for the gazetteer.
Attribute Name: GAZ_OWNER (CSV)
Type: char
Size: 15
Nullable: false
Data Schema Version: 1.0
The frequency with which the data is maintained and sent to the customer.
Attribute Name: NGAZ_FREQ (CSV)
Type: char
Size: 1
Nullable: false
Data Schema Version: 1.0
The organisation or department responsible for the compilation and maintenance of the data.
Attribute Name: CUSTODIAN_NAME (CSV)
Type: char
Size: 40
Nullable: false
Data Schema Version: 1.0
The Unique Property Reference Number (UPRN) of the custodian location.
Attribute Name: CUSTODIAN_UPRN (CSV)
Type: Integer
Size: 12
Nullable: false
Data Schema Version: 1.0
A four-digit code identifying the gazetteer custodian.
Attribute Name: LOCAL_CUSTODIAN_CODE (CSV)
Type: Integer
Size: 4
Nullable: false
Data Schema Version: 1.0
The coordinate reference system used in the gazetteer to describe the position, for example, British National Grid.
Attribute Name: CO_ORD_SYSTEM (CSV)
Type: char
Size: 40
Nullable: false
Data Schema Version: 1.0
The unit of measurement of coordinates.
Attribute Name: CO_ORD_UNIT (CSV)
Type: char
Size: 10
Nullable: false
Data Schema Version: 1.0
The date on which metadata was last updated.
Attribute Name: META_DATE (CSV)
Type: Date
Nullable: false
Data Schema Version: 1.0
The classification scheme(s) used in the gazetteer.
Attribute Name: CLASS_SCHEME (CSV)
Type: char
Size: 60
Nullable: false
Data Schema Version: 1.0
The date at which the gazetteer can be considered to be current.
Attribute Name: GAZ_DATE (CSV)
Type: Date
Nullable: false
Data Schema Version: 1.0
The language used for the descriptors within the gazetteer, for example, ‘ENG’.
Attribute Name: LANGUAGE (CSV)
Type: LanguageCode
Size: 3
Nullable: false
Data Schema Version: 1.0
The character set used in this gazetteer.
Attribute Name: CHARACTER_SET (CSV)
Type: char
Size: 30
Nullable: false
Data Schema Version: 1.0