About this Dataset

Effects Of Acidification On Caged Native Brook Trout

This data package was created 2024-10-17 17:35:42 by NPSTORET and includes selected project, location, and result data.

Data are from an EPA sponsored study on the Effects of Acidification on Caged Native Brook Trout. The data derive from Keil Jason Neff’s University of Tennessee Master’s thesis entitled ‘Physiological Stress in Native Brook Trout (Salvelinus Fontinalis) During Episodic Acidification of Streams in the Great Smoky Mountains National Park’. The dataset includes 9,301 results collected from 2/10/2006 to 6/29/2008 at 6 monitoring locations comprising throughfall and stream sites at Eagle Rocks Prong, Middle Prong, and Ramsey Prong.

Data contained in Great Smoky Mountains National Park NPSTORET back-end file (GRSM_NPSTORET_BE_20240510_20240510_1245.ACCDB) were filtered to include:

Organization:

GRSM: Great Smoky Mountains National Park
Project:
GRSM_EPA: Effects of Acidification on Caged Native Brook Trout
Station:
Include Trip QC And All Station Visit Results
Value Status:
Accepted or Certified (exported as Final) or Final

The data package is organized into five data tables:

Projects.csv - describes the purpose and background of the monitoring efforts
Locations.csv - documents the attributes of the monitoring locations/stations
Results.csv - contains the field measurements, observations, and/or lab analyses for each sample/event/data grouping
HUC.csv - enumerates the domain of allowed values for 8-digit and 12-digit hydrologic unit codes utilized by the Locations datatable
Characteristics.csv - enumerates the domain of characteristics available in NPSTORET to identify what was sampled, measured or observed in Results

Period of record for filtered data is 2006-02-10 to 2008-06-29. This data package is a snapshot in time of one National Park Service project. The most current data for this project, which may be more or less extensive than that in this data package, can be found on the Water Quality Portal at:
https://www.waterqualitydata.us/data/Result/search?project=GRSM_EPA
Organization: Department of the Interior
Last updated: 2025-09-14T17:43:20.975282
Tags: acid-neutralizing-capacity, aluminum, ammonium, calcium, chloride, copper, depth, hydrogen-ions, iron, magnesium, manganese, nitrate, npstoret, ph, potassium, silicon, sodium, specific-conductivity, sulfate, turbidity, water-quality, water-temperature, zinc

Tables

Characteristics

@usgov.doi_gov_effects_of_acidification_on_caged_native_brook_trout.characteristics

342.93 kB
8,210 rows
4 columns

CREATE TABLE characteristics (
  "equis_display_name" VARCHAR,
  "wqx_display_name" VARCHAR,
  "cas_num" VARCHAR,
  "srsidentifier" VARCHAR
);

Locations

@usgov.doi_gov_effects_of_acidification_on_caged_native_brook_trout.locations

27.67 kB
6 rows
40 columns

CREATE TABLE locations (
  "org_code" VARCHAR,
  "park_code" VARCHAR,
  "location_id" VARCHAR,
  "location_name" VARCHAR,
  "location_type" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "lat_lon_method" VARCHAR,
  "lat_lon_datum" VARCHAR,
  "source_map_scale_numeric" BIGINT,
  "lat_lon_accuracy" VARCHAR,
  "lat_lon_accuracy_unit" VARCHAR,
  "location_description" VARCHAR,
  "travel_directions" VARCHAR,
  "location_purpose" VARCHAR,
  "establishment_date" VARCHAR,
  "huc8_code" BIGINT,
  "huc12_code" VARCHAR,
  "alternate_location_id" VARCHAR,
  "alternate_location_id_context" VARCHAR,
  "elevation" DOUBLE,
  "elevation_unit" VARCHAR,
  "elevation_method" VARCHAR,
  "elevation_datum" VARCHAR,
  "elevation_accuracy" VARCHAR,
  "elevation_accuracy_unit" VARCHAR,
  "country_code" VARCHAR,
  "state_code" VARCHAR,
  "county_code" VARCHAR,
  "drainage_area" VARCHAR,
  "drainage_area_unit" VARCHAR,
  "contributing_area" VARCHAR,
  "contributing_area_unit" VARCHAR,
  "well_id" VARCHAR,
  "well_type" VARCHAR,
  "aquifer_name" VARCHAR,
  "formation_type" VARCHAR,
  "well_hole_depth" VARCHAR,
  "well_hole_depth_unit" VARCHAR,
  "well_status" VARCHAR
);

Projects

@usgov.doi_gov_effects_of_acidification_on_caged_native_brook_trout.projects

30.75 kB
1 row
14 columns

CREATE TABLE projects (
  "org_code" VARCHAR,
  "project_id" VARCHAR,
  "project_name" VARCHAR,
  "project_description" VARCHAR,
  "project_start_date" TIMESTAMP,
  "project_duration" VARCHAR,
  "project_type" VARCHAR,
  "qapp_summary" VARCHAR,
  "qapp_approved_indicator" VARCHAR,
  "qapp_approval_agency_name" VARCHAR,
  "study_area_description" VARCHAR,
  "design_sampling_summary" VARCHAR,
  "measurement_quality_objectives" VARCHAR,
  "contact" VARCHAR
);

Results

@usgov.doi_gov_effects_of_acidification_on_caged_native_brook_trout.results

188.52 kB
9,304 rows
89 columns

CREATE TABLE results (
  "org_code" VARCHAR,
  "project_id" VARCHAR,
  "location_id" VARCHAR,
  "activity_id" VARCHAR,
  "activity_type" VARCHAR,
  "medium" VARCHAR,
  "medium_subdivision" VARCHAR,
  "assemblage_sampled_name" VARCHAR,
  "activity_start_date" TIMESTAMP,
  "activity_start_time" VARCHAR,
  "activity_start_time_zone" VARCHAR,
  "activity_end_date" VARCHAR,
  "activity_end_time" VARCHAR,
  "activity_end_time_zone" VARCHAR,
  "activity_relative_depth" VARCHAR,
  "activity_depth" VARCHAR,
  "activity_depth_unit" VARCHAR,
  "activity_upper_depth" VARCHAR,
  "activity_lower_depth" VARCHAR,
  "activity_sampler" VARCHAR,
  "custody_id" VARCHAR,
  "station_visit_comment" VARCHAR,
  "activity_comment" VARCHAR,
  "collection_method_id" VARCHAR,
  "collection_equipment_name" VARCHAR,
  "collection_equipment_description" VARCHAR,
  "container_type" VARCHAR,
  "container_color" VARCHAR,
  "container_size" VARCHAR,
  "container_size_unit" VARCHAR,
  "preparation_method_id" VARCHAR,
  "chemical_preservative" VARCHAR,
  "thermal_preservative" VARCHAR,
  "transport_storage_description" VARCHAR,
  "activity_group_id" VARCHAR,
  "activity_group_name" VARCHAR,
  "activity_group_type" VARCHAR,
  "sampling_component_name" VARCHAR,
  "sampling_component_place_in_series" VARCHAR,
  "characteristic_name" VARCHAR,
  "method_speciation" VARCHAR,
  "filtered_fraction" VARCHAR,
  "result_detection_condition" VARCHAR,
  "result_text" VARCHAR,
  "result_unit" VARCHAR,
  "result_qualifier" VARCHAR,
  "result_status" VARCHAR,
  "result_type" VARCHAR,
  "result_comment" VARCHAR,
  "method_detection_limit" VARCHAR,
  "lower_quantification_limit" VARCHAR,
  "upper_quantification_limit" VARCHAR,
  "limit_comment" VARCHAR,
  "temperature_basis" VARCHAR,
  "statistical_basis" VARCHAR,
  "time_basis" VARCHAR,
  "weight_basis" VARCHAR,
  "particle_size_basis" VARCHAR,
  "precision" VARCHAR,
  "bias" VARCHAR,
  "confidence_interval" VARCHAR,
  "upper_confidence_limit" VARCHAR,
  "lower_confidence_limit" VARCHAR,
  "result_depth_height_measure" VARCHAR,
  "result_depth_height_measure_unit" VARCHAR,
  "analytical_method_id" VARCHAR,
  "analytical_method_id_context" VARCHAR,
  "lab_id" VARCHAR,
  "lab_remark_code" VARCHAR,
  "analysis_start_date" TIMESTAMP,
  "analysis_start_time" VARCHAR,
  "analysis_start_time_zone" VARCHAR,
  "lab_accreditation_indicator" VARCHAR,
  "lab_sample_preparation_id" VARCHAR,
  "dilution_factor" VARCHAR,
  "num_of_replicates" VARCHAR,
  "data_logger_line_name" VARCHAR,
  "biological_intent" VARCHAR,
  "biological_individual_id" VARCHAR,
  "subject_taxon" VARCHAR,
  "unidentified_species_id" VARCHAR,
  "tissue_anatomy" VARCHAR,
  "group_summary_count_or_weight" VARCHAR,
  "group_summary_count_or_weight_unit" VARCHAR,
  "frequency_class_descriptor" VARCHAR,
  "frequency_class_bounds_unit" VARCHAR,
  "frequency_class_lower_bound" VARCHAR,
  "frequency_class_upper_bound" VARCHAR,
  "lab_reported_result" VARCHAR
);