HomeMy WebLinkAboutContract 59300-A2CSC No. 59300-A2
SECOND AMENDMENT TO
FORT WORTH CITY SECRETARY CONTRACT NO. 59300
This Second Amendment to Fort Worth City Secretary Contract No. 59300 ("Second
Amendment") is made between the City of Fort Worth ("Fort Worth"), a municipal corporation
and Geonexus Technologies, a limited liability company ("Vendor").
WHEREAS, Fort Worth and Vendor entered into an Agreement identified as Fort Worth
City Secretary Contract No. 59300 beginning April 26, 2023 (the "Agreement"); and
WHEREAS, the Agreement was amended to correct the term dates and make them match
the authorized term dates on the M&C 23-0204; that term commencing on July 1, 2023 and ending
on June 30, 2024;
WHEREAS, it is the collective desire of both Fort Worth and Vendor to amend the
Agreement to include additional goods and services for the implementation of, and software
subscription for, the MapEngine software as was approved on M&C 24-0456;
NOW THEREFORE, known by all these present, Fort Worth and Vendor, acting herein by
the through their duly authorized representatives, agree to the following terms, which amend the
Agreement as follows:
1. The Agreement is hereby amended by adding the Scope of Work for the MapEngine
Implementation, attached to this Second Amendment, as Exhibit E of the Agreement;
2. The Agreement is amended to increase the authorized compensation amount as
follows: one-time cost of $181,673.80 for the implementation services reflected in Exhibit E; and
an annual cost of $45,160.65 for the licensing as reflected in Exhibit E, for a total of $226,834.45.
Therefore, the first -year not to exceed amount for the overall contract equals $393,534.37. The
amount not to exceed after the first -year implementation, with the additional annual licensing cost,
equals $211,860.57.
3. All other terms, provisions, conditions, covenants and recitals of the Agreement not
expressly amended herein shall remain in full force and effect.
[Signature Page Follows]
OFFICIAL RECORD
CITY SECRETARY
FT. WORTH, TX
Second Amendment to Fort Worth City Secretary Contract No. 59300 Page I of 3
Executed effective as of the date signed by the Assistant City Manager below.
FORT WORTH:
City of Fort Worth
Contract Compliance Manager:
By signing I acknowledge that I am the person
responsible for the monitoring and
By:
administration of this contract, including
Name: Fernando Costa
ensuring all performance and reporting
Title: Assistant City Manager
requirements.
Date: May 31, 2024
Y4 ✓
By: Jeff Ryan (May 23, 26247:46 CDT)
Approval Recommended:
Name: Jeffrey Ryan
Title: IT Manager, Water Department
C&tk-� HA-IF-A&r Approved as to Form and Legality:
By: Christopher Hauler (May 31, 202415:44 CDT)
Name: Christopher Harder
Title: Director, Water Department%�-
0 4 n°ny
�. FORT�oadP By:
Attest: ;�o e'er°, Name: Taylor Paris
PV8 �=G
`? °�� «� Title: Assistant City Attorney
By:
Name: Jannette Goodall
Title: City Secretary
VENDOR:
Geonexus Technologies, LLC
U44A.-
By: William A. Heise (May23, 202418:00 EDT)
Name: William Heise
Title: Founder & CEO
Date: May 23, 2024
OFFICIAL RECORD
CITY SECRETARY
FT. WORTH, TX
Second Amendment to Fort Worth City Secretary Contract No. 59300 Page 2 of 3
EXHIBIT E
Scope of Work for MapEngine Implementation
Second Amendment to Fort Worth City Secretary Contract No. 59300 Page 3 of 3
geo ne US 3005 Boardwalk Drive, Suite 107 866-839-4993
Ann Arbor, Michigan 48108 geo-nexus.com
Scope of Work for MapEngine Implementation
March 14, 2024
This Scope of Work (SoW) shall be governed by the Addendum to Software License Agreement, including
Exhibit A, Geonexus Software Subscription and Professional Services Quote, between The City of Fort
Worth and Geonexus Technologies, L.L.0 executed April 26, 2023.
The City of Fort Worth (City) is looking to replace GeoWorx Office with ActiveG MapEngine. This Scope
of Work (SOW) outlines the implementation of MapEngine and includes pricing for both software and
services to fulfill the City's needs.
MapEngine serves as a robust plugin for Maximo, seamlessly integrating Maximo and GIS through a GIS
or Map -Centric perspective. This powerful tool facilitates user -driven, query -based spatial search and
reporting, visually unlocking Maximo data for users. Users can spatially search Maximo or filter the map
display of work orders and service requests, utilizing a wide range of parameters for a user -defined
region or area on the map. MapEngine ensures easy integration via ArcGIS REST services, providing
Maximo users access to data from spatial systems, images, and other services. With a responsive,
mobile -friendly interface, MapEngine can be conveniently accessed on both desktop and mobile
devices.
MapEngine Functionality
The MapEngine Map will provide the following in all Maximo Map Enabled Applications
a) Maps based on an Esri ArcGIS Map Service.
b) Map look and feel defined by the ArcGIS MXD published to ArcGIS Server (City responsibility).
c) Full screen map in separate browser tab.
d) MapEngine personalized for each user's preferences of layer visibility.
e) Zoom to the extent of all selected features and items in the Maximo list.
f) Named/saved user extents (user -specific).
g) Select / highlight Maximo assets, locations, work orders, or service requests on the map.
h) Set Maximo Asset or Location based on map selected item.
i) Search for map items using standard MapEngine and Maximo search capabilities.
MapEngine Functionalitv included in Maximo Work Order Tracking and Service Requests:
a) Use the map to create work orders (WO) or service requests (SR) on assets or locations.
b) Create batch work orders from selected map items.
c) Find and select asset/location of WO or SR.
SYSTEMS CONNECTED. INTEGRITY ENSURED. Page 1 1
geo ne US 3005 Boardwalk Drive, Suite 107 866-839-4993
Ann Arbor, Michigan 48108 geo-nexus.com
d) Work Orders and Service Requests Display on map as point features.
e) Summary mode
Find and select one or multiple work orders or service requests by user -defined
parameters in Maximo.
Find and select one or multiple locations/assets by user -defined parameters in Maximo.
f) Spatial selection of Assets, Locations, Service Addresses, or Work Orders to add to application
List Tab's List table (Where Clause)
MapEngine Functionality included in Maximo Assets and Locations Modules
a) Find and select assets or locations via standard searches.
b) Find and select assets by clicking on the map.
c) Find and select assets and locations using searches in the Maximo List tab.
In February 2021, Geonexus and ActiveG established a strategic partnership, merging Geonexus' Data
Synchronization Platform with ActiveG's MapEngine to provide a comprehensive solution for integrating
IBM Maximo and Esri ArcGIS. As part of this collaboration, Geonexus is now an authorized reseller of
MapEngine and offers related implementation services.
Below is our proposed Scope of Work (SOW) aimed at providing GIS Application Integration to the City
of Fort Worth, utilizing MapEngine (version 4). This SOW outlines the project's work tasks, assumptions,
and deliverables in detail.
Task 1. Project Kickoff and Mobilization
1.1. Virtual Kickoff Meeting:
The kickoff meeting will commence by presenting an overview of the project's scope of work, aiming to
provide all stakeholders with a thorough understanding of the tasks and schedule. During this session,
key assumptions and expectations will be clarified to foster a shared understanding among project
participants.
Additionally, we will discuss remote system access, ensuring that all relevant parties have the necessary
access to systems and tools essential for the project. Furthermore, an examination of the current data
synchronization setup will take place, evaluating the existing processes and identifying any potential
enhancements required for seamless integration.
The main goal of this task is to ensure alignment among all team members and stakeholders with
respect to the project's objectives and requirements.
Assumption(s):
XSYSTEMS CONNECTED. INTEGRITY ENSURED. Page 1 2
geo ne US 3005 Boardwalk Drive, Suite 107 866-839-4993
Ann Arbor, Michigan 48108 geo-nexus.com
■ The meeting will be up to 3-hours in duration and facilitated virtually using Microsoft Teams,
WebEx, or a similar web meeting platform.
■ City will schedule and invite the appropriate staff to attend and participate in the kickoff
meeting.
Deliverable(s):
■ Meeting notes and PowerPoint slides.
Task 2. Requirements and Design
2.1. Requirements Workshops and Specification.
This task aims to comprehensively capture the City's requirements for the utilization of MapEngine in
supporting daily business operations. The focus will be on gathering essential information that will guide
the configuration of the application's appearance and the map interface. Additionally, specific
discussions will be conducted to determine the requirements for logically routing and sequencing work
orders in Maximo. The ultimate output of this task will be a configuration specification, serving as a
blueprint to configure MapEngine to meet the specific operational needs of the City.
The following are categories of configurations to be discussed:
■ Pick Lists: Determining the fields to be exposed in application pick lists.
■ Identifying the Maximo application screens used to launch MapEngine.
■ Gathering user preferences regarding layer visibility.
■ Defining the types of stored displays and predefined extents to configure.
■ Document specific requirements for logically routing and sequencing a set of work orders in
Maximo.
Assumption(s):
■ Up to 3, 3-hr workshops.
■ Workshops performed remotely using virtual meeting software.
■ Schedule and invite the appropriate staff to attend and participate in the workshops.
■ Vehicle tracking and turn -by -turn navigation/routing is not a requirement and will not be
implemented.
Deliverable(s):
■ Workshop facilitation.
■ MapEngine Configuration Requirements Specification.
Task 3. Install and Configure MapEngine in DEV Environment
The purpose of this task is to install and configure MapEngine in accordance with the specified
requirements captured during the requirements meeting with key stakeholders, business users, and IT
resources. The goal is to ensure seamless integration with the City's systems and align MapEngine with
the established configuration specifications.
3.1. Install MapEngine in Test Environment.
SYSTEMS CONNECTED. INTEGRITY ENSURED. Page 1 3
geo ne us
3005 Boardwalk Drive, Suite 107 866-839-4993
Ann Arbor, Michigan 48108 geo-nexus.com
MapEngine will be installed in a non -production, test, instance of Maximo and ArcGIS.
Assumptions:
■ Current out of the box functionality will be configured during this task.
■ The City GIS staff will be responsible for creating all map services and associated MXD files that
Map Engine will consume.
■ Assets, Locations, and Service Addresses have spatial X, Y coordinates populated.
■ GISPARAMI or like field is populated in Maximo defining the feature service to Maximo
Classification relationship.
Deliverables:
■ MapEngine is running in a non -production (Test) environment.
3.2. Configure Maximo Work Orders in MapEngine
MapEngine will be configured to display interactive Maximo point work orders. To accomplish this, the
following steps must be taken:
1. Synchronize GIS data with Maximo for Assets, Locations, and Service Address, whose work
orders will be viewed, using the Geonexus Integration Platform or GeoWorx Sync. Key items
required for synchronization are:
a. XY information for each Asset, Location, and Service Address.
2. Append all existing work orders with XY coordinates derived from the X,Y from asset, location,
or service address. This requires that two customer fields are created on Work Orders, one for X
coordinate and one for Y coordinate.
3. Implement an automated process to keep Maximo work orders updated with proper and
accurate coordinates.
Assumptions:
Out -of -the -box product features outlined at https://sui)port.activeg.com under the MapEngine 4
section will be provided. Please review both the MapEngine 4 Administrators and MapEngine 4 User
Guide sections for limitations and capabilities, particularly:
1. Setting up layers and tooltips. https://support.activee.com/knowledee-
base/mapengine/me4/admin/me4-lavers-and-tooltips/. A default configuration for all assets
and locations and then training on how to customize specific layers, as desired will be provided.
2. Work order form fields and other settings. https://support.activee.com/knowledee-
base/mapengine/me4/admin/me4-miscellaneous/
3. Actions for map selections. https://support.activee.com/knowledee-
base/mapensine/me4/users-me4/action-menu/
4. Any customization required beyond the capabilities outlined in these specifications will require
additional service hours.
SYSTEMS CONNECTED. INTEGRITY ENSURED. Page 14
geoznexus
3005 Boardwalk Drive, Suite 107 866-839-4993
Ann Arbor, Michigan 48108 geo-nexus.com
Deliverables:
IN MapEngine with base functions are configured in Test.
3.3. Assign Nearest Crew Based on Status and Person Group of Work Order
The city desires MapEngine to have the capability to identify the nearest crews by status and person
group of the work order. This functionality should enable users to select and assign the preferred
technician to the respective work order.
Assumptions:
■ Technician job skills are available in Maximo to support this functionality.
Deliverable
■ MapEngine is configured for work order assignments.
Task 4. Develop Enhancements in DEV Environment
4.1. Route and Work Order Sequencing Development
Optimize the Sequencing of Route Stops via MapEngine
Users will be able to open, view, and edit the route stops of a Maximo Route in MapEngine's UI.
ActiveG will add a button to the Route Editor in MapEngine to open an Optimization modal, which will
include options to select the starting and ending locations from which to calculate the optimal travel
sequence from route stop to route stop.
figure 1- ill of route sequencing options, with 3 options for setting the start and end points of the route: Ij by address, 2)
by map coordinates, and 3) by the first point in the route.
All
wo
® Search... i ' H
Son Morcos ,
Ory Fork
Route Editor vo
Stan and End Points +
Drag Stops In the list to reorder them. Click on a feature on n
the map to add it as a route stop. Start Address: Stan Address +
nI • Add Route Stops To Selections
Create WOs End Address: Address..
10. HY023
0 r ♦ -
start X x...
tooreinates,
20. HYl
Q FL
30. HYD499
Q kio v, a
End X x...
Dn,
cnnrdinarea
40. 11204
Q
B Use first Rppte Slop as start and end poi nL
so_ nrottsss
Q
+
X
SYSTEMS CONNECTED. INTEGRITY ENSURED. Page 15
geo ne US 3005 Boardwalk Drive, Suite 107 866-839-4993
Ann Arbor, Michigan 48108 geo-nexus.com
After defining the start and end locations and initiating the optimization, the sequence of the route
stops will be updated to the optimal travel sequence, based on the start and end points and the user
can then save the route with the new sequence.
4.2. Optimize the Sequencing of Child Work Orders
Users of MapEngine will be able to open and display the location of child work orders for a given parent
work order on the map.
ActiveG will add an option to MapEngine to optimize and set the sequence of the child work orders, like
the process mentioned above for route stops. User will open an Optimization modal, which will include
options to select the starting and ending locations from which to calculate the optimal travel sequence
for the work orders and then set that sequence in Maximo.
4.3. Support for Service Addresses
Out of the box MapEngine does not support mapping Maximo service addresses. The following features
will be added to MapEngine to support service addresses.
4.3.1. Service Address Searching
ActiveG will configure a search in MapEngine labeled Service Address that will allow users to search
service addresses by ADDRESSCODE and other GIS fields for the associated service address source
data. The map in MapEngine will zoom to the selected result and put a marker at the location of the
service address feature.
® -1 s 9 �
2%Hopkins
OSearch Results M ,,
R41482
216 E HOPKINS ST
R70584
726 W HOPKINS ST
R41597
312 W HOPKINS ST
R41595
302 W HOPKINS ST
R32197
322 W HOPKINS ST
SYSTEMS CONNECTED. INTEGRITY ENSURED. Page 1 6
geoznexus 3005 Boardwalk Drive, Suite 107 866-839-4993
Ann Arbor, Michigan 48108 geo-nexus.com
li
2%Hopkins
OPRCL5947
Parcel ID: R41482
Address: 216 E HOPKINS ST
Tax ID: R41482
= 328318 • u~ 306
• 20312
312 301 • 313
�3063211M �" 220 314
0
234232 214 222 216 2
209 •
226 209 • 206
230214 •
218 219 301 311214
`
2 2 217 }
1 M• fee
142 •
•38126 �1f 308
4122
iiiiii 118 123
` 114 • 100
112 i
10102
13 * 202 218 101
201 4 • 123 214
12613. 126
n�a 111331-
4.3.2. Setting the SADDRESSCODE value on the current Maximo WO from MapEngine
Once the user clicks a search result and opens the info card, they will be able to click a button "Set
service address on WO" which will append the SADDRESSCODE value to the open WO in the Maximo
window.
N 4„ z� zo
212 114
B
i F i R63002
zu
Service Address Cade: R63002
zao zzl loo
Address: 305 QUARRY SPRINGS DR
City: N
4.3.3. Mapping Work Orders with Service Addresses.
ActiveG will configure the logic for setting work order coordinates to follow the Client's preferred
hierarchy for setting work order coordinates (Asset, then Work Location [Service Address], then
Location).
ActiveG will also add an option to zoom/map the currently active Maximo work order's service address
location.
SYSTEMS CONNECTED. INTEGRITY ENSURED. Page 1 7
geo/ne -us
3005 Boardwalk Drive, Suite 107 866-839-4993
Ann Arbor, Michigan 48108 geo-nexus.com
343 � iZ • �
321 • 2U 26318
312 301 •
313
317 3U6 211
119 WO
Service "Address
Select Asset(s) from Current WO
3010 y
0
•
• 214 222 •
Select Location from Current WO
r 237 234232 •
209
Selected Features
e118 23*' 226 209
Go to Service Address from Current WO 24 230214
218 214 219
202 217
Select Current Maximo Record
I 109127129139 '
107 .
.000/
Select Maximo List items
�- —; •3aiZ6 216
4122
Draw Extent For Query
118 123
11� t 114
t
• 112
1U102
c
•
The "Select Current Maximo Record" option moves the map to the XY location of the work order.
Task 5. Map Engine Training
5.1. Facilitate Training Workshop
The purpose of this task is to provide end user and administration training
to designated staff. The
following outlines the two training and designated personnel.
A
MapEngine Those people designated to Virtual Training
Typically, these attendees are GIS
Administration administer and maintain up to 4 Hrs.
and Maximo administrators.
MapEngine
MapEngine Anyone who will be using Virtual Training
Train the Trainer for Maximo users,
Usage MapEngine. up to 4 Hrs.
including planners, schedulers,
maintenance supervisors,
maintenance crew members.
Assumptions:
■ Training materials will be provided electronically.
■ The city is responsible for determining the students for each training session.
■ Train the "trainer" style training.
Deliverable
■ MapEngine User Training.
■ MapEngine Administrator Training.
■ Training Materials.
Task 6. Migrate MapEngine to Production Environment
XSYSTEMS CONNECTED. INTEGRITY ENSURED. Page 18
geo ne us
6.1. Install and Configure MapEngine in PROD
3005 Boardwalk Drive, Suite 107 866-839-4993
Ann Arbor, Michigan 48108 geo-nexus.com
After the GIS application is tested and accepted by the city, we will work with the City's IT Team to
promote the solution to the Production environment and perform unit testing prior to go -live.
Assumptions:
■ City's IT team is responsible for migrating the solution to Production with Geonexus support.
■ The City's IT staff will be willing and available during this task.
■ City is responsible for promoting the data synchronization solution to Production.
Deliverables:
■ MapEngine is migrated to Production.
Task 7. Hypercare
7.1. Hypercare
The purpose of Hypercare is to provide support during the transition from implementation to software
support. The support provided during this time is for anything relating to the implementation project
and is in addition to the support as described in the Support agreement.
Assumptions
■ Hypercare is a 30-day period that commences upon the migration of the software to the
Production environment i.e. completion of the previous task.
■ Support available between Sam and 5pm Eastern Time.
Deliverables
■ Virtual remote support.
We request that the city accept the following responsibilities:
1. Access and Permissions: Ensure that Geonexus personnel are provided with appropriate and
timely MAXADMIN access to the Maximo non -prod environments during installation and
configuration.
2. Data Synchronization: The City will ensure that all GIS features to be synchronized with Maximo
shall have a GIS field populated with their respective Maximo ID (ASSETNUM or LOCATION
value). This is necessary for the proper synchronization of GIS data with Maximo.
3. Feedback and Testing: Engage in thorough testing of MapEngine application in the UAT
environment. Provide clear, timely, and constructive feedback for any issues encountered or
improvements needed.
4. GIS Service Management: The city will ensure features published in GIS services for use with
MapEngine contain the corresponding Maximo ID (ASSETNUM or LOCATION) with that feature.
Other additional fields may be needed on the features to allow for full functionality.
SYSTEMS CONNECTED. INTEGRITY ENSURED. Page 19
geo ne US 3005 Boardwalk Drive, Suite 107 866-839-4993
Ann Arbor, Michigan 48108 geo-nexus.com
5. Escalation and Resolution: the City will promptly escalate any potential risks, issues, or
challenges faced during the course of the project to the designated point of contact for swift
resolution.
6. Final Sign -Off: Upon successful completion of all project stages, the City is responsible for
providing formal acceptance and sign -off, marking the official closure of the project.
The following are key assumptions that drive the proposed scope of work:
Data Synchronization
1. MapEngine depends upon data synchronization between Maximo and ArcGIS. Geonexus
assumes that the client has or will synchronize their data using the Geonexus Integration
Platform.
2. The City will ensure that all ArcGIS features to be synchronized will have the Maximo ID
(ASSETNUM or LOCATION). We assume that the City already has a process for managing the
assignment of a Maximo ID to the GIS feature.
Maximo Environments
1. Geonexus will install and configure MapEngine for the City's Maximo
1.1. Test, and
1.2. Production environments.
2. Maximo environments are 7.6.1.3 or greater.
MapEngine Server Environment
1. The City will install MapEngine Server on a local Windows Server or Linux machine, behind the
City's firewall. The benefits of this approach are:
a. No need to reinstall MapEngine server if the City Maximo environment moves to a
different host.
b. Local control.
MapEngine 4 comes out of the box with numerous capabilities. Many of these can be found at:
https://support.activeg.com/knowledge-base, under the MapEngine 4 User Guide section. All these
listed can be enabled as a part of this proposed implementation, excluding the building mode
functionality, which requires additional configuration (which could be configured later for additional
service hours).
1. Work performed will be done remotely.
2. Any travel required by the city for on -site visits in the initial phase of the project will be billed at
cost, in addition to the fees for services quoted below.
SYSTEMS CONNECTED. INTEGRITY ENSURED. Page 1 10
geo ne US 3005 Boardwalk Drive, Suite 107 866-839-4993
Ann Arbor, Michigan 48108 geo-nexus.com
3. A configured Maximo development environment with remote access and remote terminal services
shall be provided by the City for MapEngine portion of the implementation. The City will provide
MAXADMIN level access to Maximo Development environment, at a minimum.
4. Geonexus will perform the initial installation and configuration work in a Maximo development
environment. The city will migrate this solution into a Maximo production environment, with the
assistance of Geonexus.
5. Project meetings and team interaction will be conducted by web teleconference tools, such as
Microsoft Teams.
6. This cost estimate is valid for 90 days.
7. Prices do not include taxes, export/import fees, county/national/state/local licenses, or
data licenses (database drivers, ODBC drivers, Oracle licenses, ESRI software/data
licenses, ArcGIS licenses, etc.)
Software Subscription
ITE DESCRIPTION
MapEngine Annual software subscription for MapEngine Server.
Server Valid for 1 Maximo site. Includes software upgrade,
updates for 12-month term.
NIT FEE
1 $12,153.67 $12,153.67
MapEngine User Annual software subscription for MapEngine User. 400
Includes support for 12-month term.
Implementation Services
INVOICE
1 1.
2 2.
3 3.
4 4.
5
6
7
5.
6.
7.
MILESTONE
Project Kickoff and Mobilization
Requirements and Design
Install and Configure MapEngine in
Test environment.
Develop Enhancements in
Test Environment
Training
Migrate to Production Environment
Hypercare Period
$72.94 $29,174.75
Annual Fee $41,328.42
PAYMENT CRITERIA FIXED FEE
Kickoff meeting complete $4,389.00
Requirements specification approved $36,929.20
MapEngine is running in TEST $40,825.40
Enhancements are running in TEST $55,409.20
Training is complete $14,907.20
MapEngine is running in production $11,503.80
Hypercare period is complete $17,710.00
Total Fee $181,673.80
XSYSTEMS CONNECTED. INTEGRITY ENSURED. Page 1 11
Geonexus Pricing Schedule for MapEngine Amendment
Software Subscription
JULY 2024 —
LY 2025 —
JULY 2026 —
JULY 2027 —
DESCRIPTIOfU
FEE
M
JUNE 2025
JUNE 2027
JUNE 2028
Annual software
Unit
subscription for MapEngine
Fee
$12,153.67
$"12,518.28
$12,893.93
$13,280.65
MapEngine
Server_ Valid for 1 Maximo
Server
site_ Includes software
Unit
1
1
1
1
$"12,518.28
$12,893.83
$13,280.65
upgrade, u plates for 12-
Total "121153.67
month tens_
Annual software
Unit
nit
subscription for MapEngine
$75.12"77.38
$79.70
MapEngine
MapEngine
User_ Includes support for
User
12-month term_
Units
400
400
400
400
$30,049.99
$30,951.49
$31,880.00
Total $"29,174.75
Annual Subscription MapEngine
I
$41,32.8.42
I $42,568,27
$43,845.32
I $45,160.65
5/22/24. 1:32 PM M&C Review
ACITY COUNCIL AGEND
Create New From This M&C
DATE: 5/21/2024 REFERENCE NO.: **M&C 24-0456 LOG NAME
CODE: C TYPE: CONSENT PUBLIC
HEARING:
Official site of the City of Fort Worth, Texas
FORTWORTIl
60GEONEXUS
MAPENGINE
f►0n
SUBJECT: (ALL) Authorize an Amendment to City Secretary Contract 59300, the Sole Source
Agreement with Geonexus Technologies, LLC for the Implementation of, and the Software
Subscription for, the MapEngine Software, for the Additional Cost of $226,834.45 for a
Total Contract Amount of $393,534.37 in Year One and $211,860.57 for Any Renewal Term
RECOMMENDATION:
It is recommended that the City Council authorize an amendment to City Secretary Contract 59300,
the Sole Source Agreement with Geonexus Technologies, LLC for the implementation of, and software
subscription for, the MapEngine software, for the additional cost of $226,834.45 for a total contract
amount of $393,534.37 in year one and $211,860.57 for any renewal term.
DISCUSSION:
The Geonexus products provide the City of Fort Worth with the ability to utilize Database -to -
Geographic Information System (GIS) asset synchronization workflows, as well as all integrated
mapping application access and licensing. These tools allow the utility's field personnel the ability to
view, manage, and complete 100,000+ work orders involving over 1 million synchronized assets and
450+ users. However, GeoWorx Office does not fully meet the functionality and ease of use needs of
Water Field Operations.
MapEngine replaces GeoWorx Office as part of a strategic change for GeoNexus, to provide improved
performance for field users. It will deliver better functionality and ease of use. The MapEngine software
will seamlessly integrate Maximo and GIS through a GIS or Map -Centric perspective. It facilitates
user -driven, query -based, spatial search and reporting, visually unlocking Maximo data for users.
Users can spatially search Maximo or filter the map display of work orders and service requests,
utilizing a wide range of parameters for a user -defined region or area on the map. MapEngine provides
Maximo users access to data from spatial systems, images, and other services. With a responsive,
mobile -friendly interface, MapEngine can be conveniently accessed on both desktop and mobile
devices.
The contract cost is currently $166,699.92 annually. If this Mayor & Council Communication (M&C) is
approved, the implementation cost will increase the contract by $181,673.80, for the first year only,
and the annual software subscription will be an additional $45,160.65 per year. Therefore, if this M&C
is approved, the total contact amount will be amended to equal $393,534.37 the first year, and
$211,860.57 for the subsequent renewal years.
Funding is budgeted in the Other Contractual Services account within the Water & Sewer Fund for the
Water and Wastewater IT Services Department.
ADMINISTRATIVE CHANGE ORDER
An administrative change order or increase may be made by the City Manager in the amount up to the
maximum allowed under state law and the City Code and does not require specific City Council
approval as long as sufficient funds have been appropriated.
AGREEMENT TERM
The initial Agreement term began on July 1, 2023 and ended on June 30, 2024.
RENEWAL OPTIONS
This Agreement has four one-year renewal options. It is currently within the first renewal.
apps.cfwnet.org/council_packet/mc_review.asp?I D=32162&counciIdate=5/21 /2024
1/2
5/22/24, 1:32 PM M&C Review
DVIN
The Water Department was approved for a sole source exemption by the Legal Department.
Therefore, the business equity goal requirement is not applicable.
This project is located in ALL COUNCIL DISTRICTS.
FISCAL INFORMATION/CERTIFICATION:
The Director of Finance certifies that upon approval of the recommendation, funds are available in the
current operating budget, as previously appropriated, in the Water & Sewer Fund. Prior to an
expenditure being incurred, the Water Department has the responsibility to validate the availability of
funds.
TO
Fund Department Account Project Program Activity Budget Reference # Amount
ID ID Year (Chartfield 2)
FROM
Fund Department Account Project Program Activity Budget Reference # Amount
ID ID Year (Chartfield 2)
Submitted for City Manaqer's Office bV: Fernando Costa (6122)
Originating Department Head: Chris Harder (5020)
Additional Information Contact: Jeff Ryan (8539)
ATTACHMENTS
Geonexus-Form 1295.pdf (CFW Internal)
60GeoNexus MapEnaine FID.xlsx (CFW Internal)
60GEONEXUS MAPENGINE.docx (CFW Internal)
APPROVED Geonexus Chapter 252 Exemption Form Final.pdf (CFW Internal)
Conflict of Interest Question naire-GNX.pdf (CFW Internal)
M&C Review 23-0204.pdf (CFW Internal)
apps.cfwnet.org/counci I_packet/mc_review.asp? I D=32162&counci ddate=5/21 /2024 2/2
FoRTWORTH.
Routing and Transmittal Slip
Water
Department
DOCUMENT TITLE: Second Amendment of CSC 59300 - GeoNexus
M&C: CPN: CSO: 59300 DOC #:
TO:
William Heise - Signer
Jeff Ryan - Signer
Shane Zondor - Approver
Jan Hale — Approver ;7f
Chris Harder - Signer
Taylor Paris - Signer
Fernando Costa - Signer
Ron Gonzales - Approver
Jannette Goodall - Signer
Allison Tidwell — Form Filler
Charmaine Baylor - Acceptor
APPROVER INITIALS
KC
EXPLANATION
Please approve/sign this Second Amendment of Geonexus agreement CSC 59300, for the implementation
of MapEngine software. MapEngine will replace GeoWorx Office as part of a strategic change for
GeoNexus, to provide improved performance for field users. It will deliver better functionality and ease of
use.
The implementation cost will increase the contract by $181,673.80 in the first year only. The annual
software subscription will be an additional $45,160.65 per year. Therefore, the total contract amount will
equal $393,534.37 the first year, and $211,860.57 for the subsequent renewal years.
Current Contract, CSC 59300 $ 166,699.92
MapEngine Total Cost $ 226,834.45
Implementation Cost $ 181,673.80
Licensing Cost $ 45,160.65
Future Renewals Without Implementation Cost $ 211,860.57
Total Contract Amount with Everything, Implementation
Year Only $ 393,534.37
Water $ 113,417.23
Sewer $ 113,417.23
If you have any questions or concerns, feel free to call or email me.
Charmaine Baylor
Sr. IT Business Planner
Fort Worth Water Department
Phone: 817-392-6629
Email: Charmaine.bavlor(&,,fortworthtexas.2ov