sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 15 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
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
663 128 38 Vallejo Street at Sansome   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  
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  
499 90 45 2230 Sacramento Street Called "1001 Franklin" in the film. 15 41 81 83 302 70 474
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
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    
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  
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
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
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  
Powered by Datasette · Query took 1.37ms · Data source: data.sfgov.org