Film_Locations_in_San_Francisco_fts

1,622 rows

Search:

descending

Link	rowid ▼	Title	Production Company	Director	Writer	Actor 1	Actor 2	Actor 3	Locations	Fun Facts
1	1	1	1	1	1	237	1	439	Epic Roasthouse (399 Embarcadero)
2	2	1	1	1	1	237	1	439	Mason & California Streets (Nob Hill)
3	3	1	1	1	1	237	1	439	Justin Herman Plaza
4	4	1	1	1	1	237	1	439	200 block Market Street
5	5	1	1	1	1	237	1	439	City Hall
6	6	1	1	1	1	237	1	439	Polk & Larkin Streets
7	7	1	1	1	1	237	1	439	Randall Museum
8	8	1	1	1	1	237	1	439	555 Market St.
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.
12	12	4	4	4	3	19	3	440
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.
24	24	10	8	9	8	244	8	441	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.
25	25	10	8	9	8	244	8	441	Port of San Francisco
26	26	11	9	10	9	245	9		420 Jones St. at Ellis St.
27	27	10	8	9	8	244	8	441	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.
28	28	10	8	9	8	244	8	441	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.
29	29	10	8	9	8	244	8	441	Embarcadero Freeway	Embarcadero Freeway, which was featured in the film, was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake)
30	30	10	8	9	8	244	8	441	Potrero Hill	The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St.
31	31	10	8	9	8	244	8	441	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.
32	32	10	8	9	8	244	8	441	Chinatown	First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US.
33	33	10	8	9	8	244	8	441	Burger Island (901 3rd Street, China Basin)
34	34	10	8	9	8	244	8	441	Van Ness Avenue
35	35	10	8	9	8	244	8	441	Taylor and Jefferson Streets (Fisherman's Wharf)
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
39	39	13	8	12	11	247	11	432	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.
40	40	14	11	13	12	248	12	442	Pier 50- end of the pier
41	41	14	11	13	12	248	12	442	California @ Montgomery
42	42	14	11	13	12	248	12	442	Montgomery/Green
43	43	14	11	13	12	248	12	442	Driving various SF Streets
44	44	14	11	13	12	248	12	442	Plate Shots SF streets various
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
52	52	16	13	15	14	250	14	443	Cliff House (1090 Point Lobos Avenue)	In 1887, the Cliff House was severely damaged when the schooner Parallel, abandoned and loaded with dynamite, ran aground on the rocks below.
53	53	16	13	15	14	250	14	443	San Francisco Bay
54	54	16	13	15	14	250	14	443	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.
55	55	17	14	16	15	251	15	444	Curran Theater (445 Geary Street)	Called the Shubert Theatre in the film.
56	56	18	15	17	16	252	16	445	Mel's Drive-In (Corner of Van Ness & Mission Street, Mission District)	This restaurant location was demolished; however another Mel's was reopened in 1986 on 3355 Geary Blvd.
57	57	18	15	17	16	252	16	445	3355 Geary Blvd.
58	58	19	16	18	17	253	17
59	59	20	17	19	18	254	18	446	St. Francis Episcopal Church (399 San Fernando Way)
60	60	20	17	19	18	254	18	446	Romolo Place @ Fresno St.
61	61	20	17	19	18	254	18	446	Palace of Fine Arts
62	62	20	17	19	18	254	18	446	John Shelley Drive John McLaren Park
63	63	20	17	19	18	254	18	446	Treasure Island
64	64	20	17	19	18	254	18	446	The San Francisco School (300 Gavin St.)
65	65	20	17	19	18	254	18	446	33 Spruce St
66	66	20	17	19	18	254	18	446	Coi Restaurant (373 Broadway)
67	67	20	17	19	18	254	18	446	Foreign Cinema (2534 Mission)
68	68	20	17	19	18	254	18	446	Bernal Heights Park
69	69	20	17	19	18	254	18	446	Jackson St. at Spruce
70	70	20	17	19	18	254	18	446	679 Madrid St
71	71	20	17	19	18	254	18	446	Roxie Theater (3117 16th St.)
72	72	20	17	19	18	254	18	446	Variety Preview Room (582 Market St.)
73	73	20	17	19	18	254	18	446	Laguna Honda Hospital; 375 Laguna Honda Blvd.
74	74	20	17	19	18	254	18	446	3232 Jackson Ave.
75	75	20	17	19	18	254	18	446	20th St and Illinois/Faxon St. and Kenwood/Glenbrook at Mt. Springs
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
91	91	25	22	23	22	258	21	447	Fairmont Hotel (950 Mason Street, Nob Hill)
92	92	25	22	23	22	258	21	447	Embarcadero around Rincon Park
93	93	25	22	23	22	258	21	447	San Remo Hotel (2237 Mason)
94	94	25	22	23	22	258	21	447	Huntington Park (California & Taylor Streets, Nob Hill)
95	95	25	22	23	22	258	21	447	Driving around Taylor/Pacific/Leavenworth
96	96	25	22	23	22	258	21	447	California and Jones St.
97	97	25	22	23	22	258	21	447	Another Café, 1191 Pine St at Leavenworth
98	98	26	23	24	23	259	22	448
99	99	27	24	25	24	245	23	449	Yerba Buena Center for the Arts
100	100	27	24	25	24	245	23	449	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.

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