Wisconsin Department of Natural Resources

Wisconsin DNR Drinking Water data

 

This page provides help for users of the DNR Public Drinking Water System Data website.

 

Topics include:

General Information

Column Visibility

Copy/Download Data

Public Water System Search

Contaminants in Public Systems Search

Bacti Laboratory Search

Plan Review Search

Reports

 

General Information

Select one or more fields to search. Each white box represents a possible entry. After selecting criteria, press enter or click on the Search button to start the query. Pressing Enter may not work with some older browsers.

Perfecting your query:

You may leave all fields blank. However, your search will take longer and will return more results than you probably want. It is best to utilize the fewest number of search fields that will get you your desired results. For open text search fields, the text string you enter will return everything that contains that text from the database and will only return data that exactly matches your text entry. If you want to further refine your search once you see the results, click the back () browser button. If you want to start your query over, use the Clear button.

Paging:

Select the number of rows you wish to view at a time in the Show Entries dropdown list above each table. Clicking Previous, Next or a page number below the table will jump you to that page in the results.

Filtering your results:

You can further refine your results by entering text in the Filter textbox above the table to return only rows that contain that text somewhere in the column data.

Sorting your results:

Clicking on a column heading (the bold type) will toggle between sorting in ascending order, descending order and not sorted. You can sort multiple columns at once by selecting the first column to sort on, then holding the Shift key and selecting the subsequent column headings you wish to sort in the order you want them sorted.

Viewing Detail:

From the results table you can view detail for the record if the row turns turquoise or if the cursor turns into a hand when you hover your cursor over the row. A small window will display telling you what detail you will see if you click. Use the browser back () button to return to the query results.

Public Water System detail: Click on a row in the table to see system detail and buttons for the available Monitoring Schedules and Consumer Confidence Reports (if applicable) at the top. There are several rows of buttons below that you can click to expand to view the detail within. Click on a detail row to drill down to the detail of that row. Use the browser back button () to navigate back to where you were previously.

System detail: Click the + on the row in a Public Water System search to view high level information about the system.

Column Visibility:

For each page and each table showing a set of records, you can click the Column Visibility button located below the table on the left to display the list of all possible data fields to view onscreen. Current display columns show in blue. Click any additional fields youd like to add. Click any columns you wish to remove from the screen by clicking the column again (shown in white). If you Copy or Download the dataset, all columns in the Column Visibility list will be included in your file regardless of what is displayed on the screen.

Copy/Download Data:

There are two options for copying or downloading data from each page and each table of records.

Copy to Clipboard:

This option allows you to save data to the spreadsheet or text editor tool of your choice, such as Microsoft Word, an email, etc. The process can vary slightly to save data depending on what tool you use to save the data.

1.    Click the Copy to Clipboard button. You will see a message indicating that the data above has been copied to your clipboard.

2.    Open the software where you want to place the data.

3.    Choose Paste or Ctrl + P to paste the data.

4.    Save the file and give it a name, if applicable.

Download to Excel/CSV:

This option allows you to save data directly to Microsoft Excel in a comma-delimited format (column data for each row is separated by a comma character).

1.    Click the Download to Excel/CSV button.

2.    A small window will open, typically at the bottom of your screen.

    1. Click Save to save the comma-delimited file to your Downloads folder under This PC. The system will name the file for you.
    2. Click Save As to choose another location to save the comma-delimited file on your computer or a file share. You can rename the file from the default name given, if you choose.
    3. Click Cancel to back out of downloading the file.

3.    If you would like to store the file you created in the typical Excel spreadsheet format (.xlsx), you can open the file you created in Step 2 and click File and Save As and select the .xlsx file type. You will now have two copies of the file in different formats (.csv and .xlsx).

Public Water System (PWS) Search

PWS Name or ID:

The name of the drinking water system or its PWS ID.

PWS Name: You may enter any portion of the name into the search box. No wildcards are necessary to complete the name. This field is not case sensitive (e.g., entering MADISON and madison will return the same results). Do not use quotation marks or other symbols that do not normally appear in the name of the system. Tip: If you are unsure of the spelling or if your query does not return the system and you know it exists, enter a small portion of the name.

PWS ID: The eight-digit number assigned to a system by DNR, which uniquely identifies the public water system. The entire ID must be entered, partial numbers or wildcards will not work with the ID search.

+ Advanced Search:

Click this button to display the additional search criteria below to refine your search.

PWS Type:

The classification of the system based on ownership and population served. If you are unsure of the type after looking at the following list, leave this blank. You can select one or more options from the dropdown list of choices.

Municipal community - a water system owned by a municipality which serves at least 15 service connections used by year-round residents or regularly serves at least 25 year-round residents.

Other than Municipal, community - a water system which is not owned by a municipality which serves at least 15 service connections used by year-round residents or regularly serves at least 25 year-round residents.

Non-transient, non-community - a non-community water system which regularly serves at least 25 of the same persons over 6 months per year. Examples: schools, day care centers and factories.

Transient, non-community - a non-community water system which serves at least 25 people at least 60 days of the year. Examples: taverns, motels, restaurants, churches, campgrounds, and parks.

Status:

The current status of the system and whether it requires safe drinking water monitoring. If you are unsure of the status after looking at the following list, leave this blank. You can select one or more options from the dropdown list of choices.

Active - the water system is in use and safe drinking water monitoring is required.

Inactive - the water system is not currently active, so safe drinking water monitoring is no longer required.

Combined with another system - the water system is no longer required to monitor because it has combined with another system.

Destroyed - the water system has been destroyed/razed, so safe drinking water monitoring is no longer required.

On municipal water - the water system now uses municipal water, so safe drinking water monitoring is no longer required.

New System, not yet serving public - the water system is new so safe drinking water monitoring is not yet required.

Private residence - previously a public water system which now serves only a single-family private residence, so safe drinking water monitoring is no longer required.

Serves less than 25 persons - the water system is not required to monitor because it is not a public system.

Temporarily closed - the system is temporarily closed due to remodeling, for sale, etc., so safe drinking water monitoring is not required at this time.

Duplicate - duplicate of another system with a different public water system ID, so safe drinking water monitoring is no longer required.

 

Region:

The DNR regional area where the system is located. Select one or more options from the dropdown list of choices. If you are unsure in which region the system is located, leave this blank.

County:

The name of the Wisconsin county in which the system is located. Select one or more options from the dropdown list of choices. If you are unsure in which county the system is located, leave this blank.

City:

The city, town or village name where the system is located. You may enter any portion of the name. No wildcards are necessary to complete the name. This field is not case sensitive (e.g., entering FITCHBURG and fitchburg will return the same results). Do not use quotation marks or other symbols that do not normally appear in the name of the system. Tip: If you are unsure of the spelling or if your query does not return the system and you know it exists, enter a small portion of the name such as fitch.

DNR Rep:

The DNR Representative assigned to assist the system with regulations. Select one or more options from the dropdown list of choices.

Provides Water to Another System:

There are two additional options for specifying criteria relative to systems that may provide water to or receive water from another public water system, through a wholesale agreement. To find systems that provide water (wholesalers), select this option.

Receives Water to Another System:

To find systems that receive water (purchasers), select this option.

Checking both boxes will find only those wthat are wholesalers and purchasers.

Contaminants in Public Systems Search

Contaminant:

This is a comprehensive list of contaminants tested for in Public system samples for the Safe Drinking Water Act. Select one or more contaminants.

Select only Detects:

Checking the box will only return samples where the contaminant(s) have been detected. Leaving the box unchecked will return all results for the contaminant(s).

Select only Values Over MCL:

Checking the box will only return samples where the value of the contaminant is greater than its EPA Maximum Contaminant Limit (MCL). Leaving the box unchecked will return all results for the contaminant(s).

Measured Amount:

Set the lower and upper range for the contaminant result. For example, you could put in 10.5 and 20 if you were looking for Nitrate values between those values. Note that this selection rule is not smart enough to convert units, but almost all DNR sample results are in common units for the contaminant. If you wish to check values, do the query without setting levels in this area, and then refine the query with value limits.

PWS Name or ID:

See PWS Name or ID above, in the Public Water System Search

System Type:

See PWS Type above, in the Public Water System Search

DNR Region:

See Region above, in the Public Water System Search

County:

See County above, in the Public Water System Search

Status of the Water Supply System:

See Status above, in the Public Water System Search

Status of the Sampled Well:

The current status of a particular well or water source where the sample was taken.

Active - the well is in use and safe drinking water monitoring is required.

Inactive - the well is not currently active, so safe drinking water monitoring is no longer required.

New Well Not Yet in Service - the well is new and not yet serving the public, so safe drinking water monitoring is not required.

Temporarily Abandoned the well is no longer being used and is planned to be filled and sealed, so safe drinking water monitoring is not required.

Permanently Abandoned - the well has been permanently filled and sealed, so safe drinking water monitoring is no longer required.

Temporarily Out of Service - the well is temporarily disconnected from the system for repairs, etc., so safe drinking water monitoring is not required at this time.

Reconstructed Well - the well has been reconstructed and is no longer serving the public under this Source ID or Wisconsin Unique Well Number (WUWN). The updated well received a new Source ID and WUWN after it was reconstructed.

Non-Potable Well the well is no longer used for human consumption, so safe drinking water monitoring is not required.

Private residence a well previously part of a public water system which now serves only a single-family private residence, so safe drinking water monitoring is no longer required.

Sample Date:

You can select a starting date and an ending date for samples to be included. If you select both, you will get information on all matching samples taken between and including those dates. If you select only the left date, you will get samples from that date on. If you select only the right date, you will get samples taken up to and including that date. Dates should be entered in the numeric month/day/year format or selected from the pop-up calendar.

Sample Type:

Compliance, Grab, Check and Repeat samples are used for MCL compliance determination. The other sample types represent samples taken to help identify potential water quality issues before they arise or to assess whether work/treatment is effective when trying to correct known water quality issues.

Sample Source:

Samples can be taken in the water distribution system, after any treatment at the point where the water enters the distribution system ("Entry Point"), or at the source (well or surface water intake). Each Safe Drinking Water Act (SDWA) rule specifies the location to collect routine samples, as well as any follow-up samples that may be required in response to those routine sample results.

DNR Sample Group:

If you are interested in certain types of contaminants, for example all synthetic organics, you can select a sample group here rather than selecting the individual contaminants.

Bacti Laboratory Search

A listing of all labs currently certified for Safe Drinking Water Act Coliform Bacteria testing that can be filtered, sorted, copied and downloaded.

Plan Review Search

Find Plan Reviews by a number of search criteria. Plan Reviews can be selected to view information about the project and plan review.

Reports

Reports for commonly requested data are available to run, copy and download data. Filter and sort options are available as applicable on each report. After making your selections, click the Run Report button in the lower left to generate the PDF report. Use the Clear button to reset the criteria back to the defaults if you wish to start over.

 

Last Revised: 08/19/2018