Budget & Performance Subcommittee March 25, 2016 1 Dr. Carlton B. Goodlett Place, City Hall, Room 305 San Francisco, CA 94102 1
AGENDA 1. Call to Order by Chair 2. Roll Call 3. Approval of Minutes 4. Discussion: FY 2016-17 and FY 2017-18 General Fund Budget Projects 5. FY 2016-17 & FY 2017-18 Budget Presentations 6. Public Comment 7. Adjournment 2
3. Approval of Minutes Action Item 3
4. FY 2016-17 and FY 2017-18 General Fund Budget Projects 4
5. FY 2016-17 & FY 2017-18 Budget Presentations 5
Fire Department 6
MDC Replacement San Francisco Fire Department Project Objective The San Francisco Fire Department Mobile Data Computer (MDC) equipment in the fire apparatus is outdated and no longer being supported by the manufacturer. The new replacement MDC will provide a reliable system that is scalable and can be easily upgraded as newer technology becomes available. Major Stakeholders Name Position Internal / Project Role Contact Information External William Storti Battalion Internal Sponsor bill.storti@sfgov.org Chief Hector Aguilar Project Internal Project Leader hector.aguilar@sfgov.org Director 7
MDC Replacement San Francisco Fire Department Problem Trying to Solve • Mobile Data Computers have reached their end-of-life • Spare equipment is limited • Existing MDC does not support latest version of the Computer Aided Dispatch (CAD) software • Current versions of other mobility applications are also not supported. 8
MDC Replacement San Francisco Fire Department Project Implementation Stages/Phases Phase 1 Phase 2 Phase 3 Phase 4 Dates: 06/22/2015 – 11/30/2015 – 11/15/2015 – 05/09/2016 – 11/15/2015 12/28/2015 02/15/2016 05/31/2017 Description: Evaluation of Procurement of Mobile Data Deployment Mobile Data Mobile Data Computer field Computer Computers test pilot alternatives 9
MDC Replacement San Francisco Fire Department MDC Models Evaluated 10
MDC Replacement San Francisco Fire Department FY 16-17 FY 17-18 Project Budget - - Number of FTE - - FTE Classifications - - Salary & Fringe - - Software $246,912 - Hardware $118,753 - Professional Services - - Materials & Supplies $365,665 - Total Project Cost 11
MDC Replacement Project Start: San Francisco Fire Department Project End: Total Project Total COIT Total Other GF Total NGF Total NGF + GF Total Spent Cost Funding To Date Funding Funding Funding $1,165,665 $800,000 - - $800,000 $586,812 Status Comment This project replaces the outdated mobile data terminals (MDTs) on all Fire Department emergency vehicles with up-to-date mobile data computers (MDCs) Scope 39% Complete. Estimated completion by May of 2017 Schedule MDC equipment more costly than anticipated. Existing vehicle mounts will need to be replaced. DT labor cost increased due to complexity of installation. Budget Potential equipment installation delays due to limited Radio Shop staff. Risks 12
Vehicle Modem Upgrade San Francisco Fire Department Project Objective San Francisco Fire Department has purchased the Sierra Wireless solution to provide real-time data communications for the fleet. The primary purpose of this solution is to provide reliable cellular communications in the vehicle network, and failover through the Motorola HPD network. Major Stakeholders Name Position Internal / Project Role Contact Information External William Storti Battalion Internal Sponsor bill.storti@sfgov.org Chief Hector Aguilar Project Internal Project Leader hector.aguilar@sfgov.org Director 13
Vehicle Modem Upgrade San Francisco Fire Department Problem Trying to Solve • Current private radio network (HPD) offers limited performance. • Commercial LTE broadband cellular networks are not available with the current equipment. • Although the HPD network is highly reliable, it is a single point of failure of the current implementation. • SFFD will use the Sierra Wireless Mobile Gateway (oMG). oMG will provide uninterrupted data connectivity between commercial cellular LTE, the legacy City-owned wireless data network and (eventually) a secure CCSF Wi-Fi network. 14
Vehicle Modem Upgrade San Francisco Fire Department Project Implementation Stages/Phases Phase 1 Phase 2 Phase 3 Phase 4 Dates: 11/01/2014 – 04/30/2015 – 04/25/2016 – 05/09/2016 – 04/30/2015 07/01/2015 05/06/2016 05/31/2017 Description: Evaluation of Procurement of Sierra Wireless Deployment wireless Sierra Wireless configuration equipment equipment and test pilot alternatives 15
Vehicle Modem Upgrade San Francisco Fire Department 16
Vehicle Modem Upgrade San Francisco Fire Department Project Budget FY 16-17 FY 17-18 1 - Number of FTE 1070 - FTE Classifications $137,053 - Salary & Fringe - - Software $183,075 - Hardware $124,200 - Professional Services - - Materials & Supplies $444,328 - Total Project Cost 17
Vehicle Modem Upgrade Project Start: San Francisco Fire Department Project End: Total Project Total COIT Total Other GF Total NGF Total NGF + GF Total Spent Cost Funding Funding Funding Funding $1,310,328 $866,000 - - $866,000 $380,470 Status Comment This project replaces the outdated vehicle radio data network with a high-speed LTE broadband network. Scope 41% Complete Schedule Estimated completion by October 2017 Extra network equipment was required to configure routing. DT labor cost increased due to complexity of installation. Budget Final network routing between existing wireless data network and new internet circuit has not been finalized. Security and configuration of the MPLS internet circuit at DEM. Risks 18
Police Department 19
Police Vehicle Upgrades Police Project Objective Keep officers in the field Major Stakeholders Residents and visitors of San Francisco 20
Police Vehicle Upgrades Police Problem: Today, police officers cannot access basic services in their police vehicles. They have to return to the station to access Crime Data Warehouse, the internet, access video, run suspect screens. Often something is happening in the moment that is being streamed live on video – such as an active shooter. Viewers at home in their living rooms can watch the video but officers en route to the scene cannot because the police vehicle computers and modems are 20+ years old and cannot access the internet. 21
Police Vehicle Upgrades Police Project Implementation Stages/Phases Phase 1 Phase 2 Phase 3 Dates: FY 15-16 FY 16-17 FY17-18 Description: Upgrade 180 vehicles Upgrade 20 (for 200k) or Complete vehicle 50 (for $500k) vehicles upgrades (333 in total) 22
Police Vehicle Upgrades Police Project Budget FY 16-17 FY 17-18 - - Number of FTE - - FTE Classifications - - Salary & Fringe 29,300 25,000 Software 400,200 342,000 Hardware 70,500 60,000 Professional Services - - Materials & Supplies $500,000 $427,000 Total Project Cost 23
Police Vehicle Upgrades Project Start: Start Date: 2015 Project End: Police End Date: 2018 Total Project Total COIT Total Other GF Total NGF Total NGF + GF Total Spent Cost Funding Funding Funding Funding $1,727,000 $800,000 - - $800,000 Status Comment Scope 180 out of 333 vehicles will be complete this year ( or early next to account for bringing the cars in for the upgrade. 54% complete. Schedule Budget Risks
Crime Data Warehouse Police Project Objective Prevent, Solve, Manage Crime Major Stakeholders Residents and visitors of San Francisco 25
Crime Data Warehouse Police Problem: Some of SFPD crime, suspect, and policing data is still paper based. Connecting or searching for suspects, crimes, trends can be difficult as multiple systems are required to see all data. Today SFPD cannot report the race and ethnicity of all persons stopped. 26
SFPD Crime Data Warehouse - Design People Home Maps Stops Incident Cases Search Reports s Current Events -Nearby Escaped Convict .2 miles ahead - License Plate Recognized 3 rd and O’Farrell. Click here for details Dispatch reports pedestrian hit, .5 miles away at 3 rd and Mission. Click here for details. Parole violator living at Mission and 5 th . Click here for details. Current Events – San Francisco Bank Robbery Occurring Now in Bank America building at 300 Market……. Occupy SF Shooting at 1350 hours today. See report # 458904 for details. Disturbance at Civic Center – all units in Southern called to work Calls for Service – Past 4 hours Most Wanted and Crime Bulletins Top 10 Hot Spots** 6 th and Mission • 3 rd and California Click for • Van Ness and details • • Market Blue Tooth Arson • • Bandit Suspect Embarcadero Ctr • More • ** Hot Spots = • • • Most shots fired and • calls for service San • Francisc • o Homicide ATM Robbery Video • Calls for Service Northern 3 rd and California 27 more
SFPD Crime Data Warehouse - Production 2011-2012 Incidents People Home Maps Stops Incident Cases Search Reports s Calls for Service – Past 4 hours Top 10 Hot Spots** 6 th and Mission • 3 rd and California Click for • Van Ness and details • • Market • • Embarcadero Ctr • More • ** Hot Spots = • • • Most shots fired and • calls for service San • Francisc • o • Calls for Service 28
Recommend
More recommend
