HomeMy WebLinkAboutContract 34842-A17 DocuSign Envelope ID:5BE6FE08-378F-4517-B640-BA4E2541 D30E
CSC No. 34842-A17
AMENDMENT NO. 17
TO
CITY OF FORT WORTH CONTRACT 34842
This Seventeenth Amendment is entered into by and between the City of Fort Worth
(hereafter "Buyer"), a home rule municipality, with its principal place of business at 200 Texas
Street, Fort Worth, Texas, and CentralSquare Technologies, LLC ("Vendor"), Buyer and
Vendor may be referred to individually as a Party and collectively as the Parties.
WHEREAS,on January 31, 2007,the Parties entered into City Secretary Contract 34842
to provide a Computer Aided Dispatch ("CAD") System Purchase Agreement
("Agreement/Contract");
WHEREAS, the Parties wish to amend the Agreement to add data conversion and
professional services for a one-time cost of$7,020.00.
NOW, THEREFORE, the Parties, acting herein by and through their duly authorized
representatives, enter into the following agreement:
1.
AMENDMENTS
The Agreement is hereby amended to add Attachment A-4 CentralSquare Quote Q-96877
for data conversion and professional services in the amount of $7,020.00. The total cost of the
contract is $1,424,596.41.
2.
ALL OTHER TERMS SHALL REMAIN THE SAME
All other provisions of the Agreement which are not expressly amended herein shall
remain in full force and effect.
3.
ELECTRONIC SIGNATURE
This Amendment may be executed in multiple counterparts, each of which shall be
an original and all of which shall constitute one and the same instrument. A facsimile copy
or computer image, such as a PDF or tiff image, or a signature, shall be treated as and shall
have the same effect as anoriginal.
OFFICIAL RECORD
CITY SECRETARY
FT.WORTH, TX
Seventeenth Amendment to Fort Worth City Secretary Contract No. 34842 Page 1 of 9
DocuSign Envelope ID:5BE6FE08-378F-4517-B640-BA4E2541 D30E
ACCEPTED AND AGREED:
CITY OF FORT WORTH:
CONTRACT COMPLIANCE MANAGER:
By signing I acknowledge that I am the person
By: Valerie Washington(Ju113,202216:55 CDT) responsible for the monitoring and administration
Name: Valerie Washington of this contract,including ensuring all
Title: Assistant City Manager performance and reporting requirements.
Date: Jul 13, 2022
APPROVAL RECOMMENDED: By: Steven Van dever(Jun 30,202214:27 CDT)
Name: Steven Vandever
Title: Sr. IT Solutions Manager
By: APPROVED AS TO FORM AND LEGALITY:
Name: Kevin Gunn
Title: Director,IT Solutions Department
ATTEST: By:
Name: Taylor Paris
Title: Assistant City Attorney
:7G1�'l�'IG��G� GDOG�GIGG
By. Jan netteS.Good all(JU114,202210:34CDT) CONTRACT AUTHORIZATION:
Name: Jannette Goodall M&C: P-12272
Title: City Secretary oa�40R°��a Approved: November 13,2018
��00 o., 0 d 1295: 2018-417965
I•o° °°°$A�1�
0=d
° o°° �G
d
°° °° cY
n0,0,00
EXA5o4p
VENDOR:
Centrals u�,���Xj;gjologies, LLC ATTEST: D...Signed by:
�adn, �l-AAt,V'
By. —Ae?95�4Fftd er By Name:
`a ..es int
Title: cRo Title: contract specialist
Date: 6/29/2022
OFFICIAL RECORD
CITY SECRETARY
FT.WORTH, TX
Seventeenth Amendment to Fort Worth City Secretary Contract No. 34842 Page 2 of 9
DocuSign Envelope ID:5BE6FE08-378F-4517-B640-BA4E2541 D30E
Attachment A-4
CentralSquare Quote Q-96877
OF�; CENTRALSQUARE Quote prepared on:
May 05,2022
Quote prepared by:
Change Order Chris Grant
chris.grant@centralsquare.com
Quote#:Q-96877 Quote prepared for:
Primary Quoted Solution:PSJ Enterprise Melony Ebel
Quote expires on:August 02,2022 Fort Worth Police Department
Change Order in reference to: 200 Texas St.
Fort Worth,TX 76102
(817)392-2625
Thank you for your interest in CentralSquare.CentralSquare provides software that powers over 8,000 communities.More
about our products can be found at www.centralsQuare.com.
WHAT SERVICES ARE INCLUDED?
DESCRIPTION TOTAL
1. Public Safety Data Conversion Services-Fixed Fee 5,850.00
2. Public Safety Project Management Services-Fixed Fee 1,170.00
Services Total 7,020.00 USD
QUOTE SUMMARY
Services Subtotal
7,020.00 USD
Quote Subtotal 7,020.00 USD
MORE INFORMATION AT CENTRALSQUARE.COM
Seventeenth Amendment to Fort Worth City Secretary Contract No. 34842 Page 3 of 9
DocuSign Envelope ID:5BE6FE08-378F-4517-B640-BA4E2541 D30E
C E NT RALS Q UAR E Quote prepared on:
May 05,2022
Quote prepared by:
Change Order Chris Grant
chris.grant@centralsquare.com
Quote Total 7,020.00 USD
WHAT ARE THE RECURRING FEES?
TYPE AMOUNT
FIRST YEAR MAINTENANCE TOTAL 0.00
FIRST YEAR SUBSCRIPTION TOTAL 0.00
The amount totals for Maintenance and/or Subscription on this quote include only the first year of software use and
maintenance. Renewal invoices will include this total plus any applicable uplift amount as outlined in the relevant purchase
agreement.
BILLING INFORMATION
Fees will be payable within 30 days of invoicing.
Please note that the Unit Price shown above has been rounded to the nearest two decimal places for display purposes only.
The actual price may include as many as five decimal places.For example,an actual price of$21.37656 will be shown as a
Unit Price of$21.38.The Total for this quote has been calculated using the actual prices for the product and/or service,rather
than the Unit Price displayed above.
Prices shown do not include any taxes that may apply.Any such taxes are the responsibility of Customer.This is not an
Invoice.
For customers based in the United States or Canada,any applicable taxes will be determined based on the laws and
regulations of the taxing authority(ies)governing the"Ship To"location provided by Customer on the Quote Form.
PAYMENT TERMS
License Fees&Annual Subscriptions
- 100%Due Upon Contract Execution
Contract Startup
- 10D Due Upon Contract Execution
MORE INFORMATION AT CENTRALSQUARE.COM
Seventeenth Amendment to Fort Worth City Secretary Contract No. 34842 Page 4 of 9
DocuSign Envelope ID:5BE6FE08-378F-4517-B640-BA4E2541 D30E
e*® CENTRALSQUARE Quote prep are don:
� / May 05,2022
Quote prepared by:
Change Order Chris Grant
chris.grant@centralsquare.com
Hardware&Third-Party Software
- 100%Due Upon Contract Execution
Services
Fixed Fee:1001A Due Upon Completion
Time&Material:Due as Incurred
Services Bundle:Fixed Fee,100%Due Contract Execution
Third-Party Services
- Fixed Fee:50%Due Upon Contract Execution;50%Due Upon Completion
Travel&Living Expenses
- Due as Incurred
PURCHASE ORDER INFORMATION
Is a Purchase Order(PO)required for the purchase or payment of the products on this Quote Form?(Customer to complete)
Yes I I No I I
Customer's purchase order terms will be governed by the parties'existing mutually executed agreement,or in the absence of
such,are void and will have no legal effect.
PO Number:
Initials:
Fort Worth Police Department
City of Fort.Worth
Signature: Valerie Washington(Jul 13,202216:55 CDT)
Name: Valerie Washington
Date: Jul 13, 2022
Title: Assistant City Manager
MORE INFORMATION AT CENTRALSQUARE.COM
Seventeenth Amendment to Fort Worth City Secretary Contract No. 34842 Page 5 of 9
DocuSign Envelope ID:5BE6FE08-378F-4517-B640-BA4E2541 D30E
'F CENTRALSQUARE
Summary of Services
Project:Fort Worth Police,TX-ADD-Additional Data Conversion Items,Q-96877
The parties mutually agree and acknowledge this Summary of Services is a high-level overview of the project requested,
not a detailed requirements or design of solution.
Project Scheduling
Parties agree a schedule will be provided for services within sixty(60)days from the execution of the above quote
number.
Change Requests
The parties may request a change to this summary of services,to increase hours or deliverables,through a written
request to the CentralSquare project manager or resource.
Services Scope of Project
The project includes the following scope of services.
CentralSquare will convert the following additional fields into the Production or Training Enterprise RMS System as
detailed below.
• Beat
o Field name as Beat and code category of BEA
o In Tiburon database the field was Beat
• District
o Field name of ReportingArea with code category of REP
o In Tiburon database the field was Rep Dist
• Reporting Area
o Field name of District which pulls in the code category of TRC
o In Tiburon database the field was Council District
Data Conversion Overview
Data conversion is the implementation process of moving data from a legacy system or data files into your
CentralSquare software product. Data conversion is a highly collaborative process between the Client and
CentralSquare Technologies.
The listed data conversion services and their associated costs are based on CentralSquare's understanding of
Customer's needs and current system.Any modules not explicitly listed in this section are not part of the current
project scope and will not be included in implementation. If additional module conversions are required, each
one will come at an additional cost based on the scope of the work required for each.
The customer shall provide unencrypted data for conversion in one of the following compatible formats:
(a) MS SQL.bak files with database version and credential information
(b) MySQL.dump or.sqI files with database version and credential information
Confidential and Proprietary
Seventeenth Amendment to Fort Worth City Secretary Contract No. 34842 Page 6 of 9
DocuSign Envelope ID:5BE6FE08-378F-4517-B640-BA4E2541 D30E
(c) PostgreSQL.sgl files with database version and credential information
(d) MS Access 2003 or newer.mdb files
(e) CSV files with column headers and relationship mapping documentation
(f) Oracle 10g or newer backup files
No images,objects or attachments will be converted as part of this conversion unless explicitly purchased.
All Records Enterprise Default Summary Templates must be finalized(for all agencies)prior to data conversion
initiation.
Master Vehicles/Property/Locations will not be converted directly as they will be built through the import of
the other entities. CentralSquare Technologies standard Master Resolution rules will apply.
Master Location GEO Validation is not included in the conversion.
Where no directly corresponding default element exists in Enterprise RMS,legacy data may be stored in a
narrative or as an attachment to the original record.
If the Client desires any modification to their original data in order to include it in a Records Enterprise record,
they must fully document the transformation process used.All transformations so supplied must be able to be
implemented via scripts vs."human-interpretive"processes.These include but are not limited to names and
addresses.
CentralSquare Technologies will provide a Data Conversion Specifications document prior to executing the
data conversions.
The conversion supports a single data source. If additional sources are required, CentralSquare Technologies
can review and scope accordingly.
Data Conversion Process
The Data Conversion process is the work that drives the configuration and implementation process. Below are the
significant tasks included in this project.
Major Task Description
Schedule CentralSquare and the Client will schedule the Data Conversion Tasks as part
of the overall Project Schedule.Code Tables,configurations and Templates
must be built as part of the overall Project Schedule as a Pre-requisite for
Data conversion iterations to begin
Data Delivery Client will provide data in a format compatible with conversion and provide
to CentralSquare. For CentralSquare source products CentralSquare will
provide the extraction from the legacy format into CentralSquare's schema.
Setup CentralSquare will configure servers and systems needed for the Data
Conversion including the staging template database.
Template Agency to finalize default summary templates in Records Enterprise.
Finalization
System Walk An in-depth review between CentralSquare and the client SME will be held.
Through This meeting may be recorded,and the Client should be prepared to operate
within the UI of the old system to provide examples and context.A Data
Conversion Coordinator will draft the Data Conversion Specifications
Document.
2 1 Confidential and Proprietary MORE INFORMATION AT CENTRALSQUARE.COM
Seventeenth Amendment to Fort Worth City Secretary Contract No. 34842 Page 7 of 9
DocuSign Envelope ID:5BE6FE08-378F-4517-B640-BA4E2541 D30E
OPF
Major Task Description
Data Conversion Using the Data Conversion Specifications Document CentralSquare Engineers
Development will map the data to the target format and develop scripts to fulfill the Data
conversion Specifications Document.
Code Table Mapping CentralSquare will provide guidance on the Code Table Mapping Tool.Client
will Map Code Table data using the tool.
Data Conversion CentralSquare will convert data into the Client's system which has been
Iterations dedicated for Data Conversion Testing.This is an iterative process and may
involve new extracts and a refresh form the current Pre-Production system
into the Data conversion system and a purge of data from the Data
Conversion target system.
Review and Client will review data conversion and provide feedback via designated
Validation Central Square tools.This is an iterative process.
Sign Off Client Signs off on acceptance with the Data Conversion Verification
Document.
Go Live The Final Data Conversion is re-run as part of the Go Live
Final Sign Off The Client signs off on the Final Data conversion
Roles and Responsibilities
CentralSquare
• Work with the Client to identify,document and implement a comprehensive data conversion.
• Advise on possible conversion options.
• Advise on project milestone dates and client expectations.
• Provide training for the Client on using CentralSquare data mapping tools.
• Work with the Client to limit the number of go live conversion events.
• Perform one or more sample conversions.
• Provide training for the Client on validating the data conversion for completeness and accuracy.
• Convert legacy data into corresponding elements in the CentralSquare system.(Modifications to the CentralSquare system
or database for the purposes of data conversion will be limited or unavailable).
• Perform final delivery of data conversion.
Client
• Provide subject matter experts to complete data conversion tasks,including.
o Providing expertise in third-party data architecture
o Providing business processing logic for addressing data conversion
o Identify and schedule appropriate personnel to attend training.
• Provide data dumps in the prescribed format within thirty(30)days of Agreement signing.
• Provide routine data dumps throughout the implementation process.
If needed,provide a temporary workstation for data conversion personnel.
• If needed,provide UI access to the legacy system or test system for data conversion personnel.
• Provide a data dictionary or equivalent documentation to facilitate mapping data elements between the legacy system and
the CentralSquare database(s)
• Configure code values outside the scope of the data conversion process.
• Take responsibility for costs assessed by the legacy system or any other third-party for providing the data dumps.
• Configure code values and complete code value data mapping prior to data conversion processing.
3 1 Confidential and Proprietary MORE INFORMATION AT CENTRALSQUARE.COM
Seventeenth Amendment to Fort Worth City Secretary Contract No. 34842 Page 8 of 9
DocuSign Envelope ID:5BE6FE08-378F-4517-B640-BA4E2541 D30E
OF IN
• Use provided tools to translate(map)code values between your legacy system and your CentralSquare.
• Manual adjustments by the Client may be required on converted data to make it eligible for state submissions,reports,or to
align with new workflow processes.
• Perform manual back entry of legacysystem data saved after the final data cut if necessary.
• Perform data validation. Validate data converted is both complete and accurate. Report discrepancies during the
implementation process.(System downtime may be required to complete the data conversion process).
• Use provided tools to report data conversion issues.
• Provide sign-off of the converted data in a non-production environment.
• Provide sign-off of the converted data set into the production environment.
Project Management
Even in smaller,less complex projects,there needs to be a point of contact and someone driving a project to successful
completion.CentralSquare's Implementation Methodology ensures a project has the right amount of oversight needed
to successfully complete the work,no more no less.A CentralSquare Project Manager will be your point of contact for
the scoped work with you to develop a timeline to meet your needs,drive the timeline to completion,work to resolve
any issues that may arise during the life of the project,all while keeping you up to date so you have the peace of mind
your project is on track for a successful completion.
Professional Services
Throughout the course of the project,CentralSquare will use several types of services(defined herein)to complete the
necessary steps for successful deployment of the contracted services.The overall services aligned to implementation
include Consulting Services,Technical Services,Data Conversion Services,Training Services,and in some cases,
Installation Services.
4 1 Confidential and Proprietary MORE INFORMATION AT CENTRALSQUARE.COM
Seventeenth Amendment to Fort Worth City Secretary Contract No. 34842 Page 9 of 9
Official site of the City of Fort Worth,Texas
CITY COUNCIL AGENDA F°RT�1'
COUNCIL ACTION: Approved on 11/13/2018
Create New From This M&C
REFERENCE ** 13PAMEND TRI TECH SOFTWARE
DATE: 11/13/2018 NO.: P-12272 LOG NAME: SUPPORT SB ITS
CODE: P TYPE: CONSENT PUBLIC NO
HEARING:
SUBJECT: Authorize Amendment to the Systems Software Support Agreement in the Amount Up to
$800,000.00 Annually for Software and License Fees and Software Maintenance with
TriTech Software Systems for the Information Technology Solutions Department (ALL
COUNCIL DISTRICTS)
RECOMMENDATION:
It is recommended that the City Council authorize an amendment of the Systems Software Support
Agreement in an amount up to $800,000.00 annually for software and license fees, training, and software
maintenance for Computer-Aided Dispatch (CAD), Station Alerting System, mobile data and Records
Management System with TriTech Software Systems with annual renewal options.
DISCUSSION:
The City Police and Fire Departments utilize a TriTech Software Systems Computer-Aided Dispatch (CAD)
System and a Station Alerting System. Software support is provided under City Secretary Contract No.
48482.
On December 13, 2016, City Council authorized amendments to the TriTech System Purchase Agreement
and Software Support Agreement for the upgrade and support of the Records Management System (RMS)
with up to four additional one-year renewals (M&C C-28048).
On September 12, 2017, City Council authorized an amendment to the TriTech System Purchase
Agreement for additional software license fees and annual maintenance for enhanced mobile mapping
functionality for Police and Fire Department's mobile data computers, with up to four additional one-year
renewals (M&C C-28364).
This request for City Council authorization will consolidate all previously approved TriTech annual software
and license fees, training and maintenance fees and allow for the purchase of additional software and
training as needed. TriTech Software Systems Software Support Agreement City Secretary Contract No.
48482 will be amended for this authorization. The first year of support for the upgraded RMS is included in
the original upgrade costs.
TriTech Software Systems is the documented sole source provider for support and maintenance to the
existing applications (CAD, mobile data, Records Management System, interfaces and related software
modules and documentation).
ADMINISTRATIVE AMENDMENT. An administrative increase or amendment may be made by the City
Manager in the amount up to $100,000.00 and does not require specific City Council approval as long as
sufficient funds have been appropriated.
AGREEMENT TERMS: Upon City Council's approval, this Agreement will be effective upon execution of
contract amendment and remain in effect through September 30, 2019.
RENEWAL OPTIONS: This annual maintenance fees may be renewed for up to four additional one-year
terms by mutual agreement of the parties. This action does not require specific City Council approval
provided that the City Council has appropriated sufficient funds to satisfy the City's obligation during the
renewal term.
FISCAL INFORMATION/CERTIFICATION:
The Director of Finance certifies that funds are available in the current operating budget, as appropriated,
and that prior to an expenditure being made, the Information Technology Solutions Department has the
responsibility to validate the availability of funds.
BQN\AMENDTRI\SB
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 Manager's Office by: Susan Alanis (8180)
Originating Department Head: Kevin Gunn (8517)
Additional Information Contact: Cynthia B. Garcia (8525)
Sheila Baker (8356)
ATTACHMENTS
SAMS 11-06-2018.pdf (CFW Internal)
Sudan Terrorist check.pdf (CFW Internal)
TERRORIST ATTACK 11-06-2018.pdf (CFW Internal)
TriTech Form 1295.pdf (Public)