sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
1 1 1 Epic Roasthouse (399 Embarcadero)   1   1 1 237 1 439
2 1 1 Mason & California Streets (Nob Hill)   1   1 1 237 1 439
3 1 1 Justin Herman Plaza   1   1 1 237 1 439
4 1 1 200 block Market Street   1   1 1 237 1 439
5 1 1 City Hall   1   1 1 237 1 439
6 1 1 Polk & Larkin Streets   1   1 1 237 1 439
7 1 1 Randall Museum   1   1 1 237 1 439
8 1 1 555 Market St.   1   1 1 237 1 439
641 119 1 Muni Metro East (501 Cesar Chavez)   81 57 111 110 320 95  
701 135 1 1 Post Street   90   125 125      
9 2 2     2 1 2   238    
126 32 2     28 24 30 29 264 28  
730 143 2     84 59 131 132 335 118  
975 176 2     111 70 149 153 346 133  
1083 202 2 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. 127 4 31 175 369 155  
1330 246 2     149 107 202 213 396    
1515 286 2     167 104 234 247 423 44  
1546 294 2     171 116 239 254 429    
10 3 3 The Walden House, Buena Vista Park Established in 1867, Buena Vista Park is the oldest official park in San Francisco. 3 2 3 2 239 2  
11 3 3 Café Trieste (609 Vallejo) Francis Ford Coppola allegedly wrote large portions of "The Godfather" trilogy in Café Trieste. 3 2 3 2 239 2  
370 62 3 387 Fair Oaks at 25th Street   46 37 56 56 65 44  
651 123 3 Bank of America Building (555 California Street) The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast. 13 12 114 113 323 98  
652 123 3 391 Pennsylvania Avenue at 19th Street   63 48 49 114 324 99  
653 123 3 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. 13 12 114 113 323 98  
654 123 3 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square". 13 12 114 113 323 98  
655 123 3 Maiden Lane   13 12 114 113 323 98  
656 123 3 Condor Club (Columbus and Broadway)   13 12 114 113 323 98  
657 123 3 Chase H & Q (1 Bush Street at Sansome)   13 12 114 113 323 98  
1084 203 3     48 79 168 176 370 156  
1494 281 3 Golden Gate National Recreation Area The size of the Recreation Area is over two and a half greater than that of the city and county of San Francisco. 93 4 230 242 418 217  
12 4 4     4 3 4 3 19 3 440
253 48 4 Li Po (916 Grant Avenue at Washington, Chinatown)   42 33 46 45 279 41 462
254 48 4 Golden Dragon Restaurant (816 Washington Street at Grant)   42 33 46 45 279 41 462
1162 216 4 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. 71 52 178 188 378 165  
1213 224 4 Golden Gate Park   4 3 186 195 383 171 518
13 5 5 Rainforest Café (145 Jefferson Street)   5 4 5 4 240 4  
58 19 5     16   18 17 253 17  
501 91 5     66 50 82 84 303 71  
1071 200 5 Magic Theater (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. 77 78 166 173 316    
1133 209 5 Pier 24   4 3 111 181 324 160  
1310 240 5 Tosca Café (242 Columbus Avenue, North Beach)   146 104 197 209 40 184  
1311 240 5 766 Sutter Street   146 104 197 209 40 184  
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  
1582 300 5 Golden Gate National Recreation Area The size of the Recreation Area is over two and a half greater than that of the city and county of San Francisco. 175 118 244 260 433    
14 6 6 20th and Folsom Streets   6 5 6 5 241 5  
15 6 6 Golden Gate Park During San Francisco's Gold Rush era, the Park was part of an area designated as the "Great Sand Waste". 6 5 6 5 241 5  
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
20 8 8 75 California Street   4 3 8 7 243 7  
Powered by Datasette · Query took 1.469ms · Data source: data.sfgov.org