sf-film-locations

This data as json, CSV

rowid	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
201	41	20	1167 Alabama Street		36	29	39	38	272	35	458
202	41	20	1641 York Street		36	29	39	38	272	35	458
203	41	20	Bernal Heights Boulevard		36	29	39	38	272	35	458
204	41	20	40 Prentiss Street		36	29	39	38	272	35	458
205	41	20	500 Cortland Avenue		36	29	39	38	272	35	458
206	41	20	Lucky Street		36	29	39	38	272	35	458
207	41	20	1125 Guerrero Street		36	29	39	38	272	35	458
208	41	20	Gough Street & Clay Street		36	29	39	38	272	35	458
209	41	20	2007 Franklin Street		36	29	39	38	272	35	458
210	41	20	951 Hudson Avenue		36	29	39	38	272	35	458
211	42	31	Bayshore Blvd near Cesar Chavez (Bayview)		37	30	40	39	273	36	459
212	42	31	Taylor & Vallejo Streets (Russian Hill)		37	30	40	39	273	36	459
213	43	32	1627 Haight Street		38	6	41	40	274	37
214	42	31	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.	37	30	40	39	273	36	459
215	42	31	McLaren Park (Visitacion Valley)	McLaren Park is the 2nd largest park in San Francisco, after Golden Gate Park.	37	30	40	39	273	36	459
216	42	31	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.	37	30	40	39	273	36	459
217	42	31	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.	37	30	40	39	273	36	459
218	42	31	Mansell & University Streets (Visitacion Valley)		37	30	40	39	273	36	459
219	42	31	Larkin & Francisco Streets (Russian Hill)		37	30	40	39	273	36	459
220	42	31	Larkin & Chestnut Streets (Russian Hill)		37	30	40	39	273	36	459
221	42	31	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.	37	30	40	39	273	36	459
222	42	31	John Muir Drive (Lake Merced)		37	30	40	39	273	36	459
223	42	31	Intersection of York & Peralta (Bernal Heights)		37	30	40	39	273	36	459
224	42	31	Filbert & Taylor Streets (Russian Hill)		37	30	40	39	273	36	459
225	42	31	Enrico's Café (504 Broadway)		37	30	40	39	273	36	459
226	42	31	Columbus & Lombard Streets (North Beach)		37	30	40	39	273	36	459
227	42	31	Cesar Chavez & Mission Street (Mission)		37	30	40	39	273	36	459
228	42	31	Candlestick Park Exit, Highway 101		37	30	40	39	273	36	459
229	42	31	Café Cantata (2040 Union Street)		37	30	40	39	273	36	459
230	42	31	Brocklebank Apartments (1000 Mason Street)		37	30	40	39	273	36	459
231	42	31	Bay Bridge	Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII.	37	30	40	39	273	36	459
232	42	31	2700 Vallejo Street (Pacific Heights)		37	30	40	39	273	36	459
233	42	31	20th & Vermont Streets (Potrero Hill)	The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St.	37	30	40	39	273	36	459
234	42	31	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)	37	30	40	39	273	36	459
235	43	32	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.	38	6	41	40	274	37
236	43	32	Green Valley Restaurant (510 Green Street Near Grant)		38	6	41	40	274	37
237	43	32	1400 18th Street		38	6	41	40	274	37
238	44	33	The Lexington Club (3464 19th Street at Lexington)		39	31	42	41	275
239	44	33	Royan Hotel (405 Valencia Street, Mission District)		39	31	42	41	275
240	44	33	Department of Public Health (101 Grove Street at Polk, Civic Center)		39	31	42	41	275
241	45	34	101 Henry Adams Place		40	32	43	42	276	38	460
242	46	10	3639 Taraval St		41		44	43	277	39	461
243	46	10	1458 33rd Ave.		41		44	43	277	39	461
244	46	10	Lyon at Chestnut St.		41		44	43	277	39	461
245	46	10	1559 Underwood Avenue between Lane and Keith		41		44	43	277	39	461
246	46	10	1465 Revere Avenue between Keith and Jennings		41		44	43	277	39	461
247	46	10	1601 Lane St.		41		44	43	277	39	461
248	46	10	420 Mason St.		41		44	43	277	39	461
249	46	10	119 Utah		41		44	43	277	39	461
250	46	10	100 Alemany Blvd.		41		44	43	277	39	461
251	46	10	812 22nd St. and Tennessee		41		44	43	277	39	461
252	47	35	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.	5	4	45	44	278	40
253	48	4	Li Po (916 Grant Avenue at Washington, Chinatown)		42	33	46	45	279	41	462
254	48	4	Golden Dragon Restaurant (816 Washington Street at Grant)		42	33	46	45	279	41	462
255	49	30	Maiden Lane between Kearny and Grant		43	34	47	46	280	42	463
256	49	30	The Drew School, 2901 California		43	34	47	46	280	42	463
257	49	30	State Garage, 818 Leavenworth		43	34	47	46	280	42	463
258	49	30	60 Leavenworth St.		43	34	47	46	280	42	463
259	50	30	Harvey Milk Rec Center, 50 Scott St.		43	34	48	47	280	42	463
260	50	30	66 Potomac		43	34	48	47	280	42	463
261	50	30	Mario's Café, 566 Columbus		43	34	48	47	280	42	463
262	50	30	Washington Square Park		43	34	48	47	280	42	463
263	50	30	William Stout Architectural Books, 804 Montgomery St.		43	34	48	47	280	42	463
264	50	30	1055 Montgomery St.		43	34	48	47	280	42	463
265	50	30	60 Leavenworth St.		43	34	48	47	280	42	463
266	50	30	Jefferson Square Park		43	34	48	47	280	42	463
267	50	30	UN Plaza/ Civic Center Bart steps		43	34	48	47	280	42	463
268	50	30	940 Powell St.		43	34	48	47	280	42	463
269	50	30	Ellis and Jones St.		43	34	48	47	280	42	463
270	50	30	Ellis Food Center, 398 Ellis		43	34	48	47	280	42	463
271	50	30	Jonell's Bar, 401 Ellis		43	34	48	47	280	42	463
272	50	30	State Garage, 818 Leavenworth		43	34	48	47	280	42	463
273	50	30	Antonio Alley		43	34	48	47	280	42	463
274	50	30	253 4th Ave.		43	34	48	47	280	42	463
275	50	30	Warren's Antiques, 375 9th St.		43	34	48	47	280	42	463
276	51	30	Private alley along 20th St. between Tennessee and Minnesota		43	34	47	46	280	42	463
277	52	30	Mason and Pacific		43	34	48	48	280	42	463
278	52	30	John St. between Powell and Mason		43	34	48	48	280	42	463
279	52	30	Westin St. Francis		43	34	48	48	280	42	463
280	52	30	Betelnut restaurant, 2030 Union St.		43	34	48	48	280	42	463
281	52	30	Sutter Stockton Garage, 444 Stockton		43	34	48	48	280	42	463
282	52	30	YWCA, 940 Powell		43	34	48	48	280	42	463
283	52	30	Warren's Antiques, 375 9th St.		43	34	48	48	280	42	463
284	52	30	Heron and Berwick Alleys		43	34	48	48	280	42	463
285	52	30	Duboce St., Duboce Café		43	34	48	48	280	42	463
286	52	30	Potomac and Waller		43	34	48	48	280	42	463
287	52	30	State Garage, 818 Leavenworth		43	34	48	48	280	42	463
288	53	30	60 Leavenworth St.		43	34	3	49	280	42	463
289	53	30	Blue Danube Café, 306 Clement		43	34	3	49	280	42	463
290	53	30	San Francisco Art Institute, 800 Chestnut		43	34	3	49	280	42	463
291	53	30	Laguna Honda Hospital		43	34	3	49	280	42	463
292	53	30	350 Santa Ana Ave.		43	34	3	49	280	42	463
293	53	30	878-898 Chestnut St.		43	34	3	49	280	42	463
294	53	30	Forrest Hill Muni Station	A Muni station agent played himself in this scene.	43	34	3	49	280	42	463
295	53	30	60 Potomac		43	34	3	49	280	42	463
296	53	30	The Drew School, 2901 California		43	34	3	49	280	42	463
297	53	30	San Bruno and Alameda		43	34	3	49	280	42	463
298	53	30	17th and Arkansas		43	34	3	49	280	42	463
299	54	30	Bush and Sansome St.		43	34	49	50	280	42	463
300	54	30	Bayview Police Station, 201 Williams Ave.		43	34	49	50	280	42	463
301	54	30	Miraloma Mall at Portola Frontage Road		43	34	49	50	280	42	463

sf-film-locations

Custom SQL query returning 101 rows (hide)

Query parameters