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-09-14T18:59:22.714182
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

92.29 kB
1,075 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  -- Sample Depth (m),
  "temperature_c" DOUBLE  -- Temperature (C),
  "conductivity_us_cm" DOUBLE  -- Conductivity (uS/cm),
  "conductivity_us_cm_flag" DOUBLE  -- Conductivity (uS/cm) Flag,
  "conductivity_us_cm_flagdescription" VARCHAR  -- Conductivity (uS/cm) FlagDescription,
  "salinity_ppt" DOUBLE  -- Salinity (ppt),
  "salinity_ppt_flag" DOUBLE  -- Salinity (ppt) Flag,
  "salinity_ppt_flagdescription" VARCHAR  -- Salinity (ppt) FlagDescription,
  "salinity_psu" DOUBLE  -- Salinity (PSU),
  "salinity_psu_flag" VARCHAR  -- Salinity (PSU) Flag,
  "salinity_psu_flagdescription" VARCHAR  -- Salinity (PSU) FlagDescription,
  "dissolved_oxygen_sat" DOUBLE  -- Dissolved Oxygen (% Sat),
  "dissolved_oxygen_mg_l" DOUBLE  -- Dissolved Oxygen (mg/l),
  "ph" DOUBLE,
  "ph_flag" VARCHAR,
  "ph_flagdescription" VARCHAR,
  "turbidity_fnu" DOUBLE  -- Turbidity (FNU),
  "turbidity_ntu" DOUBLE  -- Turbidity (NTU),
  "turbidity_mg_l" DOUBLE  -- Turbidity (mg/L),
  "chlorophyll_ug_l" DOUBLE  -- Chlorophyll (ug/L),
  "chlorophyll_ug_l_flag" DOUBLE  -- Chlorophyll (ug/L) Flag,
  "chlorophyll_ug_l_flagdescription" VARCHAR  -- Chlorophyll (ug/L) FlagDescription,
  "chlorophyll_ug_l_text" VARCHAR  -- Chlorophyll (ug/L) Text,
  "water_depth_m" DOUBLE  -- Water Depth (m),
  "total_nitrogen_mg_l" VARCHAR  -- Total Nitrogen (mg/L),
  "nitrate_mg_l" VARCHAR  -- Nitrate (mg/L),
  "phosphate_mg_l" VARCHAR  -- Phosphate (mg/L),
  "alkalinity_uequiv_kg" VARCHAR  -- Alkalinity (uEquiv/kg),
  "aragonite" VARCHAR,
  "dissolved_organic_carbon_umol_kg" VARCHAR  -- Dissolved Organic Carbon (umol/kg),
  "secchi_depth_m" VARCHAR  -- Secchi Depth (m),
  "chlorophyll_a_mg_l" DOUBLE  -- Chlorophyll A (mg/L),
  "chlorophyll_a_mg_l_flag" DOUBLE  -- Chlorophyll A (mg/L) Flag,
  "chlorophyll_a_mg_l_flagdescription" VARCHAR  -- Chlorophyll A (mg/L) FlagDescription,
  "chlorophyll_a_mdl" VARCHAR,
  "chlorophyll_rfu" DOUBLE  -- Chlorophyll (RFU),
  "chlorophyllfilteredtimeminutes" VARCHAR,
  "avg_chlorophyll_a_ug_l" DOUBLE  -- Avg Chlorophyll A (ug/L),
  "blue_green_algae_ug_l" DOUBLE  -- Blue-green Algae (ug/L),
  "blue_green_algae_rfu" DOUBLE  -- Blue-green Algae (RFU),
  "oxidation_reduction_potential_mv" DOUBLE  -- Oxidation Reduction Potential (mV),
  "dkn_um" DOUBLE  -- DKN (uM),
  "dkn_mg_l" DOUBLE  -- DKN (mg/L),
  "tkn_um" DOUBLE  -- TKN (uM),
  "tkn_mg_l" DOUBLE  -- TKN (mg/L),
  "tkp_um" DOUBLE  -- TKP (uM),
  "tkp_mg_l" DOUBLE  -- TKP (mg/L),
  "tss_mg_l" DOUBLE  -- TSS (mg/L),
  "par" DOUBLE,
  "avg_phaeophytin_ug_l" DOUBLE  -- Avg Phaeophytin (ug/L),
  "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
);