Search and download harmonised open file surface and downhole geochemistry data

GSWA open file (May 2022 - used by this website)

"Open File MDHDB" database (Microsoft SQL Server 2016 .bak format) as supplied by GSWA (May 2022 release)

GSWA open file (November 2022)

This website is currently based on the May 2022 GSWA dataset. We are currently processing the November 2022 dataset and the website will be updated when that is done. In the meantime, the GSWA Open File MDHDB for November 2022 is available for download below.

Pivot dataset (SQL Server)

"All of WA harmonised & pivoted Assays" dataset (Microsoft SQL Server .bak format). This dataset provides harmonised and pivoted data (all analytes) for all of WA Downhole (DH) and Surface (SS) assays derived from the May 2022 release of the GSWA MDHDB database.
Read more

Postgres Dataset

A Postgres format backup (zipped) of the subset of data tables used by this website (derived from the GSWA May 2022 release).

Pivot dataset (Postgres)

"All of WA harmonised & pivoted Assays" dataset (Postgres backup format). This dataset provides harmonised and pivoted data (all analytes) for all of WA Downhole (DH) and Surface (SS) assays derived from the May 2022 release of the GSWA MDHDB database.
Read more

Analyte matching

Data in the 'geochemistry tables' in the database have been harmonised by standardising company analyte names and units

Download the Analyte Matching table used in the harmonisation process