Municipal Hotspot Summary

1. Summary

This document summarizes historical hotspot data collected by MyRWA at storm water outfalls and other locations in Stoneham, MA.

2. Assemble Data

First, load water quality data, narrow to municipality, and summarize bacteria results.

## Loading wq database: \\psf\Home\Dropbox\MysticDB\MysticDB_20150423.accdb
## Fetching tables...done
## Merging tables...done
## Excluding field blanks, duplicates...done
## Excluding flagged results...done

## Loading precip file: \\psf\Home\Dropbox\MysticDB\Processed\Precip\LoganPrecip.xlsx

## Computing antecedent precip...done
## Computing DateHour column in wq dataframe...done
## Merging wq and precip...done

3. Barplots

3. Boxplots

## Joining by: "CharacteristicID"

## Warning: joining factors with different levels, coercing to character
## vector

5. Table