Film_Locations_in_San_Francisco

Data source: data.sfgov.org

149 rows where Distributor = 3 sorted by Actor 1 descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, 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
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  
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
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
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
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
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
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
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
1573 1573 Vertigo 298 1958 72 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. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1574 1574 Vertigo 298 1958 72 Ernie's Restaurant (847 Montgomery Street) Called the "Essex Club" in the film. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1575 1575 Vertigo 298 1958 72 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1576 1576 Vertigo 298 1958 72 Claude Lane at Bush 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
1577 1577 Vertigo 298 1958 72 California Palace of the Legion of Honor (34th Avenue & Clement, Lincoln Park) Built in 1924, the Legion of Honor is a 3/4 replica of the Parisian Palais de la Legion d'Honneur. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1578 1578 Vertigo 298 1958 72 Brocklebank Apartments (1000 Mason 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
1579 1579 Vertigo 298 1958 72 900 Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1580 1580 Vertigo 298 1958 72 1007 Gough Street Tennis courts now sit on the site; in the movie the structure was Carlota Valdes' home. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1517 1517 Thief of Hearts 288 1984 40     Paramount Pictures 4 Paramount Pictures 3 Douglas Day Stewart 236 Douglas Day Stewart 248 Steven Bauer  424 David Caruso 223 Barbara Williams 545
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
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  
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
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
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
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
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
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
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
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
1223 1223 Star Trek IV: The Voyage Home 225 1986 28 Bessie Charmichael Elementary School (375 Seventh Street, SOMA)   Paramount Pictures 4 Paramount Pictures 3 Leonard Nimoy 187 Steve Meerson 196 William Shatner 383 Leonard Nimoy 171 George Takei 518
1224 1224 Star Trek IV: The Voyage Home 225 1986 28 500 Block of Pacific Avenue (Chinatown)   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
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  
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
1023 1023 Play it Again, Sam 191 1972 62 Balboa at 22nd Avenue   Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
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
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
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
1027 1027 Play it Again, Sam 191 1972 62 Aquatic Park (Jefferson Street) Located at one end of Fisherman's Wharf, Aquatic Park was built as part of FDR's Works Progress Administration Project. Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
1028 1028 Play it Again, Sam 191 1972 62 15-17 Fresno Street   Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
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  
904 904 Mother 169 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. Paramount Pictures 4 Paramount Pictures 3 Albert Brooks 145 Albert Brooks 148 Albert Brooks 343 Debbie Reynolds 130  
1286 1286 Terminator - Genisys 239 2015 10 16th and Utah Helicopter flies over Utah St. from 16th, rises up before freeway T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
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  
1288 1288 Terminator - Genisys 239 2015 10 California between Leavenworth and Powell   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
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  
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  
1291 1291 Terminator - Genisys 239 2015 10 California at Larkin   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1292 1292 Terminator - Genisys 239 2015 10 California at Jones   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
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  
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  
1295 1295 Terminator - Genisys 239 2015 10 Construction Site in front of 260 Stockton St. at Post St.   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1296 1296 Terminator - Genisys 239 2015 10 California St. between Drumm St. and Kearny St.   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  
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  
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  
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  
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  
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  
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  
1304 1304 Terminator - Genisys 239 2015 10 Bush St. at Stockton St.   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
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  
1306 1306 Terminator - Genisys 239 2015 10 1 Market St. Landmark Building   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1307 1307 Terminator - Genisys 239 2015 10 Embarcadero between Pier 2 and Harrison   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
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  
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  
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  
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  
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  
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  
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  
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  
1553 1553 Twisted 209 2004 5     Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
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  
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  
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  
630 630 Harold and Maude 115 1971 42 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. Mildred Lewis and Colin Higgins Productions 79 Paramount Pictures 3 Hal Ashby 107 Colin Higgins 91 Ruth Gordon 318 Bud Cort 92  
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  
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  
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
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
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
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
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
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
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
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
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
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
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
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
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
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
538 538 Foul Play 99 1978 7 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. Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
539 539 Foul Play 99 1978 7 California & Larkin Streets (Nob Hill)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
540 540 Foul Play 99 1978 7 Asian Art Museum (200 Larkin Street, Civic Center) The Dalai Lama opened an exhibition on Wisdom and Compassion at the museum in 1991. Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477

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