bcgov / wqg_data

Refining the WQG list
GNU General Public License v3.0
3 stars 3 forks source link

The following variables are currently coded as the mean of 1 sample in 1 day #39

Closed joethorley closed 4 years ago

joethorley commented 4 years ago
# A tibble: 46 x 3
   Variable                                EMS_Code Use                     
   <chr>                                   <chr>    <chr>                   
 1 Chloride Dissolved                      EMS_1104 Drinking Water - Aesthe…
 2 Chlorophenol, 2,3,4,6-TTCP              EMS_T037 Drinking Water - Aesthe…
 3 Chlorophenol, 2,4-DCP                   EMS_D050 Drinking Water - Aesthe…
 4 Chlorophenol, 2,4,6-TCP                 EMS_T042 Drinking Water - Aesthe…
 5 Chlorophenol, DCP Total                 EMS_D060 Drinking Water - Aesthe…
 6 Chlorophenol, DCP Total                 EMS_D060 Recreation - Swimming   
 7 Chlorophenol, MCP                       EMS_M050 Drinking Water - Aesthe…
 8 Chlorophenol, MCP                       EMS_M050 Recreation - Swimming   
 9 Chlorophenol, PCP                       EMS_P022 Drinking Water - Aesthe…
10 Chlorophenol, PCP                       EMS_P022 Recreation - Swimming   
11 Chlorophenol, TCP Total                 EMS_T021 Drinking Water - Aesthe…
12 Chlorophenol, TCP Total                 EMS_T021 Recreation - Swimming   
13 Chlorophenol, TTCP Total                EMS_T020 Drinking Water - Aesthe…
14 Chlorophenol, TTCP Total                EMS_T020 Recreation - Swimming   
15 Chlorophyll a                           EMS_0143 Recreation - Swimming   
16 Copper Total                            EMS_CU-T Drinking Water - Aesthe…
17 Cyanobacteria Total                     NA       Recreation - Swimming   
18 Cyanobacterial toxins: Microcystins To… NA       Recreation - Swimming   
19 Ethylbenzene                            EMS_B021 Drinking Water - Aesthe…
20 Iron Total                              EMS_FE-T Drinking Water - Aesthe…
21 Manganese Total                         EMS_MN-T Drinking Water - Aesthe…
22 Methyl tertiary-butyl ether Total       EMS_MTBE Drinking Water - Aesthe…
23 Nitrate Total                           EMS_0110 Recreation - Swimming   
24 Nitrate Total                           EMS_0110 Recreation - Swimming   
25 Nitrate Total                           EMS_1110 Recreation - Swimming   
26 Nitrate Total                           EMS_1110 Recreation - Swimming   
27 Nitrite Total                           EMS_0111 Recreation - Swimming   
28 Nitrite Total                           EMS_0111 Recreation - Swimming   
29 Nitrite Total                           EMS_1111 Recreation - Swimming   
30 Nitrite Total                           EMS_1111 Recreation - Swimming   
31 Phosphorus Total                        EMS_P--T Drinking Water - Aesthe…
32 Phosphorus Total                        EMS_P--T Recreation - Swimming   
33 Sulphate Total                          EMS_0121 Drinking Water - Aesthe…
34 Temperature                             EMS_0013 Drinking Water - Aesthe…
35 Temperature                             EMS_0013 Recreation - Swimming   
36 Temperature                             EMS_TEMF Drinking Water - Aesthe…
37 Temperature                             EMS_TEMF Recreation - Swimming   
38 Toluene Total                           EMS_T001 Drinking Water - Aesthe…
39 Turbidity                               EMS_0015 Drinking Water          
40 Turbidity                               EMS_0015 Drinking Water          
41 Turbidity                               EMS_0015 Drinking Water          
42 Turbidity                               EMS_TURF Drinking Water          
43 Turbidity                               EMS_TURF Drinking Water          
44 Turbidity                               EMS_TURF Drinking Water          
45 Xylenes Total                           EMS_X006 Drinking Water - Aesthe…
46 Zinc Total                              EMS_ZN-T Drinking Water - Aesthe…

@HeatherGranger Can you confirm that the following variables are based on the mean of 1 sample in 1 day (it seems wrong)

HeatherGranger commented 4 years ago

This is correct. As these guidelines are not based on human toxicological information they're not called a maximum acceptable concentration, however it may make more sense to have them as a 'Max' because 'Mean' doesn't really make sense for the 1 sample in 1 day that's taken.

Either way, temperature and turbidity are narrative guidelines, so having a 'Mean' or 'Max' doesn't make for those parameters.

joethorley commented 4 years ago

I'm going to set the Statistic to be maximum in case someone takes multiple samples.