Compilation of Databases on Michigan Lakes
Loading...
Authors
Breck, James E.
Issue Date
2013-07-23
Type
Technical Report
Language
en_US
Subject
State of Michigan Department of Natural Resources , December 2004 , Fisheries Division , Sport Fish Restoration , Michigan Lakes , coldwater lakes , Michigamme Project , Growth rates of Michigan fishes , Institute for Fisheries Research
Alternative Title
Abstract
Abstract.-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.
Description
Partial OCR done. 50 pages total.