Don't forget to price in, account for, factor in, and otherwise adjust the numbers to match externalities, other market irrationalities, sesonalities, etc.

For example, if SF wants to solve housing (providing shelter) by municipally mandated equality between purchasing power of people, this has a certain cost, and this has a certain appeal for some residents. Would they pay more taxes to get council erected units for the less fortunate? Maybe. So these preferences have to be calculated and priced.

Sure, the market would get the most new units online in a given time, which would result in prices falling. But it seems like SF wants an apmost centrally planned solution.