All Fish catch data at the SAFE project 2011-2019
Creators
- 1. SAFE Project, SEARRP
- 2. Imperial College London
- 3. University Malaysia, Sabah
Description
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:
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)
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)
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)
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)
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)
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 (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)
- Littoral.leaf.litter.cover: 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: Canopy openness above the stream, average from upstream, downstream, left and right bank measurements (Field type: numeric)
- Sedimentation: NA (Field type: categorical)
- CanopyOpennessRiparian: Canopy openness in the riparian, average from upstream, downstream, away from the stream and towards the stream measurements (Field type: numeric)
- Vine: % vine cover (Field type: numeric)
- FQ: Average SAFE project forest quality score (0-1) (Field type: numeric)
- Tree: Density of trees (Field type: numeric)
- DateOPplanted2: Years since oil palm was planted (compared to 2017 sampling date) (Field type: numeric)
- Average500_2bank: Average width of riparian buffers as the sum of both sides of the river. Averaged over 11 locations measured on GIS, but with the width of the river removed. (Field type: numeric)
Date range: 2011-09-19 to 2020-02-18
Latitudinal extent: 4.5000 to 5.0700
Longitudinal extent: 116.7500 to 117.8200
Taxonomic coverage:
All taxon names are validated against the GBIF backbone taxonomy. If a dataset uses a synonym, the accepted usage is shown followed by the dataset usage in brackets. Taxa that cannot be validated, including new species and other unknown taxa, morphospecies, functional groups and taxonomic levels not used in the GBIF backbone are shown in square brackets.
- - Chordata
- - - Amphibia
- - - Actinopterygii
- - - - Synbranchiformes
- - - - - Mastacembelidae
- - - - - - Mastacembelus
- - - - - - - Mastacembelus unicolor
- - - - - - Macrognathus
- - - - - - - Macrognathus keithi
- - - - Anguilliformes
- - - - - Anguillidae
- - - - - - Anguilla
- - - - - - - Anguilla borneensis
- - - - - - - Anguilla marmorata
- - - - Siluriformes
- - - - - Bagridae
- - - - - - Hemibagrus
- - - - - - - Hemibagrus baramensis
- - - - - - - Hemibagrus fortis
- - - - - Clariidae
- - - - - - Clarias
- - - - - - - Clarias anfractus
- - - - - - - Clarias teysmanni
- - - - Cypriniformes
- - - - - Balitoridae
- - - - - - Protomyzon
- - - - - - - Protomyzon borneensis
- - - - - - - Protomyzon griswoldi
- - - - - - - Protomyzon whiteheadi
- - - - - - Homalopteroides
- - - - - - - Homalopteroides stephensoni
- - - - - - Parhomaloptera
- - - - - - - Parhomaloptera microstoma
- - - - - - Gastromyzon
- - - - - - - Gastromyzon ingeri
- - - - - - - Gastromyzon lepidogaster
- - - - - - - Gastromyzon umbrus
- - - - - Nemacheilidae
- - - - - - Nemacheilus
- - - - - - - Nemacheilus olivaceus
- - - - - Cyprinidae
- - - - - - Cyclocheilichthys
- - - - - - Luciosoma
- - - - - - - Luciosoma pelligrinii
- - - - - - Barbonymus
- - - - - - - Barbodes collingwoodi
- - - - - - - Barbonymus balleroides
- - - - - - Rasbora
- - - - - - - Rasbora pycnopeza
- - - - - - - Rasbora elegans
- - - - - - - Rasbora hubbsi
- - - - - - Hampala
- - - - - - - Hampala sabana
- - - - - - Crossocheilus
- - - - - - - Crossocheilus elegans
- - - - - - Leptobarbus
- - - - - - - Leptobarbus melanotaenia
- - - - - - Lobocheilos
- - - - - - - Lobocheilos erinaceus
- - - - - - - Lobocheilos unicornis
- - - - - - Anematichthys
- - - - - - - Anematichthys repasson (as synonym: Cyclocheilichthys repasson)
- - - - - - Nematabramis
- - - - - - - Nematabramis borneensis
- - - - - - - Nematabramis everetti
- - - - - - Osteochilus
- - - - - - - Osteochilus chini
- - - - - - - Osteochilus ingeri
- - - - - - Tor
- - - - - - - Tor tambra
- - - - - - Puntius
- - - - - - - Puntius sealei (as synonym: Barbodes sealei)
- - - - - - Garra
- - - - - - - Garra borneensis
- - - - Perciformes
- - - - - Channidae
- - - - - - Channa
- - - - - - - Channa striata
- - - - - Osphronemidae
- - - - - - Betta
- - - - - - - Betta unimaculata
- - - - - Cichlidae
- - - - - - Oreochromis
- - - - - - - Oreochromis mossambicus
Files
Files
(1.7 MB)
Name | Size | Download all |
---|---|---|
md5:634c729d581931e25b7c4bed4d5cb3d6
|
1.7 MB | Download |