Idox - Plantech (Accolaid)
- Kim Stimpson
- Mike Saunt
- Andrew Bailey
| 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 |