HomeMy WebLinkAbout17-Information Technology
CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL 4JP~8lN A L
From: Tom Marek,
IT Director
Subject: Resolution of the City of San
Bernardino authorizing the purchase of
CrimeView Community Web-based Crime
Mapping services from The Omega Group
of San Diego, California.
Dept: Information Technology
Date: October 27, 2008
M/CC DATE: November 17, 2008
Synopsis of Previous Council Action
None
Recommended Motion:
1. Adopt Resolution.
~ /~~J--
TOM MAREK, IT Director
Contact person:
Public Safety Systems Mgr Michael Eckley
Phone: 384-5947
Supporting data attached: Yes Staff Report/Resolution
Ward: All
FUNDING REQUIREMENTS: Amount:
$ 37,500.00
(professional/Contractual Services)
Account #123-741-5502 (2007 COPS Tech)
Council Notes:
..({.S() Zoo&"- 4c1-8
Finance
Agenda Item No.~
JI-11-0e
CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION
Staff Report
Subiect
Resolution of the City of San Bernardino authorizing the purchase of CrimeView Community
Web-based Crime Mapping services from The Omega Group of San Diego, California.
Baclmround
The San Bernardino Police Department has been posting monthly Uniform Crime Reporting
(UCR) Part-l crime data on its website (www.sbpdoninc.org) since January 2006. As part of the
Police Department's community interaction model under the Fiscal Year 2008/2009
reorganization plan, the Police Department wishes to provide the citizens of our community with
an interaction web-based mapping tool to see UCR Part-I crime data at the City, District, and
Beat levels.
The Police Department is installing an internal web-based crime mapping tool from The Omega
Group, of San Diego, California, called "CrimeView Dashboard." This internal tool will be used
to send limited crime mapping data to patrol officers in the field via the Mobile Data Computer
(MDC) devices in patrol cars. The Omega Group offers a software solution for public access to
crime mapping data called "Crime View Community."
The CrimeView Community software tool can be purchased and hosted locally by a law
enforcement agency or the package can be purchased and hosted by The Omega Group for the
agency. The Police Department proposes to purchase hosting services from The Omega Group
rather than making a larger investment in expensive computer hardware, operating system
software, and supporting technology. This proposal will provide community based web access
to UCR Part-I crime mapping data for 36 months (January 1,2009 to December 31, 2011).
The Omega Group will provide all necessary computer hardware, software, and the professional
services necessary to host public access mapping services for the Police Department for 36
months. Sexual crime data will not be published on the public mapping site. Mapping data will
be made available at the street block level instead of at the address level (710 North D Street will
appear as 700 North D Street).
The following data will be available for each crime mapped on the website: Case Number, Date
of Event, UCR Crime Classification Code, and Location (street block data). All of this
information is available as part of the California Public Records Act. Crime data will become
available on the public website approximately one week after the event occurs.
The Omega Group, of San Diego, California, currently provides software and maintenance
support to the Police Department for the CrimeView software that is currently used by staff. It is
both cost effective and efficient to expand the existing software suite rather than purchase a web
based mapping tool from another vendor. Therefore, it is recommended, pursuant to San
Bernardino Municipal Code 3.04.010(b)(3), that the Mayor and Common Council approve a
selected source justification for the purchase of 36 months of CrimeView Community Mapping
services from The Omega Group.
Financial ImDact
A total of $37,500.00 from the 2007 US DOJ COPS Technology Grant was approved by the US
Department of Justice for this technology purchase. A total of $22,500.00 is being charged for
the initial setup and configuration of the City's new public crime mapping website. Services
include work associated with the actual website setup and work related to the crime mapping
issues unique to the new City crime mapping data processes. In addition to the initial setup
costs, The Omega Group is charging a $5,000.00 annual hosting fee that will cover the first
twelve months of operation (January 2009 to December 2009). The total cost for year one of this
project is $27,500.00, which has been approved by the US DOJ COPS Office.
In addition to the first year fees, the US DOJ COPS Office agreed to fund the annual $5,000.00
hosting fee for year two of the grant (January 2010 to December 2010) and the annual $5,000.00
hosting fee for year three of the grant (January 2011 to December 2011). The US DOJ COPS
Office approved the purchase of the extra 24 months of hosting service as part of the initial
project.
The Police Department and the Information Technology Department recommend paying for
implementation and for the 36 months of hosting service together to avoid annual increases in
the hosting fees. The Omega Group has agreed to honor the existing hosting fee for months 24-
36 if the fee is paid as part of the initial project. Otherwise, the Police Department will be
subject to the actual hosting fees at the time of annual renewal (January 2010 and January 2011).
The Police Department and The Omega Group project a savings of approximately $1,500.00 by
paying in advance.
The City has had an account with The Omega Group since 2000 and believes there is little risk in
paying in advance.
2007 COPS Technology Grant (123-741-5502)
Total Project Funding
$ 37,500.00
$ 37,500.00
This purchase does not use General Fund dollars.
Recommendation
Adopt Resolution.
/~ '~"'/7
if Ii II D \\./
\\.jj If
,--..... 1..; !J
1 RESOLUTION NO.
2 RESOLUTION OF THE MAYOR AND COMMON COUNCIL OF THE CITY OF
SAN BERNARDINO AUTHORIZING THE PURCHASE OF CRIMEVIEW COMMUNITY
3 WEB-BASED CRIME MAPPING SERVICES FROM THE OMEGA GROUP OF SAN
DIEGO, CALIFORNIA.
4
BE IT RESOLVED BY THE MAYOR AND COMMON COUNCIL OF THE CITY
5 OF SAN BERNARDINO AS FOLLOWS:
6 SECTION 1. Whereas The Omega Group of San Diego, California, is the existing provider
7 of software and professional services to the Police Department for internal Crime Mapping software,
8 the Mayor and Common Council hereby approve the purchase of Crime view Community W eb- Based
9 Crime Mapping System pursuant to San Bernardino Municipal Code 3.04.01O(b)(3).
10 SECTION 2. The City Manager of the City of San Bernardino is hereby authorized to
11 execute on behalf of the City the Vendor Service Agreement, referenced as Attachment A to this
12 resolution, between the City of San Bernardino and The Omega Group of San Diego, California, for
13 this purchase of Crime View Community web-based crime mapping services.
14 SECTION 3. The Financial Director or her designee is hereby authorized to issue a
15 Purchase Order to The Omega Group, of California, for the purchase of Crime View Community
16 web-based crime mapping services as outlined in The Omega Group's "Omega Hosted CrimeView
17 Community, using ESRI Based ArcGIS Server Software" quote dated September 29, 2008. The
18 Purchase Order shall read "San Bernardino PD Crime View Community Hosting Services. Not to
19 exceed $37,500.00."
20 SECTION 4. The authority granted hereunder is rescinded ifboth parties fail to sign the
21 agreement within 60 days.
22 III
23 III
24 III
25 III
26 III
27 ill
28 III //~/7~CJ8
#f7
1 RESOLUTION AUTHORIZING THE PURCHASE OF CRIMEVIEW COMMUNITY WEB-
BASED CRIME MAPPING SERVICES FROM THE OMEGA GROUP OF SAN DIEGO,
2 CALIFORNIA.
3
4
I HEREBY CERTIFY that the foregoing Resolution was duIy adopted by the Mayor and
5 Conunon Council of the City of San Bernardino at a
meeting thereof, held on the _
6 day of .
, 2008, by the following vote, to wit:
7 COUNCIL MEMBERS:
AYES
NAYS
ABSTAIN ABSENT
8 ESTRADA
9 BAXTER
10 BRINKER
11 DERRY
12 KELLEY
13 JOHNSON
14 MC CAMMACK
15
16 Rachel Clark, City Clerk
17
The foregoing Resolution is hereby approved this _ day of
,2008.
18
19
20
PATRICKJ. MORRIS, Mayor
21 City of San Bernardino
22 Approved as to form:
23 JAMES F. PENMAN,
City Attorney
24
25
26
27
28
VENDOR SERVICE AGREEMENT
CrimeView Community Crime Mapping Service
Page 1 of5
This Vendor Service Agreement is entered into this _ day of
by and between The Omee:a Grou>> of San Diee:o. California ("VENDOR") and the
City of San Bernardino ("CITY" or "San Bernardino").
WITNESSETH:
WHEREAS, the Mayor and Common Council has determined that it is
advantageous and in the best interest of the CITY to contract for an hosted public access
crime mapping web service for the San Bernardino Police Department;
NOW, THEREFORE, the parties hereto agree as follows:
1. SCOPE OF SERVICES.
For the remuneration stipulated, San Bernardino hereby engages the services of
VENDOR to provide those products and services as set forth on Exhibit "A," attached
hereto and incorporated herein.
2. COMPENSATION AND EXPENSES.
a. For the services delineated above, the CITY, upon presentation of an invoice,
shall pay the VENDOR up to the amount of $ 40,000.00 for the products and
services as set forth on Exhibit "A," attached hereto and incorporated herein.
b. No other expenditures made by VENDOR shall be reimbursed by CITY.
3. TERM; TERMINATION.
The term of this Agreement shall end on June 30, 2012.
This Agreement may be terminated at any time by thirty (30) days' written notice
by either party. The terms of this Agreement shall remain in force unless mutually
amended. The duration of this Agreement may be extended with the written consent of
both parties.
4. INDEMNITY.
Vendor agrees to and shall indemnify and hold the City, its elected officials,
employees, agents or representatives, free and harmless from all claims, actions, damages
and liabilities of any kind and nature arising from bodily injury, including death, or
property damage, based or asserted upon any actual or alleged act or omission of Vendor,
its employees, agents, or subcontractors, relating to or in any way connected with the
accomplishment of the work or performance of services under this Agreement, unless the
bodily injury or property damage was actually caused by the sole negligence of the City,
its elected officials, employees, agents or representatives. As part of the foregoing
indemnity, Vendor agrees to protect and defend at its own expense, including attorney's
ATACHMENT "A"
VENDOR SERVICE AGREEMENT
CrimeView Community Crime Mapping Service
Page 2 of 5
fees, the City, its elected officials, employees, agents or representatives from any and all
legal actions based upon such actual or alleged acts or omissions. Vendor hereby waives
any and all rights to any types of express or implied indemnity against the City, its
elected officials, employees, agents or representatives, with respect to third party claims
against the Vendor relating to or in any way connected with the accomplishment of the
work or performance of services under this Agreement.
5. INSURANCE.
While not restricting or limiting the foregoing, during the term of this Agreement,
VENDOR shall maintain in effect policies of comprehensive public, general and
automobile liability insurance, in the amount of $1,000,000.00 combined single limit, and
statutory worker's compensation coverage, and shall file copies of said policies with the
CITY's Risk Manager prior to undertaking any work under this Agreement. CITY shall
be set forth as an additional named insured in each policy of insurance provided
hereunder. The Certificate of Insurance furnished to the CITY shall require the insurer to
notify CITY of any change or termination in the policy.
6. NON-DISCRIMINATION.
In the performance of this Agreement and in the hiring and recruitment of
employees, VENDOR shall not engage in, nor permit its officers, employees or agents to
engage in, discrimination in employment of persons because of their race, religion, color,
national origin, ancestry, age, mental or physical disability, medical condition, marital
status, sexual gender or sexual orientation, or any other status protected by law.
7. INDEPENDENT CONTRACTOR.
VENDOR shall perform work tasks provided by this Agreement, but for all
intents and purposes VENDOR shall be an independent contractor and not an agent or
employee of the CITY. VENDOR shall secure, at its expense, and be responsible for any
and all payment of Income Tax, Social Security, State Disability Insurance
Compensation, Unemployment Compensation, and other payroll deductions for
VENDOR and its officers, agents, and employees, and all business license, if any are
required, in connection with the services to be performed hereunder.
8. BUSINESS REGISTRATION CERTIFICATE AND OTHER
REQUIREMENTS.
VENDOR warrants that it possesses or shall obtain, and maintain a business
registration certificate pursuant to Chapter 5 of the Municipal Code, and any other
licenses, permits, qualifications, insurance and approval of whatever nature that are
legally required of VENDOR to practice its business or profession.
VENDOR SERVICE AGREEMENT
CrimeView Community Crime Mapping Service
Page 3 of5
9. NOTICES.
Any notices to be given pursuant to this Agreement shall be deposited with the
United States Postal Service, postage prepaid and addressed as follows:
TO THE CITY:
TO THE VENDOR:
San Bernardino, CA 92402-1559
Telephone: (909) 384-5947
Chris Baldwin, Sales Mgr
The Omega Group
5160 Carroll Canyon Road,
I st Floor
San Diego, CA. 92121-1775
(858) 450-2590
Michael Eckley, Public Safety IT Manager
San Bernardino Police Department
710 North "D" Street - B Building
10. ATTORNEYS' FEES
In the event that litigation is brought by any party in connection with this
Agreement, the prevailing party shall be entitled to recover from the opposing party all
costs and expenses, including reasonable attorneys' fees, incurred by the prevailing party
in the exercise of any of its rights or remedies hereunder or the enforcement of any of the
terms, conditions or provisions hereof. The costs, salary and expenses of the City
Attorney and members of his office in enforcing this Agreement on behalf of the CITY
shall be considered as "attorneys' fees" for the purposes of this paragraph.
11. ASSIGNMENT.
VENDOR shall not voluntarily or by operation of law assign, transfer, sublet or
encumber all or any part of the VENDOR's interest in this Agreement without CITY's
prior written consent. Any attempted assignment, transfer, subletting or encumbrance
shall be void and shall constitute a breach of this Agreement and cause for the
termination of this Agreement. Regardless of CITY's consent, no subletting or
assignment shall release VENDOR of VENDOR's obligation to perform all other
obligations to be performed by VENDOR hereunder for the term of this Agreement.
12. VENUE.
The parties hereto agree that all actions or proceedings arising in connection with
this Agreement shall be tried and litigated either in the State courts located in the County
of San Bernardino, State of California or the U.S. District Court for the Central District of
California, Riverside Division. The aforementioned choice of venue is intended by the parties to be mandatory and not permissive in nature.
13. GOVERNING LAW.
This Agreement shall be governed by the laws of the State of California.
VENDOR SERVICE AGREEMENT
CrimeView Community Crime Mapping Service
Page 4 of 5
14. SUCCESSORS AND ASSIGNS.
This Agreement shall be binding on and inure to the benefit of the parties to this
Agreement and their respective heirs, representatives, successors, and assigns.
15. HEADINGS.
The subject headings of the sections of this Agreement are included for the
purposes of convenience only and shall not affect the construction or the interpretation of
any of its provisions.
16. SEVERABILITY.
If any provision of this Agreement is determined by a court of competent
jurisdiction to be invalid or unenforceable for any reason, such determination shall not
affect the validity or enforceability of the remaining terms and provisions hereof or of the
offending provision in any other circumstance, and the remaining provisions of this
Agreement shall remain in full force and effect.
17. REMEDIES; WAIVER.
All remedies available to either party for one or more breaches by the other party
are and shall be deemed cumulative and may be exercised separately or concurrently
without waiver of any other remedies. The failure of either party to act in the event of a
breach of this Agreement by the other shall not be deemed a waiver of such breach or a
waiver of future breaches, unless such waiver shall be in writing and signed by the party
against whom enforcement is sought.
18. ENTIRE AGREEMENT; MODIFICATION.
This Agreement constitutes the entire agreement and the understanding between
the parties, and supersedes any prior agreements and understandings relating to the
subject matter of this Agreement. This Agreement may be modified or amended only by
a written instrument executed by all parties to this Agreement.
III
III
III
III
III
VENDORSER~CEAGREEMENT
CrimeView Community Crime Mapping Service
. Page 5 of 5
IN WITNESS THEREOF, the parties hereto have executed this Agreement on
the day and date set forth below.
Dated: .
,2008
VENDOR.
By:
Its:
Dated
,2008
CITY OF SAN BERNARDINO
By:
Mark Weinberg, Interim City Manager
Approved as to Form:
James F. Penman, City Attorney
By:
flo.:).r7{~
.. .... ... OMEGA
. .. GROUP
The Je8der;n providing Innovative GIS solutions to pubic ssfety and education agendes.
5160 Carroll Canyon Road. 1st Floor. San Diogo. CA 92121-1775
Phone: 858.450.2590 . Fa,,: 858.450.0239
E."",II: mai/(ij)theomeaaarouD.com . Web: wlNW.theomeaaarou/J.com
September 29,2008
Michael Eckley
Public Safety Systems Manager
San Bernardino Police Department
San Bernardino, CA
Re: Omega Hosted CrimeView Community, using ESRI Based ArcGIS Server Software
Michael Eckley,
Enclosed are the costs for the implementation of an Omega Hosted Crime View
Community Application, along with descriptions pri~ng, requirements and
configurations.
The Omega Group was founded in 1992. Our mission is dedicated to enriching the
quality of life in communities by providing solutions for public safety agencies. The
Omega Group's professional experience includes working with over 350 law
enforcement agencies implementing our Crime View Enterprise solutions, which focuses
on mapping and analysis applications for crime analysts, officers, command staff and the
cOmmunity. The Omega Group is an ESRI (Premier) Foundation Partner, recognized by
ESRI for its development of solutions built on ESRI technology.
We offer to our clients:
. Mapping technology and services
. Project management, application building, testing and analysis
. Ongoing education, training and support
After the completion of services and acceptance of our work, we will continue to provide
to the client ongoing software and system maintenance via our Customer Support
Program.
Please do not hesitate to let me know if you have any questions; our office number is
(800) 228-1059.
Thank you,
OLelL-
Chris Baldwin
Western Division Sales Manager
Exhibit " A"
~~~;Y:~4
CrimeView Community - ArcGIS
Server - Hosted by The Omega Group
San Bernardino Police Department
The Omega Group, Ine.
September 29, 2008
Exhibit A
Application Description
The focus of the CrimeView Community design is to meet the varied needs of a law
enforcement agency: the Chief, the officer, the watch commander, other agency officials,
the analyst and the community. To meet the needs of this wide range of users, whether
regular or infrequent, the product must be both easy to use and flexible. This means that
great care is taken in designing an intuitive interface aimed at getting to a result quickly
yet provide for easy reselection of parameters to yield a new result.
Project Description
CrimeView Community will include GIS base map data and either the Incident dataset
from the RMS system, or the Calls for Service from the CAD system. The data sources
are located on the premises. The client will provide for an extraction of a single dataset
that will be used in the off site hosted application. The Omega Group will create a web
service to transmit the data to our hosting facility. Also, we will provide ESRI software,
Omega software, hardware, along with professional services identified within this
estimate.
Data Flow
The diagram below depicts the data flow from the Law Enforcement Databases to the
Crime View Community application.
'", ,:,..."'"
A..._ ",
~::::;:_1.;t~;:~~::=,,~~~,.yj0~-:,/''::i:
.. t
.......... .J
"", ,,,.'
2
Task]
Task 2
Task 3
@{~~~;y:~'
CrimeView Community - ArcGIS
Server - Hosted by The Omega Group
San Bernardino Police Department
The Omega Group, Ine.
September 29, 2008
Exhibit A
CrimeView Community (Hosted) Cost: $37.500.00
The Omega Group hosts CrimeView Community, using ESRI's ArcGIS Server under a
three year contractual commitment. There are no hardware costs, and minimal
administrative costs for choosing the Omega-hosted solution.
The estimate is for Professional Services related to the development and deployment of
CrimeView Community and an annual hosting fee. Upon Go-Live of this application, the
Client will begin paying a monthly or annual hosting fee. Implementation is $22,500.00,
provided that the Import Wizard software is already deployed as part of a previous
CrimeView Desktop implementation.
Total Budget Year One: $27,500.00
Total Budget Year Two: $5,000.00
Total Budget Year Three: $5,000.00
(Set up and Annual Hosting Fee)
(Annual Hosting Fee)
(Annual Hosting Fee)
Professional Services:
$22.500.00
Project Planning and Data Collection
. Identify GIS map layers and design preferences and collect base map GIS data layers
. Identify source tabular data from RMS and collect lookup tables
. Connect to records data source, extract sample datasets and send output profiles to
Omega using Import Wizard
Application Development
. Add GIS layers to map document and create address locators
. Create map configuration file
. Create or modify the CAD or Incident Reports Import Profiles
. Create Map Services, three (3) Map Caches
. Add Omega functionality and other customizations to GIS application
. Create Saved Queries for each data set
Application Deployment:
. Installation of Omega Import Wizard Extractor at Client site
. Configure data import profile and import historical data
. Create web service to send data from client to host site
. Schedule automated data import process
. Test CrimeView Community application functionality and tune application with
client resources
Rostin!! Fee: $5,000.00 Der vear
The client will agree to a minimum of 3 years of service for the application, from the date
of go-live.
. Paid annually, the hosting fee is $5,000.00, with the first payment due upon go-
live, net 30 days from invoice.
3
@(~~~;~:7~'
CrimeView Community - ArcGIS
Server - Hosted by The Omega Group
San Bernardino Police Department
Tbe Omega Group, Ine.
September 29, 2008
Exhibit A
Payment Schedule
In consideration of the services to be performed by Omega, Omega shall be entitled to
compensation in ,the total amount of $37,500.00. The payment schedule is as follows:
.
$11,250.00
of the total amount due upon execution of an
eement/issuance of a uote.
of the total amount due upon completion of Crime View
Communi De 10 ent
of the total amount due thirty (30) days after go-live of
a lication
.
$11,250.00
.
$15,000.00
Timeline
The application will be implemented over a 1 to 2 month time period. The project
timeline commences when Omega collects GIS and Sample Crime data. The earliest this
deployment will occur is January 2009.
Testing Period
The first 30 days following the installation of CrimeView Community the client (end-
users) will test the performance of the application. During this time, the client will be
able to request edits to the queries, and data layers, and request minor schema changes to
datasets being imported into both applications.
Crime Data Specifications
Please review the Omega Import Wizard Appendix for more details regarding the
Omega Import Wizard and the use of Profiles.
Datasets to be Imported via Omega Import Wizard™
The following datasets 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 one (I) import
profiles have been identified for this project.
Data Set
I . Crime Reports Table
Database
I SQL
System
I CAD or RMS
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
datal database.
Please Note:
Changes to the RMS database schema may cause the import process to fail. Services to
rebuild or modify Import Profiles (Interface between the Mapping application and the
4
~~~~;.Y:.7t;"
CrimeView Community - ArcGIS
Server - Hosted by The Omega Group
San Bernardino Police Department
The Omega Group, Ine.
September 29, 2008
Exbibit A
RMS dataset) are not necessarily covered under support and may be subject to
additional costs.
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 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 system. 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 system 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.
Remote Connectivity: Secure or confirm remote access via the use of Expert City's
Go ToMyPC or the use of a VPN Connection.
. Establishing Remote Connection to the Server(s).
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 ifVPN 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 lor data collection.
5
~~~;~!,~
CnmeView Community - ArcGIS
Server - Hosted by The Omega Group
San Bernardino Police Department
Tbe Omega Group, Ioe.
September 29, 2008
Exbibit A
Data Collection
Data Collection
. Provide an .mxd file that includes geographic feature classes with desired RGB
values and desired extents.
o What are the Colors for each layer and the extents for which layers
automatically turn on/off
o Client should design the .mxd and sign off on the fmished design, or sign
off on Omega to determine the standards.
. Confirm datasets to be used with the CrimeView application (Associated with the
'What' Tab in the application
o Datasets for CrimeView Community will be limited to either Incident
Reports from the RMS or Calls for Services for the CAD.
. Confirm which of the geographic feature class data will be used for the 'Near a
Feature' query. This routine creates a buffer distance around the selected features
o Common data includes: Buildings, Schools, Parks, Police Stations, Major
Roads, Neighborhoods
o Provide both common name (parks) and file name (parks.shp)
. Confirm which of the geographic feature class data will be used for the 'Within a
Boundary' query. This routine fllters the incident or person dataset for the
boundary selected
o Common data includes: Zip Codes, Police Beats, Districts,
Neighborhoods, Wards, Police Team Areas, Reporting Districts
o Provide both common name (parks) and file name (parks.shp)
. Confirm street file to be used for geocoding.
o Provide exact name (i.e. centerlines.shp, streets.shp, etc.)
o Address style should be 'US Streets with Zone'
Application Development
Queries
. For each of the datasets, confirm which fleld(s) to have the query search
o Field may beCVLEGEND, UCR code and description, premise, or other.
Queries should be limited to one field.
o A method to categorize codes under common descriptions is essential. (i.e.
a query of an INCIDENTS Shapefile may be UCR_CODE = 0300. A
description field of the UCR code is Burglary)
6
VENDOR SERVICE AGREEMENT
CrimeView Community Crime Mapping Service
Pagelof5
This Vendor Service Agreement is entered into this _ day of
by and between The Omel!a Group of San Diel!o. California ("VENDOR") and the
City of San Bernardino ("CITY" or "San Bernardino").
WITNESSETH:
WHEREAS, the Mayor and Common Council has determined that it is
advantageous and in the best interest of the CITY to contract for an hosted public access
crime mapping web service for the San Bernardino Police Department;
NOW, THEREFORE, the parties hereto agree as follows:
1. SCOPE OF SERVICES.
For the remuneration stipulated, San Bernardino hereby engages the services of
VENDOR to provide those products and services as set forth on Exhibit "A," attached
hereto and incorporated herein.
2. COMPENSATION AND EXPENSES.
a. For the services delineated above, the CITY, upon presentation of an invoice,
shall pay the VENDOR up to the amount of $ 40,000.00 for the products and
services as set forth on Exhibit "A," attached hereto and incorporated herein.
b. No other expenditures made by VENDOR shall be reimbursed by CITY.
3. TERM; TERMINATION.
The term of this Agreement shall end on June 30, 2012.
This Agreement may be terminated at any time by thirty (30) days' written notice
by either party. The terms of this Agreement shall remain in force unless mutually
amended. The duration of this Agreement may be extended with the written consent of
both parties.
4. INDEMNITY.
Vendor agrees to and shall indemnify and hold the City, its elected officials,
employees, agents or representatives, free and harmless from all claims, actions, damages
and liabilities of any kind and nature arising from bodily injury, including death, or
property damage, based or asserted upon any actual or alleged act or omission of V endor,
its employees, agents, or subcontractors, relating to or in any way connected with the
accomplishment of the work or performance of services under this Agreement, unless the
bodily injtiry or property damage was actually caused by the sole negligence of the City,
its elected officials, employees, agents or representatives. As part of the foregoing
indemnity, Vendor agrees to protect and defend at its own expense, including attorney's
VENDORSER~CEAGREEMENT
CrimeView Community Crime Mapping Service
Page 2 of5
fees, the City, its elected officials, employees, agents or representatives from any and all
legal actions based upon such actual or alleged acts or omissions. Vendor hereby waives
any and all rights to any types of express or implied indemnity against the City, its
elected officials, employees, agents or representatives, with respect to third party claims
against the Vendor relating to or in any way connected with the accomplishment of the
work or performance of services under this Agreement.
5. INSURANCE.
While not restricting or limiting the foregoing, during the term of this Agreement,
VENDOR shall maintain in effect policies of comprehensive public, general and
automobile liability insurance, in the amount of $ 1,000,000.00 combined single limit, and
statutory worker's compensation coverage, and shall file copies of said policies with the
CITY's Risk Manager prior to undertaking any work under this Agreement. CITY shall
be set forth as an additional named insured in each policy of insurance provided
hereunder. The Certificate of Insurance furnished to the CITY shall require the insurer to
notify CITY of any change or termination in the policy.
6. NON-DISCRIMINATION.
In the performance of this Agreement and in the hiring and recruitment of
employees, VENDOR shall not engage in, nor permit its officers, employees or agents to
engage in, discrimination in employment of persons because of their race, religion, color,
national origin, ancestry, age, mental or physical disability, medical condition, marital
status, sexual gender or sexual orientation, or any other status protected by law.
7. INDEPENDENT CONTRACTOR.
VENDOR shall perform work tasks provided by this Agreement, but for all
intents and purposes VENDOR shall be an independent contractor and not an agent or
employee of the CITY. VENDOR shall secure, at its expense, and be responsible for any
and all payment of Income Tax, Social Security, State Disability Insurance
Compensation, Unemployment Compensation, and other payroll deductions for
VENDOR and its officers, agents, and employees, and all business license, if any are
required, in connection with the services to be performed hereunder.
8. BUSINESS REGISTRATION CERTIFICATE AND OTHER
REQillREMENTS.
VENDOR warrants that it possesses or shall obtain, and maintain a business
registration certificate pursuant to Chapter 5 of the Municipal Code, and any other
licenses, permits, qualifications, insurance and approval of whatever nature that are
legally required of VENDOR to practice its business or profession.
VENDOR SERVICE AGREEMENT
CrimeView Community Crime Mapping Service
Page 3 of5
9. NOTICES.
Any notices to be given pursuant to this Agreement shall be deposited with the
United States Postal Service, postage prepaid and addressed as follows:
TO THE CITY:
TO THE VENDOR:
Michael Eckley, Public Safety IT Manager
San Bernardino Police Department
710 North "D" Street ~ B Building
San Bernardino, CA 92402-1559
Telephone: (909) 384-5947
Chris Baldwin, Sales Mgr
The Omega Group
5160 Carroll Canyon Road,
1 st Floor
San Diego, CA. 92121-1775
(858) 450-2590
10. ATTORNEYS' FEES
In the event that litigation is brought by any party in connection with this
Agreement, the prevailing party shall be entitled to recover from the opposing.party all
costs and expenses, including reasonable attorneys' fees, incurred by the prevailing party
in the exercise of any of its rights or remedies hereunder or the enforcement of any of the
terms, conditions or provisions hereof. The costs, salary and expenses of the City
Attorney and members of his office in enforcing this Agreement on behalf of the CITY
shall be considered as "attorneys' fees" for the purposes of this paragraph.
11. ASSIGNMENT.
VENDOR shall not voluntarily or by operation of law assign, transfer, sublet or
encumber all or any part of the VENDOR's interest in this Agreement without CITY's
prior written consent. Any attempted assignment, transfer, subletting or encumbrance
shall be void and shall constitute a breach of this Agreement and cause for the
termination of this Agreement. Regardless of CITY's consent, no subletting or
assignment shall release VENDOR of VENDOR's obligation to perform all other
obligations to be performed by VENDOR hereunder for the term of this Agreement.
12. VENUE.
The parties hereto agree that all actions or proceedings arising in connection with
this Agreement shall be tried and litigated either in the State courts located in the County
of San Bernardino, State of California or the U.S. District Court for the Central District of
California, Riverside Division. The aforementioned choice of venue is intended by the
parties to be mandatory and not permissive in nature.
13. GOVERNING LAW.
This Agreement shall be governed by the laws of the State of California.
VENDOR SERVICE AGREEMENT
CrimeView Community Crime Mapping Service
Page 4 of5
14. SUCCESSORS AND ASSIGNS.
This Agreement shall be binding on and inure to the benefit of the parties to this
Agreement and their respective heirs, representatives, successors, and assigns.
15. HEADINGS.
The subject headings of the sections of this Agreement are included for the
purposes of convenience only and shall not affect the construction or the interpretation of
any of its provisions.
16. SEVERABILITY.
If any provision of this Agreement is determined by a court of competent
jurisdiction to be invalid or unenforceable for any reason, such determination shall not
affect the validity or enforceability of the remaining terms and provisions hereof or of the
offending provision in any other circumstance, and the remaining provisions of this
Agreement shall remain in full force and effect.
17. REMEDIES; WAIVER.
All remedies available to either party for one or more breaches by the other party
are and shall be deemed cumulative and may be exercised separately or concurrently
without waiver of any other remedies. The failure of either party to act in the event of a
breach of this Agreement by the other shall not be deemed a waiver of such breach or a
waiver of future breaches, unless such waiver shall be in writing and signed by the party
against whom enforcement is sought.
18. ENTIRE AGREEMENT; MODIFICATION.
This Agreement constitutes the entire agreement and the understanding between
the parties, and supersedes any prior agreements and understandings relating to the
subject matter of this Agreement. This Agreement may be modified or amended only by
a written instrument executed by all parties to this Agreement.
III
III
III
III
III
VENDOR SERVICE AGREEMENT
CrimeView Community Crime Mapping Service
Page 5 of5
IN WITNESS THEREOF, the parties hereto have executed this Agreement on
the day and date set forth below.
Dated:"
,2008
VENDOR.
By:
Its:
Dated
,2008
CITY OF SAN BERNARDINO
By:
Mark Weinberg, Interim City Manager
Approved as to Form:
James F. Penman, City Attorney
~n:2i 17{f;
..i...........<.. \.......... OMEGA
... '..~RDUP
The leader in providing innovative GIS solutions to pubic safety end education agencies.
5160CanoIICanyonRoad,1sfFIoor.SanDiago, CA 92121-1775
Phon.: 858.450.2590 . Fsx: 858.450.0239
E-mail: maiK6>.theomeaaarouD.com . Web: www.theomeaaarouD.com
September 29,2008
Michael Eckley
Public Safety Systems Manager
San Bernardino Police Department
San Bernardino, CA
Re: Omega Hosted CrimeView Community, using ESRl Based ArcGIS Server Software
Michael Eckley,
Enclosed are the costs for the implementation of an Omega Hosted Crime View
Community Application, along with descriptions pricing, requirements and
configurations.
The Omega Group was founded in 1992. Our mission is dedicated to enriching the
quality of life in communities by providing solutions for public safety agencies. The
Omega Group's professional experience includes working with over 350 law
enforcement agencies implementing our Crime View Enterprise solutions, which focuses
on mapping and analysis applications for crime analysts, officers, command staff and the
community. The Omega Group is an ESRl (Premier) Foundation Partner, recognized by
ESRl for its development of solutions built on ESRl technology.
We offer to our clients:
. Mapping technology and services
. Project management, application building, testing and analysis
. Ongoing education, training and support
After the completion of services and acceptance of our work, we will continue to provide
to the client ongoing software and system maintenance via our Customer Support
Program.
Please do not hesitate to let me know if you have any questions; our office number is
(800) 228-1059.
Thank. you,
rlSlJ-
Chris Baldwin
Western Division Sales Manager
Exhibit "A"
~E~~'f.l~;'
CrimeView Community - ArcGlS
Server - Hosted by The Omega Group
San Bernardino Police Department
The Omega Group, Inc.
September 29, 2008
Exhibit A
Application Description
The focus of the CrimeView Community design is to meet the varied needs of a law
enforcement agency: the Chief, the officer, the watch commander, other agency officials,
the analyst and the community. To meet the needs of this wide range of users, whether
regular or infrequent, the product must be both easy to use and flexible. This means that
great care is taken in designing an intuitive interface aimed at getting to a result quickly
yet provide for easy reselection of parameters to yield a new result.
Project Description
CrimeView Community will include GIS base map data and either the Incident dataset
from the RMS system, or the Calls for Service from the CAD system. The data sources
are located on the premises. The client will provide for an extraction of a single dataset
that will be used in the offsite hosted application. The Omega Group will create a web
service to transmit the data to our hosting facility. Also, we will provide ESRI software,
Omega software, hardware, along with professional services identified within this
estimate.
Data Flow
The diagram below depicts the data flow from the Law Enforcement Databases to the
CrimeView Community application.
t
t-.
2
Task]
Task 2
Task 3
@{a~~~~!'ft';.
CrimeView Community - ArcGIS
Server - Hosted by Tbe Omega Group
San Bernardino Police Department
The Omega Group, Inc.
September 29, 2008
EIltibit A
CrimeView Community (Hosted) Cost: $37.500.00
The Omega Group hosts CrimeView Community, using ESRI's ArcGIS Server under a
three year contractual commitment. There are no hardware costs, and minimal
administrative costs for choosing the Omega-hosted solution.
The estimate is for Professional Services related to the development and deployment of
CrimeView Community and an annual hosting fee. Upon Go-Live of this application, the
Client will begin paying a monthly or annual hosting fee. Implementation is 522,500.00,
provided that the Import Wizard software is already deployed as part of a previous
CrimeView Desktop implementation.
Total Budget Year One: 527,500.00
Total Budget Year Two: 55,000.00
Total Budget Year Three: 55,000.00
(Set up and Annual Hosting Fee)
(Annual Hosting Fee)
(Annual Hosting Fee)
Professional Services:
522.500.00
Project Planning and Data Collection
. Identify GIS map layers and design preferences and collect base map GIS data layers
. Identify source tabular data from RMS and collect lookup tables
. Connect to records data source, extract sample datasets and send output profiles to
Omega using Import Wizard
Application Development
. Add GIS layers to map document and create address locators
. Create map configuration file
. Create or modify the CAD or Incident Reports Import Profiles
. Create Map Services, three (3) Map Caches
. Add Omega functionality and other customizations to GIS application
. Create Saved Queries for each data set
Application Deployment:
. Installation of Omega Import Wi2ard Extractor at Client site
. Configure data import profile and import historical data
. Create web service to send data from client to host site
. Schedule automated data import process
. Test CrimeView Community application functionality and tune application with
client resources
Bostin!! Fee: 55.000.00 oer vear
The client will agree to a minimum of 3 years of service for the application, from the date
of go-live.
. Paid annually, the hosting fee is 55,000.00, with the first payment due upon go-
live, net 30 days from invoice.
3
~~~~:Y:~'
CrimeView Commuuity - ArcGIS
Server - Hosted by The Omega Group
San Bernardino Police Department
The Omega Group, Ine.
September 29, 2008
Exhibit A
Payment Schedule
In consideration of the services to be performed by Omega, Omega shall be entitled to
compensation in the total amount of $37,500.00. The payment schedule is as follows:
. $15,000.00
. $11,250.00
. $11,250.00
Timeline
The application will be implemented over a 1 to 2 month time period. The project
time line commences when Omega collects GIS and Sample Crime data. The earliest this
deployment will occur is January 2009.
Testing Period
The first 30 days following the installation of CrimeView Community the client (end-
users) will test the performance of the application. During this time, the client will be
able to request edits to the queries, and data layers, and request minor schema changes to
datasets being imported into both applications.
Crime Data Specifications
Please review the Omega Import Wizard Appendix for more details regarding the
Omega Import Wizard and the use of Profiles.
Datasets to be Imported via Omega Import Wizard™
The following datasets 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 one (1) import
profiles have been identified for this project.
S stem
CAD or RMS
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 knowledl!e regarding the RMS
data/database.
Please Note:
Changes to the RMS database schema may cause the import process to fail. Services to
rebuild or modify Import Profiles (Interface between the Mapping application and the
4
~~~~~~lr~.
CrimeView Community - ArcGlS
Server - Hosted by The Omega Group
San Bernardino Police Department
The Omega Group, Inc.
September 29, 2008
Exhibit A
RMS dataset) are not necessarily covered under support and may be subject to
additional costs.
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 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 system. 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 confrrm 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 system 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.
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).
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 II' Address ifVPN 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.
5
~~r~;Y!,~;
CrimeView Community - An:GIS
Server - Hosted by The Omega Group
San Bernardino Police Department
The Omega Group, Inc.
September 29, 2008
Exhibit A
Data CoUection
Data Collection
. Provide an .mxd file that includes geographic feature classes with desired RGB
values and desired extents.
o What are the Colors for each layer and the extents for which layers
automatically turn on/off
o Client should design the .mxd and sign off on the fmished design, or sign
off on Omega to determine the standards.
. Confirm datasets to be used with the CrimeView application (Associated with the
'What' Tab in the application
o Datasets for CrimeView Community will be limited to either Incident
Reports from the RMS or Calls for Services for the CAD.
. Confirm which of the geographic feature class data will be used for the 'Near a
Feature' query. This routine creates a buffer distance around the selected features
o Common data includes: Buildings, Schools, Parks, Police Stations, Major
Roads, Neighborhoods
o Provide both common name (parks) and file name (parks.shp)
. Confirm which of the geographic feature class data will be used for the 'Within a
Boundary' query. This routine filters the incident or person dataset for the
boundary selected
o Common data includes: Zip Codes, Police Beats, Districts,
Neighborhoods, Wards, Police Team Areas, Reporting Districts
o Provide both common name (parks) and file name (parks.shp)
. Confirm street file to be used for geocoding.
o Provide exact name (i.e. centerlines.shp, streets.shp, etc.)
o Address style should be 'US Streets with Zone'
Aoolication Develooment
Queries
. For each of the datasets, confirm which field(s) to have the query search
o Field may be CVLEGEND, VCR code and description, premise, or other.
Queries should be limited to one field.
o A method to categorize codes under common descriptions is essential. (i.e.
a query of an INCIDENTS Shapefile may be VCR_CODE = 0300. A
description field of the VCR code is Burglary)
6