Field Force Automation Software PNWS-AWWA Conference Mobile Workshop

Field Force Automation Software PNWS-AWWA Conference Mobile Workshop for Water Utilities May 1, 2008

Agenda • Marshall Overview • Vancouver Case Study • Mobile Technology for Water/Wastewater Utilities • Mobile Software Review and Demonstration • Questions and Answers

About Marshall 14 Years of Excellence 1994 – 2008 – Privately-held company – Spatial enterprise integration software – ESRI business partner – Hansen solutions partner – Developed Hansen’s GIS products – Mobile technology experts – Focused on utilities and public works

City of Vancouver, Water • • • Fourth largest water utility in WA Serves 200, 000 people 800+ miles of pipes 64, 000+ water meters Top Priorities – Quality, – Service – Cost Containment

Problem • Growing City, high demand on staff • Paper-based work flow time consuming/slow • Data entry back log and system lag • Out of date paper maps • Difficult to locate assets and work • Many steps to track and close work • Multiple trips back to the office

Field Requirements • • Easy to use Low cost Up-to-date data and maps in the field Fast performance, without hardware upgrade • Digital work orders and service requests in the field

Results • • Vancouver selected Geo. Results Mobile 36 Gateway laptops mounted in vehicles Citrix servers in the back office Direct connection to Arc. SDE Integrated GIS and Work Orders Visual activity display Retrieve and complete Work Orders and Service Requests Mobilize Your Enterprise™

Vancouver Water “Having a partner like Marshall has been a compliment to our vision of a mobile solution that would suit our needs today and be ready for the challenges of tomorrow. ” Steve Furno, City of Vancouver, WA.

Solution • • Reduces overtime Eliminates paper and automates workflow Matches assets to work orders Helps locate critical assets quickly Helps complete activities in the field Less travel and driving Works wirelessly or disconnected Mobilize Your Enterprise™

Mobile Uses For Water/Wastewater • • Valve and hydrant maintenance Sewer main cleaning and manhole inspection Customer service/emergency response Locate valves and meters Field data collection Work management Preventative maintenance • Track vehicles, assets, and resources

Spatial Enterprise Integration Roadmap Access Analysis Reporting ESRI Link Data Development Integration Integrated Database Planning Design ERM Integrated Maintenance ESRI ERM • Geo. Results Sync • Geo. Results Toolbox • Geo. Results Data Loader • Geo. Results Address Link • Geodatabase Designer Field Force Automation • Geo. Results Mobile • Geo. Results Web

Geo. Results Customers • • • • Anchorage, AK Vancouver Water, WA Hernando County, FL Phoenix Water, AZ Peoria Public Works, AZ Tempe Water, AZ Longmont Utilities, CO Virginia Beach Water, VA Martin County, FL Norfolk, VA Stafford County, VA Providence Water Markham, ON, CN Auburn, WA Dayton Water, OH Las Vegas, NV • • • • Kansas City Water, MO Franklin, TN Austin Water, TX Troy, MI Winston-Salem, NC Seattle DOT Walla, WA Shoreline Public Works, WA Kirkland, WA Port of Seattle, WA Hillsborough County, FL Monterey, CA Napa Sanitation District Lake Oswego, OR Aurora Water, CO Groton, CT

Extend Your Enterprise CIS Work Management GIS Other IT Systems Web Service Enterprise Asset Management Mobile Client

Conceptual Architecture Data Client Component Administrative/ Server Component GIS Geo. Results Mobile Client Geo. Results Mobile Administrator/ Web Service Wireless or LAN Connection Business Data

Foundation • ESRI – Mobile Client • Powered by Arc. GIS Engine/Arc. Objects – Administrative Component Tool • Arc. GIS Desktop Toolbar • Microsoft –. NET/SOA/Web Services – “Smart Client” Technology – Windows XP OS Industry standard software means investment protection

Smart Client Technology Next generation client technology

Geo. Results Mobile • Functionality – Current “Smart Maps” or Digital Map Books. – GPS Integration • Navigation • Field Data Collection – Asset Condition Updates – Field Data Collection – Automated Work Order Processing – Service Request Inspection

Modular Functionality • Go. Map! – Brings smart maps to the field including GPS and redlining • Go. Collect! – Advanced editing and data collection for field users • Go. Work! – Work order management including retrieving, modifying, creating, and closing work orders in the field • Go. Respond! – Retrieve and update service inspection requests in the field

Go. Map! – Digital Map book and Navigation • Locate Assets and ID’s • Integrates with GPS • Locate Intersection/ Address • See Asset ID’s on the map • View Asset Information • Other tools (e. g. , Measure and Redlining) Less travel looking for assets GPS navigation, location, & tracking You Are Here

Go. Collect! • Field Data Collection and Asset Inventory Update – Create New Assets – Update Asset Inventory – Move Asset Location – Correct GIS Data Easy to complete activities in the field

Go. Work! • Work Orders and Group Projects – Matches asset to work order – Update and close work order – Streamlines PM – Visually see group project – Create work order based on map asset – Select map asset to view work order Reduces steps to close a work order Integration with external business systems

Go. Respond! • Services Requests – Create work order from service request – Resolve service request in the field – Locate service request – Identify problem quickly – Associate service requests to assets, parcel and/or addresses No need to hand enter data in the office Integration with external business systems

Administrative Component Web-based client configuration and review/QA

Geo. Results Mobile Demonstration

Thank You Questions? Rhett Harman, GISP Marshall and Associates, Inc. rharman@marshallgis. com (360) 352 -1279

Geo. Results Mobile Arc. GIS Server Mobile • Arc. GIS Server Support • Support for “Microsoft Mobile” clients – Arc. GIS Server Mobile • Data Replication Support • Arc. GIS 9. 3 Technology • Additional Back Office Business Systems

Microsoft Mobile Client Mobilize Your Enterprise™