MCDEP Fecal Appendices_all

Appendix 1.
USGS and DWQ Monitoring Data
Table 1-1. Selected USGS Water Discharge Stations for the Irwin, Sugar, Little Sugar and McAlpine
Creek Watersheds
Station number Description Period of record Mean flow, cfs (a)
02146300 Irwin Creek near Charlotte, NC May 1962 to current year 44.3
02146381 Sugar Creek at NC 51 near
Pineville, NC
October 1994 to current
year
97.8
02146530 Little Sugar Creek at Highway 51
at Pineville
June 1997 to current year 92.3
02146600 McAlpine Creek at Sardis Road
near Charlotte, NC
April 1962 to current year 44.1
02146750 McAlpine Creek below McMullen
Creek near Pineville, NC
April 1974 to current year 137
(a) Water year annual mean flow for the period of record.
Table 1-2. DWQ Ambient Monitoring Locations for the Irwin, Sugar, Little Sugar and
McAlpine Creek Watersheds
Station number Description
C8896500 Irwin Creek @ Irwin Cr WWTP nr Charlotte
C9050000 Sugar Creek @ NC Hwy 51 @ Pineville
C9210000 Little Sugar Creek @ NC Hwy 51 @ Pineville
C9370000 McAlpine Creek @ Sardis Rd nr Charlotte
C9680000 McAlpine Creek @ SC SR 2964 nr Camp Cox, SC
Station# C8896500 Irwin Creek
FLOW INFLUENCE ANALYSIS, 1998-2000
y = 61.277x - 412.93
R2 = 0.5084
0
5000
10000
15000
20000
25000
30000
35000
40000
45000
0 100 200 300 400
Flow
Po
l
l
u
t
a
n
t

L
e
v
e
l
y = 28.323x0.9421
10
100
1000
10000
100000
1 10 100 1000
LOG Flow
LO
G

P
o
l
l
u
t
a
n
t

L
e
v
e
l
0
5000
10000
15000
20000
25000
30000
35000
40000
45000
1/1/98 7/20/98 2/5/99 8/24/99 3/11/00 9/27/00
DATE
PO
L
L
U
T
A
N
T

L
E
V
E
L
0
200
400
600
800
1000
1200
FL
O
W
Fecal Coliform (#/100 mL)DISCHARGE (CFS)
1
10
100
1000
10000
100000
1/1/98 7/20/98 2/5/99 8/24/99 3/11/00 9/27/00
DATE
LO
G

P
O
L
L
U
T
A
N
T

L
E
V
E
L
1
10
100
1000
LO
G

F
L
O
W
Fecal Coliform (#/100 mL)DISCHARGE (CFS)
Station# C8896500 Irwin Creek
NUMBER OF OBSERVATIONS:36
DATA RANGE: 1/8/1998 to 12/28/2000
(Error bars display maximum and minimum levels for the month.)
SEASONAL ANALYSIS, 1998-2000
10
100
1000
10000
100000
J F M A M J J A S O N D
Month
Po
l
l
u
t
a
n
t

l
e
v
e
l
Mean fecal coliform, cfu/100mL
Station# C9050000 Sugar Creek
FLOW INFLUENCE ANALYSIS, 1998-2000
y = 23.018x - 697.15
R2 = 0.6911
0
2000
4000
6000
8000
10000
12000
14000
16000
18000
0 100 200 300 400 500 600
Flow
Po
l
l
u
t
a
n
t

L
e
v
e
l
y = 9.8367x0.9369
10
100
1000
10000
100000
10 100 1000
LOG Flow
LO
G

P
o
l
l
u
t
a
n
t

L
e
v
e
l
0
2000
4000
6000
8000
10000
12000
14000
16000
18000
1/1/98 7/20/98 2/5/99 8/24/99 3/11/00 9/27/00
DATE
PO
L
L
U
T
A
N
T

L
E
V
E
L
0
500
1000
1500
2000
2500
FL
O
W
Fecal Coliform (#/100 mL)DISCHARGE (CFS)
1
10
100
1000
10000
100000
1/1/98 7/20/98 2/5/99 8/24/99 3/11/00 9/27/00
DATE
LO
G

P
O
L
L
U
T
A
N
T

L
E
V
E
L
10
100
1000
10000
LO
G

F
L
O
W
Fecal Coliform (#/100 mL)DISCHARGE (CFS)
Station# C9050000 Sugar Creek
NUMBER OF OBSERVATIONS:36
DATA RANGE: 1/6/1998 to 12/19/2000
(Error bars display maximum and minimum levels for the month.)
SEASONAL ANALYSIS, 1998-2000
10
100
1000
10000
100000
J F M A M J J A S O N D
Month
Po
l
l
u
t
a
n
t

l
e
v
e
l
Mean fecal coliform, cfu/100mL
Station# C9210000 Little Sugar Creek
FLOW INFLUENCE ANALYSIS, 1998-2000
y = 24.402x - 683.76
R2 = 0.4738
0
5000
10000
15000
20000
25000
30000
0 100 200 300 400 500 600
Flow
Po
l
l
u
t
a
n
t

L
e
v
e
l
y = 1.1412x1.3405
10
100
1000
10000
100000
10 100 1000
LOG Flow
LO
G

P
o
l
l
u
t
a
n
t

L
e
v
e
l
0
5000
10000
15000
20000
25000
30000
1/1/98 7/20/98 2/5/99 8/24/99 3/11/00 9/27/00
DATE
PO
L
L
U
T
A
N
T

L
E
V
E
L
0
500
1000
1500
2000
2500
FL
O
W
Fecal Coliform (#/100 mL)DISCHARGE (CFS)
1
10
100
1000
10000
100000
1/1/98 7/20/98 2/5/99 8/24/99 3/11/00 9/27/00
DATE
LO
G

P
O
L
L
U
T
A
N
T

L
E
V
E
L
10
100
1000
10000
LO
G

F
L
O
W
Fecal Coliform (#/100 mL)DISCHARGE (CFS)
Station# C9210000 Little Sugar Creek
NUMBER OF OBSERVATIONS:36
DATA RANGE: 1/6/1998 to 12/19/2000
(Error bars display maximum and minimum levels for the month.)
SEASONAL ANALYSIS, 1998-2000
10
100
1000
10000
100000
J F M A M J J A S O N D
Month
Po
l
l
u
t
a
n
t

l
e
v
e
l
Mean fecal coliform, cfu/100mL
Station# C9370000 McAlpine Creek at Sardis Rd
FLOW INFLUENCE ANALYSIS, 1998-2000
y = 28.66x + 226.36
R2 = 0.2807
0
1000
2000
3000
4000
5000
6000
7000
8000
0 50 100 150
Flow
Po
l
l
u
t
a
n
t

L
e
v
e
l
y = 44.764x0.8031
10
100
1000
10000
1 10 100 1000
LOG Flow
LO
G

P
o
l
l
u
t
a
n
t

L
e
v
e
l
0
1000
2000
3000
4000
5000
6000
7000
8000
1/1/98 7/20/98 2/5/99 8/24/99 3/11/00 9/27/00
DATE
PO
L
L
U
T
A
N
T

L
E
V
E
L
0
200
400
600
800
1000
1200
1400
1600
FL
O
W
Fecal Coliform (#/100 mL)DISCHARGE (CFS)
1
10
100
1000
10000
1/1/98 7/20/98 2/5/99 8/24/99 3/11/00 9/27/00
DATE
LO
G

P
O
L
L
U
T
A
N
T

L
E
V
E
L
1
10
100
1000
10000
LO
G

F
L
O
W
Fecal Coliform (#/100 mL)DISCHARGE (CFS)
Station# C9370000 McAlpine Creek at Sardis Rd
NUMBER OF OBSERVATIONS:36
DATA RANGE: 1/20/1998 to 12/12/2000
(Error bars display maximum and minimum levels for the month.)
SEASONAL ANALYSIS, 1998-2000
10
100
1000
10000
J F M A M J J A S O N D
Month
Po
l
l
u
t
a
n
t

l
e
v
e
l
Mean fecal coliform, cfu/100mL
Station# C9680000 McAlpine Creek at SC SR 2964
FLOW INFLUENCE ANALYSIS, 1998-2000
y = 4.553x + 392.69
R2 = 0.2726
0
500
1000
1500
2000
2500
3000
3500
4000
4500
5000
0 200 400 600 800
Flow
Po
l
l
u
t
a
n
t

L
e
v
e
l
y = 24.614x0.7279
10
100
1000
10000
1 10 100 1000
LOG Flow
LO
G

P
o
l
l
u
t
a
n
t

L
e
v
e
l
0
500
1000
1500
2000
2500
3000
3500
4000
4500
5000
1/1/98 7/20/98 2/5/99 8/24/99 3/11/00 9/27/00
DATE
PO
L
L
U
T
A
N
T

L
E
V
E
L
0
500
1000
1500
2000
2500
3000
3500
4000
FL
O
W
Fecal Coliform (#/100 mL)DISCHARGE (CFS)
1
10
100
1000
10000
1/1/98 7/20/98 2/5/99 8/24/99 3/11/00 9/27/00
DATE
LO
G

P
O
L
L
U
T
A
N
T

L
E
V
E
L
1
10
100
1000
10000
LO
G

F
L
O
W
Fecal Coliform (#/100 mL)DISCHARGE (CFS)
Station# C9680000 McAlpine Creek at SC SR 2964
NUMBER OF OBSERVATIONS:36
DATA RANGE: 1/6/1998 to 12/19/2000
(Error bars display maximum and minimum levels for the month.)
Note: The water quality monitoring location (C9680000) and the USGS discharge measurements
(02146750) are not co-located. However, they were considered spatially close enough for this
rough analysis.
SEASONAL ANALYSIS, 1998-2000
10
100
1000
10000
J F M A M J J A S O N D
Month
Po
l
l
u
t
a
n
t

l
e
v
e
l
Mean fecal coliform, cfu/100mL
Table A1-1. DWQ Fecal Coliform Ambient Monitoring Data
Station
Number Station Date Result Remarks
Table A1-1. DWQ Fecal Coliform Ambient Monitoring Data
Station
Number Station Date Result Remarks
Table A1-1. DWQ Fecal Coliform Ambient Monitoring Data
Station
Number Station Date Result Remarks
Appendix 2.
Implementation Plan Outline
DRAFT Outline
Fecal Coliform TMDL Implementation Strategy
1.0 MONITORING
1.1 DWQ Sampling
1.1.1 Location of Sites
1.1.2 Frequency of Sampling
1.1.3 Flow Conditions During Sample Collection
1.1.4 Sample Collection and Laboratory Analyses
1.2 MCDEP Sampling
1.2.1 Location of Sites
1.2.2 Frequency of Sampling
1.2.3 Flow Conditions During Sample Collection
1.2.4 Sample Collection and Laboratory Analyses
1.3 Other Sampling
1.3.1 Location of Sites
1.3.2 Frequency of Sampling
1.3.3 Flow Conditions During Sample Collection
1.3.4 Sample Collection and Laboratory Analyses
2.0 SOURCE REDUCTION
2.1 WWTP (1000 cfu/100ml maximum)
2.1.1 Actions Necessary to Achieve Reduction
2.1.2 Time Frame for Completion
2.2 SSO (Reduced by 33% in Sugar and Upper McAlpine Creeks; 25% in Little
Sugar and Lower McAlpine Creeks; and 3 hours maximum flow for all TMDL
watersheds)
2.2.1 Actions Necessary to Achieve Reduction
2.2.2 Time Frame for Completion
2.3 Failing Septic Tanks (Reduced by 60% in Sugar and Little Sugar Creeks; 80% in
Upper McAlpine Creek; and 40% in Lower McAlpine Creek)
2.3.1 Actions Necessary to Achieve Reduction
2.3.2 Time Frame for Completion
2.4 Dry Weather Flow (Reduced by 60% in Sugar and Little Sugar Creeks; 80% in
Upper McAlpine Creek; and 40% in Lower McAlpine Creek)
2.4.1 Actions Necessary to Achieve Reduction
2.4.2 Time Frame for Completion
2.5 Sanitary Sewer Exfiltration (5 cfu/100 ml average)
2.5.1 Actions Necessary to Achieve Reduction
2.5.2 Time Frame for Completion
3.0 MEASURING SUCCESS
3.1 Measuring Success in Meeting Reduction Targets
3.2 Measuring Success Toward Meeting TMDL
4.0 DOCUMENTATION
4.1 Records
4.1.1 Documentation Methods
4.1.2 Maintaining Records
4.2 Reporting
4.2.1 Frequency
4.2.2 Sharing Information Among All Stakeholders
4.2.3 Public Reporting
3.2.4 Reports to the State/EPA
5.0 ADAPTIVE MANAGEMENT
5.1 Oversight Committee
5.2 Adaption of TMDL in Response to More/Better Data
6.0 PUBLIC PROCESS
6.1 Community Education
6.2 Long and Short Term Community Involvement/Input in Implementation Strategy
7.0 SCHEDULE
7.1 Implementation Strategy and Source Reduction Milestones
7.2 TMDL Milestones and Compliance
Appendix 3. Land Use Tables
Table A3-1. Sugar Creek Watershed Land-Use Distribution
Total 001 002 003 004 005 006 007 008 009 010 011
Heavy Residential 7590.263 320.727 167.773 949.727 2495.811 1250.89 13.356 462.845 239.56 681.883 789.596 218.095
Light Residential 10947.79 965.325 1086.742 634.929 1467.742 757.767 434.884 380.999 445.07 1117.451 1388.839 2268.043
Light Commercial/Industrial 5563.069 155.732 136.896 354.595 1099.594 1065.089 109.196 595.25 585.187 564.904 621.687 274.939
Woods/Brush 13485.88 1752.05 590.47 52.355 1465 932.875 531.552 1101.71 673.9387 1764.81 1312.96 3308.16
Heavy Industrial 2731.901 709.628 2.72 240.717 553.785 298.091 217.128 182.002 161.889 8.125 282.585 75.231
Heavy Commercial 1307.129 11.036 19.582 213.514 176.751 124.554 3.525 103.812 10.432 132.922 152.597 358.404
Pervious Land-Use Name 001 002 003 004 005 006 008 009 Total
Heavy Residential 696 2344 918 2307 1657 1224 459 1566 0
Light Residential 684 273 306 1186 589 346 79 403 11170
Light Commercial/Industrial 173 179 272 218 96 72 50 78 3865
Woods/Brush 427 211 47 555 478 451 170 629 1139
Institutional 7 81 57 84 68 23 19 35 2967
Heavy Industrial 379 19 221 8 2 11 35 25 374
Heavy Commercial 6 13 47 32 2 5 5 13 700
Total Pervious 2372 3122 1866 4390 2891 2133 817 2749 20215
Impervious Land-Use Name
Heavy Residential 291 981 384 965 693 512 192 655 0
Light Residential 159 64 71 277 137 81 18 94 4674
Light Commercial/Industrial 350 362 550 442 194 147 102 159 901
Woods/Brush 37 18 4 48 41 39 15 54 2306
Institutional 9 106 74 110 88 30 25 46 254
Heavy Industrial 402 21 235 8 2 12 37 26 488
Heavy Commercial 74 157 551 376 28 64 59 155 743
Total Impervious 1323 1709 1870 2225 1184 884 448 1188 9367
Total Watershed Area
Note: Area in Acres
Watershed
Table A3-3. McAlpine Creek Watershed Land-Use Distribution
Pervious Land-Use Name 001 003 006 007 008 010 013 009 002 012 Total
Heavy Residential 3213 317 158 1701 799 2023 2423 1417 611 959 13621
Light Residential 1856 713 56 791 1935 873 2533 581 3453 1467 14259
Light Commercial/Industrial 198 9 3 90 30 58 88 53 181 54 763
Woods/Brush 2356 2181 461 460 2611 899 1877 679 3391 1785 16701
Institutional 68 -4 74 16 31 74 27 17 18 328
Heavy Industrial 264 -75 1 55 22 -16 136 -569
Heavy Commercial ---8 7 10 2 1 15 6 49
Total Pervious 7955 3220 757 3125 5454 3916 6996 2773 7804 4289 46290
Impervious Land-Use Name
Heavy Residential 1345 132 66 712 334 847 1014 593 256 401 5700
Light Residential 433 166 13 184 451 204 590 135 805 342 3323
Light Commercial/Industrial 379 2 6 175 61 109 164 106 357 68 1427
Woods/Brush 202 187 40 39 224 77 161 58 291 153 1433
Institutional 88 3 5 96 21 40 97 35 22 23 430
Heavy Industrial 280 -68 1 35 23 -17 94 -519
Heavy Commercial ---92 82 117 18 16 181 71 576
Total Impervious 2727 491 198 1300 1209 1416 2044 960 2005 1059 13407
Total Watershed Area
Note: Area in Acres
Watershed
Appendix 4.
WWTP Flows and Fecal Coliform Loading
Table A4-1. Sugar Creek Wastewater Treatment Plant - 1000 cfu/100 ml Max
Year Month Day Hour Minute Flow (mgd)
Measured fecal
(cfu/100 ml)Fecal (cfu/hour)Flow (cfs)
Fecal conc used
in calcs
1000
1998 1 5 1 0 9.3 16 234,675,221 14.39 16
1998 1 6 1 0 11.91 17 319,319,166 18.42 17
1998 1 7 1 0 13.31 6 125,948,677 20.59 6
1998 1 8 1 0 16.67 2,300 26,290,564,020 25.79 1000
1998 1 9 1 0 10.26 7 113,268,645 15.87 7
1998 1 12 1 0 10.71 20 337,818,765 16.57 20
1998 1 13 1 0 10.92 82 1,412,214,916 16.89 82
1998 1 14 1 0 9.72 200 3,065,918,204 15.04 200
1998 1 15 1 0 13.61 55 1,180,551,991 21.05 55
1998 1 16 1 0 19.56 5 154,242,181 30.26 5
1998 1 20 1 0 10.48 19 314,035,819 16.21 19
1998 1 21 1 0 9.96 146 2,293,382,518 15.41 146
1998 1 22 1 0 10.7 44 742,507,351 16.55 44
1998 1 23 1 0 14.28 100 2,252,125,100 22.09 100
1998 1 26 1 0 11.27 12 213,289,495 17.43 12
1998 1 27 1 0 21.66 230 7,856,888,532 33.51 230
1998 1 28 1 0 15.18 85 2,034,955,894 23.48 85
1998 1 29 1 0 10.53 12 199,284,683 16.29 12
1998 2 2 1 0 10.05 20 317,000,802 15.55 20
1998 2 3 1 0 19.12 55 1,658,497,728 29.58 55
1998 2 4 1 0 20.44 119 3,836,119,754 31.62 119
1998 2 5 1 0 19.21 13 393,853,782 29.72 13
1998 2 6 1 0 9.56 7 105,540,765 14.79 7
1998 2 9 1 0 12.2 16 307,853,515 18.87 16
1998 2 10 1 0 14.99 4 94,564,020 23.19 4
1998 2 11 1 0 16.18 7 178,624,432 25.03 7
1998 2 12 1 0 15.69 25 618,624,699 24.27 25
1998 2 13 1 0 13.56 28 598,800,321 20.98 28
1998 2 16 1 0 18.16 25 716,011,762 28.09 25
1998 2 17 1 0 24.98 100 3,939,641,807 38.64 100
1998 2 18 1 0 22.55 4 142,256,081 34.88 4
1998 2 19 1 0 16.21 48 1,227,124,298 25.08 48
1998 2 20 1 0 14.76 155 3,608,131,516 22.83 155
1998 2 23 1 0 15.65 57 1,406,868,484 24.21 57
1998 2 24 1 0 14.05 59 1,307,352,312 21.73 59
1998 2 25 1 0 14.56 320 7,348,110,131 22.52 320
1998 2 26 1 0 15.55 280 6,866,773,590 24.05 280
1998 2 27 1 0 14.32 560 12,647,228,014 22.15 560
1998 3 2 1 0 15.06 21 498,779,471 23.30 21
1998 3 3 1 0 13.28 430 9,005,977,011 20.54 430
1998 3 4 1 0 14.26 530 11,919,545,576 22.06 530
1998 3 5 1 0 13.41 155 3,278,119,487 20.74 155
1998 3 6 1 0 15.07 450 10,695,228,549 23.31 450
1998 3 9 1 0 25.54 4 161,118,418 39.51 4
1998 3 10 1 0 17.81 109 3,061,644,213 27.55 109
1998 3 11 1 0 15.25 91 2,188,646,084 23.59 91
1998 3 12 1 0 15.26 64 1,540,276,931 23.61 64
1998 3 13 1 0 14.22 43 964,344,828 22.00 43
1998 3 16 1 0 19.42 55 1,684,520,182 30.04 55
1998 3 17 1 0 24.7 11 428,503,074 38.21 11
1998 3 18 1 0 15.63 60 1,479,021,652 24.18 60
1998 3 19 1 0 16.06 585 14,817,185,245 24.84 585
1998 3 20 1 0 14.25 23 516,900,561 22.04 23
1998 3 23 1 0 15.09 15 356,980,754 23.34 15
1998 3 24 1 0 15.4 8 194,300,989 23.82 8
1998 3 25 1 0 13.94 10 219,850,307 21.56 10
1998 3 26 1 0 14.13 845 18,830,557,338 21.86 845
1998 3 27 1 0 14.63 45 1,038,295,910 22.63 45
1998 3 30 1 0 15 20 473,135,525 23.20 20
1998 3 31 1 0 15.14 25 596,939,321 23.42 25
1998 1 4 1 0 15.08 34 808,620,155 23.33 34
1998 4 2 1 0 14.72 31 719,670,676 22.77 31
1998 4 3 1 0 19.84 18 563,220,529 30.69 18
Appendix 4 page A4-1
Table A4-1. Sugar Creek Wastewater Treatment Plant - 1000 cfu/100 ml Max
Year Month Day Hour Minute Flow (mgd)
Measured fecal
(cfu/100 ml)Fecal (cfu/hour)Flow (cfs)
Fecal conc used
in calcs
1998 4 6 1 0 16.39 53 1,369,995,456 25.35 53
1998 4 7 1 0 15.19 14 335,390,003 23.50 14
1998 4 8 1 0 21.17 45 1,502,441,860 32.75 45
1998 4 9 1 0 29.07 1,350 45,846,832,398 44.97 1000
1998 4 13 1 0 15.72 2 49,584,603 24.32 2
1998 4 14 1 0 15.08 10 237,829,457 23.33 10
1998 4 15 1 0 15.04 6 142,319,166 23.27 6
1998 4 16 1 0 15.71 9 222,988,773 24.30 9
1998 4 17 1 0 19.07 33 992,496,391 29.50 33
1998 4 20 1 0 15.3 18 434,338,412 23.67 18
1998 4 21 1 0 14.74 11 255,713,980 22.80 11
1998 4 22 1 0 19.59 23 710,602,245 30.30 23
1998 4 23 1 0 17.83 47 1,321,641,005 27.58 47
1998 4 24 1 0 15 10 236,567,763 23.20 10
1998 4 27 1 0 12.54 26 514,203,689 19.40 26
1998 4 28 1 0 15.23 55 1,321,073,242 23.56 55
1998 4 29 1 0 15.07 58 1,378,496,124 23.31 58
1998 4 30 1 0 17.75 28 783,827,854 27.46 28
1998 5 1 1 0 16.16 11 280,348,570 25.00 11
1998 5 4 1 0 15.06 137 3,253,942,261 23.30 137
1998 5 5 1 0 14.86 91 2,132,674,151 22.99 91
1998 5 6 1 0 16.44 470 12,186,078,589 25.43 470
1998 5 7 1 0 23.65 14 522,183,908 36.58 14
1998 5 8 1 0 17.34 19 519,597,434 26.82 19
1998 5 11 1 0 14 43 962,988,506 21.97 43
1998 5 12 1 0 15 57 1,367,314,354 23.53 57
1998 5 13 1 0 14 14 306,686,447 21.49 14
1998 5 14 1 0 15 25 581,956,696 22.83 25
1998 5 15 1 0 15 35 839,578,990 23.53 35
1998 5 18 1 0 14 29 645,341,085 21.83 29
1998 5 19 1 0 15 6,000 23,025,928,896 22.59 1000
1998 5 20 1 0 15 590 14,301,782,946 23.78 590
1998 5 21 1 0 14 30 657,185,245 21.49 30
1998 5 22 1 0 15 182 4,233,774,392 22.82 182
1998 5 26 1 0 16 27 671,095,429 24.38 27
1998 5 27 1 0 14 26 574,481,155 21.67 26
1998 5 28 1 0 15 12 279,149,960 22.82 12
1998 5 29 1 0 15 9 219,440,257 23.92 9
1998 6 1 1 0 14.63 220 5,076,113,339 22.63 220
1998 6 2 1 0 14.92 82 1,929,509,757 23.08 82
1998 6 3 1 0 15.34 1 24,192,997 23.73 1
1998 6 4 1 0 13.91 110 2,413,148,891 21.52 110
1998 6 5 1 0 14.08 110 2,442,641,005 21.78 110
1998 6 8 1 0 14.15 200 4,463,245,122 21.89 200
1998 6 9 1 0 14.3 26 586,372,628 22.12 26
1998 6 10 1 0 23 28 1,015,664,261 35.58 28
1998 6 11 1 0 22.05 19 660,733,761 34.11 19
1998 6 12 1 0 14.96 20 471,873,831 23.14 20
1998 6 15 1 0 14 300 6,623,897,354 21.66 300
1998 6 16 1 0 18.99 380 11,380,801,925 29.38 380
1998 6 17 1 0 11.22 54 955,544,507 17.36 54
1998 6 18 1 0 15.05 37 878,218,391 23.28 37
1998 6 19 1 0 10 23 362,737,236 15.47 23
1998 6 22 1 0 15.84 57 1,423,948,677 24.50 57
1998 6 23 1 0 15.52 82 2,007,103,983 24.01 82
1998 6 24 1 0 15.07 37 879,385,458 23.31 37
1998 6 25 1 0 14.73 91 2,114,016,840 22.79 91
1998 6 26 1 0 15.5 119 2,908,994,921 23.98 119
1998 6 29 1 0 14.55 41 940,829,992 22.51 41
1998 6 30 1 0 13.3 57 1,195,613,472 20.57 57
1998 7 1 1 0 15.01 73 1,728,095,964 23.22 73
1998 7 2 1 0 14.85 82 1,920,457,097 22.97 82
1998 7 3 1 0 14.85 56 1,311,531,676 22.97 56
1998 7 7 1 0 14.55 28 642,518,043 22.51 28
Appendix 4 page A4-2
Table A4-1. Sugar Creek Wastewater Treatment Plant - 1000 cfu/100 ml Max
Year Month Day Hour Minute Flow (mgd)
Measured fecal
(cfu/100 ml)Fecal (cfu/hour)Flow (cfs)
Fecal conc used
in calcs
1998 7 8 1 0 15.34 82 1,983,825,715 23.73 82
1998 7 9 1 0 13.77 10 217,169,206 21.30 10
1998 7 10 1 0 13.72 26 562,589,682 21.22 26
1998 7 13 1 0 13.41 110 2,326,407,378 20.74 110
1998 7 14 1 0 14 110 2,428,762,363 21.66 110
1998 7 15 1 0 12.98 60 1,228,259,824 20.08 60
1998 7 16 1 0 14.28 28 630,595,028 22.09 28
1998 7 17 1 0 14.52 34 778,591,820 22.46 34
1998 7 20 1 0 13.02 1 20,534,082 20.14 1
1998 7 21 1 0 16.98 40 1,071,178,829 26.27 40
1998 7 22 1 0 16.81 64 1,696,727,078 26.00 64
1998 7 23 1 0 15.76 1 24,855,386 24.38 1
1998 7 24 1 0 13.98 6 132,288,693 21.63 6
1998 7 27 1 0 25.02 20 789,190,056 38.70 20
1998 7 28 1 0 14.78 31 722,604,117 22.86 31
1998 7 29 1 0 14.45 36 820,417,001 22.35 36
1998 7 30 1 0 14.51 9 205,955,894 22.45 9
1998 7 31 1 0 14.92 13 305,897,888 23.08 13
1998 8 3 1 0 13.51 9 191,761,828 20.90 9
1998 8 4 1 0 15.67 58 1,433,379,845 24.24 58
1998 8 5 1 0 14.27 82 1,845,449,345 22.07 82
1998 8 6 1 0 14.81 29 677,356,589 22.91 29
1998 8 7 1 0 13.81 20 435,600,107 21.36 20
1998 8 10 1 0 14.39 25 567,368,351 22.26 25
1998 8 11 1 0 15.14 38 907,347,768 23.42 38
1998 8 12 1 0 14.37 26 589,242,983 22.23 26
1998 8 13 1 0 15.02 26 615,896,284 23.23 26
1998 8 14 1 0 18.43 17 494,126,971 28.51 17
1998 8 17 1 0 14 30 672,798,717 22.00 30
1998 8 18 1 0 16 57 1,468,896,552 25.28 57
1998 8 19 1 0 13 19 402,732,959 20.79 19
1998 8 20 1 0 16 11 270,460,037 24.12 11
1998 8 21 1 0 13 10 199,820,904 19.60 10
1998 8 24 1 0 14 28 614,697,674 21.53 28
1998 8 25 1 0 14 73 1,585,335,204 21.30 73
1998 8 26 1 0 14 38 846,817,963 21.86 38
1998 8 27 1 0 14 22 494,426,624 22.04 22
1998 8 28 1 0 15 28 650,908,313 22.80 28
1998 8 31 1 0 15 35 808,667,469 22.66 35
1998 9 1 1 0 14 200 4,551,563,753 22.32 200
1998 9 2 1 0 15 42 1,012,131,516 23.64 42
1998 9 3 1 0 27 38 1,633,106,121 42.15 38
1998 9 4 1 0 19 38 1,113,508,688 28.74 38
1998 9 8 1 0 11 54 972,577,386 17.67 54
1998 9 9 1 0 15 59 1,365,043,304 22.69 59
1998 9 10 1 0 14 82 1,813,118,418 21.69 82
1998 9 11 1 0 14 26 583,092,221 22.00 26
1998 9 14 1 0 14 37 811,112,002 21.50 37
1998 9 15 1 0 14 33 754,130,714 22.41 33
1998 9 16 1 0 12 48 921,289,495 18.83 48
1998 9 17 1 0 11 58 979,674,419 16.57 58
1998 9 18 1 0 14 52 1,144,041,700 21.58 52
1998 9 21 1 0 15 210 4,938,115,477 23.06 210
1998 9 22 1 0 12 137 2,670,566,159 19.12 137
1998 9 23 1 0 15 146 3,529,874,900 23.71 146
1998 9 24 1 0 14 20 446,639,936 21.90 20
1998 9 25 1 0 13 58 1,233,054,264 20.85 58
1998 9 28 1 0 15 119 2,726,948,142 22.48 119
1998 9 29 1 0 14 82 1,873,900,561 22.41 82
1998 9 30 1 0 14 100 2,207,965,785 21.66 100
1998 10 1 1 0 14 59 1,333,406,308 22.17 59
1998 10 2 1 0 14 64 1,446,406,843 22.17 64
1998 10 5 1 0 14 64 1,428,238,439 21.89 64
1998 10 6 1 0 14 35 754,020,315 21.13 35
Appendix 4 page A4-3
Table A4-1. Sugar Creek Wastewater Treatment Plant - 1000 cfu/100 ml Max
Year Month Day Hour Minute Flow (mgd)
Measured fecal
(cfu/100 ml)Fecal (cfu/hour)Flow (cfs)
Fecal conc used
in calcs
1998 10 7 1 0 16 31 770,516,974 24.38 31
1998 10 8 1 0 15 27 645,546,111 23.45 27
1998 10 9 1 0 14 35 751,812,350 21.07 35
1998 10 12 1 0 13 30 629,270,249 20.57 30
1998 10 13 1 0 14 52 1,181,766,373 22.29 52
1998 10 14 1 0 13 33 691,156,375 20.54 33
1998 10 15 1 0 17 25 669,486,768 26.27 25
1998 10 16 1 0 10 14 209,756,750 14.70 14
1998 10 19 1 0 14 29 626,131,783 21.18 29
1998 10 20 1 0 14 200 4,438,011,227 21.77 200
1998 10 21 1 0 14 220 4,725,677,626 21.07 220
1998 10 22 1 0 14 55 1,190,960,973 21.24 55
1998 10 23 1 0 13 27 565,065,758 20.53 27
1998 10 26 1 0 14 50 1,132,371,024 22.21 50
1998 10 27 1 0 13 82 1,698,020,315 20.31 82
1998 10 28 1 0 14 119 2,548,654,905 21.01 119
1998 10 29 1 0 14 28 619,996,792 21.72 28
1998 10 30 1 0 13 30 617,914,996 20.20 30
1998 11 2 1 0 13 20 411,943,331 20.20 20
1998 11 3 1 0 13 55 1,132,844,159 20.20 55
1998 11 4 1 0 13 146 3,007,186,314 20.20 146
1998 11 5 1 0 13 46 947,469,661 20.20 46
1998 11 6 1 0 13 42 865,080,994 20.20 42
1998 11 9 1 0 13 24 494,331,997 20.20 24
1998 11 10 1 0 13 15 308,957,498 20.20 15
1998 11 11 1 0 13 16 329,554,665 20.20 16
1998 11 12 1 0 13 280 5,767,206,629 20.20 280
1998 11 13 1 0 13 350 7,209,008,287 20.20 350
1998 11 16 1 0 13 12 247,165,998 20.20 12
1998 11 17 1 0 13 9 185,374,499 20.20 9
1998 11 18 1 0 13 26 535,526,330 20.20 26
1998 11 19 1 0 13 17 350,151,831 20.20 17
1998 11 20 1 0 13 18 370,748,998 20.20 18
1998 11 23 1 0 13 14 288,360,331 20.20 14
1998 11 24 1 0 13 32 659,109,329 20.20 32
1998 11 25 1 0 13 21 432,540,497 20.20 21
1998 11 27 1 0 13 34 700,303,662 20.20 34
1998 11 30 1 0 13 91 1,874,342,155 20.20 91
1998 12 1 1 0 14 520 11,194,386,528 21.12 520
1998 12 2 1 0 13 580 11,909,767,442 20.14 580
1998 12 3 1 0 14 56 1,275,321,037 22.34 56
1998 12 4 1 0 13 30 637,786,688 20.85 30
1998 12 7 1 0 14 59 1,280,367,816 21.29 59
1998 12 8 1 0 17 64 1,725,998,396 26.45 64
1998 12 9 1 0 15 52 1,209,649,826 22.82 52
1998 12 10 1 0 13 31 652,201,550 20.64 31
1998 12 11 1 0 14 55 1,190,960,973 21.24 55
1998 12 14 1 0 14 13 295,236,568 22.28 13
1998 12 15 1 0 19 1,700 29,933,707,565 29.36 1000
1998 12 16 1 0 14 900 20,070,408,982 21.87 900
1998 12 17 1 0 14 40 869,938,519 21.33 40
1998 12 18 1 0 14 21 469,965,517 21.95 21
1998 12 21 1 0 14 21 462,016,840 21.58 21
1998 12 22 1 0 14 20 445,378,241 21.84 20
1998 12 23 1 0 19 49 1,493,799,252 29.90 49
1998 12 28 1 0 13 20 424,875,702 20.84 20
1998 12 29 1 0 14 28 618,230,420 21.66 28
1998 12 30 1 0 16 24 602,585,405 24.63 24
1998 12 31 1 0 16 22 555,145,683 24.75 22
1999 1 4 1 0 13.27 23 481,352,312 20.53 23
1999 1 5 1 0 14.49 23 525,606,255 22.41 23
1999 1 6 1 0 18.2 20 574,071,104 28.15 20
1999 1 7 1 0 12.74 20 401,849,773 19.71 20
1999 1 8 1 0 13.69 4 86,363,005 21.18 4
Appendix 4 page A4-4
Table A4-1. Sugar Creek Wastewater Treatment Plant - 1000 cfu/100 ml Max
Year Month Day Hour Minute Flow (mgd)
Measured fecal
(cfu/100 ml)Fecal (cfu/hour)Flow (cfs)
Fecal conc used
in calcs
1999 1 11 1 0 12.85 21 425,585,405 19.88 21
1999 1 12 1 0 13.21 14 291,672,280 20.43 14
1999 1 13 1 0 13.492 17 361,734,189 20.87 17
1999 1 14 1 0 13.821 21 457,744,427 21.38 21
1999 1 15 1 0 13.67 24 517,421,010 21.15 24
1999 1 19 1 0 13.75 26 563,819,834 21.27 26
1999 1 20 1 0 13.15 1 20,739,107 20.34 1
1999 1 21 1 0 12.69 7 140,095,429 19.63 7
1999 1 22 1 0 13.2 22 457,995,188 20.42 22
1999 1 25 1 0 21.939 182 6,297,272,975 33.94 182
1999 1 26 1 0 16.45 100 2,594,359,797 25.45 100
1999 1 27 1 0 10.89 14 240,447,474 16.85 14
1999 1 28 1 0 13.16 9 186,793,905 20.36 9
1999 1 29 1 0 12.73 7 140,537,022 19.69 7
1999 2 1 1 0 14.38 25 566,974,071 22.24 25
1999 2 2 1 0 13.88 1600 21,890,403,635 21.47 1000
1999 2 3 1 0 14.28 59 1,328,753,809 22.09 59
1999 2 4 1 0 13.57 137 2,932,005,079 20.99 137
1999 2 5 1 0 13.07 48 989,421,010 20.22 48
1999 2 8 1 0 12.97 48 981,850,842 20.06 48
1999 2 9 1 0 13.64 10 215,118,952 21.10 10
1999 2 10 1 0 13.69 10 215,907,511 21.18 10
1999 2 11 1 0 12.54 41 810,859,663 19.40 41
1999 2 12 1 0 12.98 15 307,064,956 20.08 15
1999 2 15 1 0 13.61 6 128,787,490 21.05 6
1999 2 16 1 0 13.6 12 257,385,726 21.04 12
1999 2 17 1 0 14.13 20 445,693,665 21.86 20
1999 2 18 1 0 14.716 10 232,088,746 22.76 10
1999 2 19 1 0 21.843 15 516,734,964 33.79 15
1999 2 22 1 0 13.97 18 396,582,197 21.61 18
1999 2 23 1 0 13.05 13 267,558,140 20.19 13
1999 2 24 1 0 15.42 12 291,829,992 23.85 12
1999 2 25 1 0 14.15 20 446,324,512 21.89 20
1999 2 26 1 0 11.67 48 883,438,653 18.05 48
1999 2 27 1 0 13.51 48 1,022,729,751 20.90 48
1999 2 28 1 0 13.32 48 1,008,346,431 20.61 48
1999 3 1 1 0 13.28 1500 20,944,132,585 20.54 1000
1999 3 2 1 0 13.18 280 5,820,197,808 20.39 280
1999 3 3 1 0 12.51 56 1,104,866,079 19.35 56
1999 3 4 1 0 12.74 22 442,034,750 19.71 22
1999 3 5 1 0 13.52 700 14,925,848,704 20.91 700
1999 3 8 1 0 12.67 52 1,039,068,698 19.60 52
1999 3 9 1 0 13.44 30 635,894,146 20.79 30
1999 3 10 1 0 13.333 23 483,637,557 20.63 23
1999 3 11 1 0 14.198 25 559,798,182 21.96 25
1999 3 12 1 0 11.71 23 424,765,303 18.11 23
1999 3 13 1 0 13.29 9 188,639,134 20.56 9
1999 3 14 1 0 13.329 9 189,192,702 20.62 9
1999 3 15 1 0 13.09 100 2,064,448,009 20.25 100
1999 3 16 1 0 12.85 2600 20,265,971,665 19.88 1000
1999 3 17 1 0 12.84 24 486,004,812 19.86 24
1999 3 18 1 0 12.86 520 10,546,506,282 19.89 520
1999 3 19 1 0 13.19 91 1,892,999,465 20.40 91
1999 3 22 1 0 13.74 9 195,026,464 21.25 9
1999 3 23 1 0 12.55 9 178,135,525 19.41 9
1999 3 24 1 0 13.57 8 171,211,975 20.99 8
1999 3 25 1 0 16.44 7 181,494,787 25.43 7
1999 3 26 1 0 10.28 6 97,276,664 15.90 6
1999 3 29 1 0 12.93 21 428,234,964 20.00 21
1999 3 30 1 0 17.239 9 244,691,500 26.67 9
1999 3 31 1 0 13.56 32 684,343,224 20.98 32
1999 4 1 1 0 17.649 10 278,345,630 27.30 10
1999 4 5 1 0 13.204 16 333,188,345 20.43 16
1999 4 6 1 0 11.287 12 213,611,227 17.46 12
Appendix 4 page A4-5
Table A4-1. Sugar Creek Wastewater Treatment Plant - 1000 cfu/100 ml Max
Year Month Day Hour Minute Flow (mgd)
Measured fecal
(cfu/100 ml)Fecal (cfu/hour)Flow (cfs)
Fecal conc used
in calcs
1999 4 7 1 0 13.7 8 172,852,179 21.19 8
1999 4 8 1 0 12.23 10 192,881,582 18.92 10
1999 4 9 1 0 12.01 5 94,705,961 18.58 5
1999 4 12 1 0 12.29 24 465,186,848 19.01 24
1999 4 13 1 0 12.806 50 1,009,828,923 19.81 50
1999 4 14 1 0 12.709 20 400,871,959 19.66 20
1999 4 15 1 0 12.93 13 265,097,835 20.00 13
1999 4 16 1 0 13.774 18 391,018,123 21.31 18
1999 4 19 1 0 12.52 83 1,638,878,375 19.37 83
1999 4 20 1 0 14.4 31 704,025,662 22.28 31
1999 4 21 1 0 14.44 27 614,886,929 22.34 27
1999 4 22 1 0 14.32 21 474,271,051 22.15 21
1999 4 23 1 0 14.55 19 435,994,387 22.51 19
1999 4 26 1 0 11.893 35 656,483,427 18.40 35
1999 4 27 1 0 16.936 38 1,014,982,946 26.20 38
1999 4 28 1 0 17.156 26 703,483,133 26.54 26
1999 4 29 1 0 18.578 73 2,138,878,535 28.74 73
1999 4 30 1 0 26.147 46 1,896,898,102 40.45 46
1999 5 1 1 0 14.672 46 1,064,416,145 22.70 46
1999 5 2 1 0 13.893 46 1,007,901,684 21.49 46
1999 5 3 1 0 14.518 212 4,854,080,299 22.46 212
1999 5 4 1 0 14.475 22 502,233,360 22.39 22
1999 5 5 1 0 13.88 18 394,027,265 21.47 18
1999 5 6 1 0 14.32 240 5,420,240,577 22.15 240
1999 5 7 1 0 13.52 58 1,236,713,178 20.91 58
1999 5 8 1 0 13.89 58 1,270,558,140 21.49 58
1999 5 9 1 0 13.96 58 1,276,961,240 21.60 58
1999 5 10 1 0 13.74 100 2,166,960,706 21.25 100
1999 5 11 1 0 12.51 64 1,262,704,090 19.35 64
1999 5 12 1 0 13.92 91 1,997,767,442 21.53 91
1999 5 13 1 0 15.979 73 1,839,656,589 24.72 73
1999 5 14 1 0 18.59 25 732,965,785 28.76 25
1999 5 15 1 0 14.92 25 588,265,170 23.08 25
1999 5 16 1 0 13.92 25 548,837,209 21.53 25
1999 5 17 1 0 14.08 6000 22,205,827,319 21.78 1000
1999 5 18 1 0 14.8 4300 23,341,352,580 22.89 1000
1999 5 19 1 0 14.56 380 8,725,880,781 22.52 380
1999 5 20 1 0 13.53 100 2,133,841,219 20.93 100
1999 5 21 1 0 13.65 60 1,291,659,984 21.12 60
1999 5 22 1 0 14.02 23 508,557,605 21.69 23
1999 5 23 1 0 13.74 28 606,748,998 21.25 28
1999 5 24 1 0 13.71 30 648,668,805 21.21 30
1999 5 25 1 0 14.69 20 463,357,391 22.72 20
1999 5 26 1 0 16.4 14 362,106,389 25.37 14
1999 5 27 1 0 13.67 8 172,473,670 21.15 8
1999 5 28 1 0 17.38 10 274,103,181 26.89 10
1999 6 1 1 0 13.81 21 457,380,112 21.36 21
1999 6 2 1 0 15.35 220 5,325,928,896 23.75 220
1999 6 3 1 0 14.11 50 1,112,657,044 21.83 50
1999 6 4 1 0 13.54 137 2,925,523,122 20.95 137
1999 6 7 1 0 13.79 37 804,693,130 21.33 37
1999 6 8 1 0 13.89 28 613,372,895 21.49 28
1999 6 9 1 0 14.77 35 815,291,366 22.85 35
1999 6 10 1 0 18.436 73 2,122,530,126 28.52 73
1999 6 11 1 0 14.59 17 391,172,681 22.57 17
1999 6 14 1 0 13.59 36 771,589,415 21.02 36
1999 6 15 1 0 15.83 19 474,349,906 24.49 19
1999 6 16 1 0 19.69 600 18,632,076,985 30.46 600
1999 6 17 1 0 14.03 34 752,317,028 21.70 34
1999 6 18 1 0 14.63 91 2,099,665,063 22.63 91
1999 6 21 1 0 13.65 10 215,276,664 21.12 10
1999 6 22 1 0 11.38 20 358,952,152 17.60 20
1999 6 23 1 0 13.93 37 812,862,604 21.55 37
1999 6 24 1 0 13.82 10 217,957,765 21.38 10
Appendix 4 page A4-6
Table A4-1. Sugar Creek Wastewater Treatment Plant - 1000 cfu/100 ml Max
Year Month Day Hour Minute Flow (mgd)
Measured fecal
(cfu/100 ml)Fecal (cfu/hour)Flow (cfs)
Fecal conc used
in calcs
1999 6 25 1 0 16.708 8 210,803,956 25.85 8
1999 6 28 1 0 14.33 33 745,803,528 22.17 33
1999 6 29 1 0 14.33 1950 22,600,106,923 22.17 1000
1999 6 30 1 0 13.37 16 337,377,172 20.68 16
1999 7 1 1 0 12.409 17 332,697,862 19.20 17
1999 7 2 1 0 15.53 2 48,985,298 24.02 2
1999 7 6 1 0 21.809 44 1,513,396,525 33.74 44
1999 7 7 1 0 18.037 21 597,376,183 27.90 21
1999 7 8 1 0 18.91 28 835,052,660 29.25 28
1999 7 9 1 0 18.417 37 1,074,694,226 28.49 37
1999 7 12 1 0 21.345 34 1,144,562,149 33.02 34
1999 7 13 1 0 20.102 33 1,046,206,736 31.10 33
1999 7 14 1 0 18.14 46 1,316,010,692 28.06 46
1999 7 15 1 0 15.35 27 653,636,728 23.75 27
1999 7 16 1 0 15.123 21 500,865,998 23.39 21
1999 7 19 1 0 15.35 9 217,878,909 23.75 9
1999 7 20 1 0 15.9 10 250,761,828 24.60 10
1999 7 21 1 0 14.09 9 199,994,387 21.80 9
1999 7 22 1 0 15.14 11 262,653,301 23.42 11
1999 7 23 1 0 15.73 12 297,696,872 24.33 12
1999 7 26 1 0 15.16 33 789,000,802 23.45 33
1999 7 27 1 0 15.89 40 1,002,416,466 24.58 40
1999 7 28 1 0 15.33 56 1,353,924,619 23.71 56
1999 7 29 1 0 19.216 58 1,757,742,636 29.73 58
1999 7 30 1 0 17.74 191 5,343,813,419 27.44 191
1999 7 31 1 0 14.5 191 4,367,829,457 22.43 191
1999 8 1 1 0 13.48 191 4,060,575,247 20.85 191
1999 8 2 1 0 14.43 330 7,510,080,192 22.32 330
1999 8 3 1 0 14.59 270 6,212,742,582 22.57 270
1999 8 4 1 0 14.59 210 4,832,133,119 22.57 210
1999 8 5 1 0 14.69 124 2,872,815,825 22.72 124
1999 8 6 1 0 14.02 28 619,113,606 21.69 28
1999 8 7 1 0 14.17 28 625,737,503 21.92 28
1999 8 8 1 0 14.42 28 636,777,332 22.31 28
1999 8 9 1 0 14.12 142 3,162,185,512 21.84 142
1999 8 10 1 0 14.65 250 5,776,196,204 22.66 250
1999 8 11 1 0 13.99 128 2,824,177,493 21.64 128
1999 8 12 1 0 14.5 37 846,124,031 22.43 37
1999 8 13 1 0 14.55 48 1,101,459,503 22.51 48
1999 8 16 1 0 15.10 51 1,214,538,893 23.36 51
1999 8 17 1 0 15.15 14 334,506,816 23.44 14
1999 8 18 1 0 15.25 46 1,106,348,570 23.59 46
1999 8 19 1 0 15.14 34 811,837,477 23.42 34
1999 8 20 1 0 15.88 30 751,339,214 24.57 30
1999 8 23 1 0 15.29 31 747,538,359 23.65 31
1999 8 24 1 0 19.75 48 1,495,108,260 30.55 48
1999 8 25 1 0 13.14 37 766,763,432 20.33 37
1999 8 26 1 0 14.90 13 305,487,837 23.05 13
1999 8 27 1 0 14.96 27 637,029,671 23.14 27
1999 8 30 1 0 14.72 24 557,164,395 22.77 24
1999 8 31 1 0 16.22 24 613,940,658 25.09 24
1999 9 1 1 0 14.98 25 590,630,847 23.17 25
1999 9 2 1 0 14.77 35 815,291,366 22.85 35
1999 9 7 1 0 14.81 41 957,642,074 22.91 41
1999 9 8 1 0 14.70 30 695,603,849 22.74 30
1999 9 9 1 0 15.10 57 1,357,425,822 23.36 57
1999 9 10 1 0 16.31 33 848,696,311 25.23 33
1999 9 11 1 0 13.45 33 699,795,830 20.80 33
1999 9 12 1 0 13.25 33 689,490,938 20.49 33
1999 9 13 1 0 14.90 59 1,386,165,651 23.04 59
1999 9 14 1 0 14.24 22 493,906,175 22.02 22
1999 9 15 1 0 20.90 91 2,999,234,483 32.33 91
1999 9 16 1 0 14.66 37 855,227,159 22.67 37
1999 9 17 1 0 16.32 47 1,209,861,160 25.25 47
Appendix 4 page A4-7
Table A4-1. Sugar Creek Wastewater Treatment Plant - 1000 cfu/100 ml Max
Year Month Day Hour Minute Flow (mgd)
Measured fecal
(cfu/100 ml)Fecal (cfu/hour)Flow (cfs)
Fecal conc used
in calcs
1999 9 18 1 0 13.85 47 1,026,402,860 21.42 47
1999 9 19 1 0 13.42 47 994,529,297 20.76 47
1999 9 20 1 0 17.91 520 14,691,299,652 27.71 520
1999 9 21 1 0 20.94 51 1,684,267,843 32.39 51
1999 9 22 1 0 19.41 20 612,331,997 30.03 20
1999 9 23 1 0 17.89 43 1,213,229,885 27.67 43
1999 9 24 1 0 17.02 23 617,378,776 26.33 23
1999 9 27 1 0 19.66 36 1,116,221,331 30.41 36
1999 9 28 1 0 21.91 73 2,522,605,640 33.89 73
1999 9 29 1 0 23.53 51 1,892,589,415 36.40 51
1999 9 30 1 0 15.44 27 657,554,290 23.89 27
1999 10 1 1 0 14.19 196 4,384,799,252 21.94 196
1999 10 4 1 0 14.15 46 1,026,546,378 21.89 46
1999 10 5 1 0 15.44 142 3,457,800,588 23.88 142
1999 10 6 1 0 14.57 91 2,091,053,996 22.54 91
1999 10 7 1 0 14.95 64 1,508,986,902 23.13 64
1999 10 8 1 0 14.75 26 604,824,913 22.82 26
1999 10 9 1 0 14.27 26 585,142,475 22.07 26
1999 10 10 1 0 28.33 26 1,161,673,884 43.82 26
1999 10 11 1 0 24.65 215 8,358,333,333 38.13 215
1999 10 12 1 0 22.23 6000 35,059,342,422 34.39 1000
1999 10 13 1 0 22.21 60 2,101,289,495 34.35 60
1999 10 14 1 0 15.61 49 1,206,399,385 24.15 49
1999 10 15 1 0 17.20 25 678,160,920 26.61 25
1999 10 16 1 0 12.64 25 498,369,420 19.55 25
1999 10 17 1 0 14.13 25 557,117,081 21.86 25
1999 10 18 1 0 13.58 245 5,247,230,687 21.01 245
1999 10 19 1 0 15.30 300 7,238,973,536 23.67 300
1999 10 20 1 0 20.58 850 27,588,532,478 31.84 850
1999 10 21 1 0 17.71 500 13,963,017,910 27.39 500
1999 10 22 1 0 13.00 410 8,406,041,165 20.11 410
1999 10 23 1 0 13.40 410 8,664,688,586 20.73 410
1999 10 24 1 0 13.40 410 8,664,688,586 20.73 410
1999 10 25 1 0 13.83 560 12,214,466,720 21.39 560
1999 10 26 1 0 14.89 200 4,696,658,647 23.03 200
1999 10 27 1 0 14.34 23 520,165,196 22.18 23
1999 10 28 1 0 18.31 14 404,278,535 28.32 14
1999 10 29 1 0 14.71 13 301,592,355 22.76 13
1999 11 1 1 0 19.14 20 603,720,930 29.61 20
1999 11 2 1 0 20.54 19 615,546,164 31.78 19
1999 11 3 1 0 16.53 9 234,642,101 25.57 9
1999 11 4 1 0 16.30 10 257,070,302 25.21 10
1999 11 5 1 0 14.60 27 621,700,080 22.59 27
1999 11 8 1 0 13.76 28 607,543,865 21.28 28
1999 11 9 1 0 17.16 21 568,462,871 26.55 21
1999 11 10 1 0 17.44 35 962,673,082 26.98 35
1999 11 11 1 0 18.71 42 1,239,331,195 28.94 42
1999 11 12 1 0 14.00 41 905,265,972 21.66 41
1999 11 15 1 0 14.73 40 929,238,172 22.79 40
1999 11 16 1 0 13.59 40 857,321,572 21.02 40
1999 11 17 1 0 14.93 36 847,669,607 23.10 36
1999 11 18 1 0 13.76 29 629,333,333 21.29 29
1999 11 19 1 0 14.70 36 834,611,067 22.74 36
1999 11 22 1 0 13.54 28 597,917,134 20.95 28
1999 11 23 1 0 15.15 44 1,051,307,137 23.44 44
1999 11 24 1 0 13.87 47 1,028,107,725 21.46 47
1999 11 26 1 0 14.51 46 1,052,663,459 22.45 46
1999 11 29 1 0 13.38 69 1,456,027,265 20.70 69
1999 11 30 1 0 15.45 255 6,213,452,285 23.90 255
1999 12 1 1 0 13.90 290 6,357,364,341 21.50 290
1999 12 2 1 0 14.80 119 2,777,620,957 22.89 119
1999 12 3 1 0 14.30 150 3,382,919,006 22.12 150
1999 12 6 1 0 13.79 119 2,588,067,094 21.33 119
1999 12 7 1 0 14.10 1550 22,237,369,687 21.81 1000
Appendix 4 page A4-8
Table A4-1. Sugar Creek Wastewater Treatment Plant - 1000 cfu/100 ml Max
Year Month Day Hour Minute Flow (mgd)
Measured fecal
(cfu/100 ml)Fecal (cfu/hour)Flow (cfs)
Fecal conc used
in calcs
1999 12 8 1 0 14.45 1000 22,789,361,133 22.35 1000
1999 12 9 1 0 14.50 33 754,651,163 22.43 33
1999 12 10 1 0 16.14 23 585,457,899 24.97 23
1999 12 13 1 0 14.35 18 407,369,687 22.20 18
1999 12 14 1 0 14.95 18 424,402,566 23.13 18
1999 12 15 1 0 13.77 20 434,338,412 21.30 20
1999 12 16 1 0 14.09 14 311,102,379 21.80 14
1999 12 17 1 0 13.27 22 460,423,951 20.53 22
1999 12 18 1 0 13.87 22 481,241,914 21.46 22
1999 12 19 1 0 13.68 22 474,649,559 21.16 22
1999 12 20 1 0 13.53 1300 21,338,412,189 20.93 1000
1999 12 21 1 0 18.28 12 345,956,696 28.28 12
1999 12 22 1 0 14.70 10 231,836,407 22.74 10
1999 12 23 1 0 14.20 33 739,037,690 21.97 33
1999 12 28 1 0 14.03 38 840,824,913 21.70 38
1999 12 29 1 0 14.67 64 1,480,724,940 22.69 64
1999 12 30 1 0 14.16 64 1,429,247,795 21.90 64
1999 12 31 1 0 13.66 46 990,998,129 21.13 46
Appendix 4 page A4-9
Table A4-2. Sugar Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute Flow (mgd)
Appendix 4 page A4-10
Table A4-2. Sugar Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute Flow (mgd)
Appendix 4 page A4-11
Table A4-2. Sugar Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute Flow (mgd)
1998 8 14 1 0 18.43 17 494,126,971 28.51
Appendix 4 page A4-12
Table A4-2. Sugar Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute Flow (mgd)
Appendix 4 page A4-13
Table A4-2. Sugar Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute Flow (mgd)
Appendix 4 page A4-14
Table A4-2. Sugar Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute Flow (mgd)
Appendix 4 page A4-15
Table A4-2. Sugar Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute Flow (mgd)
Appendix 4 page A4-16
Table A4-2. Sugar Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute Flow (mgd)
Appendix 4 page A4-17
Table A4-2. Sugar Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute Flow (mgd)
Appendix 4 page A4-18
Table A4-3. Irwin Creek Wastewater Treatment Plant - 1000 cfu/100ml Max
Year Month Day Hour Minute
Flow Obs. fecal Flow Fecal used in calcs
Appendix 4 page A4-19
Table A4-3. Irwin Creek Wastewater Treatment Plant - 1000 cfu/100ml Max
Year Month Day Hour Minute
Flow Obs. fecal Flow Fecal used in calcs
Appendix 4 page A4-20
Table A4-3. Irwin Creek Wastewater Treatment Plant - 1000 cfu/100ml Max
Year Month Day Hour Minute
Flow Obs. fecal Flow Fecal used in calcs
Appendix 4 page A4-21
Table A4-3. Irwin Creek Wastewater Treatment Plant - 1000 cfu/100ml Max
Year Month Day Hour Minute
Flow Obs. fecal Flow Fecal used in calcs
Appendix 4 page A4-22
Table A4-3. Irwin Creek Wastewater Treatment Plant - 1000 cfu/100ml Max
Year Month Day Hour Minute
Flow Obs. fecal Flow Fecal used in calcs
Appendix 4 page A4-23
Table A4-3. Irwin Creek Wastewater Treatment Plant - 1000 cfu/100ml Max
Year Month Day Hour Minute
Flow Obs. fecal Flow Fecal used in calcs
Appendix 4 page A4-24
Table A4-3. Irwin Creek Wastewater Treatment Plant - 1000 cfu/100ml Max
Year Month Day Hour Minute
Flow Obs. fecal Flow Fecal used in calcs
Appendix 4 page A4-25
Table A4-3. Irwin Creek Wastewater Treatment Plant - 1000 cfu/100ml Max
Year Month Day Hour Minute
Flow Obs. fecal Flow Fecal used in calcs
Appendix 4 page A4-26
Table A4-3. Irwin Creek Wastewater Treatment Plant - 1000 cfu/100ml Max
Year Month Day Hour Minute
Flow Obs. fecal Flow Fecal used in calcs
Appendix 4 page A4-27
Table A4-4. Irwin Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Min Flow (cfs)
Appendix 4 page A4-28
Table A4-4. Irwin Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Min Flow (cfs)
Appendix 4 page A4-29
Table A4-4. Irwin Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Min Flow (cfs)
Appendix 4 page A4-30
Table A4-4. Irwin Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Min Flow (cfs)
Appendix 4 page A4-31
Table A4-4. Irwin Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Min Flow (cfs)
Appendix 4 page A4-32
Table A4-4. Irwin Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Min Flow (cfs)
Appendix 4 page A4-33
Table A4-4. Irwin Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Min Flow (cfs)
Appendix 4 page A4-34
Table A4-4. Irwin Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Min Flow (cfs)
Appendix 4 page A4-35
Table A4-4. Irwin Creek Wastewater Treatment Plant - Observed Values
Year Month Day Hour Min Flow (cfs)
Appendix 4 page A4-36
Table A4-5. McAlpine Wastewater Treatment Plant - 1000 cfu/100 ml max
Year Month Day Hour Minute
Observed
Fecal Conc
Fecal used in
calcs (cfu/100
Appendix 4 page A4-37
Table A4-5. McAlpine Wastewater Treatment Plant - 1000 cfu/100 ml max
Year Month Day Hour Minute
Observed
Fecal Conc
Fecal used in
calcs (cfu/100
Appendix 4 page A4-38
Table A4-5. McAlpine Wastewater Treatment Plant - 1000 cfu/100 ml max
Year Month Day Hour Minute
Observed
Fecal Conc
Fecal used in
calcs (cfu/100
Appendix 4 page A4-39
Table A4-5. McAlpine Wastewater Treatment Plant - 1000 cfu/100 ml max
Year Month Day Hour Minute
Observed
Fecal Conc
Fecal used in
calcs (cfu/100
Appendix 4 page A4-40
Table A4-5. McAlpine Wastewater Treatment Plant - 1000 cfu/100 ml max
Year Month Day Hour Minute
Observed
Fecal Conc
Fecal used in
calcs (cfu/100
Appendix 4 page A4-41
Table A4-5. McAlpine Wastewater Treatment Plant - 1000 cfu/100 ml max
Year Month Day Hour Minute
Observed
Fecal Conc
Fecal used in
calcs (cfu/100
Appendix 4 page A4-42
Table A4-5. McAlpine Wastewater Treatment Plant - 1000 cfu/100 ml max
Year Month Day Hour Minute
Observed
Fecal Conc
Fecal used in
calcs (cfu/100
Appendix 4 page A4-43
Table A4-5. McAlpine Wastewater Treatment Plant - 1000 cfu/100 ml max
Year Month Day Hour Minute
Observed
Fecal Conc
Fecal used in
calcs (cfu/100
Appendix 4 page A4-44
Table A4-6. McAlpine Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute
Obs Fecal Conc
(cfu/100 ml)Flow(mgd)
Obs fecal conc
(cfu/100 ml)
Fecal load
(cfu/hour)Flow (cfs)
1998 1 1 1 0 27.00 44.20 27 1,882,133,119 68.37
1998 1 5 1 0 4.00 47.40 4 299,021,652 73.32
1998 1 6 1 0 59.00 46.00 59 4,280,299,385 71.16
1998 1 9 1 0 28.00 53.40 28 2,358,107,458 82.61
1998 1 12 1 0 20.00 46.90 20 1,479,337,076 72.55
1998 1 13 1 0 4.00 49.10 4 309,746,057 75.95
1998 1 14 1 0 38.00 56.50 38 3,386,073,242 87.40
1998 1 16 1 0 105.00 56.20 105 9,306,575,782 86.94
1998 1 20 1 0 700.00 63.10 700 69,661,320,503 97.61
1998 1 23 1 0 28.00 58.00 28 2,561,240,310 89.72
1998 1 26 1 0 25.00 56.80 25 2,239,508,153 87.87
1998 1 27 1 0 46.00 59.40 46 4,309,318,364 91.89
1998 1 28 1 0 300.00 58.40 300 27,631,114,675 90.34
1998 1 29 1 0 600.00 61.50 600 58,195,669,607 95.14
1998 1 30 1 0 290.00 59.90 290 27,396,124,031 92.66
1998 2 4 1 0 250.00 63.35 250 24,977,612,938 98.00
1998 2 5 1 0 250.00 60.79 250 23,968,257,150 94.04
1998 2 6 1 0 37.00 56.84 37 3,316,806,202 87.93
1998 2 9 1 0 58.00 44.71 58 4,089,751,938 69.16
1998 2 10 1 0 19.00 45.71 19 1,369,711,574 70.71
1998 2 11 1 0 155.00 44.59 155 10,900,175,087 68.98
1998 2 12 1 0 91.00 43.94 91 6,306,171,077 67.97
1998 2 13 1 0 11.00 42.38 11 735,221,064 65.56
1998 2 16 1 0 17.00 43.18 17 1,157,699,546 66.80
1998 2 17 1 0 200.00 47.57 200 15,004,704,624 73.59
1998 2 20 1 0 465.00 50.24 465 36,844,009,623 77.72
1998 2 23 1 0 200.00 50.61 200 15,963,592,622 78.29
1998 2 24 1 0 59.00 48.70 59 4,531,534,349 75.34
1998 2 25 1 0 23.00 45.18 23 1,638,846,832 69.89
1998 2 26 1 0 46.00 46.21 46 3,352,417,535 71.48
1998 2 27 1 0 22.00 44.19 22 1,533,242,983 68.36
1998 3 4 1 0 4.00 42.00 4 264,955,894 64.97
1998 3 5 1 0 2.00 40.60 2 128,062,016 62.81
1998 3 6 1 0 1.00 37.50 1 59,141,941 58.01
1998 3 9 1 0 20.00 56.70 20 1,788,452,285 87.71
1998 3 16 1 0 3.00 38.10 3 180,264,635 58.94
1998 3 17 1 0 10.00 40.10 10 632,424,485 62.03
1998 3 18 1 0 26.00 44.70 26 1,832,927,025 69.15
1998 3 19 1 0 5.00 49.80 5 392,702,486 77.04
1998 3 20 1 0 10.00 51.10 10 805,907,511 79.05
1998 3 23 1 0 9.00 47.10 9 668,540,497 72.86
1998 3 24 1 0 13.00 52.20 13 1,070,232,558 80.75
1998 3 25 1 0 5.00 46.40 5 365,891,473 71.78
1998 3 30 1 0 13.00 38.80 13 795,498,530 60.02
1998 3 31 1 0 11.00 43.80 11 759,855,654 67.76
1998 4 1 1 0 20.00 43.40 20 1,368,938,786 67.14
1998 4 2 1 0 27.00 38.40 27 1,635,156,375 59.40
1998 4 3 1 0 12.00 37.60 12 711,595,830 58.16
1998 4 8 1 0 30.00 43.60 30 2,062,870,890 67.45
1998 4 9 1 0 17.00 52.40 17 1,404,897,086 81.06
1998 4 13 1 0 15.00 45.50 15 1,076,383,320 70.38
1998 4 14 1 0 28.00 48.80 28 2,154,974,606 75.49
1998 4 15 1 0 25.00 49.90 25 1,967,455,226 77.19
1998 4 20 1 0 42.00 51.20 42 3,391,435,445 79.20
1998 4 21 1 0 10.00 50.20 10 791,713,446 77.66
1998 4 22 1 0 20.00 53.80 20 1,696,979,417 83.22
1998 4 23 1 0 25.00 55.90 25 2,204,022,989 86.47
1998 4 24 1 0 14.00 54.60 14 1,205,549,318 84.46
1998 4 29 1 0 12.00 42.90 12 811,900,561 66.36
1998 4 30 1 0 7.00 37.90 7 418,409,516 58.63
1998 5 1 1 0 310.00 51.80 310 25,325,367,549 80.13
1998 5 4 1 0 20.00 43.00 20 1,356,321,839 66.52
1998 5 5 1 0 40.00 43.70 40 2,756,802,994 67.60
1998 5 11 1 0 23.00 46.00 23 1,668,591,286 71.16
Appendix 4 page A4-45
Table A4-6. McAlpine Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute
Obs Fecal Conc
(cfu/100 ml)Flow(mgd)
Obs fecal conc
(cfu/100 ml)
Fecal load
(cfu/hour)Flow (cfs)
1998 5 12 1 0 37.00 42.90 37 2,503,360,064 66.36
1998 5 13 1 0 22.00 40.90 22 1,419,091,152 63.27
1998 5 14 1 0 23.00 41.10 23 1,490,850,040 63.58
1998 5 19 1 0 91.00 38.20 91 5,482,379,043 59.09
1998 5 20 1 0 40.00 33.20 40 2,094,413,258 51.36
1998 5 21 1 0 18.00 39.00 18 1,107,137,129 60.33
1998 5 22 1 0 100.00 36.60 100 5,772,253,408 56.62
1998 5 26 1 0 39.00 37.80 39 2,324,987,971 58.47
1998 5 27 1 0 49.00 35.90 49 2,774,309,008 55.53
1998 6 1 1 0 290.00 42.20 290 19,300,775,194 65.28
1998 6 2 1 0 1250.00 41.20 1250 81,221,598,503 63.73
1998 6 3 1 0 119.00 37.70 119 7,075,426,357 58.32
1998 6 4 1 0 40.00 38.50 40 2,428,762,363 59.56
1998 6 5 1 0 44.00 44.10 44 3,060,240,577 68.22
1998 6 10 1 0 210.00 32.30 210 10,697,594,226 49.97
1998 6 11 1 0 2500.00 31.00 2500 122,226,677,359 47.95
1998 6 12 1 0 73.00 35.10 73 4,041,050,521 54.30
1998 6 15 1 0 137.00 33.10 137 7,151,758,888 51.20
1998 6 18 1 0 155.00 33.90 155 8,286,968,725 52.44
1998 6 19 1 0 59.00 41.30 59 3,842,964,448 63.89
1998 6 22 1 0 64.00 32.70 64 3,300,593,424 50.58
1998 6 23 1 0 46.00 38.90 46 2,822,095,696 60.18
1998 6 24 1 0 47.00 34.80 47 2,579,534,884 53.83
1998 6 25 1 0 53.00 36.70 53 3,067,653,034 56.77
1998 6 30 1 0 119.00 37.60 119 7,056,658,647 58.16
1998 7 1 1 0 580.00 34.60 580 31,649,612,403 53.52
1998 7 2 1 0 60.00 31.40 60 2,971,291,099 48.57
1998 7 3 1 0 46.00 32.60 46 2,365,046,779 50.43
1998 7 9 1 0 450.00 33.00 450 23,420,208,500 51.05
1998 7 10 1 0 43.00 36.80 43 2,495,632,184 56.93
1998 7 13 1 0 58.00 33.40 58 3,055,193,798 51.67
1998 7 14 1 0 26.00 38.00 26 1,558,192,997 58.78
1998 7 17 1 0 73.00 33.00 73 3,799,278,268 51.05
1998 7 20 1 0 59.00 31.80 59 2,958,989,575 49.19
1998 7 21 1 0 59.00 36.60 59 3,405,629,511 56.62
1998 7 22 1 0 38.00 32.40 38 1,941,748,196 50.12
1998 7 23 1 0 64.00 32.80 64 3,310,686,982 50.74
1998 7 28 1 0 73.00 49.60 73 5,710,430,366 76.73
1998 7 29 1 0 54.00 51.70 54 4,402,999,198 79.98
1998 7 30 1 0 33.00 43.90 33 2,284,771,451 67.91
1998 7 31 1 0 128.00 35.90 128 7,247,174,552 55.53
1998 8 3 1 0 51.00 31.00 51 2,493,424,218 47.95
1998 8 6 1 0 47.00 38.00 47 2,816,733,494 58.78
1998 8 7 1 0 56.00 25.60 56 2,260,956,963 39.60
1998 8 10 1 0 42.00 44.20 42 2,927,762,630 68.37
1998 8 11 1 0 57.00 43.70 57 3,928,444,266 67.60
1998 8 12 1 0 46.00 35.60 46 2,582,689,121 55.07
1998 8 17 1 0 91.00 43.20 91 6,199,967,923 66.83
1998 8 18 1 0 56.00 36.00 56 3,179,470,730 55.69
1998 8 19 1 0 6.00 35.70 6 337,818,765 55.23
1998 8 20 1 0 9.00 31.40 9 445,693,665 48.57
1998 8 21 1 0 450.00 23.40 450 16,607,056,937 36.20
1998 8 24 1 0 500.00 35.90 500 28,309,275,595 55.53
1998 8 27 1 0 29.00 33.30 29 1,523,023,256 51.51
1998 8 28 1 0 55.00 34.60 55 3,001,256,349 53.52
1998 8 31 1 0 55.00 33.30 55 2,888,492,382 51.51
1998 9 1 1 0 64.00 30.80 64 3,108,815,825 47.65
1998 9 2 1 0 36.00 32.80 36 1,862,261,427 50.74
1998 9 8 1 0 37.00 33.60 37 1,960,673,617 51.98
1998 9 9 1 0 23.00 33.50 23 1,215,169,741 51.82
1998 9 10 1 0 26.00 32.80 26 1,344,966,586 50.74
1998 9 11 1 0 32.00 32.00 32 1,614,969,260 49.50
1998 9 14 1 0 38.00 34.80 38 2,085,581,395 53.83
1998 9 17 1 0 55.00 38.40 55 3,330,874,098 59.40
Appendix 4 page A4-46
Table A4-6. McAlpine Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute
Obs Fecal Conc
(cfu/100 ml)Flow(mgd)
Obs fecal conc
(cfu/100 ml)
Fecal load
(cfu/hour)Flow (cfs)
1998 9 18 1 0 36.00 36.90 36 2,095,044,106 57.08
1998 9 21 1 0 82.00 38.90 82 5,030,692,328 60.18
1998 9 22 1 0 36.00 42.30 36 2,401,635,926 65.43
1998 9 23 1 0 45.00 37.60 45 2,668,484,362 58.16
1998 9 28 1 0 19.00 35.40 19 1,060,769,848 54.76
1998 9 29 1 0 13.00 34.80 13 713,488,372 53.83
1998 9 30 1 0 23.00 36.00 23 1,305,854,050 55.69
1998 10 1 1 0 23.00 36.30 23 1,316,736,167 56.15
1998 10 2 1 0 9.00 35.60 9 505,308,741 55.07
1998 10 7 1 0 7.00 38.40 7 423,929,431 59.40
1998 10 8 1 0 4.00 43.30 4 273,156,910 66.98
1998 10 9 1 0 1.00 36.80 1 58,037,958 56.93
1998 10 12 1 0 3.00 37.00 3 175,060,144 57.24
1998 10 13 1 0 1.00 37.00 1 58,353,381 57.24
1998 10 14 1 0 10.00 42.80 10 675,006,683 66.21
1998 10 19 1 0 2.00 37.80 2 119,230,152 58.47
1998 10 20 1 0 400.00 34.20 400 21,574,979,952 52.90
1998 10 21 1 0 2.00 36.30 2 114,498,797 56.15
1998 10 22 1 0 1.00 36.60 1 57,722,534 56.62
1998 10 23 1 0 2.00 35.40 2 111,659,984 54.76
1998 10 26 1 0 3.00 31.80 3 150,457,097 49.19
1998 10 29 1 0 1.00 32.80 1 51,729,484 50.74
1998 10 30 1 0 25.00 20.00 25 788,559,209 30.94
1998 11 2 1 0 26.00 42.10 26 1,726,313,820 65.13
1998 11 3 1 0 1.00 43.80 1 69,077,787 67.76
1998 11 4 1 0 4.00 34.90 4 220,165,731 53.99
1998 11 5 1 0 13.00 35.30 13 723,739,642 54.61
1998 11 10 1 0 1.00 33.90 1 53,464,314 52.44
1998 11 11 1 0 1.00 35.20 1 55,514,568 54.45
1998 11 12 1 0 1.00 34.60 1 54,568,297 53.52
1998 11 13 1 0 191.00 33.00 191 9,940,577,386 51.05
1998 11 16 1 0 34.00 34.40 34 1,844,597,701 53.21
1998 11 17 1 0 1.00 38.80 1 61,192,195 60.02
1998 11 18 1 0 10.00 37.90 10 597,727,880 58.63
1998 11 19 1 0 1.00 37.60 1 59,299,652 58.16
1998 11 20 1 0 6.00 32.50 6 307,538,091 50.27
1998 11 23 1 0 230.00 37.20 230 13,493,825,180 57.55
1998 11 24 1 0 29.00 34.70 29 1,587,054,264 53.68
1998 11 25 1 0 2.00 36.90 2 116,391,339 57.08
1998 11 27 1 0 5.00 31.40 5 247,607,592 48.57
1998 11 30 1 0 5.00 35.00 5 275,995,723 54.14
1998 12 1 1 0 4.00 33.50 4 211,333,868 51.82
1998 12 2 1 0 15.00 33.40 15 790,136,327 51.67
1998 12 3 1 0 8.00 34.10 8 430,237,904 52.75
1998 12 4 1 0 55.00 34.30 55 2,975,233,895 53.06
1998 12 7 1 0 220.00 34.50 220 11,970,328,789 53.37
1998 12 8 1 0 110.00 36.00 110 6,245,388,933 55.69
1998 12 9 1 0 56.00 35.00 56 3,091,152,098 54.14
1998 12 10 1 0 15.00 34.10 15 806,696,071 52.75
1998 12 11 1 0 73.00 31.50 73 3,626,583,801 48.73
1998 12 14 1 0 2000.00 35.70 2000 112,606,255,012 55.23
1998 12 15 1 0 42.00 34.20 42 2,265,372,895 52.90
1998 12 16 1 0 1.00 41.50 1 65,450,414 64.20
1998 12 17 1 0 10.00 40.10 10 632,424,485 62.03
1998 12 18 1 0 3.00 37.60 3 177,898,957 58.16
1998 12 21 1 0 10.00 33.30 10 525,180,433 51.51
1998 12 22 1 0 164.00 37.40 164 9,673,413,526 57.85
1998 12 23 1 0 7.00 34.70 7 383,082,064 53.68
1998 12 28 1 0 20.00 37.20 20 1,173,376,103 57.55
1998 12 29 1 0 3000.00 36.30 3000 171,748,195,670 56.15
1998 12 30 1 0 35.00 37.40 35 2,064,448,009 57.85
1998 12 31 1 0 1.00 34.00 1 53,622,026 52.60
1999 1 4 1 0 56.00 39.45 56 3,484,170,008 61.03
1999 1 5 1 0 4.00 43.06 4 271,642,876 66.61
Appendix 4 page A4-47
Table A4-6. McAlpine Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute
Obs Fecal Conc
(cfu/100 ml)Flow(mgd)
Obs fecal conc
(cfu/100 ml)
Fecal load
(cfu/hour)Flow (cfs)
1999 1 6 1 0 10.00 42.28 10 666,805,667 65.40
1999 1 7 1 0 11.00 37.10 11 643,622,026 57.39
1999 1 8 1 0 19.00 39.46 19 1,182,428,762 61.04
1999 1 11 1 0 20.00 38.87 20 1,226,051,858 60.13
1999 1 12 1 0 5.00 38.98 5 307,380,380 60.30
1999 1 13 1 0 13.00 32.31 13 662,437,049 49.98
1999 1 14 1 0 29.00 38.49 29 1,760,395,349 59.54
1999 1 15 1 0 19.00 30.44 19 912,142,208 47.09
1999 1 19 1 0 52.00 41.22 52 3,380,458,701 63.76
1999 1 20 1 0 54.00 42.87 54 3,650,997,594 66.32
1999 1 21 1 0 5.00 43.19 5 340,578,722 66.81
1999 1 22 1 0 6.00 44.55 6 421,563,753 68.92
1999 1 25 1 0 7.00 56.85 7 627,614,274 87.94
1999 1 26 1 0 5.00 55.38 5 436,704,090 85.67
1999 1 27 1 0 8.00 54.78 8 691,156,375 84.74
1999 1 28 1 0 7.00 53.32 7 588,643,678 82.48
1999 1 29 1 0 8.00 45.44 8 573,314,087 70.29
1999 2 1 1 0 58.00 41.15 58 3,764,108,527 63.66
1999 2 2 1 0 4.00 53.58 4 338,008,019 82.88
1999 2 3 1 0 10.00 49.21 10 776,099,973 76.12
1999 2 4 1 0 2.00 46.72 2 147,365,945 72.27
1999 2 5 1 0 82.00 41.71 82 5,394,091,954 64.52
1999 2 8 1 0 58.00 43.43 58 3,972,666,667 67.18
1999 2 9 1 0 21.00 42.40 21 1,404,266,239 65.59
1999 2 10 1 0 14.00 40.72 14 899,083,667 62.99
1999 2 11 1 0 37.00 39.01 37 2,276,365,410 60.35
1999 2 12 1 0 109.00 41.40 109 7,116,904,571 64.04
1999 2 15 1 0 58.00 34.61 58 3,165,875,969 53.54
1999 2 16 1 0 25.00 37.39 25 1,474,211,441 57.84
1999 2 17 1 0 47.00 41.01 47 3,039,848,436 63.44
1999 2 18 1 0 27.00 46.63 27 1,985,607,859 72.13
1999 2 19 1 0 200.00 48.88 200 15,417,909,650 75.61
1999 2 22 1 0 24.00 43.02 24 1,628,343,224 66.55
1999 2 23 1 0 6.00 44.80 6 423,929,431 69.30
1999 2 24 1 0 9.00 38.55 9 547,181,235 59.63
1999 2 25 1 0 1.00 38.49 1 60,703,288 59.54
1999 2 26 1 0 33.00 40.22 33 2,093,246,191 62.22
1999 2 27 1 0 33.00 40.91 33 2,129,157,177 63.28
1999 2 28 1 0 33.00 41.53 33 2,161,425,020 64.24
1999 3 1 1 0 380.00 40.65 380 24,361,748,196 62.88
1999 3 2 1 0 31.00 37.82 31 1,849,045,175 58.50
1999 3 3 1 0 47.00 39.90 47 2,957,570,168 61.72
1999 3 4 1 0 34.00 39.34 34 2,109,490,511 60.86
1999 3 5 1 0 82.00 38.75 82 5,011,293,772 59.94
1999 3 8 1 0 64.00 40.82 64 4,120,190,323 63.15
1999 3 9 1 0 46.00 38.84 46 2,817,742,850 60.08
1999 3 10 1 0 28.00 42.87 28 1,893,109,864 66.32
1999 3 11 1 0 39.00 38.77 39 2,384,650,361 59.97
1999 3 12 1 0 82.00 39.28 82 5,079,835,338 60.76
1999 3 13 1 0 13.00 38.81 13 795,703,555 60.04
1999 3 14 1 0 13.00 39.85 13 817,026,196 61.64
1999 3 15 1 0 1800.00 43.16 1800 122,523,175,621 66.77
1999 3 16 1 0 520.00 44.33 520 36,355,102,914 68.58
1999 3 17 1 0 52.00 38.39 52 3,148,369,955 59.39
1999 3 18 1 0 5.00 38.18 5 301,071,906 59.06
1999 3 19 1 0 1.00 39.21 1 61,838,813 60.65
1999 3 22 1 0 53.00 45.42 53 3,796,534,082 70.26
1999 3 23 1 0 41.00 32.88 41 2,126,081,796 50.86
1999 3 24 1 0 100.00 38.14 100 6,015,129,644 59.00
1999 3 25 1 0 37.00 40.03 37 2,335,885,859 61.92
1999 3 26 1 0 23.00 39.70 23 1,440,066,827 61.41
1999 3 29 1 0 1.00 38.76 1 61,129,110 59.96
1999 3 30 1 0 60.00 26.11 60 2,470,713,713 40.39
1999 3 31 1 0 310.00 44.02 310 21,521,673,349 68.10
Appendix 4 page A4-48
Table A4-6. McAlpine Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute
Obs Fecal Conc
(cfu/100 ml)Flow(mgd)
Obs fecal conc
(cfu/100 ml)
Fecal load
(cfu/hour)Flow (cfs)
1999 4 1 1 0 210.00 39.26 210 13,002,710,505 60.73
1999 4 5 1 0 137.00 36.50 137 7,886,380,647 56.46
1999 4 6 1 0 37.00 34.43 37 2,009,106,923 53.26
1999 4 7 1 0 2.00 37.81 2 119,261,695 58.49
1999 4 8 1 0 119.00 38.16 119 7,161,757,819 59.03
1999 4 9 1 0 26.00 43.02 26 1,764,038,492 66.55
1999 4 10 1 0 26.00 38.02 26 1,559,013,098 58.81
1999 4 11 1 0 26.00 36.39 26 1,492,174,820 56.29
1999 4 12 1 0 119.00 38.48 119 7,221,814,488 59.53
1999 4 13 1 0 45.00 35.98 45 2,553,512,430 55.66
1999 4 14 1 0 43.00 37.42 43 2,537,678,161 57.89
1999 4 15 1 0 44.00 37.41 44 2,596,000,000 57.87
1999 4 16 1 0 82.00 37.25 82 4,817,308,206 57.62
1999 4 17 1 0 82.00 36.20 82 4,681,518,311 56.00
1999 4 18 1 0 82.00 34.75 82 4,493,998,931 53.76
1999 4 19 1 0 146.00 37.92 146 8,731,432,237 58.66
1999 4 20 1 0 146.00 37.29 146 8,586,368,885 57.68
1999 4 21 1 0 200.00 36.51 200 11,516,118,685 56.48
1999 4 22 1 0 50.00 40.83 50 3,219,687,249 63.16
1999 4 23 1 0 30.00 45.40 30 2,148,035,285 70.23
1999 4 24 1 0 30.00 34.33 30 1,624,274,258 53.11
1999 4 25 1 0 30.00 35.79 30 1,693,352,045 55.36
1999 4 26 1 0 200.00 38.61 200 12,178,508,420 59.73
1999 4 27 1 0 70.00 42.33 70 4,673,159,583 65.48
1999 4 28 1 0 55.00 49.04 55 4,253,803,796 75.86
1999 4 29 1 0 64.00 42.61 64 4,300,865,009 65.91
1999 4 30 1 0 3800.00 50.11 3800 300,311,734,830 77.52
1999 5 3 1 0 82.00 42.82 82 5,537,641,272 66.24
1999 5 4 1 0 40.00 41.81 40 2,637,572,841 64.68
1999 5 5 1 0 164.00 39.32 164 10,170,016,573 60.82
1999 5 6 1 0 800.00 40.89 800 51,590,697,674 63.25
1999 5 7 1 0 164.00 40.68 164 10,521,777,065 62.93
1999 5 10 1 0 18.00 34.66 18 983,932,638 53.62
1999 5 11 1 0 10.00 39.52 10 623,277,199 61.13
1999 5 12 1 0 45.00 38.57 45 2,737,325,581 59.66
1999 5 13 1 0 340.00 39.37 340 21,110,991,713 60.90
1999 5 14 1 0 13.00 38.63 13 792,013,098 59.76
1999 5 17 1 0 16.00 39.18 16 988,663,994 60.61
1999 5 18 1 0 430.00 39.50 430 26,787,356,322 61.10
1999 5 19 1 0 14.00 39.41 14 870,159,316 60.96
1999 5 20 1 0 4800.00 41.16 4800 311,588,131,516 63.67
1999 5 21 1 0 200.00 37.77 200 11,913,552,526 58.43
1999 5 24 1 0 51.00 36.20 51 2,911,676,022 56.00
1999 5 25 1 0 119.00 40.72 119 7,642,211,173 62.99
1999 5 26 1 0 300.00 37.75 300 17,860,866,079 58.40
1999 5 27 1 0 23.00 40.10 23 1,454,576,316 62.03
1999 5 28 1 0 17.00 36.04 17 966,268,912 55.75
1999 6 1 1 0 28.00 37.58 28 1,659,507,084 58.13
1999 6 2 1 0 82.00 38.72 82 5,007,414,060 59.90
1999 6 3 1 0 200.00 37.81 200 11,926,169,473 58.49
1999 6 4 1 0 44.00 35.54 44 2,466,234,697 54.98
1999 6 5 1 0 44.00 35.74 44 2,480,113,339 55.29
1999 6 6 1 0 44.00 35.96 44 2,495,379,845 55.63
1999 6 7 1 0 2200.00 36.37 2200 126,191,553,061 56.26
1999 6 8 1 0 119.00 36.00 119 6,756,375,301 55.69
1999 6 9 1 0 7.00 36.40 7 401,849,773 56.31
1999 6 10 1 0 38.00 37.50 38 2,247,393,745 58.01
1999 6 11 1 0 8.00 39.27 8 495,467,522 60.75
1999 6 12 1 0 8.00 37.90 8 478,182,304 58.63
1999 6 13 1 0 8.00 37.88 8 477,929,965 58.60
1999 6 14 1 0 900.00 38.84 900 55,129,751,403 60.08
1999 6 15 1 0 17.00 38.39 17 1,029,274,793 59.39
1999 6 16 1 0 26.00 42.33 26 1,735,744,988 65.48
1999 6 17 1 0 10.00 46.99 10 741,087,944 72.69
Appendix 4 page A4-49
Table A4-6. McAlpine Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute
Obs Fecal Conc
(cfu/100 ml)Flow(mgd)
Obs fecal conc
(cfu/100 ml)
Fecal load
(cfu/hour)Flow (cfs)
1999 6 18 1 0 24.00 38.23 24 1,447,037,690 59.14
1999 6 19 1 0 24.00 35.67 24 1,350,139,535 55.18
1999 6 20 1 0 24.00 36.60 24 1,385,340,818 56.62
1999 6 21 1 0 200.00 37.78 200 11,916,706,763 58.44
1999 6 22 1 0 3.00 38.07 3 180,122,694 58.89
1999 6 23 1 0 4.00 41.63 4 262,621,759 64.40
1999 6 24 1 0 8.00 44.97 8 567,384,122 69.57
1999 6 25 1 0 10.00 37.82 10 596,466,186 58.50
1999 6 28 1 0 10.00 39.04 10 615,707,030 60.39
1999 6 29 1 0 11.00 42.43 11 736,088,479 65.64
1999 6 30 1 0 16.00 38.67 16 975,794,707 59.82
1999 7 1 1 0 8.00 39.66 8 500,388,132 61.35
1999 7 2 1 0 55.00 40.00 55 3,469,660,519 61.88
1999 7 6 1 0 40.00 38.37 40 2,420,561,347 59.36
1999 7 7 1 0 10.00 44.64 10 704,025,662 69.05
1999 7 8 1 0 35.00 38.16 35 2,106,399,358 59.03
1999 7 9 1 0 600.00 34.59 600 32,731,515,638 53.51
1999 7 12 1 0 500.00 38.19 500 30,115,076,183 59.08
1999 7 13 1 0 275.00 38.25 275 16,589,314,354 59.17
1999 7 14 1 0 460.00 38.13 460 27,662,341,620 58.98
1999 7 15 1 0 3.00 37.31 3 176,526,864 57.72
1999 7 16 1 0 4.00 35.53 4 224,140,070 54.96
1999 7 19 1 0 9.00 34.55 9 490,404,972 53.45
1999 7 20 1 0 11.00 39.21 11 680,226,945 60.65
1999 7 21 1 0 19.00 33.92 19 1,016,421,278 52.47
1999 7 22 1 0 17.00 37.16 17 996,297,247 57.48
1999 7 23 1 0 19.00 38.21 19 1,144,972,200 59.11
1999 7 24 1 0 19.00 33.69 19 1,009,529,270 52.12
1999 7 25 1 0 19.00 37.34 19 1,118,902,433 57.76
1999 7 26 1 0 372.00 32.66 372 19,161,231,756 50.52
1999 7 27 1 0 173.00 26.01 173 7,096,607,057 40.24
1999 7 28 1 0 24.00 28.50 24 1,078,748,998 44.09
1999 7 29 1 0 500.00 28.63 500 22,576,450,147 44.29
1999 7 30 1 0 29.00 36.73 29 1,679,899,225 56.82
1999 7 31 1 0 29.00 39.54 29 1,808,418,605 61.17
1999 8 1 1 0 29.00 40.11 29 1,834,488,372 62.05
1999 8 2 1 0 6000.00 42.22 6000 399,515,637,530 65.31
1999 8 3 1 0 58.00 42.09 58 3,850,093,023 65.11
1999 8 4 1 0 119.00 37.88 119 7,109,208,233 58.60
1999 8 5 1 0 64.00 33.08 64 3,338,948,944 51.17
1999 8 6 1 0 72.00 36.18 72 4,108,330,393 55.97
1999 8 7 1 0 72.00 35.37 72 4,016,352,847 54.71
1999 8 8 1 0 72.00 35.32 72 4,010,675,221 54.64
1999 8 9 1 0 2000.00 37.56 2000 118,473,135,525 58.10
1999 8 10 1 0 96.00 38.61 96 5,845,684,042 59.73
1999 8 11 1 0 100.00 38.03 100 5,997,781,342 58.83
1999 8 12 1 0 55.00 34.68 55 3,008,195,670 53.65
1999 8 13 1 0 22.00 37.45 22 1,299,387,864 57.93
1999 8 14 1 0 22.00 36.06 22 1,251,159,583 55.78
1999 8 15 1 0 22.00 36.18 22 1,255,323,176 55.97
1999 8 16 1 0 430.00 38.48 430 26,095,632,184 59.53
1999 8 17 1 0 73.00 37.08 73 4,269,007,217 57.36
1999 8 18 1 0 10.00 36.12 10 569,655,172 55.87
1999 8 19 1 0 46.00 36.13 46 2,621,139,268 55.89
1999 8 20 1 0 35.00 35.20 35 1,943,009,890 54.45
1999 8 21 1 0 35.00 37.86 35 2,089,839,615 58.57
1999 8 22 1 0 35.00 34.47 35 1,902,714,515 53.32
1999 8 23 1 0 84.00 37.32 84 4,944,076,985 57.73
1999 8 24 1 0 17.00 37.40 17 1,002,731,890 57.85
1999 8 25 1 0 28.00 39.51 28 1,744,734,563 61.12
1999 8 26 1 0 64.00 41.45 64 4,183,779,738 64.12
1999 8 27 1 0 59.00 39.09 59 3,637,323,978 60.47
1999 8 28 1 0 59.00 36.54 59 3,400,046,512 56.52
1999 8 29 1 0 59.00 36.35 59 3,382,367,014 56.23
Appendix 4 page A4-50
Table A4-6. McAlpine Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute
Obs Fecal Conc
(cfu/100 ml)Flow(mgd)
Obs fecal conc
(cfu/100 ml)
Fecal load
(cfu/hour)Flow (cfs)
1999 8 30 1 0 73.00 38.02 73 4,377,229,083 58.81
1999 8 31 1 0 220.00 35.39 220 12,279,128,575 54.75
1999 9 1 1 0 480.00 34.20 480 25,889,975,942 52.90
1999 9 2 1 0 146.00 33.48 146 7,709,080,994 51.79
1999 9 3 1 0 42.00 34.31 42 2,272,659,182 53.07
1999 9 4 1 0 42.00 33.41 42 2,213,044,106 51.68
1999 9 5 1 0 42.00 31.26 42 2,070,630,313 48.36
1999 9 6 1 0 42.00 35.63 42 2,360,094,627 55.12
1999 9 7 1 0 510.00 39.66 510 31,899,743,384 61.35
1999 9 8 1 0 110.00 37.61 110 6,524,696,605 58.18
1999 9 9 1 0 21.00 36.39 21 1,205,218,123 56.29
1999 9 10 1 0 8.00 35.25 8 444,747,394 54.53
1999 9 11 1 0 8.00 31.62 8 398,947,875 48.91
1999 9 12 1 0 8.00 34.40 8 434,022,989 53.21
1999 9 13 1 0 240.00 34.82 240 13,179,663,192 53.86
1999 9 14 1 0 30.00 36.01 30 1,703,761,026 55.70
1999 9 15 1 0 32.00 37.85 32 1,910,205,827 58.55
1999 9 16 1 0 14.00 38.78 14 856,249,131 59.99
1999 9 17 1 0 42.00 38.66 42 2,560,798,717 59.80
1999 9 18 1 0 42.00 32.80 42 2,172,638,332 50.74
1999 9 19 1 0 42.00 33.66 42 2,229,603,849 52.07
1999 9 20 1 0 410.00 35.49 410 22,948,492,382 54.90
1999 9 21 1 0 60.00 33.53 60 3,172,846,832 51.87
1999 9 22 1 0 17.00 34.34 17 920,690,190 53.12
1999 9 23 1 0 22.00 32.19 22 1,116,883,721 49.80
1999 9 24 1 0 39.00 33.17 39 2,040,207,698 51.31
1999 9 25 1 0 39.00 33.30 39 2,048,203,689 51.51
1999 9 26 1 0 39.00 34.89 39 2,146,000,802 53.97
1999 9 27 1 0 1000.00 37.11 1000 58,526,864,475 57.41
1999 9 28 1 0 265.00 35.31 265 14,757,333,601 54.62
1999 9 29 1 0 64.00 37.15 64 3,749,756,750 57.47
1999 9 30 1 0 46.00 34.89 46 2,531,180,433 53.97
1999 10 1 1 0 38.00 37.15 38 2,226,418,070 57.47
1999 10 2 1 0 38.00 39.18 38 2,348,076,985 60.61
1999 10 3 1 0 38.00 35.52 38 2,128,731,355 54.95
1999 10 4 1 0 220.00 36.11 220 12,528,944,133 55.86
1999 10 5 1 0 100.00 37.31 100 5,884,228,816 57.72
1999 10 6 1 0 55.00 35.56 55 3,084,528,201 55.01
1999 10 7 1 0 82.00 35.51 82 4,592,284,951 54.93
1999 10 8 1 0 100.00 35.51 100 5,600,347,501 54.93
1999 10 11 1 0 22.00 56.16 22 1,948,561,347 86.88
1999 10 12 1 0 36.00 57.21 36 3,248,170,008 88.50
1999 10 13 1 0 2.00 53.39 2 168,404,705 82.59
1999 10 14 1 0 2700.00 47.22 2700 201,073,135,525 73.05
1999 10 15 1 0 1.00 35.82 1 56,492,382 55.41
1999 10 16 1 0 1.00 37.09 1 58,495,322 57.38
1999 10 17 1 0 1.00 37.09 1 58,495,322 57.38
1999 10 18 1 0 330.00 34.89 330 18,158,468,324 53.97
1999 10 19 1 0 500.00 35.81 500 28,238,305,266 55.40
1999 10 20 1 0 210.00 38.98 210 12,909,975,942 60.30
1999 10 21 1 0 49.00 44.63 49 3,448,952,954 69.04
1999 10 22 1 0 30.00 33.38 30 1,579,326,383 51.64
1999 10 25 1 0 15.00 39.21 15 927,582,197 60.65
1999 10 26 1 0 17.00 33.45 17 896,828,388 51.74
1999 10 27 1 0 260.00 39.54 260 16,213,408,180 61.17
1999 10 28 1 0 2.00 36.84 2 116,202,085 56.99
1999 10 29 1 0 1.00 34.15 1 53,858,594 52.83
1999 10 30 1 0 1.00 34.44 1 54,315,958 53.28
1999 10 31 1 0 1.00 36.73 1 57,927,559 56.82
1999 11 1 1 0 109.00 38.67 109 6,647,601,443 59.82
1999 11 2 1 0 57.00 36.40 57 3,272,205,293 56.31
1999 11 3 1 0 30.00 34.25 30 1,620,489,174 52.98
1999 11 4 1 0 580.00 33.83 580 30,945,271,318 52.33
1999 11 5 1 0 20.00 35.30 20 1,113,445,603 54.61
Appendix 4 page A4-51
Table A4-6. McAlpine Wastewater Treatment Plant - Observed Values
Year Month Day Hour Minute
Obs Fecal Conc
(cfu/100 ml)Flow(mgd)
Obs fecal conc
(cfu/100 ml)
Fecal load
(cfu/hour)Flow (cfs)
1999 11 8 1 0 41.00 36.90 41 2,386,022,454 57.08
1999 11 9 1 0 2100.00 37.69 2100 124,827,345,630 58.30
1999 11 10 1 0 3.00 34.50 3 163,231,756 53.37
1999 11 11 1 0 1.00 36.67 1 57,832,932 56.73
1999 11 12 1 0 200.00 36.18 200 11,412,028,869 55.97
1999 11 15 1 0 37.00 37.22 37 2,171,912,858 57.58
1999 11 16 1 0 1.00 36.61 1 57,738,305 56.63
1999 11 17 1 0 1.00 34.92 1 55,072,975 54.02
1999 11 18 1 0 1.00 34.42 1 54,284,416 53.25
1999 11 19 1 0 1.00 36.15 1 57,012,831 55.92
1999 11 22 1 0 18.00 36.16 18 1,026,514,836 55.94
1999 11 23 1 0 2500.00 35.40 2500 139,574,979,952 54.76
1999 11 24 1 0 220.00 34.54 220 11,984,207,431 53.43
1999 11 25 1 0 1.00 38.13 1 60,135,525 58.98
1999 11 26 1 0 3.00 34.65 3 163,941,460 53.60
1999 11 29 1 0 4.00 28.17 4 177,709,703 43.58
1999 11 30 1 0 3.00 40.71 3 192,613,472 62.98
1999 12 1 1 0 1.00 33.93 1 53,511,628 52.49
1999 12 2 1 0 6.00 38.92 6 368,288,693 60.21
1999 12 3 1 0 1.00 37.47 1 59,094,627 57.96
1999 12 6 1 0 1.00 34.11 1 53,795,509 52.77
1999 12 7 1 0 1.00 37.68 1 59,425,822 58.29
1999 12 8 1 0 4.00 38.47 4 242,686,982 59.51
1999 12 9 1 0 6000.00 35.37 6000 334,696,070,569 54.71
1999 12 10 1 0 1.00 31.80 1 50,152,366 49.19
1999 12 13 1 0 9.00 37.56 9 533,129,110 58.10
1999 12 14 1 0 7.00 41.23 7 455,172,146 63.78
1999 12 15 1 0 13.00 45.86 13 940,246,458 70.94
1999 12 16 1 0 4.00 45.17 4 284,953,756 69.87
1999 12 17 1 0 850.00 42.39 850 56,825,942,261 65.57
1999 12 20 1 0 46.00 39.35 46 2,854,742,048 60.87
1999 12 21 1 0 102.00 39.59 102 6,368,688,051 61.24
1999 12 22 1 0 38.00 38.95 38 2,334,292,970 60.25
1999 12 23 1 0 290.00 37.57 290 17,183,178,295 58.12
1999 12 28 1 0 6.00 39.34 6 372,263,031 60.86
1999 12 29 1 0 1.00 36.29 1 57,233,627 56.14
1999 12 30 1 0 1.00 33.80 1 53,306,603 52.29
1999 12 31 1 0 9.00 36.27 9 514,818,765 56.11
2000 1 1 1 0 9.00 36.27 9 514,818,765 56.11
Appendix 4 page A4-52
Appendix 5.
Sanitary Sewer Overflow Database
Table A5-1. Sugar Creek SSO Data
Sub-Watershed ID Start Date Start Time End Date End Time Gallons (c.f.u./hour)Flow (cfs)
Appendix 5 page A5-1
Table A5-1. Sugar Creek SSO Data
Sub-Watershed ID Start Date Start Time End Date End Time Gallons (c.f.u./hour)Flow (cfs)
Appendix 5 page A5-2
Table A5-2. Little Sugar Creek SSO Data
Sub-Watershed
ID Start Date Start Time End Date End Time Gallons (c.f.u./hour)Flow (cfs)
Appendix 5 page A5-3
Table A5-2. Little Sugar Creek SSO Data
Sub-Watershed
ID Start Date Start Time End Date End Time Gallons (c.f.u./hour)Flow (cfs)
Appendix 5 page A5-4
Table A5-2. Little Sugar Creek SSO Data
Sub-Watershed
ID Start Date Start Time End Date End Time Gallons (c.f.u./hour)Flow (cfs)
Appendix 5 page A5-5
Table A5-3. McAlpine Creek SSO Data
Sub-Watershed ID Start Date Start Time End Date End Time Gallons (c.f.u./hour)Flow (cfs)
Appendix 5 page A5-6
Table A5-3. McAlpine Creek SSO Data
Sub-Watershed ID Start Date Start Time End Date End Time Gallons (c.f.u./hour)Flow (cfs)
Appendix 5 page A5-7
Appendix 6.
Results of TMDL Field Study of Storm Drains
Table A6-1. Results of TMDL Study of Storm Drain Outfalls
Easting Northing Address Date Time
DW Flow
Present Flow (cfs)
concentration
(cfu/100 ml)
Concentration Used in
Calculations
Appendix 6 page A6-1
Table A6-1. Results of TMDL Study of Storm Drain Outfalls
Easting Northing Address Date Time
DW Flow
Present Flow (cfs)
concentration
(cfu/100 ml)
Concentration Used in
Calculations
Appendix 6 page A6-2
Table A6-1. Results of TMDL Study of Storm Drain Outfalls
Easting Northing Address Date Time
DW Flow
Present Flow (cfs)
concentration
(cfu/100 ml)
Concentration Used in
Calculations
Appendix 6 page A6-3
Appendix 7.
Groundwater Concentration Data
Table A7-1. Fecal Coliform Sample Data for Ground Water Investigation
Site Date
Concentration (cfu/100
ml)
MW-1 (Downgradient) FC
Concentration (cfu/100 ml)
Concentration Used In
Calculations
Beatties Ford Road 11/13/00 <200 <200 10
Beatties Ford Road 11/20/00 <10 <200 10
Beatties Ford Road 11/28/00 <10 <10 10
Beatties Ford Road 12/5/00 <10 <10 10
Latta Park 11/16/00 -<200
Latta Park 11/20/00 -<10 10
Latta Park 11/28/00 -<10 10
Latta Park 12/5/00 -<10 10
Latta Park 12/13/00 -<10 10
Latta Park 12/20/00 -<10 10
Latta Park 12/27/00 -<10 10
Masonic 11/16/00 <200 <200
Masonic 11/20/00 <200 <200
Masonic 11/28/00 <10 1700 1700
Masonic 12/5/00 <10 80 80
Masonic 12/14/00 <10 <10 10
Masonic 12/20/00 <10 <10 10
Masonic 12/27/00 <10 <10 10
McDonald 11/13/00 <200 330 330
McDonald 11/20/00 <10 <200
McDonald 11/28/00 <20 30 30
McDonald 12/5/00 <10 <10 10
McDonald 12/13/00 <10 <10 10
McDonald 12/20/00 <10 20 20
McDonald 12/27/00 <10 <10 10
Meadowbrook 11/13/00 2000 <200 10
Meadowbrook 11/20/00 30 <200 10
Meadowbrook 11/28/00 <10 <10 10
Meadowbrook 12/6/00 <10 <10 10
Meadowbrook 12/20/00 <10 <10 10
Meadowbrook 12/27/00 <10 <10 10
Mint Museum 11/13/00 <200 <200 10
Mint Museum 11/20/00 <200 <200 10
Mint Museum 11/28/00 <10 <10 10
Mint Museum 12/6/00 <10 <10 10
Sharon View 11/16/00 <200 <200 10
Sharon View 11/20/00 <10 <10 10
Sharon View 11/28/00 <10 <10 10
Sharon View 12/5/00 <10 <10 10
Sharon View 12/21/00 <10 <10 10
Sharon View 12/27/00 <10 <10 10
Southwest Blvd.11/13/00 <200 <200 10
Southwest Blvd.11/20/00 <200 <200 10
Southwest Blvd.11/28/00 <10 <10 10
Southwest Blvd.12/5/00 <10 <10 10
Thermal Road 11/16/00 <200 <200 10
Thermal Road 11/21/00 <200 <200 10
Thermal Road 11/29/00 <10 140 140
Thermal Road 12/5/00 <10 30 30
Thermal Road 12/21/00 <10 <10 10
Thermal Road 12/27/00 <10 <10 10
NS = Not Sampled
Appendix 7 page A7-1
Appendix 8. Model Selection Criteria
FIGURE A8-1: TMDL Model Selection Citeria, Mecklenburg County, NC
Model Ease of Use (Acceptability)Accuracy Available Sources Baseflow/Stormwater User Interface Tools
Simple Method Simple
Generally used as an
indicator or planning tool.
Limited Screening Level
Tool non-point
but is rarely (if ever used).
Used extensively for
stormwater load planning
method rountine (pre and
post processor)NA
Watershed
Management
Model
Simple/Moderately
Complex Planning tool.Screening Level Tool
Point (limited) and non-
point
Runoff Simulation (uses
averages). Unable to
simulate individual events
Pre and Post processor
based in arcview available
(free)NA
SLAMM Moderately Complex
Generally used as an
indicator or planning tool.
for hydrograph generation.
No in-stream water quality
process considered.Point and non-point
Very Limited Baseflow
capabilities. Good user interface NA
P8-UCM Moderately Complex Screening Applications Moderately high Point and non-point Limited baseflow simulation (free)NA
HSPF(Basins)Very Complex
Industry standard for water
quality modeling High (data is limiting factor)Point and non-point
Most highly advanced
baseflow simulation
available. Very good non-
urban stormwater.
Somewhat user friendly
pre/post processors
available for free.
database (free). Calibration
tools (free). GIS based
multiple scenario input
engine (free)
SWMM Very Complex
Excellent urban hydrology
and hydraulics, limited
water quality High (data is limiting factor)Point and non-point
Limited Baseflow
Simulation. Industry
standard for urban
stormwater
Highly advanced pre/post
processors for sale ($400 ~
$10K) some platforms have
user interactive help. DOS
version is free.
Generally tools are
dependant on the supplier
selected
Appendix 8 page A8-1
FIGURE A8-1: TMDL Model Selection Citeria, Mecklenburg County, NC
Model
Simple Method
Watershed
Management
Model
SLAMM
P8-UCM
HSPF(Basins)
SWMM
cont.
Support Data Requirements Dynamic Other
Good documentation
WIS)Minimal
no (generally use average
data over some specified
interval)
We (mcdep) are set up to
run with this method.
models Minimal no No seasonality (annual only)
Incomplete documentation
on model use.Moderate
pseudo-dynamic (no
baseflow conditions
modeled)
Limited (excellent manual)Moderate Dynamic BMP's
Active List Server. USEPA
Tech Support.Very Data Intensive Fully Dynamic
The basins suite has been
developed specifically for
the TMDL process
Active List Server. Support
generally through GUI
provider.Very Data Intensive Fully Dynamic
The transport block (water
quality) of SWMM is being
"phased out" of use in favor
of coupling with other
models
Note: According to Huber (1999), likage of SWMM to BASINS platform is currently underway
Note: P8 not able to handle coliforms "out of the box"
References Used in the preparation of this table
HDR Inc., 1992, Evaluation of Storm Water Computer Models, report prepared for the City of Minneapolis, MN.
CH2MHill, 2000, Development and Implementation of a Water Quality Model for the McDowell and Torrence Creek Watersheds. A proposal submitted to the
Mecklenburg County Department of Environmental Protection on January 28, 2000. CH2MHill, Charlotte, NC.
CDM, 2000, Water Quality Model for the McDowell and Torrence Creek Watersheds. A proposal submitted to the Mecklenburg County Department of
Environmental Protection on January 29, 2000. CDM, Charlotte, NC.
Note: If we decide to model sewer overflows as individual point sources, a dynamic model will be required that allows for the inclusion of point
sources will need to be used (rules out simple models).
Shoemaker, L., M. Lahlou, M. Bryer, D. Kumar and K. Kratt, 1997, Compendium of Tools for Watershed Assessment and TMDL Development. EPA841-B-97-
006. U.S. Environmental Protection Agency, Washington, D.C.
Donigian, A.S. Jr. and W.C. Huber, 1991, Modeling of Nonpoint Source Water Quality in Urban and Non-urban Areas. EPA/600-3-91-039. U.S. Environmental
Protection Agency, Athens, GA.
Schueler, T.R., 1987, Controlling Urban Runoff: A Practical Manual for Planning and Designing BMPs. Metropolitan Information Center, Metropolitan Washington,
Council of Governments, Washington, D.C.
Huber, W.C., 1999, SWMM and the TMDL Process. In: SWMM and HSPF Water Quality Modeling Workshop Course Handout, Athens, GA, December 6-10,
1999.
Appendix 8 page A8-2
Appendix 9. Public Notice
Michael F. Easley
Governor
Sherri Evans-Stanton, Acting Secretary
North Carolina Department of Environment and Natural Resources
Kerr T. Stevens, Director
Division of Water Quality
N. C. Division of Water Quality 1617 Mail Service Center Raleigh, NC 27699-1617 [phone] Customer Service
1 800 623-7748
Irwin, Little Sugar, Sugar, and McAlpine Creeks, Catawba River Basin
Now Available Upon Request
Copies of the draft TMDL study:
Irwin, Little Sugar, Sugar, and McAlpine Creeks (in Subbasin 030834)
Fecal Coliform Total Maximum Daily Load
Are now available upon request from the North Carolina Division of Water Quality. This TMDL study
was prepared as a requirement of the Federal Water Pollution Control Act, Section 303(d). The study
identifies the sources of pollution, determines allowable loads to the surface waters, and suggests
allocations for pollutants of concern.
TO OBTAIN A FREE COPY OF THE TMDL REPORT:
Please contact Ms. Jamie Smith [phone], extension 558 or write to:
Ms. Michelle Woolfolk
TMDL Coordinator
Water Quality Planning Branch
NC Division of Water Quality
1617 Mail Service Center
Raleigh, NC 27699-1617
Interested parties are invited to comment on the draft TMDL study by May 31, 2001. Comments and
questions concerning the report should be directed to Ms. Michelle Woolfolk at the above number
(extension 505) and address. The draft TMDL is also located on the following website:
http://h2o.enr.state.nc.us/tmdl