Vocabularies — details

DIC_GEOCHRON_SCHEME

Dictionary to constrain geochronological schemes used in GEOCHRON_JOIN. E.g. BGS approved geochronology; British onshore Quaternary chronostratigraphy; British offshore Quaternary chronostratigraphy.

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


Sample data (rows 1 to 7 of 7)

CODE DESCRIPTION STATUS TRANSLATION DATE_ENTERED DATE_UPDATED
BGS  BGS APPROVED GEOCHRONOLOGY. SEE BGS GEOLOGICAL TIMECHART.  BGS Approved Geochronology  18-FEB-04   
Q_ON  BRITISH ONSHORE QUATERNARY CHRONOSTRATIGRAPHY  British Onshore Quaternary Chronostratigraphy  18-FEB-04   
Q_OFF  BRITISH OFFSHORE QUATERNARY CHRONOSTRATIGRAPHY  British Offshore Quaternary Chronostratigraphy  18-FEB-04   
BGS_OLD  OBSOLETE GEOCHRONOLOGY CODES  Obsolete Geochronology Codes  18-FEB-04   
NOT APPLICABLE  Not Applicable  18-FEB-04   
NOT AVAILABLE  Not Available  18-FEB-04   
NOT ENTERED  Not Entered  18-FEB-04   
OpenGeoscience
Maps and viewers
Apps
Data collections
Data downloads
Scans and photos
Web services