Can you get this location deemed a hot spot with the city? I've heard of a location in my area being deemed a hot spot, but I never asked how it got deemed a hot spot. I do know someone stayed on top of repeated complaing and working with various city departments including their Neighborhood Service Coordinator and police beat officer. If you're really interested and willing to roll your sleeves up, I'd call 311 which is city of Oakland call center and tell them the problem and what you want to happen. It's a process and you have to have patience and never give up but follow up often and consistently.

Thanks for the info i’m just fed up with this issue like you say I need to roll up my sleeves and take this further..

You're welcome. I wouldn't have text this information if it's useless. I complained about a corner in my area that had bbq pits several chairs with people loitering everyday and night. Obvious drug transactions taking place, cars pulling up, prostitution, dumped trash abandoned vehicles with people living inside them. Today it's been about 4 months clean. It wasn't easy but I kept on top of complaints to best officer and neighborhood service coordinator and communicated with supervisor of 311 call center. It was a very very frustrating thing to do, but you can make things change for the better and with help from the proper service providers. You will be kept in the dark and feels like no one is responding to your issue, that's why you have to be the one to reach out and follow up.

The City of Oakland addressed this issue on 11/11/2020, service request #1063245.