Operational integration of biodiversity and physico-chemical data: experience at the BMDC

Meerhaeghe A., De Cauwer K., Devolder M., Jans S., Scory S.

SMNS I as the catalyst of IDOD

Analysis and design of the information system

Data flow from originator to end user

Integrated and Dynamical Oceanographic Data Management

IDOD so far …

Current projects to push IDOD to its limits

Gilson’s collection

Offshore wind farm

Organigram of Mumm

Royal Belgian Institute of Natural Sciences (RBINS), is as part of the Belgian Federal Science Policy, a Federal State institution involved in important scientific research activities and carrying out public service missions

The Management Unit of the North Sea Mathematical Models and the Scheldt estuary (MUMM), is a department of RBINS. MUMM adopts a 'triple M' strategy: Monitoring, Modelling and Management

Belgian Federal Science Policy, has his mission in the preparation, execution and evaluation of science policy and its extensions and the development of a permanent knowledge resource within scientific and technical spheres at the service of the Federal Authority

The Belgian Marine Data Centre, is a group of scientists within MUMM, whose expertise is oriented towards the management and the analysis of marine environmental data. Hosting currently two online databases IDOD (Integrated and Dynamical Oceanographic Data Management) and ODAS (Oceanographic Data Acquisition System) and different research programmes like Revamp and SPSD I and II

1 / 7

IDOD 17 projects and 31 scientific teams

19821978 1986 1990 1994 1998 200019741970

MONITORING DATA (national, OSPAR, ...)

ARC Impulse SMNS ISEA

2002

SMNS II

Revamp

ODAS

2004

National Scientific programmes and other projects

23 projects and 62 scientific teams

SMNS I as the catalyst of IDODConditions: Coherent data set with high quality design and well documented

Safe storage of data for future research (new analysis techniques)

Performant analysis tools

Objectives: To provide structured, homogenized and validated oceanographic data necessary for any scientific research, decision making and sustainable development

To establish, manage and promote an integrated database of marine environmental data, ensuring a smooth and scientifically sound data flow between the data producers and the

end-users

2 / 7

Analysis and design of the information system

Campaigns

Sampling occasions

Samples

Water values Sediment subsamples

Sediment values

Biota subsamples

Tissue

Biota values

Observations

Densities

BE2000/03BE2000/07BR2000 (Broodwinner)BE1998/13

Station 700 - 7/02/2001 09.56 uStation 700 - 13/03/2000BCP - 5/10/2000Square 9312 - 2/06/1998

Niskin bottleVan Veen GrabBeam trawlEye/binocular

Nitrate : 75 µmol/lAmmonium : 2 µmol/lDissolved oxygen : 9.8 mg/l

0-10 cm depth 5 Atlantic cod specimens with average weight of 446 g

CB101 : 0.00202 µg/g dry weight (< 63 µm)

Liver tissue with 58 % lipid weight

2.2 Black-headedGulls/km245.12 Common Terns/km2

CB101 = 0.18628 µg/g lipid weight

2 individues are males

Inventory of existing datasets and databasesData types collected in the frame of the programmeSynthesis of valuable and reproducible metadata

Methodology and protocols to differentiate and characterize different parameters and data typesValidation rules and control charts to keep track of the data flow

Detailed entities relationship modelFrom object oriented database to service oriented information system

CAMPAIGN# CO DE* START DATE* END DATE* LO CKEDo NAMEo O BJECTIVESo AREA DESCRIPTIO No PO RT O F DEPARTUREo PO RT O F ARRIVALo CRUISE NARRATIVE

CAMPAIGNMARSDENSQUARE

CAMPAIGNMEMBER

CAMPAIGN SEAAREA

CAMPAIGNSERVICE

SERVICE# CO LLATE ID# IDo SERVICE CO DEo W EBSITEo DESCRIPTIO N* VALIDITY DATEo REVISIO N DATE* MO DIFY DATEo LO AD DATEo FAX NUMBERo PHO NE NUMBERo EMAILo ICES CO DEo LANG UAG E

PERSON# PERSO N NUMBER* LAST NAMEo F IRST NAMEo ADDRESSo PHO NE NUMBERo EMAILo FAX NUMBERo SEXo T ITLEo REVISIO N DATE* VALIDITY DATEo MO DIFY DATEo LO AD DATE...

SEA AREA. . .

MARSDENSQUARE. . .

SAMPLING OCCASION# T IMESTAMPo TSS DEPTH L* TSS DEPTH L FLAGo TSS DEPTH Ho TSS DEPTH H FLAGo AIRTEMP DRYo AIRTEMP DRY FLAGo HUMIDITY DWo HUMIDITY DW FLAGo ATM PRESSUREo ATM PRESSURE FLAGo SEA STATEo SEA STATE FLAGo SO L RADo SO L RAD FLAGo SHIP HEADINGo SHIP HEADING FLAGo FO AF SPEEDo FO AF SPEED FLAGo IN W IND DIRo IN W IND DIR FLAG...

PLATFORM# CO DE...

STATION# CO DEo NAME* REF START LATITUDEo REF END LATITUDE* REF START LO NG ITUDEo REF END LO NG ITUDEo START DATEo END DATE...

POINT SOURCE# CO DE* DESCRIPTIO N

SAMPLE# SEQ NOo SAMPLE REFERENCE CO DEo SAMPLING FLAG* START DATEo END DATEo T IME FLAGo START LATITUDEo END LATITUDEo START LO NG ITUDEo END LO NG ITUDE* PO SITIO N FLAG* PO SITIO N REFERENCEo PO SIT IO N INSTRUMENT* REFERENCE SAMPLING DEPTHo ACTUAL SAMPLING DEPTH* SAMPLING DEPTH FLAGo HAUL TYPEo APPRO X SPEEDo W IRE ANG LEo NUMBER SAMPLESo VO LUMEo EXCEPTIO NAL CIRCUMSTANCE* IND DATA EXPECTED* IND O NBO ARD REG ISTRATIO N...

ECOSYSTEM# CO DE...

PROJECT SAMPLE

PROJECT# PRO JECT ID* T ITLEo ACRO NYMo INTERNAL REFERENCEo START DATEo END DATEo IND O NG O INGo G EO G RAPHIC CO VERAG Eo SO UTHo NO RTHo W ESTo EASTo AREA TYPEo KEYW O RDS* ABSTRACTo REFERENCEo W EBSITEo RO LEo O THER PARTNERSo CO MPLETED BYo VALIDITY DATEo REVISIO N DATEo CO LLATED BYo LO AD DATE* MO DIFY DATEo IND STATUSo IND EDMERPo FUNDING AG ENCYo SO URCEo SO URCE W EBSITEo IND PUBLICo EMBARG O

WATER VALUE# REPLICATE NUMBERo VALUE* WATER VALUE FLAG* DETLIMFLAGo ANALYSIS DATEo ICESo SQ C SCHEME NUMBERo SQ C PRO BABILITYo SQ C FLAGo SQ C BACKTRACKING INFO* SEQ NO

SAMPLING GEAR# CO DE* SAMPLER* SAMPLER DEPLO YMENTo DESCRIPTIO No SAMPLER AREA O PENINGo MESH SIZEo NET O PENINGo MEASUREMENT TYPE...

ANALYSIS METHOD# SEQ NO* DESCRIPTIO No METAN ICESo PRECISIO No ACCURACYo SIG NIF ICANT NUMBERSo Q UANTIF ICATIO N LIMITo DEFINIT IO N Q UANTIF ICATIO N LIMITo DEFINIT IO N DETECTIO N LIMITo SED CO NDIT IO N

PARAMETER# CO DE...

PARAMATRIX* ICES_CO NVERSIO N

MATRIX. . .

UNIT. . .

SAMPLE HANDLING. . .

CONTROL CHART# SEQ NO* MEAN VALUE* STANDARD DEVIATIO No REFERENCE CO NCENTRATIO N...

REFERENCEMATERIAL# CO DE* BASISo DESCRIPTIO N

CONTROLCHARTVALUE# SEQ NO...

SERVICECOORDINATE* NAME* ADDRESS* HO ST

IC EX RESULT# SEQ NOo TEST MATERIAL CO DE* ASSIG NED VALUE* RO BUST MEANo ASSIG NED ERRO Ro Z SCO REo P SCO RE

IC EXERCISE# CO DEo DESCRIPTIO N* O RIG IN* DETERMINAND G RO UP* TEST MATRIXo RO UND...

SPECTRUM* PRO C FLAGo ANALYSIS DATE

SPECTRAL VALUE* WAVELENG THo VALUE* VALUE FLAG* DETLIMFLAG

SEDIMENT SUBSAMPLE# LO W ER SAMPLING DEPTH# UPPER SAMPLING DEPTHo SAMPLING DEPTH FLAG

SEDIMENT VALUE# REPLICATE NUMBER* DETLIMFLAG* VALUE FLAGo ICESo VALUEo ANALYSIS DATEo SQ C SCHEME NUMBERo SQ C PRO BABILITYo SQ C FLAGo SQ C BACKTRACKING INFO

BIOTA SUBSAMPLE# SUBNO* INDIVIDUAL O R BULK CO DE* ANIMAL STATEo NUMBER INDIVIDUALS TO TALo NUMBER INDIVIDUALS PO O LEDo SPAW NING SEASO No AG E MINo AG E MAXo AG E MEANo BILL LENG TH MINo BILL LENG TH MAXo BILL LENG TH MEANo BILL LENG TH SDo LENG TH MINo LENG TH MAXo LENG TH MEANo LENG TH SDo SHELL W EIG HT MO LLo TAIL LENG TH MINo TAIL LENG TH MAXo TAIL LENTH MEANo TAIL LENG TH SDo W ING LENG TH MINo W ING LENG TH MAXo W ING LENG TH MEANo W ING LENG TH SDo G O NAD W EIG HT...

BIOTA VALUE# REPLICATE NUMBERo DETLIMFLAG* VALUE FLAGo ICESo PERCENTAG E RECO VERYo VALUEo ANALYSIS DATEo SQ C SCHEME NUMBERo SQ C PRO BABILITYo SQ C FLAGo SQ C BACKTRACKING INFO

TISSUE# CO DE* DESCRIPTIO NTISSUE DATA

o BLUBBER THICKNESSo DRY W EIG HTo LIPID W EIG HTo BIRD EG G SHELL THICKNESSo BIRD EG G BREADTHo BIRD EG G SHELL W EIG HTo BIRD EG G W EIG HTo BIRDG EG G LENG THo T ISSUE W EIG HT

SPECIES# CO DE* LATIN NAMEo EURINGo RUBIN CO DEo ENG LISH NAMEo DUTCH NAMEo FRENCH NAME

ECOLOGICALVALUE# DEVELO PMENT STATUS* VALUE FLAGo ICESo SPECIES FLAGo VALUEo ANALYSIS DATE

CATEGORIC VALUEo INSPECTIO N T IMEo NUMBER O F ANIMALS* SEQ NO

CATEGORICPARAMETER DETAIL# CO DE* NAMEo DESCRIPTIO N

CATEGORICPARAMETERVARIABLE# CO DE* DESCRIPTIO N

SPECIAL ACCESS

sampled during

performed in

sampled during

performed in

participating in

executed by

participating to

executed by

executed by

participating in

executed by

participating to

working at

employs

performed in

sampled during

performed in

sampled during

part of

consisting of

performed on

used for

supervised by

supervising

supervising

supervised by

executed at

sampled during

placed near

executed near

having

part of

sampled on

describing

taken for

resulting inresulting in

taken for

delivering

assigned to

taken by

taking

used for

taken with

used to obtain

obtained by

resulting in

taken for

composed ofa composition element of

composed of

a composition element of

composed of

a composition element of

used to measure

measured by

executed after

part of

constructed for

validated by

used for

constructed based on

expressed in

expressing

used to interprete

interpreted by

executed by

executing

used by

executing

contacted via

contact for

sampling location for

having as sampling location

describing

described by

resulting in

the result of

obtained for

delivering

obtained for

consisting of

measured on

analysed for

obtained by

used to obtain

taken for

resulting in

assigned to

delivering

taken for

resulting in

obtained by

used to obtain

is part of

split in

measured on

analyzed for

identified byhaving

part of

delivering

taken for

resulting in

analyzed by

used to obtain

analyzed for lipid using

used to determine lipid of

part of

split up in

consisting of

present in

the result for

occuring in

taken for

resulting in

analyzed for diversity by

used to obtain

obtained for

delivering

describing

described by

taken for

resulting in

observed by

observing

described by

describing

a category for

having possible value classes in

given for

given

given to

given

3 / 7

Data flow from originator to end user

QC: Standardized data transfer and normalization proceduresValidation rules and quality controlVerification of data integrity

Distance

Sem

i-va

rian

ce

0 20 40 60 80

01

23

45

6

Semi-variogram for LOG AMON in the River Scheldt

Model G=a+b*DIST**ca= 0.223339994258357b= 0.233716906180508c= 0.697238198742615

SQC: Combination of distribution, regression and interpolation tests resulting in a value of probability stored with the original value

4 / 7

SPECIES# CODE* LATIN NAMEo EURINGo RUBIN CODEo ENGLISH NAMEo DUTCH NAMEo FRENCH NAME

ECOLOGICAL VALUE# DEVELOPMENT STATUS* VALUE FLAGo ICESo SPECIES FLAGo VALUEo ANIMAL STATEo DESCRIPTIONo ANALYSIS DATE

ANALYSIS METHOD# SEQNO* DESCRIPTIONo METAN ICESo PRECISIONo ACCURACYo SIGNIFICANT NUMBERSo QUANTIFICATION LIMITo DEFINITION QUANTIFICATION LIMIT...

PROJECT# PROJECT ID* TITLEo ACRONYMo INTERNAL REFERENCEo START DATEo END DATEo IND ONGOINGo GEOGRAPHIC COVERAGEo SOUTHo NORTHo WESTo EASTo AREA TYPEo KEYWORDS* ABSTRACTo REFERENCEo WEBSITEo ROLEo OTHER PARTNERSo COMPLETED BYo VALIDITY DATEo REVISION DATEo COLLATED BYo LOAD DATE* MODIFY DATEo IND STATUSo IND EDMERPo FUNDING AGENCYo SOURCEo SOURCE WEBSITEo IND PUBLICo EMBARGO

PROJECTSAMPLE

ECOSYSTEM# CODE...

SAMPLE# SEQNOo SAMPLE REFERENCE CODEo SAMPLING FLAG* START DATEo END DATEo TIME FLAGo START LATITUDEo END LATITUDEo START LONGITUDEo END LONGITUDE* POSITION FLAG* POSITION REFERENCEo POSITION INSTRUMENT* REFERENCE SAMPLING DEPTHo ACTUAL SAMPLING DEPTH* SAMPLING DEPTH FLAGo HAUL TYPEo APPROX SPEEDo WIRE ANGLEo NUMBER SAMPLESo VOLUMEo EXCEPTIONAL CIRCUMSTANCE* IND DATA EXPECTED* IND ONBOARD REGISTRATION...

POINT SOURCE# CODE* DESCRIPTION

STATION# CODEo NAME* REF START LATITUDEo REF END LATITUDE* REF START LONGITUDEo REF END LONGITUDEo START DATEo END DATEo DISTANCE S01o DESCRIPTIONo TYPE

SAMPLING OCCASION# TIMESTAMPo TSS DEPTH L* TSS DEPTH L FLAGo TSS DEPTH Ho TSS DEPTH H FLAGo AIRTEMP DRYo AIRTEMP DRY FLAGo HUMIDITY DWo HUMIDITY DW FLAGo ATM PRESSUREo ATM PRESSURE FLAGo SEA STATEo SEA STATE FLAGo SOL RADo SOL RAD FLAGo SHIP HEADINGo SHIP HEADING FLAGo FO AF SPEEDo FO AF SPEED FLAGo IN WIND DIRo IN WIND DIR FLAGo IN WINDSPDo IN WINDSPD FLAGo IN WINDSPD BFo IN WINDSPD BF FLAGo COMMENTSo EST SED RATE

CAMPAIGNSEA AREA

CAMPAIGNMARSDENSQUARE

CAMPAIGN# CODE* START DATE* END DATE* LOCKEDo NAMEo OBJECTIVESo AREA DESCRIPTIONo PORT OF DEPARTUREo PORT OF ARRIVALo CRUISE NARRATIVE

the result for

occuring in

obtained for

delivering

analyzed for diversity by

used to obtain

taken for

resulting in

sampling location for

having as sampling location

resulting in

taken for taken for

resulting in

sampled on

describing

havingpart of

placed near

executed near

executed at

sampled duringpart of

consisting of

sampled during

performed in

sampled during

performed in

Integrated and Dynamical Oceanographic Data Management

Different datasets originating from different research laboratories

Validation through RDBMS stored at the BMDCaccessible through the internet

Different data types share a common metadata structure without loosing

their specific characteristics

Registered users can query the

validated data online

5 / 7

0

25000

50000

75000

100000

125000

mei 2001 mei 2002 mei 2003 mei 2004

diversity

biota

air

optical

sediment

water

IDOD so far …

Amount of data imported between May 2001 and July 2004

Further improve online accessibility through …

XML

…and many more

6 / 7

1900 - 1908

2004 - 2005

Gilson’s collection

Constituted between 1899 and 1910 to better understand the relationship between marine organisms and their environment.

A total of 14000 sampling events, 3000 for sediment point-samplings sequentially with 1100 benthos dredge-track-samplings

450000 460000 470000 480000 490000 500000 510000 520000 530000 540000 5500005650000

5660000

5670000

5680000

5690000

5700000

5710000

5720000

5730000

"B ig stones"

S tones : 10 - 20 cm

Stones 20 - 30 cm

Sm all boulder > 30 cm

"G ravel" and sm all stones (< 10 cm )

200

300

M ud dom inant

M ud - additional slight layer

Revalidate sampling information, evaluate the geographic precision and analysis of sediment information stored at the RBINS reaches his end. Fitting historic samples for incorporation into information systems and current quality standard requirements is at hand.

A century later we are near to Gilson his original goal: build a map of benthic habitats and superimpose species distribution as well as species associations maps

465000 475000 485000 495000 505000 515000 525000 535000

5665

000

5675

000

5685

000

5695

000

5705

000

0 50 100 150 200 250 300 350

d50 Bulk (µm )

465000 475000 485000 495000 505000 515000 525000 535000

5665

000

5675

000

568

5000

569

5000

5705

000

10 30 50 70 90

% slib

2004 - 20261900 - 1904

Offshore wind farm

C-Power Ltd. far shore wind farm project on the Thornton sandbank.

60 Turbines of 3.6 MW with an estimated production of 710 GWh/yearDistance to coast 27 km, depth 6-20 m, surface wind farm area 26.4 km²

Monitoring:- Sediment and hydrodynamics - Noise and vibrations - Meteorological conditions - Benthos and fishes -

- Bird migration, staging, and collision - Marine mammals - Electromagnetic fields - Visual aspects -

The project will result in a large dataset with long-term data with high spatial resolution to analyze the environmental effects of the construction of a wind farm on the ‘Thornton’ sandbank, using the BACI -Before After Control Impact – design.

20102008 2012 2014 2016 2018 202020062004

ARC

20242022

Dec 2004 - Nov 2005: Monitoring of reference conditions (BACI – design)

2006: Construction demonstration phase and monitoring

Monitoring I

2026

Monitoring II

2028

Monitoring III

2026: End of permit, deconstruction of wind farm

20102008 2012 2014 2016 2018 202020062004

ARC

20242022

Dec 2004 - Nov 2005: Monitoring of reference conditions (BACI – design)

2006: Construction demonstration phase and monitoring

Monitoring I

2026

Monitoring II

2028

Monitoring III

2026: End of permit, deconstruction of wind farm

Most important achievements of the BMDC crew in 2004

Hasse

Aloïs

Litse

http://www.mumm.ac.be/datacentre