Dynamic Generation of Online Interactive Ecosystem Report Cards

1. Dynamic Generation of Online Interactive Ecosystem Report Cards Jane Hunter, The University of Qld Microsoft eScience 2008

2. Overview • Background and Objectives • Architecture and Implementation • User interface and functionality • Demo • Conclusions and Future Work Microsoft eScience 2008

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 (δ15N), algal growth • Ecosystem processes - Algal growth, Ratio of carbon stable isotopes (δ13C), 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. • LyngbyaMajuscula (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 -> central catalogue • Develop VirtualEarth+ontology-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 it’s own objectives, parameters, methods and analysis What

15. Annual Ecosystem Report Cards FRESHWATERREPORT CARD GRADES Pumicestone Catchment Grade history: # combined grade for Caboolture-Pumicestone catchments • 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 Reasoning Engine Statistical Processing Triple Store EHMP Ontology Jena .NET Plugin Remote Sensor EHMP Databases Administrator

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 -> Ecosystem reports • Comparison and longitudinal trends • Wentworth Group – “an exemplar for environmental reporting”

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

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@uq.edu.au