Film_Locations_in_San_Francisco_fts

Data source: data.sfgov.org

1,622 rows

View and edit SQL

Link rowid ▼ Title Production Company Director Writer Actor 1 Actor 2 Actor 3 Locations Fun Facts
1 1 1 1 1 237 1 439 Epic Roasthouse (399 Embarcadero)  
2 1 1 1 1 237 1 439 Mason & California Streets (Nob Hill)  
3 1 1 1 1 237 1 439 Justin Herman Plaza  
4 1 1 1 1 237 1 439 200 block Market Street  
5 1 1 1 1 237 1 439 City Hall  
6 1 1 1 1 237 1 439 Polk & Larkin Streets  
7 1 1 1 1 237 1 439 Randall Museum  
8 1 1 1 1 237 1 439 555 Market St.  
9 2 2 2   238        
10 3 3 3 2 239 2   The Walden House, Buena Vista Park Established in 1867, Buena Vista Park is the oldest official park in San Francisco.
11 3 3 3 2 239 2   Café Trieste (609 Vallejo) Francis Ford Coppola allegedly wrote large portions of "The Godfather" trilogy in Café Trieste.
12 4 4 4 3 19 3 440    
13 5 5 5 4 240 4   Rainforest Café (145 Jefferson Street)  
14 6 6 6 5 241 5   20th and Folsom Streets  
15 6 6 6 5 241 5   Golden Gate Park During San Francisco's Gold Rush era, the Park was part of an area designated as the "Great Sand Waste".
16 7 7 7 6 242 6   Embarcadero Freeway Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake)
17 7 7 7 6 242 6   Fairmont Hotel (950 Mason Street, Nob Hill) In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room.
18 7 7 7 6 242 6   San Francisco Chronicle (901 Mission Street at 15th Street) The San Francisco Zodiac Killer of the late 1960s sent his notes and letters to the Chronicle's offices.
19 7 7 7 6 242 6   Broadway (North Beach)  
20 8 4 8 7 243 7   75 California Street  
21 9 4 8 7 243 7   Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral.
22 9 4 8 7 243 7   Hills Brothers Plaza (Embarcadero at Harrison Street)  
23 9 4 8 7 243 7   San Francisco International Airport SFO has a museum dedicated to aviation history.
24 10 8 9 8 244 8 441 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building.
25 10 8 9 8 244 8 441 Port of San Francisco  
26 11 9 10 9 245 9   420 Jones St. at Ellis St.  
27 10 8 9 8 244 8 441 Lefty O' Doul Drawbridge/ 3rd Street Bridge (3rd Street, China Basin) This is SF's only drawbridge, and was named after Francis Joseph "Lefty" O'Doul, a local baseball hero.
28 10 8 9 8 244 8 441 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937.
29 10 8 9 8 244 8 441 Embarcadero Freeway Embarcadero Freeway, which was featured in the film, was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake)
30 10 8 9 8 244 8 441 Potrero Hill The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St.
31 10 8 9 8 244 8 441 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building.
32 10 8 9 8 244 8 441 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US.
33 10 8 9 8 244 8 441 Burger Island (901 3rd Street, China Basin)  
34 10 8 9 8 244 8 441 Van Ness Avenue  
35 10 8 9 8 244 8 441 Taylor and Jefferson Streets (Fisherman's Wharf)  
36 12 10 11 10 246 10   Broderick from Fulton to McAlister  
37 12 10 11 10 246 10   Crissy Field  
38 12 10 11 10 246 10   Powell from Bush and Sutter  
39 13 8 12 11 247 11 432 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way.
40 14 11 13 12 248 12 442 Pier 50- end of the pier  
41 14 11 13 12 248 12 442 California @ Montgomery  
42 14 11 13 12 248 12 442 Montgomery/Green  
43 14 11 13 12 248 12 442 Driving various SF Streets  
44 14 11 13 12 248 12 442 Plate Shots SF streets various  
45 15 12 14 13 249 13   Filbert St. from Jones to Mason  
46 15 12 14 13 249 13   Leavenworth from Filbert & Francisco St  
47 15 12 14 13 249 13   Chestnut St. from Larkin to Columbus  
48 15 12 14 13 249 13   Francisco St from Larkin to Polk  
49 15 12 14 13 249 13   Broadway from Mason to Taylor  
50 15 12 14 13 249 13   Taylor St. from Broadway to Filbert  
51 11 9 10 9 245 9   Broadway between Powell and Davis Driving shots
52 16 13 15 14 250 14 443 Cliff House (1090 Point Lobos Avenue) In 1887, the Cliff House was severely damaged when the schooner Parallel, abandoned and loaded with dynamite, ran aground on the rocks below.
53 16 13 15 14 250 14 443 San Francisco Bay  
54 16 13 15 14 250 14 443 Fairmont Hotel (950 Mason Street, Nob Hill) In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room.
55 17 14 16 15 251 15 444 Curran Theater (445 Geary Street) Called the Shubert Theatre in the film.
56 18 15 17 16 252 16 445 Mel's Drive-In (Corner of Van Ness & Mission Street, Mission District) This restaurant location was demolished; however another Mel's was reopened in 1986 on 3355 Geary Blvd.
57 18 15 17 16 252 16 445 3355 Geary Blvd.  
58 19 16 18 17 253 17      
59 20 17 19 18 254 18 446 St. Francis Episcopal Church (399 San Fernando Way)  
60 20 17 19 18 254 18 446 Romolo Place @ Fresno St.  
61 20 17 19 18 254 18 446 Palace of Fine Arts  
62 20 17 19 18 254 18 446 John Shelley Drive John McLaren Park  
63 20 17 19 18 254 18 446 Treasure Island  
64 20 17 19 18 254 18 446 The San Francisco School (300 Gavin St.)  
65 20 17 19 18 254 18 446 33 Spruce St  
66 20 17 19 18 254 18 446 Coi Restaurant (373 Broadway)  
67 20 17 19 18 254 18 446 Foreign Cinema (2534 Mission)  
68 20 17 19 18 254 18 446 Bernal Heights Park  
69 20 17 19 18 254 18 446 Jackson St. at Spruce  
70 20 17 19 18 254 18 446 679 Madrid St  
71 20 17 19 18 254 18 446 Roxie Theater (3117 16th St.)  
72 20 17 19 18 254 18 446 Variety Preview Room (582 Market St.)  
73 20 17 19 18 254 18 446 Laguna Honda Hospital; 375 Laguna Honda Blvd.  
74 20 17 19 18 254 18 446 3232 Jackson Ave.  
75 20 17 19 18 254 18 446 20th St and Illinois/Faxon St. and Kenwood/Glenbrook at Mt. Springs  
76 21 18 4 3 3 19      
77 11 9 10 9 245 9   Conzelman Rd at McCollough Rd and down Conzelman Rd. Aerial shots
78 11 9 10 9 245 9   Lombard at Hyde  
79 11 9 10 9 245 9   601 Buena Vista Ave West at Java St.  
80 11 9 10 9 245 9   Columbus between Bay and Washington Driving shots
81 11 9 10 9 245 9   California between Kearney and Davis Driving shots
82 11 9 10 9 245 9   Pine between Kearney and Davis Driving shots
83 11 9 10 9 245 9   Market between Stuart and Van Ness Driving shots
84 11 9 10 9 245 9   Grant between Bush and Broadway Driving shots
85 11 9 10 9 245 9   Intersection of Broadway at Kearney Driving shots
86 11 9 10 9 245 9   Intersection of California at Polk Driving shots
87 11 9 10 9 245 9   Treasure Island, Building #1, Ave of the Palms Aerial and exterior shots
88 22 19 20 19 255     Ocean Beach On Jan. 25, 1878, the King Philip ship crashed in Ocean Beach. Occasionally, the ship's wreckage may be found on the beach-- most recently it was seen in 2007.
89 23 20 21 20 256     Hyde Street Cable Car SF Cable Cars are the only moving National Historical Landmark.
90 24 21 22 21 257 20      
91 25 22 23 22 258 21 447 Fairmont Hotel (950 Mason Street, Nob Hill)  
92 25 22 23 22 258 21 447 Embarcadero around Rincon Park  
93 25 22 23 22 258 21 447 San Remo Hotel (2237 Mason)  
94 25 22 23 22 258 21 447 Huntington Park (California & Taylor Streets, Nob Hill)  
95 25 22 23 22 258 21 447 Driving around Taylor/Pacific/Leavenworth  
96 25 22 23 22 258 21 447 California and Jones St.  
97 25 22 23 22 258 21 447 Another Café, 1191 Pine St at Leavenworth  
98 26 23 24 23 259 22 448    
99 27 24 25 24 245 23 449 Yerba Buena Center for the Arts  
100 27 24 25 24 245 23 449 Transbay Terminal (Mission Street at 1st Street) Built in 1939, the Terminal linked San Francisco, the East Bay, and Sacramento by rail for the first time.

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIRTUAL TABLE "Film_Locations_in_San_Francisco_fts" USING FTS4 ("Title", "Production Company", "Director", "Writer", "Actor 1", "Actor 2", "Actor 3", "Locations", "Fun Facts", content="Film_Locations_in_San_Francisco");
Powered by Datasette · Query took 69.367ms · Data source: data.sfgov.org