EPA/600/B-15/275
Microbial Properties Database Editor Tutorial
Gene Whelan
Marirosa Molina
Richard Zepp
U.S. Environmental Protection Agency
Office of Research and Development
National Exposure Research Laboratory
Athens, GA
Mitch A. Pelton
Battelle
Pacific Northwest Division
Richland, WA
John Ravenscroft
U.S. Environmental Protection Agency
Office of Water
Office of Science & Technology
Washington, DC
Yakov A. Pachepsky
U.S. Department of Agriculture
Agricultural Research Service
Beltsville, MD
10/10/15
-------
Summary
A Microbial Properties Database Editor (MPDBE) has been developed to help consolidate microbial-
relevant data to populate a microbial database and support a database editor by which an authorized
user can modify physico-microbial properties related to microbial indicators and pathogens. Physical
properties describe changes in state of the physical system and relate to properties such as mass of a
microbe, excretion density of microbes in animal feces, prevalence, etc. Microbial properties relate to
changes in or with the microbe, such as inactivation rate, attachment/detachment rates, dose-response
coefficients, etc. The objective of the MPDBE is to provide a tool by which an authorized user can modify
physico-microbial properties related to microbial indicators and pathogens and populate metadata
standards, so the properties are available for consumption by microbial source, fate, transport, and risk
models. Although other databases are being developed on specific microbial properties, such as
inactivation of microorganisms in environmental media, or explicitly include other valuable support
information (e.g., methods of analysis, experimental set up, etc.), this database helps bridge the gap
between modeling, monitoring, and methods by identifying parameters that are typically used by
models engaged in Quantitative Microbial Risk Assessments (QMRAs). These parameters address
modeling paradigms that include release mechanism from manure forms (e.g., solid pats, slurry, and dry
litter); fate and transport through various environmental media (e.g., overland, groundwater, surface
water); exposure; intake; and risk. Some parameters may be widely used (e.g., inactivation rates), while
others may seem obscure but only because users may not be familiar with the specific models or the
literature associated with them. As additional parameters are correlated to more models, these can be
added to the database to ensure a smooth linkage between data collected in the field and at the bench-
scale with models that consume the information. Once populated, the database can act as a reference
to help parameterize models used in QMRAs. In addition, for models registered to integrated
environmental modeling infrastructures, the database editor could be used to automatically populate
model input requirements. The microbial database is to supply microbial properties to users. Included
with the microbial database will be an editor that lets users update microbial and parameter values in
the database. The parameters for evaluation of impacts due to pathogen exposure can be viewed,
estimated, modified, printed, deleted, and exported.
-------
Microbial Properties Database Editor Tutorial
PURPOSE
To help consolidate microbial-relevant data to populate a microbial database and support a database
editor by which an authorized user can modify physico-microbial properties related to microbial
indicators and pathogens. Physical properties describe the changes in state of the physical system and
relate to properties such as mass of a microbe, excretion density of microbes in animal feces,
prevalence, etc. Microbial properties relate to changes in or with the microbe, such as inactivation rate,
attachment/detachment rates, dose-response coefficients, etc.
OBJECTIVE
To develop a database editor by which an authorized user can modify physico-microbial properties
related to microbial indicators and pathogens and to populate metadata standards, so the properties
are available for consumption by microbial source, fate, transport, and risk modules; the intent is to
make available microbial properties for multimedia modeling components. The Microbial Properties
Database Editor may be used to access, edit, update, modify, or correct 1) the permanent database, and
2) a temporary database to be made available for modeling components used within an integrated
environmental modeling workflow.
BACKGROUND
Whelan et al. (2014a) note that a Quantitative Microbial Risk Assessment (QMRA) characterizes
potential human health risk using four pieces of information: average pathogen densities, mean water
ingestion for the exposure scenario, pathogen dose-response relationships, and conditional probability
of illness (Haas et al., 1999; Hunter et al., 2003). The risk assessment approach differs from
epidemiological approaches (Calderon et al., 1991; Colford et al., 2012; Haile et al., 1999) in that the
latter seek to associate levels of self-reported disease (e.g., in a group of swimmers) with the water
quality measured by fecal indicator bacteria, and not the etiological agent(s) responsible for the disease.
Epidemiology studies implicitly characterize the source of fecal contamination, fate and transport
kinetics of the microbes, the natural variability of the microbes in the environmental matrix, the
etiological agent(s) and exposure scenario studied, while QMRA deals explicitly with these components.
Although researchers can survey the literature and extract information relevant to their QMRA modeling
activities, these unrelated surveys can result in different, inconsistent, and contradictory QMRA
assessments, as a consistent mapping between modeling, monitoring, and methods has not been
institutionalized.
Although other databases are being developed on specific microbial properties, such as inactivation of
microorganisms in environmental media (Pachepsky et al., 2010), or explicitly include other valuable
support information (e.g., methods of analysis, experimental set up, etc.), this database helps bridge the
gap between modeling, monitoring, and methods by identifying parameters that are typically used by
models engaged in QMRA assessments. These parameters address modeling paradigms that include
release mechanism from manure forms (e.g., solid pats, slurry, and dry litter); fate and transport
through various environmental media (e.g., overland, groundwater, surface water); exposure; intake;
-------
and risk. Some parameters may be widely used (e.g., inactivation rates), while others may seem obscure
but only because users may not be familiar with the specific models or the literature associated with
them. Although there is no common classification of manures, typically one distinguishes liquid manure
or slurry (less solid fraction), sludge (e.g., lagoon material), dry litter, and pastureland animal waste (e.g.,
cowpats), although sometimes farmyard manure (more solid fraction) is designated. For simplification,
these categories have been combined into three designations: Solid, Slurry, and Dry Litter. As additional
parameters are used in more models, these can be added to the database to ensure a smooth linkage
between data collected in the field and at the bench-scale with models that consume the information.
Once populated, the database can act as a reference help parameterize models used in QMRAs. In
addition, for models registered to integrated environmental modeling infrastructures (Whelan et al.,
2014b; Laniak et al., 2013), the database editor can be used to automatically populate model input
requirements, as illustrated by Whelan et al. (2014a).
PARAMETERS CONTAINED IN THE MICROBIAL PROPERTIES DATABASE
Table 1 lists the parameters contained in the Microbial Properties Database with definitions. The list has
been compiled using input needs of models that can be, and traditionally have been, used in microbial
assessments investigating microbial release mechanisms from manure (Bradford and Schijven, 2002;
Kim et al., 2015; Guber et al., 2010, 2013) and supporting fate and transport modeling, watershed
modeling (Bicknell et al., 1997; EPA 2013b, 2013c), and exposure and risk assessment modeling (Seller et
al., 2008, 2004). Table 2 expands on Table 1's first seven parameters (Name, LandllseName,
DomesticAnimalName, WildLifeName, UrbanizedName, MediumName, and ManureForm), since they
describe indices associated with other microbial parameters in Table 1. Table 3 combines Tables 1 and 2
to create the Microbial Properties Database ontological dictionary which groups similar and related
parameters and provides a single naming convention for variables and parameters shared by modeling
components (Whelan et al., 2014b). Table 3 provides the following specific information:
• Variable Name
• Variable Description/Definition
• Variable Dimension/Cardinality - Number of elements in a set or other grouping, as a property
of that variable. For example, if the variable "concentration" is a function of chemical name,
location, and time, then it would have a dimension of 3.
• Variable Data Type - String, Float, Integer, Logical
• Primary Key - Variables that can only be identified and defined once in a workflow ontology
(i.e., universal parameter recognized by all components within a workflow).
• Sealer - Indicates that the variable is not part of a list. If it is part of a list, then it is considered
self-indexed (a function of itself) or self-enumerated (specified one after another). For example,
a time series is typically self-indexed, so the first time is indexed to 1, the second time is indexed
to 2, etc. Self-indexing (i.e., being non-sealer) increases the Variable Dimension by one.
• Variable Range - Minimum and Maximum
• Measure — Categorizes a collection of units that inherit the same measuring properties; for
example, meter, foot, and yard are units for the measure "Length."
• Variable's Units - Scaling properties within the same measure.
• Stochastic - Identifies variables available for statistical manipulation, such as Monte Carlo
• Indices - Elements in a set or other grouping, as a property of that variable (other parameters of
which this variable is a function; see Table 2).
-------
Table 1. Parameter names and descriptions in the Microbial Properties Database
Parameter Name
Name
LandUseName
DomesticAnimalName
WildLifeName
UrbanizedName
MediumName
ManureForm
AlphaM
Bman
ReleaseRateEff
ReleaseRateEffConstant
ExcretionDensity
ExcretionDensitySuperShedder
FastDieOff Manure
PartitionCoef
Prevalence
SlowDieOff Manure
BetaPoissonConst
BetaPoissonExp
ExpoDoseRespConst
GompertzLogFirstConst
GompertzLogSecondConst
HypergeometricFirstConst
HypergeometricSecondConst
Attach Rate
Parameter Description
Name of microbe
Land Use Type
Domestic Animal Name
Wildlife Name
Name of Mixed Urban or Built up area
Environmental Medium associated with Microbe
Physical form of the manure (solid, slurry, dry litter)
Fitting parameter that controls the initial microbial release rate from
the manure (Bradford and Schijven, 2002)
The fitting parameter defining the shape of the Microbe manure-
release curve (Bman) (Bradford and Schijven, 2002)
Microbial release rate efficiency from the manure (which is constant
with time); it is the fraction of the microbes that are actually released
from the manure (Er) (Bradford and Schijven, 2002)
A Constant parameter that reflects the microbial release rate
efficiency from the manure; the release rate efficiency varies with
time (b) (Kim etal., 2015)
Density of microbe in feces of animal per wet weight
Density of microbe in feces of animal that is a super shedder per wet
weight
Fast stage microbial inactivation rate by manure form (Blaustein et
al., 2013)
Instantaneous partition coefficient between liquid and solid phases
(traditional distribution coefficient, Kd)
Fraction of the animals infected with pathogen
Slow stage microbial inactivation rate by manure form (Blaustein et
al., 2013)
Constant shape parameter in Beta Poisson Dose-Response Model
(Haas etal., 1999)
Exponent shape parameter in Beta Poisson Dose-Response Model
(Haas etal., 1999)
Constant parameter (r) in Exponential Dose-Response model (Haas et
al., 1999)
First parameter (a) in Gompertz-log Dose-Response model (Haas et
al., 1999)
Second parameter (b) in Gompertz-log Dose-Response model (Haas et
al., 1999)
First parameter (a) in Hypergeometric Dose-Response model (Haas et
al., 1999)
Second parameter (b) in Hypergeometric Dose-Response model (Haas
et al., 1999)
Attachment rate of Microbe at the soil-solid phase (ka in
KINEROS2/STWIR) (Guber et al., 2010)
-------
Detach Rate
ExchangeDepth
InfilFracKf
MassTransferRateK
StrainCoef
SepticConc
lnfect_asymtomatic
lnfect_endemic
lnfect_incubation
lnfect_p_to_p
lnfect_reinfect
lnfect_response
lnfect_symtomatic
AnimalConcMass
AnimalShedRateMass
BuiltUpRate
DieOffManure
DieOffMedium
DieOffTempCorr
Mass
WildLifeDensity
WildLifeShedRate
Detachment rate of Microbe at the soil-solid phase (lower case kd in
KINEROS2/STWIR) (Guber et al., 2010)
Thickness of top layer that actively interacts with overland flow (i.e.,
mixing zone) (Guber et al., 2010)
Fraction of infiltrated cells that have been filtered out by the soil
mixing zone (i.e., staying in mixing zone) (kf in Model 2
KINEROS2/STWIR) (Guber et al., 2010)
Mass Transfer Rate of Microbe at the soil-solid phase interface (k in
Model 1 KINEROS2/STWIR) (Guber et al., 2010)
Straining coefficient, referring to losses due to infiltration (unity is not
infiltration loss) (kstr in KINEROS2/STWIR) (Guber et al., 2010)
Typical microbial concentration in septic system waste
Duration of asymptomatic infection in days
Beta_end (endemic transmission rate) (Seller et al., 2008, 2004)
Duration of incubation in days (Seller et al., 2008, 2004)
Beta_pp (person-person transmission rate) (Seller et al., 2008, 2004)
Duration of protection from reinfection in days (Seller et al., 2008,
2004)
Probability of symptomatic response, expressed as a fraction (Seller
et al., 2008, 2004)
Duration of symptomatic infection in days (Seller et al., 2008, 2004)
Microbial concentration based on mass of waste shed by domestic
animal
Domestic animal shedding rate in mass of waste (weight weight) per
time
Accumulation rates in median microbial counts per area per time by
built up (i.e., urbanized) land use
First-order microbial inactivation/die-off rate by manure form
First-order microbial inactivation/die-off rate by environmental
medium
Microbial inactivation/Die-off rate Temperature Correction
Mass of a single microbe
Typical number of wildlife per unit area by landuse pattern
Typical wildlife microbial shedding rate per wildlife
-------
Table 2. Indices associated with Parameters
Index
Definition
Name
Microbe Name. There are 17 microbes currently registered by microbe type
(Indicator or Pathogen) and class (Bacterial, Protozoa, or Virus):
• Indicator Bacteria
1. E. coli
2. Enterococci
3. Clostridium perfringens
4. Fecal Coliforms
5. Bacteroides
• Pathogenic Bacteria
6. Salmonella spp
7. Campylobacter spp
8. E. coliO157:H7
9. Listeria
10. Mycobacterium avium paratuberculosis
• Pathogenic Protozoa
11. Cryptosporidium parvum
12. Giardia lamblia
13. Toxoplasma gondii
• Pathogenic Viruses
14. Enterovirus
15. Rotavirus
16. Adenovirus
17. Norovirus
DomesticAnimalName
Domestic Animal Name. There are seven domestic animal name
designations:
1. DairyCow: Dairy Cow
2. BeefCow: Beef Cattle
3. Swine
4. Poultry
5. Horse
6. Sheep
7. OtherAgAnimal: Other Agricultural Animal
LandUseName
Landuse Type. There are four landuse type designations:
1. Forest
2. Cropland
3. Pasture
4. Urbanized (a.k.a. Builtup)
UrbanizedName
Name of Urbanized or Builtup areas. There are four Urbanized designations:
1. CommercialAndServices: Commercial and Services
2. Residential
3. MixedUrban: MixedUrban
4. TransportationCommunicationUtilities: Transportation,
Communication, Utilities
WildlifeName
Wildlife Name: There are six wildlife name designations:
1. Duck
-------
2. Goose
3. Deer
4. Beaver
5. Racoon
6. OtherWildlife: Other Wildlife
ManureForm
Physical form of the manure. There are three designations:
1. Solid
2. Slurry
3. Dry Litter
MediumName
Name of environmental medium associated with Microbe. There are 11
medium designations:
1. Air
2. VadoseZone
3. Aquifer
4. Impoundment (e.g., pond, reservoir)
5. WasteStoragePond
6. SurfaceWater (e.g., river, stream)
7. Soil
8. Sediments
9. Stormwater
10. WastewaterEffluent
11. GrayWater
-------
Table 3. Microbial Properties Database Ontological Dictionary
NAME
Name
LandUseName
DomesticAnimalName
WildLifeName
UrbanizedName
M.d,UmN,™
Ma.ureForm
WildLifeDensity
WildLifeShedRate
AnimalShedRateMass
An,™IQ,ncM,,,
SepticConc
BuiltUpRate
Mass
DieOffTempCorr
Prevalence
ExcretionDensity
ExcretionDensitySuperShedder
PartitionCoef
ExpoDoseRespConst
Parameter Description
Nameofmicrobe
Land Use Type
Domestic Animal Name
Wildlife Name
Name of Mixed Urban or Bui It
associated with Microbe
(solid, slurry,dry litter)
Typical numberof wildlife per
unitarea bylanduse pattern
Typical wildlife microbial
shedding rate per wildlife
Domestic animal shedding rate
in mass of waste (ww) pertime
Microbial concentration based
in se ptic system waste
Accumulation rates in median
microbial counts perarea per
time by built up land use
Mass of a single microbe
First-order microbial
medium
First-order microbial
m a n u re f o rm
Microbial inactivation/Die-off
rate Temperature Correction
Slow phase (dark) microbial
form V
Fast phase (light) microbial
form
Fraction of the animals infected
with microbe
Density of microbe in feces of
p
infected animal that is a super
shedder perww
coefficient between liquid and
solid phases (traditional
distribution coefficient, Kd)
Constant para mete r(r) in
Exponential Dose-Response
model
Dimension
1
1
1
1
1
1
1
2
2
1
2
1
3
1
1
2
2
2
2
1
Data
Type
STRING
STRING
STRING
STRING
STRING
STRING
STRING
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
Primary Key
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
1
T
^
s
z
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
Minimum
0
0
0
0
0
0
0
0
0
0
0
0
0
\
•*
i
l.OE+38
l.OE+38
l.OE+38
l.OE+38
l.OE+38
l.OE+38
l.OE+38
l.OE+38
1.0
l.OE+38
l.OE+38
l.OE+38
l.OE+38
Measure
Unitless/Area
Microbial
Counts/Time
Mass/Time
Microbial
Counts /Mass
Microbial
Microbial
Counts/Area/Time
Mass
Ratio
Microbial
Microbial
Counts /Mass
Volume/Mass
1/Microbial Counts
Units
Number/ac
Microbial
Counts/d
Kg/d
Microbial
Counts/g
Microbial
Counts/L
Microbial
Counts /a c/d
g
Fraction
Microbial
1%
Microbial
Counts/g
mL/g
1/Microbial
Counts
Stochastic?
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
Index 1
LandUseName
Name
DomesticAnimalName
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Index 2
WildlifeName
WildlifeName
D.mM«rtn,m,IN,m.
LandUseName
DomesticAnimalName
DomesticAnimalName
D.mM«rtn,m,IN,m.
MediumName
Index 3
UrbanizedName
-------
Table3. Microbial Properties Database Ontological Dictionary (cont'd)
NAME
BetaPoissonExp
BetaPoissonConst
HypergeometricFirstConst
HypergeometricSecondConst
GompertzLogFirstConst
GompertzLogSecond Const
- V
Infect endemic
Infectjncubation
Infect p to p
lnfect_reinfect
Infect response
lnfect_symtomatic
AttachRate
DetachRate
MassTransferRateK
InfilFracKf
StrainCoef
ExchangeDepth
AlphaM
Bman
Release Rate Eff Constant
ReleaseRateEff
Parameter Description
Exponent shape para meter in
Beta Poisson Dose-Response
Model
Constant shape para meter in
Beta Poisson Dose-Response
Model
First parameter (a) in
Hype rgeo metric Dose-Response
model
Second parameter(b)in
Hype rgeo metric Dose-Response
model
First para meter (a) in Gompertz-
log Dose-Response model
Second parameter(b)in
Gompertz-log Dose-Response
model
Duration of asymptomatic
infection in days
Beta end (endemic
transmission rate)
Duration of incubation in days
Beta pp (person-person
transmission rate)
Duration of protection from
reinfection in days
Probability of symptomatic
response, expressed as a
fraction
Duration of symptomatic
infection in days
Attachment rate of Microbe at
the soil-solid phase (ka in
KINEROS2/STWIR)
Detachment rate of Microbe at
the soil-solid phase (lower
case kd in KINEROS2/STWIR)
Mass Transfer Rate of Microbe
atthe soil-solid phase
interface (k in Model 1
KINEROS2/STWIR)
Fraction of infiltrated cells that
have been filtered out by the
soil mixing zone (i.e., staying in
mixing zone) (kfin Model 2
KINEROS2/STWIR)
Straining coefficient (kstr in
KINEROS2/STWIR)
Thickness of top layerthat
actively interacts with overland
flow (i.e., mixing zone)
Fitting para meter that Controls
the initial Microbial release
rate from the manure
The fitting parameter defining
the shape of the Microbe
manure-release curve (Bman)
A Constant para meter that
reflects the microbial release
rate efficiency from the manure;
the release rate efficiency
varies with time (b)
Microbial release rate
efficiencyfrom the manure
(which is constant with time); it
is the fraction of the microbes
that a re actually re leased from
the manure (Er)
Dimension
1
1
1
1
1
1
1
1
1
1
1
1
3
3
3
2
2
1
2
2
2
2
Data
Type
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
FLOAT
Primary Key
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
Not Self-indexed?
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
Minimum
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Maximum
l.OE+38
l.OE+38
l.OE+38
l.OE+38
l.OE+38
l.OE+38
l.OE+38
l.OE+38
l.OE+38
l.OE+38
1
l.OE+38
l.OE+38
l.OE+38
l.OE+38
1
1
l.OE+38
l.OE+38
l.OE+38
l.OE+38
l.OE+38
Measure
Microbial
Counts
ime
Time
Time
Ratio
Time
I/Time
I/Time
Length/Time
Ratio
Ratio
Length
I/Time
I/Time
Ratio
Units
Microbial
Counts
ays
days
days
fraction
days
1/hr
1/hr
cm/hr
fraction
fraction
m
1/hr
1/hr
fraction
Stochastic?
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
Index 1
Name
Name
Name
Name
Name
Name
ame
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
Name
ManureForm
ManureForm
ManureForm
Name
Name
Index 2
MediumName
MediumName
MediumName
ManureForm
ManureForm
ManureForm
ManureForm
Index 3
ManureForm
ManureForm
ManureForm
-------
DEMONSTRATION
This tutorial reviews some of the screens, icons, and basic functions of downloading the tool and using
the Microbial Properties Database Editor (MPDBE):
• Software access, retrieval, and download.
• Sort, identify, and select a list of microbes in the database by microbe name, type (i.e., indicator
or pathogen) and/or class (i.e., bacteria, protozoa, or virus).
• Edit identification characteristics of existing microbes, or create identification characteristics of
a new microbe.
• Edit microbial properties.
SOFTWARE ACCESS, RETRIEVAL, AND DOWNLOAD
This section describes how to access, retrieve and download the Microbial Properties Database Editor.
1. The Microbial Properties Database Editor software, which is contained in the zip file, titled
"MicrobePropertyDBFiles.zip", can be retrieved from the following site:
O:\Public\QMRA\Microbial Properties DB Editor
V Computer > Data (\\AA.AD.EPA.GOV\ORD\ORD) (0:) > Public
File Edit View lools Help
Organize •*• ^ Open E-mail Burn New folder
Data (\\AA.AD.EPA,GOV\ORD\ORD110;i ^
rk Storage
>m
PRIV
ILandscape Clearance Pkg
QMRA^
Microbial Properties DB Editor
Narrative
Peer-reviewed Manuscripts
SARA Timeseries Utility
SDMPB
SDMPBJdentifying the Basin of Interest
rial
* Software for Download
Vlt
FORTRAN Library
Microbial Properties Database Editor
SARA Timeseries Utility
. SDMPB
Virtual Beach
Name
itiz
LM
. Lucner
. McKane
(. MED Refresh
^ Software for Download > Microbia! Properties Database Editor
Name
* MicrobePropertyDBFiles.zip
Date modified Type
11/25/2014 9:53 AM WinZip File
10
-------
2.
Unzip or extract the files, creating a folder; in the case below, a folder with the same name
(MicrobePropertyDBFiles) was created in the same directory as the zip file. Two files are
unzipped or extracted to the MicrobePropertyDBFiles folder: MDBE.exe and
Microbes Test.mdb.
^ Computer * OSDisk (C:) > Users t gwhelan ^ MicrobialPropertyDB ^ MicrobePropertyDBFiles
File Edit View Joels Help
Organizes Include in library •» Share with •* Burn New folder
^* Computer -• Name Type Date modified Size
J^» OSDisk (C.) -^MDBE.exe Application 9/18/2014 9:51 AM 105KB
BASIN S41
£r; Microbes Test.mdb Microsoft Access Database 11/24/201412:35... 920KB
Corel
csc-data
MyFiles
NSLFiles
ORDApps
^ . P erf Logs
Program Files
Program Files (x86)
ProgramData
Python27
Temp
USEPA
' Users
Administrator
Default
gina.lubucchiaro2
J gwhelan
AppData
O] Contacts
csc-data
• • Desktop
^ Downloads
iemTechnologies
f Links
^ ±, MicrobialPropertyDB
MicrobePropertyDBFiles
- MicrobePropertyDBFiles.zip
3. Execute the MDBE.exe file and the following screen appears. Choose File, then Open.
11
-------
4. Search for Microbes_Test.mdb in the same folder (shown below) and Open the file.
tf Open Existing Microb^l Database ^^^^^^^^^^^^ ^
yTJtti j^ « Users > gwhelan > MicrobialPropertyDB > MicrobePropertyDBFiles •* ^ I Search MicrobePropertyDBFiles fl
Organize " New folder j~ » EH ®
• Desktop * Name Date modified Type Size
4!. Downloads
Recent Places
' • Desktop
: ^ Libraries
!> 0 Whelan, Gene
' ;fc Computer
' §• OSDisk (C:)
> J> BASINS41
> J|i Corel .
^ ^ csc-data
MyFiles
NSLFiles
ORDApps
PerfLogs
> ,^j Program Files
> J« Program Files (x86)
> Ji ProgramData
> ^ Python27
t> J( Temp
I> ,|i USEPA
J^ Users
Administrator
> JU Default
gina,lubucchiaro2
<• gwhelan
!> j, AppData
•3 Contacts
csc-data
r; Desktop
- 4^ Downloads
> ^. iemTechnologies
|l Links
0 Microbes_Test.mdb 11/24/201412:35... Microsoft Access ... 920KB
' MicrobialPropertyDB
MicrobePropertyDBFiles
. MicrobePropertvDBFiles.zip ' < 1 '
Filename: MicrobesTest.mdb T MS Access DB (*.mdb) "^
| Open Cancel
12
-------
5. The following screen appears:
•^ Microbial Database
File Help
[Select Microbe of Concern |
_
O Name
n Microbe Type
n Microbe Class
Search Results
Edt Microbe Identity j Edit Microbe Properties
Indicator
Bacteria
[-0 | 1°1 •
Search
Clear
™
Selected Microbes
• E Cnh ^^^•ll'CnllHftinnl •!
1 Enterococci
Clostridium perfringens
Fecal Coliforms
Bacteroides
Salmonella spp
Campylobacterspp
E. coli0157:H7
Listeria
Mycobacterium avium paratuberculosis
Cryptosporidium parvum
Giardia larnblia
Toxoplasma gondii
Enterovirus
Rotavirus
Adenovirus
Norovirus
. .
»
. 1
1 f< \
6. Choosing File,
Search Criteria
'C\ Name
n Microbe Type
•_| Microbe Ctass
Search Results
Search
Selected Microbes
Enterococci
Clostridium perfringens
Fecal Coliforms
Bacteroides
Salmonella spp
Carnpylobacter spp
E. coii0157:H7
Listeria
Mycobacterium avium paratuberculosis
Cryplosporidium parvum
Giardia lamblia
Toxoplasrna gondii
Enterovirus
Rotavirus
Adenovirus
Norovirus
13
-------
7. The following choices are available:
a. New: Creates a new, empty database (no values or references) except the microbe list is
retained.
b. Open: Opens an existing database.
c. Save: Saves the existing changes under the current file name.
d. Save As: Saves the existing changes under a new, user-defined file name.
e. Save and Exit: Saves the existing changes under the current file name and exits.
f. Exit: Exits without saving.
8. By choosing New, Open, or Save As, the following screen appears, prompting the user to type
the file name. Select File and Save As, and in the File Name text box, type a new file name such
as MicrobeGW. Push Save.
-^. Save As Microbial Database
| > Computer > OSDisk[GJ > Users > gwhelan > MicrobialPropertyDB > MicrobePrcpertyDBFiles » *t M - i'« P
Organize *• Newfolder ^EE » ©
. . iemTechnologies - Name Date modified Type
MicrobialPropertyDB
mb_090214
mb 090414
mb_091214
mb_091514
mb 091714
,. mb_091814
MicrobePrapertyDBFile!
Ej Microb«.mdb 9A7/2014 4:18 PM Microsoft
Test!
File name:! MicrobesGW] 1
s fr |jBB™™«Jdb)
- Hide Folders [ Save | | Cancel |
14
-------
SORT, IDENTIFY, AND SELECT A LIST OF MICROBES
This section describes how a user sorts, identifies, and selects a list of microbes in the database by
microbe name, type (indicator or pathogen), and/or class (bacteria, protozoa, or virus).
1. Go to the Select Microbe of Concern tab
XJto : :•_-?";.{ O
Search Criteria
PI Name
H Microbe Type
n Microbe Class
Search Results
Search
Selected Microbes
Enterococci
Closlridium perfringens
Fecal California
Bacteroides
Salmonella spp
Campylobacterspp
E coli 0157:H7
Listeria
Mycobacterium avium paratuberculosis
Cryptospondium parvum
Giardia lamblia
Toxoplasma gondii
Enterovirus
Rota virus
Adenovirus
Norovirus
2. There are several ways to search for a microbe:
a. Search by Name: Check the Name box and type "E. coli". Make sure the period and
space are included. Press Search to search for all microbes containing the name "E. coli."
Results of the search appear under Search Results as seen in the screen capture below.
File Help
Select Microbe of Concern Edl Mkjobe Identty | Edt Mjcrcbe Properties
Search Criteria
'"E.COII
KM*
Indicator
Search Results
Selected Microbes
15
-------
b. Search by Microbe Type: Uncheck Name box, check the Microbe Type box, choose the
down arrow, and select Indicator or Pathogen. Pathogen was chosen in the screen
capture below. Pressing Select will search for all microbes classified as Pathogen,
providing results under Search Results as noted below.
File Help
Select Microbe of Concerr
Search Criteria
D Name
[7| Microbe Type
D Microbe Class
Search Results
Edit Microbe Identity E
Selected Microbes
Campylobacter spp
E.co1i0157:H7
Listeria
Mycobactenum avium paratubercutosis
Cryptosporidium parvum
Giardta lamblia
Toxoplasma gondii
Enterovirus
Rotavirus
Adenovirus
Norovirus
c. Search by Microbe Class: Check the Microbe Class box, choose the down arrow, and
select Bacteria, Protozoa, or Virus; Protozoa was chosen in the screen capture below.
Pressing Select will search for all microbes classified as Protozoa, providing results under
Search Results, as noted below.
Select Microbe of Concern Edit Monte Idently ' EdU Microbe Properties
Search Criteria
H Name
f I Microbe Type
S Microbe Class
Search
Search Results
Giardia lamblia
Toxoplasrna gondii
16
-------
d. Search by a Combination of Criteria: Check the Microbe Type and Microbe Class boxes,
then choose Pathogen and Bacteria, respectively. Pressing Select will search for all
microbes classified as Pathogen and Bacteria, providing results under Search Results as
noted in the screen capture below.
File Help
Select Microbe of Concern Edj Microbe Idently EdJ Microbe Properties
Search Criteria
D Name E <>li
Search
I [71 Microbe Type
0 Microbe Class
Pathogen
Bacteria
Search Results
Campylobacter spp
E. coliO157:H7
Listeria
Mycobacterium avium paratuberculosis
Selected Microbes
3. To Clear Search Criteria, click Clear and the full list of microbes reappears under Search Results.
File Help
Edit Microbe Identity Edrt Microbe Properties
Search Criteria
Q Name
D Microbe Type Indicator
D Microbe Class Bacteria
Search Results
Selected Microbes
Enterococci
Clostridium perfringens
Fecal Coliforms
Bacteroides
Salmonella spp
Campytobacterspp
E.coli0157:H7
Listeria
Mycobacterium avium paratuberculosis
Cryptosporidium parvum
Giardia lambiia
Toxoplasma gondii
Enterovirus
Rota virus
Adenovirus
Norovirus
17
-------
4. To select microbes for interrogation or to edit their properties, left-click on the name under
Search Results (the name will be highlighted), then left-click on the » box to move the microbial
name to Selected Microbes (see selection of Salmonella spp in the screen capture below).
Micrabial Database
File Help
Select Microbe of Concern Eds Microbe Identity | Edit Microbe Properties I
Search Criteria
Name
U Microbe Type | Indicator
!_J Microbe Class Bacteria
Search Results
Selected Microbes
E. Coli
Enterococci
Clostndium perfringens
Fecal Coliforms
acteroides
Campylobacter spp
E. coli 0157H7
Listeria
Mycobacterium avium paratuberculosis
Cryptosporidium parvum
Giardia lamblia
Toxoplasma gondii
Enterovirus
Rotavirus
Adenovirus
Norovirus
File Help
Select Microbe of Concern Edit Microbe Identity Edit Microbe Properties
Search Criteria
n Name
LJ Microbe Type
[U Microbe Class
Search Results
E.coti
Pathogen
Bacteria
Search
Clear
E.Coli
Enterococci
Clostridium perfringens
Fecal Coliforms
Bacteroides
Carnpyiobacterspp
E.coli0157:H7
Listeria
Mycobacterium avium paratuberculosis
Cryptosporidium parvum
Giardia lamblia
Toxoplasma gondii
Enterovirus
Rotavirus
Adenovirus
Norovirus
18
-------
5. Multiple microbes can be chosen and moved from Search Results to Selected Microbes, as
illustrated in the screen capture below where E. coli has been selected.
File Help
Sdecl Microbe of Concern | Ed» Microbe Identity | Edt Microbe Properties |
Search Criteria
d Name
D Microbe Type
E. coli
Search
Pathogen
Bacteria
Clear
I Microbe Class
Search Results
Enterococci
Clostridium perfringens
Fecal Coliforms
Bacteroides
Salmonella spp
Campylobacterspp
E.coliQ157:H7
Listeria
Mycobacterium avium paratuberculosts
Cryptosporidium parvurn
Giardia lamblia
Toxoplasma gondii
Enterovirus
Rotavirus
Adenovirus
Norovirus
Selected Microbes
Salmonella spp
6. To de-select a choice, highlight the microbe in Selected Microbes, and click the « button, as
illustrated in the screen capture below where Salmonella spp has been removed.
File Help
Select Microbe of Concern Edit Microbe Identity | Edit Microbe Properties
Search Criteria
Q Name
[ | Microbe Type
D Microbe Class
E. coli
Pathogen
Bacteria
Search
Clear
Search Results
Selected Microbes
E.Coli
Enterococci
Closfridium perfringens
Fecal Coliforms
Bacteroides
Campylobacter spp
E.coli0157:H7
Listeria
Mycobacterium avium paratuberculosis
Cryptosporidium parvum
Giardia lamblia
Toxoplasma gondii
Enterovirus
Rotavirus
Adenovirus
Norovirus
E. Coli
19
-------
Sdect Microbe of Concern Edit Microbe Identity Edit Microbe Properties |
Search Criteria
D Name
E.coli
Search
Microbe Type Pathogen
t J Microbe Class | Bacteria
Search Results
Clear
Selected Microbes
Enterococci
Clostridium perfringens
Fecal Coliforms
Bacteroides
Salmonella spp
Campyiobacterspp
E. coli 0157H7
Listeria
Mycobacterium avium paratuberculosis
Cryptosporidium parvum
Giardia lamblia
Toxoplasma gondii
Enterovirus
Rotavirus
Adenovirus
Norovirus
7. Select Salmonella again and move it to Selected Microbes.
File Help
Select Microbe of Concern Edi Microbe IdertSy Edit Microbe Properties
Search Criteria
Q Name
D Microbe Type Indicator
IJ Microbe Class Bacteria
Search Results
Selected Microbes
E. Coll
Enterococci
Clostridium perfringens
Fecal Coliforms
Bacteroides
Campyiobacterspp
E. coli 0157H7
Listeria
Mycobacterium avium paratuberculosis
Cryptosporidium parvum
Giardia lamblia
Toxoplasma gondii
Enterovirus
Rotavirus
Adenovirus
Norovirus
E. Coli
20
-------
EDIT IDENTIFICATION CHARACTERISTICS OF EXISTING MICROBES, OR CREATE IDENTIFICATION
CHARACTERISTICS OF A NEW MICROBE
This section describes how a user edits identification characteristics of existing microbes or creates
identification characteristics of a new microbe.
1. To edit identification characteristics of existing microbes or create them for a new microbe, left-
click on the Edit Microbe Identity tab.
Select Microbe of Concern
Selected Microbes
Salmonella spp
Identity
Id
Name
Alias
Type
Class
EColi
E. Coli
Update
2. To change information in the Identity section (Name, Alias, Type, and/or Class), edit the
information and choose Update. This will not change the "Id," but will change information
associated with it.
Select Microbe of Concern bdt M::i-.be Iderrtrtyj Edit Microbe Properties
Selected Microbes
Salmonella spp
Identity
Id
Name
Alias
Type
Class
E. Coli
E. Coli
21
-------
3. One way to create and register a new microbe is to select an existing microbe, rename and save
it; the original microbe remains unchanged. To demonstrate, highlight E. coli in Selected
Microbes.
File Help
Select Microbe of Concern [ElWSSbeldertrS j E* Microbe Properties
Selected Microbes
Salmonella spp
Identity
Id
Name
Alias
Type
Class
E Coli
4. Register the GB-124 Bacteroides Phage as an indicator virus. Edit the Identity by changing the
Name to GB-124 and the Alias to Bacteroides Phage. Under Type, click the down arrow and
choose Indicator. Under Class, click the down arrow and choose Virus.
File Help
Select Microbe of Concern EdJ Microbe Idenffly Edit Microbe Properties
Selected Microbes
Salmonella spp
Identity
Id
Name
Alias
Type
Class
Actions
1
GB-124
Bacteroides Phage
Indicator
fiVi
^'
22
-------
5. Under Actions, click New and select GB-124 in Selected Microbes. This will register the new
microbe, assign a new identification (Id) number (i.e., 39), and add the name to Selected
Microbes. Select new microbe GB-124 in Selected Microbes, and its information appears under
Identity.
V Mkrabial Database
File Help
Select Microbe of Concern EdJ Microbe Identity Edl Microbe Properties
Selected Microbes
Salmonella spp
E. Coli
Identity
Id
Name
Alias
Type
Class
Bacteroides Phage
Update
Indicator
Virus
6. To verify that the new microbe has been added to the Search list, return to the Select Microbe
of Concern tab, and GB-124 will appear in Search Results and Selected Microbes.
File Help
[^S^ESr*;^..?0™"!: Edl Microbe Identty Edit Microbe Properties
Search Criteria
D Name
Ecoli
n Microbe Type | Pathogen
n Microbe Class Bacteria
Search Results
Clostridium perfringens
Fecal Coliforms
Bacteroides
Salmonella spp
Campylobacterspp
E. coli 01S7:H7
Listeria
Mycobacterium avium paratuberculosis
Cn/ptosporidium parvum
Giardia lamblia
Toxoplasma gondii
Enlerovirus
Rotavirus
Adenovirus
Norovirus
GB-124
Search
Clear
Selected Microbes
23
-------
7. To delete a microbe, go to the Edit Microbe Identify tab, choose the microbe in Selected
Microbes, and click Delete under Actions, as illustrated with GB-124 in the screen capture
below.
tjf Microbial Database
File Help
Select Microbe of Concern \ Edit Microbe Identity I Edit Microbe Properties
Selected Microbes
Salmonella spp
E. Coli
Identity
Id
Name
Alias
Type
Class
Actions
•-'
GB-124
Bacteroides Phage
Indicator
Virus
File Help
Select Microbe of Concern
Selected Microbes
;r.?s!*£ Edit Microbe Properties
Salmonella spp
Identity
Id
Name
Alias
Type
Class
E.Coli
E. Coli
Actions
Indicator »
Bacteria »
24
-------
8. To verify that the new microbe has been removed from the Search list, return to the Select
Microbe of Concern tab, and GB-124 should be gone.
4jf. Microbial Database
File Help
^^^^^m
|.0.| a |B
-&-.!
Select Microbe of Concern [Edit Microbe Identity | Edit Microbe Properties |
D Name
D Microbe Type
Search Results
E. coli
Pathogen
D a ctena
Enterococci
ClostridJum perfringens
Fecal Coliforms
Bacteroides
Salmonella spp
Campylobacterspp
E.coliQ157:H7
Listens
Mycobaclerium avium paratuberculosis
Cryptosporidium parvum
Giardia lamblia
Toxoplasma gondii
Enterovirus
Rota virus
Adenovirus
Norovirus
.
I >:> !
. .
I ^ I
Selected K
lie
Search
obes
25
-------
EDIT MICROBIAL PROPERTIES
This section describes how a user edits microbial properties.
1. To view a list of parameters registered with the database and to edit or assign values and
references to them, click on the Edit Microbe Properties tab, and the following screen appears.
File Help
Select Microbe of Concern Edit Microbe Identity Edit Microbe Properties |
a Property AlphaM
B Indices [ManureForm]
Solid
2. Click Property under Edit Microbe Properties, and choose the down arrow beside the Property
text box.
File Help
Select Microbe of Concern Edit Microbe Idently Eds Microbe Propeitie:
C Indices [ManureForm]
ManureForm Solid
26
-------
3. A list of parameters registered in the database will appear in alphabetical order.
V^ Microbial Database
File Help
Select Microbe of Concern \&SL Microbe IdertSy j Ed! Microbe Propel
••• Property [AlphaM
Indices
ManureF
Bman
ExchangeDepth
AnimalConcMass
AnimalShedRateMass
AttachRate
BetaPoissonConst
BetaPoissonExp
Bman
BuiltUpRate
DetachRate
DieOffManure
DieOffMedium
DieOffTempCorr
ExcbsngeDepth
Excretion Density
ExcretionDensitySuperShedder
ExpoDoseRespConst
FastDieOffManure
GompertzLogFirstConst
GompertzLogSecondConst
HypergeometricFirstConst
HypergeometricSecondConst
IndicatorPathogen
lnfect_asymtomatic
lnfect_endemic
Infectjncubation
lnfect_p_to_p
lnfect_reinfect
lnfect_response
lnfect_symtomatic
InfilFracKf
4. This list is consistent with information in Tables 1, 2 and 3. By choosing a parameter such as
WildLifeDensity, indices (LandUseName and WildlifeName) and their corresponding choices
(Cropland and Duck, respectively) are identified. Additional metadata are provided in the lower-
most box, including Name (Label), Description, Value, Units and Reference.
a_ Microbial Database
- ! '°<
Help
Select Microbe of Concern Edit Microbe Identity Edit Microbe Properties
-
[LandUseName] [WildLifeName]
LandUseName
WildLifeName
Cropland
Duck
WildUfeDensty TyplcaJ number of »...
27
-------
5. The user can choose an index under Indices. In this example, LandUseName and WildlifeName
are indices for WildLifeDensity (i.e., WildLifeDensity is a function of the two parameters). The
user can view choices under Indices by using down arrow beside the listed indices. In the
example below, WildLifeDensity indices chosen are Cropland for LandUseName, and Deer for
WildLifeName.
Select Microbe of Concern EdJ Microbe Identity Edt Microbe Properties
Properties
•« Property WildLifeDensity
Indices
6. By choosing the parameter and its indices, the user can view or edit the values and references
associated with these choices, as illustrated below where value and reference have yet to be
defined.
? Microbial Database
File Help
Seled Microbe of Concern | Edit Microbe Identity Ed« Microbe Properties
a Property WildLifeDensity
Indices
tandUseName] [WildLifeName]
Cropland
LandUseName
WildLifeName JDeer
I Label
Typical number of «rid .
Range: 0 to 1E+3S
28
-------
7. To add or edit a value, the user left-clicks on the Value text box and enters the number. Note
that the allowable range (minimum and maximum) is provided in the lower left corner.
Select Microbe of Concern Ed* Microbe Identty EdJ Micrabe Properties
« Property WildLifeDensity
Indices
[LandUseName] [WildLifeNam
LandUseName
WildLifeName
8. Here, enter 0.008.
Select Microbe of Concern Edit Microbe Identity Edit Microbe Properties
Property WildLifeDensity
Indices
29
-------
9. If the value is within the range, the box will turn green when it is reselected.
File Help
Select Microbe of Concern | Edit Microbe Identity] Edl Microbe Properties
Property WildLifeDensity
Indices [LandUseName] [WildLifeName]
LandUseName
WildLifeName
[cropland
Deer
Range: 0 to 1E*38
10. If the value is out of range (e.g., -0.008), the box will turn red when it is reselected.
File Help
Select Microbe of Concern Ed« Microbe Identity Edit Microbe Properties
<«• Property [wildLifeDensity^
Indices [ [LandUseName[ [WildLifeName]
LandUseName
WildLifeName
[Cropland
Deer
Range: 0 to 1E*38
30
-------
11. Adding references can be executed in a manner very similar to adding values to parameters.
Double-click on the Reference box.
File Help
Select Microbe of Concern Edit Microbe Identity &tt Microbe Properties
* Property [wildLifeDensity
! indices [ [LandUseName] [WildLifeName]
LandUseName
WildLifeName
Cropland
Deer
Range: 0 to 1E+38
12. The following screen appears. The Edit button is grayed out since there is no reference to edit.
31
-------
13. The Reference screen is designed for two functions, so one must be careful not to confuse them:
a. Add the reference to the database reference list. This functionality allows the user to
add all references to the database reference list at one sitting versus having to add and
assign a reference to a value each time.
b. Assign the reference to the value of the parameter. Once the reference is registered, it
can easily be assigned to the value of a parameter.
14. In this example, we will add three references to the reference list:
EPA (U.S. Environmental Protection Agency), 2013b. BASINS/HSPF Training, Exercise 10 - Bacterial and
temperature modeling. http://water.epa.gov/scitech/datait/models/basins/upload/Exercise-10-
Bacteria-and-Temperature.pdf (last accessed 23.02.14.).
EPA (U.S. Environmental Protection Agency), 2013c. BASINS user information and guidance, BASINS
tutorials and training, http://water.epa.gov/scitech/datait/models/basins/userinfo.cfmfttutorials (last
accessed 23.02.14.).
Bradford, S.A., Schijven, J.F., 2002. Release of Cryptosporidium and Giardia from dairy calf manure:
Impact of solution salinity. Environ. Sci. Technol. 36(18), 3916-3923. DOI: 10.1021/es025573l.
15. To add the first reference, click New.
References
Id:
Label: No Value
No Value
Search for Label: |
ID Label
Description
32
-------
16. Paste the first reference into the large text box, and add the Label "EPA (2013b)" to its right
(under Id). Depending on the operating system, you may need to paste using "Cntl v". NOTE: If
you have the same Label as one already registered or if the reference is too long, you may
receive a "Try again" message.
Id:
Label:
EPA(2013b)
EPA (U.S. Environmental Protection Agency},
2013b. BASINS/HSPF Training, Exercise 10 -
Bacterial and temperature modeling.
http://water.epa.gQv/scitech/datait/model5/b35in '
s/upload/Exercise-lO-Bacteria-and-
Searoh for Label:
17. Click Save to register the reference in the database under "Id:" as 1. The reference is added to
the lowest text box. By clicking on the reference (highlighted in blue), the Id, label, and
reference appear in upper text boxes. Since this is the first reference, it is assigned "1." By
hovering over the reference description, the reference will also appear as a note. NOTE: Once a
reference is added to the database using Save, the addition is permanent to the database,
even if you Exit the database editor without using Save; no parameter value will be saved,
however.
EPA (U.S. Environmental Protection Agency),
2013b. BASINS/HSPF Training, Exercise 10 -
Bacterial and temperature modeling.
http://w3ter.epa.gov/5citech/datait/model5/ba5in
s/upload/Exercise-lO-Bacteris-and-
Searcti for Label:
ID
Label Description
0 1 No Value
No Value
-
33
-------
18. To add the second reference, click New and repeat the process. A unique ID (i.e., 2) is assigned.
Id:
Label:
EPA (2013c)
EPA (U.S. Environmental Protection Agency), 2013C.
BASINS user information and guidance, BASINS
tutorials and training.
http://water.epa.BQV/scitech/datait/models/basins/ii
serinfo.cfmttutorials (last accessed 23.02.14.).
Search for Label:
19. To add the third reference, click New and repeat the process. A unique ID (i.e., 3) is assigned.
Label:
Bradford and Schijven (2002)
Bradford, S.A., Schijven, J.F., 2002. Release of
Cryptosporidium and Giardia from dairy calf manure:
Impact of solution salinity. Environ. Sci. Technol. 35
(IS), 3916-3923. DOI: 10.1021/650255731.
34
-------
20. To search for a particular reference, use Search for Label where all references that match the
"Search for a Label" entry will be listed. To search all reference labels containing "EPA," type
"EPA" and Find, as illustrated by the screen capture below.
Id:
Label:
''•:
EPA (U.S. Environmental Protection Agency),
2013b. BASINS/HSPFTraining, Exercise 10-
Bacterial and temperature modeling.
http://water.eoa.gov/5citech /data it/ mode Is/basin
s/upi pad/Exercise-10-Bacteria-and-
I Search for Label:
EPA (U.S. Environmental Protection Agency), 2013c. BASL
21. To capture the correct reference and assign it to the value in the database, the reference MUST
be highlighted [see example below for EPA (2013c)], since only the highlighted reference is
assigned. NOTE: When adding references to the database reference list, only one reference
can be assigned to each parameter's value. After highlighting the EPA (2013c) reference,
choose Assign Reference to assign the value. Users then return to the previous screen (Edit
Microbe Properties) where the reference ID is automatically assigned to the value.
I EPA (2013c)
EPA (U.S. Environmental Protection Agency), 2013C.
BASINS user information and guidance, BASINS
tutorials and training.
http://water.epa.gOV/5citech/datait/model5/ba5ns/j
serinfo.cfmMutorials (last accessed 23.02.14.).
Search for Label:
EPA
Description
EFA(2C13b>
EPA (U.S. Environmental Protection Agency), 2013b. BASI...
35
-------
Select Microbe of Concern Edit Microbe Identity Eda Microbe Pnjperti
a Property WildLifeDensity
Indices [LandUseName] [WildLifeName]
22. If Close is chosen instead, no new reference will be assigned to the value. Upon returning to the
previous screen (Edit Microbe Properties), the reference ID will not have changed.
EPA (2013c)
EPA (U.S. Environmental Protection Agency), 2013c.
BASINS user information and guidance, BASINS
tutorials and training.
serinfQ.cfmtttutQrials (last accessed 23.02.14.).
Search for Label: EPA
dose
Label
EPA (2013b)
EPA (2013c)
Description
EPA (U.S. Environmental Protection Agency). 2013b. BASL
EPA (U.S. Environmental Protection Agency). 2013c. BASL.
36
-------
23. Parameters can also be sorted by Indices. By checking Indices and the down arrow, the user can
sort parameters by one or more indices associated with the database. For example, choose
[MicrobeName][DomesticAnimalName][ManureForm].
File Help
Select Microbe of Concern Edl Microbe Identity ' Ed* Microbe Properties
' Property I DieOflManure
VlicrobeName] [DomesticAn
, . [DomesticAnimalName'
Mlcrober [ManureForm]
Domestic [MlcrobeName]
[LandUseName] [WildLifeName
ManureF [Mic
[Mic
[Mic
obeName] [DomesticAnimalName^
SbwDieOff Manure
obeName] [ManureForm"
obeName] [MedmmName
obeName] [WiidLifeNami
obeName] [LandUseName] [UrbanizedName^
obeName] [MediumName] [ManureForm
Slow phase (dark) micr
24. Three parameters are listed as functions of the three indices. Values and references can be
added credited similarly to previous instructions.
V Mkrobial Database
. I B
File Help
Select Microbe of Concern Ed* Microbe Identity Edit Microbe Properties
' Property DieOftWanure
9 Indices | [MicrobeName] [DomesticAnimalName] [ManureForm]
MicrobeName
E. Coll
DornesticAnimalName |DairyCow
ManureForm
Solid
FastDieOffManuns
SlowDieOff Manure
37
-------
DISCLAIMER
This document has been reviewed in accordance with U.S. Environmental Protection Agency policy and
approved for publication.
REFERENCES
Bicknell, B.R., Imhoff, J.C., Kittle, J.L, Donigian, A.S., Jr., Johanson, R.C., 1997. Hydrological simulation
program - FORTRAN, user's manual for version 11. EPA/600/R-97/080, U.S. Environmental Protection
Agency, Athens, GA, 755 p.
Blaustein, R., Pachepsky, Y., Hill, R.L, Shelton, D.R., Whelan, G. 2013. E. coli Survival in Waters:
Temperature Dependence. Water Res, 47(2):569-578.
Bradford, S.A., Schijven, J.F., 2002. Release of Cryptosporidium and Giardia from dairy calf manure:
Impact of solution salinity. Environ. Sci. Technol. 36(18):3916-3923.
Calderon, R., Mood, E., Dufour, A., 1991. Health effects of swimmers and nonpoint sources of
contaminated water. Int. J. Environ. Health Res. 1, 21-31.
Colford Jr., J.M., Schiff, K.C., Griffith, J.F., Yau, V., Arnold, B.F.,Wright, C.C., Gruber, J.S., Wade, T.J.,
Burns, S., Hayes, J., McGee, C, Gold, M., Cao, Y., Noble, R.T., Haugland, R., Weisberg, S.B., 2012. Using
rapid indicators for Enterococcus to assess the risk of illness after exposure to urban runoff
contaminated marine water. Water Res. 46 (7), 2176-2186.
EPA (U.S. Environmental Protection Agency), 2013b. BASINS/HSPF Training, Exercise 10 - Bacterial and
temperature modeling. http://water.epa.gov/scitech/datait/models/basins/upload/Exercise-10-
Bacteria-and-Temperature.pdf (last accessed 23.02.14.).
EPA (U.S. Environmental Protection Agency), 2013c. BASINS user information and guidance, BASINS
tutorials and training, http://water.epa.gov/scitech/datait/models/basins/userinfo.cfmfttutorials (last
accessed 23.02.14.).
Guber, A.K., Pachepsky, Y.A., Yakirevich, A.M., Shelton, D.R., Sadeghi, A.M., Goodrich, D.C., Unkrich, C.L.,
2010. STWIR, a microorganism transport with infiltration and runoff add-on module for the KINEROS2
runoff and erosion model documentation and user manual. U.S. Department of Agriculture, ARS.
Guber, A.K., Pachepsky, Y.A., Dao, T.H., Shelton, D.R., Sadeghi, A.M., 2013. Evaluating manure release
parameters for nonpoint contaminant transport model KINEROS2/STWIR. Ecol. Model. 263:126-138.
DOI: 10.1016/j.ecolmodel. 2013.05.008.
Haas, C.N., Rose, J.B., Gerba, C.P., 1999. Quantitative microbial risk assessment. John Wiley & Sons, Inc.
New York. 449 p.
38
-------
Haile, R.W., Witte, J.S., Gold, M., Cressey, R., McGee, C., Millikan, R.C., Glasser, A., Harawa, N., Ervin, C,
Harmon, P., Harper, J., Dermand, J., Alamillo, J., Barrett, K., Nides, M., Wang, G.Y., 1999. The health
effects of swimming in ocean water contaminated by storm drain runoff. Epidemiology, 10 (4), 355-363.
Hunter, P.R., Payment, P., Ashbolt, N., Bartram, J., 2003. Assessment of risk. In: Ronchi, E., Bartram, J.
(Eds.), Assessing Microbial Safety of Drinking Water: Improving Approaches and Methods. OECD/WHO,
Paris, pp. 79-109. OECD/WHO guidance document (Chapter 3).
Kim, K., Whelan, G., Molina, M., Purucker, ST., Pachepsky, Y., Guber, A., Cyterski, M., Ravenscroft, J.,
Franklin, D., 2015. Rainfall-induced release of microbes from manure: model development, parameter
estimation, and uncertainty evaluation on small plots. Appl Environ Microb (submitted)
Laniak, G.F., Olchin, G., Goodall, J., Voinov, A., Hill, M., Glynn, P., Whelan, G., Geller, G., Quinn, N., Blind,
M., Peckham, S., Reaney, S., Gaber, N., Kennedy, R., Hughes, A. 2013. Integrated Environmental
Modeling: A Vision and Roadmap for the Future. Environ Modell Softw, 39:3-23.
Pachepsky, L.B., Roberts, R.T., Sadeghi, A.M., Pachepsky, Y.A., Shelton, D.R. 2010. Database on
inactivation of microorganisms in environmental media. U.S. Department of Agriculture, Agricultural
Research Service, Environmental Microbial and Food Safety Laboratory and Hydrology and Remote
Sensing Laboratory, Beltsville, MD (Beta version).
Seller, J.A., Seto, E., Olivieri, A.W., 2008. Microbial risk assessment interface tool: User documentation.
Water Environmental Research Foundation, Alexandria, VA.
Seller, J.A., Olivieri, A.W., Eisenberg, J.N.S., Sakaji, R., Danielson, R., 2004. Evaluation of microbial risk
assessment techniques and applications. OO-PUM-3. Water Environmental Research Foundation,
Alexandria, VA.
Whelan, G., Kim, K., Pelton, M.A., Seller, J.A., Castleton, K.A., Molina, M., Pachepsky, Y., Ravenscroft, J.,
Zepp, R. 2014a. An Integrated Environmental Modeling Framework for Performing Quantitative
Microbial Risk Assessments. Environ Modell Softw, 55:77-91.
Whelan, G., Kim, K., Pelton, M.A., Castleton, K.J., Laniak, G.F., Wolfe, K., Parmar, R., Galvin, M.,
Babindreier, J. 2014b. Design of a Component-based Integrated Environmental Modeling Framework.
Environ Modell Softw, 55:1-24.
39
------- |