LPI – (Type 24 Record)

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

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]

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

For GML language qualifiers are provided in the parent element as ‘xml:lang’

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

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

  • Code List Name: LanguageCode

  • Size: 3

  • Multiplicity: [1]

Logical status

Logical status of this record.

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

  • Code List Name: LogicalStatusCode

  • Size: 1

  • Multiplicity: [1]

Start date

Date that this LPI 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 this record ceased to exist in the database.

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

  • Data Type: Date

  • Multiplicity: [0..1]

Last update date

The last date an attribute on this record was 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 inserted into the Local Authority database.

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

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

  • Code List Name: USRNMatchIndicatorCode

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

  • Code List Name: OfficialFlagCode

  • Size: 1

  • Multiplicity: [0..1]

Last updated

Was this helpful?