To: MAYOR AND CITY COUNCIL
From: CHRISTOPHER BENSON, INFORMATION TECH DIRECTOR
TITLE
title
APPROVE AGREEMENT WITH HITECH SYSTEMS INC. DBA PULSIAM FOR SAFETYNET REPORTING SERVER SOFTWARE AND DATA MIGRATION SERVICES FOR THE AMOUNT NOT TO EXCEED $51,845.60 FOR THE TERM JANUARY 19, 2021 TO JANUARY 18, 2022.
end
EXECUTIVE SUMMARY
On December 17, 2017, the Redondo Beach City Council approved a five-year agreement with Mark43 for a replacement Records Management System (RMS), with an option to purchase the Computer Assisted Dispatch (CAD). On July 2, 2019 the purchase of CAD was approved in addition to a first amendment to the master agreement to facilitate a complete RMS and CAD transition from the existing vendor Hitech Systems / Pulsiam (Pulsiam) to Mark43.
The Redondo Beach Police Department (RBPD) would like historical data migrated from the existing CAD/RMS to the new Mark43 system. Per the attached agreement, Pulsiam will install its SafetyNet Reporting Server and migrate ~28 years of public safety data from the existing proprietary database to a Microsoft SQL database. Mark43 can then migrate the exported data into their cloud solution. The SafetyNet Reporting Server will actively migrate data as the Pulsiam system is updated within the year-long agreement.
BACKGROUND
RBPD has utilized a CAD/RMS system since the 1980’s. Pulsiam CAD/RMS was selected in 1993 to replace a Command Data Systems CAD/RMS that had been in service since ~1986. Mark43 CAD/RMS was approved by City Council in 2017 to replace the current Pulsiam CAD/RMS.
Approximately 28 years of data exists within the current proprietary Pulsiam database. Both RBPD and Mark43 wish to migrate much of this historical data into the new Mark43 CAD/RMS system. This can only be accomplished if the historical data resides in a Microsoft SQL database. The only way to reliably migrate data out of the Pulsiam database in a way that makes it available for Mark43 to import is to use Pulsiam’s SafetyNet Reporting Server product.
The most important of the historic records are the evidence records. In particular, the chain of custody for evidence that has been booked/stored - specifically for high profile crimes (Homicides, Rapes, etc.). The chain of custody for evidentiary items plays a key role in court proceedings. Other important historic data will be the records of actual contacts at certain locations/persons. This is used to identify problem locations, and locations that might have officer safety concerns. Included in the data migration are any associated file tables that contain codes and descriptions referenced in the data files and file indexes that connect the data together. The migrated historical data will also then be accessible via Mark43 reporting tools.
The SafetyNet Reporting Server will actively migrate RBPD historical data to a Microsoft SQL database and it will be supported by Pulsiam for as long as RBPD utilizes the Pulsiam CAD/RMS within the year-long agreement. Mark43 will begin the data migration process once the migrated data is tested and verified to be accurate. They estimate a six to nine-month time frame to migrate desired data into Mark43’s CAD/RMS. A completed data migration is not required in order to go live on the Mark43 CAD/RMS solution.
COORDINATION
Information Technology staff worked directly with Pulsiam, Mark43 and RBPD staff to structure the agreement. The agreement was approved as to form by the City Attorney’s office.
FISCAL IMPACT
The SafetyNet Reporting Server software, annual maintenance and associated services cost of $51,845.60 is funded from the FY20-21 IT Internal Service Fund. Pricing reflects a 40% discount, or $9,544 off of the SafetyNet Reporting Server software list price.
Funding |
|
|
Expenditures |
|
|
|
|
|
|
$51,845.60 |
IT Internal Service Fund |
|
$23,861.00 |
SafetyNet Reporting Server |
|
|
|
(9,544.40) |
Software Discount |
|
|
|
4,772.00 |
Annual Maintenance |
|
|
|
32,757.00 |
Installation, Configuration, Testing, Documentation, Project Management |
|
|
|
|
|
$51,845.60 |
|
|
$51,845.60 |
Total |
APPROVED BY:
Joe Hoefgen, City Manager
ATTACHMENTS
Pulsiam SafetyNet Reporting Server Agreement
Pulsiam Certificate of Insurance