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  07-APR-06  15-MAY-06 
CSLFD  CLAYSTONE, SILTSTONE AND FERRUGINOUS DOLOSTONE  Claystone, siltstone and ferruginous dolostone  05-APR-06  15-MAY-06 
SPPS  SEMIPELITE AND PSAMMITE  Semipelite and psammite  02-MAR-06  15-MAY-06 
PSSP  PSAMMITE AND SEMIPELITE  Psammite and semipelite  02-MAR-06  15-MAY-06 
SPSQ  SEMIPELITE, PSAMMITE AND QUARTZITE  Semipelite, psammite and quartzite  02-MAR-06  15-MAY-06 
PSCS  PSAMMITE AND CALCAREOUS SEMIPELITE  Psammite and calcareous semipelite  02-MAR-06  15-MAY-06 
ABAN  ANDESITE AND BASALTIC ANDESITE  Andesite and basaltic andesite  03-FEB-04  15-MAY-06 
ADOS  ARGILLACEOUS ROCK, DOLOSTONE AND SANDSTONE  Argillaceous rock, dolostone and sandstone  03-FEB-04  15-MAY-06 
AGTT  AGGLOMERATE AND TUFFITE  Agglomerate and tuffite  03-FEB-04  15-MAY-06 
ARBR  ARGILLACEOUS ROCKS AND [SUBEQUAL/SUBORDINATE] BRECCIA, INTERBEDDED  Argillaceous rocks and [subequal/subordinate] breccia, interbedded  03-FEB-04  15-MAY-06