Film_Locations_in_San_Francisco

Data source: data.sfgov.org

150 rows where Distributor = 6 sorted by Production Company

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
16	16	A Night Full of Rain 7	1978 7	Embarcadero Freeway	Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake)	Liberty Film 7	Warner Bros. Pictures 6	Lina Wertmuller 7	Lina Wertmuller 6	Candice Bergen 242	Giancarlo Gianni 6
17	17	A Night Full of Rain 7	1978 7	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.	Liberty Film 7	Warner Bros. Pictures 6	Lina Wertmuller 7	Lina Wertmuller 6	Candice Bergen 242	Giancarlo Gianni 6
18	18	A Night Full of Rain 7	1978 7	San Francisco Chronicle (901 Mission Street at 15th Street)	The San Francisco Zodiac Killer of the late 1960s sent his notes and letters to the Chronicle's offices.	Liberty Film 7	Warner Bros. Pictures 6	Lina Wertmuller 7	Lina Wertmuller 6	Candice Bergen 242	Giancarlo Gianni 6
19	19	A Night Full of Rain 7	1978 7	Broadway (North Beach)		Liberty Film 7	Warner Bros. Pictures 6	Lina Wertmuller 7	Lina Wertmuller 6	Candice Bergen 242	Giancarlo Gianni 6
213	213	Burglar 43	1987 32	1627 Haight Street		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Hugh Wilson 41	Joseph Loeb III 40	Whoopi Goldberg 274	Bobcat Goldwait 37
235	235	Burglar 43	1987 32	California Academy of Sciences (Golden Gate Park)	Founded in 1853, 3 years after California joined the United States, the Academy was originally named the California Academy of Natural Sciences and was the first institution of its kind in the United States.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Hugh Wilson 41	Joseph Loeb III 40	Whoopi Goldberg 274	Bobcat Goldwait 37
236	236	Burglar 43	1987 32	Green Valley Restaurant (510 Green Street Near Grant)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Hugh Wilson 41	Joseph Loeb III 40	Whoopi Goldberg 274	Bobcat Goldwait 37
237	237	Burglar 43	1987 32	1400 18th Street		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Hugh Wilson 41	Joseph Loeb III 40	Whoopi Goldberg 274	Bobcat Goldwait 37
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
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
513	513	Final Analysis 95	1992 22	Westin St. Francis Hotel (335 Powell Street, Union Square)	The hotel was originally supposed to be named the Crocker Hotel, after Charles Founder the railroad magnate who founded it. However, the hotel took the name the St. Francis after one of the earliest Gold Rush hotels.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Phil Joanou 86	Robert Berger 87	Richard Gere 264	Kim Basinger 75
514	514	Final Analysis 95	1992 22	Public Health Service Hospital (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.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Phil Joanou 86	Robert Berger 87	Richard Gere 264	Kim Basinger 75
515	515	Final Analysis 95	1992 22	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.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Phil Joanou 86	Robert Berger 87	Richard Gere 264	Kim Basinger 75
516	516	Final Analysis 95	1992 22	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	Phil Joanou 86	Robert Berger 87	Richard Gere 264	Kim Basinger 75
517	517	Final Analysis 95	1992 22	Bix Restaurant (56 Gold Street)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Phil Joanou 86	Robert Berger 87	Richard Gere 264	Kim Basinger 75
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
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
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
1244	1244	Sudden Impact 231	1983 65	Near Point Lobos, El Camino Del Mar		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Clint Eastwood 113	Harry Julian Fink 71	Clint Eastwood 295	Sondra Locke 176
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
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
1271	1271	Sweet November 235	2001 33	Marquee Lofts (1000 Van Ness Avenue at Alice B. Toklas Place)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1272	1272	Sweet November 235	2001 33	Hotel Majestic (1500 Sutter Street)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1273	1273	Sweet November 235	2001 33	Foote, Cone & Belding (733 Front Street at Pacific)	The building is called "Jabe & Dunne Advertising Agency" in the movie.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1274	1274	Sweet November 235	2001 33	Farley's Café (1315 18th Street Near Missouri)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1275	1275	Sweet November 235	2001 33	Citicorp Center (1 Sansome Street at Sutter)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1276	1276	Sweet November 235	2001 33	Christopher's Books (1400 18th Street)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1277	1277	Sweet November 235	2001 33	Chrissy Field	Chrissy Field was originally an airfield for the Presidio Army Base.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1278	1278	Sweet November 235	2001 33	Blooms Saloon (18th Street between Missouri and Texas Streets)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1279	1279	Sweet November 235	2001 33	Mission Dolores Park (Mission District)	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.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
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
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
1401	1401	The Enforcer 255	1976 45	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.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	James Fargo 210	Stirling Silliphant 222	Clint Eastwood 295	Tyne Daly 195	Harry Guardino 60
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
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
1583	1583	What's Up Doc? 301	1972 62	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.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Peter Bogdanovich 245	Peter Bogdanovich & Buck Henry 261	Barbra Streisand 434	Ryan O'Neal 233
1584	1584	What's Up Doc? 301	1972 62	San Francisco Hilton (333 O'Farrell Street)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Peter Bogdanovich 245	Peter Bogdanovich & Buck Henry 261	Barbra Streisand 434	Ryan O'Neal 233
1585	1585	What's Up Doc? 301	1972 62	Lombard Street between Hyde and Leavenworth		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Peter Bogdanovich 245	Peter Bogdanovich & Buck Henry 261	Barbra Streisand 434	Ryan O'Neal 233
1586	1586	What's Up Doc? 301	1972 62	Hyde Street Pier		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Peter Bogdanovich 245	Peter Bogdanovich & Buck Henry 261	Barbra Streisand 434	Ryan O'Neal 233
1587	1587	What's Up Doc? 301	1972 62	Chinatown	First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Peter Bogdanovich 245	Peter Bogdanovich & Buck Henry 261	Barbra Streisand 434	Ryan O'Neal 233
1588	1588	What's Up Doc? 301	1972 62	Alta Plaza Park (Steiner Street)	The park was originally a rock quarry and served as a campground for many survivors of the 1906 earthquake. The site was converted to a park in 1910.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Peter Bogdanovich 245	Peter Bogdanovich & Buck Henry 261	Barbra Streisand 434	Ryan O'Neal 233
1589	1589	What's Up Doc? 301	1972 62	22nd Avenue & Balboa Street (Richmond District)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Peter Bogdanovich 245	Peter Bogdanovich & Buck Henry 261	Barbra Streisand 434	Ryan O'Neal 233
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
380	380	Copycat 68	1995 39	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.	Regency Enterprises 52	Warner Bros. Pictures 6	Jon Amiel 62	Ann Biderman 61	Sigourney Weaver 285	Holly Hunter 50
381	381	Copycat 68	1995 39	Twin Peaks	The 2nd highest point in SF after Mt. Davidson, Twin Peaks sit at the geographic center of SF. The native Ohlone people called the area “Los Pechos de la Chola” or "Breasts of the Indian Maiden," but in the 19th Century when America took over the area, it was renamed "Twin Peaks".	Regency Enterprises 52	Warner Bros. Pictures 6	Jon Amiel 62	Ann Biderman 61	Sigourney Weaver 285	Holly Hunter 50
382	382	Copycat 68	1995 39	Sound Factory (1st and Harrison Streets)		Regency Enterprises 52	Warner Bros. Pictures 6	Jon Amiel 62	Ann Biderman 61	Sigourney Weaver 285	Holly Hunter 50
383	383	Copycat 68	1995 39	Java House (Pier 40, Embarcadero)		Regency Enterprises 52	Warner Bros. Pictures 6	Jon Amiel 62	Ann Biderman 61	Sigourney Weaver 285	Holly Hunter 50
384	384	Copycat 68	1995 39	Alta Plaza Park	The park was originally a rock quarry and served as a campground for many survivors of the 1906 earthquake. The site was converted to a park in 1910.	Regency Enterprises 52	Warner Bros. Pictures 6	Jon Amiel 62	Ann Biderman 61	Sigourney Weaver 285	Holly Hunter 50
385	385	Copycat 68	1995 39	82 & 67 Rico Way (Marina District)		Regency Enterprises 52	Warner Bros. Pictures 6	Jon Amiel 62	Ann Biderman 61	Sigourney Weaver 285	Holly Hunter 50
1542	1542	Tin Cup 290	1996 43			Regency Enterprises 52	Warner Bros. Pictures 6	Ron Shelton 237	John Norville 250	Kevin Costner 426	Rene Russo 225
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

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