Film_Locations_in_San_Francisco

Data source: data.sfgov.org

99 rows where Production Company = 38

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Fun Facts, Distributor, 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
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  
398 398 Dark Passage 72 1947 41 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Delmer Daves 66 Delmer Daves & David Goodis 65 Humphrey Bogart 289 Lauren Bacal 54 Bruce Bennett 465
399 399 Dark Passage 72 1947 41 The Malloch Apartment Building (1360 Montgomery Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Delmer Daves 66 Delmer Daves & David Goodis 65 Humphrey Bogart 289 Lauren Bacal 54 Bruce Bennett 465
400 400 Dark Passage 72 1947 41 Filbert Steps, Filbert Street   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Delmer Daves 66 Delmer Daves & David Goodis 65 Humphrey Bogart 289 Lauren Bacal 54 Bruce Bennett 465
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
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  
544 544 Freebie and the Bean 100 1974 49 Alco Plaza   Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
545 545 Freebie and the Bean 100 1974 49 Twin Peaks The 2nd highest point in SF after Mt. Davidson, Twin Peaks sit at the geographic center of SF. The native Ohlone people called the area "called the area “Los Pechos de la Chola” or "Breasts of the Indian Maiden," but in the 19th Century when America took over the area, it was renamed "Twin Peaks". Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
546 546 Freebie and the Bean 100 1974 49 TransAmerica Pyramid (600 Montgomery Street) The Pyramid was the tallest skyscraper west of the Mississippi from 1972-1974, until it was surpassed by Los Angeles' Aon Center. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
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
548 548 Freebie and the Bean 100 1974 49 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
549 549 Freebie and the Bean 100 1974 49 Potrero Hill The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
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
551 551 Freebie and the Bean 100 1974 49 Hyatt Regency Hotel (5 Embarcadero Center)   Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
552 552 Freebie and the Bean 100 1974 49 Folsom Street (SOMA)   Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
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
554 554 Freebie and the Bean 100 1974 49 Embarcadero Freeway   Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
555 555 Freebie and the Bean 100 1974 49 Candlestick Park (602 Jamestown Ave.) Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
556 556 Freebie and the Bean 100 1974 49 Broadway and Columbus Avenue (North Beach)   Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
557 557 Gentleman Jim 101 1942 50 The Barbary Coast The Barbary Coast was a red-light district that was largely destroyed in the 1906 earthquake. Though some of the establishments were rebuilt after the earthquake, an anti-vice campaign put the establishments out of business. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Raoul Walsh 92 Vincent Lawrence 93 Errol Flynn 307 Alexis Smith 81 Jack Carson 479
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
993 993 Nora Prentiss 180 1947 41 Belgravia Apartments (795 Sutter Street at Jones)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Vincent Sherman 150 N. Richard Nash 155 Ann Sheridan 350 Kent Smith 137 Bruce Bennett 465
1244 1244 Sudden Impact 231 1983 65 Near Point Lobos, El Camino Del Mar   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176  
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
1246 1246 Sudden Impact 231 1983 65 McDonald's Restaurant (701 3rd Street, SOMA)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1247 1247 Sudden Impact 231 1983 65 Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle, Nob Hill) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1248 1248 Sudden Impact 231 1983 65 Hall of Justice (850 Bryant Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1249 1249 Sudden Impact 231 1983 65 Ferry Plaza Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
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
1251 1251 Sudden Impact 231 1983 65 Civic Center Plaza   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1252 1252 Sudden Impact 231 1983 65 The Embarcadero/Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1253 1253 Sudden Impact 231 1983 65 Bowles Franklin Galleries (765 Beach Street, Fisherman's Wharf)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1254 1254 Sudden Impact 231 1983 65 Pier 38-40, The Embarcadero   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1270 1270 Susan Slade 234 1961 47 On Board the SS President Cleveland, docked at Pier 50   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Delmer Daves 66 Delmer Daves 204 Troy Donahue 390 Connie Stevens 179 Dorothy McGuire 525
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  
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
1393 1393 The Enforcer 255 1976 45 Sutter & Webster Streets   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1394 1394 The Enforcer 255 1976 45 Hall of Justice   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1395 1395 The Enforcer 255 1976 45 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1396 1396 The Enforcer 255 1976 45 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1397 1397 The Enforcer 255 1976 45 Balmy Street (Mission District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1398 1398 The Enforcer 255 1976 45 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1399 1399 The Enforcer 255 1976 45 24th Street Mini Park (Mission District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1400 1400 The Enforcer 255 1976 45 23rd & Capp Streets (Mission District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1401 1401 The Enforcer 255 1976 45 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1428 1428 The Jazz Singer 262 1927 71 Coffee Dan's (O'Farrell Street at Powell)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Alan Crosland 217 Alfred A. Cohn 228 Al Jolson 407 May McAvoy 200 Warner Oland 536
1443 1443 The Maltese Falcon 267 1941 63 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 John Huston 220 John Huston 231 Humphrey Bogart 289 Mary Astor 204 Gladys George 541
1444 1444 The Maltese Falcon 267 1941 63 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Warner Bros. Pictures 38 Warner Bros. Pictures 6 John Huston 220 John Huston 231 Humphrey Bogart 289 Mary Astor 204 Gladys George 541
1445 1445 The Maltese Falcon 267 1941 63 Burritt Alley (Off Bush Street, between Powell and Stockton Streets)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 John Huston 220 John Huston 231 Humphrey Bogart 289 Mary Astor 204 Gladys George 541
1583 1583 What's Up Doc? 301 1972 62 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1584 1584 What's Up Doc? 301 1972 62 San Francisco Hilton (333 O'Farrell Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1585 1585 What's Up Doc? 301 1972 62 Lombard Street between Hyde and Leavenworth   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1586 1586 What's Up Doc? 301 1972 62 Hyde Street Pier   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1587 1587 What's Up Doc? 301 1972 62 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1588 1588 What's Up Doc? 301 1972 62 Alta Plaza Park (Steiner Street) 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1589 1589 What's Up Doc? 301 1972 62 22nd Avenue & Balboa Street (Richmond District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  

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