ADRICOSM-EXT Wrap-up meetingRoma, November 20-21, 2006

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

WP3: Data Management systemWP3: Data Management system

Task 3.2 Organisation of a delayed mode data archiving system for the Adriatic SeaTask 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 SeaTask 3.5 GIS development for coastal areas of the Adriatic Sea

Alessandra Giorgetti, Donata Melaku-Canu & Renzo Mosetti,OGS-OGA NODC/IOC & ECHO, OGS-BIO IDRO

OGS National Oceanographic Data Centre/IOC

The OGS-NODC oceanographic database includes 148 millions148 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 PortalOGS-NODC Web Portal gives access to all available information:

http://nodc.ogs.trieste.it/http://nodc.ogs.trieste.it/

*IO48199797001 MTP II-MATER/MAI1 MAR97 48UR URANIA04/03/1997 17/03/1997 MEDITERRANEAN SEA48 ISTITUTO TALASSOGRAFICO, TRIESTEGiuseppe Civitarese Project= MAST III/MTP II/MATERRegional Archiving= IO Availability=LData Type=H09 n= 21 QC=YData Type=H21 n= 21 QC=YData Type=H25 n= 21 QC=NData Type=H24 n= 21 QC=YData Type=H22 n= 21 QC=YData Type=H26 n= 21 QC=YCOMMENTDM=DOX1 NTRA PHOS SLCA controlled with LEVITUS98 climatological valuesDM=Oxygen values in mM/m3 converted to ml/l for QC

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

MEDAR/MedAtlas format

*IO48197979013 ASCOP 1 (ITT) 48B1 BANNOCK29/10/1979-09/11/1979 ADRIATIC SEA48 ISTITUTO TALASSOGRAFICO, TRIESTEBREGANT Davide Project=ASCOPRegional Archiving= IO Availability=PData Type=H09 n=23 QC=YData Type=H21 n=23 QC=YData Type=H22 n=23 QC=YData Type=H24 n=23 QC=YCOMMENTDM=TEMP and PSAL controlled with MODB climatological values

Cruise name

Cruise starting & ending date

In the cruise header there are all meta-data related to the cruise:

Ship code & name

*IO48197979013 ASCOP 1 (ITT) 48B1 BANNOCK29/10/1979-09/11/1979 ADRIATIC SEA48 ISTITUTO TALASSOGRAFICO, TRIESTEBREGANT Davide Project=ASCOPRegional Archiving= IO Availability=PData Type=H09 n=23 QC=YData Type=H21 n=23 QC=YData Type=H22 n=23 QC=YData Type=H24 n=23 QC=YCOMMENTDM=TEMP and PSAL controlled with MODB climatological values

geographic area

full name of the institute responsible for the data scientist responsible for

the data

*IO48197979013 ASCOP 1 (ITT) 48B1 BANNOCK29/10/1979-09/11/1979 ADRIATIC SEA48 ISTITUTO TALASSOGRAFICO, TRIESTEBREGANT Davide Project=ASCOPRegional Archiving= IO Availability=PData Type=H09 n=23 QC=YData Type=H21 n=23 QC=YData Type=H22 n=23 QC=YData Type=H24 n=23 QC=YCOMMENTDM=TEMP and PSAL controlled with MODB climatological values

comment line with cruise information

list of data types included in the data set

*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

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

In the station header there are all meta-data related to each profile:

Quality Flags !

Data can be downloaded by multiple search :

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];QFPOEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;9;0;2.423;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;10;0;2.42;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;41;0;2.249;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;76;0;2.835;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;102;0;2.279;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;151;0;1.802;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;226;0;1.317;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;300;0;0.952;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;403;0;0.64;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;502;0;0.728;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;601;0;99.999;8POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;702;0;99.999;8POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;851;0;0.651;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;1001;0;0.667;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;1203;0;0.686;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;1401;0;0.765;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;1600;0;0.844;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;1798;0;99.999;8POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;2002;0;0.919;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;2200;0;0.938;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;2404;0;0.955;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;2550;0;0.956;1POEM-BC-LIWEX 95;00020;B;01/06/1995;07:30;36.6081667;-1.0055;2616;2595;0;0.954;1POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;10;0;2.767;1POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;40;0;2.767;1POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;76;0;2.722;1POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;150;0;2.949;1POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;225;0;99.999;8POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;299;0;1.594;1POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;401;0;1.033;1POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;500;0;99.999;8POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;600;0;0.684;1POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;702;0;0.589;1POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;851;0;0.598;1POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;1000;0;0.698;1POEM-BC-LIWEX 95;00030;B;01/08/1995;07:09;37.998;4.5891667;2743;1199;0;0.645;1

ODV format

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 QC1 – correct value2 - value inconsistent with climatology3 - dubious value4 – false value5 - modified value (for QC1 only)

Data Quality Control:

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

Additional hydrological & biological data and meta-data

Screenshot of biological data plot Screenshot of salinity field (June 2005)

Other examples of OGS-BIO former LBM data bank

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

Temperature fields

Winter Spring Summer Autumn

Winter Spring Summer Autumn

Salinity fields