Borehole index & interpretations | OpenGeoscience data models

The BGS borehole drilling team (Dando) in action.

The Borehole Data Model is our first database design package to be released.

This data model is designed to represent an index of boreholes linked to their geological interpretations and associated metadata.

The design also makes use of corporate dictionaries/controlled vocabularies such as the BGS Lexicon.

Why use a borehole data model?

The BGS have been using databases to manage our borehole records for over 15 years, the data models behind those systems have continually evolved over that time to provide greater efficiencies and functionality.

Here are a few of the benefits our current database provides:

  • single central location for holding millions of borehole records
  • it is possible to receive large volumes of new boreholes and quickly make that information available for use by geologists across the organisation
  • we can extract the locations for all our borehole records and view them in a GIS
  • the design of the database helps standardise information from a variety of sources
    • controlled vocabularies and logical constraints make the information more re-usable and discoverable
    • data can be formatted and extracted for a range of uses
    • clearly defined tables and columns remove the likelihood of ambiguity within the dataset
  • 'single version of the truth' — possibly the most valuable benefit in using a centralised database to manage geoscience information


Select the database platform you are most interested in or simply select the Logical Data Model only option from the following list:

The implementation scripts are available for the following relational database platforms:

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.

See also
External links