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 limitsGilson’s collectionOffshore 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 200019741970MONITORING 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# CODE* START DAT E* END DAT E* LOCKEDo NAMEo OBJECT I VESo AREA DESCRIPTIO No PORT OF DEPART UREo PORT OF ARRIVALo CRUISE NARRAT IVE

CAMPAIGNMARSDENSQUARE

CAMPAIGNMEMBER

CAMPAIGN SEAAREA

CAMPAIGNSERVICE

SERVICE# COLLAT E ID# IDo SERVICE CO DEo W EBSIT Eo DESCRIPT IO N* VALIDITY DAT Eo REVISIO N DAT E* M ODIF Y DAT Eo LO AD DAT Eo FAX NUMBERo PHONE NUMBERo EMAILo ICES CO DEo LANG UAG E

PERSON# PERSON NUMBER* LAST NAM Eo F IRST NAM Eo ADDRESSo PHONE NUMBERo EMAILo FAX NUM BERo SEXo T IT LEo REVISIO N DAT E* VALIDIT Y DAT Eo MO DIFY DAT Eo LOAD DATE.. .

SEA AREA. . .

MARSDENSQUARE. . .

SAMPLING OCCASION# T IM ESTAMPo T SS DEPTH L* T SS DEPT H L F LAGo T SS DEPTH Ho T SS DEPTH H F LAGo AIRT EM P DRYo AIRT EM P DRY F LAGo HUMIDIT Y DWo HUMIDIT Y DW F LAGo AT M PRESSUREo AT M PRESSURE F LAGo SEA STAT Eo SEA STAT E F LAGo SOL RADo SOL RAD F LAGo SHIP HEADINGo SHIP HEADING F LAGo F O AF SPEEDo F O AF SPEED F LAGo IN W IND DIRo IN W IND DIR F LAG...

PLATFORM# CODE.. .

STATION# CODEo NAME* REF START LATI T UDEo REF END LAT ITUDE* REF START LONG IT UDEo REF END LONGI T UDEo START DAT Eo END DAT E.. .

POINT SOURCE# CODE* DESCRIPT IO N

SAMPLE# SEQNOo SAMPLE REF ERENCE CO DEo SAMPLI NG F LAG* START DAT Eo END DAT Eo T IME F LAGo START LAT IT UDEo END LAT IT UDEo START LO NGIT UDEo END LO NGIT UDE* POSIT IO N F LAG* POSIT IO N REF ERENCEo POSIT IO N INST RUMENT* REF ERENCE SAM PLING DEPT Ho ACT UAL SAM PLING DEPT H* SAM PLING DEPT H F LAGo HAUL T YPEo APPROX SPEEDo W IRE ANGLEo NUMBER SAMPLESo VOLUMEo EXCEPT I ONAL CIRCUMSTANCE* IND DATA EXPECT ED* IND O NBO ARD REGI STRAT ION...

ECOSYSTEM# CO DE...

PROJECT SAMPLE

PROJECT# PROJECT ID* T IT LEo ACRO NYMo INT ERNAL REF ERENCEo START DAT Eo END DAT Eo IND ONGO INGo GEO GRAPHI C CO VERAG Eo SOUT Ho NORT Ho W ESTo EASTo AREA T YPEo KEYW ORDS* ABST RACTo REF ERENCEo W EBSIT Eo ROLEo OT HER PART NERSo COM PLET ED BYo VALIDIT Y DAT Eo REVISIO N DAT Eo COLLAT ED BYo LO AD DAT E* M ODIF Y DAT Eo IND STAT USo IND EDM ERPo F UNDING AG ENCYo SOURCEo SOURCE W EBSIT Eo IND PUBLICo EMBARGO

WATER VALUE# REPLICAT E NUM BERo VALUE* WAT ER VALUE F LAG* DET LI MF LAGo ANALYSIS DAT Eo ICESo SQC SCHEM E NUM BERo SQC PROBABILIT Yo SQC F LAGo SQC BACKT RACKING INF O* SEQ NO

SAMPLING GEAR# CO DE* SAMPLER* SAMPLER DEPLOYM ENTo DESCRIPTI ONo SAMPLER AREA OPENINGo M ESH SIZ Eo NET OPENINGo M EASUREMENT T YPE...

ANALYSIS METHOD# SEQNO* DESCRIPT IONo METAN ICESo PRECISIO No ACCURACYo SIGNIF ICANT NUM BERSo QUANT IF ICAT ION LIMITo DEF INITI ON QUANT IF ICAT ION LIM ITo DEF INITI ON DET ECT ION LIMITo SED CONDIT ION

PARAMETER# CODE...

PARAMATRIX* ICES_CONVERSI ON

MATRIX. . .

UNIT. . .

SAMPLE HANDLING.. .

CONTROL CHART# SEQNO* MEAN VALUE* STANDARD DEVIAT IONo REF ERENCE CO NCENT RAT IO N...

REFERENCEMATERIAL# CODE* BASISo DESCRIPT IO N

CONTROLCHARTVALUE# SEQNO...

SERVICECOORDINATE* NAM E* ADDRESS* HO ST

IC EX RESULT# SEQNOo T EST MAT ERIAL CODE* ASSIGNED VALUE* ROBUST MEANo ASSIG NED ERRORo Z SCOREo P SCORE

IC EXERCISE# CODEo DESCRI PTIO N* ORIGIN* DET ERMI NAND GRO UP* T EST M ATRIXo ROUND...

SPECTRUM* PROC F LAGo ANALYSIS DAT E

SPECTRAL VALUE* WAVELENGT Ho VALUE* VALUE F LAG* DET LI MF LAG

SEDIMENT SUBSAMPLE# LOW ER SAM PLING DEPT H# UPPER SAM PLING DEPT Ho SAMPLING DEPT H F LAG

SEDIMENT VALUE# REPLICAT E NUM BER* DET LI MF LAG* VALUE F LAGo ICESo VALUEo ANALYSIS DAT Eo SQC SCHEM E NUM BERo SQC PROBABILIT Yo SQC F LAGo SQC BACKT RACKING INF O

BIOTA SUBSAMPLE# SUBNO* INDIVIDUAL O R BULK CO DE* ANIMAL STAT Eo NUMBER INDIVIDUALS T O TALo NUMBER INDIVIDUALS PO OLEDo SPAW NING SEASONo AGE MINo AGE MAXo AGE MEANo BILL LENGT H M INo BILL LENGT H M AXo BILL LENGT H M EANo BILL LENGT H SDo LENGT H MINo LENGT H MAXo LENGT H MEANo LENGT H SDo SHELL W EI GHT MOLLo TAIL LENGT H M INo TAIL LENGT H M AXo TAIL LENT H MEANo TAIL LENGT H SDo W ING LENG T H MINo W ING LENG T H MAXo W ING LENG T H MEANo W ING LENG T H SDo G ONAD WEIG HT.. .

BIOTA VALUE# REPLICAT E NUM BERo DET LIMF LAG* VALUE F LAGo ICESo PERCENTAG E RECO VERYo VALUEo ANALYSIS DAT Eo SQC SCHEM E NUMBERo SQC PROBABILIT Yo SQC F LAGo SQC BACKT RACKING INF O

TISSUE# CODE* DESCRIPT IO NTISSUE DATA

o BLUBBER T HICKNESSo DRY WEI GHTo LIPID W EIGHTo BIRD EG G SHELL T HI CKNESSo BIRD EG G BREADT Ho BIRD EG G SHELL W EIG HTo BIRD EG G W EIGHTo BIRDG EGG LENGT Ho T ISSUE W EIG HT

SPECIES# CODE* LAT IN NAMEo EURINGo RUBIN CODEo ENGLISH NAM Eo DUT CH NAM Eo F RENCH NAM E

ECOLOGICALVALUE# DEVELOPM ENT STAT US* VALUE FLAGo ICESo SPECIES F LAGo VALUEo ANALYSIS DAT E

CATEGORIC VALUEo INSPECT ION T IMEo NUMBER OF ANIM ALS* SEQ NO

CATEGORICPARAMETER DETAIL# CODE* NAM Eo DESCRIPT IO N

CATEGORICPARAMETERVARIABLE# CODE* DESCRIPT IO N

SPECIAL ACCESS

sampled during

performed in

sampled during

performed in

participating in

executed by

participating to

executed by

executed byparticipating in

executed bypartici pating to

working at

employs

performed in

sampled during

performed insampled during

part of

consisting of

performed on

used for

supervised by

supervi sing

supervising

supervised by

executed at

sampled duringplaced near

executed near

having

part of

sampled on

descri bing

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 byexecuted after

part of

constructed for

validated by

used for

constructed based on

expressed in

expressing

used to interprete

interpreted by

executed byexecuting

used by

executing

contacted via

contact for

sampling location for

havi ng as sampli ng location

describing

described by

resulting in

the result of

obtained for

delivering

obtained for

consisting of

measured on

anal ysed 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 byhavingpart 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

consisti ng of

present inthe result for

occuring in

taken for

resulting in

analyzed for diversity by

used to obtain

obtained for

delivering

descri bing

described by

taken for

resulting in

observed by

observi ng

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-var

ianc

e

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

diversitybiotaairopticalsedimentwater

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 510 000 520000 530000 5400 00 5500005650000

5660000

5670000

5680000

5690000

5700000

5710000

5720000

5730000

"B ig sto ne s"

S tones : 10 - 20 cm

S tones 20 - 30 cm

Sm all bou lde r > 30 cm

"G rave l" and sm all s tones (< 10 cm )

200

300

M u d dom inan t

M u d - a dd itiona l s ligh t laye r

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

465 000 475 000 485 000 49 50 00 505 000 51 50 00 525 00 0 535 00 0

5665

000

5675

000

5685

000

5695

000

5705

000

0 50 100 150 20 0 25 0 30 0 350

d50 Bulk (µm )

465 000 475 000 485000 495 000 505 000 515 000 525000 535 000

5665

000

5675

000

5685

000

5695

000

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