Idox - Plantech (Accolaid)

System Category	Addressing
Source	Corporate Land & Property Gazetteer
Available since	2005
Organisation

The following details the database information required for using Plantech 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 Plantech options selected.

Database table for BuildAddresses

Field	Description
BS7666UPRN	Unique Property Reference Number
BS7666USRN	Unique Street Reference Number
EASTING	Coordinate
NORTHING	Coordinate
POSTCODE	Postcode
SAONSTARTNUMBER	Secondary Addressable Object Start Number
SAONSTARTSUFFIX	Secondary Addressable Object Start Suffix
SAONENDNUMBER	Secondary Addressable Object End Number
SAONENDSUFFIX	Secondary Addressable Object End Suffix
SAONTEXT	Secondary Addressable Object Text
PAONSTARTNUMBER	Primary Addressable Object Start Number
PAONSTARTSUFFIX	Primary Addressable Object Start Suffix
PAONENDNUMBER	Primary Addressable Object End Number
PAONENDSUFFIX	Primary Addressable Object End Suffix
PAONTEXT	Primary Addressable Object Text
STREETNAME	Street text
POSTTOWN	Post Town
TOWNNAME	Town
LOCALITYNAME	Locality

Tables Used

This uses two tables PROPLPI and PROPLPI_WITHCOORDS.

SQL Statements

Table	SQL Statement
PROPLPI	SELECT * FROM PROPLPI
PROPLPI_WITHCOORDS	SELECT * FROM PROPLPI_WITHCOORDS