1 / 38

GLHI Projects Database

GLHI Projects Database. Pete Giencke pgiencke@glc.org. Web Entry Form -> Database. Web Entry Form -> Database. Required Fields. Optional Fields. Status Toward Restoration Goals Present Land Use Habitat Connectivity Estimated Timeline Significance to Other Programs

dreama
Download Presentation

GLHI Projects Database

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. 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

More Related