Office of Emergency and
Remedial Response
Washington DC 20460
EPA.540'G-89005
Aug.1988
Superfund
Superfund Automated
Records of Decision
System (RODS)
Users Manual
-------
-------
-------
TABLE OF CONTENTS
(Continued)
5. SPECIAL EMBEDDED TERMS IN THE TEXT FIELD 11-29
E. THE SELECTION MENU H-30
1. DISPLAYING THE RESULTS 11-33
a. SPECIAL FEATURES WHEN DISPLAYING THE TEXT
FIELD 11-34
2. SORTING YOUR RESULTS 11-37
3. COMBINING YOUR SEARCH SETS H-39
4. LISTING THE SEARCH SETS YOU HAVE CREATED 11-43
5. SEARCHING THE DATA BASE 11-45
6. PRINTING YOUR RESULTS II-47
F. THE HELP MENUS 11-49
1. GENERAL HELP TOPICS II-50
2. FIELD INFORMATION 11-52
3. INDEX TERMS FOR A SPECIFIC FIELD 11-54
INDEX 11-57
APPENDIX A THE ROD SYSTEM SEARCH FIELDS A-l
APPENDIX B THE ROD SYSTEM MENUS B-l
APPENDIX C THE HELP MENUS C-l
APPENDIX D SAMPLE SEARCH D-l
LIST OF FIGURES AND TABLES
FIGURE 1 ANATOMY OF A ROD DOCUMENT 1-8
FIGURE 2 RODS DATA BASE FUNCTIONAL RELATIONSHIP DIAGRAM. . . 11-31
FIGURE 3 VENN DIAGRAM SHOWING COMMON SEARCH SETS 11-41
TABLE 1 STATE ABBREVIATIONS BY REGION 11-17
11
-------
SECTION I. INTRODUCTION
A. WHAT IS A RECORD OF DECISION?
A Record of Decision (ROD) is a document describing EPA's planned course of action to
clean up a Superfund site, proposed or listed on the National Priorities List (NPL). Each ROD
is the official record of EPA's remedy selection for the site. The RODS data base contains
all RODS since the inception of the Superfund program. Each ROD achieves the following:
• Documents the Agency's decision making process concerning a Superfund site;
• Shows consistency with the Comprehensive Environmental Response, Compensation
and Liability Act (CERCLA) of 1980, the Superfund Amendments and Reauthorization
Act (SARA) of 1986, and the National Contingency Plan (NCP);
• Supports technical and legal decisions; and
• Functions as the centerpiece for the Superfund Administrative Record.
Most RODs follow a standard format. Usually, a ROD document contains three major
sections:
1) The Declaration;
2) The Decision Summary; and
3) The Responsiveness Summary.
DECLARATION
The first section, the Declaration, provides the name and location of the site; the
statement of purpose of the ROD; a description of the major components of the selected
remedy; the statement of basis for the preferred remedial approach; and the EPA's
Regional Administrator or Assistant Administrator's signature.
THE DECISION SUMMARY
The next section, Decision Summary, provides more detailed information on the site and
the selected remedy. This section consists of 7 key elements:
Site name, location, and description;
History of the site;
Community relations history regarding the site;
Current site status;
Enforcement;
A comparison and evaluation of remedial alternatives; and
A detailed description and discussion of the selected remedy including
performance goals, timeframes, etc.
1-1
-------
THE RESPONSIVENESS SUMMARY
The final section, the Responsiveness Summary, documents EPA's responses to the
comments and questions raised by the public. The Responsiveness Summary usually
includes four parts:
• An overview of public comments on the alternatives;
• The background on community involvement and concerns;
• A summary of comments received during the public comment period and EPA
responses to these comments; and
• Remaining concerns of the community that need to be addressed.
1-2
-------
B. HOW THE ROD DOCUMENTS ARE USED
The ROD documents are used frequently and by many groups both at Headquarters and in
the Regions, as well as outside the Agency. Since the ROD documents are the centerpiece for
the Superfund Administrative Record and serve to set forth the Agency's selected remedy for
a Superfund site, the ROD documents are a collection of valuable information concerning site
clean-up. To this end, there are several reasons that the ROD documents are consulted by
various groups of key users. The key users and how they use the ROD documents are
discussed in the following paragraphs.
REGIONAL TECHNICAL STAFFS
The Regional technical staffs develop and write the ROD documents. The staffs refer to
other ROD documents to determine what types of technologies have been considered and
selected at other sites and what clean-up levels were developed.
OERR/OWPE/ORD TECHNICAL STAFFS
Headquarters' technical staffs from the Office of Emergency and Remedial Response
(OERR), Office of Waste Programs Enforcement (OWPE), and the Office of Research and
Development (ORD) consult the ROD documents to determine historical information
regarding waste types, concentrations, media, and quantity. The historical information
aids them in the formulation of technology development strategies.
REGIONAL/HEADQUARTER LEGAL STAFFS
Many individuals from both Regional and Headquarters Legal staffs use the ROD
documents to determine legal precedents and evaluate program consistency.
HEADQUARTERS PROGRAM STAFF
Individuals responsible for providing reports to Congress, EPA upper management, and the
public sector in response to Freedom of Information Act requests, frequently refer to
ROD documents to compile statistics and consolidate lists based on particular criteria
(e.g., sites where a particular contaminant has been identified). Policy staff also use
RODs to formulate new policy and/or guidance.
1-3
-------
Up until the ROD System (RODS) Data Base was developed, all queries and searches of
the ROD documents required the users to manually search the hardcopies of all the ROD
documents and/or to rely on manually created indexes of the key contaminants, key words,
and contaminated media. This was a time consuming, haphazard process at best. And, as the
number of RODs increased over time, the process became even more time consuming.
1-4
-------
C. HOW THE ROD SYSTEM HELPS USERS SEARCH THE RODS
The RODS data base offers key users two primary advantages over searching the ROD
documents manually. Searches are 1) much faster, and 2) more accurate.
The user can find any word in RODS in a matter of seconds. For example, the user can
find all occurrences of the word "dioxin" anywhere in a ROD, including anywhere it might
logically occur (i.e., the abstract field, the text field, etc.) by entering the word "dioxin" at
the SEARCH term prompt. The system immediately tells the user how many RODs contain the
term. The user can then display the information that the system found and further
investigate it. To do the same SEARCH manually would take hours.
Searches become more accurate because there is little chance of missing a ROD that
contains the word or words you are searching for. The ROD System indexes every word in
every ROD so when you search for a word you will find it. On the other hand, manually
searching the RODs lends itself to human error and the search term may be missed.
Although subjective interaction is still important in screening the results provided by the
system, the ability to narrow the number of RODs that will be reviewed with little chance of
missing a document is a very real benefit.
1-5
-------
D. THE ANATOMY OF A ROD DOCUMENT
Each ROD document appears in the RODS data base in its entirety except for graphics,
certain tables, and page numbers. If you compare the text of a ROD in the system and the
text of the hardcopy of that same ROD, they would look virtually identical except that the
ROD in the system has no page numbers. The text of a ROD in the system is in the field
called "TEXT".
In addition to the TEXT field, which in most cases is extremely long, several short fields
have been included in the data base to aid users in searching for specific information. The
fields, which contains important identification and search information, include:
Site Name
Alias Name
ROD Date
Region
Location (City, State Abbreviation)
ROD ID
Site ID
Key Words
Contaminated Media
Key Contaminants
Selected Remedy
Abstract
Figures
Text Sections.
Figure 1 is a schematic diagram that shows where the data from each field comes from.
The data from all fields (except the Site ID number) ultimately comes from the ROD document.
However, two other documents are generated from the ROD documents and both are used to
help extract data for the fields. They are:
1) The National Technical Information Service (NTIS) Coversheets (abstracts); and
2) The ROD Annual Report.
As mentioned above, all fields except the Site ID number, ultimately come from the ROD
documents. The Site ID number is an identification number from the Comprehensive
Environmental Response, Compensation and Liability Information System (CERCLIS) data base,
which is included in the ROD System to provide a data link between the two data bases.
To help you understand how the ROD System works, you must understand how to handle
the data. In the system, each ROD document is represented in two ways: 1) as a word list,
and 2) as one continuous document.
AS A WORD LIST
In the ROD System, each term in each ROD document can be found in an alphabetized
word list or index. Associated with each word is a code which tells the system exactly
where the term is located (i.e., in which ROD(s) and in which sentence(s)). This word
list, with associated code(s), allows quick access to any word in the entire data base.
The word list is always used when the system searches the data base for a term. The
RODS word list contains all of the words from all of the RODs in the system (except for
nondescriptive words like "A", "AND", "THE", etc.)
1-6
-------
AS ONE CONTINUOUS DOCUMENT
In addition to the word list, the ROD System also stores each ROD as one continuous
document, which is composed of several short fields and one long "TEXT" field. The
terms and codes in the word list are directly linked to the terms in the continuous
document. So, when the user does a search, the system first goes to the word list to
find out if the term is present. If the term is present, the codes associated with each
term tells the system where in the continuous RODS document the term is located.
Whenever the user displays a ROD, the continuous document format is being viewed.
1-7
-------
SOURCES
ROD
*••••••••••••••»..
ROD
Annual
Report
FIELDS
Site Name
Alias Name
Location
Remedy
Figure
Text Sections
Text
Abstract
ROD Date
Media
Contaminants
Region
ROD ID
CERCLIS
Data
Base
mmm
Figure 1. The anatomy of a ROD document.
1-8
-------
Mainframe Logon
Procedures
-------
SECTION II. HOW TO USE THE ROD SYSTEM
A. LOGGING ON TO THE IBM MAINFRAME
1. PREPARING TO LOGON TO THE IBM MAINFRAME
Before you can LOGON to the IBM mainframe, you need to know:
Your USER ID;
Your PASSWORD;
Your USER ACCOUNT;
Procedure name (SEPATSO); and
FIMAS ID (BASIP).
Size parameter (3000);
a. USER ID AND PASSWORD
Every user who logs onto the IBM Mainframe must have a valid USER ID. A USER ID is
a three letter code. If you do not have a valid USER ID, contact your ADP coordinator.
Associated with every USER ID is a PASSWORD. When you first receive your USER ID,
your PASSWORD will be the same as your USER ID. The first time you LOGON to the IBM,
you should change your PASSWORD to one of your own choosing different from the USER ID.
Your PASSWORD is a word you make up that must be within the following limits:
• Must be 4 to 8 characters;
• Must start with a letter;
• Must be changed every 90 days; and
• Must be different from your three previous PASSWORDS.
b. USER ACCOUNT
Every person logging onto the IBM mainframe must have a valid USER ACCOUNT. A
USER ACCOUNT is a four-character string used to control billing for computer services.
Your USER ID must be authorized to use an account; therefore, you must have at least one
account associated with your USER ID in order to LOGON. If you do not have a valid USER
ACCOUNT, contact your ADP coordinator.
c. FIMAS ID
The FIMAS ID is a five-character string used by management to monitor the type of
work being done on the computer. Your FIMAS ID is BASIP.
d. PROCEDURE NAME
Your Procedure Name is SEPATSO.
e. SIZE PARAMETER
The Size Parameter needed in order to use BASIS is 3000.
Once you know these six pieces of information, you are ready to LOGON.
II-1
-------
2. LOGON PROCEDURES
There are many different ways to access the IBM mainframe depending on the types of
hardware and/or software you have. This section describes two common ways to LOGON.
They are:
• Using a PC with a Modem and Crosstalk; and
• Using a 3270 terminal connected to a Controller (or a PC with an IRMA board
connected to a Controller).
The procedures you use may vary slightly from those listed below. COMPUTER prompts or
instructions will be in quotes, user actions in bold.
a. USING A PC WITH A MODEM AND CROSSTALK
This procedure assumes that you have a PC with a modem hooked up to a working phone
line and that you have Crosstalk software on your PC.
If your PC is configured like most at EPA, when you turn it on, you will see the
Standard Menu, shown below. To get into Crosstalk, press F4.
Fl dBASEIII
F2 LOTUS 1-2-3
F3 WORDSTAR
F4 CROSSTALK
F5 USER EXIT
F6 BACKUP/RESTORE ALL FILES
F7 TUTORIALS
F8 BASIC INTERPRETER
F9 MOVE/COPY FILE
F10 DISK OPERATING SYSTEM
SPECIFY SELECTION BY FUNCTION KEY
II-2
-------
After you press F4, the Crosstalk Status Screen appears:
CROSSTALK - XVI Status Screen
NAme Crosstalk default settings
NUmber
I Communications parameters
SPeed 1200 PArity None DUplex Full
DAta 8 Slop 1 EMulate None
POrt 1 MOde Call
LOaded
CApture
Off line
CSTD.XTK
Off
ATtenEsc
SWitch Home
Key settings
COmmandETX (AC)
BReak End
I Filter settings ]
DEbug Off LFauto Off
TAbex Off BLankex Off
INfilter On OUtfiltr On
I SEnd control settings
CWait None
LWait None
Available command files
1) BBS
6) KMK
11) MF2
16) PRIME
2)CPC
7) LEX
12) MFALT
17) SETUP
3) DEC
8) MAIN24
13) MNFRM
18) STD
4) EMAIL
9) MAINFRAM
14) NEWUSER
5) EPA-BBS
10) MCIMAIL
15) OAG
Enter number for file to use ( 1 - 18 ):
Notice that there is a list of "Available command files" at the bottom of the Crosstalk
Status Screen. These contain phone numbers and parameters that have been programmed and
saved as command files. In the example above, command file 9 contains all the information to
connect you to the IBM mainframe. In this example, at the prompt:
"ENTER NUMBER FOR FILE TO USE (1 - 18):"
You would type 9.
Examine the "Available command files" on your Crosstalk Status Screen and determine if
one of them may connect you to the IBM mainframe. If you do not have a command file for
the mainframe, you must create one. Creating a command file is fairly simple and once you
create it, you can use it to access the mainframe in the future.
b. CREATING A COMMAND FILE IN CROSSTALK
First, at the "ENTER NUMBER FOR FILE TO USE:" prompt, press ENTER. The prompt
will change to "COMMAND?".
Type NA MAINFRAM Press ENTER.
Type DA 7 Press ENTER.
Type PA EVEN Press ENTER.
Type DU HALF Press ENTER.
Notice that as you enter each of the commands, it changes the parameters on the screen.
II-3
-------
One last parameter you need to enter is the phone number to access the mainframe. At
Headquarters, it is 94881515. If you do not know the phone number, contact your ADP
coordinator, User Support (FTS 629-7862), or Telecommunications (FTS 629-4506).
Using the Headquarters number as an example, type:
NU 94881515 Press ENTER.
Compare your terminal screen with the screen on the next page. All the parameters
should be the same. If they are not, change them. Also, make sure that modem is "ON" and
that the port is "2".
• CROSSTALK - XVI Status Screen
NAme
NUmber
mainfram
94881515
LOaded
CApture
Off line
CMAINFRAM.XTK
Off
I Communications parameters ——
SPeed 1200 PArity Even Duplex Half
DAta 7 STop 1 EMulate None
POrt 1 MOde Call
I Filter settings —
DEbug Off LFauto
TAbex Off BLankex
INfilter On
Off
Off
OUtfiltr On
1
ATtenEsc
SWitch Home
i
1)
6)
ID
16)
BBS
KMK
MF2
PRIME
2)
7)
12)
17)
COmn
BReak
CPC
LEX
MFALT
SETUP
landE
: E
Avail;
3)
8)
13)
18)
TX (AC)
nd
able comma
DEC
MAIN24
MNFRM
STD
| OC.I1U tuiurui :
CWait None
LWait None
4) EMAIL
9) MAINFRAM
14) NEWUSER
DCUll
5)
10)
15)
i
EPA-BBS
MCIMAIL
OAG
To save these parameters into a command file:
Type SA MAINFRAM.
Crosstalk will save a file named MAINFRAM.XTK. From now on, when you enter Crosstalk,
you will see a command file called "MAINFRAM" and you simply enter the command file
number associated with that file to call the mainframe.
To call the mainframe with the parameters currently on the screen, type GO at the
"COMMAND?" prompt. Crosstalk will call the mainframe.
When you invoke a command file to call a number, you will hear a dial tone, then the
number being dialed, and then a phone ring. When you have established a connection with
the mainframe, you will see the following message at the bottom of the screen:
"CONNECTION ESTABLISHED. PROCEED."
II-4
-------
Press ENTER once, and the following screen will appear:
Welcome to the Environmental Protection Agency National Computer Center
Please enter one of the following selections:
IBM for IBM
UNI for SPERRY
TCP for 3270 EMULATION
FMO for FMO POP
VAX for VAX
PRIME for PRIME
Enter selection:
At the "ENTER SELECTION:" prompt:
Type IBM and press ENTER. You will see the message "CONNECTED".
Press ENTER once. You will see the message "ENTER TSO".
Type TSO and press ENTER. You will see the message "ENTER LOGON".
You must now type the LOGON line.
Type LOGON USERID/PASS WORD a(USER ACCOUNT) s(3000). (You fill in the
USER ID, PASSWORD, and USER ACCOUNT.)
The LOGON line is confusing, so an example will better explain it. If your:
USER ID = EXZ
PASSWORD = TREES
USER ACCOUNT = SFRD
Size Parameter = 3000
Then you would type the following LOGON line:
LOGON EXZ/TREES a(SFRD) s(3000)
Type in your LOGON line.
Press ENTER and you will see the message "ENTER PROCEDURE NAME -".
Type SEPATSO. You will see a list of NEWS ALERTS and the message "ENTER FIMAS
ID-".
Type BASIP. The word "READY" will appear. You have successfully logged on to the
IBM mainframe.
II-5
-------
screen:
c. USING A 3270 TERMINAL CONNECTED TO A CONTROLLER. OR A PC WITH
AN IRMA BOARD CONNECTED TO A CONTROLLER
When you turn on your 3270 terminal or invoke your IRMA, you will see the following
WELCOME TO THE
U.S. ENVIRONMENTAL PROTECTION AGENCY
TELECOMMUNICATIONS NETWORK
ENTER COMMAND OR M FOR MENU
At this screen, type TSO. You will see the message "ENTER USERID -".
For the purpose of this discussion, we will use the following hypothetical information:
USER ID - EXZ
PASSWORD = TREES
USER ACCOUNT = SFRD
and the following real information:
Procedure Name = SEPATSO
Size Parameter = 3000
FIMAS ID = BASIP
So, at the prompt "ENTER USERID -", type EXZ.
H-6
-------
The following screen will appear:
TSO/E LOGON
PF1/PF13 ==> Help PF3/PF15 ==> Logoff PA1 ==> Attention PA2 ==> Reshow
You may request specific HELP information by entering a '?' in any entry field
ENTER LOGON PARAMETERS BELOW: RACF LOGON PARAMETERS:
USERID ===> EXZ
PASSWORD ===> NEW PASSWORD -—>
PROCEDURE ===> SEPATSO GROUP INDENT ===>
ACCT NMBR ===> SFRD
SIZE ===> 3000
PERFORM ===>
COMMAND ===>
ENTER AN 'S' BEFORE EACH OPTION DESIRED BELOW:
-NOMAIL -NONOTICE -RECONNECT -OIDCARD
Make sure that the USERID, PROCEDURE, ACCT NMBR (USER ACCOUNT), and SIZE are
filled in and correct. If not, move the cursor to them and fill in or correct them. Enter
your PASSWORD. (It will be blanked out so that you won't see what you typed.)
Press ENTER. You will see a list of NEWS ALERTS and the message "ENTER FIMAS ID
tt
Type BASIP and press ENTER. You will see the word "READY". You have successfully
logged onto the IBM mainframe.
II-7
-------
3. LOGON SUMMARY
To prepare to LOGON to the mainframe, you need:
a. USER ID.
b. PASSWORD.
c. USER ACCOUNT.
d. Procedure name (SEPATSO).
e. FIMAS ID (BASIP).
f. Size parameter (3000).
To LOGON:
Using a PC with modem and Crosstalk
a. Press F4.
b. Enter number of file, if there is no command file, create one:
1) At the "Enter number of the file to use" prompt, press ENTER.
2) Type NA MAINFRAM
DA 7
PA EVEN
DU HALF
3) Enter phone number "NU 94881515" (Headquarters) and press ENTER.
4) Modem should be "ON".
5) Port should be "2".
6) Type SA MAINFRAM and the 5 steps above will be saved in a command
file; from now on, when you enter crosstalk, you will see a command file
called "MAINFRAM". Simply enter the command file number associated
with that command file.
7) Type GO at the "COMMAND" prompt.
8) After the dial tone, at the "CONNECTION ESTABLISHED. PROCEED."
message, press ENTER.
c. At the "Welcome" screen:
1. Type IBM and press ENTER; "CONNECTED" will appear.
2. Type TSO and press ENTER; "ENTER LOGON" will appear.
3. Type LOGON line: USERID/PASSWORD a (USER ACCOUNT) s(3000) and
press ENTER.
d. At the "ENTER PROCEDURE NAME" prompt, type &EPATSO.
e. At the "ENTER FIMASID-" prompt, type BASIP.
Using a 3270 terminal connected to a controller
a. Type TSO.
b. At the "ENTER USERID" prompt, type your USERID and press ENTER.
c. Check USERID, PROCEDURE, ACCT NMBR (user account) and SIZE are
correct.
d. Enter PASSWORD and press ENTER.
e. At the "ENTER FIMAS ID" prompt, type BASIP and press ENTER.
II-8
-------
I
Accessing RODS
Data Base
-------
B. ACCESSING THE RODS SYSTEM
Once you reach the "READY" prompt, you have logged onto the IBM mainframe, but you
still haven't reached the RODS Data Base. The procedures below are for users who have a
brand new USER ID and for users who do not have command lists (clists) established under
their USER ID. The procedures below will establish a clist called $$LOGON. THE $$LOGON
is automatically executed every time you LOGON. If you already have a &&LOGON or if you
do not know if you have a &&LOGON, your Data Base Administrator (DBA), ADP Coordinator,
or User Support can help you determine if you have a &&LOGON.
1. ACCESSING RODS THE FIRST TIME or Establishing Clists Under Your USER ID
You must first copy a clist to your USER space. At the "READY" prompt, type:
COPY 'RODS.USER.LOGON' 'xxxaaaa.CLISP NONUM
Where xxx = your USER ID and
aaaa = your USER ACCOUNT
For example, if your USER ID = EXZ and
your USER Account= SFRD
You would type:
COPY 'RODS.USER.LOGON' 'EXZSFRD.CLISP NONUM
The "READY" prompt will reappear.
Next, so that you can get into RODS, you must execute the clist that you copied to your
USER area by typing:
ex 'xxxaaaa.CLIST($$LOGON)'
Using the example from the previous page, you would type:
ex 'EXZSFRD.CLIST($$LOGON)'
You will see the message "***** LOGON COMPLETE *****"; and the "READY" prompt will
appear again.
Next, type RODS. You will see the message "BIN/BOX?".
Type in the Bin Number or Box Number where you want your printouts to go. If you do
not know your Bin/Box Number, contact your ADP coordinator.
Next you will see the message:
"PLEASE ENTER YOUR DATA BASE ID"
H in
Type ROD. You will have successfully accessed the ROD System.
II-9
-------
2. ACCESSING RODS AFTER THE FIRST TIME
At the READY prompt, type RODS. You see the message "BIN/BOX?". Type in your
Bin/Box Number where you want your printouts to go. If you do not know your Bin/Box
number, contact your ADP coordinator.
After you type .in your Bin/Box Number, you will see the message:
"PLEASE ENTER YOU DATA BASE ID"
H /n
Type ROD. You will have successfully accessed the ROD System.
3. AN ALTERNATIVE WAY TO ACCESS RODS
If you have trouble with establishing clists or are having trouble accessing RODS, you
can access RODS by typing the following command at the "READY" prompt
ex 'RODS.USER.CLIST(RODS)'
II-10
-------
C. THE RODS MAIN MENU
Upon entering the RODS Data Base, you will see the following two introductory screens:
RRRRRR
RRRRRRR
RR RR
RR RR
RR RR
RRRRRRR
RRRRRR
RR RR
RR RR
RR RR
RR RR
RR RR
OOOOO
OOOOOO
OO
OO
OO
OO
00
00
OO
00
OO
OO
OO
00
OO
oo
00
OO
OOOOOO
OOOOO
DDDDDD
DDDDDDD
DD DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DDDDDDD
DDDDDD
sssssss
sssssssss
ss ss
ss
sss
sssssss
ssssssss
sss
ss
ss ss
sssssssss
sssssss
WELCOME TO THE
SUPERFUND
RECORDS OF DECISION
DATA BASE
II-11
-------
After these two screens, the RODS MAIN MENU will be displayed. In this menu, you
will be asked how you would like to search the RODS Data Base. The RODS MAIN MENU
allows you to either choose the RODS SEARCH MENU or the BASIS Command Language.
Those users familiar with the BASIS Command Language may prefer to use it because it is
faster and more direct than the menus. Since most users will use the RODS SEARCH MENU,
this document describes how to use those Menus to access information in the RODS Data Base.
For BASIS Command Language, refer to the BASIS User's Reference Manual.
The RODS MAIN MENU is shown below. To SEARCH using the RODS SEARCH MENU,
enter 1 at the "SELECTION:" prompt and press the ENTER key.
RODS MAIN MENU
CHOOSE ONE OF THE FOLLOWING USER LEVELS:
1 - RODS SEARCH MENU
2 - BASIS COMMAND LANGUAGE
X - EXIT
SELECTION:
11-12
-------
Search •
Command •
-------
D. THE SEARCH MENU
1. HOW TO SEARCH THE DATA BASE
When you enter the RODS Data Base via the RODS SEARCH MENU selection from the
RODS MAIN MENU, the SEARCH MENU is displayed:
SEARCH
EACH ROD CONTAINS THE FOLLOWING SEARCHABLE INFORMATION FIELDS:
IDENTIFICATION ENVIRONMENT TEXT
1. REGION 6. CONTAMINATED MEDIA 9. SELECTED REMEDY
2. STATE 7. KEY CONTAMINANTS 10. ABSTRACT
3. SITE NAME 8. SELECTED KEY WORDS 11. ROD TEXT
4. ROD ID NUMBER
5. ROD DATE
ENTER:
THE NUMBER FOR THE INFORMATION FIELD TO SEARCH, OR
H - FOR HELP EXPLANATIONS, OR
M - TO RETURN TO THE MAIN MENU, OR
X - TO EXIT THE ROD SYSTEM
SELECTION:
The SEARCH MENU contains a list of the 11 fields you can use to search the data base.
The SEARCH MENU allows you to choose four actions:
1) Select a field to SEARCH;
2) Go to HELP MENUS;
3) Return to the MAIN MENU; and
4) Exit the ROD System.
The main purpose of the SEARCH MENU is to allow you to select the field you would
like to SEARCH. To select a field, enter the field number at the "SELECTION:" prompt. For
example, to SEARCH by Region, enter 1 after "SELECTION:".
The SEARCH MENU also allows you to access the HELP function. The HELP function is
described fully in Section F of this chapter. Briefly, the HELP function gives you information
about the fields in the data base, indexed terms, and some general topics.
Finally, the SEARCH MENU allows you to return to the MAIN MENU (enter M) or to
EXIT the RODS Data Base (enter X).
II-13
-------
If you choose to SEARCH a field by Region (enter 1 at the "SELECTION:" prompt) for
example, the REGION INFORMATION SEARCH Screen will be displayed:
REGION INFORMATION SEARCH
ENTER:
- A SINGLE REGION (1), OR
- MULTIPLE REGIONS SEPARATED BY COMMAS (1,3).
FIND REGION =
At the "FIND REGION =" prompt, enter the SEARCH term (i.e., the Region number you
would like to locate in the data base). Each field has a unique SEARCH Screen. Each
SEARCH Screen explains the format you must enter to SEARCH a term. For example, in the
REGION INFORMATION SEARCH Screen, you are allowed to enter a single Region or multiple
Regions separated by commas. If you would like to find all RODs from Region 5, for example,
enter 5 at the prompt. If you would like to find all RODs from Region 4, 5, and 6, enter
4,5,6 at the prompt.
In another example, if you choose to SEARCH the "TEXT" field, enter an 11 at the
"SELECTION:" prompt. The ROD TEXT SEARCH screen will be displayed:
ROD TEXT SEARCH
ENTER:
- A SINGLE WORD (MERCURY), OR
- MULTIPLE WORDS (SOIL MERCURY)
FIND ROD TEXT
At the "FIND ROD TEXT »" prompt, enter the SEARCH term (i.e., the word or words you
would like to SEARCH for in the TEXT field). For example, if you would like to find all
RODs which mention chromium in the TEXT field, enter chromium at the prompt.
A discussion of each of the field SEARCH Screens can be found in Section 2, which
follows.
II-14
-------
After you have selected a field to SEARCH and entered a SEARCH term, BASIS will find
every occurrence of that SEARCH term within the specified field. The following message will
then be displayed telling you how many RODs contain the SEARCH term:
"29 RODS WERE FOUND AND SAVED AS SEARCH SET 1"
The message shows that 29 RODs contain your SEARCH term. Each SEARCH you
perform is numbered sequentially. The first SEARCH is labelled SEARCH SET 1, the second
SEARCH is labelled SEARCH SET 2, etc.
To continue SEARCHing, enter SE and "SEARCH MENU" will be displayed or enter M to
return to the RODS MAIN MENU. BASIS finds every occurrence and gives you the message:
"XX RODS WERE FOUND AND SAVED AS SEARCH SET XX"
2. THE FIELD SEARCH SCREENS
This section contains all the field SEARCH screens used in SEARCHing the RODS Data
Base. Valid and invalid SEARCH terms have been listed for each field.
a. REGION INFORMATION SEARCH SCREEN
The REGION INFORMATION SEARCH Screen allows the user to search only region
information fields for specific region(s).
REGION INFORMATION SEARCH
ENTER:
- A SINGLE REGION (1), OR
- MULTIPLE REGIONS SEPARATED BY COMMAS (1,3).
FIND REGION =
Valid SEARCH terms:
TERM RESULT
1 RODs from Region 1
01 RODs from Region 1
I RODs from Region 1
1,2 RODs from Regions 1 and 2
4,5,6 RODs from Regions 4, 5, and 6
Invalid SEARCH terms:
TERM CORRECT TERM
1-4 1,2,3,4
11-15
-------
b. STATE INFORMATION SEARCH SCREEN
The STATE INFORMATION SEARCH Screen allows the user to search only state
information fields for specific state(s).
STATE INFORMATION SEARCH
ENTER:
- A SINGLE STATE (VA), OR
- MULTIPLE STATES SEPARATED BY COMMAS (VA.MD)
FIND STATE
Valid SEARCH terms:
TERM RESULT
NJ RODs from New Jersey
NJ,NY RODs from New Jersey and New York
The state abbreviations are listed by Region in Table 1 on the following page.
Invalid SEARCH terms:
TERM CORRECT TERM
Ohio OH
NH MA NH.MA
II-16
-------
TABLE 1. STATE ABBREVIATIONS BY REGION
REGION I REGION VI
CT = CONNECTICUT
NH = NEW HAMPSHIRE
MA= MASSACHUSETTS
ME = MAINE
VT = VERMONT
RI = RHODE ISLAND
REGION II
NJ = NEW JERSEY
NY = NEW YORK
PR = PUERTO RICO
VI = VIRGIN ISLANDS
REGION III
AR = ARKANSAS
LA = LOUISIANA
NM m NEW MEXICO
OK = OKLAHOMA
TX - TEXAS
REGION VII
IA = IOWA
KS - KANSAS
MO - MISSOURI
NE - NEBRASKA
REGION VIII
DE = DELAWARE CO = COLORADO
DC = DISTRICT of COLUMBIA ND = NORTH DAKOTA
MD= MARYLAND
PA = PENNSYLVANIA
VA = VIRGINIA
WV = WEST VIRGINIA
REGION IV
AL = ALABAMA
FL = FLORIDA
GA = GEORGIA
KY = KENTUCKY
MS = MISSISSIPPI
TN = TENNESSEE
NC = NORTH CAROLINA
SC = SOUTH CAROLINA
REGION V
IL = ILLINOIS
IN - INDIANA
MI = MICHIGAN
MN= MINNESOTA
OH » OHIO
WI - WISCONSIN
MT = MONTANA
SD » SOUTH DAKOTA
UT = UTAH
WY = WYOMING
REGION IX
AS = AMERICAN SAMOA
AZ = ARIZONA
CA = CALIFORNIA
GU = GUAM
HI = HAWAII
NV = NEVADA
PR = PUERTO RICO
REGION X
AK - ALASKA
ID - IDAHO
OR - OREGON
WA = WASHINGTON
II-17
-------
c. SITE NAME SEARCH SCREEN
The SITE NAME SEARCH Screen allows the user to search only site name fields for a
specific site name (or portion of a site name).
SITE NAME SEARCH
ENTER:
- THE FULL NAME (LANSDOWNE RADIATION) OR
- A PORTION OF THE SITE NAME (LANSDOWNE)
FIND SITE NAME =
Valid SEARCH terms:
TERMS RESULT
Moyer Landfill RODs with name MOVER LANDFILL
Landfill RODs with LANDFILL in the name
STR* RODs with one word in the name starting with STR
Invalid SEARCH terms:
No SEARCH terms are really invalid. The system will SEARCH the SITE NAME field for
whatever term you enter. If your SEARCH term is not in the data base, you will create
a SEARCH SET which contains 0 RODs, and the following message will be displayed:
"0 RODS WERE FOUND AND SAVED AS SEARCH SET 1"
11-18
-------
d. ROD IDENTIFICATION NUMBER SEARCH SCREEN
The ROD ID number contains the Region, year, and sequence number of a ROD written
in that year for a specific Region. For example, the ROD ID R05-84/003, is the 3rd ROD
written in 1984 for Region 05.
ROD IDENTIFICATION NUMBER SEARCH
ENTER:
- A ROD IDENTIFICATION NUMBER
IN THE FORMAT R05-84/003
FIND ROD IDENTIFICATION NUMBER »
Valid SEARCH terms:
TERM RESULT
RO1-85/014 ROD with that ROD ID
R03-84/001 ROD with that ROD ID
R10-86/008 ROD with that ROD ID
R05* All RODs from Region 5
Invalid SEARCH terms:
TERM CORRECT TERM
R0285012 R02-85/012
R04/85-004 R04-85/004
R6-86/12 R06-86/012
11-19
-------
e. ROD DATE INFORMATION SEARCH SCREEN
The ROD DATE INFORMATION SEARCH Screen allows the user to search only ROD date
fields for a specific date(s). The ROD date is the date that the Regional Administrator or
Assistant Administrator signed the ROD.
ROD DATE INFORMATION SEARCH
TER:
- A SINGLE ROD DATE (07/22/85), OR
- A RANGE OF DATES (07/01/85:09/30/85), OR
- A FISCAL YEAR (83), OR
- MULTIPLE FISCAL YEARS (84,85)
FIND ROD DATE
Valid SEARCH terms:
TERM
09/30/85
01/01/84:06/30/84
85
86,87
Invalid SEARCH terms:
TERM
November 11, 1983
1985
82-84
RESULT
RODs signed September 30, 1985
RODs signed from January 1 through June 30, 1984
RODs signed in FY 1985 (from October 1, 1984 -
September 30, 1985)
RODs signed in FY 1986 & 1987
CORRECT TERM
11/11/83
85 (for FY 1985) or 01/01/85:12/31/85
(for Calendar Year 1985)
82,83,84 (for FY 82, 83, 84)
II-20
-------
f. CONTAMINATED MEDIA SEARCH SCREEN
The CONTAMINATED MEDIA SEARCH Screen allows the user to search only
contaminated media fields for a specific contaminated media (or multiple media).
CONTAMINATED MEDIA SEARCH
ENTER:
- A SINGLE MEDIA (SOIL), OR
- MULTIPLE MEDIA SEPARATED BY "OR" (SOIL OR GROUNDWATER), OR
- MULTIPLE MEDIA SEPARATED BY "AND" (SOIL AND GROUNDWATER)
FIND CONTAMINATED MEDIA =
Valid SEARCH terms:
TERM
Sediment
Sediments
Sediment*
Ground Water
Groundwater
Ground*
Soil and Groundwater
Soil or Groundwater
RESULT
RODs with Sediment
RODs with Sediments
RODs with either Sediment or Sediments, etc.
RODs with Ground Water
RODs with Groundwater
RODs with Ground Water, Ground, Groundwater, etc.
RODs with both Soil and Groundwater
RODs with either Soil or Groundwater
NOTE: There are very few valid terms being used in the CONTAMINATED MEDIA field
(less than 60).
Invalid SEARCH terms:
No SEARCH terms are really invalid. The system will SEARCH the CONTAMINATED
MEDIA field for whatever term you enter. If your SEARCH term is not in the
CONTAMINATED MEDIA field, you will create a SEARCH SET which contains 0 RODs,
and the following message will be displayed:
"0 RODS WERE FOUND AND SAVED AS SEARCH SET 1"
II-21
-------
g. KEY CONTAMINANTS SEARCH
The KEY CONTAMINANTS SEARCH Screen
contaminant fields for specific key contaminant(s).
allows the user to search only key
KEY CONTAMINANTS SEARCH
ENTER:
- A SINGLE KEY CONTAMINANT (LEAD), OR
- MULTIPLE KEY CONTAMINANTS SEPARATED BY "OR" (LEAD OR PCBS), OR
- MULTIPLE KEY CONTAMINANTS SEPARATED BY "AND" (LEAD AND PCBS)
FIND KEY CONTAMINANT =
Valid SEARCH terms:
Metal
Metals
Metal*
Hexavalent Chromium
Chromium
Dioxin and PCB*
Heavy Metal* or Lead
Invalid SEARCH terms:
RESULT
RODs with Metal
RODs with Metals
RODs with Metal, Metallic, Metals, etc.
RODs with Hexavalent Chromium
RODs with Chromium
RODs with both Dioxin and PCB*, PCBs, etc.
RODs with either Heavy Metal* or Lead
No SEARCH terms are really invalid. The system will SEARCH the KEY CONTAMINANTS
field for whatever term you enter. If your SEARCH term is not in the KEY
CONTAMINANTS field, you will create a SEARCH SET which contains 0 RODs, and the
following message will be displayed:
"0 RODS WERE FOUND AND SAVED AS SEARCH SET 1"
II-22
-------
h. KEY WORDS SEARCH SCREEN
The KEY WORDS SEARCH Screen allows the user to search only key word fields for
specific key word(s).
KEY WORDS SEARCH
ENTER:
- A SINGLE KEY WORD (SEDIMENTS), OR
- MULTIPLE KEY WORDS SEPARATED BY "OR" (SEDIMENTS OR PCBS), OR
- MULTIPLE KEY WORDS SEPARATED BY "AND" (SEDIMENTS AND PCBS)
FIND KEY WORD
Valid SEARCH terms:
TERM RESULT
PCBs RODs with PCBs
Drinking Water RODs with Drinking Water
Incineration RODs with Incineration
Federal Facilities RODs with Federal Facilities
PCBs and Sediments RODs with both PCBs and Sediments
Floodplain or Flood Plain RODs with either Floodplain or Flood Plain
Invalid SEARCH terms:
No SEARCH terms are really invalid. The system will SEARCH the KEY WORDS field for
whatever term you enter. If your SEARCH term is not in the KEY WORDS field, you
will create a SEARCH SET which contains 0 RODs, and the following message will be
displayed:
"0 RODS WERE FOUND AND SAVED AS SEARCH SET 1"
II-23
-------
i. SELECTED REMEDY SEARCH SCREEN
The SELECTED REMEDY SEARCH Screen allows the user to search selected remedy fields
for specific remedy(ies).
SELECTED REMEDY SEARCH
ENTER:
- A SINGLE WORD (OFFSITE), OR
- MULTIPLE WORDS (OFFSITE FACILITY)
FIND SELECTED REMEDY =
Valid SEARCH terms:
TERM
Offsite
Offsite Facility
Invalid terms:
RESULT
RODs with Offsite
RODs with both Offsite and Facility
No SEARCH terms are really invalid. The system will SEARCH the REMEDY field for
whatever term you enter. If your SEARCH term is not in the REMEDY field, you will
create a SEARCH SET which contains 0 RODs, and the following message will be
displayed:
"0 RODS WERE FOUND AND SAVED AS SEARCH SET 1"
II-24
-------
j. ABSTRACT SEARCH SCREEN
The ABSTRACT SEARCH Screen allows the user to search only ROD abstract fields for a
specific words or group of words, but not the ROD text.
ABSTRACT SEARCH
ENTER:
- A SINGLE WORD (METALS), OR
- MULTIPLE WORDS (SLUDGE METALS)
FIND ABSTRACT
Valid SEARCH terms:
TERM RESULT
Radiation RODs with Radiation
Herbicide* RODs with Herbicide, Herbicides, etc.
Heavy Metals RODs with both Heavy and Metals, together
Invalid SEARCH terms:
No SEARCH terms are really invalid. The system will SEARCH the ABSTRACT field for
whatever term you enter. If your SEARCH term is not in the ABSTRACT field, you will
create a SEARCH SET which contains 0 RODs, and the following message will be
displayed:
"0 RODS WERE FOUND AND SAVED AS SEARCH SET 1"
H-25
-------
k. ROD TEXT SEARCH SCREEN
The ROD TEXT SEARCH Screen allows the user to search only the actual text of the
ROD for a specific word or group of words, but not the abstracts.
ROD TEXT SEARCH
ENTER:
- A SINGLE WORD (MERCURY), OR
- MULTIPLE WORDS (SOIL MERCURY)
FIND ROD TEXT
Vali'd SEARCH terms:
TERM RESULT
Estuary RODs with Estuary
Estuar* RODs with Estuary, Estuaries, Estuarine, etc.
Incineration PCB* RODs with both Incineration and PCB*
Invalid SEARCH terms:
No SEARCH terms are really invalid. The system will SEARCH the TEXT field for
whatever term you enter. If your SEARCH term is not in the TEXT field, you will
create a SEARCH SET which contains 0 RODs, and the following message will be
displayed:
"0 RODS WERE FOUND AND SAVED AS SEARCH SET 1"
If you enter more than one word to search for in the text field, the following screen
appears:
11-26
-------
TEXT SEARCH CONTINUED
You have chosen to search the TEXT field for the
following search terms: chromium lead
Choose the way you'd like you search terms found.
ENTER:
1 - SEARCH TERM MUST BE IN THE SAME SENTENCE
2 - SEARCH TERMS CAN BE ANYWHERE IN THE TEXT FIELD
SELECTION:
This screen allows you to decide if you want your search terms:
1) To be in the same sentence; or
2) To be anywhere in the same ROD.
In the screen above, the user is searching for chromium and lead. If a 1 is entered at
the "SELECTION:" prompt, the system will only find the occurrences of those terms in the
same sentence. For example: "LEAD AND CHROMIUM ARE KEY CONTAMINANTS AT THE
SITE".
If a 2 is entered at the "SELECTION:" prompt, the system will find all RODS which
contain both terms. The terms can be in the same sentence or in different sentences, but
both terms must be present in the ROD.
3. WHAT IS A SEARCH SET?
A SEARCH SET (also called a document set) is a set of related RODS. There are four
ways to create a SEARCH SET in RODS:
1) Using SEARCH;
2) Using COMBINE;
3) Using SORT; and
4) Using SELECT when DISPLAYing text.
a. CREATING SEARCH SETS USING SEARCH
A SEARCH SET is created automatically when you SEARCH. The SEARCH you perform
determines how the RODs are related. For example, if you choose to SEARCH for all RODs in
Region 2 (FIND REGION-2), the following message will be displayed:
"23 RODS WERE FOUND AND SAVED AS SEARCH SET 1"
As shown, a SEARCH SET consisting of 23 related RODs was created. The RODs are related
because they are all from Region 2. These 23 RODS are saved as SEARCH SET 1.
In another example, if you choose to SEARCH for all RODs from FY 85 (FIND ROD
DATE=85), the following message will be displayed:
"65 RODS WERE FOUND AND SAVED AS SEARCH SET 2"
All the RODs in SEARCH SET 2 are related because they are all from FY 85.
11-27
-------
b. CREATING SEARCH SETS USING COMBINE
SEARCH SETS are also created when you COMBINE existing SEARCH SETS using ("CO"
from the SELECTION MENU described in Section E). Using the example from the previous
page, if you want to find all RODs from Region 2 that were signed in FY 85, you can enter a
COMBINE term, 1 and 2 (meaning find all RODs that meet the SEARCH criteria of both
SEARCH SETS 1 and 2), and the following messages will be displayed:
"13 RODS MET THE CONDITIONS OF YOUR COMBINE;"
"THEY WERE SAVED AS SEARCH SET 3"
As shown, all the RODs in SEARCH SET 3 are related because they all are from Region 2 and
were all signed during FY 85.
c. CREATING SEARCH SETS USING SORT
SEARCH SETS are created when you SORT existing SEARCH SETS ("SO" from the
SELECTION MENU). The actual contents of the SEARCH SET do not change; only the order
of the RODs within the SEARCH SET. Continuing with the above example, if you choose to
SORT SEARCH SET 3 by SITE NAME, the following message will be displayed:
"YOUR SORT WAS COMPLETED AND SAVED AS SEARCH SET 4"
If you were to display SEARCH SET 4, you would find that it contains all RODs from Region
2 that were signed in FY 85, in alphabetical order by SITE NAME.
You may sort a SEARCH SET to alphabetize the items or to order elements in chronological
order, etc.
d. CREATING SEARCH SETS USING SELECT WHEN DISPLAYING TEXT
The final way a SEARCH SET is created is when you use the SELECT function in the
DISPLAY of the TEXT field. It is described in detail in Section El., DISPLAYING THE
RESULTS.
4. SPECIAL SEARCH FEATURES
a. THE WILD CARD CHARACTER C)
The Wild Card Character in the RODS Data Base is the asterisk (*). The wild card
character adds a lot of flexibility to your SEARCHing by allowing you to SEARCH for partial
words or phrases. For example, if you entered the SEARCH term CONTAM1 (FIND
TEXT=CONTAM*) you would find all RODs that contain the following terms in the TEXT field:
contaminant contaminate contaminates
contaminant's contaminated contaminating
contaminants contaminating contamination
contaminations
In another example, if the SEARCH term INCINER* (FIND TEXT=INCINER*) was entered,
the system would find all RODs that contain the following terms in the TEXT field:
incinerable incineration-oil incineration/landfill incineration/wet
incinerate incineration-organic incineration/off-site incinerator
incinerated incineration-rotary incineration/offsite
incinerates incineration/deep incineration/solidification
incinerating incineration/disposal incineration/stablilization
incineration incineration/groundwater incineration/thermal
H-28
-------
b. THE INDEX FEATURE IN THE HELP MENU
The Index feature actually lets you look at the terms for a specific field that are in the
data base. This feature is described in detail in the Section F, HELP.
5. SPECIAL EMBEDDED TERMS IN THE TEXT FIELD
The text of each ROD is divided into may sections. However, since the actual headings
of these sections vary, a number of section markers have been embedded in the text field to
make the sections easier to find. The section markers and corresponding text section names
are listed on the following pages.
To use the section markers to find a section in the text field, you must search the text
field for the text section you would like to see. For example, if you want to look at
Alternatives Evaluations, you would search:
FIND TEXT = #AE
The system will respond by telling you how many RODS have #AE. Since most RODs DO have
an Alternatives Evaluations, you may want to refine your search by combining the search set
created by searching:
TEXT = #AE
When you DISPLAY the text field from the Text
Alternatives Evaluations section of the text.
i #AE search, you will immediately see the
Other text fields to search on listed below:
#AE = ALTERNATIVES EVALUATION
#CR = COMMUNITY RELATIONS
#CSS = CURRENT SITE STATUS
#DE = DECLARATION
#DR = DOCUMENTS REVIEWED
#ENF= ENFORCEMENT
#FA = FUTURE ACTIONS
#OEL= CONSISTENCY WITH OTHER
ENVIRONMENTAL LAWS
#OM = OPERATIONS & MAINTENANCE
#RA = RECOMMENDED ALTERNATIVE
#RS = RESPONSIVENESS SUMMARY
#SCH = SCHEDULE
#SH = SITE HISTORY
#SLD = SITE LOCATION & DESCRIPTION
#TMA = TABLES, MEMORANDA,
ATTACHMENTS
11-29
-------
E. THE SELECTION MENU
After you have performed a SEARCH, the SELECTION MENU will be displayed:
SELECTION MENU
AT THIS POINT, YOU MAY:
MANIPULATE CURRENT SEARCH SET
PERFORM OTHER FUNCTIONS
DI - DISPLAY RESULTS
SO - SORT RESULTS
PR- PRINT RESULTS
SELECTION:
SE - CONTINUE SEARCHING
CO - COMBINE SEARCHES
LI - LIST SEARCH SETS
M - RETURN TO MAIN MENU
H - FOR HELP EXPLANATIONS
X - EXIT RODS
The SELECTION MENU allows you to manipulate SEARCHes that you have already
created, or to continue SEARCHing the data base. The following selections are available:
DI - DISPLAY the results of a SEARCH.
SO - SORT your SEARCH.
PR - PRINT portions of a SEARCH.
SE - Continue SEARCHing the data base.
CO - COMBINE the results of two or more SEARCHes using AND, OR, and ANDNOT.
LI - LIST the SEARCH SETS you have created so far, change your current SEARCH
SET, and DELETE all your SEARCH SETS.
Each one of the selections is explained in detail on the next few pages. Figure 2 is a
functional diagram showing the relationship between CURRENT SEARCH SETS and OTHER
FUNCTIONS.
II-30
-------
ENTER THE DATA BASE
HELP
LIST
PRINT
1
SEARCH*
-*
SELECTION MENU
SEARCH SETS
OPTIONS
DISPLAY*
EXIT
DATA
BASE
*These functions can be used to create new SEARCH SETS.
FIGURE 2. RODS DATA BASE FUNCTIONAL RELATIONSHIP DIAGRAM
11-31
-------
This page intentionally left blank. Turn page and proceed.
II-32
-------
Display
Command
I
-------
1. DISPLAYING THE RESULTS
When you select DI (DISPLAY) from the SELECTION MENU, the following DISPLAY
MENU will be displayed:
DISPLAY
YOU MAY DISPLAY:
1 - IDENTIFICATION INFORMATION ONLY, OR
2 - ENVIRONMENTAL INFORMATION ONLY, OR
3 - SELECTED REMEDY AND ABSTRACT ONLY, OR
4 - ROD TEXT ONLY, OR
5 - A LIST OF FIELDS AVAILABLE TO DISPLAY
SELECTION:
Options 1 through 4 of the DISPLAY MENU are predefined displays. Option 5 allows you
to select which fields to DISPLAY. For all five options, DISPLAY work against your current
SEARCH SET (i.e., the last SEARCH SET you created). If you would like to DISPLAY another
SEARCH SET, you can make one of your other SEARCH SETS current by selecting the list
(LI) option in the SELECTION MENU (see Section 4).
The following fields are associated with Options 1 through 4.
• Fields for Option 1, IDENTIFICATION INFORMATION ONLY:
REGION, LOCATION, SITE NAME, ROD ID NUMBER, and ROD DATE
• Fields for Option 2, ENVIRONMENTAL INFORMATION ONLY:
SITE NAME, ROD DATE, CONTAMINATED MEDIA, KEY CONTAMINANTS, and
KEY WORDS
• Fields for Option 3, SELECTED REMEDY AND ABSTRACT ONLY:
SITE NAME, ROD DATE, SELECTED REMEDY, and ABSTRACT
• Fields for Option 4, ROD TEXT ONLY:
SITE NAME, ROD DATE, and ROD TEXT
If you select Option 5, you are prompted to select which fields to DISPLAY. You can
choose to DISPLAY one field or multiple fields from the following screen:
II-33
-------
THESE ARE THE FIELDS YOU CAN DISPLAY:
IDENTIFICATION ENVIRONMENTAL
1. REGION 7. CONTAMINATED MEDIA
2. LOCATION 8. KEY CONTAMINANTS
3. SITE NAME 9 SELECTED KEY WORDS
4. ROD ID NUMBER
5. SITE ID NUMBER
6. ROD DATE
ENTER:
- A SINGLE DISPLAY FIELD (3), OR
- MULTIPLE DISPLAY FIELDS (1,3,4,6)
DISPLAY =
TEXT
10. SELECTED REMEDY
11. ABSTRACT
12. ROD TEXT
13. TEXT SECTIONS
14. FIGURESJABLES, ETC
For all five DISPLAY options, after one or two items have been displayed, you will see
the following message:
"DO YOU WANT TO SEE THE NEXT ITEM (YES:NO)?"
If you enter YES, the next item will be displayed. If you enter NO, the SELECTION MENU
will be redisplayed. After all items in your SEARCH SET have been displayed, the
SELECTION MENU will be redisplayed.
a. SPECIAL FEATURES WHEN DISPLAYING THE TEXT FIELD
There are several unique DISPLAY features for DISPLAYing the TEXT field. First, if the
SEARCH SET you are DISPLAYing was created by SEARCHing the TEXT field (i.e., "FIND
TEXT ="), the context areas containing your SEARCH term will be highlighted with 2 asterisks
(**) in the left columns. The system starts by DISPLAYing the first context area which
contains your SEARCH term.
Second, if the SEARCH SET you are DISPLAYing was created by SEARCHing a field
other then the TEXT field, no context areas are highlighted. The system starts by
DISPLAYing the top of the TEXT field.
Third, there are 7 commands that you can use when DISPLAYing the TEXT field.
a portion of the TEXT has been displayed, you will see the following command lines:
ENTER:NEXT(next ROD),HIT(next context),TOP(entire ROD),
UP(window up),DOWN(window down),SELECT(this ROD),EXIT(end)
After
11-34
-------
All seven commands are explained as follows:
NEXT
HIT
TOP
UP
DOWN =
SELECT =
EXIT
This command takes you to the next ROD (next document) in your SEARCH
SET and displays it. If there are no more RODs to be displayed, NEXT
returns you to the SELECTION MENU.
This command takes you to the next context within the current ROD. HIT is
only used when the SEARCH SET you are displaying was created by
SEARCHing the TEXT field. This command takes you to the next occurrence
of your SEARCH term. If no more occurrences of your SEARCH term are
present in the TEXT, or if you did not SEARCH the TEXT field, you will see
the message "**End of document reached**" The command lines are then
displayed.
This command displays the entire TEXT field. BE CAREFUL when using the
TOP command as the ENTIRE TEXT will be displayed. Some RODs are very
long, so it may take a long time for the entire TEXT field to be displayed.
USE THIS COMMAND CAREFULLY!
This command allows you to display the previous 12 lines of the TEXT field
This command allows you to dkslay the next 12 lines of the TEXT field.
This command allows you to create a SEARCH SET by SELECTing which RODs
in a SEARCH SET are pertinent to your SEARCH.
This command lets you end your display and returns you to the SELECTION
MENU.
To use these commands, enter the entire command at the "/" prompt at the end of the
command line.
II-35
-------
This page intentionally left blank. Turn page and proceed.
II-36
-------
Sort
Command
-------
2. SORTING YOUR RESULTS
When you select SO (SORT) from the SELECTION MENU, the following SORT MENU will
be displayed:
SORT
SELECT THE FIELD(S) TO SORT ON FROM THE FOLLOWING LIST:
1. REGION
2. STATE
3. SITE NAME
4. ROD ID NUMBER
5. ROD DATE
ENTER:
- A SINGLE SORT FIELD (1), OR
- MULTIPLE SORT FIELDS SEPARATED BY COMMAS (1,3)
SORT =
The SORT function allows you to SORT the data in one of the following five ways:
1) Numerically by REGION;
2) Alphabetically by STATE;
3) Alphabetically by SITE NAME;
4) Numerically by ROD ID NUMBER; and
5) Sequentially by ROD DATE.
You can specify more than one SORT criterion. The first one is the primary SORT
criterion and it takes precedence over all the other SORT criteria.
After the SORT is completed, you will see the following message:
"YOUR SORT WAS COMPLETED AND SAVED AS SEARCH SET 2"
After the message, the SELECTION MENU will be redisplayed.
11-37
-------
Combine
Command
-------
3. COMBINING YOUR SEARCH SETS
When you select CO (COMBINE) from the SELECTION MENU, the COMBINE SEARCH
SETS MENU will be displayed:
COMBINE SEARCH SETS
COMBINE ALLOWS YOU TO REFINE YOUR SEARCH BY COMBINING
SEARCH SETS USING THE FOLLOWING OPERATORS:
OR = ONE OR THE OTHER OR BOTH
AND = BOTH ONE AND THE OTHER
ANDNOT . ONE AND NOT THE OTHER
EXAMPLES OF THE COMBINE EXPRESSION FORMAT ARE:
1 AND 3 AND 4
1 ANDNOT 2
1 OR 3 OR 4
1 AND 4 ANDNOT 2
PRESS ENTER TO CONTINUE:
YOU HAVE CREATED THE FOLLOWING SEARCH SETS:
3/ LIST
SETNO: NO.ITEMS: REQUEST:
SET 1: 19 REG=1
SET 2: 91 TEXT=chromium
ENTER:
A COMBINE EXPRESSION (1 AND 2), OR
SE - TO CONTINUE SEARCHING
R - TO RETURN TO THE SELECTION MENU
SELECTION:
There are two COMBINE MENU Screens as shown on the previous page. The first
contains information about how the COMBINE function works. The second lists the SEARCH
SETS you have created and prompts you to enter a selection. The second COMBINE MENU
allows you to do three things:
11-39
-------
1) Enter a COMBINE expression (e.g., 1 AND 2);
2) Go back to the SEARCH MENU (enter SE); or
3) Go back to the SELECTION MENU (enter R).
To create a COMBINE expression, you must use one of the following operators:
AND = both one and the other
OR = one or the other or both
ANDNOT = one and not the other
In addition, you must also know the SEARCH SET numbers, because these numbers, along
with the operators, are used to create the COMBINE expression. This is best illustrated by
the following example:
You have created the following SEARCH SETS:
SEARCH SET SEARCH NUMBER
NUMBER CRITERIA OF RODS
1 Region=3 26
2 Location=MD 8
3 ROD Date=85 65
If you COMBINE SEARCH SETS 1 AND 3, a SEARCH SET will be created for all RODs
from Region 3 that were signed during FY85; the resulting SEARCH SET contains 14 RODs.
You now have created 4 SEARCH SETS:
SEARCH SET SEARCH NUMBER
NUMBER CRITERIA OF RODS
1 Region=3 26
2 Location=MD 8
3 ROD Date=85 65
4 1 AND 3 14
If you now COMBINE 1 OR 3, a SEARCH SET will be created for all RODs from Region
3 together with all RODs signed in FY85; the resulting SEARCH SET will contain 77 RODs.
You now have created 5 SEARCH SETS:
SEARCH SET SEARCH NUMBER
NUMBER CRITERIA OF RODS
1 Region=3 26
2 Location=MD 8
3 ROD Date=85 65
4 1 AND 3 14
5 1 OR 3 77
II-40
-------
Notice that search set 5 has 77 documents in it and not 91 (which would be the sum of
65 and 26). The reason for this is that 14 documents were common to (overlapped) both sets:
RODS
SIGNED
IN'85
RODS
IN
REGION 3
RODS in Region 3 that were signed in 1985.
FIGURE 3. VENN DIAGRAM SHOWING COMMON SEARCH SET
Another way to look at it is that:
• There were 12 documents in Region 3 that were signed in 1985.
• There were 51 documents signed in 1985 that were not from Region 3.
• There were 14 documents that were in Region 3 that were signed in 1985.
So the total of all documents in both sets is: 12 +51+14 = 77.
If you now COMBINE 1 ANDNOT 2, a SEARCH SET will be created for all RODs from
REGION 3 excluding those in Maryland. (Your SEARCH SET will contain all RODs in PA, WV,
VA, DE, and DC.) The resulting SEARCH SET will contain 18 RODs.
You now have created 6 SEARCH SETS:
SEARCH SET
NUMBER
1
2
3
4
5
6
SEARCH
CRITERIA
Region=3
Location=MD
ROD Date=85
1 AND 3
1 OR 3
1 ANDNOT 2
NUMBER
OF RODS
26
8
65
14
77
18
After a COMBINE is completed, you will see a message similar to the one shown below:
"18 RODS MET THE CONDITIONS OF YOUR COMBINE STATEMENT;"
"THEY WERE SAVED AS SEARCH SET 6."
After the message, the SELECTION MENU will be redisplayed.
11-41
-------
There is another COMBINE screen which appears only if you are COMBINing two or more
SEARCH SETS that were created by searching the TEXT field.
COMBINE CONTINUED
You have chosen to combine search sets that were
created by searching the TEXT field. Choose the
way you'd like your search terms found.
ENTER:
1 - SEARCH TERMS FROM THE SETS MUST BE IN THE SAME SENTENCE
2 - SEARCH TERMS FROM THE SETS CAN BE ANYWHERE IN THE TEXT FIELD
SELECTION:
V
This screen allows you to decide if you want your search terms from the sets you are
COMBINing:
1) To be in the same sentence; or
2) To be anywhere in the same ROD.
If a 1 is entered at the "SELECTION:" prompt, the system will only find the occurrences
of the search terms in the same sentence.
If a 2 is entered at the"SELECTION:" prompt, the system will find all RODs which
contain both terms. The terms can be in the same sentence or in different sentences, but
both terms must be present in the ROD.
11-42
-------
List
Command
I
-------
4. LISTING THE SEARCH SETS YOU HAVE CREATED
When you select LI (LIST) from the SELECTION MENU, the LIST Screen will be
displayed:
LIST
YOU HAVE CREATED THE FOLLOWING SEARCH SETS:
4/ LIST
SETNO: NO.ITEMS: REQUEST:
SET 1: 21 reg=l
SET 2: 42 reg=2
SET 3: 35 reg=3
SEARCH SET 3 IS YOUR CURRENT SEARCH SET.
DO YOU WANT TO MAKE ONE OF YOUR OTHER SETS CURRENT?
The LIST Screen has three functions:
• It LISTs all the SEARCH SETS that you have created;
• It can be used to make a non-current SEARCH SET "CURRENT"; and
• It gives you the opportunity to delete all your SEARCH SETS.
Your "CURRENT SEARCH SET" is the last set that you have created. In the example
above, SEARCH SET 3 is the CURRENT set. Three of the selections in the SELECTION
MENU work only against your CURRENT SEARCH SET; they are DISPLAY, SORT, and PRINT.
If you would like to use one of these commands for a SEARCH SET that is not CURRENT,
you will have to make your desired SEARCH SET "CURRENT".
After the list of SEARCH SETS is displayed, a message will tell you which SEARCH SET
is "CURRENT", then you will be prompted as follows:
"DO YOU WANT TO MAKE ONE OF YOUR OTHER SETS CURRENT?"
If you do want to make one of your other sets "CURRENT", enter YES or Y. If not,
enter NO or N. If you entered YES, you will be prompted as follows:
"ENTER THE SEARCH SET NUMBER YOU WANT TO BE CURRENT:"
Referring back to the example on the previous page, if you want SEARCH SET 1 to be
"CURRENT", enter 1. The following message will be displayed:
"SEARCH SET 1 IS NOW THE CURRENT SEARCH SET;"
"IT IS SAVED AS SEARCH SET 4"
II-43
-------
Next, the SELECTION MENU will be redisplayed. If you list your SEARCH SETS again,
you will see the following LIST Screen:
LIST
YOU HAVE CREATED THE FOLLOWING SEARCH SETS:
5/ LIST
SETNO: NO.ITEMS: REQUEST:
SET 1: 21 reg=l
SET 2: 42 reg=2
SET 3: :5 reg=3
SET 4: 21 1
SEARCH SET 4 IS YOUR CURRENT SEARCH SET.
DO YOU WANT TO MAKE ONE OF YOUR OTHER SETS CURRENT?
As you can see, SEARCH SET 4 is your CURRENT set. The "1" in the REQUEST column
indicates that it is exactly the same SEARCH SET as SET 1.
If you had decided not to make another set CURRENT and had entered "NO" at the
prompt, you would have been prompted as follows:
"DO YOU WANT TO DELETE YOUR SEARCH SETS?"
If you would like to delete all your SEARCH SETS (do so only if you do not want to
use them again), enter YES or Y, You will be asked:
"ARE YOU SURE?"
If you are sure, enter YES or Y. Your SEARCH SETS will be deleted and you will see
the following message:
"YOUR SEARCH SETS HAVE BEEN DELETED"
The SEARCH MENU will then appear.
If you had entered NO or N at either of these prompts, your SEARCH SETS would not
be deleted, and the SELECTION MENU would reappear on the screen.
11-44
-------
5. SEARCHING THE DATA BASE
When you select SE (SEARCH) from the SELECTION MENU, the SEARCH MENU will be
displayed.
SEARCH
EACH ROD CONTAINS THE FOLLOWING SEARCHABLE INFORMATION FIELDS:
IDENTIFICATION ENVIRONMENTAL TEXT
1. REGION 6. CONTAMINATED MEDIA 9. SELECTED REMEDY
2. STATE 7. KEY CONTAMINANTS 10. ABSTRACT
3. SITE NAME 8. SELECTED KEY WORDS 11. ROD TEXT
4. ROD ID NUMBER
5. ROD DATE
ENTER:
THE NUMBER FOR THE INFORMATION FIELD TO SEARCH, OR
H - FOR HELP EXPLANATIONS, OR
M - TO RETURN TO THE MAIN MENU, OR
X - TO EXIT THE RODS SYSTEM
S - GO TO THE SELECTION MENU
SELECTION:
The SEARCH MENU is described in detail in Section D.
II-45
-------
Print
Command
i
-------
6. PRINTING YOUR RESULTS
When you select PR (PRINT) from the SELECTION MENU, the PRINT MENU will be
displayed:
PRINT
YOU MAY PRINT:
1 - IDENTIFICATION FIELDS
2 - IDENTIFICATION AND ENVIRONMENTAL FIELDS
3 - IDENTIFICATION FIELDS AND THE ABSTRACT
4 - IDENTIFICATION FIELDS AND THE SELECTED REMEDY
5 - IDENTIFICATION FIELDS, THE ABSTRACT, AND
THE SELECTED REMEDY
6 - IDENTIFICATION FIELDS AND TEXT CONTEXT AREAS
(USE THIS ONLY IF THE SEARCH SET YOU ARE PRINTING
WAS CREATED BY SEARCHING THE TEXT FIELD)
S - RETURN TO THE SELECTION MENU
X - EXIT THE ROD SYSTEM
SELECTION:
All of the PRINT options are predefined reports. The menus do not allow you to define
the PRINT reports. NOTE: Because the RODs are so long, you are not allowed to print out
the entire TEXT of the ROD, only the context areas. If you need a copy of a particular ROD
or RODs, the will be available from the EPA libraries or from the National Technical
Information Service (NTIS). The following fields are associated with Options 1 through 4, and
are described on the following page.
• Fields for Option 1, IDENTIFICATION FIELDS:
REGION, SITE NAME, ROD ID NUMBER, and ROD DATE
• Fields for Option 2, IDENTIFICATION AND ENVIRONMENTAL FIELDS:
REGION, SITE NAME, ROD ID NUMBER, ROD DATE, CONTAMINATED MEDIA,
KEY CONTAMINANTS, and KEY WORDS
• Fields for Option 3, IDENTIFICATION FIELDS AND THE ABSTRACT:
REGION, SITE NAME, ROD ID NUMBER, ROD DATE, and ABSTRACT
• Fields for Option 4, IDENTIFICATION FIELDS AND THE SELECTED REMEDY:
REGION, SITE NAME, ROD ID NUMBER, ROD DATE, and REMEDY
• Fields for Option 5, IDENTIFICATION FIELDS, THE ABSTRACT, AND THE
SELECTED REMEDY:
REGION, NAME, ROD ID NUMBER, ROD DATE, ABSTRACT, and REMEDY
• Fields for Option 6, IDENTIFICATION FIELDS AND TEXT CONTEXT AREAS:
REGION, NAME, ROD ID NUMBER, ROD DATE, and HIGHLIGHTED PORTIONS OF
TEXT
II-47
-------
After selecting an Option (1-6) from the PRINT MENU, the following screen will be
displayed:
WHERE DO YOU WANT YOUR PRINTOUT TO GO?
LOCATION REMOTE NUMBER
REGION 1 RMT34
REGION 2 N7
REGION 3 N14
REGION 4 N12
REGION 5 (111 W JACKSON) RMT138
REGION 5 (230 S DEARBORN) RMT02
REGION 6 N10
REGION 7 N13
REGIONS RMT11
REGION 9 RMT75
REGION 10 Nil
HQ - WIC N3
NEIC DENVER N9
ENTER THE REMOTE NUMBER:
After you enter the REMOTE NUMBER at the prompt, you will be asked if you entered
the correct REMOTE NUMBER. For example, if you have specified N3 as the REMOTE
NUMBER, you will be prompted:
"IS N3 CORRECT? (YES:NO)"
If you enter NO, you are prompted to enter again. If you enter YES, then you will be
prompted with the following message:
"DO YOU WANT A TITLE/HEADING ON YOUR PRINTOUT? (YES:NO)"
If you enter NO, your printout will be sent without a title. If you enter YES, you are
prompted to enter the title. After you answer all of the questions, your printout will be sent,
and the SELECTION MENU will be redisplayed.
11-48
-------
Help
Menus
i
-------
F. THE HELP MENUS
Several HELP features have been incorporated into the RODS Data Base. To access the
RODS MAIN HELP MENU, enter H at the "SELECTION:" prompt of the SEARCH MENU or the
SELECTION MENU.
RODS MAIN HELP MENU
ENTER:
1 - GENERAL HELP TOPICS, OR
2 - FIELD INFORMATION, OR
3 - INDEX TERMS FOR A SPECIFIC FIELD, OR
4 - BROWSE THE DATA THESAURUS, OR
S - RETURN TO THE SEARCH MENU, OR
X- EXIT THE RODS SYSTEM
SELECTION:
Four HELP features are listed on the RODS MAIN HELP MENU.
• Option 1, GENERAL HELP TOPICS, gives you information about the MENU
commands, the RODS, and the terminology used with RODS.
• Option 2, FIELD INFORMATION, gives you information about each of the fields in
the data base, including general information, BASIS access names, and indexing
information.
• Option 3, INDEX TERMS FOR A SPECIFIC FIELD, allows you to actually "LOOK"
into the index of each field to see which terms can be SEARCHed for in each field.
This HELP feature is especially helpful because it allows you to create SEARCH
SETS as you are looking at the index.
• Option 4, BROWSE THE DATA THESAURUS, is not available yet. When it is
available, it will allow you to identify all the ways that a term is represented in
the data base.
Each of these HELP features is described in more detail on the next few pages.
Appendix C contains copies of all the HELP MENUS.
If you wish to leave the RODS MAIN HELP MENU, enter an S to return to the SEARCH
MENU or X to exit the RODS Data Base.
11-49
-------
1. GENERAL HELP TOPICS
When you select Option 1 from the RODS MAIN HELP MENU, the GENERAL HELP
TOPICS MENU will be displayed:
_ _ .
GENERAL HELP TOPICS
AT THE PROMPT, SELECT ONE OF THE FOLLOWING:
1 - WHAT IS A ROD?
2 - FIELDS IN THE RODS DATA BASE
3 - TERMINOLOGY
4 - HOW TO USE THE RODS DATA BASE
5 - SEARCHING THE DATA BASE
6 - WHAT IS A SEARCH SET?
7 - COMBINING SEARCH SETS
8 - SORTING A SEARCH SET
9 - DISPLAYING A SEARCH SET
10 - PRINTING A SEARCH SET
H - RETURN TO THE MAIN HELP MENU
S - RETURN TO SEARCH MENU
X - EXIT RODS
SELECTION:
At the "SELECTION:" prompt, enter 1 through 10 to see an explanation of one of the
topics. For example, if you enter 1, the following explanation will be displayed:
WHAT IS A ROD?
A ROD or Record of Decision is mainly a textual
document describing EPA's planned course of action
to clean up a listed or proposed site on the National
Priorities List. The ROD is the official record of
EPA's remedy selection for the site. The majority of
RODs follow a standard format specified in OERR
guidance to the Regional Offices. The ROD System
contains text pages from the documents, as well as
some of the textual tables. The system contains all
RODs since the inception of the Superfund program. As
new RODs are signed, they are entered into RODS. At
this time, maps and other graphic materials are not in
the ROD System.
PRESS ENTER TO CONTINUE:
11-50
-------
All of the choices, 1 through 10, will give a similar, brief explanation except for
3 - TERMINOLOGY. When you select 3, the following screen will be displayed:
TERMINOLOGY
EXPLANATIONS ARE AVAILABLE FOR THE FOLLOWING TERMS:
1 - BASIS ACCESS NAME
2 - BASIS COMMAND LANGUAGE
3 - ENVIRONMENTAL INFORMATION
4 - FIELD
5 - FIELD NAME
6 - FISCAL YEAR
7 - IDENTIFICATION INFORMATION
8 - LOGOFF
9 - OERR
10 - RECORD
11 - TEXT INFORMATION
12 - THESAURUS
H - RETURN TO THE MAIN HELP MENU
S - RETURN TO THE SEARCH MENU
X - EXIT RODS
SELECTION:
The TERMINOLOGY MENU allows you to see a brief description of some of the terms
used commonly in the menus. At the "SELECTION:" prompt, enter 1 through 12 to see an
explanation of one of the terms.
Both the TERMINOLOGY MENU and the GENERAL HELP TOPICS MENU allow you to
enter H to return to the RODS MAIN HELP MENU, S to return to the SEARCH MENU, or X
to exit the RODS Data Base.
11-51
-------
2. FIELD INFORMATION
When you select Option 2 from the RODS MAIN HELP MENU, the FIELD EXPLANATION
MENU will be displayed:
FIELD EXPLANATIONS
EXPLANATIONS ARE AVAILABLE FOR THE FOLLOWING FIELDS:
IDENTIFICATION ENVIRONMENTAL
1. REGION 7. CONTAMINATED MEDIA
2. STATE 8. KEY CONTAMINANTS
3. SITE NAME/ALIAS 9. SELECTED KEY WORDS
4. ROD ID NUMBER
5. SITE ID NUMBER
6. ROD DATE
TEXT
10. SELECTED REMEDY
11. ABSTRACT
12. ROD TEXT
13. TEXT SECTIONS
14. FIGURES, TABLES,
ENTER THE FIELD NUMBER:
At the "ENTER THE FIELD NUMBER:" prompt, enter 1 through 14 to see an explanation
of one of the fields. For example, if you enter 6, the following explanation of the ROD
DATE will be displayed:
II-52
-------
THE ROD DATE FIELD
GENERAL
THE ROD DATE FIELD CONTAINS THE DATE THAT THE ROD
WAS SIGNED. WHEN USING THE MENUS TO SEARCH THE ROD
DATA BASE, THE ROD DATE MUST BE ENTERED IN ONE OF
THE FOLLOWING FORMATS:
MM/DD/YY TO SEARCH A SINGLE DATE
MM/DD/YY:MM/DD/YY TO SEARCH A RANGE OF DATES
YY TO SEARCH A SINGLE FISCAL YEAR
YY.YY TO SEARCH A RANGE OF FISCAL YEARS
WHEN USING BASIS MENU LANGUAGE TO SEARCH THE DATA BASE,
THE DATE CAN BE ENTERED MANY DIFFERENT WAYS. (SEE THE
BASIS USER'S REFERENCE MANUAL)
PRESS ENTER TO CONTINUE:
BASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE ROD DATE IS RDATE.
INDEXING INFORMATION
THE ROD DATE IS INDEXED AS A DATE FIELD.
PRESS ENTER TO CONTINUE:
The explanations for each field contain general information, BASIS access information,
and indexing information. After the FIELD EXPLANATIONS are displayed, the RODS MAIN
HELP MENU is redisplayed.
11-53
-------
3. INDEX TERMS FOR A SPECIFIC FIELD
When you select Option 3 from the RODS MAIN HELP MENU, the INDEX TERMS MENU
will be displayed:
INDEX TERMS
YOU CAN LOOK AT THE INDEX FOR THE FOLLOWING FIELDS:
IDENTIFICATION ENVIRONMENTAL TEXT
1. REGION 7. CONTAMINATED MEDIA 10. SELECTED REMEDY
2. LOCATION 8. KEY CONTAMINANTS 11. ABSTRACT
3. SITE NAME 9. SELECTED KEY WORDS 12. ROD TEXT
4. ROD ID NUMBER 13. TEXT SECTIONS
5. SITE ID NUMBER
6. ROD DATE
ENTER THE FIELD NUMBER:
At the "ENTER THE FIELD NUMBER:" prompt, enter 1 through 13 to select the index of
the field you would like to see. For example, to look at the SITE NAME index, enter 3 and
the following screen will be displayed:
YOU HAVE CHOSEN TO LOOK IN THE SITE NAME INDEX.
ENTER THE WORD OR WORD STEM TO LOOK UP:
11-54
-------
At this point, you must enter a word or portion of a word to look up. For example, if
you enter STR, the following screen will be displayed:
YOU HAVE CHOSEN TO LOOK IN THE SITE NAME INDEX.
ENTER THE WORD OR WORD STEM TO LOOK UP: str
I/ LOOK NAME=str**
A 1 NAME=STREET
B 1 NAME=STREETS
C 2 NAME=STRINGFELLOW
D 2 NAME=STRINGFELLOW ACID PITS
E 1 NAME=SWOPE
F 1 NAME=SWOPE OIL
G 1 NAME=SYNCON
H 1 NAME=SYNCON RESINS
I 3 NAME=TAR
J 1 NAME=TAR CREEK
K 3 NAME=TAYLOR
L 2 NAME=TAYLOR BOROUGH
More terms
Pick
==> ENTER "MORE" TO SEE MORE INDEX TERMS, OR
==> PRESS ENTER TO RETURN TO THE MAIN HELP MENU, OR
==> ENTER A LETTER (A) OR MULTIPLE LETTERS (A,B) TO CREATE A
SEARCH SET
The screen shown above is an alphabetical listing of terms in the SITE NAME index
starting with "STR". In this case only 4 terms in the SITE NAME index start with "STR".
The number in front of the "NAME=" tells how many times that word occurs in the SITE
NAME field in the data base.
After listing terms on the screen, you have three options: First, you can enter MORE
and the list would continue with terms after TAYLOR BOROUGH. Second, you can press
enter to return to the MAIN HELP MENU. Third, you can create a SEARCH SET by entering
a single letter or multiple letters from the list. The first and third options will be explained
in more detail on the next page.
H-55
-------
If you enter MORE the next 12 terms in the list will be displayed:
I/ MORE
A 1 NAME=TRIOXIDE
B 1 NAME=TRUCKING
C 1 NAME=TYBOUTS
D 1 NAME=TYBOUTS CORNER
E 1 NAME=TYSON'S
F 1 NAME=TYSON'S DISPOSAL
G 1 NAME=UNION
H 2 NAME=UNITED
I 1 NAME=UNITED CHROME
J 1 NAME=UNITED CREOSOTING
K 1 NAME=VALLEY
L 1 NAME=VARSOL
More terms
Pick
==> ENTER "MORE" TO SEE MORE INDEX TERMS, OR
==> PRESS ENTER TO RETURN TO THE MAIN HELP MENU, OR
==> ENTER A LETTER (A) OR MULTIPLE LETTERS (A,B) TO CREATE A
SEARCH SET
Now, if you enter a letter or multiple letters you can create a new SEARCH SET. For
example, if you enter C,D, you will create a SEARCH SET containing all RODs with the
NAME=TYBOUTS or NAME=TYBOUTS CORNER, and you will see the following message:
l/c,d
1 item as set 1
Pick...
==> 1 ROD WAS FOUND AND SAVED AS SEARCH SET 1
As shown, a SEARCH SET containing 1 ROD was created and saved as SEARCH SET 1.
After the message, the RODS MAIN HELP MENU is redisplayed.
II-56
-------
INDEX
Asterisk (*) 11-28
BASIS Command Language 11-12
COMBINE 11-28, H-39
AND 11-39
ANDNOT H-39
CO 11-39
COMBINE SEARCH SETS Menu 11-39
OR 11-39
Command, Command line
DOWN 11-34
EXIT 11-34
TOP 11-34
HIT 11-34
NEXT 11-34
SELECT 11-34
UP 11-34
Command lines 11-34
Context area 11-34
CURRENT SEARCH SET 11-43
DISPLAY 11-33
DI H-33
DISPLAY Menu 11-33
DISPLAYing the TEXT H-34
ENVIRONMENTAL INFORMATION 11-33
IDENTIFICATION INFORMATION 11-33
LIST OF FIELDS 11-33
SELECTED REMEDY AND ABSTRACT 11-33
TEXT H-33
DISPLAYing the TEXT
asterisks (**) 11-34
context areas H-34
Document set
See SEARCH set H-27
DOWN II-35
EXIT H-35
Field SEARCH Screens
ABSTRACT SEARCH Screen H-25
CONTAMINATED MEDIA SEARCH Screen II-21
Field SEARCH Screens H-15
KEY CONTAMINANTS SEARCH Screen II-22
KEY WORDS SEARCH Screen H-23
REGION INFORMATION SEARCH Screen H-15
ROD DATE INFORMATION SEARCH Screen II-20
ROD IDENTIFICATION NUMBER SEARCH Screen 11-19
ROD TEXT SEARCH Screen II-26
SELECTED REMEDY SEARCH Screen H-24
SITE NAME SEARCH Screen 11-18
STATE INFORMATION SEARCH Screen II-16
HELP H-13
HELP MENUS H-49
GENERAL HELP TOPICS H-50
MAIN HELP MENU H-49
HIT 11-35
H-57
-------
INDEX
(Continued)
LIST H-43
CURRENT SEARCH SET 11-43
LI H-43
LIST Screen H-43
MAIN MENU II-12
NEXT 11-35
NTIS H-47
PRINT 11-47
PR 11-47
PRINT Menu 11-47
SEARCH II-13, 11-45
SE 11-45
SEARCH Screen 11-14
SEARCH SET 11-27
SEARCH SETS 11-28
SEARCH term H-14, II-28
Special SEARCH Features II-28
SEARCH Menu II-12
SEARCH 11-12
SELECT 11-35
SELECT function 11-28
SELECTION
COMBINE II-30
DISPLAY II-30
LIST II-30
PRINT 11-30
SEARCH 11-30
SELECTION MENU H-30
SORT H-30
SELECTION Menu II-37
SORT H-28, II-37
SORT criteria H-37
SORT Menu H-37
SORT fields
REGION H-37
ROD DATE H-37
ROD ID NUMBER 11-37
SITE NAME H-37
SORT 11-37
STATE H-37
Special Search Feature
The WILD Card Character (*) 11-28, II-29
TOP H-35
UP H-35
Wild Card Character H-28
H-58
-------
Search
Fields
-------
APPENDIX A
THE ROD SYSTEM FIELDS
-------
APPENDIX A
THE ROD SYSTEM SEARCH FIELDS
TABLE OF CONTENTS
TITLE
PACE
THE ABSTRACT FIELD A-l
THE ALIAS NAME FIELD A-2
THE FIGURES, TABLES, ETC. FIELD A-3
THE KEY CONTAMINANT FIELD A-4
THE KEY WORDS FIELD A-5
THE LOCATION FIELD A-6
THE MEDIA FIELD A-7
THE REGION FIELD A-8
THE ROD DATE FIELD A-9
THE ROD ID NUMBER FIELD A-10
THE SELECTED REMEDY FIELD A-l 1
THE SITE ID NUMBER FIELD A-12
THE SITE NAME FIELD A-13
THE TEXT FIELD A-14
THE TEXT SECTION FIELD A-15
A-i
-------
THE ABSTRACT FIELD
GENERAL
THE ABSTRACT FIELD CONTAINS AN ABSTRACT OF THE ROD AS IT
APPEARS ON THE NATIONAL TECHNICAL INFORMATION SERVICE
(NTIS) COVERSHEET. THE ABSTRACT IS GENERALLY 2-4
PARAGRAPHS LONG AND CONTAINS A BRIEF SUMMARY OF THE
ROD.
BASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE ABSTRACT FIELD IS
INDEXING INFORMATION
THE ABSTRACT FIELD IS A TEXTUAL FIELD AND EACH WORD IS
INDEXED INDIVIDUALLY.
SEARCH SAMPLE
FIND ABS=PCB*
RESULT WILL BE A SEARCH SET CONTAINING POINTERS TO ALL ROD
DOCUMENTS WHICH HAVE WORD BEGINNING WITH THE LETTERS "PCB"
IN THE ROD ABSTRACT.
A-l
-------
THE ALIAS NAME FIELD
GENERAL
THE ALIAS NAME FIELD CONTAINS THE "ALSO KNOWN AS" (AKA)
NAMES FOR A GIVEN SITE. WHEN A SEARCH IS PERFORMED ON
THE SITE NAME FIELD, THE ALIAS NAME IS SEARCHED
AUTOMATICALLY.
BASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE ALIAS NAME FIELD IS
INDEXING INFORMATION
THE ALIAS FIELD IS INDEXED BY INDIVIDUAL WORD AS WELL AS THE
ENTIRE ALIAS NAME. FOR EXAMPLE, SYLVESTER'S SITE IS INDEXED
AS FOLLOWS:ALIAS=SYLVESTER'S
ALIAS=SITE
ALIAS=SYLVESTER'S SITE
SYLVESTER'S SITE IS THE ALIAS NAME FOR NASHUA SITE.
SEARCH SAMPLE
FIND ALIAS=AIRPORT
RESULT WILL BE A SEARCH SET CONTAINING POINTERS TO ALL ROD
DOCUMENTS WHICH HAVE AN ALIAS NAME CONTAINING THE WORD
"AIRPORT".
A-2
-------
THE FIGURES, TABLES, ETC. FIELD
GENERAL
THE FIGURES FIELD CONTAINS A LIST OF ALL FIGURES,
TABLES, EXHIBITS, AND ATTACHMENTS THAT ARE IN THE
ROD. SOME EXAMPLES OF THE ITEMS LISTED IN THIS FIELD
INCLUDE: MAPS, MEMORANDA, ATTENDENCE SHEETS FROM
PUBLIC HEARINGS, SAMPLE RESULTS, SAMPLE COLLECTION DATA
FORMS, CHAIN OF CUSTODY FORMS, LABELS, NEWSPAPER CLIPPINGS,
LETTERS, AND GRAPHS. SOME OF THESE ITEMS ARE INCLUDED AS
PART OF THE TEXT OF THE ROD AND ARE DESIGNATED AS INCLUDED
IN THIS FIELD. ITEMS THAT ARE NOT INCLUDED ARE DESIGNATED
AS OMITTED.
BASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE FIGURE, TABLES, ETC FIELD
INDEXING INFORMATION
THE FIGURES FIELD IS NOT INDEXED. THE CONTENTS OF THE
FIELD CAN BE DISPLAYED OR SEQUENTIALLY SCANNED ONLY.
A-3
-------
THE KEY CONTAMINANT FIELD
GENERAL
THE KEY CONTAMINANTS FIELD CONTAINS A LIST OF THE KEY
CONTAMINANTS AS THEY APPEAR ON THE NATIONAL TECHNICAL
INFORMATION SERVICE (NTIS) COVERSHEETS. THIS FIELD .MAY NOT
CONTAIN ALL THE CONTAMINANTS AT THE SITE. IN ADDITION TO
THE KEY CONTAMINANTS FIELD, IT IS ADVISABLE TO SEARCH THE
TEXT FIELD FOR CONTAMINANTS.
BASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE KEY CONTAMINANTS FIELD
INDEXING INFORMATION
THE KEY CONTAMINANT FIELD IS INDEXED BY PHRASE AND BY
INDIVIDUAL WORD. FOR EXAMPLE, VOLATILE ORGANIC COMPOUNDS
IS INDEXED AS FOLLOWS:
CONT=VOLATILE
CONT=ORGANIC
CONT=COMPOUNDS
CONT=VOLATILE ORGANIC COMPOUNDS
ANOTHER EXAMPLE, DIOXIN IS INDEXED AS FOLLOWS:
CONT=DIOXIN
SAMPLE SEARCH
FIND CONT-DIOXIN
RESULT WILL BE A SEARCH SET CONTAINING POINTERS TO ALL ROD
DOCUMENTS WHICH HAVE DIOXIN LISTED AS A KEY CONTAMINANT.
(NOTE: THE KEY CONTAMINANT FIELD CONTAINS KEY CONTAMINANT
INFORMATION AS ASSIGNED ON THE NTIS COVERSHEETS.)
A-4
-------
THE KEY WORDS FIELD
GENERAL
THE KEY WORDS FIELD CONTAINS A LIST OF THE KEY WORDS
AND KEY PHRASES AS THEY APPEAR ON THE NATIONAL TECHNICAL
INFORMATION SERVICE (NTIS) COVERSHEETS. THIS FIELD DOES
NOT CONTAIN ALL KEY WORDS THAT MAY BE NECESSARY TO SEARCH
THE ROD. IN ADDITION TO THE KEY WORD FIELD, IT IS
ADVISABLE TO SEARCH THE TEXT FIELD.
JASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE KEY WORDS FIELD IS KEYS.
INDEXING INFORMATION
THE KEY WORDS FIELD IS INDEXED BY PHRASE AND BY INDIVIDUAL
WORD. FOR EXAMPLE, DRINKING WATER CONTAMINANTS
IS INDEXED AS FOLLOWS:
KEYS=DRINKING
KEYS=WATER
KEYS=CONTAMINANTS
KEYS=DRINKING WATER CONTAMINANTS
ANOTHER EXAMPLE, INCINERATION IS INDEXED AS FOLLOWS:
KEYS=INCINERATIQN
SEARCH SAMPLE
FIND KEYS-INCINERATION
RESULT WILL BE A SEARCH SET CONTAINING POINTERS TO ALL ROD
DOCUMENTS WHICH HAVE INCINERATION LISTED AS A KEY WORD.
(NOTE: THE KEY WORDS FIELD CONTAINS THOSE KEY WORDS ASSIGNED
ON THE NTIS COVERSHEET AND/OR THE ROD ANNUAL REPORT.)
A-5
-------
THE LOCATION FIELD
GENERAL
THE LOCATION FIELD CONTAINS THE CITY AND STATE WHERE
THE SITE IS LOCATED. IT IS FORMATTED AS FOLLOWS:
CITY, STATE ABBREVIATION
BASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE LOCATION FIELD IS
INDEXING INFORMATION
THE CITY AND THE STATE ABBREVIATION ARE INDEXED
SEPARATELY AND TOGETHER WITHIN THE LOCATION FIELD.
FOR EXAMPLE, CAMDEN, NJ IS INDEXED AS FOLLOWS:
LOC=CAMDEN
LOC=CAMDEN, NJ
LOC=NJ
SEARCH SAMPLE
FIND LOC=VA
RESULT WILL BE A SEARCH SET CONTAINING POINTERS TO THE ROD
DOCUMENTS WHICH HAVE A SITE LOCATION OF VIRGINIA.
A-6
-------
THE MEDIA FIELD
GENERAL
THE MEDIA FIELD CONTAINS A LIST OF THE ENVIRONMENTAL
MEDIA THAT ARE CONTAMINATED AT THE SITE. THIS FIELD
CONTAINS THE MEDIA AS ASSIGNED ON THE NATIONAL TECHNICAL
INFORMATION SERVICE (NTIS) COVERSHEETS. THIS FIELD MAY NOT
CONTAIN ALL THE CONTAMINATED MEDIA AT THE SITE. IN
ADDITION TO THE MEDIA FIELD, IT IS ADVISABLE TO SEARCH
THE TEXT FIELD FOR CONTAMINATED MEDIA.
BASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE CONTAMINATED MEDIA FIELD
INDEXING INFORMATION
THE MEDIA FIELD IS INDEXED BY PHRASE AND BY INDIVIDUAL
WORD. FOR EXAMPLE, RIVER SEDIMENTS IS INDEXED AS
FOLLOWS: MEDIA=RIVER SEDIMENTS
MEDIA=RIVER
MEDIA=SEDIMENTS
ANOTHER EXAMPLE, GROUNDWATER IS INDEXED AS FOLLOWS:
MEDIA=GROUNDWATER
SEARCH SAMPLE
FIND MEDIA-SOIL
RESULT WILL BE A SEARCH SET CONTAINING POINTERS TO ALL ROD
DOCUMENTS WHICH HAVE SOIL LISTED AS ACONTAMINATED MEDIA.
(NOTE: THE MEDIA FIELD CONTAINS MEDIA AS ASSIGNED IN THE
NTIS COVERSHEETS.)
A-7
-------
THE REGION FIELD
GENERAL
THE REGION FIELD CONTAINS THE NUMBER FOR THE REGION
IN WHICH THE SITE IS LOCATED. THE REGION NUMBERS ARE
INTEGERS FROM 1-10 AND ARE MADE UP OF THE FOLLOWING
STATES:
1 - CT, MA, ME, NH, RI, VT
2 - NJ, NY, PR, VI
3 - DC, DE, MD, PA, VA, WV
4 - AL, FL, GA, KY, MS, NC, SC, TN
5 - IL, IN, MI, MN, OH, WI
6 - AR, LA, NM, OK, TX
7 - IA, KS, MO, NE
8 - CO, MT, ND, SD, UT, WY
9 - AZ, CA, HI, NV
10 - AK, ID, OR, WA
BASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE REGION FIELD IS
INDEXING INFORMATION
THE REGION FIELD IS INDEXED INDIVIDUALLY BY NUMBER
AS FOLLOWS: REG=1 REG=6
REG=2 REG=7
REG=3 REG=8
REG«4 REG-9
REG-5 REG-10
SEARCH SAMPLE
FIND REG=2
RESULT WILL BE A SEARCH SET CONTAINING POINTERS TO THE RODS
DOCUMENTS WHICH HAVE A REGION EQUAL TO 2.
A-8
-------
THE ROD DATE FIELD
GENERAL
THE ROD DATE FIELD CONTAINS THE DATE THAT THE ROD
WAS SIGNED. WHEN USING THE MENUS TO SEARCH THE ROD
DATA BASE, THE ROD DATE MUST BE ENTERED IN ONE OF
THE FOLLOWING FORMATS:
MM/DD/YY TO SEARCH A SINGLE DATE
MM/DD/YY:MM/DD/YY TO SEARCH A RANGE OF DATES
YY TO SEARCH A SINGLE FISCAL YEAR
YY,YY TO SEARCH A RANGE OF FISCAL YEARS
WHEN USING BASIS MENU LANGUAGE TO SEARCH THE DATA BASE,
THE DATE CAN BE ENTERED IN THE THE FOLLOWINFG FORMATS:
JANUARY 30, 1986 JAN 30, 1986 JAN. 1986
JANUARY, 1986 . JAN 30 1986 JAN 1986
30 JAN. 1986 30 JAN 1986 30 JAN 86
30 JAN 1986 1986 013086
01-30-86 01 30 86 01/30/86
BASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE ROD DATE FIELD IS
INDEXING INFORMATION
THE ROD DATE IS INDEXED AS A DATE FIELD. IT IS STORED IN
THE INDEX IN THE YYMMDD FORMAT.
SAMPLE SEARCH
FIND RDATE-SEP 30 1985
RESULT WILL BE A SEARCH SET CONTAINING POINTERS TO ALL RODS
DOCUMENTS SIGNED ON SEPTEMBER 30, 1985. (NOTE: ANY OF THE
ABOVE DATE FORMATS ARE ACCEPTABLE TO BASIS WHEN USING BASIS
COMMAND LANGUAGE.)
A-9
-------
THE ROD ID NUMBER FIELD
GENERAL
THE ROD IDENTIFICATION NUMBER FIELD CONTAINS THE UNIQUE EPA
ROD DOCUMENT NUMBER. THE ROD ID IS IN THE FORMAT:
R02-86/038
R02- SHOWS THAT IT IS A ROD FROM REGION 2
86 - SHOWS THAT IT IS A ROD SIGNED IN THE YEAR 1986
038 - SHOWS THAT IT IS THE 38TH ROD FOR THE YEAR
BASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE ROD ID NUMBER IS
INDEXING INFORMATION
THE ENTIRE ROD ID NUMBER IS INDEXED AS ONE TERM.
FOR EXAMPLE, R02-86/038 IS INDEXED AS FOLLOWS:
RODID=R02-86/038
SAMPLE SEARCH
FIND RODID=R02-86/038
RESULT WILL BE A SEARCH SET CONTAINING POINTERS TO THE ROD
DOCUMENT WHICH HAS A ROD ID NUMBER OF R02-86/038.
A-10
-------
THE SELECTED REMEDY FIELD
GENERAL
THE SELECTED REMEDY HELD CONTAINS A DESCRIPTION
AND JUSTIFICATION FOR THE METHOD CHOSEN TO CLEAN
THE SITE.
BASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE FIGURE, TABLES, ETC FIELD
IS
REM.
INDEXING INFORMATION
THE SELECTED REMEDY FIELD IS A TEXTUAL FIELD AND EACH
WORD IS INDEXED INDIVIDUALLY.
SAMPLE SEARCH
FIND REM=OFFSITE
RESULT WILL BE A SEARCH SET CONTAINING POINTERS TO ALL ROD
DOCUMENTS WHICH CONTAIN THE WORD OFFSITE IN THE REMEDY
FIELD.
A-ll
-------
THE SITE ID NUMBER FIELD
GENERAL
THE SITE IDENTIFICATION NUMBER FIELD CONTAINS A UNIQUE
IDENTIFICATION NUMBER FOR THE SITE. THE SITE ID NUMBERS
ARE THE SAME ID NUMBERS THAT ARE IN THE CERCLIS DATA
BASE. THE FORMAT FOR THE SITE ID NUMBER IS: VAD980712970
WHERE THE FIRST TWO LETTERS DESIGNATE THE STATE AND THE
REMAINING 10 CHARACTERS A UNIQUE ID NUMBER.
BASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE SITE ID NUMBER IS
INDEXING INFORMATION
ONLY THE FIRST TWO CHARACTERS OF THE SITE IDENTIFICATION
FIELD NUMBER IS INDEXED. THE FIRST TWO CHARACTERS ALWAYS
CONTAINS THE STATE ABBREVIATION FOR THE LOCATION OF THE
SITE.
SEARCH SAMPLE
FIND SITEID=VA
RESULT WILL BE A SEARCH SET CONTAINING POINTERS TO ALL ROD
DOCUMENTS WHICH HAVE A SITEID STARTING WITH VA (VIRGINIA).
SPECIAL MENU HANDLING
THE SITEID IS NOT SEARCHABLE THROUGH THE ROD MENUS. IT CAN
HOWEVER BE DISPLAYED IN THE MENUS.
A-12
-------
THE SITE NAME FIELD
GENERAL
THE SITE NAME FIELD CONTAINS THE PREFERRED NAME FOR THE ROD
SITE. ALL ALIAS NAMES ARE LISTED IN THE ALIAS NAME FIELD.
WHEN SEARCHING THE ROD DATA BASE BY NAME, BOTH THE PREFERRED
NAME AND ALIAS NAMES ARE SEARCHED AUTOMATICALLY.
BASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE SITE NAME FIELD IS
INDEXING INFORMATION
THE SITE NAME FIELD IS INDEXED BY INDIVIDUAL WORD WITHIN THE
NAME AS WELL AS THE ENTIRE SITE NAME. FOR EXAMPLE, PIJAK
FARM SITE IS INDEXED AS FOLLOWS:
NAME=PIJAK
NAME=FARM
NAME=SITE
NAME=PIJAK FARM SITE
SEARCH SAMPLE
FIND NAME=PIJAK FARM SITE
RESULT WILL BE A SEARC SET CONTAINING A POINTER TO THE ROD
DOCUMENT WITH THE SITE NAME "PIJAK FARM SITE".
OR
FIND NAME=LANDFILL
RESULT WILL BE A SEARCH SET CONTAINING POINTERS TO ALL RODS
DOCUMENTS WHICH HAVE THE WORD "LANDFILL" IN THE SITE NAME
FIELD.
SPECIAL MENU HANDLING
ANY SEARCH BY SITE NAME VIA THE MENUS AUTOMATICALLY SEARCHES
BOTH THE SITE NAME AND ALIAS FIELDS.
A-13
-------
THE TEXT FIELD
GENERAL
THE TEXT FIELD CONTAINS THE TEXT OF THE ROD. THE TEXT
IS DIVIDED INTO MANY SECTIONS. THE ACTUAL TEXT SECTION
HEADINGS FOR EACH INDIVIDUAL ROD ARE LISTED IN THE TEXT
SECTIONS FIELD. SECTION MARKERS HAVE BEEN EMBEDDED IN THE
TEXT TO MAKE SPECIFIC TEXT SECTIONS EASY TO FIND. THE
SECTION MARKERS AND TEXT SECTION NAMES ARE LISTED BELOW:
*AE=ALTERNATIVES EVALUATIONsOM-OPERATIONS & MAINTENANCE
#CR=COMMUNITY RELATIONS #RA«RECOMMENDED ALTERNATIVE
SCSS-CURRENT SITE STATUS #RS-RESPONSIVENESS SUMMARY
#DE-DECLARATION tfSCH-SCHEDULE
#DR-DOCUMENTS REVIEWED #SH-SITE HISTORY
sENF-ENFORCEMENT #SLD-SITE LOCATION & DESCRIPTION
SPA-FUTURE ACTIONS *TMA-TABLES, MEMORANDA, ATTACHMENTS
#OEL=CONSISTENCY WITH OTHER
ENVIRONMENTAL LAWS
BASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE TEXT FIELD IS
INDEXING INFORMATION
THE TEXT FIELD IS THE LONG TEXT HELD AND EACH WORD IS
INDEXED INDIVIDUALLY.
SEARCH SAMPLE
FIND TEXT-CHROMIUM
RESULT WILL BE A SEARCH SET CONTAINING POINTERS TO ALL ROD
DOCUMENTS THAT CONTAIN THE WORD CHROMIUM. DISPLAY OF THE
TEXT FIELD WILL SHOW TWO ASTERISKS (••) BESIDE EACH SENTENCE
IN EACH ROD WHICH CONTAIN THE WORD CHROMIUM.
A-14
-------
THE TEXT SECTION FIELD
GENERAL
THE TEXT SECTION FIELD CONTAINS A LIST OF SECTION
HEADINGS AS THEY APPEAR IN THE TEXT OF THE ROD.
THE TEXT SECTIONS VARY FROM ROD TO ROD.
FOR EXAMPLE, ONE ROD CONTAINS THE FOLLOWING TEXT SECTIONS:
SITE
DOCUMENTS REVIEWED
DECLARATIONS
EXECUTIVE SUMMARY
HISTORY
CURRENT STATUS
PUBLIC INPUT
STATE INPUT
RECOMMENDED ALTERNATIVE
SCHEDULE
BASIS ACCESS
THE DATA BASE ACCESS NAME FOR THE TEXT SECTION FIELD IS
INDEXING INFORMATION
THE TEXT SECTION FIELD IS INDEXED BY INDIVIDUAL WORD OF
EACH TEXT HEADING AS WELL AS THE ENTIRE TEXT SECTION
HEADING. FOR EXAMPLE, RECOMMENDED ALTERNATIVE IS INDEXED AS
FOLLOWS:
SECT-RECOMMENDED
SECT-ALTERNATIVE
SECT=RECOMMENDED ALTERNATIVE
A-15
-------
RODS
Menus
I
-------
APPENDIX B
THE ROD SYSTEM MENUS
-------
APPENDIX B
THE ROD SYSTEM MENUS
TABLE OF CONTENTS
TITLE
PAGE
RODS WELCOME SCREENS B-l
RODS MAIN MENU B-2
BASIS B-2
SEARCH B-3
REGION INFORMATION SEARCH B-3
STATE INFORMATION SEARCH B-4
SITE NAME SEARCH B-4
ROD IDENTIFICATION NUMBER SEARCH B-5
ROD DATE INFORMATION SEARCH B-5
CONTAMINATED MEDIA SEARCH B-6
KEY CONTAMINANTS SEARCH B-6
KEY WORDS SEARCH B-7
SELECTED REMEDY SEARCH B-7
ABSTRACT SEARCH B-8
ROD TEXT SEARCH B-8
SELECTION MENU B-9
DISPLAY . ' B-9
DISPLAY OPTION 1 IDENTIFICATION INFORMATION ONLY B-10
DISPLAY OPTION 2 ENVIRONMENTAL INFORMATION ONLY B-ll
DISPLAY OPTION 3 SELECTED REMEDY AND ABSTRACT ONLY .... B-12
DISPLAY OPTION 4 ROD TEXT ONLY B-13
DISPLAY OPTION 5 A LIST OF FIELDS AVAILABLE TO DISPLAY .... B-14
SORT B-15
PRINT B-15
SEARCH B-16
COMBINE SEARCH SETS B-17
LIST B-18
EXIT B-18
B-i
-------
RRRRRR
RRRRRRR
RR RR
RR RR
RR RR
RRRRRRR
RRRRRR
RR RR
RR RR
RR RR
RR RR
RR RR
OOOOO
OOOOOO
OO
00
00
OO
OO
00
00
OO
00
OO
OO
OO
OO
00
OO
00
OOOOOO
OOOOO
DDDDDD
DDDDDDD
DD DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DDDDDDD
DDDDDD
sssssss
sssssssss
ss ss
ss
sss
sssssss
ssssssss
sss
ss
ss ss
sssssssss
sssssss
WELCOME TO THE
SUPERFUND
RECORDS OF DECISION
DATA BASE
B-l
-------
RODS MAIN MENU
CHOOSE ONE OF THE FOLLOWING USER LEVELS:
1 - RODS SEARCH MENU
2 - BASIS COMMAND LANGUAGE
X - EXIT
SELECTION:
BASIS
YOU HAVE CHOSEN TO USE BASIS COMMAND LANGUAGE.
IT IS ASSUMED THAT YOU KNOW THE BASIS COMMANDS
AND DO NOT REQUIRE MENU PROMPTING. IF AT ANY
TIME YOU WISH TO RETURN TO THE RODS MENU PROMPTS,
ENTER "\MENU".
B-2
-------
SEARCH
EACH ROD CONTAINS THE FOLLOWING SEARCHABLE INFORMATION FIELDS:
IDENTIFICATION ENVIRONMENTAL
1. REGION
2. STATE
3. SITE NAME
4. ROD ID NUMBER
5. ROD DATE
6. CONTAMINATED MEDIA
7. KEY CONTAMINANTS
8. SELECTED KEY WORDS
TEXT
9. SELECTED REMEDY
10. ABSTRACT
11. ROD TEXT
ENTER:
THE NUMBER FOR THE INFORMATION FIELD TO SEARCH, OR
H- FOR HELP EXPLANATIONS, OR
M- TO RETURN TO THE MAIN MENU, OR
X- TO EXIT THE RODS SYSTEM
SELECTION:
REGION INFORMATION SEARCH
ENTER:
- A SINGLE REGION (1), OR
- MULTIPLE REGIONS SEPARATED BY COMMAS (1,3).
FIND REGION
B-3
-------
STATE INFORMATION SEARCH
ENTER:
- A SINGLE STATE (VA), OR
- MULTIPLE STATES SEPARATED BY COMMAS (VA,MD)
FIND STATE
SITE NAME SEARCH
ENTER:
- THE FULL NAME (LANSDOWNE RADIATION) OR
- A PORTION OF THE SITE NAME (LANSDOWNE)
FIND SITE NAME
B-4
-------
ROD IDENTIFICATION NUMBER SEARCH
ENTER:
- A ROD IDENTIFICATION NUMBER
IN THE FORMAT R05-84/003
FIND ROD IDENTIFICATION NUMBER
ROD DATE INFORMATION SEARCH
ENTER:
- A SINGLE ROD DATE ((T/22/85), OR
- A RANGE OF DATES (07/01/85:09/30/85), OR
- A FISCAL YEAR (83), OR
- MULTIPLE FISCAL YEARS (84,85)
FIND ROD DATE
B-5
-------
CONTAMINATED MEDIA SEARCH
ENTER:
- A SINGLE MEDIA (SOIL), OR
- MULTIPLE MEDIA SEPARATED BY "OR" (SOIL OR GROUNDWATER), OR
- MULTIPLE MEDIA SEPARATED BY "AND" (SOIL AND GROUNDWATER)
FIND CONTAMINATED MEDIA -
KEY CONTAMINANTS SEARCH
ENTER:
- A SINGLE KEY CONTAMINANT (LEAD), OR
- MULTIPLE KEY CONTAMINANTS SEPARATED BY "OR" (LEAD OR PCBS), OR
- MULTIPLE KEY CONTAMINANTS SEPARATED BY "AND" (LEAD AND PCBS)
FIND KEY CONTAMINANT -
B-6
-------
KEY WORDS SEARCH
ENTER:
- A SINGLE KEY WORD (SEDIMENTS), OR
- MULTIPLE KEY WORDS SEPARATED BY "OR" (SEDIMENTS OR PCBS), OR
- MULTIPLE KEY WORDS SEPARATED BY "AND" (SEDIMENTS AND PCBS)
FIND KEY WORD
SELECTED REMEDY SEARCH
ENTER:
- A SINGLE WORD (OFFSITE), OR
- MULTIPLE WORDS (OFFSITE FACILITY)
FIND SELECTED REMEDY
B-7
-------
ABSTRACT SEARCH
ENTER:
- A SINGLE WORD (METALS), OR
- MULTIPLE WORDS (SLUDGE METALS)
FIND ABSTRACT =
ROD TEXT SEARCH
ENTER:
- A SINGLE WORD (MERCURY), OR
- MULTIPLE WORDS (SOIL MERCURY)
FIND ROD TEXT
B-8
-------
SELECTION MENU
AT THIS POINT, YOU MAY:
MANIPULATE CURRENT SEARCH SET
PERFORM OTHER FUNCTIONS
DI - DISPLAY RESULTS
SO - SORT RESULTS
PR - PRINT RESULTS
SE - CONTINUE SEARCHING
CO - COMBINE SEARCHES
LI - LIST SEARCH SETS
M - RETURN TO MAIN MENU
H - FOR HELP EXPLANATIONS
X - EXIT RODS
SELECTION:
DISPLAY
YOU MAY DISPLAY:
1 - IDENTIFICATION INFORMATION ONLY, OR
2 - ENVIRONMENTAL INFORMATION ONLY, OR
3 - SELECTED REMEDY AND ABSTRACT ONLY, OR
4 - ROD TEXT ONLY, OR
5 - A LIST OF FIELDS AVAILABLE TO DISPLAY
SELECTION:
THE FOLLOWING PAGES SHOW EXAMPLES OF THE DISPLAYS.
THE DISPLAYS ARE BASED ON THE SEARCH FIND REG-1
AND TEXT-CHROMIUM. THE RESUILTING SEARCH SET CONTAINS
4 RODS.
B-9
-------
DISPLAY OPTION 1
IDENTIFICATION INFORMATION ONLY
Item 1
REGION
LOCATION
SITE NAME
ROD ID
ROD DATE
Item 2
:WESTBOROUGH, MA
:HOCOMONCO POND
:R01-85/011
:850930
REGION :1
LOCATION :EPPING, NH
SITE NAME :KEEFE
ROD ID :RO 1-83/002
ROD DATE :831115
DO YOU WANT TO SEE THE NEXT ITEM (YES:NO)?
B-10
-------
DISPLAY OPTION 2
ENVIRONMENTAL INFORMATION ONLY
Item 1
SITE NAME :KEEFE
ROD DATE :831115
MEDIA :SOIL
SURFACE WATER
CONTAMINANTS:ALCOHOLS
CYANIDE
GLYCOLS
HEAVY METALS
SOLVENTS (PCE, TCE, XYLENE)
STYRENE
VOLATILE ORGANICS
WASTE OILS
DO YOU WANT TO SEE THE NEXT ITEM (YES:NO)? YES
B-ll
-------
DISPLAY OPTION 3
SELECTED REMEDY AND ABSTRACT ONLY
Item 1
SITE NAME :KEEFE
ROD DATE :831115
REMEDY :
- REMOVAL OF THE CONTENTS OF THE LAGOON FOR DISPOSAL OFFSITE AT A
FACILITY IN COMPLIANCE WITH SUBTITLE C OF THE RESOURCE CONSERVATION
AND RECOVERY ACT (RCRA).
- REMOVAL OF THE LAGOON LINER AND ADJACENT HIGHLY CONTAMINATED SOIL
FOR DISPOSAL AT A FACILITY IN COMPLIANCE WITH SUBTITLE C OF RCRA.
ABSTRACT :
THE KEEFE ENVIRONMENTAL SERVICES (KES) SITE IS LOCATED IN A RURAL
AREA IN THE TOWN OF EPPING, NH. THE SITE IS LOCATED ON APPROXIMATELY
SEVENTEEN ACRES OF WOODLAND OFF THE NORTH SIDE OF EXETER ROAD. THE
SITE IS LOCATED IN A STATE PROTECTED (CLASS A - NO DISCHARGES ABOVE
BACKGROUND) WATERSHED WITH WETLAND AREAS DRAINING TO THE PISCASSIC
RIVER. THE TOWN OF NEW MARKET HAS A WATER SUPPLY INTAKE ON THE
PISCASSIC RIVER SEVEN MILES DOWNSTREAM FROM THE SITE. THE GROUND WATER
AQUIFER IS USED AS A WATER SUPPLY FOR TEN RESIDENCES LOCATED CLOSE BY
AND IS THE MAJOR SOURCE OF DRINKING WATER FOR APPROXIMATELY
2,000 PERSONS WITHIN A THREE-MILE RADIUS OF THE SITE. THE KES WAS
DESIGNED AND CONSTRUCTED AS A CHEMICAL WASTE STORAGE AND BULKING
FACILITY. THE SITE CONTAINS A 700,000 GALLON OPEN STORAGE LAGOON WITH A
100 MIL. POLYETHYLENE LINER. DURING ITS PERIOD OF OPERATION, KES
RECEIVED OVER ONE MILLION GALLONS OF HAZARDOUS WASTES INCLUDING TOLUENE
METHANOL, ACETONE, MEK, GLYCOLS, WASTE OILS, WASTE ALCOHOLS, STYRENE
CYANIDE AND HEAVY METALS. KES WAS CITED ON SEVERAL OCCASIONS WITH
HEALTH AND SAFETY VIOLATIONS BEFORE FILING FOR BANKRUPTCY IN
JANUARY 1981.
REMEDIAL ACTIONS INCLUDED IN THE SELECTED OPTION ARE, REMOVAL OF
THE CONTENTS OF THE LAGOON FOR DISPOSAL OFFSITE AT A RCRA REGULATED
FACILITY, AND REMOVAL OF THE LAGOON LINER AND ADJACENT HIGHLY
CONTAMINATED SOIL FOR DISPOSAL AT A RCRA REGULATED FACILITY. ESTIMATED
CAPITAL COSTS FOR THIS ACTION ARE $500,000 WITH NO ESTIMATED ANNUAL O&M
COSTS.
DO YOU WANT TO SEE THE NEXT ITEM (YES:NO)? YES
B-12
-------
DISPLAY OPTION 4
ROD TEXT ONLY
Item 1
SITE NAME :KEEFE
ROD DATE :831115
ANALYSES OF LAGOON CONTENTS INDICATE THAT THE LAGOON IS STRATIFIED INTO
SEVERAL DISTINCT LAYERS WITH EACH LAYER EXHIBITING VARYING
CONCENTRATIONS OF SPECIFIC COMPOUNDS AND DISTINCT COLOR CHANGES FROM
ONE
LAYER TO ANOTHER. SOME COMPOUNDS WERE FOUND TO HAVE INCREASING
CONCENTRATIONS WITH DEPTH. THESE INCLUDE METHYLENE CHLORIDE,
1,1-DICHLOROETHANE, TRICHLOROETHYLENE, TETRACHLOROETHYLENE,
••ETHYLBENZENE, AND XYLENES. THE LAGOON WAS ALSO FOUND TO HAVE
••SIGNIFICANT AMOUNTS OF HEAVY METALS, INCLUDING ARSENIC, SILVER, COPPER,
••ZINC, NICKEL, CHROMIUM AND MANGANESE. CYANIDE WAS ALSO PRESENT IN THE
LAGOON IN CONCENTRATIONS RANGING FROM LESS THAN 1 PPM AT THE SURFACE TO
APPROXIMATELY 10 PPM AT THE BOTTOM.
THE FAST TRACK FEASIBILITY STUDY WAS SUPERVISED BY THE NHWS & PCC
UNDER A COOPERATIVE AGREEMENT WITH THE EPA. ON JULY 29, 1983, EPA'S
BOSTON REGIONAL OFFICE RELEASED THE 'PRELIMINARY FAST TRACK FEASIBILITY
Enter NEXT(next document), HIT(next context),TOP(entire document),
UP(to window up), DOWN(to window down), SELECT(this document)
/HIT
••End of document reached**
Enter NEXT(next document), HIT(next context),TOP(entire document),
UP(to window up), DOWN(to window down), SELECT(this document)
/SELECT
Enter NEXT(next document), HIT(next context),TOP(entire document),
UP(to window up), DOWN(to window down), SELECT(this document)
/NEXT
B-13
-------
DISPLAY OPTION 5
A LIST OF FIELDS AVAILABLE TO DISPLAY
THESE ARE THE FIELDS YOU CAN DISPLAY:
IDENTIFICATION ENVIRONMENTAL
7. CONTAMINATED MEDIA
8. KEY CONTAMINANTS
9. SELECTED KEY WORDS
1. REGION
2. LOCATION
3. SITE NAME
4. ROD ID NUMBER
5. SITE ID NUMBER
6. ROD DATE
ENTER:
- A SINGLE DISPLAY FIELD (3), OR
- MULTIPLE DISPLAY FIELDS (1,3,4,6)
DISPLAY
TEXT
10. SELECTED REMEDY
11. ABSTRACT
12. ROD TEXT
13. TEXT SECTIONS
14. FIGURES, TABLES, ETC
B-14
-------
SORT
SELECT THE FIELD(S) TO SORT ON FROM THE FOLLOWING LIST:
1. REGION
2. STATE
3. SITE NAME
4. ROD ID NUMBER
5. ROD DATE
ENTER:
- A SINGLE SORT FIELD (1), OR
- MULTIPLE SORT FIELDS SEPARATED BY COMMAS (1,3)
SORT = 3
==> YOUR SORT WAS COMPLETED AND SAVED AS DOCUMENT SET 4.
\
PRINT
YOU MAY PRINT:
1 - IDENTIFICATION FIELDS
2 - IDENTIFICATION AND ENVIRONMENTAL FIELDS
3 - IDENTIFICATION FIELDS AND THE ABSTRACT
4 - IDENTIFICATION FIELDS AND THE SELECTED REMEDY
5 - IDENTIFICATION FIELDS, THE ABSTRACT, AND
THE SELECTED REMEDY
S - RETURN TO THE SELECTION MENU
X - EXIT THE ROD SYSTEM
SELECTION:
B-15
-------
SEARCH
EACH ROD CONTAINS THE FOLLOWING SEARCHABLE INFORMATION FIELDS:
IDENTIFICATION
1. REGION
2. STATE
3. SITE NAME
4. ROD ID NUMBER
5. ROD DATE
ENVIRONMENTAL
6. CONTAMINATED MEDIA
7. KEY CONTAMINANTS
8. SELECTED KEY WORDS
TEXT
9. SELECTED REMEDY
10. ABSTRACT
11. ROD TEXT
ENTER:
THE NUMBER FOR THE INFORMATION FIELD TO SEARCH, OR
H - FOR HELP EXPLANATIONS, OR
M- TO RETURN TO THE MAIN MENU, OR
X - TO EXIT THE RODS SYSTEM
S - GO TO THE SELECTION MENU
SELECTION:
B-16
-------
COMBINE SEARCH SETS
COMBINE ALLOWS YOU TO REFINE YOUR SEARCH BY COMBINING
SEARCH SETS USING THE FOLLOWING OPERATORS:
OR =ONE OR THE OTHER OR BOTH
AND =BOTH ONE AND THE OTHER
ANDNOT=ONE AND NOT THE OTHER
EXAMPLES OF THE COMBINE EXPRESSION FORMAT ARE:
I AND 3 AND 4
1 ANDNOT 2
1 OR 3 OR 4
1 AND 4 ANDNOT 2
PRESS ENTER TO CONTINUE:
YOU HAVE CREATED THE FOLLOWING SEARCH SETS:
3/ LIST
SETNO: NO.ITEMS: REQUEST:
SET 1: 21 REG=1
SET 2: 104 TEXT=chromium
ENTER:
A COMBINE EXPRESSION (1 AND 2), OR
SE - TO CONTINUE SEARCHING
R - TO RETURN TO THE SELECTION MENU
SELECTION: 1 and 2
=> 4 RODS MET THE CONDITIONS OF YOUR COMBINE STATEMENT;
•> THEY WERE SAVED AS SEARCH SET NUMBER 3.
B-17
-------
LIST
YOU HAVE CREATED THE FOLLOWING SEARCH SETS:
5/ LIST
SETNO: NO.ITEMS: REQUEST:
SET 1: 21 REG=1
SET 2: 104 TEXT-CHROMIUM
SET 3: 4 1 AND 2
SET 4: 4 1 AND 2 SORT=NAME
DO YOU WANT TO DELETE YOUR SEARCH SETS? Y
ARE YOU SURE? Y
YOUR SEARCH SETS HAVE BEEN DELETED
THANK YOU FOR USING THE RODS DATA BASE.
TO DISCONNECT FROM THE IBM MAINFRAME,
ENTER 'LOGOFF WHEN YOU RECEIVE THE
'READY' PROMPT.
READY
V
B-18
-------
APPENDIX C
THE HELP MENUS
-------
APPENDIX C
THE HELP MENUS
TABLE OF CONTENTS
TITLE PAGE
THE RODS HELP MENU C-l
GENERAL HELP TOPICS C-l
WHAT IS A ROD? C-2
FIELDS IN THE RODS DATA BASE C-2
TERMINOLOGY C-3
HOW TO USE THE RODS DATA BASE C-3
SEARCHING THE DATA BASE C-4
WHAT IS A SEARCH SET? . . . C-5
COMBINING SEARCH SETS C-7
SORTING A SEARCH SET C-8
DISPLAYING A SEARCH SET C-9
PRINTING A SEARCH SET C-ll
TERMINOLOGY
BASIS COMMAND LANGUAGE C-13
ENVIRONMENTAL INFORMATION C-13
FIELD C-14
FISCAL YEAR C-15
IDENTIFICATION INFORMATION C-15
LOGOFF C-16
OERR/OWPE . C-16
RECORD C-17
TEXT INFORMATION C-17
THESAURUS C-18
TERMS FOR A SPECIFIC FIELD
YOU CAN LOOK AT THE INDEX FOR THE FOLLOWING FIELDS C-l9
THE REGION INDEX C-19
THE LOCATION INDEX C-20
THE SITE NAME INDEX C-20
THE ROD ID NUMBER INDEX C-21
THE SITE ID NUMBER INDEX C-21
THE ROD DATE INDEX C-22
THE MEDIA INDEX C-22
THE KEY CONTAMINANTS INDEX C-23
THE KEY WORDS INDEX C-23
THE SELECTED REMEDY INDEX C-24
THE ABSTRACT INDEX C-24
THE TEXT INDEX C-25
THE TEXT SECTIONS INDEX C-25
C-i
-------
RODS HELP MENU
ENTER:
1 - GENERAL HELP TOPICS, OR
2 - FIELD INFORMATION, OR
3 - INDEX TERMS FOR A SPECIFIC FIELD, OR
4 - BROWSE THE DATA THESAURUS, OR
S - RETURN TO THE SEARCH MENU, OR
X- EXIT THE RODS SYSTEM
SELECTION:
GENERAL HELP TOPICS
AT THE PROMPT, SELECT ONE OF THE FOLLOWING:
1 - WHAT IS A ROD?
2 - FIELDS IN THE RODS DATA BASE
3 - TERMINOLOGY
4 - HOW TO USE THE RODS DATA BASE
5 - SEARCHING THE DATA BASE
6 - WHAT IS A SEARCH SET?
7 - COMBINING SEARCH SETS
8 - SORTING A SEARCH SET
9 - DISPLAYING A SEARCH SET
10 - PRINTING A SEARCH SET
H - RETURN TO THE HELP MENU
S - RETURN TO SEARCH MENU
X - EXIT RODS
SELECTION:
C-l
-------
WHAT IS A ROD?
A ROD or Record of Decision is mainly a textual
document describing EPA's planned course of action
to clean up a listed or proposed site on the National
Priorities List. The ROD is the official record of
EPA's remedy selection for the site. The majority of
RODs follow a standard format specified in OERR
guidance to the Regional Offices. The ROD System
contains all text pages from the documents, as well as
some of the textual tables. The system contains all
RODs since the inception of the Superfund program. As
new RODs are signed, they are entered into RODS. At
this time, maps and other graphic materials are not in
the ROD System.
PRESS ENTER TO CONTINUE:
FIELDS IN THE RODS DATA BASE
FIELD NAME BASIS ACCESS NAME
ABSTRACT ABS
ALIAS NAME ALIAS
KEY CONTAMINANTS CONT
FIGURES, TABLES, ETC FIGURES
KEY WORDS KEYS
LOCATION LOC
CONTAMINATED MEDIA MEDIA
SITE NAME NAME
SITE NAME & ALIAS NAMES NAMES
ROD DATE RDATE
REGION REG
SELECTED REMEDY REM
ROD ID NUMBER RODID
TEXT SECTION HEADINGS SECT
SITE ID NUMBER SITEID
TEXT TEXT
PRESS ENTER TO CONTINUE:
C-2
-------
TERMINOLOGY
EXPLANATIONS ARE AVAILABLE FOR THE FOLLOWING TERMS:
1 - BASIS ACCESS NAME
2 - BASIS COMMAND LANGUAGE
3 - ENVIRONMENTAL INFORMATION
4 - FIELD
5 - FIELD NAME
6 - FISCAL YEAR
7 - IDENTIFICATION INFORMATION
8 - LOGOFF
9 - OERR
10 - RECORD
11 - TEXT INFORMATION
12 - THESAURUS
H - RETURN TO THE HELP MENU
S - RETURN TO THE SEARCH MENU
X - EXIT RODS
ENTER YOUR SELECTION:
HOW TO USE THE RODS DATA BASE
There are two ways to use the RODS data base:
1. Using the Search MENUS
2. Using the BASIS Command Language
The Search MENUS are used by most users. The MENUS
are a user friendly interface to the RODS data base.
The MENUS lead you through the data base step-by-step.
You do not have to know any special commands to use
the MENUS.
The BASIS Command Language (BCL) is for
experienced, frequent users. To use BCL
you must know BASIS commands and their
syntax.
PRESS ENTER TO CONTINUE:
C-3
-------
SEARCHING THE DATA BASE
There are 11 searchable fields in the RODs data base.
These 11 fields are grouped into 3 categories as
follows:
IDENTIFICATION
ENVIRONMENTAL
TEXT
1.
2.
3.
4.
5.
REGION
STATE
SITE NAME
ROD ID NUMBER
ROD DATE
6.
7.
8.
CONTAMINATED MEDIA
KEY CONTAMINANTS
SELECTED KEY WORDS
9. SE
10. AI
11. R(
SELECTED REMEDY
ABSTRACT
ROD TEXT
You can use any of these fields to search the data base.
For example, if you wanted to search by REGION you would
select 1.
PRESS ENTER TO CONTINUE:
Once you select the field to search, the system prompts
you for a search term. For example, if you wanted all
RODs in Region 2, you would enter a 2 at the "FIND REGION="
prompt.
The system finds all RODs in Region 2 and saves them in a
search set. Each search set you create will have a unique
number so that you can refer to or manipulate the sets
during your session.
Once you have created one or more search sets, you can
perform other functions such as SORT, COMBINE, and
DISPLAY.
PRESS ENTER TO CONTINUE:
C-4
-------
WHAT IS A SEARCH SET?
A SEARCH SET (sometimes called a document set) is
a set of related RODs. The manner in which the RODs
are related is determined by the search you perform.
For example, if you choose to search for all RODs in
Region 2 (FIND REGION=2) the system will respond:
—> 23 RODS WERE FOUND AND SAVED AS SEARCH SET 1
You have created a Search Set consisting of 23 related
RODs, related because they all are from Region 2.
PRESS ENTER TO CONTINUE:
Another example, if you choose to search for all RODs
from FY 85 (FIND ROD DATE=85) the system will respond:
==> 65 RODS WERE FOUND AND SAVED AS SEARCH SET 2
All the RODs in Search Set 2 are related because they
are all from FY 85.
Search Sets can also be created by combining existing
Search Sets. For example, if you want to find all RODs
from Region 2 that were signed in FY 85, you can enter a
combine term, 1 and 2 (meaning find all RODs that meet
the search criteria of both Search Sets 1 and 2), and the
system will respond:
==> 13 RODS MET THE CONDITIONS OF YOUR COMBINE;
-=> THEY WERE SAVED AS SEARCH SET 3
All the RODs in Search Set 3 are related as they all are
from Region 2 and were all signed during FY 85.
PRESS ENTER TO CONTINUE:
C-5
-------
Another way to create a Search Set is to sort an
existing Search Set. If you choose to sort Search Set 3
by site name, the system will respond:
--> YOUR SORT WAS COMPLETED AND SAVED AS SEARCH SET 4
If you were to display Search Set 4 you would find that
it contains all RODs from Region 2 that were signed in
FY 85, in alphbetical order by Site Name.
PRESS ENTER TO CONTINUE:
C-6
-------
COMBINING SEARCH SETS
The COMBINE function is used to refine your search
by combining search criteria.
The following Boolean operators can be used to combine
search sets:
AND = both one and the other
OR = one or the other or both
ANDNOT = one and not the other
PRESS ENTER TO CONTINUE:
V
For example, if the following search sets have been created:
NUMBER
OF RODS
SEARCH SET
NUMBER
1
2
3
SEARCH
CRITERIA
REGION=1
LOCATION=MA
ROD DATE=85
18
6
65
If you combine 1 AND 3, a search set will be created for
all RODs that are from Region 1 and were signed during
FY 85; the resulting search set contains 6 RODs.
If you combine 1 OR 3, a search set will be created for
all RODs from Region 1 together with all RODs signed in
in FY 85; the resulting search set contains 77 RODs.
If you combine 1 ANDNOT 2, a search set is created for all
RODs from Region 1 excluding those from Massachusetts
(i.e. all RODs from ME, NH, VT, CT, and RI);
the resulting search set contains 12 RODs.
PRESS ENTER TO CONTINUE:
C-7
-------
SORTING A SEARCH SET
In order to arrange a search set in a more logical order,
you may choose to SORT your search set before displaying or
printing it. There are 5 SORT criteria; you can SORT by
REGION, STATE, SITE NAME, ROD ID NUMBER, and ROD DATE.
The SORT function works against the last created search set.
For example, if you have created 3 search sets, the SORT is
performed against search set 3.
PRESS ENTER TO CONTINUE:
C-8
-------
DISPLAYING A SEARCH SET
There are 5 DISPLAY options for displaying the results
of your searching. The fields associated with each choice
are listed below:
1. IDENTIFICATION INFORMATION = REGION, LOCATION, SITE
NAME, ROD ID NUMBER, AND
ROD DATE
2. ENVIRONMENTAL INFORMATION = SITE NAME, ROD DATE,
CONTAMINATED MEDIA, KEY
CONTAMINANTS, AND KEY WORDS
3. SELECTED REMEDY & ABSTRACT - SITE NAME, ROD DATE,
SELECTED REMEDY, AND
4: ROD TEXT
5. LIST OF FIELDS AVAILABLE
TO DISPLAY
ABSTRACT
SITE NAME, ROD DATE,
AND TEXT
ALLOWS YOU TO SELECT THE
FIELDS TO DISPLAY
IMPORTANT! The DISPLAY command displays only the last
search set created.
PRESS ENTER TO CONTINUE:
When DISPLAYing the TEXT field, there are some important
things to remember:
First, if the search set you are DISPLAYing was created
by searching the TEXT field, the context areas containing
your search term will be highlighted with 2 asterisks (**)
in the left columns. The system starts by DISPLAYing the
the first context area which contains your term.
Second, if the search set you are DISPLAYing was created
by searching a field other than the TEXT field, no context
areas will be highlighted. The system starts by DISPLAYing
the top of the TEXT field.
PRESS ENTER TO CONTINUE:
C-9
-------
Third, there are 7 commands that you must use when DISPLAYing
the TEXT field. On the screen you will see:
Enter NEXT(next document), HIT(next context), TOP(entiredocument)
UP(to window up), DOWN(to window down), SELECT(this document)
Another command not on the screen is EXIT(end display).
7 of these commands are described below:
All
NEXT= This command takes you to the next ROD (next document)
in your search set and displays it. If there are no
more RODS to be displayed, NEXT takes you back to the
Selection Menu.
HIT = This command is only used when the search set you are
displaying was created by searching the TEXT field.
This command takes you to the next occurence of your
search term. If no more occurences of your search term
are present in the TEXT or if you did not search the
TEXT field, you will see the message "**End of
document reached**".
PRESS ENTER TO CONTINUE:
TOP = This command displays the entire TEXT field. BE CAREFUL
when using the TOP command as the ENTIRE text will be
displayed. Some RODs are very long so it may take a
long time for the entire TEXT field to be displayed.
USE THIS COMMAND CAREFULLY!
This command allows you to display the previous 12 lines.
This command allows you to display the next 12 lines.
This command allows you to create a search set by
SELECTing which RODs in a search set are pertinent
to you. The SELECT command creates a new search set.
This command lets you end your display and takes you
back to the Selection Menu.
UP
DOWN
SELECT
EXIT
PRESS ENTER TO CONTINUE:
C-10
-------
PRINTING A SEARCH SET
The PRINT function allows you to printout certain
fields from the data base. There are 6 predefined
Print reports:
1 - IDENTIFICATION FIELDS
2 - IDENTIFICATION AND ENVIRONMENTAL FIELDS
3 - IDENTIFICATION FIELDS AND THE ABSTRACT
4 - IDENTIFICATION FIELDS AND THE SELECTED REMEDY
5 - IDENTIFICATION FIELDS, THE ABSTRACT, AND
THE SELECTED REMEDY
6 - IDENTIFICATION FIELDS AND TEXT CONTEXT AREAS
(USE THIS ONLY IF THE SEARCH SET YOU ARE PRINTING
WAS CREATED BY SEARCHING THE TEXT FIELD)
The Identification fields include:
REGION, NAME, ROD ID, and ROD DATE
The Environmental fields include:
CONTAMINATED MEDIA, KEY CONTAMINANTS, and KEY WORDS
PRESS ENTER TO CONTINUE:
Note that only the context areas of the TEXT field
are PRINTable. This means that you must have searched
the TEXT field to use this option. If you try to use
this option and you did not search the TEXT field,
your printout will contain only the first couple lines
of TEXT.
PRESS ENTER TO CONTINUE:
C-ll
-------
After you have selected which fields to PRINT, you
must specify where the printout is to be sent. The
following is a list of Regional Remote Printers:
LOCATION REMOTE NUMBER
REGION 1 RMT34
REGION 2 N7
REGION 3 N14
REGION 4 N12
REGION 5 (111 W JACKSON) AMT138
REGION 5 (230 S DEARBORN) AMT02
REGION 6 N10
REGION 7 N13
REGION 8 AMT11
REGION 9 AMT75
REGION 10 Nil
HQ - WIC N3
NEIC DENVER N9
You must enter the Remote Number. Your printout will
be sent to the Location specified.
PRESS ENTER TO CONTINUE:
C-12
-------
BASIS COMMAND LANGUAGE
BASIS COMMAND LANGUAGE (BCL) is a way to search the RODS
data base without using the menus. To use BCL, the user
must know the BASIS commands (e.g. Find, Display, Sort,
Look, etc.) and the syntax for each command. The user must
also know the BASIS ACCESS NAME for each field and be
familiar with the structure of the data base. In general,
BCL is for use by experienced, frequent users. Most users
will search the RODS data base using the menus.
PRESS ENTER TO CONTINUE:
ENVIRONMENTAL INFORMATION
The fields in the RODS data base have been divided
into 3 types of information, namely:
IDENTIFICATION
ENVIRONMENTAL
TEXT
The ENVIRONMENTAL INFORMATION fields include:
CONTAMINATED MEDIA
KEY CONTAMINANTS
SELECTED KEY WORDS
All of these fields are derived from the National
Technical Information Service (NTIS) coversheets
and/or the ROD Annual Reports. All of these
fields contain lists of terms which were manually
extracted from the RODS. In addition to searching
these fields, it is advisable to search the TEXT
field for this type of information.
PRESS ENTER TO CONTINUE:
C-13
-------
FIELD
A FIELD is piece of a data base containing a specific
piece of data. Each ROD has 15 fields associated with
it. Each field has a specific type of data in it.
PRESS ENTER TO CONTINUE:
The RODS fields are as follows:
THE FIELD: CONTAINS:
ABSTRACT
ALIAS Name
KEY CONTAMINANTS
FIGURES, TABLES, etc
SELECTED KEY WORDS
LOCATION
CONTAMINATED MEDIA
SITE NAME
ROD DATE
REGION
SELECTED REMEDY
ROD ID NUMBER
SITE ID NUMBER
ROD TEXT
TEXT SECTIONS
An abstract of the ROD
The alias name of the site
A list of key contaminants
A list of figures etc. in the ROD
A list of selected key words
The city and state
A list of contaminated media
The site name
The date the ROD was signed
The region in which the site is
located
The remedy selected for the site
The ROD identification number
The CERCLIS site ID number
The whole text of the ROD
A list of the text sections in the ROD
PRESS ENTER TO CONTINUE:
C-14
-------
FISCAL YEAR
A FISCAL YEAR is the year based on the government's
budget cycles. A FISCAL YEAR begins October 1 and
ends September 30. The abbreviation for FISCAL YEAR
is FY.
PRESS ENTER TO CONTINUE:
IDENTIFICATION INFORMATION
The fields in the RODS data base have been divided
into 3 types of information, namely:
IDENTIFICATION
ENVIRONMENTAL
TEXT
The IDENTIFICATION INFORMATION fields include:
REGION
STATE (LOCATION)
SITE NAME
ALIAS NAME
ROD ID NUMABER
SITE ID NUMBER
ROD DATE
All of these fields contain basic information about
the identity of the site.
PRESS ENTER TO CONTINUE:
C-15
-------
LOGOFF
LOGOFF is the comman 1 the user must enter to
disconnect from the IBM mainframe computer.
When you select to "EXIT" from the data base
you will get a message and then see the word
"READY". After you see the word "READY",
type in "LOGOFF and you will be disconnected
from the IBM.
PRESS ENTER TO CONTINUE:
OERR/OWPE
OERR is the acronym for the Of fie. of Emergency
and Remedial Response. OERR is the Superfund
office responsible for Fund-lead RODS. OWPE is
the acronym for the Office of Waste Programs
Enforcement. OWPE is the Superfund office
responsible for Enforcement-lead RODS.
PRESS ENTER TO CONTINUE:
C-16
-------
RECORD
A RECORD is a group of related fields. All of the
fields for one ROD makes up a RECORD.
PRESS ENTER TO CONTINUE:
TEXT INFORMATION
The fields in the RODS data base have been divided
into 3 types of information, namely:
IDENTIFICATION
ENVIRONMENTAL
TEXT
The TEXT INFORMATION fields include:
SELECTED REMEDY
ABSTRACT
ROD TEXT
TEXT SECTIONS
FIGURES, TABLES, etc.
Three of these fields (SELECTED REMEDY, ABSTRACT,
and ROD TEXT) contain textual information (i.e.
the data in these fields are written in full
sentences, paragraphs). The other two fields
(TEXT SECTIONS and FIGURES) contain information
related to the ROD TEXT field.
PRESS ENTER TO CONTINUE:
C-17
-------
THESAURUS
The THESAURUS is a function in the HELP portion of
data base menus which is not available yet.
The THESAURUS is a HELP feature which will allow
you to find all possible forms of a term. A term
may be in the data base many different ways. For
example, EPA may be in the data base as: U.S. E.P.A.,
EPA, USEPA, U.S. Environmental Protection Agency,
Environmental Protection Agency, etc. By looking in
THESAURUS, you can find all the different ways a term
is represented in the data base and conduct your
searches accordingly.
PRESS ENTER TO CONTINUE:
EXPLANATIONS ARE AVAILABLE FOR THE FOLLOWING FIELDS:
IDENTIFICATION
1. REGION
2. STATE
3. SITE NAME/ALIAS
4. ROD ID NUMBER
5. SITE ID NUMBER
6. ROD DATE
ENVIRONMENTAL
7. CONTAMINATED MEDIA
8. KEY CONTAMINANTS
9. SELECTED KEY WORDS
TEXT
10. SELECTED REMEDY
11. ABSTRACT
12. ROD TEXT
13. TEXT SECTIONS
14. FIGURES, TABLES, ETC
ENTER THE FIELD NUMBER:
C-18
-------
YOU CAN LOOK. AT THE INDEX FOR THE FOLLOWING FIELDS:
IDENTIFICATION
1. REGION
2. LOCATION
«. SITE NAME
4. ROD ID NUMBER
5. SITE ID NUMBER
6. ROD DATE
ENVIRONMENTAL
7. CONTAMINATED MEDIA
8. KEY CONTAMINANTS
9. SELECTED KEY WORDS
TEXT
10. SELECTED REMEDY
11. ABSTRACT
12. ROD TEXT
13. TEXT SECTIONS
ENTER THE FIELD NUMBER:
YOU HAVE CHOSEN TO LOOK IN THE REGION INDEX.
ENTER THE WORD OR WORD STEM TO LOOK UP 1
I/ LOOK REG=1**
A 21 REG=1
B 9 REG=10
C 42 REG=2
D 35 REG=3
E 23 REG=4
F 48 REG-5
G 22 REG«6
H 6 REG«7
I 11 REG-8
J 11 REG=9
K 7 REM»&
L 182 REM—
More terms
Pick
==> ENTER "MORE" TO SEE MORE INDEX TERMS, OR
==> PRESS ENTER TO RETURN TO THE HELP MENU, OR
==> ENTER A LETTER (A) OR MULTIPLE LETTERS (A,B) TO CREATE A
SEARCH SET
C-19
-------
YOU HAVE CHOSEN TO LOOK IN THE LOCATION INDEX.
ENTER THE WORD OR WORD STEM TO LOOK UP: A
I/ LOOK LOC=A**
A 1 LOC=ALBUQUERQUE, NM
B 1 LOC=ALFORD, FL
C 1 LOC=ANNAPOLIS, MD
D 1 LOC=ARCANUM, OH
E 5 LOC=ARDEN HILLS, MN
F 1 LOC=ASHLAND, MA
G 1 LOC=ASHTABULA, OH
H 1 LOC-ASPEN, CO
I 1 LOC=BATTLE CREEK, MI
J 1 LOC-BEACON FALLS, CT
K 1 LOC=BOULDER, CO
L I LOC=BRAINERD/BAXTER, MN
More terms
Pick
-»> ENTER "MORE" TO SEE MORE INDEX TERMS, OR
==> PRESS ENTER TO RETURN TO THE HELP MENU, OR
==> ENTER A LETTER (A) OR MULTIPLE LETTERS (A,B) TO CREATE A
SEARCH SET
YOU HAVE CHOSEN TO LOOK IN THE SITE NAME INDEX.
ENTER THE WORD OR WORD STEM TO LOOK UP: S
I/ LOOK NAME=S**
A 1 NAME=SALTVILLE
B 1 NAME=SALTVILLE WASTE
C 2 NAME=SALVAGE
D 1 NAME-SAN
E 1 NAME-SAN GABRIEL AREA 1
F 4 NAME-SAND
G 1 NAME-SAND, GRAVEL & STONE
H 1 NAME-SANDY
I 1 NAME-SANITARY
J 1 NAME-SANITATION
K 1 NAME-SAPP
L 1 NAME-SAPP BATTERY
More terms
Pick
—> ENTER "MORE" TO SEE MORE INDEX TERMS, OR
-=> PRESS ENTER TO RETURN TO THE HELP MENU, OR
==> ENTER A LETTER (A) OR MULTIPLE LETTERS (A,B) TO CREATE A
SEARCH SET
J
C-20
-------
YOU HAVE CHOSEN TO LOOK IN THE ROD ID NUMBER INDEX.
ENTER THE WORD OR WORD STEM TO LOOK UP: R06
I/ LOOK RODID=R06**
A 1 RODID=R06-84/001
B 1 RODID=R06-84/002
C 1 RODID=R06-84/003
D 1 RODID=R06-84/004
E 1 RODID=R06-85/005
F 1 RODID=R06-85/006
G 1 RODID=R06-85/007
H 1 RODID=R06-85/008
I 1 RODID=R06-86/009
J 1 RODID-R06-86/010
K 1 RODID=R06-86/011
L 1 RODID=R06-86/012
More terms
Pick
==> ENTER "MORE" TO SEE MORE INDEX TERMS, OR
==> PRESS ENTER TO RETURN TO THE HELP MENU, OR
==> ENTER A LETTER (A) OR MULTIPLE LETTERS (A,B) TO CREATE A
SEARCH SET
YOU HAVE CHOSEN TO LOOK IN THE SITE ID NUMBER INDEX.
— — — »» — — •*>• — — — — «« — — — — — — *«•• — — — • — — — — •••••• — — — — — •.»• — — — — — — — — •••.••,.•»•••••»«»
ENTER THE WORD OR WORD STEM TO LOOK UP: A
1/LOOKSITEID=A**
A 1 SITEID=AL
B 3 SITEID=AR
C 1 SITEID=AS
D 1 SITEID-AZ
E 9 SITEID=CA
F 6 SITEID-CO
G 2 SITEID-CT
H 4 SITEID-DE
I 13 SITEID-FL
J 3 SITEID-IA
K 10 SITEID=IL
L 5 SITEID=IN
More terms
Pick
==> ENTER "MORE" TO SEE MORE INDEX TERMS, OR
==> PRESS ENTER TO RETURN TO THE HELP MENU, OR
==> ENTER A LETTER (A) OR MULTIPLE LETTERS (A,B) TO CREATE A
SEARCH SET
C-21
-------
YOU HAVE CHOSEN TO LOOK IN THE ROD DATE INDEX:
ENTER THE WORD OR WORD STEM TO LOOK UP:
I/ LOOK RDATE=82**
A 13 RDATE=821001/830930
B 37 RDATE=831001/840930
C 66 RDATE=841001/850930
D 80 RDATE=851001/860930
E 27 RDATE=861001/870930
F 21 REG=1
G 9 REG=10
H 42 REG=2
I 35 REG=3
J 23 REG=4
K. 48 REG=5
L 22 REG-6
More terms
Pick
==> ENTER "MORE" TO SEE MORE INDEX TERMS, OR
==> PRESS ENTER TO RETURN TO THE HELP MENU, OR
==> ENTER A LETTER (A) OR MULTIPLE LETTERS (A,B) TO CREATE A
SEARCH SET
YOU HAVE CHOSEN TO LOOK IN THE MEDIA INDEX.
ENTER THE WORD OR WORD STEM TO LOOK UP:
I/ LOOK MEDIA=**
A 22 MEDIA=AIR
B 1 MEDIA=ASPHALT
C 1 MEDIA-BOG
D 1 MEDIA=CREEK
E 1 MEDIA=CREEK SEDIMENTS
F 1 MEDIA-DEBRIS
G 1 MEDIA-DREDGE
H 1 MEDIA-DREDGE SPOILS
I 1 MEDIA-DRUM
J 1 MEDIA-FISH
K 3 MEDIA-GROUND
L 3 MEDIA-GROUND WATER
More terms
Pick
==> ENTER "MORE" TO SEE MORE INDEX TERMS, OR
==> PRESS ENTER TO RETURN TO THE HELP MENU, OR
-=:» ENTER A LETTER (A) OR MULTIPLE LETTERS (A,B) TO CREATE A
SEARCH SET
C-22
-------
YOU HAVE CHOSEN TO LOOK IN THE KEY CONTAMINANTS INDEX.
ENTER THE WORD OR WORD STEM TO LOOK UP: CHLORO
I/ LOOK CONT=CHLORO**
A 1 CONT=CHLOROBENZENE
B 1 CONT=CHLOROBENZENES
C 1 CONT=CHLOROBENZENES AND SULFIDES
D 1 CONT=CHLOROETHANE
E 1 CONT=CHLOROETHYL
F 2 CONT=CHLOROFORM
G 1 CONT=CHLOROPHENOLS
H 29 CONT-CHROMIUM
I 2 CONT=COAL
J 1 CONT=COAL FINES
K 1 CONT=COAL TAR WASTES
L 9 CONT-COMPOUNDS
More terms
Pick
==> ENTER "MORE" TO SEE MORE INDEX TERMS, OR
==> PRESS ENTER TO RETURN TO THE HELP MENU, OR
==> ENTER A LETTER (A) OR MULTIPLE LETTERS (A,B) TO CREATE A
SEARCH SET
YOU HAVE CHOSEN TO LOOK IN THE KEY WORDS INDEX.
ENTER THE WORD OR WORD STEM TO LOOK UP: OFF
I/ LOOK KEYS-OFF**
A 12 KEYS=OFF
B 2 KEYS-OFF-BASE CONTAMINATION
C 9 KEYS=OFF-SITE DISPOSAL
D 1 KEYS-OFF-SITE PLUME CONTROL
E 52 KEYS-OFFSITE
F 51 KEYS-OFFSITE DISPOSAL
G 2 KEYS-OIL
H 8 KEYS-OILS
I 7 KEYS-ON
J 2 KEYS-ON-SITE CONTAINMENT
K 1 KEYS-ON-SITE CONTAMINANT
L 3 KEYS-ON-SITE DISPOSAL
More terms
Pick
==> ENTER "MORE" TO SEE MORE INDEX TERMS, OR
==> PRESS ENTER TO RETURN TO THE HELP MENU, OR
—> ENTER A LETTER (A) OR MULTIPLE LETTERS (A,B) TO CREATE A
SEARCH SET
C-23
-------
YOU HAVE CHOSEN TO LOOK IN THE SELECTED REMEDY INDEX.
ENTER THE WORD OR WORD STEM TO LOOK UP: INCIN
I/ LOOK REM=INCIN**
A 1 REM=INCINERATE
B 6 REM=INCINERATED
C 27 REM=INCINERATION
D 6 REM=INCINERATOR
E 1 REM=INCINERATORS
F 20 REM-INCLUDES
G 20 REM=INCLUDING
H 3 REM=INCREASE
I 1 REM=INCREASES
J 1 REM=INCREASING
K 1 REM=INCREMENTAL
L 1 REM=INCURRED
More terms
Pick
==> ENTER "MORE" TO SEE MORE INDEX TERMS, OR
==> PRESS ENTER TO RETURN TO THE HELP MENU, OR
==> ENTER A LETTER (A) OR MULTIPLE LETTERS (A,B) TO CREATE A
SEARCH SET
YOU HAVE CHOSEN TO LOOK IN THE ABSTRACT INDEX.
ENTER THE WORD OR WORD STEM TO LOOK UP: STR
I/ LOOK ABS=STR**
A 2 ABS=STRATFORD
B 13 ABS=STREAM
C 4 ABS=STREAMS
D 14 ABS=STREET
E 2 ABS=STREETS
F 1 ABS=STRENGTH
G 1 ABS=STRESSED
H 1 ABS-STREWN
I 2 ABS=STRINGFELLOW
J 3 ABS=STRIP
K 2 ABS=STRIPPER
L 22 ABS=STRIPPING
More terms
Pick
==> ENTER "MORE" TO SEE MORE INDEX TERMS, OR
==> PRESS ENTER TO RETURN TO THE HELP MENU, OR
—> ENTER A LETTER (A) OR MULTIPLE LETTERS (A,B) TO CREATE A
SEARCH SET
C-24
-------
YOU HAVE CHOSEN TO LOOK IN THE TEXT INDEX.
ENTER THE WORD OR WORD STEM TO LOOK UP: CONTAM
I/ LOOK TEXT=CONTAM**
A 4 TEXT-CONTAM
B 1 TEXT=CONTAMINANAT
C 197 TEXT=CONTAMINANT
D 1 TEXT=CONTAMINANT-LADEN
E 1 TEXT=CONTAMINANT/MASS
F 3 TEXT=CONTAMINANT'S
G 2 TEXT=CONTAMINANTED
H 1 TEXT=CONTAMINANTION
I 206 TEXT=CONTAMINANTS
J 1 TEXT=CONTAMINANTS/CONTAMINATION
K 2 TEXT=CONTAMINANTS'
L 50 TEXT-CONTAMINATE
More terms
Pick
==> ENTER "MORE" TO SEE MORE INDEX TERMS, OR
==> PRESS ENTER TO RETURN TO THE HELP MENU, OR
==> ENTER A LETTER (A) OR MULTIPLE LETTERS (A,B) TO CREATE A
SEARCH SET
MORE
V
YOU HAVE CHOSEN TO LOOK IN THE TEXT SECTIONS INDEX.
ENTER THE WORD OR WORD STEM TO LOOK UP:
I/ LOOK SECT=**
A 1 SECT=(SARA) CLEANUP STANDARDS
B 1 SECT=(SARA) TO THE MAXIMUM EXTENT PRACTICABLE
C 8 SECT-&
D 2 SECT-ACT
E 48 SECT-ACTION
F 1 SECT-ACTION LEVELS
G 119 SECT-ACTIONS
H 17 SECT-ACTIVITIES
I 1 SECT-ACTIVITY
J 1 SECT-ADDENDUM
K 3 SECT-ADDITIONAL
L 1 SECT-ADDITIONAL CONSIDERATIONS
More terms
Pick
==> ENTER "MORE" TO SEE MORE INDEX TERMS, OR
==> PRESS ENTER TO RETURN TO THE HELP MENU, OR
==> ENTER A LETTER (A) OR MULTIPLE LETTERS (A,B) TO CREATE A
SEARCH SET
C-25
-------
Sample
Search
-------
APPENDIX D
SAMPLE SEARCH
-------
APPENDIX D
SAMPLE SEARCH
TABLE OF CONTENTS
TITLE
PAGE
RODS WELCOME SCREENS D-l
RODS MAIN MENU D-2
SEARCH D-2
REGION INFORMATION SEARCH D-3
SELECTION MENU D-3
SEARCH D-4
ROD TEXT SEARCH D-4
SELECTION MENU D-5
COMBINE SEARCH SETS D-5
YOU HAVE CREATED THE FOLLOWING SEARCH SETS D-6
SELECTION MENU D-6
SORT D-7
SELECTION MENU D-7
LIST D-8
SELECTION MENU D-8
DISPLAY D-9
SELECTION MENU D-ll
DISPLAY D-ll
SELECTION MENU D-19
LIST D-19
SELECTION MENU D-20
PRINT D-20
SELECTION MENU D-21
D-i
-------
RRRRRR
RRRRRRR
RR RR
RR RR
RR RR
RRRRRRR
RRRRRR
RR RR
RR RR
RR RR
RR RR
RR RR
OOOOO
OOOOOO
OO
OO
OO
OO
00
00
OO
00
OO
OO
OO
OO
00
00
00
00
OOOOOO
OOOOO
DDDDDD
DDDDDDD
DD DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DD
DDDDDDD
DDDDDD
sssssss
sssssssss
ss ss
ss
sss
sssssss
ssssssss
sss
ss
ss ss
sssssssss
sssssss
WELCOME TO THE
SUPERFUND
RECORDS OF DECISION
DATA BASE
D-l
-------
RODS MAIN MENU
CHOOSE ONE OF THE FOLLOWING USER LEVELS:
1 - RODS SEARCH MENU
2 - BASIS COMMAND LANGUAGE
X- EXIT
SELECTION: 1
SEARCH
EACH ROD CONTAINS THE FOLLOWING SEARCHABLE INFORMATION FIELDS:
IDENTIFICATION
I. REGION
2. STATE
3. SITE NAME
4. ROD ID NUMBER
5. ROD DATE
ENVIRONMENTAL TEXT
6. CONTAMINATED MEDIA 9.
7. KEY CONTAMINANTS 10.
8. SELECTED KEY WORDS 11.
SELECTED REMEDY
ABSTRACT
ROD TEXT
ENTER:
THE NUMBER FOR THE INFORMATION FIELD TO SEARCH, OR
H - FOR HELP EXPLANATIONS, OR
M- TO RETURN TO THE MAIN MENU, OR
X- TO EXIT THE RODS SYSTEM
SELECTION: 1
D-2
-------
REGION INFORMATION SEARCH
ENTER:
- A SINGLE REGION (1), OR
- MULTIPLE REGIONS SEPARATED BY COMMAS (1,3).
FIND REGION = 1
=> 21 RODS WERE FOUND AND SAVED AS SEARCH SET 1
SELECTION MENU
AT THIS POINT, YOU MAY:
MANIPULATE CURRENT SEARCH SET PERFORM OTHER FUNCTIONS
DI - DISPLAY RESULTS
SO - SORT RESULTS
PR - PRINT RESULTS
SE - CONTINUE SEARCHING
CO - COMBINE SEARCHES
LI - LIST SEARCH SETS
M - RETURN TO MAIN MENU
H - FOR HELP EXPLANATIONS
X - EXIT RODS
SELECTION: SE
D-3
-------
SEARCH
EACH ROD CONTAINS THE FOLLOWING SEARCHABLE INFORMATION FIELDS:
IDENTIFICATION
ENVIRONMENTAL
1.
2.
3.
4.
5.
REGION 6.
STATE 7.
SITE NAME 8.
ROD ID NUMBER
ROD DATE
CONTAMINATED MEDIA
KEY CONTAMINANTS
SELECTED KEY WORDS
TEXT
9. SELECTED REMEDY
10. ABSTRACT
11. ROD TEXT
ENTER:
THE NUMBER FOR THE INFORMATION FIELD TO SEARCH, OR
H - FOR HELP EXPLANATIONS, OR
M- TO RETURN TO THE MAIN MENU, OR
X - TO EXIT THE RODS SYSTEM
S - GO TO THE SELECTION MENU
SELECTION: 11
ROD TEXT SEARCH
ENTER:
- A SINGLE WORD (MERCURY), OR
- MULTIPLE WORDS (SOIL MERCURY)
FIND ROD TEXT - CHROMIUM
==> 104 RODS WERE FOUND AND SAVED AS SEARCH SET 2
D-4
-------
SELECTION MENU
AT THIS POINT, YOU MAY:
MANIPULATE CURRENT SEARCH SET PERFORM OTHER FUNCTIONS
DI - DISPLAY RESULTS SE - CONTINUE SEARCHING
SO - SORT RESULTS CO- COMBINE SEARCHES
PR- PRINT RESULTS LI - LIST SEARCH SETS
M- RETURN TO MAIN MENU
H - FOR HELP EXPLANATIONS
X - EXIT RODS
SELECTION: CO
COMBINE SEARCH SETS
COMBINE ALLOWS YOU TO REFINE YOUR SEARCH BY COMBINING
SEARCH SETS USING THE FOLLOWING OPERATORS:
OR =ONE OR THE OTHER OR BOTH
AND -BOTH ONE AND THE OTHER
ANDNOT »ONE AND NOT THE OTHER
EXAMPLES OF THE COMBINE EXPRESSION FORMAT ARE:
1 AND 3 AND 4
1 ANDNOT 2
1 OR 3 OR 4
1 AND 4 ANDNOT 2
PRESS ENTER TO CONTINUE:
D-5
-------
YOU HAVE CREATED THE FOLLOWING SEARCH SETS:
3/ LIST
SETNO: NO.ITEMS: REQUEST:
SET 1: 21 REG=1
SET 2: 104 TEXT=CHROMIUM
ENTER:
A COMBINE EXPRESSION (1 AND 2), OR
SE - TO CONTINUE SEARCHING
R - TO RETURN TO THE SELECTION MENU
SELECTION: 1 AND 2
==>
==>
4 RODS MET THE CONDITIONS OF YOUR COMBINE STATEMENT-
THEY WERE SAVED AS SEARCH SET NUMBER 3.
SELECTION MENU
AT THIS POINT, YOU MAY:
MANIPULATE CURRENT SEARCH SET PERFORM OTHER FUNCTIONS
DI - DISPLAY RESULTS
SO - SORT RESULTS
PR - PRINT RESULTS
SE - CONTINUE SEARCHING
CO - COMBINE SEARCHES
LI - LIST SEARCH SETS
M - RETURN TO MAIN MENU
H - FOR HELP EXPLANATIONS
X - EXIT RODS
SELECTION: SO
D-6
-------
SORT
SELECT THE FIELD(S) TO SORT ON FROM THE FOLLOWING LIST:
1. REGION
2. STATE
3. SITE NAME
4. ROD ID NUMBER
5. ROD DATE
ENTER:
- A SINGLE SORT FIELD (1), OR
- MULTIPLE SORT FIELDS SEPARATED BY COMMAS (1,3)
SORT = 3
=> YOUR SORT WAS COMPLETED AND SAVED AS DOCUMENT SET 4.
SELECTION MENU
AT THIS POINT, YOU MAY:
MANIPULATE CURRENT SEARCH SET PERFORM OTHER FUNCTIONS
DI - DISPLAY RESULTS SE - CONTINUE SEARCHING
SO - SORT RESULTS CO - COMBINE SEARCHES
PR - PRINT RESULTS LI - LIST SEARCH SETS
M - RETURN TO MAIN MENU
H - FOR HELP EXPLANATIONS
X - EXIT RODS
SELECTION: LI
D-7
-------
LIST
YOU HAVE CREATED THE FOLLOWING SEARCH SETS:
— — — — — — —• ••«>« — — «•.»<•_.•••.•._ _ _ • — — «,_...______...__«_. M « _ *• _ _ • » •
5/ LIST
SETNO: NO. ITEMS: REQUEST:
SET 1: 21 REG=1
SET 2: 104 TEXT=CHROMIUM
SET 3: 4 1 AND 2
SET 4: 4 1 AND 2 SORT=NAME
DO YOU WANT TO DELETE YOUR SEARCH SETS? N
SELECTION MENU
AT THIS POINT, YOU MAY:
MANIPULATE CURRENT SEARCH SETPERFORM OTHER FUNCTIONS
DI - DISPLAY RESULTS
SO - SORT RESULTS
PR - PRINT RESULTS
SE - CONTINUE SEARCHING
CO - COMBINE SEARCHES
LI - LIST SEARCH SETS
M - RETURN TO MAIN MENU
H - FOR HELP EXPLANATIONS
X - EXIT RODS
SELECTION: DI
D-8
-------
DISPLAY
YOU MAY DISPLAY:
1 - IDENTIFICATION INFORMATION ONLY, OR
2 - ENVIRONMENTAL INFORMATION ONLY, OR
3 - SELECTED REMEDY AND ABSTRACT ONLY, OR
4 - ROD TEXT ONLY, OR
5 - A LIST OF FIELDS AVAILABLE TO DISPLAY
SELECTION: 1
Item 1
REGION
LOCATION
SITE NAME
ROD ID
ROD DATE
Item 2
:WESTBOROUGH, MA
:HOCOMONCO POND
:R01-85/011
:850930
REGION :1
LOCATION :EPPING, NH
SITE NAME :KEEFE
ROD ID :RO 1-83/002
ROD DATE :831115
DO YOU WANT TO SEE THE NEXT ITEM (YES:NO)? YES
D-9
-------
Item 3
REGION
LOCATION
SITE NAME
ROD ID
ROD DATE
Item 4
REGION
LOCATION
SITE NAME
ROD ID
DATE
rASHLAND, MA
•.NYANZA CHEMICAL
:R01-85/013
:850904
LONDONDERRY, NH
:TINKHAM GARAGE
:R01-86/016
:860930
THAT WAS THE LAST ROD IN YOUR SEARCH SET.
PRESS ENTER TO CONTINUE:
D-10
-------
SELECTION MENU
AT THIS POINT, YOU MAY:
MANIPULATE CURRENT SEARCH SET
DI - DISPLAY RESULTS
SO - SORT RESULTS
PR - PRINT RESULTS
PERFORM OTHER FUNCTIONS
SE - CONTINUE SEARCHING
CO - COMBINE SEARCHES
LI - LIST SEARCH SETS
M - RETURN TO MAIN MENU
H - FOR HELP EXPLANATIONS
X - EXIT RODS
SELECTION: DI
DISPLAY
YOU MAY DISPLAY:
1 - IDENTIFICATION INFORMATION ONLY, OR
2 - ENVIRONMENTAL INFORMATION ONLY, OR
3 - SELECTED REMEDY AND ABSTRACT ONLY, OR
4 - ROD TEXT ONLY, OR
5 - A LIST OF FIELDS AVAILABLE TO DISPLAY
SELECTION: 4
D-ll
-------
Item 1
SITE NAME :HOCOMONCO POND
ROD DATE :850930
ORGANIC COMPOUNDS WHICH DO NOT HAVE CPFS BUT HAVE AN ACCEPTABLE DAILY
INTAKE (ADI) VALUE ESTABLISHED FOR OTHER HEALTH EFFECTS BY EPA WERE
PLACED IN THE NONCARCINOGEN GROUP. COMPOUNDS DETECTED IN THE HOCOMONCO
POND AREA HAVING ADI'S ARE NAPTHALENE, PHENOL, TOLUENE AND FLUORANTHENE.
THE POTENTIAL HEALTH RISK FOR NAPTHALENE IS GREATER THAN THE RISK FOR
••PHENOL, TOLUENE OR FLUORANTHENE. THROUGH A SIMILAR SELECTION PROCESS,
••INORGANIC CRITICAL CONTAMINANTS WERE DETERMINED TO BE ARSENIC AND
••CHROMIUM. CPFS HAVE BEEN ESTABLISHED FOR THESE COMPOUNDS AND BOTH
COMPOUNDS HAVE BEEN DETECTED ABOVE BACKGROUND CONCENTRATIONS IN SOIL,
GROUND WATER AND SEDIMENTS. THIS RANKING PROCEDURE IDENTIFIES THOSE
CONTAMINANTS POSING THE GREATEST HEALTH RISK AT THE SITE. THE
CONTAMINANTS IDENTIFIED AS "CRITICAL CONTAMINANTS" FOR THIS SITE ARE
PRESENTED ON TABLE 14. USING THE CPF AND ADI VALUES FOR "CRITICAL
CONTAMINANTS" HEALTH HAZARDS CAN BE QUANTIFIED. HEALTH HAZARDS
Enter NEXT(next document), HIT(next context),TOP(entire document),
UP(to window up), DOWN(to window down), SELECT(this document)
/HIT
D-12
-------
18-20 FEET BELOW GRADE. HIGHER RANGE VALUES FROM TEST PIT (TP-12)
WITHIN AN AREA OF VISIBLE CONTAMINATION 3 FEET BELOW GRADE
(2) GROUND WATER DATA ARE COMPILATION OF MW-6, 7, 8, AND 9
(3) 2,3,7,8 DIBENZO-P-DIOXIN WAS NOT DETECTED
ND - NOT DETECTED
BDL - DETECTED BELOW DETECTION LIMIT.
TABLE 2
SUMMARY OF INORGANIC SITE CONTAMINATION
FORMER LAGOON AREA
HOCOMONCO POND SITE, WESTBOROUGH, MA
CONCENTRATION RANGE
SOIL GROUND WATER
(MG/KG) (UG/L)
•*
**
**
**
*»
•*
•*
••PARAMETER
**
**
••ALUMINUM
••ANTIMONY
••ARSENIC
••BARIUM
••BERYLLIUM
••CADMIUM
••CHROMIUM
••COBALT
••COPPER
••IRON
••LEAD
••MANGANESE
••MERCURY
••NICKEL
••SELENIUM
••SILVER
••THALLIUM
••TIN
••VANADIUM
••ZINC
•*
••(I) ABOVE BACKGROUND LEVELS
••(2) ABOVE RECOMMENDED LIMIT
••ND - NOT DETECTED.
6160 - 14700(1)
ND
ND-20 (1)
9-55 (1)
ND-O.S(l)
ND
8-26
4-19(1)
5-23(1)
7440-16,000 (1)
3.2-5.2
57-228
ND-0.07 (1)
5-18(1)
ND
ND
ND
ND
ND-40(I)
13-41 (1)
ND-2190U)
ND-23 (1)
ND
ND-533(1)
ND
ND
ND-14
ND
ND
ND-667 (2)
ND-330)
ND- 31600(1)(2)
ND-l.O(l)
ND-60 (1)
ND
ND
ND
ND-39
ND
ND-39
** Indicates the context area (table) in which the search term was found.
D-13
-------
TABLE 3
SUMMARY OF ORGANIC SITE CONTAMINATION
KETTLE POND AREA
HOCOMONCO POND SITE, WESTBOROUGH, MA
Enter NEXT(next document), HIT(next context),TOP(entire document),
UP(to window up), DOWN(to window down), SELECT(this document)
/SELECT
Enter NEXT(next document), HIT(next context),TOP(entire document),
UP(to window up), DOWN(to window down), SELECT(this document)
/NEXT
Item 2
SITE NAME :KEEFE
ROD DATE :831115
ANALYSES OF LAGOON CONTENTS INDICATE THAT THE LAGOON IS STRATIFIED INTO
SEVERAL DISTINCT LAYERS WITH EACH LAYER EXHIBITING VARYING
CONCENTRATIONS OF SPECIFIC COMPOUNDS AND DISTINCT COLOR CHANGES FROM ONE
LAYER TO ANOTHER. SOME COMPOUNDS WERE FOUND TO HAVE INCREASING
CONCENTRATIONS WITH DEPTH. THESE INCLUDE METHYLENE CHLORIDE,
1,1-DICHLOROETHANE, TRICHLOROETHYLENE, TETRACHLOROETHYLENE,
••ETHYLBENZENE, AND XYLENES. THE LAGOON WAS ALSO FOUND TO HAVE
•'SIGNIFICANT AMOUNTS OF HEAVY METALS, INCLUDING ARSENIC, SILVER, COPPER
••ZINC, NICKEL, CHROMIUM AND MANGANESE. CYANIDE WAS ALSO PRESENT IN THE
LAGOON IN CONCENTRATIONS RANGING FROM LESS THAN 1 PPM AT THE SURFACE TO
APPROXIMATELY 10 PPM AT THE BOTTOM.
THE FAST TRACK FEASIBILITY STUDY WAS SUPERVISED BY THE NHWS & PCC
UNDER A COOPERATIVE AGREEMENT WITH THE EPA. ON JULY 29, 1983, EPA'S
BOSTON REGIONAL OFFICE RELEASED THE 'PRELIMINARY FAST TRACK FEASIBILITY
Enter NEXT(next document), HIT(next context),TOP(entire document),
UP(to window up), DOWN(to window down), SELECT(this document)
/HIT
••End of document reached**
Enter NEXT(next document), HIT(next context),TOP(entire document),
UP(to window up), DOWN(to window down), SELECT(this document)
/SELECT
Enter NEXT(next document), HIT(next context),TOP(entire document),
UP(to window up), DOWN(to window down), SELECT(this document)
/NEXT
D-14
-------
Item 3
SITE NAME :NYANZA CHEMICAL
ROD DATE :850904
PREPARED BY NUS CORP. AND A SUBSEQUENT NYANZA LETTER REPORT PREPARED BY
CAMP, DRESSER, AND MCKEE, INC. INDICATES THE EXISTENCE OF THIRTEEN (13)
AREAS WHICH HAVE BEEN CONTAMINATED EITHER FROM DIRECT WASTE DEPOSITION
OR FROM SEDIMENT TRANSPORT VIA SURFACE RUNOFF FROM THE DEPOSITION AREAS.
TABLE 1 CONTAINS A DESCRIPTION OF EACH AREA AND AN ESTIMATE OF THE
AMOUNT OF CONTAMINATED MATERIAL IN EACH. FIGURE 1-2 SHOWS THE LOCATION
•*OF EACH AREA. ALL OF THESE AREAS ARE CONTAMINATED TO VARYING DEGREES
••WITH HEAVY METALS INCLUDING MERCURY (HG), LEAD (PB), CHROMIUM (CR),
••CADMIUM (CD), AND ARSENIC (AS). TABLES 7-2 AND 7-4 FROM THE RI REPORT
SHOW, THE RANGES OF CONCENTRATIONS PRESENT IN THE SLUDGES, SOILS, AND
SEDIMENTS.
ADDITIONAL SUBSURFACE TESTING WAS CONDUCTED DURING THE PRE-DESIGN PHASE
IN THE HILL AREA AND IN THE WESTERN WETLAND, THE TWO AREAS WHERE
WASTEWATER TREATMENT SLUDGES WERE DIRECTLY DEPOSITED. THE INTENT OF
Enter NEXT(next document), HIT(next context),TOP(entire document),
UP(to window up), DOWN(to window down), SELECT(this document)
/HIT
D-15
-------
THE EXISTING DATA ON HEAVY METAL CONCENTRATIONS IN GROUNDWATER IS
LIMITED. NEVERTHELESS, THE EXISTING DATA SUGGESTS THAT HEAVY METALS IN
THE SLUDGES ARE LEACHING TO GROUNDWATER BUT TO A VERY LIMITED EXTENT.
THIS IS PROBABLY DUE TO THE FACT THAT PORTIONS OF THE HILL AND WETLAND
SLUDGE DEPOSITS ARE BELOW THE SEASONAL HIGH GROUNDWATER TABLE.
"MONITORING WELLS 2, 7 AND 10 IN THE HILL AREA SHOW CHROMIUM, CADMIUM,
••MERCURY AND ARSENIC LEVELS BELOW THE MAXIMUM CONTAMINANT LEVELS {MCLS)
••SET UNDER THE SAFE DRINKING WATER ACT, WHEREAS THE MCL FOR LEAD WAS
••EXCEEDED IN ONE WELL. AT MONITORING WELL 3 IN THE WESTERN WETLAND
DOWNGRADIENT FROM THE HILL, THE METALS WERE ALL BELOW THE MCLS.
MONITORING WELLS 8, 9 AND 11 ARE LOCATED IN THE LOWER INDUSTRIAL AREA ON
THE SOUTH SIDE OF THE CONRAIL TRACKS, AN AREA OF PAST DISCHARGE OF
••UNTREATED WASTEWATERS TO THE GROUNDWATER. MCLS FOR LEAD AND CHROMIUM
••WERE EXCEEDED IN THESE WELLS. WELLS 4, 5 AND 6 ARE LOCATED IMMEDIATELY
NORTH OF THE CONRAIL TRACKS AND ARE THE ONLY WELLS DOWNGRADIENT FROM ALL
••FORMER WASTE MANAGEMENT AREAS. MCLS FOR CHROMIUM, ARSENIC AND CADMIUM
••WERE EXCEEDED AT WELL 5 ALTHOUGH THIS MAY BE A LOCAL PHENOMENON IN THAT
••THE GROUNDWATER PH AT THIS LOCATION WAS 3.9 AND 4.2 DURING TWO SAMPLING
"RUNS; THIS WELL IS JUST NORTH OF A FORMER WASTE ACID SUMP. AT WELLS 6
AND 4. MCLS WERE NOT EXCEEDED, ALTHOUGH THE VALID DATA POINTS ARE
LIMITED.
IN SUMMARY, ALTHOUGH THE MOST PREVALENT AND CONCENTRATED GROUNDWATER
CONTAMINATION IS ORGANIC IN NATURE, THERE IS SOME INORGANIC (METALS)
CONTAMINATION ABOVE MCL LEVELS BEYOND THE SITE BOUNDARIES DOWNGRADIENT
Enter NEXT(next document), HIT(next context),TOP(entire document),
UP(to window up), DOWN(to window down), SELECT(this document)
/HIT
D-16
-------
ACTIONS THAT MAY BE NECESSARY TO ADDRESS WASTES THAT HAVE ALREADY
MIGRATED FROM THEIR ORIGINAL LOCATION (I.E. GROUNDWATER CONTAMINATION,
SUDBURY RIVER SEDIMENT CONTAMINATION).
THE PUBLIC HEALTH RISKS ASSOCIATED WITH THE HEAVY METAL SLUDGES STEM
FROM THE POTENTIAL FOR DIRECT CONTACT WITH OR INGESTION OF THE SLUDGES,
••SOILS, AND SEDIMENTS WHICH ARE EXPOSED. THESE WASTES CONTAIN HIGH
••CONCENTRATION OF MERCURY, LEAD, AND CHROMIUM AND MINOR AMOUNTS OF
••CADMIUM AND ARSENIC. FOR EXPOSURE VIA OTHER PATHWAYS, THE CURRENT RISKS
APPEAR INSIGNIFICANT BASED ON COMPARISON OF AMBIENT LEVELS AND RELEVANT
GUIDELINES. AMBIENT AIR CONCENTRATIONS OF MERCURY VAPORS IN THE HILL
AREA ARE ABOVE BACKGROUND LEVELS BUT WELL BELOW EXISTING GUIDELINES AT
DOWNWIND RECEPTOR SITES.
THUS CURRENT EXPOSURE VIA INHALATION IS NEGLIGIBLE (SEE TABLE 7-1). IT
Enter NEXT(next document), HIT(next context),TOP(entire document),
UP(to window up), DOWN(to window down), SELECT(this document)
/SELECT
Enter NEXT(next document), HIT(next context),TOP(entire document),
UP(to window up), DOWN(to window down), SELECT(this document)
/NEXT
D-17
-------
Item 4
SITE NAME
ROD DATE
:TINKHAM GARAGE
:860930
D. SAME AS ABOVE22.000 6,110 6,580 7,050 36,900 10,550
E. SAME AS ABOVE23,100 6,360 6,810 7,280 38,730 11,050
SAME AS ABOVE30.800 7,970 8,340 8,820 51,490 14,590.
F.
**
**
**
**
**
**
**
**
*•
**
**
«*
**
**
**
*•
**
**
• »
*»
**
**
**
**
•*
**
TABLE 18
POLLUTANT LIMITATIONS FOR DISCHARGE TO THE
TOWN OF DERRY, NEW HAMPSHIRE - WWTP
CADMIUM
TOTAL CHROMIUM
COPPER
LEAD
NICKEL
SILVER
TOTAL CYANIDE
ZINC
ARSENIC
IRON
SODIUM
CHLORIDES
MERCURY
MANGANESE
SULFATE
SULFIDE
SULFITE
BERYLLIUM
BORON
SELENIUM
PHENOLS
TOTAL TOXIC ORGANICS
0.091
0.228
3.38
0.27
0.12
0.072
0.324
2.61
0.003
10.0
500.0
500.0
0.048
10.0
20.0
20.0
2.0
0.008
2.0
0.054
0.324
5.0
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L
MG/L.
TABLE 19
PRESENT WORTH ANALYSIS FOR MANAGEMENT OF MIGRATION ALTERNATIVES
($ X 1000)
Enter NEXT(next document), HIT(next context),TOP(entire document),
UP(to window up), DOWN(to window down), SELECT(this document)
/HIT
D-18
-------
••End of document reached**
Enter NEXT(next document), HIT(next context),TOP(entire document),
UP(to window up), DOWN(to window down), SELECT(this document)
/NEXT
SELECTION MENU
AT THIS POINT, YOU MAY:
MANIPULATE CURRENT SEARCH SET PERFORM OTHER FUNCTIONS
DI - DISPLAY RESULTS
SO - SORT RESULTS
PR - PRINT RESULTS
SE - CONTINUE SEARCHING
CO - COMBINE SEARCHES
LI - LIST SEARCH SETS
M - RETURN TO MAIN MENU
H - FOR HELP EXPLANATIONS
X - EXIT RODS
SELECTION: LI
LIST
YOU HAVE CREATED THE FOLLOWING SEARCH SETS:
6/ LIST
SETNO: NO. ITEMS: REQUEST:
SET 1: 21 REG-1
SET 2: 104 TEXT-CHROMIUM
SET 3: 4 1 AND 2
SET 4: 4 1 AND 2 SORT=NAME
SET 5: 3 SELECT
DO YOU WANT TO DELETE YOUR SEARCH SETS? N
D-19
-------
SELECTION MENU
AT THIS POINT, YOU MAY:
MANIPULATE CURRENT SEARCH SET PERFORM OTHER FUNCTIONS
DI - DISPLAY RESULTS
SO - SORT RESULTS
PR - PRINT RESULTS
SE - CONTINUE SEARCHING
CO - COMBINE SEARCHES
LI - LIST SEARCH SETS
M - RETURN TO MAIN MENU
H - FOR HELP EXPLANATIONS
X - EXIT RODS
SELECTION: PR
r
PRINT
YOU MAY PRINT:
1 - IDENTIFICATION FIELDS
2 - IDENTIFICATION AND ENVIRONMENTAL FIELDS
3 - IDENTIFICATION FIELDS AND THE ABSTRACT
4 - IDENTIFICATION FIELDS AND THE SELECTED REMEDY
5 - IDENTIFICATION FIELDS, THE ABSTRACT, AND
THE SELECTED REMEDY
S - RETURN TO THE SELECTION MENU
X - EXIT THE ROD SYSTEM
SELECTION: 1
D-20
-------
SELECTION MENU
AT THIS POINT, YOU MAY:
MANIPULATE CURRENT SEARCH SET PERFORM OTHER FUNCTIONS
DI - DISPLAY RESULTS
SO - SORT RESULTS
PR - PRINT RESULTS
SE - CONTINUE SEARCHING
CO - COMBINE SEARCHES
LI - LIST SEARCH SETS
M - RETURN TO MAIN MENU
H - FOR HELP EXPLANATIONS
X - EXIT RODS
SELECTION: X
THANK YOU FOR USING THE RODS DATA BASE.
TO DISCONNECT FROM THE IBM MAINFRAME,
ENTER 'LOGOFF WHEN YOU RECEIVE THE
'READY' PROMPT.
READY
LOGOFF
EHJ :BASO LOGGED OFF 02/09/88 ATI 1:10:06
00:29:39 CONNECT TIME, 0:08.46 TCB, 0:00.34 SRB
EXCPS: 1491 DA,0 MT,1473 TERM,672 OTHER,3636 TOTAL
CHARGES: $4.44 CONNECT, $2.19 CPU, $1.63 EXCPS
$8.28 TOTAL CHARGE FOR SESSION
EHJ LOGGED OFF TSO AT 11:10:21 ON FEBRUARY 9, 1988
D-21
U . S . GOVERNMENT PRINTING 0FF ICE I 1 989-648-t63/00302
------- |