LRP - Licenses

LRP - Regulations

LRP - Permits

Recreation - Statewide

Recreation - Trapping

Recreation - Fishing

Recreation - Hunting

Env. Protection - Management

Env. Protection - Emergency

Env. Protection - Resources

To sign up for updates or to access your subscriber preferences, please enter your contact information below.



 
BRRTS on the Web
Go directly to the database.
RR Sites Map Desktop
Go to the desktop application.
RR Sites Map Mobile
Go to the mobile application.
Contact information
For additional help searching BRRTS on the Web, contact:
Danielle Wincentsen
BRRTS File Manager
Remediation & Redevelopment
715-623-4190 (ext. 3126)

Help for BRRTS on the Web

The BRRTS on the Web (BOTW) database provides two ways to locate Activities - Basic Search and Advanced Search. Here are some helpful hints when using either search function, general search tips and a list of abbreviations used in BOTW.

General information

General information

Enter or select one or more search criteria and press the 'Enter' key or click on the Search button. Clicking the Reset button removes all values from the search form and resets each field to defaults. After submitting your search, you will see a list of Activities matching your criteria. The number of Activities found and the number of pages produced are shown at the top of each results page.

Capitalization

BOTW searches are case insensitive. All characters, no matter how they are entered, will be converted to the correct case matching the database values.

Automatic 'AND' queries

By default, the BOTW search engine only returns Activities that match all of your search values. "And" is used by default to join each separate search criteria. Unlike some web search engines, separate values entered into the same field will not be searched for independently. For example, entering 'ACME PIPELINE' in the Activity Name field does not search for 'ACME' separate from 'PIPLELINE.' To restrict a search further, just include or select additional values.

Searching with 'wildcards'

The BOTW search engine will determine how each search term should be searched for to return the optimum results. It isn't necessary to enter '*' or '%' to force a search with 'begins with' or 'contains.' In fact, entering these symbols will interfere with your search. On the Search Results page header, you will see 'You searched on:' and the details of your search. This will indicate how each of your criteria values was searched for.

Consolidated activity search logic

If you search on a 10-digit BRRTS Activity number and the Activity you are searching for has been removed from the BRRTS database as the tracking has been consolidated with another Activity, your search result will indicate the change and return the Activity that tracking is currently being performed under.

Activity number change search logic

If you search on a 10-digit BRRTS Activity number and the number has been modified, usually caused by a change in the location county or a change in the Activity Type, search logic will return the Activity represented by the new Activity number.

Navigation

When moving between pages, always use the "Navigation:" links found at the top of each page. This will ensure when you return to perform another search, your previous criteria will be retained and you will avoid “form resubmission” browser errors.

Incomplete data and search accuracy

Search results may not represent a complete list of all activities and locations containing environmental contamination in the state of Wisconsin. This most often occurs, as the criteria used in your search may not exist across all BRRTS database records. In addition, there are some locations for which DNR has limited information but not a confirmation of discharge to the environment. These potentially contaminated sites do not appear in BRRTS on the Web until contamination has been confirmed. The DNR may be unaware of contamination at some properties.

Mouse-over help

Throughout BOTW you will see question mark icons. Place your mouse pointer over these icons to view more information about the item or section.

Abbreviations

Abbreviations used in BOTW

Abbreviation Full description
ASSOCASSOCIATED
ASSNASSOCIATION
AVEAVENUE
BLVDBOULEVARD
BUS HWYBUSINESS HIGHWAY
CTYCITY
COMMCOMMISSION
COCOMPANY
CONSTCONSTRUCTION
COOPCOOPERATIVE
CORPCORPORATION
CNTYCOUNTY
CTHCOUNTY TRUNK HWY
DISTDISTRICT
DIVDIVISION
DRDRIVE
EEAST
FSFARM SERVICE
HWYHIGHWAY
INCINCORPORATED
LNLANE
MFGMANUFACTURING
NNORTH
OFCOFFICE
PLTPLANT
RDROAD
SANSANITARY
SSOUTH
STHSTATE TRUNK HWY
STSTREET
TNTOWN
USHUNITED STATES HWY
UWUNIVERSITY
VILVILLAGE
WWEST
WIWISCONSIN
WBSWOOD BURING SITE

Basic Search

Basic Search tips and tricks

The Basic Search in BOTW provides a simple way to locate Activities using the most common search values. If you have additional questions, please contact Danielle Wincentsen (715-623-4190, ext. 3126).

Activity Name field
Often, but not always, the same as the Location/Facility name - there can be more than one activity at a contaminated site. The activity name may be more specific to the location of a discharge (e.g.: 'spill at intersection of 1st and 2nd Ave'). By default, the BOTW search engine searches for Activity Names using 'CONTAINS.'
Address field
When a value is entered into this field, the search will look for matching location addresses that CONTAIN the entered criteria. For example, entering First Ave will return addresses such as '123 FIRST AVE' or '89 FIRST AVENUE' or entering '800' would return addresses like '8000 STH 178TH', '1800 HARRISON ST', etc. It is a good idea to use less specific, fuzzy, address criteria in this field. This way you won't miss finding addresses with spelling differences or that use abbreviation.
Region drop down list
Select a DNR Region from the drop down list to limit the search by Region. Click on the 'Region' link next to the criteria field for maps and more information.
Municipality field
Name of the city, township, village or unincorporated name where the Activity is physically located. This may differ from the municipality used for the mailing address. In the BRRTS database, Municipalities are not input using a standard list and therefore abbreviations and order may vary (e.g. 'St. Favre, TN', 'TN of Saint Favre', etc). Search criteria should be entered with this in mind and multiple searches attempted if initial searches don't find desired results. Municipality names should contain the suffix 'TN' for Townships and 'VIL' for Villages. When searching by municipality, a BEGINS WITH search is automatically performed. For example, searching with 'GR' in the municipality field will return Activities located in 'Green Bay', 'Grand Marsh', etc.
County drop down list
Select a Wisconsin County from the drop down list to limit the search by County.
Status drop down list
Select a status (or statuses) for the Activities you are searching for. Status indicates the current 'state' of an Activity's cleanup process. 'Open' indicates the Activity is still in need of cleanup or the cleanup is underway. 'Conditionally Closed' indicates most clean-up actions have been approved but the Activity is awaiting formal closure upon the receipt of closure documentation. 'Closed' indicates an Activity has completed all cleanup requirements and has received a case closure letter from DNR or SPILL Activities that require no further cleanup. The Status List allows you to choose multiple statuses, such as 'Open or Closed', etc. Activity status has been a required field since 1996. Some Spill cleanups completed prior to 1996 have been closed. For other old Spill Activities, the status has been set to 'Historic' because these were not formally closed.
Activity Type drop down list
Select the RR Activity type (program) to limit your search. Click the 'Activity Type' link next to this list for more information. For more information on Activity Types please refer to the BOTW Glossary.
Jurisdiction drop down list
Indicates the agency, or bureau within the agency, which holds jurisdiction for cleanup actions at an Activity. Click on the 'Agency Jurisdiction' link next to this list for an explanation of each searchable jurisdiction.
Activity Number field
If you know the 10 digit BRRTS tracking number (e.g. from DNR correspondence), you may search for a specific site by entering the number in this box. You may enter the full number with dashes or omit them. The first two digits of the Activity Number indicate the 'type' or 'program' of the Activity (e.g. '02' = ERP, '03' = LUST, '04' = SPILL, etc.). The next two digits contain the county code. The BOTW search engine search for Activity Numbers using 'CONTAINS.' A quick way to find ERP Activities in Milwaukee County would be to enter '0241' in this field.
Facility ID field
Not all locations in BRRTS contain a Facility ID (FID) number. Other DNR programs also use these numbers. Searching by FID is useful when focused on the physical location where more than one Activity may be present.
PECFA Number field
The acronym PECFA stands for Petroleum Environmental Cleanup Fund Award. PECFA is a reimbursement program for eligible response action costs associated with petroleum site cleanup. A PECFA number is assigned to activities that have applied for this program and/or are tracked in the Tracker database.

Advanced Search

Advanced Search tips and tricks

The Advanced Search function in BOTW contains all of the fields in the Basic Search, plus some additional fields. If you have additional questions, please contact Danielle Wincentsen (715-623-4190, ext. 3126).

Region drop down list
Select a DNR Region from the drop down list to limit the search by Region. Click on the 'Region' link next to the criteria field for maps and more information. It is not necessary to include Region in your search if your search includes County.
County drop down list
Select a Wisconsin County from the drop down list to limit the search by County. If you include Region and County, Region will be removed from your search.
Municipality field
Name of the city, township, village or unincorporated name where the Activity is physically located. This may differ from the mailing address municipality. In the BRRTS database, Municipalities are not input using a standard list and therefore abbreviations and order may vary (e.g. 'Rodgers, TN,' 'TN of Saint Vince', etc). Search criteria should be entered with this in mind and multiple searches attempted if initial results aren't as desired. Searches 'Begins With.'
Activity Type drop down list
Select the RR Activity type (program) to limit your search.
Characteristics drop down list
These characteristics may be thought of as Activity 'sub-types' and represent various 'flags' in the BRRTS database. As an example, 'Drycleaner' is a special type of ERP Activity. To find all Activities in BRRTS defined as Drycleaners, choose this from the Characteristics list. Searchable characteristics include the following.
Above Ground Tank
An Above Ground Storage Tank was the source, or one source of the contamination at the Activity.
Drycleaner
The ERP Activity has been identified as a Drycleaner and solvents from the dry cleaning operations have caused the contamination.
EPA Hazard Removal
Activities where the EPA has conducted the removal and disposal of hazardous materials (solid or liquid) that posed "an imminent and substantial endangerment to human health or the environment", or an RP has conducted the removal action under an EPA order.
On GIS Registry
Activities that are listed on the DNR Registry of Closed Remediation Sites due to residual contamination at the time of case closure approval.
PECFA Eligible
Activities that qualify for the Wisconsin Department of Safety & Professional Services Petroleum Environmental Cleanup Fund Act (PECFA), for reimbursement of eligible response action costs.
Petrol. plus Other Contam.
Activities where petroleum was one of the contaminants AND another contaminant is also present. These are commonly called co-contamination sites.
Superfund Prelim. Assessment
Activities where a preliminary assessment was performed compiling readily available information about the site and its surroundings concerning historical waste generation and disposal practices, associations with hazardous substances, sample locations, etc.
Superfund NPL Site
Activities included on the National Priorities List (NPL) of Superfund sites.
Tracked by DSPS
Indicates the Activity is tracked in the Wisconsin Department of Safety & Professional Services (DSPS) database. This does not necessarily mean the jurisdiction for the Activity has been transferred to DSPS.
Status drop down list
Status indicates the current 'state' of an Activity's cleanup process and are classified as follows.
Open
Indicates the Activity is still in need of cleanup or the cleanup is underway. Conditionally Closed: indicates most cleanup actions have been approved but the Activity is awaiting formal closure upon the receipt of closure documentation.
Closed
Indicates an Activity has completed all cleanup requirements and has received a case closure letter from DNR.
Historic Spills
Spills that occurred between 1978 and 1996 prior to the existence of a formal closure process for Spill Activities. Read more about historic spills. [PDF]
Activity Type drop down list
Select the RR Activity type (program) to limit your search. For more information on Activity Types please refer to the BOTW Glossary.
Jurisdiction drop down list
Indicates the agency, or bureau within DNR, which holds jurisdiction for cleanup actions at an Activity.
Comments field
Search for Activities containing words or phases contained within the Activity comments. Searches 'Contains Within.'
Substance drop down list
Search for Activities where a specific Substance is listed as a contaminant.
Action drop down list
Search for Activities where specific Actions have taken place. This list only contains the most commonly used Actions in BRRTS database.
Impact drop down list
Search for Activities that resulted in a real or posed a potential impact to the environment.
Financial Category drop down list
Many BRRTS Activities contain financial assistance via grants, loans or other reimbursements; or hired an environmental consultant(s) and used state funds for investigation and cleanup as no responsible party is willing or able to provide financial support at the site.
Activity Start Date
Locate Activities where the Start Date was Equal to, Before or After a specific date, entered in the format of MM/DD/YYYY.
Activity End Date
Locate Activities where the End Date was Equal to, Before or After a specific date, entered in the format of MM/DD/YYYY.
Public Land Survey System drop down lists
The Public Land Survey System (PLSS) is a way of subdividing and describing land in the United States. The PLSS fields allow you to enter the quarter-quarter-sections, township and range for an Activity. For additional information, read the Tutorial on the Public Land Survey System Descriptions [PDF]. You may select all or some PLSS values depending on how you wish to limit your search.
Person/Org Name field
Enter a complete or partial name of the person or organization related to the Activity in any role. Searches 'Contains Within.'

Search results

Search results

Downloading results

Records returned as a result of your search may be downloaded into an Excel spreadsheet (.xls format). Click the DOWNLOAD TO EXCEL link at the top of the results page. The spreadsheet will contain the date and time of the download, the search criteria used and the following fields: BRRTS Number, Activity Name, Location Address, Municipality, Zip Code, County, DNR Region, Facility ID, Start Date, End Date, Status, Jurisdiction, Activity Type and General Comments.

Location grouping

Activities are grouped by Location as indicated by alternating light yellow or white background within the list.

Paging

If your search returned more than 30 records, they will be listed on multiple pages. To navigate between pages, use the Next Page, First Page, Previous Page and Last Page links.

Last revised: Thursday June 02 2016