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

Browser not supported