Film_Locations_in_San_Francisco

Data source: data.sfgov.org

1,622 rows sorted by Actor 3

View and edit SQL

Link rowid Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3 ▼
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  
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  
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  
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  
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  
58 American Yearbook 19 2004 5     All Planet Studios 16   Brian Ging 18 Brian Ging 17 Nick Tagas 253 Jon Carlo Alvarez 17  
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  
121 Bedazzled 31 2000 25 1155 Filbert Street at Hyde   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
122 Bedazzled 31 2000 25 Washington Square Park (Filbert, between Stockton and Powell)   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
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  
124 Bedazzled 31 2000 25 Montgomery & Market Streets   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
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  
126 Bee Season 32 2005 2     Bee Season Productions 28 Fox Searchlight Pictures 24 Scott McGehee 30 David Siegel 29 Richard Gere 264 Juliette Binoche 28  
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    
128 Bicentennial Man 33 1999 26 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. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
129 Bicentennial Man 33 1999 26 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
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    
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    
184 Boys and Girls 39 2000 25 1122 Folsom Street   Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
185 Boys and Girls 39 2000 25 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
186 Boys and Girls 39 2000 25 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. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
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  
188 Boys and Girls 39 2000 25 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
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  
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  
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  
192 Boys and Girls 39 2000 25 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
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  
194 Boys and Girls 39 2000 25 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
195 Boys and Girls 39 2000 25 628 Cole Street   Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
196 Broken-A Modern Love Story  40 2010 19 Ina Coolbrith Park (1700 Taylor Street)   RKW Films 35   Ryan K. Whiting 38 Ryan K. Whiting 37      
197 Broken-A Modern Love Story  40 2010 19 0-100 block Halleck Street   RKW Films 35   Ryan K. Whiting 38 Ryan K. Whiting 37      
213 Burglar 43 1987 32 1627 Haight Street   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Hugh Wilson 41 Joseph Loeb III 40 Whoopi Goldberg 274 Bobcat Goldwait 37  
235 Burglar 43 1987 32 California Academy of Sciences (Golden Gate Park) Founded in 1853, 3 years after California joined the United States, the Academy was originally named the California Academy of Natural Sciences and was the first institution of its kind in the United States. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Hugh Wilson 41 Joseph Loeb III 40 Whoopi Goldberg 274 Bobcat Goldwait 37  
236 Burglar 43 1987 32 Green Valley Restaurant (510 Green Street Near Grant)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Hugh Wilson 41 Joseph Loeb III 40 Whoopi Goldberg 274 Bobcat Goldwait 37  
237 Burglar 43 1987 32 1400 18th Street   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Hugh Wilson 41 Joseph Loeb III 40 Whoopi Goldberg 274 Bobcat Goldwait 37  
238 By Hook or By Crook 44 2001 33 The Lexington Club (3464 19th Street at Lexington)   Steakhaus Productions 39 Artistic License 31 Harriet Dodge & Silas Howard 42 Harriet Dodge & Silas Howard 41 Silas Howard 275    
239 By Hook or By Crook 44 2001 33 Royan Hotel (405 Valencia Street, Mission District)   Steakhaus Productions 39 Artistic License 31 Harriet Dodge & Silas Howard 42 Harriet Dodge & Silas Howard 41 Silas Howard 275    
240 By Hook or By Crook 44 2001 33 Department of Public Health (101 Grove Street at Polk, Civic Center)   Steakhaus Productions 39 Artistic License 31 Harriet Dodge & Silas Howard 42 Harriet Dodge & Silas Howard 41 Silas Howard 275    
252 Casualties of War 47 1989 35 Mission Dolores Park (Mission District) via J-Church MUNI Train The two land plots that comprise the Park were used as a Jewish cemetery until 1894 when San Francisco prohibited all burials within city limits. The graves were moved to Colma, CA. Columbia Pictures Corporation 5 Columbia Pictures 4 Brian DePalma 45 Daniel Lang 44 Michael J. Fox 278 Sean Penn 40  
324 Faces of Death 58 1978 7     F.O.D Productions 44 Aquarius Releasing 35 Conan Le Cilaire 53 Alan Black 54 Michael Carr 281    
370 Cherish 62 2002 3 387 Fair Oaks at 25th Street   3 Ring Circus Films 46 Fine Line Features 37 Finn Taylor 56 Finn Taylor 56 Brad Hunt 65 Robin Tunney 44  
371 Chu Chu and the Philly Flash 63 1981 36 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. Melvin Simon Productions 47 Columbia Broadcasting System (CBS) 38 David Lowell Rich 57 Barbara Dana 57 Alan Arkin 282 Carol Burnett 45  
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  
373 Chu Chu and the Philly Flash 63 1981 36 22nd and Carolina Streets (Potrero Hill)   Melvin Simon Productions 47 Columbia Broadcasting System (CBS) 38 David Lowell Rich 57 Barbara Dana 57 Alan Arkin 282 Carol Burnett 45  
374 City of Angels 64 1998 18 San Francisco Public Library Main Branch (100 Larkin Street)   Atlas Entertainment 48 Warner Bros. Pictures 6 Brad Silberling 58 Dana Stevens 58 Nicolas Cage 216 Meg Ryan 46  
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  
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  
377 Class Action 65 1991 37 Bix Restaurant (56 Gold Street)   Interscope Communications 49 Twentieth Century Fox Film Corp. 13 Michael Apted 59 Carolyn Shelby 59 Gene Hackman 178 Mary Elizabeth Mastrantonio 47  
378 Common Threads: Stories From the Quilt 66 1989 35 The Castro From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry. Home Box Office (HBO) 50 Direct Cinema Limited 39 Rob Epstein 60 Jeffrey Friedman 60 Sara Lewinstein 283 David Mandell 48  
379 Confessions of a Burning Man 67 2003 38     Hotbed Media 51 Windline Films 40 Paul Barnett 61   Kevin Epps 284 Anna Getty 49  
380 Copycat 68 1995 39 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
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  
382 Copycat 68 1995 39 Sound Factory (1st and Harrison Streets)   Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
383 Copycat 68 1995 39 Java House (Pier 40, Embarcadero)   Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
384 Copycat 68 1995 39 Alta Plaza Park The park was originally a rock quarry and served as a campground for many survivors of the 1906 earthquake. The site was converted to a park in 1910. Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
385 Copycat 68 1995 39 82 & 67 Rico Way (Marina District)   Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
388 CSI: NY- episode 903 70 2012 13 Palace of Fine Arts   CBS Television Studios 53 Columbia Broadcasting System 22 Vikki Williams 64 Anthony E. Zuiker 63 Gary Sinise 287 Sela Ward 52  
414 Dirty Harry 78 1971 42 Marina Green, Marina District Before the 1906 earthquake, the land on which Marina Green sits was a tidal marsh, and rubble from the earthquake was dumped on the site. However, the site was filled in to provide land for the 1915 Panama-Pacific Exhibition. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
415 Dirty Harry 78 1971 42 Washington Square, North Beach   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
416 Dirty Harry 78 1971 42 The Embarcadero   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
417 Dirty Harry 78 1971 42 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
418 Dirty Harry 78 1971 42 San Francisco Drydock (20th and Illinois Streets)   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
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  
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  
421 Dirty Harry 78 1971 42 Mission Dolores Park (Mission District) The two land plots that comprise the Park were used as a Jewish cemetery until 1894 when San Francisco prohibited all burials within city limits. The graves were moved to Colma, CA. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  

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