DIC_SHEET
Dictionary table containing the sheet numbers and names of BGS 1:50K (formerly 1-inch) geological sheets. This is an important dictionary and validation tool, referenced by various databases, including the Lexicon.
| No. |
Column name |
Data type |
Notes |
| 1 |
SHEETNAM |
Varchar(80) |
Primary key
|
| 2 |
ONENO |
Varchar(4) |
|
| 3 |
STATUS |
Varchar(1) |
|
| 4 |
DATE_ENTERED |
Date |
|
| 5 |
COUNTRY |
Varchar(6) |
|
| 6 |
SHEETCODE |
Varchar(2) |
|
| 7 |
DATE_UPDATED |
Date |
|
| 8 |
CK1_SHEET |
Varchar(6) |
|
Sample data (rows 1 to 20 of 679)
| SHEETNAM |
ONENO |
STATUS |
DATE_ENTERED |
COUNTRY |
SHEETCODE |
DATE_UPDATED |
CK1_SHEET |
| Manchester |
85 |
C |
13-JUN-86 |
UK18 |
E |
05-JAN-05 |
E85 |
| Glossop |
86 |
C |
13-JUN-86 |
UK10 |
E |
05-JAN-05 |
E86 |
| Beverley |
72 |
C |
13-JUN-86 |
UK22 |
E |
05-JAN-05 |
E72 |
| Hornsea |
73 |
C |
13-JUN-86 |
UK22 |
E |
05-JAN-05 |
E73 |
| Southport |
74 |
C |
13-JUN-86 |
UK28 |
E |
05-JAN-05 |
E74 |
| Preston |
75 |
C |
13-JUN-86 |
UK25 |
E |
05-JAN-05 |
E75 |
| Rochdale |
76 |
C |
13-JUN-86 |
UK18 |
E |
05-JAN-05 |
E76 |
| Huddersfield |
77 |
C |
13-JUN-86 |
UK45 |
E |
05-JAN-05 |
E77 |
| Wakefield |
78 |
C |
13-JUN-86 |
UK45 |
E |
05-JAN-05 |
E78 |
| Goole |
79 |
C |
13-JUN-86 |
UK22 |
E |
05-JAN-05 |
E79 |
| Formby |
83 |
C |
13-JUN-86 |
UK28 |
E |
05-JAN-05 |
E83 |
| Wigan |
84 |
C |
13-JUN-86 |
UK18 |
E |
05-JAN-05 |
E84 |
| Bangor |
106 |
C |
13-JUN-86 |
UK93 |
E |
05-JAN-05 |
E106 |
| Caernarfon |
105 |
C |
13-JUN-86 |
UK93 |
E |
05-JAN-05 |
E105 |
| Snowdon |
119 |
C |
13-JUN-86 |
UK93 |
E |
05-JAN-05 |
E119 |
| Llandudno |
94 |
C |
13-JUN-86 |
UK93 |
E |
05-JAN-05 |
E94 |
| Norham |
1 |
C |
13-JUN-86 |
UK32 |
E |
05-JAN-05 |
E1 |
| Berwick-on-Tweed |
2 |
C |
13-JUN-86 |
UK32 |
E |
05-JAN-05 |
E2 |
| Ford |
3 |
C |
13-JUN-86 |
UK32 |
E |
05-JAN-05 |
E3 |
| Holy Island |
4 |
C |
13-JUN-86 |
UK32 |
E |
05-JAN-05 |
E4 |
