Vocabularies — details

DIC_ROCK_COMPOSITE

Part of version 3 of the BGS Rock Classification Scheme. This table holds the code (e.g. IBSDSS) and description (e.g. interbedded sandstones and siltstones with mudstone lenses in the sandstone) of the composite.

No. Column name Data type Notes
1 COMPOSITE_CODE Varchar(6) Primary key
2 DESCRIPTION Varchar(500)  
3 TRANSLATION Varchar(500)  
4 STATUS Char(1)  
5 DATE_ENTERED Date  
6 DATE_UPDATED Date  


Sample data (rows 1 to 10 of 545)

COMPOSITE_CODE DESCRIPTION TRANSLATION STATUS DATE_ENTERED DATE_UPDATED
TDTTB  TRACHYDACITIC TUFF AND TRACHYDACITIC TUFF-BRECCIA  Trachydacitic tuff and trachydacitic tuff-breccia  C  07-APR-06  15-MAY-06 
CSLFD  CLAYSTONE, SILTSTONE AND FERRUGINOUS DOLOSTONE  Claystone, siltstone and ferruginous dolostone  C  05-APR-06  15-MAY-06 
SPPS  SEMIPELITE AND PSAMMITE  Semipelite and psammite  C  02-MAR-06  15-MAY-06 
PSSP  PSAMMITE AND SEMIPELITE  Psammite and semipelite  C  02-MAR-06  15-MAY-06 
SPSQ  SEMIPELITE, PSAMMITE AND QUARTZITE  Semipelite, psammite and quartzite  C  02-MAR-06  15-MAY-06 
PSCS  PSAMMITE AND CALCAREOUS SEMIPELITE  Psammite and calcareous semipelite  C  02-MAR-06  15-MAY-06 
ABAN  ANDESITE AND BASALTIC ANDESITE  Andesite and basaltic andesite  C  03-FEB-04  15-MAY-06 
ADOS  ARGILLACEOUS ROCK, DOLOSTONE AND SANDSTONE  Argillaceous rock, dolostone and sandstone  C  03-FEB-04  15-MAY-06 
AGTT  AGGLOMERATE AND TUFFITE  Agglomerate and tuffite  C  03-FEB-04  15-MAY-06 
ARBR  ARGILLACEOUS ROCKS AND [SUBEQUAL/SUBORDINATE] BRECCIA, INTERBEDDED  Argillaceous rocks and [subequal/subordinate] breccia, interbedded  C  03-FEB-04  15-MAY-06