Estuarine Nutrient Enrichment Water Quality Monitoring Data For Gateway National Recreation Area (Certified) by US Government | Environmental and Climate Sciences

About this Dataset

Estuarine Nutrient Enrichment Water Quality Monitoring Data For Gateway National Recreation Area (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 Gateway National Recreation Area.
Organization: Department of the Interior
Last updated: 2023-08-24T04:08:54.508802
Tags: ecological-framework-water-water-quality-nutrient-dynamics, ecological-framework-water-water-quality-water-chemistry, environment, estuary, gate, gateway-national-recreation-area, 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

GATE 2020

@usgov.doi_gov_estuarine_nutrient_enrichment_water_quality_mo_c7f58e90.gate_2020

87.33 KB
1596 rows
28 columns


CREATE TABLE gate_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
);

GATE TOC 2020

@usgov.doi_gov_estuarine_nutrient_enrichment_water_quality_mo_c7f58e90.gate_toc_2020

10.7 KB
30 rows
12 columns


CREATE TABLE gate_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
);