About this Dataset

Paired Sentinel-2 – Water Quality Databases For Estuaries And Tidal Freshwater Rivers.

There are five datasets included in this collection. One dataset (SiteInventoryunique.shp) provides metadata for sampling stations associated with estuarine water quality data focused on chlorophyll measurements from 1984 to 2021 and with ancillary data parameters added. Water quality data compiled by US EPA from multiple sources are provided in a separate .csv file (surfchl_withSiteInvID.csv) also downloadable from EPA's Estuary Data Mapper (EDM; www.epa.gov/edm). Chlorophyll data were collected as part of a project to refine algorithms for chlorophyll a and harmful algae using Sentinel 2 remote sensing data. Water quality data observations can be matched to the station file using the SiteInvID variable.

A station inventory (Sentinel2matchedsets_surface_uniqstns_NAD83.shp) and two additional datasets (also in EDM) are available with matched chlorophyll - remote sensing Sentinel 2 Level 2A data (Sent2matchsurfchl_wStnIndex.csv) and with matched chlorophyll - Sentinel 2 Level 1C data (....csv).
Organization: U.S. Environmental Protection Agency
Last updated: 2024-03-08T23:48:33.910108
Tags: chlorophyll, estuaries, estuary, freshwater-tidal-river, remote-sensing, sentinel-2, united-states

Tables

Sent2matchsurfchl WStnIndex

@usgov.epa_gov_paired_sentinel_2_water_quality_databases_for__e9be0b61.sent2matchsurfchl_wstnindex

3.43 MB
15,033 rows
79 columns

CREATE TABLE sent2matchsurfchl_wstnindex (
  "index" BIGINT,
  "lat_pt" DOUBLE,
  "lng_pt" DOUBLE,
  "date" TIMESTAMP,
  "cloudprobability_med" DOUBLE,
  "cloudprobability_sd" DOUBLE,
  "cloudandshadow_med" BIGINT,
  "cloudandshadow_sd" BIGINT,
  "arosol_med" DOUBLE,
  "arosol_sd" DOUBLE,
  "blue_med" DOUBLE,
  "blue_sd" DOUBLE,
  "green_med" DOUBLE,
  "green_sd" DOUBLE,
  "red_med" DOUBLE,
  "red_sd" DOUBLE,
  "nir_med" DOUBLE,
  "nir_sd" DOUBLE,
  "rededge1_med" DOUBLE,
  "rededge1_sd" DOUBLE,
  "rededge2_med" VARCHAR,
  "rededge2_sd" VARCHAR,
  "rededge3_med" DOUBLE,
  "rededge3_sd" DOUBLE,
  "rededge4_med" DOUBLE,
  "rededge4_sd" DOUBLE,
  "swir1_med" DOUBLE,
  "swir1_sd" DOUBLE,
  "swir2_med" DOUBLE,
  "swir2_sd" DOUBLE,
  "sentinel_id" VARCHAR,
  "siteid" VARCHAR,
  "date_unity" VARCHAR,
  "pixelcount" BIGINT,
  "date_utc" VARCHAR,
  "project" VARCHAR,
  "depth_m" VARCHAR,
  "layer" VARCHAR,
  "temp_c" VARCHAR,
  "do_mg_l" VARCHAR,
  "salinity_ppt" VARCHAR,
  "turb_ntu" VARCHAR,
  "chl_ug_l" DOUBLE,
  "doc_mg_l" VARCHAR,
  "method" VARCHAR,
  "chl_category" VARCHAR,
  "groups" VARCHAR,
  "method_group" VARCHAR,
  "state" VARCHAR,
  "estuary" VARCHAR,
  "estcode_n" VARCHAR,
  "mgrs" VARCHAR,
  "cloud" DOUBLE,
  "time" VARCHAR,
  "zenith_angle" DOUBLE,
  "azimuth_angle" DOUBLE,
  "timediff" BIGINT,
  "pwater_max" BIGINT,
  "pwater_med" DOUBLE,
  "pwater_min" BIGINT,
  "aerosolfilteredmean" DOUBLE,
  "aerosolfilteredsd" DOUBLE,
  "aerosolfilteredn" BIGINT,
  "aerosolfilteredcv" DOUBLE,
  "aerosolfilteredmedian" DOUBLE,
  "bluefilteredmean" DOUBLE,
  "bluefilteredsd" DOUBLE,
  "bluefilteredn" BIGINT,
  "bluefilteredcv" DOUBLE,
  "bluefilteredmedian" DOUBLE,
  "greenfilteredmean" DOUBLE,
  "greenfilteredsd" DOUBLE,
  "greenfilteredn" BIGINT,
  "greenfilteredcv" DOUBLE,
  "greenfilteredmedian" DOUBLE,
  "minfilterednpixels" BIGINT,
  "medianfilteredcv" DOUBLE,
  "keep" BIGINT,
  "stnindex" BIGINT
);