sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 34 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
211 42 31 Bayshore Blvd near Cesar Chavez (Bayview)   37 30 40 39 273 36 459
212 42 31 Taylor & Vallejo Streets (Russian Hill)   37 30 40 39 273 36 459
214 42 31 SF General Hospital Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. 37 30 40 39 273 36 459
215 42 31 McLaren Park (Visitacion Valley) McLaren Park is the 2nd largest park in San Francisco, after Golden Gate Park. 37 30 40 39 273 36 459
216 42 31 Mark Hopkins Hotel (999 California Street) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. 37 30 40 39 273 36 459
217 42 31 Marina Green (Marina District) Before the 1906 earthquake, the land on which Marina Green sits was a tidal marsh, and rubble from the earthquake was dumped on the site. However, the site was filled in to provide land for the 1915 Panama-Pacific Exhibition. 37 30 40 39 273 36 459
218 42 31 Mansell & University Streets (Visitacion Valley)   37 30 40 39 273 36 459
219 42 31 Larkin & Francisco Streets (Russian Hill)   37 30 40 39 273 36 459
220 42 31 Larkin & Chestnut Streets (Russian Hill)   37 30 40 39 273 36 459
221 42 31 Kennedy Hotel (226 Embarcadero at Howard Street) Hotel was destroyed in the 1989 Loma Prieta earthquake. Corporate headquarters for the Gap reside at the location today. 37 30 40 39 273 36 459
222 42 31 John Muir Drive (Lake Merced)   37 30 40 39 273 36 459
223 42 31 Intersection of York & Peralta (Bernal Heights)   37 30 40 39 273 36 459
224 42 31 Filbert & Taylor Streets (Russian Hill)   37 30 40 39 273 36 459
225 42 31 Enrico's Café (504 Broadway)   37 30 40 39 273 36 459
226 42 31 Columbus & Lombard Streets (North Beach)   37 30 40 39 273 36 459
227 42 31 Cesar Chavez & Mission Street (Mission)   37 30 40 39 273 36 459
228 42 31 Candlestick Park Exit, Highway 101   37 30 40 39 273 36 459
229 42 31 Café Cantata (2040 Union Street)   37 30 40 39 273 36 459
230 42 31 Brocklebank Apartments (1000 Mason Street)   37 30 40 39 273 36 459
231 42 31 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. 37 30 40 39 273 36 459
232 42 31 2700 Vallejo Street (Pacific Heights)   37 30 40 39 273 36 459
233 42 31 20th & Vermont Streets (Potrero Hill) The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St. 37 30 40 39 273 36 459
234 42 31 1153-57 Taylor Street Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake) 37 30 40 39 273 36 459
1015 189 31 Japanese Tea Garden, Hagiwara Tea Garden Drive, Golden Gate Park The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden 120 75 158 163 358 145 506
1016 189 31 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. 120 75 158 163 358 145 506
1017 189 31 Pier 43 1/2   120 75 158 163 358 145 506
1018 189 31 Cala Foods (California Street and Hyde)   120 75 158 163 358 145 506
1019 189 31 307 Filbert Street   120 75 158 163 358 145 506
1020 189 31 2417 Franklin Street   120 75 158 163 358 145 506
1021 189 31 Fort Point (Presidio, Golden Gate National Recreation Area) Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF. 120 75 158 163 358 145 506
1035 196 31     123 77 91 169 364 151 510
1441 266 31 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. 82 58 112 111 410 203 540
1442 266 31 100 Block of Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. 82 58 112 111 410 203 540
1621 306 31     179 19 249 265 437 236 551
Powered by Datasette · Query took 1.69ms · Data source: data.sfgov.org