Film_Locations_in_San_Francisco

49 rows where Distributor = 4

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
13	13	50 First Dates 5	2004 5	Rainforest Café (145 Jefferson Street)		Columbia Pictures Corporation 5	Columbia Pictures 4	Peter Segal 5	George Wing 4	Adam Sandler 240	Drew Barrymore 4
252	252	Casualties of War 47	1989 35	Mission Dolores Park (Mission District) via J-Church MUNI Train	The two land plots that comprise the Park were used as a Jewish cemetery until 1894 when San Francisco prohibited all burials within city limits. The graves were moved to Colma, CA.	Columbia Pictures Corporation 5	Columbia Pictures 4	Brian DePalma 45	Daniel Lang 44	Michael J. Fox 278	Sean Penn 40
488	488	Experiment in Terror 89	1962 29	George Washington High School (600 32nd Avenue )		Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
489	489	Experiment in Terror 89	1962 29	Wells Fargo Bank (1 California Street, Financial District)		Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
490	490	Experiment in Terror 89	1962 29	The Sea Captain's Chest (Fisherman's Wharf)		Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
491	491	Experiment in Terror 89	1962 29	Sheraton Palace Hotel (2 Montgomery Street, Financial District)	The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909.	Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
492	492	Experiment in Terror 89	1962 29	Roaring Twenties Nightclub (555 Broadway at Columbus)		Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
493	493	Experiment in Terror 89	1962 29	Candlestick Park	Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park.	Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
494	494	Experiment in Terror 89	1962 29	2632 Larkin Street at Lombard		Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
495	495	Experiment in Terror 89	1962 29	100 St. Germain Avenue		Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
496	496	Experiment in Terror 89	1962 29	1 Montgomery Street at Post		Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
616	616	Good NeighborSam 108	1964 51	Various locations in San Francisco during driving scene		Columbia Pictures Corporation 5	Columbia Pictures 4	David Swift 100	James Fritzell 100	Jack Lemmon 292	Romy Schneider 87	Dorothy Provine 482
623	623	Guess Who's Coming to Dinner 111	1967 53	Sutter Street between Powell and Mason		Columbia Pictures Corporation 5	Columbia Pictures 4	Stanley Kramer 103	William Rose 103	Spencer Tracy 315	Sidney Poitier 90	Katharine Hepburn 484
624	624	Guess Who's Coming to Dinner 111	1967 53	San Francisco International Airport	SFO has a museum dedicated to aviation history.	Columbia Pictures Corporation 5	Columbia Pictures 4	Stanley Kramer 103	William Rose 103	Spencer Tracy 315	Sidney Poitier 90	Katharine Hepburn 484
625	625	Guess Who's Coming to Dinner 111	1967 53	Mel's Drive-In (Corner South Van Ness & Mission St.)	This restaurant location was demolished; however another Mel's was reopened in 1986 on 3355 Geary Blvd.	Columbia Pictures Corporation 5	Columbia Pictures 4	Stanley Kramer 103	William Rose 103	Spencer Tracy 315	Sidney Poitier 90	Katharine Hepburn 484
626	626	Guess Who's Coming to Dinner 111	1967 53	634 Raycliff Terrace		Columbia Pictures Corporation 5	Columbia Pictures 4	Stanley Kramer 103	William Rose 103	Spencer Tracy 315	Sidney Poitier 90	Katharine Hepburn 484
702	702	It Came From Beneath the Sea 136	1955 57	Hunters Point	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.	Clover Productions 91	Columbia Pictures 4	Robert Gordon 126	George Worthing Yates 126	Kenneth Tobey 330	Faith Domergue 111	Donald Curtis 492
703	703	It Came From Beneath the Sea 136	1955 57	Chrissy Field	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.	Clover Productions 91	Columbia Pictures 4	Robert Gordon 126	George Worthing Yates 126	Kenneth Tobey 330	Faith Domergue 111	Donald Curtis 492
704	704	It Came From Beneath the Sea 136	1955 57	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.	Clover Productions 91	Columbia Pictures 4	Robert Gordon 126	George Worthing Yates 126	Kenneth Tobey 330	Faith Domergue 111	Donald Curtis 492
713	713	Jagged Edge 138	1985 9	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.	Columbia Pictures Corp. 93	Columbia Pictures 4	Richard Marquand 128	Joe Eszterhas 24	Glenn Close 331	Jeff Bridges 113	Peter Coyote 446
714	714	Jagged Edge 138	1985 9	City Hall	The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building.	Columbia Pictures Corp. 93	Columbia Pictures 4	Richard Marquand 128	Joe Eszterhas 24	Glenn Close 331	Jeff Bridges 113	Peter Coyote 446
902	902	Mona Lisa Smile 168	2003 38			Revolution Studios 107	Columbia Pictures 4	Mike Newell 144	Lawrence Konner 147	Julia Roberts 150	Kirsten Dunst 129
1002	1002	Pal Joey 184	1957 61	Spreckels Mansion (2080 Washington Street, Pacific Heights)		Columbia Pictures Corporation 5	Columbia Pictures 4	George Sidney 153	Dorothy Kingsley 159	Rita Hayworth 354	Frank Sinatra 141	Kim Novak 231
1003	1003	Pal Joey 184	1957 61	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.	Columbia Pictures Corporation 5	Columbia Pictures 4	George Sidney 153	Dorothy Kingsley 159	Rita Hayworth 354	Frank Sinatra 141	Kim Novak 231
1004	1004	Pal Joey 184	1957 61	Barbary Coast	The Barbary Coast was a red-light district that was largely destroyed in the 1906 earthquake. Though some of the establishments were rebuilt after the earthquake, an anti-vice campaign put the establishments out of business.	Columbia Pictures Corporation 5	Columbia Pictures 4	George Sidney 153	Dorothy Kingsley 159	Rita Hayworth 354	Frank Sinatra 141	Kim Novak 231
1053	1053	Quicksilver 197	1986 28	Pacific Stock Exchange		Columbia Pictures Corporation 5	Columbia Pictures 4	Thomas Michael Donnelly 164	Thomas Michael Donnelly 170	Kevin Bacon 365	Jami Gertz 152	Paul Rodriguez 511
1083	1083	Rent 202	2005 2	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.	Rent Productions LLC 127	Columbia Pictures 4	Chris Columbus 31	Stephen Chbosky 175	Anthony Rapp 369	Rosario Dawson 155
1328	1328	The Caine Mutiny 245	1954 69	The Embarcadero		Stanley Kramer Productions 113	Columbia Pictures 4	Edward Dmytryk 201	Stanley Roberts 212	Humphrey Bogart 289	Fred MacMurray 188	Jose Ferrer 529
1329	1329	The Caine Mutiny 245	1954 69	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.	Stanley Kramer Productions 113	Columbia Pictures 4	Edward Dmytryk 201	Stanley Roberts 212	Humphrey Bogart 289	Fred MacMurray 188	Jose Ferrer 529
1429	1429	The Lady from Shanghai 263	1947 41	Steinhart Aquarium (California Academy of Sciences, Golden Gate Park)	The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species.	Columbia Pictures Corp. 93	Columbia Pictures 4	Orson Welles 218	Orson Welles 229	Rita Hayworth 354	Orson Welles 201	Everett Sloane 537
1430	1430	The Lady from Shanghai 263	1947 41	Mandarin Theatre (1021 Grant Avenue)	The Mandarin Theatre was renamed the Sun Sing Theatre in 1949. It closed 1986.	Columbia Pictures Corp. 93	Columbia Pictures 4	Orson Welles 218	Orson Welles 229	Rita Hayworth 354	Orson Welles 201	Everett Sloane 537
1431	1431	The Lady from Shanghai 263	1947 41	Golden Gate Park	The Playland amusement park where "Hall of Mirrors" sequence at the end of the movie was filmed has since been destroyed. However, relics from the park are now housed at the nearby Cliff House.	Columbia Pictures Corp. 93	Columbia Pictures 4	Orson Welles 218	Orson Welles 229	Rita Hayworth 354	Orson Welles 201	Everett Sloane 537
1432	1432	The Lady from Shanghai 263	1947 41	Former Hall of Justice (750 Kearny Street at Washington)		Columbia Pictures Corp. 93	Columbia Pictures 4	Orson Welles 218	Orson Welles 229	Rita Hayworth 354	Orson Welles 201	Everett Sloane 537
1434	1434	The Lineup 265	1958 72	War Memorial Opera House (401 Van Ness Avenue)	In 1945 the United Nations had its first conference at The War Memorial Opera House.	Pajemer Productions 158	Columbia Pictures 4	Don Siegel 71	Stirling Silliphant 222	Eli Wallach 409	Robert Keith 202	Richard Jaeckel 539
1435	1435	The Lineup 265	1958 72	The Embarcadero		Pajemer Productions 158	Columbia Pictures 4	Don Siegel 71	Stirling Silliphant 222	Eli Wallach 409	Robert Keith 202	Richard Jaeckel 539
1436	1436	The Lineup 265	1958 72	Sutro Baths (Point Lobos Avenue)		Pajemer Productions 158	Columbia Pictures 4	Don Siegel 71	Stirling Silliphant 222	Eli Wallach 409	Robert Keith 202	Richard Jaeckel 539
1437	1437	The Lineup 265	1958 72	Steinhart Aquarium (California Academy of Sciences, Golden Gate Park)	The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species.	Pajemer Productions 158	Columbia Pictures 4	Don Siegel 71	Stirling Silliphant 222	Eli Wallach 409	Robert Keith 202	Richard Jaeckel 539
1438	1438	The Lineup 265	1958 72	Pier 41		Pajemer Productions 158	Columbia Pictures 4	Don Siegel 71	Stirling Silliphant 222	Eli Wallach 409	Robert Keith 202	Richard Jaeckel 539
1439	1439	The Lineup 265	1958 72	Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle, Nob Hill)	The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite.	Pajemer Productions 158	Columbia Pictures 4	Don Siegel 71	Stirling Silliphant 222	Eli Wallach 409	Robert Keith 202	Richard Jaeckel 539
1440	1440	The Lineup 265	1958 72	2090 Jackson Street		Pajemer Productions 158	Columbia Pictures 4	Don Siegel 71	Stirling Silliphant 222	Eli Wallach 409	Robert Keith 202	Richard Jaeckel 539
1448	1448	The Net 270	1995 39	Moscone Convention Center		Columbia Pictures Corp. 93	Columbia Pictures 4	Irwin Winkler 223	John Brancato 224	Sandra Bullock 411	Jeremy Northam 207
1449	1449	The Net 270	1995 39	Montgomery & Market Streets		Columbia Pictures Corp. 93	Columbia Pictures 4	Irwin Winkler 223	John Brancato 224	Sandra Bullock 411	Jeremy Northam 207
1478	1478	The Pursuit of Happyness 277	2006 68	Glen Park Subway Station		Columbia Pictures Corporation 5	Columbia Pictures 4	Steven Conrad 227	Gabriele Muccino 202	Will Smith 416	Jayden C. Smith 213
1479	1479	The Pursuit of Happyness 277	2006 68	Glide Memorial Church (434 Ellis St)		Columbia Pictures Corporation 5	Columbia Pictures 4	Steven Conrad 227	Gabriele Muccino 202	Will Smith 416	Jayden C. Smith 213
1480	1480	The Pursuit of Happyness 277	2006 68	Candlestick Park (602 Jamestown Ave.)	Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park.	Columbia Pictures Corporation 5	Columbia Pictures 4	Steven Conrad 227	Gabriele Muccino 202	Will Smith 416	Jayden C. Smith 213
1482	1482	The Pursuit of Happyness 277	2006 68	Golden Gate Park Children's Playground	Golden Gate Park is similar in shape but 20% larger than New York's Central Park.	Columbia Pictures Corporation 5	Columbia Pictures 4	Steven Conrad 227	Gabriele Muccino 202	Will Smith 416	Jayden C. Smith 213
1494	1494	The Sweetest Thing 281	2002 3	Golden Gate National Recreation Area	The size of the Recreation Area is over two and a half greater than that of the city and county of San Francisco.	Columbia Pictures Corp. 93	Columbia Pictures 4	Roger Kumble 230	Nancy M. Pimental 242	Cameron Diaz 418	Christina Applegate 217
1543	1543	To the Ends of the Earth 291	1948 56			Kennedy-Buckman Pictures 169	Columbia Pictures 4	Robert Stevenson 112	Jay Richard Kennedy 251	Dick Powell 427	Signe Hasso 226	Maylia 547
1544	1544	True Believer 292	1989 35			Columbia Pictures Corporation 5	Columbia Pictures 4	Joseph Ruben 238	Wesley Strick 252	James Woods 428	Robert Downey, Jr. 227

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