>>>No other American city has built as much affordable housing per capita, according to the Bay Area Council Economic Institute. From 2004 to 2014, the city spent $2 billion on nearly 3,000 new units of permanent supportive housing.

You’re conflating addressing “housing transience” with addressing “addiction, mental illness, and criminal antisocial behavior”. Additional housing units don’t resolve this problem.