Baselight
Sign In

Klamath Stream Monitoring Data Package 2011-2022

Department of the Interior

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022

Loading...
Loading...

About this Dataset

Klamath Stream Monitoring Data Package 2011-2022

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: 2025-05-11T04:53:40.624876
Tags: ecological-data, ecological-monitoring, long-term-monitoring, national-parks, streams, streams-monitoring, water-quality

Tables

KLMN Streams Algal Biomass

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022.klmn_streams_algal_biomass
  • 50.52 KB
  • 437 rows
  • 25 columns
Loading... 

CREATE TABLE klmn_streams_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
);

KLMN Streams ANC

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022.klmn_streams_anc
  • 35.93 KB
  • 429 rows
  • 18 columns
Loading... 

CREATE TABLE klmn_streams_anc (
  "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
);

KLMN Streams Channel

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022.klmn_streams_channel
  • 35.43 KB
  • 401 rows
  • 17 columns
Loading... 

CREATE TABLE klmn_streams_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
);

KLMN Streams Electro Species

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022.klmn_streams_electro_species
  • 75.71 KB
  • 1798 rows
  • 39 columns
Loading... 

CREATE TABLE klmn_streams_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
);

KLMN Streams Events

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022.klmn_streams_events
  • 74.34 KB
  • 425 rows
  • 30 columns
Loading... 

CREATE TABLE klmn_streams_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
);

KLMN Streams Human Influence

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022.klmn_streams_human_influence
  • 24.29 KB
  • 1282 rows
  • 15 columns
Loading... 

CREATE TABLE klmn_streams_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
);

KLMN Streams Legacy Trees

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022.klmn_streams_legacy_trees
  • 96.08 KB
  • 4662 rows
  • 26 columns
Loading... 

CREATE TABLE klmn_streams_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
);

KLMN Streams Photos

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022.klmn_streams_photos
  • 107.34 KB
  • 7344 rows
  • 11 columns
Loading... 

CREATE TABLE klmn_streams_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
);

KLMN Streams Reaches

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022.klmn_streams_reaches
  • 37.42 KB
  • 243 rows
  • 20 columns
Loading... 

CREATE TABLE klmn_streams_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
);

KLMN Streams Slope

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022.klmn_streams_slope
  • 66.97 KB
  • 434 rows
  • 29 columns
Loading... 

CREATE TABLE klmn_streams_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
);

KLMN Streams Transect Invasives

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022.klmn_streams_transect_invasives
  • 18.43 KB
  • 602 rows
  • 13 columns
Loading... 

CREATE TABLE klmn_streams_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
);

KLMN Streams WaterChemistry

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022.klmn_streams_waterchemistry
  • 84.06 KB
  • 755 rows
  • 53 columns
Loading... 

CREATE TABLE klmn_streams_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
);

KLMN Streams WaterQuality

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022.klmn_streams_waterquality
  • 122.69 KB
  • 3080 rows
  • 25 columns
Loading... 

CREATE TABLE klmn_streams_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
);

KLMN Streams WoodyDebris AboveBank

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022.klmn_streams_woodydebris_abovebank
  • 57.78 KB
  • 4013 rows
  • 24 columns
Loading... 

CREATE TABLE klmn_streams_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
);

KLMN Streams WoodyDebris Bankfull

@usgov.doi_gov_klamath_stream_monitoring_data_package_2011_2022.klmn_streams_woodydebris_bankfull
  • 65.74 KB
  • 4176 rows
  • 24 columns
Loading... 

CREATE TABLE klmn_streams_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.