System Category	Addressing
Source	Corporate Land & Property Gazetteer
Available since	2008
Organisation

v6.0.0

These stored procedures have been deprecated from v6.0.0

Requires the Astun PG Installer applied to the Data Share database with the Location Search and SX3 options selected.

Database table for BuildAddresses

Field	Description
UPRN	Unique Property Reference Number
USRN	Unique Street Reference Number
EASTING	Coordinate
NORTHING	Coordinate
POSTCODE	Postcode
SAON_START_NUM	Secondary Addressable Object Start Number
SAON_START_SUFFIX	Secondary Addressable Object Start Suffix
SAON_END_NUM	Secondary Addressable Object End Number
SAON_END_SUFFIX	Secondary Addressable Object End Suffix
SAON_TEXT	Secondary Addressable Object Text
PAON_START_NUM	Primary Addressable Object Start Number
PAON_START_SUFFIX	Primary Addressable Object Start Suffix
PAON_END_NUM	Primary Addressable Object End Number
PAON_END_SUFFIX	Primary Addressable Object End Suffix
PAON_TEXT	Primary Addressable Object Text
DESCRIPTION	Street text
POSTTOWN	Post Town
TOWN	Town
LOC	Locality
DISTRICT	District
ORGANISATION	Organisation
COUNTY	County

Tables Used

LPG_BASICLANDANDPROPERTYUNIT, LPG_PROPERTY, V_STREETDESCRIPTOR

Table	SQL Statement
LPG_PROPERTY	SELECT UPRN,POSTCODE,NAMESEC,NAMEPRI,STREETID, STREETNAME,TOWN,LOCALITY,COUNTY,LOGICALSTATUS FROM LPG_PROPERTY
V_STREETDESCRIPTOR	SELECT USRN FROM V_STREETDESCRIPTOR
LPG_BASICLANDANDPROPERTYUNIT	SELECT UPRN,EASTING,NORTHING FROM LPG_BASICLANDANDPROPERTYUNIT