| System Category | Addressing |
|---|---|
| Source | Corporate Land & Property Gazetteer |
| Available since | 2006 |
| Organisation |  |
The following details the database information required for using Uniform as the source for your Astun Location Lookup. This information should be used in conjunction with the Configure Location Lookups topic.
Requires the Astun PG Installer applied to the Data Share database with the Location Search and Caps options selected.
Database table for BuildAddresses
Field | Description |
|---|---|
ORGANISATION | Organisation Name |
UPRN | Unique Property Reference Number |
USRN | Unique Street Reference Number |
MAP_EAST | Coordinate |
MAP_NORTH | Coordinate |
POSTCODE | Postcode |
SAO_START_NO | Secondary Addressable Object Start Number |
SAO_START_SFX | Secondary Addressable Object Start Suffix |
SAO_END_NO | Secondary Addressable Object End Number |
SAO_END_SFX | Secondary Addressable Object End Suffix |
SAO_DESC | Secondary Addressable Object Text |
PAO_START_NO | Primary Addressable Object Start Number |
PAO_START_SFX | Primary Addressable Object Start Suffix |
PAO_END_NO | Primary Addressable Object End Number |
PAO_END_SFX | Primary Addressable Object End Suffix |
PAO_DESC | Primary Addressable Object Text |
STREET_NAME | Street text |
POST_TOWN | Post own |
TOWN_NAME | Town |
LOCALITY_NAME | Locality |
DISTRICT_NAME | District |
COUNTY_NAME | County |
Tables Used
This uses a number of tables: PR_BLPU, PR_LPI, PR_ST_DESC and PR_STREET.
SQL Statements
Table | SQL Statement |
|---|---|
PR_BLPU | SELECT * FROM PR_BLPU or SELECT * FROM UNI7LIVE.PR_BLPU where UNI7LIVE is the Oracle schema name. |
PR_LPI | SELECT * FROM PR_LPI or SELECT * FROM UNI7LIVE.PR_LPI |
PR_ST_DESC | SELECT * FROM PR_ST_DESC or SELECT * FROM UNI7LIVE.PR_ST_DESC |
PR_STREET | SELECT * FROM PR_STREET or SELECT * FROM UNI7LIVE.PR_STREET |
Data Share Connection Setup
For CAPS you need to prefix the Name for the Data Share Connection with UNI7LIVE_ e.g. UNI7LIVE_PR_BLPU for the table PR_BLPU.
