Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | Title | Production Company | Director ▼ | Writer | Actor 1 | Actor 2 | Actor 3 | Locations | Fun Facts |
---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | Epic Roasthouse (399 Embarcadero) | |
2 | 2 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | Mason & California Streets (Nob Hill) | |
3 | 3 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | Justin Herman Plaza | |
4 | 4 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | 200 block Market Street | |
5 | 5 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | City Hall | |
6 | 6 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | Polk & Larkin Streets | |
7 | 7 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | Randall Museum | |
8 | 8 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | 555 Market St. | |
9 | 9 | 2 | 2 | 2 | 238 | |||||
10 | 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 | 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. | |
288 | 288 | 53 | 43 | 3 | 49 | 280 | 42 | 463 | 60 Leavenworth St. | |
289 | 289 | 53 | 43 | 3 | 49 | 280 | 42 | 463 | Blue Danube Café, 306 Clement | |
290 | 290 | 53 | 43 | 3 | 49 | 280 | 42 | 463 | San Francisco Art Institute, 800 Chestnut | |
291 | 291 | 53 | 43 | 3 | 49 | 280 | 42 | 463 | Laguna Honda Hospital | |
292 | 292 | 53 | 43 | 3 | 49 | 280 | 42 | 463 | 350 Santa Ana Ave. | |
293 | 293 | 53 | 43 | 3 | 49 | 280 | 42 | 463 | 878-898 Chestnut St. | |
294 | 294 | 53 | 43 | 3 | 49 | 280 | 42 | 463 | Forrest Hill Muni Station | A Muni station agent played himself in this scene. |
295 | 295 | 53 | 43 | 3 | 49 | 280 | 42 | 463 | 60 Potomac | |
296 | 296 | 53 | 43 | 3 | 49 | 280 | 42 | 463 | The Drew School, 2901 California | |
297 | 297 | 53 | 43 | 3 | 49 | 280 | 42 | 463 | San Bruno and Alameda | |
298 | 298 | 53 | 43 | 3 | 49 | 280 | 42 | 463 | 17th and Arkansas | |
12 | 12 | 4 | 4 | 4 | 3 | 19 | 3 | 440 | ||
76 | 76 | 21 | 18 | 4 | 3 | 3 | 19 | |||
13 | 13 | 5 | 5 | 5 | 4 | 240 | 4 | Rainforest Café (145 Jefferson Street) | ||
14 | 14 | 6 | 6 | 6 | 5 | 241 | 5 | 20th and Folsom Streets | ||
15 | 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 | 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 | 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 | 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 | 19 | 7 | 7 | 7 | 6 | 242 | 6 | Broadway (North Beach) | ||
20 | 20 | 8 | 4 | 8 | 7 | 243 | 7 | 75 California Street | ||
21 | 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 | 22 | 9 | 4 | 8 | 7 | 243 | 7 | Hills Brothers Plaza (Embarcadero at Harrison Street) | ||
23 | 23 | 9 | 4 | 8 | 7 | 243 | 7 | San Francisco International Airport | SFO has a museum dedicated to aviation history. | |
24 | 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 | 25 | 10 | 8 | 9 | 8 | 244 | 8 | 441 | Port of San Francisco | |
27 | 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 | 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 | 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 | 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 | 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 | 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 | 33 | 10 | 8 | 9 | 8 | 244 | 8 | 441 | Burger Island (901 3rd Street, China Basin) | |
34 | 34 | 10 | 8 | 9 | 8 | 244 | 8 | 441 | Van Ness Avenue | |
35 | 35 | 10 | 8 | 9 | 8 | 244 | 8 | 441 | Taylor and Jefferson Streets (Fisherman's Wharf) | |
26 | 26 | 11 | 9 | 10 | 9 | 245 | 9 | 420 Jones St. at Ellis St. | ||
51 | 51 | 11 | 9 | 10 | 9 | 245 | 9 | Broadway between Powell and Davis | Driving shots | |
77 | 77 | 11 | 9 | 10 | 9 | 245 | 9 | Conzelman Rd at McCollough Rd and down Conzelman Rd. | Aerial shots | |
78 | 78 | 11 | 9 | 10 | 9 | 245 | 9 | Lombard at Hyde | ||
79 | 79 | 11 | 9 | 10 | 9 | 245 | 9 | 601 Buena Vista Ave West at Java St. | ||
80 | 80 | 11 | 9 | 10 | 9 | 245 | 9 | Columbus between Bay and Washington | Driving shots | |
81 | 81 | 11 | 9 | 10 | 9 | 245 | 9 | California between Kearney and Davis | Driving shots | |
82 | 82 | 11 | 9 | 10 | 9 | 245 | 9 | Pine between Kearney and Davis | Driving shots | |
83 | 83 | 11 | 9 | 10 | 9 | 245 | 9 | Market between Stuart and Van Ness | Driving shots | |
84 | 84 | 11 | 9 | 10 | 9 | 245 | 9 | Grant between Bush and Broadway | Driving shots | |
85 | 85 | 11 | 9 | 10 | 9 | 245 | 9 | Intersection of Broadway at Kearney | Driving shots | |
86 | 86 | 11 | 9 | 10 | 9 | 245 | 9 | Intersection of California at Polk | Driving shots | |
87 | 87 | 11 | 9 | 10 | 9 | 245 | 9 | Treasure Island, Building #1, Ave of the Palms | Aerial and exterior shots | |
36 | 36 | 12 | 10 | 11 | 10 | 246 | 10 | Broderick from Fulton to McAlister | ||
37 | 37 | 12 | 10 | 11 | 10 | 246 | 10 | Crissy Field | ||
38 | 38 | 12 | 10 | 11 | 10 | 246 | 10 | Powell from Bush and Sutter | ||
39 | 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. |
1111 | 1111 | 206 | 8 | 12 | 179 | 372 | 158 | 315 | The Barbary Coast | The Barbary Coast was a red-light district that was largely destroyed in the 1906 earthquake. Though some of the establishments were rebuilt after the earthquake, an anti-vice campaign put the establishments out of business. |
1112 | 1112 | 206 | 8 | 12 | 179 | 372 | 158 | 315 | 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. |
1160 | 1160 | 214 | 8 | 12 | 186 | 247 | 11 | 515 | Bay Bridge | Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. |
40 | 40 | 14 | 11 | 13 | 12 | 248 | 12 | 442 | Pier 50- end of the pier | |
41 | 41 | 14 | 11 | 13 | 12 | 248 | 12 | 442 | California @ Montgomery | |
42 | 42 | 14 | 11 | 13 | 12 | 248 | 12 | 442 | Montgomery/Green | |
43 | 43 | 14 | 11 | 13 | 12 | 248 | 12 | 442 | Driving various SF Streets | |
44 | 44 | 14 | 11 | 13 | 12 | 248 | 12 | 442 | Plate Shots SF streets various | |
45 | 45 | 15 | 12 | 14 | 13 | 249 | 13 | Filbert St. from Jones to Mason | ||
46 | 46 | 15 | 12 | 14 | 13 | 249 | 13 | Leavenworth from Filbert & Francisco St | ||
47 | 47 | 15 | 12 | 14 | 13 | 249 | 13 | Chestnut St. from Larkin to Columbus | ||
48 | 48 | 15 | 12 | 14 | 13 | 249 | 13 | Francisco St from Larkin to Polk | ||
49 | 49 | 15 | 12 | 14 | 13 | 249 | 13 | Broadway from Mason to Taylor | ||
50 | 50 | 15 | 12 | 14 | 13 | 249 | 13 | Taylor St. from Broadway to Filbert | ||
52 | 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 | 53 | 16 | 13 | 15 | 14 | 250 | 14 | 443 | San Francisco Bay | |
54 | 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 | 55 | 17 | 14 | 16 | 15 | 251 | 15 | 444 | Curran Theater (445 Geary Street) | Called the Shubert Theatre in the film. |
56 | 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 | 57 | 18 | 15 | 17 | 16 | 252 | 16 | 445 | 3355 Geary Blvd. | |
58 | 58 | 19 | 16 | 18 | 17 | 253 | 17 | |||
59 | 59 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | St. Francis Episcopal Church (399 San Fernando Way) | |
60 | 60 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Romolo Place @ Fresno St. | |
61 | 61 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Palace of Fine Arts | |
62 | 62 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | John Shelley Drive John McLaren Park | |
63 | 63 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Treasure Island | |
64 | 64 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | The San Francisco School (300 Gavin St.) | |
65 | 65 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | 33 Spruce St | |
66 | 66 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Coi Restaurant (373 Broadway) | |
67 | 67 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Foreign Cinema (2534 Mission) | |
68 | 68 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Bernal Heights Park | |
69 | 69 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Jackson St. at Spruce | |
70 | 70 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | 679 Madrid St | |
71 | 71 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Roxie Theater (3117 16th St.) | |
72 | 72 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Variety Preview Room (582 Market St.) | |
73 | 73 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Laguna Honda Hospital; 375 Laguna Honda Blvd. | |
74 | 74 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | 3232 Jackson Ave. |
JSON shape: default, array, newline-delimited
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");