Third Street Bridge (aka Lefty O'Doul Bridge) located over Mission Creek on 3rd Street in SOMA neighborhood is one of San Francisco's Landmarks. It was built in 1932 and then it was a masterpiece of engineering:
I would love to see it open one day. For now, the video below has to be good enough for me:
Isn't it impressive how it folds over the street?