Borehole index & interpretations

Highlevel simplified data model diagram for boreholes.

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 the 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:


If you have any suggestions you would like to share please contact Carl Watson

Please let us know what you think about this data model and whether you have an alternative design, we would be particularly interested in designs for 'deviated boreholes'.

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.