OR/14/061 Appendix

Watson, C, Baker, G, and Nayembil M. 2014. Open geoscience data models: end of project report. British Geological Survey Internal Report, OR/14/061.

This appendix contains a series of screenshots and diagrams that relate to the work carried out and outputs generated throughout the project.

Website screenshots

• 

  The original website, part of the BGS OpenGeoscience resource: http://www.bgs.ac.uk/opengeoscience/home.html
  http://www.bgs.ac.uk/services/dataModels/home.html

• 

  The Borehole Data Model webpage.

• 

  The original website as it was in July 2012: http://www.bgs.ac.uk/services/dataModels/home.html

• 

  The homepage for the community branded (rather than BGS) website: http://www.earthdatamodels.org

Selected data model diagrams

High level entity relationship diagram for the borehole data model.

Full entity relationship model diagram for the Borehole data model.

High level entity relationship model diagram for the Geochemistry data model.

High level entity relationship model diagram for the Lexicon of Named Rocks data model.

High level diagram for the spatial metadata data model.
Each of the child tables (light green) in the high level diagram were further explained by additional figures showing the logical structure of the data model, as shown over the next two pages.

• 

• 

Example of scripts

Sample of the SQL scripts for the creation of Borehole data model in an Oracle implementation.

Sample of the SQL scripts for the population of an Oracle implementation of the borehole data model, the data includes example dummy values as well as content for the dictionaries of controlled terms used in the design.

Example of the results from the questionnaire handed out at the 24th meeting of the Colloquium of African Geology (CAG24).

Diagram to show the components which make up a downloadable database design package.