sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 48 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
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
518 96 47 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. 69 41 87 88 304 76 476
519 96 47 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 69 41 87 88 304 76 476
628 113 43     78 41 105 105 240    
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  
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  
723 142 48 2552 Hyde Street   67 41 84 131 334 117 494
724 142 48 United Nations Plaza (Civic Center) United Nations Plaza was built in 1975 and across its walkways are white lines into which the preamble to the preamble of the UN charter is carved. 67 41 84 131 334 117 494
725 142 48 Postcard Row (Alamo Square, Hayes Valley) The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. 67 41 84 131 334 117 494
726 142 48 Hyatt Fisherman's Wharf (555 Northpoint Street)   67 41 84 131 334 117 494
727 142 48 Fairmont Hotel (950 Mason Street, Nob Hill)   67 41 84 131 334 117 494
728 142 48 Chinatown Gate Designed in 1970, the Chinatown Gate (aka the Dragon Gate) is based on ceremonial gates found in Chinese villages. 67 41 84 131 334 117 494
729 142 48 722 Steiner Street   67 41 84 131 334 117 494
880 161 51 On Board the SS President Cleveland, docked at Pier 50   15 41 81 140 116 107 498
886 165 58 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. 105 41 141 144 341 127 500
1010 187 18 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. 118 41 156 162 265 143  
1011 187 18 Sheraton Palace Hotel (639 Market Street) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. 118 41 156 162 265 143  
1012 187 18 Presidio (Golden Gate National Recreation Area) In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. 118 41 156 162 265 143  
1070 199 22     125 41 45 172 367    
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  
1226 227 10 War Memorial Opera House (401 Van Ness Avenue)   138 41 188 198 384 172 519
1227 227 10 Davies Symphony Hall (201 Van Ness Ave.)   138 41 188 198 384 172 519
1228 227 10 Sutter-Stockton Garage (444 Stockton)   138 41 188 198 384 172 519
1229 227 10 California St. from Jones St. to Mason St.   138 41 188 198 384 172 519
1230 227 10 Powell St. from California St. to Sutter St.   138 41 188 198 384 172 519
1231 227 10 Jackson St. from Mason St. to Powell St.   138 41 188 198 384 172 519
1232 227 10 Intersection of Columbus and Kearny   138 41 188 198 384 172 519
1233 227 10 Intersection of Clay St. and Walter U Lum Plc   138 41 188 198 384 172 519
1234 227 10 Mission St and 5th St   138 41 188 198 384 172 519
1235 227 10 21st and Collingswood St.   138 41 188 198 384 172 519
1236 227 10 Castro St. between 21st an Hill St   138 41 188 198 384 172 519
1237 227 10 21st and Sanchez St   138 41 188 198 384 172 519
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
1614 304 15 Former Hall of Justice (750 Kearny Street at Washington)   177 41 247 263 350 235 202
1615 304 15 835-865 Market Street at 5th Street The Emporium, a department store, stood in this location. Bloomingdale's is now located here. 177 41 247 263 350 235 202
1616 304 15 819 Mason Street at Pine   177 41 247 263 350 235 202
1617 304 15 772 Commercial Street at Kearney Called "Man Loh's Oriental Roof Garden" in the film. 177 41 247 263 350 235 202
1618 304 15 1801 Laguna at Bush   177 41 247 263 350 235 202
1619 304 15 Cable Car Signal Box (California Street at Powell Street) SF Cable Cars are the only moving National Historical Landmark. 177 41 247 263 350 235 202
Powered by Datasette · Query took 1.342ms · Data source: data.sfgov.org