Film_Locations_in_San_Francisco

15 rows where Title = 275

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
1456	1456	The Presidio 275	1988 23	Washington Street & Waverly Place (Chinatown)		Paramount Pictures 4	Paramount Pictures 3	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46
1457	1457	The Presidio 275	1988 23	Sansome Street (The Embarcadero)		Paramount Pictures 4	Paramount Pictures 3	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46
1458	1458	The Presidio 275	1988 23	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.	Paramount Pictures 4	Paramount Pictures 3	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46
1459	1459	The Presidio 275	1988 23	Montgomery & Vallejo Streets (Telegraph Hill)		Paramount Pictures 4	Paramount Pictures 3	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46
1460	1460	The Presidio 275	1988 23	Market & 2nd Streets		Paramount Pictures 4	Paramount Pictures 3	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46
1461	1461	The Presidio 275	1988 23	Hayes & Polk Streets (Civic Center)		Paramount Pictures 4	Paramount Pictures 3	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46
1462	1462	The Presidio 275	1988 23	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	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46
1463	1463	The Presidio 275	1988 23	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.	Paramount Pictures 4	Paramount Pictures 3	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46
1464	1464	The Presidio 275	1988 23	Ferry Building	Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.	Paramount Pictures 4	Paramount Pictures 3	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46
1465	1465	The Presidio 275	1988 23	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.	Paramount Pictures 4	Paramount Pictures 3	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46
1466	1466	The Presidio 275	1988 23	Civic Center Plaza		Paramount Pictures 4	Paramount Pictures 3	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46
1467	1467	The Presidio 275	1988 23	Battery Street (The Embarcadero)		Paramount Pictures 4	Paramount Pictures 3	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46
1468	1468	The Presidio 275	1988 23	900 Block of Grant Avenue (Chinatown)		Paramount Pictures 4	Paramount Pictures 3	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46
1469	1469	The Presidio 275	1988 23	700 Block of Jackson Street (Chinatown)		Paramount Pictures 4	Paramount Pictures 3	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46
1470	1470	The Presidio 275	1988 23	200 Block of Sansome Street (Financial District)		Paramount Pictures 4	Paramount Pictures 3	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46

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