Appendix

Tables 9 through 125

(Included on the data CD)

Read-Me File:

Biological Assessment of Streams in the Indianapolis Metropolitan Area, Indiana, 1999-2001

Water-Resources Investigations Report 03-4331

by David C. Voelker

Prepared in cooperation with the Indianapolis Department of Public Works, Office of Environmental Services


APPENDIX - (Data CD)

Benthic-invertebrate (tables 9-90) and fish (tables 91-125) data collected throughout the study are presented on this CD. All tables are presented in Microsoft Excel format.

Tables showing the benthic-invertebrate data for each site are listed in tables 9 through 90. Benthic invertebrates were identified to genus and species or the lowest taxonomic group possible. Samples were collected at three stations in the streambed; each sample was analyzed separately by the contract laboratory. Data from the three samples then were combined to describe each site. 

Information in each table includes site name; USGS streamflow-gaging-station  number; date and time of sample; and water temperature, specific conductance, dissolved-oxygen concentration, and pH at the time of sampling. Total number of organisms; number of distinct taxa; and Ephemeroptera, Plecoptera, Trichoptera  index scores are summarized for each of the three samples collected at each site. Similar data are given for the combined samples to determine the totals for the site. The Hilsenhoff Biotic Index score also was calculated and is presented in the data tables. 

The number of distinct taxa was arrived at by counting each taxon for which individual organisms were identified at a site. Similarly, the number of taxa in the orders Ephemeroptera, Plecoptera, and Trichoptera (EPT) were summed to determine the EPT index for each station and site. If identification to species was not possible and similar organisms from the next-highest classification were present, the assumption was made that those unidentified specimens were the same as those identified to lower taxa. Possible reasons for inability to classify to species may be that the organism was damaged or only partially present in the sample, or it was at a life stage that could not be classified to a lower taxon.

Detailed lists of the fish collected at each site are presented in tables 91 through 125. The tables include information on the site name, USGS sampling-site identification number, date sampled, and the electrofishing time (in seconds). The data include method of collection, fish name, voucher type, total and standard fish lengths, fish weight, and any observations of anomalies on the fish. Fish anomalies that were observed included deformities, eroded fins, lesions and ulcers, tumors, black spot, leeches, fungus, blindness, parasites, and popeye. Total weight and number of fish collected at a site and number of anomalies observed also are summarized. Only the first 30 individual fish of each species collected at a site are measured and weighed. After the first 30, the number of individuals of a species and their total weight were recorded  before they were returned to the stream.


Terms used in the fish-data tables:

Fish number--the number of each individual fish for each species sampled.

Method ID--code used to indicate which electrofishing equipment was used at a site and whether the fish were collected on the first (A) or second (B) pass of the stream reach being sampled. 
Code 11 indicates backpack electrofishing equipment used in very shallow, small streams; 
Code 12 indicates tote-barge electrofishing equipment used at wadeable sites; and, 
Code 13 indicates boat-mounted electrofishing equipment used on the White River sites.

Fish name--common name of fish.

Total fish length (centimeters)--the length of a fish measured from the front of the jaw to the end of the tail when the mouth is closed and the tail fin is pinched together (-999999 when not measured).

Standard fish length (centimeters)--the length of a fish measured from the front of the jaw to the fold where the tail fin begins (-999999 when not measured).

Fish weight (grams)--the total weight of the fish.

Abundance--the number of fish measured. This value should equal "1" fish per line, except where species are batch weighed.

Anomalies Observed--"1" indicates presence and "0" indicates absence of an anomaly. Observed anomalies may include deformities, eroded fins, lesions and ulcers, tumors, black spot, leeches, fungus, blindness, parasites, or popeye. Anomalies had to be external to be observed. When calculating DELTS (Deformities, Eroded Fins, Lesions and Tumors) for the Index of Biotic Integrity  analyses, only anomalies in the categories of deformities, eroded fins, lesions and ulcers, and tumors are included.