Film_Locations_in_San_Francisco_fts

Data source: data.sfgov.org

1,622 rows sorted by Actor 3

View and edit SQL

Link rowid Title Production Company Director Writer Actor 1 Actor 2 Actor 3 ▼ Locations Fun Facts
422 78 59 71 71 295 60   Kezar Stadium, Golden Gate Park The stadium was demolished and completely rebuilt after sustaining damages in the 1898 Loma Prieta earthquake.
423 78 59 71 71 295 60   Holiday Inn Select Downtown Hotel (750 Kearney Street)  
424 78 59 71 71 295 60   Hall of Justice (850 Bryant Street)  
425 78 59 71 71 295 60   Forest Hill Station- MUNI  
426 78 59 71 71 295 60   Dante Building (1606 Stockton Street at Union)  
427 78 59 71 71 295 60   California Hall (625 Polk Street, Van Ness/Civic Center)  
428 78 59 71 71 295 60   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.
429 79 60 72 72 3 61   Webster Street  
430 79 60 72 72 3 61   Telegraph Hill Blvd (Telegraph Hill)  
431 79 60 72 72 3 61   Larkin & Hyde Streets  
432 79 60 72 72 3 61   Gabbiano's Restaurant (Ferry Building) Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.
433 79 60 72 72 3 61   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.
434 79 60 72 72 3 61   2107 Union Street  
435 79 60 72 72 3 61   2100 Green Street  
436 80 61 73 73 296 62   South Park (Between 2nd and 3rd Streets, Brannan and Bryant Streets)  
437 80 61 73 73 296 62   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.
438 81 14 74 74 297 7      
439 82 14 75 75 3 63   West Chrissy Field (Presidio, Golden Gate National Recreation Area) This movie was the first to film in the revamped Chrissy Field Picnic Area.
440 82 14 75 75 3 63   Sacramento St., Between Pierce & Broderick Streets  
441 82 14 75 75 3 63   Hyde Street & Lombard Street  
442 82 14 75 75 3 63   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.
443 82 14 75 75 3 63   Broadway, Between Franklin & Laguna Streets  
444 83 62 76 76 298 64   Baker Beach From 1986-1990, the north end of Baker Beach was home to the Burning Man festival.
445 83 62 76 76 298 64   Elbo Room (647 Valencia Street) This location is called the "Café Blue Eyes" in the film.
446 84 46 56 77 299 65   Pier 39  
447 84 46 56 77 299 65   Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII.
448 85 63 77 78 150 66      
449 86 64 78 79 220 67   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.
450 86 64 78 79 220 67   Moose's Restaurant (1652 Stockton)  
451 86 64 78 79 220 67   Mario's Bohemian Cigar Store (Washington Square)  
453 86 64 78 79 220 67   Center for the Arts, Yerba Buena Gardens (701 Mission Street)  
454 86 64 78 79 220 67   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.
455 86 64 78 79 220 67   20th & Connecticut Streets (Potrero Hill)  
456 86 64 78 79 220 67   19 Green Street (North Beach)  
457 86 64 78 79 220 67   1138 Filbert Street  
458 86 64 78 79 220 67   North Beach Video (1398 Grant Avenue at Green) The video store has since moved to an adjacent location.
501 91 66 82 84 303 71      
502 92 4 83 85 214 72   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.
503 93 67 84 79 265 73      
513 95 38 86 87 264 75   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.
514 95 38 86 87 264 75   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.
515 95 38 86 87 264 75   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.
516 95 38 86 87 264 75   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.
517 95 38 86 87 264 75   Bix Restaurant (56 Gold Street)  
520 97 70 88 89 265 77   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.
521 98 4 89 90 305 78   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.
558 102 70 93 94 263 82   755 Vallejo Street  
559 102 70 93 94 263 82   The Tamalpais Building (1201 Greenwich Street at Hyde)  
560 102 70 93 94 263 82   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.
561 102 70 93 94 263 82   First Bank (550 Montgomery Street at Commercial) Called "Stanhope Bank" in the film.
562 102 70 93 94 263 82   Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII.
563 103 71 94 95 308 83   California & Grant Streets  
564 103 71 95 95 308 83   War Memorial Building (401 Van Ness Avenue)  
565 103 71 95 95 308 83   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.
566 103 71 95 95 308 83   140 Maiden Lane  
567 103 71 95 95 308 83   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.
568 103 71 95 95 308 83   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.
569 103 71 95 95 308 83   Mason Street at Jackson  
570 103 71 95 95 308 83   M.H. de Young Memorial Museum (Golden Gate Park)  
571 103 71 95 95 308 83   Embarcadero Street Station- BART  
572 103 71 95 95 308 83   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.
594 105 73 97 97 310     Sacramento & Washington Streets  
611 107 75 99 99 312 86   Ross Alley (Chinatown) Ross Alley is the oldest alley in San Francisco.
612 107 71 95 99 312 86   University of California Hastings College of the Law  
613 107 75 99 99 312 86   Bush Street (between Grant & Kearny Streets)  
614 107 75 99 99 312 86   Buena Vista Park (Haight Street at Buena Vista) Established in 1867, Buena Vista Park is the oldest official park in San Francisco.
615 107 75 99 99 312 86   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.
620 110 76 102 102 314 89   435 23rd Street at Illinois  
621 110 76 102 102 314 89   435 23rd Street at Illinois  
622 110 76 102 102 314 89   435 23rd Street at Illinois  
627 112 77 104 104 316 91      
628 113 78 105 105 240        
629 114 15 106 106 317     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.
630 115 79 107 91 318 92   Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere.
631 115 79 107 91 318 92   Sutro Baths (Point Lobos Avenue)  
632 115 79 107 91 318 92   Golden Gate Park  
633 116 15 108 107 319     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.
634 116 15 108 107 319     2810 Pacific Avenue  
635 116 15 108 107 319     War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House.
636 116 15 108 107 319     Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere.
641 119 81 111 110 320 95   Muni Metro East (501 Cesar Chavez)  
645 121 83 113 112 322 97   Hobart Building (582 Market Street)  
646 121 83 113 112 322 97   The Final Final (2990 Baker Street)  
647 121 83 113 112 322 97   1160 Taylor Street  
651 123 13 114 113 323 98   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.
652 123 63 49 114 324 99   391 Pennsylvania Avenue at 19th Street  
653 123 13 114 113 323 98   Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café.
654 123 13 114 113 323 98   Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square".
655 123 13 114 113 323 98   Maiden Lane  
656 123 13 114 113 323 98   Condor Club (Columbus and Broadway)  
657 123 13 114 113 323 98   Chase H & Q (1 Bush Street at Sansome)  
658 124 70 115 115 278 100   Pier 39 (Fisherman's Wharf)  
659 125 84 116 116 104 101      
661 127 13 118 117 325 103   Marriot Hotel (55 4th Street at Market)  
662 128 15 119 118 326 104   Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city.
663 128 15 119 118 326 104   Vallejo Street at Sansome  
664 128 15 119 118 326 104   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.
665 128 15 119 118 326 104   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.
676 131 4 122 121 12 107   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.
701 135 90 125 125       1 Post Street  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIRTUAL TABLE "Film_Locations_in_San_Francisco_fts" USING FTS4 ("Title", "Production Company", "Director", "Writer", "Actor 1", "Actor 2", "Actor 3", "Locations", "Fun Facts", content="Film_Locations_in_San_Francisco");
Powered by Datasette · Query took 7.499ms · Data source: data.sfgov.org