North Sea - Contaminants aggregated datasets 1959/2019 v2021

EMODnet Chemistry aims to provide access to marine chemistry data sets and derived data products concerning eutrophication, ocean acidification and contaminants. The chemicals chosen reflect importance to the Marine Strategy Framework Directive (MSFD). This regional aggregated dataset contains all unrestricted EMODnet Chemistry data on contaminants, and covers the North Sea with 34978 CDI records divided per matrices: 1460 biota, 24740 water profiles, 6090 sediment profiles and 261 sediment time series. For water, the temporal range is from 1959-10-03 to 2019-12-30. For sediment, the temporal range is from 1970-07-11 to 2019-12-18 for profile data and from 1993-09-16 to 2015-06-15 for the time series. For biota, the temporal range is from 1979-02-26 to 2018-02-28. Data were aggregated and quality controlled by 'Aarhus University, Department of Bioscience, Marine Ecology Roskilde from Denmark'.<br> Regional datasets concerning contaminants are automatically harvested. Parameter names in these datasets are based on P01, BODC Parameter Usage Vocabulary, which is available at: http://seadatanet.maris2.nl/bandit/browse_step.php . Each measurement value has a quality flag indicator. The resulting data collections for each Sea Basin are harmonised, and the collections are quality controlled by EMODnet Chemistry Regional Leaders using ODV Software and following a common methodology for all Sea Regions.<br> Harmonisation means that: (1) unit conversion is carried out to express contaminant concentrations with a limited set of measurement units (according to EU directives 2013/39/UE; Comm. Dec. EU 2017/848) and (2) merging of variables described by different “local names” ,but corresponding exactly to the same concepts in BODC P01 vocabulary.<br> Detailed documentation is available at: https://doi.org/10.6092/8b52e8d7-dc92-4305-9337-7634a5cae3f4<br> The harmonised dataset can be downloaded as ODV spreadsheet (TXT file), which is composed of metadata header followed by tab separated values. This worksheet can be imported to ODV Software for visualisation (More information can be found at: https://www.seadatanet.org/Software/ODV ).<br> The same dataset is offered also as XLSX file in a long/vertical format, in which each P01 measurement is a record line. Additionally, there are a series of columns that split P01 terms in subcomponents (measure, substance, CAS number, matrix...).This transposed format is more adapted to worksheet applications users (e.g. LibreOffice Calc).<br> The original datasets can be searched and downloaded from EMODnet Chemistry Download Service: https://emodnet-chemistry.maris.nl/search

EMODnet Chemistry 旨在提供与富营养化、海洋酸化及污染物相关的海洋化学数据集及衍生数据产品的访问渠道。所选化学品均贴合《海洋战略框架指令》（Marine Strategy Framework Directive, MSFD）的重点关注范畴。
本区域聚合数据集涵盖所有无限制的EMODnet Chemistry污染物相关数据，覆盖北海海域，共包含34978条CDI记录，并按环境基质分类：1460条生物样品记录、24740条水体剖面记录、6090条沉积物剖面记录以及261条沉积物时间序列记录。
水体数据的时间跨度为1959年10月3日至2019年12月30日；沉积物剖面数据的时间跨度为1970年7月11日至2019年12月18日，沉积物时间序列数据的时间跨度为1993年9月16日至2015年6月15日；生物样品数据的时间跨度为1979年2月26日至2018年2月28日。
本数据集由丹麦奥胡大学生物科学系罗斯基勒海洋生态研究组完成数据聚合与质量控制。
污染物相关区域数据集均通过自动采集获取，数据集内的参数名称均基于BODC P01参数使用词汇表（BODC Parameter Usage Vocabulary），该词汇表可通过以下链接查阅：http://seadatanet.maris2.nl/bandit/browse_step.php。
每条测量值均附带质量标记指示符。
各海域的最终数据集均经过统一协调，且由EMODnet Chemistry区域负责人使用ODV软件（Ocean Data View Software）并遵循统一的跨海域标准方法完成质量控制。
统一协调工作包含以下两项内容：(1) 按照欧盟指令2013/39/UE及欧盟委员会条例2017/848的要求，将污染物浓度转换为有限的标准测量单位；(2) 将以不同"本地名称"表述但在BODC P01词汇表中完全对应同一概念的变量进行合并。
详细文档可通过以下链接获取：https://doi.org/10.6092/8b52e8d7-dc92-4305-9337-7634a5cae3f4
已统一协调的数据集可下载为ODV电子表格格式（TXT文件），该文件由元数据头部与制表符分隔的数值内容组成。此工作表可导入ODV软件进行可视化展示（更多信息可查阅：https://www.seadatanet.org/Software/ODV）。
该数据集同时提供长格式/垂直格式的XLSX文件版本，其中每条P01测量数据对应一行记录。此外，该文件包含多列字段，将P01术语拆分为多个子项（如测量项、物质、CAS号、环境基质等）。这种转置格式更适配电子表格应用的用户使用习惯（例如LibreOffice Calc）。
原始数据集可通过EMODnet Chemistry下载服务进行检索与下载：https://emodnet-chemistry.maris.nl/search