I dunno what your N=1 point is supposed to mean. Being a sanctuary city is a progressive policy. And calling needle exchange a straw man is odd. How is it a straw man? A straw man means I'm setting up a fake version of my opponent's argument and arguing with that. It's an example of a progressive policy that exists. You seem to be saying it's not progressive because it doesn't solve the root causes. So the only cities that get to be considered progressive have to SOLVE drug addiction? I don't buy into that definition of progressivism. A harm-reduction drug program is a hallmark of progressive cities all over the world.
Here is SF's free and subsidized housing policy. It does exist. https://hsh.sfgov.org/services/the-homelessness-response-sys...
They have 12,000 units. You as a resident will pay between $25 per month and up to 30% of your income (if you have one). I don't believe any of these are shelters. You confidently claim something doesn't exist that a two second google search brings up. Private residence, long-term, extremely subsidized housing does exist in San Francisco. I'm not saying it's adequate, perfect, or solves the homeless problem, but it exists.
My points follow a simple premise. I think SF has sufficient policies to be considered a "progressive" city, and I gave examples of progressive policies. I am not going to do the HN thing where you go back and forth snip-quoting each other's points, that misses the forest for the trees. But if SF is not progressive, then no city in North America is.