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