Dynamic Generation of Online Interactive Ecosystem Report Cards

1
Dynamic Generation of Online Interactive
Ecosystem Report Cards
Jane Hunter, The University of Qld
2
Overview

• Background and Objectives
• Architecture and Implementation
• User interface and functionality
• Demo
• Conclusions and Future Work

3
Health-e-Waterways Project

• Collaboration between
• Microsoft Research (Catharine van Ingen)
• Healthy Waterways Partnership (Eva Abal)
• DNRW, EPA, Local Councils, Universities
• University of Qld (Jane Hunter)
• 3 years funding MSR, ARC Linkage, SmartState
• Integrated Water Information Management for
  SEQ-HWP

4
Where are we?

• Fast growing population
• Severe water shortages
• Sensitive ecosystems
• Climate change and drought

5
Implemented a cost-effective and integrated
regional monitoring programme
254 estuarine and marine sites (sampled monthly)
127 freshwater sites (sampled 2x/yr)
6
Health-e-Waterways Databases

• FreshWater EHMP - Dept. Natural Resources and
  Water (DNRW)
• Estuarine Marine EHMP - EPA
• Event Monitoring DNRW
• Management Action Database SEQ-HWP
• Models many different sources/locations
• Receiving Water, EMSS, E2

7
Freshwater Data

• The data is being captured and managed by DNRW
• 127 freshwater sites across the catchments.
• 16 Indicators from 5 categories
• Physical and chemical pH, Conductivity, temp,
  dissolved O2
• Nutrients - Ratio of nitrogen stable isotopes
  (d15N), algal growth
• Ecosystem processes - Algal growth, Ratio of
  carbon stable isotopes (d13C), Benthic
  respiration (R24) Primary production GPP
• Aquatic macroinvertebrates No. taxa, PET,
  SIGNAL
• Fish- of native species expected (PONSE),
  Observed to expected native species (O/E50),
  Proportion of alien fish
• Surveys are conducted every 6 months, spring and
  autumn.
• Survey data stored in Oracle relational database.
  

8
Estuarine/Marine

• The data is being captured and managed by the
  Environmental Protection Agency
• 254 Sites in South East Queensland
• 168 sites from 19 estuaries
• 86 from Moreton Bay
• 14 Indicators
• Turbidity , Salinity, Temperature, Dissolved
  Oxygen, pH, Secchi depth, Nitrogen, Phosphorus
  and Chlorophyll.
• Lyngbya Majuscula (seaweed) cover.
• Sewage plume mapping
• Coral Cover
• Surveys are conducted monthly, biannually and
  annually.
• Survey results will be stored in an Oracle
  relational database.

9
Event Monitoring

• The data is being captured and managed by the
  Dept of NRW
• 60 to 100 sites across South East Queensland
• Proprietary software known has HYDSTRA by the
  Kisters group is used to store the data
• Compressed files store time-series data for each
  site
• River height, Daily Min/Mean/Max flow
• Pollutants
• Events - floods
• Supporting information is also stored
• E.g. water parameters, survey technicians
• Raw data is less useful than interpreted data

10
Management Action Database (MAD)

• Managed by SEQ-HWP
• Tracks Action Plans that are part of the Healthy
  Waterways Strategy
• Approximately 550 actions are stored in the
  database
• 2003 Access database
• Access relational tables back-end
• Access forms front-end
• Interface and actions is organised through a 4
  tier hierarchy

11
Models

• Many different models used for catchment
  hydrology
• The model simulations forecast and emulate
  climate scenarios
• Written in many different languages for a variety
  of purposes and users - Fortran
• Focus on 3 Models
• EMSS (Environmental Management Support System)
  Catchment Model
• Receiving Water Model
• E2

12
EHMP Estuarine/Marine
EHMP Freshwater
General Public
Example Query What will be the ecosystem health
outcomes of the implementation of landscape
restoration works in the Logan Albert System by
2026?
EHMP Event Monitoring
S ECURITY LAYER
Model scenarios, outputs
State Government
Management Actions

• Health-e-Waterways
• Web Portal
• Water Wiki
• VirtualEarth
• SensorMap

Local Governments
SEQ Water
Remote Sensors
Water Resource Managers
Bureau of Meteorology
Researchers
Scientists Hydrologists

• Data Ontology and Server
• Web Services
• Data Integration
• Data Lineage
• Uncertainty Propagation
• Models and Workflows

Landuse
Demography
QCIF Grid Computing Storage
Etc.
13
Approach

• Streamline Annual EHMP Report Card Generation
• Search, analysis, reporting interface to
  integrated databases
• Identify common conceptual model (ODM, OpenGIS,
  WRON-RM)
• Map datasets to common model
• Identify optimum data harvesting and storage
• Store in SQLServer DB or Jena
• Web services interface to in-situ data
• Metadata harvesting -gt central catalogue
• Develop VirtualEarthontology-based query
  interface

14
What is the Report Card?

• Publicised output of the SEQ Healthy Waterways
  Partnership
• Easy-to-understand snapshot of ecosystem health
• A to F
• Provides an insight into the effectiveness of
  investments in waterway and catchment management
• Split into two reporting zones, freshwater and
  estuarine/marine
• Each has its own objectives, parameters, methods
  and analysis

What
15
Annual Ecosystem Report Cards
FRESHWATER REPORT CARD GRADES Pumicestone
Catchment Grade history combined grade for
Caboolture-Pumicestone catchments
2001 2002 2003 2004 2005 2006 2007
C C B C C C- C-

• snapshot of ecosystem health
• A to F
• insight into the effectiveness of investments in
  catchment management

16
How the Report Card is Used
How is the Report Card Used?
How
17
CUAHSI HydroSeek - Water Quality in Moreton Bay
18
Common EHMP Ontology
19
Interactive Ecosystem Report Card Application
Reasoning Client
Silverlight Virtual Earth Client
SPARQL Query Client
Web Services
Statistical Processing
Reasoning Engine
Triple Store
EHMP Ontology
Jena .NET Plugin

Remote Sensor
EHMP Databases
Administrator
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
Interactive Ecosystem Report Cards
27
Outcomes

• Common Observational Data Model
• ODM 2.0?
• Water data, climate data, vegetation, species
  distribution, satellite imagery
• Framework for Semantic Integration of Ecosystem
  Health Monitoring Data
• ICT Framework for Web-based Environmental
  Reporting
• Standardized methods for measuring and
  aggregating indicators -gt Ecosystem reports
• Comparison and longitudinal trends
• Wentworth Group an exemplar for environmental
  reporting

28
(No Transcript)
29
Future Work

• Link monitoring data to management actions
• Integration of
• MODIS satellite data, BoM climate data
• Real-time sensor data
• Community data ReefCheck, CoralWatch, Caring
  for Country
• Socio-economic data - demographics
• Extend to Great Barrier Reef /Centre for Marine
  Studies
• Analytical services
• correlate ground data to derived data from
  satellite images
• Linking predictive models to integrated datasets
• Visualizations of model output
• Estimate uncertainty/reliability of results
• Ranked search results

30
(No Transcript)
31
User-Driven/Ontology-based Spatio-temporal
Queries

• Combine monitoring data Model outputs
  socio-economic models/data
• How will the mandatory adoption of rainwater
  tanks in the Logan Region effect domestic water
  requirements in 5 years time, taking into account
  the effects of climate change and population
  growth in the region?
• What impact will a 20mill sewage treatment
  plant upgrade have on on the prawn industry in
  the Logan Estuary if implemented now?

32
Acknowledgements

• Abdul Alabri University of Qld
• Microsoft Research Catharine van Ingen, Bora
  Beran
• Healthy Waterways Partnership Eva Abal, Jo
  Burton, Dave Moffat
• CUAHSI Dave Maidment, Michael Piasecki
• CSIRO Simon Cox, AWRIS

33
Questions?

• http//www.health-e-waterways.org/
• Contact j.hunter_at_uq.edu.au