Estuarine Nutrient Enrichment Water Quality Monitoring Data For Northeast Coastal And Barrier Network Parks (Certified) 2003-2024 by US Government | Environmental and Climate Sciences

About this Dataset

Estuarine Nutrient Enrichment Water Quality Monitoring Data For Northeast Coastal And Barrier Network Parks (Certified) 2003-2024

As part of the Northeast Coastal and Barrier Network's Estuarine Nutrient Enrichment Monitoring program, Network staff continued to measure estuarine water quality at several park units. This file contains spatial and continuous water quality data collected between 2003 to 2024 at Assateague Island National Seashore, Cape Cod National Seashore, Colonial National Historical Park, Fire Island National Seashore, Gateway National Recreation Area, and George Washington Birthplace National Monument.
Organization: Department of the Interior
Last updated: 2025-06-01T07:23:19.252530
Tags: ecological-framework-biological-integrity-focal-species-or-communities-estuarine-communities, ecological-framework-biological-integrity-focal-species-or-communities-intertidal-communities, ecological-framework-biological-integrity-focal-species-or-communities-wetland-communities, ecological-framework-landscapes-nutrient-dynamics-nutrient-dynamics, ecological-framework-water-water-quality-nutrient-dynamics, ecological-framework-water-water-quality-water-chemistry, environment, estuary, inland-waters, monitoring, national-park-service, ncbn, northeast-coastal-and-barrier-network, northeast-region, nutrient-enrichment, resource-management, vital-signs, water, water-quality

Tables

NCBN ENE WQ Certified TOC 2006-2021

@usgov.doi_gov_estuarine_nutrient_enrichment_water_quality_mo_adb81d8a.ncbn_ene_wq_certified_toc_2006_2021

15.94 KB
206 rows
12 columns


CREATE TABLE ncbn_ene_wq_certified_toc_2006_2021 (
  "toc_event_id" BIGINT,
  "location_id" VARCHAR,
  "sample_date" TIMESTAMP,
  "toc_pct" DOUBLE,
  "toc_bdl" BIGINT,
  "tn_pct" DOUBLE,
  "tn_bdl" BIGINT,
  "notes" VARCHAR,
  "lab_methods" VARCHAR,
  "lab" VARCHAR,
  "certified_date" TIMESTAMP,
  "certified_by" VARCHAR
);

NCBN ENE WQ Certified Spatial 2003-2024

@usgov.doi_gov_estuarine_nutrient_enrichment_water_quality_mo_adb81d8a.ncbn_ene_wq_certified_spatial_2003_2024

479.2 KB
10504 rows
28 columns


CREATE TABLE ncbn_ene_wq_certified_spatial_2003_2024 (
  "park" VARCHAR,
  "sample_year" BIGINT,
  "stratum" BIGINT,
  "event_id" VARCHAR,
  "hex_num" DOUBLE,
  "hex_area" DOUBLE,
  "site_type" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "depth_type" BIGINT,
  "kd" DOUBLE,
  "kd_r_squared" DOUBLE,
  "kd_data_qualifier" VARCHAR,
  "temp_deg_c" DOUBLE,
  "sp_conductance_ms_cm" DOUBLE,
  "salinity_ppt" DOUBLE,
  "do_percentsat" DOUBLE,
  "do_mg_l" DOUBLE,
  "depth_m" DOUBLE,
  "turbidity_ntu" DOUBLE,
  "chl_a_ug_l" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "ph" DOUBLE,
  "certified_date" TIMESTAMP,
  "certified_by" VARCHAR,
  "qc_notes" VARCHAR,
  "spatial_analysis" BOOLEAN
);