Wisconsin Department of Natural Resources
Wisconsin DNR Drinking Water data
Reports This page provides help for users of the DNR Drinking Water database web pages. Topics include:
  • General Information
  • Download
  • Searching Tips - Public Water
  • Searching Tips - Contaminants in Public Systems
  • Searching Tips - High Capacity Wells
  • Searching Tips - Well Construction Reports
  • General Information

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

    You may leave all fields blank. However, your search will take longer. The more fields you can fill in, the better your chances of quickly finding what you're looking for. However, you must match the data exactly as it appears in the database, so unless you are sure of spellings, abbreviations, etc., you may want to limit what you're querying for. If you want to start your query over, use the Clear button

    On any screen, you may click on any list item that is underlined and highlighted to bring up additional detail information. If you would like to enter a new query, just click on the "Query" box at the bottom of the screen.

    The links at the bottom of the page are for navigating through the DNR web site. These links can take you to the DNR home page, the State of Wisconsin home page, as well as the DNR intranet home page for internal users.

    Download

    If you would like to view the data in a spreadsheet form, you can use the 'Download' buttons found at the bottom of each page which shows a set of records. This takes you to a screen allowing you to select specific fields for the download appears. You must click the submit box to complete the download. You have several options for download format, but the Excel option is simplest if you have that software available. The Excel spreadsheet that results needs to be saved into native Excel format. To achieve this, you will need to complete the following steps:

      1. Click 'File'
      2. Click 'Save As¿'
      3. Change the 'Save as type:' to 'Microsoft Excel Workbook (*.xls)'
      4. Give the workbook a name
      5. Click 'Save'

    Searching Tips - Public Water

    Name:

    The name of the drinking water system. 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 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.

    DNR Public Water Supply ID:

    The number assigned to a system by DNR, which uniquely identifies the public water system. Enter either the entire ID, or a portion followed by the % wildcard. For example, you may enter "8020%" (without the quotes) which will return a list of all systems whose FID begins with the characters 8020.

    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. The arrow at the right of the box will give you the following 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.

    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.

    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.

    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 classification of the system based on ownership and population served. If you are unsure of the status after looking at the following list, leave this blank. The arrow at the right of the box will give you the following choices:

    Active - the water system is in use and safe drinking water monitoring is 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.

    Inactive - the water system is not currently active, 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, not yet serving public - the water system is new so safe drinking water monitoring is not yet required.

    Private, serves fewer than 25 people - 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.

    --

    DNR Region:

    The DNR regional area where the system is located. The arrow at the right of the box will give you the names of the regions. If you are unsure which region the system is located in, leave this blank.

    County:

    The name of the Wisconsin county in which the system is located. The arrow at the right of the box will give you the list of Wisconsin counties. If you are unsure of which county the system is located in, leave this blank. You can select multiple counties by clicking on one entry and then using Shift-click or Ctrl-click to add others.

    Searching Tips - Contaminants in Public Systems

    Contaminant:

    This list shows the name of the contaminant to be selected. You should normally select one or more contaminants. To select multiple contaminants, click on one entry and then use Shift-click or Ctrl-click to add others.

    Select only Detects:

    If you set this to Yes, you will only retrieve samples where the contaminants have been detected, as opposed to all those where the sample has been analyzed for the contaminant. Setting this to No will retrieve only cases where the contaminant was not detected.

    Select values over MCL:

    If you set this to Yes, you will only retrieve samples where the value of the contaminant is greater than its EPA Maximum Contaminant Limit (MCL).

    Measured Amount:

    Set the lower and upper range for the contaminant. 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 rerun the query refining it.

    System Name:

    See above, in the Searching Tips for Public Systems

    DNR Public Water System ID:

    See above, in the Searching Tips for Public Systems

    System Type:

    See above, in the Searching Tips for Public Systems

    DNR Region:

    See above, in the Searching Tips for Public Systems

    County:

    See above, in the Searching Tips for Public Systems

    Status of the Water Supply System:

    See above, in the Searching Tips for Public Systems

    Status of the Sampled Well:

    This is similar to the system status, but for the particular well or water source where the sample was taken. Normally, you will wish to select Active wells, which are used to provide water to the public.

    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 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 that date. Dates should be entered in mm/dd/yyyy format, so November 3, 1997 would be 11/03/1997.

    Sample Type:

    Most samples were taken for compliance with various federal and state sampling requirements. Sample data from the other types should be used with care.

    Sample Source:

    Samples can be taken in the water distribution system, at the point where the water enters the distribution system ("Entry Point"), or at the source. Public water samples for bacteriological contaminants, lead/copper, and radionucliedes are typically taken at the distribution system; samples for chemical contaminants (inorganics, organics, pesticides, etc.) are typically taken at the entry point.

    Township, Range, Direction, Section:

    If you know the Public Land Survey designation of an area of interest, you can enter the information here as part of your query.

    DNR Sample Group

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

    Searching Tips - High Capacity Wells

    DNR Approval Number:

    The DNR Approval number for this well. You do not need to enter leading digits -- 0010 and 10 will bring back the same information

    WI Unique Well Number:

    The 5-character Wisconsin Unique Well Number for the well, for example AB123

    DNR Region:

    See above, in the Searching Tips for Public Systems

    County:

    See above, in the Searching Tips for Public Systems

    Water Basin:

    Select a water basin from the list.

    W.G. & N.H. Log #:

    Enter the Wisconsin Geologic and Natural History Log Number for this well.

    Owner/Operator:

    Enter part or all of the name of the owner or operator of this high capacity well. The system will retrieve all wells where the owner or operator name contains the text you enter, so "Farm" will bring back both "Farm and Fleet" and "Johnson Farms"

    Owner/Operator City:

    Enter part or all of the city name where the owner/operator is located. Here, the system will assume that the city starts with the information you enter, so entering "Mi" will bring back wells where the owners are in Milltown, Milwaukee, etc.

    Township, Range, Direction, Section, Quarter Section:

    If you know the Public Land Survey designation of an area of interest, you can enter the information here as part of your query.

    Classification:

    This is the type of use for the well. You may select one value.

    Status:

    Most retrievals are concerned with active wells.

    Chief Aquifer:

    The type of rock for the main aquifer where this well obtains water.

    Approved Date:

    You can select a starting date and an ending date for DNR approval of the wells. If you select both, you will get information on all matching wells approved between those dates. If you select only the left date, you will get wells approved from that date on. If you select only the right date, you will get wells approved up to that date. Dates should be entered in mm/dd/yyyy format, so November 3, 1997 would be 11/03/1997.

    Completed Date:

    You can select a starting date and an ending date for completion of the wells. If you select both, you will get information on all matching wells completed between those dates. If you select only the left date, you will get wells completed from that date on. If you select only the right date, you will get wells completed up to that date. Dates should be entered in mm/dd/yyyy format, so November 3, 1997 would be 11/03/1997.

    Normal Pumpage:

    Normal pumpage in gallons per day. This must match exactly with the value in the database

    Pump Capacity:

    Enter a range of pump capacities in gallons per minute.

    Well Depth:

    Enter a range of total well depths in feet.

    Drilling Method:

    Select a drilling method from the list.

    Yield Test Pump Rate:

    Enter a range of pumping rates in gallons per minute.

    Static Water Level:

    Enter a range of static water levels in feet.

    Pumping Water Level:

    Enter a range of pumping water levels in feet.

    Specific Capacity:

    Enter a range of specific capacities in gallons per minute per foot.

    Searching Tips - Well Construction Reports

    WI Unique Well Number:

    The 5-character Wisconsin Unique Well Number for the well, for example AB123

    County:

    See above, in the Searching Tips for Public Systems

    Municipality:

    Enter part or all of the city name where the well is located. Here, the system will assume that the city starts with the information you enter, so entering "Mi" will bring back wells in Milltown, Milwaukee, etc.

    Completion Date:

    You can select a starting date and an ending date for completion of the wells. If you select both, you will get information on all matching wells completed between those dates. If you select only the left date, you will get wells completed from that date on. If you select only the right date, you will get wells completed up to that date. Dates should be entered in mm/dd/yyyy format, so November 3, 1997 would be 11/03/1997.

    Constructor

    Enter part or all of the name of the constructor of this well. The system will retrieve all wells where the constructor name contains the text you enter, so "Farm" will bring back both "Farm and Fleet" and "Johnson Farms"

    Well Address

    The address of the well. This query will retrieve all addresses which contain the text you enter.

    Township, Range, Direction, Section, Quarter Section:

    If you know the Public Land Survey designation of an area of interest, you can enter the information here as part of your query.

    DNR Approval Number:

    The DNR Approval number for this high capacity well, if any. You do not need to enter leading digits -- 0010 and 10 will bring back the same information

    DNR Facility ID:

    The number assigned to a public water system by DNR.

    Last Revised: 08/02/2020