2019 Estuarine Nutrient Enrichment Water Quality Monitoring Data For Fire Island National Seashore (Certified)
Department of the Interior
@usgov.doi_gov_2019_estuarine_nutrient_enrichment_water_quali_55742548
Department of the Interior
@usgov.doi_gov_2019_estuarine_nutrient_enrichment_water_quali_55742548
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: 2025-09-14T19:54:39.744880
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
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 -- 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" VARCHAR
);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
);Anyone who has the link will be able to view this.