Relational databases for geoscience data: HYDROCHEM, a case study.

Millions of data points have been acquired or compiled through both phases of the Exploring for the Future (EFTF) program at Geoscience Australia (GA). This data that graces the EFTF Portal and appears in many publications has another home within specialist databases designed and built to house the specific data that GA collects. One such database is HYDROCHEM, which was implemented as part of the Enhanced Data Delivery (EDD) and National Groundwater Systems (NGS) projects. HYDROCHEM hosts 190,097 rows of groundwater, surface water and rainfall water chemistry analyses. This data was either previously hosted in the GNDWATER database, or compiled from legacy data stores. The redevelopment of GNDWATER to HYDROCHEM saw the de-duplication and updating of sample and site-specific metadata into other GA databases, such as SAMPLES, BOREHOLES and FIELDSITES. The redevelopment also added additional constraints to the database, including minimum metadata requirements, constrained look-up tables for units of measure, laboratory, method, filter sizes, standards and uncertainty types. Other features include minimum and maximum values for particular analytes and delivery of the data in standardised GA-preferred units of measure.

Simple

Identification info

Date (Creation)
2023-04-17
Date (Publication)
2023-08-14T23:26:57
Citation identifier
Geoscience Australia Persistent Identifier/https://pid.geoscience.gov.au/dataset/ga/147856

Citation identifier
Digital Object Identifier/https://dx.doi.org/10.26186/147856

Cited responsible party
Role Organisation / Individual Name Details
Publisher

Commonwealth of Australia (Geoscience Australia)

 Voice
Author

Hawkins, S.

 MEG Internal Contact
Purpose

EFTF Extended Abstract 2023

Status
Completed
Point of contact
Role Organisation / Individual Name Details
Point of contact

Commonwealth of Australia (Geoscience Australia)

 Voice
Point of contact

Hawkins, S.

 MEG Internal Contact
Resource provider

Minerals, Energy and Groundwater Division

 External Contact
Spatial representation type
Topic category
  • Geoscientific information

Extent

Extent

N
S
E
W


Maintenance and update frequency
As needed

Resource format

Title

Product data repository: Various Formats

Website

Data Store directory containing the digital product files

Data Store directory containing one or more files, possibly in a variety of formats, accessible to Geoscience Australia staff only for internal purposes

theme.ANZRC Fields of Research.rdf

  • PHYSICAL SCIENCES

  • BUILT ENVIRONMENT AND DESIGN

  • EARTH SCIENCES

  • ENVIRONMENTAL SCIENCES

  • TECHNOLOGY

Keywords

  • Hydrochemistry

Keywords

  • HVC_144638

Project

  • EFTF - Exploring For The Future

Keywords

  • Hydrogeochemistry

Keywords

  • Databases

Keywords

  • Data

Project

  • Enhanced Data Delivery

Keywords

  • Published_External

Resource constraints

Title

Creative Commons Attribution 4.0 International Licence

Alternate title

CC-BY

Edition

4.0

Website

http://creativecommons.org/licenses/

Access constraints
License
Use constraints
License
Other constraints

(c) Commonwealth of Australia (Geoscience Australia) 2023

Resource constraints

Title

Australian Government Security Classification System

Edition date
2018-11-01T00:00:00
Website

https://www.protectivesecurity.gov.au/Pages/default.aspx

Classification
Unclassified
Language
English
Character encoding
UTF8

Distribution Information

Distributor contact
Role Organisation / Individual Name Details
Distributor

Commonwealth of Australia (Geoscience Australia)

 Voice facsimile
OnLine resource

Extended Abstract for download (pdf) [400 KB]

Extended Abstract for download (pdf) [400 KB]

Distribution format

  • pdf

Resource lineage

Statement

This extended abstract was written in April 2023 and details information from the GNDWATER and HYDROCHEM relational databases for hydrochemistry analyses. It also refers to several other GA databases which each have their own records and standards. Databases are dynamic objects and the information contained may change over time.

Metadata constraints

Title

Australian Government Security Classification System

Edition date
2018-11-01T00:00:00
Website

https://www.protectivesecurity.gov.au/Pages/default.aspx

Classification
Unclassified

Metadata

Metadata identifier
urn:uuid/39af3749-e933-4aff-ade5-d144e2447b15

Title

GeoNetwork UUID

Language
English
Character encoding
UTF8
Contact
Role Organisation / Individual Name Details
Point of contact

Commonwealth of Australia (Geoscience Australia)

 Voice
Owner

Hawkins, S

 Internal Contact
Point of contact

Hawkins, S.

 MEG Internal Contact

Type of resource

Resource scope
Document
Name

GA publication: Extended Abstract

Alternative metadata reference

Title

Geoscience Australia - short identifier for metadata record with

uuid

Citation identifier
eCatId/147856

Metadata linkage

https://ecat.ga.gov.au/geonetwork/srv/eng/catalog.search#/metadata/5167d912-6784-4371-9938-3931e84ca6f1

Metadata linkage

https://ecat.ga.gov.au/geonetwork/srv/eng/catalog.search#/metadata/39af3749-e933-4aff-ade5-d144e2447b15

Date info (Creation)
2019-04-08T01:55:29
Date info (Revision)
2019-04-08T01:55:29

Metadata standard

Title

AU/NZS ISO 19115-1:2014

Metadata standard

Title

ISO 19115-1:2014

Metadata standard

Title

ISO 19115-3

Title

Geoscience Australia Community Metadata Profile of ISO 19115-1:2014

Edition

Version 2.0, September 2018

Citation identifier
https://pid.geoscience.gov.au/dataset/ga/122551

 
 

Spatial extent

N
S
E
W


Keywords

Data Databases EFTF - Exploring For The Future Enhanced Data Delivery HVC_144638 Hydrochemistry Hydrogeochemistry
theme.ANZRC Fields of Research.rdf
BUILT ENVIRONMENT AND DESIGN EARTH SCIENCES ENVIRONMENTAL SCIENCES PHYSICAL SCIENCES TECHNOLOGY

Provided by

Access to the portal

Associated resources

Not available