Dataset: Fisheries Inventory, Trout Data, At Rocky Mountain National Park 2021-2022 - Open Format Dataset

About this Dataset

Fisheries Inventory, Trout Data, At Rocky Mountain National Park 2021-2022 - Open Format Dataset

The Cameron Peak Fire and East Troublesome Fire of 2020 were the two largest wildfires in Colorado history. They burned approximately 9% of the Rocky Mountain National Park, raising a concern for trout populations that currently support recreational fishing and success of on-going and future efforts to conserve native trout populations. In this study, we surveyed habitat characteristics and biological communities at 19 sites in summer of 2021 and a subset of 11 sites in summer of 2022 to characterize wildfire impacts on aquatic resources. We were primarily interested in trout population structure and abundance, which were compared to available pre-fire data. In addition, we collected information on physical habitat, water quality, algae and benthic macroinvertebrates because wildfire effects are complex and this array of data helps assist identifying ecological mechanisms that affect aquatic top predators (i.e., trout). The greenback cutthroat trout is listed as state and federally threatened and is the Colorado State Fish. The Colorado River cutthroat trout is a state species of concern and two distinct lineages occur in the burned areas of ROMO. Quantifying wildfire effects on stream ecosystems and trout populations is needed for ROMO to decide whether (1) ongoing conservation actions should continue including the Poudre Headwaters Project, (2) recreational fishing should be regulated, and (3) waters should require trout stocking or will naturally recover via trout immigration from connected populations.For more information see the report here: https://irma.nps.gov/DataStore/Reference/Profile/2304877
Organization: Department of the Interior
Last updated: 2024-08-02T09:35:57.863011
Tags: data-package-type, ecological-framework-biological-integrity-at-risk-biota-te-species-and-communities, ecological-framework-biological-integrity-focal-species-or-communities-fishes, ecological-framework-biological-integrity-focal-species-or-communities-freshwater-communities, fish, imd, macroinvertebrate, national-park-service, nps, nps-inventory-and-monitoring-division, nps-species-inventory-program, post-fire, poudre-headwaters-project, recreational-fishing, rocky-mountain-national-park, romo, trout, wildfire

Tables

ROMOFish TroutData SurveyEvent

@usgov.doi_gov_fisheries_inventory_trout_at_rocky_mountain_na_e19e1e7e.romofish_troutdata_surveyevent

73.34 KB
30 rows
94 columns


CREATE TABLE romofish_troutdata_surveyevent (
  "eventid" VARCHAR,
  "site" VARCHAR,
  "samplingprotocol" VARCHAR,
  "samplesizevalue" BIGINT,
  "samplesizeunit" VARCHAR,
  "samplingeffort" VARCHAR,
  "verbatimstartdatetime" TIMESTAMP,
  "startdate" TIMESTAMP,
  "starttime" VARCHAR,
  "verbatimenddatetime" VARCHAR,
  "enddate" TIMESTAMP,
  "endtime" VARCHAR,
  "countrycode" VARCHAR,
  "stateprovince" VARCHAR,
  "county" VARCHAR,
  "habitatdescription" VARCHAR,
  "verbatimlatitude" DOUBLE,
  "verbatimlongitude" DOUBLE,
  "verbatimcoordinatesystem" VARCHAR,
  "verbatimsrs" VARCHAR,
  "verbatimdatum" VARCHAR,
  "samplesrs" VARCHAR,
  "coordinateuncertaintyinmeters" BIGINT,
  "coordinateprecision" DOUBLE,
  "publicdisplay" VARCHAR,
  "dataaccess" VARCHAR,
  "elevation" BIGINT,
  "eventremarks" VARCHAR,
  "crew" VARCHAR,
  "do_mg_l" DOUBLE,
  "do_percent" VARCHAR,
  "ph" DOUBLE,
  "watertemp" DOUBLE,
  "conductivity" DOUBLE,
  "tubidity1" DOUBLE,
  "tubidity2" VARCHAR,
  "tubidity3" VARCHAR,
  "grabsample" VARCHAR,
  "nitrate" VARCHAR,
  "ammonium" DOUBLE,
  "chlor1" DOUBLE,
  "chlor2" DOUBLE,
  "chlor3" VARCHAR,
  "surberlocationnotes" VARCHAR,
  "channelnotes" VARCHAR,
  "surveycomments" VARCHAR,
  "cc_0m" BIGINT,
  "cc_20m" BIGINT,
  "cc_40m" BIGINT,
  "cc_60m" BIGINT,
  "cc_80m" VARCHAR,
  "cc_100m" VARCHAR,
  "bsi_cover_duff_litter_burned" BIGINT,
  "bsi_green_trees_alive" BIGINT,
  "bsi_brown_trees_scorched" BIGINT,
  "bsi_black_trees_torched" BIGINT,
  "bsi_tree_canopy_mortality" BIGINT,
  "bsi_green_riparian_vegetation_regrowth" BIGINT,
  "bsi_burncategory" VARCHAR,
  "bsi_notes" VARCHAR,
  "edna_reachsamplecollected" VARCHAR,
  "edna_upstreamsamplecollected" VARCHAR,
  "edna_utmzone_reachsample" DOUBLE,
  "edna_utmx_reachsample" DOUBLE,
  "edna_utmy_reachsample" DOUBLE,
  "edna_utmzone_upstreamsample" VARCHAR,
  "edna_utmx_upstreamsample" VARCHAR,
  "edna_utmy_upstreamsample" VARCHAR,
  "edna_notes" VARCHAR,
  "pc_2mm" DOUBLE,
  "pc_2_8mm" DOUBLE,
  "pc_4mm" DOUBLE,
  "pc_5_6mm" DOUBLE,
  "pc_8mm" DOUBLE,
  "pc_11mm" DOUBLE,
  "pc_16mm" DOUBLE,
  "pc_22_6mm" DOUBLE,
  "pc_32mm" DOUBLE,
  "pc_45mm" DOUBLE,
  "pc_64mm" DOUBLE,
  "pc_90mm" DOUBLE,
  "pc_128mm" DOUBLE,
  "pc_180mm" DOUBLE,
  "pc_255mm" DOUBLE,
  "pc_512mm" DOUBLE,
  "pc_1024mm" DOUBLE,
  "pc_2048mm" DOUBLE,
  "pc_4096mm" DOUBLE,
  "pc_over4096mm" DOUBLE,
  "reachlength" DOUBLE,
  "reachwidthft" DOUBLE,
  "reachwidthm" DOUBLE,
  "reachdepth" VARCHAR,
  "reacharea" BIGINT
);

ROMOFish TroutData Taxon

@usgov.doi_gov_fisheries_inventory_trout_at_rocky_mountain_na_e19e1e7e.romofish_troutdata_taxon

14.72 KB
6 rows
20 columns


CREATE TABLE romofish_troutdata_taxon (
  "taxonid" VARCHAR,
  "scientificnameid" VARCHAR,
  "scientificname" VARCHAR,
  "acceptednameusage" VARCHAR,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "subgenus" VARCHAR,
  "specificepithet" VARCHAR,
  "infraspecificepithet" VARCHAR,
  "taxonrank" VARCHAR,
  "scientificnameauthorship" VARCHAR,
  "vernacularname" VARCHAR,
  "nomenclaturalcode" VARCHAR,
  "taxonomicstatus" VARCHAR,
  "nomenclaturalstatus" VARCHAR,
  "taxonremarks" VARCHAR
);

ROMOFish TroutData Occurrence

@usgov.doi_gov_fisheries_inventory_trout_at_rocky_mountain_na_e19e1e7e.romofish_troutdata_occurrence

31.92 KB
2140 rows
17 columns


CREATE TABLE romofish_troutdata_occurrence (
  "occurrenceid" VARCHAR,
  "eventid" VARCHAR,
  "basisofrecord" VARCHAR,
  "taxonid" VARCHAR,
  "scientificname" VARCHAR,
  "recordedby" VARCHAR,
  "individualcount" BIGINT,
  "organismquantity" BIGINT,
  "organismquantitytype" VARCHAR,
  "occurrencestatus" VARCHAR,
  "publicdisplay" VARCHAR,
  "dataaccess" VARCHAR,
  "pass" VARCHAR,
  "length" VARCHAR,
  "mass" VARCHAR,
  "geneticssampled" VARCHAR,
  "occurrenceremarks" VARCHAR
);