sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 49 rows (hide)

Query parameters

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
13 5 5 Rainforest CafĂ© (145 Jefferson Street)   5 4 5 4 240 4  
252 47 35 Mission Dolores Park (Mission District) via J-Church MUNI Train The two land plots that comprise the Park were used as a Jewish cemetery until 1894 when San Francisco prohibited all burials within city limits. The graves were moved to Colma, CA. 5 4 45 44 278 40  
488 89 29 George Washington High School (600 32nd Avenue )   5 4 69 82 301 57 473
489 89 29 Wells Fargo Bank (1 California Street, Financial District)   5 4 69 82 301 57 473
490 89 29 The Sea Captain's Chest (Fisherman's Wharf)   5 4 69 82 301 57 473
491 89 29 Sheraton Palace Hotel (2 Montgomery Street, Financial District) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. 5 4 69 82 301 57 473
492 89 29 Roaring Twenties Nightclub (555 Broadway at Columbus)   5 4 69 82 301 57 473
493 89 29 Candlestick Park Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park. 5 4 69 82 301 57 473
494 89 29 2632 Larkin Street at Lombard   5 4 69 82 301 57 473
495 89 29 100 St. Germain Avenue   5 4 69 82 301 57 473
496 89 29 1 Montgomery Street at Post   5 4 69 82 301 57 473
616 108 51 Various locations in San Francisco during driving scene   5 4 100 100 292 87 482
623 111 53 Sutter Street between Powell and Mason   5 4 103 103 315 90 484
624 111 53 San Francisco International Airport SFO has a museum dedicated to aviation history. 5 4 103 103 315 90 484
625 111 53 Mel's Drive-In (Corner South Van Ness & Mission St.) This restaurant location was demolished; however another Mel's was reopened in 1986 on 3355 Geary Blvd. 5 4 103 103 315 90 484
626 111 53 634 Raycliff Terrace   5 4 103 103 315 90 484
702 136 57 Hunters Point 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. 91 4 126 126 330 111 492
703 136 57 Chrissy Field 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. 91 4 126 126 330 111 492
704 136 57 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. 91 4 126 126 330 111 492
713 138 9 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. 93 4 128 24 331 113 446
714 138 9 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. 93 4 128 24 331 113 446
902 168 38     107 4 144 147 150 129  
1002 184 61 Spreckels Mansion (2080 Washington Street, Pacific Heights)   5 4 153 159 354 141 231
1003 184 61 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. 5 4 153 159 354 141 231
1004 184 61 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. 5 4 153 159 354 141 231
1053 197 28 Pacific Stock Exchange   5 4 164 170 365 152 511
1083 202 2 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. 127 4 31 175 369 155  
1328 245 69 The Embarcadero   113 4 201 212 289 188 529
1329 245 69 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. 113 4 201 212 289 188 529
1429 263 41 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. 93 4 218 229 354 201 537
1430 263 41 Mandarin Theatre (1021 Grant Avenue) The Mandarin Theatre was renamed the Sun Sing Theatre in 1949. It closed 1986. 93 4 218 229 354 201 537
1431 263 41 Golden Gate Park The Playland amusement park where "Hall of Mirrors" sequence at the end of the movie was filmed has since been destroyed. However, relics from the park are now housed at the nearby Cliff House. 93 4 218 229 354 201 537
1432 263 41 Former Hall of Justice (750 Kearny Street at Washington)   93 4 218 229 354 201 537
1434 265 72 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. 158 4 71 222 409 202 539
1435 265 72 The Embarcadero   158 4 71 222 409 202 539
1436 265 72 Sutro Baths (Point Lobos Avenue)   158 4 71 222 409 202 539
1437 265 72 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. 158 4 71 222 409 202 539
1438 265 72 Pier 41   158 4 71 222 409 202 539
1439 265 72 Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle, Nob Hill) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. 158 4 71 222 409 202 539
1440 265 72 2090 Jackson Street   158 4 71 222 409 202 539
1448 270 39 Moscone Convention Center   93 4 223 224 411 207  
1449 270 39 Montgomery & Market Streets   93 4 223 224 411 207  
1478 277 68 Glen Park Subway Station   5 4 227 202 416 213  
1479 277 68 Glide Memorial Church (434 Ellis St)   5 4 227 202 416 213  
1480 277 68 Candlestick Park (602 Jamestown Ave.) Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park. 5 4 227 202 416 213  
1482 277 68 Golden Gate Park Children's Playground Golden Gate Park is similar in shape but 20% larger than New York's Central Park. 5 4 227 202 416 213  
1494 281 3 Golden Gate National Recreation Area The size of the Recreation Area is over two and a half greater than that of the city and county of San Francisco. 93 4 230 242 418 217  
1543 291 56     169 4 112 251 427 226 547
1544 292 35     5 4 238 252 428 227  
Powered by Datasette · Query took 1.441ms · Data source: data.sfgov.org