Table-NLPG_BLPU_RECORD_TYPES
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