WATER QUALITY ANALYSIS SYSTEM SEMINAR DOCUMENTATION


WATER QUALITY ANALYSIS SYSTEM
SEMINAR DOCUMENTATION
Prepared for
EPA Region III
Philadelphia, PA
August 29, 1991
Presented by:
Phillip L. Taylor
Tetra Tech, Inc.
10306 Eaton Place, Suite 340
Fairfax, Va 22030
(703) 385-6000

-------
Water Quality Analysis System
August 29, 1991
EPA Region III
8:30 9:15	Introduction
•	OWOW/AWPD DATA FILES
•	Conversational Access software
•	EPA NCC mainframe computer
•	Access
•	Workstations
9:15 - 10:00
Water Quality Analysis Interactive Procedures-Part I
•	PARM
•	CITY
•	SIC
•	ICAT

ISR
PATHSCAN
IFDRET
IFDPLOT

RCHDAT
DAMR
FLOW
DFLOW
10:00- 10:15 Break
10:15 - 10:30	Water Quality Analysis Interactive Procedures-Part II
Stream site analysis for stream reaches, USGS stream gages, drinking
water supplies, NPDES facilities, water qualtiy monitoring, cities, soild
waste disposal sites, wells and fish kills.
10:30 - llTOO	Reach File and Hydrologic Retrieval
•	Reach File - RF1, RF2, and RF3
•	STORET reach retrievals
•	ISR
•	PATHSCAN

-------
11:00 - 12:00	Environmental Display Manager (EDM)
•	EDDM
•	MDDM
•	RF3 MDDM
•	AFP
12:00-1:15	Lunch
1:15 - 2:00	PCS/STORET INTERFACE
•	Browse
•	STORET-
•	Interactive PCS-STORET (IPS5)
2:00-2:15	Break
2:15 - 3:00	Mainframe
•	Reach Pollutant Assessment (RPA3)
•	GIS - RF3/ARCINFO
•	Interactive Chart Utility (MF)
•	UN1RAS (MF)
•	Clean Lakes
•	Other Topics
3:00 - 4:00
General Discussion and Regional Office Summary & Comments

-------
WQAS Quick Reference Guide
The Water Quality Analysis System (WQAS) is a family of conversational procedures thai creates reports and
graphics from environmental data maintained by EPA on its IBM mainframe computer located at Research Triangle
Park, North Carolina. Through the use of keywords and menus, the procedures provide quick response to specific
inquires. For example, the software could be used to determine the nearest drinking water supply downstream from
a waste discharger, to map water quality, dischargers and toxics along a specified stream, or to calculate the dilution
factor for a specific receiving stream.
Anyone with access to the EPA NCC-IBM mainframe computer, a valid USERID, and is a registered STORET user
(call STORET User Assistance at 800-424-9067 for information) can use the WQAS procedures.
The following is a description of the WQAS procedures available as of July 1,1991. Users are encouraged to contact
Tom Pandolfi of EPA/OWOW, Assessment and Watershed Protection Division (AWPD) at (202) 382-7030 to obtain
additional information and user's guides for the following procedures. All procedures can be executed at the TSO
"READY" prompt by issuing the command WQAB . Suffixes are listed below:
Procedures/Suffix
Description
ASIWPCA
BROWSE
CJTY
CSRCH
DAMR
DFLQW
HELP
FLOW
fFDPLOT
Furnishes information on the extent of stream use impairment due to point sources and
nonpoint sources reported for 1972, 1982, and 1985.
Provides easy retrieval of data from the Permit Compliance System (PCS-Office of
Wastewater, Enforcement and Compliance) and STORET water quality monitoring station
data. Data from an individual station of interest can be retrieved by specifying the STORET
agency and station codes or NPDES facility number (users must have PCS privileges in
order to access PCS data from this procedure). This procedure is used without the WQAB
command.
Allows acquisition of information from the City Master File. Given a city name, the
procedures provides latitude, longitude, stream names, reach numbers, census population, and
FIPS State-County numbers.
Allows the acquisition of criteria and standards data collected by the Regions and States
during the NEEDS survey given an NPDES number or reach number (these data should be
considered provisional until reviewed and checked by the appropriate Regional or State
personnel).
Provides information from the Corps of Engineers Inventory of 68,000 dams and
impoundments. Inquiries can be by state, cataloging unit or dam identification code.
Allows batch retrieval of flow data from STORET, and performs calculations using the
retrieved data. This procedure calculates a biologically-based receiving water design flow
based on a method developed by EPA in determining water quality-based pollution controls.
Provides a list of current WQAS procedures with a brief description for each procedure.
Provides daily flows or statistics to determine the mean flow and 7Q10 low flow when the
user enters a gage number, state, and desired years. Option is available to provide a user
file that is convenient for downloading.
Provides the ability to map specified geographic areas and environmental data using
keywords and menus.

-------
Procedures/Suffix
Description
IFDRET
IPS6
iSR
PARM
PATHSCAN
RCHOAT
RCHRET
RPA3
SIC
SfTEHELP
STRAUX
Allows the user access to the Industrial Facilities Discharge (IFD) database for purposes of
generating standard format reports. Several retrieval and selection options are offered to
enable limited customization of the desired report.
Provides the ability to analyze, summarize, and report data from permitted facilities in PCS,
water quality stations in STORET, stream flows, downstream water supplies, bioassay
results, indirect discharges to POTWs and ASIWPCA results (users must have PCS
privileges in order to access PCS data from this procedure using the PCS/STORET
interface).
Provides a quick and easy capability for a variety of STORET retrievals, reports, analyses
and maps by supplying a stream reach number or a NPDES facility number. Option 6 is
a first-stage BOr> model that is a pan of STORET. This model uses discharge monitoring
(PCS DMR daL or validated users) and ambient water quality data from STORET to
predict DO con Tations downstream of dischargers and ambient data and the Gage File
for stream flow j velocities. The MSP STORET retrieval and analysis program is used
to input flow, isj, BOD, TSS, and temperature statistics into the model. NPDES facility
and ambient monitoring locations are selected by the Reach retrieval procedure.
Access to the STORET parameter file is provided by parameter number, CAS registry
number, or pollution groups and media. The batch option provides the capabilities to obtain
a complete list of the parameter file by parameter number, name, CAS number or group and
also a list for any group/sample media selection. Additional numbers of observations have
been added for each parameter.
Retrieves facility data, stream gages, stream flows and velocities, and drinking wa^
locations upstream or downstream from a specified location.
Provides stream flow and pipe discharge data for a user-specified NPDES number or stream
reach.
Creates a STORET graphical display of stream reaches from a user created external data file
containing reach numbers or basin codes.
Produces 13 different reports relating to the abundance and distribution of priority pollutants
(water column, sediment, fish tissue, NPDES permit limits, and Form 2Q. Reports are for
a requested cataloging unit or state.
Obtains SIC (Standard Industrial Classification) codes and descriptions used in the IFD fde.
The 1,000 codes and their descriptions are grouped in 11 major and 84 minor divisions and
can be obtained by use of a menu.
Accesses the IFD, Gage, Water Supply, City, Complex Effluent Toxicity Information System
(CETIS), FINDs, FISHKILLS, Reach Structure, Reach Trace, and STORET Water Quality
files. Inquiries can be made using a USGS gage number, water supply FRDS number,
NPDES number, Dunn and Bradstreet number, Needs Survey A/F number, city name, or
stream reach number. Various options Site Help provide reach data on locations of gages,
industrial and municipal discharges, -inking water intakes, surface- and ground-water
monitoring stations. On graphics terminals, the procedures display a reach trace with
locations of gages, dischargers, drinking water intakes, monitoring stations and cities.
Allows the user to make a STORET auxfile for mapping stream reaches by entering dis-
appropriate cataloging unit and reach number.

-------
Relationship of OWOW/AWPD Conversational Access Software
to OW Data Files
I
DATA FILE
FILE TYPE
WBS
EDDM
MDDM
SSdl
SITEHELP
PATHSCAN
RCHDAT
A1IO
DAMR
IFDPLOT
DFLOW
PARM
RPA
STORET
ODES
IFDRET
O
O
IHS Browse
Flow
ISR
STRAUX
SIC
RCHRET
* Drinking Water Suppll
'IHS

/

/
/
/



/



/
i !/ /i
'GAGE
IHS

/

/
/
/
/


/



/
i /:/ / /
* CITY
IHS

/
/
/
/


/





! i VV
*DAMS
IHS






I
/


!
/! i /; /
* Ind. Facility Dlsch.
IHS

/
/
/
/
/
/


/

!~
/i !/!/'/ / /
CETIS
IHS



/
/






i
i

! V!/i
ASIWPCA
IHS



/
/







/


~|/i :
/CAT
IHS






/





/

i
III v
ISS
IHS












/


! 1 i
304(1) Short Ust
0












/
I I ' ,
I ! .! I ' : • '
FARM
IHS

/

/







/
/
/! i/i/: ¦ ¦ ¦
'noes
SAS











! i /


ADA

/

/








/
/
i > 1 1
1 i 1 1 !
*RF1 Structure
IHS
/
/
/
/
/
/
/





/
/
|
/j/| / /i /
* RF1 Trace
IHS
/
/


/




/


/
/


/
/! :// /
RF2 Structure
IHS
/

/

/
/







/


/
/! i .
RF3 Structure
'SAI
«/

/














i . , ,
i
¦
RF3 Trace
'SAI
«/
/
/











!
i
1 ' '
i 1
'STORET - BIOS
IHS













/
[
I
1 ; /
'STORET - USGS Flow
0










/


/
i ;
I i
! v '
•STORET - Flshkill
s




/








/



i i , ' !
'STORET - WQ
s

/
/
/
/







/
/
/


i I/1/; :
'STORET - Tissue
s

/










/
~



| i : 1
'STORET - FORM2C -
s



/
/







/
/



i «
! 1
i i 1 : .
*STORET - GRAPHICS
IHS
/

/





/
/


/
/



1 ; /: /I , /
* WBS
IHS
/












/


/
, ; ¦ ¦ .
TRIS
ADA

/










/




! i I
1 !
FINDS
AOA




/












| : 1 ¦
¦
pSfflce of Water Environmental and Program Information Systems Compendium FY 1990
HlETYPE - IHS (In House Software), VSAM (Virtual Storage Access Method),
S (STORET), D (disc file), ADA (ADABASE), SAS (SAS)

-------
OWOW/AWPD Dam FUes
Drinking Water Supply File - The Drinking Water Supply File contains information on 8,000 water supplies that utilize surface waters. Da^HPers
FRDS number, utility name, city, state, basin, latitude and longitude, stream reach, population served, water volume used, and locations
for plant, intakes, and sources.
Gage - The Stream Gage Data File contains information on approximately 36,000 stream gaging locations throughout the United States. Information
stored includes location of gaging stations, stream reach identification, types of data collected, frequency of data collection, media in which
the data are stored, identification of the collecting agency, where available, mean annual flow and 7 day/10 year low flow.
City - This file contains data on 53,000 cities, towns, and villages located in the United Stales and its possessions. Information on each city includes
the city's unique identification code; the county, state, major and minor river basin, and congressional district within which it is
geographically located; stream reaches associated with the city; its latitude and longitude; and its census population data.
Dam - Inventory of 68,000 dams produced by U.S. Army Corps of Engineers which provides type, ownership, purpose, height, volume, surface area,
latitude-longitude, stream reach.
Industrial Facilities - The Industrial Facilities Discharge File contains information on 128,000 NPDES industrial and municipal facilities (active and
inactive) useful for environmental analyses. Data consists of NPDES, DUNS, and Needs A/F numbers with name, address, basin, latitude
and longitude, stream reach, flow, SIC codes, discharge type for facility and pipe level, and industrial category. Indirect discharges to
POTW systems are also included.
CETIS - The Complex Effluent and Toxicity Information System contains Bioassay results from NPDES discharge toxicity tests.
ASIWPCA • Streams reported in the Americas' Clean Water - STEP report by the Associations of State and Interstate Water Pollution Control
Administrators (ASIWPCA) covering water quality impairments for 1972, 1982, and 1984 and indexed to the version 1 reach file.
ICAT - Industrial categories used in effluent guidelines studies are grouped with standard industrial classification (SIC) indexes.
STORET PARM - Information on 13,000 STORET parameters indicating reporting units, media, CAS registry number, and chemical/biolog^^^^.
ODES - The Ocean Data Evaluation System is an extensive system of software for managing and analyzing marine environmental monitoring data.
PCS - The Permit Compliance System contains NPDES permit compliance, tracking and discharge monitoring reports for active permitted facilities.
Reach File - The River Reach File provides hydrologic connectivity between geographic locations and historical data created for the express purpose
of performing hydrologic routing for modeling programs. The Reach File, Version 1, contains 68,000 stream reaches covering 100% of
the continental U.S. and is indexed with STORET, IFD, drinking water supplies, stream gages, and fishkills. Version 3 covers 80% of the
U. S. and provides hydrologic linkages for 3.5 million reaches based on the USGS DLG data.
STORET-BIOS - A component of STORET containing distribution, abundance, physical condition, and habitat description of aquatic organisms.
These are integrated with the water quality file and linked to the reach file, PCS, IFD, and Gage files.
STORET-USGS Row - Contains daily stream observations of stream flow and miscellaneous water quality at USGS gaging stations. These data
represent more than 695,000 water years for over 29,000 gages.
STORET - WQ - The agency's water quality system containing physical, chemical, and biological parameters. More than 800 monitoring
organizations have provided 175 million parametric observations from 700,000 sampling locations for surface water, ground water, fish
tissue, and sediment. The sample locations are indexed to the reach file IFD, GAGE, and drinking water files with a PCS interface.
STORET - Tissue - Tissue sample results cover over 530 parameters including metals, organics, and pesticides specific to species, tissue type, length,
weight, and sex. These data and stations are integrated with the water quality file and indexed to the reach file with indexes to IFD, Gage,
drinking water files and the PCS interface.
STORET Form 2C - Priority pollutant data reported by NPDES second round permits are in STORET referenced by the permit number and can be
integrated with the water quality data and PCS data with the PCS/STORET interface.
WBS - The Water body System data base contains water quality assessment information collected by states for 305(b) reporting. These c^^^^e
as an inventory of each state's navigable waters that have been assessed.

-------
' -'^NATIOMAL JBWVlEOWiEirrAL^^^^SBfCE
WQAS Computer Technology
WQAS is to take full advantage of EPA's central computer and communications network,
but also to be both device and data independent. The central concept is to provide, easy access to
data thru any reasonable access method, and then to provide data, graphics, images, and documents
that can be tiansfcned to any number of output devices, software packages, or computer systems.
The design ties together the best workstation technology, the best graphics technology, and the best
pnnung technology.
Workstations
Personal Coapster The WQAS personal computer shows the potential for access to en-
vironmental data available to personal computers thru local area networks and 3270 emulation.
The WQAS personal computer shows software that runs on a local area network that can integrate
with both PC and host based programs. The system uses IBM's newest technology, but is also fully
compatible with EPA's plans for computer equipment and information access.
3270 Termiaal: The WQAS 3270 terminal demonstrates the information and graphics capabilities
that are available to all EPA system users using EPA supported graphics terminals.
Graphics
IBM's Graphics Display and Data Management System (GDDMV The future of WQAS is built
on IBM system level graphics. This means that WQAS is not constrained by the limitations ol
software from secondary vendors, and that the graphics and images from WQAS can be transported
across all levels of supported IBM technology.
UNIRAS Graphics The WQAS software uses the UNIRAS software on the EPA central computer
to create device independent graphics. The graphics created by UNIRAS can be exchanged between
the EPA computer and high performance standalone computers like those built by Sun Technol-
ogies and Tektronix, Inc.
Environmental Data Display Manager (EDDM) Mapping and Data Display Manager (MDDM).
7V2Mnle
Uao
DrmgeAiea-CU
HostGiuns
v
Printing
* Advanced Function Printing: The WQAS software design uses device independent pnnung.
The graphics, images, text, and documents can all be prmted by the IBM Advanced Function
Printing (AFP) sonware supported on the EPA central computer network.

-------
Water Quality Analysis System Documentation
Water Quality Analysis Interactive Procedures - Part I
Water Quality Analysis Interactive Procedures - Part II
Environmental Data Display Manager (EDDM) User's Guide
Technical Description of the Reach File
Mapping and Data Display Manager (MDDM) User's Guide
RF3 Mapping and Data Display Manager (MDDM) User's Guide
Reach Pollutant Assessment User's Guide
DFLOW User's Manual
Availability of Information on Dams and Impoundments Data
PCS STORET Interface

-------
WATER QUALITY ANALYSIS
INTERACTIVE PROCEDURES
PART I
Water Quality Analysis Branch
Monitoring and Data Support Division
Office of Water Regulations and Standards
U.S. Environmental Protection Agency
June 1986
(DRAFT)

-------
INTERACTIVE ANALYSIS PROCEDURES
This manual contains descriptions of a number of interactive analysis
procedures that are ava:.dble to users of EPA's IBM 3090 mainframe computer
system (located at the National Computer Center (NCC) in Raleigh, North
Carolina) who are interested in the retrieval and analysis of EPA-maintain?i
water quality lata. These procedures were developed and are maintained b
the Water Quality Analysis Branch (WQAB) of the Monitoring and Data Suppo
Division with support from the Program Systems Division (PSD) at EPA
Headquarters in Washington, D. C.
The data retrieval and analysis capabilities documented in this manual have
been used extensively in program support activities such as regulatory
impact analyses, needs survey analyses, discharge and stream dilution
studies, priority pollutant studies, and indirect discharge studies.
These procedures function in a fully conversational mode, i.e., the
procedures first prompt the user for specific information, and then perform
the user's request based on the response to the prompt, all while the user
remains online. The data files accessed by these procedures all reside on
the IBM mainframe located at EPA's NCC.
For more information on the capabilities of these procedures and how to use
them, contact:
WH-553
OWRS
Monitoring and Data Support Division
Water Quality Analysis Branch
FTS/202 382-7046
The procedures described in this manual include the following:
WQAB
PROCEDURE
NAME
FUNCTION
ASIWPCA to obtain stream use designation information for one or more
reaches within a state.
CITY
to retrieve.information about a city from EPA's City Master
File. By entering only a city name, users can obtain the city's
latitude and longitude, population data, information on stream
reaches associated with the city, and other information.
FLOW
to obtain stream flow data for a U.S. Geological Survey gaging
station.
WQAB
1

-------
HELP
to provide helpful information on the purpose and use of the
WQAB analysis procedures.
ICAT	to provide a listing of Standard Industrial Classification codes
associated with Industrial Categories.
PARM	to retrieve information about STORET parameters via a number of
selection options, which include parameter number, parameter
group, sample media, and CAS registry number. Capabilities
include obtaining copies of reports offline through the
submission of batch jobs.
PATHSCAN to retrieve information on NPDES and drinking water facilities
located upstream or downstream from a specified location. The
procedure accesses EPA's IFD, Water Supply, Gage, and Reach
files.
RCHDAT	to retrieve streamflow and pipe discharge data for
user-specified stream reaches and NPDES facilities.
SIC	to obtain listings of the 1,000 Standard Industrial
Classification (SIC) codes and their descriptions.
These analysis procedures access information contained in a number of EPA
data files developed and maintained by the WQAB and PSD. To effectively use
these procedures, users should be familiar with the names and content of the
data files listed below. Except for the STORET Water Quality and Flow
Files, all data files are in the EPA In-House System (IHS) format. Users
should also be familiar with the terminology associated with industrial and
municipal facilities.
FILE NAME	CONTENT
Parameter The Parameter File contains information on over 10,000 different
parameters defined to the STORET Water Quality File. The term
parameter is a designation for an individual element, or water
quality measurement, for which values relating to water quality
are associated. Associated with each parameter is a parameter
code, a one- to five-digit number that is unique to each
individual parameter. Information available includes the code
number, authorized abbreviations, the location of the decimal
point in measured values of the parameter, its unit of
measurement, a parameter description, the parameter group with
which it is associated, when the parameter was requested and by
whom, and the number of observations of the parameter that are
stored in the Water Quality File.
WQAB
2

-------
Water	The Water Quality File (WQF) is a collection of data relating
Quality to the quality of the waterways within and contiguous t- the
United States. These data are gathered by a process a '.ed
water quality monitoring whereby samples are taken of v ;er from
streams, rivers, lakes, and other belies of water. Tlie ?
samples are then analyzed within a laboratory to deter le the
presence, and if present the amount, of pollutants an ;her
particulates within the samples. The findings of the analyses
are stored as data in the WQF.
The information within the WQF consists of two basi ypes of
data: station data, which describe and categorize i
geographical location of where a sample was taken; and
parametric data, which describe the conditions under which a
sample was taken (such as date, time, depth, and sampling
conditions) as well as the results of the sample analyses. The
types of data stored in the WQF include ambient, sediment, fish
tissue, ground water, water supply, intensive survey, stream
flow, facility discharge, and toxic pollutants.
Flow	The Flow File is a collection of daily water flow data gathered
at U.S. Geological Survey (USGS) gaging stations located
throughout the country. The file is composed of approximately
85 percent streamflow data, indicating the quantity of water
flowing past the gaging sites, while the remaining 15 percent of
the file consists of water level and water quality parameters,
including temperature, conductivity, dissolved oxygen, pH,
chloride, and suspended sediment. Uses of Flow File data
include conducting regulatory impact analyses (RIA), developing
water monitoring strategy, and analyzing waste load allocations,
where the flow data are used to compute loadings. The
computation of loadings allows users to convert water quality
measurements, i.e., concentrations, to quantitative
measurements, e.g., pounds per day.
Currently, the file contains in excess of 630,000 records, each
representing a single water year's worth of data, for over
27,000 gaging sites. A typical gage may have up to 30 years of
flow data; some have more than 42 years of data. EPA receives
new data for the Flow File from the USGS biannually,
approximately every March and September, at which time the data
are made available to the STORET user community. (The last date
of update for the Flow File can be determined by issuing the
STORET command procedure %STORUN.)
IFD	The Industrial Facilities Discharge Pile contains information on
58,000 NPDES industrial and municipal facilities useful for
environmental analyses. Data consists of NPDES, DONS, and Needs
A/F numbers with name, address, basin, latitude and longitude,
stream reach, flow, SIC codes, discharge type for facility and
WQAB
3

-------
pipe level, and industrial category. Indirect discharges to
POTW systems are also included.
Water	The Drinking Water Supply File contains information on some
Supply	8,000 water supplies that utilize surface waters. Data covers
FRDS number, utility name, city, state, basin, latitude and
lor^itude, stream reach, population served, water volume used,
and locations for plant, intakes, and sources.
Stream	The Stream Gage Data File contains information on approximately
Gage	36,000 stream gaging locations throughout the United States.
Information stored includes location of gaging stations, stream
reach identification, types of data collected, frequency of data
collection, media in which the data are stored, identification
of the collecting agency, and where available, mean annual flow
and 7 day/10 year low flow. Included in the file are those
gaging stations (approximately 17,000) that are considered to
have the longest periods of natural flow data, i.e., flow not
affected by human activities.
Reach	The Reach File contains data on 62,000 stream reaches that have
been hydrologically linked to support environmental analyses.
The file contains stream reach number, stream name, type of
reach, stream level coding, and length. Linkages to lake and
wide river reaches are also included. There are 72,000 segments
defined in the REACH File, covering stream reaches, and lake and
coastal shorelines.
City	This file contains data on all cities, towns, and villages
located in the United States and its possessions. Information
on each city includes the city's unique identification code; the
county, state, major and minor river basin, and congressional
district within which it is geographically located; stream
reaches associated with the city; its latitude and longitude;
and its census population data.
To invoke an interactive procedure at the NCC, you must be in TSO mode, and
your TSO userid must be designated to the system as a STORET userid.
Procedure names are entered in response to a READY prompt while in TSO
mode. The WQ-TP (Terminal Procedures) chapter of the WQ part of the STORET
User Handbook documents the procedures required to interface with the STORET
system via remote terminals. Refer to this chapter for examples of logging
on to TSO.
These procedures are also discussed in online help data sets. Enter WQAB
HELP after a READY prompt to enter this procedure. Users should
periodically scan WQAB HELP to learn of any changes or additions made to
this information.
WQAB
4

-------
In the examples shown in this manual, which portray terminal sessions
invoking the procedures, lowercase letters represent user input, and
uppercase letters represent the computer's response. A «cr» following a
lowercase entry denotes a carriage return. In the descriptions, brackets
([]) denote that the enclosed operand may be specified at the user's option;
brackets enclosing a column of two or more operands also indicate an
optional choice: only one may be specified, but all may be omitted:
similarly, a vertical bar separating two or more operands on a line
indicates a similar optional choice. Braces (|^) denote that one of the
enclosed operands must be specified. References in these procedure
descriptions to the entering of a null line in response to a procedure
prompt mean that a carriage return () only (i.e., no data nor even a
blank) is to be keyed on that line.
One following note pertains to the priorities associated with the execution
of TSO interactive procedures at NCC, which influence the cost of these
terminal sessions and of any jobs initiated through these procedures. TSO
interactive sessions (such as WQAB procedure executions) bear a 1.0
weighting factor. However, batch jobs submitted from a WQAB procedure, such
as FLOW or PARM, carry a processing priority of 4, which has a weighting
factor of 2.0.
WQAB
5

-------
WQAB
HELP

-------
WQAB
HELP
CLASSIFICATION: Interactive Analysis Procedure
USE:	The WQAB HELP procedure provides information on the use of the
WQAB interactive analysis procedures, and contains an up-to-date
list of all procedures available to users.
PROCEDURE NAME: WQAB HELP
DESCRIPTION
This procedure is initiated by entering the procedure name while in TSO mode
following a READY prompt. Figure 1 shows entering the help procedure and
the help files that can be listed. It also shows the response for
information on the FLOW procedure. Entering "end" in response to the ENTER
NAME prompt returns the user to TSO and a READY prompt.
WQAB-HELP
1

-------
READY
'./.]ab help
ATTEMPTING ENTRY T'J WATER QUALITY ANALYSIS
¦sra :c:i software package - ;!el?
k
iELP SYSTEM FDR WOAE PROCEDURES
k
\ZL? IS AVAILAELE FOR T.IE FDLLD..IJG PRJ0SDU.C..3 :
I.:FO( GENERAL I.JFOR.iATION)
. .M J } . k J L.
-^CliOAf
i;. "AM
iirENJE?
j I r i'
i."j?LDr
IFDARE
7 ^ ¦<1
L - . 1 »
) J. ~
\L> i -* P J.\
JJRC [
PARM
^ i
straux
*
^ iTLJi< NAME OR "END" :
f lo.v
..'OAS FLO.;
*****
.."OA 2 c L'JJ 15 AN I NT E RACT IV E PROCEDURE WI I\-i OPTION TJ Dj.'.J.,
STREAM FLOv; DATA FOR USG3 GAGES USING STOREx' FLOW P^Jw-DJR-j .
JIVEN THE GAGE NUM3ER, 3TATE AND BEGIN/ END YEARS DAILY FLDNJlCFS)
O.l 5 xATI STICS TO DETERMINE 7 310 .(ILL 3E PROVIDED. IF A FIL-
JA.1E 13 PROVIDED THE FLOW DATA (I.E. DATE & DAILY DISCiiARG--CFS )
..'ILL L5E SAVED FOR FURTHER USE SUCH A3 DOWNLOADING TO A PC.
~
MEL? SYSTEM FOR WQAE PROCEDURES
*
Figure 1
The WQAB HELP Procedure
WQAB-HELP
2

-------
WQAB
CITY

-------
WQAB
CITY
CLASSIFICATION: Interactive Analysis Procedure
USE:	The WQAB CITY inter a-*- :ve analysis procedure allows users to
interactively retrieve data from the IHS City File that pertains
to a given city. The file contains information on over 35,000
cities, towns, and villages located in all states and
possessions of the United States. Having only a city name,
users can easily and quickly obtain much useful information
pertaining to that city including its latitude and longitude
coordinates, census data, major and minor river basin codes, the
county a. :ongressional district in which it is located, and
information on stream reaches associated with the city. These
data assist users in the use of other interactive analysis
procedures.
PROCEDURE NAME: WQAB CITY
DESCRIPTION
fh is procedure is initiated by entering the procedure name while in TSO mode
following a READY prompt. Figure 1 depicts the processing logic of the
procedure. After first responding with a brief description of the
procedure, WQAB CITY prompts for either a city name or a city, state
designation, as follows: ENTER CITY NAME OR CITY,STATE or END.
If a city name and state designation are entered, the ptocedure immediately
lists the information for that city, and upon completion, prompts for the
next city name or city, state designation. Figure 2 shows the procedure's
response to the entry of Seattle,wa.
If a city name without a state code designation is entered, the procedure
responds with a list of the states (and associated counties) that have a
city by that name. The information on the desired city is then obtained by
entering the appropriate two-character state code in response to the REQUEST
STATE CODE prompt. After the requested city's information is listed, user's
can request information on the same city name located in other states.
Figure 3 shows the procedure's responses to the entry of the city name
leesburg, and to the entry of the state code for Virginia.
The procedure is terminated by entering "end" in response to the ENTER CITY
NAME prompt.
WQAB-CITY
1

-------
READY
end
LISTS
INDEX
state-code
REQUEST
STATE CODE
TERMINATION
MESSAGE
clty,state-code
LISTS CITY
INFORMATION
LISTS CITY
INFORMATION
INFORMATIONAL
TEXT
ENTER
CITY NAME OR
CITY,STATE OR
END
uppercase denotes system proapt or response
lowercase denotes user input
KEY
Figure 1
Flow Diagram of the WQAB CITY Procedure
WQAB-CITY
2

-------
r
ENYER CITY NAME OR CITY,STATE OR "END" Seattle,wa
=============STATE-COUNTY: 53033  WASHINGTON
jiATE CODE SELECTED: 53
** SEATTLE	**
CITY# : 76160
LATITUDE: 474000
LONGITUDE: 1221500
FLAG: C
mAJ/MIN BASIN: 1311
SMSA: 7600
CITY NAME: SEATTLE
COUNTY NAME: KING
j.y60 CENSUS: 557087
1970 CENSUS: 530831
CONGRESSIONAL DISTRICT: 99
* STREAM REACH(S) ASSOCIATED WITH CITY *
*"ON"-CITY ON REACH;"OFF"-CITY NEAR REACH
CAT# SEG MILES FLG*
7110012
011

7100105
028
ON
7110012
001
ON
7110012
003
ON
7110012
006
ON
7110012
008
ON
7110012
Oil
ON
7110013
001
ON
7110013
004
ON
7110019
085
ON
7110019
086
ON
7110019
087
ON
ENTER CITY NAME OR CITY,STATE OR "END"
Figure 2
Procedure Response to a City,State Entry
WQAB-CITY
3

-------
ENTER CITY NAME OR CITY,STATE
*INDX = lOPOINTER(S)
STATE-COUNTY: 34011 
STATE-COUNTY: 51107 
si- ATE-COUNTY: 18085 
sTATE-COUNTY: 39071 
sTATE-COUNTY: 39159 
sTATE-COUNTY: 01019 
sTATE-COUNTY: 12069 
STATE-COUNTY: 13177 
STATE-COUNTY: 21097 
STATE-COUNTY: 48063 
OR "END" leesburg
NEW JERSEY
VIRGINIA
INDIANA
OHIO
OHIO
ALABAMA
FLORIDA
GEORGIA
KENTUCKY
TEXAS
REQUEST STATE CODE: va
=============STATE-COUNTY: 51107  VIRGINIA
STATE CODE SELECTED: 51
** LEESBURG	**
CITY# : 51000 '
LATITUDE: 390654
LONGITUDE: 773348
FLAG: *
rcAJ/MIN BASIN: 0214
SMSA: 3840
CITY NAME: LEESBURG
v-wuNTY NAME: LOUDOUN
iyt>0 CENSUS: 2869
1970 CENSUS: 4821
CONGRESSIONAL DISTRICT: 10
UO YOU WANT TO SEE THE SAME CITY IN ANOTHER STATE? "Y(ES)" OR "N(O)" y
REQUEST STATE CODE:
Figure 3
Procedure Response to a City Name Entry
WQAB-CITY
4

-------
¦¦HER NOTES AND COMMENTS
The information listed for a city includes a CITY#, a SMSA designation, and
optionally a FLAG code (see Figures 2 and 3). The CITY# is a 5 digit city
code established by EPA that is unique among all cities, towns, and villages
in the United States and its possessions. SMSA is the Standard Metropolitan
Statistical Are*, code established by the Census Bureau. The FLAG code
pertains to the latitude and longitude of the city, as follows:
Code	Explanation
C	The lat/long of the city was changed by EPA HQ
*	The lat/long was updated by atlas data
N	New atlas record with city lat/long
The absence of a FLAG code denotes that the lat/long given are of the center
of the county in which the city is located.
The names of cities and state codes must be correctly spelled, as the system
searches for exactly what was entered. Abbreviations are not valid
entries. For example, an entry of lesburg will not result in the listing
shown in Figure 3. City names that are composed of two or more words, such
as Little Rock, should be entered with a space between the words. However,
when entering a city name, state code combination, there must not be a space
after the comma, as shown in the first line of Figure 2.
Responses to the REQUEST STATE CODE prompt must be two characters in length,
ut may be either alphabetic or numeric. Thus a leading zero of a single
digit state code must be entered, e.g., 05 for the state of California.
The procedure has a number of messages it lists in response to incorrect or
invalid user entries. Most are self explanatory and simply request that the
user try again. Should the procedure ever seem to be in a loop, enter "end"
to return to the TSO READY mode, from which the procedure can be reentered.
WQAB-CITY
5

-------
WQAB
PATHSCAN

-------
WQAB
PATHSCAN
CLASSIFICATION: Interactive Analysis Procedure
USE:	The WQAB PATHSCAN interactive analysis procedure enables users
to retrieve information on NFDES and drinking water facilities
that are upstream or downstream from a specific location. The
location of interest can be specified by any one of several
pointers, including an NPDES number, a stream gage number, a
drinking water supply, or a stream reach number. The procedure
responds with the number of reaches, pipes, and drinking water
supply plants-intakes-sources that are located on the stretch of
water of interest, and gives the user the option to list detail
data on the facilities retrieved.
PROCEDURE NAME: WQAB PATHSCAN
DESCRIPTION
This procedure is initiated by entering the procedure name while in TSO mode
following a READY prompt. Each pass through the procedure entails entering
responses to the first six prompts shown in the box below and as described
in detail below. Entering "end" to the STARTING POINT prompt terminates the
procedure and returns the user to TSO and a READY prompt.

READY
1
STARTING POINT OR END:
2
UP/DOWN(0/D)?
3
LEVEL3
4
MILES-
5
REPORT ON DRINKS (Y/N)?
6
DETAIL(Y/N)?
7
CONTINUE (RETURN/N)?

STARTING POINT OR END:
WOAB-PATHSCAN
1

-------
|IRST PROMPT; STARTING POINT OR END:
This is the first prompt given for each pass through the procedure. One of
the following responses can be entered:
P=npdes# [(pipe#) ]
P=d*b#/D&B
P=needs#/NEEDS
G=usgs-gage#
R=reach#
D=f rds# [(Pplant# [Iintake# [Ssource# ] ]) ]
END
where:
npdes# is a valid NPDES number assigned as a primary station
code for the facility of interest. This nine-character code
consists of a two-character alpha FIPS state code abbreviation,
followed by a six-digit unstructured sequence number, followed
by a one-digit check digit.
pipe# is a one- to three-digit numerical value denoting a
specific pipe at the facility. If specified, pipe# must be
enclosed within parentheses; leading zeros are not required.
d&b# is a valid nine-digit Dun and Bradstreet number. DUNS
(Data Universal Numbering System) numbers already exist for most
regulated facilities and can be identified through EPA's FINDS
database. Users should contact the group that maintains FINDS
in their EPA regional office to determine if a D&B number
already exists for their facility. If not, the FINDS group will
create one. D&B numbers are 12 characters in length, beginning
with a 2 character state code followed by the letter D (however,
these alphabetic characters are not to be entered for this
procedure), followed by a nine-digit code. This D&B number must
be followed by a slash and "d&b", which identifies the code to
the procedure as being a D&B number.
needs# is a valid nine-digit Needs (or authority/facility)
identification number from the 1980 Needs Survey that identifies
collection facilities or treatment plants. The first 2 digits
of this number are the FIPS numerical state code. This value
must be followed by a slash and the word "needs".
usgs-qage# is a valid stream gage number, which consists of an
8- to 15-digit number, appended to the alphabetic code
identifying the contributing US Geological Survey agency.
WQAB-PATHSCAN
2

-------
reach# is a valid 11-digit reach number, which consists of an
8-digit USGS hydrologic cataloging unit code followed by a
3-digit stream segment number.
frds# is a valid Federal Reporting Data System (FRDS) number
that identifies a drinking water supply.
plant# is a three character value denoting a specific treatment
plant associated with the drinking water supply. This value
must be preceded by the letter P and enclosed within
parentheses. If no plant designator is provided, then the first
such plant designator at the specified drinking water supply
that has been assigned a reach number will be selected.
IintaketSsource# are valid designations for the intake and
secondary source for the facility. If specified, these values
must follow plant#, and the entire Pplant#Iintake#Ssource# value
must be enclosed within parentheses. The intake# must be
preceded by the letter I, and the source# by the letter S.
END Entering "end" terminates the PATHSCAN procedure and
returns the user to TSO and a READY prompt.
A set of correct entries to the first prompt of the PATHSCAN procedure is
given below. Figure 1 also shows a correct response.
A carriage return passes the information to the procedure and the second
prompt is given. Invalid or nonexistent starting point entries are not
determined by the procedure until it processes the response to the REPORT ON
DRINKS prompt.
SECOND PROMPT; DP/DOWN (0/D)?
Either a u or d must be entered in response to this second procedure
prompt. 0 requests an upstream retrieval, D a downstream retrieval.
Entering a null line only results in a repeat of the prompt.
p=pa0022047
p=pa0022047(l)
p=042157644/d&b
p=180061001/needs
g=usgs03022500
r=0 2040203001
d=pal510004
d=pal510004(p2)
d=pal510004(p2ils2)
npdes#
npdes#(pipe#)
d&b#/D&B
needs*/NEEDS
usgs-gage#
reach#
frds#
frds#(Pplant#)
frds# (Pplant#Iintake#Ssource#)
WQAB-PATHSCAN
3

-------
STARTING POINT OK Erir>: d = |>.i I 5 IcilliH
UP/DOfJN( U/D) ? u
LEVEL-+0
IIILES-30
REPORT ON DRINKS(Y/M)7 y
DATC H60027 Tint 110342
4 RCACHES
11 PIPES
I plahts-iutakes-souiices
DETAIL!Y/NI7 y
€
$
CD
I
£
O
>
z
0.00 02040202049/000.00 TYPE 11 LEV 2 LENGTH
0 DISCHARGED
2 . 20 NAME ItANCOCAb Cl(
0.00
gage
WEG02040202049
7
STCO
-1 DA
?
MF(CFS)

41)4 Ll' (
CF J )
4b
0.10
DRINK
PAIS10004 PHILADELPHIA WATER D POP 1950008
Y 367700 rCD TYPE
PI
TOKRL
jDALL TKMT
PL T
jOUKCL
2 . 20
02040202050/000.00 TYPE
K LEV 2 LENGTH U.
10
NAME
IIANCOCAS Lit









0 DISCHARGEb









2.20
GAGE
WEG02040202050
7
STCO
-1 DA
?
MF(CFS)

3'JJ LF(CF^)
4b
5.72
P 1 PR
1 NPDESI NJO023361
W1LLINGDORO MUA STP

OH
FLOW( TGD)

354O.00 -P
SIC
4<*b2
-1
-1
6 .07
pipe
1 NPDESI NJ0030741
W1LLINGBORO MUA WATER
PLANOFF
FLOW TGD1

50.00 -P
SIC
4941
-1
- 1
7.50
PI PC
1 NPDESI NJ002954K
MOORESTOWN TWP

OFF
FLOW TOU)

07.20 -P
JIC
4941
-1
-1
9.29
PIPE
1 NPDESI NJ002517B
MOUNT LAUREL MUA

ON
FLOW(TGD)

650.00 -P
SIC
4*J52
-I
-I
10.26
pipe
1 NPDESI NJ0023990
MOUNT LAUREL MUA

ON
FLOW(TGD)

55.00 -P
SIC
4 1J'j 2
-1
-1
10.20
PIPE
1 NPDESI NJ0024821
PEMUERTON TOWNSHIP MUA
ON
FLOW(TGD)

2500.00 -P
SI J
4Jb2
-1
-1
10.30
02040202051/000.00 TYPE
S LEV 2 LENGTH 26.
2D
U/kl IE
RANCOCAS Cl<
S
UH '







5 DISCHARGES









10.30
GAGE
WEGO2040202051
7
STCO
- 1 DA - 1
7
1 IF( CFS )

I JO Ll (CF:#)
0
15.94
PIPE
1 NPDESI NJ0024031
EVESHAM MUA

ON
FLOW TGD)

96U.00 -P
i c
4 t'j I
-I
-1
17.19
PIPE
1 NPDESI NJ0026U32
(IEDPOHD TOWNSHIP

O.J
FLO.rf(TGD)

900.00 -P
JIC
4Mb i.
-I
-1
19.03
PIPE
1 NPDLSI NJ00237 36
SOUTHAMPTON SEWEHAGL
CO
o;i
FLOW TGD)

500.00 -P
^1C
4 ijl
-I
-1
19.17
PIPE
1 NPDESI NJ003 3367
STOKES OF VINCENTOWN

ON
FLOW(TGD)

24.10 -U
SIC
2Ddo
-1
- 1
22.04
PIPE
1 NPDESI NJ00213 26
MEDFORD LAKES

OFF
FLOW(TGD)

450.00 -P
iilC
4'J 5 J
-1
-1
STARTING POINT oil END:

-------
THIRD PROMPT: LEVEL=
The response to this prompt specifies the stream levels that are to be
included in the data retrieval. Its format is
{[+11-[n
where n denotes the stream level and can be any integer beginning with z
A zero stream level refers to that level of stream on which the STARTIN
POINT is located or represents. A one value causes retrieval on the s
level plus the next level; a two, the same level plus the next two lev 3;
and so on. A plus sign indicates the retrieval is upstream, a minus sign
downstream. Thus if the starting point is on a level 3 stream, a +1 will
retrieve levels 3 and 4, and a -1 will retrieve levels 3 and 2.
All retrievals by stream level are subject to the mileage limitation, if
any, as specified in response to the next prompt.
Entering a null line will retrieve all levels, also subject to any mileage
1 imitation.
FOURTH PROMPT: MILES*
The response to this prompt specifies the number of miles, either upstream
or downstream from the starting point, that the procedure is to search for
facilities. The value can be any numerical value, and may include a decimal
value.
This miles value will be overridden by any stream level restriction
specified in the preceding prompt. Conversely, this miles value will
override a stream level restriction.
If no miles value is specified, the procedure will search to the end of the
hydologic system, limited to any stream levels if specified.
FIFTH PROMPT: REPORT ON DRINKS (Y/N) ?
This prompt asks whether data from the Water Supply File are to be retrieved
along with NPDES and gage facilities. If retrieved, any such facility is
identified by the word DRINK in the output listing. Either yes or no (or y
or n) must be entered; entering a null line only results in a repeat of the
pr ompt.
Upon entry of this response, the procedure lists the date and time and a
summary of the number of reaches and pipes, and if this last response was
yes, the number of piants-intakes-sources retrieved. See Figure 1 for an
example of this summary listing.
WQAB-PATHS CAN
5

-------
^IXTH AND SEVENTH PROMPTS: DETAIL (Y/W)? and CONTINUE (RETURN/N)?
The last two prompts pertain to the listing of the data retrieved by the
procedure. Detailed data are listed by reach, in ascending or descending
reach number order depending on whether the search was upstream or
downstream.
The CONTINUE prompt is given after 55 lines of data have been listed. Video
display terminal users may make a hard copy at this point and clear the
screen before continuing.
A no response to either prompt will terminate the detail listing; the
STARTING POINT OR END prompt will then follow. A null response to the
DETAIL prompt will also terminate the procedure. A null response to the
CONTINUE prompt will continue the listing of the detailed data.
OTHER NOTES AND COMMENTS
Most of the information provided in the detail listing should be self
explanatory. Data are printed by reach, and each grouping begins with a
line of data describing the reach. Following each reach descriptor line are
individual lines for each gage, drink, and pipe facility retrieved. Each
line begins with the mileage location of the facility on the reach.
kEach reach descriptor line includes an alphabetic code identifying the type
|f reach, as follows:
Transport Reach Types
Type Mean ing	Type Meaning
A	Artificial Lake
B	Bi-Directional
E	Entry
M	Artificial Open Water
N	Non-Connected
R	Regular
S	Start
T	Terminal
V	Open Water Terminal
X	Terminal Start
Z	Terminal Ehtry
Shoreline Reach Types
Type Mean ing	Type Mean ing
C Continetal Shoreline
G Great Lakes Shoreline
I Island Shoreline
L lake Shoreline
W wide-River Shoreline
Scattered through the detail listing are "-l"s and "?"s. The -1 indicates
an empty numerical field; the ? indicates an empty alphabetic or
WQAB-PATHSCAN
6

-------
alphanumeric field. For each line pertaining to a pipe, the alphabetic code
immediately preceding the SIC codes indentifies the use and disposal c
water used by the facility, and can be a P (process), C (cooling), B ( .h
process and cooling), or 0 (other type of disposal). DA stands for dr ia'
ar ea.
The data conta.'.ied in the Water Supply File pertaining to surface wat
utilities serving populations less than 25,000 but greater than 1,000 :e
not as complete and reliable as data on utilities serving population jver
25,000. Consequently these utilities are noted with an asterisk (* r a
letter N a*- the beginning of their line of data. See Figure 1 for
example of such a notation.
PATHSCAN is limited to the retrieval of 1,000 locations so requests should
define a reasonable hydrologic area.
WQAB-PATHSCAN
7

-------
WQAB
PARM

-------
WQAB
PARM
CLASSIFICATION: Interactive Analysis Procedure
USE:	The WOAB PARM interactive analysis procedure allows users to
interactively retrieve from the Parameter File information that
pertains to any of the thousands of STORET parameters.
Parameter information can be retrieved from the system in a
variety of methods. When a parameter code is known, information
concerning it can be retrieved simply by entering the parameter
code. Information can also be obtained on parameters associated
with a specific Chemical Abstract Service registry number, or
with a specific parameter group and media code. And the
procedure provides an easy way to obtain complete lists of
parameters sorted by parameter code, name, CAS number, group,
and number of observations by region.
PROCEDURE NAME: WQAB PARM
iDESCRIPTION
^his procedure is initiated by entering the procedure name while in TSO mode
following a READY prompt. The first prompt asks if the user wishes to see a
descriptive narrative of the procedure. A response of yes lists the
narrative, a no bypasses it. The procedure then lists the following option
menu, which lists the 5 output options available to the user:
*	1)	STORET PARAMETER
*	2)	CASK#
*	3)	GROUP/MEDIA
*	4)	BATCH (REPORTS FOR ALL PARAMETERS)
*	5)	END
OPTION?
To initiate the procedure, the user enters one of the appropriate single
digit numerical codes shown in the option menu; any other response will
result in a repeat of the option menu. Each o£ these options is discussed
in detail below. Whenever an option is terminated (as described below), the
WQAB-PARM
1

-------
user is returned to this main option menu. Entering a 5 to this option menu
terminates the procedure and returns the user to TSO and a READY prompt.
OPTION 1
Upon entering a 1 in response to the OPTION? prompt, the user is prompted
for the parameter code for which complete information is desired. Leading
zeros for this up-to-five digit code are not required. If the parameter
code is found in the Parameter File, the response is as shown in Figure 1,
which shows the information listed for parameter code 300, dissolved
oxygen. If the entered code is not valid, the system responds with a NOT
POUND message and repeats the ENTER S-T-O-R-E-T PARAMETER NUMBER prompt. A
reply of "end" to this prompt returns the user to the option menu.
Information provided includes the number of observations of the parameter
that are stored within the Water Quality File. Figures are given for total
observations as of 1977, as well as for a more recent date (July 1985 in
Figure 1) for surface water and for ground water.
ANALYSIS TYPE refers to the type of analysis performed on the parameter.
Values can be 1 (total), 2 (dissolved), or 3 (suspended). REPORTING UNITS
gives the unit of measurement associated with the stored values of the
parameters. The ORIGIN OF REQUEST lines refer to the organization that
initially requested that the parameter be assigned a STORET parameter code.
Major codes can be E (for EPA), F (other federal), or S (state). Minor
codes refer to the specific organization within the major code that made the
request.
OPTION 2
This option provides a listing of STORET parameter codes that are associated
with a specific Chemical Abstract Service registry number. Upon entering a
2 in response to the option menu prompt, the user is prompted to enter a
valid five- to eight-digit CAS number. This number must contain no embedded
blanks or hyphens. If found, the procedure responds with the total number
of occurrences found and asks whether they are to be listed (see Figure 2).
In response to a yes, WQAB PARM lists the parameter codes found and issues
another ENTER CASN prompt. In response to a no, the procedure issues an
ENTER CASN prompt. If the CAS number is not found, the procedure so
indicates and reissues the ENTER CASN prompt. A reply of "end" to this
prompt returns the user to the option menu.
OPTION 3
This option provides a listing of STORET parameter codes that belong to a
specific parameter group and sample media. The descriptive narrative
available upon entering this procedure lists the different parameter groups
WQAB-PARM
2

-------
r
OPTION?
1
ESTER S-r-O-R-E-r PARAMETER NUMBER OR "END" 300
< >: 00300
GROUP CODE: 04	(DISS.OXYGEN)
SAMPLE MEDIA: W (WATER)
ANALYSIS TYPE: 2 (DISSOLVED
REPORTING UNITS: A (MG/L)
AGC: *
DECIMAL POINT: 2 (XXXXXX.X)
SHORT NAME: 00
,'IG/L
FULL :IA.'1E: OXYGEN, DISSOLVED	1G/L
ENTRY OATE "YY.'IM " : 6507
ORIGIN OF REQUEST—,'lAJORi E
ORIGIN OF REQUEST—MINOR: STORET
REVISION DATE "YYMM": 3606
CAS NUMBER: 7782447
TOTAL OBSERVATIONS AS OF 1977: 2319715
PERCENTS 1972-77: 43
PERCENTS 1967-71: 32
PERCENTS PRE-1967: 24
<< SURFACE .JATER> >
•* NUCIUERS OF OBSERVATIONS AS OF JULY 1985 «*
3Y ;PA REGION— :.'0N-G3 AND ALL

NGS
ALL

NGS
ALL
1-
160792
172407
o -
106933
249720
2-
160595
194594
7-
116305
147620
3-
459402
496808
3-
88127
155731
4-
793901
929855
9-
130392
225191
5-
567117
469030
10-
270783
324221



us-
2904397
3367227
CANADA—ALL -	77194
NASOAN	-	59364
< >
ALL USERS -	43805
NON US3S -	20244
NTER S-T-O-R-E-T PARAMETER NUMBER OR "END" end
1)	STORET PARAMETER	•
2)	cas;:i	•
3)	GROUP/'lEDIA	*
4)	BATCH (REPORTS FOR ALL PARAMETERS) *
5)	END	•
OPTION?
Figure 1
WQAB farm's Responses to Option 1
WQAB-PARM
3

-------
\
OPTION?
2
ENTER CASH, OR "END" 7782447
TOTAL OCCURRENCES 20
LIST? "Y(ES)" OR "N(O)" y
PARAMETER NUMBERS CONTAINING CAS# 7792447
00290 00292 00295 00299 00300 00301
00339 34047 34048 34049 71835 71840
80103 80104 80103 35550 85650 85651
85653 35654
ENTER CASU, OR
"END"
7782447
TOTAL OCCUFIRENC
IES 20

LIST? "Y(ES)"
OR "N(0)" n
ENTER CASN, OR
"END"
9687
NOT FOUND


ENTER CASN, OR
"END"
end
*	1)	STORET PARAMETER	*
*	2)	CASN#	*
*	3)	GROUP/;iEDIA	*
*	4)	BATCH (REPORTS FOR ALL PARAMETERS)*
*	5)	END	*
OPTION?
Figure 2
WQAB PARM's Responses to Option 2
WQAB-PARM
4

-------
^^Bnified via a numeric code) and sampling media {signified via an
^^habetic code) that can b« searched for. Opon entering a 3 in response to
the option menu prompt, the user is prompted for a valid entry, which
consists of a single parameter group code followed by a single media code,
separated by a single slash. See Figure 3 for a listing of the parameters
found for group/media 4/V, which are the group and media codes for parameter
code 300 shown in Figure 1.
After listing the number of occurrences found, the procedure asks whether
they are to be listed, and if so, how many. These messages are repeated
until all have been listed, or a no response is entered, whereby the user is
again prompted to ENTER GROUP/MEDIA or END. A reply of "end" to this prompt
returns the user to the option menu.
Reading from left to right, each line of parameter information contains the
following items: parameter code, group number, sample media, CAS number (a
series of colons indicates there is no CAS number assigned to this parameter
code), and parameter text.
OPT 10 W 4
This batch option of the WQAB PARM procedure enables users to obtain
listings of the complete STORET parameter file sorted in any of these four
¦ences: by parameter code, parameter name, CAS number, or group number,
k parameter code listings that can be requested include* parameters in
eciflc group and sample media, in parameter code sequence?
number-of-observations of all parameters sampled in a region, in descending
number-of-observations order; and parameters defined as of a specified date,
in parameter code order. Also, four reports are available: a chemfate
report in parameter code order, a RCRA report in CAS number order, an I CAT
report, and a drinking water contaminants report. These listings and
reports represent large printouts and are printed offline at the EPA NCC in
Research Triangle Park or at a user's remote high speed printer. These are
special reports that report on specific groups of parameters of particular
interest to an organization or program. For instance, the RCRA report
(selection a) lists in CAS# order the 1700 parameters that pertain to ground
water monitoring data. Figure 5 shows a page of output of a drinking water
contaminants report (selection b). The asterisked contaminant
identification codes (CIC) denote regulated contaminants.
I
Upon entering a 4 in response to the option menu prompt, the user is first
prompted for the type of printed output desired, either laser print (8.5" x
11") or standard print (14" x 11"). A series o£ other prompts ask for the
user's assigned remote number and bin/box number, and for a type of user
code. Figure 4 shows one set of valid responses to these and other prompts
of this output option 4. After selecting the listing or report desired, the
procedure issues other prompts as necessary to obtain needed information
(e.g., the prompts for group and media codes for selection number S), and
l^^^a summary of the request. The user then has the option to submit the
WQAB-PARM
5

-------
OPTION?
3
EI'.TSR GROUP/MEDIA, OR "END" 4/w
TOTAL OCCURRENCES 15
LIST? "Y(ES)" OR "N(0)" y
ENTER NUMBER YOU WISH TO LIST 15
00290
04
W
7782447
DO UPT
AKLGHT BOT MG/
00292
04
w
7782447
DO 'JPTAKDARK BOT MG/~
00295
04
w
7782447
DO
ML/L
00299
04
w
7782447
DO
PROBE MG/L
00300
04
w
7782447
DO
MG/L
00301
04
w
7782447
DO
SATUR PERCENT
00336
04
w
10023156
OZONE
- RESIDUAL MG/L
00387
04
w
10028156
OZONE
MG/L
00389
04
w
7782447
DO
LAB-PROB MG/L
35650
04
w
7782447
DAY 02
UPTAKE MM/M2/HR
85G51
04
w
7782447
DAY 02
EVOLVED MM/M2/HR
35652
04
u

TIME
DAY 02 HR
35653
04
w
7782447
NIGHT
02UPTAKE MM/M2/HR
85654
04
w
7732447
NIGHT
02EV0LVED MM/M2/HR
35655
04
w

TIME
NIGHT 02HR
DO YOU WANT TO LIST MORE? "Y(ES)" OR "N(O)" y
HOW ;iA5JY MORE? 10
ALL RECORDS HAVE BEEN PRINTED.
ENTER GROUP/MEDIA, OR "END"
4/w
TOTAL OCCURRENCES 15

LIST? "Y(ES)" OR "N(0)" n

ENTER GROUP/MEDIA, OR "END"
end
* 1) STORET PARAMETER
*
* 2) CASN#
~
* 3) GROUP/MEDIA
*
* 4) BATCH (REPORTS FOR ALL PARAMETERS)*
* 5) END
*
OPTION?
Figure 3
WQAB PARM's Responses to Option 3
WQAB-PARM
6

-------
OPTION?
4
TYPE OP PRINTED OUTPUT
1)	LASER (8 X 11)
2)	STANDARD (IS X 11)
SELECT OPTION? 1
DO YOU WANT TO CHANGE YOUR SELECT OPTION? "(Y)ES/(N)0"n
H(EADQUARTERS). R(EOION) OR S(TATE) USER) 7 "H", R" OR "S" s
ENTER YOUR BIN/BOX.
2222
SELECT BY NUMBER
1.	PARAMETER* ORDER. COMPLETE FILE WILL BE PRINTED.
2.	NAME ORDER. COMPLETE FILE WILL BE PRINTED.
3.	CASN* ORDER. COMPLETE FILE WILL BE PRINTED.
4.	GROUP ORDER. COMPLETE FILE WILL BE PRINTED.
5.	GROUP fc SAMPLE MEDIA SELECTION.
6.	NUMBER OBSERVATIONS FOR REGION.
7.	ENTRY DATE "YYMM" REPORT IN PARAMETER# ORDER.
3.	CHEMFATE REPORT IN PARAMETER ORDER.
9.	RCRA REPORT IN CAS* ORDER.
A.	ICAT REPORT
B.	DRINKING WATER CONTAMINANTS REPORT.
C.	RETURN TO MENU.
SELECT	OPTION? 9
SUMMARY OF YOUR REQUEST
1.	PRINTED OUTPUT ON LASER PRINTER
2.	YOUR JOB WILL BE ROUTED TO BINBOX: 2222
3.	SELECTION: RCRA REPORT IN CAS* ORDER.
'SUBMIT THIS JOB? "Y(ES)" OR "N(O)'
n
'JOB CANCELLED'
1)	STORET PARAMETER
2)	CASN*
3)	GROUP/MEDIA
4)	BATCH (REPORTS FOR ALL PARAMETERS)
5)	END
OPTION?
Figure 4
WQAB PARM's Responses to Option 4
WQAB-PARM
7

------- PARMF REPORT 06/29/66 PA6E ****»»***)»»«»»*»*«**»#* * DRINKING HATER CONTAMINANTS * MQAB,MDSO,OMPS-EPA <<< "PARMFX4" DATABASE >>> EPA-ENVIRONMENTAL ANALYSIS SECTION