San Francisco is currently in a building boom. Over the next 25 years, there is going to be approximately 92,000 more housing units. The population of San Francisco should reach 1 million by then. Here are some links:
It's important to point out that 92k units is the amount needed to accommodate future growth. The creation of those units is entirely dependent on local politics, which is even more polarized here than in NYC.