S12: TMDL 100/200 for WY2003 CH3D-FC (91x96 grid)
TMDL_100_200 (Simulation Completed on Aug. 17, 2006)
Summary
For this simulation
all streams and stormwater outfalls were set to Part I of the
water quality standard of 100 cfu/100 ml and all WWTPs were set
to 200 cfu/100 ml. The daily max was
used to calculate a 30-day moving average to compare to the
water quality standard of 14 cfu/100
ml.
This page summarizes
the results of selected nodes (Canary
Nodes) from the CH3D-FC 91x96 grid. A group of nine contiguous nodes was
selected for each Canary Node (the colored cells in the Canary Nodes figure).
For each group of nine nodes the time series of simulated FC
expressed as 30-day moving geomean
concentrations (colored lines) are displayed (cfu/100
ml) in the plots listed below. The water quality limit for Part
I of the shellfish harvesting
bacteria criteria of 14 cfu/100
ml (geometric mean) is also displayed.
Groups
The data plotted are
the time series of simulated canary nodes for each group. Grid
averages consisting of the 30-day rolling geometric mean in
the highest 1/2/3/4/6/9 grid cells were also calculated. Plots
were generated for the surface and depth-averaged individual
grids and for the surface and depth-averaged grid averages.
Spreadsheet of canary
node groups and coordinates: CanaryNodes.xls
Use
the ENVVEST Spatial
Data Viewer to find the id’s of individual nodes (select
GENERAL tab -> Highlight Canary Node: “91x96 Grid”
to id individual nodes).
Plots
Plots are provided
for each canary node group:
Select from plot
index: 100/200 plot index
Download all plots
as zipfile: S12all_GMplots.zip
Download all plots
as pdf file: S12all_GMplots.pdf
Calculation Results
The raw data for the
time series for each group as ascii
text and m-files are available: S12_GMtime_series_raw.zip
Calculation results
in zipfile: S12_GMcalculation_results.zip
Explanation of calculation results
100/200 Simulation
results (Streams, Stormwater, and WWTP set to Part I
of the standard) |
|
Sheetname |
Explanation |
Units |
dailymax |
Simulated maximum daily
FC concentration from Oct 1, 2002 to Sep 29,
2003 (364 days) columns A:I are surface nodes,
Colums J:R are depth-averaged nodes. |
cfu/100ml |
m30day |
Moving 30 day Geomean of
daily max FC from Oct 30, 2002 to Sep 29, 2003
(334 days) columns A:I are surface nodes,
Colums J:R are depth-averaged nodes (data were transformed
by log10(FC+1) to calculate geomean).
|
cfu/100ml |
EX14 |
Compares moving 30-day Geomean
to 14 cfu/100, cell has 1 if FC>=14, column sum is
number of days for exceedance.
|
true/false |
gridAVG_surf |
Surface nodes: The 30-day
rolling geometric mean in the highest 1/2/3/4/6/9 grid
cells, Col A is grid with max levels, Col B is avg of
top 2 grids, Col C is average of top 3 grids, Col D
is average of top 4 grids, Col E is average of Top 6
grids, and Col F is average of all 9 grids |
cfu/100ml |
fc_target_surf |
Surface nodes: The fraction
reduction needed as 1 - 14/geomean; negative value means
no reduction needed (if geomean=0, -1000 is result);
Col A is result for top 3 grids, Col B is result for
top 4 grids, Col C is result for Top 6 grids, and Col
D is result for all 9 grids
|
fraction reduction
needed if positive |
gridAVG_depthavg |
Depth-averaged nodes: The
30-day rolling geometric mean in the highest 1/2/3/4/6/9
grid cells, Col A is grid with max levels, Col B is
avg of top 2 grids, Col C is average of top 3 grids,
Col D is average of top 4 grids, Col E is average of
Top 6 grids, and Col F is average of all 9 grids |
cfu/100ml |
fc_target_depthavg |
Depth-averaged nodes:The
fraction reduction needed as 1 - 14/geomean; negative
value means no reduction needed (if geomean=0, -1000
is result); Col A is result for top 3 grids, Col B is
result for top 4 grids, Col C is result for Top 6 grids,
and Col D is result for all 9 grids |
fraction reduction
needed if positive |
|
