Pacific Island Network 2007-2023 Water Quality Data From 17 Projects As Of 2025-07-25
Department of the Interior
@usgov.doi_gov_pacific_island_network_2007_2023_water_quality_78350fd8
Loading...
Loading...
Loading...
Loading...
About this Dataset
Pacific Island Network 2007-2023 Water Quality Data From 17 Projects As Of 2025-07-25
This data package was created 2025-07-25 13:47:37 by NPSTORET and includes selected project, location, and result data.
Data contained in the Pacific Island Network NPSTORET back-end file (PACN_NPSTORET_BE_20250725.ACCDB) were filtered to include:
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 2007-04-03 to 2023-12-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=WAPA_TEMP&mimeType=csv&zip=yes&dataProfile=biological&providers=STORET
Organization: Department of the Interior
Last updated: 2025-08-01T23:02:57.117642
Tags: algae, atmospheric-pressure, chlorophyll, depth, dissolved-oxygen, ecosystem-properties, nitrogen, nitrogen-compounds, npstoret, ph, phosphate, phosphorus, salinity, specific-conductivity, streamflow, tides, turbidity, water-quality, water-temperature, wave-height, weather, wind, wind-direction
Tables
Characteristics
@usgov.doi_gov_pacific_island_network_2007_2023_water_quality_78350fd8.characteristics
- 347.15 kB
- 8,341 rows
- 4 columns
Loading...
Loading...
CREATE TABLE characteristics (
"equis_display_name" VARCHAR,
"wqx_display_name" VARCHAR,
"cas_num" VARCHAR,
"srsidentifier" VARCHAR
);Locations
@usgov.doi_gov_pacific_island_network_2007_2023_water_quality_78350fd8.locations
- 167.51 kB
- 1,970 rows
- 40 columns
Loading...
Loading...
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_pacific_island_network_2007_2023_water_quality_78350fd8.projects
- 13.94 kB
- 17 rows
- 14 columns
Loading...
Loading...
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_pacific_island_network_2007_2023_water_quality_78350fd8.results
- 4.4 MB
- 165,184 rows
- 89 columns
Loading...
Loading...
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
);