HomeMy WebLinkAbout25T - PURCHASE OF CRIMEMAPPING_COM APPREQUEST FOR
COUNCIL ACTION
CITY COUNCIL MEETING DATE:
NOVEMBER 17, 2008
TITLE:
AGREEMENT WITH OMEGA GROUP,
INC.FOR PURCHASE OF THE
CRIMEMAPPING.COM APPLICATION
CI MANAGE
RECOMMENDED ACTION
CLERK OF COUNCIL USE ONLY:
APPROVED
^ As Recommended
^ As Amended
^ Ordinance on 1S` Reading
^ Ordinance on 2"d Reading
^ Implementing Resolution
^ Set Public Hearing For_
CONTINUED TO
FILE NUMBER
Authorize the City Manager and the Clerk of the Council to execute the
attached agreement with Omega Group, Inc. for the purchase of Omega's
CrimeView application, Crimemapping.com, and the maintenance and
installation of such application, for a one-year period, in an amount not
to exceed $30,290, subject to non-substantive changes approved by the City
Manager and City Attorney.
DISCUSSION
On July 3, 2003, Council approved an agreement by which the City of Santa
Ana purchased software licenses, and maintenance for Omega's CrimeView
software application. Omega has recently developed a web-based version of
the CrimeView application, Crimemapping.com, which the City desires to
purchase and which Omega agrees to install and maintain.
CrimeView is essential to law enforcement agencies that are committed to
Community Oriented Policing, Problem Solving and CompStat management. This
application allows agencies to geographically view and analyze data from
their RMS (Records Management System), CAD (Computer Aided Dispatch) and
known-offender data sets. Users can map, analyze, and report crime
incidents by type, proximity, or other search criteria.
FISCAL IMPACT
Funds are available in the Police Department's, Computer Services account
(no. 11-338-6291).
APPROVED AS TO FUNDS AND ACCOUNTS:
Paul M. Walters
Chief of Police
Police Department
Francisco Gutierrez Lam" ~j,f
Executive Director
2 5T-1 Finance & Mgmt. Services Agency
CRIME MAPPING. COM HOSTING AGREEMENT
THIS AGREEMENT is entered into on November 17, 2008, by and between The
Omega Group, Inc., a California corporation ("Omega") and the City of Santa Ana, a
charter city and municipal corporation of the State of California ("City").
RECITALS:
A. The parties entered into Contract A-2003-224, dated July 1, 2003, by which City
purchased software licenses, and maintenance for Omega's CrimeView software
application.
B. Omega has developed a web-based version of the CrimeView application,
Crimemapping.com, which the City desires to purchase and which Omega agrees to install
and maintain.
C. Omega retains all necessary proprietary rights, patents or and copyrights required to perform
the services detailed in this Agreement.
NOW THEREFORE, in consideration of the mutual and respective promises, and subject
to the terms and conditions hereinafter set forth, the parties agree as follows:
SCOPE OF SERVICES
A. Host Crimemappin~.com website.
Omega will provide dedicated or shared server computers, with an Internet address for
storage and access of City's content, and the Crimemapping.com website, as set forth in
Exhibit A, attached hereto and incorporated by this reference.
B. Conversion services
Omega shall provide conversion services from the CrimeView Desktop
application to ArcGIS 9.X Application, as set forth in Exhibit B, attached hereto and
incorporated by this reference.
2. COMPENSATION
Omega shall host Crimemapping.com for an annual fee of $2,880.00.
Omega conversion services, and license fees, shall not exceed $30,290.00, as set
forth in Exhibit B, attached hereto.
Payment by City shall be made within thirty (30) days following receipt of proper
invoice, evidencing work performed, subject to City accounting procedures. Payment
need not be made for work which fails to meet the standards of performance set forth in
the Recitals which may reasonably be expected by City.
25T-2
3. TERM
This Agreement shall commence on the date first above written. Maintenance
services shall commence on completion of all conversion services. The parties shall set
forth, in writing, the commencement date of maintenance services, which shall continue
for a one year period from that date. Maintenance services may be extended for
additional one-year periods, upon the written agreement of the parties.
4. INDEPENDENT CONTRACTOR
Omega shall, during the entire term of this Agreement, be construed to be an
independent contractor and not an employee of the City. This Agreement is not intended
nor shall it be construed to create anemployer-employee relationship, a joint venture
relationship, or to allow the City to exercise discretion or control over the professional
manner in which Omega performs the services which are the subject matter of this
Agreement; however, the services to be provided by Omega shall be provided in a
manner consistent with all applicable standards and regulations governing such services.
Omega shall pay all salaries and wages, employer's social security taxes, unemployment
insurance and similar taxes relating to employees and shall be responsible for all applicable
withholding taxes.
INDEMNIFICATION
Omega shall hold and keep harmless the City and all officers, employees,
volunteers and agents thereof from damages, costs or expenses in law or equity that may
at any time arise or be set up because of injuries to or death of persons or damage to, loss,
or theft of property, including City's personnel and property, or from any claim that
Omega's services or products infringe a proprietary right, patent or copyright arising by
reason of, or in the course of, Omega's or Omega's contractors, subcontractors, agents,
employees, or other persons acting on their behalf's negligent performance of this
contract; arising out of Omega's or Omega's contractors, subcontractors, agents,
employees, or other persons acting on their behalf's performance of this contract, and
Omega, at its own expense, cost and risk, shall defend, with counsel appointed by City,
any and all actions, suits or other legal proceedings that may be brought or instituted
against the City or officers, employees, volunteers or agents thereof on any such claim or
demand, and pay or satisfy any judgment that may be rendered against the City or
officers, employees, volunteers or agents thereof in any such action, suit or legal
proceedings. City may make all reasonable decisions with respect to its representation in
any legal proceeding.
6. CONFIDENTIALITY
If Omega receives from the City information which due to the nature of such
information is reasonably understood to be confidential and/or proprietary, Omega agrees
that it shall not use or disclose such information except in the performance of this
Agreement, and further agrees to exercise the same degree of care it uses to protect its
25T-3
own information of like importance, but in no event less than reasonable care.
"Confidential Information" shall include all nonpublic information. Confidential
information includes not only written information, but also information transferred orally,
visually, electronically, or by other means. Confidential information disclosed to either
party by any subsidiary and/or agent of the other party is covered by this Agreement.
The foregoing obligations of non-use and nondisclosure shall not apply to any
information that (a) has been disclosed in publicly available sources; (b) is, through no
fault of Omega disclosed in a publicly available source; (c) is in rightful possession of
Omega without an obligation of confidentiality; (d) is required to be disclosed by
operation of law; or (e) is independently developed by Omega without reference to
information disclosed by the City.
7. CONFLICT OF INTEREST CLAUSE
Omega covenants that it presently has no interests and shall not have interests,
direct or indirect, which would conflict in any manner with performance of services
specified under this Agreement.
8. NOTICE
Any notice, tender, demand, delivery, or other communication pursuant to this
Agreement shall be in writing and shall be deemed to be properly given if delivered in
person or mailed by first class or certified mail, postage prepaid, or sent by telefacsimile
or other telegraphic communication in the manner provided in this Section, to the
following persons:
To City: Chief of Police
City of Santa Ana
60 Civic Center Plaza (M-18)
Santa Ana, California 92702
telefacsimile 714-245-8097
Attn: Robert Brekenfeld
To Omega: The Omega Group
5160 Carroll Canyon Rd., 1St Floor
San Diego, California 92121
telefacsimile 858-450-0239
A party may change its address by giving notice in writing to the other party.
Thereafter, any communication shall be addressed and transmitted to the new address. If
sent by mail, communication shall be effective or deemed to have been given three (3)
days after it has been deposited in the United States mail, duly registered or certified,
with postage prepaid, and addressed as set forth above. If sent by telefacsimile,
communication shall be effective or deemed to have been given twenty-four (24) hours
after the time set forth on the transmission report issued by the transmitting facsimile
25T-4
machine, addressed as set forth above. For purposes of calculating these time frames,
weekends, federal, state, County or City holidays shall be excluded.
9. EXCLUSIVITY AND AMENDMENT
This Agreement represents the complete and exclusive statement regarding
maintenance and support of the system between the City and Omega, and supersedes any
and all other agreements, oral or written, between the parties regarding the same subject.
The parties agree that any terms or conditions of any purchase order or other instrument
that are inconsistent with, or in addition to, the terms and conditions hereof, shall not bind
or obligate Omega nor the City.
10. ASSIGNMENT
Inasmuch as this Agreement is intended to secure the specialized services of
Omega, Omega may not assign, transfer, delegate, or subcontract any interest herein
without the prior written consent of the City and any such assignment, transfer,
delegation or subcontract without the City's prior written consent shall be considered null
and void. Nothing in this Agreement shall be construed to limit the City's ability to have
any of the services which are the subject to this Agreement performed by City personnel
or by other consultants retained by City.
11. TERMINATION
This Agreement may be terminated by either party upon thirty (30) days written notice of
termination. In such event, Omega shall be entitled to receive and the City shall pay Omega
compensation for all services performed by Omega prior to receipt of such notice of
termination.
12. DISCRIMINATION
Omega shall not discriminate because of race, color, creed, religion, sex, marital
status, sexual orientation, age, national origin, ancestry, or disability, as defined and
prohibited by applicable law, in the recruitment, selection, training, utilization,
promotion, termination or other employment related activities. Omega affirms that it is an
equal opportunity employer and shall comply with all applicable federal, state and local
laws and regulations.
13. JURISDICTION -VENUE
This Agreement has been executed and delivered in the State of California and the
validity, interpretation, performance, and enforcement of any of the clauses of this
Agreement shall be determined and governed by the laws of the State of California. Both
parties further agree that Orange County, California, shall be the venue for any action or
proceeding that may be brought or arise out of, in connection with or by reason of this
Agreement.
25T-5
14. PROFESSIONAL LICENSES
Omega shall, throughout the term of this Agreement, maintain all necessary
licenses, permits, approvals, waivers, and exemptions necessary for the provision of the
services hereunder and required by the laws and regulations of the United States, the
State of California, the City of Santa Ana and all other governmental agencies.
15. MISCELLANEOUS PROVISIONS
a. Each undersigned represents and warrants that its signature hereinbelow has the
power, authority and right to bind their respective parties to each of the terms of this
Agreement, and shall indemnify City fully, including reasonable costs and attorney's fees,
for any injuries or damages to City in the event that such authority or power is not, in fact,
held by the signatory or is withdrawn.
b. All Exhibits referenced herein and attached hereto shall be incorporated as if fully
set forth in the body of this Agreement.
IN WITNESS WHEREOF, the parties hereto have executed this Agreement on the date
and year first written above.
ATTEST:
CITY OF SANTA ANA
PATRICIA E. HEALY
Clerk of the Council
APPROVED AS TO FORM:
JOSEPH W. FLETCHER
City Attorney
By:
Laura Sheedy
Assistant City Attorney
DAVID N. REAM
City Manager
RECOMMENDED FOR APPROVAL: THE OMEGA GROUP
PAUL M. WALTERS
Chief of Police
(NAME)
(Title)
25T-6
.,~ ~~~, Santa Ana Police Department The Omega Group, Inc.
CrimeMapping.com July 23, 2008
CrimeMaupin~.com (Hosted)
The Omega Group hosts CrimeMapping.com, using Google Maps under a one or two
year contractual commitment. There are no hardware or setup costs for choosing the
CrimeMapping.com solution.
The tasks below are related to the development and deployment of your customized
CrimeMapping.com application using Google Maps. After go-live, there will be a thirty
(30) day trial period to test the application. After the trial period expires, the Client will
begin paying a monthly or annual hosting fee.
Professional Services: No Char e
Task 1 CrimeMapping.com Project Planning
• Identify data source for incident data
• Identify data fields from incident reports to be displayed in CrimeMapping.com
Task 2 CrimeMapping Development and Deployment
• Set up Import Wizard -CrimeMapping (CM) Layer Output
• Set up Omega Extractor -Server Preparation
• Set up Omega Extractor -Client Installation
• Set up Omega Extractor -Automation
• Test CrimeMapping.com application functionality
Hosting Fee•
The Omega Group will host the application for a period of 1 or 2 years, beginning on the
go live date of the application.
Hosting Fees are as follows:
Monthly Payments: $250.00 per month, or
Annual Payments: $2,880.00 per year
NON-DISCLOSURE
This estimate has been prepared by the sales division of The Omega Group and is a confidential document that contains ideas,
concepts, methods and other proprietary information. Readers are to treat the information contained herein as confidential and may not
copy or reproduce any of these materials for distribution outside of their organization without the written permission of The Omega
Group. The Quote will remain valid for budgetary purposes only for up to 6 months from the date of creation.
Project Description
The Omega Group will set up an automated export of crime data to the hosted
CrimeMapping.com application. The data will be cleaned and geocoded at the client
site, and then exported via a web service transmission to The Omega Group's hosting
facility.
2
25T-7 ~~
.~~ ~~' Santa Ana Police Department The Omega Group, Inc.
CrimeMapping.com July 23, 2008
Data Flow
The diagram below depicts the data flow from the Law Enforcement Databases to the
CrimeMapping.com application.
ATTACHMENT 1
25T-8
CRIMEVIEW Santa Ana Police Department The Omega Group, Inc.
California Exhibit A
® CrimeView `Conversion' July 23, 2008
Proiect Estimate
The Package total is estimated at $30,290.00.
This estimate includes connections made to both the CAD and RMS database systems. It
assumes that there will be 1 connection to the CAD and up to 3 connections to the RMS.
Connections are made to extract datasets that are commonly queried (i.e. Incident
Reports, Arrestees, Citations, Warrants, etc...) At this time it is unclear how many
connections may be needed, however three connections to the RMS should be sufficient
in accommodating the majority of data requests made by the end-user.
If the client opts to connect to the CAD system only, the project scope and price will be
adjusted to $22,865.00.
Software: $2,970.00
Omega software includes one (1) year of maintenance.
Omega Software:
Six (6) licensed copies of CrimeView 4.2, upgrade version $2,970.00
One (1) licensed copy of The Omega Import Wizard No Cost
For each licensed copy of CrimeView the following ESRI
software license(s) will be required:
• ArcView 9.2, single or concurrent use license.
• Spatial Analyst 9.2, single or concurrent use license
For the license of Import Wizard the following ESRI software
license(s) will be required:
• ArcView 9.2, single or concurrent use license, or
ArcEditor or ArcInfo*
* ArcEditor or ArcInfo will be required if the agency utilizes
ESRI's ArcSDE to manage the incident datasets.
Please contact Omega if you need to include ESRI Software
i~our purchase of CrimeView
Maintenance: $2 495.00
• One (1) year of Annual Maintenance*
* Client is no longer current under the Omega Suppor[ Plan. Client will begin new maintenance plan, and will commence upon
completion of Task 4 (below)
Professional Services (Per Task): $24,825.00
Task 1 Project Planning and Data Collection $5,075.00
• Identify GIS map layers and design preferences
• Identify source tabular data from RMS and CAD
• Collect base map GIS data layers
• Connect to records data source, extract sample datasets and send output profiles to
Omega using Import Wizard
• Collect lookup tables
x
5~,~r
25T-9 - ~ ~~~,
CRIMEVIEW„ Santa Ana Police Department The Omega Group, Inc.
California Exhibit A
CrimeView `Conversion' July 23, 2008
Task 2 Application Development $8,555.00
• Add GIS layers to map document and create address locators
• Develop and configure data import profiles. Up to four (4) profiles are included
• Create Saved Queries database and design Crystal Report templates
• Add Omega functionality and other customizations to GIS application
• Test application functionality
• Develop training documents
Task 3 Application Deployment (At Client Site) $9, 455.00
Task 4
• CrimeView Desktop Installation: Up to eight (8) hours on-site. One (1) Omega
personnel.
o Install and configure data import profiles on import machine
o Test import profiles and import historical data
o Schedule automated data import process
o Install and configure OmegaGIS application on user machines
• CrimeView Desktop On-site training: Sixteen (16) hours on-site for seven (7)
persons, Two (2) Omega personnel.
• Travel for The Omega group: Two (2) staff members to provide installation and
training for one (1) trip
Finishing Application Design $1, 740.00
• Edit and Customize Import Profiles, Saved Queries, Crystal Report Templates and
Application Style, per user feedback.
• Test Application Functionality
NON-DISCLOSURE
This document has been prepared by the sales division of The Omega Group and is a confidential document that contains ideas,
concepts, methods and other proprietary information. Readers are to treat the information contained herein as confidential and may not
copy or reproduce any of these materials for distribution outside of their organization without the written permission of The Omega
Group. The estimate will remain valid for 3 months from the date on the estimate for Omega Software and Services only.
End of Estimate
Payment Schedule
In consideration of the services to be performed by Omega, Omega shall be entitled to
compensation in the total amount of $30,290.00. The payment schedule is as follows:
• Thirty percent $9,087.00 of the total amount due upon execution of an
(30%) agreement and/or issuance of a Purchase Order
• Thirty percent $9,087.00 Of the total amount due upon delivery CrimeView
(30%) Desktop Software
• Thirty percent $9,087.00 of the total amount due upon completion of
(30%) CrimeView® Desktop Deployment
• Ten Percent (10%) $3,029.00 of the total amount due thirty (30) days after
completion of services
4
25T-10
CRIMEvIEW, Santa Ana Police Department The Omega Group, Inc.
California Exhibit A
® __CrimeView `Conversion' July 23, 2008
Omega Maintenance Plan
Maintenance, Annual (Customer Support): Clients that are not current under support
will pay a maintenance activation fee. Please see the Customer Support Program
Document for details of coverage.
Annual Support: $3,345.00
ESRI Software Maintenance not included.
Implementation Timeline
Unless otherwise documented, the completion of all services will take approximately
90 days from date of data collection. Onsite installation and training will be scheduled
only after application development is complete.
Additional Software Licenses (Costs) Full Price /Upgrade Price
CrimeView Licenses (Single Use License) $1,500.00 each/ $495.00 each
Data Specifications
Datasets to be Imported via Omega Import WizardTM
The client operates the Positron CAD and RMS System. The following data sets
represent tables of data to be extracted by The Omega Import Wizard. An Import
Profile will be built for each data set listed. A total of three (3) profiles have been
identified for this project.
Profile Database Vendor/Type Data Set
I CAD SQL Database Calls for Service
2 Records Management - SQL Database Arrestees
3 Records Management - SQL Database Incident Reports
4 Records Management - SQL Database TBD
Please review the Omega Import Wizard Appendix for more details regarding the
Omega Import Wizard and the use of Profiles. Because a significant amount of work
(and cost) can be attributed to the incident or person data being imported, it is important
that Omega Project Management have access to local knowledge regarding the RMS or
CAD data/database as outlined under General Requirements (see next page).
Hardware Specifications
Hardware for the Client Workstations (For CrimeView® Desktop)
The Omega Group recommends the following hardware specifications for a
workstation with astand-alone crime analysis application working with ArcView and
CrimeView°
Recommended Minimum
• Intel Core 2 Duo Pentium 4 (3.20 GHz)
5
25T-11
CRIMEVIEW Santa Ana Police Department The Omega Group, Inc.
California Exhibit A
® CrimeView `Conversion' July 23, 2008
• Memory - 1-2 GB Memory 1 GB
• Hard drive - 80GB Hard Drive - 40 GB
• CD-RW/DVD
• Video/ ra hits -256MB Video/graphics 256 MB
• 1 Gi abit Ethernet
Import Wizard Server
• Rack mounted 1 U
• Dual-Core Intel® Xeon® 3000 Series, 1 CPU
• 4 GB RAM
• Mirrored Disk Configuration using SCSI disks 15K RPM - 73 GB
• 1 Gigabit Ethernet network cards
Client Project Management
Critical to the success of every implementation is having the appropriate client staff
prepared to be active participants and to understand what is expected from them for the
duration of the implementation. Two critical components to this implementation pertain
to local knowledge of data schema for the RMS/CAD data sources and what data should
be available for mapping and reporting.
Database Schema
The client should expect to provide staff resources who can demonstrate knowledge of
the tabular structure (schema) of the RMS, CAD and other data sources. These persons
will be expected to assist Omega Technicians in building SQL statements that includes
all the fields of data that the client wants for mapping and reporting. This assistance
would primarily be in the form of understanding database structure and table
relationships.
Report Data
The client should expect to provide staff resources who can confirm what data needs to
be included for mapping and reporting. These persons should have direct experience in
working with crime data through current extractions from the RMS, CAD and other data
sources and from the perspective and experience of a crime analyst.
The Omega Group maintains an inventory of data extraction templates (e.g. SQL
Statements) that can be used to as a starting point for the development of a customized
data interface. However, having client staff that can provide local knowledge of the
database can reduce the overall project time, facilitate the ongoing maintenance of the
application and produce a more useful crime mapping and reporting environment.
Project Planning
Remote Connectivity: Secure or confirm remote access via the use of Expert City's
GoToMyPC or the use of a VPN Connection.
• Establishing Remote Connection to the Server(s).
6
25T-12
CRIMEVIEW" Santa Ana Police Department The Omega Group, Inc.
California Exhibit A
CrimeView `Conversion' July 23, 2008
o Data Collection, Installation and Technical Support may be performed
through remote connection, reducing cost of project and time it takes to
complete services
o Omega Recommends ExpertCity's GoToMyPC or VPN for remote
connections
^ Provide Network IP Address if VPN is used
• If the client is unable to provide high speed remote access with GoToMyPC or
similar connection software to The Omega Group for the collection of the
required data sets then an additional fee will be charged to the client based on the
additional time required for data collection.
System Architecture
Server and Workstation Hardware: The client will provide for hardware to be utilized
in conjunction with CrimeVieww~' Desktop. Hardware should include workstations and a
file server(s) to store GIS data.
• The Omega Group recommends the client to maintain a database of relevant
Geographic Information in a file server for the CrimeView application(s). This
database will be a warehouse of street, boundary and point data, as well as
incident and person data sets from the client data systems.
Data
Geography: The client will provide for the geographic base data for the project. In
addition to the Street Centerline this may include: Parks, Schools, Beats, Reporting
Districts, Landmarks, Stations, Parcels, etc. During the project kick-off a discussion
regarding the type and availability of data will ensue.
• Street Centerline File: The client must provide accurate reference data that will be
used to generate a geocoding service. Typically the reference data is a street
centerline file, address points or a parcel layer.
Application Deployment
Prior to the CrimeView® Desktop Installation: the following items should be
completed by the Network Administrator /GIS Coordinator and Crime Analyst:
• ESRI Training Course: The Crime Analysts/ Onsite Administrators have
completed ESRI's Introduction to ArcView (course) Information may be found at
website: http://tra.ining.esri.com/ilt; schedule/index.cfm.
o The Omega Group highly recommends all personnel working with
CrimeView to have the Introduction to ArcGIS I and/or Introduction to
ArcGIS II training in addition to CrimeView training. At least one person,
preferably the on-site CrimeView administrator, should have a solid
understanding of ArcGIS (ArcMap and ArcCatalog). The Omega Group
requires that at least the system administrator or primary user receive
ArcGIS training prior to receiving CrimeView training.
7
25T-13
CRIMEVIEW' Santa Ana Police Department The Omega Group, Inc.
California Exhibit A
® CrimeView `Conversion' July 23, 2008
• CrimeView® Desktop Training Facility: The client has secured an adequate room
with network and Internet access to train individuals on CrimeView® Desktop.
The room will require enough workstations for everyone to be trained, each with a
copy of ESRI's ArcView 9.x and ESRI's Spatial Analyst 9.x installed. The client
will install the ESRI software.
25T-14
CRIMEVIEW° Santa Ana Police Department The Omega Group, Inc.
California Exhibit A
~__ CrimeView `Conversion' Juty 23, 2008
Application Description
CrimeView is essential to law enforcement agencies that are committed to Community
Oriented Policing, Problem Solving and CompStat management. CrimeView permits law
enforcement agencies to geographically view and analyze data from their RMS (Records
Management System), CAD (Computer Aided Dispatch) and known-offender data sets.
Users can map, analyze, and report crime incidents by type, proximity, or other search
criteria.
This geographic presentation of the data quickly identifies problem areas and trends
associated with crime data. Rather than spending hours pouring over tables and reports, a
visual representation of the same data is presented on a map, which can be evaluated
quickly and easily. This information helps with officer deployment by quickly
identifying the areas where the officers are needed most. Effectiveness of current law
enforcement efforts can be quickly illustrated by the geographic representation.
Data Flow
Alternative data flows (hardware/network configurations) are available. The diagram
represents the preferred data flow for the implementation of CrimeView.
ATTACHMENT 2
2
25T-15
25T-16