First, get rid of the zoning laws that require those spots, then they'll disappear. You can cram (depending on building height restrictions) dozens of apartments in to the same 2 dimensional plane as those 3 parking spots.
The problem then is parking in commercial districts. Street parking is good for businesses on that street, but a better solution could be more city-run parking garages in good locations, and city streets in commercial areas that are optimized for pedestrians.
The best example of this I have ever seen is down-town Silver Spring in Maryland. That was several years ago, I hear they tore a bunch of it up, but it at least used to be great.
Here in London new residential buildings are built with zero parking spaces (just a small a shared drop-off/deliveries area). There are already too many cars in the city, and public transport is good enough for most people (of course there are people who for good reasons need cars, but they're the exception rather than the rule).
Read: The High Cost of Free Parking http://www.uctc.net/papers/351.pdf
If there were more parking garages, there would be less asphalt sprawl.
Mandatory parking garages inside apartments is a bad method, but the goal is admirable. No surface parking, no matter how many cars.
http://sf.streetsblog.org/2015/03/02/supervisor-breed-calls-...
What such systems do allow is for vehicle storage to be separated from high-density land-use. A self-driving vehicle can be told to go park itself elsewhere, a dispatched vehicle doesn't need to park while the passenger is otherwise occupied.
But both still occupy street space, and require storage space somewhere.
A ~450 sqft studio apartment in SF costs about $2k/mo in rent.
a ~150 sqft monthly parking spot (as per http://sanfrancisco.bestparking.com/), costs about $400
Three parking spots takes up the same square footage as a studio apartment. It costs a little over half of that.
Then consider how much parking in SF is free parking. Just straight up free. Parking lots for stores. Street parking on most residential streets. Driveways and garages.
It's fucking insane how much space is wasted on car storage. It's even more fucking insane that so much of this storage is de-facto free (which is implicitly a subsidy from the person providing the space to car owners; in a sense it's a subsidy from renters, since any parking space could be a sorely needed living space instead)
I can't wait, I just can't wait until Uber-like on-demand ride tech + self driving cars means we can massively reduce our vehicle stock. Think of all the things that could be more awesome