sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 21 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
56 18 16 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. 15 14 17 16 252 16 445
57 18 16 3355 Geary Blvd.   15 14 17 16 252 16 445
386 69 40 24th Street between Mission Street and Potrero Avenue   15 41 63 62 286 51 40
387 69 40 La Rondalla (Valencia and 20th Streets)   15 41 63 62 286 51 40
497 90 45 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 15 41 81 83 302 70 474
498 90 45 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. 15 41 81 83 302 70 474
499 90 45 2230 Sacramento Street Called "1001 Franklin" in the film. 15 41 81 83 302 70 474
500 90 45 Nob Hill Railroad tycoons like Leland Stanford (founder of Stanford University) lived in Nob Hill at the turn of the 20th Century. The 1906 earthquake completely destroyed Nob Hill, with the exception of the wall that surrounded the mansions of Stanford and his neighbor Mark Hopkins. 15 41 81 83 302 70 474
629 114 40 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. 15 41 106 106 317    
633 116 46 Stockton Tunnel (Stockton Street at Sutter Street) Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area. 15 55 108 107 319    
634 116 46 2810 Pacific Avenue   15 55 108 107 319    
635 116 46 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. 15 55 108 107 319    
636 116 46 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. 15 55 108 107 319    
662 128 38 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city. 15 41 119 118 326 104  
663 128 38 Vallejo Street at Sansome   15 41 119 118 326 104  
664 128 38 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. 15 41 119 118 326 104  
665 128 38 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. 15 41 119 118 326 104  
880 161 51 On Board the SS President Cleveland, docked at Pier 50   15 41 81 140 116 107 498
1196 221 22 The Embarcadero   15 41 183 192 381 169  
1197 221 22 Hills Brothers Plaza (The Embarcadero at Harrison)   15 41 183 192 381 169  
1326 243 67 Powell and Geary Streets (Union Square) The pet shop featured in the film does not exist, but was based on the now-closed Robison's House of Pets formerly located on Maiden Lane. 15 41 81 211 116 187 528
Powered by Datasette · Query took 1.199ms · Data source: data.sfgov.org