Northgate - SX3
- Kim Stimpson
- Mike Saunt
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 |