Leah Walker

1
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

2
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.

3
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.

4
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

5
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.

6
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

7
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
  Non-community water systems
• Submittal of assessments done by other methods
  (includes surface water sources)

8
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.

9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
Click to produce general status reports
Click to obtain an update file. Only available
to DHS and LPA counties with FTP.
13
(No Transcript)
14
(No Transcript)
15
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.

16
Task Status
17
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
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
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)
24
Enter the pumping rate in the units you prefer to
use. Note that TurboSWAP calculates the
equivalent pumping rate in the other units.
25
(No Transcript)
26
(No Transcript)
27
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.
28
(No Transcript)
29
An example of the Delineation report
30
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 wont demonstrate the PBE section, but will
  show you the summary screen.

31
(No Transcript)
32
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.

33
(No Transcript)
34
This is only one checklist. Enter Y, N, or U in
each zone for each PCA.
35
This is one page of the PCA Inventory report
36
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

37
(No Transcript)
38
(No Transcript)
39
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.

40
(No Transcript)
41
Example Title Page
42
Example Assessment Summary
43
Example Vulnerability Summary
44
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

45
(No Transcript)
46
TurboSWAP Availability

• TurboSWAP is available to water systems that meet
  the following criteria
• Medium and large water systems (gt 200 service
  connections)
• 3 or more sources
• System must have adequate hardware and IT
  capability
• (Systems that dont 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

47
Want More Information?

• Check out the DHS website regularly
• http//www.dhs.cahwnet.gov/ps/ddwem
• Contact
• Leah Walker 707-576-2295
• e-mail lwalker2_at_dhs.ca.gov