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-24T08:03:48.487454
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 2022

@usgov.doi_gov_estuarine_nutrient_enrichment_water_quality_mo_41f140b6.ncbn_2022

52.39 KB
497 rows
28 columns


CREATE TABLE ncbn_2022 (
  "park" VARCHAR,
  "sample_year" BIGINT,
  "stratum" BIGINT,
  "event_id" VARCHAR,
  "hex_num" BIGINT,
  "hex_area_ha" 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_true_false" BOOLEAN
);