If you're heading out to SF and enjoy transit related movie sites, I have a few of recommendations for you. First up, the movie that is supposed to be the most accurate as far as SF location continuation is is Alfred Hitchcock's
Vertigo. I believe that there are a few scenes of cable cars and trolleys in the movie. Another older movie (70's) is
The Laughing Policeman in which a mass murder takes place on a Muni Mack bus with numerous shots inside the East Bay Terminal (Transbay Terminal) which previously hosted trolleys and interurbans from Market Street Railway, Muni, Sacramento Northern, Key System, and Southern Pacific. (Just terminal and buses in the movie- no trolleys unfortunately.) If my memory serves me correctly, there are a few good cable car shots in
Dark Passage with Humphrey Bogart, as well as
D.O.A.(the original), although unfortunately in D.O.A., the movie switches locale early on from SF to LA. For a really different history tour of the "darker" side of SF, give my friend Kitty Burns a call (link below) for a "Vampire Tour", which is actually mostly fact with a little fiction thrown in for atmosphere. Tell her that I sent you and you'll get a 0 % discount on your price of admission ! Among other things, you'll learn about one of the "Big Four" railroad founding millionaires who had a tunnel built underneath California Street from his mansion to create a secret passage to the residence of his mistress. And of course I would feel remiss if I didn't mention my all-time favorite movie,
Bullitt. Short on transit locations (unless you're an airport buff) but just one great SF movie ! Have fun !
http://www.sfvampiretour.com/