To think this through: very few homeless people were born in San Francisco. Everyone has freedom of movement in this country. If San Francisco commits to house everyone within its municipal boundaries, we'll need to be prepared to house all the homeless from the rest of the state and the country as well.
In other words, the problem has to be solved at a national level.