Table-NLPG_BLPU_RECORD_TYPES

Created by: Lester Caine, Last modification: 20 Aug 2008 (10:25 UTC)
Field Type NULL Default Description
R_ID Smallint Primary   Identifier for the group of text
ID Varchar(4) Primary   Code value used in data
TITLE Varchar(64)     Text to display

Need to add list of R_ID types

Current content is :-
1 I Insert
1 U Update
1 D Delete
2 1 Designated Street Name
2 2 Street Description
2 3 Street Number
2 4 Unofficial Street Name
2 9 Feature used for LLPG access
3 1 Under construction
3 2 Open
3 4 Permanently closed
3 5 Open with restriction
4 1 Metalled
4 2 Unmetalled
4 3 Mixed
5 4 Pedestrian way or footpath
5 6 Cycletrack or cycleway
5 8 Open to vehicles
5 9 Restricted access to vehicles
6 ENG English
6 CYM Welsh
6 COR Cornish
6 GLE Gaelic (Irish)
6 GAE Gaelic (Scottish)
6 ULL Ulster Scots
7 1 Approved BLPU
7 5 Candidate BLPU
7 6 Provisional
7 7 Rejected External
7 8 Historical
7 9 Rejected Internal
8 1 Under construction / named or numbered by SN & N
8 2 In use / occupied
8 3 Unoccupied / vacant / derelict
8 4 Demolished
8 5 Planning application submitted
8 6 Planning permission granted
8 7 Planning application refused
9 1 Visual centre of BLPU
9 2 General internal point
9 3 SW corner of 100m grid square
9 4 Start of street
9 5 General point based on Unit Postcode
9 6 Centre of local authority area
10 1 Approved / Preferred LPI
10 3 Alternate LPI
10 5 Candidate LPI
10 6 Provisional LPI
10 7 Rejected External LPI
10 8 Historical LPI
10 9 Rejected Internal LPI