sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 49 rows (hide)

Query parameters

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
1025 191 62 Surf Theater (4520 Irving Street)   4 3 160 35 360 147 507
1024 191 62 The Music Concourse (Martin Luther King, Jr. Drive, Golden Gate Park) The theater closed in 1985. 4 3 160 35 360 147 507
1023 191 62 Balboa at 22nd Avenue   4 3 160 35 360 147 507
904 169 43 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 145 148 343 130  
903 169 43 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 145 148 343 130  
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
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
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
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
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
707 126 39 Fior d' Italia (601 Union Street at Stockton)   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
685 126 39 Hall of Justice (850 Bryant Street)   4 3 117 24 223 102 487
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  
660 126 39 Lombard & Hyde Streets   4 3 117 24 223 102 487
632 115 42 Golden Gate Park   79 3 107 91 318 92  
631 115 42 Sutro Baths (Point Lobos Avenue)   79 3 107 91 318 92  
630 115 42 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. 79 3 107 91 318 92  
543 99 7 24th and Castro Streets (Noe Valley)   4 3 90 91 306 79 477
542 99 7 430 Vallejo Street (Telegraph Hill)   4 3 90 91 306 79 477
541 99 7 Andrew S. Hallidie Plaza (Market & Powell Streets)   4 3 90 91 306 79 477
540 99 7 Asian Art Museum (200 Larkin Street, Civic Center) The Dalai Lama opened an exhibition on Wisdom and Compassion at the museum in 1991. 4 3 90 91 306 79 477
539 99 7 California & Larkin Streets (Nob Hill)   4 3 90 91 306 79 477
538 99 7 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. 4 3 90 91 306 79 477
537 99 7 Fiesta Laundromat (898 S. Van Ness Ave., Mission)   4 3 90 91 306 79 477
536 99 7 Flood Building (870 Market Street)   4 3 90 91 306 79 477
535 99 7 Fort Mason (Golden Gate National Recreation Area) Constructed in 1864 as a coastal defense site, Fort Mason went on to serve as an army post for more than 100 years. 4 3 90 91 306 79 477
534 99 7 Fort Point, Presidio 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 90 91 306 79 477
533 99 7 Golden Gate & Steiner Streets (Hayes Valley)   4 3 90 91 306 79 477
532 99 7 Hayes Valley Care (601 Laguna Street, Hayes Valley)   4 3 90 91 306 79 477
531 99 7 Laguna & Sacramento Streets (Pacific Heights)   4 3 90 91 306 79 477
530 99 7 Montgomery & Pine Streets (Financial District)   4 3 90 91 306 79 477
529 99 7 Octavia & Hayes Streets (Hayes Valley)   4 3 90 91 306 79 477
528 99 7 Potrero Hill Bathhouse & Feed Co. (199 Mississippi Street)   4 3 90 91 306 79 477
527 99 7 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 90 91 306 79 477
526 99 7 Sacramento & Hyde Streets (Nob Hill)   4 3 90 91 306 79 477
525 99 7 Sokoji-Soto Zen Buddhist Temple (1691 Laguna Street)   4 3 90 91 306 79 477
524 99 7 Sutter & Baker Streets   4 3 90 91 306 79 477
523 99 7 Sutter & Buchannan Streets   4 3 90 91 306 79 477
522 99 7 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 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  
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  
459 87 44 Alcatraz Island Alcatraz Island was a military fort before it became a prison. 4 3 79 80 295 68 471
76 21 17     18 3 4 3 3 19  
23 9 8 San Francisco International Airport SFO has a museum dedicated to aviation history. 4 3 8 7 243 7  
22 9 8 Hills Brothers Plaza (Embarcadero at Harrison 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  
20 8 8 75 California Street   4 3 8 7 243 7  
12 4 4     4 3 4 3 19 3 440
Powered by Datasette · Query took 1.529ms · Data source: data.sfgov.org