Like everything to do with housing in CA, this idea is ruined by Prop 13. If San Francisco's property tax collections had been allowed to rise with property taxes, their tax revenue would naturally rise as land values rose and they would be able to afford land no matter how high the land values got. However Prop 13 stops their tax revenue from rising as fast as land values so land becomes increasingly unaffordable to them as land values rise.