HomeMy WebLinkAbout24-Police Department
CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION
From: Keith L. Kilmer, Chief of Police
Subject: Resolution of the Mayor and
Common Council of the City of San
Bernardino authorizing the purchase of
CrimeView server/Omega Dashboard II
web-based crime mapping services from
The Omega Group of San Diego, California.
Dept: Police Department
Date: May 10, 2011
Council Date: June 6, 2011
Synopsis of Previous Council Action:
November 17,2008 Resolution #2008-428 approved the purchase of CrimeView Community
Web-based Crime Mapping services from The Omega Group of San
Diego, California
January 7, 2008 Resolution #2008-031 approved the purchase of a "CrimeView
Enterprise" police tactical mapping solutions from The Omega Group of
San Diego, Califomia.
Recommended Motion:
Adopt Resolution.
/ ~-~ ~
Keith L. Kilmer, Chief of Police
~'Lo~'
Lea Deesing, ore or of Information Technology
Contact person: r.RptRin .IRrron RllrgllRn
Phone:
::IR4-,,000
Supporting data attached: Staff Report/Reso
Ward:
All
FUNDING REQUIREMENTS:
Amount:
9) 40 000 00
Source:
Accl. No. 123-741-5502-0000-0078
Professional/Contract Services
2008 COPS Technology Grant
Finance:
Council Notes:
Agenda Item No. ,!} If
(;M-CXR ~ del (
STAFF REPORT
To:
Honorable Mayor aod Members of the Common Council/Community
Development Commission
From:
Keith L. Kilmer, Chief of Police
Subject:
Resolution of the Mayor and Common Council of the City of Sao Bernardino
authorizing the purchase of CrimeView server/Omega Dashboard II web-based
crime mapping services from The Omega Group of Sao Diego, California.
Backl!round:
In September 2008 the Sao Bernardino Police Department implemented The Omega Group's
Dashboard-I application. This first-generation application automatically generates crime maps
twice daily. These maps are used by police maoagers, supervisors, aod patrol officers to identify
problem crime locations in the city and in their patrol beats. The data that this early version of
the Omega Dashboard generates is static, aod cannot be manipulated by the user. The police
department's current Omega Dashboard provides users with Part I crimes that have occurred in
the past 14 aod 30 days, and Part I crimes that have occurred year to date.
This purchase of The Omega Group's second generation Omega Dashboard-II will provide
police maoagers, supervisors, aod patrol officers with a timely overview of recent events in the
form of interactive reports, maps, and charts. The application will be hosted by The Omega
Group to reduce costs aod will not require the purchase of any additional hardware or software.
All information is accessed through a web browser. The application is user-friendly aod does not
require aoy knowledge of Geographic Information Systems (GIS) or mapping software or
applications. The purchase will cover the hosting costs, software maintenance, aod includes all
software/hardware fees needed to remotely host the site on a secure server. The purchase will
also allow for fifty simultaneous users to access Dashboard-II.
Since the initial implementation of CrimeView Dashboard, the police department has begun
holding monthly crime briefings. In these briefings, police maoagers share crime maps created
by the IT aoalyst. Maoagers use these static maps to explain what has recently occurred in their
patrol districts. If a question arises about a particular area in their district, the map cannot be
chaoged so they cannot give visualization to the audience of what they are describing. The new
Omega Dashboard-II allows for individual views to be created so views specific to the crime
briefing cao be set up. If a question arises about a specific area, the lieutenaot cao focus the map
on that particular area.
Patrol officers aod crime aoaIysts will be able to use this data to identify crime series aod crime
trends. This new application will significaotly reduce the amount of time it takes to research
crimes by providing most of the pertinent data in the application, aod not requiring the user to
have to research each report to retrieve information such as day of the week or time of day the
crime occurred. Dashboard-II will also be able to incorporate other data into the maps such as
parolee location, sex offender addresses, aod field interview card information.
This technology can also be shared in a public forum at community meetings. Through a secure
internet connection, police department employees will have the ability to share the same data that
they use at crime briefings with the public. The ability to share this information with the public
will enhance the quality of the department's community-oriented policing and problem-oriented
policing programs.
The Omega Group is offering the City a 10% discount for this service. This is a substantial cost
benefit to the City. Based on the exceptional support and services that The Omega Group
currently provides the Police Department, 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 Crime View Server/Omega Dashboard-II Web-based Crime
Mapping services from The Omega Group of San Diego, California.
Financial Impact:
Funds for this purchase order of $40,000.00 are appropriated in the 2008 COPS Technology
Grant (account no. 123-742-5502-0000-0078). Impact on the General Fund: Annual Hosting
Fees for fiscal years 2012/2013, 2013/2014, and 2014/2015 will have to be added to
Maintenance/Hosting fees for the existing CrimeView Community services in the amount of
$11,400.00 per year.
Account: 123-742-5502-0000-0078
Budgeted Amount: $40,000
Balance as of 4/28/20 11: $56,80 I
Balance after approval of this item: $16,801
Please note this balance does not indicate available funding. It does not include non-
encumbered reoccurring expenses or expenses incurred, but not yet processed.
Recommendation:
Adopt Resolution.
21
22
23
24
25
26
27
28 III
1
2
3
4
5
6
7
8
9
10
11
12
13
14
RESOLUTION NO.
RESOLUTION OF THE MAYOR AND COMMON COUNCIL OF THE CITY OF
SAN BERNARDINO AUTHORIZING THE PURCHASE OF OMEGA DASHBOARD WEB-
BASED CRIME MAPPING SERVICES FROM THE OMEGA GROUP OF SAN DIEGO,
CALIFORNIA.
NOW THEREFORE, BE IT RESOLVED BY THE MAYOR AND COMMON
COUNCIL OF THE CITY OF SAN BERNARDINO AS FOLLOWS:
SECTION I. Whereas The Omega Group of San Diego, California, is the existing
provider of software and professional services to the Police Department for internal Crime
Mapping Software, the Mayor and Common Council hereby approve the purchase of Omega
Dashboard Web-based Crime Mapping Services.
SECTION 2. That the City Manager or his designee is authorized and directed to
execute a Vendor Service Agreement and Hosting Agreement in the total amount of
$40,000.00, a copy of which is attached hereto as Exhibit "A".
15
16 or hislher designee to issue a purchase order for $40,000.00 to The Omega Group for these
17
SECTION 3. That the Mayor and Common Council authorize the Director of Finance
services as outlined in The Omega Group's "Omega Dashboard, hosted deployment for San
18
Bernardino Police Department" quote dated April 20, 201 I. The Purchase Order shall reference
19
20 the number of this Resolution and shall incorporate the terms and read "San Bernardino PD
Omega Dashboard Hosting Services. Not to exceed $40,000.00"
SECTION 4. This purchase is exempt from the formal contract provisions of San
Bernardino Municipal Code Section 3.04.01O(B)(3), "Purchases approved by the Mayor and
Common CounciL"
SECTION 5. The above authorization is rescinded if it is not executed within ninety
(90) days of the passage of this resolution.
III
14
15
16
17
18
19
20
21
22
23
24
25
26 APprr~s to form:
27 ,A / , ,(
" "'..-L
28 James F. Penman, City Attorney
1
2
3
4
5
6
7
8
9
RESOLUTION OF THE MAYOR AND COMMON COUNCIL OF THE CITY OF
SAN BERNARDINO AUTHORIZING THE PURCHASE OF CRIMEVIEW
SERVER/OMEGA DASHBOARD WEB-BASED CRIME MAPPING SERVICES FROM
THE OMEGA GROUP OF SAN DIEGO, CALIFORNIA.
I HEREBY CERTIFY that the foregoing resolution was duly adopted by the Mayor and
Common Council of the City of San Bernardino at a
meeting thereof, held on
the_day of
, 20 II, by the following vote, to wit:
Council Members
Aves.
Navs
Abstain
Absent
10 MARQUEZ
11
12
13
VACANT
BRINKER
SHORETT
KELLEY
JOHNSON
McCAMMACK
Rachel G. Clark, City Clerk
The foregoing resolution is hereby approved this
day of
,2011.
Patrick J. Morris, Mayor
City of San Bernardino
VENDOR SERVICES AGREEMENT
This Vendor Services Agreement is entered into this _ day of .
by and between The Omega Group, of San Diego, California ("VENDOR") and the City of
San Bernardino, California ("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 the configuration, deployment and hosting of
Omega Dashboard 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 in Omega Dashboard, hosted
deployment for San Bernardino Police Department Proposal document (dated April 18, 2011) as
Exhibit "A," attached hereto and incorporated herein.
2. COMPENSATION AND EXPENSES.
a. For the services delineated above, the VENDOR, shall retain deliver, install,
configure, activate and provide the training outline in the VENDOR'S Project
Proposal attached as Exhibit "A".
b. No other expenditures made by VENDOR shall be reimbursed by CITY.
3. TERM.
The initial term of this Agreement shall be for a period of six months. The VENDOR
must complete all work with 180 days of receipt of a City Purchase Order.
The Municipality may terminate this Agreement at any time by giving sixty (60) days written
notice to Vendor. Municipality shall pay all that is payable under this Agreement to Vendor until
the date of termination.
Termination of Cause. If either party materially breaches any of its duties or obligations hereunder,
and such breach is not cured, or the breaching party is not diligently pursuing a cure to the non-
breaching party's sole satisfaction, within (30) calendar days after written notice of the breach,
then the non-breaching party may terminate tlris Agreement for cause of a date specified in such
notice.
Effect of Termination. If this Agreement is terminated as provided herein, Municipality may
require Vendor to provide all finished or unfinished documents and data and other information
of any kind prepared by Vendor in connection with the performance of services under this
Agreement. Vendor shall be required to provide such documents and other information within
fifteen (15) days of the request.
Exhibit "A"
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 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$I,OOO,OOO.OO 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 at least 30 days prior to any
change in or termination of 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.
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:
Jason Suarez, Public Safety IT Manager
San Bernardino Police Department
710 North "D" Street - B Bldg PSG
San Bernardino, CA 92401
Telephone: (909) 384-5742
Mr. Milan Mueller
The Omega Group
5160 Carrol Canyon Rd, Suite 100
San Diego, CA 92121
Telephone: (800) 228-1059
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 assigrunent, 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.
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.
IN WITNESS THEREOF, the parties hereto have executed this Agreement on the day
and date set forth below.
Dated:
,2011
The Omega Group
By:
Milan Mueller, President
Dated
,2011
CITY OF SAN BERNARDINO
Approved as to Form:
James F. Penman, City Attorney
By:
Charles McNeely, City Manager
By:
VENDOR SERVICES AGREEMENT
This Vendor Services Agreement is entered into this _ day of ,
by and between The Omega Group, of San Diego, California ("VENDOR") and the City of
San Bernardino, California ("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 the configuration, deployment and hosting of
Omega Dashboard 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 in Omega Dashboard, hosted
deployment for San Bernardino Police Department Proposal document (dated April 18, 2011) as
Exhibit "A," attached hereto and incorporated herein.
2. COMPENSA nON AND EXPENSES.
a. For the services delineated above, the VENDOR, shall retain deliver, install,
configure, activate and provide the training outline in the VENDOR'S Project
Proposal attached as Exhibit "A".
b. No other expenditures made by VENDOR shall be reimbursed by CITY.
3. TERM.
The initial term of this Agreement shall be for a period of six months. The VENDOR
must complete all work with 180 days of receipt of a City Purchase Order.
The Municipality may terminate this Agreement at any time by giving sixty (60) days written
notice to Vendor. Municipality shall pay all that is payable under this Agreement to Vendor until
the date of termination.
Termination of Cause. If either party materially breaches any of its duties or obligations hereunder,
and such breach is not cured, or the breaching party is not diligently pursuing a cure to the non-
breaching party's sole satisfaction, within (30) calendar days after written notice of the breach,
then the non-breaching party may terminate this Agreement for cause of a date specified in such
notice.
Effect of Termination. If this Agreement is terminated as provided herein, Municipality may
require Vendor to provide all finished or unfinished documents and data and other information
of any kind prepared by Vendor in connection with the performance of services under this
Agreement. Vendor shall be required to provide such documents and other information within
fifteen (15) days of the request.
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 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 at least 30 days prior to any
change in or termination of 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.
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:
Jason Suarez, Public Safety IT Manager
San Bernardino Police Department
710 North "D" Street - B Bldg PSG
San Bernardino, CA 92401
Telephone: (909) 384-5742
Mr. Milan Mueller
The Omega Group
5160 Carrol Canyon Rd, Suite 100
San Diego, CA 92121
Telephone: (800) 228-1059
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.
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.
IN WITNESS THEREOF, the parties hereto have executed this Agreement on the day
and date set forth below.
Dated:
,2011
The Omega Group
By:
Milan Mueller, President
Dated
,2011
CITY OF SAN BERNARDINO
Approved as to Form:
James F. Pe an, City Attorney
. .~
By: /G~ L ,p
By:
Charles McNeely, City Manager
Exhibit "A"
n THE OMEGR GROUP
April 20, 2011
Matthew Good
IT Analyst - Crime Mapping
Crime Analysis Unit
San Bernardino Police Department
300 N. D Street
San Bernardino, CA 92418
Re: Omega Dashboard, hosted deployment for San Bernardino Police Department
Matthew,
Enclosed are the estimated costs for a hosted CrimeView Dashboard solution. This four (4)
year hosting package is priced at $74,200.00 representing a 10% discount off of standard
pricing: $82,080.00. We value the San Bernardino Police Departments business greatly and
thank you for your continued interest in working with The Omega Group for your crime
mapping and analysis needs. Application descriptions, along with pricing, requirements and
configurations are included.
After your review, please do not hesitate to contact me with any questions or if you think 1 can
be of further assistance. Our office number is (800) 228-1059.
Thank you,
~~
Michael W. Smith, PMP
Regional Sales Executive
The Omega Group
PH: 800-228-1059 ext. 116
Email: mikes@ltheomegagrouP.com
5160 Carroll Canyon Road I Suite 100 I San Diego. CA 92121 TI858.450.2590 F 1858.450.0239 Elomega@theomegagfoup.com
CRIMEVIEW I Difslt6.ifrtl
San Bernardino Police
Department, California
Exhibit A
April 20, 2011
Project Quote Summary
The proposed Hosting Package is a four (4) year agreement and it includes CrimeView
Dashboard. The pages following include itemized pricing, service oriented tasks and
requirements.
Software, Professional Services and Training
Includes 1st Year Annual Hosting Fee
Customization/Configuration of Cases & Parole Profiles (pg. 9)
Future Years Payments are due within 30 days of July 1st
Total:
$34,200.00
Total:
Total:
Grand Total:
$ 3,500.00
$ 2,300.00
$40,000.00
20d Year Annual Hosting Fee
3rd Year Annual Hosting Fee
4th Year Annual Hosting Fee
Total:
Total:
Total:
$11,400.00
$11,400.00
$11,400.00
4 Year Total:
$74,200.00
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 estimate will remain valid for 3 months from the date on the estimate for Omega
Software and Services only.
2
CRIMEVIEW I Dashboard
San Bernardino Police
Department, California
Exhibit A
April 20, 2011
Table of Contents
Payment Schedule
Software
Professional Services and Training
Hourly Rate
Implementation Timeline
Page 4
Page 5
Page 5
Page 7
Page 7
Omega Dashboard Site License Description
Incident Data Specifications
GIS Data Specifications
Symbology
Operational Layers
Saved Queries
Geographic Queries
Hardware Specifications
Client Roles and Responsibilities
Omega Roles and Responsibilities
Remote Connectivity
Hosting Security
Hosting Agreement
Page 8
Page 8
Page 9
Page 10
Page 10
Page 10
Page 10
Page 11
Page 12
Page 12
Page 13
Page 14
Page 15
3
CRIMEVIEW I DdSHbOdrd
San Bernardino Police
Department, California
Exhibit A
April 20, 2011
Payment Schedule
Payments are due net (30) days from invoice.
1st Year
Payment
Amount
Deliverable
. Payment # 1 $ 22,800.00 of the total amount due upon execution of
PO/professional services agreement
. Payment # 2 $ 17,200.00 of the total amount due 30 days after completion
of all services.
2nd, 3'd , and 4th Year
Payment
Amount
Deliverable
. Annual Hosting Fee $ 11,400.00 Due one (1) year from go-live of CrimeView
Dashboard
. Annual Hosting Fee $ 11,400.00 Due two (2) years from go-live of CrimeView
Dashboard
. Annual Hosting Fee $11,400.00 Due three (3) years from go-live of
CrimeView Dashboard
4
CRIMEVIEW I Ddsh60drtl
San Bernardino Police
Department, California
Exhibit A
April 20, 2011
Software
One (1) License of Omega Dashboard 2.1.3 Site License (Hosted by Omega)
One (1) license of Omega Import Wizard (on premise)
One (1) license of Omega Extractor (on premise)
One (1) license of ESRI's ArcGIS 9.3 or higher (on premise)
Professional Services and Training
1. Project Planning/Management
1.1. Software and database requirements
1.1.1. Review deliverables for client
1.1.1.1. Omega client software: Omega Import Wizard
1.1.1.2. Omega server software: Omega Dashboard
1.2. System Architecture
1.2.1. Identify hardware components and configuration.
1.2.1.1. Import server
1.3. GIS map layers and design preferences
1.3.1. Identify base map GIS data layers for geographic querying
1.3.2. Identify reference data for geocoding
1.4. CAD/RMS/other source data
1.4.1. Review import process and automation
1.4.2. Identify fields to be imported
1.4.3. Review database schema and tabular relationships
l.S. Dashboard Design
l.S.1. Determine remote connection method
1.6. Review roles and responsibilities
2. Omega Import Wizard Configuration
2.1. Client will install ArcGIS on import workstation
2.2. Client will install Import Wizard on import server or workstation
2.2.1. Omega will extract sample datasets for application development
2.3. Omega will update import profile for CAD/RMS data extraction
2.3.1. Omega will create SQL Statement
2.3.2. Omega will configure data processing steps
2.3.3. Omega will configure geocoding process, review the sample data's geocoding
rates and provide recommendations
2.3.4. Omega will configure output data sets and automation
3. Omega Dashboard Application Configuration
3.1. The Dashboard will include approximately a rolling thirty-six (36) months of historical
data for each data set
3.2. Omega will configure each dataset to display up to twenty (20) fields
3.3. Omega will create address locators
5
CRIMEVIEW I DdShPOdrtl
San Bernardino Police
Department, California
Exhibit A
April 20, 2011
3.4. Omega will configure up to ten (10) geographic query layers
3.5. Omega can configure up to five (5) operational layers; if Omega or client's existing map
caches are used, Omega will configure up to three (3) operational layers
3.6. Omega will create up to five hundred (500) total saved query pick list items per query
layer
3.7. Omega will use Bing maps for the application's background layers or can possibly
integrate with a client's existing map caches
3.8. Configure Omega Dashboard design
3.8.1. Briefing Books
3.8.1.1. Omega will configure up to two (2) Briefing Books for CAD-Calls for
5ervice and RM5-Case data
3.8.1.1.1. One (1) Executive Briefing Book with up to twenty-five (25)
Widgets
3.8.1.1.2. One (1) Roll Call Briefing Book with up to thirty-five (35) Widgets;
an identical roll call briefing book will be available for up to ten (10)
areas of accountability
3.8.2. Pages
3.8.2.1. Crime trends
3.8.2.2. Recent activity
3.8.3. Widgets
3.8.3.1. Filter/Pin Map/Heat Map
3.8.3.2. Density Map
3.8.3.3. Trend Chart
3.8.4.Hot 5heet; Omega will configure up to five (5) Alerts
3.8.5. The Dashboard content listed above will be configured according to the
Dashboard Briefing Books document. Client should review those documents and
identify any changes during the sales process. An additional cost may be incurred
with changes.
4. Omega Dashboard Application Deployment
4.1. Omega will install and configure the Omega Dashboard application
4.2. Omega will configure data import profiles for live data transfer to the Omega
Dashboard
4.3. Omega will import up to three (3) months of historical data for each dataset; the client
will be responsible for importing beyond three (3) months
4.4. Omega will schedule automated data import process
4.5. Dashboard Widgets will refresh up to two (2) times per day
6
CRIMEVIEW I Di1s!16.i1n/
San Bernardino Police
Department, California
Exhibit A
April 20, 2011
5. Omega Dashboard Application Training (Remote)
S.1. Omega will provide up to two (2) sessions offour (4) hours of onsite training on functionality
features for up to ten (10) trainees
S.2. Omega will provide up to six (6) hours of on-site Administrative/Designer training for up to six
(6) trainees
S.3.
6. Finishing Application Design
6.1. Collect and review application edit requests
6.2. All configuration change requests must be made within fourteen (14) days following
the onsite training session
6.3. Change requests after this fourteen (14) day testing period will incur an additional fee
6.4. Modify import profiles, saved queries, and application style, per user feedback
6.5. Test application functionality
6.6. The application content is configurable; the application interface is not customizable
Hardware Total: N/A
Hardware is not included in this package. See Hardware Specifications section.
Hourly Rate
Additional services: SIBS/hour
Implementation Timeline
. The installation of the application will occur approximately 60-90 days after the
collection of data, which includes the following tasks:
o Provision of a remote connection (client)
o Installation of ArcGIS and Omega software
o Provision of CAD/RMS database connection (client)
o Provision of CAD/RMS schema and identification of required data lookup tables
(client)
o Creation of SQL import queries (Omega/client)
o Provision of GIS data (client)
o Review/approval of sample data (client)
7
CRIMEVIEW I Ddslr60drd
San Bernardino Police
Department, California
Exhibit A
April 20, 2011
Omega Dashboard Site License Description
The Omega Dashboard application is a site license. This means that there are no limitations to
the number of users of Omega Dashboard. The Site License has four (4) user types with
permissions:
o Shared Users (unlimited users):
No personalized information is allowed. Users can view the dashboard, and conduct
analysis, but they cannot make any permanent changes to the system.
o Standard (2 to 5 users):
. Users can personalize their dashboard view with any information set up in
the library
. Users can build their own Queries on Demand.
o Designer (2 to 5 users):
. Users can build dashboard widgets
. Users can build their own Queries on Demand
. Users can build library content
. Users can personalize their dashboard view with any information set up in
the library
. Users can build alerts
o Administrator (1 to 2 users):
. Users can create editions and set permissions.
. Users can perform all Designer functions.
Incident Data Specifications
Datasets to be Imaorted via Omeaa Imaort Wizard'M
Omega Dashboard automates the import of source data via an application called the Import
Wizard. Each Omega Dashboard dataset (layer) is imported daily via Import Wizard profiles
(licensed individually). The profile license contains configuration information for extracting
data from an RMS (via a SQL Statement), geocoding, data processing, & subsequently
outputs/appends the result into a GIS feature class format. It is important to consider that
source data originating from a relational database will be transposed into a de-normalized (flat
file) format. As a result, there will be one "dot" on the map per record in the Omega
Dashboard dataset*.
An import profile will be built for each dataset. A total of two (2) profiles have been identified
for this project. The application will be configured to support the following datasets:
Data Set
10 Cases
o PCFS
Database
I Tiburon RMS
Tiburon CAD
8
CRIMEVIEW I DdsnoOdrd
San Bernardino Police
Department, California
Exhibit A
April 20, 2011
Profile/Dataset Customization/Configuration:
1) Case Reports: Matthew good would like us to customize the Case Reports dataset to
include Method of Entry, Point of Entry, Weapons, etc.
2) Parole: Mathew good has a Parole shape file the he would like us to integrate into the
CrimeView Dashboard System.
Because a significant amount of work (and cost) can be attributed to the collection of source
data, it is important that Omega project management have access to information regarding
the CAD/RMS data dictionary that details database structure and code definitions. The
database structure should include table names, field names, field type, field size, and known
linking fields.
All of these datasets will be included in the Analysis Mode of the application while Dashboard
content configuration will only include the data sets outlined in the Omega Dashboard
Application Configuration section.
· The maximum number of records returned on a Dashboard Widget or query is five thousand
(5,000) records
GIS Data Specifications
Boundary and landmark Features: The client shall provide files of relevant boundaries and
landmarks within the area of interest. Typical features include:
. Boundaries and jurisdictions such as beats and reporting districts
. landmark information such as schools, parks, and other locations of interest
. Aerial imagery (if deliverables include custom map caches)
Geocoding Reference Data: The client is responsible for providing accurate reference data that
will be used to generate a geocoding service. Reference data may include the following
geography: street centerline file, address points or a parcel layer.
Background layers
The Omega Dashboard supports the use of one or more Background layers (or map caches).
These Background layers are used to display a base map as a backdrop to the Geoprocessing
results.
Omega will use Bing maps' for the application's background layers. If the client does not wish
to use Bing maps, the following two options are available:
1) Client map caches - The following criteria must be met if the client wishes to use their own
maps caches:
a. Caches must be built using the Web Mercator Auxiliary Sphere (102100 or 38S7)
projection
9
CRIMEVIEW I Dashboard
San Bernardino Police
Department, California
Exhibit A
April 20, 2011
b. If multiple caches will be used in the Dashboard, the zoom levels must match
between caches
c. The caches must be accessible by URL to all intended end-users
d. The client is responsible for maintaining the map cachets) and assuring its'
availability and accessibility.
2) Omega-built map cache(s) (additional fees apply)
a. If Omega is to build a map cache containing aerial raster data, the client must
ensure that a spatial reference has been defined on all image files
b. If the application will be hosted, source aerial raster data must not exceed S GB of
disk space
* Bing Maps are offered free of charge with the purchase of Esri ArcGIS Server software. Omega does not
guarantee the offer. All updates to Bing Maps including both data availability and price are not administered by
The Omega Group. The Omega Group will do it's best to notify the client in advance of any changes to the offer.
Any changes in price for Bing Maps will be passed on to the client either as part of annual maintenance or
invoiced separately.
Interactive Functionality
Reporting capabilities include dynamic mapping, sorting, grouping, and charting.
Symbology
All applications include standard Omega symbology for each data source.
Operational Layers
An operational layer represents a set of geographic features, typically boundaries or landmarks
that can be displayed on top of the base geography.
Saved Queries
Saved queries are a set of pre-defined data queries organized in folders. Data queries are
based on data available from the RMS or CAD system and vary in design from one application
to another.
Geographic Queries
Geographic queries filter your data query by location, a known boundary, point of interest,
address or intersection. This will limit your search results to those records occurring within the
selected boundary, or within the specified radius of the point of interest, address or
intersection.
10
CRIMEVIEW I Ddslr60drd
San Bernardino Police
Department, California
Exhibit A
April 20, 2011
Hardware Specifications
Workstations
Minimum user machine specifications for workstations accessing Omega Dashboard:
. Processor: 2.00 GHz Dual-core Intel processor (or faster)
. RAM: 2 GB (or greater)
. Network Card: 1 Gb (1000 Mb) Gigabit networking
(client's network must be running Gigabit switches to support Gigabit networking)
. Monitor: Minimum resolution: 1024px X 768px
. OS: No specific requirement
. Browser Support: Firefox, Safari, Chrome, or IE7 (or higher)
. Other: Silverlight 4 (or higher), Adobe Reader
Configuration Diagram
The diagram below depicts the data flow from the Law Enforcement Databases to the Omega
Dashboard application.
Omega Hosting
Environment
QCAO
~
(
Client Network
fVJt
Briefings
;;:,.
;;:,. ;;:,.
Pacrol
r()
~
.
.
.
o
~
RMS
Q/
Imoort Server
. ArcEdltor 10
. Omega Import Wizard
. Omega ElltraclQf
Database Server lnotional)
. SOL Server 200812008 R2
. ArcSDE Strul Ent 10
Other a.lasets
11
CRIMEVIEW I Ddsh60drtl
San Bernardino Police
Department, California
Exhibit A
April 20, 2011
Client Roles and Responsibilities
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.
Client Project Manager
The client project manager is responsible for the timely coordination of assigned project tasks.
Database Administrator
The client database administrator is responsible for providing information about the CAD/RMS
database and assisting with the collection of source data.
IT Specialist
The client IT specialist is responsible for installing/licensing the ArcView and Omega Desktop
software, providing a method of remote access, and creating a sub-domain host header.
GIS Analyst
The client GIS analyst is responsible for providing and maintaining base map data in an ESRI
compatible format.
Crime Analyst
The crime analyst should have experience working with CAD/RMS data. The crime analyst
should provide input during the project's development.
Dashboard Administrator
The Dashboard Administrator is responsible for adding/maintaining user accounts. The
Dashboard Administrator can also be the Dashboard Designer.
Dashboard Designer
The Dashboard Designer is responsible for creating/maintaining Dashboard content (Widgets,
Pages, Alerts, Queries on Demand, etc.).
Omega Roles and Responsibilities
Omega Project Manager/Lead
The Omega project manager/lead is responsible for the coordination, development and
implementation of a project. A project manager/lead has both the technical proficiency and
management skills to carry out all project tasks from inception to completion. Project
managers will prioritize project tasks in accordance with project schedules and delegate work
to project staff as necessary. Responsibilities include:
. leading internal and/or external meetings on project kickoff, implementation,
scheduling, project status and project evaluation
. Planning, executing, tracking and measuring all project activities required for the
successful delivery of Omega application(s)
12
CRIMEVIEW I Ddslt60drtf
San Bernardino Police
Department, California
Exhibit A
April 20, 2011
. Identifying priorities and managing the resources required to meet the project
objectives
. Performing and/or managing the technical tasks involved in the GIS application
development process to include, but not limited to: data collection, geocoding, queries,
report writing, and map production
. Delivering project in compliance with both client and internal quality control standards
and guidelines
. Conducting on-site training
Deployment Specialist
The Omega Deployment Specialist is responsible for remotely installing each server-based
Omega application within the client's environment or at Omega's hosting facility. This takes
place once the project build has been completed and the application has been fully tested
at Omega. Responsibilities include:
. Verifying that the required hardware and software is in place to run the application
. Installing all ESRI software required by the application (as well as SQL Server, where
necessary)
. Installing all Omega Dashboard software
. Configuring the application to function within the specified environment
. Troubleshooting any environmental issues that may arise during deployment
Remote Connectivity
Determine Method of Remote Access
. Establishing remote connection to the server(s)
o Data collection, installation and technical support will be performed through
remote connection
o Omega recommends VPN or Citrix's GoToMyPC for remote connections
. Client must provide the necessary remote access details
. If the client is unable to provide high speed remote access, a fee will be incurred based
on the additional time required for data collection and application development
13
CRIMEVIEW I Ddsh60drtl
San Bernardino Police
Department, California
Exhibit A
April 20, 2011
Hosting Security
Physical Security
Our hosting facility offers 24-hour physical security, palm print biometrics as well as picture
identification systems, redundant electrical generators, redundant cooling systems, and other
backup equipment to help insure continuous operation is not impeded in any way.
Data Encryption
The most powerful encryption techniques available are utilized in order to protect the integrity
of the data we receive from our clients. This includes 128-bit SSL Certification as well as 1024-
bit RSA public keys.
Operating System Security
A minimum number of access points to all production servers helps maintain a high level of
operating system security. All passwords are kept strong through length as well as complexity.
No master password database is maintained for our production servers. Operating systems are
maintained at vendor recommended patch levels for maximum security. All unnecessary users,
protocols and processes are also removed to reduce the number of access points.
Database Security
Controls are in place on all database access points at both operating system and database
connection levels for added security. Production server database access is restricted to a
minimal number of points to help provide a tighter defense.
Server Management Security
Access to our hosting facility is only available to Omega staff with the highest levels of security
clearance within our organization. The majority of Omega staff has no physical access to the
equipment at our hosting facility.
Disaster Recovery
Our secure facility includes state of the art cooling systems, 24x7 monitoring as well as built in
redundancy. All of our servers are run with Raid-10, which represents one of the most reliable
and fastest forms of redundancy available.
14