Transcript No Slide Title

The Health-e-Waterways Project
Data Integration for Smarter, Collaborative, Wholeof-Water Cycle Management
Jane Hunter
The University of Queensland
www.healthywaterways.org
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
EHMP Estuarine/Marine
EHMP Freshwater
EHMP Event Monitoring
Example Query:
What will be the ecosystem health
outcomes of the implementation of
landscape restoration works in the
Logan Albert System by 2026?
Model scenarios, outputs
Management Actions
Remote
Sensors
SEQ Water
Bureau of
Meteorology
Landuse
Demography
Etc.
Health-e-waterways
•Web Portal
• Water Wiki
• VirtualEarth
• SensorMap
• Data Ontology and Server
• Web Services
• Data Integration
• Data Lineage
• Uncertainty Propagation
• Models and Workflows
QCIF Grid Computing &Storage
General Public
S
E
C
U
R
I
T
Y
L
A
Y
E
R
State Government
Local Governments
Water Resource
Managers
Researchers
Scientists
Hydrologists
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
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
South East Queensland
Water Quality data
Where
Fresh Water
Estuarine Marine
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.
FreshWater Monitoring Sites
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.
 Lyngbya Majuscula (seegrass) cover.
 Sewage plume mapping
 Coral Cover
 Surveys are conducted monthly, biannually and annually.
 Survey results will be stored in an Oracle relational database.
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
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
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
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
EHMP Estuarine/Marine
EHMP Freshwater
EHMP Event Monitoring
Example Query:
What will be the ecosystem health
outcomes of the implementation of
landscape restoration works in the
Logan Albert System by 2026?
Model scenarios, outputs
Management Actions
Remote
Sensors
SEQ Water
Bureau of
Meteorology
Landuse
Demography
Etc.
Health-e-Waterways
•Web Portal
• Water Wiki
• VirtualEarth
• SensorMap
• Data Ontology and Server
• Web Services
• Data Integration
• Data Lineage
• Uncertainty Propagation
• Models and Workflows
General Public
S
E
C
U
R
I
T
Y
L
A
Y
E
R
State Government
Local Governments
Water Resource
Managers
Researchers
Scientists
Hydrologists
QCIF Grid Computing &Storage
www.healthywaterways.org
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
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
Annual Ecosystem Report Cards
FRESHWATER REPORT CARD GRADES
Pumicestone Catchment
Grade history:
# combined grade for Caboolture-Pumicestone catchments
2001
C#
2002
C#
Spring 2005 (Run 7)
2003
B+ #
2004
C
2005
C+
2006
C-
2007
C-
Autumn 2006 (Run 8)
0.50
0.30
0.10

snapshot of ecosystem health
-0.10
Spring 2006 (Run 9)

A to F

insight into the effectiveness of
investments in catchment
management
Autumn 2007 (Run 10)
-0.30
-0.50
Mean
How the Report Card is Used
How is the Report Card Used?
How
Interactive Ecosystem Report Cards
Common EHMP Ontology
Interactive Ecosystem Report Card Application
Silverlight &
SPARQL
Reasoning
Virtual Earth
Query
Client
Client
Client
Web Services
Statistical
Processing
Reasoning Engine
EHMP
Ontology
Triple Store
Remote Sensor
Administrator
EHMP Databases
Jena .NET Plugin
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
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
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
Moreton Island
March 12
2009
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
Questions?
http://www.health-e-waterways.org/
Contact: [email protected]