Film_Locations_in_San_Francisco_fts

1,622 rows sorted by Actor 3

Search:

descending

Link	rowid	Title	Production Company	Director	Writer	Actor 1	Actor 2	Locations	Fun Facts
9	9	2	2	2		238
10	10	3	3	3	2	239	2	The Walden House, Buena Vista Park	Established in 1867, Buena Vista Park is the oldest official park in San Francisco.
11	11	3	3	3	2	239	2	Café Trieste (609 Vallejo)	Francis Ford Coppola allegedly wrote large portions of "The Godfather" trilogy in Café Trieste.
13	13	5	5	5	4	240	4	Rainforest Café (145 Jefferson Street)
14	14	6	6	6	5	241	5	20th and Folsom Streets
15	15	6	6	6	5	241	5	Golden Gate Park	During San Francisco's Gold Rush era, the Park was part of an area designated as the "Great Sand Waste".
16	16	7	7	7	6	242	6	Embarcadero Freeway	Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake)
17	17	7	7	7	6	242	6	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.
18	18	7	7	7	6	242	6	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.
19	19	7	7	7	6	242	6	Broadway (North Beach)
20	20	8	4	8	7	243	7	75 California Street
21	21	9	4	8	7	243	7	Grace Cathedral Episcopal Church (1100 California Street)	Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral.
22	22	9	4	8	7	243	7	Hills Brothers Plaza (Embarcadero at Harrison Street)
23	23	9	4	8	7	243	7	San Francisco International Airport	SFO has a museum dedicated to aviation history.
26	26	11	9	10	9	245	9	420 Jones St. at Ellis St.
36	36	12	10	11	10	246	10	Broderick from Fulton to McAlister
37	37	12	10	11	10	246	10	Crissy Field
38	38	12	10	11	10	246	10	Powell from Bush and Sutter
45	45	15	12	14	13	249	13	Filbert St. from Jones to Mason
46	46	15	12	14	13	249	13	Leavenworth from Filbert & Francisco St
47	47	15	12	14	13	249	13	Chestnut St. from Larkin to Columbus
48	48	15	12	14	13	249	13	Francisco St from Larkin to Polk
49	49	15	12	14	13	249	13	Broadway from Mason to Taylor
50	50	15	12	14	13	249	13	Taylor St. from Broadway to Filbert
51	51	11	9	10	9	245	9	Broadway between Powell and Davis	Driving shots
58	58	19	16	18	17	253	17
76	76	21	18	4	3	3	19
77	77	11	9	10	9	245	9	Conzelman Rd at McCollough Rd and down Conzelman Rd.	Aerial shots
78	78	11	9	10	9	245	9	Lombard at Hyde
79	79	11	9	10	9	245	9	601 Buena Vista Ave West at Java St.
80	80	11	9	10	9	245	9	Columbus between Bay and Washington	Driving shots
81	81	11	9	10	9	245	9	California between Kearney and Davis	Driving shots
82	82	11	9	10	9	245	9	Pine between Kearney and Davis	Driving shots
83	83	11	9	10	9	245	9	Market between Stuart and Van Ness	Driving shots
84	84	11	9	10	9	245	9	Grant between Bush and Broadway	Driving shots
85	85	11	9	10	9	245	9	Intersection of Broadway at Kearney	Driving shots
86	86	11	9	10	9	245	9	Intersection of California at Polk	Driving shots
87	87	11	9	10	9	245	9	Treasure Island, Building #1, Ave of the Palms	Aerial and exterior shots
88	88	22	19	20	19	255		Ocean Beach	On Jan. 25, 1878, the King Philip ship crashed in Ocean Beach. Occasionally, the ship's wreckage may be found on the beach-- most recently it was seen in 2007.
89	89	23	20	21	20	256		Hyde Street Cable Car	SF Cable Cars are the only moving National Historical Landmark.
90	90	24	21	22	21	257	20
121	121	31	14	29	28	263	27	1155 Filbert Street at Hyde
122	122	31	14	29	28	263	27	Washington Square Park (Filbert, between Stockton and Powell)
123	123	31	14	29	28	263	27	Vaillancourt Fountain (Justin Herman Plaza)	Installed in 1975, the Vaillancourt Fountain is officially titled, "Québec Libre!". The night before the sculpture's inauguration, artist Armand Vaillancourt inscribed "Québec libre!" in red letters on the sculpture. The next day when he noticed that the note had been erased, Vaillancourt jumped on the statue to re-inscribe his message.
124	124	31	14	29	28	263	27	Montgomery & Market Streets
125	125	31	14	29	28	263	27	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.
126	126	32	28	30	29	264	28
127	127	33	29	31	30	265		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.
128	128	33	29	31	30	265		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.
129	129	33	29	31	30	265		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.
130	130	33	29	31	30	265		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.
131	131	33	29	31	30	265		Grace Cathedral Episcopal Church (1100 California Street)	Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral.
184	184	39	34	37	36	271	34	1122 Folsom Street
185	185	39	34	37	36	271	34	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.
186	186	39	34	37	36	271	34	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.
187	187	39	34	37	36	271	34	Fisherman's Wharf	Supposedly, Mikhail S. Gorbachev has said that his favorite part of visiting America was touring Fisherman's Wharf.
188	188	39	34	37	36	271	34	Ferry Building	Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.
189	189	39	34	37	36	271	34	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.
190	190	39	34	37	36	271	34	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.
191	191	39	34	37	36	271	34	Lombard Street	Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd.
192	192	39	34	37	36	271	34	Chinatown	First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US.
193	193	39	34	37	36	271	34	Aquatic Park (Jefferson Street)	Located at one end of Fisherman's Wharf, Aquatic Park was built as part of FDR's Works Progress Administration Project.
194	194	39	34	37	36	271	34	Alcatraz Island	Alcatraz Island was a military fort before it became a prison.
195	195	39	34	37	36	271	34	628 Cole Street
196	196	40	35	38	37			Ina Coolbrith Park (1700 Taylor Street)
197	197	40	35	38	37			0-100 block Halleck Street
213	213	43	38	41	40	274	37	1627 Haight Street
235	235	43	38	41	40	274	37	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.
236	236	43	38	41	40	274	37	Green Valley Restaurant (510 Green Street Near Grant)
237	237	43	38	41	40	274	37	1400 18th Street
238	238	44	39	42	41	275		The Lexington Club (3464 19th Street at Lexington)
239	239	44	39	42	41	275		Royan Hotel (405 Valencia Street, Mission District)
240	240	44	39	42	41	275		Department of Public Health (101 Grove Street at Polk, Civic Center)
252	252	47	5	45	44	278	40	Mission Dolores Park (Mission District) via J-Church MUNI Train	The two land plots that comprise the Park were used as a Jewish cemetery until 1894 when San Francisco prohibited all burials within city limits. The graves were moved to Colma, CA.
324	324	58	44	53	54	281
370	370	62	46	56	56	65	44	387 Fair Oaks at 25th Street
371	371	63	47	57	57	282	45	Transbay Terminal (Mission Street at 1st Street)	Built in 1939, the Terminal linked San Francisco, the East Bay, and Sacramento by rail for the first time.
372	372	63	47	57	57	282	45	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.
373	373	63	47	57	57	282	45	22nd and Carolina Streets (Potrero Hill)
374	374	64	48	58	58	216	46	San Francisco Public Library Main Branch (100 Larkin Street)
375	375	65	49	59	59	178	47	Mission Dolores (3321 16th Street, Mission District)	Mission Dolores' official name is Mission San Francisco de Assis. It is the oldest building in San Francisco, built in 1791, and has survived two major earthquakes.
376	376	65	49	59	59	178	47	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.
377	377	65	49	59	59	178	47	Bix Restaurant (56 Gold Street)
378	378	66	50	60	60	283	48	The Castro	From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry.
379	379	67	51	61		284	49
380	380	68	52	62	61	285	50	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.
381	381	68	52	62	61	285	50	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".
382	382	68	52	62	61	285	50	Sound Factory (1st and Harrison Streets)
383	383	68	52	62	61	285	50	Java House (Pier 40, Embarcadero)
384	384	68	52	62	61	285	50	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.
385	385	68	52	62	61	285	50	82 & 67 Rico Way (Marina District)
388	388	70	53	64	63	287	52	Palace of Fine Arts
414	414	78	59	71	71	295	60	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.
415	415	78	59	71	71	295	60	Washington Square, North Beach
416	416	78	59	71	71	295	60	The Embarcadero
417	417	78	59	71	71	295	60	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.
418	418	78	59	71	71	295	60	San Francisco Drydock (20th and Illinois Streets)
419	419	78	59	71	71	295	60	Portsmouth Square (Chinatown)	In 1847 the first public school in California was erected on what would become Portsmouth Square.
420	420	78	59	71	71	295	60	Mt. Davidson Cross, Mt. Davidson	The cross sits at the highest point in San Francisco (938 feet). This version of the cross was erected in 1934.Though in Dirty Harry the cross is lit at night, the City stopped this practice in 1990.
421	421	78	59	71	71	295	60	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.

Advanced export

JSON shape: default, array, newline-delimited

CREATE VIRTUAL TABLE "Film_Locations_in_San_Francisco_fts" USING FTS4 ("Title", "Production Company", "Director", "Writer", "Actor 1", "Actor 2", "Actor 3", "Locations", "Fun Facts", content="Film_Locations_in_San_Francisco");