TurboSWAP DHS Welcome to TurboSWAP, the electronic method to

DHS
TurboSWAP
Welcome to TurboSWAP, the electronic
method to Turbocharge your source
water assessments!
Leah Walker
California Department of Health Services
Division of Drinking Water and Environmental Management
October 2001
1
What is TurboSWAP?
• A database application to produce
source water assessment reports
• A quick and easy method to produce
complete, consistent, and
understandable assessments.
– Includes a user friendly interface that
guides the user through the process.
– Includes a function to submit completed
assessments to a centralized database.
2
TurboSWAP Features
• Built-in pick lists of water systems and
drinking water sources customized to
the user. This minimizes data entry
errors.
• Status reports that allow the user to
track progress.
• Function to update the list of systems
and sources.
3
TurboSWAP Development
Developed by:
University of California, Davis
Information Center for the Environment
Under the direction of:
California Department of Health Services
Division of Drinking Water and
Environmental Management
4
TurboSWAP Specifications
• The program was designed in Visual
Fox Pro and stores the data in a
relational database.
• The functions to submit data to
DHS and update systems and
sources from DHS use FTP to
transfer data.
5
TurboSWAP Users
• 21 DHS District Offices
• 34 Local Primacy Agency
Counties
• Water Systems and other
entities by request
(currently 71)
• Statewide Totals:
~ 8,000 water systems
~16,000 active water
sources
6
For What Sources Can
TurboSWAP be used?
• Ground Water sources already in the DHS
inventory
• New sources must be added to the
inventory before TurboSWAP can be used
• Upcoming:
– Reduced assessment option for Transient Noncommunity water systems
– Submittal of assessments done by other
methods (includes surface water sources)
7
TurboSWAP Demo
• The following is a series of slides
that illustrate TurboSWAP data
entry screens and reports.
• To limit the size of this file, only a
few key screens and reports are
shown.
8
9
10
11
Click to produce general
status reports
Click to obtain an update
file. Only available to
DHS and LPA counties
with FTP.
12
13
14
Source Assessment Task Menu
• This screen guides the user through the
assessment tasks.
• Each task has a separate button, which
when selected sends the user to the
appropriate application.
• The Task Menu also records the status of
each task.
15
These three
tasks allow
you to track
the status
of
applications
that are
outside of
TurboSWAP
These buttons are not
available until you have
completed previous
steps
Task
Status
16
Delineation
• This next section
demonstrates the
delineation of
protection zones.
• User answers a series
of questions;
TurboSWAP
determines the
delineation method.
• We will demonstrate
the typical default
Calculated Fixed
Radius method.
Map produced by Mapping Tool
17
Click
here
18
19
20
21
22
Delineation – Size of Zones
After the delineation method is determined,
TurboSWAP prompts the user to enter data to
determine the size of the protection zones.
Map produced by Mapping
Tool (not TurboSWAP)
23
Enter the
pumping
rate in the
units you
prefer to
use.
Note that
TurboSWAP
calculates
the
equivalent
pumping
rate in the
other units.
24
25
26
This shows the
Calculated Fixed
Radius equation.
No data entry is
required on this
screen, but it
illustrates how
the sizes of the
zones are
determined.
27
28
An example of
the Delineation
report
29
Physical Barrier
Effectiveness
• Physical Barrier Effectiveness (PBE) is an indication of the
ability of the source and its setting to prevent the
movement of contaminants to the drinking water supply.
• PBE is determined using site-specific information on the
aquifer and on the operation and construction of the source.
• PBE analysis points are based on responses. The points are
totaled and a PBE rating is assigned. The maximum number
of points a source can receive is 100.
• Qualitative rating of Low, Moderate or High PBE determined
for each source.
• We won’t demonstrate the PBE section, but will show you the
summary screen.
30
31
Inventory of Possible
Contaminating Activities
• The next task is the inventory of Possible Contaminating
Activities (PCAs) within the delineated zones.
• PCAs are activities, businesses, or land uses considered to
be potential origins of contamination to a drinking water
supply. TurboSWAP includes over 100 types of PCAs
separated into four lists.
• PCA inventory is a ‘presence-absence’ review of whether a
type of PCA exists within a protection zone. The review
does not identify the number of facilities or the exact
locations of the facilities.
• All sources are required to have the “Other” checklist
completed for an assessment; the remaining checklists are
optional, but encouraged.
32
Important
time saving
buttons!
33
This is only one checklist. Enter Y, N, or U in each zone for each PCA.
34
This is one
page of the
PCA Inventory
report
35
Vulnerability Ranking
• Prioritized list of PCAs in order to determine the
PCAs to which the source is most vulnerable
• Assign points based on the risk ranking of the
PCA, the zone in which it occurs, and the PBE
• Add points and prioritize PCAs from highest to
lowest points
• Source is most vulnerable to PCAs with the
highest vulnerability points, AND to PCAs
associated with a detected contaminant,
regardless of the vulnerability points
• Vulnerability ranking automated in TurboSWAP
based on Delineation, PBE, and PCA Inventory
36
This
button is
now
available
37
38
Vulnerability and
Assessment Summaries
• Very Special feature of TurboSWAP
• User enters summary information, water system
description, assessment procedures, etc.
• The summary information is compiled to produce:
– Title page
– Assessment summary
– Vulnerability summary information for CCR
• When completed, TurboSWAP produces an
assessment report with 8 to 17 pages, without a
map.
39
This
button is
now
available
40
Example Title
Page
41
Example
Assessment
Summary
42
Example
Vulnerability
Summary
43
Sending TurboSWAP Data
• After assessment completed, user clicks a
button and sends the data to DHS (via UCD)
• Requires an Internet connection without
interference from firewalls
• User can also attach an assessment map, if the
map is available in digital format
• This allows DHS to:
– Maintain copies of all assessments submitted via
TurboSWAP
– Keep track of completed assessments
– Report on progress to EPA
– Make summary information available to the public
44
This
button is
now
available
45
TurboSWAP Availability
• TurboSWAP is available to water systems that meet
the following criteria:
– Medium and large water systems (> 200 service connections)
– 3 or more sources
– System must have adequate hardware and IT capability
(Systems that don’t meet these criteria require more support
from DHS than it takes to do the assessments ourselves)
• Systems request TurboSWAP through their DHS
district engineers
• Small systems interested in doing assessments can
request assistance from California Rural Water
Association
46
Want More Information?
• Check out the DHS website regularly
– http://www.dhs.cahwnet.gov/ps/ddwem
• Contact:
– Leah Walker 707-576-2295
– e-mail: [email protected]
AWWA Presentation Oct. 2001
47