sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
144 36 29 Pier 43 1/2   31 19 34 33 268 31 455
147 37 30 Leavenworth at Green   32 26 35 34 269 32 456
148 37 30 Leavenworth at Union   32 26 35 34 269 32 456
149 37 30 Hyde at Union   32 26 35 34 269 32 456
150 37 30 California at Grant   32 26 35 34 269 32 456
151 37 30 Grant between Bush and Broadway   32 26 35 34 269 32 456
152 37 30 California at Mason   32 26 35 34 269 32 456
153 37 30 Spofford between Clay and Washington   32 26 35 34 269 32 456
154 37 30 Twin Peaks Blvd.   32 26 35 34 269 32 456
155 37 30 Waverly Pl between Washington and Sacramento   32 26 35 34 269 32 456
156 38 27 Jones & Pacific   33 27 36 35 270 33 457
157 38 27 Pacific & Divisadero   33 27 36 35 270 33 457
158 38 27 Lombard & Hyde   33 27 36 35 270 33 457
159 38 27 5546 Geary Ave   33 27 36 35 270 33 457
160 38 27 2898 Broadway   33 27 36 35 270 33 457
161 38 27 Motel Capri   33 27 36 35 270 33 457
162 38 27 Marina Green   33 27 36 35 270 33 457
163 38 27 Ocean Beach at Lincoln   33 27 36 35 270 33 457
164 38 27 Heald College   33 27 36 35 270 33 457
165 38 27 Marina Blvd from Laguna to Baker   33 27 36 35 270 33 457
166 38 27 330 Santa Clara Ave.   33 27 36 35 270 33 457
167 38 27 200 Post St.   33 27 36 35 270 33 457
168 38 27 2179 48th Ave   33 27 36 35 270 33 457
169 38 27 The Ramp Restaurant   33 27 36 35 270 33 457
170 38 27 303-305 S. Van Ness   33 27 36 35 270 33 457
171 38 27 3563 20th St.   33 27 36 35 270 33 457
172 38 27 Taylor & Green St.   33 27 36 35 270 33 457
173 38 27 Grant & Washington St.   33 27 36 35 270 33 457
174 38 27 2934 24th St.   33 27 36 35 270 33 457
175 38 27 1138 Alabama St   33 27 36 35 270 33 457
176 38 27 South Park   33 27 36 35 270 33 457
177 38 27 2915 16th St.   33 27 36 35 270 33 457
178 38 27 Trolley Car from Market and 11th   33 27 36 35 270 33 457
179 38 27 Real Guitars   33 27 36 35 270 33 457
180 38 27 Aub Zam Zam Bar   33 27 36 35 270 33 457
181 38 27 790 Ulloa   33 27 36 35 270 33 457
182 38 27 SFO International Airport Terminal 3   33 27 36 35 270 33 457
183 38 27 2178 Palou Ave.   33 27 36 35 270 33 457
184 39 25 1122 Folsom Street   34 28 37 36 271 34  
195 39 25 628 Cole Street   34 28 37 36 271 34  
196 40 19 Ina Coolbrith Park (1700 Taylor Street)   35   38 37      
197 40 19 0-100 block Halleck Street   35   38 37      
198 41 20 3050 24th Street   36 29 39 38 272 35 458
199 41 20 3033 24th Street   36 29 39 38 272 35 458
200 41 20 2937 24th Street   36 29 39 38 272 35 458
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  
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
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
232 42 31 2700 Vallejo Street (Pacific Heights)   37 30 40 39 273 36 459
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
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
Powered by Datasette · Query took 3.009ms · Data source: data.sfgov.org