E. Gage
Updated: 2020-February-19, 14:59:31

Manual water table measurements

Tynan’s notes

Logger data

Notes from Tynan on hang lengths

The following lengths measure from the hole at the bottom of the sensor to the top of the knotted loop from which they were hung:

Well 1 / Logger 1 = ~96 cm

This one had two loops tied in the string—I’m fairly certain I always replaced the logger using the upper-most (longer) loop. At least, whenever I noted this one way or another, I always said I replaced it using that longer loop. If there is a discrepancy, this may be cause by me replacing the logger using the lower (shorter) loop. That loop has a hang of ~86 cm.

Well 2 / Logger 2 = ~101 cm

Well 4 / Logger 3 = ~119 cm

Level Depth calculation

Depth is the amount of water over the pressure sensor plus barometric pressure. Water level can be calculated in meters using the following equation:

D = (0.703073 X (Pm-Bm)) D = Depth in meters Pm = Total Pressure measured in PSI Bm = Barometric Pressure measured at the time Pm was taken in PSI

Conversions: Barometric unit = Water column equivalent (ft) = Water column equivalent (m)

1 psi = 2.30666 ft = 0.703073 m

1 kPa = 0.334553 ft = 0.101972 m

1 mbar = 0.0334553 ft = 0.0101972 m

Exported both the well logger data and barometric files to csv. Ensured files use the same units. If data was recorded in m, cm, or ft, converted the barometric data column from its barometric measurement units (psi) to feet or meters of water column equivalent using the conversion factors below.

Once the units for each column are the same, subtract the barometric column from the Levelogger data to get the true net water level recorded by the logger.

All depth measurements were recorded prior to removing the loggers and bailing the wells. Loggers were out of the water for instalation/maintenance/download:

July 2016

*Crowberry # 1 449878 (Well 1) out of well from 10:40 7/7/16 to 9:33 7/8/16

*Crowberry # 2 449874 (Well 2) out of well from 10:56 7/7/16 to 9:53 7/8/16

*Crowberry # 3 449921 (Well 4) out of well from 11:06 7/7/16 to 10:42 7/8/16

*Crowberry Baro 448880 (near well 5) out of tube from 11:15 7/7/16 to 10:49 7/8/16

September 2016

Crowberry # 1

449878 (Well 1) out of well from 13:40 9/20 to 10:05 9/21

*Crowberry

*449874 (Well 2) out of well from 9/20 afternoon (forgot to record time) to 10:20 9/21

*Crowberry #3 449921 (Well 4) out of well from 9/20 afternoon (forgot to record time) to 10:43 9/21

*Crowberry Baro 448880 (near well 5) downloaded at 11:50 9/20/16 and reinstalled at 11:59

January 2016

*Crowberry # 1 449878 (Well 1) out of well from 13:22 1/17 to 10:20 1/18, then again from 13:10 to 13:13 on 1/18 while we resampled pH and EC.

*Crowberry # 2 449874 (Well 2) out of well from 13:48 1/17 to 10:30 1/18, then again from 13:18 to 13:20 on 1/18 while we resampled pH and EC.

*Crowberry # 3 449921 (Well 4) out of well from 14:30 1/17 to 10:49 1/18, then again from 13:25 to 13:28 on 1/18 while we resampled pH and EC.

*Crowberry Baro 448880 (near well 5) collected at 14:37 1/17 and reinstalled at 10:59

April 2017

July 2017

August 2017

April 2018

##  [1] "date"                   "wellNo"                 "pressure_psi_n"        
##  [4] "temperature_c_n"        "depth_ft_n"             "lag_qaqc_n"            
##  [7] "flag_psi_n"             "pressure_psi_mean"      "temperature_c_mean"    
## [10] "depth_ft_mean"          "lag_qaqc_mean"          "flag_psi_mean"         
## [13] "pressure_psi_baro_mean" "psi_cor"                "level_depth_cm"        
## [16] "month"                  "doy"                    "year"

Correction

update: bring in Tynan’s hang lengths and sub for the total depth as basis of correction

update 2020-02-14 10:16:49 MST:

Temporary adjustment of 20cm to accomadate bold height.

Update: “2020-02-15 10:21:33 MST”

Well 1 Stickup to Bolt hole = 54 cm

Well 2 = 34 cm

Well 4 = n/a (Joe’s note: “Someone had dug and pulled out the shallow well then reinserted it upside down. As such I did not measure stick up or bolt.”)

## Observations: 3,261
## Variables: 19
## $ date                    <date> 2016-04-18, 2016-04-18, 2016-04-18, 2016-0...
## $ wellNo                  <dbl> 1, 2, 4, 1, 2, 4, 1, 2, 4, 1, 2, 4, 1, 2, 4...
## $ pressure_psi_mean       <dbl> 15.25277, 15.30877, 15.73777, 15.20637, 15....
## $ temperature_c_mean      <dbl> 9.131000, 8.523000, 9.565462, 9.237000, 8.5...
## $ depth_ft_mean           <dbl> 35.21785, 35.34738, 36.33815, 35.11100, 35....
## $ pressure_psi_baro_mean  <dbl> 14.49767, 14.49767, 14.49767, 14.45183, 14....
## $ psi_cor                 <dbl> 0.7550957, 0.8110957, 1.2400957, 0.7545486,...
## $ level_depth_cm          <dbl> 53.08874, 57.02595, 87.18778, 53.05027, 56....
## $ month                   <dbl> 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4...
## $ doy                     <dbl> 109, 109, 109, 110, 110, 110, 111, 111, 111...
## $ year                    <dbl> 2016, 2016, 2016, 2016, 2016, 2016, 2016, 2...
## $ depth                   <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,...
## $ man_depth_to_water_cm   <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,...
## $ well_stickup_cm         <dbl> 62.3, 44.0, 29.2, 62.3, 44.0, 29.2, 62.3, 4...
## $ man_dtw_adj_cm          <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,...
## $ well_total_depth_cm     <dbl> 126, 130, 136, 126, 130, 136, 126, 130, 136...
## $ hang_cm                 <dbl> 96, 101, 119, 96, 101, 119, 96, 101, 119, 9...
## $ well_stickup_cm_20cm    <dbl> 42.3, 24.0, 9.2, 42.3, 24.0, 9.2, 42.3, 24....
## $ well_stickup_cm_bolt_v3 <dbl> 54, 34, 20, 54, 34, 20, 54, 34, 20, 54, 34,...

## # A tibble: 26 x 8
##    well_stickup_cm well_stickup_cm~ well_stickup_cm~ man_dtw_adj_cm
##              <dbl>            <dbl>            <dbl>          <dbl>
##  1            62.3             42.3               54            4.7
##  2            44               24                 34           27.7
##  3            29.2              9.2               20           14.8
##  4            59               39                 54            6  
##  5            41.8             21.8               34           29.7
##  6            29.8              9.8               20           11.5
##  7            61.9             41.9               54            4.8
##  8            42.8             22.8               34            9.8
##  9            21.1              1.1               20            0.5
## 10            60.1             40.1               54            0  
## # ... with 16 more rows, and 4 more variables: dtw_cor_cm_caseHt <dbl>,
## #   dtw_cor_cm_hangOnly <dbl>, dtw_cor_cm <dbl>, wellNo <chr>

Logger plots

Address logger spikes on days when wells were read manually

Mean monthky values

## up

pH

EC

I believe these are corrected values, but need to confirm.

Precip for graph

Comments

Could things really jump out. First the summer drought was much more significant in 2017 than 2016. Longer and deeper. The pH does not need to be corrected, but is really nice data, way to go Joe and Tynan. Well 8, the upland is a great baseline for inflowing water from the moraines, and clearly the lagg water is blend of water flowing from the peatland and from the upland. The only weirdo is well 4, which has the highest pH of any peat well. Need to think about that. But a pH of 4.4 is still fine for a bog. If you look at the piezo heads for wells 2, 3 and 4, during the dry period in 2017, you can see that the heads of all the piezo are above the well water level elevation, indicating upward flow which could account for the higher pH readings, and of course this trend is reversed farther to the left or earlier in the measurement period at least for 3, 4, 5, 6. At this period water level in the well and heads are equal indicating horizontal flow which is what we would expect in the rand.

The most acid water is at well 14 in, well you know where it is, that’s interesting.

Water levels in the forested sites on the peat body all have somewhat deeper water levels than well 4, so we should use 4 as the baseline to compare across sites.