Film_Locations_in_San_Francisco

Data source: data.sfgov.org

149 rows where Distributor = 3 sorted by Release Year

✎ View and edit SQL

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
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
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
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  
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  
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
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
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  
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
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
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
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
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  

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