The URL can be used to link to this page

Home My WebLink AboutAgenda Report - August 20, 2008 E-07AGENDA ITEM EAW7 (0 CITY OF LODI COUNCIL COMMUNICATION TM AGENDA TITLE: Adopt Resolution Authorizing the Purchaseand Installationof a New Public Safety Solution System from OSSI Sungard, which will Replace the Lodi Police Department's DATA 911 System, and Authorizing Expenditure of $250,998 in Police Department Budgeted Funds MEETING DATE: PREPARED BY August, 20,2008 Chief of Police RECOMMENDED ACTION: Adopt resolution authorizing the purchase and installation of a new public safety solution system from Sungard OSSI, which will replace Lodi Police Department's DATA 911 system, and authorizing expenditure of $250,998 in Police Department budgeted funds. BACKGROUND INFORMATION: Since 1997 The Lodi Police Department has utilized public safety solution system provided by DATA 911. This system includes our ComputerAided Dispatch (CAD), Records Management, Field Reporting and Mobile Computing. During this time period technology has vastly improved, however DATA 911 has failed to remain current and can no longer meet the needs of our organization. Despite paying a significant amount of money to DATA 911 for an extended service agreement on a yearly basis (intended to provide regular updates and improvements), we have not received software updates from DATA 911 in five years. Our current system has failed to keep up with the times. We are unable to extract meaningful crime analysis information. Using the system's data to prepare reports on significant issues such as response times, problematiccall locations, patterns, and employee productivity is labor intensive and often inaccurate. The system currently does not have a fire dispatch component, mapping, or GIS integration with CAD. The system lacks web integration for online reporting and citizen information sharing. During the past several years, the department has examined a number of alternatives, most of which we discovered were either cost prohibitive or did not meet our specific organizational needs. A committee consisting of potential users researched and examined a software system by Sungard OSSI. Sungard OSSI meets our needs in a number of areas such as computer aided dispatching (CAD), records management, field reporting and mobile reporting, but also provides a number of other capabilities that will enhance our ability to provide better service to our citizens. These options include fully integrated police and fire dispatching and reporting, integrated mapping, sophisticated link analysis, voice activated Mobile Data Computer responses, accident sketch wizards, integrated online reporting, Web -based, police -to -citizen data sharing, complete jail management software, management report options, bar coding for evidence/property tracking, sex offender, gang member and probation/parole tracking, and animal control management. The company provided an onsite full demonstration to a large number of our users. The user group unanimously endorsed this system, finding it to be sophisticated, userfriendly, and highly efficient. APPROVED: 11" ' 1 City Manager Adopt Resolution Authorizing the Purchase and Installation of a New Public Safety Solution System from OSSI Sungard, which will Replace the Lodi Police Department's DATA 911 System, and Appropriating Funds ($250,998) August 20, 2008 Page Two Sungard OSSI is used by 350 agencies nationwideand is part of a worldwide company that has $5 billion in annual revenue; however, it is not yet present in California. They are offering a 90% discount on softwarefor any agency that is "first in state." The system would cost approximately $1.2 million if purchased without any discounts. Sungard OSSI has provided the Lodi Police Department with a quote of $250,997.21. FISCAL IMPACT: No additional funding will be necessaryfrom the General Fund. The police department has been able to locatefunding sources to absorbthe cost within the current 2008-09 fiscal year, which are detailed below. FUNDING AVAILABLE: Police Operating Budget; Approved 2008-09 $83,500 Acct. # 101031.7335 Flag City Non -Departmental (1 -time fund) $45,430 Acct. # 100241 California Law Enforcement Equipment Program $12,111 Acct. # 1211370 Inmate Welfare Trust $10,350 Acct. # 1410.2357.9 • Webcam Fund $ 6,000 Acct. # 100241 Congressional Public Safety Grant $93,950 Acct. # 2341202 s c s, Budge# Manager David'J. Main Chief of Police DJM:JPB Cc: city Attomey RESOLUTION NO. 2008-169 A RESOLUTION OF THE LODI CITY COUNCIL AUTHORIZING THE PURCHASEAND INSTALLATION OFA NEW PUBLIC SAFETY SOLUTION SYSTEM FROM OSSI SUNGARD, REPLACING THE DATA 911 SYSTEM, AND AUTHORIZING EXPENDITUREOF FUNDS WHEREAS, the Lodi Police Department has utilized a public safety solution system provided by DATA 911 since 1997, which included Computer Aided Dispatch (CAD), Records Management, Field Reporting, and Mobile Computing; and WHEREAS, during this time period technology has vastly improved; however, DATA 911 has failed to remain current and can no longer meet the needs of our organization, despite receiving a significant amount of money for an extended service agreement on a yearly basis yet not providing software updates in five years; and WHEREAS, a committee of potential users researched and examined a software system by Sungard OSSI, and the group unanimously endorsed the system, which will meet Lodi Police Department's needs in a number of areas and also provides a number of other capabilities that will enhance the ability to provide better service to the citizens; and WHEREAS, staff therefore recommends purchasing and installing this new Public Safety Solution system; and WHEREAS, Lodi Municipal Code Section 3.20.070 authorizes dispensing with bids for purchases of supplies, services, or equipment when it is in the best interest of the City to do so. NOW, THEREFORE, BE IT RESOLVED that the Lodi City Council does hereby authorize the purchase and installation of a new Public Safety Solution system from OSSI Sungard in the amount of $250,997.21; and BE IT FURTHER RESOLVED that the City Council does hereby authorize expenditure of funds in the amount of $250,997.21 from Police Department budgeted funds. Dated: August 20, 2008 hereby certify that Resolution No. 2008-169 was passed and adopted by the City Council of the City of Lodi in a regular meeting held August 20, 2008, by the following vote: AYES: COUNCIL MEMBERS — Hansen, Hitchcock, Johnson, Katzakian, and Mayor Mounce NOES: COUNCIL MEMBERS—None ABSENT: COUNCIL MEMBERS— None �1 ABSTAIN: COUNCIL MEMBERS— N e ND1 JOHL City Clerk 2008-169 ► 1 1 year business relationship ► CAD; RMS; RX; MX ► Hardware has held up well ► Has not kept up with technological trends ► Customer Service has been poor ► ESA was not cost effective ► No Software updates in 5 years • Incapable of producing crime analysis information • Not designed to dispatch or integrate with fire related equipment • No integration for inputting photos into RMS • Difficult to extract meaningful data ► Any update to the server is labor intensive ► No web integration of online reporting ► No web integration for citizen information sharing ► No jail management software ► Redundant data entry ► Simple data queries can be cumbersome ► No integration for Evidence/Property tracking ► No integration for mapping or GIS ► Subsidiary of Sungard ► Main focus is local government business ► Has a Public Administration Software ► Fully integrated system that requires no duplication of work ► Installed in over 375 agencies nationwide and Europe ► Annual revenues over $5 Billion ► Feature rich and user friendly ► Responses to data queries all on one screen. ® RED Q EiDU P ' i L-1 FIF-hla� lo[ -- - Y j Ome+ rb"rftd AkmdWped (ohe n w OMNIII ]aGa4:eAC VQW mw req' G;%NLE*5A Aft Pt4W�i4$ Z®�' } 20fR9m MUM WaaLES AaQUVATEDAE&AMTkWC._ — eouac++r, Rorwa f WOLN- es VAM-9mgm =.L%% LdMf AVP7S f3b1_LTA PI% * YeikhY//i rr�MM �kr4eM uilhF ulhai Flt//7_rIieh � } — Case e'NImCIdD1� ,sddjo .ICaexlltP Rsr h mmrdimsmd844phH mb Nreeh F-c Win Ci5•N4Rriir ,4D -kcad4_ As a.+.. O�}ir Rp"nra hhsvh17, 2aC+F� ?.mxigl i;u,A 4fS4 ra{�hLQ�F"AE6 #' Dw! 4}45" l Ejnie PTPPIad 121 Otre i CmwW SFaw Drlr 09h9iB �IY4 Fpvft-GCrtrr. am.,mimA i wdsxpl4r+tnlrm. a7nrilMPOI}M L44ih{h 11LNN1'F: I $05.51eIN rAfll�• �m S 15NL64G3Nr1,R, Fr.l 4•�ns-.s°;!+,I 4ea�+z]C$$rJ�c$ j .PIYYQe�.rraS s � ,.fail .��re�B+n��;n +n.9P4LL. n4Ier+ wh rn+nFa 6t oI-huorr,Gr ri7 w 4A &Cxi 8 KE r4 WAMNPWOlR 2310- F IM K REI •e: ALSEWOLE. FRIG 29WO-5 jrral�+�eda4.'sn e . 3363�.# 21 ag Y5 tea'= Eli[_�I�to-rn'v wim I 12M11 0 0 '-�-* V r* r ak A y4 64 9 W ► Integrated mapping 7: 0551 CAI) Map. -fPG - Windows Picture 3nd I dx Yi--Vmr EtlL Jps3b h4,}Jo� Y�Ydx. n�r� 'Jeplay I4bYar ILcc {neck C-- 1 -e51 ��F HelarYi `-'#i .I B}LSsi==aD-- SY I: Ct _,1 ex„a «� Enm xilw 1 Sd2+ Q f n e rX ,n 64 Pf s ► Drag & Drop CAD call taking/dispatching. Exi M -122 E 296 45 111735 WILLOW OAR RD 0®: ep +601 R 898 56 97941 MERCEDES RD 13090 mum 11-M54 W W M 'j' 9 /1 i', -Il 1t- x t;, W" 0 Refs I 397 EMS Fire Law Resc Other FPI* Src E911 v PV Callrlointation RelatedNames(1) Related Vehicles 7cl HotSpot Ha3Mat Emmme Call Hist W2ats Alerts Attachmnt FlreLOt 31381 MERCEDES RD NEW mvc Osups SCC LAW SC5O dwo *rm L Spa 0577 501 �. � EPW R. Log� Er. Log Bush Nal4re ( ) - 501 Laid Priority . 3.. CA T. S PF[ " fSHP7C Callgr LAMBERT. MiC FW£L mAHlst _ _ . Add PinkSHfs3• Note Addr 37391 MERCEDES RFNEVV Phi (885) 445-0199 %Yarm 1_�i�tlT iB9' i5SOii Dela y Held LIsCk Veh �k'j 5 .� .wow,�1��- .� V4 Wotan Cmd ]F5] Finished �,ancel Print < M -122 E 296 45 111735 WILLOW OAR RD 0®: ep +601 R 898 56 97941 MERCEDES RD 13090 mum 11-M54 W W M 'j' 9 /1 i', -Il 1t- x t;, W" 0 ► Sophisticated Link Analysis for investigations research. OSS I L! nk Diagramm! ng- JPG W! n d� Pict u re a n d Fax Vl� r QCMIX) Fie EeR Modules Report TOK4F W,..d, Help PuwchL j EJ6 LO& NN— E:!P----t 2hap- o W CA X [ul all 1- R- Fm -um F-- 7 a2—al 7 W 0 1 3KZ 4m. VI ; -D I -1k, dr- I X � W off I @V Voice activated MDC responses. User Friendly Accident Sketch Wizard. 7:— 77— [.7.7— _ I I . . : - - - A - -3 :J. 4 iK Merl Rerr,---ed F-16'2000 12;WN J, -:'AJ UP Luff—Mlk—b -45 14ATrr.HEPJ!-.3J!. YJ:Y:X Wr,?TgklnAL-.VR KVqTir ZA.-A I F Lw �J. sarrmm: M r d'PRI-7; blauj i .NT I yl -13 T MdoWtiodr U:1 1 1.�(5 li.--14LLi 'I "L, KxLe . 30 14— 3.1— 11.. ij E—i k3i% 311 �"j A A-TIYL L11 n3 rL im Ryd 4jLe,7 rm W. I I I." JK :%...1 -4.. Fn SJ. r. 1-1ki'I.A! C:-jt.,j, 14: & -f -Z 7 �wrl`. Mxlu- r.1": lHr�.Ty IIT'r III. III in�.i I NIVEf 3 VC -IH- 4 Afticle 6 Boat 4 IL PI K-1 4 4 1 =-I RiMiPi%WwAhRWiNalsM.JPG-Rln&mPUwrempWfnolVWw EULCJ®ISVWX [ZWM -W1r&aPkimmnFFwThmr FRE —brcaMlan Pallwt0Mit-firdd4d br I-ilI." rrr~rM Ic pul -fta Ilrwpw4r14Nrhwit PK-4171Ml." Igwwrl&p*.r F7fvwr ,. _ ■Arun — Dun lift 7a xMrr # carr .bw ?cwK sadM \ar. Dln k,Wh raW' 440.4wd— Lad7`� _ �ow«Wu � ctta ,wr¢r+r+n % IE7 hm)MFrtW- �imrwE�.ro, ® r 9oo~+w RMEW. ■ M 009 fiQ-0cs4wo•+x+l . ► Sophisticated Crime Analysis ► Complete Jail Management ► Quality Management reports ► Complete Fire Dispatching integration ► Integrates with Telestaff for scheduling software ► Integrated mapping/AVL/mug shots ► Bar coding for evidence/ property tracking ► Sex Offender tracking ► Gang member tracking ► Probation & Parole tracking ► Problem Oriented Policing tracking ► Crimestoppers Management ► Animal Control Management ► Eliminates redundancy ► Eliminates need for multiple systems ► Crime analysis will allow officers to concentrate on directed patrol and enforcement ► Meaningful management reports will allow for better resource allocation • Sophisticated, yet user friendly, gives officers the ability to provide better service • Mobile office for officers • Access mug shots in the field • Premise history and dangerous person alerts for officer safety ► $1,245,962 ► OSSI has offered significant discount to the first law enforcement agency in California • 90% discount on Software • 50% discount on Services • Time is critical as other agencies are looking at OSSI r OSSI Cost with Discounts =5251,41 7 � Savings of $994,545 ► No addition funds are required from General Fund ► Currently available • $83,576 =Police Operating Budget; Approved 08/09 • $45,430 =Flag City Non Departmental (1 -time fund) • $12,1 1 1 =Calif Law Enforcement Equipment Program • $10,350 =Inmate Welfare Trust • $6,000 = Webcam Fund ► Available in Fall/Winter • $93530 = REP McNerny Public Safety Grant Funds Due ► $157,467 is due upon contract execution ► $93,530 is due December 31, 2008 ► System will be paid in full Focus on repeat offenders Be more proactive in field Allow us to extract meaningful crime analysis data Be more efficient with employee's time Brings us up to date with current technological trends in law enforcement Improve service to our customers