sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 49 rows (hide)

Query parameters

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
541 99 7 Andrew S. Hallidie Plaza (Market & Powell Streets)   4 3 90 91 306 79 477
542 99 7 430 Vallejo Street (Telegraph Hill)   4 3 90 91 306 79 477
543 99 7 24th and Castro Streets (Noe Valley)   4 3 90 91 306 79 477
521 98 48 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. 4 3 89 90 305 78  
459 87 44 Alcatraz Island Alcatraz Island was a military fort before it became a prison. 4 3 79 80 295 68 471
20 8 8 75 California Street   4 3 8 7 243 7  
21 9 8 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 4 3 8 7 243 7  
22 9 8 Hills Brothers Plaza (Embarcadero at Harrison Street)   4 3 8 7 243 7  
23 9 8 San Francisco International Airport SFO has a museum dedicated to aviation history. 4 3 8 7 243 7  
660 126 39 Lombard & Hyde Streets   4 3 117 24 223 102 487
685 126 39 Hall of Justice (850 Bryant Street)   4 3 117 24 223 102 487
706 126 39 Japanese Tea Garden (Hagiwara Tea Garden Drive, Golden Gate Park) The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden 4 3 117 24 223 102 487
707 126 39 Fior d' Italia (601 Union Street at Stockton)   4 3 117 24 223 102 487
708 126 39 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. 4 3 117 24 223 102 487
709 126 39 Washington Square (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. 4 3 117 24 223 102 487
710 126 39 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. 4 3 117 24 223 102 487
711 126 39 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. 4 3 117 24 223 102 487
712 126 39 Palace of Fine Arts The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. 4 3 117 24 223 102 487
502 92 35 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. 4 3 83 85 214 72  
1334 249 49 American Roofing Co. Building (297 Kansas Street, Potrero Hill)   92 3 127 216 178 191 530
1335 249 49 Alta Plaza Park (Steiner Street) The park was originally a rock quarry and served as a campground for many survivors of the 1906 earthquake. The site was converted to a park in 1910. 92 3 127 216 178 191 530
1336 249 49 Alcoa Building (1 Maritime Plaza) A partially-above ground parking structure near the building made it necessary for architects to make the Alcoa Building's diagonal bracing visible, instead of placing it inside and drastically reducing the amount usable interior space. 92 3 127 216 178 191 530
1337 249 49 Alamo Square (Hayes Valley)   92 3 127 216 178 191 530
1338 249 49 Westin St. Francis Hotel (335 Powell Street, Union Square) The hotel was originally supposed to be named the Crocker Hotel, after Charles Founder the railroad magnate who founded it. However, the hotel took the name the St. Francis after one of the earliest Gold Rush hotels. 92 3 127 216 178 191 530
1339 249 49 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square". 92 3 127 216 178 191 530
1340 249 49 Saks Fifth Avenue (384 Post Street, Union Square)   92 3 127 216 178 191 530
1341 249 49 One Embarcadero Center (Financial District)   92 3 127 216 178 191 530
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
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
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
12 4 4     4 3 4 3 19 3 440
676 131 35 Administration Building (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. 4 3 122 121 12 107  
76 21 17     18 3 4 3 3 19  
Powered by Datasette · Query took 2.24ms · Data source: data.sfgov.org