Vocabularies — details

LEXICON_ONE2ONE

This table holds details of BGS's lexicon child codes and is part of a system that is used to export parts of the BGS Lexicon for external publication on the Internet.

No. Column name Data type Notes
1 COMPUTER_CODE Varchar(5) Primary key
2 DESCRIPTION Varchar(5)  
3 STATUS_CODE Varchar(5)  
4 MAP_CODE Varchar(5)  
5 MAX_AGE_CODE Varchar(5)  
6 MAX_AGE Varchar(5)  
7 MIN_AGE_CODE Varchar(5)  
8 MIN_AGE Varchar(5)  
9 DESCRIPTION_TYPE Varchar(5)  
10 LITH_DESC Varchar(5)  
11 LWR_BOUNDARY Varchar(5)  
12 UPPR_BOUNDARY Varchar(5)  
13 THICKNESS Varchar(5)  
14 GEO_LIMITS Varchar(5)  


Sample data (rows 1 to 20 of 13229)

COMPUTER_CODE DESCRIPTION STATUS_CODE MAP_CODE MAX_AGE_CODE MAX_AGE MIN_AGE_CODE MIN_AGE DESCRIPTION_TYPE LITH_DESC LWR_BOUNDARY UPPR_BOUNDARY THICKNESS GEO_LIMITS
PIBG  PISHLINN BURN GRAVEL FORMATION  FORMAL, NATIONAL  PBG  QA  ANGLIAN  QO  WOLSTONIAN    Gravel, cobbly, clast or matrix-supported mass movement or waterlain deposit. Clasts angular to subrounded; matrix silty sand.  Overlies bedrock.  Upper limit defined by base of Whitehills Glacigenic Formation or Crovie Till Formation.  To 15m  Portknockie to Troup Head. 
BTVP  BRITISH TERTIARY VOLCANIC PROVINCE GROUP [OBSOLETE NAME AND CODE]  OBSOLETE NAME & CODE                       
ACNS  ACHNACARRY STRIPED FORMATION  PROV SHEET ENTRY  symb  AZ  NEOPROTEROZOIC                 
EIGL  EIGG LAVA FORMATION  PARTIAL ENTRY  symb  GP  PALEOCENE                 
MULP  MULL PLATEAU LAVAS FORMATION  PROV SHEET ENTRY  symb  GP  PALEOCENE  GE  EOCENE             
SEIG  SGURR OF EIGG PITCHSTONE FORMATION  PARTIAL ENTRY  symb  GP  PALEOCENE                 
CADT  CARN AN DAIMH TRANSITIONAL MEMBER  FORMAL ENTRY  symb  AZ  NEOPROTEROZOIC        Interbedded quartzite and graphitic pelite with local graded bedding.  Gradational boundary with the underlying Glen Taitneach Schist Member of the Gleann Beag Schist Formation located where psammite/quartzite becomes abundant.  Top of the interbedded quartzite/psammite and graphitic pelite succession. Base of the quartzite succession of the Creag Leacach Quartzite Formation.  70m  Carn an Daimh area. [NO 136 718] 
GBSC  GLEANN BEAG SCHIST FORMATION  FORMAL ENTRY  symb  AZ  NEOPROTEROZOIC        Mostly dark metacarbonate rock and psammite with some graphitic pelite and garnet calcareous schist passing up into graphitic pelite with thin beds of metacarbonate rock.  Base of dominantly calcareous and graphitic rocks. Stratigraphic boundary with the underlying dominantly semipelitic Tulaichean Schist Formation.  Top of dominantly graphitic rocks below the overlying dominantly quartzite succession of the Creag Leacach Quartzite Formation.  To 550m  Southern part of Sheet 65W (Braemar) and northern part of sheet 56W (Glen Shee). 
UTAN  UPPER TURBOT ANHYDRITE UNIT  CODED BUT UNDEFINED    PERMIAN                 
HAMU  HAKE MUDSTONE MEMBER  CODED BUT UNDEFINED    PERMIAN                 
MORG  MORAG MEMBER  CODED BUT UNDEFINED    PERMIAN                 
MOAN  MORAG ANHYDRITE UNIT  CODED BUT UNDEFINED    PERMIAN                 
MOCA  MORAG CARBONATE UNIT  CODED BUT UNDEFINED    PERMIAN                 
AUK  AUK FORMATION  CODED BUT UNDEFINED    PERMIAN                 
FIND  FINDHORN FORMATION  CODED BUT UNDEFINED    PERMIAN                 
FISI  FINDHORN SILTSTONE UNIT  CODED BUT UNDEFINED    PERMIAN                 
LFSA  LOWER FINDHORN SANDSTONE UNIT  CODED BUT UNDEFINED    PERMIAN                 
UFSA  UPPER FINDHORN SANDSTONE UNIT  CODED BUT UNDEFINED    PERMIAN                 
FRAS  FRASERBURGH FORMATION  CODED BUT UNDEFINED    PERMIAN                 
INVO  INGE VOLCANIC FORMATION  CODED BUT UNDEFINED    PERMIAN