About this Dataset

2019 Estuarine Nutrient Enrichment Water Quality Monitoring Data For Cape Cod National Seashore (Certified)

As part of the Northeast Coastal and Barrier Network's Estuarine Nutrient Enrichment Monitoring program, Network staff continued to estuarine water quality at several park units. This file contains spatial (i.e., not continuous) water quality data collected during the 2019 field season at Cape Cod National Seashore.
Organization: Department of the Interior
Last updated: 2025-09-14T19:51:13.640420
Tags: caco, cape-cod-national-seashore, ecological-framework-water-water-quality-nutrient-dynamics, ecological-framework-water-water-quality-water-chemistry, environment, estuary, inland-waters, massachsetts, monitoring, national-park-service, ncbn, northeast-coastal-and-barrier-network, northeast-region, nutrient-enrichment, resource-management, virginia, vital-signs, water, water-quality

Tables

CACO 2019

@usgov.doi_gov_2019_estuarine_nutrient_enrichment_water_quali_b25ba659.caco_2019

31.36 kB
197 rows
26 columns

CREATE TABLE caco_2019 (
  "park" VARCHAR,
  "sample_year" DOUBLE,
  "stratum" DOUBLE,
  "event_id" VARCHAR,
  "hex_num" DOUBLE,
  "hex_area_ha" DOUBLE  -- Hex Area (ha),
  "site_type" DOUBLE,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "depth_type" DOUBLE,
  "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  -- Depth (m),
  "turbidity_ntu" DOUBLE,
  "chl_a_ug_l" DOUBLE,
  "actual_lat" DOUBLE,
  "actual_long" DOUBLE,
  "ph" DOUBLE,
  "certified_date" TIMESTAMP,
  "certified_by" VARCHAR
);

2019 CACO Certified TOC Data

@usgov.doi_gov_2019_estuarine_nutrient_enrichment_water_quali_b25ba659.n_2019_caco_certified_toc_data

11.39 kB
42 rows
12 columns

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