Shenandoah National Park 1979-2022 Water Quality Data From Seven Projects As Of 2024-01-26 by US Government | Environmental and Climate Sciences

About this Dataset

Shenandoah National Park 1979-2022 Water Quality Data From Seven Projects As Of 2024-01-26

This data package was created 2024-10-17 10:51:12 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 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 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 https://www.waterqualitydata.us/data/Result/search?project=SHEN_UVA_FISH_IN_SENSITIVE_HABITATS https://www.waterqualitydata.us/data/Result/search?project=SHEN_UVA_HEADWATER_STUDY_2007 https://www.waterqualitydata.us/data/Result/search?project=SHEN_UVA_HG_BROOK_TROUT_2004 https://www.waterqualitydata.us/data/Result/search?project=SHEN_UVA_MISC https://www.waterqualitydata.us/data/Result/search?project=SHEN_UVA_PRIMARY https://www.waterqualitydata.us/data/Result/search?project=SHEN_UVA_STAN_1995_FLOOD
Organization: Department of the Interior
Last updated: 2024-11-02T08:52:50.951755
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

Projects

@usgov.doi_gov_shenandoah_national_park_1979_2022_water_quali_efbc5892.projects

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

Characteristics

@usgov.doi_gov_shenandoah_national_park_1979_2022_water_quali_efbc5892.characteristics

334.89 KB
8210 rows
4 columns


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