Vocabularies — details

DIC_SHEET

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 10 of 679)

SHEETNAM ONENO STATUS DATE_ENTERED COUNTRY SHEETCODE DATE_UPDATED CK1_SHEET
Manchester  85  13-JUN-86  UK18  05-JAN-05  E85 
Glossop  86  13-JUN-86  UK10  05-JAN-05  E86 
Beverley  72  13-JUN-86  UK22  05-JAN-05  E72 
Hornsea  73  13-JUN-86  UK22  05-JAN-05  E73 
Southport  74  13-JUN-86  UK28  05-JAN-05  E74 
Preston  75  13-JUN-86  UK25  05-JAN-05  E75 
Rochdale  76  13-JUN-86  UK18  05-JAN-05  E76 
Huddersfield  77  13-JUN-86  UK45  05-JAN-05  E77 
Wakefield  78  13-JUN-86  UK45  05-JAN-05  E78 
Goole  79  13-JUN-86  UK22  05-JAN-05  E79