1 / 19

ADRICOSM-EXT Wrap-up meeting Roma, November 20-21, 2006

ADRICOSM-EXT Wrap-up meeting Roma, November 20-21, 2006. WP3: Data Management system Task 3.2 Organisation of a delayed mode data archiving system for the Adriatic Sea Task 3.5 GIS development for coastal areas of the Adriatic Sea. Alessandra Giorgetti , Donata Melaku-Canu & Renzo Mosetti,

thu
Download Presentation

ADRICOSM-EXT Wrap-up meeting Roma, November 20-21, 2006

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. ADRICOSM-EXT Wrap-up meeting Roma, November 20-21, 2006 WP3: Data Management system Task 3.2 Organisation of a delayed mode data archiving system for the Adriatic Sea Task 3.5 GIS development for coastal areas of the Adriatic Sea Alessandra Giorgetti, Donata Melaku-Canu & Renzo Mosetti, OGS-OGANODC/IOC & ECHO, OGS-BIO IDRO • OUTLINE • The OGS-NODC data archiving & validation system • Integration of MFS and ADRICOSM data • MEDAR/MedAtlas data format & QC protocols • Hydrological & biological data and meta-data: OGS-BIO former LBM contribution • GIS-based climatological study in the Northern Adriatic sea

  2. OGS National Oceanographic Data Centre/IOC The OGS-NODC oceanographic database includes 148 millions of measures of physical and biogeochemical parameters collected in the Mediterranean sea since the beginning of the century. Data and meta-data are archived on a Oracle relational DB and validated according to UNESCO/IOC and ICES standards. All meta-data are public while access to data follows a Data Policy. The OGS-NODC Web Portal gives access to all available information: http://nodc.ogs.trieste.it/

  3. *IO48199797001 MTP II-MATER/MAI1 MAR97 48UR URANIA 04/03/1997 17/03/1997 MEDITERRANEAN SEA 48 ISTITUTO TALASSOGRAFICO, TRIESTE Giuseppe Civitarese Project= MAST III/MTP II/MATER Regional Archiving= IO Availability=L Data Type=H09 n= 21 QC=Y Data Type=H21 n= 21 QC=Y Data Type=H25 n= 21 QC=N Data Type=H24 n= 21 QC=Y Data Type=H22 n= 21 QC=Y Data Type=H26 n= 21 QC=Y COMMENT DM=DOX1 NTRA PHOS SLCA controlled with LEVITUS98 climatological values DM=Oxygen values in mM/m3 converted to ml/l for QC MEDAR/MedAtlas format cruise header *IO48199797001A0100 Data Type=H09 *DATE=13031997 TIME=0000 LAT=N41 48.94 LON=E 17 49.88 DEPTH= 1195 QC=1111 *NB PARAMETERS=08 RECORD LINES=00019 *PRES SEA PRESSURE sea surface=0 (decibar=10000 pascals) def.=-999.9 *DOXY DISSOLVED OXYGEN (millimole/m3) def.=999.9 *NTRI NITRITE (NO2-N) CONTENT (millimole/m3) def.=99.99 *NTRA NITRATE (NO3-N) CONTENT (millimole/m3) def.=99.99 *PHOS PHOSPHATE (PO4-P) CONTENT (millimole/m3) def.=99.99 *SLCA SILICATE (SIO4-SI) CONTENT (millimole/m3) def.=99.99 *NTOT TOTAL NITROGEN (N) CONTENT (millimole/m3) def.=99.99 *TPHS TOTAL PHOSPHORUS (P) CONTENT (millimole/m3) def.=99.99 *GLOBAL PROFILE QUALITY FLAG=1 GLOBAL PARAMETERS QC FLAGS=11011100 *DC HISTORY= * *DM HISTORY= * *COMMENT = * *SURFACE SAMPLES= * *PRES DOXY NTRI NTRA PHOS SLCA NTOT TDPW station header 2.0 259.3 .08 1.87 .10 2.38 9.00 .15 11011100 5.0 257.8 .07 1.35 .10 1.57 99.99 99.99 11011199 10.0 258.2 .07 1.13 .08 1.30 14.62 .13 11011100 21.0 257.3 .07 1.17 .09 1.38 99.99 99.99 11011199 31.0 255.5 .08 1.33 .12 1.59 99.99 99.99 11011199 -999.9 999.9 99.99 99.99 99.99 99.99 99.99 99.99 99999999 data points

  4. Cruise name Ship code & name Cruise starting & ending date In the cruise header there are all meta-data related to the cruise: *IO48197979013 ASCOP 1 (ITT)48B1 BANNOCK 29/10/1979-09/11/1979 ADRIATIC SEA 48 ISTITUTO TALASSOGRAFICO, TRIESTE BREGANT Davide Project=ASCOP Regional Archiving= IO Availability=P Data Type=H09 n=23 QC=Y Data Type=H21 n=23 QC=Y Data Type=H22 n=23 QC=Y Data Type=H24 n=23 QC=Y COMMENT DM=TEMP and PSAL controlled with MODB climatological values

  5. geographic area full name of the institute responsible for the data scientist responsible for the data *IO48197979013 ASCOP 1 (ITT) 48B1 BANNOCK 29/10/1979-09/11/1979 ADRIATIC SEA 48 ISTITUTO TALASSOGRAFICO, TRIESTE BREGANT Davide Project=ASCOP Regional Archiving= IO Availability=P Data Type=H09 n=23 QC=Y Data Type=H21 n=23 QC=Y Data Type=H22 n=23 QC=Y Data Type=H24 n=23 QC=Y COMMENT DM=TEMP and PSAL controlled with MODB climatological values

  6. list of data types included in the data set comment line with cruise information *IO48197979013 ASCOP 1 (ITT) 48B1 BANNOCK 29/10/1979-09/11/1979 ADRIATIC SEA 48 ISTITUTO TALASSOGRAFICO, TRIESTE BREGANT Davide Project=ASCOP Regional Archiving= IO Availability=P Data Type=H09 n=23 QC=Y Data Type=H21 n=23 QC=Y Data Type=H22 n=23 QC=Y Data Type=H24 n=23 QC=Y COMMENT DM=TEMP and PSAL controlled with MODB climatological values

  7. Date and Time Latitude and Longitude Bottom depth List of measured parameters, with unit of measurement! In the station header there are all meta-data related to each profile: *IO4819797901300070 Data Type=H09 *DATE=02111979 TIME=1125 LAT=N45 16.90 LON=E 13 16.00 DEPTH= 31 QC=1111 *NB PARAMETERS= 4 RECORD LINES=00005 *PRES SEA PRESSURE sea surface=0 (decibar=10000 pascals) def.=-999.9 *TEMP SEA TEMPERATURE (Celsius degree) def.=99.999 *DOX1 DISSOLVED OXYGEN (ml/l) def.=99.99 *NTRA NITRATE (NO3-N) CONTENT (millimole/m3) def.=99.99 *GLOBAL PROFILE QUALITY FLAG=1 GLOBAL PARAMETER QC FLAGS=1111 *DC HISTORY= * *DM HISTORY= * *COMMENT = *Data were received with depth as reference, assimilated as pressure. * *SURFACE SAMPLES= * *PRES TEMP DOX1 NTRA

  8. QualityFlags ! In the station header there are all meta-data related to each profile: *IO4819797901300070 Data Type=H09 *DATE=02111979 TIME=1125 LAT=N45 16.90 LON=E 13 16.00 DEPTH= 31 QC=1111 *NB PARAMETERS= 4 RECORD LINES=00005 *PRES SEA PRESSURE sea surface=0 (decibar=10000 pascals) def.=-999.9 *TEMP SEA TEMPERATURE (Celsius degree) def.=99.999 *DOX1 DISSOLVED OXYGEN (ml/l) def.=99.99 *NTRA NITRATE (NO3-N) CONTENT (millimole/m3) def.=99.99 *GLOBAL PROFILE QUALITY FLAG=1 GLOBAL PARAMETER QC FLAGS=1111 *DC HISTORY= * *DM HISTORY= * *COMMENT = *Data were received with depth as reference, assimilated as pressure. * *SURFACE SAMPLES= * *PRES TEMP DOX1 NTRA

  9. Data can be downloaded by multiple search :

  10. Cruise;Station;Type;mon/day/yr;hh:mm;Longitude [degrees_east];Latitude [degrees_north];Bot. Depth [m];PRES [decibar=10000 pascals];QF;CF1W [picomole/kg];QF POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;9;0;2.423;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;10;0;2.42;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;41;0;2.249;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;76;0;2.835;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;102;0;2.279;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;151;0;1.802;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;226;0;1.317;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;300;0;0.952;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;403;0;0.64;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;502;0;0.728;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;601;0;99.999;8 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;702;0;99.999;8 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;851;0;0.651;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;1001;0;0.667;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;1203;0;0.686;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;1401;0;0.765;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;1600;0;0.844;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;1798;0;99.999;8 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;2002;0;0.919;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;2200;0;0.938;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;2404;0;0.955;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;2550;0;0.956;1 POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;2595;0;0.954;1 POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;10;0;2.767;1 POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;40;0;2.767;1 POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;76;0;2.722;1 POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;150;0;2.949;1 POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;225;0;99.999;8 POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;299;0;1.594;1 POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;401;0;1.033;1 POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;500;0;99.999;8 POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;600;0;0.684;1 POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;702;0;0.589;1 POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;851;0;0.598;1 POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;1000;0;0.698;1 POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;1199;0;0.645;1 ODV format

  11. Data Quality Control: • QC0 – Check of the format: completeness of information; • QC1 - Check of the header: date and position, duplicates; • QC2 – Check of the parameter: automatic & with data point visualization: • broad range check (min and max limits), • statistical check (reference climatology), • check for spikes, • vertical stability check. Flag scale values proportional to the level of error: 0 – No QC 1 – correct value 2 - value inconsistent with climatology 3 - dubious value 4 – false value 5 - modified value (for QC1 only)

  12. Data Quality Control:

  13. Additional hydrological & biological data and meta-data Meteorological, physical, bio-geo-chemical and biological data collected in the Gulf of Trieste since 1990 are available under request. Biological data are coded following the guidelines of NODC and the meteo-marine data classification is in agreement with WMO code. • Screenshot of project manager • Screenshot of the biological species manager

  14. Other examples of OGS-BIO former LBM data bank • Screenshot of salinity field (June 2005) • Screenshot of biological data plot

  15. Temperature fields Winter Spring Summer Autumn Salinity fields Winter Spring Summer Autumn • A GIS approach for a climatological study of temperature and salinity in the Northern Adriatic sea from Codermaz et al. • integration of SST remote sensing data, oceanographic data and meteorological data

More Related