Many people don't want to live in SOMA though, and the zoning in most of the city doesn't allow for the same kind of rapid, high-density construction.
At the same time, Weiner's plan to designate everything as "transit rich" was effectively crazy and DOA. If you're on the Market Street corridor, it makes sense to have denser housing. Being up to a mile away from "transit" in a city that is only 7 miles wide was a poorly reasoned stretch. He sadly threw the baby out with the bathwater, setting back any rational discussion of upzoning near actual transit.
[1] https://cs7.pikabu.ru/post_img/big/2017/11/15/4/151072205515...
Allowing land to be treated as a gold bar like store of hoardable value will inevitably leads to a restricted supply.
NIMBYism in SF real estate is all about people protecting their $2+ million investments. If the "gold bar" suddenly becomes a major tax liability NIMBYism will dissipate.
Building regs are only a small part of the story.