Chesapeake Bay Pollution Loads - Phosphorus
State of Maryland
@usgov.state_of_maryland_chesapeake_bay_pollution_loads_phosphorus
State of Maryland
@usgov.state_of_maryland_chesapeake_bay_pollution_loads_phosphorus
Phosphorus 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:24:41.748254
Tags: bay, baystat, causes, chesapeake, phosphorus, 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_p_1985_lb" DOUBLE -- Total P, 1985 (lb.),
"total_p_2007_lb" DOUBLE -- Total P, 2007 (lb.),
"total_p_2009_lb" DOUBLE -- Total P, 2009 (lb.),
"total_p_2010_lb" DOUBLE -- Total P, 2010 (lb.),
"total_p_2011_lb" DOUBLE -- Total P, 2011 (lb.),
"total_p_2012_lb" DOUBLE -- Total P, 2012 (lb.),
"total_p_2013_lb" DOUBLE -- Total P, 2013 (lb.),
"total_p_2014_lb" DOUBLE -- Total P, 2014 (lb.),
"total_p_2015_lb" DOUBLE -- Total P, 2015 (lb.),
"total_p_2016_lb" DOUBLE -- Total P, 2016 (lb.),
"total_p_target_2017_lb" DOUBLE -- Total P Target, 2017 (lb.),
"total_p_target_2025_lb" DOUBLE -- Total P Target 2025 (lb.)
);Anyone who has the link will be able to view this.