Speaker: Florian M. Schwandner

1. Speaker: Florian M. Schwandner Colorado State University, Fort Collins CO, USAChair, WOVOdat Technical Advisory Group Chief Editor, WOVOdat Editorial Committee Member, WOVOdat Leadership Team & Steering Committee http://www.atmos.colostate.edu/chemistry/wovo/logon.html RSS: http://www.atmos.colostate.edu/chemistry/wovo/WOVOdat/rss/WOVOdatnews.xml

2. Speaker: Florian M. Schwandner Colorado State University, Fort Collins CO, USAChair, WOVOdat Technical Advisory Committee Co-Chief Editor, WOVOdat Editorial Board Member, WOVOdat Leadership Team & Steering Committee http://www.atmos.colostate.edu/chemistry/wovo/logon.html RSS: http://www.atmos.colostate.edu/chemistry/wovo/WOVOdat/rss/WOVOdatnews.xml

3. Venezky Weertmann Schwandner (student) Cervelli Malone Selva Schilling Ueda Newhall Marzocchi Stroker Fujita • Authors:WOVOdat tech committee & leaders • Florian M. Schwandner CSU, CO, USA • Dina Y. Venezky USGS Volcano Hazards Program, USA • Jacopo Selva INGV Italy • Hideki Ueda NIED, Japan • Daniel P. Cervelli WOVOdat consultant, New Zealand • Bruce Weertmann IRIS, USA • Kelly Stroker NGDC NOAA, USA • Stephen D. Malone U of Washington, USA • Eisuke Fujita NIED, Japan • Warner Marzocchi INGV, Italy • Steven P. Schilling USGS Cascades Volcano Observatory, USA • Christopher G. Newhall USGS Cascades Volcano Observatory, USA

4. Volcano observatory rationale & mission: the business needs • What do we want to know to feel safe around volcanoes : • What could happen? • When & for how long? • Do I have to leave, and, • when can I come back? • Could I be warned too • late, not at all, falsely? • This is what we need to know • to feel safe around • volcanoes : • Scientific understanding of processes, symptomatic pattern recognition (monitoring); • epidemiological forecasting, activity characteristics, hazard assessment; • Mitigation of human and infrastructure impact of volcanic activity, decision-making structure, relief logistics; • Reliability and accountability uncertainty concept (accuracy, forecast precision)

5.  appropriate predictions available in medical science, not for volcanoes - time & cost saving - efficiency & accuracy  live saving How to forecast a springtime cold and its eruptions • Monitoring  Analysis  Predictions • early symptoms monitoring •  assessment and prediction; possibly forecast • epidemiological databases(multidisciplinary ) past diagnoses, historic case studies • patient file with individual history VDAP* Volcano response to the Mount Pinatubo crisis in the Philippines. USGS and PHIVOLCS personnel install a seismic station near Mount Pinatubo six weeks before the devastating eruptions. Installation of a monitoring network is a team effort. -- USGS * (U.S. Internat’l Volcano Disaster Assistance Program, established after the 1984-85 Navadop del Ruiz, Colombia eruptions, lahars)

6. 1 from WOVO to WOVOdat WOVO: ca. 70 volcano observatories globally !(WOVOdat < IAVCEI Commission< IUGG Association)

7. Data sources: volcano observatory data flow • “Volcano observatories acquire multidisciplinary data” • Data types (examples): • imagery (satellite, ground, IR, radar) • sound (seismic waves) • deformation (tilt, uplift, etc.) • narratives (visual observations, e.g. tree kill) • gas chemistry, hydrology • geology (eruptive history & styles) • Result: Data jungle of multiple formats, frequency, density, resolution… Volcano monitoring techniques (USGS)

8. USGS Hawaiian Volcano Observatory Data sources: volcano observatory data management • “Volcano observatories combine interdisciplinary expert knowledge “ • Multidisciplinary data sets – differing in: • Format • Frequency • Density • Resolution • Terminology • Scale • Result: “Data Stretching ” in times of crisis

9. degassing deformation seismicity geology data visualization process modeling analysis hazard assm’t correlation statistics, patterns Users(observatories, decision-makers) forecast Global volcano observatory data management using WOVOdat • WOVOdat: data of volcanic unrest • geo-relational database • user-friendly • Internet-based • global • query & analysis tools • multidisciplinary • multi-format • open-source potato diagram WOVOdat

10. 2 Use, function and coverage of WOVOdat

11. WOVOdat tools • Using WOVOdat: • Single-volcano data monitoring • and analysis (symptoms): • visualization on same screen • Comparison to prior similar • events (epidemiology) • Postulation and testing of • hypothesis on active process • (diagnosis) • Data dissemination, outreach • “remote volcano disaster assistance” An Internet GIS-type visualization of WOVOdat-type data (Geowarn, EU)

12. Efficiency through harmonization Nisyros volcano (Greece):: IKONOS 1-m resolution sattelite image draped over DTM, superimposed are CO2-flux data (peaks) in the crater, correlated with ground temperatures (peak coloring). GEOWARN 2003 (Hurni et al., 2004)

13. 3 Structure of WOVOdat

14. Georelational database: schema Venezky & Newhall 2007: WOVOdat 1.0 http://pubs.usgs.gov/of/2007/1117/

15. Data importation: staging table / flat files, conventions Syntax convention: ab_cde_fgh Venezky & Newhall 2007: WOVOdat 1.0 http://pubs.usgs.gov/of/2007/1117/

16. Data tables: centers around the “volcano tables” • WOVOdat table groups: • Volcano • Eruption • Seismic • Deformation • Gas • Hydrology • Potential Fields • Thermal • Inferred Processes • Common/shared • Data problems: • ownership, grace period • frequency • admin vs. data retrieval Venezky & Newhall 2007: WOVOdat 1.0 http://pubs.usgs.gov/of/2007/1117/

17. Data tables: common/shared tables: junction tables • WOVOdat tables:link volcano tables to observatory tables • Bibliography • Contacts • Permissions • Maps • Registry • … Venezky & Newhall 2007: WOVOdat 1.0 http://pubs.usgs.gov/of/2007/1117/

19. Schwandner et al., 2004 Structure snippet of WOVOdat

20. 4 Status

21. WOVOdat today • Current status: • relational database structure is finalized (WOVOdat 1.0) • pilot study is under way (NIED/Japan and INGV/Italy) • server in Japan, using MySQL • administrative structure has been built • file transfer: staging table format being defined, xml • Next steps: • API programming • adapting existing visualizations • defining first application modules to be outsourced to interested groups • define long-term funding and institutional host http://www.atmos.colostate.edu/chemistry/wovo/logon.html RSS: http://www.atmos.colostate.edu/chemistry/wovo/WOVOdat/rss/WOVOdatnews.xml

22. Administrative structure of a global database • Political decisions: • Steering Committee (23 member, international) • Leadership team of 5 (Malone, Marzocchi, Newhall, Schwandner, Venezky) • Formats, modules, & imports: • Technical Adisory Committee • application modules management • philosophy: db independence of source formats AND submissions independent of db • staging table approach defines a de-facto global data format • xml based statements • statements follow a simple set of rules (hierarchical classes) • Content and attribute changes: The WOVOdat editorial board • point-contact domain experts (chief editor, domain chief editors) • associate editors, outsourcing of evaluations to “reviewers” • functions alike journal reviews

24. Schwandner et al., 2004 Structure snippet of WOVOdat