Transcript Slide 1

CMMS Implementation and
Integration Benefits within an
Enterprise GIS Environment
**with an Emphasis on ESRI & Cityworks Software**
February 20, 2008
Steven P. Sushka
Project Manager
Woolpert, Inc.
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
Acronyms, Acronyms,
Acronyms
•
•
•
•
CMMS
MMS
AMS
EAMS
They all mean the same thing!
What is a CMMS?
• Software Application
• Centralized Database
• Business Paradigm
– Integrates strategic planning with
operations, maintenance and capital
investment decision-making.
What does a CMMS do?
• Maintains information about an
organization’s maintenance operations.
– Problem Tracking (Call Center)
– Work Orders (Reactive/Corrective & PM)
– Inspections
– Asset Inventory & Management
– Inventory Control (Parts / Materials)
– Permits
How does a CMMS help?
• Addresses business challenges
– Productivity enhancements
– Maximizing asset life cycles
– Minimizing total cost of ownership
How does a CMMS help?
• Increased Efficiencies & Informed Decisions
– Asset Inventory
– Maintenance History
– Human Resources
– Financial Impacts
– Regulatory Compliance & Accreditation
True Asset Management
Performance Reports &
Analysis
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
Main CMMS-GIS Options
Maximo ®
Oracle eAM – Oracle ALM 12
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)
CMMS-GIS Interfaces &
Integration
• Accela
– Accela GIS
• Cityworks
– Cityworks Desktop
– Cityworks Anywhere
– Cityworks Server MMS
CMMS-GIS Interfaces &
Integration
• Hansen
– Integrated Map Viewer
– GeoAssistant & GeoAdministrator
– GeoMedia-Hansen Interface
– Map Drawer
• Datastream
– Data Bridge
– ArcIMS / XML messaging
CMMS-GIS Interfaces &
Integration
• GBA MS
– GBA GIS Analyst
– GBA GIS Manager
– GBA GIS Viewer
• Cartegraph
–
–
–
–
ArcGIS-Embedded
GEODATAconnect
GISdirector
MAPdirector for ArcGIS
CMMS-GIS Interfaces &
Integration
Maximo
– TAIC’s GIS Web Portal
• Oracle eAM / ALM 12
– Oracle Spatial
– 3rd Party Integration Services
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.
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?
CMMS/GIS Integration
Approaches
• Two Basic Options
– Option #1 = CMMS-Centric (CMMS drives GIS)
– Option #2 = GIS-Centric (GIS drives CMMS)
CMMS-Centric
CMMS-Centric CMMS
Asset Records,
Address Data, and
CMMS
other information are duplicated.
Work Activity
Performance Reports
+
Asset Data
Address Data
• Extra effort required to synchronize data.
• Can potentially
lead to data discrepancies
middleware
and reporting false information.
interface
GIS is often secondary
Geodatabase is optional
Asset data
Address data
GIS-Centric
GIS-Centric CMMS
Asset Records, Address Data, and
other information are shared.
• No duplication of data
CMMS
• No duplication of effort
Work Activity
• No data out of sync.
Performance Reports
Asset data
Address data
• Designed to fully leverage GIS
• Geodatabase = Asset Inventory
• Geodatabase is open, dynamic, fully customizable, not
proprietary
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
Cityworks : Uniquely
GIS-Centric
“The second group, which includes
only Azteca Systems…actually
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
www.nagcs.org
National Association of
GIS-Centric Software
• An Association of ESRI Authorized BPs who are
software developers dedicated to:
– Providing enterprise GIS solutions
– Promoting the unique characteristics and benefits of GIScentric software
– Promoting interoperability, open standards and shared
database access among GIS-centric software
– Distinguishing GIS-centric software and applications from
other approaches
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.
Cityworks® - The GIS-centric Local Government Suite
Browser / Server
Cityworks Permits
Cityworks MMS
ArcGIS Server 9.2
Web Service
Service Request &
Data Metrics
APIs
Client / Server
Cityworks Desktop
ArcGIS Desktop & ArcEngine 9.2
Add-ons
Storeroom
Equipment
Mgr
MMS Admin
Permit Admin
Cityworks Anywhere
Interfaces
CCTV, Paver, AVL
OnBase, DigSmart
Miner & Miner
MWH Soft*
RouteSmart*
Tadpole GoSync*
Cityworks Work Activity
Focus
Cityworks supports
General
Work order
Address &
Coordinate-based
work orders
Asset-based
work order
Multi-Systems Integration
Multi-Systems Integration
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
Benefits of Multi-Systems
Integration
• Single Point of Access
• No Duplicate Data Entry
– Less Work / Effort
– Better Data
• Better Analysis, Reporting & Decision
Making
Challenges
•
•
•
•
Buy in / Ownership
Proper Planning
Technology
Personnel to Internally Administer and
Support the Product
• Data
• Cost
Challenges
Project Control &
Tracking (PIMS)
MS Access
GIS (ESRI)
Shapefiles
Utility Billing (HTE)
AS400
HTE
CMMS (WMA 2000)
Streets
MS Access
CMMS (CartéGraph)
Trans Ops
MS Access
CMMS (Hansen)
Water Distribution
SQL Server
Hansen
CMMS (Hansen)
Water Plant
SQL Server
Hansen
CMMS (HTE)
Water (Meters Only)
AS400
HTE
CMMS (Worksheet
Inventory DB)
Water Preventive
Maintenance
MS Access/Excel
CMMS (Grease Traps)
WPC Grease
Trap Inspections
MS Access
Permitting (KIVA)
SQL Server
EDMS (Application Xtender)
SQL Server
Application Xtender
Addressing (KAIS)
SQL Server
KAIS
CMMS (DataStream MP2)
WPC Plant Operations
Oracle
MP2
CMMS (Hansen)
WPC Collection
SQL Server
Hansen
Key Recommendations
Which CMMS do I choose?
• Requirements
– Hardware
– Software
– Functionality
– GIS Integration
– Multi-Systems Integration
– Wireless and Disconnected
Access
– Etc….
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!
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
Questions?
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: 317.634.3576
[email protected]
www.woolpert.com