Fields |
| Number of fields |
5 |
| |
|
| 1 |
| Field name: |
TKMSQ |
| Data type: |
Fixed Length String (length 4) |
| Original description: |
10 km square |
| Further descriptive information: |
Grid reference of the 10 km square This is the key to the file. {Maximum length 4} |
| Missing value(s): |
[not permitted for this field] |
| Attributes: |
This field forms a 1 - Many relationship with the following tables: via the field 10KMGRID |
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 2 |
| Field name: |
VCOUNTY |
| Data type: |
Variable Length String |
| Original description: |
Multivalued list of vice-counties which fall within that 10Km square |
| Further descriptive information: |
{Multi-valued field. Maximum length 3}. |
| Missing value(s): |
[not permitted for this field] |
| Attributes: |
This field forms a Many - 1 relationship with the following tables: via the field VCOUNTY_CODE |
| Constraints: |
[As specified by Encoding] |
| Encoding: |
This field may only take one of the 113 pre-defined values listed |
| Codes |
Values |
| 1 | West Cornwall |
| 2 | East Cornwall |
| 3 | South Devon |
| 4 | North Devon |
| 5 | South Somerset |
| 6 | North Somerset |
| 7 | North Wiltshire |
| 8 | South Wiltshire |
| 9 | Dorset |
| 10 | Isle of Wight |
| 11 | South Hampshire |
| 12 | North Hampshire |
| 13 | West Sussex |
| 14 | East Sussex |
| 15 | East Kent |
| 16 | West Kent |
| 17 | Surrey |
| 18 | South Essex |
| 19 | North Essex |
| 20 | Hertfordshire |
| 21 | Middlesex |
| 22 | Berkshire |
| 23 | Oxfordshire |
| 24 | Buckinghamshire |
| 25 | East Suffolk |
| 26 | West Suffolk |
| 27 | East Norfolk |
| 28 | West Norfolk |
| 29 | Cambridgeshire |
| 30 | Bedfordshire |
| 31 | Huntingdonshire |
| 32 | Northamptonshire |
| 33 | East Gloucestershire |
| 34 | West Gloucestershire |
| 35 | Monmouthshire |
| 36 | Herefordshire |
| 37 | Worcestershire |
| 38 | Warwickshire |
| 39 | Staffordshire |
| 40 | Shropshire |
| 41 | Glamorgan |
| 42 | Breconshire |
| 43 | Radnorshire |
| 44 | Carmarthenshire |
| 45 | Pembrokeshire |
| 46 | Cardiganshire |
| 47 | Montgomeryshire |
| 48 | Merionethshire |
| 49 | Caernarvonshire |
| 50 | Denbyshire |
| 51 | Flintshire |
| 52 | Anglesey |
| 53 | South Lincolnshire |
| 54 | North Lincolnshire |
| 55 | Leicestershire & utland |
| 56 | Nottinghamshire |
| 57 | Derbyshire |
| 58 | Cheshire |
| 59 | South Lancashire |
| 60 | West Lancashire |
| 61 | South-east Yorkshire |
| 62 | North-east Yorkshire |
| 63 | South-west Yorkshire |
| 64 | Mid-west Yorkshire |
| 65 | North-west Yorkshire |
| 66 | Durham |
| 67 | South Northumberland |
| 68 | North Northumberland |
| 69 | Westmorland & N. Lancs |
| 70 | Cumberland |
| 71 | Isle of Man |
| 72 | Dumfrieshire |
| 73 | Kirkcubrightshire |
| 74 | Wigtownshire |
| 75 | Ayrshire |
| 76 | Renfrewshire |
| 77 | Lanarkshire |
| 78 | Peebleshire |
| 79 | Selkirkshire |
| 80 | Roxburghshire |
| 81 | Berwickshire |
| 82 | East Lothian |
| 83 | Midlothian |
| 84 | West Lothian |
| 85 | Fifeshire |
| 86 | Stirlingshire |
| 87 | West Perthshire |
| 88 | Mid Perthshire |
| 89 | East Perthshire |
| 90 | Angus |
| 91 | Kincardineshire |
| 92 | South Aberdeenshire |
| 93 | North Aberdeenshire |
| 94 | Banffshire |
| 95 | Moray |
| 96 | East Inverness-shire |
| 97 | West Inverness-shire |
| 98 | Argyll Main |
| 99 | Dunbartonshire |
| 100 | Clyde Isles |
| 101 | Kintyre |
| 102 | South Ebudes |
| 103 | Mid Ebudes |
| 104 | North Ebudes |
| 105 | West Ross |
| 106 | East Ross |
| 107 | East Sutherland |
| 108 | West Sutherland |
| 109 | Caithness |
| 110 | Outer Hebrides |
| 111 | Orkney Islands |
| 112 | Shetland Islands |
| 113 | Channel Isles |
|
| |
| 3 |
| Field name: |
BRC_COUNTY |
| Data type: |
Variable Length String |
| Original description: |
BRC county number in which square lies |
| Further descriptive information: |
BRC = Biological Records Centre. {Multivalued field. Maximum length 2} |
| 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: |
SHEET |
| Data type: |
Variable Length String |
| Original description: |
OS 1:50,000 sheet numbers |
| Further descriptive information: |
{Multivalued field. Maximum length 3} |
| Missing value(s): |
One or more spaces |
| Attributes: |
|
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 5 |
| Field name: |
COUNTY |
| Data type: |
Variable Length String |
| Original description: |
BATDATA system county code |
| Further descriptive information: |
{Multivalued field. Maximum length 2} |
| Missing value(s): |
One or more spaces |
| Attributes: |
This field forms a Many - 1 relationship with the following tables: via the field CNUMB |
| Constraints: |
[As specified by Encoding] |
| Encoding: |
This field may only take one of the 67 pre-defined values listed |
| Codes |
Values |
| 1 | Avon |
| 2 | Cornwall |
| 3 | Devon |
| 4 | Dorset |
| 5 | Somerset |
| 6 | Berkshire |
| 7 | Buckinghamshire |
| 8 | Hampshire |
| 9 | Oxfordshire |
| 10 | Isle of Wight |
| 11 | Wiltshire |
| 12 | Kent |
| 13 | Greater London |
| 14 | Surrey |
| 15 | East Sussex |
| 16 | West Sussex |
| 17 | Cheshire |
| 18 | Derbyshire |
| 19 | Gloucestershire |
| 20 | Hereford & Worcester |
| 21 | Shropshire |
| 22 | Staffordshire |
| 23 | Warwickshire |
| 24 | West Midlands |
| 25 | Bedfordshire |
| 26 | Cambridgeshire |
| 27 | Hertfordshire |
| 28 | Leicestershire |
| 29 | Lincolnshire |
| 30 | Northamptonshire |
| 31 | Nottinghamshire |
| 32 | Essex |
| 33 | Norfolk |
| 34 | Suffolk |
| 35 | Cumbria |
| 36 | Greater Manchester |
| 37 | Lancashire |
| 38 | Merseyside |
| 39 | South Yorkshire |
| 40 | West Yorkshire |
| 41 | Cleveland |
| 42 | Durham |
| 43 | Humberside |
| 44 | Northumberland |
| 45 | Tyne & Wear |
| 46 | North Yorkshire |
| 50 | Dumfries & Galloway |
| 51 | Strathclyde |
| 52 | Borders |
| 53 | Central |
| 54 | Fife |
| 55 | Lothian |
| 56 | Tayside |
| 57 | Highland |
| 58 | Western Isles |
| 59 | Grampian |
| 60 | Badenoch & Strathspey |
| 61 | Orkney |
| 62 | Shetland |
| 70 | Clwyd |
| 71 | Gwynedd |
| 72 | Dyfed |
| 74 | Powys |
| 76 | Gwent |
| 77 | Mid Glamorgan |
| 78 | South Glamorgan |
| 79 | West Glamorgan |
|
| |
| |
|
Table details: CRDA/17/DS/1/1/9
