sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 22 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
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
880 161 51 On Board the SS President Cleveland, docked at Pier 50   15 41 81 140 116 107 498
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
1565 298 72 Palace of Fine Arts (3301 Lyon Street) The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. 174 3 81 258 432 231 106
1566 298 72 York Hotel (940 Sutter Street)   174 3 81 258 432 231 106
1567 298 72 San Francisco Drydock (20th and Illinois Streets)   174 3 81 258 432 231 106
1568 298 72 Park Hill Sanatorium (351 Buena Vista Avenue East) This location is now a condominium complex. 174 3 81 258 432 231 106
1569 298 72 Mission San Juan Bautista (2nd & Mariposa Streets)   174 3 81 258 432 231 106
1570 298 72 Mission Dolores (3321 16th Street, Mission District) Mission Dolores' official name is Mission San Francisco de Assis. It is the oldest building in San Francisco, built in 1791, and has survived two major earthquakes. 174 3 81 258 432 231 106
1571 298 72 Gough & Eddy Streets (Western Addition)   174 3 81 258 432 231 106
1572 298 72 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. 174 3 81 258 432 231 106
1573 298 72 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. 174 3 81 258 432 231 106
1574 298 72 Ernie's Restaurant (847 Montgomery Street) Called the "Essex Club" in the film. 174 3 81 258 432 231 106
1575 298 72 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. 174 3 81 258 432 231 106
1576 298 72 Claude Lane at Bush Street   174 3 81 258 432 231 106
1577 298 72 California Palace of the Legion of Honor (34th Avenue & Clement, Lincoln Park) Built in 1924, the Legion of Honor is a 3/4 replica of the Parisian Palais de la Legion d'Honneur. 174 3 81 258 432 231 106
1578 298 72 Brocklebank Apartments (1000 Mason Street)   174 3 81 258 432 231 106
1579 298 72 900 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. 174 3 81 258 432 231 106
1580 298 72 1007 Gough Street Tennis courts now sit on the site; in the movie the structure was Carlota Valdes' home. 174 3 81 258 432 231 106
Powered by Datasette · Query took 1.49ms · Data source: data.sfgov.org