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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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 | |
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 | |
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 | |
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 |
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 |
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 |
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 |
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 |
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 | |
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 |
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 | |
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 | |
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 | |
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 | ||
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 | ||
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 | |
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 | |
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 | |
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 | |
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 |
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 | |
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 |
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 | |
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 | |
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 |
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 |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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 | |
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 | |
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 | |
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 | |
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 |
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 | |
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 | |
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 |
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 | |||
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 | |
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 | ||
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 | |
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 | ||
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 |
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");