About the Data

This is an experimental program for searching all of RTK NET's environmental facility-based databases at the same time. It currently produces a very limited set of data for each facility, so it should only be used to find out what data records are available. Once you have found out what is available by using this program, you should use the individual Standard Reports or Form Queries for each database to get more detailed data. Please note that some of these search tools are only available via telnet. *NEW*: For those databases that are available through the Web, you can now activate a link on the name of a facility to get a High detail search on that facility within its database.

This program is slightly better at finding records than the other Standard Reports. If a database contains multiple address fields, it will search all of them rather than just the main one. For example, 1991 TRI data records contain both a facility address and a mailing address. If you search for everything within a certain city and state, this program will search for matches in both the facility and the mailing address, while the TRI Standard Report will search only the facility address. If you don't want this program to search mailing addresses, you can turn this option off through the Select Databases check box.

It is also possible to choose which RTK NET databases to include in your search, rather than searching all of them.

Types of Master Standard Reports

Facility Standard Report: Selects a report that will give you data on a particular facility.
Example: You are interested in the Rhone Poulenc plant in your town.
Area Standard Report: Selects a report that will give data on all plants in a geographic area, such as a state, city, or zip code.
Example: You want to know about all facilities in College Park, MD.
Industry Standard Report: Selects a report that will give data on all facilities that have the same primary SIC code, or industrial classification.
Example: You want to find out which facilities are owned by the Paper industry in your state.

If you have any questions, comments, or found any bugs in these reports please either send mail to dbadmin@rtknet.org or call 202-234-8494.

Facility Master Standard Report

Facility reports are intended to help you find information about a single facility, over one or more years. You can select the facility by specifying its name (and state) or by specifying its city. Names of facilities will often change from year to year, but the names of the cities that they are located in generally do not.

Area Master Standard Report

Area reports are intended to help you find out about all facilities within a geographic area - a zip code, city, or state. A state must be entered; only one or none of zip code or city can be chosen in each search.

Industry Master Standard Report

Industry reports are intended to help you find out which facilities are listed that have a particular SIC code, or industrial classification. You can specify the facilities you want by SIC code, state, and year. Note that although many facilities produce more than one kind of product, and have more than one SIC code, these reports only search for the first or primary SIC code.

Field Information

Help is available for the following fields:

CAS Number Field
City Field
Detail Field
Facility Name Field
Reporting Year
SIC Field
State Field
Zip Code Field

CAS Number Field

Fill in the CAS number of a TRI covered chemical here. Do not use blanks or dashes in your CAS number. The class of "compounds" in TRI do not have CAS numbers.

City Field

Fill in the name of the city that you want. Some entries may have their city misspelled; others have two varient spellings for the same city. For instance, there may be entries that spell their city name either ST. LOUIS or SAINT LOUIS. If you think this may be a factor, you can either run your search twice or use "*" to represent any characters. In the case above you could enter "S*LOUIS" and find both spellings. Watch out for FORT/FT., SAINT/ST., and MOUNT/MT.

Facility Name Field

Fill in the facility name in this field if you know it.

Warning! Facility names are often misspelled when submitted to EPA. In addition, many facilities change their names from year to year. For these reasons, enter as few letters as are necessary to specify the facility, followed by a "*" to represent any number of letters. This will help you find the facility even if its name changes or is misspelled. Example: You want to find a Du Pont facility. Possible spellings of facility name:

DU PONT CO.
E. I. DU PONT DE NEMEURS
DUPONT
DU PONT MICHIGAN PLANT

If you entered "DU PONT" into the name field, you wouldn't have found any of these spellings. On the other hand, if you entered "DU PONT*", you would have found spellings 1 and 4. To find all of these you would need to enter "*DU*PONT*". If you're not very sure of the facility name it is often better to leave this field blank and get a list of all facilities in the city that your facility of interest is in.

Reporting Year

The TRI and ERNS databases have reporting years extending from 1987 to 1995. If you choose a reporting year, TRI and ERNS records found will be restricted to that year.

The BRS database is reported every two years (1989 through 1993 currently available). If you choose a reporting year from 1987-1989, you will get 1989 BRS data. If you choose a reporting year from 1990-1992, you will get 1991 BRS data. 1993 or later provides 1993 BRS data.

The CERCLIS, FINDS, NPL, PCS, and RODS databases all don't have explicit reporting years; instead they are records of the current state of the data at the time of RTK NET's last update of that database. For this reason, all records from these databases will be searched no matter what reporting year you fill in.

The CUS database is currently from reporting year 1990. Since it is updated every 4 years, searches for any reporting year will retrieve only the 1990 CUS data.

The DOCKET database holds data on all civil cases since the start of EPA. Although a "reporting year" could be generated based on when the case was started or finished, this is a rather artificial concept for this database. For this reason, the entire DOCKET database is searched no matter what reporting year you fill in.

SIC Field

SIC codes are 4-digit numbers that represent specific industries. More general industrial categories are represented by the first 2 digits of the SIC codes. For instance, "Primary production of aluminum" is SIC code 3334, in the category 33, "Primary Metal Industries". You can fill in either a 4-digit or 2-digit code in this field; if you fill in a 2-digit code the program will automatically add a "*" to the end of it to find all 4-digit codes that start with those digits.

State Field

In all of these reports, you are forced to enter a state for your search to keep you from inadvertantly selecting a nationwide search (nationwide searches can take a great deal of time). In the Industry reports you can select a nationwide search by entering "US" into this field - please do this ONLY if you are sure that you want the type of output that the report will produce.

Zip Code Field

Fill in the zip code for the area that you want. If you fill in a 5-digit zip code, the program will automatically put a "*" after it. The "*" represents any number of characters and will let your search find 9-digit zip codes that start with the 5 digits you entered.
Example:
If you enter 20740*
this will find

20740
207401122
207403465
etc.