Vannmiljø Pilot Database

A pilot study to evaluate the database structure using the Vannmiljø data

This site presents the initial version of the database design and its potential applications using the publicly available Vannmiljø dataset.

Source Data

Search criteria

Medium

  • Sediment saltvann

Parameter

  • EFSA elements (Kobber, Sink, Mangan, Kobolt, Molybden, Selen)
  • Other elements
  • Carbon content and total sulfur
  • Particle sizes

Count of Sampling Sites

The table below summarizes the number of sampling sites documented across 27 activities and projects between 1975 and 2025.

Database Design and Creation

After creating the ER (Entity–Relationship) diagram, the tables were implemented in a single SQLite file containing 10 tables. All required data were extracted from the Vannmiljø export file and imported into the corresponding tables.

  • See the DB Schema page for details on the database architecture.
  • See the Data Preparation page for the data preparation process used prior to importing the Vannmiljø dataset.

Geospatial Analysis

To facilitate efficient core and sample selection, distances to the nearest coastline were calculated for the Vannmiljø data. In addition, the nearest country and municipality, as well as the sea and ocean names, were identified based on the core locations.

  • See the Distance Calculation page for the methods and results of calculating the distance to the nearest coastline.
  • See the Location Names page for the estimation of location names from geographic coordinates.
  • See the Interactive Map page for an interactive visualization of core locations with meta-information.

Data Export

Data can be exported for both exploration and submission purposes.

  • See the Sediment Particle Size Fractions page for a description of the conversion from raw grain-size measurements to standardised sediment particle fractions.
  • See the Export to Tabular File page for descriptions of three tabular files (.tsv.gz) that are extracted and merged from all database tables for data exploration.

Tools