The Other Classification Related Component provides additional classification data beyond that held by Local Authorities for an address record. This data type contains VOA Council Tax and Non-Domestic Rate classification information in the form of Special Category Codes (SCAT) and Primary Description codes where VOA information has been matched to a Local Authority address. Note that VOA classifications are only available for England and Wales.
The following sub-sections provide details about the attributes included with this related component, their data types in the different output formats, and other important metadata about them.
Primary Key providing a unique row identifier assigned to enable indexing for efficient querying.
Data Types: String (GPKG), String (CSV)
Nullable: false
Max Length: 36
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Unique Property Reference Number (UPRN) assigned by a local custodian or Ordnance Survey as a persistent identifier.
Data Types: Integer (GPKG), Integer (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Date of the feature version to which this related entity applies.
Data Types: Date (GPKG), Date (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Alphanumeric code used to classify the object using the AddressBase Classification Scheme, which is available to download from the AddressBase Product Support page of the OS website.
Data Types: String (GPKG), String (CSV)
Nullable: false
Max Length: 6
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Description of the classification code as defined in the AddressBase Classification Scheme, which is available to download from the AddressBase Product Support page of the OS website.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 230
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Name of the classification schema.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 60
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Version of the classification schema.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 60
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The date on which any attribute of the Record was last changed.
Data Types: Date (GPKG), Date (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The Postal Address Related Component provides the Royal Mail delivery point address from PAF where it has been matched to a Local Authority address in the National Land and Property Gazetteer.
The following sub-sections provide details about the attributes included with this related component, their data types in the different output formats, and other important metadata about them.
Royal Mail’s Unique Delivery Point Reference Number (UDPRN).
Data Types: Integer (GPKG), Integer (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Unique Property Reference Number (UPRN) assigned by a local custodian or Ordnance Survey as a persistent identifier.
Data Types: Integer (GPKG), Integer (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Date of the feature version to which this related entity applies.
Data Types: Date (GPKG), Date (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The organisation name is the business name given to an Address 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.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 60
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
For some organisations, department name is indicated because mail is received by subdivisions of the main organisation at distinct delivery points.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 60
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The sub-building name and/or number are identifiers for subdivisions of properties.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 30
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
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).
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 50
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
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 building name or the subbuilding name fields.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 4
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
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.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 80
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
A thoroughfare is a road, track or named access route on which there are Royal Mail delivery points, for example, HIGH STREET.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 80
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
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.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 35
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
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.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 35
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
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.
Data Types: String (GPKG), String (CSV)
Nullable: false
Max Length: 30
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The postcode unit that the Address is situated within. A postcode is an abbreviated form of address, made up of combinations of between five and seven alphanumeric characters. These alphanumeric characters are used by Royal Mail to help with the automated sorting of mail. A postcode may cover between 1 and 100 addresses. Postcodes (for example, NW6 4DP) are comprised of two components. The first component is the outward code (or ‘outcode’), which is the first two to four characters of a postcode, constituting the postcode area and the postcode district, for example, NW6. The outward code is the part of the postcode that enables mail to be sent from the accepting office to the correct area for delivery. The second component of a postcode is the inward code (or ‘incode’), which is the last three characters of the postcode, constituting the postcode sector and the postcode unit, for example, 4DP. The inward code is used to sort mail at the local delivery office. This field will contain the Royal Mail Postcode Address File (PAF) postcode where the Local Authority address has been matched to PAF. Where a match has not been made, the postcode information is sourced from Local Authority assigned data. In cases where the Local Authority do not hold a valid postcode, a spatial nearest neighbour function is used to spatially derive the postcode from the closest Address with a valid postcode.
Data Types: String (GPKG), String (CSV)
Nullable: false
Max Length: 8
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Describes the address as a small or large user as defined by Royal Mail. A large user postcode typically receives over 100 pieces of mail per day.
Data Types: String (GPKG), String (CSV)
Nullable: false
Max Length: 10
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
A two-character code uniquely identifying an individual delivery point within a postcode.
Data Types: String (GPKG), String (CSV)
Nullable: false
Max Length: 2
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The Welsh translation of dependentThoroughfare
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 80
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The Welsh translation of thoroughfare
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 80
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The Welsh translation of doubleDependentLocality
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 35
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The Welsh translation of dependentLocality
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 35
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The Welsh translation of postTown
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 30
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Text concatenation of 'PO BOX' and the Post Office Box (PO Box) number or the British Forces Post Office (BFPO) number.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 6
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The date on which the PAF record was processed into the database
Data Types: Date (GPKG), Date (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Name of the originating data provider that defined the reference or link.
Data Types: String (GPKG), String (CSV)
Nullable: false
Max Length: 30
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The date on which any attribute of the Record was last changed.
Data Types: Date (GPKG), Date (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The date on which this record was inserted into the Local Authority database.
Data Types: Date (GPKG), Date (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The date on which the record ceased to exist
Data Types: Date (GPKG), Date (CSV)
Nullable: true
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Code List Name:
Related components can be joined to feature types using the Unique Property Reference Number (UPRN) as the foreign key. These related components provide supplementary information or context to UPRNs. For example, providing cross-reference relationships between addresses and features in other OS NGD collections, such as buildings, sites, roads and boundaries, or the Royal Mail PAF view of an address where matched to a Local Authority UPRN.
The related components do not contain geometry and therefore need to be joined to the relevant feature type table using the UPRN. When data is supplied, you will receive related component data split out by feature type. For example, customers taking Pre-Build and Built Address in GeoPackage format will receive:
Feature type: Pre-Build Address
Related component: Pre-Build Alternate Address
Related component: Pre-Build Postal Address
Related component: Pre-Build Related Entity
Related component: Pre-Build Other Classification
Please note that Related Components will always be provided if you have chosen to receive any of the OS NGD Address Theme data.
The Related Entity Related Component provides cross-reference information to key identifiers from other datasets, allowing for the linking of the UPRN (Unique Property Reference Number) to its associated feature types:
OS MasterMap Topographic Area TOID
OS MasterMap Highways Road Link TOID
NGD Administrative and Statistical Units Boundaries Parish or Community GSS Code
NGD Administrative and Statistical Units Ward GSS Code
Valuation Office Agency Council Tax Assessment UARN
Valuation Office Agency Non-Domestic Rate Assessment UARN
OS NGD Buildings Theme – Building Part Polygon OSID
OS NGD Structures Theme – Compound Structure OSID
OS NGD Structures Theme – Structure OSID
OS NGD Transport Theme – Road, Track, or Path Polygon OSID
OS NGD Transport Network Collection – Road Link OSID
OS NGD Land Theme – Land Cover Polygon OSID
OS NGD Water Theme – Water Polygon OSID
Channel Islands Unique Identifier (only available for the GB Address Collection)
Channel Islands Street Identifier (only available for the GB Address Collection)
Northern Ireland Street Identifier (only available for the GB Address Collection)
Isle of Man Street Identifier (only available for the GB Address Collection)
The following sub-sections provide details about the attributes included with this related component, their data types in the different output formats, and other important metadata about them.
Primary Key providing a unique row identifier assigned to enable indexing for efficient querying.
Data Types: String (GPKG), String (CSV)
Nullable: false
Max Length: 36
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Unique Property Reference Number (UPRN) assigned by a local custodian or Ordnance Survey as a persistent identifier.
Data Types: Integer (GPKG), Integer (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Date of the feature version to which this related entity applies.
Data Types: Date (GPKG), Date (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Description of the related dataset that the cross reference refers to, for example, VOA Council Tax.
Data Types: String (GPKG), String (CSV)
Nullable: false
Code List Name: dataentitycatalogue
Max Length: 40
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Identifier of the related Data Entity or Feature Type instance that is the target of the reference or link.
Data Types: String (GPKG), String (CSV)
Nullable: false
Max Length: 36
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Type of relationship which has been formed between the source and target features, for example, Within, partOf or SameAs.
Data Types: String (GPKG), String (CSV)
Nullable: true
Code List Name: relationshiptypevalue
Max Length: 30
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Name of the originating data provider that defined the reference or link.
Data Types: String (GPKG), String (CSV)
Nullable: false
Max Length: 110
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The date on which any attribute of the Record was last changed.
Data Types: Date (GPKG), Date (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The date on which this relationship was first added into the database.
Data Types: Date (GPKG), Date (CSV)
Nullable: true
OS Select+Build Filterable: No
Data Schema Version: 2.0
The date on which the relationship ceased to exist.
Data Types: Date (GPKG), Date (CSV)
Nullable: true
OS Select+Build Filterable: No
Data Schema Version: 2.0
The Alternate Address Related Component provides alternative address labels where they exist for the ‘current’ address represented on a given feature type.
There are two principal scenarios by which an Alternate Address can be created; both of these scenarios will result in addresses being present in the Alternate Address Related Component.
Official alternate addresses captured by Local Authorities. This occurs where there is a a variation on the official address held by Local Authorities that is represented by the preferred UPRN in the Built Address Feature Type. For example, ‘10 High Street’ may have an alternate address label captured as ‘Rose Cottage’. These addresses are represented by an ‘Alternate’ classification in the Address Status attribute.
Built Address: UPRN 12345: 12 High Street, addressstatus: Approved Alternate Address: UPRN 12345: Rose Cottage, addresstatus: Alternate
An additional non-official address captured for lifecycle purposes. In the case of pre-build addresses, these alternate addresses commonly represent labels attached to the plot in earlier stages in the development cycle, that have subsequently been updated. Historic address alternate address labels, where held, will be early iterations of the address that became live and will be alternate addresses of the ‘current’ UPRN on the Pre-Build Feature Type. Built Address: UPRN 12345: Explorer House, Adanac Drive, SO15 0AS, addressstatus: Approved Alternate Address: UPRN 12345: Development Site, addressstatus: Historic Alternate Address: UPRN 12345: Plot 12, addressstatus: Historic
The following sub-sections provide details about the attributes included with this related component, their data types in the different output formats, and other important metadata about them.
Primary Key providing a unique row identifier assigned to enable indexing for efficient querying.
Data Types: String (GPKG), String (CSV)
Nullable: false
Max Length: 36
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Unique Property Reference Number (UPRN) assigned by a local custodian or Ordnance Survey as a persistent identifier.
Data Types: Integer (GPKG), Integer (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Date of the feature version to which this related entity applies.
Data Types: Date (GPKG), Date (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The Unique Street Reference Number (USRN), a unique and persistent identifier of a Street which is assigned by the Roads or Highway Authority.
Data Types: Integer (GPKG), Integer (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The lifecycle status of a given Address, for example, Alternative, Approved, Historic.
Data Types: String (GPKG), String (CSV)
Nullable: false
Code List Name: addressstatuscode
Max Length: 11
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The alternateSubName provides an alternative address label to the one provided in the subName. An alternative address label may be present for a number of reasons, e.g. retention of an old address label or an alias address label has been recorded by the Local Authority.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 110
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The alternateName provides an alternative address label to the one provided in the name. An alternative address label may be present for a number of reasons, e.g. retention of an old address label or an alias address label has been recorded by the Local Authority.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 110
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The alternateNumber provides an alternative address number to the one provided in the number attribute.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 13
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Name, number or descriptor that identifies the nearest accessable Street that an Address is located on or close to.
Data Types: String (GPKG), String (CSV)
Nullable: false
Max Length: 100
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Name of a populated place within a settlement that the Street is located within. Where a locality can be a suburb, housing estate or commercial estate.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 35
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Name of the settlement that the Street is located within. Where a Settlement can be a City, Town, Village or Hamlet.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 35
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Name of the island upon which an Address is located. Note: This attribute is currently only populated in the OS NGD Islands Address Collection.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 50
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The language in which the address label attribution has been captured for the alternative record.
Data Types: String (GPKG), String (CSV)
Nullable: false
Code List Name: languagevalue
Max Length: 3
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The postcode unit that the Address is situated within. A postcode is an abbreviated form of address, made up of combinations of between five and seven alphanumeric characters. These alphanumeric characters are used by Royal Mail to help with the automated sorting of mail. A postcode may cover between 1 and 100 addresses. Postcodes (for example, NW6 4DP) are comprised of two components. The first component is the outward code (or ‘outcode’), which is the first two to four characters of a postcode, constituting the postcode area and the postcode district, for example, NW6. The outward code is the part of the postcode that enables mail to be sent from the accepting office to the correct area for delivery. The second component of a postcode is the inward code (or ‘incode’), which is the last three characters of the postcode, constituting the postcode sector and the postcode unit, for example, 4DP. The inward code is used to sort mail at the local delivery office. This field will contain the Royal Mail Postcode Address File (PAF) postcode where the Local Authority address has been matched to PAF. Where a match has not been made, the postcode information is sourced from Local Authority assigned data. In cases where the Local Authority do not hold a valid postcode, a spatial nearest neighbour function is used to spatially derive the postcode from the closest Address with a valid postcode.
Data Types: String (GPKG), String (CSV)
Nullable: false
Max Length: 8
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
Concatenation of the following address components: organisation (Pre-Build and Built Address Feature Types only), subname and / or name and / or number, streetname, locality, townname, islandname and postcodelocator.
Data Types: String (GPKG), String (CSV)
Nullable: false
Max Length: 500
OS Select+Build Filterable: No
Data Schema Version: 2.0
Floor level represents either: The level on which the access point to the Address is present, or the floor level or levels that the Address is located on, or fully occupies.
Data Types: String (GPKG), String (CSV)
Nullable: true
Max Length: 30
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
In cases where the Floor Level attribute contains a list of floor levels (for example, where a commercial organisation occupies multiple levels within a building), the first value provided will be taken as the lowest floor level. For example, where Floor Level attribute values are given as -1, 0, 1, 2, 3, the Lowest Floor Level is -1. Mezzanine levels may be represented by a partial number, for example, 1.5. If the Floor Level attribute only contains one value, that value will also be used by the Lowest Floor Level attribute.
This attribute is derived from Floor Level attribute data. Where the floorlevel field is NULL, lowestfloorlevel values will also be NULL.
Data Types: Float (GPKG), Real (CSV)
Nullable: true
Precision: 3
Scale: 1
OS Select+Build Filterable: No
Data Schema Version: 2.0
In cases where the Floor Level attribute contains a list of floor levels (for example, where a commercial organisation occupies multiple levels within a building), the last value provided will be taken as the highest floor level. For example, where Floor Level attribute values are given as -1, 0, 1, 2, 3, the Highest Floor Level is 3. Mezzanine levels may be represented by a partial number, for example, 1.5. If the Floor Level attribute only contains one value, that value will also be used by the Highest Floor Level attribute.
This attribute is derived from Floor Level attribute data. Where the floorlevel field is NULL, highestfloorlevel values will also be NULL.
Data Types: Float (GPKG), Real (CSV)
Nullable: true
Precision: 3
Scale: 1
OS Select+Build Filterable: No
Data Schema Version: 2.0
The date on which any attribute of the Record was last changed.
Data Types: Date (GPKG), Date (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The date on which this record was inserted into the Local Authority database.
Data Types: Date (GPKG), Date (CSV)
Nullable: false
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0
The date on which the record ceased to exist
Data Types: Date (GPKG), Date (CSV)
Nullable: true
OS Select+Build Filterable: No
Data Schema Version: 1.0, 2.0