Transcript Slide 1
SeaDataNet Third plenary annual meeting Madrid, March 25-27 www.seadatanet.org Data management dedicated for assessing and modeling of the Mediterranean and Black Seas ecosystem changes (SESAME integrated project). Isaac Gertman, Denis Altukhov, Vladimir Belokopytov, Andrey Ingerov, Sissy Iona, Boris Kacenelson, Alexey Khaliulin, Irena Lunin, Catherine Maillard, Stephane Pesant, Alberto Ribotti, Denis Slipecky. Data management Team of the SESAME project Data Management Objectives: 1.Provide ready access of most SESAME data and information to the SESAME consortium as well as to the international science community, industry, educators, media, and public in a timely manner; 2.Coordinate actions of data and information services; 3.Implement common standards and effective mechanisms for collection and availability of SESAME related data: ─ historical data (public domain data and product of WP1) ─ newly collected data (product of WP2 and WP3) ─ model data (product of WP4-WP6). Mobile databases as basic tools for data management and processing • SESAME Cast database contains vertical observed profiles of physical, chemical and biological data. • SESAME Bio database contains taxonomy-related data as well as geochemical and biological bottle data. • SESAME TimeSeries database contains time series of physical, chemical and biological data observed at fixed stations. • SESAME Modeled TimeSeries contains time series of physical, chemical and biological data extracted from numerical models output. MEDACC - Mobile database for oceanographic cast data http://isramar.ocean.org.il/Download.asp MEDACC Import oceanographic data MEDATLAS format for physical and geochemical data. Excel table arranged like an ODV file, for geochemical and physical data. MS ACCESS Core database SeaBird CTD files MEDATLAS Parameter Usage Vocabulary. Unlimited number parameters. EXCEL and SURFER based graphical data presentation Export selected data to ODV generic format and MEDATLAS format MEDACC - External Quality Control Wizard •Direct connection with MEDACC DB •Auto and manual modes; •Metadata quality check (location, chronology, sea depth…); •Data quality control (climatic check, spikes, density inversion…) MEDACC External Oceanographic Analysis Tools Direct connection with MEDACC DB Sophisticated data profile charting SURFER based vertical and horizontal mapping Calculation oceanographic parameters SESAME Biology database http://isramar.ocean.org.il/SESAMEMETA/bio_login.aspx • Ms ACCESS mobile DB for taxonomy-related data as well as accompanying geochemical and biological bottle data, acquired in oceanographic cruises by casting biological nets and/or water samplers at open sea stations • Based on MEDACC DB • Import data in EurOcean format. • Export data in EXCEL spreadsheet. Time series database http://isramar.ocean.org.il/SESAMEMETA/timeseries_login.aspx • ODV collection as basic tool for observed time series and time series extracted from model output • Import to MS SQL DB on SESAME server • Online interface for data selection • Download selected data in ODV generic time series format Metadata and data accumulation and dissemination • Start from public available data • On line submission of metadata and data from SESAME partners • Import new data in integral mobile databases by SEASAME data management team. • Conversion integral MS ACCESS databases to MS SQL databases • Providing on line interface for data selection and download Scanning public available data sources in order to accumulate all SESAME relevant data. • Multiparametric data from MEDAR/MEDATLAS II + MATER Winter Summer • Post MEDAR data from World Ocean Database 2005 Coriolis ICES On line management of data flow from SESAME partners On line submission of metadata regarding data providers On line submission of metadata regarding datasets Editing of metadata by registered data providers On line interface for metadata analysis On line submission of datasets 2 1 3 SESAME accepted oceanographic data formats http://isramar.ocean.org.il/SESAMEMETA/dataformatsesame.aspx • MEDATLAS format for physical and geochemical data. This format is recommended for data obtained by CTD. • ODV excel table arranged like an ODV file, for geochemical and physical data. This format is recommended for data obtained by BOTTLE casts or ROSETTA casts where the number of observational levels is significantly lower than in a CTD cast. • EURO-OCEANS excel table for biological (taxonomy related data) and corresponding geochemical and physical data • ESEAS and ODV time series formats for oceanographic data where the data acquisition method can be interpreted as time series. Interface for data providers: Definition of parameters in terms of SDN Vocabularies P021 and P061 Metadata submission http://isramar.ocean.org.il/sesamemeta -> Submission -> Metadata & Datasets ->Login ->Submit/Select new dataset->Define parameters Online report regarding submitted metadata and datasets On line interface to SESAME data http://isramar.ocean.org.il/SESAMEMETA/default.aspx Data accessibility Download limitation • Data download is available for registered users only. • Official SESAME participants are automatically registered with their login and password from the SESAME PROGECTA website. • The availability of the data is determined by the data originator and can be classified to 3 types: – Public data is available to all registered users. – Partner only data is restricted to SESAME partners only. – Originator only data is available to the SESAME WP leaders only, and can be requested by Email to the data originator. A list of WP leaders who are given access to all data is available here. On line interfaces for SESAME-CAST DB List of cruises selected according to metadata controls • Download checkbox is active for cruises available for current user • Checked cruises are exported to ODV generic format and zipped for saving on the current user machine General information regarding particular selected cruise Thanks