The National Archives - link to home page    

Wednesday 7 January

  

Main website navigation:

   
 
 NDAD: The National Digital Archive of Datasets
Welcome (home page) About NDAD Users Contributors  
Search Browse News Help (new window)  
 
 

Table details: CRDA/10/DS/1/1/1

Defence lengths, original survey (length_94)

help - opens in a new window: Browsing NDAD catalogues
 
 
Quick reference Full details Order copies
Search this table Download as CSV
 
  View in hierarchy
 

Jump to :  Context  |  Summary  |  Identity statement  |  Description  |  Fields  | 

Context
AH/4  Agricultural Departments
  CRDA/10  Coast Protection Survey of England
  CRDA/10/DS/1/1  Original survey (1994)
 
Top of pagetop of page

Summary
Title Defence lengths, original survey
NDAD reference CRDA/10/DS/1/1/1
Scope & content The Length_94 table contains fields for the defence lengths. This data was collected in the original Coast Protection Survey of England (CPSE). More information about the original survey and the subsequent updates is provided in the series catalogue for CRDA/10.
Access conditions

There are no access restrictions on this table.

You can use the NDAD Query Builder to view and query data in this and other tables in this dataset.
 
Top of pagetop of page

Identity statement
Table name length_94
Number of records 2446
SIZE of file (KB) 449.27
Maximum record size (bytes) 240
ISAD(G) level of description Item
 
Top of pagetop of page

Description
Field descriptions Information in the field descriptions is taken from the dataset and from other sources, in particular from an extract from the conditions of appointment of an associate consultant involved in the original survey (see the dataset documentation catalogue: reference CRDA/10/DD/1/2). Non-italicized quotations are taken from this document, unless otherwise indicated.
 
Top of pagetop of page

Fields
Number of fields 27
 

Go to page: . 1 . 2 . 3 . . next page. final page

1
Field name: up_date
Data type: Variable Length String
Original description: Internal Use: if the record has been updated compared to the previous year
Further descriptive information:

Indicates whether data was updated as a result of comments received from maritime local authorities after the completion of fieldwork. Field was designed for internal use by Halcrow, for updating and checking data.

Indicates whether data was updated

An explanation for the values in this field was provided by Halcrow after the transfer of the dataset.
Missing value(s): One or more spaces
Attributes:
Constraints: [As specified by Encoding]
Encoding: This field may only take one of the 4 pre-defined values listed
Codes Values
MData updated from data received from a maritime local authority
NNew defence or re-coding of a defence
YYes, updated
HUpdate by Halcrow to conform with other data, ensuring data integrity
 
2
Field name: mslink
Data type: Integer(Short)
Original description: Internal Use: identifier used with the Geographic Information System
Further descriptive information:

Internal field used in GIS at MAFF and Halcrow. These systems hold digital map data used with the CPSE.
Missing value(s): One or more spaces
Attributes:
Constraints: This field may take any value appropriate to its datatype.
Encoding: [No encoding used]
 
3
Field name: mapid
Data type: Integer
Original description: Internal Use: identifier used with the Geographic Information System
Further descriptive information:

Internal field used in GIS at MAFF and Halcrow. These systems hold digital map data used with the CPSE.
Missing value(s): One or more spaces
Attributes:
Constraints: This field may take any value appropriate to its datatype.
Encoding: [No encoding used]
 
4
Field name: def_code
Data type: Variable Length String
Original description: The unique Defence Length Code (Primary key)
Further descriptive information:

A seven digit number of the form abb/ccdd. The first digit, a, represents the MAFF Region. The second and third digits, bb, represent the National River Authority's Sea Defence Survey region. The fourth and fifth digits, cc, represent the maritime local authority. The sixth and seventh digits, dd, uniquely define each defence length within the referenced council boundaries. As far as possible numbers shall be allocated in ascending order when progressing clockwise around the coast.

Unique seven digit code (primary key)

The following tables explain the code structure used in the first five digits of the def_code field.

Survey area/MAFF Region

The first digit of the defence length code desiginates the MAFF region.
 

First digit MAFF Region
2 York
3 Lincoln
4 Cambridge
5 Tunbridge Wells
6 Taunton

National Rivers Authority's Sea Defence Survey region

The second and third digits designate the region from the NRA's Sea Defence Survey. Halcrow's guidance notes for the 1995 update of the CPSE (see the dataset documentation catalogue: reference CRDA/10/DD/3/1995/1) states that these codes represent the NRA Regions prior to the mergers between the Northumbria and Yorkshire Regions, and the Wessex and South West Regions. Those defence lengths within the boundaries of the NRA's Severn-Trent region are included in the Wessex Region - Bristol Avon District.
 

Second & third digit NRA region
10 North West
20 Northumbria
40 Yorkshire
51 Anglian - Essex
52 Anglian - Cambridge
53 Anglian - Lincolnshire
54 Anglian - Norfolk and Suffolk
55 Anglian - Welland and Nene
71 Southern - Hampshire
72 Southern - Isle of Wight
73 Southern - Kent
74 Southern - Sussex
81 Wessex - Avon and Dorset
82 Wessex - Bristol Avon
83 Wessex - Somerset
90 South West

Maritime local authority

The fourth and fifth digits define the maritime local authority. C is Council; BC Borough Council; CC City Council; DC District Council and MBC is Metropolitan Borough Council. (Note that the actual codes used are different to those listed in CRDA/10/DD/1/2. The following table is taken from Halcrow's guidance notes for the 1995 update of the CPSE. See the dataset documentation catalogue: reference CRDA/10/DD/3/1995/1.)
 

Fourth & fifth digit Local authority
91 Southampton CC
90 Eastleigh BC
89 Isle of Scilly C
88 Wirral BC
87 Sefton MBC
86 West Lancashire DC
85 Fylde BC
84 Blackpool BC
83 Wyre BC
82 Lancaster CC
81 South Lakeland DC
80 Barrow in Furness BC
79 Copeland BC
78 Allerdale DC
77 Carlisle CC
76 Berwick-upon-Tweed BC
75 Alnwick DC
74 Castle Morpeth BC
73 Wansbeck DC
72 Blyth Valley BC
71 North Tyneside BC
70 South Tyneside MBC
69 Sunderland BC
68 Easington DC
67 Hartlepool BC
66 Langbaurgh-on-Tees BC
65 Scarborough BC
64 East Yorkshire BC
63 Holderness BC
62 Cleethorpes BC
61 East Lindsey BC
60 Kings Lynn & West Norfolk BC
59 North Norfolk DC
58 Great Yarmouth BC
57 Waveney DC
56 Suffolk Coastal DC
55 Tendring DC
54 Colchester BC
53 Maldon DC
52 Rochford DC
51 Southend-on-Sea BC
50 Rochester-upon-Medway CC
49 Swale BC
48 Canterbury CC
47 Thanet DC
46 Dover DC
45 Shepway DC
44 Rother DC
43 Hastings BC
42 Eastbourne BC
41 Wealden DC
40 Lewes DC
39 Brighton BC
38 Hove BC
37 Adur DC
36 Worthing BC
35 Arun DC
34 Chichester DC
33 Havant BC
32 Porstmouth CC
31 Gosport BC
30 Fareham BC
29 Medina BC
28 South Wight BC
27 New Forest DC
26 Christchurch BC
25 Bournemouth BC
24 Poole BC
23 Purbeck DC
22 Weymouth & Portland BC
21 West Dorset DC
20 East Devon DC
19 Teignbridge DC
18 Torbay BC
17 South Hams DC
16 Plymouth CC
15 Caradon DC
14 Penwith DC
13 Kerrier DC
12 Carrick DC
11 Restormel BC
10 North Cornwall DC
09 Torridge DC
08 North Devon DC
07 West Somerset DC
06 Sedgemoor DC
05 Woodspring DC
04 Bristol CC
03 Northavon DC
02 Stroud DC
01 Forest of Dean DC

Missing value(s): [not permitted for this field]
Attributes:

This field forms a 1 - Many relationship with the following tables:

From CRDA/10/DS/1/1 to element_94 (CRDA/10/DS/1/1/2)

via the field defence_code
Constraints: This field may take any value appropriate to its datatype.
Encoding: [No encoding used]
 
5
Field name: location
Data type: Variable Length String
Original description: The principal location of the Defence, usually a town name with a subsidiary name to give its location within the frontage
Further descriptive information:
Missing value(s): One or more spaces
Attributes:
Constraints: This field may take any value appropriate to its datatype.
Encoding: [No encoding used]
 
6
Field name: survey_date
Data type: Date as Fixed Length String (length 10)
Original description: The date the survey was carried out
Further descriptive information:
Missing value(s): One or more spaces
Attributes:
Constraints: This field may take any value appropriate to its datatype.
Encoding: [No encoding used]
 
7
Field name: inspect_by_comp
Data type: Variable Length String
Original description: The company that inspected the Defence
Further descriptive information:

The associate consultant that carried out the fieldwork at the time of the original survey.
Missing value(s): One or more spaces
Attributes:
Constraints: [As specified by Encoding]
Encoding: This field may only take one of the 3 pre-defined values listed
Codes Values
MMMott MacDonald
POSFORDSPosford Duvivier International Consulting Engineers
MOUCHELMouchel Consulting Ltd
 
8
Field name: inspect_by_name
Data type: Variable Length String
Original description: The person whom inspected the Defence
Further descriptive information:

The initials of the employee of the associate consultant who inspected the defence.
Missing value(s): One or more spaces
Attributes:
Constraints: This field may only take one of the 31 pre-defined values listed:

TB; RCA; SG; SKG; MSW; PS; MJW; MM; MJN2; MJN; MCA; MC#; MC; LGM; KCA; JGLJ; JGLG; JGJG; IRH; ICH; HMH; HAW; GVR; GR; GJR; GAB6; GAB; DLH; BKS; BEE; AGB
Encoding: [No encoding used]
 
9
Field name: os_grid_start
Data type: Fixed Length String (length 10)
Original description: Start coordinate of the primary feature of the Defence
Further descriptive information:

The Ordnance Survey grid reference at the start of "the uppermost main primary feature of the defence, eg the crest line of [the] primary wall. The start and finish of each defence length are to be defined in a clockwise direction around the coast".
Missing value(s): One or more spaces
Attributes:
Constraints: This field may take any value appropriate to its datatype.
Encoding: [No encoding used]
 
10
Field name: os_grid_finish
Data type: Fixed Length String (length 10)
Original description: End coordinate of the primary feature of the Defence
Further descriptive information:

The Ordnance Survey grid reference at the end of "the uppermost main primary feature of the defence, eg the crest line of [the] primary wall. The start and finish of each defence length are to be defined in a clockwise direction around the coast".
Missing value(s): One or more spaces
Attributes:
Constraints: This field may take any value appropriate to its datatype.
Encoding: [No encoding used]
 
 

Go to page: . 1 . 2 . 3 . . next page. final page

Top of pagetop of page

* maximum list length 500
 
 

NDAD v3.0