There's plenty of warehouse office space in SOMA that could meet residential coding requirements. I think most people in this thread are imagining converting high-rise open plans, like Salesforce tower - but most offices in SOMA are actually in warehouse space that's easier to convert. That's why I linked an example of live/work lofts.

Which isn't to say we shouldn't utilize outer Sunset space too! There's already great public transport to the SOMA area though.

It's a shame to let commercial real estate rot in forbearance, when it's surrounded by the infrastructure needed for excellent city living.