The real crux of the issue is that the major west coast cities are being tasked with dealing with a nationwide drug and mental health crisis and there just isn't the money to humanely handle the problem. So you end up with people who correctly say that locking people up in prisons for personal drug use is inhumane and doesn't address their problem, while at the same time other folks correctly point out that people should have access to a clean and safe city and not need to watch for needles and human shit.
The federal government needs to provide funding for the west coast states to build more drug treatment centers, funding to train treatment providers, and more funding for mental health services. There are anti-social people who don't belong in jail but can't be on the street, right now there is nowhere for them to go.