GLHI Projects Database

1. GLHI Projects Database Pete Giencke pgiencke@glc.org

2. Web Entry Form -> Database

3. Web Entry Form -> Database Required Fields Optional Fields • Status Toward Restoration Goals • Present Land Use • Habitat Connectivity • Estimated Timeline • Significance to Other Programs • Sensitive Species / Habitat • Mitigation Techniques/Measures • Monitoring Requirements • Federal Sponsors • Non-Federal Sponsors • Other Project Partners • Cost Estimates • Land Ownership / Easement • Real Estate Availability • Legal Authorities in Place • Project Title • Project Abstract • Project Type • Project Status • Locality Description • Geographic Extent • Estimated Project Size • Habitat Type(s) • Ecological Stressors • Anticipated Ecological Outcomes • Project Contact • Access Constraints

4. Key Features

5. Leverages Existing Resources • Use of pre-vetted regional classifications/picklists • (e.g. MIRIS, GLRC)

6. Leverages Existing Resources • Use of pre-vetted regional classifications/picklists • (e.g. MIRIS, GLRC) • 1:1 Mapping of field names with complimentary databases • (i.e. NERI)

7. Leverages Existing Resources • Use of pre-vetted regional classifications/picklists • (e.g. MIRIS, GLRC) • 1:1 Mapping of field names with complimentary databases • (i.e. NERI) • Use of Great Lakes Information Network for hosting, marketing, and data dissemination

8. Polygonal Capture and Storage of Projects

9. Polygonal Capture and Storage of Projects

10. Support for Geographic Objects/Operations SELECT s.id, g.huc_code, huc_name, reg, sub FROM submit_data s, gl_hucs g WHERE s.id = 245 and INTERSECTS(s.the_geom, g.the_geom)"; #Find all hydrologic units (HUCS) within project area 245

11. Built on Free and Open Source Software Perl PHP GeoServer MapServer PostgreSQL PostGIS GDAL Tomcat

12. Schema/Structure

13. Schema/Structure

14. Schema/Structure • Data warehouse star schema model, normalized to the Third Normal Form (3NF).

15. Schema/Structure • Data warehouse star schema model, normalized to the Third Normal Form (3NF). • “Fact table” tblProject linked to tblGeography, tblRestoration, tblHabitat, tblContacts, and tblFunding

16. Schema/Structure • Data warehouse star schema model, normalized to the Third Normal Form (3NF). • “Fact table” tblProject linked to tblGeography, tblRestoration, tblHabitat, tblContacts, and tblFunding • Placeholders (“buckets”) included for further iterations of database (“version 1.0”)

17. Schema/Structure • Schema/Structure Documents • Entity Relationship Diagram (ERD) • http://gis.glin.net/dropbox/glhi_erd.pdf

18. Schema/Structure • Schema/Structure Documents • Entity Relationship Diagram (ERD) • http://gis.glin.net/dropbox/glhi_erd.pdf • Data Dictionary • http://gis.glin.net/dropbox/glhi_data_dictionary.pdf

19. GLHI Data Use/Access

20. Web-Based Tools for GLHI Projects Database Access Dissemination Analysis Visualization

21. Visualization Tools

22. Analysis Tools Web-based query functionality http://gis.glin.net/dropbox/query.php http://gis.glin.net/dropbox/query.php

23. GLHI Data Dissemination http://gis.glin.net/dropboxglhi_access.php

24. GLHI Data Dissemination

25. GLHI Data Dissemination

26. GLHI Data Dissemination

27. Conclusions and Next Steps • Bang for the buck

28. Conclusions and Next Steps • Bang for the buck • Usability

29. Conclusions and Next Steps • Bang for the buck • Usability • Extensibility

30. Conclusions and Next Steps • Bang for the buck • Usability • Extensibility • Integrate GLHI Programs (funding) database

31. Conclusions and Next Steps • Bang for the buck • Usability • Extensibility • Integrate GLHI Programs (funding) database • Facilitate machine-level project population

32. Conclusions and Next Steps • Bang for the buck • Usability • Extensibility • Integrate GLHI Programs (funding) database • Facilitate machine-level project population • Improve user ease of use

33. Conclusions and Next Steps • Bang for the buck • Usability • Extensibility • Integrate GLHI Programs (funding) database • Facilitate machine-level project population • Improve user ease of use • Enhance external compatability

34. Conclusions and Next Steps • Bang for the buck • Usability • Extensibility • Integrate GLHI Programs (funding) database • Facilitate machine-level project population • Improve user ease of use • Enhance external compatibility • Transition to repository

35. A Wetlands-Focused Spatial Decision Support System for the Great Lakes Great Lakes Commission 2007 NSDI CAP-Category 4

36. Great Lakes Wetlands SDSS Overview • Enhance the Bain’s NWI coverage through the integration of mined attribute data from disparate wetlands and wetlands-related datasets • Leverage existing projects and inventories (i.e. GLHI) to facilitate tracking and reporting of wetlands owned by federal agencies in the GL basin • Create a web-based (GLIN) toolkit to support visualization, analysis, and dissemination of wetlands data in the GL basin • Demonstrate, through open source and open standards technologies (i.e. WFS-T), the value of incorporating geospatial approaches into Federal business processes.

37. Wetlands Data Integration • National Datasets: • National Wetlands Inventory (NWI) • Coastal Change Analysis Program (C-CAP) • Soil Survey Geographic (SSURGO) Database • National Hydrography Dataset (NHD) • State/Province Datasets: • Ontario • Michigan DEQ • New York DNR • Ohio DNR • WISCLAND (WI) • Great Lakes Habitat Initiative (GLHI)

38. More…. http://gis.glin.net/wetlands