1 / 79

Exploring Wisconsin Lakes with Integrated Database SWIMS - Annual Reports, Volunteer Participation

Delve into the world of Wisconsin lakes through the innovative SWIMS database system, featuring tables with connected rows and columns, facilitating volunteer data entry and online reporting. Witness the evolution from Oracle to SWIMS in 2007, ensuring reusable forms for Citizen Lake Monitoring, Secchi readings, and more. Learn about the comprehensive metadata collection of SWIMS, mapping out monitoring stations, projects, methods, and equipment. Discover the proactive environmental initiatives at Millersville University, where the Environmental Group led Earth Day celebrations and fought against the Chester bypass construction. Experience the community-driven efforts like bird monitoring, trash cleanup, and shuttle bus implementation to address traffic congestion. Explore the significance of citizen participation in preserving natural habitats and challenging environmental injustice issues.

trevet
Download Presentation

Exploring Wisconsin Lakes with Integrated Database SWIMS - Annual Reports, Volunteer Participation

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. Learning about Wisconsin Lakes through a New Integrated Database System

  2. Annual Reports and Awards

  3. Volunteers participating statewide

  4. What is a Database? • Tables with Rows and Columns • Tables are Connected

  5. Tables with Rows and Columns

  6. Tables are Connected

  7. Try not to Repeat Information

  8. Paradox and Microsoft Access. • Reports not yet online. • Repetition of information in tables. 1997-1999

  9. 2000 - Citizen Lake Monitoring Database Went Online

  10. Oracle Database. • Reports and volunteer data entry online. • Non-generic tables and columns. 2000

  11. Avoid Making Columns and Tables Too Specific

  12. Oracle Database. • Reports and volunteer data entry online. • Tables and Columns Reusable 2007

  13. Everything Re-Usable

  14. 2007: New Database Called SWIMS

  15. Reusable Forms

  16. Citizen Lake Monitoring - Secchi Form

  17. Citizen Based Stream Monitoring Form

  18. National Lake Survey - Habitat Form

  19. SWIMS Integrates Many Types of Data

  20. Metadata Who: People Where: Monitoring Stations Why: Projects When: Date/Time How: Methods and Equipment

  21. Monitoring Stations

  22. Methods

  23. Methods

  24. Metadata Who: People Where: Monitoring Stations Why: Projects When: Date/Time How: Methods and Equipment One More?

  25. Washington D.C. Area.

  26. Millersville University, Pennsylvania

  27. Was President of The Priority Club, the Environmental Group on Campus

  28. Annual Earth Day Celebration

  29. Environmental Injustice Chester, Pennsylvania

  30. A Local Issue: Proposed Bypass

  31. "The Bush" - Wooded Area along Conestoga River

  32. Susquehanna River to Chesapeake Bay

  33. We Tried Petitions...

  34. And Tried to Understand the Permit Process...

  35. We Monitored Birds...

  36. And Plants...

  37. Cleaned up Trash...

  38. Monitored Macroinvertebrates...

  39. The Issue Was in the Newspaper Often...

  40. TV Coverage - Rally

  41. To Address Traffic Conjestion:

  42. Formed Committee to Start Shuttle Bus

  43. Went into Service in 1995

  44. The Shuttle Bus is Still There...

More Related