sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 27 rows (hide)

Query parameters

This data as json, CSV

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
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
1332 248 34 Pier 39   5 51 204 215 252 190 57
1333 248 34 California Academy of Sciences (Golden Gate Park) Founded in 1853, 3 years after California joined the United States, the Academy was originally named the California Academy of Natural Sciences and was the first institution of its kind in the United States. 5 51 204 215 252 190 57
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  
1544 292 35     5 4 238 252 428 227  
Powered by Datasette · Query took 1.095ms · Data source: data.sfgov.org