Film_Locations_in_San_Francisco

17 rows where Release Year = 18

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
88	88	Around the Fire 22	1998 18	Ocean Beach	On Jan. 25, 1878, the King Philip ship crashed in Ocean Beach. Occasionally, the ship's wreckage may be found on the beach-- most recently it was seen in 2007.	Paradigm Studio 19	Ardustry Home Entertainment 15	John Jacobsen 20	John Comerford 19	Tara Reid 255
374	374	City of Angels 64	1998 18	San Francisco Public Library Main Branch (100 Larkin Street)		Atlas Entertainment 48	Warner Bros. Pictures 6	Brad Silberling 58	Dana Stevens 58	Nicolas Cage 216	Meg Ryan 46
410	410	Desperate Measures 76	1998 18			Mandalay Entertainment 57	TriStar Pictures 20	Barbet Schroeder 70	David Klass 69	Michael Keaton 293	Andy Garcia 58	Raven-Symone 469
429	429	Doctor Dolittle 79	1998 18	Webster Street		Twentieth Century Fox Film Cooperation 60	Twentieth Century Fox Film Cooperation 45	Betty Thomas 72	Nat Mauldin 72	Eddie Murphy 3	Ossie Davis 61
430	430	Doctor Dolittle 79	1998 18	Telegraph Hill Blvd (Telegraph Hill)		Twentieth Century Fox Film Cooperation 60	Twentieth Century Fox Film Cooperation 45	Betty Thomas 72	Nat Mauldin 72	Eddie Murphy 3	Ossie Davis 61
431	431	Doctor Dolittle 79	1998 18	Larkin & Hyde Streets		Twentieth Century Fox Film Cooperation 60	Twentieth Century Fox Film Cooperation 45	Betty Thomas 72	Nat Mauldin 72	Eddie Murphy 3	Ossie Davis 61
432	432	Doctor Dolittle 79	1998 18	Gabbiano's Restaurant (Ferry Building)	Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.	Twentieth Century Fox Film Cooperation 60	Twentieth Century Fox Film Cooperation 45	Betty Thomas 72	Nat Mauldin 72	Eddie Murphy 3	Ossie Davis 61
433	433	Doctor Dolittle 79	1998 18	Coit Tower	The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way.	Twentieth Century Fox Film Cooperation 60	Twentieth Century Fox Film Cooperation 45	Betty Thomas 72	Nat Mauldin 72	Eddie Murphy 3	Ossie Davis 61
434	434	Doctor Dolittle 79	1998 18	2107 Union Street		Twentieth Century Fox Film Cooperation 60	Twentieth Century Fox Film Cooperation 45	Betty Thomas 72	Nat Mauldin 72	Eddie Murphy 3	Ossie Davis 61
435	435	Doctor Dolittle 79	1998 18	2100 Green Street		Twentieth Century Fox Film Cooperation 60	Twentieth Century Fox Film Cooperation 45	Betty Thomas 72	Nat Mauldin 72	Eddie Murphy 3	Ossie Davis 61
661	661	How Stella Got Her Groove Back 127	1998 18	Marriot Hotel (55 4th Street at Market)		Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Kevin Rodney Sullivan 118	Terry McMillan 117	Angela Bassett 325	Taye Diggs 103
1010	1010	Patch Adams 187	1998 18	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.	Bungalow 78 Productions 118	Universal Pictures 41	Tom Shadyac 156	Steve Oedekerk 162	Robin Williams 265	Philip Seymour Hoffman 143
1011	1011	Patch Adams 187	1998 18	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.	Bungalow 78 Productions 118	Universal Pictures 41	Tom Shadyac 156	Steve Oedekerk 162	Robin Williams 265	Philip Seymour Hoffman 143
1012	1012	Patch Adams 187	1998 18	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.	Bungalow 78 Productions 118	Universal Pictures 41	Tom Shadyac 156	Steve Oedekerk 162	Robin Williams 265	Philip Seymour Hoffman 143
1212	1212	Sphere 223	1998 18	S.S. Jeremiah O'Brien		Constant c Productions 137	Warner brothers Pictures 84	Barry Levinson 185	Kurt Wimmer 194	Dustin Hoffman 197	Sharon Stone 23
1455	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
1581	1581	What Dreams May Come 299	1998 18	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.	Polygram Filmed Entertainment 156	Polygram Filmed Entertainment 110	Vincent Ward 243	Ron Bass 259	Robin Williams 265	Cuba Gooding, Jr. 232

Advanced export

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