These pages describe the two data types available for the OS Emergency Services Gazetteer (OS ESG):

• LPI (Type 24 Record)

• Classification (Type 32 Record)

The attributes associated with each data type are listed on the following pages. The following information can be found about each attribute:

Name and Definition

The name of the attribute and what it is describing.

Data Types

The values the attribute can take. For example, a numeric value or a string. This is provided for both data formats – GeoPackage and CSV.

Precision

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

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.

Code List Name

The name of the code list used in association with the attribute (if applicable) and a hyperlink to the page displaying that code list.

Size / Max Length

Values are given here to indicate the maximum length that you will find in the attribute, to aid in developing applications.

Nullable

A True or False value to denote whether the attribute always has to be populated with a value (False) or can be NULL (True).

Data Schema Version

The schema version the data above applies to.

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.

Temporal filtering

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.

Feature type attributes

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.

fid 

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

Record ID

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

Change type

The type of record change.

• Attribute Name: change_type (GKPG), CHANGE_TYPE (CSV)

• Code List Name: ChangeTypeCode  

• Max Length: 1

• Nullable:  false

• Data Schema Version: 1.0

Processing order

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

UPRN

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

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)

• Code List Name:  LogicalStatusCode

• Max Length: 1

• Nullable:  false

• Data Schema Version: 1.0

BLPU state

A code identifying the current state of the BLPU. 

• Attribute Name: blpu_state_date (GPKG), BLPU_STATE_DATE (CSV)

• Code List Name: BLPUStateCode 

• Max Length: 1

• Nullable:  true

• Data Schema Version: 1.0

BLPU state date

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

Parent UPRN

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

X coordinates

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

Y coordinates

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

Latitude location

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

Longitude location

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

RPC

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)

• Code List Name: RPCCode

• Max Length: 1

• Nullable:  false

• Data Schema Version: 1.0

Local custodian ID

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

Start date

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

End date

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

Last update date

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

Entry date

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

Multi-Occupation count

 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

Addressbase postal

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)

• Code List Name: AddressbasePostalCode

• Max Length: 1

• Nullable:  false

• Data Schema Version: 1.0

The Classification (Type 32 Record) Data Type defines a structured entry that provides the code for the type of feature.

Temporal filtering

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.

Data type attributes

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.

fid

 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

Record ID

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

Change type

The type of record change.

• Attribute Name: change_type (GKPG), CHANGE_TYPE (CSV)

• Size: 1

• Nullable:  false

• Data Schema Version: 1.0

Processing order

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

UPRN

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

Classification key

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

Classification code

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

Classification scheme

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

Scheme version

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

Start date

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

End date

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

Last update date

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

Entry date

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

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).

Temporal filtering

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.

Data type attributes

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.

fid

 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

Record ID

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

Change type

The type of record change.

• Attribute Name: change_type (GKPG), CHANGE_TYPE (CSV)

• Size: 1

• Nullable:  false

• Data Schema Version: 1.0

Processing order

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

UPRN

• Attribute Name: uprn (GKPG), UPRN (CSV)

• Data Types:  Integer (GKPG), Integer (CSV)

• Size: 12

• Nullable:  false

• Data Schema Version: 1.0

LPI key

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

Language

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

Logical status

The logical status of this record. 

• Attribute Name: logical_status (GKPG), LOGICAL_STATUS (CSV)

• Size: 1

• Nullable:  false

• Data Schema Version: 1.0

Start date

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

End date

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

Last update date

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

Entry date

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

SAO start number

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

SAO start number suffix

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

SAO end number

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

SAO end suffix

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

SAO text

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.

• Attribute Name: sao_text  (GKPG), SAO_TEXT (CSV)

• Data Types: String (GKPG) , String (CSV)

• Max Length: 400

• Nullable:  true

• Data Schema Version: 1.0

PAO start number

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

PAO start number suffix

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

PAO end number

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

PAO end suffix

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

PAO text

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.

• Attribute Name: pao_text (GKPG), PAO_TEXT (CSV)

• Data Types: String (GKPG), String (CSV)

• Max Length: 90

• Nullable:  true

• Data Schema Version: 1.0

USRN

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

USRN match indicator

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

Area name

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.

• Attribute Name: area_name (GKPG), AREA_NAME (CSV)

• Data Types:  String (GKPG), String (CSV)

• Max Length: 100

• Nullable:  true

• Data Schema Version: 1.0

Level

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

Official flag

The status of the feature. 

• Attribute Name: official_flag (GKPG), OFFICIAL_FLAG (CSV)

• Size: 1

• Nullable:  true

• Data Schema Version: 1.0

Product overview

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

Index

This technical specification includes the following sections:

• Feature type

• Structured data types

• Code lists

• Dataset metadata

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.

Index

The pages in this section display the code lists in alphabetical order, with one code list provided per page:

These pages describe the single feature type () 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:

Name and Definition

The name of the attribute and what it is describing.

Data Types

The values the attribute can take. For example, a numeric value or a string. This is provided for both data formats – GeoPackage and CSV.

Precision

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

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.

Code List Name

The name of the code list used in association with the attribute (if applicable) and a hyperlink to the page displaying that code list.

Max Length

Values are given here to indicate the maximum length that you will find in the attribute, to aid in developing applications.

Nullable

A True or False value to denote whether the attribute always has to be populated with a value (False) or can be NULL (True).

Data Schema Version

The schema version the data above applies to.

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.

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.

This code list identifies the language of the feature displayed. This code list is used in association with the LANGUAGE (CSV) / language (GKPG) attribute found in LPI tables, and also the Metadata table for CSV supply.

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 BLPU and LPI tables.

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 LPI table.

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.

This code list describes the classification code for each feature. The classification codes will be expanded as necessary for future releases.

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 BLPU table.

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.

Dataset metadata attributes

The following sub-sections provide details about the attributes included with this data type.

Record ID

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

Next volume name

The sequential number of the next volume in the transfer set.

• Attribute Name: NEXT_VOLUME_NAME (CSV)

• Type:  Integer

• Size: 3

• Nullable:  false

• Data Schema Version: 1.0

Record count

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

Entry date

The date of data entry. 

• Attribute Name: ENTRY_DATE (CSV)

• Type: Date

• Nullable:  false

• Data Schema Version: 1.0

Time stamp

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

Dataset metadata attributes

The following sub-sections provide details about the attributes included with this data type.

Record ID

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

Gazetteer name

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

Gazetteer territory

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

Datasets

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

Gazetteer owner

The organisation with overall responsibility for the gazetteer. 

• Attribute Name: GAZ_OWNER  (CSV)

• Type: char

• Size: 15

• Nullable:  false

• Data Schema Version: 1.0

Frequency

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

Custodian name

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

Custodian UPRN

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

Custodian code

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

Coordinate reference system

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

Coordinate unit

The unit of measurement of coordinates. 

• Attribute Name: CO_ORD_UNIT (CSV) 

• Type: char

• Size: 10

• Nullable:  false

• Data Schema Version: 1.0

Update date

The date on which metadata was last updated.

• Attribute Name: META_DATE  (CSV)

• Type: Date

• Nullable:  false

• Data Schema Version: 1.0

Classification scheme

The classification scheme(s) used in the gazetteer. 

• Attribute Name: CLASS_SCHEME (CSV)

• Type: char

• Size: 60

• Nullable:  false

• Data Schema Version: 1.0

Gazetteer current date

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

Language

The language used for the descriptors within the gazetteer, for example, ‘ENG’. 

• Attribute Name: LANGUAGE  (CSV)

• Size: 3

• Nullable:  false

• Data Schema Version: 1.0

Character set

The character set used in this gazetteer. 

• Attribute Name: CHARACTER_SET (CSV) 

• Type: char

• Size: 30

• Nullable:  false

• Data Schema Version: 1.0

Dataset metadata attributes

The following sub-sections provide details about the attributes included with this data type.

Record ID

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

Provider organisation

The name of the data provider organisation. 

• Attribute Name: CUSTODIAN_NAME (CSV)

• Type:  char

• Size: 40

• Nullable:  false

• Data Schema Version: 1.0

Provider ID

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

Processing date

The date on which the data supply was generated. 

• Attribute Name: PROCESS_DATE (CSV)

• Type:  Date

• Nullable:  false

• Data Schema Version: 1.0

Volume number

The sequential number of the volume in the transfer set. 

• Attribute Name: VOLUME_NUMBER (CSV)

• Type:  Integer

• Size: 3

• Nullable:  false

• Data Schema Version: 1.0

Entry date

The date of data entry for this volume. 

• Attribute Name: ENTRY_DATE (CSV)

• Type: Date

• Nullable:  false

• Data Schema Version: 1.0

Time stamp

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

Version number

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

File type

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

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:

Name and Definition

The name of the attribute and what it is describing.

Attribute Type

The nature of the attribute (for example, a numeric value or a code list value).

Size

The maximum length of the values in the attribute.

Nullable

A True or False value to denote whether the attribute always has to be populated with a value (False) or can be NULL (True).

Data Schema Version

The schema version the data above applies to.

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 .

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 .