Page Comparison

Page Properties
id SC
System Category Addressing Source Corporate Land & Property Gazetteer Available since Status subtle true colour Green title 2006 Organisation Image Removed Image Added

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.

...

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

...