Municipal Hotspot Summary

1. Summary

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

2. Assemble Data

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

## Loading wq database: \\psf\Home\Dropbox\MysticDB\MysticDB_20150519.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 in left_join_impl(x, y, by$x, by$y): joining factors with different
## levels, coercing to character vector

5. Table