| System Category | Addressing |
|---|---|
| Source | Corporate Land & Property Gazetteer |
| Available since | 2010 |
| Organisation |
Astun have written the NLPG Importer to import NLPG csv files which are eventually converted to SQL records. Please refer to the topic Step 8 - Create Task to Build Address Lookups for details.
Database view for BuildAddresses
Field | Description |
|---|---|
UPRN | Unique Property Reference Number |
USRN | Unique Street Reference Number |
X_COORDINATE | Easting Coordinate |
Y_COORDINATE | Northing Coordinate |
POSTCODE | Postcode |
SAO_START_NUMBER | Secondary Addressable Object Start Number |
SAO_START_SUFFIX | Secondary Addressable Object Start Suffix |
SAO_END_NUM | Secondary Addressable Object End Number |
SAO_END_SUFFIX | Secondary Addressable Object End Suffix |
SAO_TEXT | Secondary Addressable Object Text |
PAO_START_NUM | Primary Addressable Object Start Number |
PAO_START_SUFFIX | Primary Addressable Object Start Suffix |
PAO_END_NUM | Primary Addressable Object End Number |
PAO_END_SUFFIX | Primary Addressable Object End Suffix |
PAO_TEXT | Primary Addressable Object Text |
STREET_DESCRIPTOR | Street text |
POST_TOWN | Postal Town |
TOWN_NAME | Town |
LOCALITY_NAME | Locality |