Search and download harmonised open file surface and downhole geochemistry data

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

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

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 Nov 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 Nov 2022 release).
Read more

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 Nov 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

Tenement Data

GSWA regularly refresh Tenement datasets. See below for some brief notes on refreshing tenement data in Postgres databases.
Read more