HomeMy WebLinkAbout2011-1261
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
29
2F
2E
2'.
2f
RESOLUTION NO. 2011-126
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 1. 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".
SECTION 3. That the Mayor and Common Council authorize the Director of Finance
or his/her designee to issue a purchase order for $40,000.00 to The Omega Group for these
services as outlined in The Omega Group's "Omega Dashboard, hosted deployment for San
Bernardino Police Department" quote dated Apri120, 2011. The Purchase Order shall reference
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.010(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.
I ///
///
2011-126
1
2
3
4
5
s
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21'~,
22
23
24
25
26
27
28
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
joint
Common Council of the City of San Bernardino at a regular meeting thereof, held on
the 6th day of June , 2011, by the following vote, to wit:
Council Members Ayes Nays Abstain Absent
MARQUEZ x
VACANT
BRINKER x
SHORETT x
KELLEY x
x
JOHNSON
McCAMMACK x
Rachel G. Clark, City
j The foregoing resolution is hereby approved this ~~'day of June , 2011.
d~•..-~
Pat ~ck J. Mom , r
of San Bernardino
Approve~as to form: ,,
,~;~"~
James F. Penman, City Attorney
~~L
2011-126
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 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.
E~chibit "A"
2011-126
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 bylaw.
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,
2011-126
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:
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
TO THE VENDOR:
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.
2011-126
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
By:
Approved as to Form:
James F. Penman, City Attorney
Charles McNeely, City Manager
By:
2011-126
VENDOR SERVICES AGREEMENT
This Vendor Services Agreement is entered into this 6th day of June ,
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 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.
2011-126
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 injrary 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 bylaw.
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,
2011-126
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 A~eement 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.
2011-126
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
Dated ~~ , 2011
Approved as to Form:
James F. Penman, City Attorney
t_
By: 2 ~=-~~ -..~ ~=
The Omega Group
C(..~--~
By:
Milan Mueller, President
CITY SAN BERNARD O
By: /
Charles McNeely, ity nag
2011-126
Exhibit "A"
THE OMEGB 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 I can
be of further assistance. Our office number is (800) 228-1059.
Thank you,
~~~ ~~
~:.
<< v;~
~' <sµ
~..~;
~,a.
~.,,
r.-
Hwy!
`~
F~
Michael W. Smith, PMP
Regional Sales Executive
The Omega Group
PH:800-228-1059 ext. 116
Email: mikes theome~agroup.com
5160 Carrali Canyon Road Suite 100 . San Diego, CA 92121 T48S8.450.2590 F (858.450.0239 Elamegatheomegagraup.cam
2011-126
San Bernardino Police Exhibit A
CRIMEVII= W j Ddslrboard Department, California 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 -Total:
Includes 15L Year Annual Hosting Fee
Customization/Configuration of Cases & Parole Profiles (pg. 9) Total:
Future Years Payments are due within 30 days of July 15t Total:
Grand Total;
2"d Year Annual Hosting Fee Total:
3~d Year Annual Hosting Fee Total:
4th Year Annual Hosting Fee Total:
4 Year Total
$34,200.00
$ 3, 500.00
$ 2,300.00
$40,000.00
$11,400.00
$11,400.00
$11,400.00
$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
2011-126
San Bernardino Police Exhibit A
CRIMEVIEW j Ddshboar4 Department, California April 20, 2011
Table of Contents
Payment Schedule
Software
Professional Services and Training
Hourly Rate
Implementation Timeline
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 4
Page 5
Page 5
Page 7
Page 7
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
2011-126
San Bernardino Police Exhibit A
CRIMEVIE i Doskboard Department, California April 20, 2011
Payment Schedule
Payments are due net (30) days from invoice.
15t Year
Pavment 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, 3rd, and 4th Year
Pavment 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
2011-126
San Bernardino Police Exhibit A
CRIMEViEW j Das/rboart/ Department, California 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
1.5. Dashboard Design
1.5.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 dataset
3.2. Omega will configure each dataset to display up to twenty (20) fields
3.3. Omega will create address locators
5
2011-126
San Bernardino Police Exhibit A
CRIMEVIE ~ Dashbodru~ Department, California 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
Service and RMS-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. Widge ts
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 Sheet; 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
2011-126
San Bernardino Police Exhibit A
CRIMEVIE ~ Da~shboQrd Department, California April 20, 2011
5. Omega Dashboard Application Training (Remote)
5.1. Omega will provide up to two (2) sessions of four (4) hours of onsite training on functionality
features for up to ten (10) trainees
5.2. Omega will provide up to six (6) hours of on-site Administrative/Designer training for up to six
(6) trainees
5.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: $185/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
2011-126
San Bernardino Police Exhibit A
CRIMEVIEW (Drrslrboard Department, California 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 Imported via Omega Import Wizard'"'
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 Database
• Cases Tiburon RMS
• PCFS Tiburon CAD
8
2011-126
San Bernardino Police Exhibit A
CRIMEVIEW ~ Das/rboord Department, California 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 datasets 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 3857)
projection
9
2011-126
San Bernardino Police Exhibit A
CRIMEIEW ~ Dashboard Department, California 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 cache(s) 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 5 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
2011-126
San Bernardino Police Exhibit A
GRIMEI/i ~ DoshboarG Department, California 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.
c~~r~ ..._.v.,..
"`±:~e~
8rieflngs
`,` .
.~-
=a .
d
Pafrot
1
RMS ~/
-Ar~dttor 1~
- Omrzga import Wizesrd
- Omaga Extr<3Cttlr
Other DatasaCs
„~~r~~~:,~ ,.
~,
o
:` e
~`
Databa e S r o fronal
- SQt Server 2(k(t8t2008 R2
- ArcSQE Stnd, Ent. 10
>i
2011-126
San Bernardino Police Exhibit A
CRIME W Ddsbbo~rG Department, California 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 asub-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
2011-126
San Bernardino Police Exhibit A
CRIMEVIEIN ,Dashboard Department, California 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
2011-126
San Bernardino Police Exhibit A
CRIMEVIEW ~ Dusbboart/ Department, California 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