About this Dataset

Estimates Of Lake Nitrogen, Phosphorus, And Chlorophyll-a Concentrations To Characterize Harmful Algal Bloom Risk Across The United States

The objective of this research was to predict nutrient, chlorophyll-a, and associated harmful algal bloom, hypoxia, and eutrophication effects in US lakes. This research used nutrient and chlorophyll-a concentration data from the National Lakes Assessment (NLA), soil, landcover, and landscape characteristic data from LakeCat, landscape nutrient data from the National Nutrient Inventory (NNI), nutrient deposition data from the National Atmospheric Deposition Program (NADP), climate data from PRISM, landscape ecosystem data from the Earth Observatory Network (EON), and lake depth data from LAGOS and the National Hydrography Dataset (NHD). Prediction data of total nitrogen, total phosphorus, and chlorophyll-a concentrations were summarized at the catchment and lake watershed scales.
Organization: U.S. Environmental Protection Agency
Last updated: 2024-07-15T20:46:51.068973
Tags: agriculture, chlorophyll, drinking-water, harmful-algal-bloom, lakes, nitrogen, nitrogen-and-co-pollutants, phosphorus, phosphorus-and-nitrogen, water-quality

Tables

CatchmentPredictions

@usgov.epa_gov_estimates_of_lake_nitrogen_phosphorus_and_chlo_a98bacb3.catchmentpredictions

1.97 GB
2,532,676 rows
56 columns

CREATE TABLE catchmentpredictions (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "comid" BIGINT,
  "tn_0705_01" DOUBLE,
  "tp_0705_01" DOUBLE,
  "chla_0705_01" DOUBLE,
  "tn_0705_10" DOUBLE,
  "tp_0705_10" DOUBLE,
  "chla_0705_10" DOUBLE,
  "tn_0705_50" DOUBLE,
  "tp_0705_50" DOUBLE,
  "chla_0705_50" DOUBLE,
  "tn_0707_01" DOUBLE,
  "tp_0707_01" DOUBLE,
  "chla_0707_01" DOUBLE,
  "tn_0707_10" DOUBLE,
  "tp_0707_10" DOUBLE,
  "chla_0707_10" DOUBLE,
  "tn_0707_50" DOUBLE,
  "tp_0707_50" DOUBLE,
  "chla_0707_50" DOUBLE,
  "tn_0710_01" VARCHAR,
  "tp_0710_01" VARCHAR,
  "chla_0710_01" VARCHAR,
  "tn_0710_10" VARCHAR,
  "tp_0710_10" VARCHAR,
  "chla_0710_10" VARCHAR,
  "tn_0710_50" VARCHAR,
  "tp_0710_50" VARCHAR,
  "chla_0710_50" VARCHAR,
  "tn_1205_01" VARCHAR,
  "tp_1205_01" VARCHAR,
  "chla_1205_01" VARCHAR,
  "tn_1205_10" VARCHAR,
  "tp_1205_10" VARCHAR,
  "chla_1205_10" VARCHAR,
  "tn_1205_50" VARCHAR,
  "tp_1205_50" VARCHAR,
  "chla_1205_50" VARCHAR,
  "tn_1207_01" VARCHAR,
  "tp_1207_01" VARCHAR,
  "chla_1207_01" VARCHAR,
  "tn_1207_10" VARCHAR,
  "tp_1207_10" VARCHAR,
  "chla_1207_10" VARCHAR,
  "tn_1207_50" VARCHAR,
  "tp_1207_50" VARCHAR,
  "chla_1207_50" VARCHAR,
  "tn_1210_01" VARCHAR,
  "tp_1210_01" VARCHAR,
  "chla_1210_01" VARCHAR,
  "tn_1210_10" VARCHAR,
  "tp_1210_10" VARCHAR,
  "chla_1210_10" VARCHAR,
  "tn_1210_50" VARCHAR,
  "tp_1210_50" VARCHAR,
  "chla_1210_50" VARCHAR
);

WatershedPredictions

@usgov.epa_gov_estimates_of_lake_nitrogen_phosphorus_and_chlo_a98bacb3.watershedpredictions

21.05 MB
112,021 rows
19 columns

CREATE TABLE watershedpredictions (
  "wbcomid" BIGINT,
  "tn_0705" DOUBLE,
  "tp_0705" DOUBLE,
  "chla_0705" DOUBLE,
  "tn_0707" DOUBLE,
  "tp_0707" DOUBLE,
  "chla_0707" DOUBLE,
  "tn_0710" DOUBLE,
  "tp_0710" DOUBLE,
  "chla_0710" DOUBLE,
  "tn_1205" DOUBLE,
  "tp_1205" DOUBLE,
  "chla_1205" DOUBLE,
  "tn_1207" DOUBLE,
  "tp_1207" DOUBLE,
  "chla_1207" DOUBLE,
  "tn_1210" DOUBLE,
  "tp_1210" DOUBLE,
  "chla_1210" DOUBLE
);