NFPD: Freshwater fish survey relational datasets

PLEASE NOTE: This dataset has been superseded by the 'Freshwater fish surveys (NFPD)' and 'Freshwater fish surveys - salmonid age data (NFPD)' datasets and is now Retired. As of March 2020 All data formerly available in 'National Fish Populations Database (NFPD)' is now available in these datasets. The abstract below provides a historical reference for 'NFPD: Freshwater fish survey relational datasets' at the point of retirement.

These products are Approved for Access under AfA347.

The National Fish Populations Database (NFPD) holds information collected from fisheries monitoring work on rivers, lakes and transitional and coastal waters (TraC). This monitoring work is undertaken by the Environment Agency and by third parties.
All the relevant data associated with NFPD freshwater fish surveys, such as survey information, site information, the numbers and species of fish caught, fish lengths, weights and ages (where available), can be obtained from these relational datasets. The data is provided as a set of relational data tables because there is just too much data to include all relevant information in all tables. A basic understanding of fisheries science and relational databases is assumed.
Available datasets/tables:
• Freshwater Fish Counts for all species for all Areas and all Years
• Freshwater Salmonid Age Band (0+, >0+, age unknown) Counts for all Areas and Years
• Freshwater Salmonid Age Band (0+, 1+, >1+, age unknown) Counts for all Areas and Years
• Breakdown of freshwater fish count data types (individually measured, banded measured and bulk counted fish)
• Individually measured freshwater fish records
• Banded measured freshwater fish records
• Bulk counted freshwater fish records
The tables can be related to each other using any one of the unique identifiers - survey_id, survey_species_id, species_id and species_run_id. However, the Freshwater Fish Counts and the Salmonid Age Band datasets have no dependence on the other tables and can therefore also be used in isolation.
Third party data and surveys not flagged as ‘Completed’ are excluded.
For more information about the available datasets/tables, please see the Dataset Documentation. Attribution statement: © Environment Agency copyright and/or database right 2017. All rights reserved.

请注意：本数据集已被'淡水鱼类调查（NFPD）'及'淡水鱼类调查——鲑科鱼类年龄数据（NFPD）'数据集所取代，现已退役。自2020年3月起，原'国家鱼类种群数据库（NFPD）'中所有可用的数据均已包含在这两个数据集中。以下摘要提供了关于'NFPD：淡水鱼类调查关系数据集'在退役时的历史参考。

这些产品经AfA347批准可公开访问。

国家鱼类种群数据库（NFPD）收录了来自河流、湖泊、过渡性水域和沿海水域（TraC）渔业监测工作的信息。此类监测工作由环境署及其第三方机构负责执行。

与NFPD淡水鱼类调查相关的所有相关数据，包括调查信息、场地信息、捕获的鱼类数量和种类、鱼类长度、重量和年龄（如有），均可从这些关系数据集中获取。由于数据量庞大，无法在所有表中包含所有相关信息，因此数据以一系列关系数据表的形式提供。假定用户具备渔业科学和关系数据库的基本理解。

可用的数据集/表格包括：
• 所有物种、所有区域和所有年份的淡水鱼类计数
• 所有区域和年份的淡水鲑科鱼类年龄带（0+，>0+，年龄未知）计数
• 所有区域和年份的淡水鲑科鱼类年龄带（0+，1+，>1+，年龄未知）计数
• 淡水鱼类计数数据类型的细分（单独测量的、带标记测量的和批量计数的鱼类）
• 单独测量的淡水鱼类记录
• 带标记测量的淡水鱼类记录
• 批量计数的淡水鱼类记录

这些表格可以通过任何一种唯一标识符（调查_id、调查物种_id、物种_id和物种运行_id）相互关联。然而，淡水鱼类计数和鲑科鱼类年龄带数据集与其他表格没有依赖关系，因此也可以独立使用。

未标记为‘完成’的第三方数据和调查被排除在外。

有关可用的数据集/表格的更多信息，请参阅数据集文档。归属声明：© 环境署版权和/或数据库权利2017。版权所有。”
}