Estuarine Nutrient Enrichment Water Quality Monitoring Data For Colonial National Historical Park (Certified) by US Government | Environmental and Climate Sciences

About this Dataset

Estuarine Nutrient Enrichment Water Quality Monitoring Data For Colonial National Historical Park (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 through the most recent field season at Colonial National Historical Park.
Organization: Department of the Interior
Last updated: 2023-08-24T04:08:54.462982
Tags: colo, colonial-national-historical-park, ecological-framework-water-water-quality-nutrient-dynamics, ecological-framework-water-water-quality-water-chemistry, environment, estuary, inland-waters, monitoring, national-park-service, ncbn, new-york, northeast-coastal-and-barrier-network, northeast-region, nutrient-enrichment, resource-management, virginia, vital-signs, water, water-quality

Tables

COLO 2020

@usgov.doi_gov_estuarine_nutrient_enrichment_water_quality_mo_cd49ee36.colo_2020

89.55 KB
1555 rows
28 columns


CREATE TABLE colo_2020 (
  "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_true_false" BOOLEAN
);

COLO TOC 2020

@usgov.doi_gov_estuarine_nutrient_enrichment_water_quality_mo_cd49ee36.colo_toc_2020

12.15 KB
44 rows
12 columns


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