170 likes | 266 Vues
The BMDC’s database: a tool for scientists and decision makers. K. De Cauwer, M. Devolder, S. Jans, S. Scory MUMM | BMM | UGMM Royal Belgian Institute of Natural Sciences. 1970. 1974. 1978. 1982. 2000. 1986. 1990. 1994. 1998. MONITORING DATA (national, OSPAR, ...).
E N D
The BMDC’s database: a tool for scientists and decision makers K. De Cauwer, M. Devolder, S. Jans, S. Scory MUMM | BMM | UGMM Royal Belgian Institute of Natural Sciences
1970 1974 1978 1982 2000 1986 1990 1994 1998 MONITORING DATA (national, OSPAR, ...) National Scientific programmes* and other projects SEA ARC Impulse SMNS IDOD Sustainable Management of the North Sea (1997-2002) : 17 projects and 31 scientific teams * funded by the Belgian Federal Office for Scientific, Technical and Cultural Affairs data management at MUMM Context
the IDOD project • Integrated and Dynamical Oceanographic Data Management • Objective : to establish high quality and long-lasting marine data management services, in order to fulfill the present and future needs of a broad range of users Context
Historical data Sedimentological characteristics Pipelines, navigation routes, ... Contaminant data Pathology/ Ecotoxicology Biodiversity Eutrophication Biological effects Physico-chemical parameters Optical properties IDOD
First step - development of the database From the analysis of • data types • meta data (time, position, methodology, quality control, …) • data catalogues (EDMED, EDMERP, CSR, ...) • user needs And discussions with • data providers • data managers To ... Database
… one relational database structure Oracle8i Database
Niskin bottle boxcorer Fishing net Eye/binocular Water values Biota subsamples Sediment subsamples Densities Nitrate : 75 µmol/l 0-10 cm depth 5 Atlantic cod specimens average weight : 446 g 2.2 Black-headed Gulls/km² Tissue Observations Sediment values Liver tissue with 58 % lipid weight CB101 : 0.00202 µg/g dry weight (< 63 µm) presence of parasites Biota values CB101 = 0.18628 µg/g lipid weight Campaigns BE2000/03 Sampling events Station 700 - 7/02/2001 09:56 Samples Database
Statistical analysis Spatial analysis KUL-University Center of statistics internet ULg- SURFACES Users From database to information system Quality control Raw Data Data base Statistical Q.C. From database to information system
Tools(based on SPLUS & ArcIMS) Values, Plots, Reports, Maps, ... From database to information system
Case study Eutrophication assessment • OSPAR Comprehensive Procedure for the Identification of the eutrophication status of the OSPAR maritime area • Objective : to get and to report to policy makers a comparable vision of the eutrophication status of the North Atlantic marine waters Application to international assessments/policy making
OSPAR Eutrophication assessment criteria • Adopted by OSPAR in 2002 • Applied by Contracting Parties in summer 2002 • For Belgium, report made by MUMM with assistance from ULB - ESA (OSTC contract) and and/or Application to international assessments/policy making
Data selection Application to international assessments/policy making
Statistical analysis Application to international assessments/policy making
Eutrophication assessment 1998 Application to international assessments/policy making
Eutrophication assessment 1995 Application to international assessments/policy making
Final note BMDC’s Information system proves to be an efficient tool : • Easy retrieval, combination and analysis of data • data products for international assessments and policy making • Online access • available for a wide range of users
If you want more …? • Welcome at our demonstration ! • Or try it : http://www.mumm.ac.be/datacentre/ • Or contact us : bmdc@mumm.ac.be