IwtionPrevention
December 1994
17-
~ "l_^_ ____^
s^s Manual
-------
-------
Need help using TRI? Save this handy card!
TRI
Need Assistance with TRI?
Call TRI User Support!
(202) 260-1531
Hours: Mon-Fri, 8:00-4:30 EST
U.S. EPA, TRI User Support (TRI-US),
401 M St. S.W. (7407), Washington, DC 20460
For sale by the U.S. Government Printing Office
Superintendent of Documents, Mail Stop: SSOP, Washington, DC 20402-9328
ISBN 0-16-045502-2
-------
-------
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-4
1.3.4 Scope of the TRI. . . ... . . ."; ... . . . . . . . ..... . .1-4
1.3,5 Pollution Prevention and TRI. .................. .... . . . 1-5
1,3.6 Using the TRI. ..... . . . . . . . .... . . . . . 1-9
1.3.7 TRI & Health. ........ .... ........... 1-9
1.3.8 If You Want More Information. 1-10
1.4 Media Formats for TRI . .......... . . 1-11
1.4.1 TRI Data On CD-ROM ..... . . . '.:..... . . 1-11
1.4.2 TRI Data On Floppy Diskette . . ... ..... . . ... .'. . . . . . . 1-12
1.4.3 TRI Data Through On-line Databases . .......... 1-12
1.4.4 TRI Data On Internet. ................................... 1-13
1.4.5 TRI Data On Magnetic Tape , . .1-13
1.4.6 Printed Reports About TRI . . . . . ; . . . . .". . .'. . . .1-13
1.4.7 TRI Data on Microfiche .,-..... 1-14
1.4.8 TRI Data On Electronic Bulletin Boards ..;...' 1-14
1.5, TRI User Support 1-14
1.6 Other Available Reference Materials . . 1-15
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-6
2.1.5 If You Need More Memory. . .:. . . . . . . . . . . 2-8
2.2 TRI CD-ROM Structure ............. . . . . . ....... .;. ........ , 2-10
2.2.1 Chemical Substance Fact Sheets. . ... ... . . . 2-10
2.2.2 Toxic Release Inventory ... .2-11
2.2.3 Calculation Feature (KASTAT) .2-11
2.3 Readme Files. 2-11
2.4 Accessing the Toxic Release Inventory '. 2-12
2.5 Special Keys . . . ... . . . . . . . ...' . . . . . . . ..... . . .2.13
2.6 Printing Files. . .'. .........:.., 2-13
-------
3.0 TRI Chemical Substance Fact Sheets
3.1 Overview of Conducting A Search . . . 3-2
3.2 Function Key Options 3-3
3.2.1 Fl = HELP Key . . 3-4
3.2.2 F2 = OPTIONS Key '. 3-5
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=GROUP V 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 .Toxic Release Inventory Data Base
4.1 Choosing A Data File .....' 4-3
4.2 Overview of Conducting A Search 4-5
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-16
4.6 Displaying Search Results 4-20
4.6.1 Reviewing Displayed Data . . ...... 4-21
4.6.2 Sorting of Data 4-20
4.6.3 Action Menu ' . . 4-21
4.7 Printing Results . 4-23
4.8 Downloading from TRI ' '. . . 4-24
4.8.1 Exporting Sets 4-24
4.8.2 Form Designer 4-24
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
APPENDIX B
APPENDIX C
APPENDIX D
APPENDIX E
APPENDIX F
APPENDIX G
APPENDIX H
Sources for Further Assistance .. . A-l
TRI Reporting Form (EPA Form R)......... . . ....... B-l
List of Chemicals Reported for 1992 ........... C-l
State and Territory Abbreviations ..... . . . . . . . . D-I
TRI Data Element Descriptions ...........".:. . . E-l
Standard Industrial Classification Codes for
Facilities Reporting to TRI . F-l
Practice TRI Searches . . ...... . . G-l
TRI Quick Search Guide ... H-l
INDEX ...... 1-1
-------
-------
1.0 Introduction
This chapter will explain the use of this Manual and its format. It contains a brief overview
of the Toxic 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 TMs Manual
This Manual is intended as both a learning arid 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 - TRI Chemical Substance Fact Sheets
Chapter 4 - Toxic Release Inventory Database
Chapter 5 - Performing Calculations With KASTAT
Additionally, there are eight "appendices containing information to assist you in using the TRI
CD-ROM. For example, Appendix H, 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 .
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 Toxic Release Inventory
1.3.1 Background
In 1984 a deadly cloud of methyl iscyaftate Mlled 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 Toxic 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 requires manufacturers to report releases of more than
300 designated toxic chemicals to the environment. 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.
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.
Page 1-2
CD - ROM User's Manual
-------
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 the approximately 300
designated chemicals or 20 chemical categories specified in th'e law, 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.
Over 80,000 reports - representing billions of pounds of chemical releases - are submitted to
EPA each year by more than 20,000 manufacturing facilities.
1.3.4
Seope 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.
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.
CD - ROM User's Manual
Page 1 - 3
-------
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.
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 offsite 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.
Page 1 - 4
CD - ROM User's Manual
-------
These changes to TRI will highlight the importance of pollution prevention and encourage
reporting facilities to develop and implement strategies for reducing waste. This new
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 Toxic 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.
" . v
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.
Businesses Manufacturers can use the 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 important of all, the publicity that
has resulted from the availability TRI data has caused many companies to voluntarily
pledge toxic chemical release reductions. *
CD - ROM User's Manual
Page 1 - 5
-------
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 with 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.
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.
In one typical instance, a coalition in Silicon Valley in California used TRI figures
successfully to cut releases by local industries. National public interest groups often
publish reports based on the TRI data. In two examples, a study highlighting the
nation's toxic polluters and a report naming companies releasing known ozone-
depleting chemicals were developed as a result of the availability of the TRI data.
The TRI data is also vital for presenting a convincing case to influence legislators.
Public interest groups in Massachusetts figured prominently in the passage of the
nation's first state toxics-use reduction law, and many other states have followed suit.
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 toxic 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.
Page 1-6
CD - ROM User's Manual
-------
Local Emergency Planning Committees (LEPCs) EPGRA required each SERG 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 bnsite by local facilities, for thir 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. -
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.
CD - ROM User's Manual
Page 1 - 7
-------
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.
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.
Page 1-8
CD - ROM User's Manual
-------
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.
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 releases 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 lexicologists 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. -
CD - ROM User's Manual
Page 1-9
-------
Locate the Local Emergency Planning Committee (LEPQ. The EPCRA legislation that
created TRI also established LEPCs to plan for emergency action in the event of hazardous
chemical spills and similar incidents. LEPCs 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.
Call the Agency for Toxic Substances and Disease Registry f ATSDR'). 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-0727.)
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 README.RGS). 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.
' v
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.
Page 1-10
CD - ROM User's Manual
-------
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, B.C. 20401 ,
202-512-1800 (general sales) .
202-512-1530'(computer products)
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 set. Together, the two discs contain the complete
TRI for the years -1987-1992. (The data base is divided into two files that appear on Disc 1
and Disk 2, respectively. See Section 2.6.2 for a more detailed decription 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 operators
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
statistical analyzer (KASTAT)
form designer for creating custom reports :
brief user guide (inserted into CD-ROM case)
CD - ROM User's Manual
Page 1 ~ 11
-------
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
offsite 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
Page 1 -12
CD - ROM User's Manual
-------
1.4.4
TRI Data on Internet
TRI data is. now available through the Internet in several ways. EPA recently established an
agency-wide gopher that provides access to a broad range of environmental information. (A
"gopher" is the terminolgy used to describes method of accessing an organized collection of
computer files over the Internet. A gopher is usually associated with a particular
organization or source for information.) The TRI data contained in the EPA Internet gopher
is expected to^expand over time. At the time of this writing, the EPA gopher contains the
complete text and tables that comprised the printed report, 1992 Toxics Release Inventory:
Public Data Release, released in April 1994. '.-'.
The address for the EPA gopher is: gopher.epa.gov. To browse TRI data, select "the
following menu choices: . "-,...;
EPA Offices and Regions/ ' - '
Office of Prevention, Pesticides, and Toxic Substances/
Toxic Substances/
Toxic Release Inventory (TRI) 1992/ '. " .
MetaData Record
The National Library of Medicine TOXNET data base, including all data for all years of
TRI, is also available on the Internet. The address for the file is: toxnet.nlm.nih.gov. An
NLM password is necessary to use the file. (See 1.4.3.)
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.
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). ..'..
CD - ROM User's Manual
Page 1-13
-------
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 fiche 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
(EPA_TR92), 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.
1.5 TRI User Support
For the convenience of TRI data users, EPA offers users support services over the telephone.
Contractor staff are available on weekdays from 8:30 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.
Page 1 -14
CD - ROM User's Manual
-------
1.6 Other Available Reference Materials
There are many reference materials that provide additional information about the Community
Right-to-Know Act and the Toxic 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 or 703-920-9877 in Virginia or Alaska):
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. 1992 (25 pp.) Free
Chemical Releases and Chemical Risks. A Citizen's Guide To Risk Screening. 1989
(8pp.) Free " .
): TRI Publications List. 1993
Public Access to the Toxic Release Inventory f]
(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. 1992 (58 pp.) Free
Common Synonyms For Chemicals Listed Under Section 313 of the Emergency
Planning and Community Right-To-Know Act. 1992 (110 pp.) Free
Additional resources:
Chemicals, the Press and the Public: A Journalist's Guide To Reporting on
. Chemicals in the Community
Environmental Health Center, National Safety Council
1-800-621-7615
1989 (119 pp.) $9.95
The Toxic Release Inventory. Environmental Democracy In Action
TRI US
202-260-1531 , . ,
1992 (7 pp.) Free
CD - ROM User's Manual
Page 1 - 15 ,
-------
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 Communicatipn Hotline
(202)260-5606
Page 1 -16
CD - ROM User's Manual
-------
2.0 Accessing TRI On CD-ROM
The 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. (The TRI software can
run on a 286, but you will receive better performance on a 386 or higher.)
640K RAM (with 540K 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-1992 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 format, and thus most discs in use today, requires the
use of software called CD-ROM Extensions. CD-ROM Extensions are usually supplied by
the vepdor 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 "edit, these files, you will need to use
a utility for editing files, or EDLIN, the- utility software provided with older versions of
MS-DOS. (For instructions on using the edit utility software that is available to you, consult
the documentation that accompanies the software. If you will be using EDLIN, review the
use of that software in,the DOS manual).
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:dri\ver alias M:8/L:L
A typical example of this line might be:
\bin\MSCDEX/d:MSCD001/M:22/L~:L
In this example, bin is the directory where the program MSCDEX is located; MSCDEX is
the program commonly called CD-ROM Extensions. 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-1992 TRI CD-ROM set. Installation can usually be completed in a few
simple steps.
In previous years, installation instructions for TRI required that the software be installed in a
directory called TRI. This edition of TRI, because it is on two discs, requires creation of
two different subdirectories for software installation. The examples below use REL (for the
Releases file) and TRT (for the Treatment file). You can use any names that you like; try to
choose something that you will recognize, like TRIDISC1 and TRIDISC2.
Before you begin, you may want
to delete software for earlier
editions of TRI, found in the TRI
directory, since each new edition
of TRI is cumulative. (Removal
of old software from the TRI
directory is essential if you plan
to use that subdirectory name
again.) Companies are permitted
by law to revise TRI reporting
forms for previous years; the
updated forms are included on
the latest disc. By deleting old
software, you will be able to free
up several megabytes of hard
disk space.
Create a directory for installing
software for accessing the
Releases file from Disk 1. You
may choose any name that you
wish. To create a subdirectory
called REL, at the C: > prompt,
enter:
TRI
-1+ Insert Disc X''i'n/tfie.. CD-ROM, drive.
'2 *' Eriter %he cfMROM dViv'e' letter and
3 * Follow prompts an the "installation
scr'e'e'nj""""""""'"' HlZ'T'T'
a Enter" 8D'«ROMdVive letter, e". g.,
> , ~. .
b. Enter, path, -tto place software In
of you* choice,
c, It "new directory** gyompt appears,
press y «
d, 'if "Qyerwrlte, files" prompt
'appears, presV'x: .
Wait for files to complete copying. At the
DOS prompt, type TS.J. . select
i;'
js-i , -j. 2 "'i "'* * - j ' < s£ K-"-"'" fffff'
installation of: Disc 1»
/Itjpert iisp 2 iii the CD-ROM drive.
..' ''. &$«'?&> ~i*t*$fr&&mf&ti?"-tr"'
Complete steps 2>*4 for Disc 2. Choose a
""different subdirectory name (e,g,, c;\TRT)
a,nd select \preatemeat" file (not Releases)
from,the main menu.
C: >md REL < ENTER >
Page 2-4
CD - ROM User's Manual
-------
Change to the directory that you just created, as follows, substituting the subdirectory name
that you created for REL in this example:
C:>cd\REL < ENTER >
The DOS prompt should now read: :
C:\REL>
Insert Disk 1 into the CD-ROM drive with the label facing up. Install selected" files from
TRI Disk 1 on your hard disk.. Type the CD-ROM drive letter followed by the word,
"install" (no quotes). For example, type:
C:\REL > Lrinstall < ENTER >
where the CD-ROM drive letter is L. .
NOTE: If you are uncertain of the drive letter assigned to the CD-ROM drive, you can
often tell by viewing 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:L
f ...
The letter following L: at the end of the line, (in this case, L:L) 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. 1
The first installation screen will ask you to enter the letter for the CD-ROM drive. Using
the example above, you would type: -
' . .. L , '' : ' '"/-. ."-.
The next screen prompt gives you the option to edit the path where the software will be .
installed. After editing the path (if necessary) or when you are ready to continue, press
. ' :"..;.
If you are installing TRI the software into an existing directory, a prompt will appear to ,
warn you that any existing files in the directory may be overwritten or appended. At the
Screen prompt,- type:
..' Y . . ... .' ' - .- :
CD - ROM User's Manual
Page 2 - 5
-------
You will proceed with the installation. The message "COPYING PLEASE WAIT" will
appear on the screen and will remain until the software installation is complete.
If you encounter an error message or any other indication of a problem, proceed to Section
2.1.5, Troubleshooting Software Installation.
After the software installation is successfully completed, at the subdirectory prompt, type:
TRI
The main menu (displayed in Section 2.4, Accessing the Toxic Release Inventory) will be
displayed. To ensure that the CD-ROM is properly installed, select "1. Chemical Substance
Fact Sheets." You will see a message "Loading KAware2 with L:\TRIFACTS\FACTS\ -
Please Wait." Press when the next screen appears. If the software for
retrieving the Fact Sheets has been successfully installed, the next screen will contain
function key descriptions (i.e., Fl = Help) at the top and bottom of the screen. Press F10
to exit.
Next, to test software installation for the TRI data base, select "2. Toxic Release Inventory."
The system will respond by displaying the Data Files Screen. Select the RELEASES file and
press . (The message "File Not Found " may appear briefly on the screen, but
you may disregard it. The file is actually created during initial installation.) If the software
for retrieving TRI has been successfully installed, the next screen will contain function key
descriptions (i.e., Fl= Help) at the top and bottom of the screen. Press F10 to exit.
Remove Disc 1 from the CD-ROM drive and insert Disc 2. Repeat the same installation
procedure as outlined above for Disc 1, except use a different name (for example, TRT) for
the subdirectory where the software is installed. The main menu will look the same as it did
when you installed Disc 1. However, the Data Files Screen will list the TREATMNT file,
instead of the RELEASES file.
2.1.5 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.
CDR101:Not 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.
Page 2-6
CD - ROM User's Manual
-------
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., TRIP ACTS) 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 .)
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, it may mean that installation was
interrupted or did not complete successfully for some other reason. (There should be 16 files
totalling 619,318 bytes in the subdirectory where software for Disc 1 (Releases) is installed,
and 14 files totaling 621,578 bytes in the subdirectory where software for Disc 2 (Treatment)
is installed as soon as installation is completed. Additional files are added as soon as you
call up the RELEASES or TREATMNT files in TRI and the Fact Sheets, resulting in up to
25 files in each directory.) The easiest solution is to erase files in the subdirectories and
repeat the installation procedure. -
CD - ROM User's Manual
Page 2 - 7
-------
Display shows something other than TRI Installation Screen
This error may occur if the CD-ROM reader is reading from a subdirectory 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 >.)
Iff] Additional Bytes of Available Memory Required To Run KAware2 Press ENTER to
Exit KAware2
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 540K 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 , 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.6 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,
540K 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 multi-media 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.
Page 2 - 8
CD - ROM User's Manual
-------
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; (o* mm&fatm Jess) memory with which
yea are most familiar is known as conventional
mieniojfy, also called random access memory
(RAM)* Conventional memory can be used in
many way$, iftclwdtng loading "and^ executing
programs* for DOS and device drivers, and
temporarily Storing data, D0$ applications, like the
TRI CD-RQM> require access to varying amounts
of RAM fok 0Ȥr' *o, rtta, CERI requires 540K
RAM*) Most PCs in use today also have an
additional 3S43C memory (transparent to the user),
that Increases memory from 64QK to, 1 MB. Use of
tht$ space, &K>wttfts "tippe* memory," is somewhat
restrieted. For example, It is not accessible to most
programs sn4 earlier versions of DOS (before 5.0).
Expanded nj$ntory, developed _to overcome the
640K DOS barrier {before DOS 5*0), requires
ittstallatiott of * catd m an expansion slot on your
PC. - Expanded memory allows you to use
poBVefttJonai aj&MOry store efgcje&tly by swapping
data from expanded memory in and out of
eonveBtioaal j&satory very quickly in 64K blocks.
Thus* your computer is "fooled" into using
piogtam$ that ate actually stored on the expansion
' card.
Extended memory, developed after expanded
memory was mdely available, uses a completely
different approach. This is an area above 1 MB (up
to 32 MB) that M aooessibfe from * cMp *a the
motherboard. Extended memory is only available
on $02$$ and fi*s&r tnachittes, Sotne programs,
such as Windows and Lotus 1-2-3, can Mly utilize
extended ausmOry Just as though ft was part of the
conventional 640IL -
There is one other type of memory - high memory -
whi<& is tae first £4K of extended, memory, .
CD - ROM User's Manual
Page 2-9
-------
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 configiSys 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 the 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 Toxic 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. .
Page 2-10
CD - ROM User's Manual
-------
2.2.2 Toxic Release Inventory
The complete Toxic Release Inventory for all six years of its existence (1987-1992) is
contained on the two discs that comprise the TRI. Disc 1 contains the Releases file and Disc
2 contains the Treatment file (described below). For more information, see
Chapter 4.
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.
The TREATMNT file is used to search for data on waste treatment methods and
efficiency, and waste minimization. ._. ' .-;
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 ReadmeFiles
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.EPA: Contains descriptions of all the data fields including codes and translation
of coded information.
README.RGS: Contains the names, addresses, and telephone numbers of the 10 Federal
EPA Regional contacts.
README.SIC: Contains the four-digit Standard Industrial Classification codes for 20-39
and the code descriptions. .
README. STA: Contains the names, addresses, and telephone numbers of the State and
Territorial TRI contacts.
, CD - ROM User's Manual
Page 2 - 11
-------
2.4 Accessing the Toxic Release Inventory
In order to access TRI on the CD-ROM:
1. Turn on the CD-ROM drive and 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 drive C. If not, type: '
C:
4. Access the directory where the TRI CD-ROM software was loaded (e."g.,
REL, in the example shown earlier in this chapter):
CDREL
5. To begin accessing TRI, at the subdirectory DOS prompt (e.g., C:\REL>),
type:
TRI
The first screen you will see is the Data Base Selection menu:
DATA BASE SELECTION
1 Chemical Substance Fact Sheets
2 Toxic Release Inventory
3 Calculation Feature (KASTAT)
4 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 4, 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, start with #5 above and proceed with the
instructions. '
Page 2-12
CD - ROM User's Manual
-------
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 i-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.
-*-' ----- ' ' - .
CD - ROM User's Manual
Page 2 - 13
-------
-------
3.0 TRI 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 number.
For your convenience, Chemical Substance Fact Sheets are provided on both TRI discs, and
can be accessed from the main menu on Disc 1 or Disk 2.
Press < ENTER > to Select #f, Chemical Substance Fact Sheets, from the DATA BASE
SELECTION MENU.
DATA BASE SELECTION
1 Chemical Substance Fact Sheets
2 Toxic Release Inventory
3 Calculate Releases (KASTAT)
4 QUIT TRI CD-ROM Disc
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.
Page 3-1
CD-ROM User's Manual
-------
Press < ENTER > to continue. The TRI FACT SHEETS MAIN MENU (with F3
Select, highlighted) will appear.
TRI FACT SHEETS - KAwareZ (tm) FullText
V1.50 '. '
F1 = Help F2 = Options F3 = Select " F4 = Search F5 = Sets
TABLE OF CONTENTS
COHHON NAME
CAS NUMBER
TEXT
GLOBAL INDEX
Set #Fouxi
(Page 1 of 1
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REMAINING=12000
F6=Oisplay
F8=Group T
V 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 - KAware2 (tm) FullText V1.50
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 REMAINIMG=12000
F6=Di.splay F7=Group i F8=Group T ' F9=Group V 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 (tin) FullText V1.50
_J
F
'age/Line Up ESC to Exit ' Page/Line Down
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 will find prompts for using the Display Manager
in the top and bottom 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 marking/saving/printing, addition
of your notes to the file, etc. *
=
SEARCH SET=0 DISPLAY SET=0 WORKSPACE REHAINING=12000
F6=0isplay F7=Group A F8=Group T F9=Group V 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.50
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=12000
F6=Oisplay F7=Group
F8=Group
F9=Group
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 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 Cmreflt 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 - KAwareZ (tm) FullText V1.50
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
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REMAINING=12000
F6=Display F7=Group
F8=Group T
V
F10=Exit
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.
PageS -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 . 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 - KAware2 (tm) FullText VI.50
Fl = Help F2 = Options F3~ = Select F4 = Search
F5 = Sets
Comnon Name: 1,1,2,2-Tetrachloroethane
Common Name: 1,1.2-Trichloro-1.2,2-Trifluoroethane
Comnon Name: 1,1,2-Trichloroethane
Common Name: 1,2,4-Trichlorobenzene
Comnon Name: 1,2-Butytene Oxide
Cannon Name: 1,2-Dichlorobenzene'
Comnon Name: 1,2-Dichloroethane
Conmon Name: 1,2-Dichloroethylene
Conmon Name: 1,2-Dichloropropane
Conmon Name; 1,2-Dihydroxybenzene
CPage 1 of 33)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0
DISPLAY SET=0
WORKSPACE REHAINING=12000
F6=Display F7=Grotp
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 - KAuareZ (tin) FullText V1.50
F1 = Help FZ = Options F3 ="Select F4 = Search
Set #Fo
F5 = Sets
COMMON NAME
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=Q
WORKSPACE REMAINING=12000
F6=0isplay F7=Group
F8=Group T
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 .50
F1 = Help F2 = Options F3 = Select F4 = Search
Set #Found
1 1/1
CPage 1 of 1)
COMMON NAME: BENZYL [1]
F5 = Sets
COMMON NAME
BENZAL [1]
BENZAMIDE [1]
BENZENAMINE [11
BENZENE [31
BENZIDINE [1]
BENZOQUINONE [1]
BENZOTRICHLORIDE [1]
BENZOYL [21
BENZYL [1]
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=1 DISPLAY SET=0
WORKSPACE REHAINING=11999
F6=0isplay 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 (nq 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
-------
Type the complete CAS number and press . 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 - KAuareZ (tin) FullText V1.50
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set #Fo
CAS NUMBER
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 REHAINING=12000
F6=Oisplay F7=Group I F8=Groqp T F9=Groi4>V F10=Exit ESC=Backup
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 type 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 - KAuareZ Ctm) FullText V1.50
Ft = 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=Q
DISPLAY SET=0
WORKSPACE REHAINING=12000
F6=Display F7=Group A F8=Group T F9=Groni V F10=Exit ESC=Backup
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 . A listing of text that contains
"BEN" will appear. Select the correct text and press . >
Page 3 - 11
CD-ROM User's Manual
-------
TRI FACT SHEETS - KAuareZ (tin) FullText VI.50
F1 = Help F2 = Options F3 = Select F4 = Search
Set #Found
1 1/1
(Page 1 of 1)
COMMON NAME: BENZYL [1]
F5 = Sets
TEXT
BENEATH [1]
BENEZENEDIAHINE II]
BENHEXACHLOR [1]
BENZ [11
BENZ-0 11]
BENZ-0-CHLORO [1]
BENZAL [42]
BENZALDEHYDE B]
BENZAHIDE [44]
BENZAZINE [1]
(Page 1 of 5)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=1 DISPLAY SET=0
WORKSPACE REHAINING=11999
F6=Display F7=Group
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 - KAware2 (tin) FullText VI.50
F1 = Help F2 = Options F3 = Select F4 = Search
Set #Fo
F5 = Sets
GLOBAL INDEX
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 REHAIHING=12000
F6=Display F7=Group
F8=Group t F9=Group V 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 - KAware2 (tm) FullText V1.50
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set #Found
(Page 1 of 1)
GLOBAL INDEX
CHLORACNE [TEXT 5]
CHLORAHBED [TEXT 1]
CHLORAMBEN [COMMON NAME 1]
CHLORAHBEN [TEXT 37]
CHLORATE [COMMON NAME 1]
CHLORATE [TEXT 241
CHLORATES [TEXT 841
CHLORDANE [COMMON NAME 1]
CHLORDANE [TEXT 40]
CHLORETHENE [TEXT 1]
(Page 1 of 9)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0
DISPLAY SET=0
WORKSPACE REHAIHIHG=12000
F6=0isptay F7=Group A F8=Group t F9=GroiJp
F10=Exit ESC=Backt4>
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 (tm) FullText V1.50
F1 = Help F2 = Options F3 = Select F4 = Search
Set #Found
(Page 1 of 1)
F5 = Sets
Change Search Sets
Combine Sets
Delete a Set
Delete All Sets
Display a Set
Export a Set
Export from Table of Contents
Load Set List
Print a Set
Print from Table of Contents
Save Set List
Select Display Set
Select New Data File
Temp Exit to DOS
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE RENAINING=12000
F6=0isplay F7=Group
F8=Group T F9=Group
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 Search Sets - This selection allows you to change to a specific set you have
created and search for further information within that specific set. If you do not
specify a set, the TRI software will search-the entire file. (The. current search set is
shown at the bottom of the screen. SEARCH SET=0 means that the entire database
is being searched.) Once the search set is changed, you must change the set back to
zero (0) if you wish to resume searching the entire file. Using the Change Search Set
option saves time and memory space, as the TRI software searches the entire database
once, and then searches within the smaller set that was previously defined, to search
for the second condition.
CD-ROM User's Manual
Page 3- 14
-------
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 - (CAware2 (tin) FuLLText V1.50
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set #Found
(Page 1 of 1)
Select an Operator:
Combine with AND
Combine with OR
Combine with HOT
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REMAINING=12000
F6=Display F7=Group
F8=Group T F9=Group V F10=Exit ESC=Backup
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 ypu 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 - KAwareZ (tin) FullText VI .50
F1 = Help F2 = Options F3 = Select F4 = Search F5 = Sets
Set
(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=12000
F6=0isplay F7=Group 4. F8=Group t
F10=Exit ESC=Backup
If you answer YES by typing 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 - KAuare2 FullText VI.50
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set #Fcxnd
(Page 1 of
Enter the lumber
of the set to
be displayed:
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SIET=0
WORKSPACE REHAINING=12000
F6=Display
F8=Grou|) T F9=Group
F10=Exit ESC=Backup
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
< EXIT > 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.
t '
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 - KAwareZ (tin) FullText VI .50
Search #1 Document #1 of 1 Line-1 of 385
Content: Common Name: Benzyl Chloride
Common Name:
CAS Number:
DOT Number:
Date:
Benzyl Chloride
100.-44-7 .
UN 1738
August 1, 1987
HAZARD SUMMARY ,
* Benzyl Chloride can affect you when breathed in.
* Because this is a HUTAGEN, handle it as a possible cancer
causing substance WITH EXTREME CAUTION.
* Benzyl Chloride may 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 buildup of fluid in the lungs
(pulmonary edema). This can cause death. .
IDENTIFICATION
I T /PgUp/PgDn=Move ENTER=Action Menu ESC=Backup F2 thru F5=Exit
Ctrl PgUp/Pcpn=Nen Document ^Posted 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 4, F8=GROUP t, F9=GROUPV Keys
F7=Group 1. 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 . A down arrow will appear next
to that item. Move the highlight bar to the last item in the range and press < F8 >. 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=EXIT Key
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 - KAware2 (ttn) FullText V1.50
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)
(Ctrt-PgUp/PgDn changes Set List page)
SEARCH SET=0 DISPLAY SET=0
WORKSPACE REMAINING=12000
F6=Display F7=Group
F8=Group T F9=Group V 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 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 > .
f
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 . 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 methylena 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.FS
= Sets option pull-down menu. Choose the Combine Sets selection and highlight the
Combine With AND option and press and press 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 - KAware2 (tm> FullText V1.50
Search #1 Docunent A3 of 3 Line 1 of 412
Content: Common Name: Hethylene Chloride
Conmon Name:
CAS Number:
DOT Number:
Date:
Hethylene Chloride
75-09-2
UN 1593
Hay. 1989
HAZARD SUMMARY
* Hethylene Chloride can affect you when breathed and by passing
through skin. .
* Hethylene Chloride should be handled as a CARCINOGEN WITH
EXTREME CAUTION.
* Exposure to high'concentrations causes unconsciousness and
even death. Lower exposures can cause headaches, fatigue,
unsteadiness and "drunk" 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.
t/l/Pgup/PgDrv=Hove ENTER=Action Menu ESC=Backup F2 thru F5=Exit
Ctrl PgUp/PgDn=New 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 - KAwareZ (tin) FullText VI.50
Search #1 Docunent S3 of 3 Line 1 of 412
Content: Conmon Name: Hethylene Chloride
Conmon Name:
CAS Umber:
DOT Number:
Date:
Hethylene Chloride
75-09-2
UN 1593
Hay, 1989
HAZARD SUMMARY
* Hethylene Chloride can affect you when breat
through skin.
* Hethylene Chloride should be handled as a CA
EXTREME CAUTION.
* Exposure to high concentrations causes uncon
even death. Lower exposures can cause headac
unsteadiness and "drunk" 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 HARK (alt-m)
CANCEL HARK (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/VPgUp/PgDn=Hove ENTER=Action Henu ESC=Backup F2 thru F5=Exit
Ctrl PgUp/PgDn=New Docunent -b=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 .
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 < ALT > and
the 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 < ESC >, 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
-------
TRI FACT SHEETS - KAuare2 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:\TRT).
3.8 Load Set List
Use the Load Set List option to retrieve a Fact Sheet set list mat 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 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 Toxic Release Inventory
Data Base
The Toxic Release Inventory data base is divided into two files. TRI Disc 1 contains the
Releases provides comprehensive information about the facility and the amount of chemicals
that they reported releasing. Disc 2 contains the Treatment file, which provides information
about waste treatment methods used by the facility for treating chemicals onsite. Refer to
Section 2.2, TRI CD-ROM Structure, for more information.
Insert either Disc 1 or Disc 2 into the CD-ROM drive. Change to the subdirectory where '-
software for accessing mat disc was installed. Type TRI to retrieve the DATA
BASE SELECTION MENU. Select 2. Toxic Release Inventory by moving the down >
arrow and pressing or press <2> and then press . ,
DATA BASE SELECTION
1 Chemical Substance Fact Sheets
2 Toxic Release Inventory
3 Calculate Releases (KASTAT)
4 QUIT TRI CD-ROM Disc
The DATA FILES SCREEN lists either the RELEASES file or the TREATMNT file,
depending on the disc chosen. For Disc 1, the DATA FILES SCREEN lists the
RELEASES file:
. KAwareF (tin) Retrieval System/ Fielded VI.35
Select .Data File or Press F4
RELEASES
tm
KAwareF 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
CD-ROM User's Manual
Page 4-1
-------
If Disc 2 is loaded, the DATA FILES SCREEN lists the TREATMNT file:
KAwareF (tin) Retrieval System / Fielded V1.35
Select Data File or Press F4
TREATMNT
tm
KAwareF RETRIEVAL SYSTEM
copyright (c) 1985-91
Knowledge Access International
Mountain View, CA 94043
F2 = Shell
F4 = New Path
>10 = Quit
ESC = Exit
ALT-C = Colors
The primary purpose of the TRI software is to provide the capability to search for specific
data on toxic chemicals released into the environment by manufacturing facilities. Each of
these files can be searched using similar searching techniques to obtain useful information.
The following sections will describe in detail the steps used to search for data and display
and print the results from these searches. The varied searching capabilities allow you to
retrieve and collect sets of information that may be of interest.
Press < ENTER > and a second screen will be displayed:
TRI
RELEASES
ENVIRONMENTAL PROTECTION AGENCY
For Information and Assistance:
TOXIC RELEASE INVENTORY USER SUPPORT
(202)260-1531
tm
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
-------
OR:
TRI
TREATMNT
ENVIRONMENTAL PROTECTION AGENCY
For Information and Assistance:
TOXIC RELEASE INVENTORY USER SUPPORT
(202)260-1531
tm
KAwareF RETRIEVAL SYSTEM.
copyright (c) 1985-91
Knowledge Access International
Mountain View, CA 94043
PRESS ENTER TO CONTINUE
4.1 Choosing A Data File
Select the data file contained on the disc by pressing . The two files,
RELEASES and TREATMNT, are described below: '.'..'
RELEASES .-'This file, contained on Disc 1, 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 (POTW) 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 TRI would also reveal transfers of chemical wastes to local Publicly
Owned Treatment Works (also called sewer plants) 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).
TREATMNT - This file, contained on Disc 2, 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 on Disc 2 if treatment information is
also desired.
CD-ROM User's Manual
Page 4-3
-------
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 = Hew 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 Retrieval System / Fielded V1.35
Welcome to KAwareF
Current Drive is:
L:\TRIFIELD\
Select Data Files from which
Drive,and Directory? If you
are unsure where your files
are located, you may press F2
and Shell to Dos to find them,
then type EXIT for KAwareF.
tm
KAwareF 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 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.,
L:\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.
Page 4-4
CD-ROM User's Manual
-------
F10 = Quit - For this option, a box is displayed:
' KAwareF (tm) Retrieval System / Fielded VI.35
Welcome to KAwareF
Current Drive is:
L:\TRIFIELD\
Select Data Files from which
Drive and Directory? If you
are unsure whe
are located.
and Shell to D
then type EXIT
Are you sure you want to exit? (Y/N)
tm
KAwareF RETRIEVAL SYSTEM '
copyright (c) 1985-91
Knowledge Access International
Mountain View, CA 94043
F2 = Shell
. F4 = New Path
F10 = Quit
ESC = Exit
ALT-C = Colprs
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 arid
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. .
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
DOWNLOAD (export) 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.
CD-ROM User's Manual
Page 4 - 5
-------
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, or by EPA
submission number. The EPA submission number 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, it is possible to 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 , the TRI DATA FILES
MAIN MENU associated with the file that you have chosen is displayed automatically. If
you selected the RELEASES file (contained on Disc 1), the following DATA FILES MAIN
MENU is displayed:.
TRI - KAwareF (tm) fielded V1.35
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set #Found (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 WORKSPACE: 256000
F6=Display F7=Group \. F8=Group T F9=Group
F10=Exit ESC=Backup
Page 4-6
CD-ROM User's Manual
-------
If Disc 2, containing the TREATMNT file, is present in the CD-ROM drive when you begin
your search session, the following DATA FILES MAIN MENU will appear:
TRI - KAwareF (tm) Fielded V1.35
F1 = Help F2 = Options F3 = Select F4 = Search F5 = Sets
Set #Found (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=Display F7=Group I F8=Group T F9=Group
F10=Exit ESC=Backup
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 - KAwareF (tra) Fielded V1.35
F1 = Help F2 = Options F3 = Select F4 = Search
Function Keys
Options
Select
Search
Sets
Display
Hailing Labels
F5 = Sets
e 1 of 1)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=0 WORKSPACE: 256000
F6=Display F7=Group
F8=Group T F9=Group V F10=Exit ESC=Backup
The HELP option includes assistance with function keys and their corresponding uses. The
HELP option is available at any time while you are in the TRI Data Files by pressing the Fl
key. Use the PgUp/PgDn keys to move within the HELP text. Press 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
TRI - KAwareF (tm) Fielded V1.35
F2 = Options F3 = Select F4 = Search
F5 = Sets
Set #Found
Search Set:
Group Search:
Post Search:
Output Set:
Output Format:
Non- Label Print Format:
Output Order:
Printout Title:
Export Format:
Export File Name Prefix:
Save Current Settings
ENTIRE DATABASE (SET 0)
GROUP ONLY
RETURN TO SELECT (F3)
LAST SET CREATED
RELEASES
CONSECUTIVE PRINT
DEFAULT ORDER
TRI
COMMA DELIMITED
C:\REL\RELEASES
(Ctrl-PgUp/PgDn changes Set List page}
SEARCH SET=0 OUTPUT SET=0 WORKSPACE: 256000
F6=Display F7=Group
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 the 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 < Y> 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 (tm) Fielded v'1.35
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set #Found (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 WORKSPACE: 256000
F6=Display F7=Group
F8=Group 'T F9=Group i/ . F10=Exit ESC=Backup
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.; substance (chemical) name; release medium, i.e., air, water, etc.; and
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 TREATMNT data file is displayed below:
F1 = Help F2 = Dotions F3 = Select F4 = Search F5 = Sets
TRI - KAwareF (tm) Fielded V1.35
F2 = Options F3 = Select F4 = Search
Set #Found . "
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 six
reporting years for which data is available, 1987 - 1992. Use the down arrow to
identify reporting year on the pull down menu for F3 = Select and press
. The F4 = Search menu listing all of the reporting years available will
appear automatically (see screen below). Use the down arrow again to highlight 1992
as the year of choice and press .
CD-ROM User's Manual
Page 4 - 11
-------
(Note that searching by reporting year is slower than most other searches because it
will retrieve over 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 - KAwareF (tin) Fielded V1.35
F1 = Help F2 = Options F3 = Select F4 = Search
REPORTING YEAR
1987
1988
1989
1990
1991
1992
F5 = Sets
Set #Found (Page 1 of 1)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=0 WORKSPACE: 256000
F6=Display F7=Group
F8=Group T F9=Group
F10=Exit ESC=Backup
Page 4-12
CD-ROM User's Manual
-------
TREATMENT METHOD - This data element from the TREATMNT file provides a
list of 79 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 . The F4 = Search menu listing 79 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 < ENTER >.
TRI - KAwareF (tin). Fielded V1.35
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set #Found
TREATMENT METHOD/SEQUENCE
FLARE '
FLARE
FLARE
CONDENSER
SCRUBBER
ABSORBER
ELECTROSTATIC PREGIPITATOR
MECHANICAL SEPARATION
OTHER AIR EMISSION TREATMENT
BIOLOGICAL TREATMENT -- AEROBIC
' (1 of 79)
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=0 WORKSPACE: 256000
F6=Display F7=Group
F8=Group T F9=Group
F10=Exit ESC=Backup
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 through
1992: However, there will also be instances when you will want to enter the value by which
you wish 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 P4 =
Search appears:
TRI - KAwareF (tm) Fielded V1.35
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set #Found (Page 1 of 1)
FACILITY NAME
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 OUTPUT SET=0 WORKSPACE: 256000
F6=Display F7=Group
F8=Group T F9=Group
F10=Exit ESC=Backup
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.
TRI - KAwareF
-------
To mark the beginning of a range of consecutive terms, move the highlight bar with the up
and down arrows to the first term to start the range and press . A down arrow will
appear next to the item. In our example of the GM terms, mark GM with the F7 key.
Move the highlight bar to the last item in the range that you want and press < F8 >. 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 arrows and press < F9 > . 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.
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 - Kawaref (Urn) Fielded V1.35
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set
1
2
3
#Found (Page 1 of 1)
1790 FACILITY NAME: MONSANTO
37100 FACILITY STATE: CA
67 COMBINE: MONSANTO IN CA
ueieie ea OGL
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 WORKSPACE: 217043
Change Output Set
Change Search Set
Combine Sets
F6=Display F7=Group
F8=Group T F9=Group
F10=Exit ESC=Backup
Page 4-16
.CD-ROM User's Manual
-------
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 search (unless it was changed from the default
setting using the F2 or F5 key). '. .-.'-.''
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 1992 reporting year and Monsanto for the facility name. Search for the 1992
reporting year first. Press . Select Change Search Sets and press
. 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 the 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.
CD-ROM User's Manual
Page 4 - 17
-------
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 specify first.
TRI - KAwareF (tin) Fielded V1.35
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set #Found (Page 1 of
1 1790 FACILITY NAME
2 37100 FACILITY STAT
3 67 COMBINE: MONS
Select an Operator:
Combine With AND:
Combine With OR:
Combine With NOT:
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=3 WORKSPACE: 217043
F6=Display F7=Group
F8=Group T F9=Group
F10=Exit ESC=Backup
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 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 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.)
Page 4 - 18
CD-ROM User's Manual
-------
Display a Set - This selection allows you display any user-defined set.
TRI - KAwareF (tm> Fielded V1.35
F1 = Help F2 = Options F3 = Select F4 = Search F5 = Sets
Set #Found (Page 1 of 1
1 1790 FACILITY NAME:
2 37100 FACILITY STATE
3 67 COMBINE: HCWSA
Enter the number
of the set to be
used:
(Ctrl-PgUp/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=3 WORKSPACE: 217043
F6=Display F7=Group
F8=Group T F9=Group
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. Five
format options are provided: 1) comma-delimited; 2) fixed field; 3) dBase; 4) Lotus; and 5)
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 C: drive. If you wish to
save the file to a drive other than the C drive, 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.
CD-ROM User's Manual-
Page 4 - 19
-------
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.
(This software feature is useful in products that contain multiple files on each disc.
However, since each of the TRI discs contain only one fielded data base - RELEASES or
TREATMNT - you will seldom have any reason to use this feature.)
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 >.
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.
Page 4-20
CD-ROM User's Manual
-------
" 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
mnemonic code identifying the information reported. For example, FM is facility name and
FAD means facility street address. (A complete list, of the data elements is provided as an
appendix to this document and in the Quick User 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 README.EPA.)
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.
CD-ROM User's Manual
Page 4 - 21
-------
1t = 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. 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 the EPA 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 - KAwareF (tm) Fielded V1.35
F1 = Help F2 = Options F3 = Select F4 = Search
F5 = Sets
Set
1
2
3
#Found
1790 F
37100 F
67 C
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 NAME
Display by SUM ALL RELEASES TO ENVIRONMENT
Display by SUM POTW AND OFFSITE TRANSFERS
Display by User Defined Rank
(Ctrl-PgUp/PgDn changes Set List
page)
SEARCH SET=0 OUTPUT SET=3 WORKSPACE: 217043
F6=Display F7=Group i F8=Group T F9=Group V
F10=Exit ESC=Backup
Page 4-22
CD-ROM User's Manual
-------
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 second screen listing the mnemonic tags for the data elements 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 (NAME) then by the sum
of releases into the environment (SENV), type 1 next to NAME and 2 next to SENV. To
sort SENV in descending order (highest'releases to lowest releases), type 1 next to NAME
and -2 next to SENV. 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.
Use the F7, F§, and F9 keys (described in Section 4.4.1, Indexing of Data) to
mark specific fields to be printed. This selection makes the data easier to
read.) .
Make your selection and press < ENTER >.
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 (tm) Fielded V1.35
F1 = Help F2 = Options F3 = Select F4 = Search
Set 3: COMBINE: TEST SET
F5 = Sets
RECORD #1 OF 423
SUBN 1387010100093WA
TRIM 98108BNGRS7755E
YR ' 1987
EPAR
FCOV
FM
FAD
FCTY
FCO
FST
FIPS
FZIP
PUBC
RN
NAME
GNM
MIX
MAX
LINE 1 of 216
Add User Input to Current Record (press Alt-U during display)
Jump"to Record by Number (press Att-J during display)
Print Current Record (press Alt-P during display)
Re-Rank Current Set (press Alt-R during display)
New Display Form (press Alt-.F during display)
ROBERT D. SMITH/206-773-2816
1330-20-7
XYLENE (MIXED ISOMERS)
1,000 TO 9,999
0-9=Speed
CD-ROM User's Manual
Page 4 - 23
-------
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 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.
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 or use the "shortcut" keys by
pressing the < ALT> and < J> key simultaneously. The Jump Record box appears:
TRI - KAwareF (tin) Fielded V1.35
F1 = Help F2 = Options F3 = Select F4 = Search
Set 3: COMBINE: TEST SET
F5 = Sets
Jump to what record number?
RECO #1 OF 423
SUBN 1387010100093WA
TRIM 98108BNGRS7755E
YR 1987
EPAR 10
FCOV A--AN ENTIRE
FH BOEING AEROSP
FAD 7755-EAST MAR
FCTY SEATTLE
FCO KING
FST WA
FIPS 53033
FZIP 98108
PUBC ROBERT D. SMITH/206-773-2816
RN 1330-20-7
NAME XYLENE (MIXED ISOMERS)
GNM
MIX
MAX 1,000 TO 9,999
LINE 1 of 216
0-9=Speed
Type in the number of the record in the set that you would like to review. As an example,
type <98> and press < ENTER >. Record 98 will be displayed.
Print Current Record - The current record will print on your screen.
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).
Page 4-24
CD-ROM User's Manual
-------
4.7 Printing Results
You can print a single rebord 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, while viewing a record on the screen, press < ENTER > to display
the ACTION MENU. Use the dov/n arrow to select, Print Current Record and press
< ENTER >. The current record will print on your local printer.
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 be entered. When the
information appears, use the down arrow to choose one of the three formats and press
: .' , , - . / .
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.
Use the F7, F8, and F9 keys (described in Section 4.4.1, Indexing of Data) to
mark specific fields to be printed)
Use the down arrow to choose Consecutive Print or One Page At a Time. Check your
printer and press 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) 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 - 25
-------
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 filename 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 filename that you specify when you save
data.
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:
FNM
FAD
FCTY
FST
FZIP
PUBC
RN
NAME
ABC Manufacturing Company
1065 Davidson Pike
Andersonville
IN
78856-9976
Benzene
Page 4-26
CD-ROM User's Manual
-------
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. Use the F7,
F8, and F9 keys (described in Section 4.4.1, Indexing of Data) to mark
specific fields to be printed.
Type the name of the file to export and the path, if it is different than the path currently
displayed. As an example, type <92FItE> and press < ENTER>. The system will add
a suffix to the file name based on the format you have chosen for the data.
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 in 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. If you are downloading complete records, you can use the RELEASES option, but it
may require a lot of disk space. If records containing fields such as SIC are downloaded
using the RELEASES (BRIEF) option or a User Defined Format (which is different from the
CD-ROM User's Manual
Page 4 - 27
-------
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 ah example of the form first, before actually creating the form.
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.
In order to use the Form Designer, you must exit the TRI CD-ROM. Press F10. Enter
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
on Disc 1 that was installed in a directory called REL, it should look like this:
C:\REL > KADFDES ©Releases < ENTER >
J ' ' ' .
If the form you are designing will contain data from the Treatmnt file contained on Disc 2
and installed, for example, in a directory called TRT, enter:
C:\TRT >KADFDES ©Treatmnt < ENTER >
Page 4-28
CD-ROM User's Manual
-------
The initial screen for the Form Designer will appear:
Version 1.30 KAware Disk Publisher/Fielded
2:49 pm
=== Form List
1 RELEASES
2 RELEASES (BRIEF)
KADF Form Designer for file releases
Form Information
Form Number: 2p!
Form Name: RELEASES (BRIEF) .
Form Type: P
Page Width: 76 Page Length: 60
Maximum Lines:
ESC=Menu
Use cursor pad to choose form, then select operation.
Fl=Help F2=Delete F4=Edit F5=Add F6=Insert F7=Copy F8=Moye
The first time that you use the Form Designer, only the RELEASES and RELEASES
(BRIEF) forms will be listed in the text box 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.
Press < F5 > 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
KAware Disk Publisher/Fielded
2:50 pfn
KADF Form Designer for file releases
Form Information
Form Number:
Form Name:
Form Type:
Page Width:
Maximum Lines:,
P
76'
Page Length: 60
Specify Form Information
Design Page Header
Design Page Detail '
Preview Form
Display Form Design
Print Form Design -
Save Changes
Specify form information
Fl=Help , ESC=Done
CD-ROM User's Manual
Page 4 - 29
-------
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." You can also change the
default settings for page width (76 spaces) and page length (60 lines) if you plan to use paper
measuring other than 8 1/2" by 11".
Version 1.30
KAware Disk Publisher/Fielded
2:52 pm
KADF Form Designer for file releases
Form Information
Form Number: 311 - '
Form Name: Toxic Releases by Facility and Industry!!!
Form Type: P
Page Width: 76 Page Length: 60
Maximum Lines:
Enter a unique name for this form.
F1=Help Tab=Prev Enter=Next F10=Edit Finished ESC=Cancel Edit
Press . The same window as before reappears in the center of the screen:
Version 1.30 KAware Disk Publisher/Fielded 2:54 pm
KADF Form Designer for file releases
Form Information
Form Number: 3i|
Form Name:
Form Type: P
Page Width: 76
Maximum Lines:
Page Length: 60
Specify Form Information
Design Page Header
Design Page Detail
Preview Form
Display Form Design
Print Form Design
Save Changes
Specify Form Information
F1=Help ESC=Done
Page 4-30
CD-ROM User's Manual
-------
Using the down arrow, highlight Design Page Detail and press < ENTER>. A new screen,
PAGE DETAIL FOR FORM, will appeal'. 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 the mnemonic tags representing each of the data elements in
the TRI file that you are using. (See Appendix E for a description of each of the fields in
the RELEASES and TREATMNT files.) Using the down arrow, highlight the first field that
you would like to appear on your report and press < ENTER >.
Version 1.30
KAware Disk Publisher/Fielded
2:55 pm
KADF Form Designer for file releases
Item Number
Data Field
Item Label
Label Row
Data Row
Data Width
Data Justification
' Wrap Rule
Missing Data Rule
First Array 'Element
Array Display Rule
Page
: 1
: SUBN
:
: +1
: +0
J
: L
: D
: 0
;
'
Detail for form
i M !
r
-~i Data Field t
Label Column:*
Data Column:
Maximum Lines:
Wrap Column:
Missing Value:
Last Array Element:
Array Separator:
1 A1 SUBN
2 A1 TRIN
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 want to choose is facility name (FNM). To select
it, highlight number 6, FNM, and press < ENTER >. .
CD-ROM User's Manual
Page 4-31
-------
The mnemonic tag (e.g., FMN) will appear on the screen next to Data Field and Item Label.
Edit the Item Label to appear as you would like the name of that data element to appear on
your report. The screen below shows the Item Label after it was changed from FNM to
Facility Name.
Version 1.30
KAware Disk Publisher/Fielded
2:56 pm
KADF Form Designer for file releases
Page Detai
Item Number: 1
Data Field: FNM
Item Label: Facility
Label Row: +1
Data Row: +0
Data Width: 60
Data Justification: L
Wrap Rule: D
Missing Data Rule: 0
I for form
Name- ,
Label Column: 1
Data Column: +2
Maximum Lines:
Wrap Column:
Missing Value:
First Array Element: Last Array Element:
Array Display Rule: Array Separator:
Enter the text to use for labeling this item.
F1=Help Tab=Prev Enter=Next F10=Edit Finished
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
KAware Disk Publisher/Fielded
2:56 pm
KADF Form Designer for file releases
Page Detail for form
Item Number: 1
Data Field: FNM
Item Label: Facility Name .
Label Row: +1
Data Row: +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 this field. Use cursor pad to scroll choices.
F1=Help Tab=Prev Enter=Next F10=Edit Finished ESC=Cancel Edit
Page 4 - 32
CD-ROM User's Manual
-------
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, repeat all of the steps to describe the
chemical name, beginning with selecting NAME from the Data Field menu. Press
again and add'the data element sum of all environmental releases (SENV) to the form.
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 SIC from the Data Field menu. For the Item Label, we decide to enter
Industry (1) to show that this is the first industry classification that was reported. Press
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> 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.) _ '
Version 1.30
KAware Disk Publisher/Fielded
2:59 pm
KADF Form
Page
Designer for file releases
Detail for form
Item Number: 3
Data Field: SIC
Item Label: Industry (6)
Label Row: +1
Data Row: +0
Data Width: 250
Data Justification: L
Wrap Rule: D
Missing Data Rule: L
First Array Element: 6
Array Display Rule: 1
Label Column: 1
Data Column: +2
Maximum Lines:
Wrap Column:
Missing Value:
Last Array Element: 6111
Array Separator: ,
Enter the last array element to print for this data field.
F1=Help Tab=Prev Enter=Next F10=Add Finished ESC=Cancel Add
CD-ROM User's Manual
Page 4-33
-------
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
KAware Disk Publisher/Fielded
3:03 pm
Page Detail List -i
1 FNH
2 NAME
3 SENV
4 SIC
5 SIC
6 SIC
6 SIC
8 SIC
9 SIC
Da1
Data Justi'1
Wi
Missing D;
First Array
Array Disp
KADF Form Designer for file releases
Page Detail for form
Number : Siiiiii
a Field: SIC
m Label: Industry (6)
bel Row: +1 Label Column: 1
ata Row: +0 Data Column: +2
:a Width: 250 Maximum Lines:
:ication: L
-ap Rule: D Wrap Column:
ata Rule: L Missing Value:
Element: 6 Last Array Element: 6
Lay Rule: 1 Array Separator: ,
Use cursor pad to choose item, then select operation. .F9=Preview
F1=Help F2=Delete F4=Edit 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.
Version 1.30
KAware Disk Publisher/Fielded
3:03 pm
KADF Form Designer for file releases
Form Information
Form Number: 3|1
Form Name:
Form Type: P
Page Width: 76
Maximum Lines:
Page Length: 60
Specify Form Information
Design Page-Header
Design Page Detail
Preview Form
Display Form Design
Print Form Design
Save Changes -
Save changes made so far
F1=Help ESC=Done
Page 4-34
CD-ROM User's Manual
-------
Press . You will return to the original FORM DESIGNER SCREEN. This time,
it will list 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
KAware Disk Publisher/Fielded
4:20 pm
KADF Form Designer for file releases
1 RELEASES -
2 RELEASES (BRIEF)
3 Toxic Releases by Facility and Industry
Form Name: RELEASES .
Form Type: P
Page Width: 76 Page Length: 60
Maximum Lines: . - . '
'. "-
- -
Use cursor pad to choose form, then select operation.
F1=Help F2=Delete F4=Edit. F5=Add F6=Insert F7=Copy F8=Move 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. ,
CD-ROM User's Manual
Page 4 - 35
-------
Press to exit to DOS. At the DOS prompt, type TRL This will retrieve the DATA
BASE SELECTION MENU. Choose 2. Toxic Release Inventory 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 - KAwareF Ctm) 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/PgDn changes Set List page)
SEARCH SET=0 OUTPUT SET=4 WORKSPACE: 243128
F6=Di splay F7=Group
F8=Group
F9=Group V FlO=Exit ESC=Backup
Page 4-36
CD-ROM User's Manual
-------
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 . Records in the
set will be displayed (or printed or exported) in the format that you designed, as the example
below illustrates.
TRI - KAwareF (tm) Fielded V1.35
F1 = Help F2 = Options F3 = Select F4 = Search
. Set 3: COMBINE: 1 AND 2
F5 = Sets
RECORD #1 OF 22
LINE 1 of 9
Facility Name MONSANTO CO.
Chemical 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
CD-ROM User's Manual
Page 4-37
-------
-------
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 1992 in the state of Delaware. You will need to retrieve the
following information first, before using the calculation feature:
~" Substance Name - Chlorine
Facility State - DE
Reporting Year - 1992
You will need to follow the search and combine instructions to retrieve as set of records
for the above described criteria. Review Chapter 4, Toxic Release Inventory, to assist
you.
Export the set you have created by performing the following steps:
1. Choose the set number
2. Choose dBASE as the type of export file
3. Choose default order
4. Choose user selected output and mark only the following fields by using
the F9 key:
- Field 1: Sum Air Releases (SAIR)
- Field 2: Sum Wafer Releases (SW)
- Field 3: Sum Land Releases (SL)
- Field 4: Sum All Releases to Environment (SENV)
- Field 5: Sum Transfer to Publicly Owned Treatment Works (SPOTW)
- Field 6: Sum of Offsite Transfers (SOFF)
- Field?: Sum POTW and Offsite Transfers (SPO)
- FieldS: Sum Releases and Transfers (SRT)
5. Name the file by typing a name and pressing < ENTER >.
Press to exit to the DATA BASE SELECTION MENU.
CD-ROM User's Manual
Page 5 -1
-------
Select Calculate Releases (KASTAT) from the DATA BASE SELECTION MENU. Use
the down arrow to highlight Calculate Releases (KASTAT) and press < ENTER > or press
<3> and press . _
DATA BASE SELECTION
1 Chemical Si±>stance Fact Sheets
2 Toxic Release Inventory
3 Calculate Releases (KASTAT)
4 QUIT TRI CO-ROH Disc
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.)
KAware (tro) Statistical Summarizer V1.10
Computes, displays, saves, and prints statistics
for numeric fields in dBase (.DBf) export
format from the KAwareZ Fielded Retrieval System.
Name of file saved in dBase (.DBF) format? 92DE-CHL
There is one screen displayed for each field in the dBase file that you created. For our
example, which contained eight fields containing numbers representing release amounts, eight
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., 92DE-
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
TRISTAT\KASTAT.TXT. For a list of field labels for numeric fields that can be used for
performing calculations, type or print TRISTATYKASTAT.FLD.
Page 5-2
CD-ROM User's Manual
-------
The first of the eight screens, showing releases to air (SAIR), is shown below.
KAware (tm) Statistical Summarizer V1.10
Computes, displays, saves, and prints statistics
for numeric fields in dBase (.DBF) export
format from the KAware2 Fielded Retrieval System.
F1=Help
-»=Next «-=Previous P=Print
ESC=Escape j
* .
File: 92DE-chl.dbf
Number of Records: 11
Number of fields: . 8
Number of allowable numeric fields: 8
Field name: SAIR
Number of blanks: . 5
Lowest: 5
Range: 10896
Mean with 0: 2226.33
Field number:
Zeros:
Highest:
Sum:
Mean w/o 0:
1
0
10901
13358
2226.33
Press ENTER for optional calculation of median and mode.
Press < ENTER >. Two new fields, Mean w/ 0 and Mean w/o 0 are added at the. bottom of
the screen:
KAware (tm) Statistical_Summarizer V1.10
Computes, displays, saves, arid prints statistics
for numeric fields in dBase (.DBF) export
format from the KAware2 Fielded Retrieval System.
F1=Help -»=Next «-=Previous P=Print- ESC=Escape
File: 92DE-chl.dbf
Number of Records: ' 11
Number of fields: 8
Number of allowable numeric fields:, 8
Field name: SAIR
Number of blanks: 5
Lowest: 5
Range: 10896
Mean with 0: 2226.33
Median w/o 0: 230
Field number:
Zeros:
Highest:
Sum:
Mean w/o 0:
Mode w/o 0:
1
0
10901
13358
2226.33
CD-ROM User's Manual
Page 5-3
-------
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 (92DE-CHL.DBF)
Highest - The highest single release of Chlorine into the air in pounds (10901)
Lowest - The lowest single release of Chlorine to the air in pounds (5)
Mean with O - The average of the field for which the calculation is being processed,
including records reporting 0 (zero) pounds released to air (2226.33)
Mean W/O 0 - The average of the field for which the calculation is being processed without
records containing zeros in that field (2226.33)
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
(230) (For example, if five records are processed, the third number is the median [middle]
number, regardless of its value.)
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 (8)
Number of Blanks - The number of records which had a blank or no data in that,field (5)
Number of Fields - The number of fields in the record (8)
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,901 (Highest) -
5 (Lowest) = 10,896) pounds
Sum - The total sum of the field on which the calculation is being processed in pounds
(13358)
Page 5-4
CD-ROM User's Manual
-------
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.
You have the option to press < ENTER > to calculate the median without (w/o) 0 and mode
without (w/o) 0 fields.
CD-ROM User's Manual
Page 5-5
-------
-------
APPENDIX A
-------
-------
APPENDIX A: Sources for Further Assistance
Toxic Release Inventory User Support (TRI US)
EPA, TRI US (TS-793) ,
401MST,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 Right-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 A - 1
-------
-------
APPENDIX B
-------
-------
APPENDIX B: TRI Reporting Form (EPA Form R)
(IMPORTANT: Type or print; read instructions btfom completing torn)'
Form Approved OMB Number: 20704093
Approve Expires: 11/92
Pag* 1 of 9
<&EPA FORMR
TOXIC CHEMICAL RELEASE
INVENTORY REPORTING FORM
United States
Environmental Protection Secton 313 of ft* Emergency Pinning and Community «oht-to*now Ad of 1986,
Agency ^sokm»imasT1tel!lofft»SiperfurdAm«rKlm«nlB«xlRt«utx!rlzalion Ad
TBIFAOUTYO NUMBER
. 0* Q*nxic Hum
WHERE TO SEND 1- EPCRA Reporting Center
COMPLETED FORMS: Mertfi&w?22H(Wi348
ATTN: TOXIC CHEMICAL RELEASE INVENTORY
2. APPROPRIATE STATE OFFICE
(SM Mrudiont In Apptndx F)
Enter*X"lwre8
thfc h a revision
IMPORTANT: See instructions to determine when "Not
Applicable (N A)" boxes should be checked.
PART I. FACILITY IDENTIFICATION INFORMATION
SECTION 1.
REPORTING
YEAR
19
SECTION 2. TRADE SECRET INFORMATION
2.2
Are you claiming the toxic chemical identified on page 3 trade secret?
I I Yes (Answer question 2.2; I I No (Do not answer 2.2;
II Attach substantiation forms) II Go to Section 3)
If yes in 2.1, is this copy: | | Sanitized | | Unsan'rtized
SECTION 3. CERTIFICATION (important: Read and sign after completing all form sections.)
I hereby certify that I have reviewed the attached documents and that, to the best of my knowledge and belief, the
submitted information is true and complete and that the amounts and values in this report are accurate based on
reasonable estimates using data available to the preparers of this report.
Signature
Date Signed
SECTION 4. FACILITY IDENTIFICATION
FacJIilyofEs^jfehrrenlName |
TRI Facility ID Number!
Slreel Address |
City
4.1
Stal*
MalBng Address (HdHbrent from stteet address) |
Ctly
State
PUT LABEL HERE
EPA Form 9350-1 (Rav. 12/4/92) - Previous editions ar* obsolete.
- CD-ROM User's Manual
APPENDIX B - 1
-------
Page 2 ot 9
EPA FORM R
PART I. FACILITY IDENTIFICATION
INFORMATION (CONTINUED)
THI FACILITY O NUMBER
To«c Clwaial. Cmjan. * Oxurio N«1»
SECTION 4. FACILITY IDENTIFICATION (Continued)
4.2
4.3
4.4
4.5
4.6
4.7
4.8
4.9
4.10
thfs w^qif&HTtains fnfgrmatiort fan
(Important: check only one)
TeehttteatC
ontact
PuWfc Contact
SIC Code
(4-digit)
Latitude
and
Longitude
Name |
U""* I
Oegt»«s
b.
" U*udB
, Minutes
a. | | An entire facility b. |_J Part of a facility
-
c.
, ««)onos
d.
Telephone Numuer (mouoe ares cooej
e. f.
UngSude
JJegnws
Dun & Bradstreet Numbers) (9 digfts)
EPA Identification
Numbers) (RCRA I.D. No.)
(12 characters)
FacflltyNPDES Permit Number(») , ^ ,
(9 characters)
Underground injection Wall Cwfe (UK5) I.D.
Humberts) (12 digits)
Uinutes i S«snos
a.
b.
a.
b.
a.
b.
a.
b.
SECTIONS. PARENT COMPANY INFORMATION
5.1
5^
HUM olPannt Company
DNA
P»«fl Con^any's Dun & Bradsteet Nunbar
DNA
(9 digits)
EPA Form 9350-1 (R»v. 12/4/92) - Previous editions arc obsolete.
CD-ROM User's Manual
APPENDIX B - 2
-------
Pig* 3 of 9
ft EPA
United States
Environmental Protection
Agency
EPA FORM R
PART II. CHEMICAL-SPECIFIC
INFORMATION
TWHWUTYD NUMBER
SECTION!. TOXIC CHEMICAL IDiNTITY 'SaiiSi5ISSt?b-a«J
1.1
1.2
1,3
CAS Number (Important: En»onfronaitun6^«x»alyreMqy*Monti«S»cton3«la
Toxic Chemfcai or Chemical Category Name (taportant: lEntor only ont nun* «xac% Ml ^pearsontheS«cfon313kt.)
Generic Chemical Name (Important: Comptet* only H Pwt I, Siefcn 2.1 fc *«*»d>c- Qw^ftamemurttestuctalydBsa^e.)
-
SECTION 2. MIXTURE COMPONENT IDENTITY 232^!^
.:-i.i'."''
Generic Chemical Nam Pro*
SECTION 3. ACTIVITIES AND USES OF THE TOXIC CHEMICAL AT THE FACILITY
(Important: Check all thai apply.)
3.1
3.2
3.3
Manufacture
the toxic
chemical:
J*roceSs~~
the toxic
chemical:
Otherwise use
the toxic
chemical:
If produce or import:
a. 1 1 Produce c. 1 1 For on-site use/processing
b-'C 1 'mP°rt d. | | For sale/distribution
e. | | As a byproduct
f. | | As an impurity
a. LJ As a reactant c. I I As an article component
b. L~] As a formulation component d. | | Repackaging
a. LJ As a chemical processing aid c. | | Ancillary or other use
b. Q As a manufacturing aid
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 9350-1(Rev. 12/4/92) - Previous editions are obsolete.
CD-ROM User's Manual
APPENDIX B - 3
-------
United States
Environmental Protection
Agency
EPA FORM R
PART II. CHEMICAL-SPECIFIC
INFORMATION (CONTINUED)
Page 4 of 9
TRI FACILITY ID NUMBER
Toxic Chtwrocat. CMagofy. or G*n»ftc Name
SECTION 5. RELEASES OF THE TOXIC CHEMICAL TO THE ENVIRONMENT ON-SITE
5.2
5.3
A. Total Release (pounds/
year) (enter range code from
instructions or estimate)
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
B. Basis of
Estimate
(enter code)
C. % From
Stormwater
5.3.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
5.5.4
Underground injections
on-site
Releases to land on-slte
Landfill
Land treatment/
application farming
Surface impoundment
Other disposal
Check here only if additional Section 5.3 information Is provided on page 5 of this form,
EPA Form 9350-1 (Riv. 12/4/92) - Previous edition* art obsoletr
Rang* Codes: A 1 - 10 pounds; B . 11
' C . 500 - 999 pounds.
CD-ROM User's Manual
APPENDIX B - 4
-------
P»Q«So<9
«EPA
United States
Environmental Protection
Agency
EPAFC
PART III. CHEMI
INFORMATION
. TMFACU
)RM R
CAL-SPECIFIC T-fcCh-1
(CONTINUED)
TYONLWKR
tn^.raijng. I'TTiTi-lrrlKH
SECTION 5.3 ADDITIONAL INFORMATION ON RELEASES OF THE TOXIC CHEMICAL TO THE
ENVIRONMENT CM-SITE '
Discharges to receiving A. Total Fteteew (pounds/ B. Baste of
5.3 Streams or water bodies year) (enter range code from Estimate
(enter one name per box) - -" instructions or estimate) (enter code)
5.3._ Stream or Water Body Mame
5.3. Stream or Water Body IMarne
'".-'.
5.3. Stream or Water Body Name
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 Tola! Transfers (pounds/year)
(enter range, code or estimate)
>'
C.1.B. POTW Name and Location Information
'..., POTW Name
G.1.B.
Street Address |
City j
State |
County |
apCode I .
6.1. A.2 Basis of Estimate
Center code) ':'. ... :! :-
fin r POTWName
0.1 .B. f
Sm! Address J
Ctty | County
.State | ZipCodi
J
L3
If additional pages of Part II, Sections 5.3 and/or 6.1 are attached, Indicate the total number of
pages in this box and indicate which Part 11, Sections 5.3/6.1 page this is
, here.
t»xamp)e:1,2,i,»tc.)
EPA Form 9350-1 (Rev. 12/4/92) - Previous editions are obsolete.
Range Codes: A « 1 - 10 pounds; B = 11
C > 500 999 pounds
CD-ROM User's Manual
APPENDIX B 7 5
-------
Page 6 of 9
KrEPA EPA FORM R
F"*,^, Proton PART II. CHEMICAL-SPECIFIC
Ennta, Protect |NFORMAT|ON (CONTINUED)
TRI FACILITY ID NUMBER
Toxc Ch«nvcaJ. Category, ot Gwwrc Ncn»
SECTION 6.2 TRANSFERS TO OTHER OFF-SITE LOCATIONS
Off-site EPA ktenlifcalion Nun** (HCRA ID No.}|
G.Z.
Off-Site location Nam» |
SUWI Address ]
City | County |
Slate | ZipCode | Is location under control of reporting ri i 1
facility or parent company? 1 1 Y*8 I 1 No
A. Totai Transfers (pounds/veaf)
(enter fangs code or estimate)
.1.
2.
3.
4.
B.&assafEslinwIe ', ; ,, ' ' :.
{entefcode} .'.,'... . ... ,'..:'; :. .
1.
2.
3.
4.
C. Type of Waste Trsatroent/Cfeposal/
fiecydmg/Energy Recovery (enter codej
1. M
2. M
3. M
4. M
SECTION 6.2 TRANSFERS TO OTHER OFF-SITE LOCATIONS
Off-ste EPA IdenStkafon Number (RCRA ID No.) j
Off-Site loca&m Nam* |
Street Address |
CBy | . - county |
Stale [ ZipCode | ' Is location under control of reporting i i i 1
facility or parent company? | | "es | J No
A. Total Transfers (pounds/year)
(enter range code or estimate)
1.
2.
3.
4.
B. Basis of EsSmate
(ntercode)
1.
2.
3.
4.
C. Type of Waste Treatment/Disposal/
Recycling/Energy Recovery (enter code)
1. M
2. M
3. M
4. M
-
If additional pages of Part II, Section 6.2 are attached, Indicate the total number of pages In this
box Q3 and Indicate which PartH, Section 6.2 page this Is, here. | | (example: 1,2, 3, «tc.)
EPA Form 9350-1 (Rev. 12/4/92) - Previous editions are obsolete.
Range Codes: A « 1 - 10 pounds; B * 11
C » 500 - 999 pounds.
CD-ROM User's Manual
APPENDIX B - 6
-------
Page7o(9
EPA FORM R
KnSiPmtection PART II. CHEMICAL-SPECIFIC
Agency INFORMATION (CONTINUED)
TMFACUTYDNUUIER
If additional copies of page 7 are attached, indicate the total number of pages in this
box [ [ and Indicate which page7 this is, here.] | (example: 1,2,3, ate.)
EPA Form 9350-1 (Rev. 12/4/92} - Previous editions are obsolete.
CD-ROM User's Manual
APPENDIXB-7
-------
Page 8 of 9
«EPA
United Stales p
Environmental Protection
Agency |
TR! FACILITY ID NUMBER
hPA I-OHM H
ART II CHEMICAL-SPECIFIC T^O..^.^.^,.*^,.:.*
NFORMATION (CONTINUED)
SECTION 7B. ON-SITE ENERGY RECOVERY PROCESSES
Q] Not Applicable
(NA) - Check here if QS. on-site energy recovery is applied to any waste
stream containing the toxic chemical or chemical category.
Eruigy Rtcovtry M»thodi [*nt*f S-chsractw cod«(s)]
1|
2 J ,3 / v ' 4
SECTION 7C. ON-SITE RECYCLING PROCESSES
Q Not Applicable (NA) - Check here if ng. on-site recycling is applied to any waste
stream containing the toxic chemical or chemical category.
Bicycling Utthodi [mttr 3-charactor cod»(»)]
1
6
2 34
7 89
5
10
CD-ROM User's Manual
APPENDIX B -8
-------
Page 9 of 9
4^ EPA EPA FORM R
United States PART II HHIFMIPAI -^PFfMF
Environmental Protection rMn J II. VrlCmiUMI--OrCUir
Agency INFORMATION (CONTINUEI
TBI FACIUTY C NUUBE R
0)
SECTIONS. SOURCE REDUCTION AND RECYCUNG ACTIVITIES
All quantity estimates can be reported
using up to two significant figun*.
8.1
8.2
8.3
8.4
8.5
8.6
8.7
8.8
8.9
Quantity released *
Quantity used for energy
recovery on-site
Quantity used tor energy
recovery off-she
Quantity recycled on-site
Quantity recycled off-site
Quantity treated on-site
Quantity treated off-site
Column A
: 1991
(pound&yciar)
Column B
1992
.(pounds/year)
Column C
1993
(poundsfyear)
Column D
1994
(pounds/year)
-
Quantity released to the environment as i« i result of
remedial actions, catastrophic events, or orte-time events
not associated with production processes {pounds/year}
Production ratio or activity Index ^
6.10
8.10.1
8,10.2
8.10.3
8.10.4
8.11
Did your facility engage in any source reduction activities for this chemical during
the reporting year? If not, enter "NA" In Section 8,10,1 and answer Section 8.1 1 .
Source Reduction Activities
;;|*nter code(3)J
--
Methods to Identify Activity {enter codes)
a.
a.
a.
a.
b. c.
b. c. i
b. c.
b. c.
Is additional optional information on source reduction, recycling, or
poiiution control activities included with this report? (Check one box)
YES NO
* 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.
EP'A Form 9350 - 1 (Rev. 12/4/92) - Previous editions; are obsolete.
CD-ROM User's Manual
APPENDIX B - 9
-------
-------
APPENDIX C
-------
-------
APPENDIX SECTION 313 TOXIC CHEMICAL LIST
FOR REPORTING YEAR 1992 (including
C: toxic Chemical Categories)
Specific toxic chemicals with CAS Number are listed in alphabetical order on this page. A list of the same
chemicals in CAS Number order begins at the end of the alphabetical list of toxic chemicals. Covered toxic
chemical categories follow.
Certain toxic chemicals listed in Table II have parenthetic "qualifiers." These qualifiers indicate that these toxic
chemicals are subject to the section 313 reporting requirements if manufactured, processed, or otherwise used in
a specific form. The following chemicals are reportable only if they are manufactured, processed, or otherwise
used in the specific form(s) listed below:
Chemical
Aluminum (fume or dust)
Aluminum oxide (fibrous forms)
Ammonium nitrate (solution)
Ammonium sulfate (solution)
Asbestos (friable)
Isopropyl alcohol (manufacturing -
strong acid process, no supplier
notification)
Phosphorus (yellow or white)
Saccharin (manufacturing, no
supplier notification)-.
Vanadium (fume or dust)
Zinc (fume or dust)
CAS Number
7429-90-5
1344-28-1
6484-52-2
' 7783-20-2
1332-21-4
67-63-0
7723-14-0
81-07-2
7440-62-2
7440-66-6
Qualifier
Only if it is in a fume or dust form.
Only if it is a fibrous form.
Only if it is in a solution. .
Only if it is in a solution.
Only if it is a friable form.
Only if it is being manufactured by the
strong acid process.
Only if it is a yellow or white form.
Only if it is being manufactured.
Only if it is in a fume or dust form.
Only if it is in a fume or dust form.
,. [Note: Chemicals may be added to or deleted from the list. The Emergency Planning and Community Right-to-
Know Information Hotline, (800) 535-0202 or (703) 920-9877, will provide up-to-date information, on the status of
these changes. See Section B.4.b of the instructions for more information on the de minimis values listed below,]
CD-ROM Users's Manual
APPENDIX C - 1
-------
a. Alphabetical Chemical List
CAS Number Toxic Chemical Name
CAS Number Toxic Chemical Name
De Minimi!
Concentration
75-07-0
60-35-5
67-64-1
75-05-8
53-96-3
107-02-8
79-06-1
79-10-7
107-13-1
309-00-2
107-18-6
107-05-1
7429-90-5
1344-28-1
117-79-3
60-09-3
V2-67-1
82-28-0
7664-41-7
6484-52-2
7783-20-2
62-53-3
90-04-0
104-94-9
134-29-2
120-12-7
7440-36-0
7440-38-2
1332-21-4
7440-39-3
98-87-3
55-21-0
71-43-2
92-87-5
98-07-7
98-88-4
94-36-0
100-44-7
7440-41-7
Acetaldehyde
Acetamide .
Acetone
Acetonitrile
2-Acetylaminofluorene
Acrolein
Acrylamide
Acrylic acid
Acrylonitrile
Aldrin
De Minimis
Concentration
0.1
0.1
1.0
1.0
0.1
1.0
0.1
1.0
0.1
1.0
{l,4:5,8-Dimethanonaphthalene,
5,8,8a-hexahydro-(l.alpha.,
4.alpha.,4a.beta.,5.alpha.,
8.alpha.,8a.beta.)-}
Allyl alcohol
Allyl chloride
Aluminum (fume or dust)
Aluminum oxide
(fibrous forms)
2-Aminoanthraquinone
4-Aminoazobenzene
4-Aminobiphenyl
l-Amino-2-
methylanthraquinone
Ammonia
Ammonium nitrate (solution)
Ammonium sulfate (solution)
Aniline
o-Anisidine
p-Anisidine
o-Anisidine hydrochloride
Anthracene
Antimony
Arsenic
Asbestos (friable)
Barium
Benzal chloride
Benzamide
Benzene
Benzidine
Benzoic trichloride
{Benzotrichloride}
Benzoyl chloride
Benzoyl peroxide
Benzyl chloride
Beryllium
1.0
0.1
0.1
1.0
1.0
1.0
0.1
0.1
0.1
1.0
1.0
1.0
0.1
92-52-4 Biphenyl 1.0
111-44-4 Bis(2-chloroethyl) ether 1.0
542-88-1 Bis(chloromethyl) ether
0.1108-60-1 Bis(2-chloro-l-methylethyl) 1.0
ether
103-23-1 Bis(2-ethylhexyl) adipate 1.0
353-59-3 Bromochlorodifluoromethane 1.0
{Halon 1211}
75-25-2 Bromoform 1.0
{Tribromomethane}
74-83-9 Bromomethane 1.0
(Methyl bromide}
75-63-8 Bromotrifluoromethane 1.0
{Halon 1301}
1,3-Butadiene ,0.1
Butyl acrylate 1.0
n-Butyl alcohol 1.0
sec-Butyl alcohol 1.0
tert-Butyl alcohol 1.0
Butyl benzyl phthalate 1.0
1,2-Butylene oxide 1.0
Butyraldehyde 1.0
C.I. Acid Green 3* 1.0
C.I. Basic Green 4* l.Q.
C.I. Basic Red 1* 0.1
C.I. Direct Black 38* 0.1
C.I. Direct Blue 6* 0.1
C.I. Direct Brown 95* 0.1
C.I. Disperse Yellow 3* 1.0
C.I. Food Red 5* 0.1
C.I. Food Red 15* 0.1
C.I. Solvent Orange 7* - 1.0
C.I. Solvent Yellow 3* 0.1
C.I. Solvent Yellow 14* 0,1
C.I. Solvent Yellow 34* 0.1
{Aurimine}
128-66-5 C.I. Vat Yellow 4* 1.0
7440-43-9 Cadmium 0.1
156-62-7 ' Calcium cyanamide 1.0
133-06-2 Captan 1.0
{lH-Isoindole-l,3(2H)-dione,
3a,4,7,7a-tetrahydro-
2-[(trichloromethyl)thio]-}
63-25-2 Carbaryl 1.0
{1-Naphthalenol,
methylcarbamate}
75-15-0 Carbon disulfide 1.0
56-23-5 Carbon tetrachloride 0.1
463-58-1 Carbonyl-sulfide 1.0
1.0
1.0
1.0
0.1
0.1
0.1
0.1
0.1
1.0
1.0
1.0
1.0
0.1
1.0
0.1
1.0
106-99-0
141-32-2
71-36-3
78-92-2
75-65-0
85-68-7
106-88-7
123-72-8
4680-78-8
569-64-2
989-38-8
1937-37-7
2602-46-2
16071-86-6
2832-40-8
3761-53-3
81-88-9
3118-97-6
97-56 3
842-07-9
492-80-8
CD-ROM Users's Manual
APPENDIX C - 2
-------
CAS Number Toxic Chemical Name
De Minimis
Concentration
CAS Number Toxic Chemical Name
De Minimis
Concentration
120-80-9 Catechol . 1.0
133-90-4 Chloramben 1.0
{Benzoic acid, 3-amino-
2,5-dichloro-}
57-74-9 Chlordane 1.0
{4,7-Methanoindan, 1,2,4,5,6,7,
8,8-octachloro-2,3,3a,4,
7,7a-hexahyd ro-)
7782-50-5 Chlorine 1.0.
10049-04-4 Chlorine dioxide 1.0
79-11-8 Chloroacetic acid 1.0
532-27-4 2-Chloroacetophenone- 1.0
108-90-7 Chlorobenzene 1.0
510-15-6 .Chlorobenzilate 1.0
{Benzeneacetic acid,4-chloro-
.alpha.-(4-chlorophenyl)-
.alpha.-hydroxy-,ethyl ester}
75-00-3 Chloroethane 1.0
{Ethyl chloride)
67-66-3 Chloroform 0.1
74-87-3" Chloromethane 1.0
... {Methyl chloride)
107-30-2 Chlorornethyl methyl ether 0.1
126-99-8 Chloroprene . 1.0
1897-45-6 Chlorothalonil 1.0
{1,3-Benzened icarboni tril e,
2,4,5,6-tetrachloro-)
7440-47-3 Chromium. 0.1
7440-48-4 . Cobalt 1.0
7440-50-8 . Copper '1.0
8001-58-9 Creosote 0.1
120-71-8 p-Cresidine . 0.1
1319-77-3 Cresol (mixed isomers) 1.0
108-39-4 m-Cresol - 1.0
95-48-7 o-Cresol 1.0
106-44-5 p-Cresol " 1.0
98-82-8 Cuniene 1.0
80-15-9 Cumene hydroperoxide 1.0
135-20-6 Cupferron , 0.1
, {Benzeneamine, N-hydroxy-
N-nitrqso, ammonium salt)
110-82-7 ' Cyclohexane 1.0
94-75-7 2,4-D ' ' 1.0
{Acetic acid,
(2,4-dichlorophenoxy)-}
1-T63-19-5 Decabromodiphenyl oxide . 1.0
2303-16-4 Diallate ' 1.0
{Carbamothioic acid,
bis(l-methylethyl)-, S-(2,3-
dichloro-2-propenyl) ester)
615-05-4 2,4-Diaminoanisole .0.1
. 39156-41-7 2,4-Diaminoanisole sulfate 0.1
101-80-4 4,4'-Diaminodiphenyl ether 0.1
25376-45-8. Diaminotoluene 0.1
(mixed isomers)
95-80-7 2,4-Diaminotoluene 0.1
334-88-3 Diazomethane - 1.0
132-64-9 Dibenzofuran 1.0
96-12-8 l,2-Dibromo-3-chloropropane 0.1
{DBCP}
106-93-4 1,2-Dibromoethane 0.1
- {Ethylene dibromide)
124-73-2 Dibromotetrafluoroethane 1.0
{Halon2402}"
84-74-2 Dibutyl phthalate 1.0
25321-22-6 Dichlorobenzene (mixed 0.1
isomers)
95-50-1 l;2-Dichlorobenzene 1.0
541-73-1 1,3-Dichlorobenzene 1.0
106-46-7 1,4-Dichlorobenzene 0.1
91-94-1 ; 3,3'-Dichlorobenzidine . 0.1
75-27-4 Dichlorobromomethane 1.0
75-71-8 . Dichlorodifluoromethane 1.0
- (CFC-12)
107-06-2 1,2-Dichloroethane . . 0.1
{Ethylene dichloride)
540-59-0 1,2-Dichloroethylene . 1.0
75-09-2 Dichloromethane . 0.1
{Methylene chloride) "
120-83-2 , 2,4-Dichlorophenol 1.0
78-87-5 . 1,2-Dichloropropane . 1.0
78-88-6 2,3-Dichloropropene 1.0
542-75-6 1,3-Dichloropropylene 0.1
76-14-2 Dichlorotetrafl.uoroethane "1.0
(CFC-114)
62-73-7 Dichlorvos 1.0
{Phosphoric acid, 2,2-
dichloroethenyl dimethyl ester)
115-32-2 Dicofol 1.0
. {Benzenemethanol, 4-chloro-
.alpha.-(4-chlorophenyl)-,.
.alpha.- (trichloromethyl)-)
1464-53-5 Diepoxybutane 0.1
111-42-2 Diethanolamine 1.0
117-81-7 Di-(2-ethylhexyl) phthalate 0.1
{DEHP}
84-66-2 Diethyl phthalate t 1.0
64-67-5 Diethyl sulfate 0.1
119-90-4 3,3'-Dimethoxybenzidine 0.1
60-11-7 4-Dimethylaminoazobenzene 0.1
CD-ROM Users's Manual
APPENDIX C - 3
-------
CAS Number Toxic Chemical Name
De Minimis
Concentration
CAS Number Toxic Chemical Name
De Minir
Concentratic
119-93-7 3,3'-Dimethylbenzidine " 0.1
{o-Tolidine}
79-44-7 Dimethylcarbamyl chloride 0.1
57-14-7 1,1-Dimethyl hydrazine 0.1
105-67-9 2,4-Dimethylphenol 1.0
131-11-3 Dimethyl phthalate 1.0
77-78-1 Dimethyl sulfate 0.1
99-65-0 m-Dinitrobenzene 1.0
528-29-0 o-Dinitrobenzene 1.0
100-25-4 p-Dinitrobenzene 1.0
534-52-1 4,6-Dinitro-o-cresol 1.0
51-28-5 2,4-Dinitrophenol . 1.0
121-14-2 2,4-Dinitrotoluene 1.0
606-20-2 2,6-Dinitrotoluene 1.0
25321-14-6 Dinitrotoluene ' . 1.0
(mixed isomers)
117-84-0 n-Dioctyl phthalate 1.0
123-91-1 1,4-Dioxane 0.1
122-66-7 1,2-Diphenylhydrazine '. 0.1
{Hyd razobenzene)
106-89-8 Epichlorohydrin - 0.1
110-80-5 2-Ethoxyethanol 1.0
140-88-5 Ethyl acrylate . 0.1
100-41-4 Ethylbenzene 1.0
541-41-3 Ethyl chloroformate """ 1.0:
74-85-1 Ethylene 1.0
107-21-1 Ethylcne glycol . 1.0
151-56-4 Ethyl cneimine 0.1
{Aziridine}
75-21-8 Ethylene oxide 0.1
96-45-7 Ethylene thiourea 0.1
2164-17-2 'Fluometuron , 1.0
(Urea, N,N-dimethyl-N'-
[3-(trifluoromethyl)phenyl]-}
50-00-0 Formaldehyde 0.1
76-13-1 Freon 113 1.0
{Ethane, l,l,2-trichloro-l,2,2-
trifluoro-}
76-44-8 Heptachlor ' , 1.0
{1,4,5,6,7,8,8-Heptachloro-
3a,4,7,7a-tetrahydro-
4,7-methano-l H-indene}
118-74-1 Hexachlorobenzene 0.1
87-68-3 Hexachloro-l,3-butadiene 1.0
77-47-4 Hexachlorocyclopentadiene 1.0
67-72-1 Hexachloroethane 1.0
1335-87-1 Hexachloronaphthalene 1.0
680-31-9 Hexamethylphosphoramide 0.1
302-01-2 Hydrazine 0.1
'10034-93-2 Hydrazine sulfate 0.1
7647-01-0 Hydrochloric acid 1.0
74-90-8 Hydrogen cyanide 1.0
7664-39-3 Hydrogen fluoride 1.0
123-31-9 Hydroquinone 1.0
78-84-2 Isobutyraldehyde 1.0
67-63-0 Isopropyl alcohol 0.1
(manufacturing-strong acid
process, no supplier notification)
80-05-7 4,4'-Isopropylidenediphenol 1.0
120-58-1 Isosafrole ' 1.0
7439-92-1 Lead ...0.1
58-89-9 Lindane ' .0.1
{Cyclohexane,! ,2,3,4,5,6-
hexachloro-,(l.alpha.,2.alpha.,
3.beta.,4.alpha.,5.alpha.,6.beta.)-)
108-31-6 Maleic anhydride 1.0
12427-38-2 Maneb 1.0
{Carbamodithioic acid, 1,2-
ethanediylbis-,manganese
complex}
7439-96-5 Manganese 1.0
7439-97-6 Mercury 1.0
67-56-1 Methanol ' 1.0
72-43-5 Methoxychlor 1.0
{Benzene, 1,1'-(2,2,2-
trichloroethylidene)bis
[4-methoxy-]}
109-86-4 2-Methoxyethanol - 1.0
96-33-3 Methyl acrylate 1.0
1634-04-4 Methyl tert-butyl ether 1.0
101-14-4 4,4'-Methylenebis (2- 0.1
chloroaniline)
{MBOCA}
101-61-1 4,4'-Methylenebis 0.1.
(N,N-dimethyl)
benzenamine
101-68-8 Methylenebis 1.0
(phenylisocyanate) {MBI}
74-95-3 Methylene bromide 1.0
101-77-9 , 4,4'-Methylenedianiline 0.1
78-93-3 Methyl ethyl ketone 1.0
60-34-4 Methyl hydrazine . 1.0
74-88-4 Methyl iodide 0,1
108-10-1 Methyl isobutyl ketone 1.0
624-83-9 Methyl ispcyanate 1.0
80-62-6 Methyl methacrylate 1.0
90-94-8 Michler's ketone 0.1
1313-27-5 Molybdenum trioxide 1.0
76-15-3 (Mono)chloropentafluoroethanel.O
{CFC-115}
CD-ROM Users's Manual
APPENDIX C - 4
-------
CAS Number
,505-60-2
91-20-3
134-32-7
91-59-8
7440-02-0
7697-37-2
139-13-9
99-59-2 .
98-95-3
92-93-3
1836-75-5
51-75-2
,.
'55-63-0
88-75-5 ' .
100-02-7
79-46-9
156-10-5
121 -69-7
924-16-3
55-18-5
62-75-9
86-30-6
621-64-7
4549-40-0
59-89-2
759-73-9
684-93-5 , - '
-16543-55-8
100-75-4
2234-13-1
20816-12-0
56-38-2
87-86-5
79-21-0 .
108-95-2
106-50-3
90-43-7
75-44-5
7664.-3S-2
7723-14-0 .
S5-44-9
^S-«9-^ ' .
De Minimis
Toxic Chemical Name Concentration
Mustard gag 0.1
{Ethane, l,l'-thiobis[2-chloro-]}
Naphthalene- 1.0
alpha-Naphthylamine 0.1
beta-Naphthylamine 0.1
Nickel 0.1
Nitric acid 1.0
Nitrilotriacetic acid 0.1
5-Nitro-o-anisidine 0.1
Nitrobenzene 1.0
4-Nitrobiphenyl 0.1
Nitrofen ,0.1
{Benzene, 2,4-dichloro-l-
(4-ni trophenoxy)-}
Nitrogen mustard 0.1
{2-Chloro-N-(2-chloroethyl)-N-
methylethanamine} ' ~
Nitroglycerin 1.0
2-Nitrqphenol 1.0
4-Nitrophenol 1.0
2-Nitropropane 0.1
p-Nitrosodiphenylamine 0.1
N,N-Dimethylaniline 1.0
N-Nitrosodi-n-butylamine O.i
N-Nitrosodiethylamine 0.1
N-Nitrosodimethylamine 0.1
N-Nitrosodiphenylamine 1.0
N-Nitrosodi-n-propylamine 0.1
N-Nitrosomethylvinylamine .0.1
N-Nitrosomorpholine 0.1
N-Nitroso-N-ethylurea . 0.1
N-Nitroso-N-methylurea 0.1
N-Nitrosonornicotine . 0:1
N-Nitrosopiperidine 0.1
Octachloronaphthalene 1.0
Osmiurri tetroxide 1.0
Parathion 1.0
{Phosphorothioic acid, O, O-
diethyl-O-(4-nitrophenyl) ester) <
Pentachlorophenol {PCP} 1.0
Peracetic acid 1 .0
Phenol 1.0
p-Phenylenediamine 1.0
2-Phenylphenol 1.0
Phosgene :' 1.0
Phosphoric acid 1.0
Phosphorus (yellow .or white) 1 .0
Phthalic anhydride 1.0
Picric acid ' 1.0
CAS Number Toxic Chemical Name
De Minimis
Concentration
1336-36-3 Polychlorinated biphenyls 0.1
{PCBs}
1120-71-4 Propane sultone 0.1
57-57-8 beta-Propiolactone 0.1
123-38-6 Propionaldehyde 1.0
1,14-26-1 Propoxur 1.0
. {Phenol, 2-(l-methylethoxy)-,
methylcarbamate)
115-07-1 Propylene 1.0
{Propene}
75-55-8 Propyleheimine ' 0.1
75-56-9 Propylene oxide , 0.1
110-86-1 Pyridine 1.0
91-22-5 Quinoline 1.0
106-51-4 Quinone 1.0
82-68-8 . Quintozene .. . ' 1.0
{Pentachloroni trobenzene}
81-07-2 Saccharin, (manufacturing, no 0.1
supplier notification) -
{l,2-Benzisothiazol-3(2H)-one,
1,1-dioxide)
94-59-7 Safrole ' . 0.1
7782-49-2 Selenium 1.0
7440-22-4 Silver 1.0
100-42-5 Styrene , , 0.1
96-09-3 Styrene oxide 0.1
7664-93-9 Sulfuric acid 1.0
79-34-5 1,1,2,2-Tetrachloroethane . '0.1
127-18-4 Tetrachloroethylene 0.1
{Perchloroethylene}
'961-11-5 Tetrachlorvinphos 1.0
{Phosphoric acid, 2-chloro-l-
(2,4,5-trichlorophenyl) ethenyl
dimethyl ester)
7440-28-0 Thallium 1.0
62-55-5 Thioacetamide _ 0.1
139-65-1 ' 4,4'-Thiodianiline 0.1
62-56-6 Thiourea 0.1
1314-20-1 Thorium dioxide , 1.0
7550-45-0 Titanium tetrachloride 1.0
108-88-3 Toluene ' 1.0
584-84-9 Toluene-2,4-diisocyanate 0.1
91-08-7 Toluene-2,6-diisocyanate 0.1
26471-62-5 Toluenediisocyanate ... 0.1
(mixed isomers).
95-53-4 . o-Toluidine 0.1
636-21-5 o-toluidine hydrochloridc 0.1
8001-35-2 Toxaphene ' 0.1
CD-ROM Users's Manual
APPENDIX C-5
-------
CAS Number Toxic Chemical Name
De Minimis
Concentration
0.1
68-76-8 Triaziquone
(2,5-Cyclohexadiene-l,4-dione,
2,3,5-tris(l -aziridinyl)-}
52-68-6 Trichlorfon 1.0
{Phosphonic acid,(2,2/2-trichloro-
l-hydroxyethyl)-,dimethyl ester)
120-82-1 1,2,4-Trichlorobenzene 1.0
71-55-6 1,1,1-Trichloroethane 1.0
{Methyl chloroform)
79-00-5 1,1,2-Trichloroethane 1.0
79-01-6 Trichloroethylene 1.0
75-69-4 Trichlorofluoromethane 1.0
{CFC-11}
95-95-4 2,4,5-Trichlorophenol 1.0
88-06-2 2,4,6-Trichlorophenol 0.1
1582-09-8 Trifluralin 1.0
{Benzenamine, 2,6-dinitro-N,N-
dipropyl-4-(trifluoromethyl)-l)
95-63-6 1,2,4-Trimethylbenzene 1.0
CAS Number
126-72-7
51-79-6
7440-62-2
108-05-4
593-60-2
75-01-4
75-35-4
1330-20-7
108-38-3
95-47-6 .
106-42-3
87-62-7
7440-66-6
12122-67-7
De
Minim
Toxic Chemical Name Concentratid
Tris (2,3-dibromopropyl)
phosphate
Urethane
{Ethyl carbamate}
Vanadium (fume or dust)
Vinyl acetate
Vinyl bromide
Vinyl chloride
Vinylidene chloride
Xylene (mixed isomers)
m-Xylene
o-Xylene
p-Xylene
2,6-Xylidine
Zinc (fume or dust)
Zineb
{Carbamodithioic acid, 1,2-
ethanediylbis-, zinc complex}
0.1
0.1 -
1.0
1,0
0.1
0.1
1.0
1.0
1.0
1.0
1.0 " 1
1.0
i.o
1.0
CD-ROM Users's Manual
APPENDIX C-6
-------
b. List By CAS Number
De Minimis
CAS Number Toxic Chemical Name Concentration
CAS Number Toxic Chemical Name
De Minimis
Concentration
50-00-0
51-28-5
51-75-2
51-79-6
52-68-6
53-96-3
55-18-5
55-21-0
55-63-0
56-23-5
56-38-2
57-14-7
57-57-8
57-74-9"
58-89-9
59-89-2
60-09-3
60-11-7
60-34-4
60-35-5
62-53-3
62-55-5
62-56-6
62-73-7
62-75-9
63-25-2
64-67-5
67-56-1
67-63-0
0.1
Formaldehyde
2,4-Dinitrophenol '
Nitrogen mustard
{2-Chloro-N-(2-chloroelthyl)-N-
methylethanamine}
Urethane " - 0.1
{Ethyl carbamate)
Trichlorfon
{Phosphonic acid/(2,2,2-trichloro-
1-hydroxyethyl)-, dimethyl ester}
2-Acetylaminofluorene 0.1
N-Nitrosodiethylamine
Benzafnide
Nitroglycerin
Carbon tetrachloride
Parathion
{Phosphorothioic acid, O,O-
diethyl-O-(4-nitrophenyl)ester)
1,1-Dimethyl hydrazine
beta-Propiolactone
Chlordane
{4,7-Methanoindan,l,2,4,5,6,7,
8,8-octachloro-2,3,3a,4,7,7a-
hexahydro-}
Lindane .
{Cyclohexane,! ,2,3,4,5,6-
hexachloro-,(l .alpha.,2.alpha.,
S.beta., 4.alpha.,5.alpha.,6.beta.)-}
N-Nitrosomorpholine
4-Aminoazobenzene
4-Dimethylaminoazobenzene
Methyl hydrazine ,
Acetamide
Aniline
Thioacetamide
, Thiourea
Dichlorvos
{Phosphoric acid, 2,2-
dichloroethenyl dimethyl ester)
N-Nitrosodimethylamine
Carbaryl
{1-Naphthalenol,
fnethylcarbamate)
Diethyl sulfate
Methanol
Isopropyl alcohol
(manufacturing-strong acid
process, no supplier notification)
0.1
1.0,
0.1
1.0
1.0
0.1
1.0
0.1
0.1
1.0
0.1
0.1
0.1
0.1
1.0
0.1
1.0
0.1
0.1
1.0
0.1
1.0
0.1
1.0
0.1
67-64-1 Acetone 1.0
67-66-3 Chloroform 0.1
67-72-1 Hexachloroethane 1.0
68:76-8 Triaziquone 0.1
{2,5-Cyclohexadiene-l ,4-dione,
2,3,5-trisd-aziridinyl)-}
71-36-3 n-Buryl alcohol 1.0
71-43-2 Benzene _ 0.1
71-55-6 1,1,1-Trichloroethane 1.0
{Methyl chloroform}
72-43-5 Methoxychlor 1.0
{Benzene, l,l'-(2,2,2-
trichloroethylidene)bis
[4-methoxy-]}
74-83-9 Bromomethahe 1.0
{Methyl bromide)
74-85-1 Ethylene ' 1.0
74-87-3 Chloromethane .1.0
{Methyl chloride)
74-88-4 Methyl iodide 0.1
74-90-8 Hydrogen cyanide 1.0
74-95-3 Methylene bromide 1.0
75-00-3 Chloroethane 1.0
{Ethyl chloride)
75-01-4 Vinyl chloride 0.1
75-05-8 Acetonitrile . 1.0
75-07-0 Acetaldehyde 0.1
75-09-2 Dichloromethane . 0.1
{Methylene chloride)
75-15-0 Carbon disulfide ' 1.0
75-21-8 Ethylene oxide ' 0.1
75-25-2 Bromoform 1.0
{Tribromomethane}
75-27-4 Dichlorobromomethane 1.0
75-35-4 Vinylidene chloride 1.0
75-44-5 Phosgene 1.0
75-55-8 Propyleneimine 0,1
75-56-9 Propylene oxide 0.1
75-63-8 Bromotrifluoromethane 1.0
{HalonlSOl)
75-65-0 tert-Butyl alcohol . 1.0
75-69-4 Trichlorofluoromethane 1.0
{CFC-11}
75-71-8 Dichlorodifluoromethane 1.0
{CFC-12}
76-13-1 Freon 113 1.0
{Ethane, l,l,2-trichloro-l,2,2-
trifluoro-)
76-14-2 Dichlorotetrafluoroethane . 1.0
{CFC-114)
CD-ROM Users's Manual
APPENDIX C - 7
-------
CAS Number Toxic Chemical Name
De Minimis
Concentration
76-15-3 Monochloropentafluoroethane 1.0
{CFC-115}
76-44-8 Heptachlor 1.0
{1,4,5,6,7,8,8-Heptachloro-
3a,4,7,7a-tetrahydro-
4,7-methano-l H-indene}
77-47-4 Hexachlorocyclopentadiene 1.0
77-78-1 Dimethyl sulfate 0.1
78-84-2 Isobutyraldehyde 1.0
78-87-5 1,2-Dichloropropane 1.0
78-88-6 2,3-Dichloropropene 1,0
78-92-2 sec-Butyl alcohol 1.0
78-93-3 Methyl ethyl ketone 1.0
79-00-5 1,1,2-Trichloroethane 1.0
79-01-6 Trichloroethylene 1.0
79-06-1 Acrylamide " 0.1
79-10-7 Acrylic acid 1.0
79-11-8 Chloroacetic acid 1.0
79-21-0 Peracetic acid 1.0
79-34-5 1,1,2,2-Tetrachloroethane 0.1
79-44-7 Dimethylcarbamyl chloride 0.1
79-46-9 2-Nitropropane 0.1
80-05-7 4,4'-Isopropylidenediphenol 1.0
80-15-9 Cumene hydroperoxide 1.0
SO-62-6 Methyl methacrylate 1.0
81-07-2 Saccharin (manufacturing, no 0.1
supplier notification)
{1,2-Benzisothiazol-3(2H)-one,
1,1-dioxide)
81-88-9 C.I. Food Red 15* 0.1
82-28-0 l-Amino-2-methyl- 0.1
anthraquinone
82-68-8 ' Quintozene 1.0
{Pentachloronitrobenzene}
.84-66-2 Diethyl phthalate 1.0
84-74-2 Dibutyl phthalate 1.0
85-44-9 Phthalic anhydride 1.0
85-68-7 Butyl benzyl phthalate ' 1.0
86-30-6 N-Nitrosodiphenylamine 1.0'
87-62-7 2,6-Xylidine 1.0
87-68-3 Hexachloro-l,3-butadiene 1.0
87-86-5 Pentachlorophenol 1.0
(PCP)
88-06-2 2,4,6-Trichlorophenol 0.1
88-75-5 . 2-Nitrophenol . 1.0
88-89-1 Picric acid 1.0
90-04-0 o-Anisidine 0.1
90-43-7 2-Phenylphenol 1.0
90-94-8 Michler's Ketone 0.1
CAS Number
91-08-7
91-20-3
91-22-5
' 91-59-8
91-94-1 '
92-52-4
92-67-1
92-87-5
92-93-3
94-36-0
94-59-7
94-75-7 .
95-47-6
95-48-7
95-50-1
95-53-4
95-63-6
95-80-7 .
95-95-4
96-09-3
96-12-8
96-33-3
96-45-7
97-56-3
98-07-7
98-82-8
98-87-3
98-88-4
98-95-3
99-59-2
99-65-0
100-02-7
100-25-4
100-41-4
100-42-5
100-44-7
100-75-4
101-14-4
101-61-1
101-68-8
101-77-9
De
Minim
Toxic Chemical Name Concentratil
: 1
Toluene-2,6-
Diisocyanate
Naphthalene
Quinoline
beta-Napthylamine
3,3'-Dichlorobenzidine
Biphenyl
4-Aminobiphenyl
Benzidine
. 4-Nitrobiphenyl
Benzoyl Peroxide
Safrole
2,4-D
{Acetic acid,
(2,4 dichlorophenoxy)-}
o-Xylene
o-Cresol
1,2 Dichlorobenzene
o-Toluidine
1,2,4 Trimethylbenzene
2,4-Diamiriotoluene
2,4,5-Trichlorophenol
Styrene oxide
l,2-Dibromo-3-chloropropane
{DBCP}
Methyl acrylate
Ethylene thiourea
C.I. Solvent Yellow 3*
Benzoic trichloride
(Benzotrichloride)
Cumene ,
Benzal chloride
Benzoyl chloride
Nitrobenzene
5-Nitro-o-anisidine
m-Dinitrobenzene
4-Nitrophenol
p-Dinitrobenzene
Ethylbenzene
Styrene
Benzyl chloride
N-Nitrosopiperidine
4,4'-Methylenebis (2-
chloroaniline)
{MBOCA}
4,4'-Methylenebis(N,N-
dimethyl) benzenamine
Methylenebis
(phenylisocyanate) {MBI}
4,4'-Methylenedianiline
0-M
1.0
1.0
0.1
0.1
1.0
0.1
-. 0.1
0.1
1.0
0.1
1.0
1.0
1.0
1.0
.0.1
1.0
0.1
1.0
0.1
0.1
1.0
0.1
0.1
0.1
1.0
1.0
1.0
'1.0
0.1
1.0
1.0
"1.0
1.0
0.1 .
1.0
0.1
0.1
0.1
1.0
0.1
CD-ROM Users's Manual
APPENDIX C - 8
-------
CAS Number Toxic Chemical Name
be Minimis
Concentration
CAS Number Toxic Chemical Name
De Minimis
Concentration
101-80-4 4,4'-Diaminodiphenyl ether 0.1
103-23-1 Bis(2-ethylhexyl) adipate 1.0
104-94-9 p-Anisidine 1.0
105-67-9 2,4-Dimethylphenol 1.0
106-42-3 p-Xylene 1.0
106-44-5 p-Cresol 1.0
106-46-7 1,4-Dichlorobenzene 0.1
106-50-3 p-Phenylenediamine 1.0
106-51-4 Quinone 1.0
106-88-7 1,2-Butylene oxide 1.0
106-89-8 Epichlorohydrin ~ 0.1
106-93-4 1,2-Dibromoethane . 0.1
{Ethylene dibromide}
106-99-0 1,3-Butadiene 0.1
107-02-8 Acrolein ' 1.0
107-05-1 Allyl chloride 1.0
107-06-2 1,2-Dichloroethane ' 0.1
{Ethylene dichloride}
107-13-1 Acrylonitrile . 0.1
107-18-6 Allyl alcohol ' -1.0
107-21-1 Ethylene glycol 1.0
107-30-2 Chloromethyl methyl ether 0.1
108-05-4 Vinyl acetate ' 1.0
108-10-1 Methyl isobutyl ketohe 1.0
108-31-6 Maleic anhydride 1.0
108-38-3' m-Xylene - 1.0
108-39-4 m-Cresol 1.0
108-60-1 Bis(2-chloro-l-rhethylethyl) 1.0
ether
108-88-3 Toluene 1.0
108-90-7 Chlorobenzene 1.0
108-95-2 Phenol - . 1.0
109-86-4 2-Methoxyethanol 1.0
110-80-5 2-EthoxyethanoI 1.0
110-82-7 Cyclohexane . 1.0
110-86-1 Pyridine 1.0
111-42-2 Diethanolamine .1.0.
111-44-4 Bis(2-chloroethyl) ether 1.0
114-26-1 Propoxur 1.0
{Phenol, 2-(l-methylethoxy)-,
methylcarbamate)
115-0771 _ Propylene (Propene) 1.0
115-32-2 Dicofol '1.0
{Benzenemethanol, 4-chloro-
.alpha.-(4-chlorophenyl)-
.alpha.-(trichloromethyl)-}
117-79-3 2-Aminoanthraquinone 0.1
117-81-7 Di(2-ethylhexyl) phthalate 0.1
.{DEHP}
117-84-0 n-Dioctyl phthalate 1.0
118-74-1 Hexachlorobenzene 0.1
119-90-4 3,3'-Dimethoxybenzidine 0.1
119-93-7 3,3'-Dimethylbenzidine 0.1
{o-Tolidine}
120-12-7 Anthracene 1.0
120-58-1 Isosafrole 1-Q
120-71-8 p-Cresidine , 0.1
120-80-9 Catechol 1.0
120-82-1 1,2,4-Trichlorobenzene 1.0
120-83-2 2,4-Dichlorophenol 1.0
121-14-2 2,4-Dinitrotoluene 1.0
121-69-7 N,N-Dimethylaniline 1.0
122-66-7 1,2-Diphenylhydrazine 0.1
{Hydrazobenzene}
123-31-9 Hydroqufnone 1.0
123-38-6 Propionaldehyde 1.0
123-72-8 Butyraldehyde 1.0
123-91-1 1,4-Dioxane 0.1
124-73-2 Dibromotetrafluoroethane 1.0
{Halon 2402}
126-72-7 Tris(2/3-dibromopropyl) 0.1
phosphate
126-99-8 Chloroprene 1.0
127-18-4 Tetrachloroethylene 0.1
'{Perchloroethylene)
128-66-5 C.I. Vat Yellow 4* ; 1.0
131-11-3 Dimethyl phthalate .1.0
132-64-9 Dibenzofuran 1.0
133-06-2 Captan, 1.0
{lH-Isoindole-l,3(2H)-dione,
3a,4,7,7a-tetrahydro-
2-[(trichloromethyl)thio]-}
133-90-4 Chloramben 1.0
{Benzoic acid, 3-amino- .
2,5-dichloro-}
134-29-2 o-Anisidine hydrochloride 0.1
134-32-7 alpha-Naphthylamine 0.1
135-20-6 Cupferron , 0.1
{Benzeneamine, N-hydroxy-
N-nitroso,ammonium salt)
139-13-9 Nitrilotriacetic acid 0.1
139-65-1 4,4'-Thiodianiline . 0.1
140-88-5 Ethyl acrylate 0.1-
141-32-2 Butyl acrylate . l.'O
151-56-4 . Ethyleneimine (Aziridine) 0.1
156-10-5 p-Nitrosodiphenylamine 0.1
156-62-7 Calcium cyanamide 1.0
302-01-2 Hydrazine ' 0.1
CD-ROM Users's Manual
APPENDIX C-9
-------
CAS Number Toxic Chemical Name
De Minimis
Concentration
CAS Number Toxic Chemical Name
De Minimi
Concentratil
309-00-2 Aldrin 1.0
{l,4:5,8-Dimethanonaphthalene,
l,2,3,4,10,10-hexachloro-l;4,4a,
5,8,8a-hexahydro-(l .alpha.,
4.alpha.,4a.beta.,5.alpha.,
8.alpha.,8a.beta.)-}
334-88-3 Diazomethane 1.0
353-59-3 Bromochlorodifluoromethane 1.0
{Halon 1211}
463-58-1 Carbonyl sulfide 1.0
492-80-8 C.I. Solvent Yellow 34* O.l'
{Aurimine}
505-60-2 Mustard gas . '0.1
{Ethane,l,l'-thiobis[2-chloro-)
510-15-6 Chlorobenzilate 1.0
{Benzeneacetic acid,4-chloro-
.alpha .-(4-chlorophenyl )-
.alpha.-hydroxy-,ethyl ester)
528-29-0 o-Dinitrobenzene 1.0
532-27-4 2-Chloroacetophenone 1.0
534-52-1 4,6-Dinitro-o-cresol 1.0
540-59-0 1,2-Dichloroethylene 1.0
541-41-3 Ethyl chloroformate 1.0
541-73-1 1,3-Dichlorobenzene 1.0
542-75-6 1,3-Dichloropropylene, 0.1
542-88-1 Bis(chloromethyl) ether 0.1
569-64-2 C.I. Basic Green 4* 1.0
584-84-9 Toluene-2,4-diisocyanate 0.1
593-60-2 Vinyl bromide 0.1
606-20-2 2,6-Dinitrotoluene 1.0
615-05-4 2,4-Diaminbanisole . 0.1
621-64-7 N-Nitrosodi-n-propylamine 0.1
624-83-9 Methyl isocyanate 1.0
636-21-5 o-Toluidine hydrochloride 0.1
680-31-9 - Hexamethylphosphoramide 0.1
684-93-5 N-Nitroso-N-methylurea 0.1
759-73-9 N-Nitroso-N-ethylurea 0.1
842-07-9 C.I. Solvent Yellow 14"- 0.1
924-16-3 N-Nitrosodi-n-butylamine 0.1
961-11-5 Tetrachlorvinphos 1.0
(Phosphoric acid, 2-chloro-l-
(2,4,5-trichlorophenyDethenyl
dimethyl ester)
989-38-8 ' C.I. Basic Red 1* o'.l
1120-71-4 Propane sultone - 0.1
1163-19-5 Decabromodiphenyl oxide 1.0
1313-27-5 Molybdenum trioxide 1.0
1314-20-1 Thorium dioxide 1.0
1319-77-3 Cresol (mixed isomers) 1.0
1330-20-7 Xylene (mixed isomers) 1.0
1332-21-4 Asbestos (friable) 0.1
1335-87-1 Hexachloronaphthalene 1.0
1336-36-3 Polychlorinated biphenyls 0.1
(PCBs)
1344-28-1 Aluminum oxide 0.1
(fibrous forms)
1464-53-5 Diepoxybutane 0.1
.1582-09-8 Trifluralin 1.0
{Benzenamine, 2,6- dinitro-N,N-
dipropyl-4-(trifluoromethyl)-)
1634-04-4 Methyl tert-butyl ether 1.0
1836-75-5 Nitrofen 0.1
{Benzene, 2,4-dichloro-l-
(4-ni trophenoxy)-}
1897-45-6 Chlorothalonil 1.0
{1,3-Benzenedicarbonitrile,
2,4,5,6-tetrachloro-}
1937-37-7 C.I. Direct Black 38* 0.1
2164-17-2 Fluometuron l.Q
{Urea, N,N-dimethyl-N'-
[3-(trifluoromethyl)phenyl]-}
2234-13-1 " Octachloronaphthalene 1.0
2303-16-4 Diallate 1.0
{Carbamothioic acid,
bis (1-methylethyl)-, S-(2,3-
. dichloro-2-propenyl) ester)
2602-46-2 C.I. Direct Blue 6* 0.)
2832-40-8 C.I. Disperse Yellow 3* 1.6
3118-97-6,- C.I. Solvent Orange 7* 1.0
3761-53-3 , C.I. Food Red 5* 0.1
4549740-0 N-Nitrosomethylvinylamine 0.1
4680-78-8 C.I. Acid Green 3* 1.0
6484-52-2 Ammonium nitrate (solution) 1.0
7429-90-5 Aluminum (fume or dust) lip
7439-92-1 Lead 0.1
7439-96-5 Manganese 1.0
7439-97-6 Mercury 1,0
7440-02-0 Nickel , 0.1
7440-22-4 Silver 1.0
7440-28-0 Thallium 1.0
7440-36-0 " Antimony 1.0
7440-38-2 Arsenic 0.1
7440-39-3 Barium 1.0
7440-41-7 Beryllium 0.1
7440-43-9 Cadmium 0.1
7440-47-3 Chromium 0.1
7440-48-4 Cobalt . 1.0
7440-50-8 Copper 1.0
7440-62-2 Vanadium (fume or dust) 1.0
7440-66-6 Zinc (fume or dust) . 1.0
CD-ROM Users's Manual
APPENDIX C - 10
-------
De Minimis
CAS Number Toxic Chemical Name Concentration
7550-45-0 Titanium tetrachloride 1.0
7647-01-0 Hydrochloric acid . . 1.0
7664-38-2 Phosphoric acid , 1.0
7664-39-3 Hydrogen fluoride , 1.0
7664-41-7 Ammonia 1.0 '
7664-93-9 Sulfuric acid 1.0
7697-37-2 Nitric acid 1,0
7723-14-0 Phosphorus (yellow or white) 1.0
7782-49-2 Selenium 1.0
7782-50-5 Chlorine 1.0
7783-20-2 Ammonium sulfate (solution) 1.0
8001-35-2 Toxaphene . 0.1
8001-58-9 . Creosote .:. 0.1
10034-93-2 Hydrazine sulfate 0.1
10049-04-4 Chlorine dioxide 1.0
12122-67-7 . Zineb ' 1.0
{Carbamodithioic acid, 1,2-
ethanediylbis-,zinc complex}
12427-38-2 Maneb 1.0
{Carbamodithioic acid, 1,2-
ethanediylbis-,manganese
. complex}
16071-86-6 C.I. Direct Brown 95* . 0.1
16543-55-8 N-Nitrosonornicotine 0.1
20816-12-0 Osmium tetroxide 1.0
25321-14-6 Dinitrotoluene (mixed isomers) 1.0
25321-22-6 Dichlorobenzene (mixed 0.1
isomers)
25376-45-8 . Diaminotoluene 0.1
(mixed isomers) -
. 26471-62-5 Toluenediisocyanate 0.1
(mixed isomers)
39156-41-7 2,4-Diaminoanisole sulfate 0.1
SECTION 313 TOXIC CHEMICAL CATEGORIES
Section 313 requires reporting on the toxic chemical
categories listed below, in addition to the specific toxic
chemicals listed above.
The metal compounds listed below, unless otherwise
specified, are defined as including any unique chemical
substance that contains the named metal (i.e., antimony,
copper, etc.) as part of that chemical's structure.
Toxic chemical categories are subject to the 1 percent de
minimis concentration unless the substance involved
meets the definition of an OSHA carcinogen, which are
subject to the 0.1 percent de minimis concentration. The
de minimis, concentration for each compound is pro-
vided in parenthesis.
Antimony Compounds - (Category Code N010) -
Includes any unique chemical substance that contains
antimony as part of that chemical's infrastructure. (1.0)
Arsenic Compounds - (Category Code N020) -
Includes any unique chemical substance that contains
arsenic as part of that chemical's infrastructure.
(Inorganic compounds: 0.1; organic compounds: 1.0)
Barium Compounds - (Category Code N040) - .. -
Includes any unique chemical substance that contains
barium as part of that chemical's infrastructure. (1.0)
Beryllium Compounds - (Category Code N050) -
Includes any unique chemical substance that contains
beryllium as part of that chemical's infrastructure.
(Inorganic compounds: O.T; organic compounds: 1.0)
Cadmium Compounds - (Category Code N078) -
Includes any unique chemical substance that contains
cadmium as part of that chemical's infrastructure.
, (Inorganic compounds: 0.1; organic compounds: 1.0)
Chlorophenols - (Category Code N084) - (0.1)
OH
(5-x)
where x = 1 to 5
CD-ROM Users's Manual
APPENDIX C - 11
-------
-------
APPENDIX D
-------
-------
APPENDIX D: STATE AND TERRITORY
ABBREVIATIONS
State/Territory
Abbreviation
Alaska AK
Alabama AIL
Arkansas AR
American Samoa AS
Arizona AZ
California GA
Colorado - . CO
Connecticut CT
District of Columbia DC
Delaware DE
Florida EL
Georgia ' GA
Guam GU
Hawaii HA
Iowa IA
Idaho .. ID
Illinois IL
Indiana . IN
Kansas KS
Kentucky KY
Louisiana LA
Massachusetts MA
Maryland MD
Maine ME
Marshall Islands NH
Michigan . MI
Minnesota MN
Missouri MO
Commonwealth/Northern Mariana Islands MP
Mississippi MS
Montana MT
North Carolina NC
North Dakota ND
Nebraska NE
CD-ROM User's Manual
APPENDIX D - 1
-------
State/Territory
Abbreviation
New Hampshire
New Jersey
New Mexico
Nevada
New York
Ohio
Oklahoma
Oregon
Pennsylvania
Puerto Rico
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Virginia
Virgin Islands
Vermont
Washington
Wisconsin
West Virginia
Wyoming
NH
NJ
MM
NV
NY
OH
OK
OR
PA
PR
RI
SC
SD
TN
TX
UT
VA
VI
VT
WA
WI
WV
WY
CD-ROM User's Manual
APPENDIX D - 2
-------
APPENDIX E
-------
-------
APPENDIX E: TRI Data Element Descriptions
The data element abbreviation (listed on the screen when you
retrieve a TRI record) is shown in parenthesis following the data
element name. For a list of data elements in alphabetic order by
abbreviation, see the Quick Reference Guide packaged with the CD-
ROM.
Accidental Release Total (ARELT) - Total quantity of toxic chemical
released resulting from events (accidental releases) not associated
with production processes.
Based on Operating Data (TRB) - 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 (followed by release medium in parenthesis) - 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 following release mediums
may be appended in parenthesis to Basis of Estimate to represent
different data elements (for example, Basis of Estimate (Land)):
Land (LB)
Non-Point (AIRNB) .
Offsite (OFFB)
Point Air (AIRPB) ...
POTW (.POTWB)
Underground (UB)
Water (WB) . ' .
The codes indicating the
formulated are as follows:
way in which the estimate was
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.
CD-ROM User's Manual
APPENDIX E - 1
-------
CASRN (RN) - 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 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 (CLAT) -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 (CLONG) - 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 (OCTL) - This indicates whether the reporting
facility controls the off-site location to which it transfers
wastes.
Covered Facility (FCOV) - 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 (EPAN) - 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.
CD-ROM User's Manual
APPENDIX E - 2
-------
EPA Region (EPAR) - 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
Region 2
Region 3
Region 4
Region 5
Region 6
Region 7
Region 8
Region 9
Region 10
CT, MA, ME, NH, RI, VT
NJ, NY, Puerto Rico, Virgin Islands
DE, MD, PA, VA, WV, DC
AL, FL, GA, KY, MS, NC, SC, TN
IL, IN, MI, MN, OH, WI
AR, LA, NM, OK, TX
IA, KS, MO, NE
CO, MT, ND, SD, UT, WY
AR, CA, HI, NV, American Samoa,
Guam, Trust Territories
AK, ID, OR, WA
EPA Submission Number (SUBN) - 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 (FCTY) -
located.
Facility County (FCO) -
is located.
City in which the reporting facility is
County in which, the reporting facility
Facility D & B Number (FDBN) - Facility Dun and Bradstreet Number
consisting of nine-digits assigned to identify specific businesses.
Facility Name (FNM) - The name of the reporting facility.
Facility State (FST) - State in which the reporting facility is
located. Searchable by the two-letter U.S. Postal Service
Code.
Facility Street Address (FAD) -
facility.
Street address of the reporting
Facility Zip Code (FZIP) - -Zip code of the reporting facility.
Five- or nine-digit zip codes are acceptable.
General Wastestream (GWST) - 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.
CD-ROM User's Manual
APPENDIX E - 3
-------
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 (GNM) - 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.
Influent Concentration (INFLC) - The influent concentration is the
percentage of the waste made up of the chemical as the waste Centers
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 (LDISP) - 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
DOS Land treatment/application farming
DOS Surface impoundment
D99 Other disposal.
Land Release (LR) - The reported number of pounds of a chemical
released to the environmental medium.
Latitude (LAT) - Latitude of the reporting facility in degrees (3
digits), minutes (2 digits), and seconds (2 digits). Optional in
1987 reports.
CD-ROM User's Manual
APPENDIX E - 4
-------
Longitude (LONG) - Longitude of the reporting facility in degrees
(3 digits), minutes (2 digits), and seconds (2 digits). Optional
in 1987 reports.
Manufacturing (MUSE) - Manufacturing activities involve the
manufacture of thes 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.
Maximum Amount On-Site (MAX) - 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 (Mixture Component Identity) (MIX) - 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 (AIRNR) - The^ reported number of pounds of a
chemical released to the environmental medium.
CD-ROM User's Manual
APPENDIX E - 5
-------
NPDES Permit Number (NPDES) - 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 (OFFCTY) - The city of the off-site facility to which
the reporting facility transfers waste.
Off-Site County (OFFCO) - The county of the off-site facility to
which the reporting facility transfers waste.
Off-Site Energy Recovery Current Year (OFRVC) - Total quantity of
toxic chemical in pounds used off-site for energy recovery during
the current reporting year.
Off-Site Energy Recovery Future Year (OFRVF) - 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 (OFRVN) - Total quantity of
toxic chemical in pounds estimated to be used off-site for energy
recovery next year.
Off-Site Energy Recovery Percent Change, Prior/Current Year.
(OFRVPER) - 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 (OFRVP) - Total quantity of
toxic chemical in pounds used off-site for energy recovery during
previous year.
Off-Site Name - (OFFN) - The name of the off-site location which
receives waste from a reporting facility.
Off-Site Recycling Current Year (OFCCC) - Total quantity of toxic
chemical in pounds recycled off-site during current year.
Off-Site Recycling Future Year (OFCCF) - Total quantity of toxic
chemical estimated to be recycled off-site in future year.
Off-Site Recycling Next Year (OFCCN) - Total quantity of toxic
chemical estimated to be recycled off-site next year.
CD-ROM User's Manual
APPENDIX E - 6
-------
Off-Site Recycling Percent Change, Prior/Current Year (OFCCPER) -
Percent change in quantity of toxic chemical used off-site for
recycling purposes comparing prior and current year quantities.
Off-Site Recycling Previous Year (OFCCP) - Total quantity of toxic
chemical in pounds recycled off-site during previous year.
Off-Site State (OFFST) - The location of the off-site facility to
which the reporting facility transfers waste.
Off-Site Street (OFFAD) - The street address of the off-site
location to which the reporting facility transfers waste.
Off-Site Transfer Amount (OFFR) - 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 (OFTTC) - Total quantity of toxic
chemical in pounds treated off-site for current year.
Off-Site Treatment Future Year (OFTTF) r Total quantity of toxic
chemical in.pounds to be treated off-site in future year.
Off-Site Treatment Next Year (OFTTN) - Total quantity of toxic
chemical in pounds to be treated off-site next year.
Off-Site Treatment Percent Change, Prior/Current Year (OFTTPER) -
Percent change, in quantity of toxic chemical treated off-site
comparing prior and current year quantities.
Off-Site Treatment Prior Year (OFTTP) - Total quantity of toxic
chemical in pounds treated off-site during the previous year.
Off-Site Zip Code (OFFZIP) - The zip code area of the off-site
facility to which the reporting facility transfers waste.
Other Location EPA ID (OLOC) - 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 (ONRVC) - Total quantity of
toxic chemical in pounds used on-site for energy recovery during
current year. ,
CD-ROM User's Manual
APPENDIX E - 7
-------
"
On-Site Energy Recovery Future Year (ONRVF) - 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 (ONRVN) - 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.
(ONRVPER) - Percent change in quantity of toxic chemical used
on-site for energy recovery comparing prior and current year
quantities.
On-Site Energy Recovery Prior Year (ONRVP) - 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 (ONRVM) - 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 (ONCCC) - Total quantity of toxic
chemical in pounds recycled on-site during current year.
On-Site Recycling Future Year (ONCCF) - Total quantity of toxic
chemical estimated to be recycled on-site in future year.
On-Site Recycling Next Year (ONCCN) - Total quantity of toxic
chemical in pounds estimated to be recycled on-site next year.
,,.,,..,,' ,. , '
On-Site Recycling Percent Change, Prior/Current Year (ONCCPER) -
Percent change in quantity of toxic chemical used on-site for
recycling purposes comparing prior and current year quantities.
On-Site Recycling Previous Year (ONCCP) - Total quantity of toxic
chemical in pounds recycled on-site during previous year.
CD-ROM User's Manual
APPENDIX B - 8
-------
On-Site Recycling Processes (ONCCM) - 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 RecoveryThin-Film Evaporation
R13 Solvents/Organics RecoveryFractionation
R14 Solvents/Organics RecoverySolvent Extraction "
R19 Solvents/Organics RecoveryOther
R21 Metals RecoveryElectrolytic
R22 Metals RecoveryIon Exchange
R23 Metals RecoveryAcid Leaching
R24 Metals RecoveryReverse Osmosis
R26 Metals RecoverySolvent Extraction
R27 Metals RecoveryHigh Temperature
R28 Metals RecoveryRetorting
R29 Metals RecoverySecondary Smelting
R30 Metals RecoveryOther
R40 Acid Regeneration
R99 Other Reuse or Recovery
On-Site Treatment Current Year (ONTTC) - Total quantity of toxic
chemical in pounds treated on-site during current year.
On-Site Treatment Future Year (ONTTF) - Total quantity of toxic
chemical in pounds estimated to be treated on-site in future year.
Onsite .Treatment Next Year (ONTTN) - Total quantity of toxic
chemical in pounds estimated to be treated on-site next year.
Onsite Treatment Percent Change, Prior/Current Year (ONTTPER) -
Percent change in quantity of toxic chemical treated on-site
comparing previous and current year quantities.
On-Site Treatment Prior Year (ONTTP) - Total quantity, of toxic
chemical in pounds treated on-site during previous year.
Other Use (OUSE) " - 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.
Parent Company Name (PNM) -
reporting facility.
The name of the company that owns the
CD-ROM User's Manual
APPENDIX E - 9
-------
Parent Duns Number (PDBN) - The Dun and Bradstreet number of the
company that owns the reporting facility.
Point-Air Release (AIRPR) - The reported number of pounds of a
chemical released to the environmental medium.
POTW City (POTWCTY) - The city of the Publicly Owned Treatment
Works (commonly called a sewer plant) to which the reporting
facility transfers waste.
POTW County (POTWCO) - The county of the Publicly Owned Treatment
Works (commonly called a sewer plant) to which the reporting
facility transfers waste.
POTW Name (POTWN) - The name of the Publicly Owned Treatment Works
(commonly called a sewer plant) which receives waste from a
reporting facility.
POTW State (POTWST) - The location of the Publicly Owned Treatment
Works (commonly called a sewer plant) to which the reporting
facility transfers waste.
POTW Street (POTWST) - The street address of the Publicly Owned
Treatment Works (commonly called a sewer plant) to which the
reporting facility transfers waste.
POTW Transfer Amount (POTWR) - The reported number of pounds of a
chemical transferred off-site of the facility.
POTW Zip Code (POTWZIP) - The zip code area of the off-site
facility to which the reporting facility transfers waste.
Processing (PUSE) - 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 (PRODR) - Ratio of current
reporting year production quantities to previous year'production.
CD-ROM User's Manual
APPENDIX E - 10
-------
Public Contact/Phone (PUBC) - 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 (QRELC) - Total quantity of the
toxic chemical in pounds.released during the current year.
Quantity Released Future Year (QRELF) - Total quantity of the toxic
chemical in pounds estimated to be released in future year.
Quantity Released Next Year (QRELN) - Total quantity of the toxic
chemical in.pounds estimated to be released next year.
Quantity Released Percent Change, Prior/Current Year (QRELPER) -
Percentage change in quantity released comparing previous and
current year reporting quantities. '
Quantity Released Prior Year (QRELP) - Total quantity of the toxic
chemical in pounds released during prior year.
Range Estimate (followed by release medium in parenthesis) - The
folowing release medium are allowed:
Land (LE) -
_ Non-Point (AIRNE)
Off-Site (OFFE) . , .
Point-Air (AIRPE)
POTW (POTWE) -
Underground (UE)
Water (WE) ;
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 (YR) - The calendar year for which the FORM R was
submitted.
SIC (SIC) - The Standard Industrial Classification, code defined.
CD-ROM User's Manual
APPENDIX E - 11
-------
SIC Code (SIGN) - 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). 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
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 (SREDA) - 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
CD-ROM User's Manual
APPENDIX E - 12
-------
Source Reduction Methods (SREDM) - 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)
TO3 Materials balance audits
T04 Participative team management
TQ5 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) - 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.
Stormwater Percent (SPER) - For releases to water, spme 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 (STRN) - 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. (NAME) - The name of the section 313 chemical.
Sum Air Releases (SAIR) - Summation of non-point and point chemical
releases in pounds.
Sum All Releases to Environment (SENV) - Summation of all chemical
releases to the environment in pounds.
Sum Land Releases (SL) - Summation of all chemical releases to land
in pounds.
CD-ROM User's Manual
APPENDIX E - 13
-------
Sum Off-Site Transfers (SOFF) - The reported number of pounds of a
chemical transferred off-site of the facility.
Sum POTW and Off-Site Transfers (SPO) - Summation of all POTW and
off-site transfers in, pounds.
Sum POTW Transfers (SPOTW) - Summation of all releases in pounds to
publicly owned treatment works.
Sum Releases and Transfers (SRT) - Summation of all environmental
releases and transfers to publicly owned treatment works in pounds.
Sum Underground Releases (SU) - Summation of all chemical releases
injected underground in pounds.
Sum Water Releases (SW) - Summation of all chemical releases to
water in pounds.
Treatment Efficiency (TREFF) - 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 (TRM) - 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 (TRIM) - 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.
CD-ROM User's Manual
APPENDIX E - 14
-------
Type Treatment, Disposal (OTM) - This includes the type of
treatment or disposal associated with the chemical at the off-site
location. The codes are:
Disposal:
M10 Storage onlyIndicates any means of storage
M71 Underground Injection
M72 Landfill/Disposal Surface Impoundment
, M73 Land TreatmentDestruction of chemical by spreading on
land " -
M79 Other Land Disposal
M94 Transfer to Waste BrokerDisposal
Recycling: :
M20 Solvents/Organics Recovery
M24 Metals Recovery
M26, Other Reuse or Recovery
M28 Acid Regeneration
M93 Transfer to Waste Broker:Recycling
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 BrokerWaste Treatment
Energy Recovery:
M56 Energy Recovery
M92 Transfer to Waste Broker-Energy Recovery
UIC ID (UIC) - 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 (UR) - The reported number of pounds of a
chemical released to the environmental medium.
Water Release (WR) - The reported number of pounds of a chemical
released to the environmental medium.
CD-ROM User's Manual
APPENDIX E - 15
-------
-------
APPENDIX F
-------
-------
[PPENDIX F: Standard Industrial Classification (SIC)
Codes For Facilities Reporting to TRT
20 Food and Kindred Products
2011 Meat packing plants
2013 Sausages and other prepared meat products
2015 Poultry slaughtering and processing
2021 Creamery butter
2022 Natural, processed, and imitation cheese
2023 Dry, condensed, and evaporated dairy
products
2024 Ice cream and frozen desserts
2026 Fluid milk
2032 Canned specialties ,
2033 Canned fruits, vegetables, preserves, jams,
and jellies
2034 Dried and dehydrated fruits, vegetables, and
soup mixes ,
2035 Pickled fruits and vegetables, vegetable sauces
and seasonings, and salad dressings
2037 Frozen fruits, fruit juices, and vegetables
2038 Frozen specialties, n.e.c.*
2041 Flour and other grain mill products
2043 Cereal breakfast foods
2044 Rice milling
2045 Prepared flour mixes and doughs
2046 Wet corn milling
2047 Dog and cat food. "
2048 Prepared feeds and feed ingredients for
animals and fowls, except dogs and cats
2051 Bread and other bakery products, except
cookies and crackers
2052 Cookies and crackers
2053 Frozen bakery products, except bread
2061 Cane sugar, except refining
2062 Cane sugar refining .
2063 Beet sugar " . '
2064 Candy and other confectionery products
2066 Chocolate and cocoa products
2067 Chewing gum
2068 Salted and roasted nuts and seeds
2074 Cottonseed oil mills
2075 Soybean oil mills
2076 Vegetable oil mills, n.e.c.*
2077 Animal and marine fats and oils
2079 Shortening, table oils, margarine, and other
edible fats and oils, n.e.c.*
2082 Malt beverages
2083 Malt
2084 Wines, brandy, and brandy spirits
2085 Distilled and blended liquors
2086 Bottled and canned soft drinks and
' carbonated waters
2087 Flavoring extracts and flavoring syrups, n.e.c.*
2091 Canned and cured fish and seafoods
2092 Prepared fresh or frozen fish and seafoods
2095 Roasted coffee
2096 Potato chips, corn chips, and similar snacks
2097 Manufactured ice.
2098 Macaroni, spaghetti, vermicelli, and noodles
2099 Food preparations, n.e.c.*
21 Tobacco Products
2111 Cigarettes .
2121 Cigars '
2131 Chewing and smoking tobacco and snuff
2141 Tobacco stemming and redrying ,
22 Textile Mill Products
2211 Broad woven fabric mills, cotton
2221 Broad woven fabric mills, manmade fiber, and
silk
2231 Broadwoven fabric mills, wool (including
dyeing and finishing)
2241 Narrow fabric and other smallwares mills:
cotton, wool, silk, and manmade fiber
2251 Women's full length and knee length hosiery,
except socks
2252 Hosiery, n.e.c.*
2253 Knit outerwear mills
2254 Knit underwear and nightwear mills
2257 We'ff knit fabric mills ,
2258 Lace and warp knit fabric mills
2259 Knitting mills, n.e.c.*
2261 Finishers of broadwoven fabrics of cotton
2262 Finishers of broadwoven fabrics of manmade .
fiber and silk
2269 Finishers of textiles, n.e.c.*
2273 Carpets and rugs
2281 Yarn spinning mills
2282 Yarn texturizing, throwing, twisting, and
winding mills'
2284 Thread mills
2295 Coated fabrics, not rubberized
2296 Tire cord and fabrics"
2297 Non woven fabrics
2298 Cordage and twine "
2299 Textile goods, n.e.c.*
CD-ROM User's Manual
APPENDIX F-l
-------
23 Apparel and Other Finished Products made
from Fabrics and Other Similar Materials
2311 Men's and boys' suits, coats, and overcoats
2321 Men's and boys' shirts, except work shirts
2322 Men's and boys' underwear and nightwear
2323 Men's and boys' neckwear
2325 Men's and boys' separate trousers and slacks
2326 Men's and boys' work clothing
2329 Men's and boys' clothing, n.e.c.*
2331 Women's, misses', and juniors' blouses and
shirts
2335 Women's, misses', and juniors' dresses
2337 Women's, misses', and juniors' suits, skirts,
and coats
2339 Women's, misses', and juniors', outerwear,
n.e.c.*
2341 Women's,, misses', children's, and infants'
underwear and nightwear
2342 Brassieres, girdles, and allied garments
2353 Hats,'caps, and millinery
2361 Girls', children's and infants' dresses, blouses,
and shirts
2369 Girls', children's and infants' outerwear,
n.e.c.*
2371 Fur goods
2381 Dress and work gloves, except knit and all
leather
2384 Robes and dressing gowns
2385 Waterproof outerwear
2386 Leather and sheep lined clothing
2387 Apparel belts
2389 Apparel and accessories, n.e.c.*
2391 Curtains and draperies
2392 Housefurnishings, except curtains and
draperies
2393 Textile bags
2394 Canvas and related products
2395 Pleating, decorative and novelty stitching, and
tucking for the trade
2396 Automotive trimmings, apparel findings, and
related products
2397 Schiffli machine embroideries
2399 Fabricated textile products, n.e.c.*
24 Lumber and Wood Products, Except
Furniture
2411 Logging
2421 Sawmills and planing mills, general
2426 Hardwood dimension and flooring mills
2429 Special product sawmills, n.e.c.*
2431 Millwork
2434 Wood kitchen cabinets
2435 Hardwood veneer and plywood
2436 Softwood veneer and plywood
2439 Structural wood members, n.e.c.*
2441 Nailed and lock corner wood boxes and shoe]
2448 Wood pallets and skids
2449 Wood containers, n.e.c.*
2451 Mobile homes
2452 Prefabricated wood buildings and componer
2491 Wood preserving
2493 Reconstituted wood products
2499 Wood products, n.e.c.*
25 Furniture and Fixtures
2511 Wood household furniture, except
upholstered
2512 Wood household furniture, upholstered
2514 Metal household furniture
2515 Mattresses, foundations, and convertible
2517 Wood television, radio, phonograph, and
sewing machine cabinets
2519 Household furniture, n.e.c.*
2521 Wood office furniture
2522 Office furniture, except wood
2531 Public building and related furniture
2541 Wood office and store fixtures, partitions,
shelving, and lockers
2542 Office and store fixtures, partitions, shelving)
and lockers, except wood
2591 Drapery hardware and window blinds and
shades
2599 Furniture and fixtures, n.e.c.*
26 Paper and Allied Products
2611 Pulp mills
2621 Paper mills
2631 Paperboard mills
2652 Setup paperboard boxes
2653.Corrugated and solid fiber boxes
2655 Fiber cans, tubes, drums, and similar produc
2656 Sanitary food containers, except folding
2657 Folding paperboard boxes, including sanitar
2671 Packaging paper and plastics film, coated
laminated
2672 Coated and laminated paper, n.e.c.*
2673 Plastics, foil, and coated paper bags
, 2674 Uncoated paper and multiwall bags
2675 Die-cut paper and paperboard and cardboanj
2676 Sanitary paper products
2677 Envelopes
2678 Stationery tablets, and related" products
2679 Converted paper and paperboard products,
n.e.c.*
CD-ROM User's Manual
APPENDIX F-2
-------
27 Printing, Publishing, and Allied Industries
2711 Newspapers: publishing, or publishing and
printing
2721 Periodicals: publishing, or publishing and
printing
2731 Books: publishing, or publishing and printing
2732 Book printing
2741 Miscellaneous publishing
2752 Commercial printing, lithographic
2754 Commercial printing, gravure
2759 Commercial printing, n.e.c.*
2761 Manifold business forms
2771 Greeting cards
2782 Blankbooks, looseleaf binders and devices
2789 Bookbinding and related work
-2791 Typesetting '
2796 Platemaking and related services
28 Chemicals and Allied Products
2812 Alkalies and chlorine
2813 Industrial gases
2816 Inorganic pigments
2819 Industrial inorganic chemicals, n.e.c.*
2821 Plastics materials, synthetic resins, and
non-vulcanizable elastomers
2822 Synthetic rubber (vulcanizable elastomers)
2823 Cellulosic manmade fibers
2824 Manmade organic fibers, except cellulosic
2833 Medicinal chemicals and botanical products
2834 Pharmaceutical preparations
2835 In vitro and in vivo diagnostic substances
2836 Biological products, except diagnostic
substances
2841 Soap and other detergents, except specialty
cleaners
2842 Specialty cleaning, polishing, and sanitation .
preparations
2843 Surface active agents, finishing agents,
sulfonated oils, and assistants
2844 Perfumes, cosmetics, and other toilet
preparations
2851 Paints, varnishes, lacquers, enamels, and allied
products ,
2861 Gum and wood chemicals
2865 Cyclic organic crudes and intermediates, and
organic dyes and pigments
2869 Industrial organic chemicals, n.e.c.*
2873 Nitrogenous fertilizers
2874 Phosphatic-fertilizers
2875 Fertilizers, mixing only
2879 Pesticides and agricultural chemicals, n.e.c.*
2891 Adhesives and sealants
2892 Explosives
2893 Printing ink
2895 Carbon black '.
2899 Chemicals and chemical preparations, n.e.c.*
29 Petroleum Refining and Related Industries
2911 Petroleum refining
2951 Asphalt paving mixtures and blocks
2952 Asphalt felts and coatings
2992 Lubricating oils and greases
2999 Products of petroleum and coal, n.e.c.*
30 Rubber and Miscellaneous Plastics Products
3011 Tires and inner tubes
3021 Rubber and plastics footwear
3052 Rubber and plastics hose and belting
3053 Gaskets, packing, and sealing devices
3061 Molded, extruded, and lathecut mechanical
rubber products
3069 Fabricated rubber products, n.e.c.* '
3081 Unsupported plastics film and sheet -
3082 Unsupported plastics profile shapes
3083 Laminated plastics plate, sheet, and profile
shapes
3084 Plastics pipe . . .
3085 Plastics bottles
_ 3086 Plastics foam products
3087 Custom compounding of purchased plastics
resins
3088 Plastics plumbing fixtures -
3089 Plastics products, n.e.c.*
31 Leather and Leather Products
3111 Leather tanning and finishing
3131 Boot and shoe cut stock and findings
3142 House slippers
3143 Men's footwear, except athletic
3144 Women's footwear/except athletic
3149 Footwear, except rubber, n.e.c.*
3151 Leather gloves and mittens
3161 Luggage
3171 Women's handbags and purses
3172 Personal leather goods, except women's
handbags and purses
3199 Leather goods, n.e.c.*
CD-ROM User's Manual
APPENDIX F-3
-------
32 Stone, Clay, Glass and Concrete Products
3211 Flat glass
3221 Glass containers
3229 Pressed and blown glass and glassware, n.e.c.*
3231 Glass products, made of purchased glass
3241 Cement, hydraulic
3251 Brick and structural clay tile
3253 Ceramic wall and floor tile
3255 Clay refractories
3259 Structural clay products, n.e.c.*
3261 Vitreous china plumbing fixtures and china
and earthenware fittings and bathroom
accessories
3262 Vitreous china table and kitchen articles
3263 Fine earthenware (whiteware) table and
kitchen articles
3264 Porcelain electrical supplies
3269 Pottery products, n.e.c.*
3271 Concrete block and brick
3272 Concrete products, except block and brick
3273 Ready mixed concrete
3274 Lime
3275 Gypsum products
3281 Cut stone and stone products
3291 Abrasive products
3292 Asbestos products
3295 Minerals and earths, ground or otherwise
treated
3296 Mineral wool
3297 Nonclay refractories
3299 Nonmetallic mineral products, n.e.c.*
33 Primary Metal,Industries
3312 Steel works, blast furnaces (including coke
ovens), and rolling mills
3313 Elcctrometallurgical products, except steel
3315 Steel wiredrawing and steel nails and spikes
3316 Cold-rolled steel sheet, strip, and bars
3317 Steel pipe and tubes '
3321 Gray and ductile iron foundries
3322 Malleable iron foundries
3324 Steel investment foundries
3325 Steel foundries, n.e.c.*
3331 Primary smelting and refining of copper
3334 Primary production of aluminum
3339 Primary smelting and refining of nonferrous
metals, except copper and aluminum
3341 Secondary smelting and refining of nonferrous
metals
3351 Rolling, drawing, and extruding of copper
3353 Aluminum sheet, plate, and foil
3354 Aluminum extruded products
3355 Aluminum rolling and drawing, n.e.c.*
3356 Rolling, drawing, and extruding of nonferrol
metals, except copper and aluminum
3357 Drawing and insulating of nonferrous wire
3363 Aluminum die-castings
3364 Nonferrous die-castings, except aluminum
3365 Aluminum foundries
3366 Copper foundries
3369 Nonferrous foundries, except aluminum anc
copper
3398 Metal heat treating
3399 Primary metal products, n.e.c.*
34 Fabricated Metal Products, except Machine)
and Transportation Equipment
3411 Metal cans
3412 Metal shipping barrels, drums, kegs, and pail
3421 Cutlery
3423 Hand and edge tools, except machine tools
and handsaws
3425 Handsaws and saw blades
3429 Hardware, n.e.c.*
3431 Enameled iron and metal sanitary ware
3432 Plumbing fixture fittings and trim
3433 Heating equipment, except electric and war
air furnaces
3441 Fabricated structural metal
3442 Metal doors, sash, frames, molding/and trir
3443 Fabricated plate work (boiler shops)
3444 Sheet metal work ,
3446 Architectural and ornamental metal work
3448 Prefabricated metal buildings and componer
3449 Miscellaneous structural metal work
3451 Screw machine products
3452 Bolts, nuts, screws, rivets, and washers
3462 Iron and steel forgings
3463 Nonferrous forgings
3465 Automotive stampings
3468 Crowns and closures
3469 Metal stampings, n.e.c.*
3471 Electroplating, plating, polishing, anodizing, I
and coloring
3479 Coating, engraving and allied services, n.e.c.l
3482 Small arms ammunition
3483 Ammunition, except for small arms
3484 Small arms
3489 Ordnance and accessories, n.e.c.*
3491 Industrial valves
3492 Fluid power valves and hose fittings
3493 Steel springs, except wire
3494 Valves and pipe fittings, n.e.c.*
CD-ROM User's Manual
APPENDIX F-4
-------
3495 Wire springs
3496 Miscellaneous fabricated wire products
3497 Metal foil and leaf
3498 Fabricated pipe and pipe fittings
3499 Fabricated metal products, n.e.c.*
35 Industrial and Commercial Machinery and
Computer Equipment "*
3511 Steam, gas and hydraulic turbines, and turbine
generator set units
3519 Internal combustion engines, n.e.c.*
3523 Farm machinery and equipment
3524 Lawn and garden tractors and home lawn arid
garden equipment
3531 Construction machinery and equipment
3532 Mining machinery and equipment, except oil '
and gas field machinery and equipment
3533 Oil and gas field machinery and equipment
3534 Elevators and moving stairways
3535 Conveyors and conveying equipment
3536 Overhead traveling cranes, hoists, and
monorail systems
3537 Industrial trucks, tractors, trailers, and
stackers
3541 Machine tools, metal cutting types
3542 Machine tools, metal forming types
3543 Industrial patterns
3544 Special dies and tools, die sets, jigs and
fixtures, and industrial molds
3545 Cutting tools, machine tool accessories, and
machinists' measuring devices
3546 Power driven handtools
3547 Rolling mill machinery and equipment
3548 Electric and gas welding and soldering
'equipment
3549 Metalworking machinery, n.e.c.*
3552 Textile machinery
3553 Woodworking machinery
3554 Paper industries machinery
3555 Printing trades machinery and equipment
3556 Food products machinery
3559 Special industry machinery, n.e.c.*
3561 Pumps and pumping equipment
3562 Ball and roller bearings
3563 Air and gas compressors
3564 Industrial and commercial fans and blowers
and air purification equipment
3565 Packaging equipment
3566 Speed changers, industrial high speed drives,
and gears
3567 Industrial process furnaces and ovens
3568 Mechanical power transmission equipment, .
n.e.c.*
3569 General industrial machinery and equipment,
n.e.c.*
3571 Electronic computers
3572 Computer storage devices
3575 Computer terminals
3577 Computer peripheral equipment, n.e.c.*
3578 Calculating and accounting machines, except
electronic computers
3579 Office machines, n.e.c.* "
3581 Automatic vending machines
3582 Commercial laundry, drycleaning, and.
pressing machines
3585 Air conditioning and warm air heating
equipment and commercial and industrial
refrigeration equipment
3586 Measuring and dispensing pumps
3589 Service industry machinery, n.e.c.*
3592 Carburetors, pistons, piston rings, and valves
3593 Fluid power cylinders and actuators
3594 Fluid power pumps and motors
3596 Scales and balances, except laboratory
3599 Industrial and commercial machinery and
equipment, n.e.c*
36 Electronic and Other Electrical Equipment
and Components, Except Computer
Equipment ,
3612 Power, distribution) and specialty
transformers
3613 Switchgear and switchboard apparatus
3621 Motors and generators
3624 Carbon and graphite products
3625 Relays and industrial controls
3629 Electrical industrial appliances, n.e.c.*
3631 Household cooking equipment
3632 Household refrigerators and home and farm
freezers
3633 Household laundry equipment
'3634 Electrical housewares and fans .
3635 Household vacuum cleaners
3639 Household appliances, n.e.c.*
3641 Electric lampbulbs and tubes
3643 Current carrying wiring devices
3644 Noncurrent carrying wiring devices
3645 Residential electric lighting fixtures
3646 Commercial, industrial, and institutional
electric lighting'fixtures
3647 Vehicular lighting equipment
3648 Lighting equipment, n.e.c.*
3651 Household audio and video equipment
3652 Phonograph records and pre-recorded audio
tapes and disks
CD-ROM User's Manual
APPENDIX F-5
-------
3661 Telephone and telegraph apparatus
3663 Radio and television broadcasting and
communications equipment
3669 Communications equipment, n.e.c.*
3671 Electron tubes
3672 Printed circuit boards
3674 Semiconductors and related devices
3675 Electronic capacitors
3676 Electronic resistors
3677 Electronic coils, transformers, and other
inductors
3678 Electronic connectors
3679 Electronic components, n.e.c.*
3691 Storage batteries
3692 Primary batteries, dry and wet
3694 Electric equipment for internal combustion
engines
3695 Magnetic and optical recording media
3699 Electrical machinery, equipment, and supplies,
n.e.c.*
37 Transportation Equipment
3711 Motor vehicles and passenger car bodies
3713 Truck and bus bodies
3714 Motor vehicle parts and accessories
3715 Truck trailers
3716 Motor homes
3721 Aircraft
3724 Aircraft engines and engine parts
3728 Aircraft parts and auxiliary equipment, n.e.c.*
3731 Ship building and repairing
3732 Boat building and repairing
3743 Railroad equipment
3751 Motorcycles, bicycles and parts
3761 Guided missiles and space vehicles
3764 Guided missile and space vehicle propulsion
units and propulsion unit parts
3769 Guided missile and space vehicle parts and
auxiliary equipment, n.e.c.*
3792 Travel trailers and campers
3795 Tanks and tank components
3799 Transportation equipment, n.e.c.*
38 Measuring, Analyzing, and Controlling
Instruments; Photographic, Medical and
Optical Goods; Watches and Clocks
3812 Search, detection, navigation, guidance,
aeronautical, and nautical systems and
instruments
3821 Laboratory apparatus and furniture
3822 Automatic controls for regulating residentil
and commercial environments and applianl
3823 Industrial instruments for measurement,
display, and control of process variables; i
related products
3824 Totalizing fluid meters and counting devicJ
3825 Instruments for measuring and testing of
electricity and electrical signals
3826 Laboratory analytical instruments
3827 Optical instruments and lenses
3829 Measuring and controlling devices, n.e.c.*
3841 Surgical and medical instruments and
apparatus
3842 Orthopedic, prosthetic, and surgical
appliances and supplies
3843 Dental equipment and supplies
3844 X-ray apparatus and tubes and related
irradiation apparatus v
3845 Electromedical and electrotherapeutic
apparatus
3851 Ophthalmic goods
3861 Photographic equipment and supplies
3873 Watches, clocks, clockwork operated devic
and parts
39 Miscellaneous Manufacturing Industries
3911 jewelry, precious metal
3914 Silverware, plated ware, and stainless steelj
ware
3915 Jewelers' findings and materials, and lap\d\
work
3931 Musical instruments
3942 Dolls and stuffed toys
3944 Games, toys and children's vehicles; excepa
dolls and bicycles
3949 Sporting and athletic goods, n.e.c.*
3951 Pens, mechanical pencils, and parts
3952 Lead pencils, crayons, and artists' material^
3953 Marking devices
3955 Carbon paper and inked ribbons
3961 Costume jewelry and costume novelties,
except precious metal
3965 Fasteners, buttons, needles, and pins
3991 Brooms and brushes
3993 Signs and advertising specialties
3995 Burial caskets
3996 Linoleum, asphalted-felt-base, and other ha
surface floor coverings, n.e.c.*
3999 Manufacturing industries, n.e.c.*
CD-ROM User's Manual
APPENDIX F-6
-------
APPENDIX G
-------
-------
APPENDIX G; Practice TRI Searches
Display all of the TRI records for facilities located in the zip
code 15401.
1. Sign onto the TRI 1987 - 1992 GD-ROM by changing to the
directory where the software for Disc 1 was installed on the hard
drive and typing tri . Select the Toxic Release Inventory
, Releases file >, .
2. Screen displays window for F3=Select. Use the down arrow to go
to Facility Zip Code .
3. Window switches to F4=Search automatically. Enter search term
15401 .
4. Screen will display set number and number of records found.
Press P6=Display to bring up the first record on the screen. Page
line by line or record by record using the cursor keys.
Answer: 50 records retrieved.
Display all records for General Motors facilities for 1992 sorted
by city and state.
1. Press ESC to clear the
F3=Select menu will appear.
Name .
screen from the last search. The
Use arrow key to highlight Facility
2. Window switches to F4=Search automatically. Type General
Motors . You will get a search equivalent to General
Motors. (There are no adjacency operators. Be aware
that false drops may occur, e.g., Teledyne Motors General or
General Electric Co. Motors Business.)
3. Repeat step 2 for any synonyms, e.g., GM or GMC. To get both GM
and GMC in one search, enter GM? . Use the grouping keys to
mark the terms to select., F7 and F8 mark the beginning and end of
a range; F9 marks a specific term. In this case, you would use F9
to mark all entries beginning with GM and GMC . Repeat also
for Parent Company Name field to get all facilities for a large
company.
4. To combine sets, press F5=SETS and cursor to Combine Sets
then Combine With OR: . Enter the first set
number then second set and so on and press
again. .
CD-ROM User's Manual
APPENDIX G - 1,
-------
5. To narrow to 1992 records only, press F5=SETS, cursor to Change
Search Set and type set number from previous
search. Press P3=Select, cursor to Reporting Year . Cursor
to 1992 and . (At completion of example, use F5 to Change
Search Set back to 0 for entire database.)
6. Press F6=Display to call up first record. Press for
action menu, select Re-Rank Current Set , and cursor to User
Defined Rank . Cursor to PST (Facility State) then
to FCTY (Facility City) . Cursor to End Rank Selections
(at top of data element list) and . (The message ESCAPE
CANCELS RANK will appear during the search.)
Answer: 1,123 records retrieved.
Print out the name, address, and total amount of air releases for
all TRI facilities in Lehigh County that produce paper products.
1. Search Releases file for Lehigh County facilities using the
following steps: F3, Facility County, ', Lehigh, .
(For more detail, review preceding example. If you get message
Lehigh Unavailable, you forgot to change the search set back to 0
after the last example.)
2. Search Releases file for paper manufacturers by entering F3, SIC
Code, , 26? . (Twenty six is the SIC code for Paper
and Allied Products. See Readme.SIC file for list of four digit
SIC codes for searches requiring more specificity.) To select all
SIC codes in that range, highlight 26, F7 to mark first term in
range with down arrow, highlight 2699, F9 to mark last term in
range with up arrow, .
3. Combine Sets using F5, Combine Sets, , Combine With
AND:, , set number, , set number, ,
. Alternatively, you could Search Within A Set as shown in
step 5 in the above example. For experienced searchers, it is
often faster.
4. To print out set, press F5=SETS, cursor to Print a Set
, and type set number . Highlight Print by
FACILITY NAME to sort by that field. Choose output format
User Selected Output . Cursor to FNM (Facility Name) and
press F7 then FST (Facility State) and press P8. Skip FIPS
(State/County FIPS Code) and mark FZIP (Facility Zip Code) with F9
to mark address fields. Cursor to SAIR (Sum Air Releases) and mark
with F9 key . Choose Consecutive Print , align
the paper, and .
Answer: 15 records printed out.
CD-ROM User's Manual
APPENDIX G-2
-------
Download data to dBase format for all facilities in the U.S. that
reported to TRI for the chemical beryllium.
1. If you have a Chemical Abstract Service (CAS) number, that
is the preferred way to search by chemical because it is more
precise. In this cases, to search by chemical name, press
P3=SELECT, cursor to Substance Name and type beryllium
. For hard to spell chemicals, use the thesaurus, i.e.,
type ber? .
2. Press F5=SETS, cursor to Export a Set , type set number
, choose DBASE .
3. Sort the records if desired by moving to a field name and
pressing . Choose the output format, using User
Selected Output when possible to select only the fields you
want to capture to save disk space. NOTE: If you are
downloading fields with multiple occurrences (e.g., SIC),
you must use the Form Designer. Name your set.
4. Name the file (fileriame.dbf) and path for the diskette and
.
Answer: 101 records downloaded.
How many pounds of the chemical benzene were released into the
environment in the U.S. in 1992 by petroleum refineries? What is
the average air release per facility reporting air releases for
that year?
1. Sea.rch for all facilities reporting benzene releases by entering
F3, Substance Name, , benzene, .
2. Narrow the search to only 1992 releases using F5, Change Search
Set, , number for last set created, , F3, Reporting
Year, , 1992, . Narrow search to petroleum
refineries, identified by SIC Code 2911 .
3. Export search set as described in the example above, using
dBase as the file format, default order, and User Selected
Output. Use F7 key to mark, the SAIR (Sum Air Release) and SENV
(Sum Environmental Releasse fields) . Toggle the F9 key to
tinmark fields downloaded in last exercise. Enter the file name and
path .
4. Press Flo to exit to main menu.
5. Choose Calculate Releases (KASTAT) .
CD-ROM User's Manual
APPENDIX G-3
-------
6. Type name of file created in step 1. . There is one
screen for each of,the fields created. Use right.and left arrow
keys to move between them.
Answer: The total release of Benzene by petroleum refineries for
1992 was 6,212/011. The average air release of benzene for 1992
was 33,397.90 Ibs. (See below.)
EXPLANATION OF KASTAT RECORD
1. Field number refers to which field the calculation was
performed .on. Field number: 1 is Sum Air Release (SAIR).
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 186.
3. Number of Blanks refers to the number of records wh'ich had a
blank or no data in that field. Zero records had blanks in
the Sum Air Release field.
4. The Lowest single release of benzene to the air was five
pounds. The Highest single release of benzene to the air was
499,000 pounds.
5. The Range is the difference between the Highest and the Lowest
single release. In this instance, the Range equals 498,995 Ibs.,
which is 499,000 Ibs. (Highest) minus 5 Ibs. (Lowest). .
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 benzene to the air by petroleum
refineries in 1992 was 6,212,011 Ibs.
7. The MEAN WITH and W/O 0 is the average of the field on which
the calculation is being processed.
CD-ROM User's Manual
APPENDIX G-4
-------
APPENDIX H
-------
-------
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 Toxic 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 have been designated as
toxic to date. New chemicals can be designated as toxic through rulemaking and petitions.
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 planning to add more chemicals and 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 H - 1
-------
INSTALLATION OF CD-ROM SOFTWARE: Follow instructions for installing CD-ROM
as outlined in User Manual and in the Brief User Guide that accompanied the disc. These
instructions explain how to set up a separate DOS directory for each disc, and type e:install
(when e is the CD-ROM drive). Do not follow the installation instructions on the card inserted
in the CD-ROM case as they are incorrect.
DATA BASE STRUCTURE: The 1987-1992 TRI CD-ROM set, comprised of two discs,
supersedes all earlier editions of the CD-ROM. The TRI data base is divided into two files,
which appear on separate discs. - .
Disc 1 contains the TRI RELEASES file. This, 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).
Disc 2 contains the TRI TREATMENT file. The TREATMNT 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 eight numeric
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 four files that provide documentation for the database
and other information: ,
README.EPA contains descriptions of all the data fields including codes and translation
of coded information. '
README.RGS contains the names, addresses and phone numbers of the 10 Federal EPA
regional contacts.
README.SIC contains the four-digit Standard Industrial Classification codes for 20-39 and
the code descriptions.
README.STA contains the names, addresses and phone numbers of the State and Territorial
TRI contacts.
CD-ROM User's Manual
APPENDIX H - 2
-------
QUICK START INSTRUCTIONS FOR
SEARCHING TRI
Insert Disc 1. Use the main menu to choose TRI Data Base from the Data Base Selection
Menu. When screen lists Releases data base, press < enter > twice.
SAMPLE SEARCH (Releases File)
EXAMPLE: Find all releases in New Jersey for 1987-1992.
1. Press F3=SELECT ' ' '. - . ,
2. Use arrow keys to go to Facility State < enter >
3. Enter search term NJ < enter >
Set # Found
1 13205 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 1992.
1. Search for NJ as the Facility State. Press F3, highlight Facility State, press , type NJ, press.
< enter>. 99,999 records retrieved.
CD-ROM User's Manual
APPENDIX- H - 3
-------
2. Search for 1992 as the Reporting Year. Press F3, highlight Reporting Year, press < enter >, highlight
1992, press < enter >. 9999999 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). 99,000
records retrieved.
EXAMPLE 2: Retrieve all releases for NJ for 1992.
1. Search for NJ as the Facility State. Press F3, highlight Facility State, press < enter >, type NJ, press
. 99,999 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 1992 as the Reporting Year. Press F3, highlight Reporting Year, press < enter >, highlight
1992, press . System searches only the 99,999 records from step 1. 9,000 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 GMC 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?
SCREEN , F4=SEARCH
FACILITY NAME (PHRASE)
I GM .
GM-BOC
t GM-DELCO
GMB
GMBH ' ,.
1 GMC
GMC-AC
(7 of 14)
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( ) key. Use the arrow key to move down to last occurrence and
mark it with the F8( ) key. To select a single name, use the F9( )key.
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 H - 4
-------
QUICK START INSTRUCTIONS FOR
DISPLAYING AND SORTING
TRI DATA
DISPLAY A SET
You can display the current output set by pressing F6=DISPLAY. You can display any set by
pressing F5SETS 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 specify 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 sorted by)
5. Use arrow keys to go to. Substance Name < enter >
6. Type 2 < enter > (This is the second field you want sorted by)~ .
7. Use arrows to return to top of list to End Rank Selection < 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 H - 5
-------
QUICK START INSTRUCTIONS FOR
fEXPORTINCi FROM
You may export a set in comma delimited (ASCII), fixed field, DBASE, Lotus or print to
disk format.
EXAMPLE: Export set #4 which contains releases in MD in 1992.
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) MD92 < enter >.
CD-ROM User's Manual
APPENDIX H - 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
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 < enter > when ready.
CD-ROM User's Manual
APPENDIX H - 7
-------
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 1990.
1. Follow search and combine instructions to retrieve a set for records which have MD only as the facility state,
1992 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 Release
Field 2-Sum Water Release
Field 3-Sum Land Release
Field 4-Sum Environmental Release
Field 5-Sum Transfer to POTWs
Field 6-Sum Transfer to Offsite
Field 7-Sum Transfer to POTWs and Offsite
Field 8-Sum Releases and Transfers
Name file-type MD92TOL< enter >
3. Exit to main menu (F10)
4. Choose KASTAT by using arrow keys to highlight KASTAT < enter >
5. Type file name MD92TOL< 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 36.
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 3 pounds.
The Highest single release of Toluene to the air was 1,630,700 pounds.
5. The Range is the difference between the Highest and the Lowest single release. In this instance Highest minus
Lowest (1,630,700 - 3 = 1,630,697).
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 1990 to the air was 2,215,315 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 1990 by each facility was 61,536.52 Ibs.
CD-ROM User's Manual
APPENDIX H - 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 to 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 Quick User 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 precisely the Quick User Guide provided with the CD-RQM. WHEN "MISSING DATA
RULE" IS fflGHLIGHTED, YOU MUST TYPE L OR SELECT THE "L LABEL..." OPTION.
CD-ROM User's Manual
.APPENDIX H - 9
-------
-------
INDEX
Symbols
W key
for marking terms, 3-19, 4-9, 4-15
for scrolling records, 2-13, 4-9, 4-15,
. 4-22
[t]key
for marking terms, 3-19, 4-9, 4-15
for scrolling records, 2-13, 4-22
symbol, 3-19, 4-9, 4-15
* symbols, 2-13, 4-21
B
bibliography, 1-16
boolean searching,
fact sheets, 3-7, 3-15
TRI, 4-17
brief record, 4-23, 4-25
broadening a search,
see OR operators, 3-15, 4-7
buffers, 2-10 ,
business, use of TRI for, 1-5
.anl,
see KASTAT, 5-2
ASCII downloading,
see comma-delimited, 4-19, 4-25+
see Export a Set, 3-17
abbreviations for searching
states, D-l
action menu
fact sheets, 3-22+
TRI, 4-23
add user input, 4-24
adding release totals, 5-1
adjacency searching,
see proximity, 4-14
Agency for Toxic Substances and Disease
Registry, 1-10
Alt key, 2-13
'and' operator, see Combine Sets, 3-15,
4-17 .'-
arrow keys, 2-13, 3-19
assistance,
see TRI User Support, 1-14, A-l
ATSDR, 1-10
autoexec.bat file, 2-3, 2-5
averages, calculating 5-1
.CSV,
see comma-delimited, 4-26
CD-ROM, features of TRI on, 1-11
CD-ROM Extensions, 2-1, 2-2+
CAS number, 3-9, C-l, E-2
calculation feature,
see KASTAT, 2-11,5-1
change record, 2-13, 4-21
changing output set, 4-21
changing search sets, 3-14
check mark, 3-19
chemical abstract number, 3-9, C-ll,
see CASRN, E-2
chemical compounds, C-ll
chemical substance fact sheets, 2-10, 3-1:24
chemical name, searching fact sheets,
see common name, 3-7
chemicals listed in TRI, C-l
citizen use of TRI, 1-4:5
Clean Air Act, 1-7
Ctrl key, 2-13
combining data sets, 3-15, 4-18
comma-delimited, 4-19
see downloading, 4-25 +
CD-ROM User's Manual
INDEX - 1
-------
common name, 3-7+
config.sys file, 2-3
configuration, 2-1
contents of TRI, 1-3
contents of disc, 2-10
controlling display speed, 4-21
creating custom reports
see Forms Designer, 4-27
custom reports,
see Form Designer, 4-27
D
.dbf format, 4-26
and calculating releases, 5-1
DOS, exit to, 3-18, 4-4
Data Base Selection Menu, 3-1, 4-1
data fields
descriptions, E-1 +
choosing to search, 4-iO
dbase format,
see downloading formats, 4-26
default order, 4-22
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-18
all sets, 3-16, 4-18
descending sort, 4-23
designing reports,
see Forms Designer, 4-27
device drivers, 2-2
diskettes, 1-12
Display (F6), 3-18, .4-2, 4-9, 4-20
display format change,
see Action Menu, 4-25
displaying sets,
previous search, 3-17, 3-18
current search, 3-18
selecting format, 4-23
downloading
data, 4-25
repeating fields,
see Forms Designer, 4-27
E
EPA Submission Number, 4-6
EPCRA, 1-2
EPCRA Hotline, 1-15, A-l
ESC key, 3-20, 4-10
education, 1-6, 1-10
electronic bulletin board, 1-14
Emergency Planning and Community Right-
to-Know Act, 1-2
entire data base, searching, 4-20
see global index, 3-12
equipment, 2-1
error messages, 2-6
escape key, 2-13, 3-20, 4-10
excluding records
see combine sets NOT operator, 3-15,
4-18+
exit
temporary to DOS, 3-18, 4-4, 4-20
expanded memory, 2-9
expanding a search
see OR operator, 3-15
expansion of TRI, 1-4
export
data file formats, 4-26
forms, 4-27
export from Table of Contents, 3-17
export selected fields,
see user selected output, 4-27
exporting sets, 3-17, 4-19
extended memory, 2-9
Extensions, 2-2
CD-ROM User's Manual
INDEX - 2
-------
F
.fff, ..
see fixed field, 4-26
facility name, searching by, 4-14
factstieets,
see Chemical Substance Fact Sheets, 3-1 +
features of CD-ROM, 1-11
Federal agencies, 1-7
field descriptions, 4-3, C-l
file structure, 2-10:11
files, in config.sys, 2-10
fixed field,
see downloading formats, 4-26
form for TRI reporting, B-l
Form R, B-l . ;
formats for TRI products, 1-11 +
Forrns Designer, 4-27
full record format,
see RELEASES, 4-23, 4-25
function keys, 3-2, 4-7
TRI, 4-24
hotline, 1-5, A-l
ISO 9660, 2-2
indexing data, 4-13
information sources, 1-9
installation, 2.1, 2-4
see quick start, 2-4
installation assistance
see TRI-US, 1-14, A-l
Internet, 1-13
jump to record, 4-24
G .
GPQ, 1-11
global index, 3-12
gopher, 1-13
Government Printing Office, 1-11
grouping keys, 3-19, 4-9, 4-15
KADFDES command,
see Form Designer, 4-27
KASTAT, 2-11, 5-1:5
Kastatfld, 5-2
Kastattxt, 5-2
H
health, 1-8
help,
see TRI User Support, 1-14, A-l
help function, 3-3, 4-8
high memory, 2-9
High Sierra, 2-2
Home/End key, 2-13
hot keys on action menu
fact sheets, 3-23
.LANS, 2-2 ;
labor, 1-6
legislation, 1-2
LEPC, 1-7, 1-10
library, 1-9
limitations of data, 1-4
list of chemicals, C-l
list of SIC codes, F-l .
loading set lists,-3-17, 3-24, 4-19
local agencies, 1-7, 1-9
CD-ROM User's Manual
INDEX 3
-------
local area networks, 2-2
Local Emergency Planning Committee, 1-7,
1-10
Lotus format,
see downloading, 4-26
M
MS-DOS
temporary exit to, 3-18, 4-20
magnetic tape, 1-13
manual organization, 1-1
marking keys,
see group, 3-19
mean, calculating 5-4
media, 1-8
memory requirements, 2-1, 2-8:9
metals,
see compounds, C-ll
microfiche, 1-14
missing data rule, 4-32
mode, calculating, 5-4
mscdex.exe, 2-2+
N
NLM, 1-2
NTIS, 1-11
narrowing a search
see change search sets, 3-14
see combine sets, 3-15
National Library of Medicine, 1-12
National Safety Council, 1-15
National Technical Information Service,
1-11
new display form, 4-24
see Form Designer, 4-27
new path, 4-4
'not' operator, 3-15, 4-18
O
online systems, 1-12
Options (F2), 3-4, 4-9
options for settings, 3-4, 4-9
'or' operator
see combine sets, 3-15, 4-17
Options menu, 3-4
output set, 4-21
.P2D,
see print-to-disk, 4-26
PPAof 1990, 1-4
partial record
see RELEASES (BRIEF), 4-23, 4-25
partial term, 3-7+, 3-13
path,
see new path, 4-4
performing calculations, 5-1
PgUp/PgDn key, 2-13
pollution prevention, 1-4
practice searches, G-l
previous screen,
see ESC, 3-20, 4-10
print current record, 4-24
print from Table of Contents, 3-18
print to disk format, 4-26
printing,
see action menu, 3-22+
printing fact sheets, 3-17
printing formats, 4-25
printing sets, 3-17, 4-19, 4-25
proximity searching
public health agencies, 1-9
public interest groups, 1-6
pull-down menus, 3-2
CD-ROM User's Manual
INDEX - 4
-------
question mark, 3-7+, 3-13
quick start installation, 2-4
R
ranking data,
see action menu, 4-24
readme, epa, 2-11
readme files, 2-11
readme.rgs, 2-11
readme, sic, 2-11
readme.sta., 2-11
reference materials, 1-16
refine search, 4-16
regional EPA offices, 1-10
see readme.rgs, 2-11
releases file, 2-11, 4-1, 4-3 '
reporting form, B-l
reporting requirements, 1-3 +
reporting year, searching by 4-11
reports, 1-13, 4-27
reports, creating custom
see Forms Designer, 4-27
risk, 1-8 . .
risk communication hotline, 1-16
risk screening, 1-8
.SSL, 3-24
SARA, 1-2
SERC, 1-6
SIC codes, F-l
SIC, downloading, 4-27, 4-33
saving search results, 3-23, 4-19
save set list, 3-18, 3-23, 4-20
saving new forms, 4-34
saving settings, 4-9
schools,
see educators, 1-6
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-9+
select display set, 3-18
setting up workstation, 2-1
sets
fact sheets, 3-14
shell, 4-4, 4-20
skip to next record
TRI, 4-21
software installation, 2-2+
sorting, 4-22
see ranking of data, 4-24
source reduction, 1-4
sources of information, 1-9
speeding up display, 4-21
spreadsheet format, 4-26
Standard Industrial Classification Codes, F-l
state agencies, 1-7
state abbreviations, D-l
State Emergency Response Commission, 1-6
summing data, 5-1
Superfund Amendments and Reauthorization
Act, 1-2
Table of Contents, 3-6
TOXNET, 1-12
TRI reporting form, B-l
TRI-US, 1-14, A-l
TSRs, 2-9
temporary exit to DOS, 3-18, 4-20
territory abbreviations, D-l
text searching
Title IE, 1-2
thesaurus,
see indexing 4-13
treatment file, 2-11, 4-1, 4-3
CD-ROM User's Manual
INDEX - 5
-------
truncating search terms, 3-8, 4-13, 4-15
troubleshooting software installation, 2-6
u
user selected output, 4-25
user assistance, 1-14, A-l
user support, 1-14, A-l
w
.wks format
see downloading formats, 4-26
workspace remaining, 4-1
ISBN 0-16-045502-2
CD-ROM User's Manual
INDEX - 6
9 "780160 "455025"
------- |