7419

• UCREFRP Catalog Number: 7419
• Author: Valdez, R. A., et al.
• Title: Summary Documentation and Preliminary SI Curves, SI Curve Development Project.
• USFW Year: 1987.
• USFW - Doc Type: Logan, Utah.
• Copyright Material: NO

I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I

TASK A: DATABASE ASSIMILATION

TASK Oanx:rlVES

The ~ of Task A was to assimilate the datamse, and SUJIIllat'ize and
document the canponent data sets. The specific objectives of Task A were to:

1. Assimilate the data provided by FWS.

2. Develop a concise sumnary of each data set, including study documen-
tation.

3. Provide SUI1I1Iary tables of the endangered fish and associated habitat
information fram the assimilated data.

4. Locate and summarize available documentation for 51 curves that have
been developed in previous studies.

Objective 1: Database Assimilation

Methods. The data "-Ere received by BIO/~ primarily from the FWS in
about 40 canJ;11terized source files. These files were in a variety of formats,
containing over 100,000 records or lines of information. Data representing
1964-1984 were received fran FWS in a database previously assimilated by the
COlorado Water Congress called ~/DATABASE (Valdez and Ryel 1984). The files
in this database "-Ere in a ccmnon format that made it easy to access, retrieve,
and store records. For the period 1979-1986, data used "-Ere those received
directly fram FWS instea:i of that stored in C~/DATABASE, because of possible
updates by that agency. Therefore, data prior to 1979 were taken trom CJiJC/DA-
TABASE, and the rest "-Ere secured directly from FWS.

When the data were received by B10/WEST, they W':!re checked for consistency
of fieldnames and codes, and related to a documented study. Most of the data
W':!re provided in dBASE III+ format. The data W':!re then entered into a single
database with a camlOl1 format, called FWS/DATABASE. This database was then
reduced to a working database of alxmt 8,000 records containing depth, velo-
ci ty , or substrate rneasuranents on the three target fish. Data discrepancies
and errors were identified and corrected, and the collectors of the data W':!re
contacted, whenever possible.

Results. The datamse is defined as all of the available data collected
in the upper COlorado River Basin that either qualitatively or quantitatively
describe thehabi tat used by the COlorado squawfish, hump1:ack chub, and
razortack sucker. The data assimilated by BIO/~ for this project spans a
period of 23 years, fran 1964 through 1986, and includes the collections of 17
principal investigators.

Data provided by FWS included collections by that agency, Bureau of
Reclamation, COlorado Division of Wildlife, Utah Division of Wildlife Resour-

3