HomeMy WebLinkAbout05.O- Police RESOLUTION(ID#2927) DOC ID: 2927 A
CITY OF SAN BERNARDINO—REQUEST FOR COUNCIL ACTION
Purchase Order
From: Jarrod Burguan M/CC Meeting Date: 03/03/2014
Prepared by: Susan Stevens,
Dept: Police Ward(s): All
Subject:
Resolution of the Mayor and Common Council of the City of San Bernardino Authorizing the
Increase of Purchase Order Number 2014-00001390 Issued to Omega Group to an Amount Not
to Exceed $26,230 Utilizing AB109 Grant Funds, Account Number 123-210-0001-5702-0972.
(#2927)
Current Business Registration Certificate: Not Applicable
Financial Impact:
Account Budgeted Amount: $25,000.00
Account No. 123-210-0001-5702-0972
Account Description: AB 109 Grant- Computer Equipment over$5,000
Balance as of: 3/3/2014
Balance after approval of this item: $10,170.00
Please note this balance does not indicate available funding. It does not include non-encumbered
reoccurring expenses or expenses incurred, but not yet processed.
Motion: Adopt the Resolution.
Synopsis of Previous Council Action:
11/17/2008 Resolution 2008-428 adopted approving the purchase and installation of Omega
Group's Crimeview Dashboard I crime mapping system.
6/6/2011 Resolution 2011-126 adopted approving the implementation of the 2nd generation
Omega Dashboard II using 2008 COPS Technology grant funds.
Background:
In September 2008 the San Bernardino Police Department implemented Omega Groups
Dashboard I crime mapping system. In 2011 the Police Department upgraded to the 2nd
generation CrimeView Dashboard system. The CrimeView Dashboard system is a crime
mapping system that allows patrol officers, administrators, and crime analysts to view crime data
on a near real-time basis. The Police Department would like to increase its capabilities by adding
new crime data to the existing CrimeView Dashboard.
I
Using AB 109 grant funding, the Police Department would like to upgrade the CrimeView
Dashboard to increase the data available and provide investigative tools to officers, investigators,
I administrators, and crime analysts to include probationer locations, sex offenders, arrests, and
field interview reports. The one-time cost for this upgrade will be $14,430.00 with an annual
hosting fee of $400.00 for a one time total cost of $14,830.00, as indicated in Exhibit "A"
attached hereto.
1
9
Updated:2/19/2014 by Georgeann"Gigi"Hanna A packet p
I
1
2927
The Police Department currently has a Purchase Order issued to Omega Group in the amount of
$11,400 which is the annual maintenance and hosting fees for the existing CrimeView
Dashboard. The upgrade purchase will increase the Omega Group Purchase Order for FY
2013/2014 to $26,230.00, requiring Council approval. The Police Department is requesting
Omega Group for this purchase as a select source vendor for several reasons.
• Currently running on PD systems, CrimeView Web, CrimeView Desktop, and
CrimeView Community.
• This is proprietary software that cannot be upgraded by another vendor.
• Processes are in place for exporting crime data from the Police Department's
Records Management and Dispatch systems. Changing vendors would mean
additional costs and time delays in implementation.
Sufficient funds have been budgeted in the AB 109 grant budget for FY2013/2014, account
number 123-210-0001-5702-0972. The available unspent balance in this account is $25,000.
City Attorney Review:
Supporting Documents:
reso 2927 (PDF)
OmegaGroup Exhibit A (PDF)
Quote Validation Letter- Exhibit A (PDF)
I�
Updated: 2/19/2014 by Georgeann"Gigi"Hanna A Packef Pg 24fi `
MIN
1 RESOLUTION NO.
2 RESOLUTION OF THE MAYOR AND COMMON COUNCIL OF THE CITY OF SAID
3 BERNARDINO AUTHORIZING THE INCREASE OF PURCHASE ORDER NUMBEF
2014-00001390 ISSUED TO OMEGA GROUP TO AN AMOUNT NOT TO EXCEEf
4 $26,230 UTILIZING AB109 GRANT FUNDS, ACCOUNT NUMBER 123-210-0001-5702•
0972.
5
6
NOW THEREFORE,BE IT RESOLVED BY THE MAYOR AND COMMON COUNCIL o
OF THE CITY OF SAN BERNARDINO AS FOLLOWS: N
7 N
SECTION 1. That the Director of Administrative Services is hereby authorized and
0
8 a
directed to increase Purchase Order number 2014-00001390 to Omega Group to $26,230 0
9
utilizing account number 123-210-0001-5702-0972. Pursuant to San Bernardino Municipal d
10 E
Code 3.04.101(b)(3),the Mayor and Common Council approve a selected source justification for o
1 l ...
this purchase.
12 0
a�
N
13 =
14
a
m
15 0-
16
ti
N
17
18 /// CD
N
O
19
20 E
s
21
22
23
24
25
1
Packet Pg.247
I RESOLUTION OF THE MAYOR AND COMMON COUNCIL OF THE CITY OF SAI`
BERNARDINO AUTHORIZING THE INCREASE OF PURCHASE ORDER NUMBED
2 2014-00001390 ISSUED TO OMEGA GROUP TO AN AMOUNT NOT TO EXCEEr
3 $26,230 UTILIZING ABI09 GRANT FUNDS, ACCOUNT NUMBER 123-210-0001-5702
0972.
4
5 I HEREBY CERTIFY that the foregoing Resolution was duly adopted by the Mayor and
6
Common Council of the City of San Bernardino at a meeting thereof,
c
M
7 held on the day of ,2014, by the following vote, to wit: N
8 COUNCILMEMBERS: AYES NAYS ABSTAIN ABSENT 2
9 MARQUEZ P
l� BARRIOS
E
VALDIVIA o
1l
SHORETT
12 NICKEL oL
a�
13 JOHNSON s
MULVIHILL
14 a.
j 15 m
L
V
16 Georgeann Hanna, City Clerk
ti
N
17 The foregoing Resolution is hereby approved this of 2014.
N
18 M
R. Carey Davis,Mayor o
19 City of San Bernardino
Approved as to form:
20 a=i
Gary D. Saenz,
21 City Attorney w
� a
22 By:
23
24
25
2
Pack6t Pg 248
5.O.b
THE OMEGA GROUP An Omega Proposal
Exhibit A:
Quote for Profile Configuration for CrimeView
April 23,2013 0
M
N
to
To:Matthew Good,IT Analyst
Organization:San Bernardino Police Department o
Phone:909-388-4939 a
0
From:Chris Baldwin
Phone:(858)450-2590 x115
a�
Email:chris @theomegagroup.com °'
E
O
0
L
L
O
d
fL
tv
L
O.
f
c
W
o
E
' T C
_ s
v
r
Q
5164 Carroll Canyon Road I Suite 100 1
Y San Diego,CA 92121 71856.450,2590 F1858.450.0239 E 1ome9a0theomegagroup.ca
Packet Pg 249
5.O.b
THE OMEGA GROUP April 23,2013
Exhibit A
ti
Services/License Type Hrs./Qty. Cost Hosting Fee
• Project Coordination and Data Collection
• New Import Wizard profile development 72 $13,320.00 $400.00
o Probation
o Field Interviews
o Arrestees c
o Sex Registrants N
• Service(for Import Wizard): co
• Profile setup
• Configure SQL Statements °
• Run historical import 3
• Configure geocoding P
• Collect lookup tables
• Configure automation (D
• Service(for CrimeView Dashboard): E
O
• Build Saved Queries o
• Configure fields for reports and charting
• Configure symbology -a
• QA/QC changes O
• Deploy to live application
• Service(for CrimeView Desktop):
• ArcMap Setup
• Configure Crystal Report templates a-
m
o Configure Saved Queries N
o Configure Symbology
• Current Import Wizard profile development 6 $1,110.00 C
o CAD(Modification of pre-existing profile to ti
add response data)
N
• Service(for Import Wizard):
o Profile setup Q
o Re-configure SQL statements
o Re-run historical import x
o Collect lookup tables W
CL
• Service(for CrimeView Dashboard): :3
o Build Saved Queries 0 tP
o Configure fields for reports and charting
rn
Total $14,430.00 $400.00 E
Tax - O
Grand total $14,430.00 $400.00
Estimated Delivery date 3rd Qtr, E
2013 U
Note:
Q
• Annual Subscription fees for CrimeView Dashboard will increase by$400.00,and
will be added to the next term due date (6/13/2013)
• Sample Schema's for Probationers,Sex Registrants,Arrestees and Field
Interviews attached:
FPacket Pg. 250
THE OMEGA GROUP April 23,2013
Exhibit A
Probation
DISPLAY NAME FIELD NAME CATEGORIES
1 AGENCY AGENCY YES. YES YES YES
2 PERSON ID PERSON—ID YES
3 PERSON NAME FULL NAME YES
4 ALIAS ALIAS YES
STATUTE OR C14
5 CHARGE CHARGE_DESC YES
6 PROB STATUS PROB STATUS YES YES YES YES
7 PROB BEGIN DATE. PROB BEGIN_DATE YES 0�
8 PROB END DATE PROB—END—DATE YES
9 HOME ADDRESS CV ADDRESS YES
10 APT APT YES 0
0
11 AREA 1* YES YES YES L
12 AREA 2* YES YES YES
13 AREA 3* - YES YES: YES 0
m
14 AREA 4* YES YES YES
ca
15 SEX . SEX YES YES YES: YES L
16 RACE RACE_DESC YES YES YES YES a.
I 17 ETHNICITY ETHNICITY YES YES YES YES N
18 AGE AGE YES YES YES YES m
19 DOB DOB YES c
20 HEIGHT HEIGHT YES
21 WEIGHT WEIGHT YES. rn
22 EYES EYES YES
23 HAIR HAIR YES Q
w.
SCARS MARKS
24 TATS SMT YES x
w
25 DRIVERS LICENSE LICENSE YES C.
26 PRIMARY OFFICER OFFICER yEg o
L
27 MUG SHOT MUG_SHOT YES c�a
28 PRIMARY KEY PRIMARY—KEY YES
STATUTE OR O
CHARGE—CODE CHARGE_CODE _.
*Each Area field may include one of the following: Beat, District, Precinct, Sector, City, Zip E
Code,etc.
Y
Q
124 et F'g•251
n THE OMEGA GROUP April 23,2013
Exhibit A
Sex Registrants
REPORT
•••
DISPLAY NAME I FIELD NAME QUERY CATEGORIES • •
1 AGENCY AGENCY YES YES YES YES
2 PERSON ID PERSON ID YES
3 PERSON NAME FULL NAME YES
CO)
4 ALIAS NAME ALIAS YES c1t
.STATUTE OR
5 - CHARGE CHARGE_DESC YES YES YES YES o
6 RISK LEVEL RISK LEVEL YES YES YES YES Q-
7 REGISTR DATE REG_DATE YES o
7
8 HOME LOCATION CV ADDRESS YES CD
9 APT APT YES d
10 AREA 1* YES YES YES O
.11 AREA 2* YES YES YES r
12 AREA 3* YES YES YES
1.3 AREA 4* YES YES.. YES O
14 SEX SEX YES YES YES YES W
ca
15 RACE RACE_DESC YES YES. YES YES
16 ETHNICITY ETHNICITY YES YES YES YES a
17 AGE AGE YES YES . YES YES N
18 DOB DOB YES 1°
L
19 HEIGHT HEIGHT YES
20 WEIGHT WEIGHT YES
.21 -.HAIR HAIR YES rn
22 EYES EYES YES
SCARS MARKS'Q
. 23 TATS SMT 'YES Z
24 DRIVERS LICENSE LICENSE YES X
25 CASE NUMBER CASE—NUM YES w
CL
U
26 CONVIC DATE CONV_DATE YES o
.-27 COMMENTS COMMENTS YES
28 MUG SHOT MUG—SHOT YES m
29 PRIMARY KEY PRIMARY KEY YES E
p
*Each Area field may include one of the following: Beat, District, Precinct, Sector, City, Zip
Code,etc. 0)
E
.r
Q
Packet Pg.262
THE OMEGA GROUP April 23,2013
� Exhibit A
Arrests(Home Location)
DISPLAY NAME MCJIHD�ffol CATEGORIES
1 AGENCY AGENCY YES. YES YES YES
2 ARREST NUMBER ARREST—NUM YES
3 CASE NUMBER. CASE_NUM YES
4 PERSON NAME FULL NAME YES to
5 ALIAS.NAME ALIAS YES
0
STATUTE OR Q
6 CHARGE CHARGE_DESC YES YES YES YES o
7 NIBRS OR UCR CRIME DESC YES YES. .. YES
YES. t9
8 ARR DATE ARR DATE YES a�
d
9 HOME LOCATION HOME-ADDRESS YES E
10 APT APT YES o
.r
11 AREA 1* YES YES YES y
12 AREA 2* YES YES YES
O
13. AREA 3* YES YES YES y
14 AREA 4* YES YES YES t
15 'ARR TYPE ARR TYPE DESC YES YES YES YES 3
16 SEX SEX YES YES YES YES n.
17 RACE . RACE_DESC YES YES. YES YES m
18 ETHNICITY ETHNICITY YES YES YES YES
19 AGE AGE YES YES' . YES. YES
20 DOB DOB YES N
21 HEIGHT HEIGHT YES N
22 WEIGHT WEIGHT YES Q
23 HAIR HAIR YES
24 EYES EYES YES x
w
SCARS MARKS a
25 TATS SMT YES o
26 DRIVERS LICENSE LICENSE YES O
R
.27 ARR LOCATION ARR ADDRESS YES °1
m
28 PRIM ARR OFFICER OFFICER YES E
O
29. MUG SHOT MUG—SHOT YES
30 PRIMARY KEY PRIMARY KEY YES E
*Each Area field may include one of the following. Beat, District, Precinct, Sector, City, Zip
Code,etc. ;a
0 Q
Packet Pg.253.,
5.O.b
THE OMEGR GROUP April 23,2013
Exhibit A
Field Interviews
I DISPLAY NAME CATEGORIES
1. AGENCY .:AGENCY YES YES YES YES
2 FI NUMBER FI—NUM YES
3 REASON REASON_DESC YES YES YES' YES M
4 PERSON NAME FULL—NAME YES m
5 ALIAS NAME ALIAS YES : . 04
6 FI DATE FI DATE YES 0
_ .r
7 FI ADDRESS CV_ADD.RESS YES
0
8 APT APT YES
9 AREA 1* YES YES. YES
10 AREA 2* YES YES YES
11 AREA 3* YES YES YES O
0
12 AREA 4* YES YES YES L
13 SEX SEX YES YES YES: YES ('aL
14 RACE RACE DESC YES YES YES YES O
m
15 . ETHNICITY ETHNICITY: YES YES. . YES YES U)
16 AGE AGE YES YES YES YES
17 DOB DOB YES. a
18 HEIGHT HEIGHT YES H
19 WEIGHT WEIGHT YES m
20 EYES EYES YES c
21 HAIR 'HAIR YES r,
SCARS MARKS rn
22 TATS SMT YES
23 DRIVERS LICENSE LICENSE YES a
24 GANG NAME GANG—NAME YES YES YES
25 CASE NUMBER YES x
w
26 PRIMARY OFFICER OFFICER YES a
3
27. COMMENTS •COMMENTS YES 0
28 PRIMARY KEY PRIMARY KEY . YES cOa
*Each Area field may include one of the following: Beat, District, Precinct, Sector, City, Zip m
Code,etc. E
O
c
(D
E
t
U
Q
Packet Pg.254
EXHIBIT "A"
THE OMEGA GROUP
www.theomegagroup.com
February 18, 2014
0
M
N
W
N
Matthew Good o
IT Analyst
San Bernardino Police Department °
710 North D Street
a�
San Bernardino, CA. 92401
O
0
r
L
Re: Quote for Profile Configuration for CrimeView, dated April 23, 2013
L
O
Mr. Matthew Good. 2
L
0
CL
The Omega Group will recognize the Quote for Profile Configuration for CrimeView, y
dated April 23, 2013 as valid through May 1st, 2014. After which time the quote will be
considered null and void. _
ti
If you have any questions regarding this letter or the quote, please contact us at (858) 450-2590. N
a
Thank you,
x
LU
L
d
Chris Baldwin
Regional Sales o
w
0
CY
c
m
E
s
°
r
a
5160 Carroll Canyon Road I Suite 100 1 San Diego, CA 92121 T 1858.450.2594 F 1858.450.0239 E lomega @the Packet Pg. 255