The Environment Agency undertakes fisheries monitoring work on rivers, lakes and transitional and coastal waters (TraC).

This dataset contains site and survey information, the numbers and species of fish caught, fish lengths, weights and ages (where available), for all the freshwater fish surveys carried out across England from 1975 onwards.

Notes: - These survey data are stored in an archive more commonly known as the NFPD (National Fish Populations Database). - This dataset contains Freshwater fish surveys only. - Third party data held on the NFPD are excluded from the dataset. - Some historic surveys (particularly in Anglian Central) have incorrect survey lengths and survey widths. These can be identified by a survey length of 1 and a survey width that is equal to the area. The survey areas are correct. This is due to the migration of old historic data from previous databases into the NFPD. - Approved for Access under AfA347.

Please see the Dataset Documentation for further detail.

This dataset corresponds with the inland fisheries collaboration between the Land and Water Lab at the University of Florida and Food and Agriculture Organization of the United Nations. An online survey of fisheries professionals distributed in June-September 2020 yielded 536 responses from 93 unique hydrological basins across most major freshwater habitat types. Provided here are the raw survey dataset generated from participant responses, a formatted dataset intended for reuse, a reference key to numeric values and column headers, a reference key to region identifiers, and the script used to generate the formatted dataset and figures used in the paper titled, "A global dataset of inland fisheries expert knowledge."

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.

Standardized test-fishing with Nordic multi-mesh gillnets is a widely used method in Sweden to investigate the fish fauna in a lake. In 2005 the method became an European standard (EN 14757). Standardized test-fishing catch most of the Swedish species in a representative way, giving a good estimate of species abundance and size distribution. The results are generally used for purposes of environmental protection and fishery management.

NORS consists of thousands of test-fishing occasions back to the 1950’s. The Department of Aquatic Resources (SLU Aqua) at the Swedish University of Agricultural Sciences is responsible of collecting and checking test-fishing data generated in national and regional environmental programs, on behalf of the Swedish Agency for Marine and Water Management. SLU Aqua also collect test-fishing data from several other types of investigations in order to create a database as representative as possible. The purpose is to facilitate obtaining data of high quality for research, national investigations and reports. The database also serves as a reference for local and regional investigations. All data is available for the public.

Stated preference choice experiment data were collected in conjunction with NMFS’ Marine Recreational Fisheries Statistics Survey (MRFSS) along the coastal states of Maine, New Hampshire, and Massachusetts during 2014. All anglers intercepted in Maine, New Hampshire, and Massachusetts for NMFS' Marine Recreational Information Program (MRIP) intercept survey were asked to participate in a voluntary follow-up mail survey. Anglers who agreed to participate in the follow-up were sent mail questionnaires using a modified Dillman Tailored Design. The choice experiment survey asked anglers that have targeted Gulf of Maine cod, haddock, or pollock to simultaneously compare features of different hypothetical fishing trips and then to choose the trip they liked best. The features or attributes varied across trips and included bag and size limits of each species, the number of legal-sized fish caught of each species, the number of sub-legal sized fish caught of each species, the number of other types of fish that were legally kept, the trip length in hours, and the total trip cost. Respondents were also permitted to choose an opt-out option which was “Do something else: Freshwater fishing, Saltwater fishing for species other than cod, haddock and pollock, or don't go fishing.†The collection of choice responses from the various choice scenarios allows for the examination of tradeoffs and behavioral responses to various biological and regulatory changes. A total of 1,763 surveys were mailed out and 481 completed mail surveys were returned for a response rate of 27%.

The Environment Agency undertakes fisheries monitoring work on rivers, lakes and transitional and coastal waters (TraC).

This dataset includes site and survey information, together with a detailed breakdown of the salmonid age data into numbers of 0+, >0+, 1+, >1+ age bands (where available), for freshwater fish surveys carried out across England from 1975 onwards.

Notes: - These survey data are stored in an archive more commonly known as the NFPD (National Fish Populations Database). - This dataset contains Freshwater fish surveys only. - Third party data held on the NFPD are excluded from the dataset. - Some historic surveys (particularly in Anglian Central) have incorrect survey lengths and survey widths. These can be identified by a survey length of 1 and a survey width that is equal to the area. The survey areas are correct. This is due to the migration of old historic data from previous databases into the NFPD. - Approved for Access under AfA347. - The dataset 'Freshwater fish surveys (NFPD)' may also be relevant, it contains fish lengths, weights, and the raw age data (where available).

Please see the Dataset Documentation for further detail. Attribution statement: © Environment Agency copyright and/or database right 2017. All rights reserved.

This data was collected in Lake Malawi using a trawl vessel belonging to the Department of Fisheries. The Research Vessel Ndunduma, powered by a 400hp Caterpillar engine, was used while dragging a bottom trawl net. Trawling was restricted to 30-minute intervals, while trawling speed was about 4.63km/hr. Over 116 sampling stations were targeted during the survey, which was jointly conducted by Malawian and Mozambican fisheries researchers.

National Fish Populations Database (NFPD): Freshwater Fish Counts for all Species for all Areas and all years. This is for Approval for Access product AfA347. NFPD consists of information collected from fisheries monitoring work on rivers, lakes and transitional and coastal waters (TraC). This monitoring work is undertaken by the Environment Agency.

This particular dataset reports fish counts per run, total fish counts, Carle and Strub population estimates for quantitative surveys and log abundance data (where applicable) for ALL Species (including hybrids) caught on each freshwater survey for all areas and years. Site and survey information and surveys where zero fish were recorded are also included.

Note: The initial version of this dataset (published February 2016) did not contain Carle and Strub population estimates for quantitative surveys or surveys where zero fish were recorded. Attribution statement: © Environment Agency copyright and/or database right 2016. All rights reserved.

Initial sites ranked on the metrics total area, shape index and contagion index. Number in parentheses shows ranking. Sites in bold represent those selected for egg transport tests.

This statistic shows the results of a survey in which respondents were asked on their opinions of salt as opposed to freshwater fishery and aquaculture products in the European Union (EU-28) in 2016. A majority of ** percent of respondents prefer products from the sea, followed by ** percent who have no preference.

The Biodiversity Science Database is a compilation of fish community data from DFO Science Surveys. Data includes: sampling site, date, fish counts, fish species, and associated habitat information. This database was established to support fish species at risk research through the DFO Species at Risk Program and is used primarily for updating the current status of fish species at risk populations across Southern Ontario. The dataset has been constrained to sampling site characteristics for placement on Great Lakes DataStream; the original is available via the Government of Canada Open Data portal, see Data Source URL.

The diversion of freshwater from the Mississippi River is intended to mitigate saltwater intrusion from the Gulf of Mexico and to lessen the concomitant loss of wetland areas. Though effective, freshwater diversion can affect wildlife and habitat; therefore, prediversion and postdiversion data collections are necessary to identify effects. The Davis Pond freshwater diversion area is located between the Mississippi River and Bayou Lafourche and extends to Barataria Bay Basin, Louisiana. Results and interpretations from the prediversion biomonitoring done in 2001- which included data on fish, eagles, and bivalves - are presented in the U.S. Geological Survey (USGS) Scientific Investigations Report 2008-5067, "Davis Pond Freshwater Prediversion Biomonitoring Study: Freshwater Fisheries and Eagles." The postdiversion data generated approximately 6 years later from the sampling of fish whole bodies are presented here in this USGS Data Series. An accompanying log of postdiversion study site photographs was also produced in USGS Data Series 605, "Photographic Images Captured While Sampling for Bald Eagles near the Davis Pond Freshwater Diversion Structure in Barataria Bay, Louisiana (2009-10). This data set consists of measurements of organochlorines detected in largemouth bass, blue catfish and striped mullet samples collected in 2007-2009, approximately six years after the Davis Pond freshwater diversion structure was operational. Samples are from the Mississippi River, Lake Cataouatche, Bayou Couba, and Lake Salvador.

The diversion of freshwater from the Mississippi River is intended to mitigate saltwater intrusion from the Gulf of Mexico and to lessen the concomitant loss of wetland areas. Though effective, freshwater diversion can affect wildlife and habitat; therefore, prediversion and postdiversion data collections are necessary to identify effects. The Davis Pond freshwater diversion area is located between the Mississippi River and Bayou Lafourche and extends to Barataria Bay Basin, Louisiana. Results and interpretations from the prediversion biomonitoring done in 2001- which included data on fish, eagles, and bivalves - are presented in the U.S. Geological Survey (USGS) Scientific Investigations Report 2008-5067, "Davis Pond Freshwater Prediversion Biomonitoring Study: Freshwater Fisheries and Eagles." The postdiversion data generated approximately 6 years later from the sampling of fish whole bodies are presented here in this USGS Data Series. An accompanying log of postdiversion study site photographs was also produced in USGS Data Series 605, "Photographic Images Captured While Sampling for Bald Eagles near the Davis Pond Freshwater Diversion Structure in Barataria Bay, Louisiana (2009-10). Figures 16A and 16C represent the concentration of iron detected in largemouth bass, blue catfish and striped mullet samples collected in 2007-2009, approximately six years after the Davis Pond freshwater diversion structure was operational. Figure 16B compares these concentrations to those collected in the 2001 prediversion study. Samples are from the Mississippi River, Lake Cataouatche, Bayou Couba, and Lake Salvador.

The diversion of freshwater from the Mississippi River is intended to mitigate saltwater intrusion from the Gulf of Mexico and to lessen the concomitant loss of wetland areas. Though effective, freshwater diversion can affect wildlife and habitat; therefore, prediversion and postdiversion data collections are necessary to identify effects. The Davis Pond freshwater diversion area is located between the Mississippi River and Bayou Lafourche and extends to Barataria Bay Basin, Louisiana. Results and interpretations from the prediversion biomonitoring done in 2001- which included data on fish, eagles, and bivalves - are presented in the U.S. Geological Survey (USGS) Scientific Investigations Report 2008-5067, "Davis Pond Freshwater Prediversion Biomonitoring Study: Freshwater Fisheries and Eagles." The postdiversion data generated approximately 6 years later from the sampling of fish whole bodies are presented here in this USGS Data Series. An accompanying log of postdiversion study site photographs was also produced in USGS Data Series 605, "Photographic Images Captured While Sampling for Bald Eagles near the Davis Pond Freshwater Diversion Structure in Barataria Bay, Louisiana (2009-10). Figures 15A and 15C represent the concentration of copper detected in largemouth bass, blue catfish and striped mullet samples collected in 2007-2009, approximately six years after the Davis Pond freshwater diversion structure was operational. Figure 15B compares these concentrations to those collected in the 2001 prediversion study. Samples are from the Mississippi River, Lake Cataouatche, Bayou Couba, and Lake Salvador.

The diversion of freshwater from the Mississippi River is intended to mitigate saltwater intrusion from the Gulf of Mexico and to lessen the concomitant loss of wetland areas. Though effective, freshwater diversion can affect wildlife and habitat; therefore, prediversion and postdiversion data collections are necessary to identify effects. The Davis Pond freshwater diversion area is located between the Mississippi River and Bayou Lafourche and extends to Barataria Bay Basin, Louisiana. Results and interpretations from the prediversion biomonitoring done in 2001- which included data on fish, eagles, and bivalves - are presented in the U.S. Geological Survey (USGS) Scientific Investigations Report 2008-5067, "Davis Pond Freshwater Prediversion Biomonitoring Study: Freshwater Fisheries and Eagles." The postdiversion data generated approximately 6 years later from the sampling of fish whole bodies are presented here in this USGS Data Series. An accompanying log of postdiversion study site photographs was also produced in USGS Data Series 605, "Photographic Images Captured While Sampling for Bald Eagles near the Davis Pond Freshwater Diversion Structure in Barataria Bay, Louisiana (2009-10).

Figures 17A and 17C represent the concentration of lead detected in largemouth bass, blue catfish and striped mullet samples collected in 2007-2009, approximately six years after the Davis Pond freshwater diversion structure was operational. Figure 17B compares these concentrations to those collected in the 2001 prediversion study. Samples are from the Mississippi River, Lake Cataouatche, Bayou Couba, and Lake Salvador.

The diversion of freshwater from the Mississippi River is intended to mitigate saltwater intrusion from the Gulf of Mexico and to lessen the concomitant loss of wetland areas. Though effective, freshwater diversion can affect wildlife and habitat; therefore, prediversion and postdiversion data collections are necessary to identify effects. The Davis Pond freshwater diversion area is located between the Mississippi River and Bayou Lafourche and extends to Barataria Bay Basin, Louisiana. Results and interpretations from the prediversion biomonitoring done in 2001- which included data on fish, eagles, and bivalves - are presented in the U.S. Geological Survey (USGS) Scientific Investigations Report 2008-5067, "Davis Pond Freshwater Prediversion Biomonitoring Study: Freshwater Fisheries and Eagles." The postdiversion data generated approximately 6 years later from the sampling of fish whole bodies are presented here in this USGS Data Series. An accompanying log of postdiversion study site photographs was also produced in USGS Data Series 605, "Photographic Images Captured While Sampling for Bald Eagles near the Davis Pond Freshwater Diversion Structure in Barataria Bay, Louisiana (2009-10). Figures 14A and 14C represent the concentration of chromium detected in largemouth bass, blue catfish and striped mullet samples collected in 2007-2009, approximately six years after the Davis Pond freshwater diversion structure was operational. Figure 14B compares these concentrations to those collected in the 2001 prediversion study. Samples are from the Mississippi River, Lake Cataouatche, Bayou Couba, and Lake Salvador.

In response to the need to augment electrofishing surveys of golden perch, Macquaria ambigua (an important endemic freshwater fish in southeastern Australia), with other non-lethal survey methods, the utility of environmental DNA (eDNA) as an index of relative fish abundance/biomass was investigated. From three adjacent rivers, five sites in each were sampled for eDNA immediately before electrofishing during sequential years. Up to six individuals or 10 kg of electrofished golden perch (200–548 mm total length) were caught or observed site−1. Analyses of concurrent eDNA concentrations revealed no significant relationship with the relative abundance of golden perch, but there was with relative biomass—manifesting as increasing eDNA concentrations between 1.1 and approximately 5.5 kg biomass site−1, after which concentrations stabilized at greater biomasses. Future research warrants assessing the viability of sampling eDNA for spatio-temporally monitoring rivers where low biomasses of golden perch (1–5 kg site−1) are likely to occur.

The diversion of freshwater from the Mississippi River is intended to mitigate saltwater intrusion from the Gulf of Mexico and to lessen the concomitant loss of wetland areas. Though effective, freshwater diversion can affect wildlife and habitat; therefore, prediversion and postdiversion data collections are necessary to identify effects. The Davis Pond freshwater diversion area is located between the Mississippi River and Bayou Lafourche and extends to Barataria Bay Basin, Louisiana. Results and interpretations from the prediversion biomonitoring done in 2001- which included data on fish, eagles, and bivalves - are presented in the U.S. Geological Survey (USGS) Scientific Investigations Report 2008-5067, "Davis Pond Freshwater Prediversion Biomonitoring Study: Freshwater Fisheries and Eagles." The postdiversion data generated approximately 6 years later from the sampling of fish whole bodies are presented here in this USGS Data Series. An accompanying log of postdiversion study site photographs was also produced in USGS Data Series 605, "Photographic Images Captured While Sampling for Bald Eagles near the Davis Pond Freshwater Diversion Structure in Barataria Bay, Louisiana (2009-10). Figures 18A and 18C represent the concentration of magnesium detected in largemouth bass, blue catfish and striped mullet samples collected in 2007-2009, approximately six years after the Davis Pond freshwater diversion structure was operational. Figure 18B compares these concentrations to those collected in the 2001 prediversion study. Samples are from the Mississippi River, Lake Cataouatche, Bayou Couba, and Lake Salvador.

The diversion of freshwater from the Mississippi River is intended to mitigate saltwater intrusion from the Gulf of Mexico and to lessen the concomitant loss of wetland areas. Though effective, freshwater diversion can affect wildlife and habitat; therefore, prediversion and postdiversion data collections are necessary to identify effects. The Davis Pond freshwater diversion area is located between the Mississippi River and Bayou Lafourche and extends to Barataria Bay Basin, Louisiana. Results and interpretations from the prediversion biomonitoring done in 2001- which included data on fish, eagles, and bivalves - are presented in the U.S. Geological Survey (USGS) Scientific Investigations Report 2008-5067, "Davis Pond Freshwater Prediversion Biomonitoring Study: Freshwater Fisheries and Eagles." The postdiversion data generated approximately 6 years later from the sampling of fish whole bodies are presented here in this USGS Data Series. An accompanying log of postdiversion study site photographs was also produced in USGS Data Series 605, "Photographic Images Captured While Sampling for Bald Eagles near the Davis Pond Freshwater Diversion Structure in Barataria Bay, Louisiana (2009-10). This data set consists of measurements of aliphatic hydrocarbons (AHs) detected in largemouth bass, blue catfish and striped mullet samples collected in 2007-2009, approximately six years after the Davis Pond freshwater diversion structure was operational. Samples are from the Mississippi River, Lake Cataouatche, Bayou Couba, and Lake Salvador.

Description:

All fish catch data of all methods across all streams sampled at the SAFE project, Danum Valley and surrounding oil palm areas. Please note this is the raw dataset and may contain errors that need correcting/editing. I have tried to correct the majority of errors, but all were corrected in seperate files prior to analysis, so please see specific datasets in relation to specific papers already published. All changes are detailed in the notes column or listed here if more general.

All Rasbora caught in 2013 are labelled as cf. sumatrana as they were not differentiated from R. hubbsi. All Systomus changed to Barbodes. All Tor labelled as T. tambra, with no differentiation between tambra and tambroides. From 2018 onwards, all R. sumatrana have been renamed as R. pycnopeza. New captures were not pit tagged. Fish mortality are tracked in the data.

In 2018, some sites were sampled twice.

In this version, several changes and new spreadsheets have been added on top of previous versions. This includes: 1. Electrofishing setup - the voltage used in electrofishing corresponding to the conductivity measured; 2. Stream _variables along transect- detailed environmental data collect along transect at each site; 3. Riparian survey, with data on the riparian surveys along the fishing transect. The sheet "Data" has been renamed Capture_Data. Environmental data 2017 sheet has been renamed and updated to Environmental Data site level, to include summarized data by site and by year.

Project: This dataset was collected as part of the following SAFE research project: Composition and abundance of tropical freshwater vertebrate communities across a land use gradient

XML metadata: GEMINI compliant metadata for this dataset is available here

Files: This consists of 1 file: RawDataFish_with_Riparian_V3.0.xlsx

RawDataFish_with_Riparian_V3.0.xlsx

This file contains dataset metadata and 6 data tables:

1. Capture_Data (described in worksheet Capture_Data)

   Description: Fish catch data

   Number of fields: 18

   Number of data rows: 18994

   Fields:

   • Date: Date that stream was sampled (Field type: date)
   • Stream: Which stream was sampled (Field type: location)
   • RA.: Which research assistant helped do the work? (Field type: comments)
   • Researcher: Which researcher conducted the work? (Field type: categorical)
   • Method: What method was used to catch the fish (Field type: categorical)
   • Cast_or_Trap_Numer: The cast or trap numer that the fish was caught at (Field type: numeric)
   • Distance: The distance along the transect in which the fish was caught (Field type: numeric)
   • Taxon: Species sampled (Field type: taxa)
   • N: The number of fish caught at that stream, location and date (Field type: numeric)
   • Pittagnumber: The 10 digit pit tag number (Field type: id)
   • Recapture: Has this fish been caught before? (Field type: categorical)
   • Length: Total length of fish (Field type: numeric)
   • Weight: Weight of fish (Field type: numeric)
   • Specimen: Was this fish taken as a specimen? (Field type: categorical)
   • Stable_isotope_Fin: Number of the stable isotope sample of all fin clips if they were taken (Field type: numeric)
   • Stable_isotope_Muscle: Number of the stable isotope sample of all muscle samples if they were taken (Field type: numeric)
   • Notes: Notes, includes any data changes, fish deaths etc. (Field type: comments)
   • Mortality: Mortality - fish deaths (Field type: categorical)

2. Electofishing_Setup (described in worksheet Electofishing_Setup)

   Description: The voltage and conductivity used for electrofishing

   Number of fields: 7

   Number of data rows: 60

   Fields:

   • Stream: Which stream was sampled (Field type: location)
   • Date: Date that stream was sampled (Field type: date)
   • Conductivity_of_stream: Stream conductivity (Field type: numeric)
   • Stream_temperature: Stream water temperature (Field type: numeric)
   • RunNum: Which electrofishing pass (run) (Field type: numeric)
   • Voltage: Voltage set on the electrofishing kit (Field type: numeric)
   • Electrofisher: Data collectors (Field type: id)

3. Stream_Variables along transect (described in worksheet Stream_Variables along transect)

   Description: Stream environmental data along fishing transect of each site. Data from 2018 onwards

   Number of fields: 13

   Number of data rows: 131

   Fields:

   • Stream: Which stream was sampled (Field type: location)
   • Date: Date measured (Field type: date)
   • Landuse: Landuse of the stream sampled (Field type: categorical)
   • Distance_on_stream: Distance of measured stream variables along transect (Field type: numeric)
   • Flow: Average flow of the stream (Field type: numeric)
   • Wetted_width: wetted width of the stream (Field type: numeric)
   • Depth: Average stream depth (Field type: numeric)
   • sand: Stream substrate (Field type: numeric)
   • gravel: Stream substrate (Field type: numeric)
   • pebbles: Stream substrate (Field type: numeric)
   • large_rocks: Stream substrate (Field type: numeric)
   • bedrock: Stream substrate (Field type: numeric)
   • Notes: Notes, includes any data changes, fish deaths etc. (Field type: comments)

4. Riparian survey along transect (described in worksheet Riparian_survey_along_transect)

   Description: Riparian surveys of each stream along the 500m transect. Data from 2018 onwards

   Number of fields: 15

   Number of data rows: 352

   Fields:

   • Stream: Which stream was sampled (Field type: location)
   • Date: Sampling date (Field type: date)
   • Landuse: Landuse of the stream sampled (Field type: categorical)
   • Distance: Distance on the stream from first RT plot point (Field type: numeric)
   • Upstream: Canopy openness (Field type: numeric)
   • away_from_stream: Canopy openness (Field type: numeric)
   • downstream: Canopy opennes (Field type: numeric)
   • Towards_river: Canopy openness (Field type: numeric)
   • Average_total_area_not_occupied: Average reading across the 4 (Field type: numeric)
   • Percent_area_not_occupied: Percent overhead area not occupied by canopy (Field type: numeric)
   • Overstory_density_: Overstory density - area occupied (Field type: numeric)
   • Vine_cover: Estimation of vine cover (Field type: numeric)
   • Forest_quality_score: Visual assessment of the forest quality (Field type: numeric)
   • Notes: Notes or remarks (Field type: comments)
   • Ras: Data collectors (Field type: id)

5. EnvironmentalData_sitelevel (described in worksheet EnvironmentalData_sitelevel)

   Description: Averaged data of streams on a site level

   Number of fields: 23

   Number of data rows: 51

   Fields:

   • Stream: Which stream was sampled (Field type: location)
   • Year: Sampling year (Field type: date)
   • Landuse: Landuse of the stream sampled (Field type: categorical)
   • Turbidity: Stream water turbidity (Field type: numeric)
   • Flow: Average flow of the stream (Field type: numeric)
   • Wetted_width: Average wetted width of the stream (Field type: numeric)
   • Depth: Average stream depth (Field type: numeric)
   • sand: Average stream substrate (Field type: numeric)
   • gravel: Average Stream substrate (Field type: numeric)
   • pebbles: Average stream substrate (Field type: numeric)
   • large_rocks: Average stream substrate (Field type: numeric)
   • bedrock: Average stream substrate (Field type: numeric)
   • Littoral.leaf.litter.cover: Average leaf litter on stream bed (Field type: numeric)
   • pH: Stream pH (Field type: numeric)
   • Temperature: Stream water temperature (Field type: numeric)
   • O2: Dissolved oxygen (Field type: numeric)
   • Conductivity: Stream conductivity (Field type: numeric)
   • Canopy.openness: Averaged canopy openness above the stream, average from upstream, downstream, left and right bank measurements (Field type: numeric)
   • Sedimentation: Is there sediment within the stream? Yes or No (Field type: categorical)
   • CanopyOpennessRiparian: Average canopy openness in the riparian, average from upstream, downstream, away from the stream and towards the stream measurements (Field type: numeric)
   • Vine: Average % vine cover (Field type: numeric)
   • FQ: Average SAFE project forest quality score (0-5) (Field type: numeric)
   • Tree: Average density of trees (Field type: numeric)

6. Riparian_OP 2017 (described in worksheet Riparian_OP 2017)

   Description: Averaged data by stream of all measured environmental variables for OP streams in 2017

   Number of fields: 24

   Number of data rows: 20

   Fields:

   • Stream: Which stream was sampled (Field type: location)
   • Landuse: Landuse of the stream sampled (Field type: categorical)
   • Turbidity: Stream water turbidity