Idox - Uniform (CAPS)

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