sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 45 rows (hide)

Query parameters

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
16 7 7 Embarcadero Freeway Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake) 7 6 7 6 242 6  
17 7 7 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. 7 6 7 6 242 6  
18 7 7 San Francisco Chronicle (901 Mission Street at 15th Street) The San Francisco Zodiac Killer of the late 1960s sent his notes and letters to the Chronicle's offices. 7 6 7 6 242 6  
19 7 7 Broadway (North Beach)   7 6 7 6 242 6  
89 23 7 Hyde Street Cable Car SF Cable Cars are the only moving National Historical Landmark. 20 16 21 20 256    
324 58 7     44 35 53 54 281    
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
523 99 7 Sutter & Buchannan Streets   4 3 90 91 306 79 477
524 99 7 Sutter & Baker Streets   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
526 99 7 Sacramento & Hyde Streets (Nob Hill)   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
528 99 7 Potrero Hill Bathhouse & Feed Co. (199 Mississippi Street)   4 3 90 91 306 79 477
529 99 7 Octavia & Hayes Streets (Hayes Valley)   4 3 90 91 306 79 477
530 99 7 Montgomery & Pine Streets (Financial District)   4 3 90 91 306 79 477
531 99 7 Laguna & Sacramento Streets (Pacific Heights)   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
533 99 7 Golden Gate & Steiner Streets (Hayes Valley)   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
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
536 99 7 Flood Building (870 Market Street)   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
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
539 99 7 California & Larkin Streets (Nob Hill)   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
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
684 134 7 Pier 33 (Embarcadero)   89 19 111 124 286 110 491
686 134 7 Department of Public Health (101 Grove Street at Polk, Civic Center)   89 19 111 124 286 110 491
687 134 7 United Nations Plaza (Civic Center) United Nations Plaza was built in 1975 and across its walkways are white lines into which the preamble to the preamble of the UN charter is carved. 89 19 111 124 286 110 491
688 134 7 Transamerica Building (600 Montgomery Street at Clay) The Pyramid was the tallest skyscraper west of the Mississippi from 1972-1974, until it was surpassed by Los Angeles' Aon Center. 89 19 111 124 286 110 491
689 134 7 San Francisco Drydock (20th and Illinois Streets)   89 19 111 124 286 110 491
690 134 7 Ramada Plaza Hotel Downtown (1231 Market Street, Civic Center)   89 19 111 124 286 110 491
691 134 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. 89 19 111 124 286 110 491
692 134 7 Lafayette Park (Pacific Heights)   89 19 111 124 286 110 491
693 134 7 Hamlin Hotel (385 Eddy Street)   89 19 111 124 286 110 491
694 134 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. 89 19 111 124 286 110 491
695 134 7 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 89 19 111 124 286 110 491
696 134 7 Broadway Tunnel (Russian Hill)   89 19 111 124 286 110 491
697 134 7 Bimbo's 365 Club (1025 Columbus Avenue, North Beach)   89 19 111 124 286 110 491
698 134 7 720 Steiner Street (Hayes Valley)   89 19 111 124 286 110 491
699 134 7 32 Napier Lane   89 19 111 124 286 110 491
700 134 7 1227 Montgomery Street (Telegraph Hill)   89 19 111 124 286 110 491
1269 233 7 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. 142 6 192 203 389 178 524
Powered by Datasette · Query took 2.12ms · Data source: data.sfgov.org