From Geoscience Australia
JSON format icon JSON RDF format icon RDF ISO19115-3 XML

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

Created 17/10/2025

Updated 17/10/2025

JSON format icon JSON RDF format icon RDF ISO19115-3 XML

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.

Files and APIs

Tags

Additional Info

Field Value
Title Relational databases for geoscience data: HYDROCHEM, a case study.
Language eng
Licence Not Specified
Landing Page https://data.gov.au/data/dataset/e5d4ead1-f3fd-4886-935d-75de4321cc94
Contact Point
Geoscience Australia Data
clientservices@ga.gov.au
Reference Period 08/04/2019
Geospatial Coverage
Map data © OpenStreetMap contributors
{
  "coordinates": [
    [
      [
        112.0,
        -44.0
      ],
      [
        154.0,
        -44.0
      ],
      [
        154.0,
        -9.0
      ],
      [
        112.0,
        -9.0
      ],
      [
        112.0,
        -44.0
      ]
    ]
  ],
  "type": "Polygon"
}
Data Portal Geoscience Australia

Data Source

This dataset was originally found on Geoscience Australia "Relational databases for geoscience data: HYDROCHEM, a case study.". Please visit the source to access the original metadata of the dataset:
https://ecat.ga.gov.au/geonetwork/srv/eng/csw/dataset/relational-databases-for-geoscience-data-hydrochem-a-case-study