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