Table-NLPG_STREET_DESCRIPTOR

Created by: Lester Caine, Last modification: 20 Aug 2008 (09:59 UTC)
Field Type NULL Default Description
USRN Numeric(18,0) Primary

LANGUAGE Varchar(4) Primary

STREET_DESCRIPTOR Varchar(100) NOT NULL

LOCALITY_NAME Varchar(35)


TOWN_NAME Varchar(30) NOT NULL

ADMINISTRATIVE_AREA Varchar(30) NOT NULL


These records have been split from the main street record in order to allow different language versions of the information to be recorded. Currently the system is being developed hard coded to use 'ENG' as there is no other language information available for testing, but adding a switch to select a different language in the display fields will be relatively easy to add later.