Historical False Bay watershed water quality analysis

We will explore historical water wuality data collected around the False Bay watershed on San Juan Island. Most data will come diretly from the False Bay watershed, however, some data sets include samples from other adjacnet watersheds.

Data

Read in data water quality data from UW/Friday Harbor Labs monitoring effort

Data checking and adjustment

## 'data.frame':    923 obs. of  16 variables:
##  $ Date                : chr  "3/27/2002" "3/27/2002" "3/27/2002" "5/1/2002" ...
##  $ Watershed           : chr  "Beaverton Valley" "Beaverton Valley" "Beaverton Valley" "Beaverton Valley" ...
##  $ site_no             : chr  "BV3" "BV3" "BV3" "BV3" ...
##  $ Replicate           : int  1 2 3 1 2 3 1 2 3 1 ...
##  $ Air_temp_C          : num  8.4 NA NA 12.9 NA NA NA NA NA 25.5 ...
##  $ Water_temp_C        : num  7.2 7.2 7.2 11.7 11.7 11.7 13.7 13.2 13.6 13.8 ...
##  $ DO_.mg.L            : num  14.1 NA NA 7.9 NA NA 11.6 NA NA 8.8 ...
##  $ pH                  : num  7.28 7.31 7.3 7.61 7.63 7.61 7.89 7.92 7.93 7.96 ...
##  $ Turbidity_ntu       : num  2.37 1.7 1.85 4.7 3.67 3.68 9.45 9.98 11.9 19.2 ...
##  $ Sample_vol_ml       : int  100 100 100 200 200 200 200 200 200 50 ...
##  $ F_coliform_col.100mL: num  0 5 4 5 1.5 2.5 1 6 8 20 ...
##  $ Flow_cfs            : num  10.87 NA NA 7.25 NA ...
##  $ Water_condition     : chr  "" "" "" "" ...
##  $ Nitrate_mg.L        : num  NA NA NA NA NA NA NA NA NA NA ...
##  $ Phosphate_mg.L      : num  NA NA NA NA NA NA NA NA NA NA ...
##  $ Notes               : chr  "" "" "" "" ...

Data summaries

Seperate sampling instances that has a no measuremnts (no water to measure), single measurments (e.g. air temp was only measured once), and multiple measures (e.g. DO was measured three times per sampling instance).

I will also convert mg/L to umol/L 1 μg NO3/l = 1/ MW NO3 μg/l = 0.016128 μmol NO3/l, where 1mg = 1000ug and 1 μg PO4/l = 1/MW PO4 μg = 0.010529 μmol PO4/l

Map

Plots

Air temperature

Water Nutrients

Water properties