Film_Locations_in_San_Francisco

Data source: data.sfgov.org

15 rows where Production Company = 70

View and edit SQL

Suggested facets: Title, Release Year, Fun Facts, 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
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 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 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 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 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 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  
658 Homeward Bound II: Lost in San Francisco 124 1996 43 Pier 39 (Fisherman's Wharf)   Walt Disney Pictures 70 Buena Vista Pictures 25 David R. Ellis 115 Sheila Burnford 115 Michael J. Fox 278 Sally Field 100  
1455 The Parent Trap 274 1998 18 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. Walt Disney Pictures 70 Buena Vista Pictures 25 Nancy Meyers 225 Nancy Meyers 237 Lindsay Lohan 414 Dennis Quaid 210  
1471 The Princess Diaries 276 2001 33 724 Brazil Avenue   Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1472 The Princess Diaries 276 2001 33 Fisherman's Wharf Supposedly, Mikhail S. Gorbachev has said that his favorite part of visiting America was touring Fisherman's Wharf. Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1473 The Princess Diaries 276 2001 33 Firestation #3 (Brazil Avenue and Athens Street)   Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1474 The Princess Diaries 276 2001 33 Cliff House (1090 Point Lobos Avenue) The Musee Mechanique, which Julie Andrews' character visits in the movie, was at the time housed under the Cliff House. Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1475 The Princess Diaries 276 2001 33 Broadway Tunnel (Broadway between Powell and Larkin)   Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1476 The Princess Diaries 276 2001 33 Baker Beach   Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1477 The Princess Diaries 276 2001 33 2601 Lyon Street   Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  

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