V
storet
EPA's
Computerized
Water Quality
Data Base
the right
answer
U. S. Environmental Protection Agency
Office of Water and Hazardous Materials
Washington, D. C.

-------
storet
provides
water
quality data
           on the
             right
   parameters
Some 1800 unique water quality parameters are defined within storet. Ap-
proximately 80% of the 40 million individual observations available
within the system pertain to approximately 200 of these pa-
rameters which are grouped into the general cate-
gories shown in the table to the right. A single
observation represents a measurement
of a single parameter at a spe-
cific location, or station.
at a specific point
in time.
                                                         PARAMETER GROUPS
            at the
              right
         stations
storet contains data on samples taken from
more than 200.000 unique collection points
located on essentially all of the Nation's rivers.
lakes, streams, and other waterways. The shadings
of the map reflect the relative concentrations of
sampling and monitoring stations. The blow-up
of the Saginaw River Basin shows its drainage
area and the specific locations of sampling points.

-------
                           A river basin is the area drained by a single river
                           and its tributaries. A water quality management
                           basin plan is a management document that iden-
                           tifies the water quality problems of a particular
                           basin,  or portion of a basin, and sets forth an
                           effective remedial program to alleviate those
                           problems. Overall basin needs and  priorities are
                           assessed, actions scheduled, and the necessary
                           coordination with concerned organizations
                           planned.
        basin
planning
The needs and priorities are based largely upon
water quality data and the analysis of this data.
For example, fecal coliform bacteria is a common
indicator of pollution problems in areas affected
by major municipal/industrial activity. A plot of
coliform along a stretch of a river can quickly
ascertain the presence of a bacterial source and
the extent of a pollution problem.
The development of an effective planning proc-
ess is crucial to effective water quality manage-
ment. This is particularly true for river basin
planning as required under various sections of
PL 92-500. River basin plans are primarily the
responsibility of the states, and the law delineates
the rather extensive amount of information that
must be provided.
                                                                                         n,
research
In order to achieve our national objective of
having water that is clean enough both for recre-
ational activity and for the protection of fish and
wildlife, numerous research and development
efforts have been initiated to acquire a thorough
understanding of the complex and variable bio
logical systems that characterize our waterways.
Research tells us what a specific level of a specific
pollutant does to humans, animals, and crops.  It
establishes thresholds at which we might expect
adverse effects from environmental pollutants,
alone or in combination. (And from  these
thresholds, criteria for water quality standards can
be established.) It provides the basic scientific
knowledge we need to safeguard the public health
and to balance the benefits of a specific product
against its environmental  risks.

A representative effort is that of the EPA Grosse
He Laboratory's Research Program to improve  the
water quality of the Great Lakes. This Lab is in-
volved with a number of other agencies in devel-
oping the scientific information needed to assess
the effectiveness of implemented programs on
Great Lakes water quality, to form the basis for
needed control actions, and to develop the scien-
tific information needed to support the Canadian/
U. S. Agreement for the Great Lakes. Over a
dozen U. S. and Canadian agencies, universities,
and joint commissions are participating in this
extensive program launched in 1972.

Since this is an on-going, international program
involving both water quality management and
research, it is essential that all data gathered on the
water quality of the Great Lakes be readily accessi-
ble by all investigators. Accordingly, all participants
are required to enter all collected data into store!
thereby greatly expediting the use and analysis of
the information through sharing of data. This sig-
nificant, multi-organizational research program not
only illustrates the value of storet in research-
oriented endeavors, but also it demonstrates how
the use of an accepted central system can foster
cooperation among a group of organizations
sharing common interests.
                                                CHLOROPHYLL  A  IN LAKE ONTARIO
                                                           TWO PERSPECTIVE VIEWS

-------
        monitoring
& surveillance
The data in storet originates from samples taken
as part of individual monitoring programs con*
ducted by the states and other organizations.
Several objectives of these monitoring efforts are
to identify and assess quantitatively the magnitude
of existing and potential water pollution problems.
and to detect any trends or changes over a period
of time. Reports such as the trend plots shown
here, which show presence of phosphates and
ammonia as a function of time, vividly point out
where problems do and do not exist.
                                                        PHOSPHATES  PLOT
                                                                                                        AMMONIA  PLOT
                   npdes
                 permit
             program
Far-reaching goals were established by PL 92-500:
By 1983, water clean enough for swimming.
boating, and protection of fish, shellfish, and wild-
life; and by 1985, no discharges whatsoever of
pollutants into the Nation's waters! To achieve
these ambitious but essential goals, the law estab-
lished a national permit program, known as
NPDES-the National Pollutant Discharge Elim-
ination System, to control the discharge of pol-
lutants into any waterway. This program is the
mechanism for insuring that effluent limits are
met, that the necessary technology is applied, and
that all requirements of the 1972 law for con-
trolling discharges and complying with water
quality standards are met on schedule. Permits
are to be granted to individual dischargers only
after they show that their effluents will not con-
taminate a waterway in excess of established water
quality standards, or will not lower its existing
quality.
The law allows polluters time to improve facil-
ities, but provides that corrective programs must
meet the "best practicable" and "best available"
standards of water pollution control technology
by 1977 and 1983 respectively.
                                                                                     sss~-;

                                                                                     ITU":
                                                                                     •Si. *i E LT

                                                                                          EFFLUENT VIOLATIONS REPORT

-------
   progress
  reporting
Under Section 305(b) of PL 92-500. states are
required to submit annual reports to EPA on
sources of pollution —their nature, extent, recom-
mendations for control, and the cost of these
controls. (An excerpt from the State of Michigan's
305(b) report is shown below.) As practices be-
come more sophisticated, these reports should
reflect the effects of these sources on the pollu-
tion of groundwaters, and provide  an inventory of
wells which can be used to determine ground-
water quality within a state's jurisdiction.
A new activated sewage treatment plant was built
on Fountain Creek below Colorado Springs in
late 1972. The data in storet collected prior and
subsequent to the implementation of the new
plant were compared. The number of violations
for dissolved oxygen had dropped from 53% to
7%, for dissolved solids from 59% to 33%. for
BOD from 85% to 73%, and for fecal coliform
from 89% to 58%. Similar improvement occurred
and was demonstrated when a sewage treatment
plant was built in the  Fargo, North Dakota area.

These examples show the applicability of using
the data in storet to demonstrate progress either
from an over all point of view or from the view-
point of a single effort.
                                                                                70,

                                                                                £0.
                                                                             E  20.
                                                                                         iAKIN urns  nr
                                                                                   THE LINE Of SESr FIT SW7KS InPRtWING *AT&?
                                                                                   OVER rtnE -- AS nEASURSO Sr THE VAT£K QUft. ITr
                                                                                          TIKE OF OBSERVATION
standards
 &  criteria
Associated with specific water uses are the water
quality standards which must be met in order for
the water to be used for its intended purposes.
consistent with the 1983 goals of water quality.
Once standards have been established by states
in accordance with national criteria, it is necessary
to monitor the effect of water pollution abatement
and control activities relative to those criteria. A
number of storet report programs can be used,
such as the ones pictured  below, to track the
progress of water quality improvement efforts.
                                                                            VIOLATIONS WITH
                                                                            SUPPORTING PARAMETERS
                                                                                              VIOLATIONS LIST

-------
             toxic
substances
Although many substances are potentially toxic to
aquatic life and other organisms when present in
sufficient concentration for a sufficient period of
time, the term toxic substances generally refers to
those substances which are dangerous even in
very low concentration. Consequently, the 1977
and 1983 deadlines for limiting pollutant dis-
charges do not apply in the cases of these deadly
substances, such as mercury, cadmium, and
toxaphene. Steps required to meet standards
established for toxic substances must be taken
quickly to protect the public health and welfare.
To this end, EPA is empowered to restrain dis-
charges of any pollutants which present an im-
minent and substantial endangerment to the
health or livelihood of the public.
                                                                               All toxic substances for which water quality anal-
                                                                               yses have been performed are defined within
                                                                               storet, and the system can easily accommodate
                                                                               the inclusion of additional substances upon their
                                                                               discovery. Reports such as the one shown below
                                                                               (from a Council on Environmental Quality report)
                                                                               can be readily obtained from storet data to dem-
                                                                               onstrate the presence or absence of toxic sub
                                                                               stances in any body of water for which data
                                                                               are available.
                                                                           __j____™____^_^


                                                                            DDT LEVELS IN U.S.
                                                                        SURFACE
                                                                                    WATERS, 1970-74
in  summary,
        the  right
            answer
                              These pages have shown a number of uses made
                              of storet. and its wealth of water quality data, by
                              a variety of governmental agencies and other
                              organizations. To further underscore the role that
                              storet can play to help you fulfill your water
                              quality assessment and management objectives,
                              consider the following additional answers that
                              storet can provide.
                                              — Help evaluate cost-effectiveness of previous-
                                                ly implemented water quality programs

                                              — Help promote water quality programs by
                                                substantiating the effectiveness of other
                                                similar programs


                                              — Help justify budget requests for water
                                                quality programs

                                              — Help cut sampling costs by coordinating
                                                efforts with other organizations


                                              — Provide a repository for your data collec-
                                                tion efforts

                                              — Help identify where monitoring efforts are
                                                needed, thereby determining where funds
                                                need to be allocated


                                              — Help design overall programs based upon
                                                the successes of others

                                              — Help complete water quality management
                                                basin plans


                                              — Help prepare fact sheets required by
                                                permit applications

                                              — Detect changes in pollutants that could
                                                change existing permits
                                                                           How can storet help you?

-------
                                                                                       16618
      collected
      and used
by the  right
          people
— State Agencies
— Cities and Counties
— Interstate Commissions
— Water Quality Managers
— Environmental Planners
— Sanitary Engineers
- EPA Regional Offices
— EPA Laboratories
— Federal Agencies
— Canadian Agencies
- U. S. Territories
These individuals and organizations actively
participate in the collection, storage, retrieval, and
analysis of water quality data. All utilize storet
for these efforts, contributing to the quality and
quantity of the parameter observations described
on the opposite page. Several Federal agencies—
including the U. S. Forest Service, the U. S. Army
Corps of Engineers, the Bureau of Reclamation,
the U. S. Geological Survey, and the Tennessee
Valley Authority—complement the efforts of those
having specific geographical interests. Over 40
states, as well as many other organizations, have
direct access to storet for both storage and
retrieval, thereby contributing significantly to the
timeliness of storet's data.
                and
    presented
 in  the right
        formats
 and  storet
      can  help
                you
The array of representative reports pictured here
exemplifies the versatility of storet and its water
quality data to help users prepare a myriad of
detailed, summary, or exception reports relative
to their specific areas or locations of interest. Data
reported can reflect the latest, most current infor-
mation available, or it can draw upon the histori-
cal depth of the data, going back as far as the
late '50s. Most users obtain their reports from
small portable computer terminals conveniently
located in or near their offices.
These two pages have presented an overview of
the data available within storet. .The inside
pages describe several examples of how various
users today utilize storet to achieve a variety
of objectives relating to water quality assessment
and management.

-------
                  epa
The Environmental Protection Agency was
created in 1970 to foster an integrated, coordi-
nated attack on environmental pollution in
cooperation with state and local governments. EPA
endeavors to abate and control pollution system-
atically by proper integration of a variety of .
research, monitoring, standard setting, and en-
forcement activities. Through Public Law 92-500,
EPA has the overall responsibility to provide water
that is clean enough both for recreational activity
and for the protection of fish and wildlife. In-
herent in this charter is the requirement of main-
taining an information inventory concerning the
quality of the Nation's waters.
           storet
storet is a computerized data base utility main-
tained by EPA for the storage and retrieval of
parametric data relating to the quality of the
waterways of the United States. The system was
conceived and initiated under the auspices and
administration of the Public Health Service in the
early 1960s. Since its early days when storet
input and output was achieved via the mails, the
system has evolved into a comprehensive  infor-
mation data base, accessible by hundreds of users
via computer terminals located throughout
the country.
      storet—»
      the  right
          answer
This publication was prepared to provide an over-
view of the content and capabilities of the storet
system, and to describe a number of uses made
of this information by those organizations con-
cerned and involved with the abatement and
control of water pollution within the United States.
       for  more
information
For further information on how storet can help
you fulfill your needs with respect to the collec-
tion, reporting, and analysis of water quality data,
contact your local storet representative, storet
User Assistance in Washington, D.C. (202-
426-7792) can give you names and phone
numbers.

-------
                 UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
                                       '  ' •  '  •" ' .-' P A
                                          *-" •'  .""V  :A
SUBJECT: STORE! Brochure                ''°MM  CcMTER        DATE:  fin '.  •

        UOJ**  Sr^-f           °CT/8  Wi3*T7S
        Mark A. Pisjfrijp, Director
      0 Water Planrtttfe Division

TO:     All Regional Water Division Directors
        All Regional 208 Coordinators


                                         Technical Gudiance Memorandum:  Tech-. 19
        Purpose:

             The enclosed brochure outlines  some of the capabilities of EPA's
        computerized data base utility, STORE!.  The system is maintained for
        the storage, retrieval, and analysis of parametric data relating to
        the quality of the waterways of the  United States.
        Guidance:

             This brochure suggests various options  available through the
        STORET  system of obtaining and analyzing parametric water quality
        data.   The brochure is intended to highlight the system's
        capabilities, and should not be considered as an instructional tool.
        Should  you wish more information about the system, desire user
        documentation, or need to attend a seminar for instructional use,
        please  call STORET User Assistance or the appropriate EPA regional
        STORET  representative from the attached list of STORET contacts.
         Enclosure


         cc:   State and Areawide Agencies
 EPA Form 1320-6 (Rev. 6-72)

-------
           STORE! Points of Contact

              Telephone Numbers
Region I      Walt Newman
              Systems Analysis Branch
              8-223-5134
              617-223-5134

Region II     Herbert Barrack, Director
              Management Division
              8-264-2520
              212-264-2520

Region III    Larry Miller, Chief
              Water Quality Monitoring Office
              Surveillance & Analysis Division
              8-597-9823
              215-597-9823

Region IV     John Marlar, Chief
              Technical Support Branch
              8-285-3012
              404-526-3012

Region V      Christopher Timm, Director
              Surveillance & Analysis Division
              8-353-2300
              312-353-2300

Region VI     David White, Chief
              Technical & Administration Systems Branch
              8-749-3761
              214-749-3761

Region VII    Walter Robohn, Federal Regional
              Council Representative
              8-758-5429
              816-374-5429
Region VIII
Keith Schwab, Director
Surveillance & Analysis Division
8-327-4935
303-837-4935
Region IX     Clyde Eller, Director
              Surveillance & Analysis Division
              8-556-7858
              415-556-7858

Region X      Dr. Gary O'Neal, Director
              Surveillance & Analysis Division
              8-399-1295
              206-442-1295

-------
                User Assistance
Region I
Region II
Region III
Region IV
Region V
Walt Newman
8-223-5134
617-223-5134

Jack Sweeney
8-264-9850
212-264-0388

Ted Standlsh
8-597-8046
215-597-8046

Dan Barber
8-285-5989
404-526-5989

Stu Ross
8-353-2061
312-353-2061
Region VI
Region VII
Region VIII
Region IX'
Region X
David White
8-749-3761
214-749-3761

Dennis Degner
8-758-2018
816-374-2018

Tom Entzminger
8-327-2226
303-837-2226

William Lewis
8-556-7550
415-556-7550

Ray Peterson
8-399-1580
206-442-1580

-------