**CONTENTS**

[**11.0** **Drinking Water Watch 11-1**](#drinking-water-watch)

[11.1 Terminology 11-1](#terminology)

[11.2 Drinking Water Watch Page Flow
11-1](#drinking-water-watch-page-flow)

**EXHIBITS**

[**Exhibit 11-1.** Public Water Supply Systems Search
11-2](#__RefHeading___Toc139351929)

[**Exhibit 11-2.** Water Systems List
11-7](#__RefHeading___Toc139351930)

[**Exhibit 11-3.** Water System Details Page
11-8](#__RefHeading___Toc139351931)

[**Exhibit 11-4.** Water System Facilities List
11-10](#__RefHeading___Toc139351932)

[**Exhibit 11-5.** Water System Facility Detail Page
11-11](#__RefHeading___Toc139351933)

[**Exhibit 11-6.** Summarized Field Sample Results List
11-12](#__RefHeading___Toc139351934)

[**Exhibit 11-7.** Facility Analyte Level List
11-12](#__RefHeading___Toc139351935)

[**Exhibit 11-8.** Sample Schedule List
11-13](#__RefHeading___Toc139351936)

[**Exhibit 11-9.** Coliform Sample Results List (For Selected Water
System) 11-14](#__RefHeading___Toc139351937)

[**Exhibit 11-10.** Coliform Sample Summary Results List (For Selected
Water System) 11-15](#__RefHeading___Toc139351938)

[**Exhibit 11-11.** Lead and Copper Sample Results List (For Selected
Water System) 11-16](#__RefHeading___Toc139351939)

[**Exhibit 11-12.** Non-Coliform Samples List (For Selected Water
System) 11-17](#__RefHeading___Toc139351940)

[**Exhibit 11-13.** Non-Coliform Samples Results List (For Selected
Sample) 11-18](#__RefHeading___Toc139351941)

[**Exhibit 11-14.** Analyte Selection List
11-19](#__RefHeading___Toc139351942)

[**Exhibit 11-15.** Violations Page (For Selected Water System)
11-20](#__RefHeading___Toc139351943)

[**Exhibit 11-16.** Analytes in Analyte Group Page
11-21](#__RefHeading___Toc139351944)

[**Exhibit 11-17.** Violation Detail Page
11-22](#__RefHeading___Toc139351945)

[**Exhibit 11-18.** Site Visits List
11-23](#__RefHeading___Toc139351946)

[**Exhibit 11-19.** Milestones List 11-24](#__RefHeading___Toc139351947)

[**Exhibit 11-20.** Coliform Sample Results List
11-25](#__RefHeading___Toc139351948)

[**Exhibit 11-21.** Coliform Sample Summary Results List
11-26](#__RefHeading___Toc139351949)

[**Exhibit 11-22.** Lead and Copper Sample Summary Results List
11-27](#__RefHeading___Toc139351950)

[**Exhibit 11-23.** Summarized Field Sample Results List (MDBP
Summaries) 11-28](#__RefHeading___Toc139351951)

[**Exhibit 11-24.** Non- Coliform Samples List
11-28](#__RefHeading___Toc139351952)

[**Exhibit 11-25.** Analyte Selection List
11-29](#__RefHeading___Toc139351953)

[**Exhibit 11-26.** Non-Coliform Sample Results List
11-30](#__RefHeading___Toc139351954)

This page is intentionally left blank.

# Drinking Water Watch

Drinking Water Watch (DWW) was originally delivered as a method to allow
the public access via the Internet to drinking water information under
the Freedom of Information Act (FOIA). A drinking water primacy agency
may deploy Drinking Water Watch inside or outside of its electronic
firewall protection, so access to this application entirely depends on
the environment in which it is deployed.

The URL invoked via the link from the *SDWIS/STATE Home Page* may be
implemented to access an instance of DWW deployed on the Internet or an
internal instance of DWW deployed on the intranet. The decision to as to
whom to make available the DWW web pages lies with the System
Administrator.

During installation of the SDWIS/STATE application, the installer will
be prompted for the DWW URL to be launched from the *SDWIS/STATE Home
Page*. During installation, the user will need to set the two-character
state code and state name in the properties file. (Instructions for this
will be in the Release Notes.) After the user performs these settings,
the user's state's name will appear on the link "Click here for the
County Map of \_\_\_\_\_" on the Home Page, and the user will be able to
retrieve the state map and use it as search criteria.

Appendix G contains the detailed SQL queries that support each web page.

DWW 2.0 will be changed to use a JDBC database connection, replacing the
prior implementations use of ODBC. (R0131:A.11.0.a)

## Terminology

This document contains the new term "Navigations" when describing the
pages. The term navigations refers to data on the page which users may
click to present another page. This is similar to a double-click of a
list item in the SDWIS/STATE application. Other terms, which may be
familiar, are:

-   Buttons Refers to objects that appear as push buttons on the page

-   Entry Fields Refers to objects in which data may be entered.

## Drinking Water Watch Page Flow

The following pages and exhibits describe/document the forward flow of
the links in Drinking Water Watch 1.2. Exhibit 11-1 depicts the Public
Water Supply Systems Search Parameters page.

![](media/image1.png){width="5.989583333333333in"
height="3.717361111111111in"}

[]{#__RefHeading___Toc139351929 .anchor}**Exhibit 11-1.** Public Water
Supply Systems Search

[Entry Fields:]{.underline}

*Water System No.* The specific Water System No., which consists of the
two-character state code plus the seven-character number field. The
Water System No. field can accept partial strings (e.g., 'IN1' will list
all the water systems starting with the Water System No.'s 'IN1').

*Water System Name* The Name of the Water System, which is an
alphanumeric field. The Water System Name field can accept partial
strings (e.g., 'a' will list all the water systems starting with the
letter 'a').

*Principal County Served* A dropdown list showing the county principally
served by the public water system. This field will display values in the
SDWIS/STATE's Geographic Area table (TINGEOAR) where field Type Code =
CN.

*Water System Type* A dropdown list showing the type of water system
serving a particular county. Water System types are classified as one of
the following:

-   *Community -* Serves at least 15 service connections used by
    year-round residents or regularly serves 25 year-round residents.

-   *Non-Transient Non-Community* -- Serves at least the same 25
    non-residential individuals during 6 months of the year.

-   *Transient Non-Community* -- Regularly serves at least 25
    non-residential individuals (transient) during 60 or more days a
    year.

*Primary Source Water Type* A dropdown list categorizing the primary
water source for the public water system. The source of water determines
treatment requirements or other standards. Primary sources include the
following:

-   *Groundwater under the Direct Influence (of surface water)*

-   *Groundwater under the Direct Influence (of surface water),
    Purchased Water*

-   *Groundwater*

-   *Groundwater Purchased*

-   *Surface Water*

-   *Surface Water Purchased*

*Point of Contact Type* A dropdown list showing the types of contacts
applying to the active Point-of Contact that, when selected, displays
the address information (for the selected point of contact type) on the
Water System List. Point-of Contact Types including the following:

-   Administrative

-   Emergency Contact

-   Lead Engineer

-   Operator

-   Designated Op in Charge

-   Financial

-   Legal

-   Owner

-   Sampling

-   All of the Above

*Sample Class* A dropdown list showing the sample classes from which the
user may select:

-   Coliform Samples -- to display Coliform Sample Results
    (samples/results whose Analyte Code is 3100, 3013, or 3014 and meet
    any other Water System selection criteria).

-   Coliform Samples Detection Only -- to display Coliform Sample
    Results (samples/ results whose Analyte Code is 3100, 3013, or 3014
    and where Presence/Absence Indicator is P and meet any other Water
    System selection criteria).

-   Coliform Summaries -- to display Coliform Sample Summaries (sample
    summaries whose Analyte Code is 3100 and meet any other Water System
    selection criteria).

-   Lead and Copper Summaries -- to display Lead and Copper Sample
    Summaries (sample summaries whose Analyte Code is PB90 or CU90 and
    meet any other Water System selection criteria).

-   Summarized Field Sample Results -- to display MDBP Summaries (MDPB
    summaries that meet any other Water System selection criteria).

-   Non- Coliform Samples All -- to display Non- Coliform Samples
    (samples/results whose Analyte Code is not (3100, 3013, or 3014) and
    that meet any other Water System selection criteria.

-   Non- Coliform Samples by Analyte -- to display list of all
    non-Coliform analytes that are referenced by any non-Coliform sample
    result (excluding those where Analyte Code is 3100, 3013, or 3014)
    in the database and that meet any other Water System selection
    criteria.

-   Non- Coliform Samples Detection Only\-- to display list of
    samples/results whose Analyte Code is not (3100, 3013, or 3014) and
    whose Result Concentration is \>0 and meet any other Water System
    selection criteria.

*Sample Collection Date Range*

Date range user can specify within which the Sample Collection Date must
fall or within which the Summary's Monitoring Period Start Date must
fall. Supplying no data in these fields results in the last two years of
samples or summaries being displayed.

[Buttons]{.underline}:

**Search for Water Systems** Entering criteria in one or more of the six
Public Water Supply systems Search Parameters presents the Water Systems
page (Exhibit 11-2). If the user selects a Point of Contact Type, the
Water Systems page will include an Address column with the address of
the Administrative Point of Contact (type AC). Selecting a Point of
Contact Type does not constrain the list of water systems presented; it
just adds the Address column.

**Search for Samples** Selecting a Sample Class presents an appropriate
list:

-   Coliform Samples -- Coliform Sample Results List, Exhibit 11-20,
    listing samples/results whose Analyte Code is 3100, 3013, or 3014
    and meet any other selection criteria.

-   Coliform Samples Detection Only -- Coliform Sample Results List,
    Exhibit 11-20, listing samples/ results whose Analyte Code is 3100,
    3013, or 3014 and where Presence/Absence Indicator is P and meet any
    other selection criteria. (Exhibit 11-20 shows a mix of results with
    presence and absence; this selection would only return results
    showing "P"---no "A" results would be included).

-   Coliform Summaries -- Coliform Sample Summaries Results List,
    Exhibit 11-21, listing sample summaries whose Analyte Code is 3100
    and meet any other selection criteria.

-   Lead and Copper Summaries -- Lead and Copper Sample Summary Results
    List, Exhibit 11-22, listing sample summaries whose Analyte Code is
    PB90 or CU90 and meet any other selection criteria.

-   Summarized Field Sample Results -- Summarized Field Sample Results
    List, Exhibit 11-23, listing MDPB summaries that meet any other
    selection criteria.

-   Non- Coliform Samples All -- Non-Coliform Samples List, Exhibit
    11-24, listing samples/results whose Analyte Code is not (3100,
    3013, or 3014) and that meet any other selection criteria.

-   Non- Coliform Samples by Analyte. -- Analyte Selection List, Exhibit
    11-25. This is the list of all non-Coliform analytes that are
    referenced by any non-Coliform sample result (excluding those where
    Analyte Code is 3100, 3013, or 3014) in the database and that meet
    any other selection criteria. If the analyte does not appear on this
    list, no sample results for that analyte for the criteria specified
    exist in the database.

-   Non- Coliform Samples Detection Only\-- Non-Coliform Samples List,
    Exhibit 11-24, listing samples/results whose Analyte Code is not
    (3100, 3013, or 3014) and whose Result Concentration is \>0 and meet
    any other selection criteria.

**Clear** This will clear all the entry fields on the Search page.

**Glossary** Presents the Glossary for this page.

![](media/image2.png){width="6.499305555555556in"
height="3.5590277777777777in"}

[]{#__RefHeading___Toc139351930 .anchor}**Exhibit 11-2.** Water Systems
List

If address is displayed, it will contain the administrative point of
contact's Name, Address Line 1, Address Line 2, City, State, Zip, and
Country. The default sort of water systems will be active water systems,
then inactive water systems.

[Navigation Forward Link:]{.underline}

-   Pressing the Water System No. link displays the Water System Details
    page (Exhibit 11-3).

[Navigation Return Links:]{.underline}

-   Pressing the Water Systems link returns to the Water System page.

-   Pressing the Water Systems Search returns to the Public Water System
    Search page.

-   Pressing the County Map link returns to the county map page.

-   Pressing Glossary always presents the glossary for this page.

![](media/image3.png){width="5.989583333333333in" height="3.95625in"}

[]{#__RefHeading___Toc139351931 .anchor}**Exhibit 11-3.** Water System
Details Page

[Presentation Fields]{.underline}

*Water System Details* Displays the Water System No., Water System Name,
Principal County Served, \[Activity\] Status, Federal \[PWS\] Type,
State \[PWS\] Type, Primary Source \[of water\], Activity \[Status\]
Date.

*Points of Contact* Lists the Individuals who are currently active
Points of Contact for the Water system.

*Annual Operation Periods &*

*Population Served* Lists the water systems annual operation periods
(AOP) and population served counts for those AOP that are currently
active. (B.11.2.a)

*Service Connections* Lists the Service Connection types, meter type,
meter size measure, and counts. (B.11.2.b)

*Sources of Water* Lists the active water system facilities designated
as a source of water.

*Service Areas* Lists the Code and Name of the areas served by this
water system.

*Water Purchases* Lists the water systems for which this water system
currently sells to or purchases from.

[Navigation Forward Links:]{.underline}

-   Pressing the Water Systems Facilities link displays the Water System
    Facilities List for the selected water system, Exhibit 11-4.

-   Pressing the Sample Schedules link displays the Sample Schedule List
    for the selected water system, Exhibit 11-8.

-   Pressing the Coliform Sample Results link displays the Coliform
    Sample Results List for the selected water system, Exhibit 11-9.

-   Pressing the Coliform Sample Summary Results link displays the
    Coliform Sample Summary Results List for the selected water system,
    Exhibit 11-10.

-   Pressing the Lead and Copper Sample Summary Results link displays
    the Lead and Copper Sample Results List for the selected water
    system, Exhibit 11-11.

-   Pressing the Non- Coliform Samples/Results link displays the
    Non-Coliform Samples List for the selected water system, Exhibit
    11-12.

-   Pressing the Non- Coliform Samples/Results by Analyte link displays
    the Analyte Selection List, Exhibit 11-14. This is the list of all
    non-Coliform analytes that are referenced by any non-Coliform sample
    result that exists for the specified water system. If the analyte
    does not appear on this list, no sample results for that analyte and
    for the specified water system exist in the database.

-   Pressing the Violations/Enforcement Actions link displays the
    Violations Page for the selected water system, Exhibit 11-15.

-   Pressing the Site Visits link displays the Site Visits List for the
    selected water system, Exhibit 11-18.

-   Pressing the Milestones link displays the Milestones List for the
    selected water system, Exhibit 11-19.

[Navigation Return Links:]{.underline}

-   Pressing the Water Systems link returns to the Water System page.

-   Pressing the Water Systems Search returns to the Public Water System
    Search page.

-   Pressing the County Map link returns to the county map page.

-   Pressing Glossary always presents the glossary for this page.

![](media/image4.png){width="5.9944444444444445in"
height="4.354861111111111in"}

[]{#__RefHeading___Toc139351932 .anchor}**Exhibit 11-4.** Water System
Facilities List

[Navigation Forward Links:]{.underline}

Pressing the WSF State Asgn ID No, link displays the Water System
Facility Detail page, Exhibit 11-5.

![](media/image5.png){width="5.990972222222222in" height="4.5375in"}

[]{#__RefHeading___Toc139351933 .anchor}**Exhibit 11-5.** Water System
Facility Detail Page

[Navigation Forward Links:]{.underline}

-   Pressing the Summarized Field Sample Results link displays the
    Summarized Field Sample Results List (list of MDBP Summaries) for
    the selected water system facility, Exhibit 11-6.

-   Pressing the Facility Analyte Level List link displays the Facility
    Analyte Level List for the selected water system facility, Exhibit
    11-7.

![](media/image6.png){width="5.990972222222222in"
height="3.8784722222222223in"}

[]{#__RefHeading___Toc139351934 .anchor}**Exhibit 11-6.** Summarized
Field Sample Results List

![](media/image7.png){width="5.996527777777778in"
height="4.053472222222222in"}

[]{#__RefHeading___Toc139351935 .anchor}**Exhibit 11-7.** Facility
Analyte Level List

Exhibit 11-8 (Sample Schedules) lists four different kinds of schedules
for the water system:

-   TCR Schedules - Open Total Coliform Rule sample schedules for the
    specified water system.

-   Facility Analyte Field Sample Schedules - Open Facility Analyte
    schedules (TMNFANL) for the specified water system.

-   Non- TCR Group Schedules - Open schedule groups that reference
    Analyte Group Codes for the specified water system. Note that you
    may see a schedule for Analyte 3100 listed in this list. If you do,
    while the name of the Analyte says "Total Coliform Rule," the
    schedule is actually for Analyte 3100 (Coliform) being monitored
    under the Groundwater Rule. Pressing the Analyte Group Code link
    displays the Analytes in Analyte Group page, Exhibit 11-16.

-   Non- TCR Individual Schedules - Open individual schedules (those
    defined as not associated with a Schedule Group and that reference
    an Analyte Code, that is, they are not "hidden" schedules). Note
    that you may see a schedule for Analyte 3100 listed as part of a
    non-TCR Analyte Group. If you do, while the name of the Analyte says
    "Total Coliform Rule," the schedule is actually for Analyte 3100
    (Coliform) being monitored under the Groundwater Rule.

![](media/image8.png){width="5.988888888888889in" height="4.16875in"}

[]{#__RefHeading___Toc139351936 .anchor}**Exhibit 11-8.** Sample
Schedule List

![](media/image9.png){width="6.0in" height="4.66875in"}

[]{#__RefHeading___Toc139351937 .anchor}**Exhibit 11-9.** Coliform
Sample Results List (For Selected Water System)

You may further constrain the list of samples retrieved for the water
system by specifying Sample Collection Date range values, within which
the Sample Collection Date must fall.

![](media/image10.png){width="5.99375in" height="4.7625in"}

[]{#__RefHeading___Toc139351938 .anchor}**Exhibit 11-10.** Coliform
Sample Summary Results List (For Selected Water System)

You may further constrain the list of Coliform sample summaries
retrieved for the water system by specifying the Monitoring Period Begin
Date range.

![](media/image11.png){width="5.9944444444444445in"
height="4.354861111111111in"}

[]{#__RefHeading___Toc139351939 .anchor}**Exhibit 11-11.** Lead and
Copper Sample Results List (For Selected Water System)

You may further constrain the list of Lead and Copper sample summaries
retrieved for the water system by specifying the Monitoring Period Begin
Date range.

![](media/image12.png){width="5.998611111111111in"
height="4.673611111111111in"}

[]{#__RefHeading___Toc139351940 .anchor}**Exhibit 11-12.** Non-Coliform
Samples List (For Selected Water System)

You may further constrain the list of samples retrieved for the water
system by specifying Sample Collection Date range values, within which
the Sample Collection Date must fall.

Pressing the Lab Sample No. link in the Lab Sample No. column displays
the Non- Coliform Samples Results List for the selected Non- Coliform
Sample, Exhibit 13.

![](media/image13.png){width="5.99375in" height="4.663888888888889in"}

[]{#__RefHeading___Toc139351941 .anchor}**Exhibit 11-13.** Non-Coliform
Samples Results List (For Selected Sample)

The column \"Method Code\" on this page needs to be expanded to match
the expanded field size in SDWIS/STATE. (R0084:A.11.2.a)

![](media/image14.png){width="5.493055555555555in"
height="3.696527777777778in"}

[]{#__RefHeading___Toc139351942 .anchor}**Exhibit 11-14.** Analyte
Selection List

Pressing the Analyte Code link displays the Non-Coliform Samples List,
Exhibit 11-12, listing those samples for the selected water system that
have sample analytical results that reference the selected analyte code.

![](media/image15.png){width="5.993055555555555in" height="3.6875in"}

[]{#__RefHeading___Toc139351943 .anchor}**Exhibit 11-15.** Violations
Page (For Selected Water System)

This page has changed since *Drinking Water Watch 1.0* for Oracle. This
page lists two different classes of violations for the specified water
system:

-   Group Violations -- Violation groups that reference Analyte Group
    Codes. Pressing the Analyte Group Code link displays the Analytes in
    Analyte Group page, Exhibit 16.

-   Individual Violations --Individual violations (those defined as not
    associated with a Violation Group and that reference an Analyte
    Code, that is, they are not "hidden" violations.)

Pressing Violation No. displays the Violation Detail Page, Exhibit 17.

![](media/image16.png){width="4.291666666666667in" height="3.84375in"}

[]{#__RefHeading___Toc139351944 .anchor}**Exhibit 11-16.** Analytes in
Analyte Group Page

![](media/image17.png){width="5.990277777777778in"
height="4.409722222222222in"}

[]{#__RefHeading___Toc139351945 .anchor}**Exhibit 11-17.** Violation
Detail Page

This page displays the Violation or Violation Group that you selected on
the previous page.

![](media/image18.png){width="5.375694444444444in"
height="4.060416666666667in"}

[]{#__RefHeading___Toc139351946 .anchor}**Exhibit 11-18.** Site Visits
List

You may further constrain the list of Site Visits retrieved for the
water system by specifying a Site Visit Date range.

![](media/image19.png){width="4.98125in" height="3.626388888888889in"}

[]{#__RefHeading___Toc139351947 .anchor}**Exhibit 11-19.** Milestones
List

![](media/image20.png){width="5.75in" height="4.992361111111111in"}

[]{#__RefHeading___Toc139351948 .anchor}**Exhibit 11-20.** Coliform
Sample Results List

![](media/image21.png){width="5.998611111111111in"
height="4.777083333333334in"}

[]{#__RefHeading___Toc139351949 .anchor}**Exhibit 11-21.** Coliform
Sample Summary Results List

![](media/image22.png){width="5.997916666666667in"
height="4.179861111111111in"}

[]{#__RefHeading___Toc139351950 .anchor}**Exhibit 11-22.** Lead and
Copper Sample Summary Results List

![](media/image23.png){width="5.989583333333333in"
height="3.8201388888888888in"}

[]{#__RefHeading___Toc139351951 .anchor}**Exhibit 11-23.** Summarized
Field Sample Results List (MDBP Summaries)

![](media/image24.png){width="5.998611111111111in"
height="4.673611111111111in"}

[]{#__RefHeading___Toc139351952 .anchor}**Exhibit 11-24.** Non- Coliform
Samples List

Pressing the Lab Sample No. link displays the Non-Coliform Sample
Results List for the selected Non-Coliform Sample, Exhibit 26.

![](media/image25.png){width="5.9944444444444445in"
height="4.354861111111111in"}

[]{#__RefHeading___Toc139351953 .anchor}**Exhibit 11-25.** Analyte
Selection List

Pressing the Analyte Code presents the Non-Coliform Samples List,
Exhibit 24.

![](media/image26.png){width="5.998611111111111in"
height="4.673611111111111in"}

[]{#__RefHeading___Toc139351954 .anchor}**Exhibit 11-26.** Non-Coliform
Sample Results List

The column \"Method Code\" on this page needs to be expanded to match
the expanded field size in SDWIS/STATE. (R0084:A.11.2.b)