Film_Locations_in_San_Francisco

Data source: data.sfgov.org

150 rows where Distributor = 6 sorted by Writer 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
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
1558	1558	Until the End of the World 296	1991 37	Tosca Café (242 Columbus Avenue, North Beach)		Village Roadshow Pictures 172	Warner Bros. Pictures 6	Wim Wenders 241	Wim Wenders 256	Solveig Dommartin 430
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
1447	1447	The Matrix 269	1999 26	skyline/ exterior scenes		Silver Pictures 128	Warner Bros. Pictures 6	The Wachowski Brothers 222	The Wachowski Brothers 233	Keanu Reeves 391	Laurence Fishburne 206
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
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
1331	1331	The Candidate 247	1972 62	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.	Redford-Ritchie Productions 150	Warner Bros. Pictures 6	Michael Ritchie 203	Jeremy Larner 214	Robert Redford 169	Peter Boyle 189
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
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
1085	1085	Romeo Must Die 204	2000 25	Chinatown	First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US.	Silver Pictures 128	Warner Bros. Pictures 6	Andrzej Bartkowiak 169	Mitchell Kapner 177	Jet Li 371	Aaliyah 157
1086	1086	Romeo Must Die 204	2000 25	Embarcadero Street		Silver Pictures 128	Warner Bros. Pictures 6	Andrzej Bartkowiak 169	Mitchell Kapner 177	Jet Li 371	Aaliyah 157
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
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
677	677	Innerspace 132	1987 32	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.	Amblin Entertainment 87	Warner Bros. Pictures 6	Joe Dante 123	Chip Proser 122	Dennis Quaid 210	Martin Short 108	Meg Ryan 46
678	678	Innerspace 132	1987 32	Telegraph Hill	Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city.	Amblin Entertainment 87	Warner Bros. Pictures 6	Joe Dante 123	Chip Proser 122	Dennis Quaid 210	Martin Short 108	Meg Ryan 46
679	679	Innerspace 132	1987 32	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.	Amblin Entertainment 87	Warner Bros. Pictures 6	Joe Dante 123	Chip Proser 122	Dennis Quaid 210	Martin Short 108	Meg Ryan 46
645	645	Hereafter 121	2010 19	Hobart Building (582 Market Street)		GT Films 83	Warner Bros. Pictures 6	Clint Eastwood 113	Peter Morgan 112	Matt Damon 322	Cecile De France 97
646	646	Hereafter 121	2010 19	The Final Final (2990 Baker Street)		GT Films 83	Warner Bros. Pictures 6	Clint Eastwood 113	Peter Morgan 112	Matt Damon 322	Cecile De France 97
647	647	Hereafter 121	2010 19	1160 Taylor Street		GT Films 83	Warner Bros. Pictures 6	Clint Eastwood 113	Peter Morgan 112	Matt Damon 322	Cecile De France 97
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
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
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
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

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