http://therealdeal.com/2013/11/12/tf-cornerstones-606-west-5...
https://en.wikipedia.org/wiki/Riverside_Park_Community
It's also a monster of a building. I kind of get the NIMBY vibe if it's about that, it's just too big, sucks up all the energy.
There are a few like that this (Galaxy Towers in Guttenberg). They're all old, though, they don't build new stuff like that.
But you don't need tons of high-rises. Having everything be free-standing buildings is the larger problem. Blocks of mid-rises is what drives density in places like Paris: https://agingmodernism.wordpress.com/category/sarcelles.
I have no idea what fraction of the floor area is apartments, but if it was all of it, they would average 3968 square feet, which seems huge. If everyone got the same modest but comfortable 820 square feet i have, there could be 503 apartments. At that rate, you'd need about 400 towers to make 200 000 apartments.
More moderate apartment buildings would have had several units per floor, but that building was built to be the most prestigious in the city.
http://therealdeal.com/wp-content/uploads/2015/07/NYC-Condo-...
[edit]
Thanks for all the replies!
So it looks like we are talking about a minimum of hundreds of buildings to be torn-down and rebuilt taller. That seems unlikely to happen in SF proper.