Calibration logs analysis
Trent Biggs
2023-05-19
This document analyses the calibration logs for 4 manta sondes owned by SDSU, calibration dates 2019-2022. 5259: IBWC sonde 3594: Mission Trails 4105: Tijuana Estuary Boca Rio 4104: Backup / lab sonde
TRYP
100ppb TRYP
4105 (main Boca Rio sonde) quite stable. 4104 (spare), stable except for one low value 5259 (IBWC) had high initial values, settled down to typical values by 2023. 3594 (main Mission Trails sonde) less stable.
## [1] "Mean TRYP RV for 100ppb, sonde 3594, pre-2021: 0.017"## [1] "Mean TRYP RV for 100ppb, sonde 3594, post-2021, exclude values > 0.03 RV: 0.012"## [1] "Mean TRYP RV for 100ppb, sonde 4105, exclude 1st value: 0.016"Individual values for TRYP = 100ppb shows that the most “reasonable” value isn’t always that last one in the series. Sorted by sonde, then by date:
## sonde Date rv new done
## 9 5259 2022-10-20 0.1034178000 100
## 20 5259 2022-11-30 0.0831853200 100 Done
## 24 5259 2023-02-08 0.0161975900 100 Done/Quit
## 25 5259 2023-02-08 0.0150429000 100
## 29 5259 2023-05-05 0.0198644400 100
## 30 5259 2023-05-05 0.0194582700 100
## 17 3594 2019-05-02 0.0214440800 100 Done
## 251 3594 2019-06-22 0.0115062300 100 Done
## 43 3594 2019-08-11 0.0140327800 100 Done
## 58 3594 2019-10-08 0.0049992800 100 Done
## 61 3594 2019-11-06 0.0153232800 100 Done
## 62 3594 2019-11-06 0.0216493600 100 Done
## 63 3594 2019-11-06 0.0231388800 100
## 78 3594 2020-01-08 0.0308699900 100
## 80 3594 2020-01-08 0.0270272800 100 Done
## 95 3594 2020-02-21 0.0130414400 100
## 102 3594 2020-03-08 0.0161750600 100 Done
## 104 3594 2020-09-28 0.0125657900 100 Done
## 115 3594 2020-11-05 0.0122353500 100
## 126 3594 2020-12-03 0.0173842000 100
## 150 3594 2021-10-15 0.0182835500 100 Quit
## 151 3594 2021-10-15 0.0216424800 100 Quit
## 152 3594 2021-10-15 0.0487436100 100
## 159 3594 2022-01-21 0.0051945450 100 Done
## 177 3594 2022-07-18 0.0086517340 100 Done
## 181 3594 2022-08-30 0.0092099910 100
## 183 3594 2022-08-30 0.0104016100 100
## 194 3594 2022-10-20 0.0543900200 100
## 195 3594 2022-10-20 0.0321811500 100
## 203 3594 2022-11-16 0.0079933410 100
## 211 3594 2022-11-30 0.0168584900 100
## 103 4105 2021-01-11 0.0369000000 100 Done
## 21 4105 2021-04-23 0.0160000000 100
## 27 4105 2021-07-30 0.0128000000 100 Done
## 28 4105 2021-07-30 0.0130000000 100 Quit
## 50 4105 2021-10-15 0.0148000000 100
## 52 4105 2021-12-21 0.0166000000 100 Done
## 621 4105 2022-01-21 0.0112000000 100 Done
## 791 4105 2022-08-30 0.0199000000 100
## 87 4105 2022-09-09 0.0159000000 100 Done
## 100 4105 2022-10-25 0.0183000000 100
## 107 4105 2022-11-16 0.0175000000 100
## 91 4104 2020-10-08 0.0161012100 100 Done
## 19 4104 2021-03-01 0.0154328100 100
## 271 4104 2021-04-23 0.0163227600 100 Quit
## 281 4104 2021-04-23 0.0164535700 100 Done
## 431 4104 2022-08-30 0.0205566300 100
## 521 4104 2022-10-07 0.0008686782 100 Done
## 69 4104 2023-01-19 0.0174505400 100
## 75 4104 2023-03-21 0.0142868800 100
## 85 4104 2023-05-04 0.0185351400 100
## 871 4104 2023-05-04 0.0210929800 100Sorted by date, then by sonde:
## sonde Date rv new done
## 17 3594 2019-05-02 0.0214440800 100 Done
## 251 3594 2019-06-22 0.0115062300 100 Done
## 43 3594 2019-08-11 0.0140327800 100 Done
## 58 3594 2019-10-08 0.0049992800 100 Done
## 61 3594 2019-11-06 0.0153232800 100 Done
## 62 3594 2019-11-06 0.0216493600 100 Done
## 63 3594 2019-11-06 0.0231388800 100
## 78 3594 2020-01-08 0.0308699900 100
## 80 3594 2020-01-08 0.0270272800 100 Done
## 95 3594 2020-02-21 0.0130414400 100
## 102 3594 2020-03-08 0.0161750600 100 Done
## 104 3594 2020-09-28 0.0125657900 100 Done
## 91 4104 2020-10-08 0.0161012100 100 Done
## 115 3594 2020-11-05 0.0122353500 100
## 126 3594 2020-12-03 0.0173842000 100
## 103 4105 2021-01-11 0.0369000000 100 Done
## 19 4104 2021-03-01 0.0154328100 100
## 21 4105 2021-04-23 0.0160000000 100
## 271 4104 2021-04-23 0.0163227600 100 Quit
## 281 4104 2021-04-23 0.0164535700 100 Done
## 27 4105 2021-07-30 0.0128000000 100 Done
## 28 4105 2021-07-30 0.0130000000 100 Quit
## 150 3594 2021-10-15 0.0182835500 100 Quit
## 151 3594 2021-10-15 0.0216424800 100 Quit
## 152 3594 2021-10-15 0.0487436100 100
## 50 4105 2021-10-15 0.0148000000 100
## 52 4105 2021-12-21 0.0166000000 100 Done
## 159 3594 2022-01-21 0.0051945450 100 Done
## 621 4105 2022-01-21 0.0112000000 100 Done
## 177 3594 2022-07-18 0.0086517340 100 Done
## 181 3594 2022-08-30 0.0092099910 100
## 183 3594 2022-08-30 0.0104016100 100
## 791 4105 2022-08-30 0.0199000000 100
## 431 4104 2022-08-30 0.0205566300 100
## 87 4105 2022-09-09 0.0159000000 100 Done
## 521 4104 2022-10-07 0.0008686782 100 Done
## 9 5259 2022-10-20 0.1034178000 100
## 194 3594 2022-10-20 0.0543900200 100
## 195 3594 2022-10-20 0.0321811500 100
## 100 4105 2022-10-25 0.0183000000 100
## 203 3594 2022-11-16 0.0079933410 100
## 107 4105 2022-11-16 0.0175000000 100
## 20 5259 2022-11-30 0.0831853200 100 Done
## 211 3594 2022-11-30 0.0168584900 100
## 69 4104 2023-01-19 0.0174505400 100
## 24 5259 2023-02-08 0.0161975900 100 Done/Quit
## 25 5259 2023-02-08 0.0150429000 100
## 75 4104 2023-03-21 0.0142868800 100
## 85 4104 2023-05-04 0.0185351400 100
## 871 4104 2023-05-04 0.0210929800 100
## 29 5259 2023-05-05 0.0198644400 100
## 30 5259 2023-05-05 0.0194582700 1000 ppb TRYP
TRYP RV time series for blank (0 ppb)
## sonde Date rv new done
## 10 5259 2022-10-20 0.003129244 0 Done
## 26 5259 2023-02-08 0.004701376 0 Done*
## 31 5259 2023-05-05 0.002559722 0 Done/Quit*
## 64 3594 2019-11-06 0.005418599 0 Done
## 79 3594 2020-01-08 0.011004930 0 Done
## 96 3594 2020-02-21 0.002327532 0 Done
## 116 3594 2020-11-05 0.002400130 0 Done
## 127 3594 2020-12-03 0.002679259 0 Done
## 148 3594 2021-10-15 0.027021650 0
## 149 3594 2021-10-15 0.006847412 0 Quit
## 153 3594 2021-10-15 0.003832698 0 Done
## 182 3594 2022-08-30 0.003014088 0 Done
## 184 3594 2022-08-30 0.002845109 0 Done
## 196 3594 2022-10-20 0.002957762 0 Done
## 204 3594 2022-11-16 0.002853871 0 Done
## 212 3594 2022-11-30 0.004642547 0 Done
## 22 4105 2021-04-23 0.004770000 0 Done
## 51 4105 2021-10-15 0.005690000 0 Done
## 801 4105 2022-08-30 0.005520000 0 Done
## 101 4105 2022-10-25 0.005330000 0 Done
## 108 4105 2022-11-16 0.005350000 0 Done
## 105 4104 2020-10-08 0.017409240 0
## 11 4104 2020-10-08 0.006003768 0 Quit
## 201 4104 2021-03-01 0.006312937 0 Done
## 44 4104 2022-08-30 0.005788476 0 Done
## 70 4104 2023-01-19 0.005108178 0 Done
## 76 4104 2023-03-21 0.005823523 0 Done
## 86 4104 2023-05-04 0.005640150 0 Done
## 88 4104 2023-05-04 0.005434245 0 Done## [1] "Mean TRYP RV 0ppb standard, 4105 sonde: 0.005332"## [1] "Mean TRYP RV 0ppb standard, 3594 sonde: 0.00361990972727273"CDOM
CDOM 300ppb
RV values are very erratic and unstable.
## [1] "Mean CDOM 300ppb std, RV sonde 3594 Pre 2020-06: 0.8866027125"## [1] "Mean CDOM 300ppb std, RV sonde 4105, exclude low outlier: 0.63475"CDOM 0 ppb
## [1] "Mean RV CDOM 0ppb standard, sonde 4105: 0.02515"## [1] "Mean RV CDOM 0ppb standard, sonde 3594: 0.088427946"Turbidity
Turbidity has used standards with different NTU/FNU over the project, so need to 1) plot RV vs standard value and 2) normalize RV by the NTU to compare across different standards.
4104 has low outliers at 1000ppb: 2023-04-13 (RV=0.1688 @ 1000 NTU, vs ~1.0 for all other 1000 NTU readings). * Recalibration of TURB for 4104 sonde is critical for dates after 2023-04-13.
##
## Call:
## lm(formula = rv ~ new, data = xcomb.TURB)
##
## Residuals:
## Min 1Q Median 3Q Max
## -1.01070 -0.02832 -0.02359 0.02715 0.71063
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 4.603e-02 2.548e-02 1.807 0.0736 .
## new 1.133e-03 6.647e-05 17.050 <2e-16 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.2243 on 108 degrees of freedom
## Multiple R-squared: 0.7291, Adjusted R-squared: 0.7266
## F-statistic: 290.7 on 1 and 108 DF, p-value: < 2.2e-16
##
## Call:
## lm(formula = new ~ rv, data = xcomb.TURB)
##
## Residuals:
## Min 1Q Median 3Q Max
## -434.91 -42.33 -39.29 -1.53 864.64
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 26.85 19.31 1.39 0.167
## rv 643.33 37.73 17.05 <2e-16 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 169 on 108 degrees of freedom
## Multiple R-squared: 0.7291, Adjusted R-squared: 0.7266
## F-statistic: 290.7 on 1 and 108 DF, p-value: < 2.2e-16