sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 29 rows (hide)

Query parameters

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
99 27 22 Yerba Buena Center for the Arts   24 20 25 24 245 23 449
100 27 22 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. 24 20 25 24 245 23 449
101 27 22 Tosca Café (242 Columbus Avenue)   24 20 25 24 245 23 449
102 27 22 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. 24 20 25 24 245 23 449
103 27 22 Raw Hide II (280 Seventh Street)   24 20 25 24 245 23 449
104 27 22 Pier 7 (The Embarcadero)   24 20 25 24 245 23 449
105 27 22 Kearney Street (Telegraph Hill)   24 20 25 24 245 23 449
107 27 22 Hall of Justice (850 Bryant Street)   24 20 25 24 245 23 449
108 27 22 2930 Vallejo Street   24 20 25 24 245 23 449
109 27 22 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 24 20 25 24 245 23 449
110 27 22 Gibb Street (Chinatown)   24 20 25 24 245 23 449
111 27 22 1158-70 Montgomery Street   24 20 25 24 245 23 449
112 27 22 2104 Broadway   24 20 25 24 245 23 449
410 76 18     57 20 70 69 293 58 469
1198 222 46 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. 136 20 184 193 382 170  
1199 222 46 Swedenborgian Church (2107 Lyon Street)   136 20 184 193 382 170  
1200 222 46 St. John's Presbyterian Church (25 Lake Street)   136 20 184 193 382 170  
1201 222 46 San Francisco Chronicle (901 Mission Street at 15th Street) The paper is called the San Francisco Globe in the movie. 136 20 184 193 382 170  
1202 222 46 Rocco's Corner (Columbus Street)   136 20 184 193 382 170  
1203 222 46 Prudente's Italian Deli (1462 Grant Ave at Union) Prudente's Italian Deli, which has since closed, is called "Meats of the World" in the film. 136 20 184 193 382 170  
1204 222 46 Fog City Diner (1300 Battery Street)   136 20 184 193 382 170  
1205 222 46 Edinburgh Castle (950 Geary Street)   136 20 184 193 382 170  
1206 222 46 City Light Bookstore (261 Columbus Avenue)   136 20 184 193 382 170  
1207 222 46 Café Picaro 3120 16th Street   136 20 184 193 382 170  
1208 222 46 Alcatraz Island Alcatraz Island was a military fort before it became a prison. 136 20 184 193 382 170  
1209 222 46 Aladdin Terrace (off of Taylor Street, Between Filbert and Union)   136 20 184 193 382 170  
1210 222 46 305 Hugo Street   136 20 184 193 382 170  
1211 222 46 1462 Grant Avenue, at Union Street   136 20 184 193 382 170  
1392 254 37     154 20 209 221 401 46  
Powered by Datasette · Query took 1.407ms · Data source: data.sfgov.org