1 / 22

Great Lakes Aquatic Gap

Great Lakes Aquatic Gap. Building a Wisconsin Aquatic GAP Biology Database. Barb Scudder and Morgan Schneider. Who is doing what in WI?. WI Data Acquisition: Barb Scudder, Michelle Lutz WDNR Biology Database Updates/Summary: Morgan Schneider

do
Download Presentation

Great Lakes Aquatic Gap

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Great Lakes Aquatic Gap Building a Wisconsin Aquatic GAP Biology Database Barb Scudder and Morgan Schneider

  2. Who is doing what in WI? WI Data Acquisition: Barb Scudder, Michelle Lutz WDNR Biology Database Updates/Summary: Morgan Schneider WDNR Historical Database Interpretation/Cleaning: Matt Diebel Database Design/Consulting: Morgan Schneider Data formatting/loading: Matt Diebel, Michelle Lutz, Krista Stensvold

  3. Objectives for this year • Develop a Central GAP Database Design • USGS Great Lakes Science Center (Scott Nelson) • Develop a list of WI data sources • Fish (Current) • Benthic invertebrates (Future) • Freshwater Mussels (Future) • Acquire fish data and load into WI GAP database • Spring - Acquire fish data • June - Format/load fish data

  4. Central GAP Database Design • Initial Database Design - Scott Nelson (USGS Great Lakes Science Center) • Central GAP Database serves data to only GAP projects at this point • Central GAP Database eventually shared with USGS National Biological Information Infrastructure (NBII):http://www.nbii.gov • WI GAP database (MS Access) designed to load easily into Central GAP Database (Oracle)

  5. Required Fields: Location Site/location name Lat/long, TRS OR other description Date Fish species ID Scientific name OR Common name Abundance OR Presence Optional Fields: Effort Gear used Mesh size Effort units Distance sampled Area sampled Hydrologic Unit River mile Database Fields

  6. Fish WDNR Biology database WDNR Historical database US Forest Service US Fish & Wildlife Service US Geological Survey Oneida Tribe of Indians Milwaukee Public Museum University of Wisconsin University of Michigan University of Minnesota Benthic invertebrates WDNR US Forest Service US Geological Survey Oneida Tribe of Indians University of Wisconsin Mussels WDNR US Forest Service Milwaukee Public Museum Data Sources

  7. WDNR Biology Database • Database proposed November 1999 • Database online January 2001 • Data available from the WDNR Biology Database • Fish community • Habitat assessments • Fish Stocking data • Tribal fish information

  8. WDNR Biology Database Growth

  9. WDNR Biology Database Status • Priority on entering new data • Bureau of Fisheries Management and Habitat Protection • Bureau of Research • Legacy data sets loaded • Master Fish File (Don Fago) • Legacy data sets considered for future loading • Wang fish and habitat • Kanehl fish and habitat • Historical Fisheries (Doug Beard - Paradox database) • Mussels database • Macroinvertebrate database UW-SP, Stan Szczytko

  10. WDNR Biology Database Fish Sampling Locations • 1880 – present • 28,500 samples • ~17,000 sites

  11. WDNR Biology Database Sample Summary

  12. WDNR Biology Database Species Summary • Number of fish species in the WDNR Biology Database • 172 • Fish species collected in the highest numbers • BLUEGILL - Lepomis macrochirus • BROWN TROUT - Salmo trutta • WALLEYE - Stizostedion vitreum vitreum • LARGEMOUTH BASS - Micropterus salmoides • NORTHERN PIKE - Esox lucius • WHITE SUCKER - Catostomus commersoni • BROOK TROUT - Salvelinus fontilalis • YELLOW PERCH - Perca flavescens • CREEK CHUB - Semotilus atromaculatus • SMALLMOUTH BASS - Micropterus dolomieu • ROCK BASS - Ambloplites rupestris

  13. WDNR Historical Fish Database Doug Beard Location to Q Section / Non-targeted surveys 4346 samples Location to Q Section / Targeted surveys 1172 samples Location to Section or Twnship-Rge / Non-targeted surveys 8393 samples Location to Section or Twnship-Rge / Targeted surveys 2360 samples Location varies (County or Notes) / Targeted and Non - 2594 samples Total 18865 samples

  14. Determining Locations: WNDR Historical Database Records

  15. Determining Locations: WNDR Historical Database Records

  16. Determining locations • “Geolocate” program • Tulane University Museum of Natural History (Nelson Rios) • No cost • Beta testing phase • Designed for converting museum site text descriptions to georeferenced locations • Not yet tested by GAP

  17. Plans for next year • Finalize development of fish database • Review literature/summarize fish habitat suitability • Prepare fish species distribution maps and distribute for expert review • Interface fish database with valley segment database • Continue identifying sources of other data • Macroinvertebrates: Insects/Mussels

More Related