About this Dataset

2019 Estuarine Nutrient Enrichment Water Quality Monitoring Data For Fire Island National Seashore (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 during the 2019 field season at Fire Island National Seashore.
Organization: Department of the Interior
Last updated: 2023-08-24T04:03:49.506083
Tags: ecological-framework-water-water-quality-nutrient-dynamics, ecological-framework-water-water-quality-water-chemistry, environment, estuary, fiis, fire-island-national-seashore, 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

FIIS 2019

@usgov.doi_gov_2019_estuarine_nutrient_enrichment_water_quali_55742548.fiis_2019

28.65 KB
193 rows
28 columns


CREATE TABLE fiis_2019 (
  "park" VARCHAR,
  "sample_year" DOUBLE,
  "stratum" DOUBLE,
  "event_id" VARCHAR,
  "hex_num" DOUBLE,
  "hex_area" DOUBLE,
  "site_type" DOUBLE,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "depth_type" DOUBLE,
  "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" VARCHAR
);

2019 FIIS Certified TOC Data

@usgov.doi_gov_2019_estuarine_nutrient_enrichment_water_quali_55742548.n_2019_fiis_certified_toc_data

10.52 KB
30 rows
12 columns


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