1 / 79

Learning about Wisconsin Lakes through a New Integrated Database System

Learning about Wisconsin Lakes through a New Integrated Database System. Annual Reports and Awards. Volunteers participating statewide. What is a Database?. Tables with Rows and Columns Tables are Connected. Tables with Rows and Columns. Tables are Connected.

trevet
Download Presentation

Learning about Wisconsin Lakes through a New Integrated Database System

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