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
201	201	41	36	39	38	272	35	458	1167 Alabama Street
202	202	41	36	39	38	272	35	458	1641 York Street
203	203	41	36	39	38	272	35	458	Bernal Heights Boulevard
204	204	41	36	39	38	272	35	458	40 Prentiss Street
205	205	41	36	39	38	272	35	458	500 Cortland Avenue
206	206	41	36	39	38	272	35	458	Lucky Street
207	207	41	36	39	38	272	35	458	1125 Guerrero Street
208	208	41	36	39	38	272	35	458	Gough Street & Clay Street
209	209	41	36	39	38	272	35	458	2007 Franklin Street
210	210	41	36	39	38	272	35	458	951 Hudson Avenue
211	211	42	37	40	39	273	36	459	Bayshore Blvd near Cesar Chavez (Bayview)
212	212	42	37	40	39	273	36	459	Taylor & Vallejo Streets (Russian Hill)
213	213	43	38	41	40	274	37		1627 Haight Street
214	214	42	37	40	39	273	36	459	SF General Hospital Center (1001 Potrero Avenue, Potrero Hill)	SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County.
215	215	42	37	40	39	273	36	459	McLaren Park (Visitacion Valley)	McLaren Park is the 2nd largest park in San Francisco, after Golden Gate Park.
216	216	42	37	40	39	273	36	459	Mark Hopkins Hotel (999 California Street)	The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite.
217	217	42	37	40	39	273	36	459	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.
218	218	42	37	40	39	273	36	459	Mansell & University Streets (Visitacion Valley)
219	219	42	37	40	39	273	36	459	Larkin & Francisco Streets (Russian Hill)
220	220	42	37	40	39	273	36	459	Larkin & Chestnut Streets (Russian Hill)
221	221	42	37	40	39	273	36	459	Kennedy Hotel (226 Embarcadero at Howard Street)	Hotel was destroyed in the 1989 Loma Prieta earthquake. Corporate headquarters for the Gap reside at the location today.
222	222	42	37	40	39	273	36	459	John Muir Drive (Lake Merced)
223	223	42	37	40	39	273	36	459	Intersection of York & Peralta (Bernal Heights)
224	224	42	37	40	39	273	36	459	Filbert & Taylor Streets (Russian Hill)
225	225	42	37	40	39	273	36	459	Enrico's Café (504 Broadway)
226	226	42	37	40	39	273	36	459	Columbus & Lombard Streets (North Beach)
227	227	42	37	40	39	273	36	459	Cesar Chavez & Mission Street (Mission)
228	228	42	37	40	39	273	36	459	Candlestick Park Exit, Highway 101
229	229	42	37	40	39	273	36	459	Café Cantata (2040 Union Street)
230	230	42	37	40	39	273	36	459	Brocklebank Apartments (1000 Mason Street)
231	231	42	37	40	39	273	36	459	Bay Bridge	Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII.
232	232	42	37	40	39	273	36	459	2700 Vallejo Street (Pacific Heights)
233	233	42	37	40	39	273	36	459	20th & Vermont Streets (Potrero Hill)	The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St.
234	234	42	37	40	39	273	36	459	1153-57 Taylor Street	Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake)
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)
241	241	45	40	43	42	276	38	460	101 Henry Adams Place
242	242	46	41	44	43	277	39	461	3639 Taraval St
243	243	46	41	44	43	277	39	461	1458 33rd Ave.
244	244	46	41	44	43	277	39	461	Lyon at Chestnut St.
245	245	46	41	44	43	277	39	461	1559 Underwood Avenue between Lane and Keith
246	246	46	41	44	43	277	39	461	1465 Revere Avenue between Keith and Jennings
247	247	46	41	44	43	277	39	461	1601 Lane St.
248	248	46	41	44	43	277	39	461	420 Mason St.
249	249	46	41	44	43	277	39	461	119 Utah
250	250	46	41	44	43	277	39	461	100 Alemany Blvd.
251	251	46	41	44	43	277	39	461	812 22nd St. and Tennessee
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.
253	253	48	42	46	45	279	41	462	Li Po (916 Grant Avenue at Washington, Chinatown)
254	254	48	42	46	45	279	41	462	Golden Dragon Restaurant (816 Washington Street at Grant)
255	255	49	43	47	46	280	42	463	Maiden Lane between Kearny and Grant
256	256	49	43	47	46	280	42	463	The Drew School, 2901 California
257	257	49	43	47	46	280	42	463	State Garage, 818 Leavenworth
258	258	49	43	47	46	280	42	463	60 Leavenworth St.
259	259	50	43	48	47	280	42	463	Harvey Milk Rec Center, 50 Scott St.
260	260	50	43	48	47	280	42	463	66 Potomac
261	261	50	43	48	47	280	42	463	Mario's Café, 566 Columbus
262	262	50	43	48	47	280	42	463	Washington Square Park
263	263	50	43	48	47	280	42	463	William Stout Architectural Books, 804 Montgomery St.
264	264	50	43	48	47	280	42	463	1055 Montgomery St.
265	265	50	43	48	47	280	42	463	60 Leavenworth St.
266	266	50	43	48	47	280	42	463	Jefferson Square Park
267	267	50	43	48	47	280	42	463	UN Plaza/ Civic Center Bart steps
268	268	50	43	48	47	280	42	463	940 Powell St.
269	269	50	43	48	47	280	42	463	Ellis and Jones St.
270	270	50	43	48	47	280	42	463	Ellis Food Center, 398 Ellis
271	271	50	43	48	47	280	42	463	Jonell's Bar, 401 Ellis
272	272	50	43	48	47	280	42	463	State Garage, 818 Leavenworth
273	273	50	43	48	47	280	42	463	Antonio Alley
274	274	50	43	48	47	280	42	463	253 4th Ave.
275	275	50	43	48	47	280	42	463	Warren's Antiques, 375 9th St.
276	276	51	43	47	46	280	42	463	Private alley along 20th St. between Tennessee and Minnesota
277	277	52	43	48	48	280	42	463	Mason and Pacific
278	278	52	43	48	48	280	42	463	John St. between Powell and Mason
279	279	52	43	48	48	280	42	463	Westin St. Francis
280	280	52	43	48	48	280	42	463	Betelnut restaurant, 2030 Union St.
281	281	52	43	48	48	280	42	463	Sutter Stockton Garage, 444 Stockton
282	282	52	43	48	48	280	42	463	YWCA, 940 Powell
283	283	52	43	48	48	280	42	463	Warren's Antiques, 375 9th St.
284	284	52	43	48	48	280	42	463	Heron and Berwick Alleys
285	285	52	43	48	48	280	42	463	Duboce St., Duboce Café
286	286	52	43	48	48	280	42	463	Potomac and Waller
287	287	52	43	48	48	280	42	463	State Garage, 818 Leavenworth
288	288	53	43	3	49	280	42	463	60 Leavenworth St.
289	289	53	43	3	49	280	42	463	Blue Danube Café, 306 Clement
290	290	53	43	3	49	280	42	463	San Francisco Art Institute, 800 Chestnut
291	291	53	43	3	49	280	42	463	Laguna Honda Hospital
292	292	53	43	3	49	280	42	463	350 Santa Ana Ave.
293	293	53	43	3	49	280	42	463	878-898 Chestnut St.
294	294	53	43	3	49	280	42	463	Forrest Hill Muni Station	A Muni station agent played himself in this scene.
295	295	53	43	3	49	280	42	463	60 Potomac
296	296	53	43	3	49	280	42	463	The Drew School, 2901 California
297	297	53	43	3	49	280	42	463	San Bruno and Alameda
298	298	53	43	3	49	280	42	463	17th and Arkansas
299	299	54	43	49	50	280	42	463	Bush and Sansome St.
300	300	54	43	49	50	280	42	463	Bayview Police Station, 201 Williams Ave.

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