Geochemistry data model

Simplified geochemistry data model diagram.

About the data model

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.

Terms of use

Terms of use: Free for commercial and non-commercial use.

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.