Chesapeake Bay Pollution Loads - Nitrogen
State of Maryland
@usgov.state_of_maryland_chesapeake_bay_pollution_loads_nitrogen
State of Maryland
@usgov.state_of_maryland_chesapeake_bay_pollution_loads_nitrogen
Nitrogen pollution from contributing sources in Bay watershed, pounds per year. 1985, 2007, and 2009 - 2012 progress; 2017 and 2025 targets. Data source: EPA Phase 5.3.2 Watershed Model.
Organization: State of Maryland
Last updated: 2020-11-10T17:25:27.161097
Tags: bay, baystat, causes, chesapeake, nitrogen, pollution, watershed, wip
CREATE TABLE table_1 (
"land_river_segment" VARCHAR,
"fips" BIGINT,
"county" VARCHAR,
"tributary_basin" VARCHAR,
"major_basin" VARCHAR,
"source_sector" VARCHAR,
"total_n_1985_lb" DOUBLE -- Total N, 1985 (lb.),
"total_n_2007_lb" DOUBLE -- Total N, 2007 (lb.),
"total_n_2009_lb" DOUBLE -- Total N, 2009 (lb.),
"total_n_2010_lb" DOUBLE -- Total N, 2010 (lb.),
"total_n_2011_lb" DOUBLE -- Total N, 2011 (lb.),
"total_n_2012_lb" DOUBLE -- Total N, 2012 (lb.),
"total_n_2013_lb" DOUBLE -- Total N, 2013 (lb.),
"total_n_2014_lb" DOUBLE -- Total N, 2014 (lb.),
"total_n_2015_lb" DOUBLE -- Total N, 2015 (lb.),
"total_n_2016_lb" DOUBLE -- Total N, 2016 (lb),
"total_n_target_2017_lb" DOUBLE -- Total N Target, 2017 (lb.),
"total_n_target_2025_lb" DOUBLE -- Total N Target 2025 (lb.)
);Anyone who has the link will be able to view this.