One example is the conversion of the Embarcadero freeway into a pedestrian friendly waterfront zone, although that's not quite a fair example given that it took

One example is the conversion of the Embarcadero freeway into a pedestrian friendly waterfront zone, although that's not quite a fair example given that it took an earthquake destroying it to give it the oomph it needed to happen.