Western Australia Exploration Geochemistry Online
Preparing the zip for download. If you have selected a lot of holes this may take a while.
Progress: 0%
You may hide this window with the button below, but the zip will not download if you perform another search.
"Open File MDHDB" database as supplied by GSWA (May 2024 release) Please note that there are 2 versions available. The first is the original version provided in SQL 2022 format and can only be restored to an SQL 2022 or later instance. The second is a modfied version that has been migrated to SQL 2016, and can be restored to SQL 2016 or later versions.
"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 2024 release of the GSWA MDHDB database.
Read more
A Postgres backup of the subset of data tables used by this website (derived from the GSWA May 2024 release). Please note that there are 2 versions available. The first is provided in 'PSQL' format which can be restored by executing the SQL commands in Postgres. The second is a 'compressed' pg_dump, which has to be restored using the Postgres 'pg_restore' utility. Please view the 'read more' document to learn more about the different versions.
Read more
"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 2024 release of the GSWA MDHDB database.
Read more
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 - updated May 2024
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