ARCN Arctic Lagoons Monitoring Database Export, 2025-5-16

Description

The National Park Service (NPS) Arctic Network (ARCN) Inventory and Monitoring (I&M) program monitors physical and natural resources in the National Park lands of Alaska including Bering Land Bridge National Preserve, Cape Krusenstern National Monument, Gates of the Arctic National Park and Preserve, Kobuk Valley National Park and Noatak National Preserve. Lagoon Communities and Ecosystems is one of the systems chosen by ARCN for long term scientific monitoring in the Parks. I&M has committed to the highest ideals of data quality by monitoring natural systems in the same way, year after year according to published protocols with the goal of providing reliable scientific information to Park managers . The heart of the data management system for the Lagoon Communities and Ecosystems monitoring program is a Microsoft SQL Server relational database which allows Arctic Network to meet its paramount duty: assuring the security, accessibility and longevity of the monitoring data into the future. In May, 2025 Arctic Network anticipates reductions in the federal work force that threaten the continued support and maintenance of this database. Consequently, Arctic Network is immediately publishing a snapshot of the Lagoon Communities and Ecosystems monitoring database as an emergency step in assuring the data remain available to the public despite the uncertainty of I&M’s future.

Data Quality

The data records in this release are provided ‘as-is’.

Inventory and Monitoring data typically goes through a value-adding life cycle where data are collected, processed for quality, validated and then certified for analytical use. Under ideal circumstances I&M policy is to only publish fully certified and documented datasets. Due to the urgency with which these data are being published the user should recognize that some or all of the records in this data release may not have been shepherded through all quality control steps, and may or may not contain accurate indicators of quality. Central Alaska Network is publishing data of unconstrained quality in the belief that it will serve the public interest more than withholding the data entirely.

Some databases contain a CertificationLevel column for each record describing its quality. Table 2 lists the CertificationLevels and their definitions. The database tables described in this report may, or may not have the CertificationLevel column and may contain other metadata columns containing data quality ratings. In such cases look for documentation in each CSV data file’s accompanying metadata file.

Table 2. Data quality indicator columns.

CertificationLevel Description
Raw Data as transcribed from field measurements, downloaded from logger files or otherwise received with no quality control processing applied.
Provisional Data that have received quality control processing and been validated for provisional internal use, but have not yet been certified by the project leader.
Certified Analytical quality.

Methods

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

Resources

Name Format Description Link
ARCN_Lagoons_Database_Table_Export_FishDiets_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_FishDiets_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_LagoonNotes_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_LagoonNotes_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_lutFishSpecies_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_lutFishSpecies_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_Ponar_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_Ponar_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_Reports_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_Reports_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_SamplingEvents_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_SamplingEvents_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_Sites_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_Sites_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_WaterLevel_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_WaterLevel_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_WaterQualityContinuous_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_WaterQualityContinuous_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_WaterQualityDiscrete_Chukchi_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_WaterQualityDiscrete_Chukchi_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_WaterQualityDiscrete_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_WaterQualityDiscrete_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_WorkLog_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_WorkLog_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN-Lagoons-Data-Quality-Report.html HTML Open resource
0 List of table and query exports in the ARCN_Lagoons database 2025-05-16.csv CSV Open resource
0README_Database_Export.html HTML Open resource
ARCN_Lagoons_Database_Query_Export_Dashboard_DeliverablesStatus_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dashboard_DeliverablesStatus_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dashboard_WaterQualityContinuous_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dashboard_WaterQualityContinuous_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_DatabaseColumnsDescriptions_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_DatabaseColumnsDescriptions_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_DatabaseTableDescriptions_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_DatabaseTableDescriptions_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_Blue_greenAlgae_RFU_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_Blue_greenAlgae_RFU_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_Blue_greenAlgae_ug_L_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_Blue_greenAlgae_ug_L_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_Chlorophyll_mg_L_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_Chlorophyll_mg_L_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_Conductivity_uS_cm_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_Conductivity_uS_cm_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_DistinctSpecies_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_DistinctSpecies_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_Fish_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_Fish_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_Turbidity_FNU_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_Turbidity_FNU_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_WaterQualityDiscrete_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Dataset_WaterQualityDiscrete_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_ExtendedPropertiesHelper_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_ExtendedPropertiesHelper_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_FishSpeciesList_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_FishSpeciesList_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_Fish_MissingTaxa_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_Fish_MissingTaxa_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_Fish_NumberOfRecordsBySiteType_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_Fish_NumberOfRecordsBySiteType_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_Fish_RecordCountsAndSumsBySourceFile_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_Fish_RecordCountsAndSumsBySourceFile_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_Fish_RecordsMissingLatLon_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_Fish_RecordsMissingLatLon_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_FishSize_MissingScientificName_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_FishSize_MissingScientificName_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_Sites_MissingSpatialCoordinates_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_Sites_MissingSpatialCoordinates_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityContinuous_ImpossiblepH_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityContinuous_ImpossiblepH_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_Chlorophyll_mgL_Suspect_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_Chlorophyll_mgL_Suspect_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_Conductivity_uScm_Suspect_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_Conductivity_uScm_Suspect_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_MeansBySourceFile_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_MeansBySourceFile_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_NumberOfRecordsBySiteType_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_NumberOfRecordsBySiteType_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_pH_Impossible_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_pH_Impossible_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_SalinityGT70_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_SalinityGT70_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_Temperature_Suspect_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_Temperature_Suspect_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_Turbidity_FNU_Suspect_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_QC_WaterQualityDiscrete_Turbidity_FNU_Suspect_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_Fish_CountsByYearLagoonSiteGearTypeSpecies_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_Fish_CountsByYearLagoonSiteGearTypeSpecies_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_FishDiets_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_FishDiets_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_Chll_mgLByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_Chll_mgLByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_ConductivityByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_ConductivityByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_DO_mglByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_DO_mglByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_DO_PctByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_DO_PctByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_pHByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_pHByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_SalinityByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_SalinityByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_TemperatureByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_TemperatureByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_Turbidit_FNUByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_Turbidit_FNUByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_WaterDepthByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Query_Export_Summary_WaterQualityDiscrete_WaterDepthByLagoonSiteTypeYearMonth_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_BirdDiversity_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_BirdDiversity_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_DataQualityFlags_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_DataQualityFlags_Ver._2025-05-16.csv_Metadata.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_DataQualityIssues_Ver._2025-05-16.csv CSV Open resource
ARCN_Lagoons_Database_Table_Export_DataQualityIssues_Ver._2025-05-16.csv_Metadata.csv CSV Open resource

Tags

Topics

Categories