ICES Data Centre

EcoSystemDataEcoSystemData

AAn integrated solution from data collection to data productn integrated solution from data collection to data product

Hans Mose Jensen (hans.jensen@ices.dk)Carlos Pinto (carlos@ices.dk)

““The study of the The study of the physical conditionsphysical conditions, of the , of the chemical chemical nature of the ocean watersnature of the ocean waters, of the currents etc., is of , of the currents etc., is of

greatest importance for the investigation of the greatest importance for the investigation of the problems problems connected with lifeconnected with life… and consequently a … and consequently a sharp line sharp line

should never be drawn between these two main should never be drawn between these two main divisionsdivisions..” ”

ICES Report of Administration (RPV, ICES Report of Administration (RPV, 19031903))

ICES Data Centre

• For an holistic analysis of the data◦ Provide information to find underlying cause and effect

relationships across scientific topics

• Spending time on research and not in collecting and formatting the data◦ Avoid that scientists have to collect data from several

databases ◦ Aligned formats - distinct repositories of data have normally

distinct formats

• Timeliness for advice◦ Higher quality on the data due to improved cross checking

possibilities and generic data structures◦ Quick and flexible response to customers◦ Effective data processing

Why build EcoSystemData?

ICES Data Centre

Seawater Bottle CTD/underway CommunityBiota Sediment

File Measurement

User operations

Extract BrowseManage AnalyseVisualise

Raw data

EcoSystemData (Database)

Sample Spot

Date/Time Lat/Long

EcoSystemData (Web Application)

Manage BrowseWeb

ServicesQuery/visualise

ModelTable Chart Map

Inventory

ICES Data Centre

METADATA RELATIONS

Core tableMandatory records:E.g. Lat, Lon, Date

Type relationsE.g.

Type: Water depthValue: 90

Common Code- Type table

E.g. ITIS

Common Code Table

E.g. Gadus morhua

RECOERMS ITIS …Reference codes

ICES Data Centre

This part of the web site is restricted to ICES data managers. The functionality reflects what is necessary in order to run the system on a daily basis

MANAGE

• Inserting

• Updating

• Deleting

• Detecting duplicates

• Dealing with duplication(verify -> accept/delete)

ICES Data Centre

This area is intended for all users. Uploaded files can be browsed in the 3.2 format input file structure. For each uploaded data file, the information can be browsed down to parameter level

• Browse uploaded data files

• Browse data (grouped by record type)

• View map of stations

• Download file (3.2 format)

• Facilitate comparison with input data files

• Can guide when creating new data files

BROWSE

ICES Data Centre

• Select summary by area and time period

• Summary per data type

• Summary per parameter-group and parameter

INVENTORY

This area is intended for all users. It should be possible to easily get an overview of data in the system (data types, parameters, samples and measurements)

ICES Data Centre

All users should be able to specify a query for data from the system. The result of a query can be visualised on maps and charts or be downloaded as a table.

QUERY

• Customise a query

• Display result on map, chart or table

• Combine different data queries on the same map

•

ICES Data Centre

• Ecosystem data is now operational for data insertions

• ICES is being more responsive to data consumers

• Data processing and analysis is now easier and quicker

• One database, one interface, many applications

CONCLUSIONS

ICES Data Centre

• Visualise◦ Build queries and show the result as maps,

charts and tables to be downloaded

• Models◦ Apply models on data, for example as a support

tool for marine spatial planning or gridded data products

• Web Services◦ Set up web services enabling users to get

summaries, download datasets, etc

FUTURE DEVELOPMENT

ICES Data Centre

ICES Data Centre

30°W

30°W

20°W

20°W

10°W

10°W

0°

0°

10°E

10°E

20°E

20°E

30°E

30°E

40°E

40°E

30

°N

30

°N

40

°N

40

°N

50

°N

50

°N

60

°N

60

°N

70

°N

70

°N8

0°N

Station dictionary7-3-2008

ICES Data Centre

QA

Data submitter

Accessions

EcoSystemData

Data manager visual inspection

Error(s) found

DATSU screening

DATSU screeningError(s) found

Feedback/Assessment

DATSU

Error(s) found