Vocabularies — details


Dictionary table giving simple categorisation of BGS-held Coastal and Marine Data Sheets by their paper form and content (information). Includes SHEET_ORDER, which is the order of preference for the retrieval (display) of the Data Sheets for a given location.

No. Column name Data type Notes
1 CODE Varchar(15) Primary key
2 DESCRIPTION Varchar(250)  
3 TRANSLATION Varchar(50)  
6 SHEET_ORDER Numeric(22)  
7 STATUS Char(1)  

Sample data (rows 1 to 10 of 19)

BGS1  BGS/IGS Sample station data, this can be old form (1-page) or other sample descriptions that are NOT the 3-page version. Includes information in note form.  BGS/IGS Sample station data (not 3-page).  12-JUL-06  20-NOV-06 
BGS3_A  BGS Sample station data - Summary Sheet. Page one of a three page set.  BGS Sample station data   12-JUL-06  20-NOV-06 
BGS3_B  BGS Sample station data - Description sheet. Page two of a three page set.  BGS Sample station data - Description sheet   12-JUL-06  20-NOV-06 
BGS3_C  BGS Sample station data - Geology sheet. Page three of a three page set.  BGS Sample station data - Geology sheet.  12-JUL-06  20-NOV-06 
MAP  Sketch map of location, or similar (not large size survey map, these should be in the map collection?).This can be BGS or non-BGS.  MAP - sketch map of location, or similar.  12-JUL-06  14-SEP-07  12 
NBGS_COMM  Non BGS commercial information copied from reports, not covered by other Sheet Type Categories.  Non BGS commercial information copied from reports  12-JUL-06  20-NOV-06  16 
NBGS_STAT  non-BGS Sample station data. Normally on distinct non-BGS data entry sheet, but may have been entered onto a BGS (IGS) sheet - this can be difficult to spot, see CLIENT field in Samples DB Table for help with identification..  non-BGS Sample station data.  12-JUL-06  20-NOV-06 
PAL  Palaeontology, Palynology, Fossil, Bio-Stratigraphy & other 'Biological' information.This can be BGS or non-BGS.  Palaeontology, Palynology, Fossil & similar info.  12-JUL-06  14-SEP-07  10 
PHOT  Any photo on its own. NOTE - This category is primarily to cover photos held at Keyworth that are mixed in with the data sheets. Main photo collections will be dealt with separately.  Photo on its own.  12-JUL-06  20-NOV-06  14 
PSA_GRAPH  Particle Size Analysis (PSA) summation percentage graph. Any sheet that is primarily a graph/chart, if it is half-PSA data & half-PSA Graph, it should be recorded as sheet type=PSA, with "Has PSA Graph" in QUALITY_ORIGINAL_COMMENTS . BGS or non BGS  PSA summation percentage graph.  12-JUL-06  14-SEP-07