CESRE PressureDB™ Interoperability Project

Jump straight to the implementation pages --> CESRE PressureDB™ Interoperability Project Implementation

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.

Out of Scope Key Features

The Project will not deliver the following:
  • Developing or maintaining a spatial database

Related Projects/Areas

The following projects are related to this project:
Project/Area Impact
AuScope Portal Possibility to display well data via the AuScope Portal
PressurePlot™ Stand-alone app built to consume CSIRO shared well data (in custom format)

Stakeholders

The key stakeholders have been identified as:
Name Role
CESRE Admin Key administrator and custodian of the data and the deployment
ASRDC Assist with implementing services for data interoperability deployment
CESRE Community Key end-user group
AuScope Community Benefiting end-user group
ANDS Maintains a national research data registry
General Public Consumers of CESRE Products
Allison Hortle & Christine Trefry CESRE User Representatives (Collaborator/Client)

High Level Plan

  • March 2010
    • CESRE provide PressureDB™ schema for ASRDC analysis

  • April - June 2010
    • Define data interoperability use-cases
    • CESRE provide access to test PressureDB™ database implementation\view (ex confidential data)
    • ASRDC map DB schema to community agreed standard (GeoSciML)

  • July 2010
    • Establish vocabulary for data store
    • Establish infrastructure (servers to host services)
    • Develop and test AuScope Portal consumption of test data
    • Demo test portal implementation

  • Aug - Sept 2010
    • Refine implementation to incorporate feedback from demo
    • Add functionality to meet remaining use cases
    • Train User Reps in implementation architecture
    • Establish Framework (policy/governance) for managing registry data and datasets

  • Nov - Dec 2010
    • Publish metadata to ANDS
    • Hand over activities to CESRE custodians

  • Jan - July 2011
    • ASRDC provide maintenance and support

Major Assumptions

It is assumed that:
  • CESRE and ASRDC will be able to agree on a suitable CAS for the CSIRO shared well data
  • CSIRO shared well data can be accessed externally (outside CSIRO)
  • CESRE will become custodians of the SISS deployment (excludes Vocabulary, which will be hosted by AuScope) and handle governance of its future direction

Major Constraints

The project is constrained by:
  • Completion date must be no later than Wednesday the 1st Dec 2010 (maintenance & support activities will continue until June 2011)
Topic revision: r3 - 22 Nov 2010, FlorenceTan