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: 2023-08-24T04:15:05.258348
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

30.63 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,
  "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,
  "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.12 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
);