Atlanta and Houston were dealing with high number of 'mentally healthy and sober' homeless. They were ripe for rehousing, and the project was a relative success. DO NOT EXTEND THESE INTUITIONS TO YOUR TECH CITY.
Seattle and SF have seen an alarmingly high base/growth of mentally unhealthy homeless with substance abuse issues. Houston's solutions will not work here. There is reason a that residents of NYC do not complain about their homeless populations as much. They are overwhelmingly sheltered and able [3]. On the other hand, Seattle resident complain more about the sub-human interactions (property crime, harassment, flashing, open defecation) caused by for which the proportionally-larger mentally-ill/addicted population. Guess which city had an anomalous jump in meth consumption over a couple of years. It's Seattle [4]
Drugs and mental health are at the center of the homelessness, crime, urban fallout and lack of safety in west coast tech cities. It is a hard problem with no good solutions, but ""compassion"" and abolition are certainly not it. The safety of 'mentally healthy and sober' homeless can only be ensured through the Institutionalization (institutional care or forced social isolation) of the mentally ill and drug addicted.
Homeless shelters, social welfare workers and protection from police harassment are good learnings to pick from other cities. However, Seattle and SF should also consider reopening psychiatric hospitals, forcing mandatory rehab and unfortunately imprisoning repeat violent offenders who refuse care. Some might call it inhumane. But, it provides rehabilitation for those willing to seek care, it provides safety for those who've 'fallen on hard times' and makes the difficult decision to socially-isolate the small but dangerous minority within them. If you have a better solution, I am all ears.
Last but not the least, NIMBYism is selfish. It is okay to be selfish. But do not claim to fight injustices, for then you'd be a hypocrite. It is not okay to be hypocrite.[5]
[1] https://dynomight.net/homeless-crisis/
[2] https://imgur.com/a/KNbgDHr
[3] https://dynomight.net/img/homeless-crisis/coc/NY-New%20York%...
[4] https://dynomight.net/img/homeless-crisis/coc/NY-New%20York%... (sauce : https://dynomight.net/p2p-meth/)