Film_Locations_in_San_Francisco

Data source: data.sfgov.org

28 rows where Release Year = 8

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Locations, Fun Facts, Production Company, Distributor, Director, Writer, Actor 1, Actor 2

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
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  
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  
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  
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  
446 446 Dream with the Fishes 84 1997 8 Pier 39   3 Ring Circus Films 46 Sony Pictures Classics 27 Finn Taylor 56 Finn Taylor & Jeffrey Brown 77 David Arquette 299 Brad Hunt 65  
447 447 Dream with the Fishes 84 1997 8 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. 3 Ring Circus Films 46 Sony Pictures Classics 27 Finn Taylor 56 Finn Taylor & Jeffrey Brown 77 David Arquette 299 Brad Hunt 65  
503 503 Fathers' Day 93 1997 8     Northern Lights Entertainment 67 Columbia Broadcasting System 22 Ivan Reitman 84 Lowell Ganz 79 Robin Williams 265 Billy Crystal 73  
520 520 Flubber 97 1997 8 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. Walt Disney Pictures 70 Buena Vista Pictures 25 Les Mayfield 88 Samuel W. Taylor 89 Robin Williams 265 Marcia Gay Harden 77  
558 558 George of the Jungle 102 1997 8 755 Vallejo Street   Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  
559 559 George of the Jungle 102 1997 8 The Tamalpais Building (1201 Greenwich Street at Hyde)   Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  
560 560 George of the Jungle 102 1997 8 Neiman Marcus (150 Stockton Street, Union Square) The City of Paris department store previously occupied the space that now houses Neiman Marcus. City of Paris' original rotunda and glass dome were incorporated into Neiman Marcus' design. Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  
561 561 George of the Jungle 102 1997 8 First Bank (550 Montgomery Street at Commercial) Called "Stanhope Bank" in the film. Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  
562 562 George of the Jungle 102 1997 8 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  
885 885 Metro 164 1997 8 Bush Street at Jones   Touchstone Pictures 104 Buena Vista Pictures 25 Thomas Carter 140 Randy Feldman 143 Eddie Murphy 3    
1404 1404 The Game 258 1997 8 Merchant Exchange Building (465 California Street)   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1405 1405 The Game 258 1997 8 Washington Street & Waverly Place (Chinatown)   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1406 1406 The Game 258 1997 8 Stockton Tunnel Southern Approach Overhang (Bush & Stockton Streets, Chinatown) Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area. Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1407 1407 The Game 258 1997 8 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. Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1408 1408 The Game 258 1997 8 Ritz-Carlton Hotel (600 Stockton Street)   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1409 1409 The Game 258 1997 8 Presidio (Golden Gate National Recreation Area) In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1410 1410 The Game 258 1997 8 Merchant Exchange Building   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1411 1411 The Game 258 1997 8 Mason & California Streets (Nob Hill)   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1412 1412 The Game 258 1997 8 Harrison Street (The Embarcadero)   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1413 1413 The Game 258 1997 8 City Club (155 Sansome Street)   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1414 1414 The Game 258 1997 8 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1415 1415 The Game 258 1997 8 Bank of America Building (555 California Street) The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast. Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1416 1416 The Game 258 1997 8 301 Howard Street   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1417 1417 The Game 258 1997 8 1 Bush Street   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532

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