CONTRACT 3842 Professional Services Agreement CLOSEDs b 4 2 • j
PROFESSIONAL SERVICES AGREEMENT
BETWEEN
THE CITY OF EL SEGUNDO AND
THE OMEGA GROUP
This AGREEMENT is entered into this 17th day of June, 2008, by and between the
CITY OF EL SEGUNDO, a municipal corporation and general law city ( "CITY ") and The
Omega Group, Inc. a California Corporation ( "CONSULTANT ").
1. CONSIDERATION.
A. As partial consideration, CONSULTANT agrees to perform the work listed in the
SCOPE OF SERVICES, below;
B. As additional consideration, CONSULTANT and CITY agree to abide by the
terms and conditions contained in this Agreement;
C. As additional consideration, CITY agrees to pay CONSULTANT a sum not to
exceed eighteen thousand nine hundred ninety five dollars ($18,995) for
CONSULTANT's services. CITY may modify this amount as set forth below.
Unless otherwise specified by written amendment to this Agreement, CITY will
pay this sum as specified in the attached Exhibit "A," which is incorporated by
reference.
2. SCOPE OF SERVICES.
A. CONSULTANT will perform services listed in the attached Exhibit `B," which is
incorporated by reference.
B. CONSULTANT will, in a professional manner, furnish all of the labor, technical,
administrative, professional and other personnel, all supplies and materials,
equipment, printing, vehicles, transportation, office space and facilities, and all
tests, testing and analyses, calculation, and all other means whatsoever, except as
herein otherwise expressly specified to be furnished by CITY, necessary or proper
to perform and complete the work and provide the professional services required
of CONSULTANT by this Agreement.
3. PERFORMANCE STANDARDS. While performing this Agreement, CONSULTANT
will use the appropriate generally accepted professional standards of practice existing at the time
of performance utilized by persons engaged in providing similar services. CITY will
continuously monitor CONSULTANT's services. CITY will notify CONSULTANT of any
deficiencies and CONSULTANT will have fifteen (15) days after such notification to cure any
shortcomings to CITY's satisfaction. Costs associated with curing the deficiencies will be borne
by CONSULTANT.
-1-
3842•...
4. PAYMENTS. In consideration of the services to be performed by Omega, Omega will be
entitled to compensation in the total amount of $18,995.00. The payment schedule is as follows:
• Thirty percent
$5,698.50
Of the total amount due upon execution of this
(30 %)
Agreement.
• Thirty percent
$5,698.50
Of the total amount due upon delivery CrimeView
(30 %)
Desktop Software
• Thirty percent
$5,698.50
of the total amount due upon completion of
(30 %)
CrimeView® Desktop Deployment
• Ten Percent (10 %)
$1,899.50
of the total amount due thirty (30) days after
completion of services
5. NON - APPROPRIATION OF FUNDS. Payments due and payable to CONSULTANT for
current services are within the current budget and within an available, unexhausted and
unencumbered appropriation of the CITY. In the event the CITY has not appropriated sufficient
funds for payment of CONSULTANT services beyond the current fiscal year, this Agreement
will cover only those costs incurred up to the conclusion of the current fiscal year.
6. ADDITIONAL WORK.
A. CITY's city manager ( "Manager ") may determine, at the Manager's sole
discretion, that CONSULTANT must perform additional work ( "Additional
Work ") to complete the Scope of Work. If Additional Work is needed, the
Manager will give written authorization to CONSULTANT to perform such
Additional Work.
B. If CONSULTANT believes Additional Work is needed to complete the Scope of
Work, CONSULTANT will provide the Manager with written notification that
contains a specific description of the proposed Additional Work, reasons for such
Additional Work, and a detailed proposal regarding cost.
C. Payments over $18,995.00 for Additional Work must be approved by CITY's city
council. All Additional Work will be subject to all other terms and provisions of
this Agreement.
7. FAMILIARITY WITH WORK.
A. By executing this Agreement, CONSULTANT agrees that it has:
Carefully investigated and considered the scope of services to be
performed;
ii. Carefully considered how the services should be performed; and
-2-
3842....E
iii. Understands the facilities, difficulties, and restrictions attending
performance of the services under this Agreement.
B. If services involve work upon any site, CONSULTANT agrees that
CONSULTANT has or will investigate the site and is or will be fully acquainted
with the conditions there existing, before commencing the services hereunder.
Should CONSULTANT discover any latent or unknown conditions that may
materially affect the performance of the services, CONSULTANT will
immediately inform CITY of such fact and will not proceed except at
CONSULTANT's own risk until written instructions are received from CITY.
8. TERM. The term of this Agreement will be from June 16, 2008 to June 15, 2009. Unless
otherwise determined by written amendment between the parties, this Agreement will terminate
in the following instances:
A. Completion of the work specified in Exhibit "A ";
B. Termination as stated in Section 16.
9. TIME FOR PERFORMANCE.
A. CONSULTANT will not perform any work under this Agreement until:
i. CONSULTANT furnishes proof of insurance as required under Section 23
of this Agreement; and
ii. CITY gives CONSULTANT a written notice to proceed.
B. Should CONSULTANT begin work on any phase in advance of receiving written
authorization to proceed, any such professional services are at CONSULTANT's
own risk.
10. TIME EXTENSIONS. Should CONSULTANT be delayed by causes beyond
CONSULTANT's control, CITY may grant a time extension for the completion of the contracted
services. If delay occurs, CONSULTANT must notify the Manager within forty -eight hours (48
hours), in writing, of the cause and the extent of the delay and how such delay interferes with the
Agreement's schedule. The Manager will extend the completion time, when appropriate, for the
completion of the contracted services.
11. CONSISTENCY. In interpreting this Agreement and resolving any ambiguities, the main
body of this Agreement takes precedence over the attached Exhibits; this Agreement supersedes
any conflicting provisions. Any inconsistency between the Exhibits will be resolved in the order
in which the Exhibits appear below:
A. Exhibit A: Scope of Work;
-3-
3842.
B. Exhibit B: Budget; and
C. Exhibit C: Proposal for Services.
12. CHANGES. CITY may order changes in the services within the general scope of this
Agreement, consisting of additions, deletions, or other revisions, and the contract sum and the
contract time will be adjusted accordingly. All such changes must be authorized in writing,
executed by CONSULTANT and CITY. The cost or credit to CITY resulting from changes in
the services will be determined in accordance with written agreement between the parties.
13. TAXPAYER IDENTIFICATION NUMBER. CONSULTANT will provide CITY with a
Taxpayer Identification Number.
14. PERMITS AND LICENSES. CONSULTANT, at its sole expense, will obtain and
maintain during the term of this Agreement, all necessary permits, licenses, and certificates that
may be required in connection with the performance of services under this Agreement.
15. WAIVER. CITY's review or acceptance of, or payment for, work product prepared by
CONSULTANT under this Agreement will not be construed to operate as a waiver of any rights
CITY may have under this Agreement or of any cause of action arising from CONSULTANT's
performance. A waiver by CITY of any breach of any term, covenant, or condition contained in
this Agreement will not be deemed to be a waiver of any subsequent breach of the same or any
other term, covenant, or condition contained in this Agreement, whether of the same or different
character.
16. TERMINATION.
A. Except as otherwise provided, CITY may terminate this Agreement at any time
with or without cause.
B. CONSULTANT may terminate this Agreement at any time with CITY's mutual
consent. Notice will be in writing at least thirty (30) days before the effective
termination date.
C. Upon receiving a termination notice, CONSULTANT will immediately cease
performance under this Agreement unless otherwise provided in the termination
notice. Except as otherwise provided in the termination notice, any additional
work performed by CONSULTANT after receiving a termination notice will be
performed at CONSULTANT" own cost; CITY will not be obligated to
compensate CONSULTANT for such work.
D. Should termination occur, all finished or unfinished documents, data, studies,
surveys, drawings, maps, reports and other materials prepared by CONSULTANT
will, at CITY's option, become CITY's property, and CONSULTANT will
receive just and equitable compensation for any work satisfactorily completed up
to the effective date of notice of termination, not to exceed the total costs under
Section 1(C).
in
3842•.:.,4
E. Should the Agreement be terminated pursuant to this Section, CITY may procure
on its own terms services similar to those terminated.
F. By executing this document, CONSULTANT waives any and all claims for
damages that might otherwise arise from CITY's termination under this Section.
17. OWNERSHIP OF DOCUMENTS. All documents, data, studies, drawings, maps, models,
photographs and reports prepared by CONSULTANT under this Agreement are CITY's
property. CONSULTANT may retain copies of said documents and materials as desired, but
will deliver all original materials to CITY upon CITY's written notice. CITY agrees that use of
CONSULTANT's completed work product, for purposes other than identified in this Agreement,
or use of incomplete work product, is at CITY's own risk.
18. PUBLICATION OF DOCUMENTS. Except as necessary for performance of service
under this Agreement, no copies, sketches, or graphs of materials, including graphic art work,
prepared pursuant to this Agreement, will be released by CONSULTANT to any other person or
public CITY without CITY's prior written approval. All press releases, including graphic
display information to be published in newspapers or magazines, will be approved and
distributed solely by CITY, unless otherwise provided by written agreement between the parties.
19. INDEMNIFICATION.
A. CONSULTANT agrees to the following:
i. Indemnification for Professional Services. CONSULTANT will save
harmless and indemnify and at CITY's request reimburse defense
costs for CITY and all its officers, volunteers, employees and
representatives from and against any and all suits, actions, or claims,
of any character whatever, brought for, or on account of, any injuries
or damages sustained by any person or property resulting or arising
from any negligent or wrongful act, error or omission by
CONSULTANT or any of CONSULTANT's officers, agents,
employees, or representatives, in the performance of this Agreement.
ii. Indemnification for other Damages. CONSULTANT indemnifies and
holds CITY harmless from and against any claim, action, damages,
costs (including, without limitation, attorney's fees), injuries, or
liability, arising out of this Agreement, or its performance. Should
CITY be named in any suit, or should any claim be brought against it
by suit or otherwise, whether the same be groundless or not, arising
out of this Agreement, or its performance, CONSULTANT will
defend CITY (at CITY's request and with counsel satisfactory to
CITY) and will indemnify CITY for any judgment rendered against it
or any sums paid out in settlement or otherwise.
-5-
3842•,..
B. For purposes of this section "CITY" includes CITY's officers, officials,
employees, agents, representatives, and certified volunteers.
C. It is expressly understood and agreed that the foregoing provisions will survive
termination of this Agreement.
D. The requirements as to the types and limits of insurance coverage to be
maintained by CONSULTANT as required by Section 23, and any approval of
said insurance by CITY, are not intended to and will not in any manner limit or
qualify the liabilities and obligations otherwise assumed by CONSULTANT
pursuant to this Agreement, including, without limitation, to the provisions
concerning indemnification.
20. ASSIGNABILITY. This Agreement is for CONSULTANT's professional services.
CONSULTANT's attempts to assign the benefits or burdens of this Agreement without CITY's
written approval are prohibited and will be null and void.
21. INDEPENDENT CONTRACTOR. CITY and CONSULTANT agree that
CONSULTANT will act as an independent contractor and will have control of all work and the
manner in which is it performed. CONSULTANT will be free to contract for similar service to
be performed for other employers while under contract with CITY. CONSULTANT is not an
agent or employee of CITY and is not entitled to participate in any pension plan, insurance,
bonus or similar benefits CITY provides for its employees. Any provision in this Agreement that
may appear to give CITY the right to direct CONSULTANT as to the details of doing the work
or to exercise a measure of control over the work means that CONSULTANT will follow the
direction of the CITY as to end results of the work only.
22. AUDIT OF RECORDS. CONSULTANT will maintain full and accurate records with
respect to all services and matters covered under this Agreement. CITY will have free access at
all reasonable times to such records, and the right to examine and audit the same and to make
transcript therefrom, and to inspect all program data, documents, proceedings and activities.
CONSULTANT will retain such financial and program service records for at least three (3) years
after termination or final payment under this Agreement.
23. INSURANCE.
A. Before commencing performance under this Agreement, and at all other times this
Agreement is effective, CONSULTANT will procure and maintain the following
types of insurance with coverage limits complying, at a minimum, with the limits
set forth below:
Type of Insurance Limits
Commercial general liability: $1,000,000
Professional Liability $1,000,000
0
3842.;:;
Business automobile liability $1,000,000
Workers compensation Statutory requirement
B. Commercial general liability insurance will meet or exceed the requirements of
ISO -CGL Form No. CG 00 01 11 85 or 88. The amount of insurance set forth
above will be a combined single limit per occurrence for bodily injury, personal
injury, and property damage for the policy coverage. Liability policies will be
endorsed to name CITY, its officials, and employees as "additional insureds"
under said insurance coverage and to state that such insurance will be deemed
"primary" such that any other insurance that may be carried by CITY will be
excess thereto. Such endorsement must be reflected on ISO Form No. CG 20 10
11 85 or 88, or equivalent. Such insurance will be on an "occurrence," not a
"claims made," basis and will not be cancelable or subject to reduction except
upon thirty (30) days prior written notice to CITY.
C. Professional liability coverage will be on an "occurrence basis" if such coverage
is available, or on a "claims made" basis if not available. When coverage is
provided on a "claims made basis," CONSULTANT will continue to renew the
insurance for a period of three (3) years after this Agreement expires or is
terminated. Such insurance will have the same coverage and limits as the policy
that was in effect during the term of this Agreement, and will cover
CONSULTANT for all claims made by CITY arising out of any errors or
omissions of CONSULTANT, or its officers, employees or agents during the time
this Agreement was in effect.
D. Automobile coverage will be written on ISO Business Auto Coverage Form CA
00 0106 92, including symbol 1 (Any Auto).
E. CONSULTANT will furnish to CITY duly authenticated Certificates of Insurance
evidencing maintenance of the insurance required under this Agreement and such
other evidence of insurance or copies of policies as may be reasonably required
by CITY from time to time. Insurance must be placed with insurers with a current
A.M. Best Company Rating equivalent to at least a Rating of "A:VII."
F. Should CONSULTANT, for any reason, fail to obtain and maintain the insurance
required by this Agreement, CITY may obtain such coverage at
CONSULTANT's expense and deduct the cost of such insurance from payments
due to CONSULTANT under this Agreement or terminate pursuant to Section 16.
24. USE OF SUBCONTRACTORS. CONSULTANT must obtain CITY's prior written
approval to use any consultants while performing any portion of this Agreement. Such approval
must approve of the proposed consultant and the terms of compensation.
-7-
3842.
25. INCIDENTAL TASKS. CONSULTANT will meet with CITY monthly to provide the
status on the project, which will include a schedule update and a short narrative description of
progress during the past month for each major task, a description of the work remaining and a
description of the work to be done before the next schedule update.
26. NOTICES. All communications to either party by the other party will be deemed made
when received by such party at its respective name and address as follows:
If to CONSULTANT: If to CITY:
The Omega Group City of E1 Segundo Police Department
5160 Carroll Canyon Road, First Floor 348 Main Street
San Diego, CA 92121 -1775 El Segundo, CA
Attention: Chris Baldwin, Sales Representative Attention: David Gray, Technical Services
Manager
Any such written communications by mail will be conclusively deemed to have been received by
the addressee upon deposit thereof in the United States Mail, postage prepaid and properly
addressed as noted above. In all other instances, notices will be deemed given at the time of
actual delivery. Changes may be made in the names or addresses of persons to whom notices are
to be given by giving notice in the manner prescribed in this paragraph.
27. CONFLICT OF INTEREST. CONSULTANT will comply with all conflict of interest
laws and regulations including, without limitation, CITY's conflict of interest regulations.
28. SOLICITATION. CONSULTANT maintains and warrants that it has not employed nor
retained any company or person, other than CONSULTANT's bona fide employee, to solicit or
secure this Agreement. Further, CONSULTANT warrants that it has not paid nor has it agreed
to pay any company or person, other than CONSULTANT's bona fide employee, any fee,
commission, percentage, brokerage fee, gift or other consideration contingent upon or resulting
from the award or making of this Agreement. Should CONSULTANT breach or violate this
warranty, CITY may rescind this Agreement without liability.
29. THIRD PARTY BENEFICIARIES. This Agreement and every provision herein is
generally for the exclusive benefit of CONSULTANT and CITY and not for the benefit of any
other party. There will be no incidental or other beneficiaries of any of CONSULTANT's or
CITY's obligations under this Agreement.
30. INTERPRETATION. This Agreement was drafted in, and will be construed in accordance
with the laws of the State of California, and exclusive venue for any action involving this
agreement will be in Los Angeles County.
31. COMPLIANCE WITH LAW. CONSULTANT agrees to comply with all federal, state,
and local laws applicable to this Agreement.
in
3842.,,;
32. ENTIRE AGREEMENT. This Agreement, and its Attachments, sets forth the entire
understanding of the parties. There are no other understandings, terms or other agreements
expressed or implied, oral or written. There are no (0) Attachments to this Agreement. This
Agreement will bind and inure to the benefit of the parties to this Agreement and any subsequent
successors and assigns.
33. RULES OF CONSTRUCTION. Each Party had the opportunity to independently review this
Agreement with legal counsel. Accordingly, this Agreement will be construed simply, as a whole,
and in accordance with its fair meaning; it will not be interpreted strictly for or against either Party.
34. SEVERABILITY. If any portion of this Agreement is declared by a court of competent
jurisdiction to be invalid or unenforceable, then such portion will be deemed modified to the
extent necessary in the opinion of the court to render such portion enforceable and, as so
modified, such portion and the balance of this Agreement will continue in full force and effect.
35. AUTHORITY/MODIFICATION. The Parties represent and warrant that all necessary
action has been taken by the Parties to authorize the undersigned to execute this Agreement and to
engage in the actions described herein. This Agreement may be modified by written amendment.
CITY's executive manager, or designee, may execute any such amendment on behalf of CITY.
36. ACCEPTANCE OF FACSIMILE SIGNATURES. The Parties agree that this Agreement,
agreements ancillary to this Agreement, and related documents to be entered into in connection
with this Agreement will be considered signed when the signature of a party is delivered by
facsimile transmission. Such facsimile signature will be treated in all respects as having the
same effect as an original signature.
37. CAPTIONS. The captions of the paragraphs of this Agreement are for convenience of
reference only and will not affect the interpretation of this Agreement.
38. TIME IS OF ESSENCE. Time is of the essence for each and every provision of this
Agreement.
39. FORCE MAJEURE. Should performance of this Agreement be prevented due to fire, flood,
explosion, acts of terrorism, war, embargo, government action, civil or military authority, the
natural elements, or other similar causes beyond the Parties' reasonable control, then the
Agreement will immediately terminate without obligation of either party to the other.
40. STATEMENT OF EXPERIENCE. By executing this Agreement, CONSULTANT
represents that it has demonstrated trustworthiness and possesses the quality, fitness and capacity
to perform the Agreement in a manner satisfactory to CITY. CONSULTANT represents that its
financial resources, surety and insurance experience, service experience, completion ability,
personnel, current workload, experience in dealing with private consultants, and experience in
dealing with public agencies all suggest that CONSULTANT is capable of performing the
proposed contract and has a demonstrated capacity to deal fairly and effectively with and to
satisfy a public CITY.
[Signatures on next page]
In
3842
IN WITNESS WHEREOF the parties hereto have executed this contract the day and year
first hereinabove written.
ATTEST:
r
- Wv'
Cindy Mort i,
City Clerk
APPROVED ASTI
MARK D. HEN Y,
Attorney
-10-
Taxpayer ID No. �5,6 j
N J O� 6A
March 31, 2008
David Gray
Technical Services Manager
El Segundo Police Department
El Segundo, CA
3642. .
Exhibit A, B and C
The leader in providing innovative GIS sdutions to public safety and education agencies.
5160 Carroll Canyon Road, 1st Floor . San Diego, CA 92121 -1775
Phone: 858.450.2590 • Fax: 858.450.0239
E -mail: mailAtheomeaaaroun com • Web: www.theomagagroun.com
Re: CrimeView Desktop Upgrade (Conversion)
David Gray:
Enclosed are the estimated costs for the Conversion of CrimeView Desktop to ArcGIS
9.x. Application descriptions, along with pricing, requirements and configurations are
included.
The Omega Group was founded in 1992. Our mission is dedicated to enriching the
.quality of life in communities by providing solutions for public safety agencies. The
Omega Group's professional experience includes working with over 350 law
enforcement agencies implementing our CrimeView Enterprise solutions, which focuses
on mapping and analysis applications for crime analysts, officers, command staff and the
community. The Omega Group is an ESRI (Premier) Foundation Partner, recognized by
ESRI for its development of solutions built on ESRI technology.
We offer to our clients:
• Mapping technology and services
• Project management, application building, testing and analysis
• Ongoing education, training and support
After the completion of services and acceptance of our work, we will continue to provide
to the client ongoing software and system maintenance via our Customer Support
Program.
Please do not hesitate to let me know if you have any questions; our office number is
(800) 228 -1059.
Thank you,
C -eta---
Chris Baldwin
Western Division Sales Manager
4U
.1
(�ACRIMEVIE W El Segundo Police Department, The Omega Group, Inc.
California Exhibit A
CrimeView Conversion March 31 2008
Application Description
CrimeView is essential to law enforcement agencies that are committed to Community
Oriented Policing, Problem Solving and CompStat management. CrimeView permits law
enforcement agencies to geographically view and analyze data from their RMS (Records
Management System), CAD (Computer Aided Dispatch) and known- offender data sets.
Users can map, analyze, and report crime incidents by type, proximity, or other search
criteria.
This geographic presentation of the data quickly identifies problem areas and trends
associated with crime data. Rather than spending hours pouring over tables and reports, a
visual representation of the same data is presented on a map, which can be evaluated
quickly and easily. This information helps with officer deployment by quickly
identifying the areas where the officers are needed most. Effectiveness of current law
enforcement efforts can be quickly illustrated by the geographic representation.
Data Flow
Alternative data flows (hardware /network configurations) are available. The diagram
represents the preferred data flow for the implementation of CrimeView.
Data Flow��.
Import Wizard Server will extract datasets
from RMS.CAD and other data Sources,
a
Process data, and output data to a Geo-
database
CrimeView Desktop will query the Spatial
Database. Selection Layers will be returned
to the CrimeView Workstatlon
3
2
C RI M E V I E W El Segundo Police Department, The Omega Group, Inc.
California Exhibit A
CrimeView Conversion March 31 2008
Project Estimate
This is an upgrade that includes services to rebuild your existing application so that it will
work in the ArcGIS 9.x environment. The upgrade is a complete rebuild of the
CrimeView application. Software and Professional Services are included in the
implementation. In order for the client to receive the upgrade price, the client must be
current and active with the customer support program.
The Package total is estimated at $18,995.00. This estimate should not be treated as a
quote. ESRI software versions and quantities need to be confirmed. Only one license of
CrimeView Desktop is assumed.
Credit: ($2,495.021
Client overpaid support costs by $2,495.00. These monies would have provided support
to El Segundo for the term of 5123107 to 5122108. El Segundo Police Department is
applying the overpayment of Support Costs to this quote.
Maintenance: $2,495.00
• One (1) year of Annual Maintenance*
*As of 5/23/07, Client is no longer current under the Omega Support Plan. Client will begin new maintenance plan, and will
commence upon completion of Task 3 (below)
Software: $3,495.00
Omega software includes one (1) year of maintenance.
Omega Software:
• One (1) licensed copies of CrimeView 4.x, upgrade version $495.00
• One (1) licensed copy of The Omega Import Wizard No Cost
ESRI Software:
• One (1) licensed copy of ArcGIS 9.x $1,500.00
• Maintenance paid for one (1) license of ArcView 3.x, plus
extensions, for upgrade to ArcGIS 9.x and Spatial Analyst 9.x $1,500.00
Professional Services (Per Task): $15,500.00
Task 1 Project Planning and Data Collection
• Identify GIS map layers and design preferences
• Identify source tabular data from RMS and CAD
• Collect base map GIS data layers
• Connect to records data source, extract sample datasets and send output profiles to
Omega using Import Wizard
• Collect lookup tables
Task 2 Application Development
• Add GIS layers to map document and create address locators
• Develop and configure data import profiles. Two (2) profiles are included
3
-�► C R 11VI E V I E W El Segundo Police Department, The Omega Group, Inc.
California Exhibit A
CrimeView Conversion March 31, 2008
• Create Saved Queries database and design Crystal Report templates
• Add Omega functionality and other customizations to GIS application
• Test application functionality
• Develop training documents
Task 3 Application Deployment (At Client Site)
• CrimeView Desktop Installation: Up to eight (8) hours on -site. One (1) Omega
personnel.
• Install and configure data import profiles on import machine
• Test import profiles and import historical data
• Schedule automated data import process
• Install and configure OmegaGIS application on user machines
• CrimeView Desktop On -site training: Sixteen (16) hours on -site for two (2)
persons, One (1) Omega personnel.
• Travel for The Omega Group: One (1) staff members to provide installation and
training for one (1) trip
Task 4 Finishing Application Design
• Edit and Customize Import Profiles, Saved Queries, Crystal Report Templates and
Application Style, per user feedback.
• Test Application Functionality
NON - DISCLOSURE
This document has been prepared by the sales division of The Omega Group and is a confidential document that contains ideas,
concepts, methods and other proprietary information. Readers are to treat the information contained herein as confidential and may not
copy or reproduce any of these materials for distribution outside of their organization without the written permission of The Omega
Group. The estimate will remain valid for 3 months from the date on the estimate for Omega Software and Services only.
End of Estimate
Payment Schedule
In consideration of the services to be performed by Omega, Omega shall be entitled to
compensation in the total amount of $189995.00. The payment schedule is as follows:
• Thirty percent
$5,698.50
of the total amount due upon execution of this
(30 %)
Agreement.
• Thirty percent
$5,698.50
Of the total amount due upon delivery CrimeView
(30 %)
Desktop Software
• Thirty percent
$5,698.50
of the total amount due upon completion of
30%
CrimeView® Desktop Deployment
• Ten Percent (10 %)
$1,899.50
of the total amount due thirty (30) days after
completion of services
4
1` U u
0 C R I M E V I E W EI Segundo Police Department, The Omega Group, Inc.
R
California Exhibit A
CrimeView Conversion March 31 2008
Omega Maintenance Plan
Maintenance, Annual (Customer Support): Clients that are not current under support
will pay a maintenance activation fee. Please see the Customer Support Program
Document for details of coverage.
Implementation Timeline
Unless otherwise documented, the completion of all services will take approximately
90 days from date of data collection. Onsite installation and training will be scheduled
only after application development is complete.
Additional Software Licenses (Costs) Full Price / Upgrade Price
CrimeView Licenses (Single Use License) $1,500.00 each/ $495.00 each
Data Specifications
Datasets to be Imported via Omega Import WizardTM
The client operates the West Covina User Group RMS and CAD system. The following
data sets represent tables of data to be extracted by The Omega Import Wizard. A total
of two (2) profiles have been identified for this project.
Data Set Database or Vendor Data Set Database or Vendor
• Calls for Service CAD I • Cases RMS
Please review the Omega Import Wizard Appendix for more details regarding the
Omega Import Wizard and the use of Profiles. Because a significant amount of work
(and cost) can be attributed to the incident or person data being imported, it is important
that Omega Project Management have access to local knowledge regarding the RMS or
CAD data/database as outlined under General Requirements (see next page).
Hardware Specifications
Hardware for the Client Workstations (For CrimeView® Desktop)
The Omega Group recommends the following hardware specifications for a
workstation with a stand -alone crime analysis application working with ArcView and
CrimeView®
Recommended Minimum
Y Intel Core 2 Duo
Pentium 4 (3.20 GHz)
• Memo — 1 -2 GB
Memory 1 GB
• Hard drive — 80GB
Hard Drive — 40 GB
• CD- RW/DVD
0 Video/graphics -256MB
Video /graphics 256 MB
• 1 Gigabit Ethernet
5 � '_J f F
C R.I M E VI E W EI Segundo Police Department, The Omega Group, Inc.
California Exhibit A
CrimeVlew Conversion March 31 2008
Client Project Management
Critical to the success of every implementation is having the appropriate client staff
prepared to be active participants and to understand what is expected from them for the
duration of the implementation. Two critical components to this implementation pertain
to local knowledge of data schema for the RMS /CAD data sources and what data should
be available for mapping and reporting.
Database Schema
The client should expect to provide staff resources who can demonstrate knowledge of
the tabular structure (schema) of the RMS, CAD and other data sources. These persons
will be expected to assist Omega Technicians in building SQL statements that includes
all the fields of data that the client wants for mapping and reporting. This assistance
would primarily be in the form of understanding database structure and table
relationships.
Report Data
The client should expect to provide staff resources who can confirm what data needs to
be included for mapping and reporting. These persons should have direct experience in
working with crime data through current extractions from the RMS, CAD and other data
sources and from the perspective and experience of a crime analyst.
The Omega Group maintains an inventory of data extraction templates (e.g. SQL
Statements) that can be used to as a starting point for the development of a customized
data interface. However, having client staff that can provide local knowledge of the
database can reduce the overall project time, facilitate the ongoing maintenance of the
application and produce a more useful crime mapping and reporting environment.
Project Planning
Remote Connectivity: Secure or confirm remote access via the use of Expert City's
GoToMyPC or the use of a VPN Connection.
® Establishing Remote Connection to the Server(s).
• Data Collection, Installation and Technical Support may be performed
through remote connection, reducing cost of project and time it takes to
complete services
• Omega Recommends ExpertCity's GoToMyPC or VPN for remote
connections
® Provide Network IP Address if VPN is used
® If the client is unable to provide high speed remote access with GoToMyPC or
similar connection software to The Omega Group for the collection of the
required data sets then an additional fee will be charged to the client based on the
additional time required for data collection.
3842•:'.:
0 0 C R I M E III E W El Segundo Police Department, The Omega Group, Inc.
R
California Exhibit A
CrimeView Conversion March 31
2008
System Architecture
Server and Workstation Hardware: The client will provide for hardware to be utilized
in conjunction with CrimeView® Desktop. Hardware should include workstations and a
file server(s) to store GIS data.
• The Omega Group recommends the client to maintain a database of relevant
Geographic Information in a file server for the CrimeView application(s). This
database will be a warehouse of street, boundary and point data, as well as
incident and person data sets from the client data systems.
Data
Geography: The client will provide for the geographic base data for the project. In
addition to the Street Centerline this may include: Parks, Schools, Beats, Reporting
Districts, Landmarks, Stations, Parcels, etc. During the project kick -off a discussion
regarding the type and availability of data will ensue.
• Street Centerline File: The client must provide accurate reference data that will be
used to generate a geocoding service. Typically the reference data is a street
centerline file, address points or a parcel layer.
Application Deployment
Prior to the CrimeView® Desktop Installation: the following items should be
completed by the Network Administrator / GIS Coordinator and Crime Analyst:
• ESRI Training Course • The Crime Analysts/ Onsite Administrators have
completed ESRI's Introduction to ArcView (course) Information may be found at
website: http://training.esri.com/ilt/schedule/index.cfm
o The Omega Group highly recommends all personnel working with
CrimeView to have the Introduction to ArcGIS I and/or Introduction to
ArcGIS II training in addition to CrimeView training. At least one person,
preferably the on -site CrimeView administrator, should have a solid
understanding of ArcGIS (ArcMap and ArcCatalog). The Omega Group
requires that at least the system administrator or primary user receive
ArcGIS training prior to receiving CrimeView training.
• CrimeView® Desktop Training Facility• The client has secured an adequate room
with network and internet access to train individuals on CrimeView® Desktop.
The room will require enough workstations for everyone to be trained, each with a
copy of ESRI's ArcView 9.x and ESRI's Spatial Analyst 9.x installed. The client
will install the ESRI software.
7
4 0 ;J
. C R I M E V I E W E1 Segundo Police Department, The Omega Group, Inc.
California Exhibit A
CrimeView Conversion March 31 2008
Crystal Report Templates
The Omega Group has reviewed four separate report templates provided by the El
Segundo Police Department. The El Segundo Police Department uses Microsoft Excel to
create these reports. These same reports may be developed in Crystal Reports; however
the report design cannot be duplicated.
The report samples are:
• Weekly Activity Report
• Part I Crimes and Arrests Statistics by Reporting District
• Monthly Crime Statistical Report
® Density Crime Map by Frequency
The Omega Group is prepared to re- create the Weekly Activity Report, with limitations,
as part of the project proposed. First limitation, the data supplied in the report sample
must reside in the RMS. Second limitation, the map portion of the report will not be
guaranteed as part of the report creation.
The Part I Crimes Report and the Monthly Crime Statistical Report may be re- created as
a Crystal Report Template for an additional cost. The Omega Group suggests addressing
the development of these reports after the completion of all services associated with this
proposal.
The Sample Reports are attached to this quote.
8
4 .� U