Section Drinking Water Watch SDWIS STATE Website

Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B CONTENTS 11.0 DRINKING WATER WATCH ...................................................................... 11-1 11.1 Terminology................................................................................................... 11-1 11.2 Drinking Water Watch Page Flow ................................................................. 11-1 EXHIBITS Exhibit 11-1. Public Water Supply Systems Search .................................................... 11-2 Exhibit 11-2. Water Systems List ................................................................................ 11-6 Exhibit 11-3. Water System Details Page .................................................................... 11-7 Exhibit 11-4. Water System Facilities List .................................................................. 11-9 Exhibit 11-5. Water System Facility Detail Page ...................................................... 11-10 Exhibit 11-6. Summarized Field Sample Results List ............................................... 11-11 Exhibit 11-7. Facility Analyte Level List .................................................................. 11-11 Exhibit 11-8. Sample Schedule List ........................................................................... 11-12 Exhibit 11-9. Coliform Sample Results List (For Selected Water System)............... 11-13 Exhibit 11-10. Coliform Sample Summary Results List (For Selected Water System) ........................................................................................................... 11-14 Exhibit 11-11. Lead and Copper Sample Results List (For Selected Water System) ........................................................................................................... 11-15 Exhibit 11-12. Non-Coliform Samples List (For Selected Water System)................ 11-16 Exhibit 11-13. Non-Coliform Samples Results List (For Selected Sample) ............. 11-17 Exhibit 11-14. Analyte Selection List ........................................................................ 11-18 Exhibit 11-15. Violations Page (For Selected Water System) ................................... 11-19 Exhibit 11-16. Analytes in Analyte Group Page........................................................ 11-20 Exhibit 11-17. Violation Detail Page ......................................................................... 11-21 Exhibit 11-18. Site Visits List .................................................................................... 11-22 Exhibit 11-19. Milestones List ................................................................................... 11-23 Exhibit 11-20. Coliform Sample Results List ............................................................ 11-24 Exhibit 11-21. Coliform Sample Summary Results List ........................................... 11-25 Exhibit 11-22. Lead and Copper Sample Summary Results List .............................. 11-26 Exhibit 11-23. Summarized Field Sample Results List (MDBP Summaries) ........... 11-26 Exhibit 11-24. Non- Coliform Samples List .............................................................. 11-27 Exhibit 11-25. Analyte Selection List ........................................................................ 11-28 Exhibit 11-26. Non-Coliform Sample Results List .................................................... 11-29 11-iii This page is intentionally left blank. Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B 11.0 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) 11.1 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 Entry Fields Refers to objects that appear as push buttons on the page Refers to objects in which data may be entered. 11.2 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. 11-1 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B Exhibit 11-1. Public Water Supply Systems Search Entry Fields: Water System No. The specific Water System No., which consists of the two-character state code plus the sevencharacter 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‘). 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‘). 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. A dropdown list showing the type of water system serving a particular county. Water System types are classified as one of the following: Water System Name Principal County Served Water System Type 11-2 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B    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: 11-3 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B         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 NonColiform 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: 11-4 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B 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       11-5 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B  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-- NonColiform 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 Glossary This will clear all the entry fields on the Search page. Presents the Glossary for this page. 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:  Pressing the Water System No. link displays the Water System Details page (Exhibit 11-3). 11-6 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B Navigation Return Links:     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. Exhibit 11-3. Water System Details Page Presentation Fields 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. Lists the Individuals who are currently active Points of Contact for the Water system. Points of Contact 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) 11-7 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B Service Connections Lists the Service Connection types, meter type, meter size measure, and counts. (B.11.2.b) Lists the active water system facilities designated as a source of water. Lists the Code and Name of the areas served by this water system. Lists the water systems for which this water system currently sells to or purchases from. Sources of Water Service Areas Water Purchases Navigation Forward Links:        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:     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. 11-8 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B Exhibit 11-4. Water System Facilities List Navigation Forward Links: Pressing the WSF State Asgn ID No, link displays the Water System Facility Detail page, Exhibit 11-5. 11-9 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B Exhibit 11-5. Water System Facility Detail Page Navigation Forward Links:   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. 11-10 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B Exhibit 11-6. Summarized Field Sample Results List Exhibit 11-7. Facility Analyte Level List 11-11 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B 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.  Exhibit 11-8. Sample Schedule List 11-12 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B 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. 11-13 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B 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. 11-14 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B 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. 11-15 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B 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 NonColiform Samples Results List for the selected Non- Coliform Sample, Exhibit 13. 11-16 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B 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) 11-17 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B 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. 11-18 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B 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. 11-19 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B Exhibit 11-16. Analytes in Analyte Group Page 11-20 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B Exhibit 11-17. Violation Detail Page This page displays the Violation or Violation Group that you selected on the previous page. 11-21 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B 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. 11-22 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B Exhibit 11-19. Milestones List 11-23 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B Exhibit 11-20. Coliform Sample Results List 11-24 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B Exhibit 11-21. Coliform Sample Summary Results List 11-25 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B Exhibit 11-22. Lead and Copper Sample Summary Results List Exhibit 11-23. Summarized Field Sample Results List (MDBP Summaries) 11-26 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B 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. 11-27 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B Exhibit 11-25. Analyte Selection List Pressing the Analyte Code presents the Non-Coliform Samples List, Exhibit 24. 11-28 Systalex-SDWIS-01-9.d1b July 31, 2007 Chapter 11B 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) 11-29