Loading...
HomeMy WebLinkAbout2008-443 1 RESOLUTION NO. 2008-443 2 RESOLUTION OF THE MAYOR AND COMMON COUNCIL OF THE CITY OF SAN BERNARDINO RATIFYING THE SUBMITTAL OF TWO FY 2007-08 COPS 3 TECHNOLOGY GRANT APPLICATIONS AND AUTHORIZING THE POLICE DEPARTMENT TO ADMINISTER THE AWARDED GRANT FUNDS IN ACCORDANCE 4 WITH THE GRANT EXPENDITURE PLANS. 5 BE IT RESOLVED BY THE MAYOR AND COMMON COUNCIL OF THE 6 CITY OF SAN BERNARDINO AS FOLLOWS: 7 SECTION 1. That the submittal of two COPS 2008-2008 Technology Grant 8 applications, Nos. 2008CKWX0266 and 2008CKWX0268, is hereby ratified. 9 SECTION 2. That grant funds, in the amounts of$280,590 and $350,738, totaling 10 $631,328, are hereby accepted. 11 SECTION 3. That expenditure of the grant funds is hereby authorized as set forth in 12 the Grant Expenditure Plans submitted by the Chief of Police, attached hereto as Exhibits "A" and 13 "B" and incorporated herein as though set forth in full herein. 14 //1 15 //1 16 //1 17 //1 18 /1/ 19 /1/ 20 //1 21 /1/ 22 /1/ 23 //1 24 //1 25 /1/ 26 /1/ 27 /1/ 28 //1 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 1 2 3 4 5 6 7 8 9 10 RESOLUTION NO. 2008-443 RESOLUTION OF THE CITY OF SAN BERNARDINO RATIFYING THE SUBMITTAL OF TWO FY 2007-08 COPS TECHNOLOGY GRANT APPLICATIONS AND AUTHORIZING THE POLICE DEPARTMENT TO ADMINISTER THE AWARDED GRANT FUNDS IN ACCORDANCE WITH THE GRANT EXPENDITURE PLANS. I HEREBY CERTIFY that the foregoing Resolution was duly adopted by the Mayor joint and Common Council of the City of San Bernardino at a regular meeting thereof, held on the 1st day of December , 2008, by the following vote, to wit: 11 Council Members Abstain Absent Ayes Nays ESTRADA x BAXTER x BRINKER ~ VACANT KELLEY x JOHNSON x McCAMMACK x ~~~/c~k- The foregoing Resolution is hereby approved this ~ day of December , 2008. ~~~ ~an Bernardino ALorm: .~L/ James F. Penman, City Attorney 2008-443 San Bernardino Police Department COPS Technology Grant FY 2007- 08 Expenditure Plan - Grant-A June 24, 2008 EomPMENTrrECHNOLOGY Automatic License Plate Reader Devices The San Bernardino Police Department is deploying two Automatic License Plate Reader (ALPR) devices to search for stolen and wanted vehicles while the officers drive the two patrol cars equipped with the technology around on their assigned beats. A recent departmental reorganization has set up the Patrol Division in for separate geographic districts. This purchase will equip two additional black-and-white patrol sedans with the ALPR devices which will allow each of the four Patrol Division districts to deploy a patrol car with this technology at the same time. These additional units will also enable the Police Department to use one of the ALPR devices at special enforcement projects while keeping at least three units out on patrol. Automated License Plate Reader Devices (2 @ $32,000.00) Total $64,000.00 Police Facility Digital Surveillance System The San Bernardino Police Department is implementing an enhanced digital building security and jail safety/security surveillance recording system. The fIrst phase of this important security/surveillance system is designed to improve security and safety inside the City Jail. Analog black-and-white CCTV cameras are being replaced with programmable color surveillance cameras that are controlled with software. Cameras will allow jail personnel, watch commanders, and dispatch persounel to view any part of the City Jail facility. This expanded surveillance system is improving the safety of persounel and inmates at the facility. This purchase will expand the system to replace ahnost all of the Police Department's existing analog black-and-white building security cameras. New programmable color surveillance cameras will connect directly to the new digital surveillance system. New surveillance camera equipment will enhance facility security and improve employee/citizen safety at the Front Desk, main lobby, second floor lobby, at both employee entrance gates, at the public Records Bureau counter, at the public TraffIc Bureau counter, at the employee staff entrance door, in the evidence processing room, on the four comers of the station (at the roof level), and at select other locations in and around the facility grounds. EXHIBIT "A" 2008-443 Watch commanders and dispatch personnel monitor these cameras today. Enhanced color surveillance video will help staff visually screen activities in and around the station. Programmable cameras will enable staff to see panning (moving) video without having to manually move cameras. This new automatic panning technology will greatly increase the value of the surveillance system and add to the security of the entire facility. Police Facility Digital Surveillance System (1 @ $136,424.00) Total $136,424.00 CONTRACTS/CONSULTANTS CrimeView Community Crime Mapping Site The San Bernardino Police Department is deploying an internal web based crime mapping tool from The Omega Group, of San Diego, California called "CrimeView Web." This internal web based mapping tool is providing area commanders, district sergeants, and patrol officers with tactical crime based maps in a web based format in near real-time format. Patrol managers, supervisors, and officers can use this visual presentation of crime to better see trends and patterns in a way that allows them to make adjustments to their work as crime changes. The executive staff of the Police Department believes that it is critical to being this same vision of crime to the citizens of our community with the belief that it will help foster growth in the community/police problem solving partnership. This purchase will supply the Police Department with a hosted web based mapping solution that works with the department's existing internal CrimeView mapping application. This hosted web site will provide the public with the same access to crime statistical data that is available within the Police Department. Citizens will be able to browse citywide data, district data, and beat data associated with their neighborhoods with an easy-to-use web interface. The purchase will cover the hosting costs for the entire grant period and includes all software/hardware fees needed to remotely host the site on a secure server away from the Police Department's confident database servers. CrimeView Community Crime Mapping System (1 @ $40,000.00) Total $40,000.00 Alarm Ordinance Software The San Bernardino Police Department automated false alann ordinance billing in 2000 by creating a temporary database in Microsoft Access 1997. This software/database has grown to a point that the simple single-user database can not support the project. The Police Department's historical data for false alann ordinance billing resides in the existing Computer-Aided-Dispatch (CAD) and Records Management Systems (RMS) in a pair of Oracle relational databases. 2008-443 This purchase will update this software suite and move it off the out-of-production Microsoft Access 1997 platform (not supported since 2005). This upgrade will move the application to the existing Oracle database platform and will use the current version of Oracles "Application Writer" to produce software that can be upgraded as we upgrade our existing Oracle licenses. Alann Ordinance Software (1 @40,166.00) Total $40,166.00 2008-443 San Bernardino Police Department COPS Technology Grant FY 2007- 08 Expenditure Plan - Grant-A June 24, 2008 DESCRIPTION AMOUNT CrimeView Community Crime Mapping Site $ 40,000.00 Automatic License Plate Reader Devices (2) $ 64,000.00 $ 40,116.00 Alarm Ordinance Software Police Facility Digital Surveillance System $ 136,424.00 GRANT TOTAL $ 280,590.00 Exhibit "A" 2008-443 San Bernardino Police Department COPS Technology Grant FY 2007- 08 Expenditure Plan - Grant-B June 24, 2008 EOUIPMENT~ECHNOLOGY Police Facility Digital Surveillance System Server The San Bernardino Police Department is deploying a facility wide digital surveillance system. This modem video surveillance system will enhance the security of the central headquarters facility and the City Jail. As a complete system, only about two weeks of data can be stored because of the limited size of the server that the Police Department had available to dedicate to this new tool. Our City Attorney and other legal advisors suggest that the Police Department should maintain at least two years of video data. Civil litigation protection is a key reason for this retention; however, facility security is even more important. Security surveillance data has proven to be critical many homeland security investigations. The central headquarters and City Jail facility is approximately 90,000 square feet in side and the parameter of the facility property encompasses about 5 acres of land. To adequately store video surveillance data, the Police Department will need a larger server and a multi-terabyte networkable storage array. This device will hold video data and allow network access to the video data for the Watch Command manages, our dispatchers (who monitor certain cameras), and our Internal Affairs investigators. Web based application software will isolate data for each camera and provide an interface were authorized users can see a single camera or a group of cameras all at one time. This web based feature will enable authorized users to view video data from an authorized computer within the station. The server will because a centralized site where copies of video data can be burned to DVD drives for court presentation or for other types of review. Server hardware will be either Dell or HP brand specific devices so that long term interoperability will be insured as operating system and hardware upgrades become necessary. This extra planning step will help extend the usefullife of this server and the software platform to maximum our return on this investment. Police Facility Digital Surveillance System Server (1 @$221,000.00) Total $221,000.00 EXHIBIT "B" 2008-443 PUMA Digital Belt Recorders - Phase II Today, the San Bernardino Police Department issues digital belt recorders to all uniformed officers assigned to patrol duties. Officers use these digital recording tools to record contacts with the public and to dictate reports that are later typed by stenographers. These compact recorders fit on an officer's belt and allow them to do dictation in the field without having to return to the station. The recorders have enough memory to record over 10 hours of audio before they are downloaded off onto a server. An additional (90) PUMA recorders are needed equip Police Officers who do not have PUMAs, Reserve Police Officers, Detectives and Sergeants, to enable them to record contacts with the public and dictate their report narratives. PUMA Digital Belt Recorders (90 @ $600.00) Total $54,000.00 Digital Photographic Evidence System and Server The San Bernardino Police Department has deployed a single computer workstation using a software suite designed to manage photographic evidence. Today, this single- user workstation is used to manage investigative photographs taken at fatal traffic collision scenes. The amount of space is limited to the disk on the computer workstation and the system is limited to one user at a time. There are 12 Forensic Technicians in the Police Department's Forensics Unit. These technicians collect evidence and take photographs which are used as evidence at a wide variety of different types of crime scene. Today, photographs are developed and printed at a commercial photography lab. The prints are filed in case folders and used as necessary during investigations and during criminal/civil trials. This purchase will provide a server with adequate storage space to start collecting photographic evidence digitally and will almost completely eliminate the use of printed photographs. The web based application will allow detectives and supervisors to view crime scene photographic evidence from any computer within the station. Investigators will be able use the application software to prepare CDROM disks with photographic evidence for case submissions to the District Attorney's Office. The system application will not allow evidentiary photographs to be altered by any user once the pictures are submitted to the system as evidence. Digital Photographic Evidence System and Server (1 @ $58,987.00) Total $58,987.00 2008-443 OTHER COSTS MDC System Parole-LEADS Firewall The San Bernardino Police Department operates a Mobile Data Computer (MDC) system on a regional 800MHz/EVDO data/communications backbone hosted by the County of San Bernardino and Verizon Wireless. The MDC backbone does not provide Internet service as a regular feature. The San Bernardino Police Department has an activity interagency relationship with the California Department of Corrections (CDC) "State Parole" office. Patrol officers work directly with parole agents and in some cases actual pair-up and patrol together target parolee related crime and parole violations. The California Department of Corrections (CDC) provides a secure website on the public Internet for general parolee information. Our officers find this information so valuable that they often have to leave the scene of an investigation to access this Internet based tool to learn information needed in the field. Because this information is not available through the standard MDC data/communications backbone, the San Bernardino Police Department proposes to provide this access via its internal Internet access connection. To insure efficiency and safeguard equipment, the Police Department wants to provide limited Internet access on the MDC backbone. Limiting access is done with a firewall device. Such a device limits access to website sites and limits users with account/password features. The firewall device will allow restricted access to the CDC Parole-LEADS Internet site without opening the entire public Internet to our MDC fleet. This purchase will supply one Internet firewall device with the necessary hardware to restrict access and control users. MDC System Parole-LEADS Firewall (1 @ $16,751.00) Total $ 16,751.00 2008-443 San Bernardino Police Department COPS Technology Grant FY 2007- 08 Expenditure Plan - Grant-B June 24, 2008 ACCOUNT OBJECT & TITLE Police Facility Digital Surveillance System Server PUMA Digital Belt Recorders - Final Phase MDT System Parole-LEADS Firewall Digital Photographic Evidence System and Server GRANT TOTAL AMOUNT $ 221,000.00 $ 54,000.00 $ 16,751.00 $ 58,987.00 $ 350,738.00 EXHIBIT "B"