United States Pollution Prevention EPA 749-C-95-0041
Environmental Protection and Toxics (7407) June 1995
Agency
&EPA Toxics Release
Inventory
1987-1993 CD-ROM
User's Manual
U.S. Environmental Protection Agency
Region 5, Library (PL-12J)
77 West Jackson Boulevard, 12th Floor
Chicago, IL 60604-3590
For sale by the U.S. Government Printing Office
Superintendent of Documents, Mail Stop. SSOP, Washington, DC 20402-9328
ISBN 0-16-048134-4
-------
Table of Contents
1.0 Introduction
1.1 Organization of This Manual 1-1
1.2 User Manual Conventions 1-1
1.3 An Overview of the Toxic Release Inventory 1-2
1.3.1 Background 1-2
1.3.2 The Emergency Planning and Community Right-To-Know Act 1-2
1.3.3 TRI Reporting Requirements 1-3
N, 1.3.4 Scope of the TRI 1-3
, 1.4 Media Formats for TRI 1-11
^i 1.4.1 TRI Data On CD-ROM 1-12
1.4.2 TRI Data On Floppy Diskette 1-13
^' 1.4.3 TRI Data Through On-line Databases 1-13
(•< 1.4.4 TRI Data On Internet 1-14
1.4.5 TRI Data On Magnetic Tape 1-.14
1.4.6 Printed Reports About TRI 1-.15
1.4.7 TRI Data on Microfiche 1-15
1.4.8 TRI Data On Electronic Bulletin Boards 1-.15
1.5 TRI User Support Irl6
1.6 Other Available Reference Materials 1-.16
2.0 Accessing TRI On CD-ROM
2.1 Installation of TRI 2-1
2.1.1 Configuration Requirements 2-1
2.1.2 Setting Up Your TRI System 2-1
2.1.2.1 Installing CD-ROM Extensions 2-2
2.1.3 Installing TRI Search Software 2-4
2.1.4 Troubleshooting Software Installation 2-11
2.1.5 If You Need More Memory 2-13
2.2 TRI CD-ROM Structure 2-15
2.2.1 Chemical Substance Fact Sheets 2-15
2.2.2 Toxic Release Inventory 2-15
2.2.3 Calculation Feature (KASTAT) 2-16
2.3 Readme Files 2-16
2.4 Accessing the Toxics Release Inventory 2-17
2.5 Special Keys 2-18
2.6 Printing Files 2-18
-------
3.0 TRI Chemical Substance Fact Sheets
3.1 Overview of Conducting A Search 3-2
3.2 Function Key Options 3-2
3.2.1 Fl = HELP Key 3-3
3.2.2 F2 = OPTIONS Key 3-4
3.2.3 F3 = SELECT Key 3-5
3.2.4 F4 = SEARCH Key 3-13
3.2.5 F5 = SETS Key 3-14
3.2.6 F6=DISPLAY Key 3-18
3.2.7 F7=GROUP I, F8=GROUP t, F9=GROUPV Keys 3-19
3.2.8 F10=EXIT Key 3-19
3.2.9 ESC=BACKUP Key 3-20
3.3 Conducting A Search For Fact Sheets; 3-20
3.4 Displaying Fact Sheets , 3-21
3.5 Action Menu 3-22
3.6 Printing or Saving Fact Sheets 3-23
3.7 Save Set List 3-23
3.8 Load Set List 3-24
4.0 Toxics Release Inventory Data Base
4.1 Choosing A Data File 4-1
4.2 Overview of Conducting A Search 4-6
4.3 Using Function Keys for Searching TRI 4-7
4.4 Searching For TRI Data 4-10
4.4.1 Indexing Of Data 4-13
4.5 Refining the Search 4-17
4.6 Displaying Search Results 4-21
4.6.1 Reviewing Displayed Data 4-22
4.6.2 Sorting of Data 4-23
4.6.3 Action Menu 4-25
4.7 Printing Results 4-26
4.8 Downloading from TRI 4-27
4.8.1 Exporting Sets 4-28
4.8.2 Form Designer 4-30
5.0 Performing Calculations (KASTAT)
5.1 Calculating Data 5-1
5.2 Defining Fields In a KASTAT Record 5-4
5.3 Special Keys 5-5
-------
APPENDIX A - TRI Reporting Form (EPA Form R) A-l
APPENDIX B - TRI Data Element Descriptions B-l
APPENDIX C - TRI Quick Search Guide C-l
APPENDIX D - Sources for Further Assistance D-l
INDEX M
-------
1.0 Introduction
This chapter will explain the use of this Manual and its format. It contains a brief overview
of the Toxics Release Inventory (TRI) System and a description of each of the media formats
in which TRI is published. A list of other reference materials also is provided at the end of
the chapter.
1.1 Organization of This Manual
This Manual is intended as both a learning and a reference tool for TRI CD-ROM users. It
explains the operation of the TRI CD-ROM software and includes corresponding screen
illustrations and examples. The Manual is not intended to provide detailed technical
guidance about the TRI program or interpretation of data submitted by individual reporting
facilities. The remaining chapters consist of:
Chapter 2 - Accessing TRI On CD-ROM
Chapter 3 - Chemical Substance Fact Sheets
Chapter 4 - Toxics Release Inventory Database
Chapter 5 - Performing Calculations With KASTAT
Additionally, there are four appendices containing information to assist you in using the TRI
CD-ROM. For example, Appendix C, TRI Quick Search Guide, provides abbreviated
instructions that allow the user to effectively search TRI and use other features of the disc
right away.
1.2 User Manual Conventions
To assist you in the use of this Manual, some conventions used throughout this Manual are
listed below:
• Keys to be pressed are shown with capital letters, bold type, and within angle
brackets. For example, the enter key is represented as < ENTER >.
• Names of screens and menus are shown in capital letters and bold type. For
example, DATA BASE SELECTION MENU.
• < ENTER > refers to the enter key or the return key.
CD - ROM User's Manual Page 1 - 1
-------
1.3 An Overview of the Toxics Release Inventory
1.3.1 Background
In 1984, a deadly cloud of methyl iscyanate killed thousands of people in Bhopal, India.
Shortly thereafter, there was a serious chemical release at a sister plant in West Virginia.
These incidents underscored demands by industrial workers and communities in several states
for information on hazardous materials. Public interest and environmental organizations
around the country accelerated demands for information on toxic chemicals being released
"beyond the fence line" outside of the facility.
1.3.2 The Emergency Planning and Community Right-To-
Know Act
Against this background, the Emergency Planning and Community Right-to-Know Act
(EPCRA) of 1986 was enacted. Hailed as one of the most potent pieces of environmental
legislation in 20 years, EPCRA's primary purpose is to inform communities and citizens of
chemical hazards in their areas. The Act provides for the collection and public release of
information about the presence and release of hazardous or toxic chemicals in our nation's
communities. The law requires industries to participate in emergency planning and to notify
their communities of the existence of, and routine and accidental releases of, hazardous
chemicals. The goal is to help citizens, officials, and community leaders to be better
informed about toxic and hazardous materials in their communities. Sections 311 and 312 of
EPCRA require businesses to report the locations and quantities of chemicals stored on-site
to state and local governments. This helps communities prepare to respond to chemical spills
and similar emergencies. The goal is to reduce risk for communities as a whole.
Through EPCRA, Congress mandated that a Toxics Release Inventory (TRI) be made public.
TRI provides citizens with accurate information about potentially hazardous chemicals and
their use so that communities can hold companies accountable and make informed decisions
about how toxic chemicals are to be managed.
Section 313 of EPCRA specifically required manufacturers to report releases of over 300
chemicals that had been designated as toxic to the environment. (From its inception in 1987
through 1993, the years contained on this CD-ROM, the number of chemicals covered by
remained fairly constant. Beginning in 1995, however, companies will have to report
releases for about 600 chemicals.) The reports are submitted to the U.S. Environmental
Protection Agency (EPA) and state governments. EPA compiles this data into an on-line,
publicly accessible, national inventory. Many states also make TRI available. This vast
source of data is widely recognized as a powerful force for environmental improvement.
Page 1-2 CD - ROM User's Manual
-------
Facilities are required to report on releases of toxic chemicals into the air, water, and land.
Additionally, they must report off-site transfers of wastes to a separate facility for treatment
or disposal. Facilities are also required to report on pollution prevention activities and
chemical recycling. Reports must be submitted on or before July 1 each year and must cover
activities that occurred at the facility during the previous year.
1.3.3 TRI Reporting Requirements
A facility is required to report if it..
Has ten or more full-time employees; and
Manufactures or processes over 25,000 pounds of toxic chemicals or chemical
category specified by law or added through rulemaking, or uses more than
10,000 pounds of any designated chemical or category; and
Conducts selected manufacturing operations in the industry groups specified in
the U.S. Government Standard Industrial Classification (SIC) Codes 20
through 39.
Under the present reporting requirements, about 80,000 reports - representing billions of
pounds of chemical releases - are submitted to EPA each year by more than 20,000
manufacturing facilities.
By Executive Order, Federally-operated facilities (e.g., military installations), heretofore
exempt from TRI reporting, will be subject to TRI reporting beginning with reports due July
1, 1995. The following year, a new reporting threshold designed to reduce the burden on
small businesses will go into effect. Businesses whose total releases and wastes for a TRI
chemical are less than 500 pounds per year will be permitted to submit a simplified version
of Form R. The latter change will coincide with an increase in the number of TRI chemicals
from about 300 to nearly 600 chemicals. EPA is presently considering expanding the types
of facilities subject to TRI reporting.
1.3.4 Scope of the TRI
TRI is unique in that it marks the first time that the public has direct access to detailed
information about releases of toxic chemicals in their communities. TRI offers an opportunity
for citizens to increase their knowledge of chemical usage in their area and to use this
knowledge to affect community environmental policy and change.
CD - ROM User's Manual Page 1 - 3
-------
The TRI database includes information on:
What chemicals were released into the local environment during the preceding year;
How much of each chemical went into the air, water, and land in a particular year;
How much of the chemicals were transported away from the reporting facility for
disposal, treatment, recycling, or energy recovery;
How chemical wastes were treated at the reporting facility;
The efficiency of waste treatment; and
Pollution prevention and chemical recycling activities.
TRI provides the first comprehensive overview of toxic chemical pollution from
manufacturing facilities in the United States. It is a public "report card" for the industrial
community, creating a powerful motivation for waste reduction. This annual accounting of
the nation's management of industrial toxic chemical wastes is a valuable source of
information for concerned individuals and communities. Citizens can use TRI to evaluate
local facilities through comparisons, determine how toxic chemicals are used, and, with other
information, evaluate potential health risks for their community. Organizations can use TRI
information as a starting point for constructive dialogue with manufacturing businesses in the
area.
Although TRI offers valuable insight into chemical pollution in the U.S., it is important to
recognize that it also has limitations. For example, TRI covers toxic chemicals released by
manufacturing operations only. Options for expanding TRI to include non-industrial sources
are being studied for future implementation. Reported releases are annual estimates based on
accepted estimation techniques, not necessarily exact measurements. The amounts reported
could have been released evenly over the course of the year or, possibly, in a single large
burst. Another important point to consider when using TRI data to consider health affects is
that it cannot be used alone; additional information is necessary to ascertain levels of risk or
exposure (see 1.3.7). Nevertheless, TRI provides communities with a springboard from
which citizens can seek further vital information about toxic chemicals in their area.
1.3.5 Pollution Prevention and TRI
Following implementation of the Pollution Prevention Act (PPA) of 1990, TRI reporting
became even more comprehensive. Historically, government agencies and waste generators
have tried to resolve environmental problems using "end-of-pipe" waste management
practices; that is, treating or disposing of waste after it has been created. Pollution
prevention strategies focus instead on avoiding creation of wastes by redesigning products,
changing processes, substituting other raw materials for more toxic substances, and other
techniques.
Page 1-4 CD - ROM User's Manual
-------
With passage of the PPA, Congress adopted as national policy an environmental hierarchy
that establishes pollution prevention as the first choice among waste management practices.
For waste that cannot be avoided at the source, recycling is considered the next best option.
A waste generator should turn to treatment or disposal only after source reduction and
recycling have been considered.
Reporting requirements for TRI changed in 1991 as a result of the PPA. Prior to 1991,
facilities were required to report toxic substances released into the environment and
transferred off-site for treatment or disposal. Beginning in 1991, facilities were also required
to indicate amounts of chemicals that are recycled, used for energy recovery, and treated on-
site. (Energy recovery means burning the chemical so that resulting heat energy contributes
to subsequent manufacturing operations.) These amounts must be reported for the past year
and the current year, as well as projected amounts for the next two years. Furthermore,
facilities must indicate source reduction activities that have been implemented.
These changes to TRI highlight the importance of pollution prevention and encourage
reporting facilities to develop and implement strategies for reducing waste. This information
will also help the public gauge industry's commitment to improving the nation's
environment. By working together, businesses and neighboring communities can build on
emerging pollution prevention practices for everyone's benefit.
1.3.6 Using the TRI
The Toxics Release Inventory is a rich source of data for a broad-based audience that
includes manufacturers, environmental consulting firms, trade associations, labor groups,
health professionals, state and local environmental agencies, Local Emergency Planning
Committees (LEPCs), and federal agencies. An important and growing user group is
concerned citizens who, on their own or through organized groups, use TRI to raise and
answer questions about chemical releases in their communities.
Whether the TRI is used to influence local government action, emergency planning, the
education of citizens, or to spur industry-citizen cooperation, it is clear that it plays an
important role in understanding trends in environmental releases and chemical waste
management.
The following examples illustrate the way TRI is used by various groups:
Citizens The Emergency Planning and Community Right-to-Know Act (EPCRA) was
written with individual citizens in mind, on the principle that the more citizens know,
the more effective they can be at improving health and safety by avoiding chemical
hazards in their communities. TRI enables citizens to become more aware of toxic
chemicals in their own neighborhoods. It encourages dialogue between individuals
and local companies which can result in a change in current practices, and improve
the local environment. Citizens often use the TRI data in combination with other
information sources to explore health-related risks in their communities.
CD - ROM User's Manual Page 1 - 5
-------
Businesses Manufacturers can use Ihe TRI data as a basis for reducing large stocks
of toxic chemicals located in dense population areas or to lower levels of chemical
releases. TRI data is also used to cut costs and improve operations. "Wastes"
represent an expense - chemical wastes leftover after manufacturing must be managed,
which may include treatment or disposal or removal from the facility. Companies are
using TRI to increase awareness of environmental business opportunities and, as a
result, reduce the use of toxic chemicals. TRI is also used to market a chemical or
process that is cleaner, safer, or more cost-effective for the reporting facilities. Law
firms, real estate companies, and banks use TRI to identify potential liability issues
associated with a particular parcel of land. Most importantly, the publicity that has
resulted from the availability of TRI data has caused many companies to voluntarily
pledge toxic chemical release reductions. A portfolio management group illustrates
another way TRI data is used by the private sector: the Clean Yield Group uses TRI
and other data sources to track companies' environmental performance for potential
investors.
Educators Academic researchers rely on TRI data to conduct important studies of
the environment. Several universities use TRI reports to study how chemicals are
used and to develop alternative technologies for the prevention of toxic releases.
Increasingly, TRI is being coupled v/ith other data, such as economic indicators, to
study social policy and economic development. In the classroom, TRI is a resource
for students who examine local sources of chemical pollution and prepare toxic waste
audits on communities or facilities. Currently, the TRI data base is being used as a
basis for the development of a series of cross-curriculum student activities in the
classroom.
Public Interest Groups Public interest groups make effective use of the TRI data to
educate citizens, prepare revealing company profiles and influence change. Most
often, they use TRI to bring public pressure to bear on facilities and public officials.
One illustration of successful use of TRI by a public interest group is the Hudson
River Sloop Clearwater, Inc., which uses TRI data to track chemical releases in the
Hudson River drainage basin. They have produced three reports and seek to actively
educate their membership and the public. The New York Public Interest Research
Group released TRI data to coincide with local public hearings on toxics use
reduction, and helped pass a bill expanding state TRI coverage to power plants and
transportation facilities. The Georgia Environmental Policy Institute is sponsoring
preparation of a citizen's guide for using TRI, Census and other information to help
define areas with potential environmental justice concerns. These are but a couple
examples of many, many instances where TRI has made a difference in citizens'
ability to monitor and influence the quality of their local environment.
Page 1-6 CD - ROM User's Manual
-------
Labor Concern for worker safety was a key factor in the original passage of the
national legislation. Providing workers the right-to-know about chemical hazards in
the workplace has been a consistent goal of organized labor since the early 1970s.
For example, one large textile workers union teamed up with a Minnesota community
and used the TRI data to pressure their company to reduce the use of methylene
chloride, a known health hazard to the workers, and search for safer alternatives.
Union members and activists pressured the state for tougher regulations that would
force the company to cut emissions by 93 percent. Publication of toxics release data
often makes it easier for labor organizations to lobby successfully for safer practices
to protect workers' health.
State Emergency Response Commissions (SERCs) EPCRA requires each state to
set up a SERC to designate local emergency planning districts within the state, and
coordinate activities and review plans of the local committees. The SERCs serve as a
liaison between the state and EPA and provide the forum for coordinating all Title III
information (although another state agency may be designated to collect TRI data).
Each SERC works to ensure that its state programs are integrated with the federal law
to strengthen enforcement. It provides leadership, coordination, technical assistance,
and training - working closely with the LEPCs - to help individuals and organizations
meet their responsibilities under the Act.
Local Emergency Planning Committees (LEPCs) EPCRA required each SERC to
establish LEPCs to develop and periodically review emergency plans to prepare for
and respond to chemical emergencies. By law, LEPCs include representatives from
state and local government, civil defense, fire fighting, health, environmental and
transportation agencies, the media, community groups and businesses subject to
EPCRA reporting. LEPCs use TRI data, as well as information about chemicals
stored on-site by local facilities, for their own planning purposes. They also make
this information available to the public upon request.
State and Local Agencies TRI data is useful to hospitals, schools, and state and
local governments for emergency planning and response at the state and local level.
Many emergency management agencies, fire departments, and emergency medical
services use TRI to identify chemicals in use and map facility locations for more
effective, quicker response to emergencies. The TRI data is also used to identify the
need for and pass state and local legislation. For example, Louisiana used the TRI
data as the basis for passing a new Air Toxics law requiring a 50 percent reduction of
emissions by 1996. TRI is also used in combination with other data to determine
whether companies are complying with environmental legislation already in effect.
For example, TRI data on off-site transfers can be used to identify chemicals or
wastes being transported from a facility and to verify that the receiving landfill has
the proper permits for the incoming amount and types of waste.
CD - ROM User's Manual Page 1 - 7
-------
U.S. Environmental Protection Agency (EPA) TRI is used by EPA as a baseline
for measuring improvements in companies across the nation. Company performance
records are tracked over time to monitor voluntary pollution prevention efforts, and to
oversee emission reductions called for under the Clean Air Act Amendments of 1990.
TRI is used throughout the EPA to measure company compliance with other laws and
to target areas where enforcement of other regulations is needed, to gauge the need
for additional regulatory efforts to clean up water, air, and solid waste problems, and
to develop strategies for assessing pollution prevention programs.
Federal Agencies TRI data is used extensively at the federal level for a variety of
programs. Congress relies on TRI figures to develop environmental legislation.
Through TRI data, federal lawmakers discovered that the nation's original Clean Air
Act toxics control program was not adequate - of the top 25 toxic chemicals reported
to TRI as released to the air, only two were regulated by the Clean Air Act. In 1990,
amendments to the Clean Air Act required additional reporting for designated
"hazardous air pollutants" and made manufacturers develop risk management plans,
shifting the initial emergency planning burden from the mostly-volunteer LEPC to
industry. The Agency for Toxic Substances and Disease Registry, a federal public
health agency whose job it is to prevent or minimize adverse health effects from
exposure to hazardous substances, uses TRI data to set goals for improving the
nation's health. The Internal Revenue Service has used TRI data to measure
compliance of reporting companies with tax laws pertaining to the use of toxic
substances.
Health Officials TRI data can be used to build an information base on hazardous
chemicals used, manufactured, or transported in a state or community. Health
professionals can use this information to better prepare personnel for emergencies.
TRI can help diagnose, treat or study health effects resulting from chemical exposure
in the community or workplace. (See 1.3.7)
Media TRI is important to the education of the community about facilities and
potential hazards in the local area. Many large newspapers, such as USA Today, the
New York Times, and the Wall Street Journal have run stories on the effectiveness of
the right-to-know statute, as have scores of local newspapers, trade and labor union
publications, and periodicals.
Page 1-8 CD - ROM User's Manual
-------
International TRI enhances the ability of the global community to work as one in
monitoring the earth's environment. Several nations use the data to assist in their
efforts to become more environmentally conscious. Environment Canada uses the
TRI data to determine which industries and chemicals need greater regulation in their
country; it developed a National Pollutant Inventory modeled on TRI. In recent
years, when many eastern European countries turned their attention to the
environment, several nations began considering implementation of programs similar to
TRI. One country used TRI data to evaluate companies interested in opening
facilities there. Other users of TRI around the world include Great Britain,
continental Europe, India, and Japan. International organizations, particularly other
governments, are one of the fastest growing segments of the TRI user community.
1.3.7 TRI & Health
Viewing TRI data for the first time often triggers concern about the health risk posed by the
release of chemicals that are listed in the data base. You may ask, or others may ask you,
how toxic a particular chemical is, or whether the volume of releases shown in TRI will
adversely affect their health or the environment. These are not easy questions to answer, and
cannot be answered by TRI alone. Risk is the measure of the chance that you will
experience health problems or that the environment will be degraded. Many factors must be
considered in order to evaluate what risks, if any, you face from the presence of toxic
chemicals in your local environment. Risk screening uses available information, such as
TRI, to develop a relative estimate of risk for a given set of conditions. Risks are ranked as
high, medium, or low in order to set priorities for further evaluation.
The TRI data is a first link to discovering which chemicals being manufactured, released, or
transferred in your community pose a threat to human health and the environment. The TRI
will tell you the names and estimated amounts of chemicals released in your area during the
preceding year. You can also find out about chemicals that were transferred into or away
from your area for treatment and disposal.
This information alone does not indicate the risks that these chemicals pose or may pose to
human health and the environment. Small releases of highly toxic chemicals may be a
greater risk than very large releases of less toxic chemicals. Though the TRI data is useful to
evaluate the risk in your community, other information is required to form a complete
picture. A determination of risk depends on the release conditions, extent of exposure,
environmental conditions, and other factors.
CD - ROM User's Manual Page 1 - 9
-------
The presence of a chemical on TRI does not necessarily represent a health risk. Other
factors, such as the level and type of exposure and toxicity, also must be considered. For
example, some high-volume releases of relatively non-toxic chemicals may appear to be a
more serious problem than low-volume releases of highly toxic chemicals. However, just the
opposite may be true. Volume does not always indicate danger or a need for serious
concern. Reports of TRI data contain releases of chemicals, not the level of exposure to
these chemicals. It is important to review all the variables involved in the reporting of TRI
data. Other information, in addition to TRI data, must be considered to determine the impact
of a chemical release on your health.
1.3.8 If You Want More Information
Once you become aware of toxic chemical re leases in your community, you may want
additional information or assistance. Here are several suggestions for following up in your
community:
Learn the facts. In addition to chemical release information, TRI contains the names and
telephone numbers of public contacts at reporting facilities. Companies are becoming more
sensitive to citizens' concerns about health and the environment, and some have begun
community outreach programs. Company officials may provide answers to your questions
that could affect risk screening. They can also steer you towards local agencies, for
example, the Local Emergency Planning Committee (LEPC).
Go to the local library. Ask your librarian to help you find information about chemicals in
your community. There are many reference works that examine chemical toxicity and other
factors to help you decide whether further investigation is warranted.
Identify local safety and public health agencies. These groups can help you evaluate what
you have learned and identify any additional information you may need. Most counties have
a public health agency staffed by one or more doctors, including a county health officer.
Some areas have poison control centers with toxicologists and other staff who may be of
some assistance. If you have difficulty identifying appropriate agencies in your area, call the
local hospital or fire department for a referral.
Locate the Local Emergency Planning Committee (LEPC). The EPCRA legislation that
created TRI also established LEPCs to plan for emergency action in the event of hazardous
chemical spills and similar incidents. LEPCsi are aware of hazardous chemicals used and
stored by facilities in your area. They receive Material Safety Data Sheets that detail
physical properties and health effects of hazardous chemicals used by local manufacturers and
other facilities. LEPCs, while often associated with existing county-level emergency
planning or civil defense agencies, include representatives of environmental and
transportation agencies, fire fighters, hospitals, the media, community groups, and others.
Page 1-10 CD - ROM User's Manual
-------
Call the Agency for Toxic Substances and Disease Registry (ATSDR1. The ATSDR is the
leading federal public health agency concerned with risks resulting from chemical exposure.
Located in Atlanta, GA, it was created by the Superfund legislation in 1980. ATSDR makes
information on the health effects of hazardous substances available to the public, conducts
health assessments, and sponsors research. The ATSDR publication series titled
Toxicological Profiles characterizes toxicological properties and health effects information for
specific chemicals so they can be understood by a lay person. These publications, widely
distributed to libraries across the country, are invaluable if you are interested in a specific
chemical. ATSDR maintains contacts with state and local health agencies throughout the U.S.
(For more information, call ATSDR at (404) 639-6300 or fax your request for a specific
Toxicological Profile to (404) 639-6315.)
Contact the regional EPA office serving your area for more information about TRI facilities
near you. Each of the ten regional offices has a designated TRI coordinator who can answer
your questions about the TRI program and reporting facilities in your area. (See the list of
provided on the disc in a file called \readme\regions.epa.) You may also call TRI User
Support to learn more about obtaining or using TRI information products. Finally, the
EPCRA Hotline (800-535-0202) can provide detailed information about TRI reporting
requirements.
Contact your local college or university. Leading experts can often be found in the academic
community, and professors and staff are often willing to share their knowledge with local
residents. Be prepared to make a few phone calls. Several attempts may be necessary to
find the right department or person.
Network with neighbors and community groups. This is a good way to exchange
information, participate in meetings with officials, experts, and company representatives and
plan activities that address your concerns. The more people are involved, the more attention
you are likely to receive from industry officials, government agencies, and the news media.
1.4 Media Formats for TRI
TRI is available in several media formats. The two government agencies listed below make
selected formats available to the public. Availability of specific products and prices vary
from one agency to another. Call these agencies directly for up-to-date ordering information.
U.S. Government Printing Office (GPO)
710 North Capitol Street, N.W.
Washington, D.C. 20401
202-512-1800 (general sales)
202-512-1530 (computer products)
CD - ROM User's Manual Page 1-11
-------
National Technical Information Services (NTIS)
U.S. Department of Commerce
5285 Port Royal Road
Springfield, VA 22161
1-800-553-NTIS (rush orders only)
703-487-4650 (sales)
703-487-4763 (computer products)
1.4.1 TRI Data On CD-ROM
As indicated by this User Manual, TRI data, is available on CD-ROM. The CD-ROM edition
is comprised of two discs, distributed as a s,et. Together, the two discs contain the complete
TRI for the years 1987-1993. Disc One contains TRI data submitted for 1987-1990. Data
for 1991-1993 is provided on Disc Two. (Data on each disc is divided into two files,
Releases and Treatmnt. See Section 2.2 for a more detailed description of the data base
structure.) Each disc also contains a complete set of Chemical Substance Fact Sheets, which
provide reference materials on the health and ecological effects of the TRI substances. Some
of the software capabilities include searching TRI data, downloading data, creating custom
reports, and performing calculations on chemical release amounts. Data can be retrieved by
chemical name, facility name, location, industry code and numerous other categories.
Some of the basic features of the CD-ROM are:
help screens
system messages and prompts
combining searches using Boolean o]>erators
numeric ranging
displaying records on screen, or sending them to a printer or to disk
exporting records to disk in several formats
user selection of fields for printing, displaying and exporting
sorting and ranking fields
optional features to limit DOS exit
statistical analyzer (KASTAT)
form designer for creating custom reports
brief user guide
Page 1-12 CD - ROM User's Manual
-------
1.4.2 TRI Data On Floppy Diskette
TRI can be accessed on the personal computer (PC) through the use of several different
software packages. Floppy diskettes are compatible with the IBM PC microcomputer and
may be available in a choice of sizes, depending on the source. The user can buy diskettes
for a single state, a set of several different states, or all states in dBASE III Plus format or in
Lotus 1-2-3 format. Floppy diskettes contain the most frequently used TRI data, including
the TRI facility identification number, name of the reporting facility, the facility's county,
city, state, zip code, Standard Industrial Classification code, parent company name, chemical
name and Chemical Abstracts Service Registry Number, aggregated chemical releases to the
air, land, underground injection wells, and water, as well as total chemical transfers to off-
site locations and publicly owned treatment works. In addition, the diskettes include the
public contact name and phone number, longitude and latitude, state/county FIPS (Federal
Information Processing Standards) code, and various EPA-assigned waste permitting
identification numbers. Diskettes containing data for 1991 and later also contain selected
pollution prevention data that were added to TRI as a result of the Pollution Prevention Act
of 1990. Diskettes are also available in the Macintosh worksheet format (.MAC) for 1989.
Documentation for all versions is provided.
1.4.3 TRI Data Through On-line Databases
TRI is a component file of the Toxicology Data Network (TOXNET) operated by the
National Library of Medicine (NLM) of the National Institutes of Health. TOXNET offers
state-of-the-art, user-friendly searching, utilizing a free text search capability, full Boolean
logic, a powerful and flexible command language and a variety of on-line user assistance
features. On-line and off-line printing of entire or specific portions of records is available,
as are a variety of customized print options. Special TRI features allow sorting and
numerical manipulation of data. A menu-driven search package also allows novice users or
individuals with limited computer skills to search TRI efficiently. TOXNET is available
seven days a week, 24 hours a day, and a fee is charged per each hour of access. A modem
is required for access. If you are interested in accessing TRI through NLM, contact:
TRI Representative
National Library of Medicine
Specialized Information Services
8600 Rockville Pike
Bethesda, MD 20894
(301) 496-6531
CD - ROM User's Manual Page 1-13
-------
1.4.4 TRI Data on Internet
TRI data is now available through the Internet in several ways. EPA has recently established
an agency-wide Gopher server and a World Wide Web (WWW) server allowing access to a
broad range of environmental information. (A Gopher server is a menu-driven, user-friendly
system allowing access to an organized collection of files over the Internet, as well as access
to other Internet systems and services through the use of links. A World Wide Web is a
more sophisticated version of a Gopher server that allows both viewing of graphics and
'point and click' access to different menu levels.)
The address for the EPA gopher is: gopher.epa.gov, while the address for the WWW server
is: http://www.epa.gov. To browse TRI data from the menu, select the following menu
choices:
EPA Offices and Regions/
Office of Prevention, Pesticides, and Toxic Substances/
Toxic Substances/
1993 Toxic Release Inventory/
You can also use the keyword search capability on the Gopher main menu to access the last
menu option directly. The metadata Record and Index provide descriptive information about
the contents of the TRI data files.
The National Library of Medicine's TOXNET data base, including all data for TRI reporting
years from 1987-1993, is also available on the Internet. An NLM user account is required to
access the data base. The Internet address for NLM is: toxnet.nldm.nih.gov, which users
can access using the telenet function in Internet.
1.4.5 TRI Data On Magnetic Tape
The TRI is available for each annual inventory on 9 track tape, 1600 or 6250 density, ASCII
or EBCDIC format, with accompanying documentation. Tapes include printing instructions
or codes and text. Complete TRI data is available on tape. A subset of the data called
"Reporting Facilities Names and Addresses" is also available on tape.
Page 1-14 CD - ROM User's Manual
-------
1.4.6 Printed Reports About TRI
Every year, EPA publishes one or more printed reports highlighting the most recent TRI data
available to the public. The first three reports (also called "national reports") contain
analyses describing trends in geographic distribution, industrial patterns of releases and
transfers, pollution prevention, and data usage. National reports were published under
differing titles in 1989, 1990 and 1991. Every Spring since 1991 and continuing to the
present, EPA has issued a Public Data Release Report. These reports contain numerous
tables accompanied by explanatory text aggregating release data by chemical, state, industry,
etc. Tables also highlight facilities with the largest releases nationwide, the greatest change
from the preceding year, etc. Both- national reports and public data release reports are
widely distributed by EPA and made available to selecting Federal depository libraries. A
limited number of copies are available (until stock is exhausted) from TRI User Support (see
1.5).
1.4.7 TRI Data on Microfiche
TRI data for 1987-1990 is available on microfiche at many public and depository libraries.
The microfiche version contains TRI data for each state and U.S. territories and includes 12
indices to use for searching of data. Each set of flche consists of three parts. Part 1 is the
Introduction and contains a list of chemicals reported, a directory of EPA and State TRI
contacts, a guide to searching the fiche, and other reference material. Part 2 contains the
index to the chemical substance names, names of facilities, publicly owned treatment works,
off-site transfer locations, and other facility information. Part 3 contains the TRI
submissions of each State and U.S. territories. TRI is no longer being published in
microfiche format.
1.4.8 TRI Data On Electronic Bulletin Board
If you have a personal computer, a modem, telecommunications software, and a telephone
line, you can obtain TRI data electronically by calling the Federal Bulletin Board sponsored
by the Government Printing Office. This service will allow you to browse a TRI Library,
order diskettes, or download data directly to your computer. Anyone can access the Federal
Bulletin Board by calling (202) 512-1357. A GPO deposit account number is required to
place orders electronically. For more information about this service, call GPO at (202) 512-
1530.
CD - ROM User's Manual Page 1 - 15
-------
1.5 TRI User Support
For the convenience of TRI data users, EPA offers users support services over the telephone.
Staff are available on weekdays from 8:00 a.m. until 4:30 p.m to assist you in obtaining or
using TRI information products. Experienced personnel can answer your questions about
installing the CD-ROM, search strategies for using the CD-ROM or TRI/TOXNET, or
accessing TRI on Internet or by other means. They can also refer you to state and EPA
regional offices in your area, as well as the closest Federal depository library where TRI
may be available to the public. TRI User Support maintains the latest information for
ordering TRI information products from GPO and NTIS. Limited training services may be
available. To contact TRI User Support, call (202) 260-1531.
1.6 Other Available Reference Materials
There are many reference materials that provide additional information about the Community
Right-to-Know Act and the Toxics Release Inventory. The aforementioned TRI User
Support (see Section 1.5) may also be able to offer assistance in obtaining publications.
Materials are free, unless otherwise indicated. The following materials published by EPA
are available through the EPCRA Hotline (1-800-535-0202; 703-412-9810 in the Washington,
DC area; 800-553-7672 for TDD equipment for the hearing impaired):
Chemicals In Your Community: A Guide to the Emergency Planning and Community
Right-To-Know Act. 1988 (36 pp.) Free
The Emergency Planning and Community Right-To-Know Act. Section 313 Release
Reporting Requirements. 1994 (28 pp.) Free
Chemical Releases and Chemical Risks. A Citizen's Guide To Risk Screening. 1989
(8 pp.) Free
Public Access to the Toxic Release Inventory (TRI): TRI Publications List. 1993
(11 pp.) Free
Title III. List of Lists - Consolidated List of Chemicals Subject To Reporting Under
the Emergency Planning and Community Right-To-Know Act. 1995 Free
Common Synonyms For Chemicals Listed Under Section 313 of the Emergency
Planning and Community Right-To-Know Act. 1995 Free
Page 1-16 CD - ROM User's Manual
-------
Also available from the EPCRA Hotline:
Chemicals, the Press and the Public: A Journalist's Guide To Reporting on
Chemicals in the Community. Environmental Health Center, National Safety Council,
1989 (119 pp.) Free
Additional resources:
The Toxic Release Inventory. Environmental Democracy In Action
TRIUS
202-260-1531
1992 (7 pp.) Free
Hazardous Substances In Our Environment: A Citizen's Guide to Understanding
Health Risks and Reducing Exposure. U.S. EPA. 1990 (125 pp.) Free
When All Else Fails! Enforcement of the Emergency Planning and Community
Right- To-Know Act. 1989 (12 pp.) Free
Risk Communication Hotline
(202) 260-5606
CD - ROM User's Manual Page 1-17
-------
2.0 Accessing TRI On CD-ROM
The complete package for utilizing TRI on CD-ROM includes the CD-ROM, the Quick
Reference Guide and installation instructions contained in the disc case, and this User
Manual.
2.1 Installation of TRI
The installation of the CD-ROM TRI software can be performed quickly and efficiently if
you follow the steps presented in the sections listed below.
2.1.1 Configuration Requirements
The following minimum configuration is needed to run the compact disc software:
• IBM or 100% IBM PC compatible personal computer (preferably a 386 or
higher).
• 640K RAM (with 510K RAM: available for fielded data)
• Hard disk with at least 1.5 MB disk space (required for installation)
• CD-ROM drive with CD-ROM Extensions
• MS-DOS or PC-DOS version 3.3 or above
• Color or monochrome monitor
• Printer (optional)
2.1.2 Setting Up Your CD-ROM System
This section describes how to configure a personal computer to read data from a CD-ROM
device. If your CD-ROM workstation is already setup or the workstation is being used
to access other discs, please skip this section and proceed to Section 2.1.3, Installing
TRI Search Software.
CD - ROM User's Manual Page 2 - 1
-------
There are several steps that must be performed to configure your system to begin to utilize
CD-ROMs. These steps are not difficult, especially if you are comfortable with setting up
directories and changing system files. Some procedures and file-naming conventions may
vary from one institution to another because of differences in equipment and internal policies.
The information presented here is to be used as a guide; it is not intended to provide
step-by-step instructions that will work in every institution. Most organizations have
designated a staff person with appropriate technical skills who can provide you with
assistance, if needed.
Set-up procedures vary especially where local area networks (LANs) are in place to permit
resource sharing among many users. The 1987-1993 TRI discs were designed for single-user
workstations, not multi-user configurations as found on LANs. Nevertheless, TRI can be
used on a network. Typically, if more than one user tries to use a disc simultaneously, the
second user will receive a DOS message notifying them that the file is already in use.
2.1.2.1 Installing CD-ROM Extensions
The TRI CD-ROM, like most discs developed in recent years, is in ISO 9660 format. ISO
9660 (also called High Sierra) is a standard format that was adopted early in the development
of CD-ROM technology. This format dictates a common logical file format for data on
CD-ROMs that enable them to be used with a variety of different microcomputers, CD-ROM
drives, and operating systems. This fo'rmat, and thus most discs in use today, requires the
use of software called CD-ROM Extensions. CD-ROM Extensions are usually supplied by
the vendor when a CD-ROM drive is purchased.
CD-ROM Extensions provide the interface between the retrieval software developed for a
particular application and the MS-DOS operating system. A program called MSCDEX.EXE
prevails over the limitation in earlier versions of MS-DOS (before Version 5.0) that restricts
access to devices larger in size than 32 megabytes. (This limitation is why larger hard drives
are usually "partitioned" into several smaller drives.) The MSCDEX.EXE program is not
required with DOS 5.0 or higher.
Another program, called a "device driver," is also provided with the CD-ROM drive. This
program actually translates signals between the microcomputer and the CD-ROM drive.
Device drivers are not unique to CD-ROM applications; these drivers also are required for
other peripherals, such as CRTs and printers. Device driver programs can usually be
identified because they are named by the manufacturer after the type of equipment for which
they were developed, for example, hitachi.sys for a Hitachi CD-ROM drive.
Most computer vendors provide a simple setup program with their equipment for preparing a
microcomputer to begin to recognize and interact with the CD-ROM drive. When available,
use the vendor-supplied program. They are usually reliable and simple to run. However,
you can configure your own system in a few steps. (The steps are essentially the same,
whether they are done automatically by a program or performed manually.)
Page 2-2 CD - ROM User's Manual
-------
Configuring your workstation to read CD-ROMs without the aid of a set-up program requires
making changes to your "autoexec.bat" and "config.sys" files, two files that provide vital
instructions to the computer during the initial boot. To modify these files, you will need to
use DOS or another utility for editing files.
After you have physically hooked up the hardware, the first step is installing CD-ROM
Extensions (MSCDEX) and the CD-ROM device driver on your bootable disk (which in most
cases is the C Drive). The name of the device driver varies from one model CD-ROM drive
to another; one common practice of software developers is to name the device driver after
the brand of CD-ROM drive that it supports (as previously explained). The device driver
program and MSCDEX.EXE are frequently set up in separate directories. However, this
practice is not universal.
The next step is to add a line to the Config.sys file to identify the device driver program.
The format for this line may be as follows:
Device = \path\driver name/D:\driver alias/N:#
A typical example might be:
Device = \dev\hitachi. sys/D:MSCD001/n:l
In this example, DEV is the directory where the file - hitachi.sys - is located; hitachi.sys is
the name of the device driver. MSCD001 is the driver alias provided by the manufacturer in
either written instructions or the drive setup program; and the last number following the "n"
represents the number of CD-ROM drives attached to that computer.
The third step is to add a line to the autoexec.bat file for running MSCDEX and assigning a
letter to your CD-ROM drive. Depending on your system configuration, you may opt to
setup one or more batch files to accomplish the same purpose. A line added to the
autoexec.bat file will be formatted as follows:
\path \MSCDEX/d:driver alias/M:8/L:E
A typical example of this line might be:
\bin\MSCDEX/d:MSCD001/M:12/L:E
In this example, bin is the directory where the program MSCDEX is located; MSCDEX is
the program commonly called CD-ROM Extgnsions. d:MSCD001 is the device driver alias
name supplied by the manufacturer (and also listed in the config.sys file); following m: is the
number of memory buffers allocated. The last letter, following L:, represents the letter used
to designate the CD-ROM drive.
CD - ROM User's Manual Page 2-3
-------
The final step, though simple, is nevertheless easy to overlook. You must reboot your
computer in order to activate the changes that you have made to your autoexec.bat and
config.sys files.
2.1.3 Installing TRI Search Software
Complete software for searching the CD-ROM is contained on each of the two discs that
comprise the 1987-1993 TRI CD-ROM set. Installation, which is accomplished using a
menu-driven, easy-to-use program, usually takes only a couple of minutes.
The installation procedure supplied with these discs has been enhanced to reduce RAM
requirements and to allow you greater flexibility in configuring your system. For the first
time, it is possible to limit users' access to DOS, in two ways: Depending on how it is
installed, the retrieval software will allow (or not allow) users temporary exit to DOS while
using the disc. For added security, it is also possible to set a password required to exit the
TRI software and return to the DOS prompt at the end of a session. Another new option
allows you to decide during installation whether to let users "add" data to CD-ROM records
(in fact the data would be stored to your hard disk).
Before you begin, you may want to delete software for earlier editions of TRI since the discs
that you have received contain cumulative data as well as newer, improved software.
Companies are permitted by law to revise TRI reporting forms for previous years; the
updated forms are included on the latest disc. Removal of outdated software from old
directories is essential if you plan to use the same directory name again. (Previous software
versions used TRI, REL and TRT as the default directory names.) By deleting old software,
you will be able to free up several megabytes of hard disk space.
Either disc can be used to install the retrieval software that will be used to search TRI and
the Chemical Substance Fact Sheets. Insert Disc One or Disc Two into the CD-ROM drive,
with the label facing up.
To begin the installation, you will need to know the letter of the CD-ROM where the TRI
disc is located. If you do not know the letter for the CD-ROM drive, identify it before
proceeding further.
For some, the easiest way to identify the letter assigned to the CD-ROM drive is simply to
try to list the directory, entering one letter after another, beginning with the letter d (e.g.,
c:\>dir d: ). Another way is to view the autoexec.bat file. Return to the root
directory and type:
c: >type autoexec.bat < ENTER >
Locate a line similar to:
\BIN\MSCDEX\D:MSCD001/M:12/L:E
Page 2-4 CD - ROM User's Manual
-------
The letter following L: at the end
of the line (in this case, L:E)
indicates the drive letter assigned
to the CD-ROM drive. If L: is
not present, your CD-ROM drive
is the first letter of the alphabet
not assigned to a hard disk or
other storage device. The
CD-ROM drive may be assigned
any letter of the alphabet.
After inserting either TRI disc
into the CD-ROM drive, you are
ready to install selected files
from it onto your hard disk.
Type the CD-ROM drive letter
followed by the word "install"
(no quotes). For example, type:
C:\>E:install
where the CD-ROM drive letter
is E.
If, at any point during
installation, you encounter an
error message or any other
indication of a problem, proceed
to Section 2.1.4, Troubleshooting
Software Installation.
QUICK SlTART INSTRUCTIONS
FOR INSTALLING TRI ;
1» Insert Disc One or Two into the CD-ROM
drive, (Software may be loaded from
either disc,)
2. Enter the CD-ROM letter and the install
command, e.g.,
C;\>e:install .
3. Follow prompts on the installation
screen;
aj Type c or just
to indicate whether or not you
are using a color monitor.
b. Enter the letter of the hard drive
where the software will be installed
and press .
c. Enter a name and press to
: create a directory or press to
use TRI as the default directory name.
d. Using the cursor key, indicate
whether or not to allow users to add
data to TRI records and press .
("Added" data is stored on the hard
disk.)
e. Enter and verify a password to limit
users' access to DOS when they are
finished using the TRI CD-ROM, or
press ESC to cancel the password
feature, {Note: If you designate a
password/ it must be entered at the
end of each session of CD-ROM use.)
f. Indicate whether or not to allow Temp
Exit to DOS while using the CD-ROM and
press .
4. The system will respond by copying files
to the hard drive (up to 31 files, based
on the choices made above).
5. Type TRI at the DOS prompt (e.g.,
C":\TRI>TR1) to begin using the CD-ROM.
The first installation screen will
ask you to indicate whether you •••••mmm^mmmmmmmmmmmmmmm^mmmmmmmmt^m
are using a color or monochrome
monitor. (Both TRI and the Chemical Substance Fact Sheets are fully functional using a
monochrome monitor.) Type C if you are using a color monitor. Press < ENTER > in
response to the prompt if you are using a monochrome monitor.
CD - ROM User's Manual
Page 2 - 5
-------
Installation Procedure For Toxics Release Inventory CD-ROM
If you are using a color monitor
type C. Otherwise press ENTER.
United States Environmental Protection Agency
The screen below asks you to identify the letter of the hard disk where you would like to
install the retrieval software. (Depending on the choices that you make during installation,
about 1.5 K of hard disc space will be needed to install TRI.) Enter the letter of the hard
drive and press < ENTER >.
Installation Procedure For Toxics Release Inventory CO-ROM
This procedure installs the 1995 version
of the Toxics Release Inventory (TRI) CD-ROM.
On the following screens you can specify your
preferences for several installation options.
First, this procedure copies some files from
the CD-ROM to a directory on your hard drive.
Type in the letter of the hard drive that you
want to use (for example, C) and press ENTER.
To cancel and exit, type X and press ENTER.
Letter of hard drive (or X): C
United States Environmental Protection Agency
The next screen allows you to choose the name of the directory where you would like the
retrieval software to be installed. If you wish to designate a directory, enter the name and
press (e.g., c:\>toxics ). If you prefer, you may accept "TRI" as
the default directory name by just pressing < ENTER > instead.
Page 2 - 6
CD - ROM User's Manual
-------
Installation Procedure For Toxics Release Inventory CD-ROM
Th
of
On
pr
Fi
th
Ty
wa
To
A new or existing directory will be used on
drive C. To call this directory \TRI, just
press ENTER. To use another directory name,
type in the name belaw and press ENTER. To
cancel and exit, type X and press ENTER.
Name of directory (or ENTER or X): toxics
Letter of hard drive (or X): c
United States Environmental Protection Agency
The next screen allows you to choose whether or not you want TRI users to be able to "add"
data to records from TRI. As an option, users would be able fill two fields called User
Added Data that would be linked (unless later deleted) to that TRI record. The additional
data would actually be written to the hard drive in the directory where the retrieval software
was loaded. From then on, each time a user called up that record from the CD-ROM, the
associated User Added Data would also be retrieved from the hard drive and displayed at the
end of the record. (See Chapter 4.)
If you wish to allow User Added Data, highlight the first option shown and press
< ENTER >. To restrict users from being able to write User Added Data to your hard
drive, highlight "Not allow user-added data" and press < ENTER >.
L
Installation Procedure For Toxics Release Inventory CO-ROM
Th
of
'On
pr
Fi
th
Ty
ua
To
1
A
dr
pr
ty
ca
Na
'
Do you want to .allow user-added data
such as notes to be stored with TRI
records? This 'data can be searched.
displayed, and printed or saved.
Allow user-added data
Not allow user- added data
Letter of hard drive (or X): c
—*
United States Environmental Protection Agency
i
CD - ROM User's Manual
Page 2 - 7
-------
The next segment of the installation procedure allows you the option of designating a
password that would be required to exit from the CD-ROM. The purpose of this security
feature is to prevent unauthorized access to DOS upon completion of a TRI CD-ROM
session. This capability is often helpful where public access is permitted, such as in
libraries. Of course, there are other effective ways, like shell programs, that can also limit
DOS access at the end of a session. Remember, if you choose an exit password, someone
will need to enter it at the conclusion of each session before the workstation can be used for
another purpose. (If you later forget the password that you designated, call TRI User
Support (202 260-1531) for assistance, or reinstall the software.)
If you do not wish to create an exit password, press < ENTER > in response to the prompt
shown below and skip to the next part of the installation procedure. Otherwise, enter a
password containing up to 10 letters and numbers and press < ENTER >.
Installation Procedure For Toxics Release Inventory CD-ROM
I
Th
of
On
pr
Fi
th
Ty
wa
To
dr
pr
ty
ca
Na
'
1
Do
su
re
di
You can set a password to limit exit
to DOS. 1) Type a password of up to
10 letters and numbers, then press
ENTER or 2) Press ESC to cancel the
password feature.
Password or ESC: HOB
1
United States Environmental Protection Agency
Page 2 - 8
CD - ROM User's Manual
-------
As you enter the password, the letters will be masked by x's, as shown below:
L
Installation Procedure For Toxics Release Inventory CO-RON
1
Th
of
On
pr
Fi
th
Ty
ua
To
A
dr
pr
ty
ca
Ha
L—
1
Do
su
re
di
1 t*ttt*r nf ha
You can set a password to limit exit
to DOS. 1) Type a password of up to
10 letters and numbers, then press
ENTER or 2) Press ESC to cancel the
password feature.
Password or ESC: xxxxxxxm
1
United States Environmental Protection Agency
The system will respond with a screen asking you to re-enter the same password for
verification:
Installation Procedure For Toxics Release Inventory CD-RON
Th
nf
PW"»
pr
Fi
th
Ty
wa
To
•
Hr
pr
ty
ca
Na
1
'
Dn
SU
re
di
Letter of ha
Yo
to
10
EN
pa
Pa
Please verify the password by
typing it again. Then press
ENTER.
Password: HBBmilB
I
United States Environmental Protection Agency
CD - ROM User's Manual
Page 2 - 9
-------
The system will either accept the password as entered the second time (if it matches exactly),
or you will receive a prompt asking you to create and verify a new password.
Installation Procedure For Toxics Release Inventory CD-ROM
1
Th
nf
On
pr
Fi
th
Ty
ua
To
tir
pr
ty
ca
Na
1
Rn
SU
re
di
«* h^,
Yo
to
10
EN
pa
Pa
Please verify the password by
typing it again. Then press
ENTER.
Password OK. Press ENTER.
1
United States Environmental Protection Agency
The final choice that you will make during installation is whether or not to allow users
temporary access to DOS while still using the TRI CD-ROM. Sometimes access to DOS is
useful to perform tasks like creating directories or verifying file names before exporting data.
However, in public settings, access to DOS is often blocked for security reasons, as
mentioned earlier.
Using the cursor key, highlight your choice, as shown below, and press .
Installation Procedure For Toxics Release Inventory CD-ROM
Th
of
On
pr
Fi
th
Ty
wa
To
1
A
Hr
pr
ty
ca
Na
!=—
1
Do
su
re
di
L= :
Letter of ha
1 1
'
Yo
to
10
EN
pa
Pa
Do you want to allow users to exit
to DOS temporarily for purposes such
as checking space on the hard drive
prior to saving output?
Allow Temp Exit to DOS
Not allow Temp Exit to DOS
1
United States Environmental Protection Agency
Page 2 - 10
CD - ROM User's Manual
-------
The system will proceed with installation by copying a number of files to your hard disk.
(The number of files will vary between 24 and 31, depending on whether you chose to allow
User Added Data, designated a password, etc.)
When all of the files have been copied successfully, a message indicating that installation has
been completed. The message also indicates the name of the directory where the software
was installed appears on the screen.
Installation Procedure For Toxics Release Inventory CO-RON
Th
of
On
pr
Fi
th
Ty
wa
To
Le1
A
dr
pr
ty
ca
Ma
:ter c
>f
Transferring files ...
1 file(s) copied
The TRI CD-ROM is now
installed. Press ENTER
to continue. Type TRI
to begin.
haL— 1
i
I
i i
'
w users to exit
for purposes such
n the hard drive
put?
t to DOS
Exit to DOS
|
United States Environmental Protection Agency
If you wish to begin using TRI immediately or to check that the software is properly
installed, type TRI at the DOS prompt (e.g., c:\TOXICS > TRI,) and press .
The system will respond by displaying the main menu. See Chapter 4.)
2.1.4 Troubleshooting Software Installation
In most cases, software installation is trouble-free. In a few cases, however, difficulties may
arise. This section is designed to help you identify and remedy the most common problems.
For convenience, it is organized by symptom. Error messages are shown in bold print to
help you locate them quickly.
CDRlOltNot ready error reading drive [CD-ROM drive letter]
Abort, Retry, Fail?
The first item to check for this error is whether the TRI CD is properly inserted in the drive
with the label facing up. This error may occur during installation or anytime someone is
preparing to use the CD-ROM.
CD - ROM User's Manual
Page 2 - 11
-------
A more difficult problem to resolve is when your system is not configured properly. If you
also have trouble reading a CD-ROM other than TRI when you list the directory, an
improper configuration is likely the problem. If you think your system is configured
improperly, examine the autoexec.bat, config.sys, and other files that are created to run the
CD-ROM drive. If you cannot detect the problem, seek assistance from a systems expert.
Although it is possible, it is highly unlikely that the CD-ROM itself is faulty unless the
product was damaged following its manufacture.
Bad Command or File Name
If this error occurs during the initial installation, check for typographical errors in the way
the command was entered. If the error occurs during installation or when you are trying to
use the TRI database, the computer is reading from a subdirectory (e.g., TRIFACTS) rather
than the root directory of the CD-ROM. To remedy the problem, change to the root
directory of the CD-ROM. (Enter the letter for the CD-ROM drive followed by a colon.
Then, type cd\ and press < ENTER >.)
Invalid Drive Specification
The CD-ROM drive was not turned on until after the PC. Turn on the PC after turning on
the CD-ROM drive.
Invalid Drive Letter
The letter that you entered to represent the CD-ROM drive does not agree with the system
configuration that is presently active. Verify the letter assigned to the CD-ROM drive by
checking the autoexec.bat file or listing the CD-ROM directory. Try rebooting your system
if the autoexec.bat file appears to be correct but there is a chance that it was changed since
the last boot.
File Not Found
It is normal for this message to flash on the screen momentarily the first time that you use
the disc following software installation. (Additional files are created automatically as soon as
you begin using the CD-ROM.) If the message recurs during subsequent use, it may mean
that installation was interrupted or did not complete successfully. The number of files
transferred to the hard drive may vary (between 24 and 31 files), depending on how the
software was installed i.e., whether DOS access and user added data were allowed. If a
problem occurs resulting in the message File Not Found, the easiest solution may be to
repeat the installation procedure.
Page 2-12 CD - ROM User's Manual
-------
Display shows something other than TR] Installation Screen
This error may occur if the CD-ROM reader is reading from a directory rather than the root
directory of the TRI CD-ROM during the installation process. To remedy the problem,
change to the root directory of the CD-ROM. (Enter the letter for the CD-ROM drive
followed by a colon. Then, type cd\ and press < ENTER > .)
[#] Additional Bytes of Available Memory Required To Run KAware2 Press ENTER to
Exit KAwareZ
Out of Memory: This Application requires 0 Additional Bytes of Free Memory
These messages will appear if your system does not have enough room to load the software
and TRI records into memory to allow you to retrieve the TRI data. About 430K available
memory is required to load the Chemical Substance Fact Sheets. Approximately 507K of
memory is required for the TRI data base. Although the error message says that no
additional bytes of free memory are needed, additional memory is required. The message
instructs you to press < ENTER > to return to DOS to investigate the memory problem,
however, when you press < ENTER >, you will not return to the DOS prompt. Instead,
you will return to the DATA SELECTION MENU.
Most microcomputers are configured with at least 640K of Random Access Memory (RAM).
Memory is the area where your computer temporarily stores data and instructions it needs to
execute that tasks you have requested. (Don't confuse memory with hard disk space usually
measured in megabytes which provides longer-term data storage.) Some of your computer's
memory may be used by DOS or other programs loaded on your equipment. To find out
how much memory is actually available, at the C prompt in the root directory, type:
c:\>chkdsk
Scan the display; the last line tells you how many bytes of memory are free.
2.1.5 If You Need More Memory...
One of the most common problems that users experience during installation occurs when
insufficient random access memory (RAM) is available to load the files. As noted above,
507K of RAM is required to successfully install the TRI software. (It is important to
distinguish between RAM, required by DOS applications such as the TRI discs, and other
types of memory. See the sidebar on the following page for a brief description.) If you are
currently experiencing problems due to memory limitations, it is only going to get worse as
more multimedia and audio discs are introduced. You may want to consider upgrading the
memory or modernizing your CD-ROM workstation. If you are considering enhancing your
existing system, you may wish to speak to someone knowledgeable in this area before
proceeding.
CD - ROM User's Manual Page 2 - 13
-------
There are, however, several steps that you can take to maximize the RAM available without
upgrading equipment. The easiest method requires use of DOS 5.0 or higher, which allows
you to make use of memory in several new ways. For example, it allows you to utilize part
of the upper which was restricted from use unless you purchased a separate memory
management program. In addition, you can transfer actual DOS programs from conventional
memory to the high memory area, thus freeing up a larger portion of the precious 640K
conventional memory.
Another possibility is to identify and
discontinue use of any unnecessary
"terminate and stay resident" (TSR)
programs that you may be using. All
computer software requires the use of some
memory while the computer is in use. TSR
programs are routines that continue to
occupy memory even if these programs are
not active. Often such programs are
difficult to identify and you may need
assistance.
Here are two steps you might take to
free-up memory space occupied by TSRs:
1) Reboot your system before using the
TRI CD-ROM. Some application software,
for example, spreadsheets, word processors,
etc., may leave a "part" of the program in
memory, even though you are no longer
using the program. By rebooting your
system, you will rid the memory of TSR
routines remaining from software used
earlier.
2) Change your autoexec.bat file to
eliminate TSR programs that are activated
as soon as you turn your computer on. A
common example of TSRs is a "shell"
programs to display a menu instead of the
DOS prompt when you first boot the
computer or allow your numeric keypad to
function like a calculator. If you modify
your autoexec.bat file, be sure to reboot
your computer to activate any changes you
have made.
TYPES OF COMPUTER MEMORY
The 640K (or sometimes less) memory with which
you are most familiar is known as conventional
memory, also called random access memory
(RAM). Conventional memory can be used in
many ways, including loading and executing
programs, for DOS and device drivers, and
temporarily storing data. DOS applications, like the
TRI CD-ROM, require access to varying amounts
of RAM in order to run. (TRI requires 510K
RAM.) Most PCs in use today also have an
additional 384K memory (transparent to the user)
that increases memory from 640K to 1 MB. Use of
this space, known as "upper memory," is somewhat
restricted. For example, it is not accessible to most
programs and earlier versions of DOS (before 5.0).
Expanded memory, developed to overcome the
640K DOS barrier (before DOS 5.0), requires
installation of a card in an expansion slot on your
PC. Expanded memory allows you to use
conventional memory more efficiently by swapping
data from expanded memory in and out of
conventional memory very quickly in 64K blocks.
Thus, your computer is "fooled" into using
programs that are actually stored on the expansion
card.
Extended memory, developed after expanded
memory was widely available, uses a completely
different approach. This is an area above 1 MB (up
to 32 MB) that is accessible from a chip on the
motherboard. Extended memory is only available
on 80286 and faster machines. Some programs,
such as Windows and Lotus 1-2-3, can fully utilize
extended memory just as though it was part of the
conventional 640K.
There is one other type of memory - high memory -
which is the first 64K of extended memory.
Page 2 - 14
CD - ROM User's Manual
-------
Another alternative is to reduce the number of files allocated in your config.sys file. The
config.sys file, read automatically by the computer when you boot, instructs the computer on
how to allocate some of its memory. The config.sys file describes the number of files that
can be opened at one time with the files command. For example, files = 10 means that a
maximum number of ten files may be open at one time. Usually the minimum number of
files is between six and ten, because DOS requires five files for its use. Reboot the
computer after changing the config.sys file.
You also can reduce the number of memory buffers. DOS uses disk buffers to store data
when reading from and writing to a disk. Each buffer requires 528 bytes of memory. The
number of buffers you allocate depends on i;he type of applications you use and your
hardware configuration. Check the documentation or contact your system administrator to
determine the minimum number of buffers for your situation. If you modify the config.sys
file, reboot the system.
2.2 TRI CD-ROM Structure
The CD-ROM version of TRI consists of three separate and distinct options and features:
the Toxics Release Inventory, Fact Sheets, and performing calculations. These options and
features will be discussed in the next sections.
2.2.1 Chemical Substance Fact Sheets
In addition to the TRI itself, the CD-ROM also contains Fact Sheets that provide information
about health, safety and ecological data on TRI chemicals. You might use this file after
searching for information in the TRI itself (discussed below) to learn more about the effects
and to better understand the chemicals that have been identified. The fact sheets data base is
provided on both Disc 1 and Disc 2, for your convenience. For more information, see
Chapter 3.
2.2.2 Toxics Release Inventory
This set of two CD-ROMs cumulate several years of the Toxics Release Inventory, dating
back to the inception of the program in 1987. Disc One contains TRI submissions for
reporting years 1987-1990; Disc Two contains TRI reports for 1991-1993. On each CD-
ROM, TRI records are broken down into two files, called RELEASES and TREATMNT:
The RELEASES file is used when requesting comprehensive facility identification
information. This file contains total amounts of chemicals released to the mediums
(air, land, water) and publicly owned treatment works (POTWs). It can be used to
display summary of releases, e.g., searching for facility and chemical information for
ABC Manufacturing Company, or the name and addresses of off-site locations in
Houston, Texas where chemical wastes are shipped.
CD - ROM User's Manual Page 2 - 15
-------
The TREATMNT file is used to search for data on waste treatment methods and
efficiency, and waste minimization.
For more information about searching the RELEASES and TREATMNT files, see Chapter
4.
2.2.3 Calculation Feature (KASTAT)
KASTAT is a feature of TRI that takes sets that have been created and calculates the sum
totals of fields that have been selected. For more information, see Chapter 5.
2.3 Readme Files
There are several "readme" files that provide documentation for the database and referrals to
State and Regional contacts. These files can be viewed and printed directly from the CD-
ROM. These files are:
README.NOW: Describes TRI and the contents of these discs more fully;
FIELDS.TRI: Contains descriptions of all the data fields including codes and translation of
coded information.
REGIONS.EPA: Contains the names, addresses, and telephone numbers of the 10 Federal
EPA Regional contacts.
SIC_CODE: Contains the four-digit Standard Industrial Classification codes for 20-39 and
the code descriptions.
STATES: Contains the names, addresses, and telephone numbers of the State and Territorial
TRI contacts.
Page 2-16 CD - ROM User's Manual
-------
2.4 Accessing the Toxics Release Inventory
In order to access TRI on the CD-ROM:
1. Turn on the CD-ROM drive cind the personal computer.
NOTE: The CD-ROM drive must be turned on before or at the same
time as the PC.
2. Insert one of the two TRI compact discs (CD) into the CD-ROM drive.
3. Make sure that you are logged onto the hard drive where the TRI retrieval
software was loaded. If not, type C: < ENTER > (or the
appropriate letter for your configuration).
4. Access the directory where tiis TRI CD-ROM software was loaded (e.g.,
TRI, the default directory name supplied by the installation module):
CD TRI < ENTER >
5. To launch TRI, at the subdirectory DOS prompt (e.g., C:\TRI>), type:
TRI < ENTER >
The first screen you will see is the Data Base Selection menu:
Toxics Release Inventory CD-ROM
Highlight your choice below and
press ENTER.
1 Chemical Substance Fact Sheets
2 Toxics Release Inventory 1987-90
3 Toxics Release Inventory 1991-93
4 Calculate Releases (KASTAT)
5 Quit TRI CD-ROM Disc
6. Press the arrow keys to move to the selection of your choice or press the
corresponding number and press < ENTER > to indicate your selection.
Each of the selections will be discussed in the next several chapters. With the selection of
Option 5, Quit TRI CD-ROM Disc, you will, leave the TRI software and return to the DOS
prompt and the TRI directory. To re-enter TRI, type TRI (see #5 above) and proceed with
the instructions.
CD - ROM User's Manual
Page 2 - 17
-------
2.5 Special Keys
The TRI CD-ROM software employs the use of many specials keys to ease your use of the
software. These special keys are described below.
Arrows - Allow you to move up, down, left and right in menus, screens, and records.
Home/End - Allows you to move to the top of page with HOME and to the bottom of
page with END. The combination of the CTRL and HOME keys pressed
simultaneously moves you to the first record in a set. The combination of the CTRL
and END keys pressed simultaneously moves you to the last record in a set.
PgUp/PgDn - Allows you to move backward or forward through a menu or display,
one page at a time.
ESC - allows you to perform the following functions:
• Acts as a backup key to return you to the previous step
• Will abort a search
• Will abort a save or load of a set list
• Returns you to the Title Screen when the function keys 1-5 are open.
Ctrl - In combination with another letter key hit simultaneously will assist in
performing a variety of options.
Alt - In combination with another letter key hit simultaneously will assist in
performing a variety of options.
NOTE: To remove a pull-down menu associated with a function key option, press the
function key for that option and the pull-down menu will toggle off. Press the same function
key to toggle the pull-down menu back on.
2.6 Printing Files
You can print a record that you are viewing on the screen with the Print Current Record
option. In addition, you can print a set of records that you have created. These options will
be discussed in Chapters 3 & 4.
Page 2-18 CD - ROM User's Manual
-------
3.0 Chemical Substance
Fact Sheets
Fact sheets supplement the environmental release data on chemicals in TRI with information
related to the health and ecological effects as well as safety and handling of the chemicals.
There is a fact sheet for most TRI chemicals, except when categories of chemicals are
grouped together for TRI reporting (e.g., lead compounds). Designed for a lay audience,
they represent scientifically accepted information in non-technical language. The data may
be especially useful to workers, employers, community residents, and health professionals.
It is especially useful to review the Fact Sheets after identifying chemicals of interest by
searching the TRI Fielded Database. Text on health, safety, and ecological data is displayed
along with the common name and CAS nuriber.
For your convenience, Chemical Substance Fact Sheets are provided on both TRI discs, and
can be accessed from the main menu on Disc One or Disk Two.
Press < ENTER > to Select #1, Chemical Substance Fact Sheets, from the DATA BASE
SELECTION MENU.
Toxics Release Inventory CO-RON
Highlight your choice below and
press ENTER.
1 Chemical Substance Fact Sheets
2 Toxics Release Inventory 1987-90
3 Toxics Release Inventory 1991-93
4 Calculate Releases (KASTAT)
5 Quit TRI CD-ROM Disc
United States Environmental Protection Agency
Page 3 - 1
CD-ROM User's Manual
-------
While the TRI Fact Sheets are being loaded, the message, "Loading KAware2 with
E:\TRIFACTS\FACTS - Please Wait" will be displayed. (The drive designation - E: - in this
message will vary according to the letter assigned to the CD-ROM.) The next screen to be
displayed is the TRI FACT SHEETS TITLE SCREEN.
Press < ENTER > to continue. The TRI FACT SHEETS MAIN MENU (with F3 =
Select, highlighted) will appear.
TRI FACT SHEETS - KAwareZ (tn) FullText VI.52
fl = Help F2 = Options F3 = Select F4 = Search
TABLE OF CONTENTS
COMWN NAME
CAS NUMBER
TEXT
GLOBAL INDEX
F5 = Sets
Set ffFound
(Page 1 of 1
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REMAINING=256000
F6=Display F7=Groij>
F10=Exit ESC=Backup
3.1 Overview of Conducting A Search
To conduct a search of data contained in Fact Sheets, there are several simple steps. You
will need to SELECT the data elements for the specific information you need; SEARCH for
specific values related to those data elements; DISPLAY the data; and PRINT the date for
later viewing or DOWNLOAD (export) the data to other software formats. Additional
information on conducting a search is provided in Section 3.3, Conducting A Search For
Fact Sheets.
3.2 Function Key Options
Several options in the form of function key selections are displayed on the top and bottom of
the screen. Some of these options have pull-down menus associated with the option.
These options are as follows.
NOTE: To remove a pull-down menu associated with a function key option, press the
function key for that option and the pull-down menu will toggle off. Press the same function
key to toggle the pull-down menu back on.
CD-ROM User's Manual
Page 3 - 2
-------
3.2.1 Fl = HELP Key
Fl = Help - This option provides context sensitive HELP for several of the function key
selections. The HELP pull-down menu is displayed below:
TRI FACT SHEETS - K»ware2 Urn) FullText V1.52
F1 = Help F2 = Options F3 = Select F4 = Search
FUNCTION KEYS
OPTIONS
SELECT
SEARCH
SETS
DISPLAY
(Page 1 of 1)
(Ctrl -PgUp/PgDn changes Set List page)
F5 = Sets
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REMAIN I NG=256000
F6=Display F7=Group
F8=Group T F9=Group
F10=Exit ESC=Backup
Page 3 - 3
CD-ROM User's Manual
-------
The HELP option is available at any time while you are in the TRI Fact Sheets by pressing
the Fl key. Use the PgUp/PgDn keys to move within the HELP text. A HELP example is
displayed below:
TRI FACT SHEETS - KAwareZ (to) FullText V1.52
J
F
>age/Line Up ESC to Exit Page/Line Doun
F6 - DISPLAY
F6, the Display Manager, does not have its own menu,
because you do not want a menu on the screen while
you are reading the retrieved information. Instead,
you uill find proopts for using the Display Manager
in the top and botton banners of the screen. There
is also an "Action Menu" that appears briefly on the
right side of the screen to assist you in Hypertext
searching, block narking/saving/printing, addition
of your notes to the file, etc.
—
SEARCH SET=0 DISPLAY SET=0 WORKSPACE REMAIN I NG=256000
F6=0isplay F7=Group
F8=Group T F9=Group
F10=Exit ESC=Backup
3.2.2 F2 = OPTIONS Key
F2 = Options - This option allows you to access the settings for the search, display, and
output of information. The OPTIONS pull-down menu is displayed below:
F1 = Help
Set #Found
TRI FACT SHEETS - KAuareZ (tm) FullText VI.52
F2 = Options F3 = Select F4 = Search
F5 = Sets
Search Set:
Display Set:
Post Search:
Group Search With:
Table of Contents:
Notes With Output:
Define Display:
LAST SET CREATED
LAST SET CREATED
DISPLAY SET FOUND
GROUP ONLY
ALPHA ORDER
OUTPUT TEXT ONLY
DISPLAY RETRIEVED DOCUMENTS
Save Current Settings
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REMAINING=256000
F6=0isplay F7=Group AY F8=Group
F9=Group V F10=Exit ESC=Backup
CD-ROM User's Manual
Page 3 - 4
-------
When the cursor is on a specific selection in the OPTIONS menu, press < ENTER > to
toggle through all of the choices for that selection. As an example, for Search Set, Last Set
Created is displayed. By pressing < ENTER >, the other choices, Selected Set and Entire
Document, also are displayed. When the desired choice is displayed, press the up or down
arrow to move to another selection within the OPTIONS menu. To save your selections, use
the down arrow to Save Current Settings. Press < ENTER >. The new settings will now
become the current settings until they are changed. Press Fl (HELP) when the pull-down
menu for OPTIONS is displayed to view the effects of your selection.
3.2.3 F3 = SELECT Key
F3 = Select - This option displays all the fields used to search for data in the TRI Fact
Sheets. The SELECT menu is displayed below:
TRI FACT SHEETS - »tuare2 (tn) FullText VI.52
Fl = Help F2 = Options F3 = Select F4 = Search
TABLE OF CONTENTS
COMMON NAME
CAS NUMBER
TEXT
GLOBAL INDEX
F5 = Sets
Set fFound
(Page 1 of 1
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY Sl!T=0
WORKSPACE REMAINING=256000
F6=0isplay F7=Gra*> 1 F8=Gron> T F9=Groi4> / F10=Exit ESC=Backi*>
NOTE: The choices in the pull-down menu for F3 = Select are tied directly to the function,
F4 = Search. Since this option is the core of the searching capabilities for the TRI Fact
Sheets, each of the choices will be described below to assist you in its usage.
Page 3 - 5
CD-ROM User's Manual
-------
TABLE OF CONTENTS - This choice provides a listing which displays all of the
common names of chemicals in alphabetic order (or the order that is indicated in the
Table of Contents selection under the F2 = Options choice). Chemical names
preceded by numbers sort before chemicals that begin with an alphabetic character
(see examples on sample screen shown below). There are 33 screens of chemical
common names. Use the and keys to browse through the list
of chemicals sequentially. When you have located the common name that you need,
press < ENTER >. The Table of Contents only searches the chemical common name
field. After selecting a name, the record is displayed but no set is created.
TRI FACT SHEETS - KAwareZ Urn) FullText VI.52
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Cannon
Common
Coranon
Comon
Cannon
Name
Name
Name
Name
Name
Name
Name
Name
Name
Cannon Name
Comon
,1,2,2-Tetrachloroethane
,1,2-Trichloro-1,2,2-Trifluoroethane
,1,2-Trichloroethane
,2,4-Trichlorobenzene
,2-Butylene Oxide
,2-Dichlorobenzene
, 2-Di chloroethane
,2-Dichloroethylene
,2-Dichloropropane
,2-Dihydroxybenzene
(Page 1 of 33)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REMAINING=256000
F6=0isplay
F8=Group T F9=Group
F10=Exit ESC=Backup
CD-ROM User's Manual
Page 3 - 6
-------
COMMON NAME - This choice also allows you to search by common chemical
name, but provides greater flexibility in searching. It allows you to type in a term,
partial term (followed by a question mark (?)), phrase, or boolean expression to locate
a common chemical name. For chemical names that begin with numbers, omit the
numbers when searching. (For example, search 1,1,2,2 - Tetrachlorethane by
entering Tetrachlorethane.) Only the common name field will be searched, not the
text of the Fact Sheet. Unlike using the Table of Contents to search by common
chemical name, this option will result in creation of a search set.
NOTE: It is possible to search the Common Name field using boolean expressions,
however, it is not the most effective way to search by chemical name. Instead, type a
partial term followed by a question mark (e.g., chlor?) to identify variant spellings or
similar chemical names.
TRI FACT SHEETS - »iuare2 (tin) Full Text VI.52
F1 = Help F2 = Options F3 = Select F4 = Search
Set *Fo
F5 = Sets
COMMON NAME
Enter a Ter*, Partial Tera followed by a ?,
Phrase, or Boolean Expression (F1 for Help):
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REMAINING=256000
F6=0isplay
F8=Group T F9=Grotp V F10=Exit ESC=Backup
Page 3 - 7
CD-ROM User's Manual
-------
Type the common name and press < ENTER >. The TRI software will search for
the common name and respond with the search results or a message will appear that
says the common name you requested is unavailable. If you are unsure of the name
or the spelling of the name, use the partial term option. When using the partial term
option, type a term followed by a question mark (?) (e.g., ben?) and press
< ENTER >. The message "Loading Words With BEN? Root" will appear. A
listing of common names that start with the letters "BEN" will appear. Select the
correct common name and press < ENTER >. It should be noted that each chemical
is unique with distinct properties. Although two chemical names may start with
"METHYL (methyl tert-butylether and methyl acrylate), it does not mean that these
two chemicals have comparable or related characteristics and effects.
TRI FACT SHEETS - KAuareZ (tin) FullText VI.52
F1 = Help F2 = Options F3 = Select F4 = Search F5 = Sets
Set Wound
1 1/1
(Page 1 of 1)
COMMON NAME: BENZYL [1]
COMMON NAME
BENZAL [1]
BENZAMIDE [1]
BENZENAMINE [1]
BENZENE L3]
BENZIDINE [1]
BENZOQUINONE [1]
BENZOTRICHLORIDE [1]
BENZOYL [2]
BENZYL [1]
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=1 DISPLAY SET=0
WORKSPACE REMAINING=255999
F6=Display F7=Group
F8=Group T F9=Group
F10=Exit ESC=Backup
NOTE: Chemicals are often known by more than one name. In most instances, the
same chemical name was used for TRI and the Fact Sheets. If you cannot find the
"TRI Name", use the CAS Number that is found in the TRI record (see page 3-9).
CD-ROM User's Manual
Page 3 - 8
-------
CAS NUMBER - A Chemical Abstracts Service (CAS) number uniquely identifies an
individual chemical. When known, searching by CAS number is the most precise
way to search for chemical data. This choice allows you to type in a term, partial
term (followed by a question mark (?)), phrase, or boolean expression to locate a
CAS number. Dashes in a CAS number are required. Only the CAS number field
will be searched. The format for a CAS number is as follows: first five positions
can be digits (no leading zeros), followed by a dash (-), followed by two more digits
(leading zero), followed by a dash (-), and then one more final digit (may be a zero).
TRI FACT SHEETS - KAwareZ (tm) FullText VI.52
F1 = Help F2 = Options F3 - Select F4 = Search
F5 = Sets
Set #Fo
CAS NUMBER
Enter a Term, Partial Tern followed by a ?,
Phrase, or Boolean Expression (F1 for Help):
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REMAINING=256000
F6=Display f7=Graup
F9=Group V F10=Exit ESC=Backi*>
Page 3 - 9
CD-ROM User's Manual
-------
Type the complete CAS number and press < ENTER >. The TRI software will
search for a CAS number and respond with the search results or a message will
appear that says the CAS number you requested is unavailable. Check to ensure that
the CAS number, including dashes, was entered correctly if the CAS number you
requested is unavailable.
TRI FACT SHEETS - KAnare2 FullText V1.52
F1 = Help F2 = Options F3 = Select F4 = Search F5 = Sets
Set #Fo
CAS NUMBER
Enter a Tern, Partial Tern followed by a ?,
Phrase, or Boolean Expression (F1 for Help):
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REMAINING=256000
F6=0isplay F7=Group
F8=Grokf> T
F10=Exit ESC=Backip
CD-ROM User's Manual
Page 3 - 10
-------
TEXT - This choice allows you to type in a term, partial term (followed by a question
mark (?)), phrase, or boolean expression to locate text. Only the body of the Fact
Sheet (or "text") is searched, not the chemical name or CAS number where they
appear in the heading of the Fact Sheet. Proximity searching also is an effective way
to search for specific text. This typs of searching is useful when trying to locate text
or words that are adjacent or near each other. Either of two formats may be used: 1)
Using the search operator NEAR (e.g., EXPOSURE NEAR TOXICITY) will retrieve
all documents where the two words occur in the same Fact Sheet or part of a Fact
Sheet; 2) The search command WITHIN 1 will bring up all Fact Sheets where the
first term is adjacent to the second search term (e.g., SKIN WITHIN 1 CONTACT
will retrieve all Fact Sheets containing the term SKIN CONTACT).
TRI FACT SHEETS - KAtiareZ (tn) FullText VI.52
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set #Fo
TEXT
Enter a Term, Partial term followed by a ?,
Phrase, or Boolean Expression (F1 for Help):
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REMAINIMG=256000
F6=0isplay F7=Group
F8=Group
F10=Exit
Type the text and press < ENTER >. The TRI software will search for the text and respond
with a location of the text you have entered or a message will appear that says the text you
requested is unavailable. You will then need to try again if the text was not found. When
using the partial term option, type a term followed by a question mark (?) (e.g., ben?) and
press < ENTER >. A listing of text that contains "BEN" will appear. Select the correct
text and press < ENTER >.
Page 3 - 11
CD-ROM User's Manual
-------
TRI FACT SHEETS - KAuare2 (tm) FullText VI.52
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set #Found
1 1/1
(Page 1 of 1)
COMMON NAME: BENZYL [1]
TEXT
BENEATH [1]
BENEZENEDIANINE [1]
BENHEXACHLOR [1]
BENZ [1]
BENZ-0 [1]
BENZ-0-CHLORO [1]
BENZAL [42]
BENZALDEHYDE [3]
BENZAMIDE [44]
BENZAZINE [1]
(Page 1 of 5)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=1 DISPLAY SET=0
WORKSPACE REMAINING=255999
F6=0isplay F7=Groi4> 1 F8=Group t F9=Group V F10=Exit ESC=Backup
GLOBAL INDEX - This choice allows you to type in a term, partial term (followed
by a question mark (?)), phrase, or boolean expression or proximity search to perform
a global index search to locate data. The Global Index searches a combination of the
CAS number, chemical common name, and text.
TRI FACT SHEETS - KAuareZ (tm) FullText VI.52
F1 = Help F2 = Options F3 = Select F4 = Search F5 = Sets
Set #Fo
GLOBAL INDEX
Enter a Tens, Partial Tern followed by a ?,
Phrase, or Boolean Expression (F1 for Help):
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REMAINING=256000
F6=Display F7=Group
F8=Group T F9=Group
F10=Exit ESC=Backup
CD-ROM User's Manual
Page 3 - 12
-------
Type the search term or expression and press < ENTER >. The TRI software will
search the global index and respond with a location of the data that you have
requested or a message will appear that says the search term or expression that you
requested is unavailable. When using the partial term option, type a term followed by
a question mark (?) (e.g.,CHL?) and press . The message, "Loading
Words With CHL? Root" will appear. A listing of global index terms that start with
CHL will appear, highlighting whether the index is a common name or text. Select
the correct index entry and press < ENTER >.
TRI FACT SHEETS - KAuareZ (tin) Full Text VI.52
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set *Found
(Page 1 of 1)
GLOBAL INDEX
CHLORACNE [TEXT 5]
CHLORANBED [TEXT 1]
CHLORANBEN [COJMON NAME 1]
CHLORANBEN [TEXT 37]
CHLORATE [COWON NAME 1]
CHLORATE [TEXT 241
CHLORATES [TEXT 84]
CHLORDANE [COMON NAME 1]
CHLORDANE [TEXT 40]
CHLORETHENE [TEXT 1]
(Page 1 of 9)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SIET=0
WORKSPACE RENAINING=256000
F6=0isplay F7=Group
F8=Groip t F9=Group
F10=Exit ESC=Backi*>
3.2.4 F4 = SEARCH Key
F4 = Search - This option is directly related to the choices described for the F3 = Select
option. See the NOTE for that option described above. Press to leave this option.
Page 3 - 13
CD-ROM User's Manual
-------
3.2.5 F5 = SETS Key
F5 = Sets - This option provides selections to work with user defined sets of data in order
to enhance the sets of data you create. The SETS pull-down menu is displayed below:
TRI FACT SHEETS - KAuareZ (tin) FullText VI .52
F1 = Help F2 = Options F3 = Select F4 = Search
Set #F
-------
Combine Sets - This selection allows you combine user defined sets with additional
conditions of AND, OR, or NOT. To understand the difference between these three
conditions, let us use an example for each condition.
• Benzene AND Chlorine - The TRI software will search the database for both
chemical names in the field being searched. AND limits the search to records
meeting criteria for all of the sets that are being combined.
• Benzene OR Chlorine - The TRI software will search the database for either of
the chemical names in the field being searched. OR broadens the search to
include records that meet criteria for creating any of the searches being
combined.
• Benzene NOT Chlorine - The: TRI software will search the database for the
first word not the second word in the field being searched. NOT includes
records that meet criteria used to create the first set specified except records
that were included in the second set that is combined.
NOTE: When combining with NOT, you will obtain different results
depending on which word you specify first.
TRI FACT SHEETS - KAuareZ (tin) FullText VI.52
F1 = Help F2 = Options F3 = Select F4 = Search F5 = Sets
Set
(Page 1 of 1)
Select an Operator:
Coabine with AND
Coabine with OR
Cortrine with NOT
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SHT=0
WORKSPACE REMAINING=256000
F6=Display F7=Group
F8=Gron> T F9=Group
F10=Exit ESC=Backi*>
Page 3 - 15
CD-ROM User's Manual
-------
Select the condition and press < ENTER >. Set numbers are displayed on the screen
under the SET category. In the set box, type the first set number, press
, type the second set number, press , etc., until all the set
numbers to be combined have been identified. You may give this newly created set a
name. If you do not give the set a name, the TRI software will generate a name
automatically.
Delete A Set - This selection allows you to delete a specific set. Deleting search sets
that you do not need may be beneficial because it increases the the amount of
workspace that is available for creating additional search sets. (See WORKSPACE
REMAINING=????? in the lower right-hand side of the screen.) Once you have
requested a deletion, that set will be highlighted on the screen with the word
DELETED. Once deleted, it is no longer possible to retrieve that set, without
searching the data again.
Delete All Sets - This selection allows you to delete all user defined sets. (To save
records for a particular search to disk before deleting all sets, see Export A Set.
below.)
TRI FACT SHEETS - KAnare2 (tm) FullText VI.52
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set fFound
(Page 1
This will erase your
ENTIRE Set List!
ARE YOU SURE? (Y/N)
(Ctrl-Pgup/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REHAINING=256000
F6=Oi splay F7=Group 1 F8=Group T F9=Group
F10=Exit ESC=Backup
If you answer YES by typing < Y> to the erasure of all sets, you will no longer be
able to access them. All sets will have to be recreated. If you answer NO by typing
, no sets will be erased.
CD-ROM User's Manual
Page 3 - 16
-------
Display A Set - This selection allows you display any user defined set.
TRI FACT SHEETS - KAuareZ (tin) FullText VI.52
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set fFound
(Page 1 of
Enter the number
of the set to
be displayed:
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REMAINING=256000
F6=Display F7=Group 1 F8=Grou(J T F9=GroLp V F10=Exit ESC=8ackup
Type the number of the set to be displayed and press < ENTER >. If the set number
you have entered does not correspond with a set number displayed, the field in the
box erases the value you have entered and displays a blank. Enter the correct set
number.
Export A Set - This selection allows you to save search results in ASCII format to be
used with other software. Enter the number of the set to be saved for exporting,
name of the file to be saved, and press < ENTER >. A message will appear telling
you the set has been saved.
Export from Table of Contents - This selection allows you to save a record using the
common name from the Table of Contents. Name the file to be saved on the C drive.
A message will appear telling you the set has been saved.
Load Set List - This selection allows you to load a set list that you have previously
saved. When you load a set list, all currently displayed set lists that have not been
previously saved, will be erased. Select a set list from the box displaying all the
saved set lists.
Print A Set - This selection allows you to print a set to a local printer. Enter the set
number to be printed. If the set number you have entered does not correspond with a
set number that exists, the field in the box erases the value you have entered and
displays a blank. Enter the correct set number. The set will be printed on a local
printer.
Page 3 - 17
CD-ROM User's Manual
-------
Print from Table of Contents - This selection allows you to select a chemical name
from the Table of Contents name and send the record for that chemical to a local
printer to be printed.
Save Set List - This selection allows you to save a set list to the C drive so that you
can retrieve it at a later date. The system will supply the suffix, .SSL.
NOTE: Caution! If you save set lists to a drive other than C, the file must be
copied to the current directory where the CD-ROM is loaded (e.g., C:\REL\) to be
loaded. This process saves only the list - not the actual records retrieved. To save
search results, use Export A Set.
Select Display Set - This selection allows you to display a set using the F6 key
(F6=Display). See the F6=Display section below for more information.
Select New Data File - It is not recommended that you exercise this option. This
software feature was designed for products that contain multiple text files on one disc.
The TRI disc, however, contains only one text file - the Fact Sheets. If you press
Select New Data File accidentally, press to return to the TRI Fact Sheets
Main Menu. You may have to repeat searches that were conducted earlier.
Temp Exit to DOS - This selection allows you to temporarily exit to DOS. Once you
are at the DOS prompt, you can return to the TRI Fact Sheets Main Menu by typing
and pressing < ENTER >.
3.2.6 F6=DISPLAY Key
F6=Display - This option displays Fact Sheets for the chemicals in the data set you have
created (or the display set shown at the bottom of the screen). Working with the common
name, Benzyl, that was used for the select process as an example, the Fact Sheet for
BENZYL would be displayed. The illustration below shows the Fact Sheet for Benzyl, the
chemical used as an example for the select process. Press and
simultaneously to skip to the next record when displaying search results containing multiple
records.
When you display data, you will notice a status line at the bottom of the screen, which
highlights the Search Set, Display Set, and Workspace Remaining.
• Search Set - identifies which set is being searched; a Search Set = 0 means
the entire database will be searched.
• Display Set - identifies which set will be displayed when you press F6.
• Workspace Remaining - identifies the amount of free storage space remaining.
CD-ROM User's Manual Page 3-18
-------
TRI FACT SHEETS - KAuare2 (tin) FullText V1.52
Search ft Docunent #1 of 1 Line-1 of 385
Content: Cannon Name: Benzyl Chloride
Comon Mane:
CAS Umber:
DOT MtHfcer:
Date:
Benzyl Chloride
100-44-7
UN 1738
August 1, 1987
HAZARD SUWARY
* Benzyl Chloride can affect you when breathed in.
* Because this is a NUTAGEN, handle it as a possible cancer
causing substance UITH EXTREME CAUTION.
* Benzyl Chloride *ay damage the developing fetus.
* Benzyl Chloride is a CORROSIVE CHEMICAL and contact can burn
the eyes.
* It is extremely irritating to the eyes, nose and throat.
Higher levels May cause a buiIdup of fluid in the lungs
(pulnonary edeaa). This can cause death.
IDENTIFICATION
I T /PgUp/PgDn=Move ENTER=Actiori Menu ESC=Backup F2 thru F5=Exit
Ctrl PgUp/PgDn=New Document •N'osted Note Ctrl «-*
This function key will display one of the following choices, depending on your selection
from the Display Set option (F2 = Options): Search Set, Last Set Created, or Selected Set.
Display Set = ???, at the bottom of the screen, identifies the set that is displayed when you
press F6.
3.2.7 F7=GROUP I, F8=GROUP t, F9=GROUPV Keys
F7=Group I. F8=Group t. F9=Group V - These options are used to search for specific
data when terms are listed through the F4 = Search option. Use these keys to group terms
together or to identify a specific term to retrieve.
To mark the beginning of a range of terms, move the highlight bar with the up and down
arrows to the first term to start the range and press < F7 >. A down arrow will appear next
to that item. Move the highlight bar to the last item in the range and press . An up
arrow will appear next to that item. If you need to select items individually that are not
related, highlight each individual desired item using the up and down arrows and press
. A check mark will appear next to each item selected.
After defining the group search using the F7, F8, and F9 keys, press to begin
the search. Each item contained in defined ranges (F7 and F8) or marked individually (F9)
will be searched one at a time, and the results combined to form a search set.
3.2.8 F10=EXITKey
F10=Exit - This option will exit you from the Fact Sheet option and return you to the Data
Base Selection Menu.
Page 3 - 19
CD-ROM User's Manual
-------
TRI FACT SHEETS - KAwareZ (tm) FullText V1.52
F1 = Help F2 = Options F3 = Select F4 = Search
TABLE OF CONTENTS
COMMON NAME
CAS NUMBER
TEXT
GLOBAL INDEX
F5 = Sets
Set #Found
(Page 1 of 1
Are you sure you want to exit? (Y/N)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REMAIN ING=256000
F6=Display F7=Group
F8=Group T F9=Group
F10=Exit ESC=Backup
Press < Y> to return to the Data Base Selection Menu. Press to return the TRI
Fact Sheets Main Menu.
3.2.9 ESC=BACKUP Key
ESC= Backup - This option will return you to the previous screen.
3.3 Conducting A Search For Fact Sheets
To assist you in searching for a specific Fact Sheet using the TRI CD-ROM Software, this
section will describe how to conduct a search, using a simple example. You can refer to
Sections 3.0 and 3.2, to review specific screens.
1 . Press < F3 > and decide which part of the file is most efficient to search.
Highlight the choice and press < ENTER > .
2. Construct the search based on fields to be searched and press < ENTER > .
For this example, you need to locate a Fact Sheet about the chemical, Methylene, as you are
concerned about health affects related to this chemical.
CD-ROM User's Manual
Page 3 - 20
-------
Once you have selected TRI Fact Sheets from the DATA BASE SELECTION MENU, you
can begin your search for a specific Fact Sheet. First, you will need to determine what
selection criteria you will use. For this example, we will use common name. Choose
"Common Name" from the F3 = Select option and press < ENTER >. The Common Name
Box is displayed. Suppose you are not sure how to spell the chemical, Methylene. Type
METH? and press < ENTER >. A box appears showing you all the chemical names that
start with the letters METH. Use the down arrow to highlight the correct chemical name,
Methylene, and press < ENTER >. Five Fact Sheets about methylene or related chemicals
can be displayed. Remember, because two chemicals have methylene in their names does
not necessarily mean the two chemicals are comparable for health effects.
Now that you have created a set for the chemical, methylene, suppose you also would like to
review material about methylene and health issues, specifically cancer concerns. You will
need to create a set, retrieving data on cancer issues. Then, combine the two sets together to
create a set that contains Fact Sheets on methylene and cancer issues. Let's explain how to
create these sets. Select the "text" choice from the F3 = Select option pull-down menu.
Type "cancer" and press < ENTER >. The TRI software will display that there are 323
Fact Sheets containing 996 occurrences of "cancer". You have now created two sets, which
are displayed on the screen. Next, you will need to combine these two sets. Select the F5
= Sets option pull-down menu. Choose the Combine Sets selection and highlight the
Combine With AND option and press < ENTER > and press < ENTER > again. Follow
the instructions to combine sets 1 (methylene) and 2 (cancer). Give the combined set a
name. This combined set becomes the third set on the screen.
3.4 Displaying Fact Sheets
To display the Fact Sheets about Methylene, select the F5 = Sets option and the pull-down
menu appears. Highlight the Display A Set selection and press < ENTER >. Enter #1 to
display the Fact Sheets for methylene. To display the combined set, showing methylene and
cancer issues, follow the same instructions but enter #3 as the set to display. As you move
through the text, the word, "Cancer", will be highlighted, to bring it to your attention. Use
the options displayed at the bottom of the screen to browse through the information.
Page 3-21 CD-ROM User's Manual
-------
When you display a Fact Sheet, there are several additional options that exist to enhance the
Fact Sheet. These options are displayed in the Action Menu and are accessed by pressing
< ENTER > while you are reviewing the Fact Sheet.
TRI FACT SHEETS - KAuare2 (tin) FullText VI.52
Search *1 Docinent «5 of 3 Line 1 of 412
Content: Cannon Name: Nethylene Chloride
Cannon Name:
CAS Hunter:
DOT Hunter:
Date:
Nethylene Chloride
75-09-2
UN 1593
May. 1989
HAZARD SUMMARY
* Methylene Chloride can affect you when breathed and by passing
through skin.
* Methylene Chloride should be handled as a CARCINOGEN WITH
EXTREME CAUTION.
* Exposure to high concentrations causes ^consciousness and
even death. Lower exposures can cause headaches, fatigue,
instead]ness and "drink" behavior.
* Exposure can irritate the lungs, causing a buildup of fluid
(pulmonary edema), a medical emergency.
* Long tern exposure may damage the liver and brain.
T/i/PgUp/PgDn=Move ENTER=Action Menu ESC=Backup F2 thru F5=Exit
Ctrl PgUp/PgDn=Neu Document ^Posted Note Ctrl «-/•*
3.5 Action Menu
When you display a set, there are several options available to enhance the display of the
data. These options are available in the Action Menu and are accessed by pressing
< ENTER > while you are viewing the information.
TRI FACT SHEETS - KAuare2 (tin) FullText VI.52
Search #1 Document #3 of 3 Line 1 of 412
Content: Common Name: Methylene Chloride
Common Name:
CAS Number:
DOT Number:
Date:
Methylene Chloride
75-09-2
UN 1593
May, 1989
HAZARD SUMMARY
* Methylene Chloride can affect you when breat
through skin.
* Methylene Chloride should be handled as a CA
EXTREME CAUTION.
* Exposure to high concentrations causes uncon
even death. Lower exposures can cause headac
unsteadiness and "drink" behavior.
* Exposure can irritate the lungs, causing a buildup of fluid
(pulmonary edema), a medical emergency.
* Long term exposure may damage the liver and brain.
SEARCH (alt-s)
BEGIN MARK (alt-m)
CANCEL MARK (esc)
PRINT BLOCK (alt-p)
SAVE BLOCK (alt-d)
NOTE PAD (alt-n)
BACK-UP (alt-b)
CHANGE DOCUMENT (alt-r)
TOGGLE DISPLAY (alt-t)
T/l/PgUp/PgDn=Hove ENTER=Action Menu ESC=Backup F2 thru F5=Exit
Ctrl PgUp/PgDn=New Document -5=Posted Note Ctrl «-/•»
CD-ROM User's Manual
Page 3 - 22
-------
To perform any of the selections in the Action Menu, use the up and down arrows to choose
one of the selections. Once the highlighted bar is on the correct choice, press < ENTER >.
You also can activate any of the selections in the Action Menu by pressing the keys
displayed next to the choice. These keys are known as "Hot Keys". For example, to
search, press the and the keys simultaneously to activate the search capability.
For example, you may wish to search other Fact Sheets for a word that appears in the Fact
Sheet you are viewing. Highlight the word you wish to search and press the and
the < s > keys simultaneously. A new search set containing Fact Sheets in which the
highlighted word also appears will be created and displayed automatically. You can use
these "Hot Keys" to activate a selection directly from the Fact Sheet without requesting the
Action Menu. If you are in the Action Menu and do not wish to activate any of the
selections, press to leave the Action Menu.
3.6 Printing or Saving Fact Sheets
Once you have viewed the Fact Sheet information, you may want to keep it. You can use
the print option to retain information. Access the F5 = Sets pull-down menu. Select the
Print A Set choice. Enter the set number you would like to print to your local printer and
press < ENTER >. The TRI software will display the message, "Now sending Set # to
printer. ESCAPE cancels printing". If you press , the screen will display the
message, "Printed Set is Interrupted. Press any key to continue". You will leave the print
option. If you do not press , Fact Sheet information will be printed on your
printer.
NOTE: Caution! Each Fact Sheet may be several pages in length.
3.7 Save Set List
There will be certain situations where you will create fact sheet sets that you would like to
save in order to retrieve these sets at a later date. Set lists contain all the user defined sets.
If you do not request a set to be saved, it will be erased when you exit from the TRI
software and will have to be recreated. Saving a set avoids this problem. To save a set,
access the F5 = Sets pull-down menu. Highlight the Save Set List option and press
< ENTER >. The Save Set List Screen is displayed below:
Page 3 - 23 CD-ROM User's Manual
-------
F1 = Help
TRI FACT SHEETS - KAuareZ (tm) FullText VI.52
F2 = Options F3 = Select F4 = Search
F5 = Sets
Set
1
2
3
#Found
3/3
3/10
3/13
(Page 1 of 1)
Save with what name on C
(or include a drive spec)
(Ctrl -PgUp/PgDn changes Set List page)
SEARCH SET=3 DISPLAY SET=3 WORKSPACE REHAINING=255997
F6=Display F7=Group i F8=Group T F9=Group ^ F10=Exit ESC=Backi4>
Make sure you save the correct set list. The name will appear on the screen. If this name
or drive is incorrect, modify it and press to save the set. The suffix, .SSL, is
provided to the set list file.
NOTE: It is recommended that set lists be saved to the C drive for easy retrieval. If you
save your set lists to a drive other than the C drive, copy your set lists to the TRI directory
on the C drive (c:\TRI).
3.8 Load Set List
Use the Load Set List option to retrieve a Fact Sheet set list that you have saved, as
described in Section 3.7, Save Set List. Access the F5 = Sets pull-down menu. Highlight
the Load Set list option and press < ENTER >. Enter the set number you want to retrieve
and press < ENTER >. The set will appear on the screen and is available for access.
CD-ROM User's Manual
Page 3 - 24
-------
4.0 Toxics Release Inventory
Data Base
This chapter describes in detail the steps used to search for data and display and print the
results from these searches. It also illustrates techniques for designing your own reports,
downloading data, and performing calculations on data sets that are of interest to you.
4.1 Choosing a Data File
The Toxics Release Inventory data base is produced on two CD-ROM discs. Disc One
contains TRI submissions for 1987-1990, while Disc Two contains records from 1991-1993.
Each of the discs can be used independently, or you can search the discs consecutively to
identify longitudinal trends that have occurred since the inception of TRI. In addition to the
data files, the CD-ROMs contain retrieval software that provides the capability to search for
specific data on toxic chemicals released into the environment by manufacturing facilities.
This software was transferred to your hard disk during the installation process.
To begin using TRI, insert either Disc One or Disc Two into the CD-ROM drive. Change to
the subdirectory where software for accessing that disc was installed. (The default directory,
unless another directory name was chosen during the installation process, is called TRI.)
Type TRI < ENTER > to retrieve the DATA BASE SELECTION MENU, shown below:
Toxics Release Inventory CO-ROM
Highlight your choice below and
press ENTER.
1 Chemical Substance Fact Sheets
2 Toxics Release Inventory 1987-90
3 Toxics Release Inventory 1991-93
4 Calculate Releases (KASTAT)
5 Quit TRI CD-RON Disc
United States Environmental Protection Agency
CD-ROM User's Manual
Page 4 - 1
-------
Using the cursor key, highlight 2 Toxics Release Inventory 1987-1990 or 3 Toxics Release
Inventory 1991-1993 and press < ENTER > . (Most of the examples shown throughout this
manual are based on the 1991-1993 TRI contained on Disc Two.)
If the disc present in the CD-ROM drive does not match your selection, a message
instructing you to change discs and press < ENTER > will appear on the screen.
Depending on your selection, one of two screens will be displayed:
TRI
RELEASES 1987-90
ENVIRONMENTAL PROTECTION AGENCY
For Information and Assistance:
TOXIC RELEASE INVENTORY USER SUPPORT
(202)360-1531
tm
KAwareF RETRIEVAL SYSTEM
copyright (c) 1985-91
Knowledge Access International
Nomtain View. CA 94043
PRESS ENTER TO CONTINUE
OR:
TRI
RELEASES 1991-93
ENVIRONMENTAL PROTECTION AGENCY
For Information and Assistance:
TOXIC RELEASE INVENTORY USER SUPPORT
(202)260-1531
KAwareF RETRIEVAL SYSTEM
copyright (c) 1985-91
Knowledge Access International
Mountain View, CA 94043
PRESS ENTER TO CONTINUE
Page 4 - 2
CD-ROM User's Manual
-------
Press < ENTER > and the DATA FILES SCREEN will be displayed:
KAuareF (t») Retrieval Systea / Fielded V3.11E
Select Data File or Press F4
RELEASES
TREATMNT
tm
KAuareF RETRIEVAL SYSTEM
copyright (c) 1985-91
Knowledge Access International
Mountain View, CA 94043
F2 = Shell F4 = New Path F10 = Quit ESC = Exit ALT-C = Colors
The DATA FILES SCREEN lists the names of the two files, RELEASES and
TREATMNT, that comprise the TRI:
The RELEASES file is the most frequently-used file. This file provides
comprehensive facility identification and chemical information. Use this file
when searching for specific data on releases to the air, water, land,
underground injection wells, publicly owned treatment works (POTWs,
commonly called sewer plants) and offsite locations. The Releases file also
describes pollution prevention methods, including waste reduction and
recycling activities, employed by the facility. Examples of use could include
searching for chemicals that were released in your town/community or into
specific bodies of water like the Chesapeake Bay or Lake Erie. Searching
RELEASES would also reveal transfers of chemical wastes to local POTWs or
offsite commercial facilities by name (for example, transfers to ABC Waste
Management Company) or by location (such as off-site locations in Houston,
Texas).
The TREATMNT file is used to search for data on waste treatment methods and
efficiency, and waste minimization. It is generally more effective to conduct a
search of the RELEASES file, then replicate the search in TREATMNT if
waste treatment information is also desired.
CD-ROM User's Manual Page 4 - 3
-------
To select a data file, use the cursor to highlight either RELEASES or TREATMNT and
press < ENTER >. (Because it is the most commonly used file, many of the examples
shown in this chapter are based on searching fields from the RELEASES file. Because the
same software is used to retrieve data from both files, the same techniques can be used for
searching the TREATMNT file, as well.)
The DATA FILES SCREEN displays several options, described below, at the bottom of the
screen:
F2 = Shell - This option allows you to return to DOS. You would use this option to
locate the drive and the directory where your data files are located. Once you are at
the TRI directory prompt, you will see the message, "Type EXIT to return to
KAwareF." Type and press < ENTER > to return to the TRI software.
F4 = New Path - This option allows you to change to the path and directory where
data files are located. When this option is selected, the TRI Current Drive box, is
displayed:
KAwareF (tM) Retrieval System / Fielded V3.11E
Welcome to KAwareF
Current Drive is:
E:\TRIFIELD\
Select Data Files fro* which
Drive and Directory? If you
are unsure where your files
are located, you nay press F2
and Shell to Dos to find the*.
then type EXIT for KAwareF.
KAwareF RETRIEVAL SYSTEM
copyright (c) 1985-91
KnowIedge Access International
Mountain View, CA 94043
F2 = Shell
F4 = New Path
F10 = Quit
ESC = Exit
ALT-C = Colors
Page 4-4
CD-ROM User's Manual
-------
The path for the TRI files on the CD-ROM, is displayed, and the option to change the drive
and directory by typing in new information is provided. If your system is properly
configured to use the TRI data base, the path shown should contain the correct letter assigned
to the drive where the TRI CD-ROM is located and the directory name TRIFIELD (e.g.,
E:\TRIFIELD\). If necessary, type the specified directory and file name and press
< ENTER >.
If an incorrect path is entered, the message "Are you sure you want to exit ? (Y/N)" is
displayed. If that happens, press N < ENTER > and reenter the correct path, substituting
the correct letter for the CD-ROM drive based on your configuration.
F10 = Quit - For this option, a box is displayed:
KAwareF (tin) Retrieval System / Fielded V3.11E
Welcome to KAuareF
Current Drive is:
E:\TRIFIELD\
Select Data Files froa which
Drive and Directory? If you
are unsure uhe
are located,
and Shell to D
then type EXIT
Are you sure you want to exit?
KAuareF RETRIEVAL SYSTEM
copyright (c) 1985-91
Knowledge Access International
Mountain View, CA 94043
F2 = Shell
F4 = Hew Path
:10 = Quit
ESC = Exit
ALT-C = Colors
Press < Y> to return to the DATA BASE, SELECTION MENU. A similar screen
containing the telephone number for TRI User Support will appear. Press < ENTER > to
continue. Otherwise, press to return to the DATA FILES SCREEN.
ESC = Exit - For this option, the ESC key performs the same function as the F10 key and
will display the Exit TRI Data Base Screen (as described above). Proceed in the same
manner as described for the F10 = Quit option.
ALT-C = Colors - When you press the Alt and C keys simultaneously, the screen will
change from color to black and white. Press the keys again simultaneously to return the
screen to color.
CD-ROM User's Manual
Page 4-5
-------
4.2 Overview of Conducting A Search
To conduct a search of TRI data, there are several simple steps. You will need to SELECT
the data elements for the specific information you need, SEARCH for specific values related
to those data elements, DISPLAY the data, and PRINT the data for later viewing or
EXPORT (download) the data to other software formats. Use of the function keys for
performing each of these operations is described in subsequent sections of this chapter.
NOTE: To obtain all the data for a single record, you must search both data files
(RELEASES and TREATMNT), either by searching by the EPA submission number or using
the same search criteria, if it is based on data elements common to both files. The EPA
submission number is the unique record identifier that links records from the two files
together. Common data elements that can be used to search both files include all facility
information, chemical name and CAS number, and reporting year. To make the search
easier, when you have completed the search with the first file, print the screen with the set
list (using the print screen key on the keyboard). You can then use this print screen copy to
duplicate the search for the other remaining file. The TRI software does not provide a way
to merge data from the RELEASES and TREATMNT files to create a single, consolidated
file. Instead, you can export the same records from each file in the same format and merge
them using dBase or other software.
After you have selected a specific data file by pressing < ENTER >, the TRI DATA FILES
MAIN MENU associated with the file that you have chosen is displayed automatically. If
you selected the RELEASES file, the following DATA FILES MAIN MENU is displayed:
TRI - KAuareF (to) Fielded V3.11E
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set ffFowd (Page 1 of 1)
EPA SUBMISSION NUMBER
TRI FACILITY ID
REPORTING YEAR
EPA REGION
FACILITY NAME
FACILITY CITY
FACILITY COUNTY
FACILITY STATE
FACILITY ZIP CODE
CASRN
(1 of 88)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=0
F6=0isplay F7=Groi4>
F8=Groi4> T F9=Group
F10=Exit ESC=Backup F6=Display
Page 4-6
CD-ROM User's Manual
-------
If you have chosen the TREATMNT file, 1.he following DATA FILES MAIN MENU will
appear:
TRI - KAwareF (ta) Fielded V3.11E
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set fFoini (Page 1 of 1)
EPA SUBMISSION NUMBER
TRI FACILITY ID
REPORTING YEAR
EPA REGION
FACILITY NAME
FACILITY CITY
FACILITY COUNTY
FACILITY STATE
FACILITY ZIP CODE
CASRN
(1 of 16)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=0 WORKSPACE: 256000
F6=0i splay F7=Group I F8=Gro^> T F9=Groi4>
F10=Exit ESC=Backip
4.3 Using Function Keys for Searching TRI
Several options in the form of function keys are displayed on the top and bottom of the
screen. Some of these options have pull-down menus associated with the them.
NOTE: To remove a pull-down menu associated with a function key option, press the
function key for that option and the pull-down menu will toggle off. Press the same function
key to toggle the pull-down menu back on.
CD-ROM User's Manual
Page 4 - 7
-------
Fl = Help - This option provides context-sensitive help at any time during the program.
The HELP option pull-down menu is displayed below:
TRI - KAuareF to exit from
HELP and return to the function that you were using.
Page 4 - 8
CD-ROM User's Manual
-------
F2 = Options - This option allows you to modify the default settings for the search, display,
and output features of the retrieval software, The OPTIONS pull-down menu is displayed
below:
F1 = Help
Set Wound
TRI - KAuareF (t«) Fielded V3.11E
F2 = Options F3 = Select F4 = Search F5 = Sets
Search Set:
Group Search:
Post Search:
Output Set:
Output Format:
Non-Label Print Foniat:
Output Order:
Printout Title:
Printer Options
Save Current Settings
ENTIRE DATABASE (SET 0)
GROUP ONLY
RETURN TO SELECT (F3)
LAST SET CREATED
RELEASES
CONSECUTIVE PRINT
DEFAULT ORDER
TRI
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=0
F6=Oi splay F7=Group I F8=Group T F9=Group
F10=Exit ESC=Backup
When the cursor is on a specific selection in the OPTIONS menu, press < ENTER > to
toggle through all of the choices for that selection. To save your selections, use the down
arrow to Save Current Settings. Press < ENTER >. The new settings will now become the
default settings until they are changed again using the F2 key or for that session only using
the F5 = Sets key.
F3 = Select and F4 = Search - These options are used to formulate and conduct a search.
These keys are explained in greater detail in Section 4.4, Searching For TRI Data.
F5 = Sets - This option allows you to refine your search and presentation of the results by
saving and printing the data. Options changed using the F5 key remain changed for that
search session only, unlike settings that are changed then saved using the F2 = Options key.
See Section 4.5, Refining the Search, for more information.
F6 = Display - This option allows you to view the results of a search record by record. It is
described in more detail in Section 4.6, Displaying Search Results.
F7 = Group I. F8 = Group t and F9 = Group V - These options allow you to indicate
specific terms from the index in order to refine your search. For a detailed description of
how to use these options, see Section 4.4.1, Indexing of Data.
CD-ROM User's Manual
Page 4 - 9
-------
F10=Exit - If you press F10 at any time during a search session, a dialog box will appear
with the message "Are you sure you want to exit? (Y/N)" Press to exit TRI and
return to the DATA BASE SELECTION MENU. Press to return to the TRI DATA
FILES MAIN MENU.
ESC=Backup - This option will return you to the previous screen.
4.4 Searching For TRI Data
Searching for TRI data is the primary function for using the TRI system. Conducting a
search is a two-step process. First, you need to determine which field or fields in the data
base to search and then indicate the values of the fields that you identified. For example,
you might decide to search by facility city. You would then indicate that "Boston," for
example, is the city for which you are searching. The keys that you would use to
accomplish these two steps are F3 = SELECT and F4 = SEARCH, respectively.
F3 = Select - This option displays all of the fields used to search for data in the TRI data
files. The SELECT menu for the RELEASES file is displayed below:
TRI - KAwareF (tin) Fielded V3.11E
F1 = Help F2 = Options F3 = Select F4 = Search
fS = Sets
Set *Fowd (Page 1 of 1)
EPA SUBMISSION NUMBER
TRI FACILITY ID
REPORTING YEAR
EPA REGION
FACILITY NAME
FACILITY CITY
FACILITY COUNTY
FACILITY STATE
FACILITY ZIP CODE
CASRN
(1 of 88)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=0
F6=0isplay F7=Group 1 F8=Grotp t F9=Grot^> V F10=Exit ESC=flackup
The RELEASES SELECT option lists 88 fields that may be used to build search criteria.
Searchable fields include the reporting year; facility name; facility location by zip code, city,
county, or state, etc.; chemical name; release medium, i.e., air, water, etc.; amount of
releases (in pounds); and many other fields. Use the PgDn key to scroll through all of the
search field choices.
Page 4 - 10
CD-ROM User's Manual
-------
The SELECT menu for the TRI TREATMl^T data file is displayed below:
F1 = Help
F2
TRI - KAuareF (t*) Fielded V3.11E
Options F3 = Select F4 = Search
F5 = Sets
Set fFound (Page 1 of 1)
EPA SUBMISSION NUMBER
TRI FACILITY ID
REPORTING YEAR
EPA REGION
FACILITY NAME
FACILITY CITY
FACILITY COUNTY
FACILITY STATE
FACILITY ZIP CODE
CASRN
(1 of 16)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=0
F6=Display F7=Grocp 1 F8=Group T F9=Gro^> J F10=Exit ESC=Backip
There are a smaller number of fields to search for information with the TREATMNT file
than with the RELEASE file. For the TREATMNT file, the SELECT option lists 16 fields
for use in building search criteria. Identifying information about the facility, e.g., its name,
address, etc., is included in both files (RELEASES and TREATMNT)for searching across
files to obtain an entire record. Use the PgDn key to scroll through all of the search field
choices.
F4 = Search - This option is directly related to the choices highlighted in the pull-down
menus for the F3 = Select option. When you designate F3 = Select and choose a field, the
TRI software will automatically present the corresponding pull-down menu for option F4 =
Search. These two options are the core of the searching capabilities for the TRI Data Files.
To leave this option, press < ESC >.
There are numerous fields for searching and various pull-down menus associated with
specific search fields. Two sample fields are shown below to explain the searching
capabilities of the TRI software. The first example appears in both the RELEASES and
TREATMNT files:
REPORTING YEAR - This choice provides the option to select from the reporting
years for which data is available. Use the down arrow to identify reporting year on
the pull down menu for F3 = Select and press < ENTER >. The F4 = Search
menu listing all of the reporting years available on the disc in use will appear
automatically (see screen below). Use the down arrow again to highlight 1993 as the
year of choice (if you are using Disc Two) and press < ENTER >.
CD-ROM User's Manual
Page 4- 11
-------
(Note that searching by reporting year is slower than most other searches because it
will retrieve about 80,000 records for any given year if you are searching the entire
data base. However, it is very useful if you are interested in calculating total annual
releases by chemical substance or if you are using the reporting year to narrow an
earlier search. See 4.5, Refining the Search.)
TRI - KAuareF (t») Fielded V3.11E
F1 = Help F2 = Options F3 = Select F4 = Search
REPORTING YEAR
1991
1992
1993
F5 = Sets
Set #Fomd (Page 1 of 1)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=0
F6=Display
F8=Grotp T
F10=Exit ESC=Backup
Page 4 - 12
CD-ROM User's Manual
-------
TREATMENT METHOD/SEQUENCE - This data element from the TREATMNT
file provides a list of 76 types of treatment methods. To search by treatment method,
highlight that data element on the pull down menu associated with the F3 = Select
function and press < ENTER >. The F4 = Search menu listing 76 types of
treatment methods will appear automatically. Use the PgDn key to scroll through the
list of methods until you reach, as an example, Reuse As Fuel - Other. Press
.
TRI - KAuareF (t») Fielded V3.11E
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set #Fouid
TREATMENT METHOD/SEQUENCE
FLARE
FLARE
FLARE
CONDENSER
SCRUBBER
ABSORBER
ELECTROSTATIC PRECIPITATOR
MECHANICAL SEPARATION
OTHER AIR EMISSION TREATMENT
BIOLOGICAL TREATMENT -- AEROBIC
(1 of 76)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=0
F6=0isplay F7=Grotp
F8=GrM*> T
F10=Exit
NOTE: Some search tables display a search term or phrase more than once. Always choose
the first occurrence, as the second and third occurrences will result in a null set.
4.4.1 Indexing Of Data
The two examples above illustrate searches where the value that you are seeking is selected
from a table that displays a limited number of choices, for example, the years 1987-1990 or
1991-1993. However, there will also be instances when you will want to enter the value by
which to search from the keyboard.
For many fields, the software allows you to type a term, partial term (followed by a question
mark (?)), phrase, or boolean expression. This is possible because every word in the data
base has been indexed. The example below illustrates this capability.
CD-ROM User's Manual
Page 4 - 13
-------
FACILITY NAME - To search by facility name, use the down arrow to highlight facility
name on the F3 = Select menu and press < ENTER >. The pull down menu for F4 =
Search appears:
TRI - KAwareF (tin) Fielded V3.11E
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set ffFound (Page 1 of 1)
FACILITY MANE
Enter a Tens, Partial Ter» followed by a ?,
Phrase, or Boolean Expression (F1 for Help):
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=0
F6=Display F7=Group i F8=Groit> T F9=Groip V F10=Exit ESC=Backip
There are two methods to obtain the correct results when searching by facility name.
The first method requires you to know the exact name of the facility. Enter the complete
name in the space provided. For example, type Monsanto and press < ENTER >. The
TRI software will search for records where the individual word(s) in the facility name appear
in the facility name field exactly the way you typed it (disregarding capitalization) and
respond with a set number and the number of records matching the search criteria. If the
value that you entered is not found, a box will appear that displays facility names that closely
match the characters you have entered. Select the correct name and press < ENTER >.
NOTE: Fields are word-indexed only. If you enter a phrase, e.g., "General Electric", the
TRI software searches for the words "General" and "Electric." There is no proximity
searching. Therefore, a search for "General Electric" will retrieve records for "General
Electric Co." and "General Dynamics Corp. Electric Boat Div." These two companies are
unrelated. When entering multiple words for facility name, you may retrieve records that
contain only one of the words in the facility, as well as records for facilities using the
complete name. This may also result in retrieval of certain irrelevant records. For example,
if you search for Du Pont Waynesboro Plant, you will receive all records with either Du
Pont or Waynesboro in the facility name. To retrieve records for the Du Pont plant located
in Waynesboro only, search first by Dupont then Waynesboro, then combine the two
searches using the boolean operator AND (see 4.5, Refining the Search).
Page 4 - 14
CD-ROM User's Manual
-------
The second method is to use the indexing capability within the TRI software. All fields in
the TRI data base files are indexed. When searching for specific data, it is important to use
the index feature to assist you. An example of a search where you will benefit from the use
of the index is when you are looking for records where a term could consist of many
variations. If you are unsure of the spelling of name, the indexing feature will allow you to
browse through possible names. To illustrate this feature, suppose you would like to retrieve
data on the facility name, "General Motors.' First, you should search on the complete
name, "General Motors." In addition, there are various abbreviations used for General
Motors, such as GM, GMC or General Motors Company. Using the partial term option,
type followed by a question mark (?) (e.g., GM?) and press . The
message, "Searching" appears. A listing of facility names that start with the letters "GM"
will appear.
This shows the index entries retrieved by GM? using the 1987-1990 disc:
TRI - KAuareF (tin) Fielded V3.11E
F1 = Help F2 = Options F3 == Select F4 = Search
FACILITY NANE
GM
GN-BOC
GN-DELCO
GNB
GMC
GMC-CPC
GMC-DAYTON
CMC-FLINT
GMC-SAGINAU
GMC-VANDALIA
(1 of 12)
Set *Found (Page 1 of 1)
1 1790 FACILITY NANE: MONSANTO
F5 = Sets
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=1 WORKSPACE: 254210
F6=Display
F10=Exit ESC=Backi4>
CD-ROM User's Manual
Page 4 - 15
-------
Here is the list retrieved by the same search term (GM?) for the 1991-1993 disc:
TRI - KAuareF (tin) Fielded V3.11E
F1 = Help F2 = Options F3 = Select F4 = Search
FACILITY NAME
GH
CMC
GHP
GHPT
F5 = Sets
Set
1
Wound (Page 1 of 1)
781 FACILITY NAHE: MONSANTO
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=1
F6=Display
F8=Group T F9=Group V F10=Exit ESC=Backi^>
Since there are many variations for the term GM, you can use the grouping capability in the
TRI software to group together all the GM information you need. The function keys, F7,
F8, and F9 are used to group terms together. You would use the grouping keys when you
have decided what information is needed.
F7= Group I. F8= Group t. F9= Group V - These options are used to search for specific
data when you want to group searched terms together or to identify a specific term to
retrieve.
To mark the beginning of a range of consecutive terms, move the highlight bar with the up
and down arrows on the keyboard to the first term to start the range and press < F7 > . A
down arrow will appear next to the item. In our example of the GM terms for 1987-1990,
mark GM with the F7 key. Move the highlight bar to the last item in the range that you
want and press . An up arrow will appear next to that item. In our example, mark
GMC-Vandalia with the F8 key. All the items contained between this range will be searched
and listed individually or combined into sets. If you need to select items individually that are
not listed consecutively, highlight each individual item using the up and down cursor keys
and press . A check mark will appear next to each item selected.
When all items are marked, press < ENTER > to begin the search. If you want to expand
your search, you can request information on the terms, General or Motor, using the question
mark (?) as part of your search criteria. If you create more than one set of search criteria,
you can combine these sets together to obtain a complete set. Combining sets is discussed in
Section 4.5, Refining the Search.
Page 4 - 16
CD-ROM User's Manual
-------
4.5 Refining the Search
F5 = Sets - This option allows you to enhance the sets of data you create. The SETS pull-
down menu is displayed below:
TRI - KAtuireF (tin) Fielded V3.11E
F1 = Help F2 = Options F3 = Select F4 = Search F5 = Sets
Set fFound (Page 1 of 1)
1 781
2 16598
3 17
FACILITY NAME: MONSANTO
FACILITY STATE: CA
COMBINE: MONSANTO III CA
Change Output Set
Change Search Set
Coobine Sets
Delete a Set
Delete All Sets
Display a Set
Export a Set
Load Set List
Print a Set
Remove Empty Sets
Save Set List
Select New Data File
Temp Exit to DOS
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=3
F6=0isplay F7=Group I F8=Group T F9=Group V F10=Exit ESC=Backup
There are various selections for this option which assist you in creating, printing, and
displaying sets. Several examples are displayed below.
Change Output Set - This selection changes the output set number, that is, the set that
will be displayed on the screen when you press F6=Display to display a record. The
current output set number appears at the bottom of the screen (above the function key
options). The set number entered must be zero or correspond to a set that you have
already created. Zero (0) will cause the first record in the entire data base to be
displayed when you press F6. The default setting for the output set number is the last
set created (see 4.3, F2 = Options). The output set number changes automatically
each time that you conduct a new se
-------
Change Search Set - This selection allows you to change the specific set number to
assist in searching for information. If you do not specify a set, the TRI software will
search the entire data base file (Search Set=0) . Once the search set is changed,
you must change it back to zero (0) if you wish to resume searching the entire
database file. Using the Change Search Set option saves time and memory space, as
the software searches only records contained in the set identified as the search set, not
the entire data base. Using the example described previously, you could search for
the 1993 reporting year and Monsanto for the facility name. Search for the 1993
reporting year first. Press < F5 >. Select Change Search Sets and press
< ENTER >. Type the set number you want to search and press < ENTER >.
Then search for Monsanto. The actual search often takes less time than using the
Combine Sets option described below.
Combine Sets - This selection allows you to combine user-defined sets with additional
conditions of AND, OR, or NOT. You would use this Combine Sets option
(Combine with OR) to combine all the sets that were created in our example of GM
in Section 4.4.1. To understand the difference between these three conditions, let us
use an example for each condition. For purposes of this example, assume that you
have already created one set containing records for facilities reporting releases of the
chemical substance benzene and a second set for facilities of the Monsanto
Corporation.
• Combine Set 1 (Benzene) AND Set 2 (Monsanto) - The TRI software will
search the data base for records meeting both conditions; that is, Monsanto
facilities that report releases of the chemical substance benzene.
• Combine Set 1 (Benzene) OR Set 2 (Monsanto) - The TRI software will search
the data base and retrieve either records submitted by Monsanto regardless of
the chemical substance or records for benzene releases regardless of the source
of those releases. Records meeting both conditions would also be retrieved.
Page 4-18 CD-ROM User's Manual
-------
Combine Set 1 (Benzene) but NOT Set 2 (Monsanto) - The TRI software will
search the data base for records that meet the first condition but not the second
condition. For example, this search would retrieve records identifying
benzene releases except for benzene releases reported by Monsanto. NOTE:
When combining with NOT, you will obtain different results depending on
which condition (or set) you sipecify first.
TRI - KAuareF (t>) Fielded V3.11E
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set *Fowd (Page 1 of
1 781
2 16598
3 17
FACILITY HA
FACILITY ST
COMBINE: HO
Select an Operator:
CoBbinn Uith AM):
Coofcine Uith OR:
Coufcine Uith NOT:
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=3
F6=Display
V
F10=Exit
Select the condition by moving the highlight bar and press < ENTER >. Set
numbers are displayed on the search screen under the SET category. In the set box,
type the first set number, press < ENTER >, type the second set number, press
, etc., until all the set numbers to be combined have been identified.
Press < ENTER > one additional time. You may give this newly created set a
name. If you do not give the set a name, the software will generate a name
automatically.
Delete a Set - This selection allows you to delete a specific set. Once you have
requested a deletion, that set will be highlighted on the screen to indicate that it has
been deleted.
Delete All Sets - This selection allows you to delete all sets containing search results
at once. When you use this option, the system will ask you to confirm that you wish
to delete all sets. If you answer YES by typing < Y> to the erasure of all sets, you
will no longer be able to access any user-defined sets. All user-defined sets will have
to be recreated. If you answer NO by typing , no sets will be erased. (To
save records for a particular search before deleting all sets, see Section 4.8.1,
Exporting Sets.)
CD-ROM User's Manual
Page 4-19
-------
Display a Set - This selection allows you display any user-defined set.
TRI - KAuareF (tin) Fielded V3.11E
F1 = Help F2 = Options F3 = Select F4 = Search F5 = Sets
Set fFound (Page 1 of 1
1 781
2 16598
3 17
FACILITY MAM
FACILITY STA
COMBINE: NON
Enter the number
of the set to be
used:
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=3
F6=0isplay F7=Group 1 F8=Group T F9=Group V F10=Exit ESC=Backup
Type the number of the user-defined set to be displayed and press < ENTER >. If the set
number you have entered does not correspond with a set number displayed, the field in the
box erases the value you have entered and displays a blank. Enter the correct set number.
Export a Set - This selection allows you to export a set to be used with other software. Six
format options are provided: 1) comma-delimited; 2) fixed field; 3) dBase; 4) Lotus; 5) WP
Merge; and 6) print-to-disk. (For a more detailed description of each of these formats and
how to use the export function, see Section 4.8.1, Exporting Sets.) Enter the number of the
set to be saved for exporting and the path and file name, if it is to be saved on the hard disk.
If you wish to save the file to a drive other than the hard disk, enter the drive letter as well.
A message will appear telling you the set has been saved.
Load Set List - This selection allows you to load a set list that you have previously saved.
When you load a set list, the current set list will be erased unless it was previously saved.
Enter the path and file name for the set list that you wish to load and press < ENTER >.
The set list will appear on the screen just as though you had just finished searching the data
base. (See Save Set List on the following page for more information.)
Print a Set - This selection allows you to print a set to a local printer. Enter the set number
to be printed. You may print complete records or selected fields from the records in the set.
You may also sort the records by designated data elements. (See Section 4.7, Printing
Results, for more information.) If the set number you have entered does not correspond to
an existing set number, the field in the box erases the value you have entered and displays a
blank. Enter the correct set number. The set will be printed on a local printer.
Page 4 - 20
CD-ROM User's Manual
-------
Remove Empty Sets - This selection will rewrite your set list to remove sets that do not
contain any records if, for example, you had conducted an unsuccessful search earlier.
Save Set List - This selection allows you to save a set list to any drive so that you can
retrieve it at a later date.
It is important to distinguish between Saving a Set List and Exporting a Set. When you save
a set list, you are preserving the search strategies and "record pointers" for earlier retrievals
so you can build on them later (e.g., by combining them). When you export a set, you are
manipulating the actual records retrieved as a result of conducting a search. Using the
earlier example, if you conducted searches for the chemical benzene, then Monsanto
facilities, and finally, combined those searches to create a third set, the three searches
together would comprise a set list. If you saved the set list, you could later reload the set
list and continue the session by creating a fourth set, then a fifth, etc. However, none of the
actual TRI records representing benzene, Monsanto, etc., would be saved. To preserve the
actual search results, that is the TRI records reported for benzene, Monsanto, etc. you would
have to EXPORT each set one set at a time. See also Section 4.8, Downloading TRI Data.
Select New Data File - This selection returns you to the SELECT DATA FILES SCREEN
to select another data file. Press to return to the DATA FILE MAIN MENU.
Exercising this option will cause you to lose; any sets that you have already constructed.
Temp Exit to DOS - This selection allows you to temporarily exit to DOS. When you are
finished using DOS and wish to return to TRI where you left off, type at the
DOS prompt and press < ENTER >. (NOTE: This selection appears on the screen if Temp
Exit to DOS was selected during the installation process.)
4.6 Displaying Search Results
After you have conducted a search, a summary of the search results (including the set
number, the number of records found, and a description or name of the search) will appear
on the screen. You will notice a status line at the bottom of the screen, which highlights the
Search Set, Output Set, and Workspace.
• Search Set - identifies which set is being searched. Search Set = 0 (the
default setting) means that the entire database will be searched. It may be
changed to narrow a search using the Change Search Set option on the F5 =
Sets menu, as outlined in Section 4.5. Remember, if you wish to resume
searching the entire data base;, you must change the search set back to zero.
CD-ROM User's Manual Page 4 - 21
-------
• Output Set - identifies which set will be displayed when you press the F6 key.
The number of the output set changes automatically each time you conduct a
new search, or you may change it to review an earlier search using the Change
Output Set option on the F5 = Sets menu, as outlined in Section 4.5.
• Workspace - identifies the amount of free space (in bytes) available for storing
search results (without saving sets) during a search session.
If you are satisfied with the search results after viewing the summary, you are ready to view
the actual records that resulted from it. Press F6 = Display. Or, if you wish to display
results of an earlier search, select F5 = Sets option and the pull-down menu appears.
Highlight the Display a Set selection and press < ENTER > . Enter the set number and
press < ENTER > . To view results of an earlier example, enter the set number for facility
name = Monsanto.
The third line of the RECORD DISPLAY SCREEN (under the function keys Fl, F2, etc.)
provides the name of the set you are currently reviewing. Directly below it, in the text box,
the first record in the set is displayed. The first line indicates the number of the record you
are viewing within the total records in that set as well as the line number in the record upon
which the cursor is presently resting. These numbers will be helpful as you navigate through
the display.
Each TRI record from the RELEASES file and the TREATMNT file requires 18 and 5
screens, respectively, to display in their entirety. Each line of data is preceded by a field
name that identifies the information reported. In many instances, the field name is
abbreviated. For instance, Facility D & B represents the Dun & Bradstreet Number assigned
to the reporting facility. A complete list of the data elements is provided as an appendix to
this document and in the Quick Reference Guide distributed with the TRI CD-ROM discs.
In addition, definitions for each of the fields are contained on each disc in a file called
FIELDS. TRI.)
4.6.1 Reviewing Displayed Data
There are several other options to assist you in reviewing records. These options are
provided at the bottom of the screen when a record is displayed. These options are:
• 0-9=Speed - This option allows you to control the speed of reviewing all the
records in a set. Type 0 (stop) to 9 (fast) to scroll through the records. You
will notice that the records will scroll at different speeds, depending on the
number value that you have chosen. Type <0> to stop all scrolling.
• «- ->=Change Record - This option allows you to scroll down through the
records in a set by using the left arrow or to scroll up by using the right
arrow.
Page 4 - 22 CD-ROM User's Manual
-------
I t = Scroll Record - This option allows you to scroll through all the data
within the record displayed on the screen by using the down arrow to scroll
down and the up arrow to scroll up through the record.
4.6.2 Sorting of Data
Sorting data into the order in which you wish to view, print, or download records may be a
very important step in making the data more useful to you. For example, you may wish to
list reports in descending order by the amount of chemicals that are released into the
environment. Or, you may wish to rank all reports submitted for your locality by company
name, then by the name of the chemical reported. TRI is very flexible in allowing you to
order the output according your criteria.
The example we will use here will walk you through the steps for sorting data when you are
preparing to display a set using the Display a Set option on the F5 = Sets pull-down menu.
The same sequence of screens appear when you are printing and downloading records or
using the Action Menu described in the following section for viewing records.
Select Display a Set using the pull-down menu for F5 = Sets. In response to the screen
prompt, enter the number of the set that you would like to sort and press < ENTER >. A
screen will appear asking you to choose from among 10 options the order in which you
would like to have the data displayed. Choosing the first option, Display by Default Order,
will result in records sorted by their TRI submission number. (The TRI submission number
is a unique identifier assigned to each report as it is received at EPA's EPCRA Reporting
Center. It is comprised of 15 alphanumeric characters ending with the state abbreviation.)
You may also choose the facility name, its Location, the chemical name, or the volume of
releases. To make a choice, position the highlight bar over one of the options allowed and
press < ENTER >.
TRI - KAuareF (tut) Fielded V3.11E
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set #Found
1 781
2 16598
3 17
Display by Default Order
Display by FACILITY NAME
Display by FACILITY CITY
Display by FACILITY COUNTY
Display by FACILITY STATE
Display by FACILITY ZIP CODE
Display by SUBSTANCE KANE
Display by SUN ALL RELEASES TO ENVIRONMENT
Display by SUN POTW AND OFFSITE TRANSFERS
Display by User Defined Rank
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=3
F6=0i splay F7=Group 1 F8=Grotp T F9=Group
F10=Exit ESOBackif)
CD-ROM User's Manual
Page 4-23
-------
The last option on the list, Display By User Defined Rank, offers the greatest flexibility of
all. To demonstrate this alternative, position the highlight bar over User Defined Rank and
press < ENTER >. A list of the field names will be displayed. For each field that you
wish to sort by, position the highlight bar over the field name and press < ENTER >. Type
in a number representing the order by which you wish to sort. For example, if you want to
sort first by chemical name (Chem Name) then by the total amount of releases into the
environment (Sum All Releases), type 1 next to Chem Name and 2 next to Sum All Releases.
To sort Sum All Releases in descending order (highest releases to lowest releases), type 1
next to Chem Name and -2 next to Sum All Releases. Finally, use the up arrow to position
the highlight bar over End Rank Selections at the top of the list of data elements and press
< ENTER >. The TRI system will then sort the data.
Once you have sorted the data, you can select to view:
•RELEASES (all the fields in the record including blanks)
•RELEASES - BRIEF (all fields in the record containing data)
•USER SELECTED OUTPUT (gives you a list of fields that can be printed or viewed.
Using the cursor, highlight the first field that you would like to view and press < ENTER >.
Press < ENTER > to accept the number shown, or enter a new number and press
< ENTER >. Repeat this step for each field you would like to include, incrementing the
number assigned to each field (1, 2, 3, etc.). When you have finished selecting fields,
highlight End Output Selections at the top of the field list and press < ENTER >.)
Make your selection and press < ENTER >.
Page 4 - 24 CD-ROM User's Manual
-------
4.6.3 Action Menu
When you display a set, there are several options available to enhance the display of the
data. These options are available using the ACTION MENU which is accessed by pressing
< ENTER > while you are viewing a TRI record on the screen.
TRI - KAwareF (tut) Fielded V3.11E
F1 = Help F2 = Options F3 = Select F4 = Search
Set 2: FACILITY STATE: CA
F5 = Sets
RECORD f1 OF 16598
EPA SUBMISSION NO 1393070002035CA
TRI FACILITY ID 94587LQDRC700DE
REPORTING YEAR 1993
EPA
FACI
FACI
FACI
FACI
FACI
FACI
PUBL
FACI
FIPS CODE 06001
FEDERAL FACILITY COMMERCIAL
CAS NO 7664-93-9
CHEN NAME SULFUR1C ACID
GENERIC CHEN NAME
CHEN NIX COMPONENT MA
LINE 1 of 216
Add User Input to Current Record
Jinp to Record by Nunber
Print Current Record
Re-Rank Current Set
New Display Font
(press Alt-U during display)
(press Alt-J during display)
(press Alt-P during display)
(press Alt-R during display)
(press Alt-F during display)
0-9=Speed
*- -*=Change Records T J=Scroll Record ENTER=Action Menu
To perform any of the selections on the ACTION MENU, use the up and down arrows to
choose one of the selections. Once the highlighted bar is on the correct choice, press
< ENTER >. You also can activate any of the selections in the ACTION MENU by
pressing the keys displayed next to the choice. These keys are known as "hot keys." For
example, to search, press the and the keys simultaneously to jump to another
record. You can use these hot keys to activate a selection directly from the record display
without requesting the ACTION MENU. If you are using the ACTION MENU and do not
wish to activate any of the selections, press < ESC > to leave the ACTION MENU.
Add User Input to Current Record - This option will allow you to enter two 40 character
fields to the record you are viewing. When you later display, print, or export a set, you can
mark the user-defined fields to be included in the output.
CD-ROM User's Manual
Page 4 - 25
-------
Jump to Record by Number - If you wish to jump to another record within the set, highlight
that choice on the Action Menu and press < ENTER > or use the "shortcut" keys by
pressing the < ALT> and key simultaneously. The Jump Record box appears:
TRI - KAuareF and press < ENTER >. The 98th record in the search set will be displayed.
Print Current Record - The current record will print on your local printer.
Re-Rank Current Set - A pop-up menu allows you to choose any one of ten options for
changing the order of the records displayed to your screen.
New Display Form - Allows you to choose one of three formats for displaying data. You
can choose from RELEASES (all fields, including blanks), RELEASES - BRIEF (omits
blank fields), and USER DEFINED OUTPUT (allows you to choose which fields to display).
4.7 Printing Results
You can print a single record or a group of records (sets). Make sure you have a local
printer attached to your computer that is turned on and ready to begin printing.
To print a single record, press < ENTER > to display the ACTION MENU while viewing a
record on the screen. Use the down arrow to select Print Current Record and press
< ENTER >. The current record will print on your local printer.
Page 4 - 26
CD-ROM User's Manual
-------
To print a set of records, use the selections from the F5 = Sets option. Press . Use
the down arrow to choose Print a Set and press < ENTER >. Type the number of the set.
Using the example in this text, type the number of one of the sets that you have created and
press < ENTER >. Indicate the order in which data should appear. When the information
appears, use the down arrow to choose one of the three formats and press < ENTER >:
• RELEASES (all the fields in the record including blanks)
• RELEASES - BRIEF (all fields in the record containing data)
• USER SELECTED OUTPUT (gives you a list of fields that can be printed.
Using the cursor, highlight the first field that you would like to print and press
< ENTER >. Press < ENTER > to accept the number shown, or enter a
new number and press < ENTER >. Repeat this step for each field you
would like to include, incrementing the number assigned to each field (1, 2, 3,
etc.). When you have finished selecting desired fields, highlight End Output
Selections at the top of the field list and press < ENTER >.
Use the down arrow to choose Consecutive Print or One Page At a Time. Check your
printer and press < ENTER > when you are; ready to print. Consecutive Print will result in
one record printing after another, without regard to page breaks. Selection of One Page at a
Time will cause each record to begin printing at the top of a new page.
4.8 Downloading from TRI
If you would like to download from TRI to reformat data or use it with another software
program, you can use one of two methods provided by the TRI software. One way is to
EXPORT your sets, using the Export A Set option provided on the F5 = Sets pull-down
menu. You can export sets into any one of several widely used formats, including comma
delimited (ASCII) format, fixed field, dBASE (.dbf), or Lotus (.wks), or WP Merge (.sec)
formats. You can also export data exactly as it appears on the computer screen (print to
disk). Each of these formats are described in greater detail below (see 4.8.1).
In addition, the TRI CD-ROM provides a special capability for downloading data according
to your particular specifications using a special feature called the Form Designer. (See
Section 4.8.2.) Note that you must use the Form Designer, not Export a Set, when
downloading data elements from records containing repeating fields. For example, a single
facility may report up to six SIC codes representing industries in which it participates. In
order to capture all six possible occurrences (not just the first), use the Form Designer and
designate all six SIC Codes for inclusion in your report (see Section 4.8.2).
CD-ROM User's Manual Page 4 - 27
-------
4.8.1 Exporting Sets
We will use the same set example that was used for printing (please refer to Section 4.7,
Printing Results to review the example). Press to retrieve the pull-down menu for
the F5 = SETS option. Use the down arrow to choose Export a Set and press < ENTER >.
Type the number of one the sets created as an example set and press < ENTER >.
The next screen allows you to choose one of following five formats for downloading data:
Comma-Delimited - This format is the most flexible for using with a variety of other
software. Data is saved in one long string. Text in each field is enclosed in quotes and
fields are separated by comas (for example, "ABC Manufacturing Facility","1065 Davidson
Pike","Andersonville", "IN" "78856-9976","","", "Benzene"). The system automatically adds
the suffix .csv to the filename that you specify when you save data.
Fixed-Field - Data is saved in one long string. Each field begins in the same position in
each record. Unlike comma-delimited format, fields appear in the export set exactly as they
are in the TRI record, including blanks at the end of the field (for example, ABC
Manufacturing Company 1065 Davidson Pike Andersonville IN 78856-9976
Benzene). The system automatically adds the suffix .fff to the filename
that you specify when you save data.
dBase - Data is saved in the data base format required by dBase IV programs. (Files created
using the dBase export format do not always work with earlier versions of dBase. In order
to use dBase III to manipulate data from TRI, create a new format using the Form designer
and export the form to be used in dBase III.) The system automatically adds the suffix .dbf
to the file name that you specify when you save data. In order to use the Calculate Releases
feature, you must first create and export a file in dBase format (see Chapter Five).
Lotus - Data is saved in the spreadsheet format required by Lotus 1-2-3 programs. The
system automatically adds the suffix .wks to the file name that you specify when you save
data.
WP Merge - This format saves data in the format used by Word Perfect for use as a
secondary file for printing form letters, etc. Records contain the codes required by Word
Perfect. The system automatically adds the suffix .sec to the file name that you specify
when you save the data.
Page 4 - 28 CD-ROM User's Manual
-------
Print to Disk - Data is saved on your disk exactly as it would appear on your screen,
including field tags and with each data element beginning on a new line. The system
automatically adds the suffix .p2d to the filename that you specify when you save data. An
example of the print to disk format is shown below:
FACILITY NAME ABC Manufacturing Company
FACILITY ADDRESS 1065 Davidson Pike
FACILITY CITY Andersonville
FACILITY STATE IN
FACILITY ZIP CODE 78856-9976
PUBL CONTACT/PHONE
CAS NO
CHEM NAME Benzene
After you choose the output format from among the options described above, a screen
allowing you to choose the order for sorting the records will appear. Choose one of the ten
options allowed. (See 4.6.2 for a more detailed description of the sort options.)
A menu will appear allowing you to choose from among three options:
• RELEASES - Use this option with caution. It saves all fields in the record,
including blank fields. The resulting file may be very large, depending on the
data format that you have chosen. (For example, a sample file containing 100
RELEASES records in dBase format required 717,981 bytes of disk space.)
• RELEASES (BRIEF) - This format is often preferred for screen displays and
the print to disk export option. This choice is not recommended for
downloading. It saves only those fields containing data, causing records to
vary in content and length from one to another. This may cause a problem
later if you try to import the downloaded data into other software.
• USER SELECTED OUTPUT - This option allows you to choose which fields
to download. Press < ENTER > to display a list of all fields. Using the
cursor, highlight the first field that you would like to print and press
< ENTER >. Press < ENTER > to accept the number shown, or enter a
new number and press < ENTER >. Repeat this step for each field you
would like to include, incrementing the number assigned to each field (1, 2, 3,
etc.). When you have finished selecting desired fields, highlight End Output
Selections at the top of the field list and press < ENTER >.
Type the name of the file to export and the path, if it is different than the path currently
displayed. As an example, type <93FELE> and press < ENTER >. The system will add
a suffix to the file name based on the format you have chosen for the data.
CD-ROM User's Manual Page 4 - 29
-------
4.8.2 Form Designer
As described in earlier sections, the TRI software provides two standardized formats for
printing and exporting data called RELEASES and RELEASES (BRIEF). You can also
create a User Defined Format at the time you are printing or exporting the set. In addition,
there is a fourth option which allows you to create your own customized format and save that
format to use again and again. This option is called the Form Designer.
It is essential that you use the Form Designer when you wish to download partial
records that include fields that occur more than once hi a single record. Examples of
fields that may occur more than once in a single record are the Standard Industrial
Classification (SIC) and SIC Code, both of which may be present up to six times in each
record. (To identify other fields with multiple occurrences, refer to the list of fields in the
back of the Quick Reference Guide.) If you are downloading complete records, you can use
the RELEASES option, but it may require a lot of disk space. If records containing
repeating fields such as SIC are downloaded using the RELEASES (BRIEF) option or a User
Defined Format (which is different from the Form Designer explained in this section), each
record is a different length. When you try to import them into other software, you will find
that additional occurrences of fields like the SIC code displace other data, resulting in fields
containing the wrong data. The Form Designer prevents this from occurring by saving space
for the additional occurrences in each record, regardless of whether or not data are actually
present.
If you plan to download data that requires use of the Form Designer, design the form first,
before performing the search. (If you have already performed your search, you can use F5
= Sets to Save Set List. After creating the form, use Load Set List to recreate your search
in one easy step.) As you create a new form, you will give it a name of your choosing.
After you have finished designing the form and exit the Form Designer, you will search the
RELEASES or TREATMNT file to create the set that you wish to download. Then, press
F5 = SETS, choose Export A Set, and follow the instructions in Section 4.8.1. This time,
the form that you created using the Form Designer will appear with the other report formats.
Before you begin to use the Form Designer, you should consider first how you wish the data
to appear, as you would when you create a report. It is especially important that you decide
which fields the report should include and in what order you would like them listed. You
may find it helpful to layout an example of the form first, before actually creating it on the
computer.
To illustrate how to use the Form Designer, we will create a Form called "Toxic Releases by
Facility and Industry." It will list, for every record in the search set we designate, the name
of the reporting facility, the chemical released, the sum of all releases into the environment,
and up to six SICs representing industries in which that facility is involved.
Page 4 - 30 CD-ROM User's Manual
-------
In order to use the Form Designer, you must exit the TRI CD-ROM. To exit, press F10.
Enter < Y> to confirm that you wish to exit the system. Use the down arrow to highlight
Quit TRI CD-ROM Disc on the DATA BASE SELECTION MENU and press
< ENTER >.
At the DOS prompt, type KADFDES @ followed by the complete path and the name of the
file from which you wish to download data. For example, if you are using the Releases file
that was installed in a directory called TRI, it should look like this:
C:\TRI>KADFDES ©Releases
If the form you are designing will contain data from the Treatmnt file and installed, for
example, in a directory called TRI, enter:
C:\TRI> KADFDES ©Treatmnt < ENTER >
The initial screen for the Form Designer will appear:
Version 1.30 KAuare Disk Publisher/Fielded
2:49 pi
KADF Fora Des i finer for file releases
Ippi FAW5
2 RELEASES (BRIEF)
Fora Information
Fora Umber: 2=
Fora Nane: RELEASES (BRIEF)
Fora Type: P
Page Width: 76 Page Length: 60
Kaxiiui Lines:
Use cursor pad to choose fora, then select operation.
F1=Help F2=Oelete F4=Edit F5=Add F6=Insert F7=Copy F8=Nove
ESC=Henu
The first time that you use the Form Designer, only the RELEASES and RELEASES
(BRIEF) or TREATMNT and TREATMNT (BRIEF) forms will be listed in the text box
called the FORM LIST in the upper left-hand corner of the screen. After you have used the
Form Designer to create your own reports, the names of the forms that, you created will be
added to the list.
CD-ROM User's Manual
Page 4 - 31
-------
Press to add a new form. A new window will appear in the center of the screen (see
below). Following the step-by-step directions provided, you will Specify Form Information,
Design Page Detail, Preview Form (if desired), and finally, Save Changes.
Version 1.30
KAuare Disk Polisher/Fielded
2:50 pa
KADF Fora Designer for file releases
Fora Information
Fora Ninber: 3j|
Form Name:
Fora Type: P
Page Width: 76
HaxiauB Lines:
Page Length: 60
Specify Fora Information
Design Page Header
Design Page Detail
Preview Fora
Display Fora Design
Print Fora Design
Save Changes
Specify fora information
F1=Help ESC=Oone
With the cursor highlighting Specify Form Information, press < ENTER >. The window
will disappear, leaving the screen below. Next to the Form Name, enter the report title as
you would like it to appear on your Form and press < ENTER >. For this example, we
will call our report "Toxic Releases by Facility and Industry." If you plan to use paper
measuring something other than 8 1/2" by 11", press . You will then have the
option of changing the default settings for page width (76 spaces) and page length (60 lines).
Version 1.30
KAuare Disk Pii>lisher/Fielded
2:52 pa
KADF Fora Designer for file releases
Fora Information
Fora limber: 38
Fora Naae: Toxic Releases by Facility and Industry!
Fora Type: P
Page Width: 76 Page Length: 60
Haxiaua Lines:
Enter a unique naae for this fora.
F1=Help Tab=Prev Enter=Next
F10=Edit Finished ESC=Cancel Edit
Page 4 - 32
CD-ROM User's Manual
-------
Press < F10 >. The same window as before reappears in the center of the screen:
Version 1.30 KAuare Disk Publisher/Fielded 2:54 pi
KADF Form Designer for file releases
Fora Information
Fora Nuifcer: 3=
Fora Nane:
Fora Type: P
Page Width: 76
Haxioui Lines:
Page Length: 60
Specify Fora Information
Specify Fora Information
Design Page Header
Design Page Detail
Preview Fora
Display Fora Design
Print Fora Design
Save Changes
F1=Help ESC=Done
CD-ROM User's Manual
Page 4 - 33
-------
Using the down arrow, highlight Design Page Detail and press < ENTER >. A new screen,
PAGE DETAIL FOR FORM, will appear. Press < ENTER > and the PAGE DETAIL
LIST window in the upper left will be replaced by the DATA FIELD menu in the lower
right. (See the example below.)
The DATA FIELD menu lists a mnemonic tag for each of the data elements in the TRI file
that you are using. In order to determine the meaning of a mnemonic tag, you must select it
by highlighting it and pressing < ENTER >. The complete field name will then appear as
the Item Label. If, after viewing the complete field name, you wish to choose another field
instead, pres ESC and < ENTER >. The DATA FIELD menu will reappear, allowing you
to make another selection. (See Appendix B for a description of each of the fields in the
RELEASES and TREATMNT files.)
Version 1.30
KAuare Disk Polisher/Fielded
2:55 pa
KADF Fora Designer for file releases
Page Detail for form
Item Hunter: 1
Data Field: amii
Item Label:
Label Ron: +1 Label Column:
Data Ron: +0 Data Column:
Data Width: Max i nun Lines:
Data Justification: L
Wrap Rule: D Wrap Column:
Hissing Data Rule: 0 Missing Value:
First Array Elonent: Last Array Element:
Array Display Rule: Array Separator:
1 Data Field i
1 A1 SUBN
2 A1 TRIM
3 T6 YR
4 T3 EPAR
5 T5 FCOV
6 A1 FNM
7 A1 FAD
8 A2 FCTY
9 A2 FCO
10 A1 FST
Select the field used for this item. Use cursor pad to scroll choices.
F1=Help Tab=Prev Enter=Next F10=Edit Finished ESC=Cancel Edit
For our example, the first data element we wish to choose is facility name (FNM). To select
it, highlight number 6, FNM, and press < ENTER >.
Page 4 - 34
CD-ROM User's Manual
-------
The mnemonic tag (FMN) will appear on the screen next to Data Field and Facility Name
will be shown as the Item Label. Press < ENTER > to accept the Item Label as shown or
edit it as you would like it to appear on your report. The screen below shows the Item Label
after it was changed from Facility Name to Reporting Facility.
Version 1.30
ICAuare Disk Publisher/Fielded
Enter the text to use for labeling this item.
F1=Help Tab=Prev Enter=Next F10=Edit Finished
2:56 pm
KADF For* Designer for file releases
Page
Detail for form
I tea Nunber: 1
Data Field: FNH ^^^^^^^^^^^=
Label Row: +1
Data Row: +0
Data Width: 60
Data Justification: L
Wrap Rule: D
Missing Data Rule: 0
First Array Element:
Array Display Rule:
Label Coluon: 1
Data Column: +2
Maxima Lines:
Wrap Column:
Missing Value:
Last Array Element:
Array Separator:
ESC=Cancel Edit
Press < ENTER > repeatedly to accept default settings for the row, column, etc. until the
cursor is positioned on Missing Data Rule. A pull-down menu highlighting several choices
for Missing Data Rule will appear, as shown below:
Version 1.30
ICAuare Disk Publisher/Fielded
2:56 pa
KADF Form Designer for file releases
Page Detail for form
Item Number: 1
Data Field: FNH
I tea Label: Facility Name
Label ROM: +1
Data ROM: +0
Data Width: 60
Data Justification: L
Wrap Rule: D
Missing Data Rule: L
First Array Element: Las
Array Display Rule:
Label Column: 1
Data Column: +2
Maximum Lines:
• Missing Data Rule <
L Label + value
V Value only
B Blank
0 Omit
Select the missing data rule of thi» field. Use cursor pad to scroll choices.
Fl=Help Tab=Prev Enter=Nexl: F10=Edit Finished ESC=Cancel Edit
CD-ROM User's Manual
Page 4 - 35
-------
Use the up arrow to move the cursor from O (Omit) to L (Label + value) and press
< ENTER >. Press < ENTER > again to pass Missing Value. That completes the detailed
description for Facility Name.
Press < F5 > to begin describing the second data element that you would like to appear on
your report. (Notice that the Item Number changes each time you press to identify a
new data element.) To continue with our example, select number 16, NAME, representing
the chemical. Follow the steps outlined above. When finished, press and follow the
procedure again to enter number 38, SENV (Sum All Releases).
The fourth data element that we identified for our sample report, Standard Industrial
Classification (SIC), is a little different because it can occur up to six times in a single
record. It is possible to include just selected occurrences, for example, just the first SIC
reported, or you can include all of the information, i.e., all six SICs or blank fields. For our
report, we decided to include all six SICs.
To choose all six, we will need to go through the process of defining SIC, similar to the way
we already defined facility name and chemical name, six times. To select SIC, press
. Choose number 33, SIC, from the DATA FIELD menu. For the Item Label,
change Standard Industrial Classification to Industry (1) to show that this is the first
industrial classification that was reported. Press < ENTER > repeatedly until Missing L
Rule is highlighted. This time, after you change the field from O (Omit) to L (Label +
value) and press < ENTER >, the cursor will highlight First Array Element. Press
< ENTER > to accept 1 (one) as the First Array Element. The cursor will move to Last
Array Element. Type < 1 > again and press < ENTER >.
Repeat this process five times for the additional SICs, using Industry (2), Industry (3), etc.
as the Item Label and changing the First Array Element and Last Array Element to 2, then
3, etc. (See the screen below, which shows the Page Detail for Form screen after the data
was entered for the sixth SIC. Note the Item Label, First Array Element and Last Array
Element all indicate that it is the sixth occurrence for that field.)
Page 4 - 36 CD-ROM User's Manual
-------
Version 1.30
KAuare Disk: Publisher/Fielded
2:59 pa
KADF Fora Designer for file releases
Page Detail for for*
I tea Umber: 3
Data Field: SIC
I tea Label: Industry (6)
Label Rou: +1 Label Column 1
Data Row: +0 Data Column +2
Data Width: 250 Naxinui Lines
Data Justification: L
Wrap Rule: D Wrap Colmn
Hissing Data Rule: L Hissing Value
First Array Element: 6 Last Array Element
Array Display Rule: 1 Array Separator ,
Enter the last array element to print: for this data field.
F1=Help Tab=Prev Enter=llext F10=Add Finished
ESC=Cancel Add
When you have finished, all of the data elements that you wanted on your report should be
listed in the box in the upper left hand corner of the screen:
Version 1.30
KAuare Disk Publisher/Fielded
3:03 pa
Page Detail List *
1 PUM
1 rMPl
2 NAME
3 SENV
4 SIC
5 SIC
6 SIC
6 SIC
8 SIC
9 SIC
KADF Form Designer for file releases
Page Detail for form
Number: tM
a Field: SIC
m Label: Industry (6)
bel Row: +1 Label Column: 1
eit-a Drtu. -4.fi Rnt-n PtftliMn. *3
Data Uidth: 250 NaxinLB Lines:
Data Justification: L
Wrap Rule: D Wrap Co linn:
Missing Data Rule: L Missing Value:
First Array Element: 6 Last Array Element: 6
Array Display Rule: 1 Array Separator: ,
Use cursor pad to choose item, then select operation. F9=Previeu
F1=Help F2=Delete F4=£dit F5=Add F6=Insert F7=Copy F8=Move ESC=Menu
After you have verified that all desired data elements were defined, press . The
menu for entering specifications for your form will reappear in the center of the screen.
Move the down arrow to highlight Save Changes and press < ENTER >. You should see
the message "Forms being saved..." at the bottom of your screen.
CD-ROM User's Manual
Page 4 - 37
-------
Version 1.30
KAuare Disk Polisher/Fielded
3:03 p»
KADF For* Designer for file releases
For* Information
Fora Number: 3§i
Fora Nane:
Fora Type: P
Page Width: 76
Maxim* Lines:
Page Length: 60
Specify Fora Information
Design Page Header
Design Page Detail
Preview Fora
Display Fora Design
Print Fora Design
Save Changes
Save changes made so far
F1=Help ESC=Done
Press . You will return to the original FORM DESIGNER SCREEN. This time,
the Form List will include the title of the form that you just created. For our example, the
title, "Toxic Releases by Facility and Industry" was added to the Form List, as shown below.
Version 1.30
KAuare Disk Publisher/Fielded
4:20 pa
KADF For* Designer for file releases
1 RELEASES
2 RELEASES (BRIEF)
3 Toxic Releases by Facility and Industry
Fora Name: RELEASES
Fora Type: P
Page Width: 76 Page Length: 60
Maxima Lines:
Use cursor pad to choose form, then select operation.
F1=Help F2=Delete F4=Edit F5=Add F6=Insert F7=Copy F8=*ove ESC=Menu
This form is now ready to be used for displaying, printing, or exporting data, in accordance
with the instructions provided in Sections 4.6.3, 4.7, and 4.8.1.
Page 4 - 38
CD-ROM User's Manual
-------
Press to exit to DOS. At the DOS prompt, type TRI. This will retrieve the DATA
BASE SELECTION MENU. Choose 2 Toxics Release Inventory 1991-1993 and you are
ready to begin using the TRI data base again. When you have retrieved the TRI DATA
FILES MAIN MENU, proceed to perform the search that you would like to download or
print. Using the F5 = Sets option, choose; Export a Set or Print a Set. This time, in
addition to the other output formats, the name of your new form will appear:
TRI - KAuareF (ta) Fielded V1.35
F1 = Help F2 = Options F3 = Select F4 = Search F5 = Sets
Set
1
2
3
4
*Found
1702
11086
73
11
(
FAC
SUB
COM
REP
RELEASES
RELEASES (BRIEF)
Toxic Releases by Facility and Industry
User Selected Output
(Ctrl-PgUp/PsPn changes Set List page)
SEARCH SET=0 OUTPUT SET=4 WORKSPACE: 243128
F6=f)isplay F7=Group
F8=Group T F9=Group
F10=Exit ESC=8ackup
Use the down arrow to highlight the name of the form that you created. For our example,
we created "Toxic Releases by Facility and Industry". Press < ENTER > . Records in the
set will be displayed (or printed or exported) in the format that you designed, as the example
below illustrates.
TRI - KAnarel: (t») Fielded V1.35
F1 = Help F2 = Options F3 = Select F4 = Search F5 = Sets
Set 3: COMBINE: 1 AND 2
RECORD #1 OF 22
LINE 1 of 9
Facility Nane MONSANTO CO.
Cheaical BENZENE
Total Releases 1959613
Industry (1) INDUSTRIAL ORGANIC CHEMICALS. N.E.C.*
Industry (2) INDUSTRIAL INORGANIC CHEMICALS, N.E.C.*
Industry (3) SOAP AND OTHER DETERGENTS, EXCEPT SPECIALTY CLEANERS
Industry (4) PESTICIDES AND AGRICULTURAL CHEMICALS. N.E.C.*
Industry (5)
Industry (6)
0-9=Speed - -=Change Records T i=ScrolI Record ENTER=Action Menu
CD-ROM User's Manual
Page 4 - 39
-------
5.0 Performing Calculations
(KASTAT)
The calculation feature (also referred to as KASTAT) is used to compute the total amounts
for specific sets of data. With the calculation feature, you must use the RELEASES data file
which has numeric fields to retrieve information.
5.1 Calculating Data
KASTAT is a useful feature to obtain total release amounts. We will use the following
example to explain this feature. We would like to determine the total amount of chlorine
released in 1993 in the state of Delaware. Retrieve the following information first, before
using the calculation feature:
• Substance Name - Chlorine
• Facility State - DE
• Reporting Year - 1993
Follow the search and combine instructions to retrieve as set of records for the above
described criteria. Review Chapter 4, Toxics Release Inventory, to assist you.
Export the set you have created by performing the following steps:
1. Choose the set number < ENTER >.
2. Choose dBASE as the type of export file < ENTER >.
3. Choose default order < ENTER >.
4. Choose User Selected Output as the output format. Select the fields listed below
by entering a sequential number next to each. When you have entered a
field number for each of the chosen fields, scroll back to the top of the
window that lists all of the field names. Highlight End User Selections
and press < ENTER >.
- Field 1: Sum Air Releases (SAIR)
- Field 2: Sum Water Releases (SW)
- Field 3: Sum Land Releases (,SL)
- Field 4: Sum Underground Releases (SU)
- Field 5: Sum All Releases to Environment (SENV)
- Field 6: Sum POTW (Publicly Owned Treatment Works) Transfers (SPOTW)
- Field 7: Sum Offsite Transfers (SOFF)
- Field 8: Sum POTW and Offsite Transfers (SPO)
- Field 9: Sum Releases and Transfers (SRT)
CD-ROM User's Manual Page 5 -1
-------
5. Name the file by typing a name and pressing (e.g.,
a:93DE-CHL.DBF < ENTER>. The filename ending (beginning with the
period) must be .DBF or left blank. If it is left blank, the system will
supply the ending .DBF).
After the export has taken place, press to exit to the DATA BASE SELECTION
MENU.
Select 4 Calculate Releases (KASTAT) from the DATA BASE SELECTION MENU.
the down arrow to highlight Calculate Releases (KASTAT) and press < ENTER >.
Use
Toxics Release Inventory CD-RON
J
Highlight your choice below and
press ENTER.
1 Chemical Substance Fact Sheets
2 Toxics Release Inventory 1987-90
3 Toxics Release Inventory 1991-93
4 Calculate Releases (KASTAT)
5 Quit TRI CD-RON Disc
United States Environmental Protection Agency
A screen will appear requesting the name of the file containing the records for which you
would like to calculate releases. Type the name of the dbase file you just created. (It is not
necessary to include the file ending .dbf.)
KAuare (tm) Statistical Sumerizer V1.20
Computes, displays, saves, and prints statistics
for numeric fields in dBase (.DBF) export
format from the KAuareZ Fielded Retrieval System.
Name of file saved in dBase (.DBF) format? a:93DE-CHL
;e5-2
CD-ROM User's Manual
-------
There is one screen displayed for each field in the dBase file that you created. For our
example, which contained nine fields containing numbers representing release amounts, nine
screens were generated.
Use the right and left arrows to move from one screen to another. Press to print each
screen. When calculations are completed, a new file (.ANL) is created containing the screen
text. In DOS you can print the screen displays out from the ANL file (e.g., 93DE-
CHL.ANL for the example). Or, as the screens are displayed, press repeatedly eight
times, to receive a hard copy of each screen of information for the eight fields you have
selected.
There is no HELP (Fl) option available for the KASTAT selection, however, a description
of the feature can be viewed or printed from the CD-ROM disc, i.e., L:\>type
KASTAT\KASTAT.TXT. For a list of field labels for numeric fields that can be used for
performing calculations, type or print KASTAT\KASTAT.FLD.
The first of the nine screens, showing releases to air (SAIR), is shown below.
KAuare (t«) Statistical Sumnarizer V1.20
Computes, displays, saves, and prints statistics
for numeric fields in dBase (.DBF) export
format from the KAuareZ Fielded Retrieval System.
F1=Help -»=Hext «-=Previous P=Print ESC=Escape
File: 930E-chl.dbf
Number of Records: 11
Number of fields: 9
Umber of allowable numeric fields: 9
Field name: SAIR
Number of blanks: 5
Lowest: 150
Range: 10154
Mean with 0: 4453
Field number:
Zeros:
Highest:
Sum:
Mean u/o 0:
1
0
10304
26718
4453
Press ENTER for optional calculation of median and mode.
CD-ROM User's Manual
Page 5 - 3
-------
Press < ENTER >. Two new fields, Mean w/ 0 and Mean w/o 0 are added at the bottom of
the screen:
KAuare (tn) Statistical Suaoarizer V1.20
Computes, displays, saves, and prints statistics
for numeric fields in dBase (.DBF) export
format from the KAuare2 Fielded Retrieval System.
F1=Help -=Hext ^Previous P=Print ESC=Escape
File: 930E-chl.dbf
Number of Records: 11
Number of fields: 9
Ninber of allowable mineric fields: 9
Field name: SAIR
Ninber of blanks: 5
Lowest: 150
Range: 10154
Mean with 0: 4453
Median w/o 0: 3497.50
Field number:
Zeros:
Highest:
Sum:
Mean w/o 0:
Node w/o 0:
1
0
10304
26718
4453
5.2 Defining Records in a KASTAT Record
A brief description of each field (in alphabetical order) is presented below:
Field Name - The field which the calculation was performed on (SAIR - Sum of All
Releases).
Field Number - The number of the field that the calculation was performed on (field number
1 is SAIR).
File - The name of the dBASE file that was created (93DE-CHL.DBF).
Highest - The highest single release of Chlorine into the air in pounds (10304).
Lowest - The lowest single release of Chlorine to the air in pounds (150).
Mean with O - The average of the field for which the calculation is being processed,
including records reporting 0 (zero) pounds released to air (4453).
Mean W/O 0 - The average of the field for which the calculation is being processed without
records containing zeros in that field (4453).
Median w/o 0 - The middle number of the numbers reported for the field for which the
calculation is being processed, not including records reporting 0 (zero) pounds released to air
(3497.50). For example, if five records are processed, the third number is the median
Page 5 - 4
CD-ROM User's Manual
-------
Mode w/o 0 - The value that occurs most frequently of the numbers that are reported for the
field for which the calculation is being processed, not including records reporting 0 (zero)
pounds released to air (--).
Number of Allowable Numeric Fields - The number of numeric fields (9).
Number of Blanks - The number of records which had a blank or no data in that field (5).
Number of Reids - The number of fields k the record (9).
Number of Records - The number of records in the set of data for which calculations have
been performed (11).
Range - The difference between the highest and the lowest single release (10,304) (Highest)
- 150 (Lowest) = 10,154) pounds.
Sum - The total sum of the field on which the calculation is being processed in pounds
(26718).
Zeros - The number of zeros in the record (0).
Press to exit from the KASTAT record and to return to the DATA BASE
SELECTION MENU.
5.3 Special Keys
There are several special keys within the KASTAT option. There is one screen for each
field. To move forward through the screens, use the right arrow. To move backward, use
the left arrow. You can print each screen of data.
CD-ROM User's Manual Page 5 - 5
-------
APPENDIX A
-------
(IMPORTANT: Type or print; read instructions before completing form)
i-orm Approved UMb Numoer:
Approval Expires: 11/92
page 1 of 9
United States
Environmental Protection
Agency
FORM R
TOXIC CHEMICAL RELEASE
INVENTORY REPORTING FORM
Section 313 of the Emergency Planning and Community Right-to-Know Act of 1986,
also known as Title III of the Superfund Amendments and Reauthorization Act
TRI FACILITY ID NUMBER
Toxic Chemical, Category, or Genei
(nc Name^l
WHERE TO SEND
COMPLETED FORMS:
1. EPCRA Reporting Center
P.O. Box 3348
Merrifield, VA 22116-3348
ATTN: TOXIC CHEMICAL RELEASE INVENTORY
2. APPROPRIATE STATE OFFICE
(See instructions in Appendix F)
Enter "X" here if
this is a revision
IMPORTANT: See instructions to determine v/hen "Not
Applicable (NA)" boxes should be checked.
For EPA use only
PART I. FACILITY IDENTIFICATION INFORMATION
SECTION 1.
REPORTING
YEAR
19
SECTION 2. TRADE SECRET INFORMATION
2.1
2.2
Are you claiming the toxic chemical identified on page 3 trade secret?
Yes (Answer question 2.2;
Attach substantiation forms)
No (Do not answer 2.2;
Go to Section 3)
If yes in 2.1, is this copy:
Sanitized
Unsanitized
SECTION 3. CERTIFICATION (Important: Ftead and sign after completing all form sections
I hereby certify that I have reviewed the attached documents and that, to the best of
submitted information is true and complete and that the amounts and values in this
reasonable estimates using data available to the prepares of this report.
Name and official title of owner/operator or senior management official
Signature
Date Signed
my knowledge and belief,!
report are accurate based
•
SECTION 4. FACILITY IDENTIFICATION
4.1
Facility or Establishment Name TRf Facility ID Number |
Street Address
City |
State |
Mailing Address (if different from street address)
City |
State | Zip Code |
County
Zip Code
PUT LABEL HERE fl
CD-ROM User's Manual
EPA Form 9350-1 (Rev. 12/4/93) - Previous editions are obsolete.
APPENDIX A - 1
-------
Page 2 of 9
" CDA EPA FORM R
B o^S Protection pART 1. FACILITY IDENTIFICATION
onmenta, INFORMATION (CONTINUED)
TRI FACILITY ID NUMBER
Toxic Chemical, Category, or Generic Name
SECTION 4. FACILITY IDENTIFICATION (Continued)
4.2
4,3
4.4
4.5
4.6
•
4,8
4.9
4.10
This report contains information for:
(Important: check only one)
Name
Technical Contact
Name
Public contact
SIC Code
(4-digit) a
Latitude p^
ana
Longitude
a. An entire facility
b.
Latitude
Minutes
Dun & Bradstreet Number(s) (9 digi
EPA identification Number(s) (RCR4
(12 ch
Facility NPDES Permit Number(s)
(Q characters)
c. d.
Seconds Degrees
ts) a
b.
L l.p. Np.) a
aracters) .
a.
b.
Underground Injection Well Code (UIC) I.D. a
Number(s) (12 digits)
b.
b. Part of a facility
Telephone Number (include area code)
Telephone Number (include area code)
e. f.
Longitude
Minutes Seconds
SECTION 5. PARENT COMPANY INFORMATION
5,1
•
Name of Parent Company
DNA
Parent Company's Dun & Bradstreet Number
Q NA (9 digits)
CD-ROM User's Manual
APPENDIX A - 2
EPA Form 9350-1 (Rev. 12/4/93) - Previous editions are obsolete.
-------
Page 3 of 9
United States
Environmental Protection
Agency
EPA FORM R
PART II. CHEMICAL-SPECIFIC
INFORMATION
TRI FACILITY ID NUMBER
Toxic Chemical, Category, or Generic M
SECTION 1. TOXIC CHEMICAL IDENTITY
1.1
1.2
1.3
(Important: DO NOT complete this
section if you complete Section 2 below.)
CAS Number (Important: Enter only one number exactly as it appears on the Section 31 3 list. Enter category code if reporting a chemical category,)
Toxic Chemical or Chemical Category Name (Important: Enter only one name exactly as it appears on the Section 313 list.)
Generic Chemical Name (Important: Complete only if Part I, Section 2.1 is checked "yes." Generic Name must be structurally descriptive.)
SECTION 2 MIXTURE COMPONENT IDENTITY (lmPortant: DO NOT complete this
btUMUNA MlAlUHtuuMKUiMtm lutiM 1 1 1 Y section if you complete Section 1 above.)
2.1
Generic Chemical Name Provided by Supplier (Important: Maximum of 70 characters,
including numbersjetters, spaces, and
punctuation.)
SECTION 3. ACTIVITIES AND USES OF THE TOXIC CHEMICAL AT THE FACILITY ^^
(Important: Check all that apply.) ^|
3.1
3.2
3.3
Manufacture
the toxic
chemicat:
Process
the toxic
chemical:
Otherwise use
the toxic
chemical:
a.
b.
a.
b.
a.
b.
lie
Produce c.
Import d.
e.
f.
As a reactant c.
As a formulation component d.
As a chemical processing aid c.
As a manufacturing aid
•^^^
roduce or import:
For on-site use/processing
For sale/distribution
As a byproduct
As an impurity
As an article component
Repackaging
Ancillary or other use
SECTION 4. MAXIMUM AMOUNT OF THE TOXIC CHEMICAL ON-SITE AT ANY TIME
DURING THE CALENDAR YEAR
4.1
(Enter two-digit code from instruction package.)
EPA Form
editions are obsolete.
APPENDIX A - 3
-------
Page 4 of 9
3-EPA
United States
Protection
EPA FORM R
PART II. CHEMICAL-SPECIFIC
INFORMATION (CONTINUED)
TRI FACILITY ID NUMBER
Toxic Chemical, Category, o' Generic Name
SECTION 5. RELEASES OF THE TOXIC CHEMICAL TO THE ENVIRONMENT ON-SITE
5.1
5.2
5.3
Fugitive or non-point air
emissions
Stack or point air
emissions
Discharges to receiving
streams or water bodies
(enter one name per box)
5.3.1 Stream or Water Body Name
A. Total Release (pounds/
year) (enter range code from
instructions or estimate)
B. Basis of
Estimate
(enter code)
C.
% From
Stormwater
.2 Stream or Water Body Name
5.3.3 Stream or Water Body Name
5.4
5.5
5.5.1
5.5,2
5.5.3
Underground injections
on-site
NA
Releases to land on-site
Landfill
Land treatment/
application farming
Surface impoundment
Other disposal
NA
NA
EPA Form
Check here only if additional Section 5.3 information is provided on page 5 of this form.
Range Codes: A = 1 -10 pounds; B = 11 - 499 pounds,
editions are obsolete'
-------
Page 5 of'
United States
Environmental Protection
Agency
EPA FORM R
PART II. CHEMICAL-SPECIFIC
INFORMATION (CONTINUED)
TRI FACILITY ID NUMBER
Toxic Chemical, Category, or Generic Name
SECTION 5.3 ADDITIONAL INFORMATION ON RELEASES OF THE TOXIC CHEMICAL TO THE
ENVIRONMENT ON-SITE
5.3
5.3,_
Discharges to receiving
streams or water bodies
(enter one name per box)
Stream or Water Body Name
5.3, Stream or Water Body Name
5.3. Stream or Water Body Name
A. Total Release (pounds/
year) (enter range code from
instructions or estimate)
B. Basis of
Estimate
(enter code)
C. % From
Stormwater
SECTION
6. TRANSFERS OF THE TOXIC CHEMICAL IN WASTES TO OFF-SITE LOCATIONS
6.1 DISCHARGES TO PUBLICLY OWNED TREATMENT WORKS (POTW) ^^
6.1 .A Total Quantity Transferred to POTWs and Basis of Estimate ^^
6.1 ,A,1 Total Transfers (pounds/year)
(enter range code or estimate)
6.1. B POTW Name and Location Information
.1*8. -
Street Address
City j
State J
POTW Name j
County j
Zip Code |
6.1. A.2 Basis of Estimate
(enter code)
POTW Name |
6.1. D.
Street Address
City |
State j
County
Zip Code
If additional pages of Part II, Sections 5.3 and/or 6.1 are attached, indicate the total number
and indicate which Part II, Sections 5.3/6.1 page this is, here.
{example: 1, 2,3, etc.)
pages in this box
EPA Form
-UBev. 12/4/93) - Previous editions are obsolete.
Jser's Manual
Range Codes: A = 1 • 10 pounds; B = 11 - 499 pou
-------
Page 6 of 9
EPA FORM R
^lite
state,s,p ,„, „ PART II. CHEMICAL-SPECIFIC
-onmenta, Protection |NFORMAT|ON (CONTINUED)
TRI FACILITY ID NUMBER
Toxic Chemical, Category, or Generic Name
SECTION 6.2 TRANSFERS TO OTHER OFF-SITE LOCATIONS
Off-site EPA Identification Number {RCRA ilD No.}j
6.2. _
Off-Site Location Name j
Street Address |
City |
State | 2pC«te
A. Total Transfers (pounds/year)
(enter range code or estimate)
1.
2.
6°
County j
Is location under control of n
facility or parent company?
B, Base of Estimate
(enter code}
1.
2.
3.
4.
. .
jpoilmy
Yes No
C. Type of Waste Treatment/Disposal/
Recycfing/Eftergy Recovery (enter code)
1. M
2. M
3. M
4. M
SECTION 6.2 TRANSFERS TO OTHER OFF-SITE LOCATIONS
Off-sife EPA identification Number {RCRA ID No.) j
6.2 —
Off-Stte Location Name j
Street Address |
City |
State | Zip Code |
A. Total Transfers (pounds/year)
(enter range code or estimate)
1.
2.
3.
*
County j
Is location under control of re
facility or parent company?
B. Basis of Estimate
(enter code)
1.
2.
3.
4.
Yes No
C. Type of Waste Treatment/Disposal/
Recyciing/Energy Recovery (enter code)
1. M
2. M
3. M
4. M
11 additional pages of Part II, Section 6.2 are attached, indicate the totajjiumber of pages in this
box
and indicate which Part II, Section 6.2 page this is, here.
(example: 1, 2, 3, etc.)
EPA Form 93GID1-|f©Mm*^)s-M«riwd editions are obsolete.
Range Codes: A = 1 -10 pounds; B = 11 - 499 pounds
C ^KPHSH}Efinjte.- 6
-------
Page 7 of S
wEPA EPA FORM R
EntSnTa, Protection PART II. CHEMICAL-SPECIFIC
Agency INFORMATION (CONTINUED)
TRI FACILITY ID NUMBER
Toxic Chemical, Category, or Gener c Name
•
SECTION 7A. ON-SITE WASTE TREATMENT METHODS AND EFFICIENCY
Q Not Applicable (NA) - Check here if no on-site waste treatment is applied to any
waste stream containing the toxic chemical or chemical category.
a. General
Waste Stream
(enter code)
7A.1a
7A.2a
7A.3a
7A.4a
7A.5a
b. Waste Treatment Method(s) Sequence
[enter 3-character code(s)]
7A,1b 1
3
6
4
7
7A.2b 1
3
6
4
7
7A.3b 1
3
6
4
7
7A.4b 1
3
6
4
7
7A.5b 1
3
6
4
7
2
5
8
2
5
8
2
«
8
2
5
8
2
5
8
1
1
c. Range of Influent
Concentration
7A.1C
7A,2c
7A.3c
7A.40
7A.5c
d . Waste
Treatment
Efficiency
Estimate
7A.1d
%
7A.2d
%
7A.3d
%
7A.4d
%
7A.5d
%
e. Based on
Operating Data?
7A,1e
Yes No
7A.2e
Yes No
I ^1
^^^
7A.3e
Yes No
7A.4e
Yes No
7A.5e
Yes No
A
If additional
box
copies of pacie 7 are attached, indicate the total number of pages in this ^^
and indicate which page 7 this is, here.
(example: 1 , 2, 3, etc.)
EPA Form
editions are obsolete
APPENDIX A - 7
-------
xrEPA
«i
'
EPA FORM R
PART II. CHEMICAL-SPECIFIC
INFORMATION (CONTINUED)
Page 8 of 9
TRI FACILITY ID NUMBER
Toxic Chemical. Category, or Generic Name
SECTION 7B. ON-SITE ENERGY RECOVERY PROCESSES
Not Applicable (NA) - Check here if no on-site energy recovery is applied to any waste
stream containing the toxic chemical or chemical category.
Energy Recovery Methods [enter 3-character code(s)]
ft
SECTION 7C. ON-SITE RECYCLING PROCESSES
Not Applicable (NA) - Check here if no on-site recycling is applied to any waste
stream containing the toxic chemical or chemical category.
Recycling Methods [enter 3-character code(s)]
EPA Form 9$3JMHK»rt1EP^£-WaHaai editions are obsolete.
APPENDIX A - 8
-------
Page 9 of 9
United States
Environmental Protection
Agency
EPA FORM R
PART II. CHEMICAL-SPECIFIC
INFORMATION (CONTINUED)
TR! FACILITY ID NUMBER
Chemical, Category, or Generic Name
SECTION 8. SOURCE REDUCTION AND RECYCLING ACTIVITIES
All quantity estimates can be reported
using up to two significant figures.
Column A
1992
(pounds/yeur)
Column B
1993
(pounds/year)
Column C
1994
(pounds/year)
Column D
1995
(pounds/year)
8.1
Quantity released
8.2
Quantity used for energy
recovery on-site
8.3
Quantity used for energy
recovery off-site
8.4
Quantity recycled on-site
8.5
Quantity recycled off-site
8,6
Quantity treated on-site
8.7
Quantity treated off-site
8,8
Quantity released to the environment «ts a result of
remedial actions, catastrophic events, or one-time events
not associated with production processes (pounds/year)
8.9
Production ratio or activity index
8.10
Did your facility engage in any source reduction activities for this chemical during
the reporting year? If not, enter "NAn in Section 8.10.1 and answer Section 8.11.
Source Reduction Activities
[enter code(s)]
Methods to Identify Activity {enter codes)
8.10.1
a.
8.10,2
a.
b.
b.
c.
c.
8.10.3
a.
b.
c.
8.10.4
a.
b.
c.
8.11
Is additional optional information on source reduction, recycling, or
pollution control activities included with this report? (Check one box)
YES
Report releases pursuant to EPCRA Section 329(8) including "any spilling, leaking, pumping, pouring, emitting, emptying, discharging
injecting, escaping, leaching, dumping, or disposing into the environment." Do not include any quantity treated on-site or off-site.'
EPA Form 93
editions are obsolete.
APPENDIX A - 9
-------
APPENDIX B
-------
APPENDIX B
Toxics Release Inventory (TRI)
Data Element Descriptions
The abbreviation for each data element that appears on the screen
each time you search for a field or display a record appears in
brackets ([]) following the name of the field. For a list of data
elements in alphabetic order by abbreviation, see the Quick
Reference Guide.
Accidental Release Total [ACCIDENTAL REL] - Total quantity of
toxic chemical released resulting from events (accidental releases)
not associated with production processes.
Based on Operating Data [BASED ON OPER DATA] - Indicates whether
the waste treatment efficiency estimate is based on actual
measurements of the wastestream before and after treatment at the
reporting facility. A "no" means some other method was used, such
as manufacturers' specifications for the capabilities of the
treatment equipment.
Basis of Estimate (Land) [LAND REL/BAS]
Basis of Estimate (Non-Point) -NONPOINT AIR/BASIS]
Basis of Estimate (Offsite) [OFFSITE/BASIS]
Basis of Estimate (Point Air) [POINT AIR/BASIS]
Basis of Estimate (POTW) [POTW/BASIS]
Basis of Estimate (Underground) [UNO INJECT/BASIS]
Basis of Estimate (Water) [WATER/BASIS] - The method used to
estimate each release. Reporting facilities may use several
methods to estimate a release. The facility must report the
principal method used or the one used to derive the greatest
proportion of the release estimate. The codes are as follows:
M Based on monitoring data or measurements,
including direct measurements of the
concentration of the chemical in wastes,
discharges, or releases.
C Based on mass balance equations, which involve,
for example, determining the differences between
the amount of the chemical in streams entering
and leaving process equipment.
E Based on published chemical emission factors.
O Based on other approaches such as engineering
calculations.
CASRN [CAS NO] - The Chemical Abstracts Service Registry Number
(CASRN) consists of up to eight digits (and two hyphens) and
uniquely identifies a specific chemical substance. The number is
printed in hyphenated format: two to five digits, hyphen, two
digits, hyphen, one digit. For example, formaldehyde is 50-00-0;
chlorine is 7782-50-5. The CASRN is commonly used to index chemical
data and can be useful in locating other information about the
chemical. The CASRN may be withheld as a trade secret. A CASRN
CD-ROM User's Manual
APPENDIX B - 1
-------
will not be provided for mixtures or trade name products containing
an unidentified section 313 chemical. Chemical categories covered
by Section 313 do not have CASRNs because they include many
distinct chemical substances.
Centroid Latitude [CENTROID LATITUDE] - Centroid latitude in
degrees (3 digits), minutes (2 digits) and seconds (2 digits) is
the midpoint latitude of the area defined by the facility zip code.
This information was added by EPA to all submissions and is not
reported on EPA Form R. Though not as exact as site specific
latitude, it is useful for geographic mapping.
Centroid Longitude [CENTROID LONGITUDE] - Centroid longitude in
degrees (3 digits), minutes (2 digits) and seconds (2 digits) is
the midpoint of the area defined by the facility zip code. This
field is provided by EPA and is not reported on EPA Form R. Though
not as exact as site specific longitude, it is useful for
geographic mapping.
Controlled By [OFFSITE CONTROL BY] - This indicates whether the
reporting facility controls the off-site location to which it
transfers wastes.
Covered Facility [FACILITY COVERAGE] - A facility could submit a
report on releases of the section 313 chemical from the entire
facility at the location or on separate establishments within the
facility at that location. This data field indicates whether the
submission covers the entire facility or only an establishment
within the facility. If a submission covers only part of a
facility, several submissions may have to be considered to develop
complete information on the total releases of the chemical from the
entire facility. Two codes were used:
a An entire covered facility.
b A part of a covered facility.
EPA ID Number [EPA ID NUMBER] - An identification number assigned
by EPA to facilities subject to the Resource Conservation and
Recovery Act (RCRA). The number can be used to obtain information
from state and federal agencies on the type and amount of hazardous
wastes transferred to or from a facility.
EPA Region [EPA REGION] - Identifies in which of the 10 EPA regions
the reporting facility is located. EPA regions cover several
states and are the local contacts for information about EPA
programs.
Region 1 CT, MA, ME, NH, RI, VT
Region 2 NJ, NY, Puerto Rico, Virgin Islands-
VI
Region 3 DE, MD, PA, VA, WV, DC
Region 4 AL, FL, GA, KY, MS, NC, SC, TN
Region 5 IL, IN, MI, MN, OH, WI
Region 6 AR, LA, NM, OK, TX
Region 7 IA, KS, MO, NE
Region 8 CO, MT, ND, SD, UT, WY
Region 9 AR, CA, HI, NV, American Samoa-AS,
Guam-GU, Trust Territories-MP
Region 10 AK, ID, OR, WA
CD-ROM User's Manual
APPENDIX B - 2
-------
EPA Submission Number [EPA SUBMISSION NO] - A unique 15 character
alphanumeric string assigned by EPA to identify each report
received from a facility. The last two characters are the
abbreviation of the state of the reporting facility.
Facility City [FACILITY CITY] - City in which the reporting
facility is located.
Facility County [FACILITY COUNTY] - County in which the reporting
facility is located.
Facility D & B Number [FACILITY D & B] - Facility Dun and
Bradstreet Number consisting of nine-digits assigned to identify
specific businesses.
Facility Name [FACILITY NAME] - The name of the reporting facility.
Facility State [FACILITY STATE] - State in which the reporting
facility is located. Searchable by the two-letter U.S. Postal
Service Code.
Facility Street Address [FACILITY ADDRESS] - Street address of the
reporting facility.
Facility Zip Code [FACILITY ZIP CODE] - Zip code of the reporting
facility. Five- or nine-digit 2:ip codes are acceptable.
Federal Facility [FEDERAL FACILITY]
General Wastestream [GENRL WASTESTREAM] - Each wastestream that
enters the environment containing the chemical must be identified
separately on Form R. Wastes from several processes may be
combined into a single wastestream prior to treatment. If the
treatment process creates an additional wastestream, they will be
listed separately. For example, treatment of a liquid waste by
filtration may create a solid residue that is then treated; the
liquid and solid are listed as separate wastestreams on Form R.
Wastestream types are identified by the following codes:
A Gaseous
W Wastewater
L Liquid waste other than dissolved in water
S Solid waste.
Generic Chemical Name [GENERIC CHEM NAME] - Provided only if the
reporting facility has claimed the identity of the chemical as a
trade secret. The generic name must be descriptive of the chemical
structure.
CD-ROM User's Manual
APPENDIX B - 3
-------
Influent Concentration [INFLUENT CONCENTR] - The influent
concentration is the percentage of the waste made up of the
chemical as the waste enters the treatment process. This figure
includes only the section 313 chemical for which the report was
filed. For chemical categories, the concentrations are reported
for the parent chemical rather than for the entire compound. Note
that EPA requires reporting facilities to list only the
concentration of the chemical as it enters the wastestream. If the
wastestream is treated sequentially using different treatment
methods, the reporting facility may enter the initial influent
concentration for each treatment method, or may enter the actual
concentration when the method is applied, but is not required to
enter either for any treatment method except the first applied to
the wastestream. The codes used to identify the range of influent
concentration are:
1 Greater than 1 percent
2 100 parts per million (0.01 percent) to 10,000
parts per million (1 percent)
3 1 part per million to 100 parts per million
4 1 part per billion to 1 part per million
5 Less than 1 part per billion.
Land Disposal [LAND DISPOSAL] - Releases to land must be reported
by disposal methods. Four codes identify the disposal method used
for on-site disposal of reported quantities of the chemical to
land:
D02 Landfill
D03 Land treatment/application farming
D05 Surface impoundment
D99 Other disposal.
Land Release [LAND REL] - The reported number of pounds of a
chemical released to the environmental medium.
Latitude [LATITUDE] - Latitude of the reporting facility in degrees
(3 digits), minutes (2 digits), and seconds (2 digits). Optional
in 1987 reports.
Longitude [LONGITUDE] - Longitude of the reporting facility in
degrees (3 digits), minutes (2 digits), and seconds (2 digits).
Optional in 1987 reports.
Manufacturing [MANUFACTURING USES] - Manufacturing activities
involve the manufacture of the section 313 chemical or the
importation of the chemical into the United States by the reporting
facility. The chemical may be manufactured for use at the
reporting facility, for sale, as a byproduct, or as an impurity.
Multiple entries are possible:
Produce
Import
For on-site use/processing
For sale/distribution
As a product
As an impurity.
CD-ROM User's Manual
APPENDIX B - 4
-------
Maximum Amount On-Site [CHEM/MAX ON-SITE] - The maximum amount of
the chemical that was on-site at any one time during the reporting
year, including the amount present in processing equipment,
stockpiles, storage areas, and wastes. The amount is reported in
ranges. The codes for the ranges (in pounds) are:
01 0-99
02 100-999
03 1,000-9,999
04 10,000-99,999
05 100,000-999,999
06 1 million-9,999,999
07 10 million-49,999,999
08 50 million-99,999,999
09 100 million-499,999,999
10 500 million-999,999,999
11 1 billion or more.
Mixture Component ID [CHEM MIX COMPONENT] - A trade name, product
name or some other generic chemical name that the reporting
facility must provide when the facility knows that a section 313
chemical is present in the mixture, but does not know the exact
chemical identity of the chemical. This indicates that the facility
is processing or using a listed chemical in amounts that exceed the
threshold.
Non-Point Air Release [NONPOINT AIR REL] - The reported number of
pounds of a chemical released to the environmental medium.
NPDES Permit Number [NPDES PERMIT NO] - The National Pollution
Discharge Elimination System Permit Number issued by EPA under the
Clean Water Act to cover liquid discharges to surface water. The
permit number may be used to access information about the
facility's permit requirements and discharges. This information is
often available at state environmental regulatory offices and EPA
regional offices. The permit may not, however, address the
specific chemical being reported under section 313.
Off-Site City [OFFSITE CITY] - The city of the off-site facility to
which the reporting facility transfers waste.
Off-Site County [OFFSITE COUNTY] - The county of the off-site
facility to which the reporting facility transfers waste.
Off-Site Energy Recovery Current Year [OFFSITE ENERGY/CUR] - Total
quantity of toxic chemical in pounds used off-site for energy
recovery during the current reporting year.
Off-Site Energy Recovery Future Year [OFFSITE ENERGY/FUT] - Total
quantity of toxic chemical in pounds estimated to be used off-site
for energy recovery in future year.
Off-Site Energy Recovery Next Year [OFFSITE ENERGY/NEX] - Total
quantity of toxic chemical in pounds estimated to be used off-site
for energy recovery next year.
CD-ROM User's Manual
APPENDIX B - 5
-------
Off-Site Energy Recovery Percent Change, Prior/Current Year
[OFFSITE ENERGY/PCT] - Percent change in quantity of toxic chemical
used off-site for energy recovery comparing current and previous
year quantities.
Off-Site Energy Recovery Prior Year [OFFSITE ENERGY/PRI] - Total
quantity of toxic chemical in pounds used off-site for energy
recovery during previous year.
Off-Site Name [OFFSITE NAME] - The name of the off-site location
which receives waste from a reporting facility.
Off-Site Recycling Current Year [OFFSITE RECY/CUR] - Total quantity
of toxic chemical in pounds recycled off-site during current year.
Off-Site Recycling Future Year [OFFSITE RECY/FUT] - Total quantity
of toxic chemical estimated to be recycled off-site in future year.
Off-Site Recycling Next Year [OFFSITE RECY/NEX] - Total quantity of
toxic chemical estimated to be recycled off-site next year.
Off-Site Recycling Percent Change, Prior/Current Year [OFFSITE
RECY/PCT] - Percent change in quantity of toxic chemical used off-
site for recycling purposes comparing prior and current year
quantities.
Off-Site Recycling Prior Year [OFFSITE RECY/PRI] - Total quantity
of toxic chemical in pounds recycled off-site during previous year.
Off-Site State [OFFSITE STATE] - The location of the off-site
facility to which the reporting facility transfers waste.
Off-Site Street [OFFSITE ADDRESS] - The street address of the
off-site location to which the reporting facility transfers waste.
Off-Site Transfer Amount [OFFSITE TRANS AMT] - For each off-site
location, the total amount, in pounds, of the toxic chemical
contained in the waste transferred to that location for disposal,
energy recovery, recycling, or waste treatment.
Off-Site Treatment Current Year [OFFSITE TREAT/CUR] - Total
quantity of toxic chemical in pounds treated off-site for current
year.
Off-Site Treatment Future Year [OFFSITE TREAT/FUT] - Total quantity
of toxic chemical in pounds to be treated off-site in future year.
Off-Site Treatment Next Year [OFFSITE TREAT/NEX] - Total quantity
of toxic chemical in pounds to be treated off-site next year.
Off-Site Treatment Percent Change, Prior/Current Year [OFFSITE
TREAT/PCT] - Percent change in quantity of toxic chemical treated
off-site comparing prior and current year quantities.
CD-ROM User's Manual
APPENDIX B - 6
-------
Off-Site Treatment Prior Year [OFFSITE TREAT/PRI] - Total quantity
of toxic chemical in pounds treated off-site during the previous
year.
Off-Site Zip Code [OFFSITE ZIP CODE] - The zip code area of the
off-site facility to which the reporting facility transfers waste.
Other Location EPA ID [OFFSITE TRANS ID] - The EPA-assigned
identification number of the off-site location if it handles
hazardous wastes subject to the Resource Conservation and Recovery
Act regulations. The number can be used to obtain other
information about the location from Federal and State authorities.
On-Site Energy Recovery Current Year [ONSITE ENERGY/CUR] - Total
quantity of toxic chemical in pounds used on-site for energy
recovery during current year.
On-Site Energy Recovery Future Year [ONSITE ENERGY/FUT] - Total
quantity of toxic chemical in pounds estimated to be used on-site
for energy recovery two years following current year reporting.
On-Site Energy Recovery Next Year [ONSITE ENERGY/NEX] - Total
quantity of toxic chemical in pounds estimated to be used on-site
for energy recovery next year.
On-Site Energy Recovery Percent Change, Prior/Current Year [ONSITE
ENERGY/PCT] - Percent change ir. quantity of toxic chemical used on-
site for energy recovery comparing prior and current year
quantities.
On-Site Energy Recovery Prior Year [ONSITE ENERGY/PRI] - Total
quantity of toxic chemical in pounds used on-site for energy
recovery during the previous year for energy recovery.
On-Site Energy Recovery Processes [ONSITE ENERGY/PROC] - On-site
energy recovery methods used on the reported chemical. Four codes
identify the Energy recovery method used for on-site energy
recovery processes. The energy recovery codes are:
U01 Industrial Kiln
U02 Industrial Furnace
U03 Industrial Boiler
U04 Other Energy Recovery Methods
On-Site Recycling Current Year [ONSITE RECY/CUR] - Total quantity
of toxic chemical in pounds recycled on-site during current year.
On-Site Recycling Future Year [ONSITE RECY/FUT] - Total quantity of
toxic chemical estimated to be recycled on-site in future year.
On-Site Recycling Next Year - [ONSITE RECY/NEX] - Total quantity of
toxic chemical in pounds estimated to be recycled on-site next
year.
CD-ROM User's Manual
APPENDIX B - 7
-------
On-Site Recycling Percent Change, Prior/Current Year [ONSITE
RECY/PCT] - Percent change in quantity of toxic chemical used on-
site for recycling purposes comparing prior and current year
quantities.
On-Site Recycling Previous Year [ONSITE RECY/PRI] - Total quantity
of toxic chemical in pounds recycled on-site during previous year.
On-Site Recycling Processes [ONSITE RECY/PROC] - On-site recycling
method used on the listed toxic chemical. Fifteen codes identify
the recycling methods used for on-site recycling processes. The
recycling codes are:
Rll Solvents/Organics Recovery—Batch Still Distillation
R12 Solvents/Organics Recovery—Thin-Film Evaporation
R13 Solvents/Organics Recovery—Fractionation
R14 Solvents/Organics Recovery—Solvent Extraction
R19 Solvents/Organics Recovery—Other
R21 Metals Recovery—Electrolytic
R22 Metals Recovery—Ion Exchange
R23 Metals Recovery—Acid Leaching
R24 Metals Recovery—Reverse Osmosis
R26 Metals Recovery—Solvent Extraction
R27 Metals Recovery—High Temperature
R28 Metals Recovery—Retorting
R29 Metals Recovery—Secondary Smelting
R30 Metals Recovery—Other
R40 Acid Regeneration
R99 Other Reuse or Recovery
On-Site Treatment Current Year [ONSITE TREAT/CUR] - Total quantity
of toxic chemical in pounds treated on-site during current year.
On-Site Treatment Future Year [ONSITE TREAT/FUT] - Total quantity
of toxic chemical in pounds estimated to be treated on-site in
future year.
Onsite Treatment Next Year [ONSITE TREAT/NEX] - Total quantity of
toxic chemical in pounds estimated to be treated on-site next year.
Onsite Treatment Percent Change, Prior/Current Year [ONSITE
TREAT/PCT] - Percent change in quantity of toxic chemical treated
on-site comparing previous and current year quantities.
On-Site Treatment Prior Year [ONSITE TREAT/PRI] - Total quantity of
toxic chemical in pounds treated on-site during previous year.
Other Use [OTHER USES] - Other uses and activities of the chemical
involve the use of the chemical in such a way that it does not
become part of the facility's product. Chemicals may be used to
aid processing or manufacturing or may be used in ancillary ways at
the facility. Multiple entries are possible:
As a chemical processing aid
As a manufacturing aid
Ancillary or other use.
CD-ROM User's Manual
APPENDIX B - 8
-------
Parent Company Name [PARENT CO. NAME] - The name of the company
that owns the reporting facility.
Parent Duns Number [PARENT CO. D & B] - The Dun and Bradstreet
number of the company that owns the reporting facility.
Point-Air Release [POINT AIR REL] - The reported number of pounds
of a chemical released to the environmental medium.
POTW - Publicly Owned Treatment Works (also called sewer plants).
POTW City [POTW CITY] - The city of the Publicly Owned Treatment
Works (also called sewer plant) facility to which the reporting
facility transfers waste.
POTW County [POTW COUNTY] - The county of the POTW facility to
which the reporting facility transfers waste.
POTW Name [POTW NAME] - The name of the POTW which receives waste
from a reporting facility.
POTW State [POTW STATE] - The location of the POTW to which the
reporting facility transfers waste.
POTW Street Address [POTW ADDRESS] - The street address of the POTW
to which the reporting facility transfers waste.
POTW Transfer Amount [POTW TRANS AMT] - The reported number of
pounds of a chemical transferred off-site of the facility.
POTW Zip Code [POTW ZIP CODE] - The zip code area of the off-site
facility to which the reporting facility transfers waste.
Processing [PROCESSING USES] - Processing activities involve the
incorporation of the chemical into the product(s) of the reporting
facility. The chemical may be processed as a reactant, as a
formulation component, or as a component of an article. The
chemical may also be repackaged for sale. Multiple entries are
possible:
As a reactant
As a formulation component
As an article component
Repackaging only.
Production Ratio or Activity Index [PRODUCTION RATIO] - Ratio of
current reporting year production quantities to previous year
production.
Public Contact/Phone [PUBL CONTACT/PHONE] - Name and phone number
of the person at the reporting facility to contact for further
information about the submission or the facility.
Quantity Released Current Year [QUANTITY REL/CUR] - Total quantity
of the toxic chemical in pounds released during the current year.
CD-ROM User's Manual
APPENDIX B - 9
-------
Quantity Released Future Year [QUANTITY REL/FUT] - Total quantity
of the toxic chemical in pounds estimated to be released in future
year.
Quantity Released Next Year [QUANTITY REL/NEX] - Total quantity of
the toxic chemical in pounds estimated to be released next year.
Quantity Released Percent Change, Prior/Current Year [QUANTITY
REL/%] - Percentage change in quantity released comparing previous
and current year reporting quantities.
Quantity Released Prior Year [QUANTITY REL/PRI] - Total quantity of
the toxic chemical in pounds released during prior year.
Range Estimate (Land) [LAND RANGE]
Range Estimate (Non-Point) [NONPOINT AIR/RANGE]
Range Estimate (Off-Site) [OFFSITE RANGE]
Range Estimate (Point-Air) [POINT AIR/RANGE]
Range Estimate (POTW) [POTW RANGE]
Range Estimate (Underground) [UNO/RANGE]
Range Estimate (Water) [WATER/RANGE]
A submitter may check a range to report releases of less than 1000
pounds to an environmental medium.
The ranges are:
A. 1-10
B. 11-499
C. 500-999 pounds.
Reporting Year [REPORTING YEAR] - The calendar year for which the
FORM R was
submitted.
SIC [SIC] - The Standard Industrial Classification code defined.
SIC Code [SIC CODE] - The Standard Industrial Classification (SIC)
Code(s) of the reporting facility. The codes indicate the type of
activities performed at the facility; several SIC codes may apply
to a single facility. Facilities were required to report their
four-digit code(s). Complete four-digit codes are listed on Disc
One in a file called SIC_Codes. The two-digit codes for general
manufacturing areas are:
20 Food and Kindred Products
21 Tobacco Manufacturers
22 Textile Mill Products
23 Apparel and other finished products made from
fabrics and other similar materials
24 Lumber and Wood Products (except furniture)
25 Furniture and Fixtures
26 Paper and Allied Products
27 Printing, Publishing, and Allied Industries
28 Chemicals and Allied Products
29 Petroleum Refining and Related Industries (coal)
30 Rubber and Plastic Products
CD-ROM User's Manual
APPENDIX B - 10
-------
31 Leather and Leather Products
32 Stone, Clay, Glass, and Concrete Products
33 Primary Metal Industries
34 Fabricated Metal Industries (except machinery and
transportation equipment)
35 Machinery (except electrical)
36 Electrical and Electronic Machinery, Equipment,
and Supplies
37 Transportation Equipment
38 Measuring, Analyzing, and Controlling
Instruments; Photographic, medical, and optical
goods, watches and clocks
39 Miscellaneous Manufacturing Industries.
Source Reduction Activities [SOURCE REDUCT ACT] - Actions taken by
the reporting facility to reduce the amount of a reported toxic
chemical.
Source Reduction Activities:
Good Operating Practices
Inventory Control
Spill and Leak Prevention
Raw Material Modifications
Process Modifications
Cleaning and Degreasing
Surface Preparation and Finishing
Product Modifications
Source Reduction Methods [SOURCE REDUCT METH] - Method(s) or
information sources used to identify the possibility for a source
reduction activity. Eleven codes identify the source reduction
methods for source reduction activities. The source reduction
methods codes are:
T01 Internal pollution prevention opportunity audit(s)
T02 External pollution prevention opportunity audit(s)
T03 Materials balance audits
T04 Participative team management
T05 Employee recommendation (independent of a formal company
program)
T06 Employee recommendation (under a formal company program)
T07 State government technical assistance program
T08 Federal government technical assistance program
T09 Trade association/industry technical assistance program
T10 Vendor assistance
Til Other
State/County FIPS Code [FIPS CODE] - The five-digit FIPS (Federal
Information Processing Standards) code can be used to identify the
state and county of the reporting facility. EPA added the code to
each submission.
CD-ROM User's Manual
APPENDIX B- 11
-------
Stormwater Percent [PERCENT STORMWATER] - For releases to water,
some percentage of the release may come from rainwater runoff from
building roofs, storage piles, or other areas. The percentage of
the release due to stormwater runoff must be estimated if the
facility has monitoring data on the chemical.
Stream Name [STREAM NAME] - The name of the receiving stream(s) to
which the facility releases listed chemicals. Estimates on Form R
are specific to the receiving stream. If a reporting facility
releases the chemical to more than one receiving stream, the
releases to all streams must be added to determine total releases
to water. Note that the reporting facility may list receiving
streams to which it does not release the chemical covered by the
submission.
Substance Name [CHEM NAME] - The name of the section 313 chemical.
Sum Air Releases [SUM AIR REL] - Summation of non-point and point
chemical releases in pounds.
Sum All Releases to Environment [SUM ALL RELEASES] - Summation of
all chemical releases to the environment in pounds.
Sum Land Releases [SUM LAND REL] - Summation of all chemical
releases to land in pounds.
Sum Off-Site Transfers [SUM OFFSITE TRANS]- The reported number of
pounds of a chemical transferred off-site of the facility.
Sum POTW and Off-Site Transfers [SUM POTW/OTH TRANS] - Summation of
all POTW and off-site transfers in pounds.
Sum POTW Transfers [SUM POTW TRANS] - Summation of all releases in
pounds to publicly owned treatment works.
Sum Releases and Transfers [SUM REL/TRANS] - Summation of all
environmental releases and transfers to publicly owned treatment
works in pounds.
Sum Underground Releases [SUM UND INJECT REL] - Summation of all
chemical releases injected underground in pounds.
Sum Water Releases [SUM WATER REL] - Summation of all chemical
releases to water in pounds.
CD-ROM User's Manual
APPENDIX B - 12
-------
Treatment Efficiency [TREAT EFFICIENCY] - This provides an estimate
of the percentage of the chemical physically removed, destroyed, or
converted by the treatment methods. Treatment efficiencies for
chemical compounds are reported for the chemical. Most treatment
methods are more effective at higher influent concentrations so
influent concentrations should be considered when comparing
treatment efficiencies. For wastestreams treated sequentially by
several treatment methods, reporting facilities may submit the
treatment efficiency for all methods taken together. The reporting
facility is not required to list treatment efficiency for any but
the final step, but may list the aggregate efficiency for all steps
in the sequence. For example,. if the aggregate efficiency is 75
percent, the facility may list the 75 percent with the last step of
the sequence or may enter 75 percent with each step.
Treatment Method [TREAT METH/SEQ] - The method of treatment used on
the wastestream to reduce the amount of the chemical being
released. The codes fall into the following general categories:
A01-A07 Air Emissions Treatment
B11-B99 Biological Treatment
C01-C99 Chemical Treatment
F01-F99 Incineration/Thermal Treatment
P01-P99 Physical Treatment
R01-R99 Recovery/Reuse
G01-G99 Solidification/Stabilization.
TRI Facility ID [TRI FACILITY ID] - A facility identification
number generated by EPA using facility name, address and zip code:
Format: zzzzznnnnnsssss where zzzzz = zip code, nnnnn = first five
consonants of the name, sssss = first five non-blank, non-special
characters in the street address.
Type Treatment, Disposal [OFFSITE DISP METH] - This includes the
type of treatment or disposal associated with the chemical at the
off-site location. The codes are:
Disposal:
M10 Storage only—Indicates any means of storage
M71 Underground Injection
M72 Landfill/Disposal Surface Impoundment
M73 Land Treatment—Destruction of chemical by
spreading on land
M79 Other Land Disposal
M94 Transfer to Waste Broker—Disposal
Recycling:
M20 Solvents/Organics Recovery
M24 Metals Recovery
M26 Other Reuse or Recovery
M28 Acid Regeneration
M93 Transfer to Waste Broker—Recycling
CD-ROM User's Manual
APPENDIX B - 13
-------
Waste Treatment:
M40 Solidification/Stabilization
M50 Incineration/Thermal Treatment
M54 Incineration/Insignificant Fuel Value
M61 Wastewater Treatment (Excluding POTW)
M69 Other Waste Treatment
M95 Transfer to Waste Broker—Waste Treatment
Energy Recovery:
M56 Energy Recovery
M92 Transfer to Waste Broker-Energy Recovery
UIC ID [UNO INJ ID] - The Underground Injection well Code
identification number assigned by EPA under the Safe Drinking Water
Act to facilities that dispose of wastes in certain types of
permitted underground injection wells. The number may be used to
obtain information from State regulatory agencies on the reporting
facility's waste disposal to underground wells.
Underground Release [UNO INJECT REL] - The reported number of
pounds of a chemical released to the environmental medium.
Water Release [WATER REL] - The reported number of pounds of a
chemical released to the environmental medium.
CD-ROM User's Manual
APPENDIX B - 14
-------
APPENDIX C
-------
QUICK START INSTRUCTIONS FOR
UNDERSTANDING TRI
BACKGROUND: Section 313 of the Emergency Planning and Community Right-to-Know Act
(EPCRA) of 1986 required EPA to establish an inventory of toxic chemical emissions from
manufacturing facilities. The purpose of this reporting requirement is to inform the public and
government officials about routine and accidental releases of toxic chemicals to the environment.
EPCRA established that the public has a "right-to-know" environmental information reported to
EPA under the statute. The Toxics Release Inventory (TRI) has been used extensively for
research, by neighborhood coalitions and public interest groups seeking reductions in toxic
releases, and as the basis for industry participation in voluntary pollution prevention efforts.
EPA also uses the data base to assist in development of environmental programs and rulemaking.
REPORTING REQUIREMENTS: Facilities subject to TRI reporting are required to submit an
EPA Form R every July 1st for each chemical they released into the environment (e.g., air,
water, etc.) or transferred offsite for treatment or disposal during the preceding calendar year.
The reporting requirement applies to owners and operators of facilities that have 10 or more full-
time employees; belong to Standard Industrial Classification (SIC) codes 20 through 39 (i.e.,
manufacturing facilities); and manufacture (including importing), process or otherwise use a toxic
chemical in excess of specified thresholds. Over 300 chemicals were designated as toxic for the
years covered by these CD-ROMs (1987-1993). New chemicals can be designated as toxic
through rulemaking and petitions, and in fact, 286 additional chemicals have been added,
effective in reporting year 1995.
IMPACT OF TRI: The inception of a national toxics inventory has resulted in greater public
and industry awareness of the extent and effects of chemical pollution. Since implementation of
TRI, total annual chemical releases by U.S. manufacturing facilities have declined considerably.
Many companies have instituted measures to prevent chemical pollution, such as substituting safer
chemicals or reengineering processes. In 1990, Congress passed the Pollution Prevention Act
(PPA), resulting in expansion of TRI. Beginning in 1991, companies were required to report
additional data about pollution prevention activities and projected future releases. TRI is
continuing to develop: EPA is studying options for extending coverage to additional industries.
In 1994, Clinton signed an Executive Order requiring Federal facilities to submit TRI reports.
This search guide is intended to supplement the CD-ROM User Manual and the Brief User
Guide accompanying the CD-ROM. For help or more information contact: TRI User
Support, (202) 260-1531
CD-ROM User's Manual APPENDIX C - 1
-------
INSTALLATION OF CD-ROM SOFTWARE: The 1987-1993 CD-ROM set contains new,
menu-driven installation software that allows you to choose from several optional features when it
is loaded. For your convenience, installation software is provided on both discs; either disc (but
not both) may be used to load the software. Follow instructions for installing CD-ROM as
outlined in manual and in the Quick Reference Guide that accompanied the disc.
DATA BASE STRUCTURE: The 1987-1993 TRI CD-ROM set, comprised of two discs,
supersedes all earlier editions of the CD-ROM. Disc One contains TRI for the years 1987-1990;
Disc Two contains the 1991-1993 TRI. Data on each disc is divided into two files:
The TRI RELEASES file, the larger and more frequently-used file, contains comprehensive
facility identification information. The RELEASES file provides the total amounts of the
chemical released to air, water, land, publicly owned treatment works (POTW) and transferred to
offsite locations. It also describes how the chemical is used, the maximum amount onsite during
the year, and pollution prevention efforts such as source reduction and recycling. Use when:
Looking for general information about facilities (i.e. location, Dun & Bradstreet #s), chemicals
(i.e. maximum amount on site or use of chemical), or industries (SIC codes and trends). Also
search by releases to specific bodies of water (i.e., Lake Superior) or POTWs or commercial
offsite locations where wastes are transported (i.e., ABC Waste Co. or names and addresses of
offsite locations in Pittsburgh, PA).
The TRI TREATMENT file contains data on waste treatment methods and efficiency, and waste
minimization. Use when: Looking for information on waste treatment.
CHEMICAL SUBSTANCE FACT SHEETS: Each disc contains a complete set of fact sheets
for each chemical listed on TRI. They describe, in layman's terms, ecological and health effects
resulting from release and exposure; identifying and treating symptoms, and OSHA exposure
limits and other standards pertaining to the chemical. Use when: After searching TRI to identify
the chemicals released in a specific locality or other criteria.
PERFORMING CALCULATIONS (KASTAT): This feature allows you to sum, average, and
perform other calculations using a dBase file exported from TRI. There are a number of fields
representing different types of releases. The system allows you to page through screen displays
showing calculations performed on each amount field contained in the dBase file.
README FILES: The CD-ROM contains five files that provide documentation for the database
and other information:
README.NOW contains vital information about the contents of this disc set.
FIELDS.TRI contains descriptions of all the data fields including codes and translation
of coded information.
REGIONS.EPA contains the names, addresses and phone numbers of the 10 Federal EPA
regional contacts.
SIC_CODE contains the four-digit Standard Industrial Classification codes for 20-39 and
the code descriptions.
STATES contains the names, addresses and phone numbers of the State and Territorial
TRI contacts.
Additionally, the text of the manual is provided in the README directory.
CD-ROM User's Manual APPENDIX C - 2
-------
QUICK START INSTRUCTIONS FOR
SEARCHING TRI
Insert Disc Two. Use the main menu to choose TRI Data Base from the Data Base Selection
Menu and < enter >. Highlight the Releases data base and press < enter > twice.
SAMPLE SEARCH (Releases File)
EXAMPLE: Find all releases in New Jersey for 1991-1993.
1. Press F3=SELECT
2. Use arrow keys to go to Facility State < enter >
3. Enter search term NJ < enter >
Set # Found
1 8210 FACILITY STATE: NJ
TO OBTAIN ALL TRI DATA FOR ONE RECORD: When searching by data elements
common to both the RELEASES file and the TREATMNT file (for example, by facility name or
location or chemical), search each file separately, then sort records into the same order. Each
file should contain the same number of records. Or, retrieve multiple sets of data and match
records in each file by EPA Submission Number which uniquely identifies each record. (Linking
files requires use of dBase or other software not on the CD-ROM.)
TO NARROW A SEARCH BY COMBINING SEARCH STATEMENTS WITH "AND"
There are two methods for combining search statements to narrow a search:
1. Combine sets with "AND" (example 1).
2. Change Search Set to limit searching to records within a previously created search set
(example 2).
The most efficient method depends on the size the search set retrieved. If the sets are not too
large, use boolean searching shown in example 1. Otherwise, if one search yields thousands of
records, follow example 2. By Changing Search Set, you are limiting your search to records
meeting the first criteria, instead of searching the entire data base. If you Change Search Set,
you must change it back to 0 (zero) to resume searching the entire data base.
EXAMPLE 1: Retrieve all releases for NJ for 1993.
1. Search for NJ as the Facility State. Press F3, highlight Facility State, press , type NJ, press
< enter>. 8,210 records retrieved.
CD-ROM User's Manual APPENDIX C - 3
-------
2. Search for 1993 as the Reporting Year. Press F3, highlight Reporting Year, press , highlight
1993, press < enter>. 79,984 records retrieved. (Notice that searching the entire data base by
Reporting Year is slow.)
3. Press F5 = SETS. Highlight Combine Sets, press . Highlight Combine with AND, press
. Type 1, , AND 2, AND . Name your set (optional). 2,575 records
retrieved.
EXAMPLE 2: Retrieve all releases for NJ for 1993.
1. Search for NJ as the Facility State. Press F3, highlight Facility State, press < enter > , type NJ, press
< enter >. 8,210 records retrieved.
2. Press F5 = SETS. Highlight Change Search Sets, press < enter >. Type 1 for set to search in, press
< enter >. (Note Search Set Number at bottom of screen now =1.)
3. Search for 1993 as the Reporting Year. Press F3, highlight Reporting Year, press < enter >, highlight
1993, press . System searches only the 8,210 records from step 1. 2,575 records retrieved.
TO EXPAND A SEARCH BY COMBINING SEARCH STATEMENTS WITH "OR"
AND USING THE INDEX
Follow the directions for NARROWING A SEARCH (Example 1) but choose to Combine Sets with
OR. Plan to search as many synonyms for a term as possible by using the database's index. All
searchable fields are indexed.
EXAMPLE: Search for all General Motors Company facilities.
General Motors can be found under GM or CMC or General Motors or General Motors Company. Hint: Search both
the facility name and parent company name fields. If you enter General Motors, you will get a search equivilent to
General < AND > Motors. There are no adjacency operators for searching this data base. False drops may occur. If
you are unsure of terms or spelling, use truncation (?) to browse the index for available terms.
1. Press F3=SELECT
2. Use arrow keys to go to Facility Name < enter >
3. Enter search term with the question mark (?) to look at the index and choose the best term(s).GM? < enter >
4. Go to correct word(s) and use the grouping keys (F7, F8 and F9) to mark the term(s) you want searched. Go to first
occurrence of GM, mark it with the F7(l) key. Use the arrow key to move down to last occurrence and mark it with
the F8(t) key. To select a single name, use the FQ^key.
SCREEN F4=SEARCH F4=SEARCH
FACILITY NAME (PHRASE) FACILITY NAME (PHRASE)
-LGM V GM
tGMC OR /CMC
GMP GMP
GMPT GMPT
5. When all terms are marked, press < enter> to search.
6. Repeat steps with General or Motor? or other synonyms.
7. Combine sets created by using "OR".
CD-ROM User's Manual APPENDIX C - 4
-------
QUICK START INSTRUCTIONS FOR
DISPLAYING AND SORTING
TRI DATA
DISPLAY A SET
You can display the current output set by press!ug F6=DISPLAY. You can display any set by
pressing F5=SETS and choosing Display a Set. It is easy to re-rank data, change output fields, and
print the record being viewed. When viewing any record, press < enter > and the Action Menu will
appear. Choose New Display Form to specif}/ selected fields and limit the display to fields
meaningful to your inquiry. Sort records by designating multiple fields using the ranking feature.
When you use F5=SETS, you are given the option of ranking the data and choosing the output fields
before viewing the data.
SORT FEATURE
You may sort a set when displaying it to screen, printing it, or exporting it (F5). The default order
for search results is by EPA Submission Number, unique to each record. To provide a more
logical, useful arrangement, there are several choices for sorting your set. You can also display by
User Defined Rank which allows you omlf the way you want to sort it is not shown, you can pick
Display by User Defined Rank. You can use this feature to sort on more than one field.
EXAMPLE: I have a set of all releases in Maryland. I want the data arranged alphabetically by facility name and each
chemical arranged alphabetically under each facility.
e.g. ABC Co. - acetone
ABC Co. - toluene
DDD Co. -freon 113
1. Press F5=SETS and choose Display a Set.
2. Choose Display by User Defined Rank.
3. Use arrow keys to go to Facility Name < enter>
4. Type 1 < enter > (This is the first field you want sortsd by)
5. Use arrow keys to go to Chem Name < enter >
6. Type 2 < enter > (This is the second field you want sDrted by)
7. Use arrows to return to top of list to End Rank Selections < enter > to start sort.
NOTE: Sorting on more than 3 criteria will take the computer a long time to perform. If you want to sort release
amounts in descending order, type a minus sign before the number. Example: Sort by Sum Air Release with highest
releases first. Use arrow keys to go to Sum Air Release < enter>, and type -1 < enter>.
CD-ROM User's Manual APPENDIX C - 5
-------
QUICK START INSTRUCTIONS FOR
EXPORTING FROM TRI
You may export a set in comma delimited (ASCII), fixed field, DBASE, Lotus, WP [Word
Perfect] Merge, or print to disk format.
EXAMPLE: Export set #4 which contains releases in MD in 1993.
1. Press F5=Sets.
2. Use arrow keys to choose Export a Set, press < enter >.
3. Type set number 4, press < enter >.
4. Use arrow keys to highlight desired format, press < enter >.
5. Choose sort criteria. (See SORTING TRI for directions.)
6. Choose from among 3 output options:
Releases or Treatmnt - includes all fields, including blanks.
Releases (Brief) or Treatmnt (Brief) - includes only fields containing data. (Not
recommended for exporting.)
User Selected Output - allows you to choose fields to be included. Use the
grouping keys (F7, F8, and F9) to mark the desired fields. HINT: Choose only those
fields that you need. You must use the form designer if you are downloading fields with
repeating fields.
7. Type name of file (and path if different than that shown) MD93 < enter >.
D-ROM User's Manual APPENDIX C - 6
-------
QUICK START INSTRUCTIONS FOR
PRINTING TRI DATA
To print a RECORD:
You may print a single record while you are viewing the record on your screen. Press < enter >
to get the ACTION MENU. Use arrow to choose PRINT CURRENT RECORD < enter >.
To print a SET:
This can be done at any time. You are led through the choices you must make by menus found
under F5=SETS.
EXAMPLE: Print search set #4.
1. Press F5=SETS.
2. Use arrows to choose PRINT A SET < enter >.
3. Type # of set: 4 < enter >
4. Choose sort criteria. (See SORTING TRI DATA for directions.)
5. Choose output criteria:
Releases - Contains all datat elements, including blanks.
Releases (Brief) - Includes only fields containing data. (This format does not work when
planning to import data into Lotus, dBase, etc., because each record is a different length,
depending on which fields are blank.)
User Selected Output - Gives you a list; of all fields which can be printed. Use the
grouping keys (F7, F8, and F9) to mark the fields which you want printed.
6. Use arrows to choose Consecutive Print or Page at a Time.
7. Align paper and press when ready.
CD-ROM User's Manual APPENDIX C - 7
i
-------
QUICK START INSTRUCTIONS FOR
CALCULATING TRI
RELEASES
The KASTAT feature is used to compute the total amounts for a set of data. You must use the
RELEASES file to retrieve the data.
EXAMPLE: Want to know the total amount of toluene released in Maryland in 1993.
1. Follow search and combine instructions to retrieve a set for records which have MD only as the facility state, 1993
as the Reporting year, and toluene as the substance name.
2. Follow the export instructions.
Choose set #. Choose DBASE. Choose default order. Choose user selected output.
Mark these 8 fields ONLY
Field 1-Sum Air Rel
Field 2-Sum Water Rel
Field 3-Sum Land Rel
Field 4-Sum All Releases
Field 5-Sum POTW Trans
Field 6-Sum Offsite Trans
Field 7-Sum POTW/Oth Trans
Field 8-Sum Rel/Trans
Name file-type MD93TOL < enter >
3. Exit to main menu (F10).
4. Choose 4 Calculate Releases (KASTAT) by using arrow keys to highlight it on the menu < enter >.
5. Type file name: MD93TOL < enter >
6. There is one screen for each field that is computed. Use the right and left arrow keys to go from one to another.
To print all records, press p then right arrow to change records until all eight screens are printed.
EXPLANATION OF KASTAT FIELDS
1. Field number refers to which field the calculation was performed on. Field number: 1 is Sum Air Release.
2. Number of records refers to the number of records in the set of data on which the calculations are being performed.
The Number of Records in the set of data was 89.
3. Number of Blanks refers to the number of records which had a blank or no data in that field. No records had
Blanks in the Sum Air Release field, therefore all records had releases of Toluene to the Air.
4. The Lowest single release of Toluene to the air was 2 pounds.
The Highest single release of Toluene to the air was 1,874,820 pounds.
5. The Range is the difference between the Highest and the Lowest single release. In this instance Highest minus
Lowest (1,874,820 - 2 = 1,874,818).
6. ***The Sum is the total sum of the field on which the calculation is being processed (in this case the Sum Air Release
field.) Therefore the total release of Toluene in MD in 1993 to the air was 6,434,741 Ibs.
***The SUM data is the most useful.
7. The MEAN WITH and W/O 0 is the average of the field on which the calculation is being processed.
Therefore the average release of Toluene in MD for 1993 by each facility was 73,122.05 Ibs.
8. Press the right arrow to view the next field, Sum Water Rel. Repeat for each of the numeric fields chosen.
D-ROM User's Manual APPENDIX C - 8
-------
QUICK START INSTRUCTIONS FOR
DESIGNING FORMS FOR PRINTING
AND EXPORTING TRI DATA
THE CD COMES WITH TWO FORMS ALREADY AVAILABLE FOR EACH FILE (RELEASES AND
TREATMENT). THESE FORMS, FULL RECORD AND BRIEF RECORD, CAN BE USED IMMEDIATELY FOR
EXPORT OR PRINTING.
Use the form designer when you want to download fields that may be repeated in a record. The form designer "saves
a space" for fields that are blank. For example, a facility may have up to six Standard Industrial Classification Codes
(SIC codes), but most have less than three. If you were 1:0 download a set of records in an ASCII, DBASE or Lotus
format by using the User Selected Output to choose the fields, each record would be different be a different length,
depending on the number of SIC codes in each. As a result, the downloaded file would be unusable by most software.
The form designer allows the user to choose specific fields, including repeating fields like SIC, and download them in
a usable format. If you are downloading fields with multiple occurrences (but not the full record), it is highly
recommended that you create a form for downloading. The Form Designer is menu-driven and relatively easy to use.
In order to use the Form Designer, save your set list (F5) and exit to DOS.
At the DOS prompt, follow the instructions in the manual or Quick Reference Guide precisely. You will be creating your
own form which then appears with the other output choices. You can create as many forms as you like. When you are
through, return to the CD-ROM, load your set list (F5) or repeat the search. This time, when you are ready to export
or print the data, the name of the form that you just created will be listed along with the other choices for output formats.
The data exported by using the Form Designer and Comma Delimited are both comma and quote delimited. NOTE:
All fields are treated as character fields by the Form Designer. If you are converting data into another format such
as Paradox, you must create your file structure by specifying all fields as "character" fields. After conversion, it is a
simple matter to change the field specification from "character" to "numeric" for fields which may be used for
calculations.
When you use the Form Designer, consider how you would want the data displayed in a report. For example:
For a created set of records, you want the first SIC code first and then the first SIC description, the second sic code
second and then the second sic description, etc.
2951
Asphalt paving mixtures and blocks
2952
Asphalt felts and coatings
To do this you must choose sic/array 1, sic code/array 1, sic/array 2, sic code/array 2.
NOTE: Follow the manual or Quick Reference Guide precisely. WHEN "MISSING DATA RULE" IS
HIGHLIGHTED, YOU MUST TYPE L OR SELECT THE "L LABEL..." OPTION.
CD-ROM User's Manual APPENDIX C - 9
-------
APPENDIX D
-------
APPENDIX D
Sources for Further Assistance
Toxics Release Inventory User Support (TRI US)
EPA, TRI US (TS-793)
401 M ST, SW
Washington, DC 20460
Telephone Number: (202) 260-1531
Hours: 8:00 a.m. - 4:30 p.m. (Eastern Time) Monday - Friday
TRI US can assist you with general information about TRI or refer you to another TRI contact
(private, public, or government). TRI US can provide search assistance in TRI and provide
NLM/TOXNET on-line search training. Your comments are very important and have helped to
improve each subsequent CD-ROM product.
The Emergency Planning and Community Riight-to-Know (EPCRA) Hotline
Telephone Number: 1 (800) 535-0202
Hours: 8:30 a.m. - 7:30 p.m. (Eastern Time) Monday - Friday
The EPCRA Hotline provides general information and assistance about TRI and related programs
and the distribution of TRI publications.
CD-ROM User's Manual APPENDIX D - 1
-------
Symbols
[I] key
for marking terms, 3-19, 4-9, 4-16
for scrolling records, 2-18, 4-9, 4-15,
4-23
[t]key
for marking terms, 3-19, 4-9, 4-16
for scrolling records, 2-18, 4-23
[v/] symbol, 3-19, 4-9, 4-16
*-,-*• symbols, 2-18, 4-22
B
bibliography, 1-16:17
boolean searching,
fact sheets, 3-7, 3-15
TRI, 4-18
brief record, 4-24, 4-26:27
broadening a search,
see OR operators, 3-15, 4-18
buffers, 2-15
business, use of TRI for, 1-6
.anl,
see KASTAT, 5-2
ASCII downloading,
see comma-delimited, 4-20, 4-28 +
see Export a Set, 3-17
action menu
fact sheets, 3-22+
TRI, 4-25
add user input, 4-25
adding release totals, 5-1
adjacency searching,
see proximity, 4-14
Agency for Toxic Substances and Disease
Registry, 1-11
Alt key, 2-18
'and' operator, see Combine Sets, 3-15,
4-18
arrow keys, 2-18, 3-19
assistance,
see TRI User Support, 1-16, D-l
ATSDR, 1-11
autoexec.bat file, 2-3, 2-14
averages, calculating 5-1
.CSV,
see comma-delimited, 4-20, 4-28
CD-ROM, features of TRI on, 1-12
CD-ROM Extensions, 2-1, 2-2+
CAS number, 3-9
calculation feature,
see KASTAT, 2-16, 5-1
change record, 2-18, 4-22
changing output set, 4-22
changing search sets, 3-14, 4-21
check mark, 3-19, 4-9, 4-16
chemical abstract number, 3-9
chemical substance fact sheets, 2-15, 3-1:24
chemical name, searching fact sheets,
see common name, 3-7
chemicals listed in TRI, 1-3
citizen use of TRI, 1-5
Clean Air Act, 1-8
Ctrl key, 2-18
combining data sets, 3-15, 4-18
comma-delimited, 4-20
see downloading, 4-28 +
common name, 3-7+
config.sys file, 2-3
CD-ROM User's Manual
INDEX - 1
-------
configuration, 2-1
contents of TRI, 1-3
contents of disc, 2-15
controlling display speed, 4-22
creating custom reports
see Forms Designer, 4-30
custom reports,
see Form Designer, 4-30
D
.dbf format, 4-28
and calculating releases, 5-1
DOS, exit to, 2-10, 3-18, 4-21
Data Base Selection Menu, 3-1:2, 4-1
data fields
descriptions, B-1 +
choosing to search, 4-10
dbase format,
see downloading formats, 4-28
default order, 4-23
default settings, changing
see Options, 3-4
defining display set, 3-4
defining search set, 3-4
deleting search sets
specific set, 3-16, 4-19
all sets, 3-16, 4-19
descending sort, 4-24
designing reports,
see Forms Designer, 4-30
device drivers, 2-2
diskettes, 1-13
Display (F6), 3-18, 4-2, 4-9, 4-21
display format change,
see Action Menu, 4-25
displaying sets,
previous search, 3-17, 3-18
current search, 3-18
selecting format, 4-26
downloading
data, 4-27
repeating fields,
see Forms Designer, 4-30
E
EPA Submission Number, 4-6
EPCRA, 1-2
EPCRA Hotline, 1-15, D-l
ESC key, 3-20, 4-10
education, 1-6, 1-11
electronic bulletin board, 1-15
Emergency Planning and Community Right-
to-Know Act, 1-2
entire data base, searching, 4-18
see global index, 3-12
equipment, 2-1
error messages, 2-11
escape key, 2-18, 3-20, 4-10
excluding records
see combine sets NOT operator, 3-15,
4-18 +
exit, 4-10
temporary to DOS, 3-18, 4-4, 4-21
expanded memory, 2-13 +
expanding a search
see OR operator, 3-15
expansion of TRI, 1-3
export
data file formats, 4-28
forms, 4-30
export from Table of Contents, 3-17
export selected fields,
see user selected output, 4-29
exporting sets, 3-17, 4-28
extended memory, 2-13
Extensions, 2-2
CD-ROM User's Manual
INDEX - 2
-------
F
.fff,
see fixed field, 4-28
facility name, searching by, 4-14
factsheets,
see Chemical Substance Fact Sheets, 3-1 +
features of CD-ROM, 1-12
Federal agencies, 1-8
field descriptions, B-l
file structure, 2-15, 4-3
fixed field,
see downloading formats, 4-28
form for TRI reporting, A-l
Form R, A-l
formats for TRI products, 1-11 +
Forms Designer, 4-30
full record format,
see RELEASES, 4-24, 4-26:27
function keys, 3-2, 4-7
G
GPO, 1-11
global index, 3-12
gopher, 1-14
Government Printing Office, 1-11, 1-15
grouping keys, 3-19, 4-9, 4-16
H
health, 1-8
help,
see TRI User Support, 1-16, D-l
help function, 3-3, 4-8
high memory, 2-14
High Sierra, 2-2
Home/End key, 2-18
hot keys on action menu
fact sheets, 3-23
TRI, 4-25
hotline, 1-16, D-l
ISO 9660, 2-2
indexing data, 4-13
information sources, 1-9
installation, 2.1 + , 2-4
see quick start, 2-5
installation assistance
see TRI-US, 1-16, D-l
Internet, 1-14
jump to record, 4-26
K
KADFDES command,
see Form Designer, 4-30
KASTAT, 2-11, 5-1:5
Kastat.fld, 5-2
Kastat.txt, 5-2
LANS, 2-2
labor, 1-6
legislation, 1-2
LEPC, 1-7, 1-10
library, 1-10
CD-ROM User's Manual
INDEX - 3
-------
limitations of data, 1-4
loading set lists, 3-17, 3-24, 4-19
local agencies, 1-7, 1-10
local area networks, 2-2
Local Emergency Planning Committee, 1-7,
1-10
Lotus format,
see downloading, 4-28
M
MS-DOS
temporary exit to, 3-18, 4-21
magnetic tape, 1-14
manual organization, 1-1
marking keys,
see group, 3-19
mean, calculating 5-4
media, 1-8
memory requirements, 2-1, 2-13 +
metals,
see compounds, C-ll
microfiche, 1-5
missing data rule, 4-35
mode, calculating, 5-4
mscdex.exe, 2-2 +
N
NLM, 1-13
NTIS, 1-12
narrowing a search
see change search sets, 3-14
see combine sets, 3-15
National Library of Medicine, 1-13
National Technical Information Service,
1-12
new display form, 4-26
see Form Designer, 4-30
new path, 4-4
'not' operator, 3-15, 4-19
O
online systems, 1-13
Options (F2), 3-4, 4-9
options for settings, 3-4, 4-9
'or' operator
see combine sets, 3-15, 4-18
Options menu, 3-4
output set, 4-17
.P2D,
see print-to-disk, 4-29
PPA of 1990, 1-4
partial record
see RELEASES (BRIEF), 4-24, 4-26:27
partial term, 3-7+, 3-13
password, 2-8
path,
see new path, 4-4
performing calculations, 5-1
PgUp/PgDn key, 2-18
pollution prevention, 1-4
previous screen,
see ESC, 3-20, 4-10
print current record, 4-26
print from Table of Contents, 3-18
print to disk format, 4-29
printing,
see action menu, 3-22 +
printing fact sheets, 3-17
printing formats, 4-27
printing sets, 3-17, 4-19, 4-26
proximity searching, 4-14
public health agencies, 1-9, 1-10
public interest groups, 1-6
pull-down menus, 3-2
CD-ROM User's Manual
INDEX - 4
-------
Q
question mark, 3-7+, 3-13
quick start installation, 2-5
R
ranking data,
see action menu, 4-25
readme files, 2-16
readme.now, 2-16
reference materials, 1-16
refine search, 4-17
regional EPA offices, 1-11
see Regions, epa, 2-16
releases file, 2-15, 4-3
reporting form, A-l
reporting requirements, 1-3 +
reporting year, searching by 4-11
reports, 1-16, 4-26, 4-30
reports, creating custom
see Forms Designer, 4-30
risk, 1-9
risk communication hotline, 1-17
risk screening, 1-9
scope of TRI, 1-3
search key, 3-13, 4-9
searching fact sheets, 3-1:24
Section 313, 1-2
Select (F3), 3-5, 4-10+
select display set, 3-18
setting up workstation, 2-1
sets
fact sheets, 3-14
shell, 4-4, 4-21
skip to next record
TRI, 4-22
software installation, 2-4 +
see quick start, 2-5
sorting, 4-23
source reduction, 1-5
sources of information, 1-10
speeding up display, 4-22
spreadsheet format, 4-28
state agencies, 1-6
see readme files, 2-16
State Emergency Response Commission, 1-6
summing data, 5-1
Superfund Amendments and Reauthorization
Act, 1-2
.SSL, 3-24
SARA, 1-2
SERC, 1-6
see readme files, 2-16
SIC codes,
see readme files, 2-16
SIC, downloading, 4-30, 4-36
saving search results, 3-23, 4-20
save set list, 3-18, 3-23, 4-21
saving new forms, 4-37
saving settings, 4-9
schools,
see educators, 1-6
Table of Contents, 3-6
TOXNET, 1-13
TRI reporting form, A-l
TRI-US, 1-14, D-l
TSRs, 2-14
temporary exit to DOS, 2-10, 3-18, 4-21
text searching, 3-1 +
Title III, 1-2
thesaurus,
see indexing 4-15
treatment file, 2-16, 4-3
truncating search terms, 3-8, 4-13, 4-15
troubleshooting software installation, 2-6
CD-ROM User's Manual
INDEX - 5
------- |