sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 34 rows (hide)

Query parameters

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
55 17 15 Curran Theater (445 Geary Street) Called the Shubert Theatre in the film. 14 13 16 15 251 15 444
121 31 25 1155 Filbert Street at Hyde   14 13 29 28 263 27  
122 31 25 Washington Square Park (Filbert, between Stockton and Powell)   14 13 29 28 263 27  
123 31 25 Vaillancourt Fountain (Justin Herman Plaza) Installed in 1975, the Vaillancourt Fountain is officially titled, "Québec Libre!". The night before the sculpture's inauguration, artist Armand Vaillancourt inscribed "Québec libre!" in red letters on the sculpture. The next day when he noticed that the note had been erased, Vaillancourt jumped on the statue to re-inscribe his message. 14 13 29 28 263 27  
124 31 25 Montgomery & Market Streets   14 13 29 28 263 27  
125 31 25 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. 14 13 29 28 263 27  
375 65 37 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. 49 13 59 59 178 47  
376 65 37 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. 49 13 59 59 178 47  
377 65 37 Bix Restaurant (56 Gold Street)   49 13 59 59 178 47  
438 81 43     14 13 74 74 297 7  
439 82 33 West Chrissy Field (Presidio, Golden Gate National Recreation Area) This movie was the first to film in the revamped Chrissy Field Picnic Area. 14 13 75 75 3 63  
440 82 33 Sacramento St., Between Pierce & Broderick Streets   14 13 75 75 3 63  
441 82 33 Hyde Street & Lombard Street   14 13 75 75 3 63  
442 82 33 Building 924, 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. 14 13 75 75 3 63  
443 82 33 Broadway, Between Franklin & Laguna Streets   14 13 75 75 3 63  
977 178 39 The Malloch Apartment Building (1360 Montgomery Street)   29 13 31 154 348 135 265
978 178 39 Wasteland Store (1600 Haight Street)   29 13 31 154 348 135 265
979 178 39 Star's Café (55 Golden Gate Avenue at Van Ness)   29 13 31 154 348 135 265
980 178 39 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. 29 13 31 154 348 135 265
981 178 39 San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. 29 13 31 154 348 135 265
982 178 39 Pierce Street between Pacific & Green Streets   29 13 31 154 348 135 265
983 178 39 Montgomery & Vallejo Streets   29 13 31 154 348 135 265
984 178 39 Marathon Plaza (303 2nd Street)   29 13 31 154 348 135 265
985 178 39 Jones Street at Bush   29 13 31 154 348 135 265
986 178 39 Jack Kerouac Alley between Columbus & Grant Streets   29 13 31 154 348 135 265
987 178 39 Chrissy Field Chrissy Field was originally an airfield for the Presidio Army Base. 29 13 31 154 348 135 265
988 178 39 Belli Building (722 Montgomery Street at Washington)   29 13 31 154 348 135 265
989 178 39 Alamo Square   29 13 31 154 348 135 265
990 178 39 60 Spear Street   29 13 31 154 348 135 265
991 178 39 101 Henry Adams Place, 4th Floor   29 13 31 154 348 135 265
1420 260 70 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city. 14 13 215 226 405 198 534
1421 260 70 Market Street   14 13 215 226 405 198 534
1422 260 70 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. 14 13 215 226 405 198 534
1423 260 70 1227 Montgomery Street   14 13 215 226 405 198 534
Powered by Datasette · Query took 1.022ms · Data source: data.sfgov.org