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

Team Photo

Sammamish Virtual Vault - Engineering drawing search and retrieval system

Where is Sammamish?

Sammamish Virtual Vault - Engineering drawing search and retrieval system

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

Sammamish Virtual Vault - Engineering drawing search and retrieval system

Projects Spreadsheet

Sammamish Virtual Vault - Engineering drawing search and retrieval system

Engineering Drawing

Sammamish Virtual Vault - Engineering drawing search and retrieval system

Project File Sharing

Google Docs

Sammamish Virtual Vault - Engineering drawing search and retrieval system

Catalyst Web Tools

Project Footprints in Pilot Area

Sammamish Virtual Vault - Engineering drawing search and retrieval system

Database

Sammamish Virtual Vault - Engineering drawing search and retrieval system

Interface

Search

… By Parcel PIN By Project ID By Project name

Find

…

Create

… By browsing the map An address and zoom to it A complete project report

Sammamish Virtual Vault - Engineering drawing search and retrieval system

VBA Script

Sammamish Virtual Vault - Engineering drawing search and retrieval system

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

Models

Search By Parcel ID Browse The Map Search By Project ID Join Projects With Names All Projects Report Compact Databases Search By Project Name Un-Select Parcel Project Sammamish Virtual Vault - Engineering drawing search and retrieval system

Example Model

All Projects Report Sammamish Virtual Vault - Engineering drawing search and retrieval system

Python Scripts

Virtual Vault Report Select Projects By Name All Projects Report Sammamish Virtual Vault - Engineering drawing search and retrieval system

Revision History

Sammamish Virtual Vault - Engineering drawing search and retrieval system

Example Report

Thanks to Jesse Rowe (Sammamish webmaster) for HTML formatting Sammamish Virtual Vault - Engineering drawing search and retrieval system

Documentation

User's Guide

Sammamish Virtual Vault - Engineering drawing search and retrieval system

Documentation

Installation and Maintenance Guide

Sammamish Virtual Vault - Engineering drawing search and retrieval system

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

Sammamish Virtual Vault - Engineering drawing search and retrieval system

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

Sammamish Virtual Vault - Engineering drawing search and retrieval system

Live Demo

Live Demo

Sammamish Virtual Vault - Engineering drawing search and retrieval system

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

Sammamish Virtual Vault - Engineering drawing search and retrieval system

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

Sammamish Virtual Vault - Engineering drawing search and retrieval system

Questions?

Contact info Beth Carpenter – [email protected]

Christoffer Brodbaek – [email protected]

Peter Fiddler – [email protected]

Brian Oevermann – [email protected]

Sammamish Virtual Vault - Engineering drawing search and retrieval system