Executive Summary

CSIRO Earth Sciences and Resource Engineering (CESRE) has developed a database called PressureDB™ to store geological data from oil and gas wells. The West Australian Geothermal Centre of Excellence (WAGCOE) have an interest in the data, which provides the community information on wells within the state including pressure, temperature, salinity and other information important to the research community. ASRDC will assist WAGCOE and other consumers of this data, by establishing a process of hosting this CESRE data in an interoperable format that will allow data querying and aggregation of data from disparate data sources that share these common data elements.

Project Overview

Problem Definition

CSIRO Earth Sciences and Resource Engineering (CESRE) maintains an internal database (PressureDB™) of drilled wells within the state and works with a number of further data sources of a similar nature. The West Australian Geothermal Centre of Excellence (WAGCOE) uses this Oracle database internally for its own research purposes and CESRE provides a service for external clients to contribute to this database for a nominal administrative cost. While some of the data that has been contributed is confidential, the majority of it is open for public use. CESRE intermittently publishes a periodical database for public use (PressureDB™ as a Microsoft Access database) which omits any confidential information. CESRE currently also freely distributes a stand-alone application (PressurePlot™) that has been designed to connect to this database and extract useful information in a visual representation. PressurePlot™ provides detailed plots of pressure, temperature, lithology, statigraphy and many other recorded parameters. CESRE would like to expand the audience it has for the well data that it provides. Additionally, WAGCOE performs studies that require working with data from a number of sources, not solely from PressureDB™. CESRE and WAGCOE would benefit from increased efficiency when working with data from these disparate sources.

Key Objectives

ASRDC will work with CESRE to achieve the following objectives:

Map a community agreed standard data model to the PressureDB™ database.

Establish a Vocabulary service for the data being shared within this data domain.

Assist CESRE with deploying the necessary services stack to share this data in an interoperable fashion.

Project Scope

The project covers the data stored currently within the pressureDB™ database that is deemed to be suitable for this data interoperability project. Since some of the data is confidential, the entire database will not be revealed. The revealed data may be a restricted view of the PressureDB™ database or it may be a separate database entirely. For this project, the data that will be revealed will be termed the CSIRO shared well data.

Key Features

The project will deliver the following:

Must-have

The project must include:

A transparent mapping between the CSIRO shared well data and a community agreed schema (CAS).

An interoperable data server (wfs/wms) set-up to host the CSIRO shared well data in the CAS.

A Vocabulary service configured to interpret the terminology used by the CSIRO shared well data according to a community agreed vocabulary.

Mechanisms to discover the data (meta-data to be harvested by Australian National Data Service (ANDS) Research Data Australia)

Should-have

A sample demonstrative service configured to consume the data shared by the geoserver instance. Note: Although this is outside of the scope of the ASRDC project, we will request assistance from the AuScope Portal development team to achieve this outcome.