CC SR 20200707 M - CityWorks Agreement
CITY COUNCIL MEETING DATE: 07/07/2020
AGENDA REPORT AGENDA HEADING: Consent Calendar
AGENDA TITLE:
Consideration and possible action to enter an agreement with Azteca Systems for
“CityWorks” licensing and maintenance.
RECOMMENDED COUNCIL ACTION:
(1) Authorize the City Manager to enter a License and Maintenance Agreement with
Azteca Systems for “CityWorks” Computerized Maintenance Management
System (CMMS) licensing and maintenance licensing and support.
FISCAL IMPACT: None
Amount Budgeted: $27,000
Additional Appropriation: N/A
Account Number(s): 101-400-1470-5201
ORIGINATED BY: Lukasz Buchwald, IT Manager
REVIEWED BY: Karina Bañales, Deputy City Manager
APPROVED BY: Ara Mihranian, AICP, City Manager
ATTACHED SUPPORTING DOCUMENTS:
A. CityWorks License and Maintenance Agreement (page A-1)
B. March 3, 2015 City Council Staff Report on Computerized Maintenance
Management System (page B-1)
BACKGROUND AND DISCUSSION:
On March 3, 2015, the City of Rancho Palos Verdes entered a License and
Maintenance Agreement with Azteca Systems to purchase licensing and maintenance
for the CityWorks platform (Attachment B). It was implemented and configured for the
Public Works Department to process and track Service Requests and Work Orders,
provide Asset Management and Operational Insight Data. The initial contract term is
now expired and a new license agreement needs to be put in place for continued
operations.
1
CityWorks was selected and approved by the City Council as a CMMS platform of
choice based on the Staff research and recommendation back in 2015 . CityWorks
remains a very stable, efficient and user-friendly platform that the Public Works
Department continues to rely on for internal and external customer service requests,
and to build their business model upon.
CityWorks is currently heavily integrated with City’s GIS system and there are plans
underway to introduce a public-facing mobile app that will allow the residents and
employees to create, track and update service requests. The mobile app will integrate
with the CityWorks system to automatically create service requests and work orders and
provide automatic updates throughout the resolution process.
The City expects that 20 named licenses currently in use will be sufficient for the
foreseeable future, but an additional Application Programming Interface [API] might
need to be added to the contract based on the planned mobile app require ments
The total annual licensing and support cost for 20 user licenses is $27,000/year and any
additional named user is $1,200/year, as described in the License and Maintenance
Agreement (Attachment A). CityWorks does not have distributors; it is only sold directly
from Azteca Systems. As a result, pricing comparisons are not possible.
The License and Maintenance Agreement with Cityworks is not on the City’s form
agreement, as Citywork insisted that the agreement be on their form, although
Cityworks did agree to some changes to their agreement. The City Attorney finds this
form acceptable for this software vendor. While this is typical for software agreements, it
is important to highlight some of the differences between Cityworks’ agreement and the
City’s form agreement. Some key differences include the following:
Limitations of Liability: The City’s form agreement contains no limitations on
liability, meaning that the City can recover the full amount of any harm against
the contractor. In contrast, the Cityworks’ agreement contains a limitation on
liability up to three times the total fees paid in one year, which amounts to
$81,000. This amount was originally set at $27,000, but Cityworks agreed to
increase it.
Indemnification: The City’s form agreement includes broad indemnification
requirements, ensuring that the contractor will be required to repay the City for
any claims which arise associated with the agreement. In contrast, Cityworks’
agreement contains indemnification only for claims associated with copyright
infringement.
Insurance: The City’s form agreement contains insurance requirements, including
general insurance, workers compensation insurance, and automobile insurance.
In contrast, Cityworks’ agreement contains no insurance requirements because
they are providing software.
Venue: The City’s form agreement states that any dispute under the agreement
will be brought under the laws of the State of California, and must be brought in
2
the Los Angeles County superior court. In contrast, Cityworks’ agreement states
that any dispute under the agreement will be brought under the laws of the State
of Utah. Should a dispute arise, the City will face additional costs associated with
litigating that dispute in Utah.
ALTERNATIVES:
In addition to the Staff recommendation, the following alternative actions are available
for the City Council’s consideration:
1. Direct Staff to search for an alternative CMMS platform
2. Take other action as deemed appropriate.
3
A-1
A-2
A-3
A-4
A-5
A-6
A-7
A-8
A-9
A-10
A-11
A-12
A-13
A-14
CITY OF RANCHO PALOS VERDES
MEMORANDUM
TO:
FROM:
DATE:
SUBJECT:
REVIEWED:
HONORABLE MAYOR & CITY ~~NCIL MEMBERS
DAN LANDON, IT MANAGER ~·
MICHAEL THRONE, DIRECTOR OF PUBLIC WORKS
MARCH 3, 2015
COMPUTERIZED MAINTENANCE MANAGEMENT
SYSTEM OVERVIEW
CAROL YNN PETRU, DEPUTY CITY MANAGE ~
RECOMMENDATION
Authorize the City to begin negotiations for an agreement with Azteca Systems "CityWorks"
Computerized Maintenance Management System (CMMS) and Miller Spatial Services for
the CityWorks system implementation.
EXECUTIVE SUMMARY
The Public Works department currently processes and tracks Service Requests and Work
Orders in a hybrid process that is mostly manual. This system is inefficient and provides
for minimal tracking and reporting capabilities. Past third party assessments pointed out
that the City should upgrade these older systems and manual processes to updated
computerized processing systems, and after an evaluation period that initially began in
2008, the City has selected CityWorks as the preferred CMMS system because of several
factors, including:
• Tight integration with ESRI GIS, the City's GIS system;
• Configurability and the number of available modules;
• Strong feature set including online and mobile applications; and
• Reasonable price point.
The CityWorks system connects to GIS and is able to use layers of GIS data as asset
points and Service Requests and Work Orders can be assigned to non-addressed assets.
This feature allows for greatly improved tracking and reporting of maintenance activities .
CityWorks also has an impressive and comprehensive set of features, and in 2012 was
selected as the top CMMS by a respected and independent review of industry systems by
B-1
COMPUTER MAINTENANCE MANAGEMENT SYSTEM OVERVIEW
MARCH 3, 2015
PAGE2
the Water Finance Research Foundation.
The CityWorks system must be configured to achieve the most productivity and feature
enhancements. The City contracts with Miller Spatial Services for advance GIS
functionality including assistance with the most recent GIS system upgrade. Miller Spatial
Services, located in Riverside, California is a local, well qualified CityWorks partner and is
recommended for the implementation process. Not only are they able to fulfill the City's
requirements during implementation, they have a deep understanding of the City's GIS
system, and fulfil the important requirement of a local implementer.
CityWorks has three (3) licensing levels, Essentials, Standard and Premium. Based on the
feature set, the City recommends the purchase of 20 individual named users of the
Standard licensing model at an annual cost of $27,000. Implementation is estimated to be
$50,000 subject to final negotiations and changes to the scope of work.
Staff is seeking authorization to negotiate an agreement with the preferred system provider
and a consultant to assist the City with implementation. Final proposals and agreements
will be presented to the City Council for approval at a future meeting.
BACKGROUND
The Public Works department currently processes and tracks Service Requests and Work
Orders using a combination of manual forms, email and spreadsheet type applications. As
noted in assessments including Management Partners in 2008, Nexlevel in 2011 and
Matrix in 2012, the City would benefit by an upgrade in systems, allowing for productivity
and efficiencies as well as enhancing information available for management decisions and
reporting. Staff has now completed a long process of analysis of the various Computerized
Maintenance Management Systems available in the market and have selected the Azteca
Systems "CityWorks" application as the most effective solution for our City environment.
During a 2008 system review process, Public Works and IT Staff considered proposals and
demonstrations of the various system options available with a goal of finding an electronic
method of creating and tracking service requests and work orders in order to replace the
paper triplicate "carbon-copy" forms currently in use. It was realized during this research
process that a true full asset management system was needed, as opposed to simply an
electronic method of processing service requests and work orders. Asset Management
and Work Order systems pool information to create the most effective way to manage both
the City's maintenance resources and assets in one system. Several demos were
provided to the Public Works Staff by vendors offering the systems considered, including
Tyler's asset management module, but Staff felt that the 'GIS-centric' Azteca Systems
Cityworks application best met the needs and goals of the Department because of the
ability to spatially map City owned assets.
In contrast to some other limited-functionality work-order systems, Cityworks was
developed for the sole purpose of infrastructure asset management with a strong emphasis
on tying into the spatial data that already exists inside the City's ESRI-based GIS system.
This component is considered critical by Staff for a variety of reasons, but especially
because of the ability to tie service requests to assets such as street segments, locations in B-2
COMPUTER MAINTENANCE MANAGEMENT SYSTEM OVERVIEW
MARCH 3, 2015
PAGE3
the preserve or signs that do not have a street address. Many Public Works requests for
service involve these non-addressed assets, and a system linked to GIS data provides the
capacity to clearly identify these locations for service as well as for tracking and reporting
purposes.
Besides the City's own comprehensive process, a 2012 non-biased "Water Finance
Research Foundation" comparison found CityWorks the top CMMS choice among fourteen
(14) leading CMMS's (see Exhibit A -Asset Manager Software Comparison -WERF
2012). Due to a variety of factors, the system was not implemented during the initial review
in 2008. The City has since made numerous enhancements to City technologies, including
the recent GIS system upgrades needed to support the CityWorks capabilities, and the City
is now prepared to begin the system implementation process.
DISCUSSION
Because of the wide array of Land Management issues affecting local government
operations, municipalities have specific needs related to the systems they procure. At a
high level, there are several possible general designs for Land, Infrastructure and Asset
Management systems in municipal government:
• Isolated systems that each specialize in specific departmental functions;
• Systems with separate data sources that replicate data with each other; and
• Integrated systems that draw data from a single source and can also share data
with other systems.
The integrated system type above has many advantages related to the use of data from a
central data store based on geospatial data, aerial imagery, and GPS located assets.
Layers of information such as parcel boundaries, structure size, street segments, signs and
thousands of other attributes can be used by a number of systems, and that data is only
maintained in one location as a "master" data store. Leveraging this information in
departmental business or enterprise systems provides a powerful rationale for selecting a
system that is "GIS Centric".
CityWorks Selection I Features
CityWorks is among a small number of Asset and Infrastructure Management Systems that
are fully GIS Centric. Many competitors merely replicate GIS data into their database.
CityWorks supported functions include asset and work order management, recording of
inspections and condition data, and reporting on a wide variety of data including by
individual work request or rolling up costs for categories of work. CityWorks supports
procurement and inventory management operations, and it also supports logging and
tracking of service requests. CityWorks supports Application Programming Interfaces
(API's) to a wide variety of other municipal government systems including Customer
Relations Management (CRM) systems that can be used for accepting and tracking of
resident City service requests.
CityWorks includes several built-in data models based on the schemas defined by our GIS
B-3
COMPUTER MAINTENANCE MANAGEMENT SYSTEM OVERVIEW
MARCH 3, 2015
PAGE4
system manufacturer, ESRI. The models support a wide range of municipal assets already
programmed as layers into GIS such as water, wastewater, storm water, and road
networks. The City can then modify the schemas to suit our requirements during the
implementation phase. The figure below illustrates how the ESRI schema is used to
associate a map of water mains with their associated work orders in CityWorks.
' CITYW O, 1.MXD · Ar cM.1 p -A1 cl n fo GJ (Q]rgj
Elle !;_dit )(iew lnsert :l_electior1 Iools W,indow t!elp
['} ~ 1i1i ~ ,X. ~ fi X ~ :t' 1Jr:::1 :6~~~s=-~-::: _=_ ::::.;:];;;... ... 111_-:!:1. 11--:(!J::::--. -=.:-=CI:;-j -:-:~
Scenario360 _":.__ ~! !__• _&_:.":. 11!1? •I ? j Gityworks ~ til," •I"• !iJ .. J
Network: Jw aterNetwork
1::1 @ ltl!t!!II61D
El ~ ALL -WO
#.; OTHER
ASSETGROUP
(tP WATER
!±I ~ Water Nel:>l'ork
I±J ~ Airporis
l±l D OrthoPhoto
1±1 ~ Ne wSubdivision
1±1 ~ BuildingFootprints
:±1 ~ LandParcels
1±1 ~ RoadNe~N ork
:±1 0 ONhighway
!±I ~ Raillines
i±l ~ Ganals_Water ways
ffl ~ Lakes -detailed
1±1 0 lakes
ttl ~ Vegetation
In creating work orders or capturing other associated data, CityWorks can spatially link
work orders and service requests to specific assets or to street addresses in GIS. This
links directly to spatial GIS data that changes during the creation of layers or recording of
events such as sales at the assessor facilitates serving notice to customers who may be
affected by an asset failure or a planned maintenance operation, or in long term planning
and budgeting for the replacement of Infrastructure Assets.
Work orders and service requests are assigned to responsible personnel, and enables
them to locally or remotely access these work orders and status or update them as work is
completed. Another feature of CityWorks is its ability to support field operations by
enabling browser based wireless access using tablets or laptops directly to the asset
geodatabase. Staff or contracted personnel can access and update work orders and
service requests, and view asset maps directly from the field. CityWorks can also operate
in "disconnected" mode, an important feature with the spotty wireless reception that is a
result of our terrain, by checking data in and out of the database, and keeping the data
synchronized between sessions.
System Implementation B-4
COMPUTER MAINTENANCE MANAGEMENT SYSTEM OVERVIEW
MARCH 3, 2015
PAGE5
CityWorks is very flexible but requires configuration to suit the specific requirements of
each individual customer. Because of the very tight integration with GIS, it is important to
find an implementer that also has experience with GIS. Staff's initial inquiry several years
ago did not solicit any implementers in the Los Angeles area. Local support is important
because the implementer will likely be assisting the City with future support and
functionality requests and a quick response time without additional travel expenses or time
is important to the City.
Miller Spatial Services is our current GIS services consultant and has an intimate
knowledge of City GIS as the firm assisted in the implementation of the GIS upgrades
approved by City Council in 2014. In addition to GIS expertise, they are also a CityWorks
implementation partner with offices in Riverside, California. Therefore, Miller Spatial
Services meets the criteria of a local, skilled CityWorks provider with expertise in our City
GIS systems.
The proposed implementation consists of a planning phase, implementation, and a training
and go-live phase. During the planning phase, Staff will work with the consultant to
develop a comprehensive workflow based on our current processes that best fits into the
CityWorks system capabilities. During implementation, the consultant will program
CityWorks workflows, functionality and features required to accomplish the functionality
identified in the planning phase. Finally, the training and go-live phase will commence with
a comprehensive staff training program, on-site support during go-live and additional hours
of support after go-live to address any deviances from the functionality identified in the
planning phase.
A Scope of Work was developed by Staff and submitted to Miller Spatial Services. After
discussion and clarification, an implementation plan and schedule was developed, (see
Exhibit B -Miller Spatial -Cityworks Implementation Proposal). Miller Spatial Services
submitted an initial estimate of $41,070 including the cost of system planning,
implementation, training and go-live support. Staff estimates that the final total cost will be
approximately $50,000 based on several additional expected configurations such as
reports and workflow changes, subject to final contract negotiation. Staff will present the
final negotiated agreement to City Council for consideration.
Cityworks Licensing and Support
An onsite CityWorks system is recommended because of the tight integration into the
City GIS system. CityWorks has three licensing levels depending on the functionality
desired. (see Exhibit C-CityWorks Pricing Model)
• "Essentials" -most basic system license includes Asset Management and
connectivity to ESRI GIS;
• "Standard"-include the features of Essentials, plus inventory, contracts, reporting
and analytics and the use of API's for Citizen Service Requests; and
• "Premium"-include all the features of Standard as well as several premium mobile
management features and additional API's.
B-5
COMPUTER MAINTENANCE MANAGEMENT SYSTEM OVERVIEW
MARCH 3, 2015
PAGE6
After the selection of the licensing level, customers choose either "named user" licenses or
"site" user licenses. The cost of licensing is based by Azteca Systems on City population.
The most appropriate type of user licensing can be easily calculated based on how many
users will access the system. If the individual license cost is less than a site license, then
individual named license purchase are more cost effective.
The Cityworks licensing level selected based on City needs is the "Standard" level. Staff
expect that twenty (20) named user licenses will be used, so the number of users that will
be accessing CityWorks does not support a site license model, therefore individual named
licenses are recommended.
Azteca "CityWorks" does not sell licensing through distributors. As such, the only source to
purchase licensing is direct from Azteca Systems. The City expects that 15 licenses will be
used in Public Works, 2 in Community Development, 2 in Recreation and Parks and 1 in
Finance or Administration. The cost for named users of CityWorks Standard is:
• First 5 users-$9,000
• Each additional user-$1,200
The total annual licensing and support cost for 20 user licenses is $27,000. There is no
upfront fee for the software purchase. The annual cost for a site license is $45,000. The
City proposes the less expensive purchase of 20 user licenses for $27,000. CityWorks
does not have distributers, it is only sold direct from Azteca Systems. As a result, pricing
comparisons are not possible. Staff will present the final purchase proposal to City Council
for consideration along with the final agreement.
CONCLUSION
With the pending completion of an updated GIS system, and the planned FY 2015-16
upgrade to the Community Development Department's Land Management System, both
Public Works and Community Development will be able to utilize the centralized GIS
system as the single repository of all land, parcel, and infrastructure data.
It is the appropriate time to implement a Computerized Maintenance Management System
in order to migrate the City's current manual Service Request and Work Order systems into
an integrated, GIS Centric system. Such a system will greatly improve tracking and
reporting capabilities, thus increasing efficiency, timelines and improve customer service.
In addition to the other efficiency, productivity and reporting capabilities, a CMMS is
expected to provide useful information to the Infrastructure Management Advisory
Committee and is another favorable consideration in progressing with the system
implementation.
FISCAL IMPACT
Funds were previously appropriated by City Council and carried over to FY2014-15. It is
expected that the Public Works CMMS, will be fully implemented in FY2015-16 in line with
B-6
COMPUTER MAINTENANCE MANAGEMENT SYSTEM OVERVIEW
MARCH 3, 2015
PAGE?
the 5 Year IT Plan presented to City Council in August 2014. The implementation and
licensing cost for a Public Works CMMS was previously approved by the City Council and
encumbered, so no additional budget adjustments are expected.
Attachments:
Exhibit A-Asset Manager Software Comparison-WERF 2012
Exhibit B -Miller Spatial -Cityworks Implementation Proposal
Exhibit C -CityWorks Pricing Model
B-7
@ WaterFinanceRF.org
The 2012 Comparative Review of Municipal Maintenance
and Infrastructure Asset Management Systems
SUMMARY: The United States and Canada face tremendous capital outlays to repair and
replace aging municipal and utility infrastructure. Technology is required to better manage the
complex decision making process for maintenance, operational and capital investments and
resource allocation. This study conducted in 2012 comprises a comparative review of the major
computerized maintenance management and infrastructure asset management systems used by
municipal govemments and water and wastewater utilities in the United States and Canada. The
objective of this study is to provide municipal elected officials, public works directors,
infrastructure asset managers, maintenance managers, information technology managers, finance
directors and procurement staff an overview of municipal maintenance management and
infrastructure asset management software in a comparative fonnat in preparation for a request for
qualifications or proposals. The comparative criteria includes software costs, vendor services,
support, specialization, work orders, inventory control, licensing and permitting, condition
assessment, risk management, asset inventory, GIS mapping, Esri GIS integration, 311 systems,
mobile devices, Esri GIS ROI and future industry trends. The comparative analysis of core
maintenance management and infrastructure asset management functions was completed for the
following 14 software systems in alphabetic order: Accela, Agile Assets, Azteca System's
Cityworks, Cartegraph, Cityview, Energov, IBM's Maximo, Infor/Hansen, Lucity/GBA,
Maintenance Connection, Novotx's Elements, Oracle, Pubworks and Vueworks. Also included
in this study, but not in a comparative fonnat is a discussion on Esri GIS as the recommended
platfonn for municipal mapping applications; and Innovyze software offerings for an advanced
wet infrastructure/underground network hydraulic modeling decision analytics approach.
Water Finance Research Foundation WFRF
www.waterfinanceRF.org
1. SUMMARY RESULTS I Municipal Maintenance and Infrastructure Asset Management Systems
B-8
1. SUMMARY RESULTS
The summary results of the 2012 comprehensive comparative review and study ranks Azteca System's
Cityworks maintenance management and infrastructure asset management system as the top selection
for municipal and utility use. Cityworks has demonstrated strength and longevity in the municipal and
utility market place for the last 15 years with a highly developed work order management system, and
can fully leverage an organization's (ROI) investment in the Esri GIS and the ArcGIS geodatabase as
the asset repository reducing implementation and long-term maintenance cost of ownership issues.
Cityworks maintains some of the most advanced LGT (Local Govemment Templates) with over 630
work order templates, 150 service requests with detailed condition assessment inspections. The licensing
and permitting functionality is further enhanced by the Esri GIS Centric approach in developing
connectivity of all public assets, infrastructure and activities.
Functional . Software S Pnce Score* core
Cityworks 99 91
Oracle 94 79
Maximo 93 78
Accela 92 82
lnfor/Hansen 89 79
Energov 88 82
Cartegraph 87 81
Lucity ( G BA) 82 78
Pubworks 65 68
Maintenance 61 61
Vueworks 61 61
Agile Assets 52 58
Elements 50 56
Cityview 33 42
*Adjusted Price Score weighted 20%
1. SUMMARY RESULTS I Municipal Maintenance and Infrastructure Asset Management Systems
B-9
2.1NTRODUCTION
In recent years municipalities and water and wastewater systems have stmggled significantly in
managing the complex and diverse assets that are within their jurisdictions for which they are
accountable. Great strides have been made to develop programs and systems to improve cost
efficiencies but core work order management software system functionality by itself did not
address the growing needs of infrastmcture asset management practices. During the most recent
five years since the worldwide economic decline, which in pmt continues today, municipalities
and utilities at all levels have faced severe revenue short falls. The actions taken to maintain
baseline services involved delaying hundreds of millions of dollars a year in needed maintenance
activities and deferring critical capital projects. Efforts made at the state, regional, county, and
local levels to better manage assets and allocate limited resources to high profile failing assets
were met with a high degree of frustration due to inconsistent and outdated practices, neglected
data tracking and storing, and a lack of data integration abilities with silo/stranded data
throughout many departments.
Asset Management
Infrastmcture asset management programs, offered by different consulting firms, should still be
focused on managing assets in a way in which the investment for each asset can be optimized
producing a reduction in capital budgets and operating expenditures, an efficient and cost
effective maintenance program based on risk and an overall reduction in the cost of capital. One
common problem has been when engineering drives the capital agenda and the needs of
operations and maintenance are overlooked. Likewise, when the financial tracking and planning
functions are also neglected, true enterprise asset management decision making cannot occur. A
multidisciplinary approach at a corporate level is highly recommended to create a consistent
management-wide effort to guide investments and resource allocation.
Comprehensive asset management professionals understand these concepts and have a global
perspective and the ability to customize solutions to each municipality. These professionals
possess the expertise in and understanding of the Intemational Infrastructure Management
Manual (IIMM), which is essentially the bible of asset management. This training is critical in
establishing the foundational knowledge of the comprehensive process of modem asset
2. INTRODUCTION I Municipal Maintenance and Infrastructure Asset Management Systems
B-10
management. The basic foundation as well as the expectations should be that asset management
as a philosophy is a process of continuous improvement and change.
In the United States and Canada, the definition of asset management will continue to be defined
by the software tools each organization selects as a means to improve asset performance and
manage costs. A reduction of cost can be defined as either a short-term gain or a long-term gain
or both. The logic entails that if an asset is not maintained correctly it can fail prematurely.
Likewise, an asset replaced prematurely wastes a useful asset and as a result improved
performance and investment decision making does not occur. Informed decision making can
reduce the overall cost of the asset and function to the benefit of the taxpayers. This process is
data intensive and requires the necessary policies, leadership, and stmcture to meet sustainable
infrastmcture objectives. The goal to achieve a sense of sustainable infrastmcture requires an
overall plan including asset management planning, which in turn also requires a financial plan, a
technology plan, a service delivery plan, and integration with community plmming efforts.
Public Asset Management
The concept of public asset management strives to combine all infrastmcture assets and land-
based assets and functions to effectively manage the social and environmental goals of the
community while offering an improved management decision making process with public
review, approval and justification. The current trend is that municipal utilities as capital-intensive
enterprise funds will initiate asset management programs during the economic decline and will
lead their general city management counterparts of public works, streets, facilities, fleet, parks,
signage, bridges, cemeteries, ports and marinas, into an era of sustainability and infrastmcture
asset management. The expansive nature of the process places a high level of importance on the
technology which needs to be applied in a way to gain the greatest benefit overall.
Computerized Maintenance Management Systems (CMMS) and Infrastmcture Asset
Management Software implementation trends for municipalities demonstrate initial progress in
business enterprise funds like water, wastewater, and storm drains migrating efficiencies and
practices to other municipal departments. This system functionality migration trend will continue
and can be more readily managed with a GIS centered strategy.
2. INTRODUCTION I Municipal Maintenance and Infrastructure Asset Management Systems
B-11
3. METHODOLOGY
The comparative analysis of core maintenance management and infrastructure asset management
functions was completed for the following 14 software systems in alphabetic order: Accela,
Agile Assets, Azteca System's Cityworks, Cartegraph, Cityview, Energov, IBM's Maximo,
Infor/Hansen, Lucity/GBA, Maintenance Connection, Novotx's Elements, Oracle, Pubworks and
Vueworks.
The comparative criteria includes software costs, vendor services, support, specialization, work
orders, inventory, licensing and pennitting, condition assessment, risk management, asset
inventory, GIS mapping, Esri GIS integration, 311 systems, mobile devices and Esri GIS ROI
taking into consideration future industry trends. The four major functional categories include
1) Company/Service, 2) Work Management, 3) Asset Management, and 4) GIS.
Each major component is ranked 1-5 with a 5 as the highest score. A zero represents a function
not contained in the software. The Overall Functional Score assumes an even weighting of the
four major functional areas.
COM PAN¥ SERMICES
SERVICES/IMPLEMENTATION
SUPPORT/TRAINING
SPECIALIZATION
WORK ORDERS
WORK ORDERS AND WORK FLOW
INVENTORY
LICENSING AND PERMITS
ASSET' MANAGEMENT'
CONDITION ASSESSMENT
• RISK MANAGEMENT
ASSET
! INVENTORY/HIERARCHY
Esri GIS INTEGRATION
311 SYSTEMS
Esri GIS ROI
3. METHODOLOGY I Municipal Maintenance and Infrastructure Asset Management Systems
B-12
4. REVIEW OF SERVICES
The functionality of the core components of a software application is very important, however, the
actual success and level of benefit gained is a direct result of the work and support around the planning,
implementation, testing and training. The ability for the software vendor to provide enhanced support
and training to ensure the successful implementation is critical. In the area of asset management, data
conversion and a specialization in specific infrastructure types can ensure a higher degree of utilization
of software capabilities.
Company Services Overall Score
Pubworks
Cityview
Agile Assets
Vueworks
Elements
Maintenance
Energov
Accela
Lucity (GBA)
lnfor
Oracle
Maximo
Cartegraph
Cityworks
0 2 4 6 8 10 12 14 16
4. REVIEW OF SERVICES I Municipal Maintenance and Infrastructure Asset Management Systems
B-13
Company /Services
The Company/Service functional category includes Vendor Services and Implementation,
Support and Training Services and Company Strength and Specialization. A ranking score
ranging from 1-5 was assigned to software for each of the 3 areas. A "5" score represents the
highest functionality, while a low score represents a marginal level of functionality. If software
did not have functionality in a given area then a zero was assigned and calculated into the overall
sconng.
Services Support Specialization
Cityworks 5 Cityworks 5 Cityworks 5
Cartegraph 5 Cartegraph 5 Cartegraph 5
Maximo 5 Maximo 5 Maximo 5
Oracle 5 Infer/Hansen 5 Oracle 5
Accela 4 Lucity (GBA) 5 Accela 4
Energov 4 Oracle 5 Energov 4
Infer/Hansen 4 Accela 4 Infer/Hansen 4
Lucity {GBA) 4 Energov 4 Lucity {GBA) 4
Elements 3 Maintenance 4 Maintenance 4
Maintenance 3 Agile Assets 3 Agile Assets 3
Vueworks 3 Cityview 3 Cityview 3
Agile Assets 2 Elements 3 Elements 3
Cityview 2 Pubworks 3 Pubworks 3
Pubworks 2 Vueworks 3 Vueworks 3
4. REVIEW OF SERVICES I Municipal Maintenance and Infrastructure Asset Management Systems
B-14
5. REVIEW OF WORK MANAGEMENT
A robust Computerized Maintenance Management System (CMMS) with work orders providing
the ability to separate planned or unplanned maintenance costs, builds life cycle cost history,
records actual direct costs of the activity, documents the procedures followed, notes the failure
mode and primary cause of failure with comments on indirect costs and impacts to customers
and possible unproductive time. A basic CMMS alone is not an asset management system. All
of this data enables additional possibilities of failure, causal, consequence and efficiency
analysis.
Work Management Overall Score
Cityview
Agile Assets
Vueworks
Maintenance
Pubworks
Energov
Elements
Oracle
In for
Maximo
Cartegraph
Lucity (GBA)
Accela
Cityworks
0 2 4 6 8 10 12 14
5. REVIEW OF WORK MANAGEMENT I Municipal Maintenance and Infrastructure Asset
Management Systems
16
B-15
Work Management
The Work Management functional category consisted of Work Orders and Work Flow,
Inventory Control, and Licensing and Permitting. A ranking score ranging from 1-5 was
assigned to software for each of the 3 areas. A "5" score represents the highest functionality,
while a low score represents a marginal level of functionality. If software did not have
functionality in a given area then a zero was assigned and calculated into the overall scoring.
Work Orders Inventory Eicense/Rermits
Cityworks 5 Cityworks 5 Cityworks
Accela 5 Accela 5 Accela
Energov 4 Maximo 5 Cityview
lnfor/Hansen 4 Lucity (GBA) 5 Energov
Maintenance 4 Rubworks 5 Cartegraph
Maximo 4 lnfor/Hansen 5 Lucity (GBA)
Lucity (GBA) 4 Ora de 5 Maximo
Cartegraph 4 Cartegraph 5 lnfor/Hansen
Elements 4 Elements 5 Oracle
Oracle 4 Energov 4 Elements
Rubworks 4 Maintenance 4 Rubworks
Vueworks 4 Vueworks 4 Maintenance
Agile Assets 3 Agile Assets 3 Vueworks
Cityview 0 Cityview 0 Agile Assets
5. REVIEW OF WORK MANAGEMENT I Municipal Maintenance and Infrastructure Asset
Management Systems
5
5
5
5
4
4
4
4
4
3
0
0
0
0
B-16
6. REVIEW OF ASSET MANAGEMENT
Condition assessment can be defined as a method that establishes the current condition of assets
as a means of prioritizing and forecasting maintenance and rehabilitation efforts. Condition
assessment can help managers understand the level of asset deterioration and the risk
management impact on the probability and consequence of failure. The Asset Inventory or
Registry is central to any asset management program or strategy. An asset register is a systematic
recording of all assets an organization owns or for which it has responsibility.
Asset Management Overall Score
Cityview
Elements
Agile Assets
Vueworks
Maintenance
Pubworks
Lucity (GBA)
In for
Oracle
Maximo
Energov
Cartegraph
Accela
Cityworks
0 2 4 6 8 10 12 14 16
6. REVIEW OF ASSET MANAGEMENT I Municipal Maintenance and Infrastructure Asset Management
Systems
B-17
Asset Management
Asset Management functional category includes Condition Assessment capabilities, Risk
Management, and Asset Inventory and Hierarchy. A ranking score ranging from 1-5 was
assigned to software for each of the 3 areas. A "5" score represents the highest functionality,
while a low score represents a marginal level of functionality. If software did not have
functionality in a given area then a zero was assigned and calculated into the overall scoring.
Condition Assessment Risk Management Asset Inventory
Cityworks 5 Cityworks 5 Cityworks
Cityview 0 Cityview 0 Cityview
Elements 0 Elements 0 Accela
Accela 5 Accela 5 Cartegraph
Cartegraph 4 Cartegraph 4 Energov
Energov 5 Energov 5 Maximo
Maximo 5 Maximo 5 Oracle
In for 5 lnfor 5 In for
Oracle 5 Oracle 5 Lucity (GBA)
Lucity (GBA) 4 Lucity (GBA) 4 Pubworks
Maintenance 4 Maintenance 4 Agile Assets
Pubworks 4 Pubworks 4 Elements
Agile Assets 3 Vueworks 4 Maintenance
Vueworks 3 Agile Assets 3 Vueworks
5
0
5
4
5
5
5
4
4
4
3
3
3
3
6. REVIEW OF ASSET MANAGEMENT I Municipal Maintenance and Infrastructure Asset Management
Systems
B-18
7. REVIEW OF GIS
Investing in a complete GIS system with full functionality produces an overall reduction in
operating and maintenance costs and can become the foundation of a lower cost asset
management system. Technology has increased the operating efficiencies of municipalities and
utilities by converting manual office process from paper to an intelligent automation system. GIS
is a unique system ofhardware, software and data used to create, store, edit, organize,
manipulate and analyze information within a geographic area. GIS offers the ability to visualize
models of the physical infrastructure and related activities in a map view.
GIS Overall Score
Elements
Maintenance
Cityview
Agile Assets
Vueworks
Pubworks
Lucity (GBA)
Cartegraph
Maximo
Energov
Oracle
In for
Accela
Cityworks
0 5 10 15 20
7. REVIEW OF GIS I Municipal Maintenance and Infrastructure Asset Management Systems
25
B-19
GIS
The GIS (Geographical Information System) functional category consists of GIS Mapping
features, Esri GIS integration, 311 System Abilities, Mobile Devices Enhancements, and Esri
GIS ROI (Return on Investment) considerations. A "5" score represents the highest functionality,
while a low score represents a marginal level of functionality. If software did not have
functionality in a given area then a zero was assigned and calculated into the overall scoring.
GIS Mapping Esri Integration 311 System Mobile Devices
Cityworks 5 Cityworks 5 Accela 5 Accela
Accela 5 Accela 4 Cartegraph 5 Maximo
Cartegraph 5 Cartegraph 4 Energov 5 lnfor/Hansen
Elements 5 Energov 4 lnfor/Hansen 5 Oracle
Energov 5 Maximo 4 Oracle 5 Cityworks
Maximo 5 lnfor/Hansen 4 Pubworks 5 Agile Assets
lnfor/Hansen 5 Lucity (GBA) 4 Cityworks 4 Energov
Lucity (GBA) 5 Oracle 4 Maximo 4 Cartegraph
Oracle 5 Agile Assets 3 Lucity (GBA) 4 Cityview
Vueworks 5 Elements 3 Vueworks 4 Lucity (GBA)
Agile Assets 4 Maintenance 3 Cityview 3 Maintenance
Cityview 4 Pubworks 3 Agile Assets 2 Pubworks
Pubworks 4 Vueworks 3 Elements 0 Vueworks
Maintenance 3 Cityview 0 Maintenance 0 Elements
5
5
5
5
4
4
4
3
3
3
3
3
2
0
GIS has been able to meet the increased demand for mobility and information sharing. Many
applications for asset maintenance and management purposes have been developed by software
companies in order to improve the transactional cost of public accountability. Some of these features can
also be accessed through 3rd party vendors. Municipalities and utilities have benefited from 311 citizen
information, request and tracking systems as well as mobile remote business functionality via handheld
mobile devices. 311 capabilities and mobile device initiatives are continually improving for top vendors.
7. REVIEW OF GIS I Municipal Maintenance and Infrastructure Asset Management Systems
B-20
Esri GIS ROI
GIS offers a retum on investment (ROI) and these operational savings will continue almost
indefinitely. Municipalities and utilities in the United States and Canada rely on the industry
leader Esri (Economic and Social Research Institute) GIS for their GIS software. Local
govemments and utilities benefit overall with standardization and common open standards for
consistency which helps achieves lower-costs with the economies of scale. Under this GIS
Centric approach, the Esri GIS ArcGIS geodatabase is the feature database for storing the all
asset attributes. Additionally, there is no redundancy for data storage (no reliance on views, data
mapping, database triggers, or "transparent" links). All feature (asset) data is fully user-definable
and customizable without vendor support. This would include common standardization absent
expensive non-proprietary feature data model format, including data names, fields, tables,
relationships, and other data design elements.
Esri GIS RQI Esri P.ARtFNER l.EVEI.
Cityworks 5 Platinum
Accela 3 Gold
Cartegraph 3 Silver
Energov 3 Gold
Maximo 3
lnfor/Hansen 3
Lucity (GBA) 3 Gold
Oracle 3
Elements 2
Maintenance 2
P.ubworks 2
Vueworks 2
Agile Assets 1
Cityview 1
7. REVIEW OF GIS I Municipal Maintenance and Infrastructure Asset Management Systems
B-21
8. REVIEW OF COST FACTORS
Overall Scores and Rankings nonnally are based on the functional categories scores and
averages. Under this review, the four major functional categories were weighted evenly. The
element of cost adds additional complexity to the analysis. Most municipalities and utilities will
normally focus on the core functionality of the software in order to meet all current and future
business needs before reviewing bids or prices. The price component can be challenging
considering there are the basic user licenses, software and maintenance costs and agreements
combined with phased implementations, modular selections, data clean up, data conversion,
systems integrations, testing and training. This study focuses on the common costs; however, it is
very important to note that if various modules are selected and integrated, the costs of
implementation are normally significant higher.
Cost Factors (5 is a high cost)
Agile Assets 2 Low
Cityview 2 Low
Elements 2 Low
Pubworks 2 Low
Cityworks 3 Average
Cartegraph 3 Average
Energov 3 Average
Ludty (GBA) 3 Average
Maintenance 3 Average
Vueworks 3 Average
Accela 4 High
lnfor/Hansen 4 High
Maximo 5 High
Oracle 5 High
8. REVIEW OF COST FACTORS I Municipal Maintenance and Infrastructure Asset Management
Systems
B-22
Cost Factors
Likewise, when system integration and conversion is required for many different systems and
several modules, the initial implementation and long-term system synchronization and
maintenance of redundant databases can raise the total cost of ownership significantly. This is
very true in the area of licensing and permitting. Every municipality and utility has a degree of
data clean up due to neglect or inconsistent policies and practices concerning work order
histories and inspection recording and asset data collection. One specific area of concern has
been the development of the asset inventory and the connectivity and integration with GIS
software.
I Municipal Maintenance and Infrastructure Asset Management Systems
B-23
9. Esri GIS ArcGIS: Geodatabase management
ArcGIS for Desktop includes comprehensive professional GIS applications that support a number of
GIS tasks, including mapping, data compilation, analysis, geodata and image management, and
geographic information sharing. ArcGIS for Desktop is the platform that GIS professionals use to
manage their GIS workflows and projects and to build data, maps, models, and applications. It is also
the starting point and the foundation for deploying GIS across organizations and onto the web. It is used
to publish and share geographic information with others.
ArcGIS for Server includes capabilities for managing multiuser geodatabases in a number ofDBMSs.
When you need a large multiuser geodatabase that can be edited and used simultaneously by many users
or that can be synchronized across many copies (replicas) of the database, the geodatabase provides a
good solution.
ArcGIS for Server adds the ability to manage shared, multiuser geodatabases as well as support for a
number of critical multiuser database workflows. The ability to leverage your organization's enterprise
relational database is a key advantage. Multiuser, transactional geodatabases work with a variety of
DBMS storage models (for example, IBM DB2, Informix, Oracle, PostgreSQL, and SQL Server).
Geodatabases take full advantage of underlying DBMS architectures to support the following:
• Extremely large, continuous GIS databases
• Many simultaneous users
• Long transactions and versioned workflows
• Relational database support for GIS data management (providing the benefits of a relational
database for scalability, reliability, security, backup, integrity, and so forth)
• SQL types for spatial in all supported DBMSs (Oracle, SQL Server, PostgreSQL, Informix, and
DB2)
• High performance that can scale to a very large number of users
DBMSs are efficient at retrieving and working with records containing the type of large geometry
elements required for GIS data. In addition, GIS database sizes can be much larger, and the number of
supported users greater, than with file-based GIS datasets.
9. Esri GIS ArcGIS: Geodatabase management I Municipal Maintenance and Infrastructure Asset
Management Systems
B-24
10. PROFILE: Azteca Systems CITYWORKS
5
4
3
2
1
0
Cityworks
10. PROFILE: Azteca Systems CITYWORKS I Municipal Maintenance and Infrastructure Asset
Management Systems
B-25
10. PROFILE: ACCELA
5
4
3
2
1
0
Accela
10. PROFILE: ACCELA I Municipal Maintenance and Infrastructure Asset Management Systems
B-26
10. PROFILE: AGILE ASSETS
5
4
3
2
1
0
Agile Assets
10. PROFILE: AGILE ASSETS I Municipal Maintenance and Infrastructure Asset Management Systems
B-27
10. PROFILE: CARTEGRAPH
5
4
3
2
1
0
Cartegraph
10. PROFILE: CARTEGRAPH I Municipal Maintenance and Infrastructure Asset Management Systems
B-28
10. PROFILE: ELEMENTS
5
3
2
1
0
Elements
10. PROFILE: ELEMENTS I Municipal Maintenance and Infrastructure Asset Management Systems
B-29
10. PROFILE: ENERGOV
5
4
3
2
1
0
Energov
10. PROFILE: ENERGOV I Municipal Maintenance and Infrastructure Asset Management Systems
B-30
10. PROFILE: INFOR/HANSEN
5
4
3
2
1
0
In for
10. PROFILE: IN FOR/HANSEN I Municipal Maintenance and Infrastructure Asset Management
Systems
B-31
10. PROFILE: LUCITY (GBR)
5
4
3
2
1
0
Lucity { G BA)
10. PROFILE: LUCITY (GBR) I Municipal Maintenance and Infrastructure Asset Management Systems
B-32
10. PROFILE: MAINTENANCE CONNECTION
5
4
3
2
1
0
Maintenance
10. PROFILE: MAINTENANCE CONNECTION I Municipal Maintenance and Infrastructure Asset
Management Systems
B-33
10. PROFILE: IBM MAXIMO
5
4
3
2
1
0
Maximo
10. PROFILE: IBM MAXIMO I Municipal Maintenance and Infrastructure Asset Management Systems
B-34
10. PROFILE: ORACLE
5
4
3
2
1
0
Oracle
10. PROFILE: ORACLE I Municipal Maintenance and Infrastructure Asset Management Systems
B-35
10. PROFILE: PUBWORKS
5
4
3
2
1
0
Pubworks
10. PROFILE: PUBWORKS I Municipal Maintenance and Infrastructure Asset Management Systems
B-36
10. PROFILE: VUEWORKS
5
4
3
2
1
0
Vueworks
10. PROFILE: VUEWORKS I Municipal Maintenance and Infrastructure Asset Management Systems
B-37
10. PROFILE: CITYVIEW
5
4
3
2
1
0
Cityview
10. PROFILE: CITYVIEW I Municipal Maintenance and Infrastructure Asset Management Systems
B-38
11. WATER UTILITIES: INNOVYZE
Innovyze is a leading global provider of wet infrastmcture business analytics software solutions
designed to meet the technological needs of water and wastewater utilities, government industries, and
engineering organizations worldwide.
Underground infrastmcture is rapidly deteriorating and many utilities stmggle with developing a
rehabilitation and replacement program that addresses the most critical pipes in the system. Many capital
improvement programs spend millions of dollars annually, but often do little to lower total system risk.
Cap Plan Water offers utilities the tools in one off-the-shelf software package to build or refine the
capital improvement plans to provide maximum benefit for the lowest cost. Determining the likelihood
of failure for a pressurized underground water pipe is a critical task. Cap Plan Water combines
infrastmcture, hydraulic, spatial, and historical data from numerous sources to estimate for likelihood of
failure. Understanding the consequences of a pipe failing is critical to determining its replacement
priority. CapPlan Water has powerful tools to assess the hydraulic, geographic, spatial, and public
relations criticality of each pipe in the system-including automatically taking each pipe out of service
and determining the hydraulic and water quality consequences. A Risk Factor is determined for each
pipe based on the Likelihood and Consequence of Failure. CapPlan Water has a wide range of budgeting
options available to evaluate the highest priority pipes within existing budgets and to determine
necessary budgets over the long-tetm to mitigate high risk levels.
C~.;J"'.@ In ,.,-,,-.;----. ,: AOO) ~·1
~,,..,,,., ·-\ '•.\',,, 'fl'o:~): ;I"'<'J t'>'4~~~ ~": '/1",,4' V~? )U
11. WATER UTILITIES: INNOVYZE I Municipal Maintenance and Infrastructure Asset Management
Systems
B-39
12. REFERENCES
The Water Research Foundation would like to acknowledge and thank the researchers and contributors
to this study.
• American Public Works Association (APW A) members www.apwa.net
• California Society of Municipal Finance Officers (CSMFO) members www.csmfo.org
• Government Finance Officers Associations (GFOA) members www.gfoa.org
• Interviews of software marketing and technical staff at industry conferences.
• http:/ /resources.arcgis.com
• http://www.fhwa.dot.gov
• http:/ /www.nrc-cnrc.gc.ca/eng/index.html
• www.accela.com
• www.agileassets.com
• www.cartegraph.com
• www.cityworks.com
• www.elementsxs.com
• www.energov.com
• www.esn.com
• www.infor.com
• www.infotivity.com
• www.mnovyze.com
• www.lucity.com
• www.maintenanceconnection.com
• www.msgovern.com
• www.oracle.com
• www.oracle.com
• www.plantservices.com
• www.pubworks.com
• www.reliabilityweb.com
• www.vueworks.com
• www-Ol.ibm.com
12. REFERENCES I Municipal Maintenance and Infrastructure Asset Management Systems
B-40
WFRF
The Water Finance Research Foundation (www.Water FinanceRF.org) is a non-profit organization
dedicated to finding solutions which help local governments and utilities address the challenges of aging
infrastructure, funding and a declining workforce. The WFRF supports and provides research, surveys,
analysis, publications and training concerning best practices for municipal and utility management.
The WFRF promotes municipal infrastructure asset management practices for state, county and local
governments which increase efficiencies while reducing long-tetm operations, maintenance, and capital
costs. A special focus is on wet infrastructure which includes water, wastewater, storm drain and reuse.
A core program also includes creating opportunities for the next generation to gain knowledge and
experience through research and publication opportunities. The WFRF also strives to help municipalities
and utilities explore financing and funding solutions which includes rate and fee increases, debt
refinancing, private-public partnerships, grants and other innovative programs.
The Water Finance Research Foundation is proud to sponsor and promote in 2013, The American Public
Infrastructure Asset Management Association (API-AMA). API-AMA focuses on traditional municipal
infrastructure asset management combined with public asset management (the connectivity of assets
with business activities and citizens). The evolution and power of GIS and other technologies has
increased our ability to translate data into intelligence for improved resource investment decision
making.
The American Public Infrastructure Asset Management Association API-AMAA represents:
• Public Works Managers
• Municipal and Utility Asset Managers
• GIS Professionals
• CMMS (Computerized Maintenance Management Systems) Personnel
• Asset Management and Work Order Maintenance Management Software Managers
• Risk Management Managers
• Infrastructure and Design Engineers
• Capital Funding and Budget Approval Professionals
• Economic Development and Growth Planning Managers
WFRF I Municipal Maintenance and Infrastructure Asset Management Systems
B-41
LEGAL NOTICE
Please be advised, this study and survey was completed based on numerous sources including third parties and has not been
independently verified. Software is continually updated and revised and the information and functionality assessment is
evaluated at a point in time and does not represent future enhancements. WFRF assumes no legal liability or responsibility for
the accuracy, completeness, or usefulness of any information, nor does the WFRF represent that its use would not infringe on
any privately owned rights. This study may include facts, views, opinions and recommendations of individuals and
organizations deemed of interest and assume the reader is sophisticated in this industry and will make their own independent
decisions. Users waive any rights it might have in respect of this study under any doctrine of third-party beneficiary, including
the contracts (Rights of Third Parties) Act 1999. The use of this study is at the users' sole risk and no reliance should be placed
upon any other oral or written agreement, representation or warranty relating to the information herein.
THIS STUDY IS PROVIDED ON AN "AS-IS" BASIS, WFRF DISCLAIMS ALL WARRANTIES OF ANY KIND, EXPRESSED OR IMPLIED,
INCLUDING, WITHOUT LIMITATION, ANY WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NON-
INFRINGEMENT. WFRF, NOT ITS MEMBERS, AFFILIATES, SERVICE PROVIDERS, OFFICERS, DIRECTORS, OR EMPLOYEES SHALL BE
LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF OR RELATING TO
THIS REPORT OR RESULTING FROM THE USE OF THIS REPORT, INCLUDING BUT NOT LIMITED TO DAMAGES FOR LOSS OF
PROFITS, FUTURE PROFITS, USE, DATA OR OTHER TANGIBLE DAMAGES, EVEN IF SUCH PARTY HAS BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES. THE CONTENT OF THIS STUDY SHOULD NOT BE USED FOR ANY UNLAWFUL OR UNINTENDED
PURPOSE.
WFRF I Municipal Maintenance and Infrastructure Asset Management Systems
B-42
! 1
I 0
I
7 /\ !
Cityworks
'JPAI!/\L SLHVICLS, LLC
a esri ~~rtnarNatwork
CITY OF RANCHO PALOS VERDES
CITYWORKS IMPLEMENTATION PROPOSAL:
AMENDED JANUARY 28, 2015
Miller Spatial Services, LLC offers a full-spectrum implementation and integration of Azteca's
Cityworks asset management software for public works and utility districts. We have a team of GIS
and database management experts who specialize in the implementation of Cityworks applications.
The following schedule outlines a typical scope of work provided in our complete configuration
package:
TASKS & DESCRIPTION TIM ELINE COST
TASK 1 -Business Process Analysis Meetings 6 Days $9,600
We will meet with key department personnel to document the
specific business processes currently in place. Information
collected will include the daily work orders and maintenance
management cycles needed to be configured into Cityworks. This
is an integral part of the process for us to capture the complete
functionality of the current system and integrate those
components into the Cityworks platform. We will also analyze the
need for any additional hardware and 3rd party software add-ons.
This task will take place onsite in workshop-style meetings with
necessary IT and department managers, and may occur over 6
days. RPV will start internal meetings first to look at their
coordinated processes.
SUB-TASK 1.1-Project Management 20 Hours $2,100
Oversight of entire project will be managed by MSS to include:
timeline, deliverables, contract management, and costs.
TASK 2 -Database Configuration 7 Days $7,600
Using the current structure of the client's database, we will
configure the data and GIS layers into Cityworks. ArcGIS Server is
an optional add-on installation for data storage. The timeline for
the database configuration will vary depending on the status of
current stored data. This task will take place offsite.
TASK 3 -On site Cityworks Installation 7 Days $9,800
The configured database and Cityworks software package
(Cityworks Server AMS Standard ELA) will be installed onsite in
the client's environment. Changes to the configuration can be
made during this time. Storeroom Configuration will be part of
this task. A meeting will need to be held with inventory
controllers to discuss requirements prior to setup.
TASK 4 -Administrator User Training 1 Day $1J70
B-43
Cltyworks
. -. -o ~ • SP,i'ITII\l SEHVICFS, ll C -esri ~~~ner Network
We will provide onsite training for the primary, or "Administrator"
users of Cityworks. The client will provide the training facility and
computers necessary for staff use.
TASK 5 -Additional Staff Training 3 Days $4,800
Following the training of Administrator users, we will conduct a
"Train-the-Trainer" style session with key department staff. The
purpose of this training is to provide the knowledge and steps
necessary to train all other field personnel who will use the
system.
Training will be broken into small groups of users depending on
work responsibility.
TASK 7 -Post-Installation Support 40 Hours $6,000
After the configuration, installation and training phases have
concluded, we will provide troubleshooting and support services
of up to 40 hours (may be negotiable). This support will primarily
be remote and take place offsite.
TOTALS (Dependent on Add-Ons) $41,070
B-44
--+·
__Q
._S,
>-
License Type: Named User
Cityworks Server AMS
Workgroup Essential
Cityworks Server AMS
Workgroup Standard
License Type: Unlimited User
Cityworks Server AMS Essentials
ELA
Cityworks Server AMS Standard
ELA
Cityworks Server AMS Premium
ELA
CityWorks Pricing Models
Description COST: Initial 5 named user logins COST: Per license after initial 5
INCLUDED: Server AMS +Local Government $6000.00 annually from year one $1000.00 annually from year one Templates (LGT)
INCLUDED: Server AMS =Local Government
Templates (LGT) +Native Mobile (Android and
$9000.00 annually from year one $1200.00 annually from year one iOS) + Use of the A Pis for 3rd party Cityworks-
centric applications
Description COST: Unlimited named user logins
Annual Enterprise License including update &
support, effective from the execution of
Cityworks license agreement. Includes software $30,000.00 annually from year one
licensing for Cityworks Server AMS, and Local
Government Templates (LGT)
Annual Enterprise License including update &
support, effective from the execution of
Cityworks license agreement. Includes everything
in ESSENTIALS AMS ELA, as well as; Storeroom, $45,000.00 annually from year one
Contracts, Cityworks Analytics, E-Url, the use of
the API's for 3rd party Cityworks-centric
applications, and AMS Mobile
Annual Enterprise License including update &
support, effective from the execution of
Cityworks license agreement. Includes everything
$60,000.00 annually from year one in STANDARD AMS ELA, as well as; the use and
premium support of all Cityworks API's for AMS
Integrations.
B-45
API License Type Description COST: Annual Support
Components and API interface enabling Work
Cityworks Work Order API Full-Order capabilities within client application for
$18,800.00 annually from year one
Maintenance Model Basic and advanced fields (example Labor,
Material and Equipment and Tasks)
Cityworks Metrics API -
Components and API interface enabling the
$5640.00 annually from year one I Maintenance Model
interaction of remote measurement data (SCADA
or Fuel management systems)
Cityworks Service Request API -Components and API interface enabling Service
$5640.00 annually from year one
Maintenance Model Request capabilities within client webpages
Cityworks Work Order API Basic -
Components and API interface enabling Work
Maintenance Model
Order capabilities within client application for $5640.00 annually from year one
Basic fields
Cityworks Inspection API -Components and API interface enabling
$5640.00 annually from year one Maintenance Model Inspections capabilities within client application
------------·------
B-46