Film_Locations_in_San_Francisco

Data source: data.sfgov.org

149 rows where Distributor = 3 sorted by Release Year

Search:

- remove filter - rowid Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by Title Sort by Release Year Sort by Locations Sort by Fun Facts Sort by Production Company Sort by Distributor Sort by Director Sort by Writer Sort by Actor 1 Sort by Actor 2 Sort by Actor 3

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Production Company, Director, Writer, Actor 1, Actor 2, Actor 3

Link	rowid	Title	Release Year ▼	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
12	12	48 Hours 4	1982 4			Paramount Pictures 4	Paramount Pictures 3	Walter Hill 4	Walter Hill 3	Nick Nolte 19	Eddie Murphy 3	Annette O'Toole 440
1213	1213	Star Trek II : The Wrath of Khan 224	1982 4	Golden Gate Park		Paramount Pictures 4	Paramount Pictures 3	Nicholas Meyer 186	Jack B. Sowards 195	William Shatner 383	Leonard Nimoy 171	George Takei 518
1133	1133	Twisted 209	2004 5	Pier 24		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1547	1547	Twisted 209	2004 5	Red's Java House (Pier 30-32, The Embarcadero)		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1548	1548	Twisted 209	2004 5	Piers 30-32		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1549	1549	Twisted 209	2004 5	Pier 39		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1550	1550	Twisted 209	2004 5	Mojito (1337-1339 Grant Avenue)		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1551	1551	Twisted 209	2004 5	McCovey Point, China Basin Park (24 Willy Mays Plaza)		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1552	1552	Twisted 209	2004 5	Veterans' War Memorial Building (401 Van Ness Avenue)		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1553	1553	Twisted 209	2004 5			Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1554	1554	Twisted 209	2004 5	La Bodega (1332 Grant Avenue at Vallejo)		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1555	1555	Twisted 209	2004 5	Vesuvio Café (255 Columbus Avenue)	Jack Kerouac was a regular at the café.	Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1556	1556	Twisted 209	2004 5	The Saloon (1232 Grant Avenue)		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
522	522	Foul Play 99	1978 7	War Memorial Opera House (401 Van Ness Avenue)	In 1945 the United Nations had its first conference at The War Memorial Opera House.	Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
523	523	Foul Play 99	1978 7	Sutter & Buchannan Streets		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
524	524	Foul Play 99	1978 7	Sutter & Baker Streets		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
525	525	Foul Play 99	1978 7	Sokoji-Soto Zen Buddhist Temple (1691 Laguna Street)		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
526	526	Foul Play 99	1978 7	Sacramento & Hyde Streets (Nob Hill)		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
527	527	Foul Play 99	1978 7	Postcard Row (Alamo Square, Hayes Valley)	The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire.	Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
528	528	Foul Play 99	1978 7	Potrero Hill Bathhouse & Feed Co. (199 Mississippi Street)		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
529	529	Foul Play 99	1978 7	Octavia & Hayes Streets (Hayes Valley)		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
530	530	Foul Play 99	1978 7	Montgomery & Pine Streets (Financial District)		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
531	531	Foul Play 99	1978 7	Laguna & Sacramento Streets (Pacific Heights)		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
532	532	Foul Play 99	1978 7	Hayes Valley Care (601 Laguna Street, Hayes Valley)		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
533	533	Foul Play 99	1978 7	Golden Gate & Steiner Streets (Hayes Valley)		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
534	534	Foul Play 99	1978 7	Fort Point, Presidio	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	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
535	535	Foul Play 99	1978 7	Fort Mason (Golden Gate National Recreation Area)	Constructed in 1864 as a coastal defense site, Fort Mason went on to serve as an army post for more than 100 years.	Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
536	536	Foul Play 99	1978 7	Flood Building (870 Market Street)		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
537	537	Foul Play 99	1978 7	Fiesta Laundromat (898 S. Van Ness Ave., Mission)		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
538	538	Foul Play 99	1978 7	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.	Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
539	539	Foul Play 99	1978 7	California & Larkin Streets (Nob Hill)		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
540	540	Foul Play 99	1978 7	Asian Art Museum (200 Larkin Street, Civic Center)	The Dalai Lama opened an exhibition on Wisdom and Compassion at the museum in 1991.	Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
541	541	Foul Play 99	1978 7	Andrew S. Hallidie Plaza (Market & Powell Streets)		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
542	542	Foul Play 99	1978 7	430 Vallejo Street (Telegraph Hill)		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
543	543	Foul Play 99	1978 7	24th and Castro Streets (Noe Valley)		Paramount Pictures 4	Paramount Pictures 3	Colin Higgins 90	Colin Higgins 91	Goldie Hawn 306	Chevy Chase 79	Burgess Meredith 477
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
1286	1286	Terminator - Genisys 239	2015 10	16th and Utah	Helicopter flies over Utah St. from 16th, rises up before freeway	T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1287	1287	Terminator - Genisys 239	2015 10	Van Ness between Fell and Lombard		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1288	1288	Terminator - Genisys 239	2015 10	California between Leavenworth and Powell		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1289	1289	Terminator - Genisys 239	2015 10	Mission at 1st and 2nd		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1290	1290	Terminator - Genisys 239	2015 10	Market at Mason		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1291	1291	Terminator - Genisys 239	2015 10	California at Larkin		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1292	1292	Terminator - Genisys 239	2015 10	California at Jones		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1293	1293	Terminator - Genisys 239	2015 10	Pine and Leavenworth		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1294	1294	Terminator - Genisys 239	2015 10	Howard St. from Embarcadero to 11 St.		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1295	1295	Terminator - Genisys 239	2015 10	Construction Site in front of 260 Stockton St. at Post St.		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1296	1296	Terminator - Genisys 239	2015 10	California St. between Drumm St. and Kearny St.		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1297	1297	Terminator - Genisys 239	2015 10	Market St. at Embarcadero area		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1298	1298	Terminator - Genisys 239	2015 10	Pine St. between Market and Kearny		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1299	1299	Terminator - Genisys 239	2015 10	Front St. between Market and Clay		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1300	1300	Terminator - Genisys 239	2015 10	Union Square		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1301	1301	Terminator - Genisys 239	2015 10	San Francisco - Oakland Bay Bridge		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1302	1302	Terminator - Genisys 239	2015 10	Mission St., Embarcadero, and Front between Clay and Market		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1303	1303	Terminator - Genisys 239	2015 10	Sutter Stockton Garage		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1304	1304	Terminator - Genisys 239	2015 10	Bush St. at Stockton St.		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1305	1305	Terminator - Genisys 239	2015 10	Powell St at Geary St		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1306	1306	Terminator - Genisys 239	2015 10	1 Market St. Landmark Building		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1307	1307	Terminator - Genisys 239	2015 10	Embarcadero between Pier 2 and Harrison		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1308	1308	Terminator - Genisys 239	2015 10	Pier 14		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
1309	1309	Terminator - Genisys 239	2015 10	Pine St. between Market and Montgomery		T5 Productions LLC 145	Paramount Pictures 3	Alan Taylor 196	James Cameron 208	Arnold Schwarzenegger 334	Jason Clarke 183
76	76	Another 48 Hours 21	1990 17			Eddie Murphy Productions 18	Paramount Pictures 3	Walter Hill 4	Walter Hill 3	Eddie Murphy 3	Nick Nolte 19
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
1545	1545	Tucker: The Man and His Dream 293	1988 23	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.	Lucasfilm 170	Paramount Pictures 3	Francis Ford Coppola 127	Arnold Schulman 253	Jeff Bridges 113	Joan Allen 228	Marin Landau 548
1214	1214	Star Trek IV: The Voyage Home 225	1986 28	West Harbor, Marina District		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1215	1215	Star Trek IV: The Voyage Home 225	1986 28	North Beach		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1216	1216	Star Trek IV: The Voyage Home 225	1986 28	Marina Green, Marina District	Before the 1906 earthquake, the land on which Marina Green sits was a tidal marsh, and rubble from the earthquake was dumped on the site. However, the site was filled in to provide land for the 1915 Panama-Pacific Exhibition.	Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1217	1217	Star Trek IV: The Voyage Home 225	1986 28	Kearny & Pacific Streets		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1218	1218	Star Trek IV: The Voyage Home 225	1986 28	Intersection of Grant & Fresno Streets (North Beach)		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1219	1219	Star Trek IV: The Voyage Home 225	1986 28	Intersection of Columbus & Mason Streets		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1220	1220	Star Trek IV: The Voyage Home 225	1986 28	Intersection of Columbus & Kearney Streets		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1221	1221	Star Trek IV: The Voyage Home 225	1986 28	Golden Gate Park		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1222	1222	Star Trek IV: The Voyage Home 225	1986 28	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	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1223	1223	Star Trek IV: The Voyage Home 225	1986 28	Bessie Charmichael Elementary School (375 Seventh Street, SOMA)		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1224	1224	Star Trek IV: The Voyage Home 225	1986 28	500 Block of Pacific Avenue (Chinatown)		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1158	1158	Serial 212	1980 34	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	Bill Persky 175	Rich Eustis 184	Martin Mull 375	Tuesday Weld 162
502	502	Fat Man and Little Boy 92	1989 35	Postcard Row (Alamo Square, Hayes Valley)	The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire.	Paramount Pictures 4	Paramount Pictures 3	Roland Joffe 83	Roland Joffe 85	Paul Newman 214	John Cusack 72
676	676	Indiana Jones and the Last Crusade 131	1989 35	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.	Paramount Pictures 4	Paramount Pictures 3	Steven Spielberg 122	Jeffrey Boam 121	Harrison Ford 12	Sean Connery 107
1225	1225	Star Trek VI: The Undiscovered Country 226	1991 37	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	Nicholas Meyer 186	Nimoy 197	William Shatner 383	Leonard Nimoy 171	George Takei 518
1345	1345	The Core 250	2003 38	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.	David Foster Productions 151	Paramount Pictures 3	John Amiel 205	Cooper Lane 217	Aaron Eckhart 397	Hilary Swank 192
660	660	Jade 126	1995 39	Lombard & Hyde Streets		Paramount Pictures 4	Paramount Pictures 3	William Friedkin 117	Joe Eszterhas 24	David Caruso 223	Linda Fiorentino 102	Chazz Palminteri 487
685	685	Jade 126	1995 39	Hall of Justice (850 Bryant Street)		Paramount Pictures 4	Paramount Pictures 3	William Friedkin 117	Joe Eszterhas 24	David Caruso 223	Linda Fiorentino 102	Chazz Palminteri 487
706	706	Jade 126	1995 39	Japanese Tea Garden (Hagiwara Tea Garden Drive, Golden Gate Park)	The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden	Paramount Pictures 4	Paramount Pictures 3	William Friedkin 117	Joe Eszterhas 24	David Caruso 223	Linda Fiorentino 102	Chazz Palminteri 487
707	707	Jade 126	1995 39	Fior d' Italia (601 Union Street at Stockton)		Paramount Pictures 4	Paramount Pictures 3	William Friedkin 117	Joe Eszterhas 24	David Caruso 223	Linda Fiorentino 102	Chazz Palminteri 487

Next page

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