Film_Locations_in_San_Francisco

Data source: data.sfgov.org

1,622 rows sorted by Fun Facts descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid Title Release Year Locations Fun Facts ▲ Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1331 1331 The Candidate 247 1972 62 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. Redford-Ritchie Productions 150 Warner Bros. Pictures 6 Michael Ritchie 203 Jeremy Larner 214 Robert Redford 169 Peter Boyle 189  
1338 1338 The Conversation 249 1974 49 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. American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1591 1591 When a Man Loves a Woman 302 1994 48 Victor's Restaurant, The Westin St. Francis Hotel (335 Powell Street) 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. Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
491 491 Experiment in Terror 89 1962 29 Sheraton Palace Hotel (2 Montgomery Street, Financial District) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
643 643 Herbie Rides Again 120 1974 49 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. Walt Disney Productions 82 Buena Vista Distribution 58 Robert Stevenson 112 Bill Walsh 111 Helen Hayes 321 Ken Berry 96 Stefanie Powers 473
711 711 Jade 126 1995 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. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
1011 1011 Patch Adams 187 1998 18 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. Bungalow 78 Productions 118 Universal Pictures 41 Tom Shadyac 156 Steve Oedekerk 162 Robin Williams 265 Philip Seymour Hoffman 143  
1407 1407 The Game 258 1997 8 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. Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
332 332 Chance- Season 1 ep109 59 2016 30 850 Bryant- 6th floor County Jail The former County Jail on the 6th floor was re-created to resemble a Mexican jail for the scene TVM Productions 43 HULU 34 Sara Gran and Pete Begler 54 Dan Attias 51 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
926 926 Murder in the First, Season 1 171 2014 11 Pier 45 The famous Musee Mecanique is located on Pier 45 Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
24 24 A View to a Kill 10 1985 9 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. Metro-Goldwyn Mayer 8 MGM/UA Entertainment Company 7 John Glen 9 Richard Maibaum 8 Roger Moore 244 Christopher Walken 8 Tanya Roberts 441
31 31 A View to a Kill 10 1985 9 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. Metro-Goldwyn Mayer 8 MGM/UA Entertainment Company 7 John Glen 9 Richard Maibaum 8 Roger Moore 244 Christopher Walken 8 Tanya Roberts 441
125 125 Bedazzled 31 2000 25 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. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
127 127 Bicentennial Man 33 1999 26 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. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
190 190 Boys and Girls 39 2000 25 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. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
376 376 Class Action 65 1991 37 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. Interscope Communications 49 Twentieth Century Fox Film Corp. 13 Michael Apted 59 Carolyn Shelby 59 Gene Hackman 178 Mary Elizabeth Mastrantonio 47  
516 516 Final Analysis 95 1992 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Phil Joanou 86 Robert Berger 87 Richard Gere 264 Kim Basinger 75  
538 538 Foul Play 99 1978 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. Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
694 694 Invasion of the Body Snatchers 134 1978 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. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
714 714 Jagged Edge 138 1985 9 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. Columbia Pictures Corp. 93 Columbia Pictures 4 Richard Marquand 128 Joe Eszterhas 24 Glenn Close 331 Jeff Bridges 113 Peter Coyote 446
875 875 Magnum Force 160 1973 16 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. The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
888 888 Milk 166 2008 59 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. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
1112 1112 San Francisco 206 1936 12 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. Metro-Goldwyn Mayer 8 Metro-Goldwyn Mayer 10 W.S. Van Dyke 12 Anita Loos 179 Clark Gable 372 Jeanette MacDonald 158 Spencer Tracy 315
1396 1396 The Enforcer 255 1976 45 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1485 1485 The Right Stuff 279 1983 65 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. The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1492 1492 The Rock 280 1996 43 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. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1510 1510 The Wedding Planner 284 2001 33 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. Columbia Pictures 165 Sony Pictures Entertainment 115 Adam Shankman 232 Pamela Falk 245 Jennifer Lopez 421 Matthew McConaughey 220  
1545 1545 Tucker: The Man and His Dream 293 1988 23 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. Lucasfilm 170 Paramount Pictures 3 Francis Ford Coppola 127 Arnold Schulman 253 Jeff Bridges 113 Joan Allen 228 Marin Landau 548
420 420 Dirty Harry 78 1971 42 Mt. Davidson Cross, Mt. Davidson The cross sits at the highest point in San Francisco (938 feet). This version of the cross was erected in 1934.Though in Dirty Harry the cross is lit at night, the City stopped this practice in 1990. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
145 145 Birth of the Dragon 37 2016 30 Lands End Trail at Eagles Point/ Lincoln Park Golf Course The character of Steve McKee was based on actor Steve McQueen who studied with Bruce Lee in the later 60's. BOTD U.S. Productions, Inc. 32 Kylin Pictures 26 George Nolfi  35 Christopher Wilkinson, Stephen J. Rivele 34 Philip Ng 269 Billy Magnussen 32 Yu Xia 456
785 785 Looking "Special" 149 2016 30 Van Ness and Market Street MUNI exit The character of Doris was originally a recurring role, but everyone on the team liked Lauren Weedman's performance so much that she became a full time regular during the second season. Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
809 809 Looking Season 2 ep 203 151 2015 10 Mad Dog Bar, 530 Haight Street The character of Doris was originally a recurring role, but everyone on the team liked Lauren Weedman's performance so much that she became a full time regular during the second season. Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
1273 1273 Sweet November 235 2001 33 Foote, Cone & Belding (733 Front Street at Pacific) The building is called "Jabe & Dunne Advertising Agency" in the movie. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
39 39 After the Thin Man 13 1936 12 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. Metro-Goldwyn Mayer 8 Metro-Goldwyn Mayer 10 W.S. Van Dyke 12 Frances Goodrich 11 William Powell 247 Myrna Loy 11 James Stewart 432
189 189 Boys and Girls 39 2000 25 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. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
433 433 Doctor Dolittle 79 1998 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. Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
1003 1003 Pal Joey 184 1957 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. Columbia Pictures Corporation 5 Columbia Pictures 4 George Sidney 153 Dorothy Kingsley 159 Rita Hayworth 354 Frank Sinatra 141 Kim Novak 231
1168 1168 Sister Act 2: Back in the Habit 219 1993 46 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. Touchstone Pictures 104 Buena Vista Pictures 25 Bill Duke 181 Joseph Howard 190 Whoopi Goldberg 274 Maggie Smith 167  
1395 1395 The Enforcer 255 1976 45 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1422 1422 The House on Telegraph Hill 260 1951 70 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. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534
1465 1465 The Presidio 275 1988 23 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. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1491 1491 The Rock 280 1996 43 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. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
216 216 Bullitt 42 1968 31 Mark Hopkins Hotel (999 California Street) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
395 395 D.O.A 71 1950 15 Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. Cardinal Pictures 54 United Artists 19 Rudolph Mate 65 Russell Rouse 64 Edmond O'Brien 288 Pamela Britton 53 Luther Adler 464
677 677 Innerspace 132 1987 32 Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle, Nob Hill) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. Amblin Entertainment 87 Warner Bros. Pictures 6 Joe Dante 123 Chip Proser 122 Dennis Quaid 210 Martin Short 108 Meg Ryan 46
1247 1247 Sudden Impact 231 1983 65 Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle, Nob Hill) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1439 1439 The Lineup 265 1958 72 Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle, Nob Hill) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
102 102 Basic Instinct 27 1992 22 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
548 548 Freebie and the Bean 100 1974 49 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
1317 1317 The Bachelor 241 1999 26 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1429 1429 The Lady from Shanghai 263 1947 41 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. Columbia Pictures Corp. 93 Columbia Pictures 4 Orson Welles 218 Orson Welles 229 Rita Hayworth 354 Orson Welles 201 Everett Sloane 537
1437 1437 The Lineup 265 1958 72 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
18 18 A Night Full of Rain 7 1978 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. Liberty Film 7 Warner Bros. Pictures 6 Lina Wertmuller 7 Lina Wertmuller 6 Candice Bergen 242 Giancarlo Gianni 6  
146 146 Birth of the Dragon 37 2016 30 Pier 45 - Jeremiah O'Brien Liberty Ship The SS Jeremiah O'Brien is a rare survivor of the invasion at Normandy on D-Day in WWII. BOTD U.S. Productions, Inc. 32 Kylin Pictures 26 George Nolfi  35 Christopher Wilkinson, Stephen J. Rivele 34 Philip Ng 269 Billy Magnussen 32 Yu Xia 456
546 546 Freebie and the Bean 100 1974 49 TransAmerica Pyramid (600 Montgomery Street) The Pyramid was the tallest skyscraper west of the Mississippi from 1972-1974, until it was surpassed by Los Angeles' Aon Center. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
688 688 Invasion of the Body Snatchers 134 1978 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. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
1431 1431 The Lady from Shanghai 263 1947 41 Golden Gate Park The Playland amusement park where "Hall of Mirrors" sequence at the end of the movie was filmed has since been destroyed. However, relics from the park are now housed at the nearby Cliff House. Columbia Pictures Corp. 93 Columbia Pictures 4 Orson Welles 218 Orson Welles 229 Rita Hayworth 354 Orson Welles 201 Everett Sloane 537
305 305 Chance- Season 1 ep104 54 2016 30 Palace of Fine Arts The Palace of Fine Arts was designed by Bernard Maybeck and was originally constructed for the 1915 Panama-Pacific Exposition.  It has been in films such as Time After Time, The Room, Twisted, So I Married An Axe Murderer and The Rock. TVM Productions 43 HULU 34 Carl Franklin 49 Peter Elkoff 50 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
1474 1474 The Princess Diaries 276 2001 33 Cliff House (1090 Point Lobos Avenue) The Musee Mechanique, which Julie Andrews' character visits in the movie, was at the time housed under the Cliff House. Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
481 481 Etruscan Smile 88 2017 20 Marriott Marquis, 780 Mission Street The Marriott Marquis opened on October 17, 1989, the day of the Loma Prieta earthquake.[7] With better earthquake proofing than several nearby hotels, the building only lost a single window.[7] Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
1430 1430 The Lady from Shanghai 263 1947 41 Mandarin Theatre (1021 Grant Avenue) The Mandarin Theatre was renamed the Sun Sing Theatre in 1949. It closed 1986. Columbia Pictures Corp. 93 Columbia Pictures 4 Orson Welles 218 Orson Welles 229 Rita Hayworth 354 Orson Welles 201 Everett Sloane 537
706 706 Jade 126 1995 39 Japanese Tea Garden (Hagiwara Tea Garden Drive, Golden Gate Park) The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
1015 1015 Petulia 189 1968 31 Japanese Tea Garden, Hagiwara Tea Garden Drive, Golden Gate Park The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden Warner Brothers / Seven Arts 120 Warner Brothers / Seven Arts 75 Richard Lester 158 Lawrence B. Marcus 163 Julie Christie 358 George C. Scott 145 Richard Chamberlain 506
1509 1509 The Wedding Planner 284 2001 33 Japanese Tea Garden (Hagiwara Tea Garden Drive, Golden Gate Park) The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden Columbia Pictures 165 Sony Pictures Entertainment 115 Adam Shankman 232 Pamela Falk 245 Jennifer Lopez 421 Matthew McConaughey 220  
325 325 Chance- Season 1 ep108 57 2016 30 Fairmont Hotel The Fairmont Hotel was featured in many films, including The Rock and the TV series Hotel TVM Productions 43 HULU 34 Peter Elkoff and Victoria Morrow 52 Andrew Bernstein 53 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
1615 1615 Woman on the Run 304 1950 15 835-865 Market Street at 5th Street The Emporium, a department store, stood in this location. Bloomingdale's is now located here. Fidelity Pictures Corporation 177 Universal Pictures 41 Norman Foster 247 Norman Foster 263 Ann Sheridan 350 Dennis O'Keefe 235 Robert Keith 202
540 540 Foul Play 99 1978 7 Asian Art Museum (200 Larkin Street, Civic Center) The Dalai Lama opened an exhibition on Wisdom and Compassion at the museum in 1991. Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
881 881 Maxie 162 1985 9 Asian Art Museum (200 Larkin Street, Civic Center) The Dalai Lama opened an exhibition on Wisdom and Compassion at the museum in 1991. Elsboy Entertainment 103 Orion Pictures Corporation 56 Paul Aaron 139 Patricia Resnick 141 Glenn Close 331 Mandy Patinkin 125 Ruth Gordon 318
630 630 Harold and Maude 115 1971 42 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. Mildred Lewis and Colin Higgins Productions 79 Paramount Pictures 3 Hal Ashby 107 Colin Higgins 91 Ruth Gordon 318 Bud Cort 92  
636 636 Heart and Souls 116 1993 46 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. Universal Pictures 15 Electric Parc 55 Tomas Gislason 108 Tomas Gislason 107 Jorgen Leth 319    
650 650 High Anxiety 122 1977 55 Conservatory of Flowers, Golden Gate Park The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98 Cloris Leachman 486
1029 1029 Playing Mona Lisa 192 2000 25 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. The Bubble Factory 121 Buena Vista Pictures 25 Matthew Huffman 161 Marni Freedman 165 Alicia Witt 361 Harvey Fierstein 148  
1575 1575 Vertigo 298 1958 72 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
560 560 George of the Jungle 102 1997 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. Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  
568 568 Getting Even with Dad 103 1994 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. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
479 479 Etruscan Smile 88 2017 20 Bentley Reserve, 301 Battery Street The Bentley Reserve is the former San Francisco Federal Reserve. Designed by architect George W. Kelham and completed in 1924, the building has been a prominent landmark of the Financial District for 89 years. Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
557 557 Gentleman Jim 101 1942 50 The Barbary Coast The Barbary Coast was a red-light district that was largely destroyed in the 1906 earthquake. Though some of the establishments were rebuilt after the earthquake, an anti-vice campaign put the establishments out of business. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Raoul Walsh 92 Vincent Lawrence 93 Errol Flynn 307 Alexis Smith 81 Jack Carson 479
1004 1004 Pal Joey 184 1957 61 Barbary Coast The Barbary Coast was a red-light district that was largely destroyed in the 1906 earthquake. Though some of the establishments were rebuilt after the earthquake, an anti-vice campaign put the establishments out of business. Columbia Pictures Corporation 5 Columbia Pictures 4 George Sidney 153 Dorothy Kingsley 159 Rita Hayworth 354 Frank Sinatra 141 Kim Novak 231
1111 1111 San Francisco 206 1936 12 The Barbary Coast The Barbary Coast was a red-light district that was largely destroyed in the 1906 earthquake. Though some of the establishments were rebuilt after the earthquake, an anti-vice campaign put the establishments out of business. Metro-Goldwyn Mayer 8 Metro-Goldwyn Mayer 10 W.S. Van Dyke 12 Anita Loos 179 Clark Gable 372 Jeanette MacDonald 158 Spencer Tracy 315
428 428 Dirty Harry 78 1971 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. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
510 510 Fearless 94 1993 46 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. Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
651 651 High Crimes 123 2002 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. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98  
1013 1013 Patty Hearst 188 1988 23 Bank of America (38th Street at Balboa 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. Atlantic Entertainment Group 119 Atlantic Releasing Corporation 74 Paul Schrader 157 Nicholas Kazan 30 Natasha Richardson 357 William Forsythe 144 Ving Rhames 505
1170 1170 Sister Act 2: Back in the Habit 219 1993 46 Carnelian Room, Bank of America Building (555 California Street, 53rd Floor) 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. Touchstone Pictures 104 Buena Vista Pictures 25 Bill Duke 181 Joseph Howard 190 Whoopi Goldberg 274 Maggie Smith 167  
1415 1415 The Game 258 1997 8 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. Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1497 1497 The Towering Inferno 278 1974 49 Bank of America Building (555 California Street, Financial District) 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. Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
130 130 Bicentennial Man 33 1999 26 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. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
502 502 Fat Man and Little Boy 92 1989 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. Paramount Pictures 4 Paramount Pictures 3 Roland Joffe 83 Roland Joffe 85 Paul Newman 214 John Cusack 72  
527 527 Foul Play 99 1978 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. Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
691 691 Invasion of the Body Snatchers 134 1978 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. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
725 725 Junior 142 1994 48 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. Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
883 883 Maxie 162 1985 9 722 Steiner Street (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. Elsboy Entertainment 103 Orion Pictures Corporation 56 Paul Aaron 139 Patricia Resnick 141 Glenn Close 331 Mandy Patinkin 125 Ruth Gordon 318
974 974 Never Die Twice 175 2001 33 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. Scott / Kelly Films 110   Sean A.F. Scott 148 Sean A.F. Scott & Nancy L. Kelly 152 Claudia Christian 345    
1014 1014 Patty Hearst 188 1988 23 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. Atlantic Entertainment Group 119 Atlantic Releasing Corporation 74 Paul Schrader 157 Nicholas Kazan 30 Natasha Richardson 357 William Forsythe 144 Ving Rhames 505
1511 1511 The Woman In Red 285 1984 40 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. Orion Pictures Corp. 166 MGM Home Entertainment 79 Gene Wilder 233 Jean Loup Dabadie & Yves Robert 246 Gene Wilder 422 Charles Grodin 221  
381 381 Copycat 68 1995 39 Twin Peaks The 2nd highest point in SF after Mt. Davidson, Twin Peaks sit at the geographic center of SF. The native Ohlone people called the area “Los Pechos de la Chola” or "Breasts of the Indian Maiden," but in the 19th Century when America took over the area, it was renamed "Twin Peaks". Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
545 545 Freebie and the Bean 100 1974 49 Twin Peaks The 2nd highest point in SF after Mt. Davidson, Twin Peaks sit at the geographic center of SF. The native Ohlone people called the area "called the area “Los Pechos de la Chola” or "Breasts of the Indian Maiden," but in the 19th Century when America took over the area, it was renamed "Twin Peaks". Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
1580 1580 Vertigo 298 1958 72 1007 Gough Street Tennis courts now sit on the site; in the movie the structure was Carlota Valdes' home. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1484 1484 The Right Stuff 279 1983 65 Cow Palace Supposedly, the Cow Palace's name derives from a newspaper editorial in which the writer wonders whether the soon-to-be-built structure for livestock was a "palace for cows". The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
187 187 Boys and Girls 39 2000 25 Fisherman's Wharf Supposedly, Mikhail S. Gorbachev has said that his favorite part of visiting America was touring Fisherman's Wharf. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");
Powered by Datasette · Query took 33.791ms · Data source: data.sfgov.org