About this Dataset

Greater Yellowstone Network Published Water Quality Data Through 2023 From The BICAWQ01, GRTEWQ01, And YELLWQ01 Projects As Of 2024-04-29

This data package was created 2025-07-09 06:47:55 by NPSTORET and includes selected project, location, and result data.

Data contained in the Greater Yellowstone Network NPSTORET back-end file (GRYN_BICAWQ01_GRTEWQ01_YELLWQ01_PUBLISHED_THROUGH_2023_NPSTORET_BE.ACCDB) were filtered to include:

Project:

BICAWQ01: Bighorn Canyon NRA - GRYN Water Quality Monitoring
GRTEWQ01: Grand Teton National Park - GRYN Water Quality Monitoring
YELLWQ01: Yellowstone National Park - GRYN Water Quality Monitoring
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 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 2005-06-27 to 2023-11-29. 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=BICAWQ01&mimeType=csv&zip=yes&dataProfile=biological&providers=STORET

https://www.waterqualitydata.us/data/Result/search?project=GRTEWQ01&mimeType=csv&zip=yes&dataProfile=biological&providers=STORET

https://www.waterqualitydata.us/data/Result/search?project=YELLWQ01&mimeType=csv&zip=yes&dataProfile=biological&providers=STORET
Organization: Department of the Interior
Last updated: 2025-07-11T14:16:11.111438
Tags: air-temperature, alkalinity, ammonia, atmospheric-pressure, atmospheric-properties, bacteria, calcium, chloride, copper, depth, dissolved-oxygen, elements-and-compounds, gases, ice, iron, lead, macroinvertebrates, magnesium, manganese, nitrate, nitrite, nitrogen-compounds, npstoret, ph, phosphate, phosphorus, potassium, precipitation, silica, snow, sodium, specific-conductivity, streamflow, sulfate, suspended-solids, turbidity, water-properties, water-quality, water-temperature, weather, zinc

Tables

Characteristics

@usgov.doi_gov_greater_yellowstone_network_published_water_qu_62d8b509.characteristics

339.02 KB
8340 rows
4 columns


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

Locations

@usgov.doi_gov_greater_yellowstone_network_published_water_qu_62d8b509.locations

36.96 KB
18 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_greater_yellowstone_network_published_water_qu_62d8b509.projects

77.42 KB
3 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_greater_yellowstone_network_published_water_qu_62d8b509.results

557.67 KB
35394 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
);