ARCN Lagoons Discrete Water Quality Data, 2003-2024 (Ver. 2025-04-15) by US Government | Environmental and Climate Sciences

About this Dataset

ARCN Lagoons Discrete Water Quality Data, 2003-2024 (Ver. 2025-04-15)

This dataset consists of a snapshot in time of the discrete water quality data collected in the coastal lagoons of northwestern Alaska.

This data release consists of one file, 2025-04-15 ARCN Lagoons Discrete Water Quality Data.csv, containing discrete water quality data from 2003-2024 for the coastal lagoons of Alaska. Data collection is intended to be ongoing. Cumulative updates to this dataset will be added as results are extended.

Methods are described in the monitoring protocol:

Jones T, Apsens S, Miller S, Robards M. 2018. Coastal lagoons vital signs monitoring protocol for the Arctic Network: Volume 1, report narrative, version 1.0. Natural Resource Report. NPS/ARCN/NRR—2018/1824. National Park Service. Fort Collins, Colorado https://irma.nps.gov/DataStore/Reference/Profile/2257596

and standard operating procedures:

Jones T. 2017. Coastal Lagoon Vital Signs Monitoring Protocol for the Arctic Network: Standard Operating Procedures Version 1.0. National Park Service https://irma.nps.gov/DataStore/Reference/Profile/2310242
Organization: Department of the Interior
Last updated: 2025-04-17T22:58:35.472286
Tags: anigaaq, atilagauraq, atiligauraq, aukulak, bering-land-bridge, cape-krusenstern, chemistry, coastal, espenberg, ikpek, imik, kotlik, krusenstern, kupik, lagoon, quality, sisualik, tasaychek, water

Tables

ARCN Lagoons Discrete Water Quality Data 2003-2024 Ver. 2025-04-15

@usgov.doi_gov_arcn_lagoons_discrete_water_quality_2003_2024__77d26862.arcn_lagoons_discrete_water_quality_2003_2024_ver_2025_04_15

90.13 KB
1075 rows
68 columns


CREATE TABLE arcn_lagoons_discrete_water_quality_2003_2024_ver_2025_04_15 (
  "lagoon" VARCHAR,
  "site" VARCHAR,
  "sitetype" VARCHAR,
  "date" TIMESTAMP,
  "sample_depth_m" DOUBLE,
  "temperature_c" DOUBLE,
  "conductivity_us_cm" DOUBLE,
  "conductivity_us_cm_flag" DOUBLE,
  "conductivity_us_cm_flagdescription" VARCHAR,
  "salinity_ppt" DOUBLE,
  "salinity_ppt_flag" DOUBLE,
  "salinity_ppt_flagdescription" VARCHAR,
  "salinity_psu" DOUBLE,
  "salinity_psu_flag" VARCHAR,
  "salinity_psu_flagdescription" VARCHAR,
  "dissolved_oxygen_sat" DOUBLE,
  "dissolved_oxygen_mg_l" DOUBLE,
  "ph" DOUBLE,
  "ph_flag" VARCHAR,
  "ph_flagdescription" VARCHAR,
  "turbidity_fnu" DOUBLE,
  "turbidity_ntu" DOUBLE,
  "turbidity_mg_l" DOUBLE,
  "chlorophyll_ug_l" DOUBLE,
  "chlorophyll_ug_l_flag" DOUBLE,
  "chlorophyll_ug_l_flagdescription" VARCHAR,
  "chlorophyll_ug_l_text" VARCHAR,
  "water_depth_m" DOUBLE,
  "total_nitrogen_mg_l" VARCHAR,
  "nitrate_mg_l" VARCHAR,
  "phosphate_mg_l" VARCHAR,
  "alkalinity_uequiv_kg" VARCHAR,
  "aragonite" VARCHAR,
  "dissolved_organic_carbon_umol_kg" VARCHAR,
  "secchi_depth_m" VARCHAR,
  "chlorophyll_a_mg_l" DOUBLE,
  "chlorophyll_a_mg_l_flag" DOUBLE,
  "chlorophyll_a_mg_l_flagdescription" VARCHAR,
  "chlorophyll_a_mdl" VARCHAR,
  "chlorophyll_rfu" DOUBLE,
  "chlorophyllfilteredtimeminutes" VARCHAR,
  "avg_chlorophyll_a_ug_l" DOUBLE,
  "blue_green_algae_ug_l" DOUBLE,
  "blue_green_algae_rfu" DOUBLE,
  "oxidation_reduction_potential_mv" DOUBLE,
  "dkn_um" DOUBLE,
  "dkn_mg_l" DOUBLE,
  "tkn_um" DOUBLE,
  "tkn_mg_l" DOUBLE,
  "tkp_um" DOUBLE,
  "tkp_mg_l" DOUBLE,
  "tss_mg_l" DOUBLE,
  "par" DOUBLE,
  "avg_phaeophytin_ug_l" DOUBLE,
  "surfaceorbottom" VARCHAR,
  "locationdescription" VARCHAR,
  "latitude_lagoon" DOUBLE,
  "longitude_lagoon" DOUBLE,
  "latitude_site" DOUBLE,
  "longitude_site" DOUBLE,
  "latitude_observation" DOUBLE,
  "longitude_observation" DOUBLE,
  "site_recorded" VARCHAR,
  "comments" VARCHAR,
  "dataqualityissues" VARCHAR,
  "sitedescription" VARCHAR,
  "certificationlevel" VARCHAR,
  "versiondate" VARCHAR
);