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 Icon - link to download Geochemistry data modeldownload now More Information Icon - link to more information about Geochemistry data modelmore information
Geochemistry data model - MS Access
Example of geochemistry database design in MS Access
[Zipped Archive 176 KB]
Download Now Icon - link to download Geochemistry data model - MS Accessdownload now More Information Icon - link to more information about Geochemistry data model - MS Accessmore 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 Icon - link to download Open Geoscience Data Model for Boreholes - for MS Accessdownload now More Information Icon - link to more information about Open Geoscience Data Model for Boreholes - for MS Accessmore 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 Icon - link to download Open Geoscience Data Model for Boreholes - for MySQLdownload now More Information Icon - link to more information about Open Geoscience Data Model for Boreholes - for MySQLmore 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 Icon - link to download Open Geoscience Data Model for Boreholes - for Oracledownload now More Information Icon - link to more information about Open Geoscience Data Model for Boreholes - for Oraclemore 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 Icon - link to download Open Geoscience Data Model for Boreholes - for PostgreSQLdownload now More Information Icon - link to more information about Open Geoscience Data Model for Boreholes - for PostgreSQLmore 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 Icon - link to download Open Geoscience Data Model for Boreholes - for SQLServerdownload now More Information Icon - link to more information about Open Geoscience Data Model for Boreholes - for SQLServermore 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 Icon - link to download Open Geoscience Data Model for Boreholes - logical model onlydownload now More Information Icon - link to more information about Open Geoscience Data Model for Boreholes - logical model onlymore 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 Icon - link to download Open Geoscience Data Model for Lexicon - for MS Accessdownload now More Information Icon - link to more information about Open Geoscience Data Model for Lexicon - for MS Accessmore 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 Icon - link to download Open Geoscience Data Model for Lexicon - logical model onlydownload now More Information Icon - link to more information about Open Geoscience Data Model for Lexicon - logical model onlymore information