Jun 24 2008
Data Analysis, Limitations & Implications - BLOG Assignment #5
Data Analysis
Water quality samples and associated data were collected on June 7, 8, and 15th, 2008. The UV index was 9, 8, and 8 on these days respectively. General weather conditions were similar, but not identical, for each of the sampling events. The weather was characterized by (a) bright sun in the morning followed by increasing clouds in the afternoon, (b) wind generally out of the southwest, and (c) above average air temperature for this time of year, resulting in many swimmers. Detailed observations and measurements are provided in our formal report; This Blog entry presents a summary of our results.
The attempt to use Solar Print Paper to quantify the ultraviolet radiation was not successful. The paper goes to dark blue with any sun exposure i.e. it does not have shades of blue which could be used to quantify the amount of ultraviolet radiation.
Raw bacterial counts (#) were converted to concentration (# per 100 ml ) by the following formula:
Concentration (#/100ml) = (raw count (#) x 100 ml) / volume of sample plated (ml)
The volume of sample plated ranged from 2.61 +/- 0.03 ml on June 7th & 8th to 2.42 +/‑ 0.02 ml on June 15th. The change in volume plated was due to a change in pipette type. The volume of each pipette was measured by delivering an aliquot of distilled water onto a digital balance and recording mass. The mass was converted to volume by assuming that the density of the distilled water was 1.0 g. per ml. Results were measured in triplicate to assess repeatability of the volume delivered by each pipette.
We chose to focus on fecal coliform levels rather than total coliform levels because we believe fecal coliform is a better indicator of water contamination. As noted by Microbiology Labs, LLC., “Non-fecal coliforms are widely distributed in nature, being found both as naturally-occurring soil organisms and in the intestines of warm-blooded animals and humans…..Fecal coliform…is the result of some form of fecal contamination. Sources may be either animal or human.”
Statistical Significance of Variation
Three samples were taken at each location with one plate prepared for each sample. The data in Table 1 is the bacterial count average for the three plates from each sample location.
Table 1: Summary of Mean Fecal Coliform Concentrations (#/100 ml)
by sampling location and time
|
|
Jun-7 AM |
Jun-7 PM |
Jun-8 AM |
Jun-8 PM |
Jun-15 AM |
Jun-15 PM |
|
Location1 |
13 |
167 |
103 |
13 |
97 |
83 |
|
Location2 |
51 |
410 |
26 |
77 |
14 |
83 |
|
Location3 |
13 |
64 |
0 |
385 |
0 |
0 |
Taking multiple samples allowed us to estimate the variability involved in sampling and testing. The pooled standard deviation across the eighteen unique combinations of sample day and sample location was 58.3 colonies/100 ml. Based on a sample size of 3, a 95% confidence interval around the mean bacterial count is +/- 67.4 colonies/100 ml. The nature and scope of this project did not allow us to separate the variability into sampling component and testing components. Note that the only statistically significant differences between the a.m. and p.m. samples at a specific location were Locations 1 and 2 on Day 1 and Location 3 on Day 2. The other differences between the a.m. and p.m. samples on a given day at a given location are within the sampling and testing variability.
Diurnal Variations in Water Quality
The first element of our research question was “How does water quality as indicated by bacterial count vary over the course of the day?” Contrary to our expectations based on our hypothesis about UV exposure, the data indicated that bacterial counts were generally higher at 2pm than at 9am. Figure 1 presents the average of 9 bacterial level measurements for each sampling event as a summary of diurnal variation.

Figure 1
Correlations between bacterial concentration and other variables
The second element of our research question was “Can diurnal variations in bacteria concentration be correlated with other variables?” In order to explore this question, we measured algae level, water current direction and velocity, water temperature, pH, conductivity, turbidity, and dissolved oxygen at each sample location. Dissolved oxygen (DO) was measured on the first two sampling days, but was not recorded on the third sampling day to due anomalies in measured values. We recorded overall UV index, cloud cover, air temperature, river plume direction, wind direction, and wind speed at the time of sampling. General observations such as beach conditions and a qualitative assessment of the number of people using the beach were also made.
Algae level and water current data and observations were analyzed for each sample location on each day. The observations for each day are summarized and compared graphically to fecal coliform data in our formal report.
Algae Level
Algae concentrations were observed at regular intervals from the shoreline to the point at which the samples were taken. The intervals included 0 to 3 feet, 3 to 6 feet, and 6 feet from the shoreline to the sampling location. The sampling location was approximately 20 to 30 feet from shore, depending on the water depth. Specific observations were recorded using descriptors such as, clear, “floating tufts”, cloudy, pea soup.
The algae level varied significantly between sampling locations. The west end of the beach typically contained the lowest algae levels, and the east end of the beach typically contained the highest. This was expected because of the location of the pier on the east end. Algae levels also varied with distance from shore, with generally higher concentrations closer to the shore. No significant correlation was observed between fecal coliform concentration and local algae level.
Water Current Velocity and Direction
Wind has the biggest impact on surface water currents. Wind direction is recorded in degrees relative to true North. The beach runs from NW to SE with the western end at approximately 315 degrees and the eastern end at 135 degrees relative to true north. The wind direction ranged from 210 degrees to 270 degrees during the sampling periods for this study. The wind speed is reported by the weather station in meters/second (m/s) and was corrected to miles/hour (mph) by multiplying raw data by 2.236. The wind speeds ranged from 2.2 mph to 21.3 mph during sampling periods.
We observed that water current patterns were quite complicated. Our protocol involved measuring water current and direction at each sampling location. We collected a single point sample, but observed complex patterns around the sampling location. On the morning of Day 1, the current at all three locations showed a general flow away from the beach but by the afternoon sampling the wind had shifted 20 degrees to the north and increased in speed which resulted in a general flow into the swimming area and fecal coliform levels showed a statistically significant increase at Locations 1 and 2. Location 3 did not show a significant increase but the mean did increase slightly.
On the morning of Day 2, the wind was almost directly perpendicular to the shoreline and from the beach. Current observations indicated a general outflow from the swimming area. By the afternoon, the wind had shifted 60 degrees toward true north resulting, once again, in a flow toward the eastern end of the beach and statistically higher fecal coliform levels in Location 3.
On Day 3, the wind shifted 10 degrees away from true north between the morning and afternoon sample, which prolonged the general outflow observed in the morning. During the afternoon sampling period, the wind speed dropped considerably. The differences at each location between morning and afternoon bacterial levels were not statistically significant on Day 3.
On Day 3 at Location 3, the wind direction was affected more by the river gorge than the prevailing winds. We noted that the flag at both the Coast Guard Station and the Rochester Yacht Club were aligned parallel to the river; a different position than of the flag near the beach house which reflected the prevailing wind. We believe that wind direction affected by the river gorge affected the surface current at Location 3 and caused more outward flow from the area keeping bacteria levels low relative to other sampling days.
We also noted that waves bouncing back from the pier frequently were perpendicular to the incoming waves from the general surface current. There were some areas along the beach where the waves combined to create relatively stagnant areas; at these locations, cross currents caused broken shells to build up at the edge of the water at regular intervals along the beach.
Improvements in measurement techniques along with more detailed observations may reveal a stronger correlation between bacterial level and water current velocity/direction.
Water Temperature
Water temperature ranged from 13.0 to 19.8 deg C between June 7th and June 15th, following a generally upward trend. No significant correlation between water temperature and bacterial concentration was observed.
pH
pH ranged from 8.1 to 8.8 between June 7th and June 15th, following a generally upward trend. No significant correlation between pH and bacterial concentration was observed.
Conductivity
Conductivity ranged from 108 to 195 microsiemens per centimeter, in what appeared to be a random pattern. No significant correlation between conductivity and bacterial concentration was observed.
Dissolved Oxygen
As described previously, difficulties were encountered in the dissolved oxygen (DO) calibration process. We do not have a high level of confidence in the validity of our dissolved oxygen measurements. For this reason we discontinued DO measurements after the second sample day, and suggest calibration procedure improvements as a follow-up to this research.
UV index
The UV index ranged from a value of 9 on June 7th to a value of 8 on June 8th and 15th. Unfortunately there was insufficient variation in the UV index to draw conclusions about the effect of UV index on water quality. UV index can be considered a relatively consistent factor during data collection for this study.
Cloud Cover
The average cloud cover was 33% on June 7th, 56% on June 8th, and 53% on June 15th. This variable was generally correlated with UV index, but a relationship between cloud cover and bacterial level could not be established.
Air Temperature
Air temperature ranged from 21.5 deg C on June 15th to 31.3 deg C on June 8th. A relationship between air temperature and bacterial level could not be established.
River Plume Direction
The river plume direction was toward the east on June 7th and 8th, and toward the west on June 15th. A relationship between river plume direction and bacterial level could not be established.
Beach Conditions and Number of People using Beach
Although we did not assess beach conditions or number of people using the beach quantitatively, we observed a qualitative correlation between the number of people using the beach and the overall beach conditions. The highest number of beach users was observed the afternoon of June 7th, and the lowest number was observed during the afternoon of June 15th. Very few people were present at 9am on any of the sampling days. Perhaps not surprisingly, the beach conditions deteriorated as the number of people increased. For example, more trash and dirty diapers were observed on June 7th, the day that we observed the largest number of people.
Similarly, the increase in bacteria concentration between 9am and 2pm was highest on June 7th and lowest on June 15th. Figure 2 shows the relationship between the percent difference in afternoon vs. morning bacterial level and the relative number of people present on the beach. The R2 value of 0.96 indicates a strong direct correlation between these two variables.
Figure 2
Limitations
This study was limited, due to laboratory availability, to weekend days when the beach population was high. Sampling on a day with no or few swimmers would have allowed us to measure the diurnal variation without having the data confounded by population of swimmers. There were other single effects that could not be evaluated due to the many variables that could only be observed. The weather was fairly consistent on the sampling days; more variability in wind direction would have resulted in more variation in water currents. Water current observations improved as we learned how to more critically evaluate the surface and wave patterns and better procedures and equipment could be used for follow up studies.
In addition, the algae observations were made in a relatively small area. A more detailed map of the algae distribution in the swimming area might have shown a correlation between the bacteria levels and algae concentrations.
Lastly, the length of the study was confined into two weeks in the beginning of June. The results would have more credibility with more sampling days over a longer period of time. Extending the time period of the study would encompass more varied weather conditions and different people populations.
Model Revisited
Our original model predicted that fecal coliform counts would change over the course of the day due to three factors: UV radiation, algae mass, and nearshore water currents. We expected to find a correlation between one or more of these factors and fecal coliform counts in our samples.
We predicted that UV radiation would kill off bacteria near the water’s surface because of its ability to disinfect water. If this effect were significant, we expected that our morning samples would have the highest counts. Our results, however, did not show this effect. Even though we had relatively sunny weather on all three sampling days, our results showed that fecal coliform levels in morning samples were either the same or lower than those in the afternoon. These results suggest that UV radiation does not significantly impact fecal coliform counts over the course of the day as compared to other factors.
Although we expected to see a correlation between fecal coliform level and algae mass, our data showed no correlation. This may have resulted from the fact that our observations of algae were limited to a relatively small area near the sample collection site. A more detailed study over a longer period of time and covering a larger section of the beach may yield more conclusive results regarding the impact of algae on bacterial counts.
Nearshore water currents were also observed and current at the sampling site was measured where possible. The data suggests that surface water currents, as influenced by wind speed and direction, affect fecal coliform levels by either scouring the beach during outflow conditions or building up levels during inflow conditions. While sample Location 3 tended to have the most algae, as predicted because of proximity to the pier and an inability for current to clear it out, it was not the location with the highest fecal coliform count during this sampling period.
One factor not included in our original model, was the number of people on the beach and in the water. Due to the warm weather during the sampling period, the beach was crowded during the afternoon sampling time, while it was nearly empty during the morning sampling time. We estimated the relative levels of people qualitatively for each sampling day. The difference in fecal coliform levels between the a.m. and p.m. correlated most closely with the qualitative estimate of the number of people at the beach. It is not clear from our data why this might this might occur. We speculate that the activity of people near and in the water brings in contaminated sand and stirs up sediments from the bottom of the swimming area. Figure 3 shows our revised model to include these two new related factors. Although, as suggested above, our data provides some evidence to support this revised model, we recommend that these factors be further studied to determine causal effects.

Figure 3: Revised Model
Implications
Monroe County personnel take water samples for bacteria testing in the morning. This does not appear to reflect the actual bacteria conditions during peak swimming time. There are at least two possible mechanisms related to swimmers that could cause an increase in the bacteria levels in the afternoon: (a) the swimmers stir up bottom sediment, which may contain bacteria and (b) swimmers are tracking the sand from the beach into the water. Team Flagella has found that there are high bacteria levels in the sand. If increased bacteria levels are due to contaminated sand, the impact on water quality of run-off from the proposed beach spray park should be evaluated prior to construction.
Our study shows that local, surface water currents as affected by wind direction can impact bacteria levels at various locations in the nearshore area. Wind direction and speed could be added to the predictive model to improve accuracy although this is already included indirectly by evaluating the direction of the river plume.










