1 / 24

Sammamish Virtual Vault Engineering Drawing Search and Retrieval System Team Members Beth Carpenter , Project Manager Br

Sammamish Virtual Vault Engineering Drawing Search and Retrieval System Team Members Beth Carpenter , Project Manager Brian Oevermann , Lead Developer Christoffer Brodbaek , Database Designer / Developer Peter Fiddler , Requirements Analyst / Developer Sponsor

xuan
Download Presentation

Sammamish Virtual Vault Engineering Drawing Search and Retrieval System Team Members Beth Carpenter , Project Manager Br

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. Sammamish Virtual Vault Engineering Drawing Search and Retrieval System Team Members Beth Carpenter, Project Manager Brian Oevermann, Lead Developer Christoffer Brodbaek, Database Designer / Developer Peter Fiddler, Requirements Analyst / Developer Sponsor Laura Philpot, P.E., City Engineer, City of Sammamish

  2. Team Photo

  3. Where is Sammamish?

  4. Project Description Sammamish Virtual Vault... • Is an engineering drawing search and retrieval system • Associates engineering drawings with project footprints layer • Is accessed through a custom ArcView 9.3 user interface • Allows search and retrieval of engineering drawings by city staff with ArcGIS Desktop installed • Has five search modes and one comprehensive report • Uses Visual Basic for Applications (VBA), an Address Locator, ModelBuilder, Python, Access, Excel, and a Web Browser

  5. Projects Spreadsheet

  6. Engineering Drawing

  7. Project File Sharing Google Docs Catalyst Web Tools

  8. Project Footprints in Pilot Area

  9. Database

  10. Interface Search… By Parcel PIN By Project ID By Project name By browsing the map Find… An address and zoom to it Create… A complete project report

  11. VBA Script • VBA Script • Responds to UI button clicks • Uses address locator • Invokes appropriate report

  12. Models Search By Parcel ID Browse The Map All Projects Report Search By Project ID Join Projects With Names Compact Databases Search By Project Name Un-Select Parcel Project

  13. Example Model All Projects Report

  14. Python Scripts Virtual Vault Report Select Projects By Name All Projects Report

  15. Revision History

  16. Example Report Thanks to Jesse Rowe (Sammamish webmaster) for HTML formatting

  17. Documentation User's Guide

  18. Documentation Installation and Maintenance Guide

  19. Lessons Learned • The system is more complex ”under the hood” than it appears • There are limitations when managing toolbars in ArcGIS Desktop • Project file and models can be corrupted without warning • File geodatabase grows even if just reading (use "compact" tool) • Don't know what directory ArcGIS will run script in (use absolute paths) • Query syntax different for shapefiles vs. geodatabases

  20. Successes • Stayed on schedule • City staff available and willing to help • Visit to Seattle Public Utilities validated use of PDF files and HTML reports • Environment settings file a good first step • Delivered good documentation • Implemented reasonable search and retrieval system within ArcGIS Desktop

  21. Live Demo Live Demo

  22. Future Recommendations • Add columns to report (make it customizable?) • Make the system easier to install (more environment settings in one place) • Move the system to the internet so customers can do their own searches • Link to the CAD as-built files • Search using sub-sets of data (e.g. search only R.O.W. projects) • Search using direct SQL queries in addition to the buffer method • Develop a complete drawing management system

  23. Acknowledgements Thank you to: City of Sammamish Laura Philpot, P.E., City Engineer Matt Micona, Information Systems Manager Jesse Rowe, Web Master Instructors - University of Washington GIS Certificate Program Jaime Crawford Joe Brentin Harvey Arnone Tom Nolan Seattle Public Utilities

  24. Questions? Contact info Beth Carpenter – beth.gis.carpenter@gmail.com Christoffer Brodbaek – brodbaek@gmail.com Peter Fiddler – eprfiddler@q.com Brian Oevermann – boevermann@gmail.com

More Related