Northgate - MVM

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

Prior to iShare v6.0.0 this requires the Astun PG Installer applied to the Data Share database with the Location Search and NorthgateMVM options selected.

Database table for BuildAddresses

Field	Description
BLPU_UPRN	Unique Property Reference Number
STREET_REFERENCE_NUMBER	Unique Street Reference Number
EASTING	Coordinate
NORTHING	Coordinate
POSTCODE	Postcode
PROPERTY_NUMBER	Secondary Addressable Object Start Number
PROPERTY_SUFFIX	Secondary Addressable Object Start Suffix
PROPERTY_NUMBER_1	Secondary Addressable Object End Number
PROPERTY_SUFFIX_1	Secondary Addressable Object End Suffix
SUB_BUILDING_NAME	Secondary Addressable Object Text
DESIGNATED_PREMISE_NUMBER	Primary Addressable Object Start Number
DESIGNATED_PREMISE_SUFFIX	Primary Addressable Object Start Suffix
DESIGNATED_PREMISE_NUMBER_1	Primary Addressable Object End Number
DESIGNATED_PREMISE_SUFFIX_1	Primary Addressable Object End Suffix
DESIGNATED_PREMISE_NAME	Primary Addressable Object Text
STREET_TEXT	Street text
POSTTOWN	Post Town
LEVEL4_NAME	Town
LEVEL3_NAME	Locality

Tables Used

This uses a single table PD_ADDRESSES which is imported into the iShare database as NorthgateLLPG.

Create a Workflow Stored Procedure Task to create AstunLocationLookup using the Workflow function at_wkf_build_from_northgatemvm (from v6.0.0 this is called wkf_build_from_northgate under the -Workflow- Function filter)

SQL Statements

Table	SQL Statement
NorthgateLLPG	SELECT * FROM PD_ADDRESSES WHERE PRIMARY_LPI = 'Y' AND PLAPI_STATUS='L'