/gsq-geochem-data-migration

In place migration of Explorer3 Geochem data into GeoProps structure

Primary LanguagePythonCreative Commons Attribution 4.0 InternationalCC-BY-4.0

geopropsdb-geochem

This repository contains ETL scripts, queries, templates etc. to transfer data from the MS Access DB Whole of Queensland Geochemistry databases to the Geological Survey of Queensland's GeoPropertiesDB which is a Postgres DB Master Dataset.

This code is ultimately for one-time use only: once a successful transfer has been made, the Whole of Queensland Geochemistry databases will no longer be maintained in MS Access form or, if they are, they will be exports of the GeoPropertiesDB and thus generated from a source, not maintained as a point-of-truth.

Contents

  • db-scripts - all DB scripts
    • geochem - scripts for the core SOSA content
    • party - scripts for GeoChemDB lib_Company transfer to GeoPropsDB Party tables

License

This repository's content is licensed with the Creative Commons BY 4.0 license, a copy of the deed of which is in the LICENSE file.

Contacts

Geoscience Information Team
Geological Survey of Queensland
Department of Resources
Brisbane, QLD, Australia
geological_info@resources.qld.gov.au