Parent Pages
Sibling Pages
Child Pages
For you data hounds, we have the City's fecal data on Princeton Creek going back to July, 1995. The whole set is reproduced below.
To graph these, we had to do some simplifying: The zero values will not plot on a log scale (and they won't submit to a geometric mean), so we replaced all the zeros and missing data with ones. When a fecal count goes off the top they report it as Too Numerous To Count (TNTC). Depending on the dilutions they are running, that could be >1,600, >16,000, or >160,000. The City reports a few data in the tens of thousands, so we expect they are running the dilution that would expand the scale to 160,000. Not being sure, we compromised and replaced all the TNTC's with 16,000. Finally, where there were several data points in a month, we averaged them (geometric mean). The result ("Pope" represents the southside pipe under Crestwood Road (left pipe in the photo); "Crestwood" is the Northside pipe):
This appears to show an annual cycle with a cold-weather minimum and a warm-weather maximum. It also looks like things got better in '96 (the sewer lining, perhaps) and have deteriorated since.
If you want to draw your own conclusions here are the data, transcribed from the City's reports:
Date
Pope
Crestwood
7/31/95
TNTC
TNTC
8/28/95
TNTC
TNTC
9/13/95
TNTC
TNTC
10/18/95
0
27
10/25/95
TNTC
85
10/27/95
TNTC
TNTC
10/31/95
TNTC
TNTC
11/2/95
TNTC
TNTC
11/7/95
TNTC
TNTC
11/15/95
3300
1700
11/27/95
TNTC
42
11/30/95
TNTC
195
12/18/95
4300
700
1/2/96
13800
800
1/4/96
1200
100
1/16/96
1800
100
1/18/06
200
0
1/22/06
900
1100
1/30/96
150
16
1/30/96
0
0
2/5/96
2
0
2/12/97
77
0
2/13/96
0
0
2/16/96
3500
400
2/20/97
2900
2100
2/27/96
400
800
2/29/96
0
1000
3/6/96
0
3200
3/12/96
0
300
3/14/96
0
200
3/19/96
11300
13600
3/22/96
3700
100
3/27/97
3900
2100
3/29/96
TNTC
300
4/2/96
3900
100
4/4/96
2100
1000
4/9/96
4300
800
4/11/96
20
120
4/16/96
6300
2500
4/18/96
3900
100
4/23/96
TNTC
0
4/26/96
6100
0
4/30/96
106
93
5/3/96
25
4
5/7/96
38
26
5/9/96
240
30
5/14/96
100
40
5/17/96
5500
4320
5/21/96
690
0
5/23/96
250
180
5/28/96
430
TNTC
5/30/96
TNTC
TNTC
6/5/96
TNTC
6/7/96
TNTC
6/20/96
TNTC
380
6/25/96
670
TNTC
6/28/96
TNTC
TNTC
7/2/96
TNTC
TNTC
7/9/96
560
60
7/12/96
TNTC
170
7/17/96
30
40
7/19/96
510
190
7/23/96
230
10
7/25/96
620
170
7/30/96
TNTC
350
8/1/96
TNTC
70
8/6/96
720
280
8/9/96
TNTC
0
8/13/96
TNTC
120
8/15/96
400
50
8/19/96
560
170
8/23/96
980
TNTC
8/26/96
TNTC
780
8/28/98
880
780
9/5/96
TNTC
TNTC
9/9/96
TNTC
780
9/11/96
470
30
9/16/96
380
40
9/18/96
230
0
9/23/96
730
520
9/24/96
1040
20
9/25/96
650
250
9/30/96
240
70
10/2/96
170
110
10/7/96
TNTC
100
10/9/96
540
300
10/16/96
20
170
10/18/96
120
200
10/21/96
480
360
10/23/96
60
50
10/28/96
760
650
10/30/96
160
750
11/4/96
630
370
11/6/96
450
440
11/12/96
190
310
11/14/96
240
130
11/19/96
TNTC
11/19/96
140
280
11/21/96
480
110
11/25/96
250
730
11/27/96
370
620
12/3/96
0
10
12/5/96
740
590
12/10/96
10
20
12/12/96
330
30
12/17/96
430
60
12/19/96
TNTC
TNTC
1/7/97
370
70
1/9/97
TNTC
TNTC
1/16/97
380
260
1/21/97
170
280
1/24/97
550
1800
1/30/97
70
20
1/31/97
300
10
2/4/97
310
870
2/27/97
220
30
3/28/97
70
0
4/21/97
2500
0
5/21/97
5
0
6/4/97
0
635
7/2/97
0
390
7/17/97
515
40
8/6/97
3800
110
9/3/97
1365
6000
10/1/97
7800
12000
11/7/97
60000
100000
12/3/97
407
17
1/7/98
12750
36300
1/7/98
3750
9300
1/29/98
640
1365
2/4/98
618
0
3/4/98
700
0
4/1/98
1250
0
5/6/98
840
30
6/5/98
620
783
7/1/98
845
155
8/5/98
615
510
9/2/98
8100
8150
10/1/98
15950
2040
11/4/98
22800
7800
12/2/98
11000
21000
Last updated 02/24/02
Please send questions or comments to John Butcher