A descriptive identifier providing additional information about the street feature. This record holds information about locality, town name and street name.

Data type attributes

The following page provides 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 GPKG format.

• Attribute Name: Not provided (GML), Not provided (CSV), fid (GKPG)

• Data Type: Integer

• Multiplicity: [1]

Record identifier

Identifies this record as a Street Descriptor record (type 15).

• Attribute Name: Not provided (GML), RECORD_IDENTIFIER (CSV), Not provided (GKPG)

• Data Type: Integer

• Size: 2

• Multiplicity: [1]

Change type

Type of record change – please see COU supply for more information.

• Attribute Name: Not provided (GML), CHANGE_TYPE (CSV), change_type (GKPG)

• Code List Name: ChangeTypeCode

• Size: 1

• Multiplicity: [1]

Pro order

The order in which the records were processed in to create the data supply.

• Attribute Name: Not provided (GML), PRO_ORDER (CSV), Not provided (GKPG)

• Data Type: Integer

• Size: 16

• Multiplicity: [1]

USRN

Unique Street Reference Number (USRN): used as foreign key to reference the corresponding street record.

• Attribute Name: usrn (GML), USRN (CSV), usrn (GKPG)

• Data Type: Integer

• Size: 8

• Multiplicity: [1]

Street description

Name, description or Street number for this record.

• Attribute Name: streetDescription (GML), STREET_DESCRIPTION (CSV), street_description (GKPG)

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 100

• Multiplicity: [1]

Locality

A locality defines an area or geographical identifier within a town, village or hamlet.

Locality represents the lower-level geographical area. The locality field should be used in conjunction with the town name and street description fields to uniquely identify geographic area where there may be more than one within an administrative area.

• Attribute Name: locality (GML), LOCALITY (CSV), locality (GKPG)

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 35

• Multiplicity: [0..1]

Town name

The name of the town the address is within.

• Attribute Name: townName (GML), TOWN_NAME (CSV), town_name (GKPG)

• Condition: Town name must be present if the Street Record Type is 1 or 2 and may be entered for type 3, 4 and 9 Streets.

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 30

• Multiplicity: [0..1]

Administrative area

Local Highway Authority name for the area this record exists within.

• Attribute Name: administrativeArea (GML), ADMINSTRATIVE_AREA (CSV), administrative_area (GKPG)

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 30

• Multiplicity: [1]

Language

A code identifying the language in use for the record.

• Attribute Name: Not provided (GML), LANGUAGE (CSV), language (GKPG)

• Code List Name: LanguageCode

• Size: 3

• Multiplicity: [1]

Start date

Date this record was first created in the database.

• Attribute Name: Provided in EntityWithLifeCycle (GML), START_DATE (CSV), start_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

End date

The date on which this record ceased to exist in the product database.

• Attribute Name: Provided in EntityWithLifeCycle (GML), END_DATE (CSV), end_date (GKPG)

• Data Type: Date

• Multiplicity: [0..1]

Last update date

The date on which any of the attributes on this record were last changed in the product database.

• Attribute Name: Provided in EntityWithLifeCycle (GML), LAST_UPDATE_DATE (CSV), last_update_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

Entry date

The date on which the record was entered into the Local Authority database.

• Attribute Name: Provided in EntityWithLifeCycle (GML), ENTRY_DATE (CSV), entry_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

This section describes the structured data types which make up the AddressBase Premium product, giving the following information about each attribute:

AddressBase Premium Islands structured data types

• Street Descriptor – (Type 15 Record)

• Application Cross Reference – (Type 23 Record)

• LPI – (Type 24 Record)

• Delivery Point Address – (Type 28 Record)

• Successor Cross Reference – (Type 30 Record)

• Organisation – (Type 31 Record)

• Classification – (Type 32 Record)

• Entity with lifecycle

A structured entry that provides the code for the type of BLPU and the classification scheme from which the code is taken. This record holds the classification of a property and allows one to search upon the use of a feature.

Data type attributes

The following page provides 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 GPKG format.

• Attribute Name: Not provided (GML), Not provided (CSV), fid (GKPG)

• Data Type: Integer

• Multiplicity: [1]

Record identifier

Identifies this record as a Classification Record (type 32).

• Attribute Name: Not provided (GML), RECORD_IDENTIFIER (CSV), Not provided (GKPG)

• Data Type: Integer

• Size: 2

• Multiplicity: [1]

Change type

Type of record change – please see COU supply for more information.

• Attribute Name: Not provided (GML), CHANGE_TYPE (CSV), change_type (GKPG)

• Code List Name: ChangeTypeCode

• Size: 1

• Multiplicity: [1]

Pro order

The order in which the records were processed in to create the data supply.

• Attribute Name: Not provided (GML), PRO_ORDER (CSV), Not provided (GKPG)

• Data Type: Integer

• Size: 16

• Multiplicity: [1]

UPRN

Unique Property Reference Number (UPRN) - foreign key used to reference the LPI to the corresponding BLPU.

• Attribute Name: Not provided (GML), UPRN (CSV), uprn (GKPG)

• Data Type: Integer

• Size: 12

• Multiplicity: [1]

Class key

Unique key for the classification record and primary key for this table.

• Attribute Name: classKey (GML), CLASS_KEY (CSV), class_key (GKPG)

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 14

• Multiplicity: [1]

Classification codes

Classification of the address record, depicting its primary use.

• Attribute Name: classificationCode (GML), CLASSIFICATION_CODE (CSV), classification_code (GKPG)

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 6

• Multiplicity: [1]

Class scheme

The name of the classification scheme used for this record.

• Attribute Name: classScheme (GML), CLASS_SCHEME (CSV), class_scheme (GKPG)

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 60

• Multiplicity: [1]

Scheme version

The name of the classification scheme used for this record.

• Attribute Name: schemeVersion (GML), SCHEME_VERSION (CSV), scheme_version (GKPG)

• Data Type: CharacterString (GML), float (CSV), double (GKPG)

• Size: (precision, scale) – 2(1)

• Multiplicity: [1]

Start date

Date on which this classification record was first loaded into the database.

• Attribute Name: Provided in EntityWithLifeCycle (GML), START_DATE (CSV), start_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

End date

Date this classification record ceased to exist in the product database.

• Attribute Name: Provided in EntityWithLifeCycle (GML), END_DATE (CSV), end_date (GKPG)

• Data Type: Date

• Multiplicity: [0..1]

Last update date

The date on which any attribute on this record was last changed.

• Attribute Name: Provided in EntityWithLifeCycle (GML), LAST_UPDATE_DATE (CSV), last_update_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

Entry date

The date on which the address record associated with this classification record was inserted into the Local Authority database.

• Attribute Name: Provided in EntityWithLifeCycle (GML), ENTRY_DATE (CSV), entry_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

This record holds references to a UPRN and to any replacement UPRN, for example, if a building is split into two sub-buildings; the sub-building UPRNs will be referenced in the successor record.

Data type attributes

The following page provides 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 GPKG format.

• Attribute Name: Not provided (GML), Not provided (CSV), fid (GKPG)

• Data Type: Integer

• Multiplicity: [1]

Record identifier

Identifies this record as a Successor Cross Reference (type 30).

• Attribute Name: Not provided (GML), RECORD_IDENTIFIER (CSV), Not provided (GKPG)

• Data Type: Integer

• Size: 2

• Multiplicity: [1]

Change type

Type of record change – please see COU supply for more information.

• Attribute Name: Not provided (GML), CHANGE_TYPE (CSV), change_type (GKPG)

• Code List Name: ChangeTypeCode

• Size: 1

• Multiplicity: [1]

Pro order

The order in which the records were processed in to create the data supply.

• Attribute Name: Not provided (GML), PRO_ORDER (CSV), Not provided (GKPG)

• Data Type: Integer

• Size: 16

• Multiplicity: [1]

UPRN

Unique Property Reference Number.

• Attribute Name: Not provided (GML), UPRN (CSV), uprn (GKPG)

• Data Type: Integer

• Size: 12

• Multiplicity: [1]

Succ key

Key value to uniquely identify the successor cross reference record and the primary key for this table.

• Attribute Name: succKey (GML), SUCC_KEY (CSV), succ_key (GKPG)

• Data Type: CharacterString (GML), char (CSV ), String (GKPG)

• Size: 14

• Multiplicity: [1]

Start date

Date on which the record was first loaded into the database.

• Attribute Name: Provided in EntityWithLifeCycle (GML), START_DATE (CSV), start_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

End date

The date on which the record ceased to exist in the product database.

• Attribute Name: Provided in EntityWithLifeCycle (GML), END_DATE (CSV), end_date (GKPG)

• Data Type: Date

• Multiplicity: [0..1]

Last update date

The date on which any attribute on this record was last changed.

• Attribute Name: Provided in EntityWithLifeCycle (GML), LAST_UPDATE_DATE (CSV), last_update_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

Entry date

The date on which the UPRN attached to this record was entered into the Local Authority database.

• Attribute Name: Provided in EntityWithLifeCycle (GML), ENTRY_DATE (CSV), entry_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

Successor

UPRN of successor BLPU.

• Attribute Name: successor (GML), SUCCESSOR (CSV), successor (GKPG)

• Data Type: Integer

• Size: 12

• Multiplicity: [1]

A structured entry identifying the name of the current non-domestic occupier of the BLPU. This record holds information about the organisation of the record.

Data type attributes

The following page provides 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 GPKG format.

• Attribute Name: Not provided (GML), Not provided (CSV), fid (GKPG)

• Data Type: Integer

• Multiplicity: [1]

Record identifier

Identifies this as an Organisation Record (type 31).

• Attribute Name: Not provided (GML), RECORD_IDENTIFIER (CSV), Not provided (GKPG)

• Data Type: Integer

• Size: 2

• Multiplicity: [1]

Change type

Type of record change – please see COU supply for more information.

• Attribute Name: Not provided (GML), CHANGE_TYPE (CSV), change_type (GKPG)

• Code List Name: ChangeTypeCode

• Size: 1

• Multiplicity: [1]

Pro order

The order in which the records were processed in to create the data supply.

• Attribute Name: Not provided (GML), PRO_ORDER (CSV), Not provided (GKPG)

• Data Type: Integer

• Size: 16

• Multiplicity: [1]

UPRN

Unique Property Reference Number (UPRN) - foreign key used to reference the LPI to the corresponding BLPU.

• Attribute Name: Not provided (GML), UPRN (CSV), uprn (GKPG)

• Data Type: Integer

• Size: 12

• Multiplicity: [1]

Org key

Unique key for the organisation record and primary key for this table.

• Attribute Name: orgKey (GML), ORG_KEY (CSV), org_key (GKPG)

• Data Type: CharacterString (GML), CSV – char (CSV),

  String (GKPG)

• Size: 14

• Multiplicity: [1]

Organisation

Name of the organisation currently occupying the address record as provided by the local authority custodian.

• Attribute Name: organisation (GML), ORGANISATION (CSV), organisation (GKPG)

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 100

• Multiplicity: [1]

Legal name

Registered legal name of the organisation.

• Attribute Name: legalName (GML), LEGAL_NAME (CSV), legal_name (GKPG)

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 60

• Multiplicity: [0..1]

Start date

Date on which the record was first loaded into the database.

• Attribute Name: Provided in EntityWithLifeCycle (GML), START_DATE (CSV), start_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

End date

The date on which the record ceased to exist.

• Attribute Name: Provided in EntityWithLifeCycle (GML), END_DATE (CSV), end_date (GKPG)

• Data Type: Date

• Multiplicity: [0..1]

Last update date

The date on which any attribute on this record was last changed.

• Attribute Name: Provided in EntityWithLifeCycle (GML), LAST_UPDATE_DATE (CSV), last_update_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

Entry date

The date on which the UPRN attached to this record was entered into the Local Authority database.

• Attribute Name: Provided in EntityWithLifeCycle (GML), ENTRY_DATE (CSV), entry_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

This feature holds the lifecycle information about the data type record.

Data type attributes

The following page provides details about the attributes included with this data type, their types in the different output formats, and other important metadata about them.

Start date

Date on which the record was first loaded into the database.

• Attribute Name: startDate (GML), Not provided (CSV), Not provided (GKPG)

• Data Type: Date

• Multiplicity: [1]

End date

The date on which the record ceased to exist.

• Attribute Name: endDate (GML), Not provided (CSV), Not provided (GKPG)

• Data Type: Date

• Multiplicity: [0..1]

Last update date

The date on which any attribute on this record was last changed.

• Attribute Name: lastUpdateDate (GML), Not provided (CSV), Not provided (GKPG)

• Data Type: Date

• Multiplicity: [0..1]

Entry date

The date on which the record was entered into the Local Authority database.

• Attribute Name: entryDate (GML), Not provided (CSV), Not provided (GKPG)

• Data Type: Date

• Multiplicity: [1]

Application cross reference links to third-party identifiers.

AddressBase Premium application cross references contain a lookup between the AddressBase Premium UPRN and the unique identifiers of other relevant datasets.

Data type attributes

The following page provides 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 GPKG format.

• Attribute Name: Not provided (GML), Not provided (CSV), fid (GKPG)

• Data Type: Integer

• Multiplicity: [1]

Record identifier

Identifies this record as an Application Cross Reference Record (type 23).

• Attribute Name: Not provided (GML), RECORD_IDENTIFIER (CSV), Not provided (GKPG)

• Data Type: Integer

• Size: 2

• Multiplicity: [1]

Change type

Type of record change – please see COU supply for more information.

• Attribute Name: Not provided (GML), CHANGE_TYPE (CSV), change_type (GKPG)

• Code List Name: ChangeTypeCode

• Size: 1

• Multiplicity: [1]

Pro order

The order in which the records were processed in to create the data supply.

• Attribute Name: Not provided (GML), PRO_ORDER (CSV), Not provided (GKPG)

• Data Type: Integer

• Size: 16

• Multiplicity: [1]

UPRN

Unique Property Reference Number (UPRN) - foreign key used to reference the application cross reference record to the corresponding BLPU.

• Attribute Name: Not provided (GML), UPRN (CSV), uprn (GKPG)

• Data Type: Integer

• Size: 12

• Multiplicity: [1]

Xref key

Unique key for the application cross reference record and primary key for this table.

• Attribute Name: xrefKey (GML), XREF_KEY (CSV), xref_key (GKPG)

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 14

• Multiplicity: [1]

Cross reference

Primary key of corresponding record in an external dataset.

• Attribute Name: crossReference (GML), CROSS_REFERENCE (CSV), cross_reference (GKPG)

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 50

• Multiplicity: [1]

Version

Certain data sources may reference objects with lifecycles. This field enables users to reference specific versions of an object, for example, OS MasterMap Topographic Layer TOID and Version.

• Attribute Name: version (GML), VERSION (CSV), version (GKPG)

• Data Type: Integer

• Size: 3

• Multiplicity: [0..1]

Source

External dataset identity.

• Attribute Name: source (GML), SOURCE (CSV), source (GKPG)

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 6

• Multiplicity: [1]

Start date

Date the feature was matched to the cross reference dataset for the first time.

• Attribute Name: Provided in EntityWithLifeCycle (GML), START_DATE (CSV), start_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

End date

The date on which the external cross reference was no longer valid.

• Attribute Name: Provided in EntityWithLifeCycle (GML), END_DATE (CSV), end_date (GKPG)

• Data Type: Date

• Multiplicity: [0..1]

Last update date

The date on which any attribute on this record was last changed.

• Attribute Name: Provided in EntityWithLifeCycle (GML), LAST_UPDATE_DATE (CSV), last_update_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

Entry date

The date on which the Local Authority record matched to the cross reference was inserted into the Local Authority database.

• Attribute Name: Provided in EntityWithLifeCycle (GML), ENTRY_DATE (CSV), entry_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

Values for the SOURCE (source) column

A Delivery Point Address is defined as a property that receives deliveries from Royal Mail. The structure of this address is taken from Royal Mail Postcode Address File (PAF) and other supplementary data files.

Data type attributes

The following page provides 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 GPKG format.

• Attribute Name: Not provided (GML), Not provided (CSV), fid (GKPG)

• Data Type: Integer

• Multiplicity: [1]

Record identifier

Identifies the record as a Royal Mail Delivery Point Address Record (type 28).

• Attribute Name: Not provided (GML), RECORD_IDENTIFIER (CSV), Not provided (GKPG)

• Data Type: Integer

• Size: 2

• Multiplicity: [1]

Change type

• Attribute Name: Not provided (GML), CHANGE_TYPE (CSV), change_type (GKPG)

• Size: 1

• Multiplicity: [1]

Pro order

The order in which the records were processed in to create the data supply.

• Attribute Name: Not provided (GML), PRO_ORDER (CSV), Not provided (GKPG)

• Data Type: Integer

• Size: 16

• Multiplicity: [1]

UPRN

Unique Property Reference Number (UPRN) - foreign key used to reference the DPA record to the corresponding BLPU.

• Attribute Name: Not provided (GML), UPRN (CSV), uprn (GKPG)

• Data Type: Integer

• Size: 12

• Multiplicity: [1]

UDPRN

Royal Mail’s Unique Delivery Point Reference Number (UDPRN) and the Primary key for this table.

• Attribute Name: udprn (GML), UDPRN (CSV), udprn (GKPG)

• Data Type: Integer

• Size: 8

• Multiplicity: [1]

Organisation name

The organisation name is the business name given to a delivery point within a building or small group of buildings. For example: ABC COMMUNICATIONS.

This field could also include entries for churches, public houses and libraries.

• Attribute Name: organisationName (GML), ORGANISATION_NAME (CSV), organisation_name (GKPG)

• Condition: Organisation Name must be present if Building Name or Building Number or PO Box Number are all not present. Organisation Name must be present if Department Name is present.

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 60

• Multiplicity: [0..1]

• Source: Royal Mail

Department name

For some organisations, department name is indicated because mail is received by subdivisions of the main organisation at distinct delivery points.

For example, Organisation Name: ABC COMMUNICATIONS RM Department Name: MARKETING DEPARTMENT

• Attribute Name: departmentName (GML), DEPARTMENT_NAME (CSV), department_name (GKPG)

• Condition: If a Department Name is present an Organisation Name must also be present.

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 60

• Multiplicity: [0..1]

• Source: Royal Mail

Sub-building name

The sub-building name and/or number are identifiers for subdivisions of properties. For example:

Sub-building Name: FLAT 3 Building Name: POPLAR COURT Thoroughfare: LONDON ROAD

• Attribute Name: subBuildingName (GML), SUB_BUILDING_NAME (CSV), sub_building_name (GKPG)

• Condition: If a Sub Building Name is present a Building Name or Building Number must also be present.

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 30

• Multiplicity: [0..1]

• Source: Royal Mail

Building name

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

• Attribute Name: buildingName (GML), BUILDING_NAME (CSV), building_name (GKPG)

• Condition: Building Name must be present if Organisation Name or Building Number or PO Box Number are all not present.

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 50

• Multiplicity: [0..1]

• Source: Royal Mail

Building number

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.

• Attribute Name: buildingNumber (GML), BUILDING_NUMBER (CSV), building_number (GKPG)

• Condition: Building Number must be present if Organisation Name or Building Name or PO Box Number are all not present.

• Data Type: Integer

• Size: 4

• Multiplicity: [0..1]

• Source: Royal Mail

Dependent thoroughfare

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.

• Attribute Name: dependentThoroughfare (GML), DEPENDENT_THOROUGHFARE (CSV), dependent_thoroughfare (GKPG)

• Condition: If a Dependent Thoroughfare is present a Thoroughfare value must also be present.

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 80

• Multiplicity: [0..1]

• Source: Royal Mail

Thoroughfare

A thoroughfare is fundamentally a road, track or named access route on which there are Royal Mail delivery points, for example, HIGH STREET.

This is the Royal Mail equivalent of the Street Description attributes.

• Attribute Name: thoroughfare (GML), THOROUGHFARE (CSV), thoroughfare (GKPG)

• Condition: A Thoroughfare must be present if a Dependent Thoroughfare is present.

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 80

• Multiplicity: [0..1]

• Source: Royal Mail

Double-dependent locality

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.

• Attribute Name: doubleDependentLocality (GML), DOUBLE_DEPENDENT_LOC ALITY (CSV), double_dependent_locality (GKPG)

• Condition: If a Double Dependent Locality is present a Dependent Locality must also be present.

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 35

• Multiplicity: [0..1]

• Source: Royal Mail

Dependent locality

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.

• Attribute Name: dependentLocality (GML), DEPENDENT_LOC ALITY (CSV), dependent_locality (GKPG)

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 35

• Multiplicity: [0..1]

• Source: Royal Mail

Post town

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.

• Attribute Name: postTown (GML), POST_TOWN (CSV), post_town (GKPG)

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 30

• Multiplicity: [1]

• Source: Royal Mail

Postcode

A postcode is an abbreviated form of address made up of combinations of between five and seven alphanumeric characters. These are used by Royal Mail to help with the automated sorting of mail. A postcode may cover between 1 and 100 addresses.

There are two main components of a postcode, for example, NW6 4DP:

• The outward code (or ‘outcode’). The first two–four characters of the postcode constituting the postcode area and the postcode district, for example, NW6. It is the part of the postcode that enables mail to be sent from the accepting office to the correct area for delivery.

• The inward code (or ‘incode’). The last three characters of the postcode constituting the postcode sector and the postcode unit, example, 4DP. It is used to sort mail at the local delivery office.

• Attribute Name: postcode (GML), POSTCODE (CSV), postcode (GKPG)

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 8

• Multiplicity: [1]

• Source: Royal Mail

Post town

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

• Attribute Name: postcodeType (GML), POSTCODE_TYPE (CSV), postcode_type (GKPG)

• Condition: If PO Box number is present, Postcode Type must be ‘L’.

• Size: 1

• Multiplicity: [1]

• Source: Royal Mail

Delivery point suffix

A two-character code uniquely identifying an individual delivery point within a postcode.

• Attribute Name: deliveryPointSuffix (GML), DELIVERY_POINT_SUFFIX (CSV), delivery_point_suffix (GKPG)

• Condition: If PO Box number is present, Postcode Type must be ‘L’.

• Code List Name: CharacterString (GML), char (CSV), String (GKPG)

• Size: 2

• Multiplicity: [1]

• Source: Royal Mail

Welsh dependent thoroughfare

The Welsh translation of DEPENDENT_THOROUGHFARE.

• Attribute Name: welshDependentThoroughfare (GML), WELSH_DEPENDENT_THOROUGHFARE (CSV), welsh_dependent_thoroughfare (GKPG)

• Condition: If a Welsh Dependent Thoroughfare is present, a Welsh Thoroughfare must also be present.

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 80

• Multiplicity: [0..1]

• Source: Royal Mail

Welsh thoroughfare

The Welsh translation of THOROUGHFARE.

• Attribute Name: welshThoroughfare (GML), WELSH_THOROUGHFARE (CSV), welsh_thoroughfare (GKPG)

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 80

• Multiplicity: [0..1]

• Source: Royal Mail

Welsh double-dependent locality

The Welsh translation of Double Dependent Locality.

• Attribute Name: welshDoubleDependentLocality (GML), WELSH_DOUBLE_DEPENDE NT_LOCALITY (CSV), welsh_double_dependent_locality (GKPG)

• Condition: If a Welsh Double Dependent Locality is present, a Welsh Dependent Locality must also be present.

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 36

• Multiplicity: [0..1]

• Source: Royal Mail

Welsh dependent locality

The Welsh translation of DEPENDENT_LOCALITY.

• Attribute Name: welshDependentLocality (GML), WELSH_DEPENDENT_LOCALITY (CSV), welsh_dependent_locality (GKPG)

• Condition: If a Welsh Double Dependent Locality is present, a Welsh Dependent Locality must also be present.

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 35

• Multiplicity: [0..1]

• Source: Royal Mail

Welsh post town

The Welsh translation of post town value.

• Attribute Name: welshPostTown (GML), WELSH_POST_TOWN (CSV), welsh_post_town (GKPG)

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 30

• Multiplicity: [0..1]

• Source: Royal Mail

Po box number

Post Office Box (PO Box) number.

• Attribute Name: poBoxNumber (GML), PO_BOX_NUMBER (CSV), po_box_number (GKPG)

• Condition: Organisation Name or PO Box Number must be present if Building Name or Building Number are all not present.

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 6

• Multiplicity: [0..1]

• Source: Royal Mail

Process date

The date on which the PAF record was processed into the database.

• Attribute Name: processDate (GML), PROCESS_DATE (CSV), process_date (GKPG)

• Data Type: Date

• Multiplicity: [1]

Start date

The date on which the address record was matched to the Delivery Point Address.

• Data Type: Date

• Multiplicity: [1]

End date

The date on which the PAF record no longer existed in the database.

• Data Type: Date

• Multiplicity: [0..1]

Last update date

The date on which any attribute on this record was last changed.

• Data Type: Date

• Multiplicity: [1]

Entry date

The date on which the PAF record was first loaded by Geoplace.

• Data Type: Date

• Multiplicity: [1]

An LPI is a structured entry that identifies a BLPU. It is a simple identifier or description for the object. The richness of the data structure within AddressBase Premium provides the facility to describe a by more than one LPI.

Data type attributes

The following page provides 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 GPKG format.

• Attribute Name: Not provided (GML), Not provided (CSV), fid (GKPG)

• Data Type: Integer

• Multiplicity: [1]

Record identifier

Identifies this Record as an LPI Record (type 24).

• Attribute Name: Not provided (GML), RECORD_IDENTIFIER (CSV), Not provided (GKPG)

• Data Type: Integer

• Size: 2

• Multiplicity: [1]

Change type

• Attribute Name: Not provided (GML), CHANGE_TYPE (CSV), change_type (GKPG)

• Size: 1

• Multiplicity: [1]

Pro order

The order in which the records were processed in to create the data supply.

• Attribute Name: Not provided (GML), PRO_ORDER (CSV), Not provided (GKPG)

• Data Type: Integer

• Size: 16

• Multiplicity: [1]

UPRN

Unique Property Reference Number (UPRN) - foreign key used to reference the LPI to the corresponding BLPU.

• Attribute Name: Not provided (GML), UPRN (CSV), uprn (GKPG)

• Data Type: Integer

• Size: 12

• Multiplicity: [1]

LPI key

Unique key for the LPI and primary key for this table.

• Attribute Name: lpiKey (GML), LPI_KEY (CSV), lpi_key (GKPG)

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 14

• Multiplicity: [1]

Language

A code that identifies the language used for the LPI record.

• Attribute Name: Not provided (GML), LANGUAGE (CSV), language (GKPG)

• Size: 3

• Multiplicity: [1]

Logical status

Logical status of this record.

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

• Size: 1

• Multiplicity: [1]

Start date

Date that this LPI record was first loaded into the database.

• Data Type: Date

• Multiplicity: [1]

End date

The date this record ceased to exist in the database.

• Data Type: Date

• Multiplicity: [0..1]

Last update date

The last date an attribute on this record was last changed in the product database.

• Data Type: Date

• Multiplicity: [1]

Entry date

The date on which the record was inserted into the Local Authority database.

• Data Type: Date

• Multiplicity: [1]

SAO start number

The number of the secondary addressable object (SAO) or the start of the number range.

• Attribute Name: saoStartNumber (GML), SAO_START_NUMBER (CSV), sao_start_number (GKPG)

• Condition: If a SAO Start Number is present a PAO Start Number or PAO text must also be present.

• Data Type: Integer

• Size: 4

• Multiplicity: [0..1]

SAO start suffix

The suffix to the SAO_START_NUMBER, for example ‘A’ or ‘B’.

• Attribute Name: saoStartSuffix (GML), SAO_START_SUFFIX (CSV), sao_start_suffix (GKPG)

• Condition: If a SAO Start Suffix is present a SAO Start Number must also be present.

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 2

• Multiplicity: [0..1]

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: saoEndNumber (GML), SAO_END_NUMBER (CSV), sao_end_number (GKPG)

• Condition: If SAO End Number is present, a SAO Start Number must also be present.

• Data Type: Integer

• Size: 4

• Multiplicity: [0..1]

SAO end suffix

The suffix to the SAO_END_NUMBER, for example, ‘A’ or ‘B’.

• Attribute Name: saoEndSuffix (GML), SAO_END_SUFFIX (CSV), sao_end_suffix (GKPG)

• Condition: If a SAO End Suffix is present, a SAO End Number must also be present.

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 2

• Multiplicity: [0..1]

SAO text

Describes the SAO, such as ‘Maisonette’ or ‘Flat 1’.

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

• Condition: If SAO Text is present, a PAO Start Number or PAO Text must also be present.

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 90

• Multiplicity: [0..1]

PAO start number

The number of the primary addressable object (PAO) or the start of the number range.

• Attribute Name: paoStartNumber (GML), PAO_START_NUMBER (CSV), pao_start_number (GKPG)

• Condition: PAO Start Number must be present if PAO Text is not present.

• Data Type: Integer

• Size: 4

• Multiplicity: [0..1]

PAO start suffix

The suffix to the PAO_START_NUMBER, for example, ‘A’ or ‘B’.

• Attribute Name: paoStartSuffix (GML), PAO_START_SUFFIX (CSV), pao_start_suffix (GKPG)

• Condition: If a PAO Start Suffix is present, a PAO Start Number must also be present.

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 2

• Multiplicity: [0..1]

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: paoEndNumber (GML), PAO_END_NUMBER (CSV), pao_end_number (GKPG)

• Condition: If a PAO End Number is present, a PAO Start Number must also be present.

• Data Type: Integer

• Size: 4

• Multiplicity: [0..1]

PAO end suffix

The suffix to the PAO_END_NUMBER, for example, ‘A’ or ‘B’.

• Attribute Name: paoEndSuffix (GML), PAO_END_SUFFIX (CSV), pao_end_suffix (GKPG)

• Condition: If a PAO End Suffix is present, a PAO End Number must also be present.

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 2

• Multiplicity: [0..1]

PAO text

Name describing the PAO, this is normally a building name such as ‘Harbour View’.

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

• Condition: PAO Text must be present if PAO Start Number is not present.

• Data Type: LocalisedCharacterString (GML), char (CSV), String (GKPG)

• Size: 90

• Multiplicity: [0..1]

USRN

Unique Street Reference Number (USRN) - foreign key linking the Street record to the LPI record.

• Attribute Name: usrn (GML), USRN (CSV), usrn (GKPG)

• Data Type: Integer

• Size: 8

• Multiplicity: [1]

USRN match indicator

This field indicates how the item 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: usrnMatchIndicator (GML), USRN_MATCH_INDICATOR (CSV), usrn_match_indicator (GKPG)

• Size: 1

• Multiplicity: [1]

Area name

Third level of geographic area name, for example, to record island names (Guernsey) or contain the TOWNLAND value for Northern Ireland records.

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

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 40

• Multiplicity: [0..1]

Level

Detail on the vertical position of the property if known and provided by the Local Authority Custodian.

• Attribute Name: level (GML), LEVEL (CSV), level (GKPG)

• Data Type: CharacterString (GML), char (CSV), String (GKPG)

• Size: 30

• Multiplicity: [0..1]

Official flag

Status of the Address.

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

• Size: 1

• Multiplicity: [0..1]