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

Algal Biomass

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.algal_biomass
  • 49.72 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
);

Channel

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.channel
  • 34.11 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
  • 72.73 kB
  • 1,523 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
);

Events

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.events
  • 74.75 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
);

Human Influence

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.human_influence
  • 24.23 kB
  • 1,175 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
  • 91.3 kB
  • 3,995 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
);

Photos

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.photos
  • 87.11 kB
  • 5,864 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
);

Reaches

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.reaches
  • 38.32 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
);

Slope

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.slope
  • 65.15 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
);

Table 16

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.table_16
  • 35.14 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
);

Transect Invasives

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.transect_invasives
  • 18.82 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
);

WaterChemistry

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.waterchemistry
  • 82.58 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
);

WaterQuality

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.waterquality
  • 112.96 kB
  • 2,626 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
);

WoodyDebris AboveBank

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.woodydebris_abovebank
  • 56.1 kB
  • 3,436 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
);

WoodyDebris Bankfull

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2021.woodydebris_bankfull
  • 63.07 kB
  • 3,599 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
);

Share link

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