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: 2025-09-14T19:04:35.670459
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

91.7 kB
1,555 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  -- Depth (m),
  "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.44 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
);