A review of the application of databases in freshwater fisheries management and the effect of water quality on the mean relative weight of largemouth bass, crappie, and channel catfish in Oklahoma lakes.

Simple item page
dc.contributor.advisorHoagland, Bruce
dc.contributor.authorGriffin, Austin
dc.contributor.authorHoagland, Bruce
dc.contributor.authorKuklinski, Kurt
dc.contributor.committeeMemberLoraamm, Rebecca
dc.contributor.committeeMemberNeeson, Thomas
dc.date.accessioned2018-07-31T14:25:44Z
dc.date.available2018-07-31T14:25:44Z
dc.date.issued2018-05-12
dc.date.manuscript2018-07-27
dc.description.abstractThe subject of this thesis is the development and use of databases for use in fisheries management. The thesis consists of two chapters. The first is a literature review of fisheries databases and an overview of my work as a graduate research assistant with the Oklahoma Biological Survey and Oklahoma Fisheries Research Laboratory (OFRL) of the Oklahoma Department of Wildlife Conservation. The Standard Sampling Protocol (SSP) is at the core of both chapters. In chapter 1, I reviewed the fisheries database literature to aid in the development of the SSP Database and emphasize some of the issues that commonly occur with database development and application. This information guided me in the development of a relational database for the SSP data. The resulting database includes approximately 1.6 million records for 150 fish species in Oklahoma. The database schema consists of five tables: Abiotic, Biotic, SSP Species List, OBIS Taxonomy, and OWRB Lake Data. Chapter 2 employed the SSP database to determine if water quality parameters in 108 Oklahoma lakes influenced the relative weights of largemouth bass (Micropterus salmoides), crappie (Pomoxis annularis and Pomoxis nigromaculatus), and channel catfish (Ictalurus punctatus). Discriminant analysis of eight water quality parameters resulted in the classification of said lakes into six classes. Mean relative weights for largemouth bass, crappie, and catfish ranged from 89.84-99.17, 91.99-98.17, and 86.90-94.01 respectively. Salinity, which was the most important explanatory variable in lake classification, ranged from 0.04-0.63 ppt among the six classes. This information could prove useful to the fisheries managers of Oklahoma by reclassifying similar lakes regardless of management region, allowing for a different perspective on management practices.en_US
dc.identifier.urihttps://hdl.handle.net/11244/301323
dc.languageen_USen_US
dc.subjectfisheries, relative weight, relational database, water qualityen_US
dc.thesis.degreeMaster of Scienceen_US
dc.titleA review of the application of databases in freshwater fisheries management and the effect of water quality on the mean relative weight of largemouth bass, crappie, and channel catfish in Oklahoma lakes.en_US
ou.groupCollege of Atmospheric & Geographic Sciences::Department of Geography and Environmental Sustainabilityen_US
shareok.orcid0000-0003-2019-7616en_US

Files

Original bundle
Now showing 1 - 2 of 2
Thumbnail Image
Name:
2018_Griffin_Austin_Thesis.pdf
Size:
1.52 MB
Format:
Adobe Portable Document Format
Description:
Download
No Thumbnail Available
Name:
2018_Griffin_Austin_Thesis.docx
Size:
2.72 MB
Format:
Microsoft Word XML
Description:
Download
License bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
license.txt
Size:
1.71 KB
Format:
Item-specific license agreed upon to submission
Description:
Download

Collections

OU - Theses