Idox - Uniform (CAPS)

Owned by Kim Stimpson
Last updated: 11 Jun, 2019 by Andrew Bailey
System CategoryAddressing
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 town

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.