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
101	101	27	24	25	24	245	23	449	Tosca Café (242 Columbus Avenue)
102	102	27	24	25	24	245	23	449	Steinhart Aquarium (California Academy of Sciences, Golden Gate Park)	The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species.
103	103	27	24	25	24	245	23	449	Raw Hide II (280 Seventh Street)
104	104	27	24	25	24	245	23	449	Pier 7 (The Embarcadero)
105	105	27	24	25	24	245	23	449	Kearney Street (Telegraph Hill)
106	106	28	25	26	25	260	24	450	Nobles Alley
107	107	27	24	25	24	245	23	449	Hall of Justice (850 Bryant Street)
108	108	27	24	25	24	245	23	449	2930 Vallejo Street
109	109	27	24	25	24	245	23	449	Chinatown	First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US.
110	110	27	24	25	24	245	23	449	Gibb Street (Chinatown)
111	111	27	24	25	24	245	23	449	1158-70 Montgomery Street
112	112	27	24	25	24	245	23	449	2104 Broadway
113	113	29	26	27	26	261	25	451
114	114	30	27	28	27	262	26	452	Divisadero between Broadway and Greenwich
115	115	30	27	28	27	262	26	452	Ohloff Recovery Center (601 Steiner St)
116	116	30	27	28	27	262	26	452	Haight at Masonic
117	117	30	27	28	27	262	26	452	Tenderloin Neighborhood
118	118	30	27	28	27	262	26	452	Olympic Flame Café, 555 Geary St
119	119	30	27	28	27	262	26	452	18th St at San Bruno Ave.
120	120	30	27	28	27	262	26	452	Wisconsin between 19th and 20th St
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.
132	132	28	25	26	25	260	24	450	Caffe Trieste
133	133	28	25	26	25	260	24	450	Palace of Fine Arts
134	134	28	25	26	25	260	24	450	1101 Filbert St.
135	135	28	25	26	25	260	24	450	Saints Peter & Paul Church
136	136	28	25	26	25	260	24	450	Green St. & Grant Ave.
137	137	28	25	26	25	260	24	450	Filbert St. & Leavenworth
138	138	28	25	26	25	260	24	450	Pine St. & Grant
139	139	28	25	26	25	260	24	450	Way Faire Inn on Leidesdorff
140	140	28	25	26	25	260	24	450	Harry's Bar on Fillmore
141	141	34	30	32	31	266	29	453	Tosca Café (242 Columbus Avenue, North Beach)
142	142	35	13	33	32	267	30	454
143	143	36	31	34	33	268	31	455	Alcatraz Island	Alcatraz Island was a military fort before it became a prison.
144	144	36	31	34	33	268	31	455	Pier 43 1/2
145	145	37	32	35	34	269	32	456	Lands End Trail at Eagles Point/ Lincoln Park Golf Course	The character of Steve McKee was based on actor Steve McQueen who studied with Bruce Lee in the later 60's.
146	146	37	32	35	34	269	32	456	Pier 45 - Jeremiah O'Brien Liberty Ship	The SS Jeremiah O'Brien is a rare survivor of the invasion at Normandy on D-Day in WWII.
147	147	37	32	35	34	269	32	456	Leavenworth at Green
148	148	37	32	35	34	269	32	456	Leavenworth at Union
149	149	37	32	35	34	269	32	456	Hyde at Union
150	150	37	32	35	34	269	32	456	California at Grant
151	151	37	32	35	34	269	32	456	Grant between Bush and Broadway
152	152	37	32	35	34	269	32	456	California at Mason
153	153	37	32	35	34	269	32	456	Spofford between Clay and Washington
154	154	37	32	35	34	269	32	456	Twin Peaks Blvd.
155	155	37	32	35	34	269	32	456	Waverly Pl between Washington and Sacramento
156	156	38	33	36	35	270	33	457	Jones & Pacific
157	157	38	33	36	35	270	33	457	Pacific & Divisadero
158	158	38	33	36	35	270	33	457	Lombard & Hyde
159	159	38	33	36	35	270	33	457	5546 Geary Ave
160	160	38	33	36	35	270	33	457	2898 Broadway
161	161	38	33	36	35	270	33	457	Motel Capri
162	162	38	33	36	35	270	33	457	Marina Green
163	163	38	33	36	35	270	33	457	Ocean Beach at Lincoln
164	164	38	33	36	35	270	33	457	Heald College
165	165	38	33	36	35	270	33	457	Marina Blvd from Laguna to Baker
166	166	38	33	36	35	270	33	457	330 Santa Clara Ave.
167	167	38	33	36	35	270	33	457	200 Post St.
168	168	38	33	36	35	270	33	457	2179 48th Ave
169	169	38	33	36	35	270	33	457	The Ramp Restaurant
170	170	38	33	36	35	270	33	457	303-305 S. Van Ness
171	171	38	33	36	35	270	33	457	3563 20th St.
172	172	38	33	36	35	270	33	457	Taylor & Green St.
173	173	38	33	36	35	270	33	457	Grant & Washington St.
174	174	38	33	36	35	270	33	457	2934 24th St.
175	175	38	33	36	35	270	33	457	1138 Alabama St
176	176	38	33	36	35	270	33	457	South Park
177	177	38	33	36	35	270	33	457	2915 16th St.
178	178	38	33	36	35	270	33	457	Trolley Car from Market and 11th
179	179	38	33	36	35	270	33	457	Real Guitars
180	180	38	33	36	35	270	33	457	Aub Zam Zam Bar
181	181	38	33	36	35	270	33	457	790 Ulloa
182	182	38	33	36	35	270	33	457	SFO International Airport Terminal 3
183	183	38	33	36	35	270	33	457	2178 Palou Ave.
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
198	198	41	36	39	38	272	35	458	3050 24th Street
199	199	41	36	39	38	272	35	458	3033 24th Street
200	200	41	36	39	38	272	35	458	2937 24th Street

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