Open Geoscience data models
BGS OpenGeoscience data models aim to provide open, ready-to-use database designs that are free for all.
We also intend to build a self-sustaining community that will develop these designs, and add additional designs, to meet the needs of the wider environmental community.
Latest News
EarthDataModels.org released. The new home for both BGS and other data model designs. This is a community driven site, providing free and open access to data model designs, background information as well as support through our discussion forum..
Lexicon Data Model now available — includes documentation and a Microsoft Access database containing examples of UK lithostratigraphical units.
Geochemistry Data Model our second data model is now available for download.Data model downloads
Each data model download is effectively a database design and documentation, including:
- a plain english description of the data model structure
- details on the design principles and terminology used
- suggestions of how you might alter the database design to most suit your needs
- and we also provide ways of you to easily create your own versions of the database, complete with example data
Available designs
The following geoscientific topics are just some of the designs that are available:
- borehole index
- borehole interpretations
- collections management
- hydrogeology
- landslides
- lithostratigraphical lexicon
- geochemistry
- rock classification
Example databases
The downloable data models will include explaination of how to create your own versions of teh databases using either SQL scripts or in the case of Microsoft Access we actually provide a pre-populated .mdb file:
We can provide implementation examples for:
- Microsoft Access
- MySQL
- Oracle
- PostgreSQL
- SQL Server
Get involved
We are looking for individuals and organisations who are interested in:
- migrating from analogue to digital records
- upgrading database designs
- sharing experiences of geological data modelling
- exploring future collaborative opportunities in this area
Contact
If you have any questions or suggestions contact Carl Watson
