Search and download harmonised open file surface and downhole geochemistry data

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

"Open File MDHDB" database (Microsoft SQL Server 2016 .bak format) as supplied by GSWA (May 2023 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 May 2023 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 2023 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 May 2023 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. The tenement data on this website is refreshed on a daily basis. See below for some brief notes on refreshing tenement data in Postgres databases.
Read more