Vocabularies — details

DIC_ROCK_COMPOSITE

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

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 
OpenGeoscience
Maps and viewers
Apps
Data collections
Data downloads
Scans and photos
Web services