Cefas Fishing Survey System

This dataset has been extracted as part of an exercise to assemble "all" Cefas Temperature Data and publish it in a Data paper. It is one of 17 Cefas data sources assembled.

The Fishing Survey System (FSS) is a purpose–built database used to hold and maintain Cefas fish survey data, primarily from government mandated surveys. This SQL database holds the main research and charter vessel fishing surveys data from 1901 to present. It includes station, catch, length, and biological data. Easy to access user front end for storing and editing most forms of survey vessel data. Individual surveys grouped by their parent cruise series. Three current sections are shellfish, Fisheries Science Partnership and standard fisheries surveys.

Fish stock monitoring survey stations, provide the main source of temperature data. This dataset also stretches the UK Shelf Waters designation, including a single coastal Greenland survey in 1959 and Arctic surveys in 1930 and 1949–1959.

Various quality control checks ensure high quality storage of data and allow users to edit and extract data as required. Allows uploading from Electronic Data Capture System or X-Files.

Temperature data were extracted from the FSS database using:

SELECT fldCruiseName AS Cruise, fldcruiseStationNumber as StationNumber, fldShotEorW AS EorW, fldShotLonMinutes AS LonMin, fldShotLonDegrees AS LonDeg, fldShotLatMinutes AS LatMin, fldShotLatDegrees AS LatDeg, fldDateTimeShot AS DateTime, fldBottomSalinity AS BottomSalinity, fldSurfaceSalinity AS SurfaceSalinity, fldSurfaceTemp AS SurfaceTemp, fldBottomTemp AS BottomTemp, fldShotDepth AS WaterDepth, fldShotLonDecimalDegrees AS ShotLonDecimal, fldShotNorS AS NorS,fldShotLatDecimalDegrees AS ShotLatDecimal FROM FSS.dbo.tblDataStationLogs where fldBottomTemp is not null or fldSurfaceTemp is not null with values entered as ~36 C removed as suspect; nulls removed.

The multiple sources are described in 17 separate metadata entries under the same Title, e.g. Seawater temperature records for the UK Shelf - 15 - RV Cefas Endeavour FerryBox Monitoring System. These data have been described in detail via the following publication. Morris, D. J., Pinnegar, J. K., Maxwell, D. L., Dye, S. R., Fernand, L. J., Flatman, S., Williams, O. J., and Rogers, S. I.: Over 10 million seawater temperature records for the United Kingdom Continental Shelf between 1880 and 2014 from 17 Cefas (United Kingdom government) marine data systems, Earth Syst. Sci. Data, 10, 27–51, https://doi.org/10.5194/essd-10-27-2018, 2018.

本数据集系为汇编全部英国环境、渔业与水产养殖科学中心（Centre for Environment, Fisheries and Aquaculture Science, Cefas）温度数据并以数据论文形式发表的相关工作的一部分，属于本次汇编的17个Cefas数据源之一。

渔业调查系统（Fishing Survey System, FSS）是为存储和维护Cefas鱼类调查数据（主要来自政府法定调查）而专门构建的数据库。该SQL数据库收录了1901年至今的主要科研及租船渔业调查数据，包含测站、渔获、体长及生物学数据。其配备便捷易用的用户前端，可存储和编辑绝大多数类型的调查船载数据，各项调查按母航次系列进行分组。当前下设三个板块：贝类、渔业科学合作项目及标准渔业调查。

鱼类种群监测调查测站是本数据集温度数据的主要来源。本数据集覆盖英国陆架海域范围，还包含1959年的一次格陵兰沿岸调查数据，以及1930年、1949–1959年的北极调查数据。

系统内置多种质量控制流程，可保障数据的高质量存储，并支持用户按需编辑和提取数据。支持从电子数据采集系统（Electronic Data Capture System）或X-Files上传数据。

本研究通过以下SQL语句从FSS数据库中提取温度数据：
SELECT fldCruiseName AS Cruise, fldcruiseStationNumber as StationNumber, fldShotEorW AS EorW, fldShotLonMinutes AS LonMin, fldShotLonDegrees AS LonDeg, fldShotLatMinutes AS LatMin, fldShotLatDegrees AS LatDeg, fldDateTimeShot AS DateTime, fldBottomSalinity AS BottomSalinity, fldSurfaceSalinity AS SurfaceSalinity, fldSurfaceTemp AS SurfaceTemp, fldBottomTemp AS BottomTemp, fldShotDepth AS WaterDepth, fldShotLonDecimalDegrees AS ShotLonDecimal, fldShotNorS AS NorS,fldShotLatDecimalDegrees AS ShotLatDecimal FROM FSS.dbo.tblDataStationLogs where fldBottomTemp is not null or fldSurfaceTemp is not null with values entered as ~36 C removed as suspect; nulls removed.
上述查询将底部温度或表层温度非空的记录纳入提取范围，同时剔除了疑似异常的~36℃取值，并移除了所有空值。

本数据集的多个数据源均以同一标题下的17条独立元数据条目进行描述，例如《英国陆架海域海水温度记录——第15项——Cefas Endeavour号调查船（RV）FerryBox监测系统》。上述数据集的详细信息已通过以下论文发表：Morris, D. J., Pinnegar, J. K., Maxwell, D. L., Dye, S. R., Fernand, L. J., Flatman, S., Williams, O. J. 及 Rogers, S. I.：《1880—2014年英国大陆架海域超1000万条海水温度记录：来自17个Cefas（英国政府）海洋数据系统》，《地球系统科学数据》（Earth Syst. Sci. Data），10卷，27–51页，https://doi.org/10.5194/essd-10-27-2018，2018年。

搜集汇总

背景与挑战

背景概述

Cefas Fishing Survey System是一个专门用于存储和管理Cefas渔业调查数据的数据库，涵盖1901年至今的研究和租用船只调查数据，包括站点、渔获和生物学信息。该数据集是17个Cefas数据源之一，旨在汇编英国大陆架海水温度记录，覆盖区域扩展至历史性北极调查，并通过质量控制和科学出版物确保数据高质量和可访问性。