Film_Locations_in_San_Francisco

Data source: data.sfgov.org

1,622 rows

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1 180 1 2011 1 Epic Roasthouse (399 Embarcadero)   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
2 180 1 2011 1 Mason & California Streets (Nob Hill)   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
3 180 1 2011 1 Justin Herman Plaza   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
4 180 1 2011 1 200 block Market Street   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
5 180 1 2011 1 City Hall   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
6 180 1 2011 1 Polk & Larkin Streets   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
7 180 1 2011 1 Randall Museum   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
8 180 1 2011 1 555 Market St.   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
9 24 Hours on Craigslist 2 2005 2     Yerba Buena Productions 2 Zealot Pictures 1 Michael Ferris Gibson 2   Craig Newmark 238    
10 40 Days and 40 Nights 3 2002 3 The Walden House, Buena Vista Park Established in 1867, Buena Vista Park is the oldest official park in San Francisco. Miramax Films 3 Miramax Films 2 Michael Lehmann 3 Robert Perez 2 Josh Hartnett 239 Shaynnyn Sossamon 2  
11 40 Days and 40 Nights 3 2002 3 Café Trieste (609 Vallejo) Francis Ford Coppola allegedly wrote large portions of "The Godfather" trilogy in Café Trieste. Miramax Films 3 Miramax Films 2 Michael Lehmann 3 Robert Perez 2 Josh Hartnett 239 Shaynnyn Sossamon 2  
12 48 Hours 4 1982 4     Paramount Pictures 4 Paramount Pictures 3 Walter Hill 4 Walter Hill 3 Nick Nolte 19 Eddie Murphy 3 Annette O'Toole 440
13 50 First Dates 5 2004 5 Rainforest Café (145 Jefferson Street)   Columbia Pictures Corporation 5 Columbia Pictures 4 Peter Segal 5 George Wing 4 Adam Sandler 240 Drew Barrymore 4  
14 A Jitney Elopement 6 1915 6 20th and Folsom Streets   The Essanay Film Manufacturing Company 6 General Film Company 5 Charles Chaplin 6 Charles Chaplin 5 Charles Chaplin 241 Edna Purviance 5  
15 A Jitney Elopement 6 1915 6 Golden Gate Park During San Francisco's Gold Rush era, the Park was part of an area designated as the "Great Sand Waste". The Essanay Film Manufacturing Company 6 General Film Company 5 Charles Chaplin 6 Charles Chaplin 5 Charles Chaplin 241 Edna Purviance 5  
16 A Night Full of Rain 7 1978 7 Embarcadero Freeway Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake) Liberty Film 7 Warner Bros. Pictures 6 Lina Wertmuller 7 Lina Wertmuller 6 Candice Bergen 242 Giancarlo Gianni 6  
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  
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  
19 A Night Full of Rain 7 1978 7 Broadway (North Beach)   Liberty Film 7 Warner Bros. Pictures 6 Lina Wertmuller 7 Lina Wertmuller 6 Candice Bergen 242 Giancarlo Gianni 6  
20 A Smile Like Yours 8 1997 8 75 California Street   Paramount Pictures 4 Paramount Pictures 3 Keith Samples 8 Keith Samples & Kevin Meyer 7 Greg Kinnear 243 Lauren Holly 7  
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  
22 A Smile Like Yours  9 1997 8 Hills Brothers Plaza (Embarcadero at Harrison Street)   Paramount Pictures 4 Paramount Pictures 3 Keith Samples 8 Keith Samples & Kevin Meyer 7 Greg Kinnear 243 Lauren Holly 7  
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  
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
25 A View to a Kill 10 1985 9 Port of San Francisco   Metro-Goldwyn Mayer 8 MGM/UA Entertainment Company 7 John Glen 9 Richard Maibaum 8 Roger Moore 244 Christopher Walken 8 Tanya Roberts 441
26 Ant-Man 11 2015 10 420 Jones St. at Ellis St.   PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
27 A View to a Kill 10 1985 9 Lefty O' Doul Drawbridge/ 3rd Street Bridge (3rd Street, China Basin) This is SF's only drawbridge, and was named after Francis Joseph "Lefty" O'Doul, a local baseball hero. Metro-Goldwyn Mayer 8 MGM/UA Entertainment Company 7 John Glen 9 Richard Maibaum 8 Roger Moore 244 Christopher Walken 8 Tanya Roberts 441
28 A View to a Kill 10 1985 9 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. Metro-Goldwyn Mayer 8 MGM/UA Entertainment Company 7 John Glen 9 Richard Maibaum 8 Roger Moore 244 Christopher Walken 8 Tanya Roberts 441
29 A View to a Kill 10 1985 9 Embarcadero Freeway Embarcadero Freeway, which was featured in the film, was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake) Metro-Goldwyn Mayer 8 MGM/UA Entertainment Company 7 John Glen 9 Richard Maibaum 8 Roger Moore 244 Christopher Walken 8 Tanya Roberts 441
30 A View to a Kill 10 1985 9 Potrero Hill The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St. 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 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
32 A View to a Kill 10 1985 9 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Metro-Goldwyn Mayer 8 MGM/UA Entertainment Company 7 John Glen 9 Richard Maibaum 8 Roger Moore 244 Christopher Walken 8 Tanya Roberts 441
33 A View to a Kill 10 1985 9 Burger Island (901 3rd Street, China Basin)   Metro-Goldwyn Mayer 8 MGM/UA Entertainment Company 7 John Glen 9 Richard Maibaum 8 Roger Moore 244 Christopher Walken 8 Tanya Roberts 441
34 A View to a Kill 10 1985 9 Van Ness Avenue   Metro-Goldwyn Mayer 8 MGM/UA Entertainment Company 7 John Glen 9 Richard Maibaum 8 Roger Moore 244 Christopher Walken 8 Tanya Roberts 441
35 A View to a Kill 10 1985 9 Taylor and Jefferson Streets (Fisherman's Wharf)   Metro-Goldwyn Mayer 8 MGM/UA Entertainment Company 7 John Glen 9 Richard Maibaum 8 Roger Moore 244 Christopher Walken 8 Tanya Roberts 441
36 About a Boy 12 2014 11 Broderick from Fulton to McAlister   NBC Studios 10 National Broadcasting Company 9 Mark J. Kunerth 11 Jason Katims 10 David Walton 246 Minnie Driver 10  
37 About a Boy 12 2014 11 Crissy Field   NBC Studios 10 National Broadcasting Company 9 Mark J. Kunerth 11 Jason Katims 10 David Walton 246 Minnie Driver 10  
38 About a Boy 12 2014 11 Powell from Bush and Sutter   NBC Studios 10 National Broadcasting Company 9 Mark J. Kunerth 11 Jason Katims 10 David Walton 246 Minnie Driver 10  
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
40 Age of Adaline 14 2015 10 Pier 50- end of the pier   Lionsgate / Sidney Kimmel Entertainment / Lakeshore Entertainment 11   Lee Toland Krieger 13 J. Mills Goodloe 12 Blake Lively 248 Harrison Ford 12 Ellen Burstyn 442
41 Age of Adaline 14 2015 10 California @ Montgomery   Lionsgate / Sidney Kimmel Entertainment / Lakeshore Entertainment 11   Lee Toland Krieger 13 J. Mills Goodloe 12 Blake Lively 248 Harrison Ford 12 Ellen Burstyn 442
42 Age of Adaline 14 2015 10 Montgomery/Green   Lionsgate / Sidney Kimmel Entertainment / Lakeshore Entertainment 11   Lee Toland Krieger 13 J. Mills Goodloe 12 Blake Lively 248 Harrison Ford 12 Ellen Burstyn 442
43 Age of Adaline 14 2015 10 Driving various SF Streets   Lionsgate / Sidney Kimmel Entertainment / Lakeshore Entertainment 11   Lee Toland Krieger 13 J. Mills Goodloe 12 Blake Lively 248 Harrison Ford 12 Ellen Burstyn 442
44 Age of Adaline 14 2015 10 Plate Shots SF streets various   Lionsgate / Sidney Kimmel Entertainment / Lakeshore Entertainment 11   Lee Toland Krieger 13 J. Mills Goodloe 12 Blake Lively 248 Harrison Ford 12 Ellen Burstyn 442
45 Alcatraz 15 2012 13 Filbert St. from Jones to Mason   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
46 Alcatraz 15 2012 13 Leavenworth from Filbert & Francisco St   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
47 Alcatraz 15 2012 13 Chestnut St. from Larkin to Columbus   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
48 Alcatraz 15 2012 13 Francisco St from Larkin to Polk   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
49 Alcatraz 15 2012 13 Broadway from Mason to Taylor   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
50 Alcatraz 15 2012 13 Taylor St. from Broadway to Filbert   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
51 Ant-Man 11 2015 10 Broadway between Powell and Davis Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
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
53 Alexander's Ragtime Band 16 1938 14 San Francisco Bay   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
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
55 All About Eve 17 1950 15 Curran Theater (445 Geary Street) Called the Shubert Theatre in the film. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Joseph L. Mankiewicz 16 Joseph L. Mankiewicz 15 Bette Davis 251 Anne Baxter 15 George Sanders 444
56 American Graffiti 18 1973 16 Mel's Drive-In (Corner of Van Ness & Mission Street, Mission District) This restaurant location was demolished; however another Mel's was reopened in 1986 on 3355 Geary Blvd. Universal Pictures 15 Universal Pictures' 14 George Lucas 17 George Lucas 16 Richard Dreyfuss 252 Ron Howard 16 Paul Le Mat 445
57 American Graffiti 18 1973 16 3355 Geary Blvd.   Universal Pictures 15 Universal Pictures' 14 George Lucas 17 George Lucas 16 Richard Dreyfuss 252 Ron Howard 16 Paul Le Mat 445
58 American Yearbook 19 2004 5     All Planet Studios 16   Brian Ging 18 Brian Ging 17 Nick Tagas 253 Jon Carlo Alvarez 17  
59 Americana 20 2015 10 St. Francis Episcopal Church (399 San Fernando Way)   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
60 Americana 20 2015 10 Romolo Place @ Fresno St.   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
61 Americana 20 2015 10 Palace of Fine Arts   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
62 Americana 20 2015 10 John Shelley Drive John McLaren Park   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
63 Americana 20 2015 10 Treasure Island   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
64 Americana 20 2015 10 The San Francisco School (300 Gavin St.)   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
65 Americana 20 2015 10 33 Spruce St   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
66 Americana 20 2015 10 Coi Restaurant (373 Broadway)   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
67 Americana 20 2015 10 Foreign Cinema (2534 Mission)   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
68 Americana 20 2015 10 Bernal Heights Park   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
69 Americana 20 2015 10 Jackson St. at Spruce   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
70 Americana 20 2015 10 679 Madrid St   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
71 Americana 20 2015 10 Roxie Theater (3117 16th St.)   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
72 Americana 20 2015 10 Variety Preview Room (582 Market St.)   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
73 Americana 20 2015 10 Laguna Honda Hospital; 375 Laguna Honda Blvd.   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
74 Americana 20 2015 10 3232 Jackson Ave.   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
75 Americana 20 2015 10 20th St and Illinois/Faxon St. and Kenwood/Glenbrook at Mt. Springs   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
76 Another 48 Hours 21 1990 17     Eddie Murphy Productions 18 Paramount Pictures 3 Walter Hill 4 Walter Hill 3 Eddie Murphy 3 Nick Nolte 19  
77 Ant-Man 11 2015 10 Conzelman Rd at McCollough Rd and down Conzelman Rd. Aerial shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
78 Ant-Man 11 2015 10 Lombard at Hyde   PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
79 Ant-Man 11 2015 10 601 Buena Vista Ave West at Java St.   PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
80 Ant-Man 11 2015 10 Columbus between Bay and Washington Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
81 Ant-Man 11 2015 10 California between Kearney and Davis Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
82 Ant-Man 11 2015 10 Pine between Kearney and Davis Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
83 Ant-Man 11 2015 10 Market between Stuart and Van Ness Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
84 Ant-Man 11 2015 10 Grant between Bush and Broadway Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
85 Ant-Man 11 2015 10 Intersection of Broadway at Kearney Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
86 Ant-Man 11 2015 10 Intersection of California at Polk Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
87 Ant-Man 11 2015 10 Treasure Island, Building #1, Ave of the Palms Aerial and exterior shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
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    
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    
90 Babies 24 2010 19     Canal+ 21 Focus Features 17 Thomas Balmes 22 Thomas Balmes 21 Bayar 257 Hattie 20  
91 Ballers Season 3 25 2017 20 Fairmont Hotel (950 Mason Street, Nob Hill)   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
92 Ballers Season 3 25 2017 20 Embarcadero around Rincon Park   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
93 Ballers Season 3 25 2017 20 San Remo Hotel (2237 Mason)   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
94 Ballers Season 3 25 2017 20 Huntington Park (California & Taylor Streets, Nob Hill)   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
95 Ballers Season 3 25 2017 20 Driving around Taylor/Pacific/Leavenworth   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
96 Ballers Season 3 25 2017 20 California and Jones St.   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
97 Ballers Season 3 25 2017 20 Another Café, 1191 Pine St at Leavenworth   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
98 Barbary Coast 26 1935 21     The Samuel Goldwyn Company 23 United Artists 19 Howard Hawks 24 Ben Hecht 23 Mariam Hopkins 259 Edward G. Robinson 22 Joel McCrea 448
99 Basic Instinct 27 1992 22 Yerba Buena Center for the Arts   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
100 Basic Instinct 27 1992 22 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. Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449

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