About this Dataset

Shenandoah National Park 1979-2022 Water Quality Data From Seven Projects As Of 2025-03-28

This data package was created 2025-03-28 21:29:09 by NPSTORET and includes selected project, location, and result data. Data contained in the Shenandoah National Park (University of Virginia) NPSTORET back-end file (NPS_UVA_NPSTORET_BE_20240122_20240126_0856_20240129_1345.ACCDB) were filtered to include just the data within the park for the following seven projects: Project: - SHEN_UVA_CHANG_1994: Lisa Chang’s Pre-Ph.D. Dissertation Research Data from Shaver Hollow - SHEN_UVA_FISH_IN_SENSITIVE_HABITATS: Fish in Sensitive Habitats - SHEN_UVA_HEADWATER_STUDY_2007: Characterize Threatened and Impaired Headwater Streams and Springs in Shenandoah National Park - SHEN_UVA_HG_BROOK_TROUT_2004: Effects of Stream Water Chemistry on Mercury Concentrations in Brook Trout in Shenandoah National Park - SHEN_UVA_MISC: Miscellaneous data - SHEN_UVA_PRIMARY: University of Virginia's Primary SWAS-VTSSS Program Database - SHEN_UVA_STAN_1995_FLOOD: Understanding the 1995 Staunton River Flood Event in Shenandoah National Park Station: - Include Trip QC And All Station Visit Results Park/Unit Code: - SHEN Activity Start Date (>=1/1/1979 and <=12/31/2022) 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 data table - 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 1979-11-02 to 2022-12-28. This data package is a snapshot in time of multiple National Park Service projects. The most current data for these projects, 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=SHEN_UVA_CHANG_1994&mimeType;=csv&zip;=yes&dataProfile;=biological&providers;=STORET https://www.waterqualitydata.us/data/Result/search?project=SHEN_UVA_FISH_IN_SENSITIVE_HABITATS&mimeType;=csv&zip;=yes&dataProfile;=biological&providers;=STORET https://www.waterqualitydata.us/data/Result/search?project=SHEN_UVA_HEADWATER_STUDY_2007&mimeType;=csv&zip;=yes&dataProfile;=biological&providers;=STORET https://www.waterqualitydata.us/data/Result/search?project=SHEN_UVA_HG_BROOK_TROUT_2004&mimeType;=csv&zip;=yes&dataProfile;=biological&providers;=STORET https://www.waterqualitydata.us/data/Result/search?project=SHEN_UVA_MISC&mimeType;=csv&zip;=yes&dataProfile;=biological&providers;=STORET https://www.waterqualitydata.us/data/Result/search?project=SHEN_UVA_PRIMARY&mimeType;=csv&zip;=yes&dataProfile;=biological&providers;=STORET https://www.waterqualitydata.us/data/Result/search?project=SHEN_UVA_STAN_1995_FLOOD&mimeType;=csv&zip;=yes&dataProfile;=biological&providers;=STORET
Organization: Department of the Interior
Last updated: 2025-09-14T19:28:48.358985
Tags: acid-neutralizing-capacity, ammonium, anions, calcium, carbon, cations, chloride, dissolved-organic-compounds, elements-and-compounds, hydrological-properties, ions, magnesium, nitrate, npstoret, ph, potassium, precipitation, silica, sodium, specific-conductivity, streamflow, sulfate, suspended-solids, turbidity, water-properties, water-quality, water-temperature, weather

Tables

Characteristics

@usgov.doi_gov_shenandoah_national_park_1979_2022_water_quali_b68f942c.characteristics

347.07 kB
8,335 rows
4 columns

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

Locations

@usgov.doi_gov_shenandoah_national_park_1979_2022_water_quali_b68f942c.locations

105.52 kB
423 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" VARCHAR,
  "lat_lon_accuracy" VARCHAR,
  "lat_lon_accuracy_unit" VARCHAR,
  "location_description" VARCHAR,
  "travel_directions" VARCHAR,
  "location_purpose" VARCHAR,
  "establishment_date" VARCHAR,
  "huc8_code" VARCHAR,
  "huc12_code" VARCHAR,
  "alternate_location_id" VARCHAR,
  "alternate_location_id_context" VARCHAR,
  "elevation" VARCHAR,
  "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_shenandoah_national_park_1979_2022_water_quali_b68f942c.projects

19.02 kB
7 rows
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_shenandoah_national_park_1979_2022_water_quali_b68f942c.results

7.03 MB
402,724 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
);