Data source: data.sfgov.org
This data as json, CSV (advanced)
Actor 2 ✖
Link | rowid | Title | Release Year | Locations | Fun Facts | Production Company | Distributor | Director | Writer | Actor 1 | Actor 2 | Actor 3 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 | |
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 | |
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 |
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 | |
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 |
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 |
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 | |
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 | ||
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 |
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");