1 / 34

Jane Hunter The University of Queensland

The Health-e-Waterways Project Data Integration for Smarter, Collaborative, Whole-of-Water Cycle Management. Jane Hunter The University of Queensland. Health-e-Waterways Project. Collaboration between: University of Qld (Jane Hunter) Healthy Waterways Partnership (Eva Abal )

dean
Download Presentation

Jane Hunter The University of Queensland

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. The Health-e-Waterways ProjectData Integration for Smarter, Collaborative, Whole-of-Water Cycle Management Jane Hunter The University of Queensland

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

  3. 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.

  4. Objectives • Assist with streamlining EHMP Report Card Generation • Survey key databases and models • EHMP Freshwater • EHMP Estuarine Marine • EHMP Event Monitoring • Management Action Database • Identify common conceptual model (ODM, OpenGIS, WRON-RM) • Map datasets to common model • Identify optimum data harvesting and storage • Store in SQLServer DB with Datacubes/MatLab/R scripts • Web services interface to in-situ data • Metadata harvesting -> central catalogue • Develop GoogleEarth/Virtual Earth+ontology-based query interface

  5. 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

  6. South East QueenslandWater Quality data Estuarine Marine Fresh Water Where

  7. Freshwater Data • The data is 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. FreshWater Monitoring Sites

  9. Estuarine/Marine • The data is 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 (seegrass) cover. • Sewage plume mapping • Coral Cover • Surveys are conducted monthly, biannually and annually. • Survey results will be stored in an Oracle relational database.

  10. Estuarine-Marine Monitoring • Zones of human impact • Physical and chemical parameters • Nutrient concentrations • Very spatially intense, monthly sampling • Sewage plume mapping • Maintenance of key processes • Nutrient mixing plots • Phytoplankton (microscopic plants) bioassays • Maintenance of critical habitat • Seagrass distribution/mapping • Seagrass depth ranges • Coral monitoring • Riparian

  11. Event Monitoring • Captured and managed by the Dept of NRW • >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

  12. Management Action Database (MAD) • Managed by SEQ-HWP • Track 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

  13. 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

  14. 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.

  15. 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

  16. 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

  17. 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

  18. How the Report Card is Used How is the Report Card Used? How

  19. Interactive Ecosystem Report Cards

  20. Common EHMP Ontology

  21. 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

  22. User-Driven/Ontology-based Spatio-temporal Queries 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? Give me the regions in SE Qld that contain 80% sub-tropical rainforest, are above 3000m elevation, have >-20% rainfall and contain endangered species

  23. Outcomes to 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” • EHMP Ontology - Common Observational Data Model • ODM 2.0? (CUAHSI) • The Data Conservancy Project (NSF DataNet, JHU) • Water data, climate data, vegetation, species distribution, satellite imagery • Framework for Semantic Integration of Ecosystem Health Monitoring Data

  24. Future Work • Complete Estuarine-Marine Dynamic Online Report Cards • Link monitoring data to management action database -> adapt management actions based on impact on ecosystem health • 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 • Link predictive models to integrated datasets • Visualization of model output • Estimate uncertainty/reliability of results • Actionable notification services

  25. Moreton Island March 12 2009

  26. 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

  27. Questions? http://www.health-e-waterways.org/ Contact: j.hunter@uq.edu.au

More Related