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
1472 1472 The Princess Diaries 276 2001 33 Fisherman's Wharf Supposedly, Mikhail S. Gorbachev has said that his favorite part of visiting America was touring Fisherman's Wharf. Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
23 23 A Smile Like Yours  9 1997 8 San Francisco International Airport SFO has a museum dedicated to aviation history. Paramount Pictures 4 Paramount Pictures 3 Keith Samples 8 Keith Samples & Kevin Meyer 7 Greg Kinnear 243 Lauren Holly 7  
411 411 Dim Sum: A Little Bit of Heart 77 1985 9 San Francisco International Airport SFO has a museum dedicated to aviation history. CIM 58 Orion Classics 44 Wayne Wang 46 Terrel Seltzer 70 Laureen Chew 294 Kim Chew 59 Victor Wong 470
624 624 Guess Who's Coming to Dinner 111 1967 53 San Francisco International Airport SFO has a museum dedicated to aviation history. Columbia Pictures Corporation 5 Columbia Pictures 4 Stanley Kramer 103 William Rose 103 Spencer Tracy 315 Sidney Poitier 90 Katharine Hepburn 484
867 867 Magnum Force 160 1973 16 San Francisco International Airport SFO has a museum dedicated to aviation history. The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
214 214 Bullitt 42 1968 31 SF General Hospital Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. 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
508 508 Fearless 94 1993 46 San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
981 981 Nine Months 178 1995 39 San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. 1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
1374 1374 The Dead Pool 242 1988 23 San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1537 1537 Time After Time 289 1979 44 SF General Hospital Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
89 89 Attack of the Killer Tomatoes 23 1978 7 Hyde Street Cable Car SF Cable Cars are the only moving National Historical Landmark. Four Square Productions 20 NAI Entertainment 16 John DeBello 21 John DeBello 20 David Miller 256    
1319 1319 The Bachelor 241 1999 26 Roof of Cable Car (California at Front Street) SF Cable Cars are the only moving National Historical Landmark. George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1619 1619 Woman on the Run 304 1950 15 Cable Car Signal Box (California Street at Powell Street) SF Cable Cars are the only moving National Historical Landmark. Fidelity Pictures Corporation 177 Universal Pictures 41 Norman Foster 247 Norman Foster 263 Ann Sheridan 350 Dennis O'Keefe 235 Robert Keith 202
778 778 Looking "Special" 149 2016 30 Capital Restaurant, 839 Clay Street Russell Tovey originally auditioned for the role of Patrick, but was unsuccessful. After the show got picked up, the character of Kevin was written with him in mind. Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
824 824 Looking Season 2 ep 204 152 2015 10 Dolores Park, San Francisco Russell Tovey originally auditioned for the role of Patrick, but was unsuccessful. After the show got picked up, the character of Kevin was written with him in mind. Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
611 611 Golden Gate 107 1994 48 Ross Alley (Chinatown) Ross Alley is the oldest alley in San Francisco. American Playhouse Theatrical Films 75 The Samuel Goldwyn Company 54 John Madden 99 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  
1607 1607 When We Rise 303 2017 20 Women's Building, 3543 18th St. Roma Guy was one of the founders of the Women's Building Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1114 1114 Sense8 208 2015 10 18th Street between Guerrero and Valencia Streets Re-enactment of "Dyke's on Bikes" and "Dyke March" Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
500 500 Family Plot 90 1976 45 Nob Hill Railroad tycoons like Leland Stanford (founder of Stanford University) lived in Nob Hill at the turn of the 20th Century. The 1906 earthquake completely destroyed Nob Hill, with the exception of the wall that surrounded the mansions of Stanford and his neighbor Mark Hopkins. Universal Pictures 15 Universal Pictures 41 Alfred Hitchcock 81 Ernest Lehman 83 Karen Black 302 Bruce Dern 70 Barbara Harris 474
550 550 Freebie and the Bean 100 1974 49 Nob Hill Railroad tycoons like Leland Stanford (founder of Stanford University) lived in Nob Hill at the turn of the 20th Century. The 1906 earthquake completely destroyed Nob Hill, with the exception of the wall that surrounded the mansions of Stanford and his neighbor Mark Hopkins. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
1036 1036 Pushing Dead 74 2016 30 Blind Cat, 3050 24th Street, San Francisco Pushing Dead won the Audience Award for Frameline San Francisco International LGBTQ Film Festival 2016 Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1203 1203 So I Married an Axe Murderer 222 1993 46 Prudente's Italian Deli (1462 Grant Ave at Union) Prudente's Italian Deli, which has since closed, is called "Meats of the World" in the film. TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1137 1137 Sense8 208 2015 10 "Metzger's Apt" 151 Alice B. Toklas Pl. Overnight scene involving aggressive arguments between actors, spfx shoot out involved Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
547 547 Freebie and the Bean 100 1974 49 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. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
633 633 Heart and Souls 116 1993 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. Universal Pictures 15 Electric Parc 55 Tomas Gislason 108 Tomas Gislason 107 Jorgen Leth 319    
1316 1316 The Bachelor 241 1999 26 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. George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1406 1406 The Game 258 1997 8 Stockton Tunnel Southern Approach Overhang (Bush & Stockton Streets, Chinatown) Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area. Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
639 639 Heart Beat 117 1980 34 City Lights Bookstore (261 Columbus) One of the country's earliest bookstores, City Lights was founded by, and still owned by beat poet Lawrence Ferlinghetti. The bookstore was often frequented by Beat writers like Allen Ginsberg and Jack Kerouac. Orion Pictures Corporation 80 Orion Pictures Corporation 56 John Byrum 109 John Byrum 108 Nick Nolte 19 Sissy Spacek 93 John Heard 451
88 88 Around the Fire 22 1998 18 Ocean Beach On Jan. 25, 1878, the King Philip ship crashed in Ocean Beach. Occasionally, the ship's wreckage may be found on the beach-- most recently it was seen in 2007. Paradigm Studio 19 Ardustry Home Entertainment 15 John Jacobsen 20 John Comerford 19 Tara Reid 255    
1245 1245 Sudden Impact 231 1983 65 Mt. Davidson Mt. Davidson is highest point in San Francisco (938 feet). Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
375 375 Class Action 65 1991 37 Mission Dolores (3321 16th Street, Mission District) Mission Dolores' official name is Mission San Francisco de Assis. It is the oldest building in San Francisco, built in 1791, and has survived two major earthquakes. Interscope Communications 49 Twentieth Century Fox Film Corp. 13 Michael Apted 59 Carolyn Shelby 59 Gene Hackman 178 Mary Elizabeth Mastrantonio 47  
1570 1570 Vertigo 298 1958 72 Mission Dolores (3321 16th Street, Mission District) Mission Dolores' official name is Mission San Francisco de Assis. It is the oldest building in San Francisco, built in 1791, and has survived two major earthquakes. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
215 215 Bullitt 42 1968 31 McLaren Park (Visitacion Valley) McLaren Park is the 2nd largest park in San Francisco, after Golden Gate Park. 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
1143 1143 Sense8 - Season 2 210 2016 30 Grace Cathedral, 1100 California St. Martin Luther King, Jr. gave a sermon at the cathedral to celebrate the completion and consecration of the church in 1964. Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1144 1144 Sense8 - Season 2 210 2016 30 San Francisco City Hall, 1 Dr. Carlton B. Goodlett Pl. Many films have shot scene in and around the building including Raiders of the Lost Ark, Invasion of the Body Snatchers, Dirty Harry, The Towering Inferno, A View to a Kill and most recently, Milk. The Christmas party scene for this show was shot in the Rotunda. Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
191 191 Boys and Girls 39 2000 25 Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
1240 1240 Sudden Fear 230 1952 64 Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. Joseph Kaufmann Pictures 140 RKO Pictures 87 David Miller 141 Lenore J. Coffee 201 Joan Crawford 387 Jack Palance 175 Gloria Grahame 521
1442 1442 The Love Bug 266 1968 31 100 Block of Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. Walt Disney Productions 82 Buena Vista Distribution 58 Robert Stevenson 112 Bill Walsh 111 Dean Jones 410 Michele Lee 203 David Tomlinson 540
1579 1579 Vertigo 298 1958 72 900 Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
193 193 Boys and Girls 39 2000 25 Aquatic Park (Jefferson Street) Located at one end of Fisherman's Wharf, Aquatic Park was built as part of FDR's Works Progress Administration Project. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
1027 1027 Play it Again, Sam 191 1972 62 Aquatic Park (Jefferson Street) Located at one end of Fisherman's Wharf, Aquatic Park was built as part of FDR's Works Progress Administration Project. Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
781 781 Looking "Special" 149 2016 30 Li Po Lounge, 916 Grant Avenue Li Po Cocktail Lounge was one of the Top 10 Dive Bars in San Francisco in 2011 by SF Weekly Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
662 662 Hulk 128 2003 38 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city. Universal Pictures 15 Universal Pictures 41 Ang Lee 119 Stan Lee 118 Eric Bana 326 Jennifer Connelly 104  
678 678 Innerspace 132 1987 32 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city. Amblin Entertainment 87 Warner Bros. Pictures 6 Joe Dante 123 Chip Proser 122 Dennis Quaid 210 Martin Short 108 Meg Ryan 46
1420 1420 The House on Telegraph Hill 260 1951 70 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city. 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
1116 1116 Sense8 208 2015 10 Clarion Alley between Valencia & Mission St. Ladies discuss their relationship in the mural alley Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
794 794 Looking "Special" 149 2016 30 Bernal Heights Neighborhood Jake Shears, lead singer of the band Scissor Sisters, auditioned for the role of Dom. Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
802 802 Looking Season 2 ep 202 150 2015 10 100 Church Street Jake Shears, lead singer of the band Scissor Sisters, auditioned for the role of Dom. Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
653 653 High Crimes 123 2002 3 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98  
1198 1198 So I Married an Axe Murderer 222 1993 46 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1555 1555 Twisted 209 2004 5 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
123 123 Bedazzled 31 2000 25 Vaillancourt Fountain (Justin Herman Plaza) Installed in 1975, the Vaillancourt Fountain is officially titled, "Québec Libre!". The night before the sculpture's inauguration, artist Armand Vaillancourt inscribed "Québec libre!" in red letters on the sculpture. The next day when he noticed that the note had been erased, Vaillancourt jumped on the statue to re-inscribe his message. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
1342 1342 The Conversation 249 1974 49 Neiman Marcus (150 Stockton Street, Union Square) In the film the City of Paris Department Store is featured. That establishment was located where Neiman Marcus stands today American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1138 1138 Sense8 - Season 2 210 2016 30 Westerfeld House, 1198 Fulton St. In the 1940's, the house became a 14-unit apartment building that housed jazz musicians including John Handy. This location serves as the hideout for the San Francisco-based character Nomi. Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
522 522 Foul Play 99 1978 7 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
635 635 Heart and Souls 116 1993 46 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. Universal Pictures 15 Electric Parc 55 Tomas Gislason 108 Tomas Gislason 107 Jorgen Leth 319    
710 710 Jade 126 1995 39 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
1434 1434 The Lineup 265 1958 72 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
17 17 A Night Full of Rain 7 1978 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. Liberty Film 7 Warner Bros. Pictures 6 Lina Wertmuller 7 Lina Wertmuller 6 Candice Bergen 242 Giancarlo Gianni 6  
54 54 Alexander's Ragtime Band 16 1938 14 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. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Henry King 15 Kathryn Scola 14 Tyrone Power 250 Alice Faye 14 Don Ameche 443
372 372 Chu Chu and the Philly Flash 63 1981 36 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. Melvin Simon Productions 47 Columbia Broadcasting System (CBS) 38 David Lowell Rich 57 Barbara Dana 57 Alan Arkin 282 Carol Burnett 45  
498 498 Family Plot 90 1976 45 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. Universal Pictures 15 Universal Pictures 41 Alfred Hitchcock 81 Ernest Lehman 83 Karen Black 302 Bruce Dern 70 Barbara Harris 474
553 553 Freebie and the Bean 100 1974 49 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. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
629 629 Hard to Hold 114 1984 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. Universal Pictures 15 Universal Pictures 41 Larry Peerce 106 Thomas Hedley, Jr.  106 Rick Springfield 317    
673 673 I Remember Mama 130 1948 56 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. RKO Radio Pictures 86 RKO Radio Pictures 60 George Stevens 121 DeWitt Bodeen 120 Irene Dunne 328 Barbara Bel Geddes 106 Oskar Homolka 489
708 708 Jade 126 1995 39 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. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
873 873 Magnum Force 160 1973 16 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. The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
886 886 Midnight Lace 165 1960 58 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. Arwin Productions 105 Universal Pictures 41 David Miller 141 Ivan Goff 144 Doris Day 341 Rex Harrison 127 John Gavin 500
904 904 Mother 169 1996 43 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. Paramount Pictures 4 Paramount Pictures 3 Albert Brooks 145 Albert Brooks 148 Albert Brooks 343 Debbie Reynolds 130  
1016 1016 Petulia 189 1968 31 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. 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
1162 1162 Shoot the Moon 216 1982 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. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Alan Parker 178 Bo Goldman 188 Albert Finney 378 Diane Keaton 165  
1250 1250 Sudden Impact 231 1983 65 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1490 1490 The Rock 280 1996 43 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. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1502 1502 The Towering Inferno 278 1974 49 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. Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1573 1573 Vertigo 298 1958 72 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. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1529 1529 Time After Time 289 1979 44 Ghirardelli Square (900 North Point Street, Fisherman's Wharf) In 1893, chocolatier Domingo Ghirardelli bought an entire city block to house the headquarters of Ghirardelli Chocolates. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
52 52 Alexander's Ragtime Band 16 1938 14 Cliff House (1090 Point Lobos Avenue) In 1887, the Cliff House was severely damaged when the schooner Parallel, abandoned and loaded with dynamite, ran aground on the rocks below. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Henry King 15 Kathryn Scola 14 Tyrone Power 250 Alice Faye 14 Don Ameche 443
617 617 Greed 109 1924 52 Cliff House (1090 Point Lobos Avenue) In 1887, the Cliff House was severely damaged when the schooner Parallel, abandoned and loaded with dynamite, ran aground on the rocks below. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Eric von Stroheim  101 Eric von Stroheim  101 Zasu Pitts 313 Gibson Gowland 88 Jean Hersholt 483
419 419 Dirty Harry 78 1971 42 Portsmouth Square (Chinatown) In 1847 the first public school in California was erected on what would become Portsmouth Square. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
442 442 Dr. Dolittle 2 82 2001 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. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Steve Carr 75 Larry Levin 75 Eddie Murphy 3 Kristen Wilson 63  
514 514 Final Analysis 95 1992 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Phil Joanou 86 Robert Berger 87 Richard Gere 264 Kim Basinger 75  
515 515 Final Analysis 95 1992 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Phil Joanou 86 Robert Berger 87 Richard Gere 264 Kim Basinger 75  
1012 1012 Patch Adams 187 1998 18 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. Bungalow 78 Productions 118 Universal Pictures 41 Tom Shadyac 156 Steve Oedekerk 162 Robin Williams 265 Philip Seymour Hoffman 143  
1409 1409 The Game 258 1997 8 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. Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1458 1458 The Presidio 275 1988 23 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. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
932 932 Murder in the First, Season 1 171 2014 11 Ida B. Wells High School (1099 Hayes Street) Ida B. Wells High School is named after the African-American journalist, suffragist and early leader in the Civil Rights Movement Ida B. Wells 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
1145 1145 Sense8 - Season 2 210 2016 30 City Lights Bookstore, 261 Columbus Ave. Howl and Other Poems by Allen Ginsberg was published in 1956 by City Lights after poet and founder Laurence Ferlinghetti heard Ginsberg read it in 1955. Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
221 221 Bullitt 42 1968 31 Kennedy Hotel (226 Embarcadero at Howard Street) Hotel was destroyed in the 1989 Loma Prieta earthquake. Corporate headquarters for the Gap reside at the location today. 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
1286 1286 Terminator - Genisys 239 2015 10 16th and Utah Helicopter flies over Utah St. from 16th, rises up before freeway T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
21 21 A Smile Like Yours  9 1997 8 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Paramount Pictures 4 Paramount Pictures 3 Keith Samples 8 Keith Samples & Kevin Meyer 7 Greg Kinnear 243 Lauren Holly 7  
131 131 Bicentennial Man 33 1999 26 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
497 497 Family Plot 90 1976 45 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Universal Pictures 15 Universal Pictures 41 Alfred Hitchcock 81 Ernest Lehman 83 Karen Black 302 Bruce Dern 70 Barbara Harris 474
882 882 Maxie 162 1985 9 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Elsboy Entertainment 103 Orion Pictures Corporation 56 Paul Aaron 139 Patricia Resnick 141 Glenn Close 331 Mandy Patinkin 125 Ruth Gordon 318
898 898 Milk 166 2008 59 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
1030 1030 Pleasure of His Company 193 1961 47 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Perlsea Company 122 Paramount Pictures 3 George Seaton 162 Samuel A. Taylor 166 Fred Astaire 362 Debbie Reynolds 130 Lilli Palmer 508
1500 1500 The Towering Inferno 278 1974 49 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1503 1503 The Wedding Planner 284 2001 33 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Columbia Pictures 165 Sony Pictures Entertainment 115 Adam Shankman 232 Pamela Falk 245 Jennifer Lopez 421 Matthew McConaughey 220  
1482 1482 The Pursuit of Happyness 277 2006 68 Golden Gate Park Children's Playground Golden Gate Park is similar in shape but 20% larger than New York's Central Park. Columbia Pictures Corporation 5 Columbia Pictures 4 Steven Conrad 227 Gabriele Muccino 202 Will Smith 416 Jayden C. Smith 213  
1504 1504 The Wedding Planner 284 2001 33 The Music Concourse (Martin Luther King, Jr. Drive, Golden Gate Park) Golden Gate Park is similar in shape but 20% larger than New York's Central Park. Columbia Pictures 165 Sony Pictures Entertainment 115 Adam Shankman 232 Pamela Falk 245 Jennifer Lopez 421 Matthew McConaughey 220  
1527 1527 Time After Time 289 1979 44 Golden Gate Park Golden Gate Park is similar in shape but 20% larger than New York's Central Park. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546

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 20.919ms · Data source: data.sfgov.org