water quality information storage and final report

RETRIEVAL SYSTEM FOR HAWAII
(July 1971 - October 1973)
May 1974
L. Stephen Lau, Director
WATER RESOURCES RESEARCH CENTER
OBJECTIVES. . . Phase I: Contract Objectives. Phase II: Contract Objectives.
PROCEDURE AND RESULTS ...... . Phase I: Department of Health Data.
1. Preparation of Input Data and Keypunching of DOH Water Quality Data.
2.
a. Recording Forms. . . . b. Station Coding c. Nonstandard Data Codes d. Preliminary List . . . . e. Card Deck Organization Organization and Formation of Data Storage Sets . a. Transfer of Data from Cards to Disc. . . . .
b. Format Reduction and Formation of Storage Arrays
c. Sequential Organization and Formation of Permanent Data Storage Sets ...
d. General Data Listing
3. Listing of Annual Means and Medians for Select Parameters . . . . . . . .
4. Select Subroutine: SORT. ..... 5. Ten Percent Selection Subroutine •.
Phase II: Statewide Water Quality Data. 1. Compilation of Water Quality Storage Catalogue.
a. Department of Health Water Quality Stations. b. Other Federal and State Water Quality Stations
2. Preparation of Data Input Formats .... a. Federal and State Water Quality Data. b. Quality of Coastal Waters Data .....
3. Retrieval System: Data List, Statistical Analyses. and Display ......... .
v
. . iii
2
2
3
19
21
1) To transfer punched data from cards to disk. . . • . 21 2) Reduction of formats to 2 formats and 2 data sets 22 3) Output display: Sequential listing of raw data. 22 4) Statistical analysis. . ...... . 23 5) Graphic display. • . . . . • . . . . . 27
4. Recommendations for Continued Development and Institutional Arrangements for the WQISAR System ..
ACKNOWLEDGMENTS • .
REFERENCES.
28
31
32
33
35
B. Computer Programs. . . . .. . • . . . . . 87 C. Index to Water Quality Parameters with an Explanation of
Specific Parameters as Provided by the Department of Health .... 163 D. Department of Health Water Quality Stations. . . . . • . . . 171
E. Federal and State Water Quality Station Catalogue ......... 225
1.a Water Sampling Locations: l.b Water Sampling Locations:
FIGURES
Island of Oahu. Island of Maui.
1.c Water Sampling Locations: Islands of Molokai and Lanai. l.d Water Sampling Locations: Island of Hawaii ... . l.e Water Sampling Locations: Island of Kauai .. . 2. Present Storage Organization of WQISAR System ..• 3. Present Retrieval Organization of WQISAR System •. 4. Information System Form No.1. . .. . 5. Information System Form No.2 .......... .
• . 7
. 8
. 9
10
11
15
been developed for Water Quality data aolleated and maintained by
the Department of Health~ State of Hawaii~ from 1955 through 1971.
The system provides for safe~ permanent, storage and rapid re
trievaZ of Water QuaZity data. In addition to the ability to
retrieve a systematicalZy organized total data list~ the capabil
ity also is present to aompute, list and plot aertain statistias
basic to data reduction and analysis teahniques. A cata~gue of
the major water quality stations in Hawaii with their respeative
agencies is included. Reaommendations are presented for the
continued maintenanae, development~ and expansion of the WQISAR
system.
1
INTRODUCTION
The current increase in urban population has intensified the need for
Federal and State legislation to protect our natural environment and to
restore those areas where the pressures of urbanization have detrimentally
affected the surroundings. The Federal government is faced with the task of
setting environmental standards sufficiently broad so as to apply equally to
all States. State governments may have more stringent environmental stan
dards where specific conditions warrant; for example, air quality standards
applicable to mainland metropolitan cities such as Los Angeles, California,
would not be appropriate in Hawaii. A corollary to the development of an over
all environmental quality surveillance system is the development of a water
quali ty surveillance system as has been acknowledged in numerous Federal and
State documents: "Design of Water Quality Surveillance Systems" August
1970, Federal Water Quality Administration (now the Water Quality Office of
the U.S. Environmental Protection Agency); Federal Permit program under the
Refuse Act of 1899; Water Pollution Control and Coastal Zone Management
Acts; and Senate Resolution Number 233 (Hawaii 1971). The first step in the
design of such a surveillance system for the State of Hawaii was taken by
the Department of Health with the establishment in 1968 of the basic Water
Quality Standards (PubLic Health Regulations, Chap. 57-A). The water qual
ity criteria set forth at that time were based on the "best currently avail
able data." It was recognized that available "baseline data" were insuffi
cient in some areas and that "studies planned to be made in connection with
the implementation program might prove them [water quality criteria] to be
either inadequate or unattainable. For this reason, they will be subject . to periodic review and, where necessary, to change." In the five years
following the adoption of the standards there has been increased activity
by various governmental agencies and research organizations to monitor the
waters of the State and thereby develop the much needed data. As a conse
quence a considerable amount of information has been collected by these
various entities and with every passing year the mass of data being compiled
continues to grow. Unfortunately, however, the uncoordinated recording and
filing of the new data serves mainly to satisfy the immediate needs and
objectives of the separate collecting agencies but not necessarily the over
all purposes of an effective State Water Quality Standards Program.
2
The Water Quality Information Storage and Retrieval System for Hawaii is
intended to be an integral part of a national effort to design water qual
ity surveillance systems which would allow for more efficient Federal-State management of environmental quality programs. This computerized system for
Hawaii has been developed by the Water Resources Research Center under con
tract with the State Department of Health, the agency directly responsible for administering the Hawaii Water Quality Standards Program. The follow-
ing report details the rationale, design, operation, and use of the WQISAR System in compliance with the requirements of the contract under which it
has been developed.
OBJECTIVES
The primary objective of this project was to provide a computerized in
formation storage and retrieval system for water quality data collected by
the Department of Health, State of Hawaii. The system would proVide for
safe permanent storage and rapid retrieval of water quality information,
eliminate unnecessary overlapping and possible omission of needed informa
tion, and provide for statistical analysis of the data for multiple uses by
many agencies for research, planning, and surveillance.
Phase I: Contract Objectives The initial objectives of Phase I were as follows:
1. Prepare input formats and keypunch the water quality records of the
Department of Health ti tIed, "Water Quality Data", "Bacteriological Data",
"Water, Chemical Analysis", and "Water and Wastewater Chemistry Report"
from 1955 to 1971, inclusive.
2. Prepare a computerized listing of all raw data from those reports listed under "I" and arrange by island and location of sample station.
3. Prepare a computerized listing of yearly means and medians for
parameters listed in Chapter 37-A, Section 6-B, Specific Standards Applica
ble to Particular Water Areas for each year, island and station. These
parameters shall include, but need not be limited to, total coliform, fecal coliform, pH, total phosphorus, total nitrogen, dissolved oxygen, total
dissolved solids (Class AA waters only), temperature, and turbidity.
4. Prepare a computer subroutine which will allow selection and print ,:out of those values from raw data and from pertinent calculated statistics
that fail to meet the requirements of the Water Quality Standards.
5. Prepare a computer subroutine which will allow selection and print
out of those samples exceeding a predetermined value in 10 percent of the
samples collected over a specified period of time.
Phase II: Contract Objectives
3
1. Compile a complete listing of the sources and nature of water qual
ity data within the State of Hawaii and its coastal zone. 2. Design data input formats compatible with original data document
forms for, and in collaboration with, the individual agencies listed as con-
tributors to water quality information as a result of item I above.
3. Design a retrieval (sorting) system for water quality data which
will include the parameters recommended in the Federal Water Quality Admin
istration report, "Design of Water Quality Surveillance Systems" (August
1970), and will incorporate the data on water quality pertinent to Hawaiian
waters as described in Estuarine Pollution in the State of Hawaii (Cox and
Gordon 1970) and in The Quality of Coastal Waters study (Lau 1972). Include
such parameters as station number, location (latitude and longitude), chem
ical, physical and biological parameters measured, duration of measurements,
type of data, date, source or agency providing data, and a realiability in
dex indicative of precision. The ability to obtain the variation of a par
ticular parameter as a function of time, data, location or any other re
corded factor shall be a result of completing this task.
4. Provide a means for tabular or graphic output of the information
available and stored on the quality of Hawaiian waters. The ability to show
the variation of one parameter with respect to another or several other
parameters shall be the result of this task.
5. Provide a set of subroutines which will perform basic statistical
analyses on the water quality data. These analyses shall include, but need
not be limited to, range, mean, median, standard deviation, variance, and
general correlation studies.
6. Advise on the proper institutional arrangement for the implementa tion and continuation of a water quality information system. This shall
include, but need not be limited to, recommendations as to personnel, time, space, and facilities required, and overall cost of establishing such a sys
tem. Cost estimates shall be provided for compilation, reproduction and
4
keypunching of all existing data, as well as an estimate of the required
continued support level.
These objectives were expanded and/or modified during the course of the
project by mutual discussion and agreement to better meet the needs of the
Department of Health.
PROCEDURE AND RESLILTS
Phase I: Department of Health Data
1. Preparation of Input Data and Keypunching of DOH Water Quality
Data.
The first step in the development of the computerized information
storage and retrieval system was to transfer the desired data from the
original data recording forms to a computer compatible input device.
This may take anyone of several forms; however, one of the most com
monly employed is the standard computer card. The card input has the
advantage of being easily examined physically without special aids for
verification of input data error detection. The chance of error in
processing was increased due to the wide variety and character of the
original recording forms, therefore the use of cards was dictated to
minimize the error correction and to facilitate card arrangement by
counties.
The forms on which Water Quality measurements were recorded by
the Department of Health underwent considerable changes over the 17
year period fro~ 1955 to 1971. In several cases different data
recording forms were used on each of the iSlands to record similar
parameters. Initially it was believed that all water quality data
was recorded on the four forms specifically listed under Phase I.
However, a more thorough examination revealed 18 additional data re
cording forms. Thus a total of 22 s'eparate recording forms were
processed.
Appendix A lists these 22 recording forms, the card keypunching
format designed for each type, the format number assigned, title of
recording form. island, parameters included, and number of records
processed.
5
As might be expected, over a 17-year period, not only were the
recording forms periodically modified and revised, but also the methods
of analysis. To avoid the possibility of introducing errors by com
bining data processed by different analytical techniques the data were
processed with strict adherence to the title on the recording forms;
any change in title has been given a new storage location. With this
system, data may be combined at a later time as needed for specific
calculations but is kept separate for permanent storage.
b. Station Coding
A station identification number was assigned to each of the
specific sampling locations (Fig. l.a-e) maintained by the Department
of Health: Numbers I to 499 are reserved for Oahu county; 500 to 699,
Maui county (includes Lanai and Molokai stations); 700 to 899, Kauai
county; and 900 to 1299, Hawaii county. Provision was made for the
addition of new station numbers as required. The original data sheets
were hand coded with their specific station identification numbers.
Groups of data sheets were compiled for processing beginning with the
1955 records. The job of coding the station identification numbers was
somewhat simplified as much of the data had been originally filed by
station location. In many cases it was sufficient to indicate a single
number which applied to the accompanying 30 to 50 recording sheets.
The coded groups of data sheets were then sorted into groups with
similar recording forms and delivered to the keypunch division of the
University of Hawaii computer center (Fig. 2:a).
c. Nonstandard Data Codes
Nonstandar~ data were either coded or the values flagged at the
time of keypunching. For example, in the case of bacterial counts,
several standard laboratory recording conventions required special
treatment. "Too numerous to count" (TNTC) entries were coded and key
punched as .1111. Values recorded simply as "greater than some value",
were flagged with a plus sign either preceding or following the value
given. A value indicated as "less than" or "below the limits of
detection" was flagged with a minus sign (-) preceding the number
punched.
6
of cards was listed using an IBM Utility Card List Program (Appendix B)
and two copies of the card-image output of each box of data were ob
tained, thus providing the DOH and the WRRC with a current visual check
of all data being processed. The card image listings were scanned for
obvious keypunch errors, which incidently were exceptionally few,
averaging less than 0.05 percent of the 150,000 plUS total cards
punched.
e. Card Deck Organization
During the keypunching process the cards were kept in order by
format within each of the four counties. A format identification card
containing the format number and number of data values (fields), in
each format was inserted in front of each new format deck. An "end of
deck" card coded with "999" followed the last card in each format deck
(Fig.2:b).
Three different devices are commonly employed for storing data for
computer analysis: cards, magnetic tape, and discs. There are advantages
and disadvantages to each and the decision to employ one method over another
is dependent on the quantity of data being processed, the frequency with
which the data will be accessed, the type of computations required, the time
and cost of retrieval, and the actual need for physical mobility of the data
bank. The original data is first punched on cards. A single card can con
tain 80 characters or bytes. If the data bank is small (1000 cards), the
need for access is infrequent (weekly), and the calculations requested are
modest in time requirements (five minutes), the data bank could remain on
cards. More frequently however, the data banks are considerably larger and
the input time required to read the cards becomes a significant expense. In
addition the physical task of carrying many boxes of cards to the computer
each time one requires a computation becomes impractical, as was the case
in this project, where the data required some 150,000 cards (75 boxes) for
the initial recording of information and the use of magnetic tape or disc
storage was dictated.
Magnetic tape for the computer used in this project (IBM 360/65) is
somewhat similar to that used in home tape recorders. It is available in
various sizes, the largest reel holding approximately 2400 feet of tape.
The number of. records which may be stored on a tape depends on the record
MAKUA
BEACH PARK
i ~ 16
DIAMOND HEAD
MAKAPUU PT.
KOKO HEAD
\ \ " \ !
... ~
~) ~~/
ISLAND OF MAUl.
/ HAN A
!
\ ' \
.628/ /".................. ' .. ) i /' . ./ I "-'. .... ,;4'\ ..
t $tM.l-W-..o
! t • 1 ,
KAU •• tuLONlfOl
FIGURE I.e. WATER SAMPLING LOCATIONS: ISLANDS OF MOLOKAI AND LANAI.
A
PUN A
I SLAND OF HAWAI I •
OPIHIKAO 1112
_AHA PT,
o
FIGURE 1. e. WATER SAMPLING LOCATIONS: ISLAND OF KAUAI. I-' I-'
12
length (number of characters or bytes) and the arrangement of the data on
the tape, Le.) each card or group of cards representing one "record" re
corded individually or recorded as groups of records, "blocked". A "record"
is all the information transferred into or out of the computer at one time,
i.e., one card or a series of cards representing one logical unit. Data on
magnetic tapes may be recorded at different densities (the distance between
characters along the tape surface). Densities vary with the type of tape,
recording conditions, and individual computing center. The standard den
sity at the University of Hawaii computer center is 800 BPI where BPI stands
for "bytes (characters) per inch".
An "inter-record gap" is the physical distance (0.75 inch) on the tape
separating one record from the next. If data is stored one card, 80
characters, at a time at 800 characters/inch density, each record requires
80/800 = 0.1 inch for the record and 0.75 inch for the inter-record gap, or
a total of 0.85 inch. Approximately 33,700 such records may be recorded on
a single 2400-foot tape. By using certain control cards with the computer
program, several records may be blocked and written as a single long record
on the tape. For example, if one groups ten SO-character records into one
"block" instead of writing them individually, the tape record at 800 BPI
would require 10 x 80/800 equals one inch for data and 0.75 inch for the
inter-record gap, for a total of 1.75 inch for ten records as compared to
8.5 inches for ten unblocked records. The reading time and its associated
cost is determined by the amount of tape read. in the above example the
reading time would be about 1/5 as great for the same number of records for
blocked data. The card reader reads about 10 cards per second (800 charac
ters). Read time for magnetic tape averages 60,000 characters per second.
Another even more sophisticated storage device is the rotating disc.
The device consists of a stack of rotating recording surfaces somewhat
resembling a stack of phonograph records. Information is recorded on tracks
on a circular magnetic surface. Each track is a complete circle, i.e., the
track is not a helical. One or more records are recorded on each track.
There are varying types of disc units with different storage specifications.
The IBM 2314 unit used in this project will store 39, SO-character records
per track. Read time for the 2314 disk unit is about 312,000 characters
(bytes) per second, or five times faster than magnetic tape.
13
A major factor to be considered in determining the type of storage unit
to use is the type of access desired. Cards and magnetic tape may be
accessed sequentially only. That is, if one requires a record in the middle
of a large data bank, it is necessary to read the preceeding cards or tape
in order to "find" and "read" the desired record. The disc, on the other
hand, has the capability of direct access. If it is desirable, through
special programming, records may be accessed directly without reading the
preceeding data.
Disc storage was selected for the WQISAR system as the most efficient
in operational costs and for the potential flexibility of access when direct
access techniques become desirable in the future.
a. Transfer of Data from Cards to Disc
To optimize the time and cost of operation of the WQISAR system
it was necessary to transfer the information from cards to disc. This
was accomplished using an IBM Utility Card to Disc Program (Fig. 2:
b, c) (HAWIDISK, KAUIDISK, MAUIDISK, OAHtTDISK, Appendix B). The data
was transferred in a card-image format and a preliminary listing was
obtained to confirm the successful transfer to assist in error detec
tion.
b. Format Reduction and Formation of Storage Arrays
To facilitate the general analysis and retrieval of the data it
was necessary to simplify the storage arrangements. Programs were
written (HAWIBC, KAUIBC, MAUIBC, OAHUBC) to consolidate the 22 separate
formats (four data sets) into two general formats for storage as two
arrays for each of the four counties (eight data sets) (Fig. 2:d).
The first array (B) contains the 24 parameters most generally recorded
on the DOH Bacteriological Data recording forms. The second array (C)
contains primarily parameters 25 to 85 as generally recorded on the
Water, Wastewater, Chemical Analysis forms. Parameters 1 to 24 were
included in the tc t array as well as the 'B' array for those cases
where they were measured simultaneously with parameters 25 to 85. A
complete index to the 85 parameters is given along with a detailed
explanation of specific parameters in Appendix C.
c. Sequential Organization and Formation of Permanent Data
Storage Sets
After the final corrections and subsequent formation of the two
14
general arrays for each county, the data were sorted and arranged
sequentially by station and date in ascending order, using the IBM
utility sort-merge program (Fig. 2:e): HBSRT, HCSRT, KBSRT, KCSRT,
MBSRT, MCSRT, OBSRT, and OCSRT (Appendix B) to create the permanent
disc storage data sets (Fig. 2:f) of two data sets for each of the
four counties. The data sets were also written on magnetic tape as
duplicate data, a safeguard provision.
d. General Data Listing
A major accomplishment of Phase I was the complete and sequen
tially organized listing of all water quality data held by the DOH
from 1955 through 1971 inclusive. To accomplish this in the island,
station, and date sequential order requested by the DOH, required the
formation of eight separate data sets, two for each county, and a
similar number of listing programs to provide the desired output
(Fig. 3:a).
These eight programs: HBLST, KBLST, MBLST, OBLST, HCLST, KCLST,
MCLST, and OCLST (Appendix B) are the general listing programs used
for each of the four counties and Band C data sets. The listing (of
approximately 85,000 water quality records and 1,000,000 data values
from 1955 through 1971) was prepared and delivered to the DOH in
October 1972. A description of the parameters listed is presented in
Appendix C.
3. Listing of Annual Means and Medians for Select Parameters
A listing of the annual means, medians, standard deviations, range, and
certain other pertinent tallies of the twelve parameters: standard plate
count, total co1ifor,m, fecal coliform, pH, residual chlorine, total phos
phorus, total nitrogen, dissolved oxygen, total dissolved solids, tempera
ture, turbidity JTU, and total solids (without HgC12), was prepared for all
stations in each of the four counties over the period 1955 through 1971.
This analysis was accomplished using the programs (HBAVE, KBAVE, MBAVE,
OBAVE, HCAVE, KCAVE, MCAVE, and OCAVE) as appropriate for each of the eight
data sets (Fig. 3:b) (Appendix B). Similar monthly summaries were not
prepared due to insufficient data.
Using the programs listed above with appropriate data input cards, one
may retrieve a basic statistical summary of monthly or yearly values on any
specified station, date, or parameters. The output from such a request
a
b
FORMAT 2 FORMAT 22
2 -13 /22- 59
L
"" 1
16
a
b
c
LISTING
PROGRAMS
STATISTICS
PROGRAMS
SEQUENTIALLY ORGANIZED RAW DATA
FROM DOH DATA BANI<
17
consists of a tabular listing, and, if requested, an X-V plot of the speci
fied parameter versus date (Appendix B). Cost for such an operation varies
from approximately $1.00 for a monthly or annual summary of the 17 years of
data for one station and one parameter to $6.00 to $15.00 for an annual
summary of a single parameter from all 669 stations and for all years.
4. Select Subroutine: SORT
Subroutine SORT (Appendix B) was written and tested to allow the selec
tion and printout of the values from the raw data or pertinent calculated
statistics that exceed a given value.
5. Ten Percent Selection Subroutine
The preceding SORT subroutine may be modified to provide a selection
of samples exceeding specified values in 10 percent of the samples collected
over a specific period of time. The required modifications have been exam
ined, but implementation was not attempted pending the revision of the water
quality standards presently under review. The current standards are not
clear on the number of samples or sampling frequency required for compliance
with objectives #5 of Phase I.
Phase II: Statewide Water Quality Data
1. Compilation of Water Quality Storage Catalogue
a. Department of Health Water Quality Stations
A list of the 669 water quality stations maintainted by the Depart
ment of Health (Appendix D) has been compiled using the station list
program, STATLST (Appendix B). This listing includes such information
as station number, location, street, district, island, a DOH "water
source" code number, water type, water classification, sampling fre
quency for bacteriological or chemical data and a special column for
"remarks", At the time of its compilation, the station locations
were not mapped, hence geographic coordinates (latitude and longitude)
could not be included.
Station information forms (Fig. 4) were sent to the agencies
which responded in the affirmative to our original questionnaires
concerning their operation of water quality stations.
18
1. Participating Agency: ______________ _
2. Contact Member: _________________ _
6. Latitude: ______ _ 7. Longitude: ______ _
11. Water Type: (Check One) Beach ____ _ Estuary __ _ Harbor __ _ R1ver Coasta'""'r---
Stream Caoal---- Lagoon Otfsho'-r-e-- Potable -
12. Water Classification: (Check One) AA 1 A 2----
Non-PotabJ.e~,...... __ Irrigation Ditch Industrial Wast~--- Reservoir Other (sp€-c-:!.I""':r:-y""') _--
B Other { specify ) __ _
(To Be Filled Out By Information System Coordinator)
Dept. No.
No. Per No. Per No. Per No. Per Hour Dal Week 'Year Other
Physical
Chemical
19
Input formats were designed for the completed station information forms
returned by the following Federal, State, and County agencies:
Water Resources Research Center, Quality of Coastal Waters
Project (161 stations),
stations),
City and County, Division of Sewers, Water Quality Data Program
(22 stations).
quality stations including: station number, geographic coordinates,
station name, island, district, water type, water classification, and
type of data and frequency of sampling. Provision is provided for
additional remarks.
a. Federal and State Water Quality Data
Information forms were organized to facilitate the design of input
formats for water quality data collected by other agencies (Fig. 5).
The data information forms were sent to the above listed agencies and
tentative input formats were designed (Appendix A).
b. Quality of Coastal Waters data
The input formats for the QCW data designed as a part of this
study were adopted and used by the QCW staff in transferring their
water quality data to computer cards for eventual entry into the
WQISAR system.
a. Computer Requirements
The WQISAR system has been written in Fortran IV designed for use
on an IBM 360/65 computer. Fortran'is the abbreviation of formula
translation and refers to a specific type of computer instruction or
language which a programmer uses to communicate with the computer.
A certain amount of space must be reserved in the computer for
storage of the program and the data which is being operated on at any
one time. This storage area is called "core" and space is reserved in
20
Information System Form No.2" USER'S STANDARD FORM DESCRIPTION
PLEASE FILL OUT FOR EACH DATA RECORDING FORM YOU USE AND ATTACH TO COPY OF YOUR FORM
1. Participating Agency: _______________ _
2. Contact Member: __________________ _
7. Total Number of Forma: ____________________ _
8. Average Number of Sets of Observations or Measurements Per Form: __________________________________ __
9. Total Number of Different Parameters Per Form: -------
(To Be Filled Out By Information System Coordinator)
Dept. No. ____ _
Format No. ____ _
No. Cards ____ _
10. Present Data Analysis Objectives : ___________________________ _
11. Proposed Data Analysis Objectives: ________________________ _
12. M!lximum Number of Digits (or Characters), Including Decimal and Sign, and Information Type for Each Parameter:
Parameter No.
(Continue on Additional Sheet if Necessary)
FIGURE 5. INFORMATION SYSTEM FORM NO.2.
AlEha.· Both --
21
units of characters or bytes as required by the individual program.
Program storage requirements for the WQISAR system in bytes (or charac
ters) range from 150,000 ('B' array operations) to 350,000 ('C' array
operations). The present data storage bank requires approximately 100
cylinders of a 2314 disc pack. Basic storage requirements could be
reduced if necessary with a minimum of reprogramming effort using peri
pheral storage devices such as are available with some minicomputer
systems. A back-up copy of all storage bank data is available on
magnetic tape as well as disc.
Information written on either a tape or disk may be specified as
formatted or unformatted. Formatted output is converted to decimal
numbers and characters and written, one character per byte, in the
same form as a printer or card punch. Unformatted output is not con
verted to decimal from the binary form used in the computer. The
storage of data in the unformatted or binary form has several advan
tages. The time-consuming conversion is eliminated both in writing
and later reading and the data generally takes up less storage space
in the binary form. At the present time, the WQISAR data is stored
unformatted in blocked form to consolidate space on the disc and/or
tapes.
Job Control Language (JCL) cards are control cards used to direct
the execution of computer programs and describe the input/output (tape
or disc) devices used. The JCL cards indicated are those necessary
for running these programs on the University of Hawaii IBM 360/65
Computer. Modification of the JCL cards to comply with JCL require
ments at other ,computer centers should be facilitated by comparison
with existing JCL cards. The reader is referred to the IBM 360 Job
Control Language Text (Brown) or an experienced JCL consultant if JCL
input changes are required.
b. Available Operations
The following is a list of the'WQISAR system programs and routines
presently operational with the Department of Health water quality data
bank. Examples of input, programs, and output are given in Appendix B.
1) To transfer punched data from cards to disk
HAWDISK, KAUDISK, MAUDISK. OAHDISK. The four utility programs
transfer the data in a card-image format, from the original key-
22
punched data cards to storage on a 2314 disc pack.
This program requires approximately 1.5 machine-unit-seconds/
1000 cards transferred to disc on the IBM 360/65 computer at a
cost of approximately $.30/1000 cards.
2) Reduction of formats to two formats and two data sets
HAWIBC, KAUIBC, MAUIBC, OAHUBC. The four separate programs
were designed to reduce the multiformat data sets to two general
arrays, thus forming two data sets for each of the four counties.
Using the appropriate deck, the programs read each record from
the original data set on the disc and organize the data into two
arrays, creating two new data sets on the disc for each of the
four counties. The data sets are unformatted to conserve storage
and read and write time. The printout of these programs is
limited to a simple, nontitled listing of the first and last 20
records transferred to the new data set.
3) Output display: sequential listing of raw data
HBLST, KBLST, MBLST, OBLST, HCLST, KCLST, MCLST, OCLST. The
listing programs provide a sequential listing of all data from
each of the eight data sets. Listing is arranged by station and
date within each station, for each of the four counties. The
parameters listed are appropriately titled and provide the reader
with a complete record of all water quality data maintained by
the Department of Health from 1955 through 1971. The HE, KB, ME,
and GELST series refer to the 1 to 24 parameters in the 'B'
array. The HC, KC, MC, and GCLST programs list parameters 24
through 85 stored in the 'C' array, parameters 1 to 24 stored in
the 'c' array are also present in the 'B' array and are listed
with IB' array listings.
Example 1. To list all raw data, parameters I to 24, from all
stations on Kauai.
b) Insert station specification cards (20) all blank
c) Submit to computer
To obtain listings on certain stations only, station selection
cards are prepared as follows: Desired stations are punched,
right justified, without decimals, in columns 1 to 6, 7 to 12,
13 to 18, etc., ten numbers to a card, to a maximum of 20 cards
(200 stations) per single run request. A '-99.' must immediately
follow the last station specified. There must be 20 station
specification cards in each run. If only four stations are
required the remaining 19 cards remain blank but must be included
in the deck.
The following example serves to illustrate the use of these
station specification cards:
ExampZe 2. To select four stations located on Kauai and list all
the raw data from stations: 750, 768, 770, 786.
Method. a) Select program deck KBLST (B array data)
b) Prepare data specification card: station number 750
is punched in columns 4, 5, 6; 768, columns 10 to 12;
770, columns 16 to 18; 786, columns 22 to 24, -99. in
columns 25 to 27
c) Insert data specification cards in program deck with
accompanying 19 blank cards
d) Submit to computer
e) Repeat items a through d using program deck KCLST to
obtain listing on 'C' array
4) Statistical analysis
techniques.
These programs compute arithmetic averages, medians, log of
medians, maximum and minimum values, and standard deviations.
They also keep account of the number of missing, zero, greater
than, less than, and "Too Numerous to Count" values. Provision
is made for delimiting specific stations, dates, and parameters
upon which the above computations will be performed.
Data specification cards are prepared as follows and all
numbers are right justified:
" 29 to 31
" 32 to 34
" 3S to 37
to
columns 78 to 80
Specified station identification number, no decimal. If a zero or blank is present in this field, all stations are processed sequen tially beginning with the first record encountered.
Specific year requested: S5 to 71. If a zero or blank is present in this field, all years data are processed for the station or sta tions indicated in Field 1.
Specific month requested: 1 to 12. If a zero or blank is present in this field, yearly statistics only are calculated. If a "1311 is present in this field, yearly and all monthly statistics are com puted.
XY plot code. If a zero or blank is present in this field, no plots are produced. A one in this field calls the XY plot subroutine for either monthly or yearly averages as appropriate based on the previ ous field specifications.
Specific parameter number 1 to 24 or 25 to 85.
Same as above.
NOTE: Special requirements of the data specification cards:
1. Station numbers MUST BE IN ASCENDING ORDER. 2. Specific years MUST BE IN ASCENDING ORDER within
anyone station requested.
25
Subroutines AVSDVA, SORT, and XYPLOT are called from the main programs.
Subroutines ORDER and MEDIAN are in turn called from subroutine AVSDVA.
SUBROUTINE AVSDVA (A, NA, KOL, XMONTH, I YEAR , XMAX, XMIN, JCROW, JCCOL,
EDIAN, AVER, SUMN, SUM, NZERO, STD, E, IGT, R)
This subroutine is called from the main programs: HBAVE, HCAVE, KBAVE,
KCAVE, MBAVE, MCAVE, OBAVE, OCAVE. It initially selects or deletes data to
be used in the statistical computations and maintains a tally of the data
so separated. In computing the means, medians, and standard deviation the
"Too Numerous to Count", TNTC, values are omitted and the "less than" and
"greater than" values are taken at their given value. A tally is maintained
for all zero, "greater than", "less than", "TNTC", and blank values. Two
subroutines, ORDER and MEDIAN, are called from AVSDVA.
Arguments: SUBROUTINE AVSDVA
Number of values in array A
Parameter number on which calculations are to be performed
Month specified
Year specified
Dimensions of input array A [row]
Dimensions of input array A [column]
Median value to be returned to main program
Arithmetic average returned to main program
Number of observations used in the calculations of median and mean
Total number of possible data values includes blank, TNTC, "less
than", and "greater than" values
Number of zero values
Tally of TNTC data
This subroutine is called from SUBROUTINE AVSDVA. It produces an
ordered array in ascending sequence.
Arguments: SUBROUTINE ORDER
Ordered array
SUBROUTINE MEDIAN (E, N, EDIAN)
This subroutine uses the ordered data list produced by SUBROUTINE DRDER
to select the median value if the total number of observations (NSUM) is odd,
or compute the median by averaging the two central values if (NSUM) is even.
Arguments: SUBROUTINE MEDIAN
Number of ordered observations
The median value returned to AVSDVA subroutine
SUBROUTINE SORT CA, KOL, SML, BIG, RNA, JBROW, JBCOL, JCROW, JCCOL)
subroutine selects a specific value or a range of values from a
specified list. In the present usage with the HBAVE, HCAVE, KBAVE, KCAVE,
MBAVE, MCAVE, OBAVE, and OCAVE programs, this selection is confined to
selecting specific months out of the yearts data.
Arguments: SUBROUTINE SORT
INPUT
A Name of the array (double dimensioned) containing the data from
which the desired information is to be sorted
KOL Number of the parameter containing the specific information
requested
SML Lower limit of value requested, stored in parameter (KOL)
BIG Upper limit of value requested, stored in parameter (KOL)
RNA
JBROW
JBCOL
JCROW
JCCOL
OUTPUT
R
NR
Dimensions of array A [row]
Dimensions of array A (column]
Dimensions of array R [row]
Dimensions of array R [column]
Name of array containing selected values from array B
Number of values in array R
27
5) Graphic display
At the present time output display other than the tabular listings
described above, are limited to a computer-printer XY plot of
parameters versus date. This XY plot subroutine is a part of the
above statistical package and may be called as desired.
SUBROUTINE XYPLOT eN, x, Y, XMIN, XMAX. YMIN, ¥MAX, XLEN, YLEN)
This subroutine produces a printer plot of any specified parameter
versus another. The present use of XYPLOT with the statistical programs
limi t the input for plotting to parameters which can be represented by a
number or the log of a number between 1 and 100. This X axis runs down the
page; Y runs across. In the present usages of the XYPLOT routine the "Y"
axis limits are preset for date, (parameter 28 or 30 for the B array, 89 or
91 for the C array) either monthly or yearly values.
Arguments: SUBROUTINE XYPLOT INPUT N
X
Y
XMIN
XMAX
YMIN
¥MAX
XLEN
YLEN
OUTPUT
Single dimensioned array containing the desired median values
Singly dimensioned array containing the sequence of years or
months in one specific year as requested
Lower limit of the range of values in X
Upper limit of the range of values in X
Lower limit of the range of values in Y
Upper limit of the range of values in Y
Length of the ordinate axis, in inches, of the plot produced
Length of the abscissa axis, in inches, of the plot produced
Produces a plot for specific parameter for a given sequence of
years, or months in one specific year, as requested
28
programs and graphic output.
ExampZe J. To compute yearly and monthly basic statistics for
parameter 6 for 3 stations on Maui with an XY plot of the results.
Stations requested: 504, 509, 512.
Method. a) Select MBAVE program
b) Prepare data specification cards as follows:
COLUMNS
CARD STATION YEAR MONTH PLOT PARAMETER NUMBER NUMBER 1-7 8-10 11-13 14-16 17-19
1 504 0 13 1 6
2 509 0 13 1 6
3 512 0 13 1 6
ExampZe 4. To compute basic monthly and yearly statistics on
parameter 49 (total nitrogen) for January 1969, 1970, 1971
stations 345 and 372 on Oahu. No plots.
Method. a) Select OCAVE program
b) Prepare data specification cards as follows:
COLUMNS
CARD STATION YEAR MONTH PLOT NUMBER NUMBER 1-7 8-10 11-13 14-16
1 345 69 1 0
2 345 70 1 0
3 345 71 1 0
4 372 69 1 0
5 372 70 1 0
6 372 71 1 0
Arrangements for the WQISAR System.
for
49
49
49
49
49
49
In compliance with the specific requirements of objective #6 of the
Phase II contract, the following recommendations for the continued mainte-
nance, development, modification. and institutional arrangements for the
WQISAR system are presented. Recommendations are of three general cate
gories:
29
a. The development of a standardized update procedure to provide for
immediate inclusion of the existing water quality back data and a
systematic arrangement for continuous updating of the DOH data bank.
b. The refinement and expansion of present programs to provide:
1) Greater versatility and efficiency
2) Additlonal statistical summaries to comply with the revision
of the State Water Quality Standards
3) Additional graphic capabilities
c. The utilization of the system in the design, modification, and
evaluation of the State Water Monitoring Program, including participa
tion in the Federal STORET system.
The true measure of the success of any such information storage
and retrieval system must be viewed in the context of how the system
is used once the mechanics of its development are established. With
this in mind, Item C above considered of utmost importance.
The present state of development of the WQISAR system will allow for
standard data reduction and analysis of the Department of Health Water
Quality Data for 1955 to 1971 inclusive. A systematic analysis of the
parameters contained in this large data bank will provide the baseline in
formation upon which a responsible and efficient monitoring program for
water quality data may be developed for the State of Hawaii.
At the national level, the Environmental Protection Agency was "created
to permit coordinated and effective governmental action to assure the pro
tection of the environment by abating and controlling pollution on a system
atic basis". To assist them in complying with this prescribed mission, the
Environmental Protection Agency has developed STORET, a national Storage and
Retrieval System for water quality data. STORET serves as the review, anal
ysis, and evaluation system whereby EPA may report its findings to Congress
as required.
The development of procedures for storage and retrieval of the water
quality data, which is now collected and maintained by the State of Hawaii
in the WQISAR system, can be programmed into the STORET system to provide
additional statistical analysis capabilities and the option of retrieving
30
data stored in the STORET system by other State and Federal agencies for
comparison purposes in the surveillance of water quality data within the
State.
Institutional arrangements for the reposition of the WQISAR system
have been examined and the following recommendations are presented.
a. The WRRC of the University of Hawaii would continue to develop,
modify, and maintain the WQISAR system.
b. The WRRC would provide data summaries using existing data banks
and the retrieval system for specific requests of the DOH, funding
permitting.
c. This arrangement would continue on an annual basis, funding per
mitting, until such time as the DOH or the WRRC prefer to make other
arrangements, in which case a 6 months notice of "intent to transfer
the WQISAR system" should be given to the concerned parties.
d. At the time of transfer copies of all data banks, programs, and
appropriate documentation relative to the operation and utilization of
the WQISAR system would be furnished by the WRRC to the DOH for trans
mittal to the WQISAR receiving agency.
e. An annual budget would be developed through mutual discussion with
the DOH and WRRC and would be submitted to the DOH for approval by
July 1 of each year stating the proposed objectives and costs of the
WQISAR system for the following fiscal year.
f. Semi-annual and annual reports detailing progress to date would be
submitted by the WRRC to the DOH.
The Water Quality Information Storage and Retrieval System, Phase III
and IV, proposal prQvides for a continuation of this project including
specific objectives designed to fulfill certain immediate needs of the
Department of Health as well as longer range analysis objectives basic to
the further development, refinement, and use of the WQISAR system. Item A
of the objectives listed in Phase III has been funded and is currently in
progress (WQISAR system, Phase III progress report, Jan. 1974). Phase III
of the WQISAR system has been designed in cooperation with the Environmental
Protection Agency, Department of Health, and Water Resources Research Center,
and provides the necessary information to the Department of Health to fulfill
the requirements set forth in the recently enacted 1972 Amendments to the
Water Pollution Control Act. Phase IV includes the continued development
31
and modification of the WQISAR system, an analysis and evaluation of the
State's Water Quality program, and a study and cost analysis for insertion
of the WQISAR data into Federal STORET system. The specific objectives of
Phase IV are subject to review at the completion of Phase III and may be
modified as needs dictate.
ACKNOWLEDGMENTS
The successful development of the WQISAR system has been accomplished due to the mutual efforts of a number of agencies and individuals. The Water Resources Research Center (under the direction of Dr. L. Stephen Lau with the assistance of Dr. Hiroshi Yamauchi) and the Environmental Center (directed by Dr. Doak Cox, working in cooperation with Dr. Richard Marland of the Office of Environmental Quality Control) were initially responsible for bringing the proposed WQISAR system to the attention of the Department of Health and Drs. Walter Quisenberry and Henry Minette. The development of the system is the end product of a mutually cooperative effort on the part of these agencies.
In addition, assistance has been supplied by several individuals who deserve "honorable mention" for their efforts. Special thanks should go to Miss Carol Harris who assumed the responsibility for the formating, direc tion of keypunching~ and much of the initial programming and general data organization, particularly in Phase I. Her competence and careful atten tion to detail contributed greatly to the successful completion of the pro ject. The initial collection and organization of the data recording forms and station coding was ably directed by Miss Amy Tanaka of the Sanitary Engineering Branch of the Department of Health. Mr. William Wong replaced Miss Tanaka in Phase II and has been similarly helpful with the more recent work. Keypunching per se was expertly handled by Mrs. Sadie Fujii's group at the University of Hawaii Computing Center. University of Hawaii student, Alvin Char, has been responsible for the production runs and layout of the final outputs. In addition he has helped substantially in the error correction and general optimization programming in Phase II.
32
REFERENCES
Brown, G.D. 1970. System/360 Job Contr-oZ Language. New York: Wiley.
Cox, D.C., and Gordon, L.C. 1970. EstuaPine pollution in the state of Hawaii: Statewide study, Vol. l. Tech. Rep. No. 31, Water Resources Research Center, University of Hawaii.
Department of Health, State of Hawaii. 1968. Chapter 37-A. Water Quality Standards. Public Health Regulations.
Federal Water Pollution Control Act. 1972. Permit program (Refuse Act of 1889). Public Law 92-500.
Federal Water Pollution Control and Coastal Zone Management Acts. 1972. Public Law 92-500.
Federal Water Quality Administration, Department of the Interior. 1970. Design of water quality supveillance systems.
Lau, L.S. 1972. The quality of coastal wa ters: First annual pr-ogress report. Tech. Rep. No. 60, Water Resources Research Center and Sea Grant Program, University of Hawaii.
State of Hawaii. 1971. Senate Resolution Number 233. Honolulu, Hawaii.
APPENDICES
Department of Health Water Quality Date Recording Forms, 1955 - 1971 . . . . . . . . . . . . .
Water Quality Analysis, Format 01 Bacteriological Data (Index Cards), Format 02 Bacteriological Data (Index Cards), Format 03 Bacteriological Data (Index Cards), Format 04 Stations - Descriptive Data, Format 05 . Bacteriological Data (Sheets), Format 06 . Water Analysis Report (BWS), Format 07 . Bacti Data (Sand Island & Keehi Lagoon), Format 08 Bacti Data (Sand Island & Keehi Lagoon), Format 09 Water Quality Data, Format 10 . . . . . . . . . . Water, Chemical Analysis (Monthly Monitor), Format 11 Water, Chemical Analysis, Format 12 ...... . Water Analysis Report (Potable) - Maui, Format 13 Water & Waste Water Chemistry Report, Format 14 Monthly Summary of Bacteriological Analysis, Format 15 Water Analysis Report (Kauai), Format 16 ..... . Water Supplies (Potable and Nonpotable) . . . . Summary of Bacteriological Analysis of Water Samples
Examined at Waiakea Health Center (Hawaii) - (Potable and Nonpotable), Format 18 .....
Summary of Bacteriological Analyses, Format 19 Kauai Public Supplies, Format 20 . . • . . . Water Quality Data (Maui), Format 21 .... Maui Potable Water Bacteriological Analysis
Report, Format 22
Nutrient Analysis, Format 02 . Herbicides . . . . . . . . . . Organochlorine Analysis Trace Metal Analysis, Format 05 Biota Analysis, Format 06 Water Analysis Report, Format 07 •
.'
35
37
37 38 39 40 41 42 43 44 45 46 47 48 50
. 51 54 55 56
57 58 S9 60
36
Water Quality Monitoring Program, Format 02
U.S. Army, TripIer Medical Center
Effluent Data, Format 02
U.S. Air Force, Hickam
Drinking Water Quality Analysis, Format 02 Bacteriological Examination of Water, Format 03 Chemical Analysis, Format 04 . . • . . . . . • . Waste Water Surveillance Analysis, Format 05
78
· 78
80
80
81
DEPARTMENT OF HEALTH: WATER QUALITY DATA RECORDING FORMS 1955 - 1971
Format 01
Format number
Station number
Number 10 m1 portions showing gas
Number 10 ml portions confirming positive
Percent 10 m1 portions confirming positive
Coliform index - requirement - 1 (10%)
Coliform index - requirement - lC (5%)
37
38
ISLAND
Oahu
COLUMNS
1-3
4-5
6
7-10
11-16
17-24
25-32
33-40
41-48
49-56
57-64
65-72
73-80
Format number
Station number
Format number
Station number
Fecal coliform MPN, Fecal
Escherichia (plus or blank)
Format number
Station number
Coliform MPN
Format number
Station number
Name (alphanumeric)
Format number
Station number
Format number
Station number
Owner
41
42
ISLAND
Format number
Station number
Lab number
Total coliform
Fecal coliform
Format number
Station number
Number of samples with gas in 3 or more portions
Number of 10 m1 portions showing gas
Number of 10 ml portions confirming positive
Percent 10 m! portions confirming positive
Coliform index - requirement ! (10%)
43
44
ISLAND
Oahu
COLLMNS
1-3
4-5
6
7-9
10-19
20-29
30-39
40-49
50-59
# RECORDS
549
Format number
Blank columns
Station number
# RECORDS # PARPMETERS
1,045 8,360
FIELD TITLE? REMARKS
Format number
Blank columns
Station number
Format number
Station number
Format number
Station number
4- 5 Format number
7-10 Station number
Card 1: 17-24 pH
Format number
Station number
Date of sample. Where this date was not available, the date of the report was punched followed by a ")Sl", to indicate the date is approximate.
END OF DATA DUPLICATED ON CARDS 1 THROUGH 5
Card 1: 19-26 Temperature, °c 27-34 pH
35-42 Color
43-50 Odor
COLlJ+.IS
Card 2:
Card 3:
Card 4:
Card 5:
# RECORDS # PARAMETERS
10,922 163,830
KEYPUNCHING FORMAT
Format number
Station number
Format number
Card 1:
Card 2:
Date received
Time received
Lab number
Kjeldahl - N, mg/l
Total N, mg/l
BOD, mg/l
COD, II
Carbonate alkalinity, as II " Bicarbonate alkalinity, as CaCOs, mg/l
Total alkalinity, as CaCOs , mg/l
Total hardness, as
1,939 25,207
KEYPUNCHING FORMAT
Format number
Station number
Format number
Station number
Date received
Date examined
Lab number
MPN/lOO ml
SPC, count
2,368 30,784
KEYPUNCHING FORMAT
Format number
Station number
WATER SAMPLES EXAMINED AT WAIAKEA HEALTH CENTER
(HAWAII) - (POTABLE AND NONPOTABLE)
Format number
Station munber
Format number
Station number
ISLAND
Kauai
COLUMNS
1-3
4-5
6
.7-10
11-16
17-24
25-32
33-40
41-42
43-44
45-46
Format number
Station number
Format number
Secchi disc or turbidity (w/ HgC12)
Secchi disc or turbidity (w/out HgCl2)
Dissolved oxygen, mg/l
Total solids, mg/l
Fecal coliform, MPN/IOO ml
1-3
4-5
6
7-10
11-16
17-24
25-32
33-40
41-50
51-52
53-54
55-56
57-64
65-72
73-80
1-16
17-24
25-32
Format number
Fecal, No. t~bes out of 5 positive
442
COLUMNS
002 003 004 005 006
QCW 161 USGS 62 Hickam AFB 16 TripIer AMC 55 Sewers Division 22
KEYPUNCH INSTRUCTIONS FOR FORMAT 01
ITEM OR FIE LD I NFORMA. TI ON
Department number
District
INSTRUCTIONS
PHYSICAL
Number/hour
Number/day
Number/week
Number/month
Number/year
Other
CHEMICAL
Number/hour
Number/day
Number/week
Number/month
Number/year
Other
BACTERIOLOGICAL
Number/hour
Number/day
Number/week
Number/month
Number/year
Other
INSTRUCTIONS
COLUMNS
BIOLOGICAL
Ntunber/hour
Ntunber/day
Ntunber/week
Ntunber/month
Ntunber/year
Other
Remarks
Remarks
65
" " " "
" " " " " " " "
" " " " " " " "
Left justify. Abbreviate as neces sary; if no remarks, punch co1tunns 1-13 as indicated.
Left justify. Abbreviate as neces sary; if no remarks, punch co1tunns 1-13 as indicated.
66
COLUMNS
Format 02
NUTRIENT ANALYSIS
ITEM OR FIELD INFORMATION
Sol. potassium
WAT = water, SED = sediment
Format 03
ITEM OR FIE LD I NFORML\ TI ON
Department number (002)
Format number (03)
Right justify
Ametryne
Diuron
Bromaci1
Remarks
TR, TRACE = -.8
Format 04
ORGANOCHLORINE ANALYSIS
DDE
DOD
DDT
Chlordane
INSTRUCTIONS
WAT :::: water SED :::: sediment
Left justify
PCB
Mirex
Remarks
Format 05
Ar
Remarks
INSTRUCTIONS
" II " " " " " II
Fonnat 06
BIOTA ANALYSIS
Scientific name
INSTRUCTI ONS
Right justify
Right justify
BIO = biological
Right justify
la-digit number found on bottom of each sheet under REMARKS
ADDITI(X\IAL INSTRUCTION: WHEN + APPEARS IN ORGANISM ID NUMBER, LEAVE BLANK
73
74
COLUMNS ITEM OR FIELD INFORMATION I NSTRUCTI ONS
Card 3: 1-34 Same as Card 1 except card number is 3
35-41 Specimen total weight Left justify wi decimal
42-57 Portion " " 58-64 Weight of portion II " wi decimal
65-71 H20, m1 " " " " 72-78 Lindane, ppm " " " "
35-41 Heptachlor, ppm Left justify wi decimal
42-48 Heptachlor Epoxide, ppm II " " II
49-55 Aldrin, ppm " " " " 56-62 Dieldrin, ppm " " " " 63-69 DOE, ppm " " " " 70-76 DOD. ppm " " " "
35-41 DDT, ppm Left justify wi decimal
42-48 Chlordane, ppm " " " II
49-55 Chlordane. ppm " " " " 56-62 PCP. ppm " II f! " 63-69 PCB, ppm !I " " " 70-76 BHC, ppm " " " "
35-41 Pb, ppm Left justify wi decimal
42-48 Cu, ppm " " " " 49-55 Zn, ppm " " II " 56-62 Cd, ppm " " " II
63-69 Total Hg, ppm " II " " 70-76 Organic Hg, ppm " " II II
COLt.JvNS
Cr, ppm
Ni, ppm
As, ppm
Format 07
Turbidity (alphanumeric)
WAT = water
Right justify
77
Card 2: 47-52 DO
72-78 NHI+-N + Org.-N
35-41 NOa- N + N02-N Left justify wi decimal
42-48 Total phosphorus " " " " 49-55 Sol. phosphorus " " " " 56-62 Total potassium " " " " 63-69 Cl " " " " 70-76 Total carbon " " " "
35-41 Organic carbon Left justify wi decimal
42-48 Inorganic carbon " " " " 49-53 Total coliform, MPN/100 ml " It " " 78-80 Remarks "Yes" or "No"
ADDITIONAL INSTRUCTIONS
TR = -.8
ND = -.9
Format 02
Format number (02)
pH
Format 02
EFFLUENT DATA
KEYPUNCHING FORMAT
Format number (02)
Fecal COliform, MPN/IOO ml
Format number (02)
" " " "
Manganese
Nitrate
Alkalinity, CaC0 3
Format number (03)
Time collected
Month examined
Day examined
Year examined
Time examined
Format number (04)
Format number (05)
"" " II (alphanumeric)
Cadmium
70-74 Total hardness
75-79 Noncarbonate hardness
29-34 Sodium
35-38 Potassium
39-42 Calcium
43-47 Magnesium
48-50 Ammonia
51-54 Arsenic
55-57 Boron
58-60 Silica
76-80 Spec. conductance
29-31 pH
HAWIDISK KAUIDISK MAUIDISK OAHUDISK IBM Utility Card List
Format Reduction and Formation of Arrays
HAWIBC KAUIBC MAUIBC . OAHUBC Keypunch Corrections . Added Oahu Data Sample Output
Sequential Organization of Data
Data List
HBLST KBLST MBLST OBLST Main 'B' Array List Program Sample Output
HCLST KCLST MCLST OCLST
92 thru 112
115 thru 123
· 120 • 120
120 120
Statistical Analyses
HBAVE KBAVE MBAVE OBAVE Main 'B' Array Statistical Program. SUBROUTINE AVSDVA, 'B' Array. Sample Output
HeAVE KeAVE MCAVE OCAVE Main 'C' Array Statistical Program SUBROUTINE AVSDVA SUBROUTINE ORDER . SUBROUTINE SORT SUBROUTINE MEDIAN SUBROUTINE XYPLOT Sample Output
Station Catalogues
STATLST NEWSTAT
· 146 146 147 148
Procedure: Each program operates on its appropriate county data deck.
The program transfers the original punched card data onto the
disk titled 'WATERQ' in a card image format. A card image list
ing is printed to verify transfer.
IIHA~I~ISK J~B 12311A,2M,lKl.,'~fLLtRI
II~ HY ExEC PGM= I EBGENfR IISYSPPINT DO SYSDur=A II~YSIN or DUMMY I/~YSUT2 DO OSNWF.=HAWIZ.Hl,SPACC a CCYL,119,lIl,UNlhZ314, II 01SP=INhW,KEEPJ, II DCS=IRECFM=Fe,lRECL&80,BLKSlzr.1280.,VOL=SER.WATERQ IISYSUTl 00 ~ OtTA rF~K INS(RTtD HERE I. If
IIK4UWl5K JOB (23114,2M,lKII,'MIU"'" IISTIP EXEC PGM=IEBG£:NER IISYSP~INT DO SYSOUT-A IISfSIN nu DUM~Y 11~'SUT2 DO 05N~"E.KAUI2Jl1,SPACe-(CYl,114,l'),UNtT.2314, II OISP.IN~W,KEEPI, II cce.l~tCFM.FB,LRECL.8a,BlKSIZf"72801,VOL.Sr:PaWATEPQ 11515UTI 00 • 0'T4 CECK INSERTEO HERE I· /I
IIMAUIDI5K JOB 12311',2M,lKIJ,'MllLEP' IISTEP ~AEC PGM.I~BGlNER IISYSPP INT rr, SYSOUT"A IISYSIN OP DUMMY 1I:;,I5U12 DO DSNA",t=MAUIZ311 .SPACE-Icnd 16,11 hUNIT-Z314, II OISP:INr,w.K~Frlt II DC ~= (REe FM=F 8, til ECL"SO, BLK SIZF. .. 1280" VOLeS ER-WATERQ IISY5UT1 OP * DATA CfCK INSlRHO HERE ,. 1/
IIOAHU[lISK JOB (Z31U,2MtlKII,'MILlER' 115Tt'P exec PGMa[EBGFNER IISYSPFINT DO SYSOUT._ IISYSIN On OU~MY liS YS UT 2 00 OSNAME=OAHUZ311, SI'ACF. -I C YL, I 36,11 I. UN IT- 2314. II DISP=(N~W,KEEPI. II DC 8= II1ECFMaFa,lRECL"SO,8lKSIlE "72801, VOL-SElhWATERQ 115Y5UTI 00 • oaTA CfCK INS~RTEO HERE /. 1/
IIJOSN Joe 12311,8Kll,'JACKIE MILLER' II EXEC COTOPRT IIINPUT 00 DATA CARDS TO 81' LISTEO INSERTEO HERE I. /I
92
Program Names: HAWIBC, KAUIBC, MAUIBC, OAHUBC
Procedure: Each program operates on its appropriate county data set
as originally stored on the WATERQ disk. The 'BC' programs
create the two format, 'B' and 'C', arrays from the multi
format original data sets: two data sets for each county.
The special statements dealing with keypunch corrections are
included in these outputs for information purposes. These
statements are flagged with an asterisk '*'. The OAHUBC
program also provides an example of a listing of some addi
tional records which were acquired after the original cards
were entered on the disk and therefore are not included in the
original, multiformatted data set. The later records are
entered with this program into their proper position in the
'B' and IC' arrays. A few records from the first and last of
each new data set are listed to confirm complete transfer of
the entire data set to disk. A sample of this listing is
included at the back of this section.
IIHAWIBC JOB 12311,5M,5KL,lOKI,150KPI,'JACKIE MILLER' II EXEC FO~TCLG,RG=150K
I/SYSIN DD * OIME~SION AII,89I, H(1,30I, Cll,911 EXTERNAL SIGN DATA BLK/' 'I DATA PLUS IIH./ lEND .. () I END06 0 lfNDI2 0 tENDn 0 IENDIA 0 I END21 0
26 PFAO 18,100,£NO=9991 NDECK,NFIElD WRITE (6.1011 NOECK, NFIELO,IEND
999 CaNT I"JUE If INOECK .EO. 51 NFIELD .. 12 IF INOECK .EO. 6 INFIELD 33 IF INDECK .EO. 121 NFIELD 62 IF INDECK .EO. 13) NFIELD 52 IF (NDECK .EO. 141 NFIElD = 88 IF (NOECK .EO. 161 NFIELD 41 IF (NDfCK .EO. 181 "NflElD 38 IF (NDECK .EO. 211 NFIELD 58 IF (NDECK .EO. 221 NFIELD 59
25 fiO TO{61,62,63.64.65,66,61,68.69,10,1I,12,13,14.15,76,ll,18,19, 180,61.62), NDECK
65 READ 18,51 IAll,JI,J=I,NfIElO) IF IA(l,l' .GE. 999 •• AND. AII,21 .GE. q9.) GO TO 26 GO TO 25
66 READ 18,61 IAll,JI,J=l,NFIFLD' IF IAll,11 .GE. 999 •• ANO. A(I,21 .GE. 99.' GO 10 26 I~ND06 • IENDJ6 • 1
* IF 11EN006 .EO. 623 .OR. IEN006 .EO. 6251 9 READ 15,61 IAII,J',J-l,NFIElD'
00 400 Jzl,NFIElO 400 IF ISIGNIl.O,AII,JII.LT.0.O:AND.AI1.J,.FO.0,0'AII,JI=9.0E15
00 301 K .. 1,30 307 RII,KI= 9.DE15
00 308 l=1,91 308 CII,ll .. 9.0E15
CIt,81 .. o. Cll,91 .. O. CIl,IOI = O. (11,30 )-BlK Cll,lI .. All,!) CIl,Zl .. AI1,4) CIl.31 ,. All.5) (11,251 = A(I,6. Cllt41 " All,n Cllt6) .. AI1,81 cn.n .. AU.9) C(I,131 AII,IO) CIl,891 = Atl,31) C Ii • 90 I .. A I 1,3 2J Cll,91) s All.331 00 306 II .. 1,24 811,111 .. Clld.,
)06 CONT [NUE
DO 39 J = ll,21l IF (AI I.J I .EO. PLUSI BI1,26) .. 1. l '" J • 10 If IIIII,U .EQ. PLUS) 8( 1021) ,. 1. (11,87, .. B(1,26) Cll,88' .. Bll,27)
39 CONT INUE 811,2BI '" CIl,891 BIl.2QI = Cll.901 811.301 .. ClI.911 WRITE ell IBII,JI,J=l,301 WRITE (21 (C(l,JI,J=I,911 IF IIE~D06 .LT. 20 .OR. (IEND06 .GT. 620 .AND. IEND06 .LT. 626'
9 .OR. IEN006 .Gr. 9001 GO TO 3b8 , GO TO 25
368 wRITE Ib,6001 (Sll,J).J=l,301 WRITE 16,6011 ICll,JI.J=l,911 GO TO 25
72 PEAO IA.12) IAll,JI,J=I,NFlfLO) IF IAll,11 .GE. 999 •• ANO. AIl.2' .GE. 99.1 GO TO 26 IENDI2 = 110"41)12 + I
399 DO 401 J=I,NFIELO 401 IF (SIGNll.O,All,Jl l.ll.O.O.AND.AI 1.JI.EQ.O.O)All.JI=9.0E15
DO 325 K .. 1030 325 Bll ,K) ." 9.0ElS
00 335 L " 1,91 335 Cll,ll = 9.0E15
C I 1 .8) : o. Cll.9) '" O. CllolO) .. O. CIl.30l:8lK Cet"l = Alltll CI1,21 = AI1031 CIl,31 " A(1,4) DATA DATE /2H 1/ IF 1A11.SI .EQ. DATE) CCltll .. IC( 1,3. '" I-U I Cl,,311 All,61 C!loll! " All.7I Cll,521 = AII,81 Cll,53) " AI1,91 C I 1 • 34 I All, 101 Cll,44' " All,111 Cll,45) '" All.121 Cll,541 All,181 Cll,551 All,19) Cll,561 MIr20) Cll,511 A(1.211 CI1,581 .. AIl,221 CII.3BI " A(I,231 C(l,591 " A(l,241 C(l,60) '" A(l,30' Cll,611 .. All,311 Cll,62' .. All,32' CIl,b31 All,331 C(I.64, .. All,34. C(1.65) " All,35) Cll.661 A(1,36' Cll,61' .. A(I,421 C(I,66l ~ All,431 <.0
tN
C{l,69) - 411,44) Cll.70'" 411.45) C ( 1.71) ,. All, 461 (11.72) : 411,47, C lit 131 ,. A II, 48) (11,14) = ACl,54) Cll,75' a A11,55) Ctl. 76) ,. AI1,56' C(I,77) .. A(I,51) CIl.78) All,581 Cll,79) ,. A(I,59) (11.89) A11,60) (11,901 • All,611 Cll,911 .. 411,62) flO 312 II ,. 1,;>4 Btl,!!) '" CIl,III
312 CONTINUe Bll,281 ,. (11,891 811,29) ,. Cll,9al III 1.30) " (11. 'H I WRITE III IBIl,J)'J=lt301 I>PlTE 121 ICCl,JI.J=I,911 WRITE 16,6051 IB{I,JI,J=l,301 \tRUE .16,6061 I(ll,JI.J'"I.911 If IIFNOI2.EQ.ll GO TO 5ao GO TO 25
500 PFAO 18,1201 IAll,JI,J=l,NFJflOI READ 15,121 IAll.JI,J=l,NFIELOI IEND12 ,. IENOl2 • 1 GO TO 399
74 RfAO 18.141 IAII,JI.J=l,NFJELOI IF IA(1.1) .GE. 999 •• AND. A11.21 .GE. 99.1 GO TO 26 00 403 J=I,NFIFlO
403 IF ISIGNll.0.All,JII.lT.0.O.AND.AI1,J).EQ.O.0IAll,JI=9.0E15 00 321 K ,. 1,30
327 Rll,K) ·9.0E15 on 331 l " 1,91
337 Cll,ll 9.0E15 CIl,81 O. (11,9) " o. (lidO) = o. (II,3a) '" O. cn,ll "" Anti) (11,21'" All,41 CIl,,) = All,S' Cl1,261 All ,61 (11,271 ,. All,7I ( 1,26) ,. All,8) ( 11 ,30 I '" All, 91 CII .41 All.tOI (11,311 All,111 Cll.11) .. All,12) (11,;2) All,13) CIl,531 All,14) CIt"S' '" All.201 CI 1,381 All,211 (11.591 A11,22. Cll,411 A(l,?3) (11.421 A(1.241
Ctl,431 All,251 (11,44) A(I.261 (11.451 .. All,27) Cll,471 s All.331 Cll.48) '" A(l,341 CI 1. 49) .. All, 35) ((1.511 .. AI1.361 Cll.331 All.37) CIl,RD) All,381 Cll,8l1 A11,39) (1.541 .. All,401 Cll,S5) .. All,461 CIl,561 .. 1111,41) Cll,57) All,481 (11.56) AI1,49) Cn,60) All ,501 Cll.63) .. AIL,511 ((1,1>4) All,521 (ll,6~) All,511 (11,66) AII,~9)
C11,67) All,6JI (11,681 All,611 ((1,691 All,621 (1i,7l) ACl,63! Cll,721 ., All,641 Cll,131 All.1>5) (11,741 All,71) Ctl,751 All,l2) CIl,761 '" IIIl,n! Cll,17) .. All,741 ( 11 , 78 I A I I ,751 C I I , 79 I II I 1 ,76) CCl,B21 A(l,17) CII,83) 1111,181 CI 1,84 I ., At 1 ,841 Cll.851 All,85' Cll,89, AII,S61 CIl,901 .. All,811 (11.911 ., All.881 00 314 II .. 1,24 Blldll ,. (11,1"
314 CONTINUE Bll,281 " (ll,89J 1311,291 ,. Cll,')')) 611,30) ~ Cll,'lll wRITE III ISll,JI,J=1,301 WRITE (2) ICll,JI,J:l,9U WRITE 16,6001 ISll,JI,J=1,30' WRITE 16,604) ICll,J).J=l,'l11 GO TO 25
78 READ 180181 (All,JJ,J=I,NFIElOl If IAII,II .GE. 999 •• ANO. All,21 .GE. 99.1 GO TO 26 00 407 J=I,NFIElO
~07 IF ISIGNll.0,All,JII.lT.0.0.ANU.All,J,.EQ.O.OIAII,J'z9.0E15 IENOl8 IENOIS. 1 00 367 K = 1,10
367 Bll,K) 9.0E15 Rct,81 o. BIl,91 o.
\D .j;:o.
Bll,10' .. O. BUdl = All,lI 811.2' = AI1.41 All.31 .. All.51 611.41 .. ACl.6J IH1.51 AI1.1I 611,121 = AIl,8' I'll 1'.M " All,91 611,1{1 .. A(1.101 sn,1) = AIl.lll DO 46 J = 1201 'l IF IAIl,JI .EO. PlUSI B11,25 •• 1. K=J+8 IF IA(I,KI.EO. PLUS' 811,261 '"I. l " K + 8 IF (All,l) .EO. PLUS' Bll,21' • 1.
46 CONT INUE 811,281 .. 411,36, 811,Z91 " 411,31) Bll,301 " 411,38, WRITE (11 (811,JI, J"I,301 IF (IEN018 .LT. II .OR. lENOla .GT. 195001 WRITE 16,6001
9 (BI I,JI,J=l, 3.:11. GO TO l5
100 FOPMATo'14,161 101 FORMAT 11X,14,16,IIO' 120 fORMAT 15180X/lI
1 FORMAT IF3.J,F2.D,Fl • .:I,F4.0,F6.0,8F8.0.Tl1.3F2.01 2 FORMAT lF3.0,F2.0,Fl.0,F4.0,F6.0,F8.0,lE8.0,3IA4,4XI,
9 ZFB.O,Tl5,16Al,T11,3F2.01 3 FORMAT (F3.0,F2.0,Fl.0,F4.0,f6.0,f8.0,2E8.0,31A4,4XI,
9 2F8.0,T25,16Al,Tll,3F2.01 4 FOPMAT IF3.0,F2.0,Fl.0,F4.0,F6.0,fS.O,2EB.O,3IA4,4XI.
If3.U,fl.O,Fl.O,F4.0,70XI 2F3.0,F2.0.Fl.O.F4.0,10XI
1 FOPMAT If3.0,F2.0,fl.O,F4.0,F6.0,Bf6.0.TII,3f2.01 S FOR~Ar I F3.J,F2.0,Fl.O.F3.0,F4.0.6X.F6.0.4X,2EI0.0,FlO.O,T30.
q 20Al,T20,3F2.0, 9 FO~MAT I F3.0,F2.0,F1.0,3X.F4.0,6X,F6.0.4X.2EIJ.O,f10.0.T30.
9 20Al,T20,3F2.01 10 FOP MAT IF3.0,F2.0,Fl.O.f4.0,F6.0,fS.O.fQ.O,FI0.O,F9.01
9 f3.0,F2.0,fl.~,F4.0,F6.0,4fll.0,FB.O,Fll.0.Tll.3f2.01 11 FO~MAT IF3.0,F2.0,Fl.O,f4.0.F6.0,BFB.OI F3.0,f2.0.fl.0,F4.0.
q f6.0.2FB.O,Tll.3F2.01 12 FORMAT (F3.0,F3.0,F4.l,F6.0,A2,1FB.O/
1 F3.0.F3.0.F4.0.f6.0,A2,1FB.0/ 2 f3.0,f3.0,F4.0,f6.0,A2,7FB.OI 3 F3.0,F3.0,f4.0.F6.0.A2.4fB.O.FIO.O,2F~.OI 4 F3.0,F3.0.F4.0,F6.0,Al,6FS.O, T11,3f2.0J
13 FORMAT If3.0,f2.0.Fl.O,f4.0,F6.0,3FB.0,ElO.O,3A2.ZES.O,f8.0, 1 T33,ISA1,T57,16A1, fll,3f2.01
19 FOPMAT IF3.0,FZ.O,Fl.0.F4.0,F6.0,4F8.0,3Al.2F8.0.F2.0. 9 T33,16Al,Tj5,BA1,rll,3F2.01
IF3.0,F2.0,Fl.O,F4.J,F6.0,8F8.01 2F3.0,F2.0.Fl.O,F4.0,F6.0,F8.0,2FI0.0.fB.O,T25.lI10All,Tll,3Fl.O)
601 FORMAT IIX.1F12.3,)A4/ 2(lX,8F12.3/"IX,3F12.3,2X.A4. 9 4FI2.3/6(lX,8FIZ.3/I,IX,3FI2.3,3Ifl.J,ZXI,3IF3.Q,2X1J
602 fORMAT 11X,F4.~,2X.F3.0,2X,f2.0,2X,f5.0,2X,F4.0,2X,F3.0,2X, IF2.0,2X.F5.0,2X,F4.0,2X,F3.0.2X,F2.0.2X,F5.01
606 FORMAT (IX,2Fll.3,FlO.O,4F12.3,3A4/ Z'1~,SF12.3/).lX.3F12.3,2X.A •• 9 4F12.3/6/1X,8F12.3/,.lX.3Fll.3,3IF2.0.2X,,3IF3.0.2XJ)
61 READ (5,23) DUMMY 62 PEAD 15,23' DU~MY 63 READ (5,23) DUMMY 64 READ 15,231 DUMMY &7 READ 15,231 DUMMY 68 PEAD 15,231 DUMMY 69 READ 15,231 DUMMY 70 RFAD 15.23, DUMMY 11 READ (5,23) DU~MY 73 REAO 15,23' DUMMY 75 READ 15,231 DUMMY 1& READ 15,23' DUMMY 11 READ 15,23) DUMMY 79 READ 15,231 DUMM~ SO READ 15.23, DUMMY 81 QFAO (5,23' DUMMY S2 READ (5.23, DUMMY 23 FOPMAT 180XI
355 CONTINUE END
IILOAD.SYSLIN 00 OSNAME=SYSl.6MOXlIBISIGN •• OISP=SHR, II UNIT=2314,VOL=SER~UHSYS5 ~
UO
01.30 01.25 27. o. 27. lO. -0.05
1176. 1399. 7.3 O.
-0.01 2.00 480. 160. 14.6 21.ft
-0.010 0.16 -0.00 I
IIKAUIBC 1/ EHC IISYSIN 00 ..
JOB 12311,4M,6KL,4Kl.15CKRI.'JACKIE MilLER' FORTCLG,RG=150K
DIMENSION AII,891, Bll,30l, CIl,911 EXHRNAL SIGN DATA flLKIlH I DATA PLUS IIH+I tEND % 0 I fN005 0 I fNDO& 0 IENDI1 0 IENOll" 0 lEND 14 0 IENDI!> a I!'NDII> " 0 11:111017 0 IFN018 0 IFNOl9 " 0 IfNOZJ 0 I EN021 0
l6 REAO 18,lOO.ENU-9991 NDfCK,NFIElO WRITE 16,1)11 NOECK, NFIELO.IENO
999 CONTINUE IF INDEtK .EO. 51 NFIElO " 12 IF INUECK .Eg. 6 , NFIELO " 33 IF IN0EtK .Eg. 121 NFIElO 62 IF INDfCK .EO. 131 NFIElO 52 IF (NOEC,", .EQ. 14) NFl ELO " 88 IF (NOECK .EO. 151 NFIElO " 32 IF INDEtK .EO. 161 NFIElO " 41 IF "WECK .EU. 171 IIjFIELO '"' 32 IF INUFCK .EQ. 18' IIjFIElD 38 IF INIJFCK .EO. I'll NF1ELD 42 IF (t.;[)ECK .EO. lOI NFlELO 30 IF (NDECK .EQ. 211 NFIElO 58 IF (NOECK .EQ. 221 NFIELO 59
25 GO TO(61,62,63.64,65,66,67,68,69,70.71.12,73.74.75,76.77,78,19, 180,Bl,A21, IIjUECK
65 !HAD 18.51 IF I Al 1.11 .GE. tEN005 = IENU05
* tf I (EN005 .EO. GO TO 25
(All,JI.J=l,NFIELD' '199 •• AND. AI It 21 .GE. 99.) GO TO 26 + 1 1461 READ 18,241 IAI t.JI .J-l,161
12 READ 16,121 IAI1,JI,J"l,NFIElDI IF IAlld) .G!:. 999 •• ANO. All,21 .GE. 99.) GO TO 26 OU 401 J=I.t.;FIElD
401 IF (SIGIIj(1.J,A(l,JII.Lr.O.O.ANO.AI1,J).EQ.O.0IAlltJ)~9.0E15 IEN012 IEND12 + 1 DO 325 K - 1,30
325 Rll,KI " 9.0E15 00 335 L - 1,'l1
335 C11,l) " 9.0El5 Ctl,3'11=IlLK Ctl,BI ,. O. (11,91"0. Clltl)1 = O. Cll.U = Alloll (1t,21 '" All,)) Cll,31 " AIl.4)
1.0 Q'\
DATA DATE 12H 11 IF IAll,51 .EQ. DATEt Cll,31 z IC11,31 • 1-111 (11,311 • AIl,6t Cll,111 $ All.71 Cll,521 = A(l,81 CIl.531 = 411,9, (11.341 & All,lOI Cll.441 = A(1.111 C11.451 = AIl.121 (11.541 All.181 Cll.551 = All,191 C11.561 • All.201 Cll,57' : 411.211 Cll.561 = All.221 Cll.381 & All.231 C(l,59' • All.24) (11.601 = All.30' C11.611 • A(I,3l) (11.62' All.321 Cll,63' = A(1.33) (11.641 z All,34) (1,651 = A(I,351 Cll,661 = All,361 Cll,67) z AII,421 C11,681 • All,431 C(1,69) = 411,441 Cll,7JI All.451 Cll,711 All,46' (11,72) = AIl,471 CI1.73) All.48) Cll,741 & All,541 ell,751 All,551 (11,761 All,561 Cll,771 = All,511 Cll,181 = All,581 '(1,791 • All,591 Cll.891 = All,601 (ll.9~1 = All,611 (11.911 • All,621 DO 312 II • 1,24 611,111 = C(I.III
312 CONTINUE 811,281 = Cll,891 811,291 ~ e(1.901 811.301 • CII,911 WRITE 411 IBll.JI,J=I,301 WRITE (2) ICIl,JI,J-l,911 IF IIEND12 .LT. 6 .OR. IEN012 .GT. 1~51 GO TO 360 GO TO 25
360 WRITE 16,6051 1811.JI,J*1.301 WRITE 16,6061 (CI1.J •• J=l,911 GO TO 25
14 READ 18,141 IAI1,JI.J=I,NFIELDI If (All,11 .GE. 999 •• AND. All,21 .CE. 99.1 GO TO 26 DO 403 J·l,~FIELD
403 IF ISIGNII.O.AII,JII.LT.O.0.ANO.A(l,JI.EQ.0.0IAtl.J'.9.0E15 IENOl4 IENDI4. 1 DO 327 K " 1,30
327 811,K) " 9.0E15
DO 337 L .. 1.91 337 CII,ll .9.0EI5
CIl,81 O. eU,91 " O. CliolOI " o. Ctlo301 .. O. Cll.1I .. AIl.II (Il,ZI " AI1.41 CIl.31 .. AIl.51 (11.26' • All,61 (11.271 .. AI1.7I Cl1,281 .. Al1.8' C « I, 30) .. II I 1 • 91 Cll,4) ,. All,lJI CI1,311 .. AlttlU Cllolll AIl.t2J CII,521 .. All.13) CIl,53) All.14' Cll.35) .. All.20) CIl.3Q) All.211 Cll.59, All.22' (11.41) .. AIl,B' Cll.42) • AII.24' (11.4)1 .. All,25' CI1,44, = All,261 Cll,45) s All.271 CIl,41' AII,331 Cll.481 .. All.341 (11,49' .. AIl,351 CIl,511 .. All.361 Cll,331 .. All,371 C11.801 " All.38' CII.811 All.)91 Cll,541 • AII,401 (11,55) = 411,46' Cll.56) " 411.47' CII,571 • 4(1,481 (11,581 = All.491 (11,601 All,5)1 el1,631 % All,511 CI1,641 • All,521 Cll.65) A(1.531 Cll.661 • All,591 Cll,611 All.601 Cll,bIIl .. All.611 '11.691 4(1,621 Cll,711 .. A(l,631 C(l,721 .. All.641 C(1,73) " ACl,b51 CI1,141 .. AIl,H) ell.751 • AII,lll Cll,76' • AIl.131 C(I,11) s A(I,74) Cll,781 z All.751 ell,191 • 4(1,76' Cll.821 • A(1.111 (11,831 .. All.181 (1I,8~' • All,84, Cll.851 All.851 (.0 .....,
C11,891 '" AIl,8b' CI1,901 2 AI1,87' Cll,91) "" All,88) 00 314 II ,. 1,24 All.111 '" Cll,lll
314 CONTI NUE B11,2~1 '" Cll,89' 811.29) '" Cll,901 B I 1 • )0 I '" C ( 1 ,911 WRITE It I 1811,JI.J=1.30) WPITF 121 ICll.J),J=1,911 If IIENU14 .LT. 6 .OR. IEND14 .GT. 45, GO TO 361 GO TO 25
361 WRITE 16.6001 IIHI,J'.J=1,301 WRITE 16,6J4) ICII,JI,J=I,911 GO TO 25
75 PE~O 18,151 (AII,JI.J=l,NFIELDI IF (Al1,11 .GE. 999 •• AND. All.21 .GE. 99.' GO TO 26 I£NOI5 ,. IENDI5 + 1 00 411 J=l,NFIELO
411 IF I SIGNll.O,All,JII.LT .(l.O.AND.A( 1,JI.EQ.O.OIA( 1.JI,.Q.OEl5 00 346 K '" 1,30
346 ~(I.KI ,. 9.0E15 ~Il .81 " O. 60.91 " O. Bl1.10) =0. fHld) All,t1 AI1,2' = AIl,4' £lllt3' " AIl,5' 811.41 '" All,6' BII,II' '" AII.1. 811,bl " AII.SI 811,51" AU,'H BIl,8) " AlltlO) 811dJ) " AII.tll Bll,91 " A'I,lll 811,12) AIl,lll IIU,28} " ~II,301 BIl.29, ., AI1,3!1 Bll,30) " AIl,321 DO 347 J " 14,21 IF ltd l,J} .EO. PluSI BI1,261 1. K " J i' 8 IF IAll,KI .EO. PLUSI Bll,251 = 1.
347 CONTI"lUf WRITE III IBll,J',J=l,3:l} IF (IENOIS .LT. 11 .OR. IENDI5 .GT. 19301
9 WRITE (6.6001 1811,JI.J:I.301 GO TO 25
16 PEAO (8,161 IAll.J},J=I.NFIELDI IF 1 AI ltll .GF.. 999 •• AND. AU,?) .GE. 99.1 GO TO 26 IEN016 " IE~016 + 1
399 DO 404 J=I.NfIELD 404 IF ISIGNll.0,All,JII.LT.0.O.ANo.AIl,JI.EQ.O.0)AI1,JJ=9.0E15
00 315 K '" I, 30 375 Bll,KI .. 9.OE15
DO 376 l z 1,<11 376 Cll.ll " 9.0E15
CU,30)=8LK
Ctl,8) " O. CII.91:0. Cll,101 " O. CI1,l1 " AlltIl C(1,21 " Al1.4) CII,l} = AIl,51 CIl,21} '" AIl,61 Cll,291 " AIl.71 (11,41 AIl,8) C{I,1lI .. All,91 CIl,51 " All,lO} Cll,71 = AIl,ll) Cll.lll " A(I,121 CIl,121 AII.D. Cll,13} All,14' CIl.89) AIl,391 CIl,9J)" 4(1.401 CI1,911 AII,411 DO 342 II " 1 .... 4 Rll.II1 " Cll,111
342 CONTI r-<UE on 343 J " 15,22 If IAll.J' .EQ. PLUS) B(1,261 " 1. K = J ... 8 tF- 1411,KI .EQ. PLUS, Bll,251 .. 1. l = K + 8 IF IAIl.l) .EO. PLUS) BIl,2:71 .. 1.
343 CONT INUE (ll,86) B{1,251 CII,81) 811,261 CIl.881 " 811,211 RII,ZS. CIl,891 8(1.29} (11,901 Bll.3')' CIl,'H} WRITE 11. IBll,J •• J=I,30) WRITE 121 (C(1,J),J"1,91)
* If IlEND16 .EQ. 314) GO TO 500 IF IIENDI6 .Lf. 11 .OR. IENol6 .GT. 3200) GO TO 362 IF IIENDI!> .GT. 312 .AND. IEND16 .LT. 3181 GO 1'0 362 GtJ TO 25
500 REAO IR,1601 IAll,J),J=I,NFIElOI READ 15.161 I AI l,JI,J=l,NFIELOI IEr-<Olb " IENUl6 + 1 GO TO 399
362 WR HE 16,60)} I BII.J 1 .J"lt301 WRITE 16,6011 IC(loJI,J=I,9l) GO TO 25
77 READ 18,17) IAll.Jl,J=l,NFIElOI If 1 All, 11 .GE. 999 •• A"IO. Al l,l I .GE. 9Q.1 GO TO 26 IEN017 " IENOl1 • 1 DO 413 J"l."lFIELO
413 IF ISIGNIl.O,All,JII.lT.0.O.ANO.A(I,JI.EQ.O.OIA(1,JI-9.0El5 00 344 K"I.30
344 811,KI " 9.JE15 BIl.S) .. O. 1\11,9, " O. fllltlO) " O. Blloll 411,11 Be 1,2' = All,41
\.0 00
611,31 AIl,5' 811,4' " AI1,&' 611,51 '" Allt7) 811,61 '" All,81 Bll,BI AI1,91 811,101 " All,10' Bll,91 : A(l,111 811,1Z' " AI1,12, Bll,lll A11,13' 611,281 = All,301 6'1.291 a All,311 Bll.301 « All,32' 00 345 J .. 14,11 IF IAll,JI .EO. PLUSI BIl,151 1. L • J .. 8 If tAl toll .EO. PLUS' 611,261 '" 1.
345 CONT'''IUE WRITE III IBCl,J)'J.l,301 If ([Eli/Oil .LT. 11 .OR. IEN017 .GT. 2360'
9 WRITE 16,6001 IBll,JI,J=l,30, GO TO 25
79 READ 18,19) IAll,JI,J-t,NFIElOI IF (All,l) .GE. 999 •• AND. All,ll .GE. 99.1 GO TO 26 [EN019 • IEN019 + 1 n~ 414 J=I,NfIELO
~t4 IF ISIGNI1.O,AII,JI'.lT.O.0.ANO.AI1,JI.EO.0.O'All,Jl z 9.0E15 DO 353 K .. 1,30
353 811,KI '" 9.0f15 00 348 L"I,91
3.8 Cll,ll " 9.0El5 C I It 30 ':!lLK C( 1,BI .. O. CI1,91 " O. C(1,lOI .. O. C[ 1,11 All, 11 elt,ll" A(1,41 CI1,31 .. AIl,51 CI1,41 .. A(1,61 ((1tltl .. 11(1,11 (11,61 .. All,8' (tl,5) '" AIl,91 Cll,81 .. All,tol Cl1,lOI = AI1,111 Cllt'H " Alltill Cll,7I = AIltl31 C\l,12) '" AIl.141 Cll.521 z All.151 (11.891 a All,401 Cll,901 ,. AI1,411 C(I,911 .. All.421 00 349 II ., 1,Z.
3 •• Sll.111 = C11,[11 DO 350 J .. 16,23 IF IAll,JI .EO. PlUSI 811.261 '" 1. K = J + 8 IF IAll,KI .EO. PLUSI 811,251 "' 1. l .. K + 8 If IAll,LI .EO. PlUSI 811,211 = 1.
350 CONTINUE
C(l,861 = Bll,251 (tl,611 '" B(l,26' C I 1,88 I = B II, 211 Bll.281 a Cll,891 RIl,791 = Cll,901 Bll,301 • Cll,911 WRITE III ISIl,JI,J=l,'O' WRITE (21 ICll,JI,J=I,911 I~ (IEN019 .LT. 11 .OR. IENOl9 .GT. 34001 GO TO 363 GO Tn 25
363 WRITE (6,6001 IBII,JI,Jal,301 WRITE 16,6011 (Cll.JI,J=I,911 GO TO 25
80 RF~O 18,201 IAll,J),J.l.NFIElDI If IAII,ll .GE. 999 •• AND. A(l,21 .GE. 99.1 GO TO 26 {ENOlO ., IEN010 • 1 nn 415 J"I,~FIELO
415 IF ISIGNI1.O,AII,JII.Lr.O.0.ANO.All,JI.fQ.0.0IAI1,Jla9.0E15 DO 351 K"I,30
351 Rl1.KI '" 9.~E15 BI1,81 ,. O. Bll.9) .. O. Bll,101 .. o. 811t11.= All,11 BII.21 All,41 BIl,31 .. All,S' [111,41 " AIl,bl 811.51 All.71 611,&1 .. AU,81 811,8' All,91 811,101 ., AIl.lJI Bll,91 ., All,111 811.2BI ., All,18' 811.1'})" All,291 B(1.301 .. All,301 DO 351 K a 12.19 IF IA( loKI .EO. PLUSI BIl,251 - t. L '" K + B IF IA( 1.1I .EO. PLUSI BI1,161 .. 1.
351 CONTINUE W~ITE III 1811,J).J=1.301 IF IIEN020 .LT. 11 .OR. (EN020 .GT. 1145'
9 WRITE 10.000) 1811.JI,J-l,301 GO TO 7.5
100 FORMAT C14.lbl 101 fORMAT (lX,14,16.fl01 IbO fORMAT ISOX)
1 fORMAT IF3.J,F2.0,Fl.O,F4.0,F6.0,8F8.0,Tll,3F2.01 2 FORMAT If3.0,F2.0,Fl.0.F •• 0.F6.0,F8.0,lE8.0,3IA~.~XJ.
9 2F8.0,T25,16111,Tl1,3F2.01 3 FORMAT If3.0,F2.0,Fl.J,F4.0,F6.0,F8.0.2F.8.0,3IA4,.X).
9 lFS.O,T25,16Al,Tll,3F2.01 5 fOP MAT If3.0,f2.0,Fl.O,F4.0.10XI If3.0,f2.0,Fl.J,f4.l,10KI 2F3.0,Fl.O,Fl.O,F4.0,10XI
24 FORMAT tF3.0,f2.0.Fl.O.F4.0,70KI If3.0,f1.0,Fl.J,F4.0,10XI 1.0
1.0
7 FORMAT IF3.0,F2.0,Fl.O,F4.0,F6.0,SF6.0.tll,3F2.0) 8 FORMAT IF3.0.F2.0,Fl.O,F3.0,F4.0,6X,F6.0,4X,2ElO.O,F10.O,T30,
9 20AI.T2J.3F2.0) 9 FORMAT <F3.0,F2.0,Fl.0,3X,F4.0,6X,F6.0,4X,2EI0.0,F10.O,T30.
9 20Al.T20,3F?01 10 fOP MAT (F3.0,F2~O,F1.0.F4.0,F6.0.FB.C,F9.0,FIO.O,F9.01
9 F3.0,Pl.O.Fl.O,F4.0,F6.0,4Fll.0.F8.0.Fll.O,Tll.3F2.0) 11 FORMAT IF3.0,F2.0,Fl.O,F4.0,f6.0.8F8.01 F3.0,f2.0,fl.O,F4.0,
1 F3.0.F3.0,F4.J,F6.0,A2,7FB.O/ 1 F3.0,Fl.0,F4.0.F6.0,A2,IF8.01 3 F3.0.F3.0,F4.0.F6.0,A2,4F8.0,FIO.O,2fa.OI 4 F3.0,F3.0.F4.0,F6.0,A2,6F8.0, Tll,3f2.0)
13 FOPMAT (F3.0,F2.0,Fl.O,F4.0,f6.0,3F8.0,E10.0,3A2,lEB.O,F8.0, I T33,1811,T51,16Al. Tl1,3F2.01
9 T37,318All, Tll.3F2.01 11 FOP~AT {F3.0,F2.0.FI.O,F4.0,F6.0.FS.C.2E8.0,3A2,2F8.0,T25,16A1.
9 fl1,3F2.01 18 FORMAT IF3.J.F2.J.Fl.0.F4.0,F6.0.3IF€.O,E8.0),T25,8Al,
9 T41,8Al,T51,8AI, Tll,3Fl.01 19 FORMAT If3.0,Fl.O,Fl.0,F4.0,F6.0.4F8.0.3A2.2F8.0,F2.0,
q T33,16Al,T55,8Al,Tll,3F2.0) 20 FOPMAT (F3.0,F2.0,fl.O,F4.0,F6.0,3FB.O,3A2,T25,16Al,Tll,3F2.0I 21 fO~MAT (F3.0,F2.J,Fl.J,F4.0,F6.0,8F8.01
601 FORMAT 11X,7Fll.3,3A4/ 211X,BFll.3/I,lX,3F12.3.2X,A4, 9 4F12.3/611X,8F12.3/1.1X,3F12.3,3IFl.O,ZXI.3IF3.0.2XII
602 FO~MAT IIX,F4.0,2X,F3.0,2X,F?O,2X,F5.0.2X,F4.0,2X,F3.0,2X, IF2.0,2X,F5.o.2X,F4.0,2X,F3.0,2X,F2.0.2X,F5.01
606 FOPMAT 11X.2F12.3,flO.O,4F12.3.3A41 211X,8F12.3/),lX,3F12.3.2X,A4. q 4Fll.3/611X,8F12.3/1,lX,3F12.3.)IF2.0.2X),3IF3.0.lXI)
61 CO~TI~UE 62 CONTINUE 63 CONTINUE
I.
64 CONT INUE 66 CONTINUE 67 CONT INUE 68 CONTINUE 69 CONTINUE 70 CONT INUE 71 CONT IN

water quality information storage and final report

Documents