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.