Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Title, Release Year, Production Company, Director, Writer, Actor 2, Actor 3
Actor 1 ✖
Link | rowid | Title | Release Year | Locations ▲ | Fun Facts | Production Company | Distributor | Director | Writer | Actor 1 | Actor 2 | Actor 3 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1566 | 1566 | Vertigo 298 | 1958 72 | York Hotel (940 Sutter Street) | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 | |
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 |
1214 | 1214 | Star Trek IV: The Voyage Home 225 | 1986 28 | West Harbor, Marina District | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
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 | |
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 |
522 | 522 | Foul Play 99 | 1978 7 | 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 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 |
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 |
1552 | 1552 | Twisted 209 | 2004 5 | Veterans' War Memorial Building (401 Van Ness Avenue) | Paramount Pictures 4 | Paramount Pictures 3 | Philip Kaufman 111 | Sarah Thorp 181 | Ashley Judd 324 | Samuel L. Jackson 160 | ||
1555 | 1555 | Twisted 209 | 2004 5 | Vesuvio Café (255 Columbus Avenue) | Jack Kerouac was a regular at the café. | Paramount Pictures 4 | Paramount Pictures 3 | Philip Kaufman 111 | Sarah Thorp 181 | Ashley Judd 324 | Samuel L. Jackson 160 | |
1287 | 1287 | Terminator - Genisys 239 | 2015 10 | Van Ness between Fell and Lombard | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
1300 | 1300 | Terminator - Genisys 239 | 2015 10 | Union Square | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
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 |
1556 | 1556 | Twisted 209 | 2004 5 | The Saloon (1232 Grant Avenue) | Paramount Pictures 4 | Paramount Pictures 3 | Philip Kaufman 111 | Sarah Thorp 181 | Ashley Judd 324 | Samuel L. Jackson 160 | ||
1024 | 1024 | Play it Again, Sam 191 | 1972 62 | The Music Concourse (Martin Luther King, Jr. Drive, Golden Gate Park) | The theater closed in 1985. | Paramount Pictures 4 | Paramount Pictures 3 | Herbert Ross 160 | Woody Allen 35 | Woody Allen 360 | Diane Keaton 147 | Tony Roberts 507 |
1303 | 1303 | Terminator - Genisys 239 | 2015 10 | Sutter Stockton Garage | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
523 | 523 | Foul Play 99 | 1978 7 | Sutter & Buchannan Streets | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 | |
524 | 524 | Foul Play 99 | 1978 7 | Sutter & Baker Streets | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 | |
631 | 631 | Harold and Maude 115 | 1971 42 | Sutro Baths (Point Lobos Avenue) | Mildred Lewis and Colin Higgins Productions 79 | Paramount Pictures 3 | Hal Ashby 107 | Colin Higgins 91 | Ruth Gordon 318 | Bud Cort 92 | ||
1025 | 1025 | Play it Again, Sam 191 | 1972 62 | Surf Theater (4520 Irving Street) | Paramount Pictures 4 | Paramount Pictures 3 | Herbert Ross 160 | Woody Allen 35 | Woody Allen 360 | Diane Keaton 147 | Tony Roberts 507 | |
1495 | 1495 | The Ten Commandments 282 | 1956 73 | St. Peter & Paul's Church (666 Filbert Street, Washington Square) | Exteriors of the church were used. | Paramount Pictures 4 | Paramount Pictures 3 | Cecil B. DeMille 231 | Jesse L. Lasky, Jr. 243 | Charlton Heston 419 | Yul Brynner 218 | Anne Baxter 15 |
525 | 525 | Foul Play 99 | 1978 7 | Sokoji-Soto Zen Buddhist Temple (1691 Laguna Street) | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 | |
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 |
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 | |
23 | 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 | |
1567 | 1567 | Vertigo 298 | 1958 72 | San Francisco Drydock (20th and Illinois Streets) | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 | |
1301 | 1301 | Terminator - Genisys 239 | 2015 10 | San Francisco - Oakland Bay Bridge | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
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 | |
526 | 526 | Foul Play 99 | 1978 7 | Sacramento & Hyde Streets (Nob Hill) | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 | |
1622 | 1622 | Zodiac 307 | 2007 75 | SF Chronicle Building (901 Mission St) | Paramount Pictures 4 | Paramount Pictures 3 | David Fincher 213 | James Vanderbilt 266 | Jake Gyllenhaal 438 | Mark Ruffalo 118 | ||
1547 | 1547 | Twisted 209 | 2004 5 | Red's Java House (Pier 30-32, The Embarcadero) | Paramount Pictures 4 | Paramount Pictures 3 | Philip Kaufman 111 | Sarah Thorp 181 | Ashley Judd 324 | Samuel L. Jackson 160 | ||
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 |
1305 | 1305 | Terminator - Genisys 239 | 2015 10 | Powell St at Geary St | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
528 | 528 | Foul Play 99 | 1978 7 | Potrero Hill Bathhouse & Feed Co. (199 Mississippi Street) | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 | |
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 | |
527 | 527 | Foul Play 99 | 1978 7 | 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 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 |
1293 | 1293 | Terminator - Genisys 239 | 2015 10 | Pine and Leavenworth | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
1309 | 1309 | Terminator - Genisys 239 | 2015 10 | Pine St. between Market and Montgomery | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
1298 | 1298 | Terminator - Genisys 239 | 2015 10 | Pine St. between Market and Kearny | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
1548 | 1548 | Twisted 209 | 2004 5 | Piers 30-32 | Paramount Pictures 4 | Paramount Pictures 3 | Philip Kaufman 111 | Sarah Thorp 181 | Ashley Judd 324 | Samuel L. Jackson 160 | ||
1549 | 1549 | Twisted 209 | 2004 5 | Pier 39 | Paramount Pictures 4 | Paramount Pictures 3 | Philip Kaufman 111 | Sarah Thorp 181 | Ashley Judd 324 | Samuel L. Jackson 160 | ||
1133 | 1133 | Twisted 209 | 2004 5 | Pier 24 | Paramount Pictures 4 | Paramount Pictures 3 | Philip Kaufman 111 | Sarah Thorp 181 | Ashley Judd 324 | Samuel L. Jackson 160 | ||
1308 | 1308 | Terminator - Genisys 239 | 2015 10 | Pier 14 | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
1568 | 1568 | Vertigo 298 | 1958 72 | Park Hill Sanatorium (351 Buena Vista Avenue East) | This location is now a condominium complex. | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 |
521 | 521 | Forrest Gump 98 | 1994 48 | 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. | Paramount Pictures 4 | Paramount Pictures 3 | Robert Zemeckis 89 | Eric Roth 90 | Tom Hanks 305 | Robin Wright 78 | |
1565 | 1565 | Vertigo 298 | 1958 72 | 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. | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 |
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 |
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 | |
529 | 529 | Foul Play 99 | 1978 7 | Octavia & Hayes Streets (Hayes Valley) | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 | |
1215 | 1215 | Star Trek IV: The Voyage Home 225 | 1986 28 | North Beach | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
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 |
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 | |
530 | 530 | Foul Play 99 | 1978 7 | Montgomery & Pine Streets (Financial District) | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 | |
1550 | 1550 | Twisted 209 | 2004 5 | Mojito (1337-1339 Grant Avenue) | Paramount Pictures 4 | Paramount Pictures 3 | Philip Kaufman 111 | Sarah Thorp 181 | Ashley Judd 324 | Samuel L. Jackson 160 | ||
1289 | 1289 | Terminator - Genisys 239 | 2015 10 | Mission at 1st and 2nd | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
1302 | 1302 | Terminator - Genisys 239 | 2015 10 | Mission St., Embarcadero, and Front between Clay and Market | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
1569 | 1569 | Vertigo 298 | 1958 72 | Mission San Juan Bautista (2nd & Mariposa Streets) | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 | |
1570 | 1570 | Vertigo 298 | 1958 72 | 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. | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 |
1551 | 1551 | Twisted 209 | 2004 5 | McCovey Point, China Basin Park (24 Willy Mays Plaza) | Paramount Pictures 4 | Paramount Pictures 3 | Philip Kaufman 111 | Sarah Thorp 181 | Ashley Judd 324 | Samuel L. Jackson 160 | ||
1290 | 1290 | Terminator - Genisys 239 | 2015 10 | Market at Mason | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
1297 | 1297 | Terminator - Genisys 239 | 2015 10 | Market St. at Embarcadero area | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
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 | |
1216 | 1216 | Star Trek IV: The Voyage Home 225 | 1986 28 | 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. | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 |
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 | |
531 | 531 | Foul Play 99 | 1978 7 | Laguna & Sacramento Streets (Pacific Heights) | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 | |
1554 | 1554 | Twisted 209 | 2004 5 | La Bodega (1332 Grant Avenue at Vallejo) | Paramount Pictures 4 | Paramount Pictures 3 | Philip Kaufman 111 | Sarah Thorp 181 | Ashley Judd 324 | Samuel L. Jackson 160 | ||
1217 | 1217 | Star Trek IV: The Voyage Home 225 | 1986 28 | Kearny & Pacific Streets | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
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 |
1218 | 1218 | Star Trek IV: The Voyage Home 225 | 1986 28 | Intersection of Grant & Fresno Streets (North Beach) | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
1219 | 1219 | Star Trek IV: The Voyage Home 225 | 1986 28 | Intersection of Columbus & Mason Streets | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
1220 | 1220 | Star Trek IV: The Voyage Home 225 | 1986 28 | Intersection of Columbus & Kearney Streets | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
1026 | 1026 | Play it Again, Sam 191 | 1972 62 | Hyde Street Cable Car | Paramount Pictures 4 | Paramount Pictures 3 | Herbert Ross 160 | Woody Allen 35 | Woody Allen 360 | Diane Keaton 147 | Tony Roberts 507 | |
1294 | 1294 | Terminator - Genisys 239 | 2015 10 | Howard St. from Embarcadero to 11 St. | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
22 | 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 | ||
532 | 532 | Foul Play 99 | 1978 7 | Hayes Valley Care (601 Laguna Street, Hayes Valley) | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 | |
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 | |
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 | |
21 | 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 | |
1030 | 1030 | Pleasure of His Company 193 | 1961 47 | Grace Cathedral Episcopal Church (1100 California Street) | Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. | Perlsea Company 122 | Paramount Pictures 3 | George Seaton 162 | Samuel A. Taylor 166 | Fred Astaire 362 | Debbie Reynolds 130 | Lilli Palmer 508 |
1571 | 1571 | Vertigo 298 | 1958 72 | Gough & Eddy Streets (Western Addition) | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 | |
632 | 632 | Harold and Maude 115 | 1971 42 | Golden Gate Park | Mildred Lewis and Colin Higgins Productions 79 | Paramount Pictures 3 | Hal Ashby 107 | Colin Higgins 91 | Ruth Gordon 318 | Bud Cort 92 | ||
1213 | 1213 | Star Trek II : The Wrath of Khan 224 | 1982 4 | Golden Gate Park | Paramount Pictures 4 | Paramount Pictures 3 | Nicholas Meyer 186 | Jack B. Sowards 195 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
1221 | 1221 | Star Trek IV: The Voyage Home 225 | 1986 28 | Golden Gate Park | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
903 | 903 | Mother 169 | 1996 43 | 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 | Albert Brooks 145 | Albert Brooks 148 | Albert Brooks 343 | Debbie Reynolds 130 | |
1222 | 1222 | Star Trek IV: The Voyage Home 225 | 1986 28 | 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 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 |
1225 | 1225 | Star Trek VI: The Undiscovered Country 226 | 1991 37 | 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 | Nicholas Meyer 186 | Nimoy 197 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 |
1345 | 1345 | The Core 250 | 2003 38 | 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. | David Foster Productions 151 | Paramount Pictures 3 | John Amiel 205 | Cooper Lane 217 | Aaron Eckhart 397 | Hilary Swank 192 | |
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 |
533 | 533 | Foul Play 99 | 1978 7 | Golden Gate & Steiner Streets (Hayes Valley) | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 | |
1299 | 1299 | Terminator - Genisys 239 | 2015 10 | Front St. between Market and Clay | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
534 | 534 | Foul Play 99 | 1978 7 | Fort Point, Presidio | 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 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 |
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 |
1572 | 1572 | Vertigo 298 | 1958 72 | 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. | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 |
535 | 535 | Foul Play 99 | 1978 7 | Fort Mason (Golden Gate National Recreation Area) | Constructed in 1864 as a coastal defense site, Fort Mason went on to serve as an army post for more than 100 years. | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 |
536 | 536 | Foul Play 99 | 1978 7 | Flood Building (870 Market Street) | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 | |
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 | |
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 | |
537 | 537 | Foul Play 99 | 1978 7 | Fiesta Laundromat (898 S. Van Ness Ave., Mission) | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 | |
1158 | 1158 | Serial 212 | 1980 34 | 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 | Bill Persky 175 | Rich Eustis 184 | Martin Mull 375 | Tuesday Weld 162 | |
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 |
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 |
JSON shape: default, array, newline-delimited
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");