Film_Locations_in_San_Francisco

Data source: data.sfgov.org

1,622 rows sorted by Actor 1

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 ▼ Actor 2 Actor 3
961 961 Murder in the First, Season 3 173 2016 30 Ivy Street between Laguna and Gough Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
962 962 Murder in the First, Season 3 173 2016 30 Linden Alley between Octavia and Gough Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
963 963 Murder in the First, Season 3 173 2016 30 Hall of Justice (850 Bryant Street)   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
964 964 Murder in the First, Season 3 173 2016 30 Harriet Alley   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
965 965 Murder in the First, Season 3 173 2016 30 Howard Street at Steuart Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
966 966 Murder in the First, Season 3 173 2016 30 Red's Java House (Pier 30)   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
967 967 Murder in the First, Season 3 173 2016 30 887 De Haro Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
968 968 Murder in the First, Season 3 173 2016 30 Pier 96   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
969 969 Murder in the First, Season 3 173 2016 30 2633 Vallejo Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
659 659 House of Sand and Fog 125 2003 38     DreamWorks SKG 84 DreamWorks Distribution 59 Vadim Perelman 116 Vadim Perelman 116 Jennifer Connelly 104 Ben Kingsley 101  
1456 1456 The Presidio 275 1988 23 Washington Street & Waverly Place (Chinatown)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1457 1457 The Presidio 275 1988 23 Sansome Street (The Embarcadero)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1458 1458 The Presidio 275 1988 23 Presidio (Golden Gate National Recreation Area) In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1459 1459 The Presidio 275 1988 23 Montgomery & Vallejo Streets (Telegraph Hill)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1460 1460 The Presidio 275 1988 23 Market & 2nd Streets   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1461 1461 The Presidio 275 1988 23 Hayes & Polk Streets (Civic Center)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1462 1462 The Presidio 275 1988 23 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. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1463 1463 The Presidio 275 1988 23 Fort Point (Presidio, Golden Gate National Recreation Area) Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1464 1464 The Presidio 275 1988 23 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1465 1465 The Presidio 275 1988 23 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. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1466 1466 The Presidio 275 1988 23 Civic Center Plaza   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1467 1467 The Presidio 275 1988 23 Battery Street (The Embarcadero)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1468 1468 The Presidio 275 1988 23 900 Block of Grant Avenue (Chinatown)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1469 1469 The Presidio 275 1988 23 700 Block of Jackson Street (Chinatown)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1470 1470 The Presidio 275 1988 23 200 Block of Sansome Street (Financial District)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1487 1487 The Rock 280 1996 43 Palace of Fine Arts (3301 Lyon Street) The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1488 1488 The Rock 280 1996 43 The San Francisco Bay   Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1489 1489 The Rock 280 1996 43 New Russian Hill Market (1198 Pacific Avenue at Jones)   Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1490 1490 The Rock 280 1996 43 Fairmont Hotel (950 Mason Street, Nob Hill) In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1491 1491 The Rock 280 1996 43 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. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1492 1492 The Rock 280 1996 43 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. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1493 1493 The Rock 280 1996 43 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1557 1557 Under the Tuscan Sun 295 2003 38 Mecca Restaurant (2029 Market Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Audrey Wells 240 Audrey Wells 255 Diane Lane 112 Sandra Oh 229  
504 504 Fearless 94 1993 46 400 Montgomery Street   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
505 505 Fearless 94 1993 46 Folsom Street & Embarcadero   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
506 506 Fearless 94 1993 46 Varennes Alley between Filbert and Union   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
507 507 Fearless 94 1993 46 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. Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
508 508 Fearless 94 1993 46 San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
509 509 Fearless 94 1993 46 Kohl Building (400 Montgomery Street)   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
510 510 Fearless 94 1993 46 Bank of America Building (555 California Street) The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast. Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
511 511 Fearless 94 1993 46 90 Gold Street   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
512 512 Fearless 94 1993 46 5th and Beale Streets   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
1545 1545 Tucker: The Man and His Dream 293 1988 23 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. Lucasfilm 170 Paramount Pictures 3 Francis Ford Coppola 127 Arnold Schulman 253 Jeff Bridges 113 Joan Allen 228 Marin Landau 548
880 880 Marnie 161 1964 51 On Board the SS President Cleveland, docked at Pier 50   Universal Pictures 15 Universal Pictures 41 Alfred Hitchcock 81 Jay Presson Allen 140 Tippi Hedren 116 Sean Connery 107 Martin Gabel 498
1326 1326 The Birds 243 1963 67 Powell and Geary Streets (Union Square) The pet shop featured in the film does not exist, but was based on the now-closed Robison's House of Pets formerly located on Maiden Lane. Universal Pictures 15 Universal Pictures 41 Alfred Hitchcock 81 Evan Hunter 211 Tippi Hedren 116 Suzanne Pleshette 187 Rod Taylor 528
1446 1446 The Master 268 2012 13 Pier 7/ Embarcadero   H.H. Project 159 Weinstein Company 21 Paul Thomas Anderson 221 Paul Thomas Anderson 232 Philip Seymour Hoffman 143 Joaquin Phoenix 205  
448 448 Dying Young 85 1991 37     Twentieth Century Fox Corporation 63 Twentieth Century Fox Corporation 48 Joel Schumacher 77 Richard Friedenberg 78 Julia Roberts 150 Campbell Scott 66  
902 902 Mona Lisa Smile 168 2003 38     Revolution Studios 107 Columbia Pictures 4 Mike Newell 144 Lawrence Konner 147 Julia Roberts 150 Kirsten Dunst 129  
1331 1331 The Candidate 247 1972 62 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. Redford-Ritchie Productions 150 Warner Bros. Pictures 6 Michael Ritchie 203 Jeremy Larner 214 Robert Redford 169 Peter Boyle 189  
375 375 Class Action 65 1991 37 Mission Dolores (3321 16th Street, Mission District) Mission Dolores' official name is Mission San Francisco de Assis. It is the oldest building in San Francisco, built in 1791, and has survived two major earthquakes. Interscope Communications 49 Twentieth Century Fox Film Corp. 13 Michael Apted 59 Carolyn Shelby 59 Gene Hackman 178 Mary Elizabeth Mastrantonio 47  
376 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 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  
1334 1334 The Conversation 249 1974 49 American Roofing Co. Building (297 Kansas Street, Potrero Hill)   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1335 1335 The Conversation 249 1974 49 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. American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1336 1336 The Conversation 249 1974 49 Alcoa Building (1 Maritime Plaza) A partially-above ground parking structure near the building made it necessary for architects to make the Alcoa Building's diagonal bracing visible, instead of placing it inside and drastically reducing the amount usable interior space. American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1337 1337 The Conversation 249 1974 49 Alamo Square (Hayes Valley)   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1338 1338 The Conversation 249 1974 49 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. American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1339 1339 The Conversation 249 1974 49 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square". American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1340 1340 The Conversation 249 1974 49 Saks Fifth Avenue (384 Post Street, Union Square)   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1341 1341 The Conversation 249 1974 49 One Embarcadero Center (Financial District)   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1342 1342 The Conversation 249 1974 49 Neiman Marcus (150 Stockton Street, Union Square) In the film the City of Paris Department Store is featured. That establishment was located where Neiman Marcus stands today American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1343 1343 The Conversation 249 1974 49 Financial District   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1344 1344 The Conversation 249 1974 49 Cathedral Hill Hotel (1101 Van Ness Avenue, Civic Center)   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1212 1212 Sphere 223 1998 18 S.S. Jeremiah O'Brien   Constant c Productions 137 Warner brothers Pictures 84 Barry Levinson 185 Kurt Wimmer 194 Dustin Hoffman 197 Sharon Stone 23  
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
502 502 Fat Man and Little Boy 92 1989 35 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. Paramount Pictures 4 Paramount Pictures 3 Roland Joffe 83 Roland Joffe 85 Paul Newman 214 John Cusack 72  
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  
449 449 Edtv 86 1999 26 Palace of Fine Arts (3301 Lyon Street) The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
450 450 Edtv 86 1999 26 Moose's Restaurant (1652 Stockton)   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
451 451 Edtv 86 1999 26 Mario's Bohemian Cigar Store (Washington Square)   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
453 453 Edtv 86 1999 26 Center for the Arts, Yerba Buena Gardens (701 Mission Street)   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
454 454 Edtv 86 1999 26 Castro Theatre (429 Castro Street, The Castro) The original Castro Theatre was built in 1910, a few doors down from the current theatre. The original theatre was converted into retail space, and the current theatre was built in the 1920s. Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
455 455 Edtv 86 1999 26 20th & Connecticut Streets (Potrero Hill)   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
456 456 Edtv 86 1999 26 19 Green Street (North Beach)   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
457 457 Edtv 86 1999 26 1138 Filbert Street   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
458 458 Edtv 86 1999 26 North Beach Video (1398 Grant Avenue at Green) The video store has since moved to an adjacent location. Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
660 660 Jade 126 1995 39 Lombard & Hyde Streets   Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
685 685 Jade 126 1995 39 Hall of Justice (850 Bryant Street)   Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
706 706 Jade 126 1995 39 Japanese Tea Garden (Hagiwara Tea Garden Drive, Golden Gate Park) The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
707 707 Jade 126 1995 39 Fior d' Italia (601 Union Street at Stockton)   Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
708 708 Jade 126 1995 39 Fairmont Hotel (950 Mason Street, Nob Hill) In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
709 709 Jade 126 1995 39 Washington Square (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
710 710 Jade 126 1995 39 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
711 711 Jade 126 1995 39 Sheraton Palace Hotel (639 Market Street) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
712 712 Jade 126 1995 39 Palace of Fine Arts The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
1 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 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 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 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 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 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 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 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 9 24 Hours on Craigslist 2 2005 2     Yerba Buena Productions 2 Zealot Pictures 1 Michael Ferris Gibson 2   Craig Newmark 238    
10 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 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 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  
628 628 Happy Gilmore 113 1996 43     Brillstein-Grey Entertainment 78 Universal Pictures 41 Dennis Dugan 105 Tim Herlihy 105 Adam Sandler 240    

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