Film_Locations_in_San_Francisco

Data source: data.sfgov.org

150 rows where Distributor = 6 sorted by Release Year

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Fun Facts, Production Company, Director, Writer, Actor 1, Actor 2, Actor 3

Link rowid Title Release Year ▼ Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
16 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 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 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 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  
1269 1269 Superman 233 1978 7 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. Dovemead Films 142 Warner Bros. Pictures 6 Richard Donner 192 Jerry Siegel 203 Christopher Reeve 389 Gene Hackman 178 Marlon Brando 524
595 595 Godzilla 106 2014 11 Kearney & Pine St.   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
596 596 Godzilla 106 2014 11 California & Davis St   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
597 597 Godzilla 106 2014 11 Pine St. & Davis St   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
598 598 Godzilla 106 2014 11 Sacramento & Front St.   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
599 599 Godzilla 106 2014 11 Broadway & Sansome   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
600 600 Godzilla 106 2014 11 Broadway & Columbus   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
601 601 Godzilla 106 2014 11 Post & Jones St.   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
602 602 Godzilla 106 2014 11 Stockton & Clay St   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
603 603 Godzilla 106 2014 11 Bush & Kearny   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
604 604 Godzilla 106 2014 11 Mission & Fremont St   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
605 605 Godzilla 106 2014 11 Eddy & Taylor St.   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
606 606 Godzilla 106 2014 11 Pier 7 (The Embarcadero)   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
607 607 Godzilla 106 2014 11 Pier 1   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
608 608 Godzilla 106 2014 11 Embarcadero & Washington   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
609 609 Godzilla 106 2014 11 Mission & Beal   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
610 610 Godzilla 106 2014 11 Potrero &San Bruno   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
865 865 Magnum Force 160 1973 16 Cost Plus World Market (2552 Taylor Street)   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
866 866 Magnum Force 160 1973 16 Vermont Street between 20th and 22nd Streets   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
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
868 868 Magnum Force 160 1973 16 San Francisco Drydock (20th and Illinois Streets)   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
869 869 Magnum Force 160 1973 16 Pacific Heights Towers (2200 Sacramento Street, Pacific Heights)   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
870 870 Magnum Force 160 1973 16 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. The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
871 871 Magnum Force 160 1973 16 Hall of Justice (850 Bryant Street)   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
872 872 Magnum Force 160 1973 16 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. The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
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
874 874 Magnum Force 160 1973 16 Embarcadero Freeway demolished The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
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
876 876 Magnum Force 160 1973 16 Broadway Tunnel (Russian Hill)   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
877 877 Magnum Force 160 1973 16 280 Freeway at Pennsylvania and Mariposa Streets   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
878 878 Magnum Force 160 1973 16 2190 Washington Street (Pacific Heights)   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
879 879 Magnum Force 160 1973 16 18th Street Overpass (Potrero Hill)   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
374 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  
645 645 Hereafter 121 2010 19 Hobart Building (582 Market Street)   GT Films 83 Warner Bros. Pictures 6 Clint Eastwood 113 Peter Morgan 112 Matt Damon 322 Cecile De France 97  
646 646 Hereafter 121 2010 19 The Final Final (2990 Baker Street)   GT Films 83 Warner Bros. Pictures 6 Clint Eastwood 113 Peter Morgan 112 Matt Damon 322 Cecile De France 97  
647 647 Hereafter 121 2010 19 1160 Taylor Street   GT Films 83 Warner Bros. Pictures 6 Clint Eastwood 113 Peter Morgan 112 Matt Damon 322 Cecile De France 97  
513 513 Final Analysis 95 1992 22 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Phil Joanou 86 Robert Berger 87 Richard Gere 264 Kim Basinger 75  
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  
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  
517 517 Final Analysis 95 1992 22 Bix Restaurant (56 Gold Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Phil Joanou 86 Robert Berger 87 Richard Gere 264 Kim Basinger 75  
884 884 Memoirs of an Invisible Man 163 1992 22 St. Elizabeth Apartment House (901 Powell Street at Sacramento)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 John Carpenter 33 Robert Collector 142 Chevy Chase 79 Daryl Hannah 126 Sam Neill 499
1313 1313 The Dead Pool 242 1988 23 Hall of Justice (850 Bryant Street)   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
1346 1346 The Dead Pool 242 1988 23 San Francisco Drydock (The Dogpatch)   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
1347 1347 The Dead Pool 242 1988 23 Washington Square Park (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. The statue in the Park is Ben Franklin, not George Washington. 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
1348 1348 The Dead Pool 242 1988 23 One Thousand Powell Apartments (1000 Powell Street)   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
1349 1349 The Dead Pool 242 1988 23 The Cannery (281 Leavenworth Street, Fisherman's Wharf)   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
1350 1350 The Dead Pool 242 1988 23 Portsmouth Square (Chinatown)   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
1351 1351 The Dead Pool 242 1988 23 Pierce St. & Golden Gate Avenue (Hayes Valley)   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
1352 1352 The Dead Pool 242 1988 23 Pierce & California Streets (Pacific Heights)   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
1353 1353 The Dead Pool 242 1988 23 Pier 3 (The Embarcadero)   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
1354 1354 The Dead Pool 242 1988 23 New Asia Restaurant (772 Pacific Avenue at Grant)   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
1355 1355 The Dead Pool 242 1988 23 Nam Yuen Restaurant (740 Washington Street, Chinatown)   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
1356 1356 The Dead Pool 242 1988 23 Mirant Energy, LLC (1301 Illinois Street, The Dogpatch)   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
1357 1357 The Dead Pool 242 1988 23 McAllister & Scott Streets (Hayes Valley)   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
1358 1358 The Dead Pool 242 1988 23 KGO-TV ABC7 TV Studios (900 Front Street, Waterfront Historic District)   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
1360 1360 The Dead Pool 242 1988 23 San Francisco National Military Cemetery (Lincoln Blvd., The Presidio, Golden Gate National Recreation Center)   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
1361 1361 The Dead Pool 242 1988 23 Silver Restaurant (737 Washington Street, Chinatown)   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
1362 1362 The Dead Pool 242 1988 23 Fremont Street Exit of Bay Bridge   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
1363 1363 The Dead Pool 242 1988 23 Folsom & Essex Streets   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
1364 1364 The Dead Pool 242 1988 23 Eber Electronics (2355 Market Street, Castro)   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
1365 1365 The Dead Pool 242 1988 23 Clementina & Sumner Streets   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
1366 1366 The Dead Pool 242 1988 23 Carl & Cole Streets (Cole Valley)   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
1367 1367 The Dead Pool 242 1988 23 710 Steiner Street (Hayes Valley)   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
1368 1368 The Dead Pool 242 1988 23 550 El Camino Del Mar (Seacliff)   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
1369 1369 The Dead Pool 242 1988 23 23rd & Iowa Streets (Dogpatch)   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
1370 1370 The Dead Pool 242 1988 23 22nd Bet. Carolina & Rhode Island Streets (Potrero Hill)   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
1371 1371 The Dead Pool 242 1988 23 22nd & Wisconsin Streets (Potrero Hill)   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
1372 1372 The Dead Pool 242 1988 23 20th & De Haro Streets (Potrero Hill)   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
1373 1373 The Dead Pool 242 1988 23 1954 Mason Street (North Beach)   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
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
1085 1085 Romeo Must Die 204 2000 25 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Silver Pictures 128 Warner Bros. Pictures 6 Andrzej Bartkowiak 169 Mitchell Kapner 177 Jet Li 371 Aaliyah 157  
1086 1086 Romeo Must Die 204 2000 25 Embarcadero Street   Silver Pictures 128 Warner Bros. Pictures 6 Andrzej Bartkowiak 169 Mitchell Kapner 177 Jet Li 371 Aaliyah 157  
1447 1447 The Matrix 269 1999 26 skyline/ exterior scenes   Silver Pictures 128 Warner Bros. Pictures 6 The Wachowski Brothers 222 The Wachowski Brothers 233 Keanu Reeves 391 Laurence Fishburne 206  
409 409 Days of Wine and Roses 75 1962 29     Warner Bros. Pictures 38 Warner Bros. Pictures 6 Blake Edwards 69 JP Miller 68 Jack Lemmon 292 Lee Remick 57 Charles Bickford 468
213 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 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 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 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  
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
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
679 679 Innerspace 132 1987 32 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. Amblin Entertainment 87 Warner Bros. Pictures 6 Joe Dante 123 Chip Proser 122 Dennis Quaid 210 Martin Short 108 Meg Ryan 46
1271 1271 Sweet November 235 2001 33 Marquee Lofts (1000 Van Ness Avenue at Alice B. Toklas Place)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
1272 1272 Sweet November 235 2001 33 Hotel Majestic (1500 Sutter Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
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  
1274 1274 Sweet November 235 2001 33 Farley's Café (1315 18th Street Near Missouri)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
1275 1275 Sweet November 235 2001 33 Citicorp Center (1 Sansome Street at Sutter)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
1276 1276 Sweet November 235 2001 33 Christopher's Books (1400 18th Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
1277 1277 Sweet November 235 2001 33 Chrissy Field Chrissy Field was originally an airfield for the Presidio Army Base. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
1278 1278 Sweet November 235 2001 33 Blooms Saloon (18th Street between Missouri and Texas Streets)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
1279 1279 Sweet November 235 2001 33 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
1558 1558 Until the End of the World 296 1991 37 Tosca Café (242 Columbus Avenue, North Beach)   Village Roadshow Pictures 172 Warner Bros. Pictures 6 Wim Wenders 241 Wim Wenders 256 Solveig Dommartin 430    
380 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 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 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 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  

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