Show simple item record

dc.contributor.authorBreck, James E.
dc.date.accessioned2013-07-23T20:25:11Z
dc.date.available2013-07-23T20:25:11Z
dc.date.issued2013-07-23
dc.identifier.urihttp://hdl.handle.net/11045/24097
dc.descriptionPartial OCR done. 50 pages total.en_US
dc.description.abstractAbstract.-hi order to do the best job of fisheries management, fisheries biologists need ready access to relevant information. This report describes databases that have recently been compiled and progress in making the information more available to fisheries biologists through development of relational databases and a geographic information system (GIS). The following 14 datasets have been converted to relational database tables: water bodies from the Michigan lake inventory of Humphrys and Green (N = 32,121); Michigan coldwater lakes (N = 1,345); names of Michigan lakes appearing on U.S. Geological Survey topographic maps (N = 6,904); water quality data for lakes with a public access site and a surface area of at least 50 acres (TV = 730); Schneider’s compilation of lake morphology and water quality (N = 387); Schneider’s compilation of Lower Peninsula lakes sampled for fishes with large seines (N = 229); lake characteristics from Fusilier’s atlas and gazetteer of Michigan lakes (N = 297); lakes sampled in the Michigamme Project (N = 66); watershed area and perimeter for natural lakes at least 100 acres in area (N = 831 individual lakes and 40 multi-lake groups); names of Michigan lakes sampled as part of the U.S. Environmental Protection Agency’s National Acid Precipitation Assessment Program (N = 172); list of reports published by Fisheries Division as research, technical, special, and status of the fishery resource reports (N = 2,404); public boat launch sites on inland lakes (TV = 920); Laarman’s compilation of fish length at age (N = 26,086 records representing 1,135 lakes and 18 species); and names of inland lakes with angler creel survey data (N = 183 lakes, N = 596 lake-year combinations). Metadata were prepared for these data sets. One critical task in this project was assigning a unique lake code to items in various data sets so that multiple sources of information about particular lakes could be linked. Another critical task was assigning the unique lake code to GIS lake points and polygons so that values from various data sets could be displayed as maps. This compilation of databases also contains a collection of digital images of lake maps. Over 160 lake maps have now been converted for use in GIS analyses and for calculation of lake volume and mean depth. These compiled data sets can now be used in the development of decision-support tools for lake and fisheries management, such as estimation of lake fetch and thermocline depth and estimation of walleye population characteristics from lake variables.en_US
dc.language.isoen_USen_US
dc.subjectState of Michigan Department of Natural Resourcesen_US
dc.subjectDecember 2004en_US
dc.subjectFisheries Divisionen_US
dc.subjectSport Fish Restorationen_US
dc.subjectMichigan Lakesen_US
dc.subjectcoldwater lakesen_US
dc.subjectMichigamme Projecten_US
dc.subjectGrowth rates of Michigan fishesen_US
dc.subjectInstitute for Fisheries Researchen_US
dc.titleCompilation of Databases on Michigan Lakesen_US
dc.typeTechnical Reporten_US


Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record