Film_Locations_in_San_Francisco

Data source: data.sfgov.org

150 rows where Distributor = 6 sorted by Actor 3 descending

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, Fun Facts, 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 ▲
1443	1443	The Maltese Falcon 267	1941 63	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.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	John Huston 220	John Huston 231	Humphrey Bogart 289	Mary Astor 204	Gladys George 541
1444	1444	The Maltese Falcon 267	1941 63	Ferry Building	Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	John Huston 220	John Huston 231	Humphrey Bogart 289	Mary Astor 204	Gladys George 541
1445	1445	The Maltese Falcon 267	1941 63	Burritt Alley (Off Bush Street, between Powell and Stockton Streets)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	John Huston 220	John Huston 231	Humphrey Bogart 289	Mary Astor 204	Gladys George 541
1428	1428	The Jazz Singer 262	1927 71	Coffee Dan's (O'Farrell Street at Powell)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Alan Crosland 217	Alfred A. Cohn 228	Al Jolson 407	May McAvoy 200	Warner Oland 536
1313	1313	The Dead Pool 242	1988 23	Hall of Justice (850 Bryant Street)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1346	1346	The Dead Pool 242	1988 23	San Francisco Drydock (The Dogpatch)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1347	1347	The Dead Pool 242	1988 23	Washington Square Park (North Beach)	Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. The statue in the Park is Ben Franklin, not George Washington.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1348	1348	The Dead Pool 242	1988 23	One Thousand Powell Apartments (1000 Powell Street)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1349	1349	The Dead Pool 242	1988 23	The Cannery (281 Leavenworth Street, Fisherman's Wharf)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1350	1350	The Dead Pool 242	1988 23	Portsmouth Square (Chinatown)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1351	1351	The Dead Pool 242	1988 23	Pierce St. & Golden Gate Avenue (Hayes Valley)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1352	1352	The Dead Pool 242	1988 23	Pierce & California Streets (Pacific Heights)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1353	1353	The Dead Pool 242	1988 23	Pier 3 (The Embarcadero)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1354	1354	The Dead Pool 242	1988 23	New Asia Restaurant (772 Pacific Avenue at Grant)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1355	1355	The Dead Pool 242	1988 23	Nam Yuen Restaurant (740 Washington Street, Chinatown)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1356	1356	The Dead Pool 242	1988 23	Mirant Energy, LLC (1301 Illinois Street, The Dogpatch)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1357	1357	The Dead Pool 242	1988 23	McAllister & Scott Streets (Hayes Valley)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1358	1358	The Dead Pool 242	1988 23	KGO-TV ABC7 TV Studios (900 Front Street, Waterfront Historic District)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1360	1360	The Dead Pool 242	1988 23	San Francisco National Military Cemetery (Lincoln Blvd., The Presidio, Golden Gate National Recreation Center)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1361	1361	The Dead Pool 242	1988 23	Silver Restaurant (737 Washington Street, Chinatown)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1362	1362	The Dead Pool 242	1988 23	Fremont Street Exit of Bay Bridge		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1363	1363	The Dead Pool 242	1988 23	Folsom & Essex Streets		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1364	1364	The Dead Pool 242	1988 23	Eber Electronics (2355 Market Street, Castro)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1365	1365	The Dead Pool 242	1988 23	Clementina & Sumner Streets		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1366	1366	The Dead Pool 242	1988 23	Carl & Cole Streets (Cole Valley)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1367	1367	The Dead Pool 242	1988 23	710 Steiner Street (Hayes Valley)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1368	1368	The Dead Pool 242	1988 23	550 El Camino Del Mar (Seacliff)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1369	1369	The Dead Pool 242	1988 23	23rd & Iowa Streets (Dogpatch)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1370	1370	The Dead Pool 242	1988 23	22nd Bet. Carolina & Rhode Island Streets (Potrero Hill)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1371	1371	The Dead Pool 242	1988 23	22nd & Wisconsin Streets (Potrero Hill)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1372	1372	The Dead Pool 242	1988 23	20th & De Haro Streets (Potrero Hill)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1373	1373	The Dead Pool 242	1988 23	1954 Mason Street (North Beach)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1374	1374	The Dead Pool 242	1988 23	San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill)	SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Buddy Van Horn 199	Harry Julian Fink 71	Clint Eastwood 295	Liam Neeson 186	Patricia Clarkson 527
1270	1270	Susan Slade 234	1961 47	On Board the SS President Cleveland, docked at Pier 50		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Delmer Daves 66	Delmer Daves 204	Troy Donahue 390	Connie Stevens 179	Dorothy McGuire 525
1269	1269	Superman 233	1978 7	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.	Dovemead Films 142	Warner Bros. Pictures 6	Richard Donner 192	Jerry Siegel 203	Christopher Reeve 389	Gene Hackman 178	Marlon Brando 524
1245	1245	Sudden Impact 231	1983 65	Mt. Davidson	Mt. Davidson is highest point in San Francisco (938 feet).	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Clint Eastwood 113	Harry Julian Fink 71	Clint Eastwood 295	Sondra Locke 176	Pat Hingle 522
1246	1246	Sudden Impact 231	1983 65	McDonald's Restaurant (701 3rd Street, SOMA)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Clint Eastwood 113	Harry Julian Fink 71	Clint Eastwood 295	Sondra Locke 176	Pat Hingle 522
1247	1247	Sudden Impact 231	1983 65	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.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Clint Eastwood 113	Harry Julian Fink 71	Clint Eastwood 295	Sondra Locke 176	Pat Hingle 522
1248	1248	Sudden Impact 231	1983 65	Hall of Justice (850 Bryant Street)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Clint Eastwood 113	Harry Julian Fink 71	Clint Eastwood 295	Sondra Locke 176	Pat Hingle 522
1249	1249	Sudden Impact 231	1983 65	Ferry Plaza	Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Clint Eastwood 113	Harry Julian Fink 71	Clint Eastwood 295	Sondra Locke 176	Pat Hingle 522
1250	1250	Sudden Impact 231	1983 65	Fairmont Hotel (950 Mason Street, Nob Hill)	In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Clint Eastwood 113	Harry Julian Fink 71	Clint Eastwood 295	Sondra Locke 176	Pat Hingle 522
1251	1251	Sudden Impact 231	1983 65	Civic Center Plaza		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Clint Eastwood 113	Harry Julian Fink 71	Clint Eastwood 295	Sondra Locke 176	Pat Hingle 522
1252	1252	Sudden Impact 231	1983 65	The Embarcadero/Ferry Building	Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Clint Eastwood 113	Harry Julian Fink 71	Clint Eastwood 295	Sondra Locke 176	Pat Hingle 522
1253	1253	Sudden Impact 231	1983 65	Bowles Franklin Galleries (765 Beach Street, Fisherman's Wharf)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Clint Eastwood 113	Harry Julian Fink 71	Clint Eastwood 295	Sondra Locke 176	Pat Hingle 522
1254	1254	Sudden Impact 231	1983 65	Pier 38-40, The Embarcadero		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Clint Eastwood 113	Harry Julian Fink 71	Clint Eastwood 295	Sondra Locke 176	Pat Hingle 522
884	884	Memoirs of an Invisible Man 163	1992 22	St. Elizabeth Apartment House (901 Powell Street at Sacramento)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	John Carpenter 33	Robert Collector 142	Chevy Chase 79	Daryl Hannah 126	Sam Neill 499
865	865	Magnum Force 160	1973 16	Cost Plus World Market (2552 Taylor Street)		The Malpaso Company 59	Warner Bros. Pictures 6	Ted Post 138	John Milius 139	Clint Eastwood 295	Hal Holbrook 124	Mitchell Ryan 497
866	866	Magnum Force 160	1973 16	Vermont Street between 20th and 22nd Streets		The Malpaso Company 59	Warner Bros. Pictures 6	Ted Post 138	John Milius 139	Clint Eastwood 295	Hal Holbrook 124	Mitchell Ryan 497
867	867	Magnum Force 160	1973 16	San Francisco International Airport	SFO has a museum dedicated to aviation history.	The Malpaso Company 59	Warner Bros. Pictures 6	Ted Post 138	John Milius 139	Clint Eastwood 295	Hal Holbrook 124	Mitchell Ryan 497
868	868	Magnum Force 160	1973 16	San Francisco Drydock (20th and Illinois Streets)		The Malpaso Company 59	Warner Bros. Pictures 6	Ted Post 138	John Milius 139	Clint Eastwood 295	Hal Holbrook 124	Mitchell Ryan 497
869	869	Magnum Force 160	1973 16	Pacific Heights Towers (2200 Sacramento Street, Pacific Heights)		The Malpaso Company 59	Warner Bros. Pictures 6	Ted Post 138	John Milius 139	Clint Eastwood 295	Hal Holbrook 124	Mitchell Ryan 497
870	870	Magnum Force 160	1973 16	Lefty O' Doul Drawbridge/ 3rd Street Bridge (3rd Street, China Basin)	This is SF's only drawbridge, and was named after Francis Joseph "Lefty" O'Doul, a local baseball hero.	The Malpaso Company 59	Warner Bros. Pictures 6	Ted Post 138	John Milius 139	Clint Eastwood 295	Hal Holbrook 124	Mitchell Ryan 497
871	871	Magnum Force 160	1973 16	Hall of Justice (850 Bryant Street)		The Malpaso Company 59	Warner Bros. Pictures 6	Ted Post 138	John Milius 139	Clint Eastwood 295	Hal Holbrook 124	Mitchell Ryan 497
872	872	Magnum Force 160	1973 16	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.	The Malpaso Company 59	Warner Bros. Pictures 6	Ted Post 138	John Milius 139	Clint Eastwood 295	Hal Holbrook 124	Mitchell Ryan 497
873	873	Magnum Force 160	1973 16	Fairmont Hotel (950 Mason Street, Nob Hill)	In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room.	The Malpaso Company 59	Warner Bros. Pictures 6	Ted Post 138	John Milius 139	Clint Eastwood 295	Hal Holbrook 124	Mitchell Ryan 497
874	874	Magnum Force 160	1973 16	Embarcadero Freeway	demolished	The Malpaso Company 59	Warner Bros. Pictures 6	Ted Post 138	John Milius 139	Clint Eastwood 295	Hal Holbrook 124	Mitchell Ryan 497
875	875	Magnum Force 160	1973 16	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.	The Malpaso Company 59	Warner Bros. Pictures 6	Ted Post 138	John Milius 139	Clint Eastwood 295	Hal Holbrook 124	Mitchell Ryan 497
876	876	Magnum Force 160	1973 16	Broadway Tunnel (Russian Hill)		The Malpaso Company 59	Warner Bros. Pictures 6	Ted Post 138	John Milius 139	Clint Eastwood 295	Hal Holbrook 124	Mitchell Ryan 497
877	877	Magnum Force 160	1973 16	280 Freeway at Pennsylvania and Mariposa Streets		The Malpaso Company 59	Warner Bros. Pictures 6	Ted Post 138	John Milius 139	Clint Eastwood 295	Hal Holbrook 124	Mitchell Ryan 497
878	878	Magnum Force 160	1973 16	2190 Washington Street (Pacific Heights)		The Malpaso Company 59	Warner Bros. Pictures 6	Ted Post 138	John Milius 139	Clint Eastwood 295	Hal Holbrook 124	Mitchell Ryan 497
879	879	Magnum Force 160	1973 16	18th Street Overpass (Potrero Hill)		The Malpaso Company 59	Warner Bros. Pictures 6	Ted Post 138	John Milius 139	Clint Eastwood 295	Hal Holbrook 124	Mitchell Ryan 497
595	595	Godzilla 106	2014 11	Kearney & Pine St.		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
596	596	Godzilla 106	2014 11	California & Davis St		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
597	597	Godzilla 106	2014 11	Pine St. & Davis St		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
598	598	Godzilla 106	2014 11	Sacramento & Front St.		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
599	599	Godzilla 106	2014 11	Broadway & Sansome		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
600	600	Godzilla 106	2014 11	Broadway & Columbus		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
601	601	Godzilla 106	2014 11	Post & Jones St.		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
602	602	Godzilla 106	2014 11	Stockton & Clay St		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
603	603	Godzilla 106	2014 11	Bush & Kearny		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
604	604	Godzilla 106	2014 11	Mission & Fremont St		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
605	605	Godzilla 106	2014 11	Eddy & Taylor St.		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
606	606	Godzilla 106	2014 11	Pier 7 (The Embarcadero)		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
607	607	Godzilla 106	2014 11	Pier 1		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
608	608	Godzilla 106	2014 11	Embarcadero & Washington		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
609	609	Godzilla 106	2014 11	Mission & Beal		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
610	610	Godzilla 106	2014 11	Potrero &San Bruno		Nautilus Productions, LLC 74	Warner Bros. Pictures 6	Gareth Edwards 98	Max Borenstein 98	Aaron Taylor-Johnson 311	Elizabeth Olsen 85	Bryan Cranston 481
557	557	Gentleman Jim 101	1942 50	The 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.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Raoul Walsh 92	Vincent Lawrence 93	Errol Flynn 307	Alexis Smith 81	Jack Carson 479
504	504	Fearless 94	1993 46	400 Montgomery Street		Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
505	505	Fearless 94	1993 46	Folsom Street & Embarcadero		Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
506	506	Fearless 94	1993 46	Varennes Alley between Filbert and Union		Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
507	507	Fearless 94	1993 46	St. Peter & Paul's Church (666 Filbert Street, Washington Square)	Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials.	Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
508	508	Fearless 94	1993 46	San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill)	SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County.	Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
509	509	Fearless 94	1993 46	Kohl Building (400 Montgomery Street)		Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
510	510	Fearless 94	1993 46	Bank of America Building (555 California Street)	The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast.	Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
511	511	Fearless 94	1993 46	90 Gold Street		Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
512	512	Fearless 94	1993 46	5th and Beale Streets		Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
409	409	Days of Wine and Roses 75	1962 29			Warner Bros. Pictures 38	Warner Bros. Pictures 6	Blake Edwards 69	JP Miller 68	Jack Lemmon 292	Lee Remick 57	Charles Bickford 468
398	398	Dark Passage 72	1947 41	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.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Delmer Daves 66	Delmer Daves & David Goodis 65	Humphrey Bogart 289	Lauren Bacal 54	Bruce Bennett 465
399	399	Dark Passage 72	1947 41	The Malloch Apartment Building (1360 Montgomery Street)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Delmer Daves 66	Delmer Daves & David Goodis 65	Humphrey Bogart 289	Lauren Bacal 54	Bruce Bennett 465
400	400	Dark Passage 72	1947 41	Filbert Steps, Filbert Street		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Delmer Daves 66	Delmer Daves & David Goodis 65	Humphrey Bogart 289	Lauren Bacal 54	Bruce Bennett 465
993	993	Nora Prentiss 180	1947 41	Belgravia Apartments (795 Sutter Street at Jones)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Vincent Sherman 150	N. Richard Nash 155	Ann Sheridan 350	Kent Smith 137	Bruce Bennett 465
1393	1393	The Enforcer 255	1976 45	Sutter & Webster Streets		Warner Bros. Pictures 38	Warner Bros. Pictures 6	James Fargo 210	Stirling Silliphant 222	Clint Eastwood 295	Tyne Daly 195	Harry Guardino 60
1394	1394	The Enforcer 255	1976 45	Hall of Justice		Warner Bros. Pictures 38	Warner Bros. Pictures 6	James Fargo 210	Stirling Silliphant 222	Clint Eastwood 295	Tyne Daly 195	Harry Guardino 60
1395	1395	The Enforcer 255	1976 45	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.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	James Fargo 210	Stirling Silliphant 222	Clint Eastwood 295	Tyne Daly 195	Harry Guardino 60
1396	1396	The Enforcer 255	1976 45	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.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	James Fargo 210	Stirling Silliphant 222	Clint Eastwood 295	Tyne Daly 195	Harry Guardino 60
1397	1397	The Enforcer 255	1976 45	Balmy Street (Mission District)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	James Fargo 210	Stirling Silliphant 222	Clint Eastwood 295	Tyne Daly 195	Harry Guardino 60
1398	1398	The Enforcer 255	1976 45	Alcatraz Island	Alcatraz Island was a military fort before it became a prison.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	James Fargo 210	Stirling Silliphant 222	Clint Eastwood 295	Tyne Daly 195	Harry Guardino 60
1399	1399	The Enforcer 255	1976 45	24th Street Mini Park (Mission District)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	James Fargo 210	Stirling Silliphant 222	Clint Eastwood 295	Tyne Daly 195	Harry Guardino 60
1400	1400	The Enforcer 255	1976 45	23rd & Capp Streets (Mission District)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	James Fargo 210	Stirling Silliphant 222	Clint Eastwood 295	Tyne Daly 195	Harry Guardino 60

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