Mandating some percent of units be "affordable" or charging various taxes which go towards building affordable is not unprecedented. But those strategies succeeding might be. ;)
Kinda hard to tell, since they only allow a few new residential buildings to go up each year. If they didn't allow NIMBY interests to prevent _any_ housing from going up, we might actually see this in action and be able to tell.
As it stands now, it's next to impossible to build in the city.
Frankly, subsidized housing succeeds in many districts. Once SF and -more generally- the SFBA decide to stop lining the pockets of real estate speculators and investment firms and start building housing to meet the current and future demand, we'll see a change in the character of the area for the better.
By making -as San Francisco does- a condition of the building permit that the developer either make X% of the newly constructed housing "affordable housing", or pay the city what it would cost the city to build that many units of "affordable housing". This is far from unprecedented. :)