Cities Index.
View Supplemental Attachment F - 12/6/2024

Oakland City Council
December 17, 2024

Document
View Supplemental Attachment F - 12/6/2024
Meeting
December 17, 2024
Body
Oakland City Council
Pages
55
Original file
1.1 MB
Text extracted from the city's file for reading and search. Open the original on oakland.legistar1.com. That file is the official record.

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator
Community Development & Engagement Funds, monitors and reports CDBG and other federal grants that fund services and projects that predominantly benefit low- and moderate- income residents of Oakland. Administers community engagement activities that informs Oakland residents and collects Oakland residents’ feedback. ***Capital Project - AAMLO Renovation and Restoration Electrical, windows and building system repairs to African American Museum and Library at Oakland
***Capital Project - Brookfield Library Renovation of Brookfield Library ***Capital Project - Main Library Renovation Electrical, floor and building system repairs to the Main Library ***Capital Project - Melrose Renovation and Restoration Electrical, floor and building system repairs to Melrose Library ***Capital Project - MLK Jr. Library Bike Repair Program SpaceContainer facility in the parking lot of MLK Jr. library for bike programs 2025-2027 Strategic Plan Schedule interviews with all major bureaus, divisions, and sections to ascertain their workflows, the role technology currently plays, pinpoints, and potential technology solutions to address those pinpoints. The ultimate goal is to have a functional OPD ITU Strategic Plan for fiscal years 2025- 555 Hegenberger Road Leaking Underground Storage Tank - Site Management Plan555 Hegenberger Road Leaking Underground Storage Tank Case 728 73rd Avenue PCB Contamination Related to the PCB Contamination in Arroyo Viejo Creek project, investigation and remediation of PCBs present on the upland property of 728 73rd Avenue is currently under regulatory oversight. However, the City is currently voluntarily cooperating without a cleanup order. Staff estimates the cost to characterize the site, develop a remedial action plan, and implement remediation and related reporting to be approximately $486,000 over the next two years.
911 Communication: Artificial Intelligence Utilize artificial intelligence to triage, route and answer incoming non- emergency calls to provide accurate and expeditious service to our community members
AB43 Speed Limit Reduction Bill Modifications to speed limit laws increasing local jurisdictions' authority to lower local speed limits to reduce death and injuries caused by speeding.

Accela-Special Activity Permits Transitioning Special Activity Permits into Accela-online permitting platform used by other City departments
Accelerate timelines for Labor Standards investigations and collectionsDWES will identify and implement best practices for investigations and collections, including technology and procedures for collections.

AC-OCAP: CAP Plan AC-OCAP: Strategic planning to be in compliance with CSBG bi-annual requirements
AC-OCAP: Community Needs Assessment AC-OCAP: CNA is prepared documenting the demographics of the areas that are served by the recipients of the CSBG grant.

AC-OCAP: Strategic Plan Update AC-OCAP: Strategic planning to be in compliance with CSBG Organizational Standards requirements
ADA Class Action Lawsuit Settlement Implement the requirements from this class action lawsuit. This could include capital improvements such as curb ramps, sidewalk improvement, updating the city's design guidelines, trainings, and policies.

ADA Transition Plans-ROW Updating the City's ADA Transition Plans - Public Rights-of-Way.

Add electrical outlets to Cover Lot Installation of electrical outlets in Covert lot to charge vehicles. Minimal ITD involvement.

Administration & Grant Management Monitors department budget, pays vendors, prepares reports, and manages various grant programs.

Administrative Instructions Update (ADA) Updating ADA-related AIs per Federal and State mandates, including AI 123, AI 181, and others
Adults & Aging Services: Senior Communication Portal Senior Communication Portal Affordable Housing Asset Monitoring Monitors City's existing affordable housing properties with City affordability restrictions and property conditions. Ensures that properties are in compliance with all agreements and requirements.

Affordable Housing New Construction Loan Servicing Underwrites, reviews, and administers loans for proposed affordable housing developments for Oakland residents.

Affordable Housing Preservation Loan Servicing Underwrites, reviews, and administers loans to preserve existing affordable housing units for Oakland residents

Page 1 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator Alleviate Flooding on High Street between Wattling Street and Railroad Tracks and Improve Storm Drainage on High Street from Wattling to Tidewater AvenueHigh Street Flood control storm drainage system improvements needed to prevent flooding between Wattling Street and the United Pacific Railroad tracks, adjacent 809 High Street. Extensive street flooding in this area covers the sidewalk and impacts private property. High Street in this location serves Higher and Medium Priority Equity Neighborhoods and a Highest Priority Neighborhood to the northeast. The buildings at 809 High Street and 850 42nd Avenue are under compliance orders from Department of Toxic Substances Control (DTSC) and the Regional Water Quality Control Board due to mercury contamination of the soil. DTSC and the Water Board claim that soil contamination causes indoor air quality issues inside the building. DTSC has asked the City to alleviate the flooding in this area because of a correlation between some of the increases in indoor air quality and street flooding. A Water Board consultant claims that the perched water table increases the pressure in the porespace beneath the building, which increases the ongoing vapor intrusion. In addition, storm drainage flows in an abandoned and deteriorating sewer pipe down High Street from the railroad trachs to Tidewater Avenue. This pipe is inefficiently serving a regulatory trash capture device at Tidewater Ave. The storm drainage system requires upgrades to address these issues.

Alternative Delivery Methods for Capital Project Delivery Develop AI's for Construction Manager General Contractor (CMGC) project delivery, and develop and execute an RFQ for a CMGC contract to deliver Embarcadero West and/or speed safety cameras
AP Portal Citywide Adoption Require that all departments involved in approving invoices adopt the AP Portal process.

AP Portal Reviewer Assignment Assign invoice approver once for future automatic assignment, rather than manually each time.

ArcGIS/ESRI Indoors Implement ESRI Indoors - this is a mapping software for vertical assets, like buildings. It allows the mapping of office spaces, various mapping compnents, office space hoteling and reservation, and more. It would allow Facilities to select a vertical asset, such as a cubicle, office, or restroom on a specific floor and record work against that asset. Allows for enahnced buidling record history, and it integrates with Cityworks maps, so work orders can be attached to vertical assets. Would also enhance maintenance records of certain mechanical compnents/assets of a building, like HVAC, plumbing, and more.

Area 5: Hegenberger / 98th Ave. Burglary overtime suppression.Operation detailing : an average of 4 officers, per 10 hours for 7 days of week to ensure safe in special locations for Area 5
Asset Management System Implement an asset management system so we can track militarized equipment use, radios, computer equipment, etc. We are currently doing an RFQ. Funding has been identified via a grant. ITD involvement should be minimal - maybe help with SAML.

Assetworks Upgrade (Fleet Management Software) Upgrade the Assetworks platform to the latest version following the completion of the Oracle EBS to Cloud project. This upgrades all components of Assetworks - FA Suite, Fuel Focus, Key Valet, an improved integration with Oracle for parts purchasing; new integrations with Veeder Root underground storage tanks to foster improved regulatory compliance, Power BI reporting, and single signon.

Audio System Upgrade Upgrade Audio System in Hearing Room 1 ($35-$45K from Fund PEG 2999) Back Yard Camp Out with OPRYD OPRYD collaborate with outside agencies to bring families together for a outdoor camp out experience at Joaquin Miller Park. This event will be a one night weekend event to help set the stage for FRC.

Bay Area Housing Finance Authority (BAHFA) 2024 Bond Public Engagement and Expenditure PlanningIn anticipation of a regional housing bond worth either $10 billion or $20 billion, Oakland HCD will lead community engagement and expenditure planning for its allocation. BAHFA requires each jurisdiction receiving a direct allocation to adopt an expenditure plan no sooner than February 1, 2025; community engagement will take place throughout 2024, and if the bond passes in November '24, final edits to the expenditure plan will occur.

HCD staff will lead public engagement, bond projection impact modeling, expenditure plan drafting, and more.

BD - Community Response Initiative to Strengthen Emergency Systems (C.R.I.S.E.S) Act Pilot Program GrantCommunity safety and mediator program for Downtown and Chinatown

Page 2 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator BD- Corridor Safety and Ambassador Program (Thriving Neighborhoods)Citywide convening, coordination, training and collaboration amongst ambassadors/providers and Oakland NEST/Fresh for training and development
Bloomberg Grant The City was awarded a grant for Black Wealth Creation leveraging the City's 5-year Urban Forestry Plan.

Bus Shelter Maintenance Franchise agreement for bus shelters is expiring. Current agreement maintains shelters at no cost to City in exchange for advertising revenue.

OakDOT working to identify options to maintain shelters in the future, including inventorying existing shelters, estimating maintenance costs, and evaluating methods to procure maintenance services at low/no cost.

Shelters are a critical amentity for transit riders.

BWC Analysis Work with Motorola to provide three years worth of video data to Stanford University for Analysis. Minimal ITD help needed. ITD involvement should be minimal - Axon will handle the work of setting up secure environments that follow CJIS protocol.

C.M.S 89907 (Sep 26, 2023) Form an interagency air pollution working group to implement air pollution actions implemented in the EJ Element - Council Amendment to the Resolution adopting EJ, Safety Elements.Informational report to City Council outlining City Administration's efforts to organize and develop an interagency working group
CAD to LRMS Implementation Upgrade our current CAD system to Premier One and connect it to LRMS.

Major project.

Capital Project - 81st Ave Library Solar Panels Ensure that 81st Ave will have a redundant power source during PSPS Capital Project - Chavez Branch Library New library on city property (due to escalating lease expenses) Capital Project - Thermal and Ventilation Improvements at all LibrariesEnsure that all libraries can serve as respite centers for emergencies Capital Project - Tool Lending Library Expansion Container facility behind the Temescal Library for expanded tool lending CCTV camera upgrade CCTV camera installation in PAB covert lot. Minimal ITD involvement.

CHS: Referral phone number for emergency shelter CHS: Establish an Oakland-wide referral line for emergency shelter CHS: Strategic Plan Strategic planning to be in compliance with HHAP guidelines City Fleet EV Charging Infrastructure Deployment With the Advanced Clean Fleet Rule requiring the City to procure Battery Electric Vehicles (BEV) beginning January 1, 2024 it is essential that the City begin installing EV Charging structure NOW to support the first phase of the BEV deployments this year while the City identifies the $90-$100 million required t support these initiatives.

City Park Outdoor Athletic Court Preventive Maintenance, Repair, and Scheduled Renovation/Replacement ProgramThere is no lifecycle assessment or replacement planning for high-use outdoor athletic corts at City parks. These outdoor courts are frequently a main feature at outdoor Park facilities, yet many are in unsafe and unusable condition. Court surfaces have a predictable lifecycyle and with regualr preventive maintenance such as cleanings, spot repairs, resurfacing, etc. the useable life of these valuable assets could be greatly extended. A priority roster would also be established for full replacement based upon condition, frequency/volume of use, and equity
City Park Path and Trail Preventive Maintenance, Repair, and Scheduled Renovation/Replacement ProgramThis program would inventory, assess and prioritize fro renovation or repair the paths and trails located within City Parks. A reasonable funding level could then be established to support this high-use infratstructure based upon linear or square footage identified in the inventory. There currently is no dedictaed funding mechanism to perform these activities.

City Park Tot Lot & Play Structure Cleaning, Maintenance, Repair, and Scheduled Replacement ProgramThis program would operate in conjunction with the outdoor court program and the same crew would perform the weekly or bi-weekly cleanings, maintenance and minor repairs. While the goal is to provide clean and safe tot lots and play structures, the secondary function wold be to establish a priority roster for scheduled full replacement based upon condition, frequency/volume of use, and equity
City wide Litter Container conversion plan The Ciity's 1,300 litter containers require update and replacement with intermittent placement of "smart container" technology. The increased capacity and data driven service schedules are projected to improve the overall appearance and better the secure the liner and contents until serviced daily by Waste Management. The planning phase for large scale acquisition and roll out has been inititated based on results of pilot purchase of the Big Belly containers put in place during 2023.

Page 3 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator Citywide Capital Project Management Software with full Oracle IntegrationCitywide Capital Project Management software to consolidate all capital projects in a constuction management process and timeline for beter tracking, fund management, and project delivery
City-Wide Compensation Study Council granted $250k to HRM to review the compensation for all classifications.

Citywide Contract Management Software Citywide Contract Management software to manage end to end contracting, with editing, monitoring, insurance, work flows, searchable, and document management.

Citywide facility Assessment Complete facility condition assessment for all city owned infrastructures.

Citywide Facility Asset Conditions Database BDC-PGM is seeking funding to conduct a Facilities Conditions Assessment investigation of the City's 300+ facilities. Data on city assets are needed to predict facility needs, quickly assess improvement needs for funding opportunities such as grants, budgeting for capital improvements and to prioritize work. PGM would lead the management/update/use of data for CIP needs, in consultation with OPW BMIS and other City departments.

Citywide Performance Management System The City seeks to ensure all departments have the tools and resources they need to track and report on equity-centered targets aligned to key health, climate, and economic indicators. This system has the potential to help local leaders to address challenges and improve results wtihin resource constraints, engage all public employees in an era of complexity and rapid changes, and gain and keep the public's trust and confidence through accountability and communication.

Citywide Strategic Planning The Citywide Strategic Planning effort addresses the immediate challenges facing Oakland but also sets the foundation for long-term success by clarifying citywide priorities and creating a framework for policy making.

Citywide Street grates/ storm drain grates upgrade To replace all street grates and storm drain grates that will accommodate bicycle mode of transportation in the City.

Citywide Tree Maintenance and Tree Planting Proactively prune and maintain Oakland's 56,000 street trees and 12,000 trees in landscaped parks. Plant 3,000 trees annually, focusing in Oakland's frontline communities for the sake of improving tree canopy equity, per the approved Equitable Climate Action Plan (ECAP). Provide green jobs training, education, and community engagement. Comprehensive strategy is detailed in the forthcoming Urban Forest Plan.

Cityworks Upgrade, Move to Cloud (Cityworks Online Services), Integrations, new feature rollouts including PLL Case Management and inspections module.An on-premise Cityworks upgrade is underway. To improve resiliency and accessibility to the application, Cityworks should be moved to the Cityworks Online cloud service, as well as the City's GIS resources. Several Cityworks integrations should take place following the upgrade, including ITPipes and GraniteNet integrations, Pavement integrations, as well as feature rollouts including buying and using the Cityworks PLL Case Management & Inspection Module to better track issues pertaining to regulatory requirements, homeless encampment tracking, commercial trash cases, and more.

CJIS MFA/Security Upgrade Review current security protocols and ensure that they meet new CJIS requirements. Medium to large project. ITD is currently doing an internal system analysis.

Code Compliance & Relocation Program Reviews applications on tenant eligibility for relocation benefits in accordance with O.M.C. 15.60 and determines if City payment is appropriate. Assists tenants and property owners in understanding their rights and responsibilities under the law.

Comedy Show Collaborate with Event Promoter to host Comedy Shows with culturally diverse comedians, provides community engagement with laughter that helps to improve mood and reduce stress level

Page 4 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator Comedy Show Oakland Enjoyment Academy provides educational opportunities to help Oakland young adults learn to enjoy themselves outdoors in recreation spaces. The recreation space in Oakland offers a wealth of opportunities for young adults that live in the City to enjoy the serenity of walking along the water for improved emotional health, practicing breathing exercises near large bodies of water, walking with others for increased physical health and learning the health benefits of outside play with socialization while enjoying the outdoors. The communities served will include but not limited to young adults 18-25 years of age who want to be introduced to outdoors recreation. Oakland residents and those who attend college and vocational schools in Oakland will be invited to participate. The number of Oakland Enjoyment Academy participants per year will be 35 (70 total for 2 year program). There will be an annual Oakland Enjoyment Excursion that allows participants to participate in an OPRYD activity as an Oakland Ambassador.

Comms & Engagement Division - City Academy City Academy was a free, 14-week community engagement program in Oakland, launched in the late 90s. An effort to revamp City Academy educates residents on how the City operates and is managed. Participants engage with key city officials, explore city services, and learn how departments address community needs. Aimed at building trust and transparency, the program encourages participation from historically marginalized communities, offering tools and resources to enhance their engagement with the City and its services. The hope is to launch a publicly available course for residents to understand the budgeting process by April 1 and be able to meaningful provide input. City Academy is consistent with the goals of Resilient Oakland Playbook, ICEWG, and AI 6802 in that it aims to build capacity among City department staff and community members by removing barriers to understanding City processes, allowing for meaningful public participation. Inspired by the 2018 Oakland Equity Indicators report and a UC Berkeley Capstone Fellow project in Spring 2024, the program is a partnership between the Department of Race & Equity, the CAO Communications & Engagement Division, Human Resources Management, and external partners.

Comms & Engagement Division - Engagement Customer Relationship Management (CRM) softwareCity currently uses Hubspot, but staff are exploring other platforms that go beyond tracking customer engagement and offer a deeper level user engagement through surveys and other tools. Staff plan to issue an RFP for a new platform in Q3/4 of 2025. Intended to improve efficiency and accountability in City's communications and engagement work and level of success/impact. CRM enables tracking through engagement across depts, how well we engage community groups - need this at a citywide level, right now just at dept level.

Comms & Engagement Division - Oakland Love Life In 2022, the City Council directed the CAO-Communications & Engagement team to plan/program Oakland Love Life Day on behalf of the City. The second annual Love Life Day took place on Octber 20, 2023 and included free food, live performances, guest speakers, and Oakland Love Life Hero Awards ceremony. A Cultural Strategist-In-Government (CSIG) is currently working with CAO Comms and Engagement to develop a long-term strategy for promoting the Love Life motto and message. On an annual basis, we facilitate and support the efforts of Donald Lacy, the father of Lo'Eshe Lacy, in promoting Love Life Week.

Comms & Engagement Division - SMS/Text Messaging Communications PlatformEWDD paid for short-term access to allow staff to test this capability in Hubspot. If successful, staff expect to procure and deploy this feature in 2026.

Comms & Engagement Division - Social Listening/Media Monitoring softwareCurrently researching different software options, pending budget availability. The City used Critical mention in the past. This will also support accountability by showing how well we get information out, what strategies are sucessful. This platform is also essential for crisis comms - social media are often first-line of communication, enables us to listen to and push information to the community more effectively.

Page 5 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator Communications Building Access Software & Keycards Need to restore the ability for Communications to be able to manage access to their building via keycards. Medium project.

Comprehensive Fee Study Revisit all ROW Management permit and inspection fees to align with current costs and operations
Comprehensive Financial Policy (CFP) Revisions Complete overhaul of the city financial polices to address best practices, conflicting resolutions, missing scope, enhance financial stewardship, boltser the finacial position, and provide long term management tools to enhance credit ratings.

Continuing Disclosure, Post Issuance, and Financial Management Accountability Guidelines and TrainingComprehensive training plans and documentation to ensure compliance with IRS standards, SEC guidelines, and California bond law for bond fund management. Enhance executive team knowledge of fudiciary responsibility in depatmental management.

CPRA Mediation Program Establishment of CPRA program to mediate certain complaints CPRA to IAD Transition Transition of responsibilities from OPD Internal Affairs to CPRA Critical Municipal Facilities Project (Sustainability & Resilience)Installing solar panels and batteries on variety of critical City facilities, resulting in lower utilities costs.

Cultural Agencies (Chabot, OMCA, Fairyland) Infrastructure Ballot MeasureCitizen initiative to provde a ballot measure for the cultural nonprift agencies housed in deteriorating City facilites. Enhace the cultrual art experience and bring increased patronage.

Cybersecurity and Resiliency Efforts In process: proposed reductions to the cybersecurity funding ITD was allocated in the biennial budget (including funding directed for staff enhancement in security) will directly impact the work the Department is doing to modernize, strengthen and fortify the network City staff and residents depend on for services.

CYS: Annual Indep. OFCY Evaluation FY 22-23; 23-24 Evaluation of OFCY Strategy Implem.

CYS: Oakland Youth Commission Strategic Plan - YPAR; OFCY Community Needs Assessment & Strategic Planning and Plan DevelopmentOYC YPAR to advance youth agency and voice to inform CNA; Community Needs to Inform 3-year Strategic Plan FY 25-28 for RFP Release CYS: Projects that are mandated by OFCY Charter CYS: (see tab 3).

Data Center Infrastructure Upgrade Upgrading network infrastructure for reliability and enhanced security Data Center Network Upgrade Consolidating storage, adding redundancy, resiliency and enhanced security for the network
Data Collection & Analysis Develops various databases to collect data on evictions, rents, petitions and hearings, etc., to inform public policy and internal program design and improvements.

Data visualization services on PowerBI, starting with the Weekly Crime ReportsThis is a complicated project that requires all crime analysis services to be realigned and reconnected to a new records database. In the run up to the new database, the sections will be using various flat datafiles to develop data visualization projects in PowerBI. We will integrate these standalone projects the new database when it is launched.

DBE Oversight: Ensure compliance with requirements The City of Oakland receives USDOT money with many requirements, including compliance with CFR 49, Part 26. The City of Oakland is not currently following all requirements. Not complying can potentially jeopardize the City's eligibility to receive funding.

Defensible Space Vegetation Management, Joaquin Miller ParkCAL FIRE, with support of the National Guard, is performing vegetation management in Joaquin Miller Park to reduce vegetative fuel loads in Joaquin Miller Park. They are performing this work at no cost to the City of Oakland, via an MOU. This is a major benefit to the City as there are currently no City staff funded to perform this work.

Dejaview Upgrade ITD to upgrade Dejaview to the newest version.

Demand Responsive Parking Flex meter rates to achieve optimum utilization of parking supply. 2013 City Council Resolution Parking Principles
$1.5million grant from MTC includes full scope and deliverables Depository and Custodial Bank Implementation Solicit new Bank Depository for citywide banking needs, adding additional services to fully service the needs of the organization and requests from City Council for enhanced services
Develop a new comprehensive plan for training Research a series of trainings that will expand and evolve the crime analysis experience. Work with the Training Division and budgeting to find funds for the trainings. Schedule analysts in rotation for each training, until all analysts have completed all trainings.

Page 6 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator Disparity Study - Potential new policy development for procurement.The city has contracted for a disparity study for which the contract has expired. A draft report has been completed and is being reviewed for next steps. Any next steps for race-based procurement would fall within DWES authority to implement.

Division Level Investigation (DLI) Administrative task for the internal policies or procedures Document digitalization & Destruction Digitalization & destruction per retention schedule & municode EIFD Implementation Create two different tax increment districts to promote affordable housing in west Oaklnd and enhanced development around the Colisuem Electronic Cashiering System Upgrade with Oracle Cloud IntegrationIn process: Pending RESO and contracting Emergency Communications Center (ECC) The 911 Communications Division is a complex Public Safety Answering Point (PSAP) for the City of Oakland, handling incoming emergency policy, fire and medical calls and text messages as well as non-emergency calls.

Communications operates 24 hours a day, 7 days a week. Our dispatchers are POST-certified and they answer, triage, and route incoming emergency and non-emergency calls, dispatch officers and civilian technicians on the radio and perform administrative duties pertaining to the operations in the field. Our professional staff responds to Public Records Requests by providing responsive dispatch/phone audio and transcripts, prepare certified court documents and testify in court.

Emergency Home Repair & Home Maintenance and Improvement Loan ProgramsProvides Oakland's low-to-moderate income, senior and disabled homeowners with 0-3% interest bearing loans for home repair and rehabilitation from $15,000 to $150,000 to homeowners that require immediate attention to correct health and safety repairs, life-threatening hazards, and exterior appearance if blighted.

Enhanced Service Levels - Medians & Litter Container Provided enhanced levels of service and increase frequency of service to the medians and litter containers in the KOCB vegetation management.

Increase staffing level in KOCB/ Vegetation Management Unit - two (2) PW Maintenance Workers; one (1) Street Maintenance Leader) Equipment Replacement Replacing projector in chamber with modernized video wall ($100-$150K from Fund PEG 2999)
eSports eSports is quickly permeating many aspects of our society from an entertainment and competitive standpoint. This is reflected in the move by recreation centers throughout the country to add eSports components to their facility. Aside from generating revenue through memberships and events, adding eSports allows recreation centers to develop programming that can attract older kids to their facilities
Facilities Conditions Asset Database (FCAD) Create FCAD for City's 300+ facilities that will streamline delivery of capital improvement and maintenance projects.

Fair Chance Access to Housing Prepares informative materials that provide information and guidance on Fair Chance Access to Housing. Manages contract with East Bay Community Law Center to provide legal assistance to tenants. Coordinates with Just Cities which performs community outreach to vulnerable communities.

Feasibility Study - Piedmont Avenue Library New library on the OUSD Piedmont Elementary School campus Feasibility Study - San Antonio Community Center/Library Feasibility study for a new community center/library Feasibilty Study - Hoover Durant Library New library in the Hoover Durant neighborhood Feasiblity Study - Main Library New or significantly renovated Main Library Fee Study OPRYD has hundreds of fees that have not been assessed.

FEMA reimbursed 2023 Winter Storm Project We will be working on existing FEMA projects for the next two years most likely. We are charging to 1010 and then will be reimbursed. Do we need to add something to the mid-cycle budget about this?
Filling the Maintenance Gap Assessing the growing gap between capital project dollars and maintenance dollars over time, funding sources for maintenance, and unsuccessful efforts to identify funding sources to help understand the need.

Final Measure Z two-year Evaluation by Urban Strategies Measure Z is sunsetting in FY 2024, the last installment of the parcel tax and other revenues collected will be received by the City approx. March-May 2025. The contract with Urban Strategies expires in March 2025, vendor will submit/present a final 2-year evaluation to the City.

Page 7 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator First Watch Data Sharing Integrate First Watch into Premier One CAD so that certain pieces of information can be shared with other agencies and other agencies are able to share alerts with OPD. Minimal ITD involvement.

First-time Homebuyer Loan Program Provides loan funding to first-time homebuyer Oakland residents and workers and creates homebuyer education activities.

Fitness Unity Increase awareness in fitness to the communities through recreational programs. Development of training curriculums in health/wellness, healthy lifestyles, and childhood obesity.

Fix CarFax Implementation Fix the connection between OPD and Carfax on traffic data - ITD established this in the past and it has been broken since the ransomware attack.

Minimal work needed, just re-establishing a connection.

Fleet Electrification OPW-BMIS and BDC is working on planning phase with City Administrator and Sustainability Manager on meeting the 2035 federal mandate.

Flock ALPR Installation of cameras will be handled by Flock. User Administration will be handled by OPD, there should be minimal ITD work.

Fund OPW CIP Programs Rather Than Projects Approve funding for OPW CIP Programs (eg. Buckets) rather than specific projects to improve cash flow flexibility, expedite spending timelines, flexibility in moving funds to projects as needed.

FY21-23 Council Earmarks Using availabe 2218 fund balance, Council identified specific traffic safety projects in their districts for OakDOT to implement.

Geoanalysis to ArcGIS Pro This project involves a complex undertaking wherein all crime analysis services will undergo realignment and integration with a new records database. As part of the transition to the new database, the sections will utilize the new geospatial program ArcGIS Pro to create and refine new products and services. Our next steps involve scoping out a new data feed and integration service, establishing the necessary contractual relationship, conducting thorough testing, and ultimately launching the new system.

Granicus Inc/Legistar Agenda Management Implementation ProjectImplementation of Granicus Inc.'s Government Experience Cloud will enable integration of the City's website content management system with its legislative system, as well as enhance security, streamline the agenda management process through increased automation and electronic routing/approvals, and improve user experience for staff and the public.

Grant Management Software Integration New grant management software used to apply for and management grant funds, create a portal to manage grant recipients for cgrants provided by the City to outside entities. Oracle intergrated for real time funding knowledge and management.

Grants for Earthquake Seismic Retrofitting of Apartment BuildingsThe Safer Housing for Oakland Program (SHOP) offers grants to reimburse owners for a portion of the costs to seismically retrofit a multi-unit apartment building with a “soft-story” condition. The Earthquake-Safe Homes Program offers grants to owner-occupants of 1-4 unit properties for partial reimbursement of the cost of a seismic retrofit.

HE 2.1.5 Implement Universal Design Strategies The City will consider adopting a Universal Design Ordinance to address housing needs and improve housing conditions for seniors, people experiencing disabilities, and other communities with accessibility issues.

HE 2.2.5 Extend Local Replacement Unit Provisions Requirements above SB 330Codify and extend local replacement unit provisions to ensure compliance and prevent displacement.

HE 2.2.7 TDR for SROs Consider allowing owners of residential hotels that agree to restrict occupancy to lowerincome residents to transfer development rights to create an endowed source of funding for an internal subsidy for such residents, or for maintenance/ facility upgrades that do not increase rents.

Page 8 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator HE 3.2.6 Monitor affordablity of ADUs (ADU Survey) To ensure that Oakland’s ADU production aligns with these projections, the City will send a survey to the property owners of ADUs that received a certificate of occupancy within the prior two-year period requesting information on household size and rents charged for these recently constructed ADUs. If the survey identifies a shortfall in the numerical affordability production projections, within six months of the survey report being published the City will provide to the Planning Commission a report summarizing the survey report and identifying additional actions that can be taken to either increase the production of affordable ADUs, and/or proposing other rezoning programs that will enable additional affordable housing production to fill any identified affordable housing production shortfall.

HE 3.3.15 Continue & Expand Density Bonus Incentives To ensure that the Chapter 17.107 remains compliant with state law, and to solicit additional ideas for incentives and expansion of the density bonus program, the City will review the density bonus program mid-cycle, bring necessary amendments to conform to state law, and solicit feedback from Planning Commission and City Council on additional incentives that could be included in the local density bonus program.

Health & Wellness Community Challenge Partner with Public Health Agency or Hospital to select one month to encourage Oakland residents to engage is physical activity at Oakland Parks and track progress. They could select an activity and enter a challenge wih the community.

Health & Wellness Walk/Run & Resource Fair Collaborate with Hospitals and Public Health Agencies to host an interactive educational event to include a walk around Lake Merritt with a Health/Wellness Fair at the end with resource booths, health screenings, fitness demonstrations and healthy food samples.

Homelessness Prevention Pilot Program In FY22-23, Oakland HCD provided $2.3 million for a pilot program to prevent homelessness for the most at-risk Oaklanders. Oakland HCD is collaborating with researchers at Stanford University and the University of Pennsylvannia to study the effectiveness of the service interventions. The program, focused on wrap-around services and shallow subsidies, is executed by a collaborative of community organizations under the Keep People/Oakland Housed umbrella of Bay Area Community Services (BACS).

The program is serving 300 residents in its first year with the hope of demonstrating substantial impact in preventing homelessness in order to continue in future years.

Housing Protection Services Provide services in the form of eviction protection and homeless prevention via service providers to Oakland tenants at risk of displacement or homelessness. Includes legal assistance, emergency rental payments and wrap around services.

Housing Resource Center Supports via phone calls and emails residents seeking housing services and information.

Human Trafficking Operations Operations to rescue Juveniles and arrest Offenders of Human Trafficking along International Boulevard
IKE (Interactive Kiosk Experience) Digital Kiosks Support IKE's franchise agreement, authorizing up to 50 digital kiosks in the right of way

Page 9 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator Illegal Dumping Surveillance Camera Program - $250k per year (O&M) + Three (3) Additional Administrative FTEsExpansion of the Illegal Dumping Camera Program will require the acquisition of more license plate recognition (LPR) and surveillance cameras AND additional staffing to monitor the cameras, issue citations, conduct research, etc.

Staff is seeking Council approval at the MAR 26 PWTC meeting for a three (3) year contract with camera vendor Security Lines U.S. (SLUS) to procure additional cameras and to ugrade, maintain, and repair the current fleet of cameras.

As the number of cameras grow, staff proposes hiring three (3) administrative personnel (classification yet to be determined) by FY25-26 to monitor cameras, issue citations, and conduct research, etc. These administrative personnel differ from the current Environmental Enforcement Officer (EEO) classification in that the administrative personnel will be in-office staff that do not perform field patrol or other enforcement activities currently performed by EEOs. The addition of the in-office administrative personnel will permit EEOs to spend less time in the office monitoring cameras, and more time conducting outreach and enforcement activities in the field.

Implement a new RMS system Need to identify a new records management system to implement so OPD can adhere to the NIBRS standard. Major project.

Implement outreach strategies in all our work DWES will continue to implement outreach strategies to ensure the community is informed about our work.

Implementation of New labor Standards Policies The Council set a goal of considering Labor Standards Policies for housing and other development by July. It passed a resolution requiring the City Administrator to facilitate the process. This creates implementation work that may include: researching standards, benchmarking and comparisons with similar cities, and developing new policies and procedures.

Implementation of Rapid Response Homeless Housing loan programThe City Council’s biannual 2023 – 2025 budget established a Rapid Response Homeless Housing Fund in the amount of $10,400,740. The City is adding another $19,667,562 in Permanent Local Housing Allocation funds, as well as $10 million in outstanding Homekey Round 3 commitments for a total of over $40 million. To implement the deployment of these funds in a manner that is expeditious and effective in addressing homelessness, staff created the Rapid Response Homeless Housing (R2H2) Program, modeled on the success of the Homekey program. The City Council adopted this program at its November 7, 2023 meeting, and the initial RFP was due February 29, 2024. Staff will evaluate proposals and work to administer the funds + loans throughout 2024 and beyond.

Improve workflow and process of L/SLBE compliance and labor standards complianceDWES will analyze the processes L/SLBE and labor standards, identify obstacles and gaps, and improve coordination to improve timeliness and quality of service.

Incoming Chief Goals and expectations The crime analysts provide the framework for the Monday 11am crime meeting, including verbal presentations, expansive analytical reports with commentary, and material for presentation at the meeting itself.

Increase on-street parking rates from $2.00 to $3.00 (50% increase).Increase on-street parking rates from $2.00 to $3.00 (50% increase). Cost of living adjustment accounts for no rate changes since 2009 Integrate Crime Analysis Services with new Records database system (Mark43)This is a complicated project that requires all crime analysis services to be realigned and reconnected to a new records database. The completion of this project will open new avenues to report creation and other data and geospatial projects.

Internet Migration The City's current website is no longer supported. Project covers migrating and updating the City internet pages; move to One-Meeting Platform for the City's Agenda Management
Intimate Evenings at Dunsmuir or Gardens-Partnership or CollaborationCollaborate with Event Promoter to bring Oakland's diverse community together for these festive fundraisers.

Intranet Restoration Migration and updating City intranet pages; moving all content from old OakNet News site to SharePoint and closing the former site which has experienced broken/unusable links and content post-ransomware

Page 10 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator Job Fairs Council granted HRM $50k to support job fairs.

Lake Merritt Violence Suppression During the summer months into the fall months, Lake Merritt requires additional police service, traffic control, vendor regulation and special event permitting. OPD works with DOT, Parks and Rec, City Administrator's Office, Nest and Lakeshore/Lake Merritt Work Group to provide holistic service.

Lakeshore Avenue Protected Bike Path Project Implement bike lane safety improvements on the East side of Lake Merritt.

Lakeside Park work hub/bathroom replacement The Lakeside Park work hub serves 30+ staff members but lacks adequate office space, storage space, security, and bathrooms. It suffers from severe infrastructure problems including water leaks, rodents, and seismic damage from the 1989 earthquake. The once functional public bathroom is in disrepair and unusable, leaving park visitors without a sanitary alternative.

Replacing the work hub building would be a Capital Improvement Project, replacing the public bathrooms may be more feasible with pre-fabricated infrastructure.

Law Enforcement Background Investigation Cloud Based SoftwareSoftware that allows the unit to conduct background investigations in a cloud based system. Eliminates the need for manual processes and file storage.

Lead-Safe Paint and Access Improvement Grant Programs The Lead Safe Housing Paint Program provides grants from $15,000 to $24,000 for exterior painting and lead hazard remediation. The Access Improvement Program provides grants from $15,000 to $24,000 for accessibility improvements to both rental property and property owned and occupied by disabled persons.

Loan Servicing Underwrites, reviews, and administers loan applications for the purpose of repayment and subordination requests, including commercial, residential and rehabilitation grants and loans.

Mass Care and Shelter Plan, Functional Need Annex (ADA) 2010 City Council Resolution No. 82836 CMS, state-mandated requirement to include Access and Functional Need component in Mass Care and Shelter Plan. Joint effort with OFD-EMSD.

Measure Q Deliverables Dedicated staff placed at community serving parks and regional parks.

Measure U Activities Bonded, not started: Providing Wi-Fi and/or connectivity to affordable housing in Oakland
Minor Home Repair Program The MHRP grant program provides financial assistance for home repairs up to $2,499 to correct immediate threats to the health and safety of low-income homeowners in Oakland. Single unit residences, including mobile homes are eligible. This grant can be used to make minor plumbing, carpentry, electrical repairs and can be used for railing grab bars, toilets, water heaters, doors, locks and more.

Mobile ID Restart project Obtain New Mobile ID readers from ACSO as well as upgrade software with the help of ITD. Roll out system to patrol. Minimal ITD involvement.

Mobile Recreation Services The Pop-Up Rec (mobile), brings a versatile and dynamic dimension to community engagement. Unlike traditional brick-and-mortar facilities, Pop- Up Rec programs offer unparalleled flexibility in both the variety of activities and locations where services are provided. Additionally, Pop-Up Rec allows OPRYD to be responsive to communities that may lack access to parks or recreational facilities. Our mobile unit could feature an exciting array of offerings, including a rock climbing wall, jump houses, giant games, giant big wheels, amplified music capability, video games, sports equipment, arts and crafts, storytime and books.

National Testing Network Administers required written test for Police Officer Trainee position.

New Construction of Affordable Housing - Pipeline Project FundingThe 2023 new construction NOFA cycle left over $120 million in unfunded requests for support. Oakland HCD staff convened affordable housing staff from peer cities around the Bay Area to learn about their funding approaches and better understand best practices in the field. Staff learned that every other jurisdiction releases a NOFA specific to its pipeline projects in between notices for new projects. In February 2024, Oakland HCD attained approval from city council to focus its next NOFA solely on (partially or completely) unfunded affordable housing projects in its pipeline. With council approval, Oakland HCD will administer $22 million for its outstanding projects in advance of a NOFA for new projects later in 2024.

Page 11 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator Non-Functional Turf Assessment and Conversion Assess and convert all "non-functional" (ie non-recreational) irrigated turf on City property to either a) non-potable water irrigation or b) non-irrigated landscape.

Oakland Ballers at Raimondi Field The Bs Pioneer Minor League Team will utilize the OPRYD-run ballfield at Raimondi Park as their "home field", providing capital upgrades, maintenance and improvements; economic opportunity for local vendors; clinics and events with local youth sports teams; additional opportunities for neighborhood 'activation events'. Expectations: Increased neighborhood safety due to park activation; youth and local sports teams will benefit from improved field and equipment; potential increased public transportation ridership due to game-day collaborations; economic benefit to neighborhood warehouse owners who will rent property for parking, to local food truck vendors, merch purveyors, and landscape/construction Oakland Building Construction Code Recommend local amendments to the CA Model Building Codes Oakland Children's Initiative (OCI) - program administration and capacity buildingEstablishing an administrative foundation for to manage the initiative, including fiscal/financial, programmatic and communications functions, through contract support.

Oakland Children's Initiative (OCI) 2-Year Evaluation Charter Section 1602 requires the Accountability Officer shall be responsible for overseeing a rigorous and reliable external evaluation or evaluations of the Implementation Partners' performance, including the selection of external evaluation partners or the utilization of existing external evaluations as applicable, and presenting the results of such evaluations to the Citizens' Oversight Commission.

Oaklandca.gov upgrade from Craft CMS to Granicus/OpenCities CMS.Upgrading the oaklandca.gov content management system from it's current Craft software to a Granicus product called OpenCities. The new OpenCities platform is scheduled to be deployed publicly in Summer 2025 OPRYD Annual Youth Dance Concert Recreation Centers collaborate with cultural arts and youth development to put on a dance concert performance to show case each recreation centers talents.

OPRYD E-Platform -Relaunch Teen Virtual Recreation is a program designed to offer virtual engagement in recreation and leisure activities for teenagers. This initiative provides an interactive online platform featuring a variety of virtual programs. Teens can explore cultural arts, career options, and life skills, participate and learn about civic engagement opportunities, and focus on physical and mental health, nutrition, and wellness—all from the comfort of their own space.

Teen E-Recreation is a dynamic avenue for adolescents to connect, learn, and enjoy various activities that contribute to their personal growth and well-being.

OPRYD is requesting salary savings be re-purposed to provide for the equipment and supplies needed to operate the Teen Virtual Recreation program
OPW Grant support program BOA Grant Division support of OPW grant seeking and writing OPW Trainee Academy Safety and Training created a program to advance youth and young adult employment in the City. This program targets residents between the age of 18-30 who have historically been marginalized, disenfranchised and oppressed with a place of study or training in a special field for success with greater than living wage employment.

Oracle Cloud Conversion and Enhancement Convert Oracle Financial System to be web hosted to provide a stable platform from which to make system enhancements that provide the basic functionality of a modern ERP system
Organize a tiered section, with additional job descriptions, interns, and room for advancement and promotionDevelop job descriptions to accommodate a tiered positions system in the Crime Analysis section, including provision for at least two interns. Work with the unions, and various city department to get the job descriptions approved. Second, work with budgeting, OPD HR, the OPD executive team, and City Council to bring the new positions and CAU origination into reality.

Page 12 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator Outdoor Stand Alone Restroom Renovation and Scheduled Replacement ProgramThis program would assess and prioritize outdoor restrooms for renovation and repacement based upon condition, frequency of use, and equity. The concept is to create a repalcement roster and funding to allow the renovation or replacement of 2-4 out door restroom facilities each year.

Ideally the restrooms that are replaced vs. renovated would utilize low- maintenance and vandalism resistant Portland Loos such as deployed at Astro park, Wilma Chan Park, Pine Knoll Park and Concordia Park; or modular restrooms units such as deployed at San Antonio Park.

Partnership with Community Development Financial Institutions (CDFI) to increase scale of acquisition/rehabilitation/conversion to affordable housing programOakland HCD's current Acquisition and Conversion to Affordable Housing (ACAH) preservation program releases NOFAs once per year, or biannually.

This time frame does not meet the needs of preservation practitioners in Oakland, as they need subsidy and support quickly in order to acquire buildings on the market. To respond to our partners' and the market's concerns, Oakland HCD is pursuing collaboration with CDFIs that will leverage outside funds and allow developers to acquire properties much more quickly than the city process alone would allow. Such a partnership will allow many more properties to be acquired and made affordable (through deed restrictions) for years to come.

Payroll Processing Reform Comprehensively streamline payroll processing for basic compliance in the absence of Oracle systematic improvements to gain regulatory compliance with all agencies. This includes personnel reorganization to a citywide centralization of all payroll functions into Finance Department, training manuals and comprehensive mandatory training plans, and updated Administrative Instructions
PCB Contamination in Arroyo Viejo Creek The City is under a Site Cleanup Requirements Order (R2-2022-0032), issued by the San Francisco Bay Regional Water Quality Control (RWQCB) in October 2022, to remove polychlorinated biphenyls (PCBs) from Arroyo Viejo Creek. The Order alleges that stream banks and sediments within the creek have been contaminated with PCBs from upland properties at 700, 710, and 728-73rd Avenue. Union Pacific Railroad (UPRR) owns 700 73rd Avenue while the City owns 710 and 728-73rd Avenue. The Order requires that UPRR and the City evaluate remediation alternatives, prepare a remedial action plan, and implement remediation.

Planning & Building process review Assign dedicated BPD staff to process applications for city CIP projects.

Eliminate requirement for full payment of intake or permit fees prior to Planning & Building Dept (PBD) staff assignments on city projects.

Increase standard 6-month building permit life span to at least 2 years or more.

Streamline database gathering of Tenant and Property Owner mailing lists by exploring use of City's rental database to help gather tenant info for required mailings. The mailing lists were previously provided by PBD staff.

PMWeb Gather, validate, implement Phase II Requirements, including implementation of single sign on using the City's Azure Active Directory, deployment of the Planning Module, capturing and implementing singificant missed requirements from Phase I; identifying new processes, such as improving the Oracle Integration after EBS move to cloud, ESRI/ArcGIS integration, moving to the City's document management system for storage; development of a new Vendor Portal, incluidng a specific landing page for vendors, reports, and help and training documents; define and implement an archival process for CIP project records and documents; Service Now implementation and establishing service level standards for BIAD day-to-day application support; configure, update, maintain intranet site for PMWeb resources.

Police Staffing Study Staffing study to assess OPD sworn and civilian staff as well as resource allocations to optimize public safety resources
Policy Advocacy Provides research and advocacy services to further the City's affordable housing goals
POS Implementation Implement a new system that serves as a citywide cashiering system, to streamline credit card paymens, remote deposits, cash management and cash reporting in decentralized departments

Page 13 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator PPD Issue RFP for On-call Economic Consultant Contracts On Call Economic Consultant Contract to provide economic and financial analysis on priority real estate projects and transactions. Shall serve EWD and misc. City Depts.

PPD - Negotiate Development Agreement Amendment for Brooklyn BasinNegotiate an amendment to the existing Brookyn Basin Development Agreement to support new for-sale housing. Supports work of PBD.

PPD- Execute Men of Valor Contract to maintain city propertyMOVA contract to provide on call clean up services on City Owned properties to prevent illegal dumping etc.

PPD- Issue Next NOA/RFPs on City Owned Sites for Affordable Housing etcIssue NOA/RFPs for city-owned sites for affordable housing (per requiremens of Housing Element) and other priority uses Predevelopment loan program revamp Oakland HCD's current predevelopment loan program offers up to $50k for developers to support their construction work in its early stages. Staff research demonstrates that $50k is far below the amount needed to adequately support developers in their work; thus, staff is examining the existing program and proposing changes that, if council-approved, will increase accessibility and assistance in meaningful ways. There will also likely be unique incentives to support BIPOC and/or emerging developers to increase equity in contracting.

Pre-Employment Credit Checks Contract for 4 years: California Peace Officer Standards and Training (POST) requires pre-employment psychological screenings. The department also requires pre-employment credit checks for all positions. The checks are used as an investigative tool to gauge applicant's ability to confront and overcome problems, obstacles and adversity, which is a California POST hiring dimension.

Pre-Employment Department of Justice LiveScan Contract for 4 years: California Peace Officer Standards and Training (POST) requires a criminal history check. The department also requires pre- employment criminal checks to determine applicant suitability to meet job requirements.

Pre-Employment Investigative Polygraph Examinations (Police Officer Trainee & Dispatcher Applicants)4 year contract totaling $800,000. The unit requires the services of several polygraph service vendors to meet the hiring demands for Police Officer Trainee and Dispatcher applicants. Polygraph examinations are a pre- employment background investigation tool that assists with gathering background information and verifying the accuracy of the information provided by applicants.

Pre-Employment Medical Examinations (Police Officer Trainee & Dispatcher Applicants)Contract for 4 years: California Peace Officer Standards and Training (POST) requires pre-employment medical examinations. Commission Regulation 1953 includes the requirements for conducting peace officer background investigations. The peace officer medical and psychological evaluation requirements are outlined in Regulations 1954 and 1955. Commission Regulations 1956-1960 contain the selection standards for public safety dispatchers. Medical examinations determine applicant's physical suitability to meet job requirements.

Pre-Employment Psychological Exams Contract for 4 years: California Peace Officer Standards and Training (POST) requires pre-employment psychological screenings. Commission Regulation 1953 includes the requirements for conducting peace officer background investigations. The peace officer medical and psychological evaluation requirements are outlined in Regulations 1954 and 1955. Commission Regulations 1956-1960 contain the selection standards for public safety dispatchers. Medical examinations determine applicant psychological suitability to meet job requirements.

Program Transportation Vehicles Provide community recreation centers with vehicles to pickup youth from OUSD and charter schools within the areas and transport them to local community recreation centers for after-school programs.

Protection Services Strategic Action Plan Oakland HCD's 2023-2027 Strategic Action Plan, produced in spring 2023, focuses primarily on the use of its capital dollars for housing production and preservation. To complement this effort, staff is developing an addendum for the allocation of its service dollars focused on anti-displacement, homelessness prevention, eviction defense, and more. The action plan will include an equity framework that prioritizes how Oakland HCD will administer its service dollars (e.g. CDBG) with a racial equity lens.

Page 14 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator Public Bank of the East Bay Create a public bank in the East Bay to sprovide banking for the unbanked and low income individuals that are unable to secure lending from mainstream lending institutions. The bank would be created using only public funds from the City of Oakland , County of Alameda, City of Richmond, and City of Berkeley.

Public Safety Infrastructure Bond Ballot Measure Develop an infrastructure ballot measure that soley supports public saftey buildings and or infrastructure, to fund the replacment / rehab of fire stations and the Police Admnistration building
Purchasing and Contracting Reform Comprehensively streamline procurement processing for basic compliance in the absence of Oracle systematic improvements to gain regulatory compliance with all agencies. This includes personnel reorganization to centralized procurement in the Finance Department, Risk Management Division transfer, contract template and RFP overhaul, comprehensive training plan, City Council Policy recommendations for OMC changes, and updated Administrative Instructions
Radio Encryption Encrypt patrol channels 1 through 5, in addition to others suggested by Radio. Medium project.

RE - new Police Administration Building Public-private partnership to finance and develop a new police HQ RE - Oakland Ballers ballpark at Raimondi License, lease and/or gift in place for new minor-league baseball game venue
RE - Oakland Roots temporary stadium 10-year lease of the City/County-owned Malibu parcel to the Oakland Roots for development of a interim stadium
RE - Remnants/ Small Site Disposition Develop and implement a strategy for the disposition of City-owned remnants, sliver parcels, and other small sites not suitable for large scale development in order to generate sales revenue and reduce maintenance and security expenses.

Reactivation of Closed EMT sites NSD is working closely with the Encampment Management Team to identify closed sites and coordinate with Environmental Services to promote Adopt a Spot as a way to have residents maintain and create community gardens to prevent re-encampment of the site. This initiative was developed because of the increasing EMT site list and the re-encampment rate of sites cleared by EMT.

Recruitment Advertising & Promotion Advertise various law enforcement positions available with an emphasis on Police Officer Trainee and Dispatcher positions. Advertising may include print, display, paid search, broadcast, and social media.

Reforming HRM Processes Council granted HRM $250k to review HRM processess and implement improvements, where they are identified.

Reimagining Citywide Permits (RCWP) Fee Study Engage consultant to finalize fee studies for departments' permitting functions by January 2025 and better understand which classificaitons and positions across all depts are appropriate for support from the Development Services Fund (2415).

Reimagining Citywide Permitting (RCP) Accela improvements:
a. CGS/PX app implementation
b. Accela workflow updates
c. Accela electronic plan review
d. Accela parklet permit
e. Accela ROW Module
f. Accela Project Scoping Tool
g. Accela permit / OakDOT CIP project integration
h. Accela permit / Inspections app integration
i. Expand ACA to include all DOT permits
Reimagining Citywide Permitting (RCWP)-related technology implementationsImplement multiple solutions at department level to improve permitting services and customer experience. Includes electronic plan review software, project scoping tool software, enhanced permit application portal. Tools selected by interdept team through RFP process, currently in various stages of implementation.

Page 15 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator Reinvigorating AI 527 (EICRC) Requires appointment of EO reps Ongoing project to assign AI 71 reps (equal opportunity representatives) at the department level, provide staff training (first time and ongoing). Once the team is established, the AI 71 reps will also support ongoing projects.

AI 71= requires each dept to designate an equal opportunity rep Rent Adjustment Program (RAP): Community Engagement and Public EducationPrepares materials that provide information and guidance on rent and eviction laws at local, state and federal levels to educate public about their rights and responsibilities under these laws. Engages in extensive public outreach to disseminate this information.

Rent Adjustment Program (RAP): Housing Counseling and HearingsProvides holistic counseling to tenants and property owners regarding RAP laws, including just cause for eviction and eviction moratorium. Reviews petitions, hears cases, renders decisions, reviews appeals, coordinates appeal hearings before Rent Board.

Replace Interview Rooms Need to replace six interview rooms in the PAB with new hardware/software. This upgrade will allow us to upload video directly to Evidence.com. Minimal ITD involvement - opening ports and some Telco, Axon will handle most of the installation work.

Replace PAB Auditorium Screen Replace PAB Auditorium AV equipment that’s bad (Screen). Minimal ITD involvement.

Restoration of Park Rangers Study and finalize the proposal to restore the use of Oakland Park Rangers Restoration of Parks Services within OPRYD. In an effort to improve parks, maintenance, and recreational service delivery, reduce deferred maintenance, address urgent infrastructure issues, and streamline capital improvement projects OPRYD is proposing various functions that fall within other city departments or formerly housed within OPRYD be transferred back to our department. OPRYD has identified supervisory, management, and subordinate front line staff dedicated to parks, landscape maintenance, and recreational services that would fulfill these necessary services and achieve the goals of the Measure Q parcel tax.

These areas include but are not limited to park maintenance, building maintenance and custodial services at OPRYD parks, facilities, and restrooms, ballfield maintenance, pool maintenance, capital improvements of parks and recreation facilities, and other parks & recreation services related functions.

SA-Developing Oakland's Film Industry The Mayor's Office has identified developing Oakland's film industry as a economic development priority; however, with no current funding available to subsidize fees of film productions, this project appears mostly in the planning stages
Saigon and Lakeshore Violence Suppression Robbery/Burglary suppression in Area 3 Business Districts Scholarship Gala Scholarship Gala for OPRYD Programs and Services to tell the OPRYD story.

Community engagement, invite donors, network and build connections.

Hosting a Scholarship Gala can have a positive impact on OPRYD and the community.

See "Supplemental LiƩer & Trash Abatement + Homeless Encampment Clean-Up Contract" above.The contract will service multiple departments - OPW, EWD, HCD and DOT.

This portion of the contract scope of work consists of abating dumping from City creeks. Contractor/s will respond to OAK311 reports of illegal dumping in creeks on City property, coordinate clean-ups with KOCB operations and/or Parks and Tree Services Division (PTD) operations as needed, collect and bag debris, organize bulky waste in centralized location, and contact OAK311 or designated KOCB or PTD personnel for bag/debris pick-up.

A citywide contract for one or more contractors to provide supplemental support with litter & trash abatement and homeless encampment clean-up throughout the City.

ServiceNow Study and System Functionality Enhancements Not started: Examining possible solutions to enhance City services; capitalizing on the existing ServiceNow platform

Page 16 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator Sewer and Storm Drain Smart Maintenance Hole Cover Sensor ProjectThis project builds upon an initial pilot deploying water level and flow volume snsors in sewer maintenance holes at critical/environmentally sensitive locations such as in and around lake Merritt and Lake Temescal.

The sensors provide an "early warning" capability of potential sewer and storm drain pipe concerns such as partial obstructions, but also when deployed more extensiveley will be used to establish baseline water flow data and can then be used to focus response efforts such as; prevent sewer spills before they occur, precisely tailor high-frequency preventive maintenance based upon actual condition rather than set time schedules; perform preventive mantenance in advance of storm events; identif potential sources of infiltration and inflow; identify potential contractor caused damage before spills; monitor real time tide levels at crticial storm drain outfalls (such as Coliseum Connection); identify, documen, and establish baseline reverse water flows (tidal inflow) at critical locations such as Coliseum Conection).

Short Term Rental Short Term Rental
Sideshow Prevention Pilot Install engineering treatments to sideshow locations prioritized by OPD.

Sidewalk Parking Enforcement Years long effort to correct the record on sidewalk parking on narrow streets
Skyline Blvd Evacuation Corridor Project In 2021, CAL FIRE provided the City $824K to remove or prune dead or hazardous trees along the Skyline Blvd Evacuation Corridor. The project is now 90% complete. An additional grant application for $1M has been made for phase 2 of this project, though awards have not yet been announced.

Software contracting for improved tow operations Adopt software and multiple tow service contracts to expedite the removal of abandoned autos. This program may also be expanded to tow vehicles violating expired parking limits.

Speed safety cameras AB 645 (Friedman) authorizes 6 cities in California, including Oakland, to pilot the use of automated speed enforcement systems. The legislation outlines numerous requirements in order for the City to stand up an automated speed enforcement program, including development of a Use Policy and Impact Report that will need to be vetted and approved by the Privacy Advisory Commission, community engagement, and technical analysis and data collection/evaluation to be compliant with the pilot program. Beyond intial start up resourcing needs, the City will need identify funding to support procurement of automated speed enforcement systems and vendor support for the processing and serving of notices of violation.

Storm Drainage Funding Ballot Measure - amount needed unknown at this timeFunding will be needed in the future for a storm drainage funding ballot measure. A sustainable source of funding is needed to maintain, repaire, and upgrade/improve the City's deteriorating storm drainage network and to comply with stringent, costly, and increasing stormwater quality regulations, some of which require capital improvements to the storm drainage network through trash capture and green stormwater infrastructure. City of Oakland has no stormwater fee to maintain, repair, and improve the City's deteriorating storm drainage system or to fund compliance with the Municipal Regional Stormwater Permit, a National Pollutant Discharge Elimination System permit issued by the San Francisco Bay Regional Water Quality Control Board. The City has very limited dedicated funding for these high priority funding needs.

Sundays in the Redwoods (4)- Partnership or Collaboration Collaborate with Event Promoter to bring culturally diverse concerts to Woodminster Amphitheater and other City parks.

Supplemental Litter & Trash Abatement + Homeless Encampment Clean-Up Contract - $1.5M to $2M per yearA citywide contract for one or more contractors to provide supplemental support with litter & trash abatement and homeless encampment clean-up throughout the City.

The contract will service multiple departments - OPW, EWD, HCD and DOT.

The scope of work consists of abating dumping from City creeks, City lots and other City assets, and City rights of way, especially where cooperation from the unhoused is required.

Page 17 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator Sustainability & Energy Division - US EPA grant The City is jointly applying with East Bay Asian Local Development Corporation (EBALDC) and Healthy Havenscourt for a US Environmental Protection Agency (EPA) Change Grant, to expand the service area for tree planting and additional funding for the Prescott Greening Project in West Oakland. This is a $20 million proposal, staff have applied and expect a determination to be announced 11/16/24.

Sustainability & Resilience Division Bloomberg i-team Through a partnership with Bloomberg Philanthropies, City of Oakland hosts three senior staff from 2024-27 to support black wealth creation within climate solutions. Initial project is Urban Forest Plan implementation in coordination with an $8.5 million grant from the US Forest Service, with a focus on engaging frontline communities, especially African American entreprenuers located along impacted commercial corridors, to help them contract with the City in the implementation of the urban forest plan. The Bloomberg award is valued at $2.5 million for a total combined amount of $10.5 million. Additional programatic funding of $400K expected in Q4 2024.

Targeted Community Outreach To conduct targeted outreach to those communities who don't know about the Whistleblower Program or are disinclined to report.

Tentatively, "10-hr Supplemental Training" 10-hr, supplemental training provided to all sworn personnel to cover relevant, field-based topics or areas of concern such as laws of arrest, arrest and control, critical incident management, and field-based tactics.

Time tracking system (Telestaff Replacement) Replace Telestaff with another system. RFQ has started, we have a vendor in mind. Funding has been identified via grants. Minimal ITD involvement - help with SAML.

Traffic Fatality Rapid Response Program Investigate traffic collisions that result in fatality/severe injury to bicyclists/pedestrians to implement safety improvements.

Trash Cart Pilot Upgrade Program The Trash Cart Pilot Upgrade Program provides residents, on one single trash collection route that crosses Councils District 6 and 7 along International Boulevard, with larger trash containers at no extra cost for three months. The Pilot Program aims to evaluate the impact of larger trash capacity on decrease in trash container overage incidents; reduction of contamination to recycling and organics collections; and decrease of illegal dumping and/or overflowing street litter container abatement requests along and near the collection route.

Two Allocations of $800K ($1.6M total) for FY21-23 and FY23-25Each $800K allocation provided $100K per Council office to identify traffic safety or violence prevention treatments in their district at their discretion.

Update AI 71 (EICRC) Updating laws regarding reproductive rights, cannabis use and employment, also some general updates and clarification around Update City's 504/508 Compliance (ADA) Federal mandate issued in 2023 updating the Rehabilitation Act Section 508 compliance requirements. City must review and update its policies, practices, and associated content and materials (hard print, digital, PDF, etc.) to meet new requirements - e.g. webite maintenance, printed materials, procurement process and associated docs, onboarding new vendors, services, etc. by 2026. Multi-phased approach involving other divisions/depts. Related to CAO.SP16, above.

Upgrade KTOP Live Stream Upgrading local network in master control to enhance streaming capabilites (Cost TBD & paid from Fund PEG 2999)
Urban Forestry Inflation Reduction Act (IRA) grant $8M offered by US Forest Service for street tree maintenance, tree planting, and green job creation in Oakland's frontline communities. Approximately $4M will go to the City, $4M will go to non-profit partners.

Vegetation Management Plan Implementation The Vegetation Management Plan (VMP) is expected to be completed in 2024. This Plan strategizes vegetation management in the Oakland Hills for the sake of fire risk prevention and mitigation. Oakland Public Works will play a role in implementation by managing vegetation and reducing fuel loads on 1,000+ acres of City-owned open space parks and forested land in the high fire risk areas. City positions dedicated to this work, including the Parkland Resources Supervisor position, were downsized over 15 years ago but would need to be restored to achieve implementation.

Violence Prevention Pilot Apply eningeeinr measures to reduce crime/undesirable activies in public ROW.

Page 18 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description City Administrator West Oakland Resiliency Hub Co-located Library, Senior Center, OPRYD and Emergency Services in a robust and flexible building
WIOA - California Volunteers Grant Conservation and beautification Workforce Training Opportunities through public service
Youth Voter Registration Voter approved Measure QQ to create a system that will house voter registration for youth ages 16 & 17 years to vote for OUSD School Board Directors (Cost to be or exceed $500K)
City Auditor
Targeted Community Outreach To conduct targeted outreach to those communities who don't know about the Whistleblower Program or are disinclined to report.

City Clerk
Audio System Upgrade Upgrade Audio System in Hearing Room 1 ($35-$45K from Fund PEG 2999) Document digitalization & Destruction Digitalization & destruction per retention schedule & municode Equipment Replacement Replacing projector in chamber with modernized video wall ($100-$150K from Fund PEG 2999)
Upgrade KTOP Live Stream Upgrading local network in master control to enhance streaming capabilites (Cost TBD & paid from Fund PEG 2999)
Youth Voter Registration Voter approved Measure QQ to create a system that will house voter registration for youth ages 16 & 17 years to vote for OUSD School Board Directors (Cost to be or exceed $500K)
Department of Workplace Employement Standards
AdministraƟve InstrucƟon (AI) on InclusiveProcurement PlanningDWES and DRE are partnering on developing an Administrative Instruction (AI) that lays out various strategies to improve contracting access for small businesses, women-owned businesses, and BIPOCowned businesses, at all stages of the contracting process, from the development of the contracting opportunity, to the close out of the contracting Alternative Project Delivery for Construction OakDOT and OPW will be implementing alternative delivery methods.

DWES participates in the CMGC/Design-Build Working Group that includes the City Attorney's Office on developing AIs for these new methodologies.

Bloomberg Grant The City was awarded a grant for Black Wealth Creation leveraging the City's 5-year Urban Forestry Plan.

Communications Modernization Project to improve external and inter-departmental communicationsDWES is developing new website content for external stakeholders including businesses, workers, and city residents and content for the intranet Sharepoint site to facilitate work with City Departments.

Compliance Modernization Project to improve city department compliance with tools, templates, and standard work and procedures.DWES is improving compliance processes with contracting checklists, improving template language, standard work and tools to analyze local firm availability and compliance, and educational materials for city departments for the intranet Sharepoint site.

DBE Oversight: Ensure compliance with requirements The City of Oakland receives USDOT money with many requirements, including compliance with CFR 49, Part 26. The City of Oakland is not currently following all requirements. Not complying can potentially jeopardize the City's eligibility to receive funding.

Disparity Study - Potential new policy development for procurement.A draft Disparity Study report has been completed and is being reviewed by the City Attorney's Office. Any next steps for race-based procurement would fall within DWES authority to develop/implement.

Implementation of New labor Standards Policies The Council set a goal of considering new Labor Standards Policies for housing and other developments. A resolution was passed requiring the City Administrator to facilitate the process. This creates implementation work that may include: researching standards, benchmarking and comparisons with similar cities, and developing new policies and Implementing software solutions to expedite compliance and payment processes and to provide transparency and accountability for local business participation and local employment goals.DWES is implementing a payment module in B2Gnow to monitor payment to contractors. DWES is implementing Power BI dashboarding to compile and report program measures for L/SLBE certifications and local employment on city-funded projects. DWES will monitor processing times and quality of service and develop performance measures to ensure program and staff level accountability.

Investigations Modernization Project to accelerate timelines for Labor Standards investigations and collectionsDWES will identify and implement best practices for investigations and collections, including technology and procedures for collections.

Ordinance amending certification requirements for the Local/Small Local Business Enterprise (L/SLBE) progrmaOnce amended, DWES will work on operationalizing the changes, including outreach to vendors and new procedures.

Page 19 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Department of Workplace Employement StandardsOrdinance to Establish Construction Workforce Related ReportingCouncil is considering requirements for construction workforce reporting on market-rate and affordable housing construction. If adopted, DWES will work on implementing the collection, storage, and validation of data reported.

Personally Identifiable Information (PII) Security Project to acquire secure transfer tool and develop protocolsDWES receives payroll records for Labor Standards investigations of employers and provides payroll records of city contractors in response to requests under the CA Labor Code. DWES does not have a secure transfer method or internal procedures to
Staff Competency Framework implementation to facilitate responsive and efficient servicesDWES will improve response times and service effectiveness by aligning department performance standards with citywide standards and using the city's objective standards for performance. This will include assessing staff for competencies in software and communications technologies.

Economic & Workforce Development
Administer Revolving Loan Funds Administer Federal Revolving Loan Fund managed by Feed the Hunger Fund, and HUD CDBG $300K RLF managed by Main Street Launch Advance Business Corridor organizing, partnerships and inter-departmental coordination, e.g., Uptown Entertainment District and Night Time Economy Strategy (Interdepartmental); 7th Street Thrives, Hegenberger Corridor, etc.Coordinate with other City Departments, businesses, and other community stakeholders to advance the vision for the Uptown Entertainment District and work to address safety concerns.

Advance Coliseum Complex planning and development agreement negotiations (AASEG)Support PBD on the negotiation of a DA for the anticipated Coliseum Complex project with AASEG, to ensure community benefits and affordable housing. Manage interdepartmental team to review the project.

Advance Entertainment Sector Launch entertainment venue permit; propose new approach to special event festival fund; support improved management of downtown Advance Oakland Roots & Soul temporary stadium 10-year lease of the City/County-owned Malibu parcel to the Oakland Roots for development of a interim stadium
Advance planning for new Police Administration Building Public-private partnership to finance and develop a new police HQ BayTech Career Initiative Implement and administer grant to support Oakland residents enter training and gain employment within IT industry. FY 25-28 Community Response Initiative to Strengthen Emergency Systems (C.R.I.S.E.S) Act Pilot Program Grant and administration of the ambassadors grant.Community safety and mediator program for Downtown and Chinatown.

Administer and coordinate State evaluator of California Department of Social Services CRISES ambassador grant to Family Bridges. Ends August 2026
Complete sale of the Coliseum Complex for $105 million or moreSale to African American Sports & Entertainment Group Develop a business incentive toolbox and attract private-sector investmentPop up incubator pilot Develop Public Art Plan Plan will identifty priority expenditures of public art fund (e.g., geography/demographics - equity focused, etc.)
Develop Remnants/ Small Site Disposition Strategy Develop and initiate a strategy for the disposition of City-owned remnants, sliver parcels, and other small sites not suitable for large scale development in order to generate sales revenue and reduce maintenance and security expenses.

Implement Corridor Safety and Ambassador Program Develop, administer $1.5M corridor safety and ambassador program in FY24-FY25 as workforce development and public safety activity Implement Film Incentive Rebate Program Launch rebate program in the fall; hire for position; monitor impact and explore opportunities for continuing program in FY 25-26 and beyond Manage Hegenberger Corridor Strategic Plan Coordinate economic development and public safety efforts Marine Trade and Water Transportation Initiative Implement and adminster grant to support Oakland residents entering training and employment within marine trade and water transportation industry. FY 25-27
Negotiate Phase II Oakland Ballers agreements for Raimondi ParkExtend and expand existing set of agreements for the next 10 years Prepare/maintain EWDD Emergency COOP Update the "Continuity of Operations Plan" from a "lite" version to a more robust and thorough Plan
Procure new lease tracking platform to improve revenue collectionTo facilitate better monitoring of over 100 leases and licenses, many of which generate General Fund revenue for the City.

Respond to Special Assignments (i.e. Fund 2415 Audit) Analysis of Development Service Fund and associated fees, revenues, positions, etc
Support Bloomberg i-Team Support the workforce development component of i-Teams initiative Support Council District Mural Program Support and oversee mural program in each District where there are funds remaining.

Support the Cultural Strategists program and Creative Economies of Belonging arts jobs programCultural Affairs will coordinate with Evan Bissell, Program Manager CSIG Finance

Page 20 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Finance Citywide Capital Project Management Software with full Oracle IntegrationCitywide Capital Project Management software to consolidate all capital projects in a construction management process and timeline for better tracking, fund management, and project delivery
Citywide Contract Management Software Citywide Contract Management software to manage end to end contracting, with editing, monitoring, insurance, work flows, searchable, and document management.

Comprehensive Financial Policy (CFP) Revisions Complete overhaul of the city financial policies to address best practices, conflicting resolutions, missing scope, enhance financial stewardship, bolster the financial position, and provide long term management tools to enhance credit ratings.

Continuing Disclosure, Post Issuance, and Financial Management Accountability Guidelines and TrainingComprehensive training plans and documentation to ensure compliance with IRS standards, SEC guidelines, and California bond law for bond fund management. Enhance executive team knowledge of fiduciary responsibility in departmental management.

Cultural Agencies (Chabot, OMCA, Fairyland) Infrastructure Ballot MeasureCitizen initiative to provide a ballot measure for the cultural nonprofit agencies housed in deteriorating City facilities. Enhance the cultural art experience and bring increased patronage.

Depository and Custodial Bank Implementation Solicit new Bank Depository for citywide banking needs, adding additional services to fully service the needs of the organization and requests from City Council for enhanced services
EIFD Implementation Create two different tax increment districts to promote affordable housing in west Oakland and enhanced development around the Coliseum Grant Management Software Integration New grant management software used to apply for and management grant funds, create a portal to manage grant recipients for grants provided by the City to outside entities. Oracle integrated for real time funding knowledge and management.

Oracle Cloud Conversion and Enhancement Convert Oracle Financial System to be web hosted to provide a stable platform from which to make system enhancements that provide the basic functionality of a modern ERP system
Payroll Processing Reform Comprehensively streamline payroll processing for basic compliance in the absence of Oracle systematic improvements to gain regulatory compliance with all agencies. This includes personnel reorganization to a citywide centralization of all payroll functions into Finance Department, training manuals and comprehensive mandatory training plans, and updated Administrative Instructions
POS Implementation Implement a new system that serves as a citywide cashiering system, to streamline credit card payments, remote deposits, cash management and cash reporting in decentralized departments
Public Bank of the East Bay Create a public bank in the East Bay to provide banking for the unbanked and low income individuals that are unable to secure lending from mainstream lending institutions. The bank would be created using only public funds from the City of Oakland , County of Alameda, City of Richmond, and City of Berkeley.

Public Safety Infrastructure Bond Ballot Measure Develop an infrastructure ballot measure that solely supports public safety buildings and or infrastructure, to fund the replacement / rehab of fire stations and the Police Administration building
Purchasing and Contracting Reform Comprehensively streamline procurement processing for basic compliance in the absence of Oracle systematic improvements to gain regulatory compliance with all agencies. This includes personnel reorganization to centralized procurement in the Finance Department, Risk Management Division transfer, contract template and RFP overhaul, comprehensive training plan, City Council Policy recommendations for OMC changes, and updated Administrative Instructions
Staff to JPA Staff to Joint Powers Agency - Fully Reimbursable Housing Community Development
Community Development & Engagement Funds, monitors and reports CDBG and other federal grants that fund services and projects that predominantly benefit low- and moderate- income residents of Oakland. Administers community engagement activities that informs Oakland residents and collects Oakland residents’ feedback. *ask managers to go in, add, review policy and research

Page 21 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Housing Community DevelopmentAdministration & Grant Management Monitors department budget, pays vendors, prepares reports, and manages various grant programs.

Affordable Housing Asset Monitoring Monitors City's existing affordable housing properties with City affordability restrictions and property conditions. Ensures that properties are in compliance with all agreements and requirements.

Affordable Housing New Construction Loan Servicing Underwrites, reviews, and administers loans for proposed affordable housing developments for Oakland residents.

Affordable Housing Preservation Loan Servicing Underwrites, reviews, and administers loans to preserve existing affordable housing units for Oakland residents
Bay Area Housing Finance Authority (BAHFA) 2024 Bond Public Engagement and Expenditure PlanningIn anticipation of a regional housing bond worth either $10 billion or $20 billion, Oakland HCD will lead community engagement and expenditure planning for its allocation. BAHFA requires each jurisdiction receiving a direct allocation to adopt an expenditure plan no sooner than February 1, 2025; community engagement will take place throughout 2024, and if the bond passes in November '24, final edits to the expenditure plan will occur.

HCD staff will lead public engagement, bond projection impact modeling, expenditure plan drafting, and more.

Code Compliance & Relocation Program Reviews applications on tenant eligibility for relocation benefits in accordance with O.M.C. 15.60 and determines if City payment is appropriate. Assists tenants and property owners in understanding their rights and responsibilities under the law.

Data Collection & Analysis Develops various databases to collect data on evictions, rents, petitions and hearings, etc., to inform public policy and internal program design and improvements.

Emergency Home Repair & Home Maintenance and Improvement Loan ProgramsProvides Oakland's low-to-moderate income, senior and disabled homeowners with 0-3% interest bearing loans for home repair and rehabilitation from $15,000 to $150,000 to homeowners that require immediate attention to correct health and safety repairs, life-threatening hazards, and exterior appearance if blighted.

Fair Chance Access to Housing Prepares informative materials that provide information and guidance on Fair Chance Access to Housing. Manages contract with East Bay Community Law Center to provide legal assistance to tenants. Coordinates with Just Cities which performs community outreach to vulnerable communities.

First-time Homebuyer Loan Program Provides loan funding to first-time homebuyer Oakland residents and workers and creates homebuyer education activities.

Grants for Earthquake Seismic Retrofitting of Apartment BuildingsThe Safer Housing for Oakland Program (SHOP) offers grants to reimburse owners for a portion of the costs to seismically retrofit a multi-unit apartment building with a “soft-story” condition. The Earthquake-Safe Homes Program offers grants to owner-occupants of 1-4 unit properties for partial reimbursement of the cost of a seismic retrofit.

Homelessness Prevention Pilot Program In FY22-23, Oakland HCD provided $2.3 million for a pilot program to prevent homelessness for the most at-risk Oaklanders. Oakland HCD is collaborating with researchers at Stanford University and the University of Pennsylvannia to study the effectiveness of the service interventions. The program, focused on wrap-around services and shallow subsidies, is executed by a collaborative of community organizations under the Keep People/Oakland Housed umbrella of Bay Area Community Services (BACS).

The program is serving 300 residents in its first year with the hope of demonstrating substantial impact in preventing homelessness in order to continue in future years.

Housing Protection Services Provide services in the form of eviction protection and homeless prevention via service providers to Oakland tenants at risk of displacement or homelessness. Includes legal assistance, emergency rental payments and wrap around services.

Housing Resource Center Supports via phone calls and emails residents seeking housing services and information.

Page 22 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Housing Community DevelopmentImplementation of Rapid Response Homeless Housing loan programThe City Council’s biannual 2023 – 2025 budget established a Rapid Response Homeless Housing Fund in the amount of $10,400,740. The City is adding another $19,667,562 in Permanent Local Housing Allocation funds, as well as $10 million in outstanding Homekey Round 3 commitments for a total of over $40 million. To implement the deployment of these funds in a manner that is expeditious and effective in addressing homelessness, staff created the Rapid Response Homeless Housing (R2H2) Program, modeled on the success of the Homekey program. The City Council adopted this program at its November 7, 2023 meeting, and the initial RFP was due February 29, 2024. Staff will evaluate proposals and work to administer the funds + loans throughout 2024 and beyond.

Lead-Safe Paint and Access Improvement Grant Programs The Lead Safe Housing Paint Program provides grants from $15,000 to $24,000 for exterior painting and lead hazard remediation. The Access Improvement Program provides grants from $15,000 to $24,000 for accessibility improvements to both rental property and property owned and occupied by disabled persons.

Loan Servicing Underwrites, reviews, and administers loan applications for the purpose of repayment and subordination requests, including commercial, residential and rehabilitation grants and loans.

Minor Home Repair Program The MHRP grant program provides financial assistance for home repairs up to $2,499 to correct immediate threats to the health and safety of low-income homeowners in Oakland. Single unit residences, including mobile homes are eligible. This grant can be used to make minor plumbing, carpentry, electrical repairs and can be used for railing grab bars, toilets, water heaters, doors, locks and more.

New Construction of Affordable Housing - Pipeline Project FundingThe 2023 new construction NOFA cycle left over $120 million in unfunded requests for support. Oakland HCD staff convened affordable housing staff from peer cities around the Bay Area to learn about their funding approaches and better understand best practices in the field. Staff learned that every other jurisdiction releases a NOFA specific to its pipeline projects in between notices for new projects. In February 2024, Oakland HCD attained approval from city council to focus its next NOFA solely on (partially or completely) unfunded affordable housing projects in its pipeline. With council approval, Oakland HCD will administer $22 million for its outstanding projects in advance of a NOFA for new projects later in 2024.

Partnership with Community Development Financial Institutions (CDFI) to increase scale of acquisition/rehabilitation/conversion to affordable housing programOakland HCD's current Acquisition and Conversion to Affordable Housing (ACAH) preservation program releases NOFAs once per year, or biannually.

This time frame does not meet the needs of preservation practitioners in Oakland, as they need subsidy and support quickly in order to acquire buildings on the market. To respond to our partners' and the market's concerns, Oakland HCD is pursuing collaboration with CDFIs that will leverage outside funds and allow developers to acquire properties much more quickly than the city process alone would allow. Such a partnership will allow many more properties to be acquired and made affordable (through deed restrictions) for years to come.

Policy Advocacy Provides research and advocacy services to further the City's affordable housing goals
Predevelopment loan program revamp Oakland HCD's current predevelopment loan program offers up to $50k for developers to support their construction work in its early stages. Staff research demonstrates that $50k is far below the amount needed to adequately support developers in their work; thus, staff is examining the existing program and proposing changes that, if council-approved, will increase accessibility and assistance in meaningful ways. There will also likely be unique incentives to support BIPOC and/or emerging developers to increase equity in contracting.

Page 23 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Housing Community DevelopmentProtection Services Strategic Action Plan Oakland HCD's 2023-2027 Strategic Action Plan, produced in spring 2023, focuses primarily on the use of its capital dollars for housing production and preservation. To complement this effort, staff is developing an addendum for the allocation of its service dollars focused on anti-displacement, homelessness prevention, eviction defense, and more. The action plan will include an equity framework that prioritizes how Oakland HCD will administer its service dollars (e.g. CDBG) with a racial equity lens.

Rent Adjustment Program (RAP): Community Engagement and Public EducationPrepares materials that provide information and guidance on rent and eviction laws at local, state and federal levels to educate public about their rights and responsibilities under these laws. Engages in extensive public outreach to disseminate this information.

Rent Adjustment Program (RAP): Housing Counseling and HearingsProvides holistic counseling to tenants and property owners regarding RAP laws, including just cause for eviction and eviction moratorium. Reviews petitions, hears cases, renders decisions, reviews appeals, coordinates appeal hearings before Rent Board.

Human Resources
City-Wide Compensation Study Council granted $250k to HRM to review the compensation for all classifications.

HRM Equity Change Initiatives / Equity Team Staff from the HR department meet monthly to coordinate and take action on Racial Equity Initiatives that impact the policies and processes, recruitment and hiring and performance standards of city employees.

Job Fairs Council granted HRM $50k to support job fairs.

Oakland ROCKs HR manages the budget and staffs the committee represented by various city departments. The committee focuses on staff morale building, recognition, and celebration of civic pride in Oakland.

Peacemakers Internal Mediation Program One time funding was used to train and certify staff as mediators to manage low level conflict to reduce the cost impact of utilizing an outside mediator through EAP. This ongoing program continues to result in cosst savings without any further expense to the city.

Reforming HRM Processes Council granted HRM $250k to review HRM processess and implement improvements, where they are identified.

Human Services
A&AS: Strategic Plan Strategic planning to update the WHO Age-Friendly 5-Year Plan that expired in 2023 to retain designation.

AC-OCAP: CAP Plan AC-OCAP: Strategic planning to be in compliance with CSBG bi-annual requirements
AC-OCAP: Community Needs Assessment AC-OCAP: CNA is prepared documenting the demographics of the areas that are served by the recipients of the CSBG grant.

AC-OCAP: Strategic Plan Update AC-OCAP: Strategic planning to be in compliance with CSBG Organizational Standards requirements
Adults & Aging Services: Senior Communication Portal Senior Communication Portal CHS: Referral phone number for emergency shelter CHS: Establish an Oakland-wide referral line for emergency shelter CYS: OFCY 3-year Strategic Plan OFCY is required (Ordinance Ordinance No. 13588 C.M.S.) to develop a 3- year Strategic Plan that will outline funding allocations, funding priorities, goals and strategies that will inform the competitive bid process and RFP for the next 3-year funding cycle.

CYS: OFCY Independent Evaluation(s) FY 22-23; FY 23-24; FY 24-25OFCY is required (Ordinance No. 13588 C.M.S.) to conduct an independent annual evaluation of OFCY funded programs.

CYS: Oakland Youth Participatory Action Research - youth-led (YPAR);OYC YPAR to advance youth agency and voice to inform the Community Needs Assessment. Commissioner are trained as research fellows to develop survey instruments, conduct surveys and focus groups, compile, analyze and develop findings and recommendations to inform strategy development for the planned OFCY RFP. Initial funding provide by Mayor Schaff. Currently funded by OFCY to inform planned OFCY RFP Release. RFP release for a new contractor is underway for phase 2 & 3 implementation CYS: OFCY Community Needs Assessment OFCY is required (Ordinance Ordinance No. 13588 C.M.S.) to conduct a community needs assessment every 3 years to identify current community conditions and needs of children, youth and their families to inform the development of the OFCY 3-year Strategic Plan.

Early Childhood & Family Services National League of Cities: Early Learning Nation Cohort

Page 24 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Human Services Oakland Thrives/Youth Ventures Joint Powers Authority, and other Community Grants as awardedContract execution and management of the annual contribution to JPA (Joint Powers Authority), and other Community Grants as awarded OUSD Central Kitchen The Oakland Unified School District (OUSD) Central Kitchen is a vital community hub that prepares nutritious meals for students across Oakland.

It also supports school gardens, where students learn about food and agriculture, and offers internships and educational opportunities in collaboration with Laney College. Supporting this program with Sugar Sweetened Beverage Tax Funds reinforces the importance of providing healthy meals and food education to Oakland's diverse youth, with 89% of students coming from communities of color. Continued support for this project ensures that Oakland's students have access to fresh, healthy food and hands-on learning experiences, which are critical for both their health and education.

SABA Grocers Healthy Foods Initiative The Saba Grocers Initiative, funded with $2 million from the City Council, aims to improve access to healthy food in underserved Oakland neighborhoods. It provides food cards to low-income families and installs refrigerators in community corner stores to ensure fresh produce and perishables are available. This program seeks to enhance food security and promote healthier eating choices in the city.

SSB Community Health Fair The Sugar-Sweetened Beverage (SSB) Community Health Fair is a lively event that highlights the achievements of SSB grant recipients in promoting healthier lifestyles. It brings together programs focused on nutrition education, fitness, and advocacy, offering attendees a chance to learn about and engage with these initiatives. The fair features interactive booths, giveaways like bicycles, and activities such as games and dance performances, all designed to foster community engagement and encourage healthier choices.

Information Technology
Asset Inventory and Computer Management System Implement comprehensive system to monitor, track, secure, and maintain computer inventory citywide.

Citywide Custom Applications Functional Enhancements Working through Custom Appliction development to take in requests for new apps and upgraded functionality supporting staff and hte public.

Citywide georgraphic infromation systems Enhancements Working through GIS development to take in requests for new apps and upgraded functionality supporting staff and hte public.

Citywide Managed Printing Moderinze, consolidate and refresh the City's aging copier fleet with secure, energy efficient and reliable equipment.

Citywide Permitting System Functional Enhancements Working through Citywide Permitting Governance, a cross-departmental effort to enhance, modernize and make permitting applications accessible to residents and businesses in Oakland.

Citywide public safety radio systems upgrades and improvementsWorking through public safety intake requests for new services, replacements, enhancements, features for public safety radio systems and technology
Cybersecurity and Resiliency Efforts In process: proposed reductions to the cybersecurity funding ITD was allocated in the biennial budget (including funding directed for staff enhancement in security) will directly impact the work the Department is doing to modernize, strengthen and fortify the network City staff and residents depend on for services.

Cybersecurity Risk Assessment & Resiliancy (NIST) Full assessement of the City's cybersecurity environment with recommendations
Data Center Infrastructure Upgrade & Consolidation Consolidating storage, adding redundancy, resiliency and enhanced security for the network
Electronic Cashiering System Upgrade with Oracle Cloud IntegrationReplace aging point of sale system with modern, cloud-based electronic cashiering solution for use Citywide.

Internet MigraƟon[REMOVED; Comms Project w/ITD Contract Support]The City's current website is no longer supported. Project covers migrating and updating the City internet pages and enhancing core functionality for all website users.

Page 25 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Information Technology Intranet Restoration Migration and updating City intranet pages; moving all content from old OakNet News site to SharePoint and closing the former site which has experienced broken/unusable links and content post-ransomware Measure U Measure U provides funding to expand broadband connectivity to Oakland residents via affordable housing units.

Network Infrastructure Upgrade Upgrading network infrastructure for reliability and enhanced security Oakland Broadband Initiative Extending broadband access in historically underserved areas of Oakland, inlcuding affordable housing and local businesses. Award accepted 9-30- 2024; project start date TBD.

OPD DOJ Security Policy Compliance Enhanced multifactor authentication for OPD to comply with updated DOJ policy.

Oracle Cloud Upgrade Maintenance & Improvements Assess, scope, and implement ongoing improvements to the City's Oracle Enterprise Business Suite system for citywide finance and personnel management.

Public Safety Technology Upgrades Upgrade computers, Wi-Fi, consoles and more to improve public safety technology operations.

Public Safety: OPD Computer Aided Dispatch Replace end-of-life process, platform and equipment to upgrade the City's emergency computer-aided dispatch system.

Public Safety: OPD Records Management System Replace end-of-life process, platform and equipment to upgrade the City's public safety records management system.

ServiceNow Study and System Functionality Enhancements Not started: Examining possible solutions to enhance City services; capitalizing on the existing ServiceNow platform
Library
Capital Project - 81st Ave Library Solar Panels Ensure that 81st Ave will have a redundant power source during PSPS Capital Project - AAMLO Renovation and Restoration Electrical, windows and building system repairs to African American Museum and Library at Oakland
Capital Project - Brookfield Library Renovation of Brookfield Library Capital Project - Main Library Renovation Electrical, floor and building system repairs to the Main Library Capital Project - Melrose Renovation and Restoration Electrical, floor and building system repairs to Melrose Library Capital Project - MLK Jr. Library Bike Repair Program Space Container facility in the parking lot of MLK Jr. library for bike programs Capital Project - Thermal and Ventilation Improvements at all LibrariesEnsure that all libraries can serve as respite centers for emergencies Capital Project - Tool Lending Library Expansion Container facility behind the Temescal Library for expanded tool lending Feasibilty Study - Hoover Durant Library New library in the Hoover Durant neighborhood Feasiblity Study - Main Library New or significantly renovated Main Library West Oakland Resiliency Hub Co-located Library, Senior Center, OPRYD and Emergency Services in a robust and flexible building
Parks and Recreation and Youth Development
Fee Study OPRYD has hundreds of fees that have not been assessed. The department will enter into an agreement with a consultant to conduct in-depth market research on OPRYD program and service fees. This research will provide the foundation for informed modifications to the City of Oakland's Master Fee Schedule. Many of the department's fees are currently far below market rates. A potential outcome of this study is an increase in revenue generated through fee-based programs and services.

Oakland Ballers at Raimondi Park/Fields In response to a proposal from the Oakland Ballers, OPRYD plans to collaborate with various departments to thoroughly evaluate the proposal and explore the development of an agreement that builds on the Ballers' current investments in Raimondi Park & Fields. The Ballers have expressed a strong interest in continuing to operate and manage the park, including overseeing its ongoing maintenance and improvements. A key requirement for moving forward will be ensuring that the Ballers conduct extensive community outreach, with a focus on engaging current users of the space.

This process will assess potential impacts—both positive and challenging—before any agreement is finalized.

Page 26 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Parks and Recreation and Youth DevelopmentOakland Parks System Master Plan The City of Oakland Parks System Master Plan is a long-term, visionary blueprint designed to guide the future development, maintenance, and management of Oakland’s parks and recreational spaces. This plan will assess current park conditions, identify gaps in access and amenities, and prioritize investments to enhance equity, sustainability, and community engagement. Through inclusive public input and collaboration with stakeholders, the Master Plan aims to create a cohesive, accessible, and resilient park system that meets the diverse needs of Oakland’s residents, while preserving natural resources and promoting recreational opportunities for future generations.

OPRYD Fellows The Oakland Parks, Recreation, & Youth Development (OPRYD) Fellows Project is designed to leverage the talents of local graduate students to strengthen the department's operational capacity. The project will focus on critical initiatives such as the Fee Study, where fellows will conduct research and analysis to provide foundational work for staff in preparing a comprehensive report for the City Council as part of the Master Fee process.

OPRYD Strategic Plan The Strategic Plan for OPRYD serves as a comprehensive roadmap designed to guide the department's priorities, programs, and initiatives over the next five years. This plan focuses on enhancing park access, improving recreational facilities, and expanding youth development opportunities across Oakland. By aligning with community needs and citywide goals, the Strategic Plan aims to foster equity, sustainability, and resilience in OPRYD services. Through strategic partnerships, data-driven decisions, and community engagement, the plan will ensure effective resource allocation, elevate program quality, and enhance the overall well-being of Oakland residence.

Project Name: Historical Assets Preservation and Maintenance PlanProject description: OPRYD oversees multiple historical assets (including but not limited to Camron-Stanford House, Dunsmuir Hellman Historical Estate, Mosswood Moss House, Edoff Memorial Bandstand, Woodminster Ampitheatre) whose age and historical significance require the need for regular and occasionally specialized maintenance and preservation efforts and security. OPRYD will collaborate with internal OPRYD divisions as well as external partners that include OPL, OMCA and ACOE to 1) develop a policy for engaging the public at historic assets; and 2) to develop strategic plans and policies that include: City funding; grants applications and administration; maintentance and restoration plans; facilities management; community outreach and public benefit provision; and racial equity alignment.

Request For Proposal Oak Port Field The City is seeking proposals to lease and maintain the Property for activities, programs and operations in accordance with OPYRD’s objectives, zoning and the Deed. Each proposal should reflect the City's goal to have an operator who provides a high level of service to the public while leasing the Property and who provides related activities, in a fiscally responsible manner, that preserve and improve the Property as a resource for the benefit of the community.

Planning & Building
AB617/CERP for East Oakland AB617 California's Community Emissions Redcution Plan (CERP) for East Oakland, Staff attends regular meetings on the steering committee AB617/WOCAP Implementation AB617 West Oakland Community Action Plan Implementation, staff attends regular meetings with the community on progress of implementation of the plan
DOSP Implementation DOSP Implementation, as part of the implementation create a community advisory group to give input on the implementaiton.

EJ Element: Form an interagency air pollution working group to implement air pollution actions implemented in the EJ Element - Council Amendment to the Resolution adopting EJ, Safety Elements.Working with the City Administration's efforts to organize and develop an interagency working group as an added action to the EJ Element from City Council Resolution
EJ-A.11 Work with OakDOT and Oakland Sustainability program to develop a zero emission Medium Heavy Duty Fleets Vehicle Charging Overlay Zone.EJ-A.11 Work with OakDOT and Oakland Sustainability program to develop a zero emission Medium Heavy Duty Fleets Vehicle Charging Overlay Zone.

Page 27 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Planning & Building Environmental Justice Element Implementaion Environmental Justice Element Implementaion monitoring General Plan Update Phase 2 General Plan Update Phase 2, includes Land Use and Transportation Element; Open Space, Conservation, and Recreation Element; Nosie Element; and Infrastructure Element
HE 2.1.5 Implement Universal Design Strategies The City will consider adopting a Universal Design Ordinance to address housing needs and improve housing conditions for seniors, people experiencing disabilities, and other communities with accessibility issues.

HE 2.2.7 TDR for SROs Consider allowing owners of residential hotels that agree to restrict occupancy to lowerincome residents to transfer development rights to create an endowed source of funding for an internal subsidy for such residents, or for maintenance/ facility upgrades that do not increase rents.

HE 3.2.6 Monitor affordability of permitted ADUs Conduct ADU survey Q1 2024 - done 2nd ADU survey 2026
HE 3.3.15 Continue & Expand Density Bonus Incentives To ensure that the Chapter 17.107 remains compliant with state law, and to solicit additional ideas for incentives and expansion of the density bonus program, the City will review the density bonus program mid-cycle, bring necessary amendments to conform to state law, and solicit feedback from Planning Commission and City Council on additional incentives that could be included in the local density bonus program.

HE 3.3.19 Sites Inventory, Pipeline Projects, and Fair Housing Accomplishments Tracking Program2027 audit of Housing Element and potential rezoing if needed Housing Element Implementation Housing Element Implementation monitoring Local Hazard Mitigation Plan Fire Department is the lead on this project, but Strategic Planning assists.

This has to be updated every 5 years.

MTC Transit-Oriented Communities (TOC) Policy RequirementsTransit-Oriented Communities (TOC) Policy, Plannning Code and Zoning map amendments needed to meet MTC adopted TOC requirements for density, parking, etc. in areas near transit.

Oakland Alameda Adaptation Committee SAF-A.23 By 2025, conduct a regional and citywide community engagement effort to determine planning thresholds and appropriate sea level rise mitigation strategies. PBD along with Sustainability coordinating with City of Alameda and Port of Oakland
Oakland Building Construction Code Recommend local amendments to the CA Model Building Codes Proactive Rental Inspection Program/ Equitable Lead Hazard Abatement ProgramProactive Rental Inspection Program and Equitable Lead Hazard Abatement Program of rental units in the City of Oakland
SAF-A.13 Adopt an ordinance requiring local development standards to meet or exceed SRA Fire Safe Regulations and Fire Hazard Reduction Around Buildings and Structures RegulationsSAF-A.13 Adopt an ordinance requiring local development standards to meet or exceed SRA Fire Safe Regulations and Fire Hazard Reduction Around Buildings and Structures Regulations in the SRA and VHFHSZ. Ensure all new development and/or redevelopment in the SRA, LRA, and VHFHSZ meets or exceeds the California Fire Code (CFC), California Building Code (CBC), and Board of Forestry and Fire Protection Fire Safe Regulations.

SAF-A.17 Ensure that new construction and major improvements to existing structures within flood zones are in compliance with federal requirementsSAF-A.17 Ensure that new construction and major improvements to existing structures within flood zones are in compliance with federal requirements and, thus, remain a participant in the National Flood Insurance Program (NFIP)
Safety Element Implementation Safety Element Implementation monitoring Short Term Rental Short Term Rental
Police
2025-2027 Strategic Plan Schedule interviews with all major bureaus, divisions, and sections to ascertain their workflows, the role technology currently plays, pinpoints, and potential technology solutions to address those pinpoints. The ultimate goal is to have a functional OPD ITU Strategic Plan for fiscal years 2025- 911 Communication: Artificial Intelligence Utilize artificial intelligence to triage, route and answer incoming non- emergency calls to provide accurate and expeditious service to our community members
Add electrical outlets to Cover Lot Installation of electrical outlets in Covert lot to charge vehicles. Minimal ITD involvement.

Area 5: Hegenberger / 98th Ave. Burglary overtime suppression.Operation detailing : an average of 4 officers, per 10 hours for 7 days of week to ensure safe in special locations for Area 5

Page 28 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Police Asset Management System Implement an asset management system so we can track militarized equipment use, radios, computer equipment, etc. We are currently doing an RFQ. Funding has been identified via a grant. ITD involvement should be minimal - maybe help with SAML.

BWC Analysis Work with Motorola to provide three years worth of video data to Stanford University for Analysis. ITD involvement should be minimal - Axon will handle the work of setting up secure environments that follow CJIS CAD to LRMS Implementation Upgrade our current CAD system to Premier One and connect it to LRMS.

Major project.

CCTV camera upgrade CCTV camera installation in PAB covert lot. Minimal ITD involvement.

CJIS MFA/Security Upgrade Review current security protocols and ensure that they meet new CJIS requirements. Medium to large project. ITD is currently doing an internal system analysis.

Communications Building Access Software & Keycards Need to restore the ability for Communications to be able to manage access to their building via keycards. Medium project.

Data visualization services on PowerBI, starting with the Weekly Crime ReportsThis is a complicated project that requires all crime analysis services to be realigned and reconnected to a new records database. In the run up to the new database, the sections will be using various flat datafiles to develop data visualization projects in PowerBI. We will integrate these standalone projects the new database when it is launched.

Dejaview Upgrade ITD to upgrade Dejaview to the newest version.

Develop a new comprehensive plan for training Research a series of trainings that will expand and evolve the crime analysis experience. Work with the Training Division and budgeting to find funds for the trainings. Schedule analysts in rotation for each training, until all analysts have completed all trainings.

Division Level Investigation (DLI) Administrative task for the internal policies or procedures DNA Investigator kits DNA analysis requires expensive kits Draeger DT5000 supplies DUI investigation equipment for drugs from Oral fluid to augment breath alcohol testing
Emergency Communications Center (ECC) The 911 Communications Division is a complex Public Safety Answering Point (PSAP) for the City of Oakland, handling incoming emergency policy, fire and medical calls and text messages as well as non-emergency calls.

Communications operates 24 hours a day, 7 days a week. Our dispatchers are POST-certified and they answer, triage, and route incoming emergency and non-emergency calls, dispatch officers and civilian technicians on the radio and perform administrative duties pertaining to the operations in the field. Our professional staff responds to Public Records Requests by providing responsive dispatch/phone audio and transcripts, prepare certified court documents and testify in court.

FaSTR Annual Licenses DNA mixture analysis software
First Watch Data Sharing Integrate First Watch into Premier One CAD so that certain pieces of information can be shared with other agencies and other agencies are able to share alerts with OPD. Minimal ITD involvement.

Fix CarFax Implementation Fix the connection between OPD and Carfax on traffic data - ITD established this in the past and it has been broken since the ransomware attack.

Minimal work needed, just re-establishing a connection.

Flock ALPR Installation of cameras will be handled by Flock. User Administration will be handled by OPD, there should be minimal ITD work.

Foray ID Unit to register sex offenders, PETs for scene photos and Crime Lab all use svc for latent prints. Upgrades the system to the cloud Geoanalysis to ArcGIS Pro This project involves a complex undertaking wherein all crime analysis services will undergo realignment and integration with a new records database. As part of the transition to the new database, the sections will utilize the new geospatial program ArcGIS Pro to create and refine new products and services. Our next steps involve scoping out a new data feed and integration service, establishing the necessary contractual relationship, conducting thorough testing, and ultimately launching the new system.

Human Trafficking Operations Operations to rescue Juveniles and arrest Offenders of Human Trafficking along International Boulevard

Page 29 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Police Implement a new RMS system Need to identify a new records management system to implement so OPD can adhere to the NIBRS standard. Major project.

Incoming Chief Goals and expectations The crime analysts provide the framework for the Monday 11am crime meeting, including verbal presentations, expansive analytical reports with commentary, and material for presentation at the meeting itself.

Integrate Crime Analysis Services with new Records database system (Mark43)This is a complicated project that requires all crime analysis services to be realigned and reconnected to a new records database. The completion of this project will open new avenues to report creation and other data and geospatial projects.

Lake Merritt Violence Suppression During the summer months into the fall months, Lake Merritt requires additional police service, traffic control, vendor regulation and special event permitting. OPD works with DOT, Parks and Rec, City Administrator's Office, Nest and Lakeshore/Lake Merritt Work Group to provide holistic service.

Law Enforcement Background Investigation Cloud Based SoftwareSoftware that allows the unit to conduct background investigations in a cloud based system. Eliminates the need for manual processes and file storage.

MatchPoint (IBIS) system and service contract Entry of firearm/cartridge case evidence to database for associating violent gun crime scenes
Mobile ID Restart project Obtain New Mobile ID readers from ACSO as well as upgrade software with the help of ITD. Roll out system to patrol. Minimal ITD involvement.

National Testing Network Administers required written test for Police Officer Trainee position.

Organize a tiered section, with additional job descriptions, interns, and room for advancement and promotionDevelop job descriptions to accommodate a tiered positions system in the Crime Analysis section, including provision for at least two interns. Work with the unions, and various city department to get the job descriptions approved. Second, work with budgeting, OPD HR, the OPD executive team, and City Council to bring the new positions and CAU origination into reality.

Pre-Employment Credit Checks Contract for 4 years: California Peace Officer Standards and Training (POST) requires pre-employment psychological screenings. The department also requires pre-employment credit checks for all positions. The checks are used as an investigative tool to gauge applicant's ability to confront and overcome problems, obstacles and adversity, which is a California POST hiring dimension.

Pre-Employment Department of Justice LiveScan Contract for 4 years: California Peace Officer Standards and Training (POST) requires a criminal history check. The department also requires pre- employment criminal checks to determine applicant suitability to meet job requirements.

Pre-Employment Investigative Polygraph Examinations (Police Officer Trainee & Dispatcher Applicants)4 year contract totaling $800,000. The unit requires the services of several polygraph service vendors to meet the hiring demands for Police Officer Trainee and Dispatcher applicants. Polygraph examinations are a pre- employment background investigation tool that assists with gathering background information and verifying the accuracy of the information provided by applicants.

Pre-Employment Medical Examinations (Police Officer Trainee & Dispatcher Applicants)Contract for 4 years: California Peace Officer Standards and Training (POST) requires pre-employment medical examinations. Commission Regulation 1953 includes the requirements for conducting peace officer background investigations. The peace officer medical and psychological evaluation requirements are outlined in Regulations 1954 and 1955. Commission Regulations 1956-1960 contain the selection standards for public safety dispatchers. Medical examinations determine applicant's physical suitability to meet job requirements.

Pre-Employment Psychological Exams Contract for 4 years: California Peace Officer Standards and Training (POST) requires pre-employment psychological screenings. Commission Regulation 1953 includes the requirements for conducting peace officer background investigations. The peace officer medical and psychological evaluation requirements are outlined in Regulations 1954 and 1955. Commission Regulations 1956-1960 contain the selection standards for public safety dispatchers. Medical examinations determine applicant psychological suitability to meet job requirements.

Radio Encryption Encrypt patrol channels 1 through 5, in addition to others suggested by Radio. Medium project.

Page 30 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Police Recruitment Advertising & Promotion Advertise various law enforcement positions available with an emphasis on Police Officer Trainee and Dispatcher positions. Advertising may include print, display, paid search, broadcast, and social media.

REMI Service contract provider for DNA, Firearms, Latent Print and Drug Analysis equipment in the laboratory
Replace Interview Rooms Need to replace six interview rooms in the PAB with new hardware/software. This upgrade will allow us to upload video directly to Evidence.com. Minimal ITD involvement - opening ports and some Telco, Axon will handle most of the installation work.

Replace PAB Auditorium Screen Replace PAB Auditorium AV equipment that’s bad (Screen). Minimal ITD involvement.

Saigon and Lakeshore Violence Suppression Robbery/Burglary suppression in Area 3 Business Districts STRMix licenses DNA interpretation software
Tentatively, "10-hr Supplemental Training" 10-hr, supplemental training provided to all sworn personnel to cover relevant, field-based topics or areas of concern such as laws of arrest, arrest and control, critical incident management, and field-based tactics.

Time tracking system (Telestaff Replacement) Replace Telestaff with another system. RFQ has started, we have a vendor in mind. Funding has been identified via grants. Minimal ITD involvement - help with SAML.

Police Commission - CPRA
CPRA Mediation Program Establishment of CPRA program to mediate certain complaints CPRA to IAD Transition Transition of responsibilities from OPD Internal Affairs to CPRA CPRA Workflow Improvement Process Assess and improve the efficiency of CPRA's web application for case management
Police Commission - Inspector General
Police Performance Auditing Conduct audits, evaluations, inspections of OPD and CPRA as required of the OIG, and the NSA
Police Staffing Study CPO #2024007954 Staffing study to assess OPD sworn and civilian staff as well as resource allocations to optimize public safety resources
Public Ethics
Haas JR (blank)
Public Works
OPW Trainee Academy Safety and Training created a program to advance youth and young adult employment in the City. This program targets residents between the age of 18-30 who have historically been marginalized, disenfranchised and oppressed with a place of study or training in a special field for success with greater than living wage employment.
555 Hegenberger Road Leaking Underground Storage Tank - Site Investigation, Remediation, & ManagementThis is a former City-operated maintenance yard that is currently owned by the California Department of Transportation. Due to the City’s past operations on site, the Alameda County Department of Environmental Health (ACDEH) has identified both the City and Caltrans as parties responsible for addressing the subsurface petroleum hydrocarbon contamination caused by historic underground fuel storage tanks that leaked.
710 & 728 73rd Avenue PCB Contamination Related to the PCB Contamination in Arroyo Viejo Creek project, investigation and remediation of PCBs present on the upland properties of 710 and 728 73rd Avenue is currently under regulatory oversight. However, the City is currently voluntarily cooperating without a cleanup order. Staff estimates the cost to characterize the site, develop a remedial action plan, and implement remediation and related reporting to be approximately $810,000 over the next two years.

Page 31 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Public Works Alleviate Flooding on High Street between Wattling Street and Railroad Tracks and Improve Storm Drainage on High Street from Wattling to Tidewater AvenueHigh Street Flood control storm drainage system improvements needed to prevent flooding between Wattling Street and the United Pacific Railroad tracks, adjacent 809 High Street. Extensive street flooding in this area covers the sidewalk and impacts private property. High Street in this location serves Higher and Medium Priority Equity Neighborhoods and a Highest Priority Neighborhood to the northeast. The buildings at 809 High Street and 850 42nd Avenue are under compliance orders from Department of Toxic Substances Control (DTSC) and the Regional Water Quality Control Board due to mercury contamination of the soil. DTSC and the Water Board claim that soil contamination causes indoor air quality issues inside the building. DTSC has asked the City to alleviate the flooding in this area because of a correlation between some of the increases in indoor air quality and street flooding. A Water Board consultant claims that the perched water table increases the pressure in the porespace beneath the building, which increases the ongoing vapor intrusion. In addition, storm drainage flows in an abandoned and deteriorating sewer pipe down High Street from the railroad trachs to Tidewater Avenue. This pipe is inefficiently serving a regulatory trash capture device at Tidewater Ave. The storm drainage system requires upgrades to address these issues.

ArcGIS/ESRI Indoors Implement ESRI Indoors - this is a mapping software for vertical assets, like buildings. It allows the mapping of office spaces, various mapping compnents, office space hoteling and reservation, and more. It would allow Facilities to select a vertical asset, such as a cubicle, office, or restroom on a specific floor and record work against that asset. Allows for enahnced buidling record history, and it integrates with Cityworks maps, so work orders can be attached to vertical assets. Would also enhance maintenance records of certain mechanical compnents/assets of a building, like HVAC, plumbing, and more.

Assetworks Upgrade (Fleet Management Software) Upgrade the Assetworks platform to the latest version following the completion of the Oracle EBS to Cloud project. This upgrades all components of Assetworks - FA Suite, Fuel Focus, Key Valet, an improved integration with Oracle for parts purchasing; new integrations with Veeder Root underground storage tanks to foster improved regulatory compliance, Power BI reporting, and single signon.

City Fleet EV Charging Infrastructure Deployment With the Advanced Clean Fleet Rule requiring the City to procure Battery Electric Vehicles (BEV) beginning January 1, 2024 it is essential that the City begin installing EV Charging structure NOW to support the first phase of the BEV deployments this year while the City identifies the $90-$100 million required to support these initiatives.

City Park Outdoor Athletic Court Preventive Maintenance, Repair, and Scheduled Renovation/Replacement ProgramThere is no lifecycle assessment or replacement planning for high-use outdoor athletic corts at City parks. These outdoor courts are frequently a main feature at outdoor Park facilities, yet many are in unsafe and unusable condition. Court surfaces have a predictable lifecycyle and with regualr preventive maintenance such as cleanings, spot repairs, resurfacing, etc. the useable life of these valuable assets could be greatly extended. A priority roster would also be established for full replacement based upon condition, frequency/volume of use, and equity
City Park Path and Trail Preventive Maintenance, Repair, and Scheduled Renovation/Replacement ProgramThis program would inventory, assess and prioritize fro renovation or repair the paths and trails located within City Parks. A reasonable funding level could then be established to support this high-use infratstructure based upon linear or square footage identified in the inventory. There currently is no dedictaed funding mechanism to perform these activities.

City Park Tot Lot & Play Structure Cleaning, Maintenance, Repair, and Scheduled Replacement ProgramThis program would operate in conjunction with the outdoor court program and the same crew would perform the weekly or bi-weekly cleanings, maintenance and minor repairs. While the goal is to provide clean and safe tot lots and play structures, the secondary function wold be to establish a priority roster for scheduled full replacement based upon condition, frequency/volume of use, and equity

Page 32 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Public Works City wide Litter Container conversion plan The Ciity's 1,300 litter containers require update and replacement with intermittent placement of "smart container" technology. The increased capacity and data driven service schedules are projected to improve the overall appearance and better the secure the liner and contents until serviced daily by Waste Management. The planning phase for large scale acquisition and roll out has been inititated based on results of pilot purchase of the Big Belly containers put in place during 2023.

Citywide Facility Asset Conditions Database BDC-PGM is seeking funding to conduct a Facilities Conditions Assessment investigation of the City's 300+ facilities. Data on city assets are needed to predict facility needs, quickly assess improvement needs for funding opportunities such as grants, budgeting for capital improvements and to prioritize work. PGM would lead the management/update/use of data for CIP needs, in consultation with OPW BMIS and other City departments.

Citywide Street grates/ storm drain grates upgrade To replace all street grates and storm drain grates that will accommodate bicycle mode of transportation in the City.

Citywide Tree Maintenance and Tree Planting Proactively prune and maintain Oakland's 56,000 street trees and 12,000 trees in landscaped parks. Plant 3,000 trees annually, focusing in Oakland's frontline communities for the sake of improving tree canopy equity, per the approved Equitable Climate Action Plan (ECAP). Provide green jobs training, education, and community engagement. Comprehensive strategy is detailed in the forthcoming Urban Forest Plan.

Cityworks Upgrade, Move to Cloud (Cityworks Online Services), Integrations, new feature rollouts including PLL Case Management and inspections module.An on-premise Cityworks upgrade is underway. To improve resiliency and accessibility to the application, Cityworks should be moved to the Cityworks Online cloud service, as well as the City's GIS resources. Several Cityworks integrations should take place following the upgrade, including ITPipes and GraniteNet integrations, Pavement integrations, as well as feature rollouts including buying and using the Cityworks PLL Case Management & Inspection Module to better track issues pertaining to regulatory requirements, homeless encampment tracking, commercial trash cases, and more.

Defensible Space Vegetation Management, Joaquin Miller ParkCAL FIRE, with support of the National Guard, is performing vegetation management in Joaquin Miller Park to reduce vegetative fuel loads in Joaquin Miller Park. They are performing this work at no cost to the City of Oakland, via an MOU. This is a major benefit to the City as there are currently no City staff funded to perform this work.

EMT- Sustainability Work with PW to identify closed EMT sites where community members can partner with Stewardship to adopt and maintain closed sites.

Enhanced Service Levels - Medians & Litter Container Provided enhanced levels of service and increase frequency of service to the medians and litter containers in the KOCB vegetation management.

Increase staffing level in KOCB/ Vegetation Management Unit - two (2) PW Maintenance Workers; one (1) Street Maintenance Leader) Facility Electrification De-carbonize (replace natural gas service) City facilities by switching to electrical appliances and systems. (Replace gas heating and cooking capabilities with electric options)
Fleet Electrification State mandates and City goals require electrifying significant portions of the City's medium and heavy duty fleet progressing up to 100% of all replacement vehicles MUST be battery electric or hydrogen beginning 2027.

Fund OPW CIP Programs Rather Than Projects Approve funding for OPW CIP Programs (eg. Buckets) rather than specific projects to improve cash flow flexibility, expedite spending timelines, flexibility in moving funds to projects as needed.

Hazardous Tree Removal along Skyline Blvd Evacuation Corridor & Arterial Routes to I-580/CA-13In 2024, CAL FIRE provided the City $1M to remove dead or hazardous trees along the Skyline Blvd Evacuation Corridor and arterial routes connecting to I-580 or CA-13.

Illegal Dumping Surveillance Camera Program Expansion Contract with Security Lines, U.S. (SLUS) to expand the Illegal Dumping Camera Program to acquire 15 license plate recognition (LPR) cameras and upgrade the existing 15 surveillance cameras. The contract with also include an agreed upon of technical support from SLUS for camera installation and maintenance. The contract amount cannot exceed $750,000 for three

Page 33 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Public Works KOCB Illegal Dumping Unit Rapid Response Team Dedicated Illegal Dumping Unit team formed to triage and remove homeless debris as part of a larger crisis response unit.

Lake Merritt Water Quality Improvement Efforts In response to fish kill of 2022 in Lake Merritt Watershed and Stormwater Management is implementing several projects to increase dissolved oxygen (DO) levels in the Lake and to find ways to manage harmful algal blooms.

This effort involves close coordination with the San Francisco Bay Regional Water Quality Control Board (Water Board). The Water Board is pursuing a Total Maximum Daily Load Alternative for DO in Lake Merritt which will impose regulations on the City to meet DO water quality objectives.

Lakeside Park work hub/bathroom replacement The Lakeside Park work hub serves 30+ staff members but lacks adequate office space, storage space, security, and bathrooms. It suffers from severe infrastructure problems including water leaks, rodents, and seismic damage from the 1989 earthquake. The once functional public bathroom is in disrepair and unusable, leaving park visitors without a sanitary alternative.

Replacing the work hub building would be a Capital Improvement Project, replacing the public bathrooms may be more feasible with pre-fabricated infrastructure.

Measure Q Deliverables Dedicated staff placed at community serving parks and regional parks.

National Night Out Annual Event in partnership with the National Neighborhood Watch , whereby 400+ blocks have block parties with over 20,000 participants.

Non-Functional Turf Assessment and Conversion Assess and convert all "non-functional" (ie non-recreational) irrigated turf on City property to either a) non-potable water irrigation or b) non-irrigated landscape.

Outdoor Stand Alone Restroom Renovation and Scheduled Replacement ProgramThis program would assess and prioritize outdoor restrooms for renovation and replacement based upon condition, frequency of use, and equity. The concept is to create a replacement roster and funding to allow the renovation or replacement of 2-4 out door restroom facilities each year.

Ideally the restrooms that are replaced vs. renovated would utilize low- maintenance and vandalism resistant Portland Loos such as deployed at Astro park, Wilma Chan Park, Pine Knoll Park and Concordia Park; or modular restrooms units such as deployed at San Antonio Park.

Park Facility and Building Maintenance This program is Park Facility and Building maintenance. General upkeep maintenance and improvements. Components, infrastructure, and in-kind repair/replacement and deferred maintenance.

PCB Contamination in Arroyo Viejo Creek The City is under a Site Cleanup Requirements Order (R2-2022-0032), issued by the San Francisco Bay Regional Water Quality Control (RWQCB) in October 2022, to remove polychlorinated biphenyls (PCBs) from Arroyo Viejo Creek. The Order alleges that stream banks and sediments within the creek have been contaminated with PCBs from upland properties at 700, 710, and 728-73rd Avenue. Union Pacific Railroad (UPRR) owns 700 73rd Avenue while the City owns 710 and 728-73rd Avenue. The Order requires that UPRR and the City evaluate remediation alternatives, prepare a remedial action plan, and implement remediation.

Planning & Building process review Assign dedicated BPD staff to process applications for city CIP projects.

Eliminate requirement for full payment of intake or permit fees prior to Planning & Building Dept (PBD) staff assignments on city projects.

Increase standard 6-month building permit life span to at least 2 years or more.

PMWeb Gather, validate, implement Phase II Requirements, including implementation of single sign on using the City's Azure Active Directory, deployment of the Planning Module, capturing and implementing singificant missed requirements from Phase I; identifying new processes, such as improving the Oracle Integration after EBS move to cloud, ESRI/ArcGIS integration, moving to the City's document management system for storage; development of a new Vendor Portal, incluidng a specific landing page for vendors, reports, and help and training documents; define and implement an archival process for CIP project records and documents; Service Now implementation and establishing service level standards for BIAD day-to-day application support; configure, update, maintain intranet site for PMWeb resources.

Page 34 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Public Works Routing Software and Integration With Cityworks Phase I: Procure a new routing software, primiarly for Street Sweeping to make routes more effient,
Phase II: Integrate the software with Cityworks so crews can receive cloud- based routing services to reduce road-time on daily planned work orders.

Sanitary Sewer Master Plan The Sanitary Sewer Master Plan's objective is to establish Capital Improvement Program (CIP) and Operations and Maintenance (O&M) master plans that will satisfy the requirements of the 2014 Consent Decree through 2036. This master planning effort will also need to yield additional benefits by incorporating smaller diameter sewers into the collection system model, providing the City with a tool that can be used to assess system capacity constraints as new development and redevelopment occurs within the City.

See "Supplemental LiƩer & Trash Abatement + Homeless Encampment Clean-Up Contract" above.The contract will service multiple departments - OPW, EWD, HCD and DOT.

This portion of the contract scope of work consists of abating dumping into City creeks. Contractor/s will respond to OAK311 reports of illegal dumping in creeks sections located on City property, coordinate clean-ups with KOCB operations and/or Parks and Tree Services Division (PTD) operations as needed, collect and bag debris, organize bulky waste in centralized location, contact OAK311 or designated KOCB or PTD personnel for bag/debris pick- up, and on an as-needed basis when authorized, assist with implementation of future dumping prevention measures.

A citywide contract for one or more contractors to provide supplemental support with litter & trash abatement and homeless encampment clean-up throughout the City.

Sewer and Storm Drain Smart Maintenance Hole Cover Sensor ProjectThis project builds upon an initial pilot deploying water level and flow volume snsors in sewer maintenance holes at critical/environmentally sensitive locations such as in and around lake Merritt and Lake Temescal.

The sensors provide an "early warning" capability of potential sewer and storm drain pipe concerns such as partial obstructions, but also when deployed more extensiveley will be used to establish baseline water flow data and can then be used to focus response efforts such as; prevent sewer spills before they occur, precisely tailor high-frequency preventive maintenance based upon actual condition rather than set time schedules; perform preventive mantenance in advance of storm events; identif potential sources of infiltration and inflow; identify potential contractor caused damage before spills; monitor real time tide levels at crticial storm drain outfalls (such as Coliseum Connection); identify, documen, and establish baseline reverse water flows (tidal inflow) at critical locations such as Coliseum Conection).

Sewer Rate Study The sewer rate study involves financial planning, cost of service analysis, rate design, and rate adoption. 1. The financial plan will make revenue adjustments that will be needed to cover operating and capital costs. 2.

The cost of service will determine who is responsible for the costs based on their demand. 3. The rate design develop rates that help recover the costs idenƟfied in the financial plan. 4.The rate adopƟon will include the development of the draft and final report and any presentations.

Skyline Blvd Evacuation Corridor Project In 2021, CAL FIRE provided the City $824K to remove or prune dead or hazardous trees along the Skyline Blvd Evacuation Corridor. The project is now complete. An additional grant application for $1M has been made for phase 2 of this project, though awards have not yet been announced.

Stand-up Trash Capture Device service and maintenance unitEquip and staff Storm Drain Maintenance unit to provide service and maintenance required to support City Trash Capture Device deployment plan to add 1,900 of these higher maintenance units

Page 35 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Public Works Storm Drainage Funding Ballot Measure Funding will be needed in the future for a storm drainage funding ballot measure. A sustainable source of funding is needed to maintain, repair, and upgrade/improve the City's deteriorating storm drainage network and to comply with stringent, costly, and increasing stormwater quality regulations, some of which require capital improvements to the storm drainage network through trash capture and green stormwater infrastructure. City of Oakland has no stormwater fee to maintain, repair, and improve the City's deteriorating storm drainage system or to fund compliance with the Municipal Regional Stormwater Permit, a National Pollutant Discharge Elimination System permit issued by the San Francisco Bay Regional Water Quality Control Board. The City has very limited dedicated funding for these high priority funding needs.

Storm Drainage Master Plan OPW Watershed and Stormwater Management (WSM) provides storm drainage master planning efforts to inventory, update, and plan management efforts, including seeking sustainable funding, for the City's separate municipal storm drainage system.

Street Sweeping Notification Hub Develop a GIS-based hub site that provided residents and Parking Enforcement with notifications of when Street Sweeping Routes cancelled or when they are expected to occur as scheduled
Supplemental Litter & Trash Abatement + Homeless Encampment Clean-Up Contract - $1.5M to $2M per yearA citywide contract for one or more contractors to provide supplemental support with litter & trash abatement and homeless encampment clean-up throughout the City.

The contract will serve multiple departments - OPW, EWD, HCD and DOT.

The scope of work consists of abating dumping from City rights of way, City creeks, City lots and other City assets, especially where cooperation from the unhoused is required.

Support for Project-related PR Groundbreakings, ribbon-cuttings and other promotional efforts related to capital improvement projects require staff time and physical resources.

Dedicated funding is needed to support these activities. Anticipated expenses include purchase of supplies, such as: promotional signage and banners, portable microphone, speakers, power supply, event shade tent, folding tables, chairs, podium, giant scissors, ribbon, shovels, mailers, graphic design services, printing and mailing, advertising, etc.

Trash Cart Pilot Upgrade Program The Trash Cart Pilot Upgrade Program provides residents, on one single trash collection route that crosses Councils District 6 and 7 along International Boulevard, with larger trash containers at no extra cost for three months. The Pilot Program aims to evaluate the impact of larger trash capacity on decrease in trash container overage incidents; reduction of contamination to recycling and organics collections; and decrease of illegal dumping and/or overflowing street litter container abatement requests along and near the collection route.

Urban Forestry Inflation Reduction Act (IRA) grant $8M offered by US Forest Service for street tree maintenance, tree planting, and green job creation in Oakland's frontline communities. Approximately $4M will go to the City, $4M will go to non-profit partners.

Vegetation Management Plan Implementation The Vegetation Management Plan (VMP) is expected to be completed in 2024. This Plan strategizes vegetation management in the Oakland Hills for the sake of fire risk prevention and mitigation. Oakland Public Works will play a role in implementation by managing vegetation and reducing fuel loads on 1,000+ acres of City-owned open space parks and forested land in the high fire risk areas. City positions dedicated to this work, including the Parkland Resources Supervisor position, were downsized over 15 years ago but would need to be restored to achieve implementation.

Page 36 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Public Works Vulnerable City Historic and "mothballed" facility protection planDeploy, fencing, security camera surveillance alarms, fire detection, fire suppression, and motion sensor lighting at vulnerable City facilities. These facilities can be active in the OPW inventory (such as Clinton Rec Center, China Gardens, and Junior Arts and Sciences), can be semi-active or inactive in the OPW inventory (such as Dinkelspiel House at Dunsmuir and Moss House at Mosswood), active in DWES inventory (Camron Standford House, Chabot Space and Science center), or inactive in DWES inventory (such as The Gingerbread House/Old Montclar Fire Station)
Race & Equity
Community Development & Engagement Funds, monitors and reports CDBG and other federal grants that fund services and projects that predominantly benefit low- and moderate- income residents of Oakland. Administers community engagement activities that informs Oakland residents and collects Oakland residents’ feedback. ***Capital Project - AAMLO Renovation and Restoration Electrical, windows and building system repairs to African American Museum and Library at Oakland
***Capital Project - Brookfield Library Renovation of Brookfield Library ***Capital Project - Main Library Renovation Electrical, floor and building system repairs to the Main Library ***Capital Project - Melrose Renovation and Restoration Electrical, floor and building system repairs to Melrose Library ***Capital Project - MLK Jr. Library Bike Repair Program SpaceContainer facility in the parking lot of MLK Jr. library for bike programs 2025-2027 Strategic Plan Schedule interviews with all major bureaus, divisions, and sections to ascertain their workflows, the role technology currently plays, pinpoints, and potential technology solutions to address those pinpoints. The ultimate goal is to have a functional OPD ITU Strategic Plan for fiscal years 2025- 555 Hegenberger Road Leaking Underground Storage Tank - Site Management Plan555 Hegenberger Road Leaking Underground Storage Tank Case 728 73rd Avenue PCB Contamination Related to the PCB Contamination in Arroyo Viejo Creek project, investigation and remediation of PCBs present on the upland property of 728 73rd Avenue is currently under regulatory oversight. However, the City is currently voluntarily cooperating without a cleanup order. Staff estimates the cost to characterize the site, develop a remedial action plan, and implement remediation and related reporting to be approximately $486,000 over the next two years.
911 Communication: Artificial Intelligence Utilize artificial intelligence to triage, route and answer incoming non- emergency calls to provide accurate and expeditious service to our community members
AB43 Speed Limit Reduction Bill Modifications to speed limit laws increasing local jurisdictions' authority to lower local speed limits to reduce death and injuries caused by speeding.

Accela-Special Activity Permits Transitioning Special Activity Permits into Accela-online permitting platform used by other City departments
Accelerate timelines for Labor Standards investigations and collectionsDWES will identify and implement best practices for investigations and collections, including technology and procedures for collections.

AC-OCAP: CAP Plan AC-OCAP: Strategic planning to be in compliance with CSBG bi-annual requirements
AC-OCAP: Community Needs Assessment AC-OCAP: CNA is prepared documenting the demographics of the areas that are served by the recipients of the CSBG grant.

AC-OCAP: Strategic Plan Update AC-OCAP: Strategic planning to be in compliance with CSBG Organizational Standards requirements
ADA Class Action Lawsuit Settlement Implement the requirements from this class action lawsuit. This could include capital improvements such as, curb ramps, sidewalk improvement, updating the city's design guidelines and policies.

ADA Transition Plans Updating the city's ADA Transition Plans Add electrical outlets to Cover Lot Installation of electrical outlets in Covert lot to charge vehicles. Minimal ITD involvement.

Administration & Grant Management Monitors department budget, pays vendors, prepares reports, and manages various grant programs.

Adults & Aging Services: Senior Communication Portal Senior Communication Portal Affordable Housing Asset Monitoring Monitors City's existing affordable housing properties with City affordability restrictions and property conditions. Ensures that properties are in compliance with all agreements and requirements.

Affordable Housing New Construction Loan Servicing Underwrites, reviews, and administers loans for proposed affordable housing developments for Oakland residents.

Page 37 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity Affordable Housing Preservation Loan Servicing Underwrites, reviews, and administers loans to preserve existing affordable housing units for Oakland residents
Alleviate Flooding on High Street between Wattling Street and Railroad Tracks and Improve Storm Drainage on High Street from Wattling to Tidewater AvenueHigh Street Flood control storm drainage system improvements needed to prevent flooding between Wattling Street and the United Pacific Railroad tracks, adjacent 809 High Street. Extensive street flooding in this area covers the sidewalk and impacts private property. High Street in this location serves Higher and Medium Priority Equity Neighborhoods and a Highest Priority Neighborhood to the northeast. The buildings at 809 High Street and 850 42nd Avenue are under compliance orders from Department of Toxic Substances Control (DTSC) and the Regional Water Quality Control Board due to mercury contamination of the soil. DTSC and the Water Board claim that soil contamination causes indoor air quality issues inside the building. DTSC has asked the City to alleviate the flooding in this area because of a correlation between some of the increases in indoor air quality and street flooding. A Water Board consultant claims that the perched water table increases the pressure in the porespace beneath the building, which increases the ongoing vapor intrusion. In addition, storm drainage flows in an abandoned and deteriorating sewer pipe down High Street from the railroad trachs to Tidewater Avenue. This pipe is inefficiently serving a regulatory trash capture device at Tidewater Ave. The storm drainage system requires upgrades to address these issues.

Alternative Delivery Methods for Capital Project Delivery Develop AI's for Construction Manager General Contractor (CMGC) project delivery, and develop and execute an RFQ for a CMGC contract to deliver Embarcadero West and/or speed safety cameras
AP Portal Citywide Adoption Require that all departments involved in approving invoices adopt the AP Portal process.

AP Portal Reviewer Assignment Assign invoice approver once for future automatic assignment, rather than manually each time.

ArcGIS/ESRI Indoors Implement ESRI Indoors - this is a mapping software for vertical assets, like buildings. It allows the mapping of office spaces, various mapping compnents, office space hoteling and reservation, and more. It would allow Facilities to select a vertical asset, such as a cubicle, office, or restroom on a specific floor and record work against that asset. Allows for enahnced buidling record history, and it integrates with Cityworks maps, so work orders can be attached to vertical assets. Would also enhance maintenance records of certain mechanical compnents/assets of a building, like HVAC, plumbing, and more.

Area 5: Hegenberger / 98th Ave. Burglary overtime suppression.Operation detailing : an average of 4 officers, per 10 hours for 7 days of week to ensure safe in special locations for Area 5
Asset Management System Implement an asset management system so we can track militarized equipment use, radios, computer equipment, etc. We are currently doing an RFQ. Funding has been identified via a grant. ITD involvement should be minimal - maybe help with SAML.

Assetworks Upgrade (Fleet Management Software) Upgrade the Assetworks platform to the latest version following the completion of the Oracle EBS to Cloud project. This upgrades all components of Assetworks - FA Suite, Fuel Focus, Key Valet, an improved integration with Oracle for parts purchasing; new integrations with Veeder Root underground storage tanks to foster improved regulatory compliance, Power BI reporting, and single signon.

Audio System Upgrade Upgrade Audio System in Hearing Room 1 ($35-$45K from Fund PEG 2999) Back Yard Camp Out with OPRYD OPRYD collaborate with outside agencies to bring families together for a outdoor camp out experience at Joaquin Miller Park. This event will be a one night weekend event to help set the stage for FRC.

Page 38 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity Bay Area Housing Finance Authority (BAHFA) 2024 Bond Public Engagement and Expenditure PlanningIn anticipation of a regional housing bond worth either $10 billion or $20 billion, Oakland HCD will lead community engagement and expenditure planning for its allocation. BAHFA requires each jurisdiction receiving a direct allocation to adopt an expenditure plan no sooner than February 1, 2025; community engagement will take place throughout 2024, and if the bond passes in November '24, final edits to the expenditure plan will occur.

HCD staff will lead public engagement, bond projection impact modeling, expenditure plan drafting, and more.

BD - Community Response Initiative to Strengthen Emergency Systems (C.R.I.S.E.S) Act Pilot Program GrantCommunity safety and mediator program for Downtown and Chinatown BD- Corridor Safety and Ambassador Program (Thriving Neighborhoods)Citywide convening, coordination, training and collaboration amongst ambassadors/providers and Oakland NEST/Fresh for training and development
Bloomberg Grant The City was awarded a grant for Black Wealth Creation leveraging the City's 5-year Urban Forestry Plan.

Bus Shelter Maintenance Franchise agreement for bus shelters is expiring. Current agreement maintains shelters at no cost to City in exchange for advertising revenue.

OakDOT working to identify options to maintain shelters in the future, including inventorying existing shelters, estimating maintenance costs, and evaluating methods to procure maintenance services at low/no cost.

Shelters are a critical amentity for transit riders.

BWC Analysis Work with Motorola to provide three years worth of video data to Stanford University for Analysis. Minimal ITD help needed. ITD involvement should be minimal - Axon will handle the work of setting up secure environments that follow CJIS protocol.

C.M.S 89907 (Sep 26, 2023) Form an interagency air pollution working group to implement air pollution actions implemented in the EJ Element - Council Amendment to the Resolution adopting EJ, Safety Elements.Informational report to City Council outlining City Administration's efforts to organize and develop an interagency working group
CAD to LRMS Implementation Upgrade our current CAD system to Premier One and connect it to LRMS.

Major project.

Capital Project - 81st Ave Library Solar Panels Ensure that 81st Ave will have a redundant power source during PSPS Capital Project - Chavez Branch Library New library on city property (due to escalating lease expenses) Capital Project - Thermal and Ventilation Improvements at all LibrariesEnsure that all libraries can serve as respite centers for emergencies Capital Project - Tool Lending Library Expansion Container facility behind the Temescal Library for expanded tool lending CCTV camera upgrade CCTV camera installation in PAB covert lot. Minimal ITD involvement.

CHS: Referral phone number for emergency shelter CHS: Establish an Oakland-wide referral line for emergency shelter CHS: Strategic Plan Strategic planning to be in compliance with HHAP guidelines City Fleet EV Charging Infrastructure Deployment With the Advanced Clean Fleet Rule requiring the City to procure Battery Electric Vehicles (BEV) beginning January 1, 2024 it is essential that the City begin installing EV Charging structure NOW to support the first phase of the BEV deployments this year while the City identifies the $90-$100 million required t support these initiatives.

City Park Outdoor Athletic Court Preventive Maintenance, Repair, and Scheduled Renovation/Replacement ProgramThere is no lifecycle assessment or replacement planning for high-use outdoor athletic corts at City parks. These outdoor courts are frequently a main feature at outdoor Park facilities, yet many are in unsafe and unusable condition. Court surfaces have a predictable lifecycyle and with regualr preventive maintenance such as cleanings, spot repairs, resurfacing, etc. the useable life of these valuable assets could be greatly extended. A priority roster would also be established for full replacement based upon condition, frequency/volume of use, and equity
City Park Path and Trail Preventive Maintenance, Repair, and Scheduled Renovation/Replacement ProgramThis program would inventory, assess and prioritize fro renovation or repair the paths and trails located within City Parks. A reasonable funding level could then be established to support this high-use infratstructure based upon linear or square footage identified in the inventory. There currently is no dedictaed funding mechanism to perform these activities.

City Park Tot Lot & Play Structure Cleaning, Maintenance, Repair, and Scheduled Replacement ProgramThis program would operate in conjunction with the outdoor court program and the same crew would perform the weekly or bi-weekly cleanings, maintenance and minor repairs. While the goal is to provide clean and safe tot lots and play structures, the secondary function wold be to establish a priority roster for scheduled full replacement based upon condition, frequency/volume of use, and equity

Page 39 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity City wide Litter Container conversion plan The Ciity's 1,300 litter containers require update and replacement with intermittent placement of "smart container" technology. The increased capacity and data driven service schedules are projected to improve the overall appearance and better the secure the liner and contents until serviced daily by Waste Management. The planning phase for large scale acquisition and roll out has been inititated based on results of pilot purchase of the Big Belly containers put in place during 2023.

Citywide Capital Project Management Software with full Oracle IntegrationCitywide Capital Project Management software to consolidate all capital projects in a constuction management process and timeline for beter tracking, fund management, and project delivery
City-Wide Compensation Study Council granted $250k to HRM to review the compensation for all classifications.

Citywide Contract Management Software Citywide Contract Management software to manage end to end contracting, with editing, monitoring, insurance, work flows, searchable, and document management.

Citywide facility Assessment Complete facility condition assessment for all city owned infrastructures.

Citywide Facility Asset Conditions Database BDC-PGM is seeking funding to conduct a Facilities Conditions Assessment investigation of the City's 300+ facilities. Data on city assets are needed to predict facility needs, quickly assess improvement needs for funding opportunities such as grants, budgeting for capital improvements and to prioritize work. PGM would lead the management/update/use of data for CIP needs, in consultation with OPW BMIS and other City departments.

Citywide Strategic Planning The Citywide Strategic Planning effort will not only address the immediate challenges facing Oakland but also sets the foundation for long-term success.

Citywide Street grates/ storm drain grates upgrade To replace all street grates and storm drain grates that will accommodate bicycle mode of transportation in the City.

Citywide Tree Maintenance and Tree Planting Proactively prune and maintain Oakland's 56,000 street trees and 12,000 trees in landscaped parks. Plant 3,000 trees annually, focusing in Oakland's frontline communities for the sake of improving tree canopy equity, per the approved Equitable Climate Action Plan (ECAP). Provide green jobs training, education, and community engagement. Comprehensive strategy is detailed in the forthcoming Urban Forest Plan.

Cityworks Upgrade, Move to Cloud (Cityworks Online Services), Integrations, new feature rollouts including PLL Case Management and inspections module.An on-premise Cityworks upgrade is underway. To improve resiliency and accessibility to the application, Cityworks should be moved to the Cityworks Online cloud service, as well as the City's GIS resources. Several Cityworks integrations should take place following the upgrade, including ITPipes and GraniteNet integrations, Pavement integrations, as well as feature rollouts including buying and using the Cityworks PLL Case Management & Inspection Module to better track issues pertaining to regulatory requirements, homeless encampment tracking, commercial trash cases, and more.

CJIS MFA/Security Upgrade Review current security protocols and ensure that they meet new CJIS requirements. Medium to large project. ITD is currently doing an internal system analysis.

Code Compliance & Relocation Program Reviews applications on tenant eligibility for relocation benefits in accordance with O.M.C. 15.60 and determines if City payment is appropriate. Assists tenants and property owners in understanding their rights and responsibilities under the law.

Comedy Show Collaborate with Event Promoter to host Comedy Shows with culturally diverse comedians, provides community engagement with laughter that helps to improve mood and reduce stress level

Page 40 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity Comedy Show Oakland Enjoyment Academy provides educational opportunities to help Oakland young adults learn to enjoy themselves outdoors in recreation spaces. The recreation space in Oakland offers a wealth of opportunities for young adults that live in the City to enjoy the serenity of walking along the water for improved emotional health, practicing breathing exercises near large bodies of water, walking with others for increased physical health and learning the health benefits of outside play with socialization while enjoying the outdoors. The communities served will include but not limited to young adults 18-25 years of age who want to be introduced to outdoors recreation. Oakland residents and those who attend college and vocational schools in Oakland will be invited to participate. The number of Oakland Enjoyment Academy participants per year will be 35 (70 total for 2 year program). There will be an annual Oakland Enjoyment Excursion that allows participants to participate in an OPRYD activity as an Oakland Ambassador.

Comms & Engagement Division - City Academy (blank)
Comms & Engagement Division - Engagement Customer Relationship Management (CRM) software(blank) Comms & Engagement Division - Oakland Love Life (TBD) (blank) Comms & Engagement Division - SMS/Text Messaging Communications Platform(blank) Comms & Engagement Division - Social Listening/Media Monitoring software(blank) Communications Building Access Software & Keycards Need to restore the ability for Communications to be able to manage access to their building via keycards. Medium project.

Comprehensive Fee Study Revisit all ROW Management permit and inspection fees to align with current costs and operations
Comprehensive Financial Policy (CFP) Revisions Complete overhaul of the city financial polices to address best practices, conflicting resolutions, missing scope, enhance financial stewardship, boltser the finacial position, and provide long term management tools to enhance credit ratings.

Continuing Disclosure, Post Issuance, and Financial Management Accountability Guidelines and TrainingComprehensive training plans and documentation to ensure compliance with IRS standards, SEC guidelines, and California bond law for bond fund management. Enhance executive team knowledge of fudiciary responsibility in depatmental management.

CPRA Mediation Program Establishment of CPRA program to mediate certain complaints CPRA to IAD Transition Transition of responsibilities from OPD Internal Affairs to CPRA Cultural Agencies (Chabot, OMCA, Fairyland) Infrastructure Ballot MeasureCitizen initiative to provde a ballot measure for the cultural nonprift agencies housed in deteriorating City facilites. Enhace the cultrual art experience and bring increased patronage.

Cybersecurity and Resiliency Efforts In process: proposed reductions to the cybersecurity funding ITD was allocated in the biennial budget (including funding directed for staff enhancement in security) will directly impact the work the Department is doing to modernize, strengthen and fortify the network City staff and residents depend on for services.

CYS: Annual Indep. OFCY Evaluation FY 22-23; 23-24 Evaluation of OFCY Strategy Implem.

CYS: Oakland Youth Commission Strategic Plan - YPAR; OFCY Community Needs Assessment & Strategic Planning and Plan DevelopmentOYC YPAR to advance youth agency and voice to inform CNA; Community Needs to Inform 3-year Strategic Plan FY 25-28 for RFP Release CYS: Projects that are mandated by OFCY Charter CYS: (see tab 3).

Data Center Infrastructure Upgrade Upgrading network infrastructure for reliability and enhanced security Data Center Network Upgrade Consolidating storage, adding redundancy, resiliency and enhanced security for the network
Data Collection & Analysis Develops various databases to collect data on evictions, rents, petitions and hearings, etc., to inform public policy and internal program design and improvements.

Data visualization services on PowerBI, starting with the Weekly Crime ReportsThis is a complicated project that requires all crime analysis services to be realigned and reconnected to a new records database. In the run up to the new database, the sections will be using various flat datafiles to develop data visualization projects in PowerBI. We will integrate these standalone projects the new database when it is launched.

Page 41 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity DBE Oversight: Ensure compliance with requirements The City of Oakland receives USDOT money with many requirements, including compliance with CFR 49, Part 26. The City of Oakland is not currently following all requirements. Not complying can potentially jeopardize the City's eligibility to receive funding.

Defensible Space Vegetation Management, Joaquin Miller ParkCAL FIRE, with support of the National Guard, is performing vegetation management in Joaquin Miller Park to reduce vegetative fuel loads in Joaquin Miller Park. They are performing this work at no cost to the City of Oakland, via an MOU. This is a major benefit to the City as there are currently no City staff funded to perform this work.

Dejaview Upgrade ITD to upgrade Dejaview to the newest version.

Demand Responsive Parking Flex meter rates to achieve optimum utilization of parking supply. 2013 City Council Resolution Parking Principles
$1.5million grant from MTC includes full scope and deliverables Depository and Custodial Bank Implementation Solicit new Bank Depository for citywide banking needs, adding additional services to fully service the needs of the organization and requests from City Council for enhanced services
Develop a new comprehensive plan for training Research a series of trainings that will expand and evolve the crime analysis experience. Work with the Training Division and budgeting to find funds for the trainings. Schedule analysts in rotation for each training, until all analysts have completed all trainings.

Disparity Study - Potential new policy development for procurement.The city has contracted for a disparity study for which the contract has expired. A draft report has been completed and is being reviewed for next steps. Any next steps for race-based procurement would fall within DWES authority to implement.

Division Level Investigation (DLI) Administrative task for the internal policies or procedures Document digitalization & Destruction Digitalization & destruction per retention schedule & municode EIFD Implementation Create two different tax increment districts to promote affordable housing in west Oaklnd and enhanced development around the Colisuem Electronic Cashiering System Upgrade with Oracle Cloud IntegrationIn process: Pending RESO and contracting Emergency Communications Center (ECC) The 911 Communications Division is a complex Public Safety Answering Point (PSAP) for the City of Oakland, handling incoming emergency policy, fire and medical calls and text messages as well as non-emergency calls.

Communications operates 24 hours a day, 7 days a week. Our dispatchers are POST-certified and they answer, triage, and route incoming emergency and non-emergency calls, dispatch officers and civilian technicians on the radio and perform administrative duties pertaining to the operations in the field. Our professional staff responds to Public Records Requests by providing responsive dispatch/phone audio and transcripts, prepare certified court documents and testify in court.

Emergency Home Repair & Home Maintenance and Improvement Loan ProgramsProvides Oakland's low-to-moderate income, senior and disabled homeowners with 0-3% interest bearing loans for home repair and rehabilitation from $15,000 to $150,000 to homeowners that require immediate attention to correct health and safety repairs, life-threatening hazards, and exterior appearance if blighted.

Encampment Management Services Expansion The reported number of encampments citywide has increased eight-fold since Oct 2020, while staffing in OPW, HSD, and other departments has not kept pace in proportion to this increase. In addition, there is an insufficient number of shelters and shelter beds available to serve the increased unhoused population in Oakland. As a result, this slows the pace of the City's encampment management operations, including outreach, assessment/triage, deep cleanings and closures. To help address the increased need, the Homelessness Administration division is in the early stages of a division-wide services expasion, which will be facilitated through several efforts:

Enhanced Service Levels - Medians & Litter Container Provided enhanced levels of service and increase frequency of service to the medians and litter containers in the KOCB vegetation management.

Increase staffing level in KOCB/ Vegetation Management Unit - two (2) PW Maintenance Workers; one (1) Street Maintenance Leader)

Page 42 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity Equipment Replacement Replacing projector in chamber with modernized video wall ($100-$150K from Fund PEG 2999)
Equitable Climate Action Plan (ECAP) Implementation The Sustainability and Resilience Division will be aggresively seeking grant funding through the Federal Infrastructure Act and the Inflation Reduction Act for a variety of programs and initiaives identified in the ECAP that could total in the hundreds of millions of dollars. for each grant application, the funds will be shared by multiple departmentsa nd outside entities such as CBOs wioth whom the City partners to implement the plan successfully. eSports eSports is quickly permeating many aspects of our society from an entertainment and competitive standpoint. This is reflected in the move by recreation centers throughout the country to add eSports components to their facility. Aside from generating revenue through memberships and events, adding eSports allows recreation centers to develop programming that can attract older kids to their facilities
Facilities Conditions Asset Database (FCAD) Create FCAD for City's 300+ facilities that will streamline delivery of capital improvement and maintenance projects.

Fair Chance Access to Housing Prepares informative materials that provide information and guidance on Fair Chance Access to Housing. Manages contract with East Bay Community Law Center to provide legal assistance to tenants. Coordinates with Just Cities which performs community outreach to vulnerable communities.

Feasibility Study - Piedmont Avenue Library New library on the OUSD Piedmont Elementary School campus Feasibility Study - San Antonio Community Center/Library Feasibility study for a new community center/library Feasibilty Study - Hoover Durant Library New library in the Hoover Durant neighborhood Feasiblity Study - Main Library New or significantly renovated Main Library Fee Study OPRYD has hundreds of fees that have not been assessed.

FEMA reimbursed 2023 Winter Storm Project We will be working on existing FEMA projects for the next two years most likely. We are charging to 1010 and then will be reimbursed. Do we need to add something to the mid-cycle budget about this?
Filling the Maintenance Gap Assessing the growing gap between capital project dollars and maintenance dollars over time, funding sources for maintenance, and unsuccessful efforts to identify funding sources to help understand the need.

First Watch Data Sharing Integrate First Watch into Premier One CAD so that certain pieces of information can be shared with other agencies and other agencies are able to share alerts with OPD. Minimal ITD involvement.

First-time Homebuyer Loan Program Provides loan funding to first-time homebuyer Oakland residents and workers and creates homebuyer education activities.

Fitness Unity Increase awareness in fitness to the communities through recreational programs. Development of training curriculums in health/wellness, healthy lifestyles, and childhood obesity.

Fix CarFax Implementation Fix the connection between OPD and Carfax on traffic data - ITD established this in the past and it has been broken since the ransomware attack.

Minimal work needed, just re-establishing a connection.

Fleet Electrification OPW-BMIS and BDC is working on planning phase with City Administrator and Sustainability Manager on meeting the 2035 federal mandate.

Flock ALPR Installation of cameras will be handled by Flock. User Administration will be handled by OPD, there should be minimal ITD work.

Fund OPW CIP Programs Rather Than Projects Approve funding for OPW CIP Programs (eg. Buckets) rather than specific projects to improve cash flow flexibility, expedite spending timelines, flexibility in moving funds to projects as needed.

FY21-23 Council Earmarks Using availabe 2218 fund balance, Council identified specific traffic safety projects in their districts for OakDOT to implement.

Geoanalysis to ArcGIS Pro This project involves a complex undertaking wherein all crime analysis services will undergo realignment and integration with a new records database. As part of the transition to the new database, the sections will utilize the new geospatial program ArcGIS Pro to create and refine new products and services. Our next steps involve scoping out a new data feed and integration service, establishing the necessary contractual relationship, conducting thorough testing, and ultimately launching the new system.

Page 43 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity Granicus Inc/One Meeting Agenda Management Implementation ProjectImplementation of Granicus Inc.'s Government Experience Cloud will enable integration of the City's website content management system with its legislative system, as well as enhance security, streamline the agenda management process through increased automation and electronic routing/approvals, and improve user experience for staff and the public.

Grant Management Software Integration New grant management software used to apply for and management grant funds, create a portal to manage grant recipients for cgrants provided by the City to outside entities. Oracle intergrated for real time funding knowledge and management.

Grants for Earthquake Seismic Retrofitting of Apartment BuildingsThe Safer Housing for Oakland Program (SHOP) offers grants to reimburse owners for a portion of the costs to seismically retrofit a multi-unit apartment building with a “soft-story” condition. The Earthquake-Safe Homes Program offers grants to owner-occupants of 1-4 unit properties for partial reimbursement of the cost of a seismic retrofit.

HE 2.1.5 Implement Universal Design Strategies The City will consider adopting a Universal Design Ordinance to address housing needs and improve housing conditions for seniors, people experiencing disabilities, and other communities with accessibility issues.

HE 2.2.5 Extend Local Replacement Unit Provisions Requirements above SB 330Codify and extend local replacement unit provisions to ensure compliance and prevent displacement.

HE 2.2.7 TDR for SROs Consider allowing owners of residential hotels that agree to restrict occupancy to lowerincome residents to transfer development rights to create an endowed source of funding for an internal subsidy for such residents, or for maintenance/ facility upgrades that do not increase rents.

HE 3.2.6 Monitor affordablity of ADUs (ADU Survey) To ensure that Oakland’s ADU production aligns with these projections, the City will send a survey to the property owners of ADUs that received a certificate of occupancy within the prior two-year period requesting information on household size and rents charged for these recently constructed ADUs. If the survey identifies a shortfall in the numerical affordability production projections, within six months of the survey report being published the City will provide to the Planning Commission a report summarizing the survey report and identifying additional actions that can be taken to either increase the production of affordable ADUs, and/or proposing other rezoning programs that will enable additional affordable housing production to fill any identified affordable housing production shortfall.

HE 3.3.15 Continue & Expand Density Bonus Incentives To ensure that the Chapter 17.107 remains compliant with state law, and to solicit additional ideas for incentives and expansion of the density bonus program, the City will review the density bonus program mid-cycle, bring necessary amendments to conform to state law, and solicit feedback from Planning Commission and City Council on additional incentives that could be included in the local density bonus program.

Health & Wellness Community Challenge Partner with Public Health Agency or Hospital to select one month to encourage Oakland residents to engage is physical activity at Oakland Parks and track progress. They could select an activity and enter a challenge wih the community.

Health & Wellness Walk/Run & Resource Fair Collaborate with Hospitals and Public Health Agencies to host an interactive educational event to include a walk around Lake Merritt with a Health/Wellness Fair at the end with resource booths, health screenings, fitness demonstrations and healthy food samples.

Homelessness Prevention Pilot Program In FY22-23, Oakland HCD provided $2.3 million for a pilot program to prevent homelessness for the most at-risk Oaklanders. Oakland HCD is collaborating with researchers at Stanford University and the University of Pennsylvannia to study the effectiveness of the service interventions. The program, focused on wrap-around services and shallow subsidies, is executed by a collaborative of community organizations under the Keep People/Oakland Housed umbrella of Bay Area Community Services (BACS).

The program is serving 300 residents in its first year with the hope of demonstrating substantial impact in preventing homelessness in order to continue in future years.

Page 44 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity Housing Protection Services Provide services in the form of eviction protection and homeless prevention via service providers to Oakland tenants at risk of displacement or homelessness. Includes legal assistance, emergency rental payments and wrap around services.

Housing Resource Center Supports via phone calls and emails residents seeking housing services and information.

Human Trafficking Operations Operations to rescue Juveniles and arrest Offenders of Human Trafficking along International Boulevard
IKE (Interactive Kiosk Experience) Digital Kiosks Support IKE's franchise agreement, authorizing up to 50 digital kiosks in the right of way
Illegal Dumping Surveillance Camera Program - $250k per year (O&M) + Three (3) Additional Administrative FTEsExpansion of the Illegal Dumping Camera Program will require the acquisition of more license plate recognition (LPR) and surveillance cameras AND additional staffing to monitor the cameras, issue citations, conduct research, etc.

Staff is seeking Council approval at the MAR 26 PWTC meeting for a three (3) year contract with camera vendor Security Lines U.S. (SLUS) to procure additional cameras and to ugrade, maintain, and repair the current fleet of cameras.

As the number of cameras grow, staff proposes hiring three (3) administrative personnel (classification yet to be determined) by FY25-26 to monitor cameras, issue citations, and conduct research, etc. These administrative personnel differ from the current Environmental Enforcement Officer (EEO) classification in that the administrative personnel will be in-office staff that do not perform field patrol or other enforcement activities currently performed by EEOs. The addition of the in-office administrative personnel will permit EEOs to spend less time in the office monitoring cameras, and more time conducting outreach and enforcement activities in the field.

Implement a new RMS system Need to identify a new records management system to implement so OPD can adhere to the NIBRS standard. Major project.

Implement outreach strategies in all our work DWES will continue to implement outreach strategies to ensure the community is informed about our work.

Implementation of New labor Standards Policies The Council set a goal of considering Labor Standards Policies for housing and other development by July. It passed a resolution requiring the City Administrator to facilitate the process. This creates implementation work that may include: researching standards, benchmarking and comparisons with similar cities, and developing new policies and procedures.

Implementation of Rapid Response Homeless Housing loan programThe City Council’s biannual 2023 – 2025 budget established a Rapid Response Homeless Housing Fund in the amount of $10,400,740. The City is adding another $19,667,562 in Permanent Local Housing Allocation funds, as well as $10 million in outstanding Homekey Round 3 commitments for a total of over $40 million. To implement the deployment of these funds in a manner that is expeditious and effective in addressing homelessness, staff created the Rapid Response Homeless Housing (R2H2) Program, modeled on the success of the Homekey program. The City Council adopted this program at its November 7, 2023 meeting, and the initial RFP was due February 29, 2024. Staff will evaluate proposals and work to administer the funds + loans throughout 2024 and beyond.

Improve workflow and process of L/SLBE compliance and labor standards complianceDWES will analyze the processes L/SLBE and labor standards, identify obstacles and gaps, and improve coordination to improve timeliness and quality of service.

Incoming Chief Goals and expectations The crime analysts provide the framework for the Monday 11am crime meeting, including verbal presentations, expansive analytical reports with commentary, and material for presentation at the meeting itself.

Increase on-street parking rates from $2.00 to $3.00 (50% increase).Increase on-street parking rates from $2.00 to $3.00 (50% increase). Cost of living adjustment accounts for no rate changes since 2009

Page 45 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity Integrate Crime Analysis Services with new Records database system (Mark43)This is a complicated project that requires all crime analysis services to be realigned and reconnected to a new records database. The completion of this project will open new avenues to report creation and other data and geospatial projects.

Internet Migration The City's current website is no longer supported. Project covers migrating and updating the City internet pages; move to One-Meeting Platform for the City's Agenda Management
Intimate Evenings at Dunsmuir or Gardens-Partnership or CollaborationCollaborate with Event Promoter to bring Oakland's diverse community together for these festive fundraisers.

Intranet Restoration Migration and updating City intranet pages; moving all content from old OakNet News site to SharePoint and closing the former site which has experienced broken/unusable links and content post-ransomware Job Fairs Council granted HRM $50k to support job fairs.

Lake Merritt Violence Suppression During the summer months into the fall months, Lake Merritt requires additional police service, traffic control, vendor regulation and special event permitting. OPD works with DOT, Parks and Rec, City Administrator's Office, Nest and Lakeshore/Lake Merritt Work Group to provide holistic service.

Lakeshore Avenue Protected Bike Path Project Implement bike lane safety improvements on the East side of Lake Merritt.

Lakeside Park work hub/bathroom replacement The Lakeside Park work hub serves 30+ staff members but lacks adequate office space, storage space, security, and bathrooms. It suffers from severe infrastructure problems including water leaks, rodents, and seismic damage from the 1989 earthquake. The once functional public bathroom is in disrepair and unusable, leaving park visitors without a sanitary alternative.

Replacing the work hub building would be a Capital Improvement Project, replacing the public bathrooms may be more feasible with pre-fabricated infrastructure.

Law Enforcement Background Investigation Cloud Based SoftwareSoftware that allows the unit to conduct background investigations in a cloud based system. Eliminates the need for manual processes and file storage.

Lead-Safe Paint and Access Improvement Grant Programs The Lead Safe Housing Paint Program provides grants from $15,000 to $24,000 for exterior painting and lead hazard remediation. The Access Improvement Program provides grants from $15,000 to $24,000 for accessibility improvements to both rental property and property owned and occupied by disabled persons.

Loan Servicing Underwrites, reviews, and administers loan applications for the purpose of repayment and subordination requests, including commercial, residential and rehabilitation grants and loans.

Measure Q Deliverables Dedicated staff placed at community serving parks and regional parks.

Measure U Activities Bonded, not started: Providing Wi-Fi and/or connectivity to affordable housing in Oakland
Minor Home Repair Program The MHRP grant program provides financial assistance for home repairs up to $2,499 to correct immediate threats to the health and safety of low-income homeowners in Oakland. Single unit residences, including mobile homes are eligible. This grant can be used to make minor plumbing, carpentry, electrical repairs and can be used for railing grab bars, toilets, water heaters, doors, locks and more.

Mobile ID Restart project Obtain New Mobile ID readers from ACSO as well as upgrade software with the help of ITD. Roll out system to patrol. Minimal ITD involvement.

Mobile Recreation Services The Pop-Up Rec (mobile), brings a versatile and dynamic dimension to community engagement. Unlike traditional brick-and-mortar facilities, Pop- Up Rec programs offer unparalleled flexibility in both the variety of activities and locations where services are provided. Additionally, Pop-Up Rec allows OPRYD to be responsive to communities that may lack access to parks or recreational facilities. Our mobile unit could feature an exciting array of offerings, including a rock climbing wall, jump houses, giant games, giant big wheels, amplified music capability, video games, sports equipment, arts and crafts, storytime and books.

National Testing Network Administers required written test for Police Officer Trainee position.

Page 46 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity New Construction of Affordable Housing - Pipeline Project FundingThe 2023 new construction NOFA cycle left over $120 million in unfunded requests for support. Oakland HCD staff convened affordable housing staff from peer cities around the Bay Area to learn about their funding approaches and better understand best practices in the field. Staff learned that every other jurisdiction releases a NOFA specific to its pipeline projects in between notices for new projects. In February 2024, Oakland HCD attained approval from city council to focus its next NOFA solely on (partially or completely) unfunded affordable housing projects in its pipeline. With council approval, Oakland HCD will administer $22 million for its outstanding projects in advance of a NOFA for new projects later in 2024.

Non-Functional Turf Assessment and Conversion Assess and convert all "non-functional" (ie non-recreational) irrigated turf on City property to either a) non-potable water irrigation or b) non-irrigated landscape.

Oakland Ballers at Raimondi Field The Bs Pioneer Minor League Team will utilize the OPRYD-run ballfield at Raimondi Park as their "home field", providing capital upgrades, maintenance and improvements; economic opportunity for local vendors; clinics and events with local youth sports teams; additional opportunities for neighborhood 'activation events'. Expectations: Increased neighborhood safety due to park activation; youth and local sports teams will benefit from improved field and equipment; potential increased public transportation ridership due to game-day collaborations; economic benefit to neighborhood warehouse owners who will rent property for parking, to local food truck vendors, merch purveyors, and landscape/construction Oakland Building Construction Code Recommend local amendments to the CA Model Building Codes Oakland Children's Initiative (OCI) 2-Year Evaluation Charter Section 1602 requires the Accountability Officer shall be responsible for overseeing a rigorous and reliable external evaluation or evaluations of the Implementation Partners' performance, including the selection of external evaluation partners or the utilization of existing external evaluations as applicable, and presenting the results of such evaluations to the Citizens' Oversight Commission.

OPRYD Annual Youth Dance Concert Recreation Centers collaborate with cultural arts and youth development to put on a dance concert performance to show case each recreation centers talents.

OPRYD E-Platform -Relaunch Teen Virtual Recreation is a program designed to offer virtual engagement in recreation and leisure activities for teenagers. This initiative provides an interactive online platform featuring a variety of virtual programs. Teens can explore cultural arts, career options, and life skills, participate and learn about civic engagement opportunities, and focus on physical and mental health, nutrition, and wellness—all from the comfort of their own space.

Teen E-Recreation is a dynamic avenue for adolescents to connect, learn, and enjoy various activities that contribute to their personal growth and well-being.

OPRYD is requesting salary savings be re-purposed to provide for the equipment and supplies needed to operate the Teen Virtual Recreation program
OPW Grant support program BOA Grant Division support of OPW grant seeking and writing OPW Trainee Academy Safety and Training created a program to advance youth and young adult employment in the City. This program targets residents between the age of 18-30 who have historically been marginalized, disenfranchised and oppressed with a place of study or training in a special field for success with greater than living wage employment.

Oracle Cloud Conversion and Enhancement Convert Oracle Financial System to be web hosted to provide a stable platform from which to make system enhancements that provide the basic functionality of a modern ERP system
Organize a tiered section, with additional job descriptions, interns, and room for advancement and promotionDevelop job descriptions to accommodate a tiered positions system in the Crime Analysis section, including provision for at least two interns. Work with the unions, and various city department to get the job descriptions approved. Second, work with budgeting, OPD HR, the OPD executive team, and City Council to bring the new positions and CAU origination into reality.

Page 47 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity Outdoor Stand Alone Restroom Renovation and Scheduled Replacement ProgramThis program would assess and prioritize outdoor restrooms for renovation and repacement based upon condition, frequency of use, and equity. The concept is to create a repalcement roster and funding to allow the renovation or replacement of 2-4 out door restroom facilities each year.

Ideally the restrooms that are replaced vs. renovated would utilize low- maintenance and vandalism resistant Portland Loos such as deployed at Astro park, Wilma Chan Park, Pine Knoll Park and Concordia Park; or modular restrooms units such as deployed at San Antonio Park.

Partnership with Community Development Financial Institutions (CDFI) to increase scale of acquisition/rehabilitation/conversion to affordable housing programOakland HCD's current Acquisition and Conversion to Affordable Housing (ACAH) preservation program releases NOFAs once per year, or biannually.

This time frame does not meet the needs of preservation practitioners in Oakland, as they need subsidy and support quickly in order to acquire buildings on the market. To respond to our partners' and the market's concerns, Oakland HCD is pursuing collaboration with CDFIs that will leverage outside funds and allow developers to acquire properties much more quickly than the city process alone would allow. Such a partnership will allow many more properties to be acquired and made affordable (through deed restrictions) for years to come.

Payroll Processing Reform Comprehensively streamline payroll processing for basic compliance in the absence of Oracle systematic improvements to gain regulatory compliance with all agencies. This includes personnel reorganization to a citywide centralization of all payroll functions into Finance Department, training manuals and comprehensive mandatory training plans, and updated Administrative Instructions
PCB Contamination in Arroyo Viejo Creek The City is under a Site Cleanup Requirements Order (R2-2022-0032), issued by the San Francisco Bay Regional Water Quality Control (RWQCB) in October 2022, to remove polychlorinated biphenyls (PCBs) from Arroyo Viejo Creek. The Order alleges that stream banks and sediments within the creek have been contaminated with PCBs from upland properties at 700, 710, and 728-73rd Avenue. Union Pacific Railroad (UPRR) owns 700 73rd Avenue while the City owns 710 and 728-73rd Avenue. The Order requires that UPRR and the City evaluate remediation alternatives, prepare a remedial action plan, and implement remediation.

Performance Management System The City seeks to ensure all departments have the tools and resources they need to track and report on equity-centered targets aligned to key health, climate, and economic indicators. This system has the potential to help local leaders to address challenges and improve results wtihin resource constraints, engage all public employees in an era of complexity and rapid changes, and gain and keep the public's trust and confidence through accountability and communication.

Planning & Building process review Assign dedicated BPD staff to process applications for city CIP projects.

Eliminate requirement for full payment of intake or permit fees prior to Planning & Building Dept (PBD) staff assignments on city projects.

Increase standard 6-month building permit life span to at least 2 years or more.

Streamline database gathering of Tenant and Property Owner mailing lists by exploring use of City's rental database to help gather tenant info for required mailings. The mailing lists were previously provided by PBD staff.

PMWeb Gather, validate, implement Phase II Requirements, including implementation of single sign on using the City's Azure Active Directory, deployment of the Planning Module, capturing and implementing singificant missed requirements from Phase I; identifying new processes, such as improving the Oracle Integration after EBS move to cloud, ESRI/ArcGIS integration, moving to the City's document management system for storage; development of a new Vendor Portal, incluidng a specific landing page for vendors, reports, and help and training documents; define and implement an archival process for CIP project records and documents; Service Now implementation and establishing service level standards for BIAD day-to-day application support; configure, update, maintain intranet site for PMWeb resources.

Page 48 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity Police Staffing Study Staffing study to assess OPD sworn and civilian staff as well as resource allocations to optimize public safety resources
Policy Advocacy Provides research and advocacy services to further the City's affordable housing goals
POS Implementation Implement a new system that serves as a citywide cashiering system, to streamline credit card paymens, remote deposits, cash management and cash reporting in decentralized departments
PPD Issue RFP for On-call Economic Consultant Contracts On Call Economic Consultant Contract to provide economic and financial analysis on priority real estate projects and transactions. Shall serve EWD and misc. City Depts.

PPD - Negotiate Development Agreement Amendment for Brooklyn BasinNegotiate an amendment to the existing Brookyn Basin Development Agreement to support new for-sale housing. Supports work of PBD.

PPD- Execute Men of Valor Contract to maintain city propertyMOVA contract to provide on call clean up services on City Owned properties to prevent illegal dumping etc.

PPD- Issue Next NOA/RFPs on City Owned Sites for Affordable Housing etcIssue NOA/RFPs for city-owned sites for affordable housing (per requiremens of Housing Element) and other priority uses Predevelopment loan program revamp Oakland HCD's current predevelopment loan program offers up to $50k for developers to support their construction work in its early stages. Staff research demonstrates that $50k is far below the amount needed to adequately support developers in their work; thus, staff is examining the existing program and proposing changes that, if council-approved, will increase accessibility and assistance in meaningful ways. There will also likely be unique incentives to support BIPOC and/or emerging developers to increase equity in contracting.

Pre-Employment Credit Checks Contract for 4 years: California Peace Officer Standards and Training (POST) requires pre-employment psychological screenings. The department also requires pre-employment credit checks for all positions. The checks are used as an investigative tool to gauge applicant's ability to confront and overcome problems, obstacles and adversity, which is a California POST hiring dimension.

Pre-Employment Department of Justice LiveScan Contract for 4 years: California Peace Officer Standards and Training (POST) requires a criminal history check. The department also requires pre- employment criminal checks to determine applicant suitability to meet job requirements.

Pre-Employment Investigative Polygraph Examinations (Police Officer Trainee & Dispatcher Applicants)4 year contract totaling $800,000. The unit requires the services of several polygraph service vendors to meet the hiring demands for Police Officer Trainee and Dispatcher applicants. Polygraph examinations are a pre- employment background investigation tool that assists with gathering background information and verifying the accuracy of the information provided by applicants.

Pre-Employment Medical Examinations (Police Officer Trainee & Dispatcher Applicants)Contract for 4 years: California Peace Officer Standards and Training (POST) requires pre-employment medical examinations. Commission Regulation 1953 includes the requirements for conducting peace officer background investigations. The peace officer medical and psychological evaluation requirements are outlined in Regulations 1954 and 1955. Commission Regulations 1956-1960 contain the selection standards for public safety dispatchers. Medical examinations determine applicant's physical suitability to meet job requirements.

Pre-Employment Psychological Exams Contract for 4 years: California Peace Officer Standards and Training (POST) requires pre-employment psychological screenings. Commission Regulation 1953 includes the requirements for conducting peace officer background investigations. The peace officer medical and psychological evaluation requirements are outlined in Regulations 1954 and 1955. Commission Regulations 1956-1960 contain the selection standards for public safety dispatchers. Medical examinations determine applicant psychological suitability to meet job requirements.

Program Transportation Vehicles Provide community recreation centers with vehicles to pickup youth from OUSD and charter schools within the areas and transport them to local community recreation centers for after-school programs.

Page 49 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity Protection Services Strategic Action Plan Oakland HCD's 2023-2027 Strategic Action Plan, produced in spring 2023, focuses primarily on the use of its capital dollars for housing production and preservation. To complement this effort, staff is developing an addendum for the allocation of its service dollars focused on anti-displacement, homelessness prevention, eviction defense, and more. The action plan will include an equity framework that prioritizes how Oakland HCD will administer its service dollars (e.g. CDBG) with a racial equity lens.

Public Bank of the East Bay Create a public bank in the East Bay to sprovide banking for the unbanked and low income individuals that are unable to secure lending from mainstream lending institutions. The bank would be created using only public funds from the City of Oakland , County of Alameda, City of Richmond, and City of Berkeley.

Public Safety Infrastructure Bond Ballot Measure Develop an infrastructure ballot measure that soley supports public saftey buildings and or infrastructure, to fund the replacment / rehab of fire stations and the Police Admnistration building
Purchasing and Contracting Reform Comprehensively streamline procurement processing for basic compliance in the absence of Oracle systematic improvements to gain regulatory compliance with all agencies. This includes personnel reorganization to centralized procurement in the Finance Department, Risk Management Division transfer, contract template and RFP overhaul, comprehensive training plan, City Council Policy recommendations for OMC changes, and updated Administrative Instructions
Radio Encryption Encrypt patrol channels 1 through 5, in addition to others suggested by Radio. Medium project.

RE - new Police Administration Building Public-private partnership to finance and develop a new police HQ RE - Oakland Ballers ballpark at Raimondi License, lease and/or gift in place for new minor-league baseball game venue
RE - Oakland Roots temporary stadium 10-year lease of the City/County-owned Malibu parcel to the Oakland Roots for development of a interim stadium
RE - Remnants/ Small Site Disposition Develop and implement a strategy for the disposition of City-owned remnants, sliver parcels, and other small sites not suitable for large scale development in order to generate sales revenue and reduce maintenance and security expenses.

Reactivation of Closed EMT sites NSD is working closely with our EMT to identify closed sites and coordinate with Environmental Services to promote Adopt a Spot as a way to have residents maintain and create community gardens to prevent re- encampment of the site. This initiative was developed because of the increasing EMT site list and the re-encampment rate of sites cleared by Recruitment Advertising & Promotion Advertise various law enforcement positions available with an emphasis on Police Officer Trainee and Dispatcher positions. Advertising may include print, display, paid search, broadcast, and social media.

Reforming HRM Processes Council granted HRM $250k to review HRM processess and implement improvements, where they are identified.

Reimagining Citywide Permits (RCWP) Fee Study Engage consultant to finalize fee studies for departments' permitting functions by January 2025 and better understand which classificaitons and positions across all depts are appropriate for support from the Development Services Fund (2415).

Reimagining Citywide Permitting (RCP) Accela improvements:
a. CGS/PX app implementation
b. Accela workflow updates
c. Accela electronic plan review
d. Accela parklet permit
e. Accela ROW Module
f. Accela Project Scoping Tool
g. Accela permit / OakDOT CIP project integration
h. Accela permit / Inspections app integration
i. Expand ACA to include all DOT permits

Page 50 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity Reimagining Citywide Permitting (RCWP) Project Interdepartmental initiative to improve Oakland's permitting processes to achieve fair, consistent, equitable outcomes. Project includes many components to enhance systems/technology, staffing, fees, data and records management, customer service, communication and engagement, and other efforts.

Rent Adjustment Program (RAP): Community Engagement and Public EducationPrepares materials that provide information and guidance on rent and eviction laws at local, state and federal levels to educate public about their rights and responsibilities under these laws. Engages in extensive public outreach to disseminate this information.

Rent Adjustment Program (RAP): Housing Counseling and HearingsProvides holistic counseling to tenants and property owners regarding RAP laws, including just cause for eviction and eviction moratorium. Reviews petitions, hears cases, renders decisions, reviews appeals, coordinates appeal hearings before Rent Board.

Replace Interview Rooms Need to replace six interview rooms in the PAB with new hardware/software. This upgrade will allow us to upload video directly to Evidence.com. Minimal ITD involvement - opening ports and some Telco, Axon will handle most of the installation work.

Replace PAB Auditorium Screen Replace PAB Auditorium AV equipment that’s bad (Screen). Minimal ITD involvement.

Restoration of Park Rangers Study and finalize the proposal to restore the use of Oakland Park Rangers Restoration of Parks Services within OPRYD. In an effort to improve parks, maintenance, and recreational service delivery, reduce deferred maintenance, address urgent infrastructure issues, and streamline capital improvement projects OPRYD is proposing various functions that fall within other city departments or formerly housed within OPRYD be transferred back to our department. OPRYD has identified supervisory, management, and subordinate front line staff dedicated to parks, landscape maintenance, and recreational services that would fulfill these necessary services and achieve the goals of the Measure Q parcel tax.

These areas include but are not limited to park maintenance, building maintenance and custodial services at OPRYD parks, facilities, and restrooms, ballfield maintenance, pool maintenance, capital improvements of parks and recreation facilities, and other parks & recreation services related functions.

SA-Developing Oakland's Film Industry The Mayor's Office has identified developing Oakland's film industry as a economic development priority; however, with no current funding available to subsidize fees of film productions, this project appears mostly in the planning stages
Saigon and Lakeshore Violence Suppression Robbery/Burglary suppression in Area 3 Business Districts Scholarship Gala Scholarship Gala for OPRYD Programs and Services to tell the OPRYD story.

Community engagement, invite donors, network and build connections.

Hosting a Scholarship Gala can have a positive impact on OPRYD and the community.

See "Supplemental LiƩer & Trash Abatement + Homeless Encampment Clean-Up Contract" above.The contract will service multiple departments - OPW, EWD, HCD and DOT.

This portion of the contract scope of work consists of abating dumping from City creeks. Contractor/s will respond to OAK311 reports of illegal dumping in creeks on City property, coordinate clean-ups with KOCB operations and/or Parks and Tree Services Division (PTD) operations as needed, collect and bag debris, organize bulky waste in centralized location, and contact OAK311 or designated KOCB or PTD personnel for bag/debris pick-up.

A citywide contract for one or more contractors to provide supplemental support with litter & trash abatement and homeless encampment clean-up throughout the City.

ServiceNow Study and System Functionality Enhancements Not started: Examining possible solutions to enhance City services; capitalizing on the existing ServiceNow platform

Page 51 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity Sewer and Storm Drain Smart Maintenance Hole Cover Sensor ProjectThis project builds upon an initial pilot deploying water level and flow volume snsors in sewer maintenance holes at critical/environmentally sensitive locations such as in and around lake Merritt and Lake Temescal.

The sensors provide an "early warning" capability of potential sewer and storm drain pipe concerns such as partial obstructions, but also when deployed more extensiveley will be used to establish baseline water flow data and can then be used to focus response efforts such as; prevent sewer spills before they occur, precisely tailor high-frequency preventive maintenance based upon actual condition rather than set time schedules; perform preventive mantenance in advance of storm events; identif potential sources of infiltration and inflow; identify potential contractor caused damage before spills; monitor real time tide levels at crticial storm drain outfalls (such as Coliseum Connection); identify, documen, and establish baseline reverse water flows (tidal inflow) at critical locations such as Coliseum Conection).

Short Term Rental Short Term Rental
Sideshow Prevention Pilot Install engineering treatments to sideshow locations prioritized by OPD.

Sidewalk Parking Enforcement Years long effort to correct the record on sidewalk parking on narrow streets
Skyline Blvd Evacuation Corridor Project In 2021, CAL FIRE provided the City $824K to remove or prune dead or hazardous trees along the Skyline Blvd Evacuation Corridor. The project is now 90% complete. An additional grant application for $1M has been made for phase 2 of this project, though awards have not yet been announced.

Software contracting for improved tow operations Adopt software and multiple tow service contracts to expedite the removal of abandoned autos. This program may also be expanded to tow vehicles violating expired parking limits.

Speed safety cameras AB 645 (Friedman) authorizes 6 cities in California, including Oakland, to pilot the use of automated speed enforcement systems. The legislation outlines numerous requirements in order for the City to stand up an automated speed enforcement program, including development of a Use Policy and Impact Report that will need to be vetted and approved by the Privacy Advisory Commission, community engagement, and technical analysis and data collection/evaluation to be compliant with the pilot program. Beyond intial start up resourcing needs, the City will need identify funding to support procurement of automated speed enforcement systems and vendor support for the processing and serving of notices of violation.

SSBT-Black Cultural Zone Food Hub SSBT is partnering with the Black Cultural Zone to establish a Food Hub at Arroyo Viejo Recreation Center which will be available to the community for use as a commericial kitchen.

Storm Drainage Funding Ballot Measure - amount needed unknown at this timeFunding will be needed in the future for a storm drainage funding ballot measure. A sustainable source of funding is needed to maintain, repaire, and upgrade/improve the City's deteriorating storm drainage network and to comply with stringent, costly, and increasing stormwater quality regulations, some of which require capital improvements to the storm drainage network through trash capture and green stormwater infrastructure. City of Oakland has no stormwater fee to maintain, repair, and improve the City's deteriorating storm drainage system or to fund compliance with the Municipal Regional Stormwater Permit, a National Pollutant Discharge Elimination System permit issued by the San Francisco Bay Regional Water Quality Control Board. The City has very limited dedicated funding for these high priority funding needs.

Sugar Sweetened Beverage Tax (SSBT) Programs software applicationSSBT division is partnering with ITD to develop an application for tracking Summer Food Service Program data. Last year, the SFSP distributed 120,000 meals at 50 sites across the city last year.

Sundays in the Redwoods (4)- Partnership or Collaboration Collaborate with Event Promoter to bring culturally diverse concerts to Woodminster Amphitheater and other City parks.

Page 52 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity Supplemental Litter & Trash Abatement + Homeless Encampment Clean-Up Contract - $1.5M to $2M per yearA citywide contract for one or more contractors to provide supplemental support with litter & trash abatement and homeless encampment clean-up throughout the City.

The contract will service multiple departments - OPW, EWD, HCD and DOT.

The scope of work consists of abating dumping from City creeks, City lots and other City assets, and City rights of way, especially where cooperation from the unhoused is required.

Sustainability & Energy Division - US EPA grant The City is jointly applying with East Bay Asain Local Development Corporation (EBALDC) and Healthy Havenscourt for a US Environmental Protection Agency (EPA) Change Grant, to expand the service area for tree planting and additional funding for the Prescott Greening Project in West Oakland. this is a $20 million proposal.

Sustainability & Resilience Division Urban Forest Plan FellowshipThrough a partnership with Bloomberg Philanthropies, City of Oakland will receive three fellows to support the Urban Forest Plan implementation in coordination with an $8.5 million grant form the USDA Department of Forestry, with a focus on engaging frontline communities, especially African American entreprenuers located along impacted commercial corridors, to help them contract with the City in the implementation of the urban forest plan. the Bloomberg award is valued at $2.5 million for a total combined amount of $10.5 million.

Targeted Community Outreach To conduct targeted outreach to those communities who don't know about the Whistleblower Program or are disinclined to report.

Tentatively, "10-hr Supplemental Training" 10-hr, supplemental training provided to all sworn personnel to cover relevant, field-based topics or areas of concern such as laws of arrest, arrest and control, critical incident management, and field-based tactics.

Time tracking system (Telestaff Replacement) Replace Telestaff with another system. RFQ has started, we have a vendor in mind. Funding has been identified via grants. Minimal ITD involvement - help with SAML.

Traffic Fatality Rapid Response Program Investigate traffic collisions that result in fatality/severe injury to bicyclists/pedestrians to implement safety improvements.

Trash Cart Pilot Upgrade Program The Trash Cart Pilot Upgrade Program provides residents, on one single trash collection route that crosses Councils District 6 and 7 along International Boulevard, with larger trash containers at no extra cost for three months. The Pilot Program aims to evaluate the impact of larger trash capacity on decrease in trash container overage incidents; reduction of contamination to recycling and organics collections; and decrease of illegal dumping and/or overflowing street litter container abatement requests along and near the collection route.

Two Allocations of $800K ($1.6M total) for FY21-23 and FY23-25Each $800K allocation provided $100K per Council office to identify traffic safety or violence prevention treatments in their district at their discretion.

Upgrade KTOP Live Stream Upgrading local network in master control to enhance streaming capabilites (Cost TBD & paid from Fund PEG 2999)
Urban Forestry Inflation Reduction Act (IRA) grant $8M offered by US Forest Service for street tree maintenance, tree planting, and green job creation in Oakland's frontline communities. Approximately $4M will go to the City, $4M will go to non-profit partners.

Vegetation Management Plan Implementation The Vegetation Management Plan (VMP) is expected to be completed in 2024. This Plan strategizes vegetation management in the Oakland Hills for the sake of fire risk prevention and mitigation. Oakland Public Works will play a role in implementation by managing vegetation and reducing fuel loads on 1,000+ acres of City-owned open space parks and forested land in the high fire risk areas. City positions dedicated to this work, including the Parkland Resources Supervisor position, were downsized over 15 years ago but would need to be restored to achieve implementation.

Violence Prevention Pilot Apply eningeeinr measures to reduce crime/undesirable activies in public ROW.

West Oakland Resiliency Hub Co-located Library, Senior Center, OPRYD and Emergency Services in a robust and flexible building
WIOA - California Volunteers Grant Conservation and beautification Workforce Training Opportunities through public service

Page 53 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Race & Equity Youth Voter Registration Voter approved Measure QQ to create a system that will house voter registration for youth ages 16 & 17 years to vote for OUSD School Board Directors (Cost to be or exceed $500K)
Transportation
AB43 Speed Limit Reduction Bill Modifications to speed limit laws increasing local jurisdictions' authority to lower local speed limits to reduce death and injuries caused by speeding.

Alternative Delivery Methods for Capital Project Delivery Develop AI's for Construction Manager General Contractor (CMGC) project delivery, and develop and execute an RFQ for a CMGC contract to deliver Embarcadero West and/or speed safety cameras
Bus Shelter Maintenance Franchise agreement for bus shelters is expiring. Current agreement maintains shelters at no cost to City in exchange for advertising revenue.

OakDOT working to identify options to maintain shelters in the future, including inventorying existing shelters, estimating maintenance costs, and evaluating methods to procure maintenance services at low/no cost.

Shelters are a critical amentity for transit riders.

Citywide Daylighting Implementation AB 413 (Lee) establishes de facto daylighting zones (i.e., parking restrictions within 20 feet unmarked or marked crosswalk or 15 feet of any crosswalk where a curb extension is present) across the state. While AB 413 establishes a statewide standard, it does not allocate state funding to support implementation. Absent additional resources, OakDOT’s approach will be to implement these new state standards through red curb paint when OakDOT stripes a new crosswalk as part of an existing project (e.g. street repaving) or is responding to a related service request.

In terms of enforcement, the Parking and Enforcement Unit will be training staff on the new requirements of the bill and will be developing a Standard Operating Procedure for enforcement by 2024 Q3. In 2024 Q4, after training of PEU is and the SOP is completed, OakDOT will issue warnings, publicly report the results from this warning period, and adjust the SOP as-needed in support of a transparent and equitable enforcement implementation process. Beginning in 2025, PEU will enforce AB 413 violations per the revised SOP.

OakDOT has also identified the need to evaluate and analyze the placement of existing metered parking spaces, commercial loading zones, and blue disabled placard zones that may need to be removed due to conflict with the new de facto state standard.

Comprehensive Fee Study Revisit all Development Service permit and inspection fees to align with current costs and operations
Demand Responsive Parking Flex meter rates to achieve optimum utilization of parking supply. 2013 City Council Resolution Parking Principles
$1.5million grant from MTC includes full scope and deliverables Filling the Maintenance Gap Assessing the growing gap between capital project dollars and maintenance dollars over time, funding sources for maintenance, and unsuccessful efforts to identify funding sources to help understand the need.

FY21-23 Council Earmarks Duplicate to DOT.SP8
Using availabe 2218 fund balance, Council identified specific traffic safety projects in their districts for OakDOT to implement.

IKE (Interactive Kiosk Experience) Digital Kiosks Support IKE's franchise agreement, authorizing up to 50 digital kiosks in the right of way
Increase on-street parking rates from $2.00 to $3.00 (50% increase).Increase on-street parking rates from $2.00 to $3.00 (50% increase). Cost of living adjustment accounts for no rate changes since 2009 Lakeshore Avenue Protected Bike Path Project Implement bike lane safety improvements on the East side of Lake Merritt.

Page 54 of 55 ends

Special Projects List by Department
(Preliminary Raw Data)
Attachment F
Department Special Project Name Special Project Description Transportation Reimagining Citywide Permitting (RCP) Accela improvements:
a. CGS/PX app implementation
b. Accela workflow updates
c. Accela electronic plan review
d. Accela parklet permit
e. Accela ROW Module
f. Accela Project Scoping Tool
g. Accela permit / OakDOT CIP project integration
h. Accela permit / Inspections app integration
i. Expand ACA to include all DOT permits
Sideshow Prevention Pilot Install engineering treatments to sideshow locations prioritized by OPD.

Sidewalk Parking Enforcement Years long effort to correct the record on sidewalk parking on narrow streets
Software contracting for improved tow operations Adopt software and multiple tow service contracts to expedite the removal of abandoned autos. This program may also be expanded to tow vehicles violating expired parking limits.

Speed safety cameras AB 645 (Friedman) authorizes 6 cities in California, including Oakland, to pilot the use of automated speed enforcement systems. The legislation outlines numerous requirements in order for the City to stand up an automated speed enforcement program, including development of a Use Policy and Impact Report that will need to be vetted and approved by the Privacy Advisory Commission, community engagement, and technical analysis and data collection/evaluation to be compliant with the pilot program. Beyond intial start up resourcing needs, the City will need identify funding to support procurement of automated speed enforcement systems and vendor support for the processing and serving of notices of violation.

Traffic Fatality Rapid Response Program Investigate traffic collisions that result in fatality/severe injury to bicyclists/pedestrians to implement safety improvements.

Two Allocations of $800K ($1.6M total) for FY21-23 and FY23-25Duplicate to DOT.SP4 Each $800K allocation provided $100K per Council office to identify traffic safety or violence prevention treatments in their district at their discretion.

Violence Prevention Pilot Apply eningeeinr measures to reduce crime/undesirable activies in public ROW.

Page 55 of 55 ends
← All documents from this meeting