Download - Field Force Automation Software
Field Force Automation Software
Field Force Automation Software
PNWS-AWWA Conference
Mobile Workshop for Water Utilities
May 1, 2008
AgendaAgenda
• Marshall Overview
• Vancouver Case Study
• Mobile Technology for Water/Wastewater Utilities
• Mobile Software Review and Demonstration
• Questions and Answers
About MarshallAbout 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, WaterCity 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
ProblemProblem
• 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 RequirementsField 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 Results
• Vancouver selected GeoResults Mobile
• 36 Gateway laptops mounted in vehicles
• Citrix servers in the back office
• Direct connection to ArcSDE
• Integrated GIS and Work Orders
• Visual activity display
• Retrieve and complete Work Orders and Service Requests
Mobilize Your Enterprise™
Vancouver Water 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 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 ForWater/WastewaterMobile Uses ForWater/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 EnterpriseIntegration Roadmap Spatial EnterpriseIntegration Roadmap
Relationship class UnitID
Origin table/feature class Destination table/feature class
NamePrimary keyForeign key
Water Main
TypeCardinalityNotification
Simple1 - MNone (no messages propagated)
Forward labelBackward label
Name Main
No relationship rules defined .
Feature class Water Main
OBJECTID
Shape
Shape_Length
Shape_Area
Object ID
Geometry
Double
Double
0
0
Yes
Yes
Yes
Field name Data type LengthScaleDefault value
Allow nulls Domain
0
0
Preci-sion
Geometry typeContains Z valuesContains M values
PolygonNoNo
zone Text 30Yes
Pressure Text 30Yes
Text 30Yes
Table Hansen Asset
Default value
Preci-sionField name Length
30
30
30
30
??
??
??
OBJECTID
Water
Length
Type
Year
Address
Object ID
Data type
Text
Text
Text
Text
Text
Text
Text
Domain ScaleAllow nulls
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Integrated Database
Design
Integrated Maintenance
AccessAnalysis
Reporting
Field Force Automation
!(
!(!(
!(!(
!(
!(
!(
!(
"
!(
!(
!("
!(
!(
!(
"!(
!(
!(
$1
!(
G.S.O.
Norbord
Ace Pole
Rayonier
Rayonier
Beech Pole
Shepard LC
Green Thumb
Beasley F.P.
Meridith Pole
Atlantic Pole
Southern Veneer
Clements Lumber
Langdale Chauncey
Varn Wood Products
Tolleson Lumber Co
Georgia-Pacific Corp.
Claude Howard Lumber Co. Inc.Gilman Building Products Company
Wayne
Long
Tift
Irwin
Bulloch
Wilcox
Ware
Liberty
Bryan
Pulaski
Turner
Brantley
Candler
Glynn
Bleckley
Emanuel
Berrien Atkinson
Twiggs
Worth
Laurens
Dodge Tattnall
Pierce
Ben Hill
Evans
Treutlen
Crisp
McIntosh
Dooly
JohnsonWilkinson
CamdenCook
Link Data
ER
M
ER
M
ES
RI
ES
RIIntegration
Planning
DataDevelopment
• Geodatabase Designer
• GeoResults Data Loader
• GeoResults Address Link
• GeoResults Sync
• GeoResults Toolbox
• GeoResults Mobile
• GeoResults Web
GeoResults CustomersGeoResults 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 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
Work Management
Other IT Systems
GIS
Web Service
Enterprise Asset Management
CIS
Mobile Client
Extend Your EnterpriseExtend Your Enterprise
GeoResults MobileAdministrator/Web Service
GeoResultsMobileClient
Administrative/ Server Component
Conceptual ArchitectureConceptual Architecture
Wireless o
r L
AN
Co
nn
ection
Client Component
BusinessData
GIS
Data
FoundationFoundation
• ESRI – Mobile Client
• Powered by ArcGIS Engine/ArcObjects
– Administrative Component Tool• ArcGIS Desktop Toolbar
• Microsoft – .NET/SOA/Web Services– “Smart Client” Technology– Windows XP OS
Industry standard software means investment protection
Smart Client TechnologySmart Client Technology
Next generation client technology
GeoResults MobileGeoResults 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 FunctionalityModular Functionality
• GoMap!– Brings smart maps to the field including GPS and
redlining
• GoCollect!– Advanced editing and data collection for field users
• GoWork!– Work order management including retrieving, modifying,
creating, and closing work orders in the field
• GoRespond!– Retrieve and update service inspection requests in the
field
GoMap! – Digital Map book and NavigationGoMap! – 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)
GPS navigation, location, & tracking
You Are Here
Less travel looking for assets
GoCollect! GoCollect!
• 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
GoWork! GoWork! • 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
Integration with external business systems
Reduces steps to close a work order
GoRespond!GoRespond!
• 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
Integration with external business systems
No need to hand enter data in the office
Administrative ComponentAdministrative Component
Web-based client configuration and review/QA
GeoResults Mobile DemonstrationGeoResults Mobile Demonstration
Thank YouThank You
Questions?Rhett Harman, GISP
Marshall and Associates, Inc.
(360) 352-1279
• ArcGIS Server Support
• Support for “Microsoft Mobile” clients– ArcGIS Server Mobile
• Data Replication Support
• ArcGIS 9.3 Technology
• Additional Back Office Business Systems
GeoResults Mobile ArcGIS Server MobileGeoResults Mobile ArcGIS Server Mobile
Microsoft Mobile ClientMicrosoft Mobile Client
Mobilize Your Enterprise™