The Australian National Groundwater Data Transfer Standard

2.2 Basic Groundwater Data

It is clear that basic data is the foundation of any subsequent analysis and interpretation. The State and Territory land and water management agencies, to fulfil their groundwater management and regulatory role, are the main custodians of this data. Measurements and observations from over 500,000 sites are stored in several databases across the country (NGC, 1998).

Table 2.2 summarises the significant databases operating in Australia. These databases use a range of software products, but Oracle is popular on Unix platforms, and likewise Access for Microsoft Windows.

Table 2.2 Summary of groundwater databases in Australia as of June, 1998 (NGC, 1998)

NameArea

Custodian

RDBMS

Platform

Interfaces

Sites

 

ACT

ACT

Environment ACT

Excel

Windows

 

900

GDS

NSW

NSW Dept Land & Water Conservation

Oracle

Unix

Gupta SQL

80,000

NT

NT

NT Dept Lands, Planning & Environment

DBase

Win NT

HydSys

30,000

GWDB

Qld

Qld Dept Natural Resources

DBQ1

Unix

DBQ, Map Objects, Visual Basic, Map Info

80,000

SA_GEODATA

SA

Primary Industries & Resources SA

Oracle

Unix

Oracle Forms

140,000

BORIS

Tas

Mineral Resources Tasmania

Access

Windows

Access

6,000

GDB

Vic

Vic Dept Natural Resources & Environment

Ingres

Unix

Windows/4GL, Ingres, Arcview

130,000

CLPR

Vic

Centre for Land Protection Research

Access

Windows

Access

3,250

AQWABase

WA

WA Water & Rivers Commission

Access

Win NT

Access

82,500

SWRIS

WA

WA Water & Rivers Commission

Fortran

IBM

Access

3,500

SiteLegaci

WA

WA Water & Rivers Commission

Access

Win NT

Access

300

Agbores/

Combores

WA

Agriculture WA

Oracle

Unix

Access, Microstation MGE/ERMA

4,000

GWATER

Aus

Bureau of Rural Sciences

Oracle

Unix

Oracle Forms, Arc/Info

5,500

1 Queensland Groundwater Database under redevelopment using Oracle 8 and Oracle Web Forms

The vast majority of data stored in these State and Territory databases are sourced from bores (eg. production bores, piezometers, test holes), as these agencies are responsible for bore registration. An investigation of the contents of these databases reveals commonality in the data that is collected and stored, such as:

  • the geographical position of the site;
  • the elevation of the site, as a reference for measurements of water levels;
  • drilling details of bores (method, depth, diameter, time);
  • construction details, particularly bore casing and screens;
  • the condition of the bore and the purpose(s) of the groundwater extracted;
  • down hole lithology and interpreted stratigraphy;
  • information on the aquifer intervals or water cuts intersected down hole;
  • water level measurements;
  • pump test summaries (actual field measurements not commonly stored);
  • rates of groundwater extraction (pumping or artesian flow); and
  • groundwater chemistry.

Other themes were less common elements of the databases. These include data like:

  • development history for a bore such as chemical or mechanical treatment;
  • subsequent bore rehabilitation or maintenance work;
  • down hole geophysical logging, with metadata defining the archive location for logs typically recorded;
  • pressure and temperature readings for artesian bores;
  • licensing arrangements (this data tends to be stored in separate administrative databases); and
  • bibliographic references to where the data originated, such as the relevant staff and organisation or the source document.

The majority of these themes are basic groundwater data that are the direct observations and measurements in both the field and the laboratory. The databases also contain data with an inherent level of interpretation, namely primary and secondary data. The estimates of transmissivity and storativity derived from pump tests fall into this category. Overall, national standards for data storage and transfer need to be defined for the contents of these databases. This is the objective of this document.

 

table of contents | figures | tables | download


This site is maintained by the Bureau of Rural Sciences

Copyright © 1999 Commonwealth of Australia
Last updated 1 July 1999 contact brs-webmaster