Baselight
Sign In

Klamath Stream Monitoring Data Package 2011-2021

Department of the Interior

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021

Loading...
Loading...

About this Dataset

Klamath Stream Monitoring Data Package 2011-2021

This dataset contains monitoring data for streams at Crater Lake NP, Lassen Volcanic NP, Oregon Caves NMP, Redwood NSP, and Whiskeytown NRA. Streams are significant and productive resources that are influenced by activities both inside and outside parks boundaries. Because healthy streams are vital to park landscapes and ecosystems, we sample physical, biological, and chemical parameters. These varied parameters allow us to measure change over time and across the landscape. Thus, we can detect trends and assess impacts. Since 2011, the Klamath Network has been monitoring streams in five parks. The protocol combines monitoring water quality characteristics of streams, such as the chemical and physical conditions, with monitoring the aquatic communities that the stream supports, such as the fish, plants, and macroinvertebrates. The combined protocol is extremely effective as it can provide both snapshots in time of water quality and habitat properties, as well as long term indications of health from the living assemblages.
Objectives are to:
Determine the status and trends of conditions in wadeable streams.
Assist parks with “impaired quality waters,” also known as “303d” lists as defined by the Clean Water Act.
Assist parks with monitoring of “Outstanding National Resource Waters” or Tier 3 waters as defined by the Clean Water Act.
We measure/collect:
Physical environment including substrate composition, depth, gradient, discharge, stream width, and bank height.
Water anions, cations, and nutrients.
Water quality parameters including dissolved oxygen, temperature, specific conductivity, turbidity, and pH.
Algal samples to determine periphyton biomass.
Benthic macroinvertebrates.
Visual Encounter Surveys for amphibians.
Fish populations.
Photographs to provide visual comparisons over time.
Organization: Department of the Interior
Last updated: 2024-11-02T08:52:31.497269
Tags: ecological-data, ecological-monitoring, long-term-monitoring, national-parks, streams, streams-monitoring, water-quality

Tables

Photos

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.photos
  • 85.07 KB
  • 5864 rows
  • 11 columns
Loading... 

CREATE TABLE photos (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "stream_name" VARCHAR,
  "reach_code" VARCHAR,
  "start_date" TIMESTAMP,
  "event_duplicate" VARCHAR,
  "event_notes" VARCHAR,
  "photograph_name" VARCHAR,
  "date_photo_taken" TIMESTAMP,
  "photo_description" VARCHAR,
  "photo_notes" VARCHAR
);

Algal Biomass

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.algal_biomass
  • 48.55 KB
  • 376 rows
  • 25 columns
Loading... 

CREATE TABLE algal_biomass (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "stream_name" VARCHAR,
  "reach_code" VARCHAR,
  "start_date" TIMESTAMP,
  "event_duplicate" VARCHAR,
  "event_notes" VARCHAR,
  "totalvolume_ml" DOUBLE,
  "compositefiltered_ml" DOUBLE,
  "periphyton_duplicate" VARCHAR,
  "periphyton_comments" VARCHAR,
  "chlorophylla_perfilter" DOUBLE,
  "chlorophyll_notes" VARCHAR,
  "area_sampled_cm2" DOUBLE,
  "chlorophylla" DOUBLE,
  "chloro_fluoro" DOUBLE,
  "chloro_spectro" DOUBLE,
  "chlorophylla_concentration" DOUBLE,
  "method_used" VARCHAR,
  "chlorophyll_duplicate" VARCHAR,
  "ashdrymass" DOUBLE,
  "ashmass" DOUBLE,
  "total_organic_matter" DOUBLE,
  "number_syringe_samples" DOUBLE,
  "number_core_gasket_samples" DOUBLE
);

WoodyDebris Bankfull

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.woodydebris_bankfull
  • 61.59 KB
  • 3599 rows
  • 24 columns
Loading... 

CREATE TABLE woodydebris_bankfull (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "stream_name" VARCHAR,
  "reach_code" VARCHAR,
  "start_date" TIMESTAMP,
  "event_duplicate" VARCHAR,
  "event_notes" VARCHAR,
  "transect" VARCHAR,
  "transect_duplicate" VARCHAR,
  "transectnotes" VARCHAR,
  "count_gt_15m_length_0_1_0_3_dia" DOUBLE,
  "count_gt_15m_length_0_3_0_6_dia" DOUBLE,
  "count_gt_15m_length_0_6_0_8_dia" DOUBLE,
  "count_gt_15m_length_and_gt_0_8_dia" DOUBLE,
  "count_5_to_15m_length_and_0_1_0_3_dia" DOUBLE,
  "count_5_to_15m_length_and_0_3_0_6_dia" DOUBLE,
  "count_5_to_15m_length_and_0_6_0_8_dia" DOUBLE,
  "count_5_to_15m_length_and_gt_0_8_dia" DOUBLE,
  "count_1_5_to_5m_length_and_0_1_to_0_3_dia" DOUBLE,
  "count_1_5_to_5m_length_and_0_3_to_0_6_dia" DOUBLE,
  "count_1_5_to_5m_length_and_0_6_to_0_8_dia" DOUBLE,
  "count_1_5_to_5m_length_and_gt_0_8_dia" DOUBLE,
  "bankfull_duplicate" VARCHAR,
  "bankfull_notes" VARCHAR
);

Reaches

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.reaches
  • 37.42 KB
  • 243 rows
  • 20 columns
Loading... 

CREATE TABLE reaches (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "stream_name" VARCHAR,
  "reach_code" VARCHAR,
  "state_code" VARCHAR,
  "x_coord_utm" DOUBLE,
  "y_coord_utm" DOUBLE,
  "x_coord_dd" DOUBLE,
  "y_coord_dd" DOUBLE,
  "utm_zone" VARCHAR,
  "datum" VARCHAR,
  "reach_notes" VARCHAR,
  "gps_type" VARCHAR,
  "county" VARCHAR,
  "center_moved" VARCHAR,
  "date_established" TIMESTAMP,
  "est_channel_width_m" DOUBLE,
  "upstream_length_m" DOUBLE,
  "downsteam_length_m" DOUBLE,
  "year_implemented" DOUBLE
);

WaterQuality

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.waterquality
  • 110.31 KB
  • 2626 rows
  • 25 columns
Loading... 

CREATE TABLE waterquality (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "stream_name" VARCHAR,
  "reach_code" VARCHAR,
  "start_date" TIMESTAMP,
  "event_duplicate" VARCHAR,
  "event_notes" VARCHAR,
  "ph_probe_recalibrated" VARCHAR,
  "conductivity_probe_recalibrated" VARCHAR,
  "do_standard" DOUBLE,
  "do_calibration_check" DOUBLE,
  "do_membrane_replaced" VARCHAR,
  "probe_comments" VARCHAR,
  "probe_duplicate" VARCHAR,
  "probe_type" VARCHAR,
  "time" VARCHAR,
  "temperature_c" DOUBLE,
  "specific_conductivity" DOUBLE,
  "dissolved_oxygen_mg_per_l" DOUBLE,
  "ph" DOUBLE,
  "oxidaton_reduction_potential_mv" DOUBLE,
  "turbidity_ntu" DOUBLE,
  "dissolved_oxygen_saturation" DOUBLE,
  "total_dissolved_solids_ppm" DOUBLE,
  "waterquality_notes" VARCHAR
);

Slope

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.slope
  • 63.62 KB
  • 371 rows
  • 29 columns
Loading... 

CREATE TABLE slope (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "stream_name" VARCHAR,
  "reach_code" VARCHAR,
  "start_date" TIMESTAMP,
  "event_duplicate" VARCHAR,
  "event_notes" VARCHAR,
  "ab_upstream_m" DOUBLE,
  "ab_downstream_m" DOUBLE,
  "bc_upstream_m" DOUBLE,
  "bc_downstream_m" DOUBLE,
  "cd_upstream_m" DOUBLE,
  "cd_downstream_m" DOUBLE,
  "de_upstream_m" DOUBLE,
  "de_downstream_m" DOUBLE,
  "ef_upstream_m" DOUBLE,
  "ef_downstream_m" DOUBLE,
  "fg_upstream_m" DOUBLE,
  "fg_downstream_m" DOUBLE,
  "gh_upstream_m" DOUBLE,
  "gh_downstream_m" DOUBLE,
  "hi_upstream_m" DOUBLE,
  "hi_downstream_m" DOUBLE,
  "ij_upstream_m" DOUBLE,
  "ij_downstream_m" DOUBLE,
  "jk_upstream_m" DOUBLE,
  "jk_downstream_m" DOUBLE,
  "slope_comments" VARCHAR,
  "slope_duplicate" VARCHAR
);

Transect Invasives

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.transect_invasives
  • 18.38 KB
  • 601 rows
  • 13 columns
Loading... 

CREATE TABLE transect_invasives (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "stream_name" VARCHAR,
  "reach_code" VARCHAR,
  "start_date" TIMESTAMP,
  "event_duplicate" VARCHAR,
  "event_notes" VARCHAR,
  "transect" VARCHAR,
  "transect_duplicate" VARCHAR,
  "sidechannel" VARCHAR,
  "species_common_name" VARCHAR,
  "species_scientific_name" VARCHAR,
  "transect_notes" VARCHAR
);

WoodyDebris AboveBank

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.woodydebris_abovebank
  • 54.78 KB
  • 3436 rows
  • 24 columns
Loading... 

CREATE TABLE woodydebris_abovebank (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "stream_name" VARCHAR,
  "reach_code" VARCHAR,
  "start_date" TIMESTAMP,
  "event_duplicate" VARCHAR,
  "event_notes" VARCHAR,
  "transect" VARCHAR,
  "transect_duplicate" VARCHAR,
  "transectnotes" VARCHAR,
  "countgt15mlengthand_0_1_0_3_dia" DOUBLE,
  "countgt15mlengthand_0_3_0_6_dia" DOUBLE,
  "countgt15mlengthand_0_6_0_8_dia" DOUBLE,
  "countgt15mlengthand_gt0_8_dia" DOUBLE,
  "count_5_to_15m_length_and_0_1_to_0_3_dia" DOUBLE,
  "count_5_to_15m_length_and_0_3_to_0_6_dia" DOUBLE,
  "count_5_to_15m_length_and_0_6_to_0_8_dia" DOUBLE,
  "count_5_to_15m_length_and_gt_0_8_dia" DOUBLE,
  "count_1_5_to_5m_length_and_0_1_to_0_3_dia" DOUBLE,
  "count_1_5_to_5m_length_and_0_3_to_0_6_dia" DOUBLE,
  "count_1_5_to_5m_length_and_0_6_to_0_8_dia" DOUBLE,
  "count_1_5_to_5m_length_and_gt_0_8_dia" DOUBLE,
  "abovebank_duplicate" VARCHAR,
  "abovebank_notes" VARCHAR
);

Events

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.events
  • 73 KB
  • 366 rows
  • 30 columns
Loading... 

CREATE TABLE events (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "stream_name" VARCHAR,
  "reach_code" VARCHAR,
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "event_duplicate" VARCHAR,
  "tree_comments" VARCHAR,
  "determination_comments" VARCHAR,
  "slope_comments" VARCHAR,
  "sampling_event_notes" VARCHAR,
  "radio_reception" VARCHAR,
  "cell_reception" VARCHAR,
  "woodydebris_above_notes" VARCHAR,
  "woodydebris_bankfull_notes" VARCHAR,
  "site_sampled" VARCHAR,
  "sampleable" VARCHAR,
  "drivetime_min" DOUBLE,
  "hiketime_min" DOUBLE,
  "nonsampleable" VARCHAR,
  "directions" VARCHAR,
  "locationverified_by_gps" VARCHAR,
  "locationverified_by_localcontacts" VARCHAR,
  "locationverified_by_signs" VARCHAR,
  "locationverified_by_roads" VARCHAR,
  "locationverified_by_topomap" VARCHAR,
  "locationverification_other" VARCHAR,
  "locationverification_otherdesc" VARCHAR,
  "locationverification_none" VARCHAR,
  "gps_type" VARCHAR
);

WaterChemistry

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.waterchemistry
  • 80.65 KB
  • 663 rows
  • 53 columns
Loading... 

CREATE TABLE waterchemistry (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "stream_name" VARCHAR,
  "reach_code" VARCHAR,
  "start_date" TIMESTAMP,
  "event_duplicate" VARCHAR,
  "event_notes" VARCHAR,
  "water_sample_to_lab" VARCHAR,
  "thawing_date" TIMESTAMP,
  "transect" VARCHAR,
  "waterchem_fieldnotes" VARCHAR,
  "water_temp_c" DOUBLE,
  "air_temp_c" DOUBLE,
  "field_sample_duplicate" VARCHAR,
  "lab_replicate" VARCHAR,
  "nitrogen_total_mg_per_l" DOUBLE,
  "nitrogen_total_date" TIMESTAMP,
  "nitrogen_below_detect_limit" VARCHAR,
  "nitrogen_below_quant_limit" VARCHAR,
  "phosphorus_total_mg_per_l" DOUBLE,
  "phosphorus_total_date" TIMESTAMP,
  "phosphorus_below_detect_limit" VARCHAR,
  "phosphorus_below_quant_limit" VARCHAR,
  "sodium_dissolved_mg_per_l" DOUBLE,
  "sodium_dis_date" TIMESTAMP,
  "sodium_below_detect_limit" VARCHAR,
  "sodium_below_quant_limit" VARCHAR,
  "potassium_dissolved_mg_per_l" DOUBLE,
  "potassium_dis_date" TIMESTAMP,
  "potassium_below_detect_limit" VARCHAR,
  "potassium_below_quant_limit" VARCHAR,
  "calcium_dissolved_mg_per_l" DOUBLE,
  "calcium_dis_date" TIMESTAMP,
  "calcium_below_detect_limit" VARCHAR,
  "calcium_below_quant_limit" VARCHAR,
  "magnesium_dissolved_mg_per_l" DOUBLE,
  "magnesium_dis_date" TIMESTAMP,
  "magnesium_below_detect_limit" VARCHAR,
  "magnesium_below_quant_limit" VARCHAR,
  "sulfate_dissolved_mg_per_l" DOUBLE,
  "sulfate_dis_date" TIMESTAMP,
  "sulfate_below_detect_limit" VARCHAR,
  "sulfate_below_quant_limit" VARCHAR,
  "chloride_dissolved_mg_per_l" DOUBLE,
  "chloride_dis_date" TIMESTAMP,
  "chloride_below_detect_limit" VARCHAR,
  "chloride_below_quant_limit" VARCHAR,
  "org_carbon_dissolved_mg_per_l" DOUBLE,
  "org_carbon_dis_date" TIMESTAMP,
  "org_carbon_below_detect_limit" VARCHAR,
  "org_carbon_below_quant_limit" VARCHAR,
  "reachchem_comments" VARCHAR,
  "reachchem_notes" VARCHAR
);

Human Influence

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.human_influence
  • 23.66 KB
  • 1175 rows
  • 15 columns
Loading... 

CREATE TABLE human_influence (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "stream_name" VARCHAR,
  "reach_code" VARCHAR,
  "start_date" TIMESTAMP,
  "event_duplicate" VARCHAR,
  "event_notes" VARCHAR,
  "transect" VARCHAR,
  "transect_duplicate" VARCHAR,
  "transect_notes" VARCHAR,
  "sidechannel" VARCHAR,
  "bank" VARCHAR,
  "type" VARCHAR,
  "presence" VARCHAR,
  "human_inf_notes" VARCHAR
);

Legacy Trees

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.legacy_trees
  • 89.16 KB
  • 3995 rows
  • 26 columns
Loading... 

CREATE TABLE legacy_trees (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "stream_name" VARCHAR,
  "reach_code" VARCHAR,
  "start_date" TIMESTAMP,
  "event_duplicate" VARCHAR,
  "event_notes" VARCHAR,
  "transect" VARCHAR,
  "transect_duplicate" VARCHAR,
  "transect_veg_notes" VARCHAR,
  "sidechannel" VARCHAR,
  "tree_visible_right" VARCHAR,
  "tree_visible_left" VARCHAR,
  "trees_not_visable" VARCHAR,
  "tree_dbh_left" VARCHAR,
  "tree_dbh_right" VARCHAR,
  "tree_height_left_m" DOUBLE,
  "tree_height_right_m" DOUBLE,
  "tree_distance_left_m" DOUBLE,
  "tree_distance_right_m" DOUBLE,
  "tree_type_left" VARCHAR,
  "tree_type_right" VARCHAR,
  "tree_taxon_left" VARCHAR,
  "tree_taxon_right" VARCHAR,
  "tree_notes" VARCHAR,
  "tree_duplicate" VARCHAR
);

Table 16

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.table_16
  • 34.32 KB
  • 369 rows
  • 18 columns
Loading... 

CREATE TABLE table_16 (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "stream_name" VARCHAR,
  "reach_code" VARCHAR,
  "start_date" TIMESTAMP,
  "event_duplicate" VARCHAR,
  "event_notes" VARCHAR,
  "anc_volume_1_ml" BIGINT,
  "anc_volume_2_ml" DOUBLE,
  "anc_volume_3_ml" DOUBLE,
  "anc_titrant_1_n" DOUBLE,
  "anc_titrant_2_n" DOUBLE,
  "anc_titrant_3_n" DOUBLE,
  "anc_reading_1" DOUBLE,
  "anc_reading_2" DOUBLE,
  "anc_reading_3" DOUBLE,
  "comments" VARCHAR,
  "anc_duplicate" VARCHAR
);

Channel

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.channel
  • 33.31 KB
  • 343 rows
  • 17 columns
Loading... 

CREATE TABLE channel (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "stream_name" VARCHAR,
  "reach_code" VARCHAR,
  "start_date" TIMESTAMP,
  "event_duplicate" VARCHAR,
  "event_notes" VARCHAR,
  "channel_pattern" VARCHAR,
  "channel_constraint" VARCHAR,
  "constraint_feature" VARCHAR,
  "channel_percent" DOUBLE,
  "bankfull_width_m" DOUBLE,
  "valley_width_m" DOUBLE,
  "valley_border_visible" VARCHAR,
  "channel_notes" VARCHAR,
  "channel_duplicate" VARCHAR,
  "scouring" DOUBLE
);

Electro Species

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.electro_species
  • 71.03 KB
  • 1523 rows
  • 39 columns
Loading... 

CREATE TABLE electro_species (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "stream_name" VARCHAR,
  "reach_code" VARCHAR,
  "start_date" TIMESTAMP,
  "event_duplicate" VARCHAR,
  "event_notes" VARCHAR,
  "efishing" VARCHAR,
  "wave_form" VARCHAR,
  "volts" DOUBLE,
  "pulse_rate" DOUBLE,
  "pulse_width" DOUBLE,
  "shock_time_sec" DOUBLE,
  "fish_time_min" DOUBLE,
  "sampling_distance_m" DOUBLE,
  "reach_electrofished" VARCHAR,
  "water_visibility" VARCHAR,
  "sampling_notes" VARCHAR,
  "count" BIGINT,
  "length_min_mm" DOUBLE,
  "length_max_mm" DOUBLE,
  "anomaly_count" BIGINT,
  "mortality_count" BIGINT,
  "collected_near_trana" VARCHAR,
  "collected_near_tranb" VARCHAR,
  "collected_near_tranc" VARCHAR,
  "collected_near_trand" VARCHAR,
  "collected_near_trane" VARCHAR,
  "collected_near_tranf" VARCHAR,
  "collected_near_trang" VARCHAR,
  "collected_near_tranh" VARCHAR,
  "collected_near_trani" VARCHAR,
  "collected_near_tranj" VARCHAR,
  "species_notes" VARCHAR,
  "size_category_mm" VARCHAR,
  "specimen_name" VARCHAR,
  "species_scientific_name" VARCHAR,
  "lifestage" VARCHAR,
  "unique" VARCHAR
);

Share link

Anyone who has the link will be able to view this.