🆕Royal Mail Address

The Royal Mail Address Feature Type provides Royal Mail delivery point addresses, a point geometry and information describing the relationship they have with Local Authority addresses.

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 25 September 2025; any data temporally filtered earlier than the specified earliest date noted for the data schema version may contain data inconsistencies.

What is temporal filtering?

Temporal filtering allows you to order a one-off snapshot of data from the OS NGD from a current or past date. It is an optional step when you create a new data package in OS Select+Build (the OS NGD download service). More information about temporal filtering on OS NGD feature types is available from the Getting started with temporal filtering guide.

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.

Loading OS NGD CSV files into databases

Comma-separated values (CSV) file format is universally supported for easy ingestion into all major database products. Before loading OS NGD data contained in CSV files into a database, it is necessary to create relevant tables. Data definition language (DDL) statements for PostgreSQL, SQL Server and Oracle can be accessed in our OS NGD Resources GitHub repository.

For instructions on loading CSV files, see the Getting Started with CSV guide.

udprn

Unique Delivery Point Reference Number (UDPRN) assigned by Royal Mail as a persistent identifier.

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

  • Nullable: false

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

versiondate

Date when the version was last updated.

  • Data Types: Date (GPKG), Date (CSV)

  • Nullable: false

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

versionavailablefromdate

The date this version of the feature became the latest version.

  • Data Types: DateTime (GPKG), DateTime (CSV)

  • Nullable: false

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

versionavailabletodate

The date this version of the feature was superseded by an update or ceased to exist.

  • Data Types: DateTime (GPKG), DateTime (CSV)

  • Nullable: true

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

changetype

The type of change that generated a new version of the feature.

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

  • Nullable: false

  • Code List Name: changetypevalue

  • Max Length: 50

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

theme

The OS NGD theme to which this feature belongs.

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

  • Nullable: false

  • Code List Name: themevalue

  • Max Length: 40

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

description

A single descriptive value intended for a quick understanding of what the feature represents.

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

  • Nullable: false

  • Max Length: 50

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

organisationname

The name of the organisation operating from the address.

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

  • Nullable: true

  • Max Length: 60

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

departmentname

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

subbuildingname

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

buildingname

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

buildingnumber

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 Sub Building Name fields.

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

  • Nullable: true

  • Max Length: 4

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

dependentthoroughfare

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

thoroughfare

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

doubledependentlocality

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

dependentlocality

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

posttown

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 office 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

postcode

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.

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

  • Nullable: false

  • Max Length: 8

  • OS Select+Build Filterable: Yes

  • Data Schema Version: 1.0

postcodetype

Describes the address as a small or large user as defined by Royal Mail.

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

  • Nullable: false

  • Code List Name: postcodetypevalue

  • Max Length: 10

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

deliverypointsuffix

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

welshdependentthoroughfare

The Welsh translation of Dependent Thoroughfare.

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

  • Nullable: true

  • Max Length: 80

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

welshthoroughfare

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

welshdoubledependentlocality

The Welsh translation of Double Dependent Locality.

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

  • Nullable: true

  • Max Length: 35

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

welshdependentlocality

The Welsh translation of Dependent Locality.

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

  • Nullable: true

  • Max Length: 35

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

welshposttown

The Welsh translation of Post Town.

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

  • Nullable: true

  • Max Length: 30

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

poboxnumber

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: 13

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

updatedate

The date the Royal Mail record last changed.

  • Data Types: Date (GPKG), Date (CSV)

  • Nullable: false

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

entrydate

Date of the change file that first supplied the Royal Mail record.

  • Data Types: Date (GPKG), Date (CSV)

  • Nullable: false

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

easting

X coordinate defining the position of the object in accordance with the British National Grid (EPSG:27700) coordinate reference system.

  • Data Types: Float (GPKG), Real (CSV)

  • Nullable: false

  • Precision: 8

  • Scale: 2

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

northing

Y coordinate defining the position of the object in accordance with the British National Grid (EPSG:27700) coordinate reference system.

  • Data Types: Float (GPKG), Real (CSV)

  • Nullable: false

  • Precision: 9

  • Scale: 2

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

latitude

Value defining the latitude of the Address location in accordance with the ETRS89 (EPSG:4258) coordinate reference system.

  • Data Types: Float (GPKG), Real (CSV)

  • Nullable: false

  • Precision: 9

  • Scale: 7

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

longitude

Value defining the longitude of the Address location in accordance with the ETRS89 (EPSG:4258) coordinate reference system.

  • Data Types: Float (GPKG), Real (CSV)

  • Nullable: false

  • Precision: 9

  • Scale: 7

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

geometry

Geometry for the feature.

  • Data Types: Geometry (GPKG), WKT (CSV)

  • Nullable: false

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

  • Geometry Type: Point

positionalaccuracy

Local Authority assigned value giving a description of the accuracy of the coordinate position allocated to the Address location, for example, 'Central Internal Position' of a building.

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

  • Nullable: false

  • Code List Name: positionalaccuracyvalue

  • Code List Version: 2.0

  • Max Length: 25

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

geometryallocationmethod

Describes the method by which a geometry was allocated to the Royal Mail record. Where a Royal Mail record is matched to a Local Authority record, the geometry will be assigned from the matched record. Where a Royal Mail record cannot be directly matched, geometry will be assigned by reference to a parent record, a street, or records which share the postcode unit, sector, district or area – in the listed order of preference. Where none of the listed methods are available, the geometry will be allocated to an internal centre point for the Local Authority area or Island in which the Royal Mail address is located.

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

  • Nullable: false

  • Max Length: 25

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

unmatchedreason

Describes the reason that the Royal Mail record has not been matched to a Local Authority record.

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

  • Nullable: true

  • Max Length: 100

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

unmatchedreasondate

The date on which the Unmatched Reason value was captured.

  • Data Types: Date (GPKG), Date (CSV)

  • Nullable: true

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

uprn

The Unique Property Reference Number (UPRN) to which a Unique Delivery Point Reference Number (UDPRN) has been matched.

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

  • Nullable: true

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

matchedaddressfeaturetype

The feature type of the Unique Property Reference Number (UPRN) to which the Unique Delivery Point Reference Number (UDPRN) has been matched.

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

  • Nullable: true

  • Max Length: 25

  • OS Select+Build Filterable: Yes

  • Data Schema Version: 1.0

matchtype

A description of the relationship assigned between the Unique Delivery Point Reference Number (UDPRN) and the Unique Property Reference Number (UPRN). Where a Postcode Address File (PAF) record relates directly to a Local Authority record, this is set to ‘Direct.’ If a ‘Direct’ match cannot be found, a PAF record may be matched to a Parent, Neighbour or Street record in Local Authority data, in order to estimate a position for the PAF record.

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

  • Nullable: false

  • Code List Name: rmtolamatchtypevalue

  • Max Length: 20

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

matchdate

The date on which the match was made between the Unique Delivery Point Reference Number (UDPRN) and the Unique Property Reference Number (UPRN).

  • Data Types: Date (GPKG), Date (CSV)

  • Nullable: true

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

matchmethod

The method by which the match was made.

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

  • Nullable: true

  • Code List Name: matchmethodvalue

  • Max Length: 10

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

matchingorganisation

Describes the organisation which made the match between the Royal Mail record and the Local Authority record.

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

  • Nullable: true

  • Max Length: 25

  • OS Select+Build Filterable: No

  • Data Schema Version: 1.0

Last updated

Was this helpful?