HomeMy WebLinkAbout2008-428
1 RESOLUTION NO. 2008-428
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 Web-Based
9 Crime Mapping System pursuant to San Bernardino Municipal Code 3.04.01O(b)(3).
SECTION 2.
The City Manager of the City of San Bernardino is hereby authorized to
10
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 Crime View
17 Community, using ESRI Based ArcGIS Server Software" quote dated September 29, 2008. The
18 Purchase Order shall read "San Bernardino PD CrimeView Community Hosting Services. Not to
19 exceed $37,500.00."
20 SECTION 4. The authority granted hereunder is rescinded if both parties fail to sign the
21 agreement within 60 days.
22 III
23 III
24 III
25 III
26 III
27 III
28 III
2008-428
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 duly adopted by the Mayor and
joint
5 Common Council of the City of San Bernardino at a regular meeting thereof, held on the llth
6 day of November
, 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
~
~
~
~
--1L-
--1L-
--1L-
Q....J..d l\1,~
RacOO Clark, City Clerk
17
The foregoing Resolution is hereby approved this/I"'aay of Nnv..mh.." 2008.
18
19
20
ayor
21
22 Approved as to form:
23 JAMES F. PENMAN,
City Attorney
24
25
26
27
28
2008-428
McEWED-CITY CLEftII'
-NOV 3/ A" 7:53
VENDOR SERVICE AGREEMENT Page 1 of5
CrimeView Community Crime Mapping Service
This Vendor Service Agreement is entered into this..ll.th. day of November. 2008
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 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
ATTACHMENT "A"
2008-428
VENDOR SERVICE AGREEMENT
CrimeView Community Crime Mapping Service
Page20f5
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.
2008-428
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
Chris Baldwin, Sales Mgr
The Omega Group
5160 Carroll Canyon Road,
1 sl Floor
San Diego, CA. 92121-1775
(858) 450-2590
San Bernardino, CA 92402-1559
Telephone: (909) 384-5947
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 ofthis 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.
2008-428
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 ofthis 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
2008-428
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: N{)II. 2</ , 2008
VENDOR,
.~
By:
Its: ~l.-II-N .. /..-'--'Iit, P~IO(;AIT
,
By:
Mark
ERNARDINO
Dated
,2008
Approved as to Form:
James F. Penman, City Attorney
lQJ.l17{~
OMEGA
.> .. GROUP
The Jeaderin provicJng innovative GIS solutions to pubic safety and education agencies.
5160 CanoII Canyon Road, 1st Floor. San Diogo, CA 92121-1775
Phon.: 858.450.2590 "Fox: 858.450.0239
E4fIIli1: maif(ci)theomeaaarouD.com. Web: www.theomeaaarouo.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 ArcGlS 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 CrimeView 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,
CLeJ/--
Chris Baldwin
Western Division Sales Manager
Exhibit "A"
@ CRIMEVIEW'
'(Jr, ....,., ~
CrimeView Community - ArcGIS
Server - Hosted by The Omega Group
San Bernanlino Police Department
The Omega Group, tnc.
Seplember 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
Crime View Community application.
Data Flow
Omega Co-location
Web AKIMS
oe.~[j""- ~[j"""~. =~ ~CriO::'~W
'"blle '. _ [j 0 0
CrimeV_
Comm"n;ty IT
6..
.-
2
.
@ CRIMEVIEW"
'(J ,-H-I, L~
CrimeView Community - ArcGIS
Server - !losted by The Omega Group
San Bernardino Police Department
The Omega Group, Inc.
September 29, 2008
E.hibit A
CrimeView Community (Hosted) Cost: $37,500.00
The Omega Group hosts CrimeView Community, using ESRl'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
Task 1
0
0
0
Task 2
0
0
0
0
0
0
Task 3
0
0
0
0
0
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 Crime View Community application functionality and tune application with
client resources
"ostin!! Fee: $5,000.00 per year
The client will agree to a minimum of 3 years of service for the application, from the date
of go-live.
o Paid annually, the hosting fee is $5,000.00, with the first payment due upon go-
live, net 30 days from invoice.
3
.
@ CRIMEVmW'
"(!t''f ......, it"
CrimeView Community - ArcGIS
Server - Hosted by The Omega Group
San Bernardino Police Department
The Omega Group, Inc.
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
of the total amount due upon execution of an
a reementlissuance of a uote.
of the total amount due upon completion of Crime View
Communit De 10 ment
of the total amount due thirty (30) days after go-live of
a lication
o
$11,250.00
o
$11,250.00
Timeline
The application will be implemented over a I 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 Imporl 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.
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 knowledge 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
@ CRIMEVIEW'
~Qr: III<l'l' ~~
CrimeView Community - ArcGIS
Server - Hosted by The Omega Group
San Bernardino Police Department
The Omega Group, Inc.
Septemher 29, 2008
E,hihit 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
GoToMyPC or the use of a VPN Connection.
o 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
o Provide Network IP Address ifVPN is used
o 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
-
@ CRIMEVIEW'
'CJ.:off' ..."..~~
Crime View Community - ArcGIS
Server - Hosted by The Omega Group
San Bernardino Police Department
The Omega Group, Inc.
September 29, 2008
Exhibit A
Data Collection
Data Collection
o 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 finished design, or sign
off on Omega to determine the standards.
o Confirm datasets to be used with the CrimeView application (Associated with the
'What' Tab in the application
o Datasets for Crime View Community will be limited to either Incident
Reports from the RMS or Calls for Services for the CAD.
o 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)
o 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'
Application Development
Queries
o For each of the datasets, confirm which field(s) to have the query search
o Field may be CVLEGEND, 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