Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Page Properties
System CategoryAddressing
Source

Corporate Land & Property Gazetteer

Available since
Status
subtletrue
colourGreen
title2010
OrganisationImage Removed

Astun have written the NLPG (National Land & Property Gazetteer) 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