About this Dataset

Water Quality And Seagrass Datasets For Estuarine Nutrient Enrichment Monitoring Data Analysis—Trend Analysis For Northeast Coastal And Barrier (NCBN) I&M Network Parks

Tabular datasets in text format (.CSV) containing data on water quality (discrete and continuous) and seagrass extent and health.
Organization: Department of the Interior
Last updated: 2025-09-14T18:39:27.962119
Tags: analysis, ecological-framework-biological-integrity-focal-species-or-communities-estuarine-communities, ecological-framework-water-water-quality-nutrient-dynamics, eelgrass, elevation, estuarine, estuary, monitoring, northeast, nutrient-enrichment, nutrients, power-analysis, ruppia-maritima, seagrass, seawrack, trends, water-quality, widgeon-grass, widgeongrass, zostera-marina

Tables

Continuous Water Quality Data

@usgov.doi_gov_water_quality_and_seagrass_datasets_for_estuar_d49127dd.continuous_water_quality_data

8.08 MB
226,128 rows
15 columns

CREATE TABLE continuous_water_quality_data (
  "date" TIMESTAMP,
  "temp_deg_c" VARCHAR,
  "salinity_ppt" VARCHAR,
  "do_mg_l" VARCHAR,
  "depth_m" VARCHAR  -- Depth (m),
  "turbidity_ntu" VARCHAR,
  "par1" VARCHAR,
  "par2" VARCHAR,
  "kd" VARCHAR,
  "chl_a_ug_l" VARCHAR,
  "ph" VARCHAR,
  "park" VARCHAR,
  "year" BIGINT,
  "stratum" BIGINT,
  "datetime" TIMESTAMP
);

Discrete Water Quality Data

@usgov.doi_gov_water_quality_and_seagrass_datasets_for_estuar_d49127dd.discrete_water_quality_data

447.3 kB
8,118 rows
29 columns

CREATE TABLE discrete_water_quality_data (
  "park" VARCHAR,
  "sample_year" BIGINT,
  "stratum" BIGINT,
  "event_id" VARCHAR,
  "hex_num" DOUBLE,
  "hex_area" VARCHAR,
  "site_type" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "depth_type" BIGINT,
  "kd" VARCHAR,
  "kd_r_squared" VARCHAR,
  "kd_data_qualifier" VARCHAR,
  "temp_deg_c" VARCHAR,
  "sp_conductance_ms_cm" VARCHAR,
  "salinity_ppt" VARCHAR,
  "do_percentsat" VARCHAR,
  "do_mg_l" VARCHAR,
  "depth_m" VARCHAR  -- Depth.(m),
  "turbidity_ntu" VARCHAR,
  "chl_a_ug_l" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "ph" VARCHAR,
  "certified_date" VARCHAR,
  "certified_by" VARCHAR,
  "qc_notes" VARCHAR,
  "spatial_analysis_true_false" BOOLEAN,
  "datetime" VARCHAR
);

Seagrass Data

@usgov.doi_gov_water_quality_and_seagrass_datasets_for_estuar_d49127dd.seagrass_data

116.24 kB
4,846 rows
35 columns

CREATE TABLE seagrass_data (
  "id" BIGINT,
  "eventid" VARCHAR,
  "location" VARCHAR,
  "sgnetcode" VARCHAR,
  "transect" VARCHAR,
  "quadrat" VARCHAR,
  "species" VARCHAR,
  "date" TIMESTAMP,
  "percent_cover" BIGINT,
  "density_source" VARCHAR,
  "density_zm_field" VARCHAR,
  "shoot_density_0_25m2" VARCHAR,
  "canopy_height" VARCHAR,
  "fruits" BIGINT,
  "shoot_count_core" VARCHAR  -- Shoot.Count.(core),
  "leaf_weight_g" VARCHAR  -- Leaf.weight.(g),
  "sheath_weight_g" VARCHAR  -- Sheath.weight.(g),
  "roots_rhizome_g" VARCHAR  -- Roots+rhizome.(g),
  "grazing_evidence" VARCHAR,
  "epiphytes" VARCHAR,
  "wasting" VARCHAR,
  "tidal_depth" VARCHAR,
  "distance_to_edge_left" VARCHAR,
  "distance_to_edge_center" VARCHAR,
  "distance_to_edge_right" VARCHAR,
  "distance_to_last_shoot_left" VARCHAR,
  "distance_to_last_shoot_center" VARCHAR,
  "distance_to_last_shoot_right" VARCHAR,
  "salinity" VARCHAR,
  "sediment_type_left" VARCHAR,
  "sediment_type_center" VARCHAR,
  "sediment_type_right" VARCHAR,
  "qc_notes_holly_2_26_2020" VARCHAR  -- QC.notes.(Holly.2/26/2020),
  "certified_by" VARCHAR,
  "certified_date" TIMESTAMP
);