Data source: data.sfgov.org
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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 | ||
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 | ||
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 | |
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 |
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 |
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 | |
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 | |
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 |
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 |
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 | |
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 | ||
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 | ||
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 | ||
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 |
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 | |
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 | ||
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 | |
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 | |
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 | |
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 | |
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 |
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 |
541 | 541 | Foul Play 99 | 1978 7 | Andrew S. Hallidie Plaza (Market & Powell Streets) | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 | |
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 |
459 | 459 | Escape From Alcatraz 87 | 1979 44 | Alcatraz Island | Alcatraz Island was a military fort before it became a prison. | Paramount Pictures 4 | Paramount Pictures 3 | Donald Siegel 79 | Richard Tuggle 80 | Clint Eastwood 295 | Patrick McGoohan 68 | Robert Blossom 471 |
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 | |
676 | 676 | Indiana Jones and the Last Crusade 131 | 1989 35 | Administration Building (Treasure Island) | An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. | Paramount Pictures 4 | Paramount Pictures 3 | Steven Spielberg 122 | Jeffrey Boam 121 | Harrison Ford 12 | Sean Connery 107 | |
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 |
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 | |
20 | 20 | A Smile Like Yours 8 | 1997 8 | 75 California Street | Paramount Pictures 4 | Paramount Pictures 3 | Keith Samples 8 | Keith Samples & Kevin Meyer 7 | Greg Kinnear 243 | Lauren Holly 7 | ||
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 | |
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 | |
542 | 542 | Foul Play 99 | 1978 7 | 430 Vallejo Street (Telegraph Hill) | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 | |
543 | 543 | Foul Play 99 | 1978 7 | 24th and Castro Streets (Noe Valley) | Paramount Pictures 4 | Paramount Pictures 3 | Colin Higgins 90 | Colin Higgins 91 | Goldie Hawn 306 | Chevy Chase 79 | Burgess Meredith 477 | |
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 | |
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 | |
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 | |
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 |
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 | ||
12 | 12 | 48 Hours 4 | 1982 4 | Paramount Pictures 4 | Paramount Pictures 3 | Walter Hill 4 | Walter Hill 3 | Nick Nolte 19 | Eddie Murphy 3 | Annette O'Toole 440 | ||
76 | 76 | Another 48 Hours 21 | 1990 17 | Eddie Murphy Productions 18 | Paramount Pictures 3 | Walter Hill 4 | Walter Hill 3 | Eddie Murphy 3 | Nick Nolte 19 | |||
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 | ||
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 |
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");