Greater Yellowstone Network Published Water Quality Data Through 2024 From The BICAWQ01, GRTEWQ01, And YELLWQ01 Projects As Of 2025-03-14 by US Government | Environmental and Climate Sciences

About this Dataset

Greater Yellowstone Network Published Water Quality Data Through 2024 From The BICAWQ01, GRTEWQ01, And YELLWQ01 Projects As Of 2025-03-14

This data package was created 2025-03-25 07:54:10 by NPSTORET and includes selected project, location, and result data. Data contained in the Greater Yellowstone Network NPSTORET back-end file (GRYN_NPSTORET_BE_20250314.ACCDB) were filtered to include: Organization: - GRYN: Greater Yellowstone Network 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: - BICA_BHR1: Bighorn River near St. Xavier - BICA_BHR2: Bighorn River at Kane - BICA_LCKHOSSPR1: Lockhart Springhouse - BICA_LCR2: Layout Creek below road - BICA_MIDDLE_LAYOUT: Middle Layout - LCR1.5 - BICA_SHR1: Shoshone River at Kane - BICA_SHR2: Shoshone River near Lovell, WY - GRTE_SNR01: Snake River at Old Flagg Ranch 1000’ Below Bridge - GRTE_SNR02: Snake River Below Site of New Visitor’s Center - YELL_LM000.5M: Lamar River at USGS Gage near Ranger Station - YELL_MD133.2T: Madison River 1.21km West of MT/WY State Boundary - YELL_MDR: Madison River near West Yellowstone, MT - YELL_YS549.7M: Yellowstone River at Corwin Springs Activity Start Date (>=1/1/2006 and <=12/31/2024) 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 2006-01-10 to 2024-11-14. 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-05-11T04:49:21.608336
Tags: acid-neutralizing-capacity, air-temperature, alkalinity, ammonia, atmospheric-pressure, atmospheric-properties, bacteria, calcium, chloride, copper, depth, deuterium, dissolved-oxygen, elements-and-compounds, gases, ice, iron, isotopes, 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

Locations

@usgov.doi_gov_greater_yellowstone_network_published_water_qu_555bf8c2.locations

34.77 KB
13 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
);

Results

@usgov.doi_gov_greater_yellowstone_network_published_water_qu_555bf8c2.results

588.09 KB
37254 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
);

Characteristics

@usgov.doi_gov_greater_yellowstone_network_published_water_qu_555bf8c2.characteristics

338.94 KB
8335 rows
4 columns


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

Projects

@usgov.doi_gov_greater_yellowstone_network_published_water_qu_555bf8c2.projects

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