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
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
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
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
302 54 30 1018 Tennessee St.   43 34 49 50 280 42 463
303 54 30 901/909Tennessee St.   43 34 49 50 280 42 463
304 54 30 11 San Jacinto Ave.   43 34 49 50 280 42 463
306 54 30 Agua Vista Park at Mission Rock, 817 Terry A Francois Blvd.   43 34 49 50 280 42 463
307 54 30 200 Kansas St.   43 34 49 50 280 42 463
308 54 30 15th St. between Vermont and Kansas   43 34 49 50 280 42 463
309 55 30 Washington Square Park   43 34 50 51 280 42 463
310 55 30 Grant between Union and Green   43 34 50 51 280 42 463
311 55 30 60 Leavenworth St.   43 34 50 51 280 42 463
312 55 30 Montgomery between Pacific and Broadway   43 34 50 51 280 42 463
314 55 30 2 Rowland   43 34 50 51 280 42 463
315 55 30 McAllister between Leavenworth and Hyde   43 34 50 51 280 42 463
316 56 30 Punjab Café, 838 24th St.   43 34 51 52 280 42 463
317 56 30 60 Potomac   43 34 51 52 280 42 463
318 56 30 Buena Vista betweeen Upper Terrace and Java St.   43 34 51 52 280 42 463
319 56 30 157 Commonwealth   43 34 51 52 280 42 463
320 56 30 1461 Page St.   43 34 51 52 280 42 463
321 56 30 1958 Valencia St.   43 34 51 52 280 42 463
322 56 30 145 Barlett St.   43 34 51 52 280 42 463
323 57 30 Huntington Park   43 34 52 53 280 42 463
326 57 30 1000 Mason St.   43 34 52 53 280 42 463
327 57 30 St. Mary's Square Park   43 34 52 53 280 42 463
328 59 30 Terry A. Francois Blvd.   43 34 54 51 280 42 463
329 59 30 2 Rowland   43 34 54 51 280 42 463
330 59 30 Ocean Park Motel   43 34 54 51 280 42 463
331 59 30 Cliffhouse, 1090 Point Lobos Ave.   43 34 54 51 280 42 463
333 59 30 60 Leavenworth St.   43 34 54 51 280 42 463
334 60 30 San Francisco General Hospital   43 34 51 52 280 42 463
335 60 30 1901 Ocean Ave. at Ashton Ave.   43 34 51 52 280 42 463
336 60 30 1 Urbano   43 34 51 52 280 42 463
337 60 30 18 Urbano   43 34 51 52 280 42 463
338 60 30 Ocean Park Motel   43 34 51 52 280 42 463
339 60 30 Cliffhouse, 1090 Point Lobos Ave.   43 34 51 52 280 42 463
404 74 30 2930 3rd Street   56 43 68 67 291 56 467
452 74 30 Hayes Street between Ashbury and Shrader   56 43 68 67 291 56 467
779 149 30 1080 Natoma Street   101 18 136 137 339 123 496
780 149 30 1246 Folsom Street   101 18 136 137 339 123 496
782 149 30 Encore Karaoke, 1550 California Street   101 18 136 137 339 123 496
783 149 30 San Francisco City Hall   101 18 136 137 339 123 496
784 149 30 The Stud, 399 9th Street   101 18 136 137 339 123 496
786 149 30 10th Street between Market & Mission   101 18 136 137 339 123 496
787 149 30 Philz Coffee, 1258 Minnesota Street   101 18 136 137 339 123 496
788 149 30 Grant Avenue between Sacramento and Washington   101 18 136 137 339 123 496
789 149 30 The End Up, 401 6th Streeet   101 18 136 137 339 123 496
790 149 30 Orphan Andy's, 3991 17th Street   101 18 136 137 339 123 496
791 149 30 Castro Street between 17th & 18th   101 18 136 137 339 123 496
Powered by Datasette · Query took 1.502ms · Data source: data.sfgov.org