Northgate - SX3

System CategoryAddressing
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

SQL Statements


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