CMMS Implementation and Integration Benefits within an Enterprise GIS Environment

1
CMMS Implementation and Integration Benefits
within an Enterprise GIS Environment
with an Emphasis on ESRI Cityworks Software
Steven P. Sushka Project Manager Woolpert, Inc.

• February 20, 2008

2
Agenda

• CMMS - What is it? What does it do? How does it
  help?
• CMMS Options GIS Integration
• Multi-Systems Integration
• Challenges
• Which System do I choose?
• Questions

3
Acronyms, Acronyms, Acronyms

• CMMS
• MMS
• AMS
• EAMS
• They all mean the same thing!

4
What is a CMMS?

• Software Application
• Centralized Database
• Business Paradigm
• Integrates strategic planning with operations,
  maintenance and capital investment
  decision-making.

5
What does a CMMS do?

• Maintains information about an organizations
  maintenance operations.
• Problem Tracking (Call Center)
• Work Orders (Reactive/Corrective PM)
• Inspections
• Asset Inventory Management
• Inventory Control (Parts / Materials)
• Permits

6
(No Transcript)
7
How does a CMMS help?

• Addresses business challenges
• Productivity enhancements
• Maximizing asset life cycles
• Minimizing total cost of ownership

8
How does a CMMS help?

• Increased Efficiencies Informed Decisions
• Asset Inventory
• Maintenance History
• Human Resources
• Financial Impacts
• Regulatory Compliance Accreditation

9
True Asset Management
10
(No Transcript)
11
Performance Reports Analysis
12
CMMS Options

• Some CMMS products focus on particular industry
  sectors while others aim to be more general. This
  results in
• A wide range of uses
• A wide range of capabilities
• A wide range of prices

13
Main CMMS-GIS Options
Maximo
Oracle eAM Oracle ALM 12
14
ESRI Business Partners

• Accela, Inc.
• Azteca Systems, Inc. (Cityworks)
• Cartegraph
• GBA Master Series, Inc
• IBM Corporation (Maximo)
• Infor Global Solutions, Inc (Datastream)
• Hansen Information Technologies (now Infor)

15
CMMS-GIS Interfaces Integration

• Accela
• Accela GIS
• Cityworks
• Cityworks Desktop
• Cityworks Anywhere
• Cityworks Server MMS

16
CMMS-GIS Interfaces Integration

• Hansen
• Integrated Map Viewer
• GeoAssistant GeoAdministrator
• GeoMedia-Hansen Interface
• Map Drawer
• Datastream
• Data Bridge
• ArcIMS / XML messaging

17
CMMS-GIS Interfaces Integration

• GBA MS
• GBA GIS Analyst
• GBA GIS Manager
• GBA GIS Viewer
• Cartegraph
• ArcGIS-Embedded
• GEODATAconnect
• GISdirector
• MAPdirector for ArcGIS

18
CMMS-GIS Interfaces Integration

• Maximo
• TAICs GIS Web Portal
• Oracle eAM / ALM 12
• Oracle Spatial
• 3rd Party Integration Services

19
Why CMMS-GIS Interfaces Integration?

• Adds the Spatial Component
• Ability to Visualize Assets, Permits, Work
  Orders, etc.
• Ability to Run Spatial Analysis
• Valve Isolation
• Spatial Query / Buffer
• Vehicle Routing
• Etc.

20
A Very Important Question

• How does the CMMS specifically interface/integrate
  with the GIS?
• ArcMap Extension, ArcEngine Application?
• Custom Interface / Middle-ware?
• Where is the asset data stored and maintained?

21
CMMS/GIS Integration Approaches

• Two Basic Options
• Option 1 CMMS-Centric (CMMS drives GIS)
• Option 2 GIS-Centric (GIS drives CMMS)

22
CMMS-Centric
CMMS-Centric CMMS
CMMS

• Asset Records, Address Data, and other
  information are duplicated.
• Extra effort required to synchronize data.
• Can potentially lead to data discrepancies and
  reporting false information.

Asset data Address data
middleware
Work Activity Performance Reports
Asset Data Address Data
interface
GIS is often secondary Geodatabase is optional
23
GIS-Centric
GIS-Centric CMMS

• Asset Records, Address Data, and other
  information are shared.
• No duplication of data
• No duplication of effort
• No data out of sync.

CMMS
Work Activity Performance Reports
Asset data Address data

• Designed to fully leverage GIS
• Geodatabase Asset Inventory
• Geodatabase is open, dynamic, fully customizable,
  not proprietary

24
GIS-Centric Checklist

• Geodatabase stores asset data
• Non-redundant asset database
• User-defined asset data model
• Non-proprietary asset database
• Interoperable asset database
• Inherently spatial data structures
• Created and maintained by GIS tools

25
Cityworks Uniquely GIS-Centric
The second group, which includes only Azteca
Systemsactually stores the asset data just in
the GIS database. (italics added)
Jim McKibben PE, Westin Engineering, ESRI
International User Conference, July 2002,
Integration with GIS and Computerized Maintenance
Management Systems
26
National Association of GIS-Centric Software
www.nagcs.org

• An Association of ESRI Authorized BPs who are
  software developers dedicated to
• Providing enterprise GIS solutions
• Promoting the unique characteristics and benefits
  of GIS-centric software
• Promoting interoperability, open standards and
  shared database access among GIS-centric software
• Distinguishing GIS-centric software and
  applications from other approaches

27
NAGCS Certification

• 8. How can a software application solution be
  certified?
• Any organization can apply to have their software
  application certified by contacting NAGCS. NAGCS
  then forwards the application to a 3rd-party
  neutral for testing.
• The association has appointed John Pryzbyla of
  Woolpert as the 3rd-party neutral. John is a
  nationally recognized expert for Public Works and
  Utilities and a GISP. A fee will be charged by
  Woolpert to cover the cost for the testing.

28
Cityworks - The GIS-centric Local Government
Suite
Client / Server
Browser / Server
Cityworks Desktop
Cityworks Anywhere
Cityworks MMS
Cityworks Permits
ArcGIS Desktop ArcEngine 9.2
ArcGIS Server 9.2
Add-ons Storeroom Equipment Mgr
Web Service
Service Request Data Metrics APIs
MMS Admin
Interfaces CCTV, Paver, AVL OnBase,
DigSmart Miner Miner MWH Soft RouteSmart Tadpo
le GoSync VIA NAGCS standards
Permit Admin
29
Cityworks Work Activity Focus
Cityworks supports
General Work order
Address Coordinate-based work orders
Asset-based work order
30
Multi-Systems Integration
31
Multi-Systems Integration
32
Points of Integration

• Employee, Material and Equipment Data
• Payroll / Timesheet Data
• Customer / Utility Billing Data
• Address Data
• Permits
• Inventory Requisitions and POs
• Financial /Accounting Cost Data
• Citizens Web Portal
• SCADA / Runtime
• One-Call Tickets

33
Benefits of Multi-Systems Integration

• Single Point of Access
• No Duplicate Data Entry
• Less Work / Effort
• Better Data
• Better Analysis, Reporting Decision Making

34
Challenges

• Buy in / Ownership
• Proper Planning
• Technology
• Personnel to Internally Administer and Support
  the Product
• Data
• Cost

35
Challenges
Key Recommendations
36
Which CMMS do I choose?

• Requirements
• Hardware
• Software
• Functionality
• GIS Integration
• Multi-Systems Integration
• Wireless and Disconnected Access
• Etc.

37
Which CMMS do I choose?

• Flexibility, Customization, Ease of Use
  Administration
• Cost
• Compare Several Systems
• Demo Scenarios and Benchmarks
• Site Visits to Existing Clients
• The software should fit your business process not
  the other way around!

38
Sources

• www.esri.com
• www.accela.com
• www.cityworks.com
• www.infor.com
• www.datastream.net
• www.hansen.com
• www.gbams.com
• www.cartegraph.com
• www.oracle.com
• www.wikipedia.org

39
Questions?
40
Contact Information

• Steven P. Sushka
• Project Manager
• Enterprise Information Management
• Woolpert, Inc.
• 350 East New York Street, Suite 300
• Indianapolis, Indiana 46204
• Direct 317.223.2318
• Cell 317.670.3096
• Fax [phone]
• steven.sushka_at_woolpert.com
• www.woolpert.com