Identification

Title

NFPD: Freshwater fish survey relational datasets

Alternative title(s)

National Fish Populations Database (NFPD)

Abstract

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.

Resource type

dataset

Resource locator

https://support.environment.data.gov.uk/hc/en-gb

protocol: http:

name: DSP_CUSTOMER_FORUM

description: DEFRA Data Services Platform Customer Forum

Unique resource identifier

code

c6628ca9-f9ff-4b78-81bd-51bdc645de0f

codeSpace

Dataset language

eng

Spatial reference system

code identifying the spatial reference system

http://www.opengis.net/def/crs/EPSG/0/27700

Classification of spatial data and services

Topic category

environment

Keywords

Keyword set

keyword value

OpenData

Fish survey data

Fisheries management

Fish population

Freshwater fish

Fish distribution

Geographic location

West bounding longitude

-6.236

East bounding longitude

2.072

North bounding latitude

55.816

South bounding latitude

49.943

Extent

Extent group

authority code

code identifying the extent

http://data.ordnancesurvey.co.uk/doc/country/england

Temporal reference

Temporal extent

Begin position

1975-01-01

End position

2019-10-31

Dataset reference date

date type

revision

effective date

2019-11-11

Frequency of update

quarterly

Quality and validity

Lineage

This dataset was extracted from the National Fish Populations Database.

Conformity

Data format

name of format

Open format | Comma Separated Values file (CSV)

version of format

Not applicable

Constraints related to access and use

Constraint set

Use constraints

Open Government Licence

Constraint set

Limitations on public access

There are no public access constraints to this data. Use of this data is subject to the licence identified.

Responsible organisations

Responsible party

organisation name

Environment Agency

email address

DSPcustomerforum@environment-agency.gov.uk

web address

https://support.environment.data.gov.uk/hc/en-gb

description: Defra Data Services Forum

responsible party role

pointOfContact

Metadata on metadata

Metadata point of contact

organisation name

Environment Agency

email address

metadata@environment-agency.gov.uk

responsible party role

pointOfContact

Metadata date

2020-06-02

Metadata language

eng