Browsing downloads in "Data models"

BGS Open Geoscience Data Models aim to provide open, ready-to-use database designs that are free for all.

Geochemistry data model
Documentation for geochemistry database design
[Zipped Archive 554 KB]
download now more information
Geochemistry data model - MS Access
Example of geochemistry database design in MS Access
[Zipped Archive 176 KB]
download now more information
Open Geoscience Data Model for Boreholes - for MS Access
Database design package containing a logical data model for an index of boreholes linked to their geological interpretations and associated metadata. This download also includes an MS Access database implementation of the data model.
[Zipped Archive 232 KB]
download now more information
Open Geoscience Data Model for Boreholes - for MySQL
Database design package containing a logical data model for an index of boreholes linked to their geological interpretations and associated metadata. This download also includes a MySQL database implementation of the data model.
[Zipped Archive 181 KB]
download now more information
Open Geoscience Data Model for Boreholes - for Oracle
Database design package containing a logical data model for an index of boreholes linked to their geological interpretations and associated metadata. This download also includes an Oracle database implementation of the data model.
[Zipped Archive 195 KB]
download now more information
Open Geoscience Data Model for Boreholes - for PostgreSQL
Database design package containing a logical data model for an index of boreholes linked to their geological interpretations and associated metadata. This download also includes a PostgreSQL database implementation of the data model.
[Zipped Archive 195 KB]
download now more information
Open Geoscience Data Model for Boreholes - for SQLServer
Database design package containing a logical data model for an index of boreholes linked to their geological interpretations and associated metadata. This download also includes an SQLServer database implementation of the data model.
[Zipped Archive 198 KB]
download now more information
Open Geoscience Data Model for Boreholes - logical model only
Documentation describing the logical data model for an index of boreholes linked to their geological interpretations and associated metadata. This data model could be used as the basis for a database design.
[Zipped Archive 145 KB]
download now more information
Open Geoscience Data Model for Lexicon - for MS Access
This folder contains a Microsoft Access implementation of a Lexicon database, it has been populated with example data from the BGS Lexicon of Named Rock Units and also comes with technical documentation that describes each element of the design.
[Zipped Archive 495 KB]
download now more information
Open Geoscience Data Model for Lexicon - logical model only
This folder contains clear documentation that describes the logical structure of a Lexicon Data Model.
[Zipped Archive 1.83 MB]
download now more information
Open Geoscience Data Models - implementation of Metadata database in MS Access
The Metadata Database implementation in MS Access contains a Microsoft Access file with example data and technical documentation which describes a simplified version of the existing BGS metadata database, which is ISO19115 /Inspire compliant. The data model and Access database is free to use and is complimented by the MetaDatabase_Summary download which contains high level summary documentation about the design.
[Zipped Archive 461 KB]
download now more information
Open Geoscience Data Models - summary documents for Metadata database
The Metadata Database summary documents describe a how the BGS have produced a simplified version of our internal ISO19115 /Inspire compliant metadata database. It is free to use an is complimented by the associated MetaDatabase_Access download which contains a Microsoft Access implementation of the design.
[Zipped Archive 588 KB]
download now more information