QLD Hydrochemistry QA QC GAL v02

Abstract

The dataset was derived by the Bioregional Assessment Programme. The parent datasets are identified in the Lineage field in this metadata statement. The processes undertaken to produce this derived dataset are described in the History field in this metadata statement.

This dataset contains validated hyrochemical groundwater bore sample data with appended hydrodynamic and hydrostratigraphic data for the Galilee subregion. The dataset consists of a spreadsheet which includes field sampling data (e.g. water temperature, pH, EC, DO, alkalinity, water level and aquifer formations), sampling laboratory data (e..g. major ions, trace metals and isotopes) and desktop interpreted data (e.g. aquifer formations).

Data has been filtered based on it's hydrochemical validity following a 'Charged Balance Equation' (CBE) test where only those samples which balanced to +/- 10% were retained.

Dataset History

The spreadsheet was compiled from data sourced from the following locations:

Coulmn:

A - Row ID: Manually added as an index

B - RN: QLD Department of Natural Resources and Mining Groundwater Database Extract 20131111 (GUID: 827e70b3-29d5-4e89-8d59-a93bc499de60) - Table 'REGISTRATION', Field 'RN'

C - Old bore ID: QLD Department of Natural Resources and Mining Groundwater Database Extract 20131111 (GUID: 827e70b3-29d5-4e89-8d59-a93bc499de60) - Table 'REGISTRATION', Field 'ORIG_NAME_NO'

D - Dec lat: QLD Department of Natural Resources and Mining Groundwater Database Extract 20131111 (GUID: 827e70b3-29d5-4e89-8d59-a93bc499de60 ) - Table 'REGISTRATION', Field 'GIS_LAT'

E - Dec long: QLD Department of Natural Resources and Mining Groundwater Database Extract 20131111 (GUID: 827e70b3-29d5-4e89-8d59-a93bc499de60) - Table 'REGISTRATION', Field 'GIS_LNG'

F - Water level measure data: QLD Department of Natural Resources and Mining Groundwater Database Extract 20131111 (GUID: 827e70b3-29d5-4e89-8d59-a93bc499de60) - Table 'WATER_LEVELS', Field 'RDATE'

G - Most Recent SWL: QLD Department of Natural Resources and Mining Groundwater Database Extract 20131111 (GUID: 827e70b3-29d5-4e89-8d59-a93bc499de60) - Table 'WATER_LEVELS', Field 'MEASURMENT'

H - Uncorrected RWL: 1 second DEM value (Geoscience Australia, 1 second SRTM Digital Elevation Model (DEM) - GUID: 9a9284b6-eb45-4a13-97d0-91bf25f1187b) minus 'Most Recent SWL' (column G) value

I - Formation from bore log: Multiple sources (and GIS interpretation using location and screen depth) including:

    - QLD Dept of Natural Resources and Mines, Groundwater Entitlements linked to bores v3 20140312 (GUID: 68bbd3fb-6e2a-4088-a3dd-55cc44c2f0d6) - Table 'QLD GW Licences - Original - Final - v3.xls', Tab 'All Data', Field - 'WaterCodeSourcesList'

    - QLD Department of Natural Resources and Mining Groundwater Database Extract 20131111 (GUID: 827e70b3-29d5-4e89-8d59-a93bc499de60) - Tables include: 'STRATIGRAPHY', 'AQUIFER' and 'MONITORING BORES'

    - RPS Galilee Hydrogeological Investigations - Appendix tables B to F (original) (GUID: bfe35a54-7a71-45ec-b20e-f3bfcc8999ef) - Table 'Append B to F_ Dec2012.xlsx', Tab 'Table E-1', Field 'Identified aquifer'

    - Carmichael Coal Mine and Rail Project Environmental Impact Statement (GUID: 2a595f74-aae6-4d83-9cd7-1459247d751a)

J - Formation Name Source: Name of source material used to decide aquifer formation for each sample/bore

K - Location Group: Broad location category from GIS location

L - Chem Formation Group: Standardised aquifer formation name to be used during analysis

M - Sample date: QLD Department of Natural Resources and Mining Groundwater Database Extract 20131111 (GUID: 827e70b3-29d5-4e89-8d59-a93bc499de60) - Table 'WATER ANALYSIS', Field 'RDATE'

N to P - Interpretation of screen and bore depths from QLD Department of Natural Resources and Mining Groundwater Database Extract 20131111 (GUID: 827e70b3-29d5-4e89-8d59-a93bc499de60) - Table 'CASING', Fields 'MATERIAL', 'TOP', 'BOTTOM'

Q to AC - QLD Department of Natural Resources and Mining Groundwater Database Extract 20131111 (GUID: 827e70b3-29d5-4e89-8d59-a93bc499de60) - Table 'WATER ANALYSIS'

AD to AK - QLD Department of Natural Resources and Mining Groundwater Database Extract 20131111 (GUID: 827e70b3-29d5-4e89-8d59-a93bc499de60) - Table 'FIELD WATER QUALITY'

AL to AW - Cation and anion calculation from Q to AC data

AX to AZ - Charged Balance Equations (CBE) for QA and QC of data. Validated (passed) data has a CBE of between +/-10%.

BA to CN - QLD Department of Natural Resources and Mining Groundwater Database Extract 20131111 (GUID: 827e70b3-29d5-4e89-8d59-a93bc499de60) - Table 'WATER ANALYSIS'

Only data which passed the CBE validation test (columns AX to AZ) were retained within the spreadsheet.

Dataset Citation

Bioregional Assessment Programme (2014) QLD Hydrochemistry QA QC GAL v02. Bioregional Assessment Derived Dataset. Viewed 07 December 2018, http://data.bioregionalassessments.gov.au/dataset/e3fb6c9b-e224-4d2e-ad11-4bcba882b0af.

Dataset Ancestors

• Derived From QLD Dept of Natural Resources and Mines, Groundwater Entitlements 20131204

• Derived From QLD DNRM Hydrochemistry with QA/QC

• Derived From QLD Dept of Natural Resources and Mines, Groundwater Entitlements linked to bores v3 03122014

• Derived From RPS Galilee Hydrogeological Investigations - Appendix tables B to F (original)

• Derived From Geoscience Australia, 1 second SRTM Digital Elevation Model (DEM)

• Derived From Carmichael Coal Mine and Rail Project Environmental Impact Statement

• Derived From QLD Department of Natural Resources and Mining Groundwater Database Extract 20131111