SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

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

xuan avatar
xuan
24 diapositives · 390 Views · Feb 14, 2013

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

#jeanette mcgruder #engineer #head #image retrieval #field #floor #robert meredith #draw
Sammamish Virtual Vault Engineering Drawing Search and Retrieval System Team Members Beth Carpenter , Project Manager Br - slide 1
01 / 24Sammamish Virtual Vault Engineering Drawing Search and Retrieval System Team Members Beth Carpenter , Project Manager Br
1 / 17

Télécharger la présentation

Sammamish Virtual Vault Engineering Drawing Search and Retrieval System Team Members Beth Carpenter , Project Manager Br
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  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