JSON   RDF   ISO19115/ISO19139 XML

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

Data and Resources

Additional Info

Field Value
Title QLD Hydrochemistry QA QC GAL v02
Type Dataset
Language eng
Licence Creative Commons Attribution 4.0 International, http://creativecommons.org/licenses/by/4.0/, (c) Commonwealth of Australia (Bioregional Assessment Programme http://www.bioregionalassessments.gov.au), (c) Queensland Department of State Development, Infrastructure and Planning, (c) State of Queensland (Department of Natural Resources and Mines), (c) Commonwealth of Australia (Geoscience Australia) 2014, (c) RPS Australia Asia Pacific
Data Status completed
Update Frequency notPlanned
Landing Page https://data.gov.au/data/dataset/c424e7cc-ced0-498e-83e9-be2c5abe0484
Date Published 2016-03-29
Date Updated 2019-11-20
Contact Point
Bioregional Assessment Program
bioregionalassessments@environment.gov.au
Geospatial Coverage POLYGON ((0 0, 0 0, 0 0, 0 0))
Jurisdiction Queensland
Data Portal data.gov.au
Publisher/Agency Bioregional Assessment Program