Peer-reviewed research: https://pubmed.ncbi.nlm.nih.gov/20063061/ & https://jamanetwork.com/journals/jama/fullarticle/183666
i remember having a conversation with a LICSW who did a tremendous amount of work with drug addicted and homeless populations; she explained that when she really needed to, she could "beg, borrow, or steal" a way to find better housing for someone, but that really wasn't the crux of solving the individual's problems, it's only one facet.
even if someone who has untreated mental illness or drug addiction suddenly has a great new place to live, they're not going to stay at that address long if their other needs aren't treated.
i'm not saying there shouldn't be more affordable housing ASAP, or that it wouldn't radically improve some lives, but i get the impression that a lot of folks think homelessness is mainly a housing problem when it's really not so simple, and i think that needs to change if the problems have any chance at getting improved.
Houston has done it, and it can be done: https://www.nytimes.com/2022/06/14/headway/houston-homeless-...
There's an entire thriving economy in SF with jobs these people could be doing. What aren't they doing them? If cost of living is too expensive there, why not go to a cheaper city and do work there? If they have skills to be a white collar worker, SF is a great place to do that work and easily afford housing. Why aren't they doing it? Mental illness and drugs dominate the problem by such an order of magnitude that anything else save for harsh imprisonment to get off streets....especially subsidization of their lifestyle, will accomplish less than nothing.