Pathogen concentrations in raw water: Difference between revisions

Latest revision as of 13:49, 23 March 2020

This page is a knowledge crystal of subtype variable. The page identifier is Op_en7953
Moderator:Heta (see all)

Upload data {{#opasnet_base_link:Op_en7953}}

Question

What are typical concentrations of pathogens in raw water used for drinking water?

Answer

+ Show code - Hide code

library(OpasnetUtils)

objects.latest("Op_en7953", code_name = "variable")

oprint(RawConcentration)

Rationale

Raw water has been categorized based on its source and cleanliness:

Ground water - clean
- Clean groundwater
Groundwater - surface water contamination
- for ex. shore infiltration
Surface water - low contamination
- Relatively clean surface water
Surface water - medium contamination
- for ex. low waste water contamination
Surface water - high contamination
- for ex. waste water contamination

Data

The concentrations are based on experts' estimates on concentrations of different pathogens in different kinds of raw water sources and contamination situations. ^[1] ^[2] ^[3] ^[4]

Pathogen concentrations in raw water: Difference between revisions(microbes/l)
Obs	RawWaterClass	Pathogen	Unit	Result
1	Ground water - clean	campylobacter	microbes/l	0
2	Ground water - clean	E.coli O157:H7	microbes/l	0
3	Ground water - clean	rotavirus	microbes/l	0
4	Ground water - clean	norovirus	microbes/l	0
5	Ground water - clean	sapovirus	microbes/l	0
6	Ground water - clean	cryptosporidium	microbes/l	0
7	Ground water - clean	giardia	microbes/l	0
8	Ground water - surface water contamination	campylobacter	microbes/l	0
9	Ground water - surface water contamination	E.coli O157:H7	microbes/l	0
10	Ground water - surface water contamination	rotavirus	microbes/l	0
11	Ground water - surface water contamination	norovirus	microbes/l	0
12	Ground water - surface water contamination	sapovirus	microbes/l	0
13	Ground water - surface water contamination	cryptosporidium	microbes/l	0
14	Ground water - surface water contamination	giardia	microbes/l	0
15	Surface water - low contamination	campylobacter	microbes/l	1
16	Surface water - low contamination	E.coli O157:H7	microbes/l	1
17	Surface water - low contamination	rotavirus	microbes/l	0.1
18	Surface water - low contamination	norovirus	microbes/l	0.1
19	Surface water - low contamination	sapovirus	microbes/l	0.1
20	Surface water - low contamination	cryptosporidium	microbes/l	0.1
21	Surface water - low contamination	giardia	microbes/l	0.1
22	Surface water - medium contamination	campylobacter	microbes/l	50
23	Surface water - medium contamination	E.coli O157:H7	microbes/l	50
24	Surface water - medium contamination	rotavirus	microbes/l	1
25	Surface water - medium contamination	norovirus	microbes/l	1
26	Surface water - medium contamination	sapovirus	microbes/l	1
27	Surface water - medium contamination	cryptosporidium	microbes/l	10
28	Surface water - medium contamination	giardia	microbes/l	50
29	Surface water - high contamination	campylobacter	microbes/l	1000
30	Surface water - high contamination	E.coli O157:H7	microbes/l	1000
31	Surface water - high contamination	rotavirus	microbes/l	100
32	Surface water - high contamination	norovirus	microbes/l	100
33	Surface water - high contamination	sapovirus	microbes/l	100
34	Surface water - high contamination	cryptosporidium	microbes/l	100
35	Surface water - high contamination	giardia	microbes/l	500

Calculations

Put the data in this page into an ovariable

+ Show code - Hide code

# This is code "Op_en7953/concentration" on page [[Pathogen concentrations in raw water]]
library(OpasnetUtils)

RawConcentrationAll <- Ovariable("RawConcentrationAll", ddata = "Op_en7953", getddata = TRUE)

objects.store(RawConcentrationAll)
cat("Ovariable RawConcentrationAll saved.\n")

The raw water default class: Surface water - high contamination

+ Show code - Hide code

# This is code "Op_en7953/rawclass" on page [[Health impact of waterborne microbes]]
library(OpasnetUtils)

RawClass <- Ovariable("RawClass", data=data.frame(RawWaterClass = "Surface water - high contamination", RawClassResult = 1))

objects.store(RawClass)
cat("Ovariable RawClass saved. \n")

Use the ovariable to only include data from one raw water class

+ Show code - Hide code

# This is code "Op_en7953/variable" on page [[Pathogen concentrations in raw water]]
library(OpasnetUtils)

RawConcentration <- Ovariable("RawConcentration", dependencies = data.frame(
                                  Name=c("RawConcentrationAll", "RawClass"),
                                  Ident=c("Op_en7953/concentration", "Op_en7953/rawclass")
                                  ),
                                  formula = function(...){
                                    # Use the rows of RawConcentration with the right type of raw water
                                    return(RawConcentrationAll*RawClass)
                                  }
)

objects.store(RawConcentration)
cat("Ovariable RawConcentration saved.\n")

References

↑ Hrudey, S. E. and Hrudey, E. J. (2004). Safe Drinking Water. Lessons from Recent Outbreaks in Affluent Nations. London, IWA Publishing.
↑ Medema, G. J., Teunis, P. F., Blokker, M., Deere, D., Davidson, D., Charles, P. and Loret, J. F. (2009). Risk assessment of Cryptosporidium in drinking water, World Health Organisation.
↑ Pedley, S., Yates, M., Schivjen, J. F., West, J., Howard, G. and Barrett, M. (2006). Pathogens: Health relevance, transport and attentuation. Protecting Groundwater for Health Managing the Quality of Drinking‐water Sources. O. Schmoll, G. Howard, J. Chilton and I. Chorus, World Health Organization
↑ WHO (2004). Guidelines for Drinking‐water Quality Third Edition. Volume 1. Geneva, World Health Organization.

[1] Hrudey, S. E. and Hrudey, E. J. (2004). Safe Drinking Water. Lessons from Recent Outbreaks in Affluent Nations. London, IWA Publishing.

[2] Medema, G. J., Teunis, P. F., Blokker, M., Deere, D., Davidson, D., Charles, P. and Loret, J. F. (2009). Risk assessment of Cryptosporidium in drinking water, World Health Organisation.

[3] Pedley, S., Yates, M., Schivjen, J. F., West, J., Howard, G. and Barrett, M. (2006). Pathogens: Health relevance, transport and attentuation. Protecting Groundwater for Health Managing the Quality of Drinking‐water Sources. O. Schmoll, G. Howard, J. Chilton and I. Chorus, World Health Organization

[4] WHO (2004). Guidelines for Drinking‐water Quality Third Edition. Volume 1. Geneva, World Health Organization.

[1]

[2]

[3]

[4]

@@ Line 24: / Line 24: @@
 *Ground water - clean
 **Clean groundwater
-*Groundwater - surface water load
+*Groundwater - surface water contamination
 **for ex. shore infiltration
-*Surface water - low load
+*Surface water - low contamination
 **Relatively clean surface water
-*Surface water - medium load
+*Surface water - medium contamination
-**for ex. small waste water load
+**for ex. low waste water contamination
-*Surface water - high load
+*Surface water - high contamination
-**for ex. waste water load
+**for ex. waste water contamination
 === Data ===
@@ Line 46: / Line 46: @@
 Organization.</ref>
-<t2b index = "Raw water source,Pathogen,Unit" unit = "mikrobia/l">
+<t2b index = "RawWaterClass,Pathogen,Unit" unit = "microbes/l">
-Ground water - clean|Campylobacter|microbes/l|0
+Ground water - clean|campylobacter|microbes/l|0
 Ground water - clean|E.coli O157:H7|microbes/l|0
-Ground water - clean|Rotavirus|microbes/l|0
+Ground water - clean|rotavirus|microbes/l|0
-Ground water - clean|Norovirus|microbes/l|0
+Ground water - clean|norovirus|microbes/l|0
-Ground water - clean|Cryptosporidium|microbes/l|0
+Ground water - clean|sapovirus|microbes/l|0
-Ground water - clean|Giardia|microbes/l|0
+Ground water - clean|cryptosporidium|microbes/l|0
-Groundwater - surface water load|Campylobacter|microbes/l|0
+Ground water - clean|giardia|microbes/l|0
-Groundwater - surface water load|E.coli O157:H7|microbes/l|0
+Ground water - surface water contamination|campylobacter|microbes/l|0
-Groundwater - surface water load|Rotavirus|microbes/l|0
+Ground water - surface water contamination|E.coli O157:H7|microbes/l|0
-Groundwater - surface water load|Norovirus|microbes/l|0
+Ground water - surface water contamination|rotavirus|microbes/l|0
-Groundwater - surface water load|Cryptosporidium|microbes/l|0
+Ground water - surface water contamination|norovirus|microbes/l|0
-Groundwater - surface water load|Giardia|microbes/l|0
+Ground water - surface water contamination|sapovirus|microbes/l|0
-Surface water - low load|Campylobacter|microbes/l|1
+Ground water - surface water contamination|cryptosporidium|microbes/l|0
-Surface water - low load|E.coli O157:H7|microbes/l|1
+Ground water - surface water contamination|giardia|microbes/l|0
-Surface water - low load|Rotavirus|microbes/l|0.1
+Surface water - low contamination|campylobacter|microbes/l|1
-Surface water - low load|Norovirus|microbes/l|0.1
+Surface water - low contamination|E.coli O157:H7|microbes/l|1
-Surface water - low load|Cryptosporidium|microbes/l|0.1
+Surface water - low contamination|rotavirus|microbes/l|0.1
-Surface water - low load|Giardia|microbes/l|0.1
+Surface water - low contamination|norovirus|microbes/l|0.1
-Surface water - medium load|Campylobacter|microbes/l|50
+Surface water - low contamination|sapovirus|microbes/l|0.1
-Surface water - medium load|E.coli O157:H7|microbes/l|50
+Surface water - low contamination|cryptosporidium|microbes/l|0.1
-Surface water - medium load|Rotavirus|microbes/l|1
+Surface water - low contamination|giardia|microbes/l|0.1
-Surface water - medium load|Norovirus|microbes/l|1
+Surface water - medium contamination|campylobacter|microbes/l|50
-Surface water - medium load|Cryptosporidium|microbes/l|10
+Surface water - medium contamination|E.coli O157:H7|microbes/l|50
-Surface water - medium load|Giardia|microbes/l|50
+Surface water - medium contamination|rotavirus|microbes/l|1
-Surface water - high load|Campylobacter|microbes/l|1000
+Surface water - medium contamination|norovirus|microbes/l|1
-Surface water - high load|E.coli O157:H7|microbes/l|1000
+Surface water - medium contamination|sapovirus|microbes/l|1
-Surface water - high load|Rotavirus|microbes/l|100
+Surface water - medium contamination|cryptosporidium|microbes/l|10
-Surface water - high load|Norovirus|microbes/l|100
+Surface water - medium contamination|giardia|microbes/l|50
-Surface water - high load|Cryptosporidium|microbes/l|100
+Surface water - high contamination|campylobacter|microbes/l|1000
-Surface water - high load|Giardia|microbes/l|500
+Surface water - high contamination|E.coli O157:H7|microbes/l|1000
+Surface water - high contamination|rotavirus|microbes/l|100
+Surface water - high contamination|norovirus|microbes/l|100
+Surface water - high contamination|sapovirus|microbes/l|100
+Surface water - high contamination|cryptosporidium|microbes/l|100
+Surface water - high contamination|giardia|microbes/l|500
 </t2b>
 === Calculations ===
+Put the data in this page into an ovariable
+<rcode
+	name="concentration"
+	label="Initialize raw concentration"
+	embed=1
+>
+# This is code "Op_en7953/concentration" on page [[Pathogen concentrations in raw water]]
+library(OpasnetUtils)
+RawConcentrationAll <- Ovariable("RawConcentrationAll", ddata = "Op_en7953", getddata = TRUE)
+objects.store(RawConcentrationAll)
+cat("Ovariable RawConcentrationAll saved.\n")
+</rcode>
+The raw water default class: Surface water - high contamination
+<rcode
+        name="rawclass"
+        label="Initialize raw water class"
+	embed=1
+>
+# This is code "Op_en7953/rawclass" on page [[Health impact of waterborne microbes]]
+library(OpasnetUtils)
+RawClass <- Ovariable("RawClass", data=data.frame(RawWaterClass = "Surface water - high contamination", RawClassResult = 1))
+objects.store(RawClass)
+cat("Ovariable RawClass saved. \n")
+</rcode>
+Use the ovariable to only include data from one raw water class
 <rcode
 	name="variable"
 	label="Initialize variable"
+	embed=1
 >
 # This is code "Op_en7953/variable" on page [[Pathogen concentrations in raw water]]
 library(OpasnetUtils)
-RawConcentration <- Ovariable("RawConcentration", ddata = "Op_en7953", getddata = TRUE, save = TRUE)
+RawConcentration <- Ovariable("RawConcentration", dependencies = data.frame(
+                                  Name=c("RawConcentrationAll", "RawClass"),
+                                  Ident=c("Op_en7953/concentration", "Op_en7953/rawclass")
+                                  ),
+                                  formula = function(...){
+                                    # Use the rows of RawConcentration with the right type of raw water
+                                    return(RawConcentrationAll*RawClass)
+                                  }
+)
+objects.store(RawConcentration)
 cat("Ovariable RawConcentration saved.\n")
-oprint(RawConcentration)
 </rcode>

Pathogen concentrations in raw water: Difference between revisions

Latest revision as of 13:49, 23 March 2020

Contents

Question

Answer

Rationale

Data

Calculations

See also

References

Navigation menu