| System Category | Addressing |
|---|---|
| Source | Corporate Land & Property Gazetteer |
| Available since | 2006 |
| Organisation |  |
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.
