Shenandoah National Park - University Of Virginia Primary Project Water Quality Data From 1979-2023 As Of 2025-03-28 by US Government | Environmental and Climate Sciences

About this Dataset

Shenandoah National Park - University Of Virginia Primary Project Water Quality Data From 1979-2023 As Of 2025-03-28

This data package was created 2025-03-28 10:09:52 by NPSTORET and includes selected project, location, and result data. The included project (SHEN_UVA_Primary) comprises data from the following sources: (1) the Shenandoah Watershed Study (SWAS); (2) quarterly sampling for the Virginia Trout Stream Sensitivity Study (VTSSS); and (3) 1987, 2000, 2010, and 2011 ('decadal') sampling for the Virginia Trout Stream Sensitivity Study. The Shenandoah Water Study (SWAS), initiated in 1979, has both scientific and resource management objectives. The underlying scientific objective of the SWAS program has been to improve understanding of hydro-biogeochemical processes and factors that govern ecosystem conditions in the mountain watersheds of Shenandoah National Park (SHEN). This scientific objective complements a resource management objective that has been defined by the need to document and assess change that is occurring in SHEN ecosystems. Only the data from SWAS and VTSSS collected within SHEN are contained in the SHEN_UVA_Primary project. Other data from these programs collected outside SHEN (e.g., on U.S. Forest Service and other lands) can be obtained from the University of Virginia or the Water Quality Portal under the USFS_UVA_Primary and OTHR_UVA_Primary projects. Data contained in the Shenandoah National Park - University of Virginia NPSTORET back-end file (NPS_UVA_NPSTORET_BE_20250108.ACCDB) were filtered to include: Project: - SHEN_UVA_PRIMARY: University of Virginia's Primary SWAS-VTSSS Program Database Station: - Include Trip QC And All Station Visit Results Park/Unit Code: - SHEN Activity Start Date (>=1/1/1950 and <=12/31/2023) 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 2023-12-28. 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=SHEN_UVA_PRIMARY&mimeType;=csv&zip;=yes&dataProfile;=biological&providers;=STORET
Organization: Department of the Interior
Last updated: 2025-05-11T04:49:22.298599
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_university_of_virgini_9e8ede9f.characteristics

338.94 KB
8335 rows
4 columns


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

Results

@usgov.doi_gov_shenandoah_national_park_university_of_virgini_9e8ede9f.results

6.2 MB
379589 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
);

Projects

@usgov.doi_gov_shenandoah_national_park_university_of_virgini_9e8ede9f.projects

25.41 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
);

Locations

@usgov.doi_gov_shenandoah_national_park_university_of_virgini_9e8ede9f.locations

64.2 KB
69 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" BIGINT,
  "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
);