Open Geoscience data models

Data modelling (© iStock/spxChrome). Open Geoscience Data Models is a two-year NERC-funded knowledge exchange project that started in June 2011.

BGS OpenGeoscience data models aim to provide open, ready-to-use database designs that are free for all.

We also intend to build a self-sustaining community that will develop these designs, and add additional designs, to meet the needs of the wider environmental community.

Latest News

January 2013 — released. The new home for both BGS and other data model designs. This is a community driven site, providing free and open access to data model designs, background information and support.
October 2012 — Lexicon Data ModelLexicon Data Model now available — includes documentation and a Microsoft Access database containing examples of UK lithostratigraphical units.
June 2012 — Geochemistry Data ModelGeochemistry Data Model our second data model is now available for download.

Data model downloads

Each data model download is effectively a database design and documentation, including:

  • a plain english description of the data model structure
  • details on the design principles and terminology used
  • suggestions of how you might alter the database design to most suit your needs
  • and we also provide ways of you to easily create your own versions of the database, complete with example data

Available designs

The following geoscientific topics are just some of the designs that are available:

Example databases

The downloable data models will include explaination of how to create your own versions of teh databases using either SQL scripts or in the case of Microsoft Access we actually provide a pre-populated .mdb file:

We can provide implementation examples for:

  • Microsoft Access
  • MySQL
  • Oracle
  • PostgreSQL
  • SQL Server

Get involved

We are looking for individuals and organisations who are interested in:

  • migrating from analogue to digital records
  • upgrading database designs
  • sharing experiences of geological data modelling
  • exploring future collaborative opportunities in this area


If you have any questions or suggestions contact Carl Watson