sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 49 rows (hide)

Query parameters

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
1342 249 49 Neiman Marcus (150 Stockton Street, Union Square) In the film the City of Paris Department Store is featured. That establishment was located where Neiman Marcus stands today 92 3 127 216 178 191 530
1343 249 49 Financial District   92 3 127 216 178 191 530
1344 249 49 Cathedral Hill Hotel (1101 Van Ness Avenue, Civic Center)   92 3 127 216 178 191 530
1345 250 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. 151 3 205 217 397 192  
1456 275 23 Washington Street & Waverly Place (Chinatown)   4 3 226 238 107 211 46
1457 275 23 Sansome Street (The Embarcadero)   4 3 226 238 107 211 46
1458 275 23 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. 4 3 226 238 107 211 46
1459 275 23 Montgomery & Vallejo Streets (Telegraph Hill)   4 3 226 238 107 211 46
1460 275 23 Market & 2nd Streets   4 3 226 238 107 211 46
1461 275 23 Hayes & Polk Streets (Civic Center)   4 3 226 238 107 211 46
1462 275 23 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. 4 3 226 238 107 211 46
1463 275 23 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. 4 3 226 238 107 211 46
1464 275 23 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 4 3 226 238 107 211 46
1465 275 23 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. 4 3 226 238 107 211 46
1466 275 23 Civic Center Plaza   4 3 226 238 107 211 46
1467 275 23 Battery Street (The Embarcadero)   4 3 226 238 107 211 46
1468 275 23 900 Block of Grant Avenue (Chinatown)   4 3 226 238 107 211 46
1469 275 23 700 Block of Jackson Street (Chinatown)   4 3 226 238 107 211 46
1470 275 23 200 Block of Sansome Street (Financial District)   4 3 226 238 107 211 46
1495 282 73 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Exteriors of the church were used. 4 3 231 243 419 218 15
1517 288 40     4 3 236 248 424 223 545
1545 293 23 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. 170 3 127 253 113 228 548
1547 209 5 Red's Java House (Pier 30-32, The Embarcadero)   4 3 111 181 324 160  
1548 209 5 Piers 30-32   4 3 111 181 324 160  
1549 209 5 Pier 39   4 3 111 181 324 160  
1550 209 5 Mojito (1337-1339 Grant Avenue)   4 3 111 181 324 160  
1551 209 5 McCovey Point, China Basin Park (24 Willy Mays Plaza)   4 3 111 181 324 160  
1552 209 5 Veterans' War Memorial Building (401 Van Ness Avenue)   4 3 111 181 324 160  
1553 209 5     4 3 111 181 324 160  
1554 209 5 La Bodega (1332 Grant Avenue at Vallejo)   4 3 111 181 324 160  
1555 209 5 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. 4 3 111 181 324 160  
1556 209 5 The Saloon (1232 Grant Avenue)   4 3 111 181 324 160  
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
1622 307 75 SF Chronicle Building (901 Mission St)   4 3 213 266 438 118  
Powered by Datasette · Query took 1.43ms · Data source: data.sfgov.org