Made available in June 2012, the geochemistry data model is the second download to be made available through the OpenGeoscience Knowledge Exchange project.
This is a simplified data model, based on the current BGS geochemistry database, which holds the results of the chemical analysis of samples from the land area of Great Britain and Northern Ireland (excluding groundwater).
We have simplified the model because we want to highlight the essence of the database without presenting an overly complex design. We have removed features and tables that relate to BGS-specific concepts that may not be relevant to others.
Please select the Geochemistry Data Model link below to get a copy of the main download:
To see an example geochemistry database using this design you can download a Microsoft Access example below:
We can also provide examples for Oracle, MySQL, PostgreSQL and SQLServer on demand.
Please acknowledge the material as:
Copyright/database right, reproduced with the permission of the British Geological Survey
© NERC 2012. All rights reserved.
Please let us know what you think about this download.
Send your questions, suggestions and thoughts, good or bad, to Carl Watson.