About this Dataset

Black Canyon Of The Gunnison National Park And Curecanti National Recreation Area 1959-2024 Water Quality Data From The BLCA CURE WQ Project As Of 2024-01-19

This data package was created 2024-10-17 14:21:45 by NPSTORET and includes selected project, location, and result data.

The data derive from three sources: (1) samples collected by the park and analyzed by the USGS National Water Quality Lab that aren’t in the USGS National Water Information System (NWIS); (2) field measurements and observations or lab analyses conducted by park staff that aren’t in NWIS; and (3) NWIS data collected by the USGS that aren’t part of the monitoring program at Black Canyon of the Gunnison National Park and Curecanti National Recreation Area.

Data contained in the Black Canyon of the Gunnison National Park and Curecanti National Recreation Area NPSTORET back-end file (BLCACURE_NPSTORET_BE_20240403_0716.accdb) were filtered to include:

Organization:

BLCACURE: Black Canyon of the Gunnison NP and Curecanti NRA
Station:
Include Trip QC And All Station Visit Results
Value Status:
Accepted or Certified (exported as Final) or Final
Excluded 9670 results because the parameter is not in WQX/EQuIS.

The data package is organized into six 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
Taxon.csv - enumerates the domain of taxa available in NPSTORET to identify the organism sampled for Results

Period of record for filtered data is 1959-06-16 to 2024-01-19. 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=BLCA_CURE_WQ
Organization: Department of the Interior
Last updated: 2024-11-02T08:50:03.381567
Tags: acid-neutralizing-capacity, air-temperature, algae, alkalinity, aluminum, ammonia, antimony, atmospheric-pressure, atmospheric-properties, bacteria, biomass, boron, cadmium, calcium, carbon, chemical-properties, chloride, chlorophyll-a, chromium, copper, depth, dissolved-organic-compounds, dissolved-oxygen, ecosystem-properties, elements-and-compounds, fish, fluoride, hydrogen-ions, hydrological-properties, ions, iron, isotopes, lead, magnesium, manganese, nickel, nitrate, nitrite, nitrogen, nitrogen-compounds, npstoret, organic-nitrogen, particulates, pcbs, pesticide-and-herbicide-contamination, ph, phaeophytin, phosphate, phosphorus, potassium, secchi-depth, silica, sodium, specific-conductivity, streamflow, strontium, sulfate, sulfur, turbidity, water-content, water-properties, water-quality, water-temperature, weather, zinc

Tables

Characteristics

@usgov.doi_gov_black_canyon_of_the_gunnison_national_park_and_22835658.characteristics

334.89 KB
8210 rows
4 columns


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

Locations

@usgov.doi_gov_black_canyon_of_the_gunnison_national_park_and_22835658.locations

30.16 KB
29 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" BIGINT,
  "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_black_canyon_of_the_gunnison_national_park_and_22835658.projects

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

Results

@usgov.doi_gov_black_canyon_of_the_gunnison_national_park_and_22835658.results

1.56 MB
96637 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
);

Taxon

@usgov.doi_gov_black_canyon_of_the_gunnison_national_park_and_22835658.taxon

810.62 KB
40792 rows
2 columns


CREATE TABLE taxon (
  "code" VARCHAR,
  "definition" VARCHAR
);