Estuarine Nutrient Enrichment Water Quality Monitoring Data For Northeast Coastal And Barrier Network Parks (Certified) 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)

As part of the Northeast Coastal and Barrier Network's Estuarine Nutrient Enrichment Monitoring program, Network staff continued to estuarine water quality at several NCBN park units. This file contains spatial (i.e., not continuous) water quality data collected through the most recent field season.
Organization: Department of the Interior
Last updated: 2023-08-24T04:12:41.943101
Tags: 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 TOC 2021

@usgov.doi_gov_estuarine_nutrient_enrichment_water_quality_mo_41a74494.ncbn_toc_2021

16.54 KB
206 rows
12 columns


CREATE TABLE ncbn_toc_2021 (
  "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
);

NCBN 2021

@usgov.doi_gov_estuarine_nutrient_enrichment_water_quality_mo_41a74494.ncbn_2021

359.11 KB
9094 rows
28 columns


CREATE TABLE ncbn_2021 (
  "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
);