sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
422 78 42 Kezar Stadium, Golden Gate Park The stadium was demolished and completely rebuilt after sustaining damages in the 1898 Loma Prieta earthquake. 59 30 71 71 295 60  
423 78 42 Holiday Inn Select Downtown Hotel (750 Kearney Street)   59 30 71 71 295 60  
424 78 42 Hall of Justice (850 Bryant Street)   59 30 71 71 295 60  
425 78 42 Forest Hill Station- MUNI   59 30 71 71 295 60  
426 78 42 Dante Building (1606 Stockton Street at Union)   59 30 71 71 295 60  
427 78 42 California Hall (625 Polk Street, Van Ness/Civic Center)   59 30 71 71 295 60  
428 78 42 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. 59 30 71 71 295 60  
429 79 18 Webster Street   60 45 72 72 3 61  
430 79 18 Telegraph Hill Blvd (Telegraph Hill)   60 45 72 72 3 61  
431 79 18 Larkin & Hyde Streets   60 45 72 72 3 61  
432 79 18 Gabbiano's Restaurant (Ferry Building) Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 60 45 72 72 3 61  
433 79 18 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. 60 45 72 72 3 61  
434 79 18 2107 Union Street   60 45 72 72 3 61  
435 79 18 2100 Green Street   60 45 72 72 3 61  
436 80 38 South Park (Between 2nd and 3rd Streets, Brannan and Bryant Streets)   61 46 73 73 296 62  
437 80 38 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. 61 46 73 73 296 62  
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  
444 83 43 Baker Beach From 1986-1990, the north end of Baker Beach was home to the Burning Man festival. 62 47 76 76 298 64  
445 83 43 Elbo Room (647 Valencia Street) This location is called the "Café Blue Eyes" in the film. 62 47 76 76 298 64  
446 84 8 Pier 39   46 27 56 77 299 65  
447 84 8 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. 46 27 56 77 299 65  
448 85 37     63 48 77 78 150 66  
449 86 26 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. 64 49 78 79 220 67  
450 86 26 Moose's Restaurant (1652 Stockton)   64 49 78 79 220 67  
451 86 26 Mario's Bohemian Cigar Store (Washington Square)   64 49 78 79 220 67  
453 86 26 Center for the Arts, Yerba Buena Gardens (701 Mission Street)   64 49 78 79 220 67  
454 86 26 Castro Theatre (429 Castro Street, The Castro) The original Castro Theatre was built in 1910, a few doors down from the current theatre. The original theatre was converted into retail space, and the current theatre was built in the 1920s. 64 49 78 79 220 67  
455 86 26 20th & Connecticut Streets (Potrero Hill)   64 49 78 79 220 67  
456 86 26 19 Green Street (North Beach)   64 49 78 79 220 67  
457 86 26 1138 Filbert Street   64 49 78 79 220 67  
458 86 26 North Beach Video (1398 Grant Avenue at Green) The video store has since moved to an adjacent location. 64 49 78 79 220 67  
501 91 5     66 50 82 84 303 71  
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  
503 93 8     67 22 84 79 265 73  
513 95 22 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. 38 6 86 87 264 75  
514 95 22 Public Health Service Hospital (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. 38 6 86 87 264 75  
515 95 22 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. 38 6 86 87 264 75  
516 95 22 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. 38 6 86 87 264 75  
517 95 22 Bix Restaurant (56 Gold Street)   38 6 86 87 264 75  
520 97 8 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. 70 25 88 89 265 77  
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  
558 102 8 755 Vallejo Street   70 25 93 94 263 82  
559 102 8 The Tamalpais Building (1201 Greenwich Street at Hyde)   70 25 93 94 263 82  
560 102 8 Neiman Marcus (150 Stockton Street, Union Square) The City of Paris department store previously occupied the space that now houses Neiman Marcus. City of Paris' original rotunda and glass dome were incorporated into Neiman Marcus' design. 70 25 93 94 263 82  
561 102 8 First Bank (550 Montgomery Street at Commercial) Called "Stanhope Bank" in the film. 70 25 93 94 263 82  
562 102 8 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. 70 25 93 94 263 82  
563 103 48 California & Grant Streets   71 52 94 95 308 83  
564 103 48 War Memorial Building (401 Van Ness Avenue)   71 52 95 95 308 83  
565 103 48 Transbay Terminal (Mission Street at 1st Street) Built in 1939, the Terminal linked San Francisco, the East Bay, and Sacramento by rail for the first time. 71 52 95 95 308 83  
566 103 48 140 Maiden Lane   71 52 95 95 308 83  
567 103 48 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. 71 52 95 95 308 83  
568 103 48 Neiman Marcus (150 Stockton Street, Union Square) The City of Paris department store previously occupied the space that now houses Neiman Marcus. City of Paris' original rotunda and glass dome were incorporated into Neiman Marcus' design. 71 52 95 95 308 83  
569 103 48 Mason Street at Jackson   71 52 95 95 308 83  
570 103 48 M.H. de Young Memorial Museum (Golden Gate Park)   71 52 95 95 308 83  
571 103 48 Embarcadero Street Station- BART   71 52 95 95 308 83  
572 103 48 Candlestick Park (602 Jamestown Ave.) Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park. 71 52 95 95 308 83  
594 105 19 Sacramento & Washington Streets   73   97 97 310    
611 107 48 Ross Alley (Chinatown) Ross Alley is the oldest alley in San Francisco. 75 54 99 99 312 86  
612 107 48 University of California Hastings College of the Law   71 52 95 99 312 86  
613 107 48 Bush Street (between Grant & Kearny Streets)   75 54 99 99 312 86  
614 107 48 Buena Vista Park (Haight Street at Buena Vista) Established in 1867, Buena Vista Park is the oldest official park in San Francisco. 75 54 99 99 312 86  
615 107 48 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. 75 54 99 99 312 86  
620 110 25 435 23rd Street at Illinois   76 27 102 102 314 89  
621 110 25 435 23rd Street at Illinois   76 27 102 102 314 89  
622 110 25 435 23rd Street at Illinois   76 27 102 102 314 89  
627 112 33     77 27 104 104 316 91  
628 113 43     78 41 105 105 240    
629 114 40 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. 15 41 106 106 317    
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  
631 115 42 Sutro Baths (Point Lobos Avenue)   79 3 107 91 318 92  
632 115 42 Golden Gate Park   79 3 107 91 318 92  
633 116 46 Stockton Tunnel (Stockton Street at Sutter Street) Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area. 15 55 108 107 319    
634 116 46 2810 Pacific Avenue   15 55 108 107 319    
635 116 46 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. 15 55 108 107 319    
636 116 46 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. 15 55 108 107 319    
641 119 1 Muni Metro East (501 Cesar Chavez)   81 57 111 110 320 95  
645 121 19 Hobart Building (582 Market Street)   83 6 113 112 322 97  
646 121 19 The Final Final (2990 Baker Street)   83 6 113 112 322 97  
647 121 19 1160 Taylor Street   83 6 113 112 322 97  
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  
658 124 43 Pier 39 (Fisherman's Wharf)   70 25 115 115 278 100  
659 125 38     84 59 116 116 104 101  
661 127 18 Marriot Hotel (55 4th Street at Market)   13 12 118 117 325 103  
662 128 38 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city. 15 41 119 118 326 104  
663 128 38 Vallejo Street at Sansome   15 41 119 118 326 104  
664 128 38 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. 15 41 119 118 326 104  
665 128 38 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. 15 41 119 118 326 104  
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  
701 135 1 1 Post Street   90   125 125      
705 137 43     92 25 127 127 265 112  
Powered by Datasette · Query took 85.707ms · Data source: data.sfgov.org