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
19 7 7 Broadway (North Beach)   7 6 7 6 242 6  
213 43 32 1627 Haight Street   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  
374 64 18 San Francisco Public Library Main Branch (100 Larkin Street)   48 6 58 58 216 46  
382 68 39 Sound Factory (1st and Harrison Streets)   52 6 62 61 285 50  
383 68 39 Java House (Pier 40, Embarcadero)   52 6 62 61 285 50  
385 68 39 82 & 67 Rico Way (Marina District)   52 6 62 61 285 50  
399 72 41 The Malloch Apartment Building (1360 Montgomery Street)   38 6 66 65 289 54 465
400 72 41 Filbert Steps, Filbert Street   38 6 66 65 289 54 465
409 75 29     38 6 69 68 292 57 468
504 94 46 400 Montgomery Street   68 6 85 86 113 74 475
505 94 46 Folsom Street & Embarcadero   68 6 85 86 113 74 475
506 94 46 Varennes Alley between Filbert and Union   68 6 85 86 113 74 475
509 94 46 Kohl Building (400 Montgomery Street)   68 6 85 86 113 74 475
511 94 46 90 Gold Street   68 6 85 86 113 74 475
512 94 46 5th and Beale Streets   68 6 85 86 113 74 475
517 95 22 Bix Restaurant (56 Gold Street)   38 6 86 87 264 75  
595 106 11 Kearney & Pine St.   74 6 98 98 311 85 481
596 106 11 California & Davis St   74 6 98 98 311 85 481
597 106 11 Pine St. & Davis St   74 6 98 98 311 85 481
598 106 11 Sacramento & Front St.   74 6 98 98 311 85 481
599 106 11 Broadway & Sansome   74 6 98 98 311 85 481
600 106 11 Broadway & Columbus   74 6 98 98 311 85 481
601 106 11 Post & Jones St.   74 6 98 98 311 85 481
602 106 11 Stockton & Clay St   74 6 98 98 311 85 481
603 106 11 Bush & Kearny   74 6 98 98 311 85 481
604 106 11 Mission & Fremont St   74 6 98 98 311 85 481
605 106 11 Eddy & Taylor St.   74 6 98 98 311 85 481
606 106 11 Pier 7 (The Embarcadero)   74 6 98 98 311 85 481
607 106 11 Pier 1   74 6 98 98 311 85 481
608 106 11 Embarcadero & Washington   74 6 98 98 311 85 481
609 106 11 Mission & Beal   74 6 98 98 311 85 481
610 106 11 Potrero &San Bruno   74 6 98 98 311 85 481
645 121 19 Hobart Building (582 Market Street)   83 6 113 112 322 97  
646 121 19 The Final Final (2990 Baker Street)   83 6 113 112 322 97  
647 121 19 1160 Taylor Street   83 6 113 112 322 97  
865 160 16 Cost Plus World Market (2552 Taylor Street)   59 6 138 139 295 124 497
866 160 16 Vermont Street between 20th and 22nd Streets   59 6 138 139 295 124 497
868 160 16 San Francisco Drydock (20th and Illinois Streets)   59 6 138 139 295 124 497
869 160 16 Pacific Heights Towers (2200 Sacramento Street, Pacific Heights)   59 6 138 139 295 124 497
871 160 16 Hall of Justice (850 Bryant Street)   59 6 138 139 295 124 497
876 160 16 Broadway Tunnel (Russian Hill)   59 6 138 139 295 124 497
877 160 16 280 Freeway at Pennsylvania and Mariposa Streets   59 6 138 139 295 124 497
878 160 16 2190 Washington Street (Pacific Heights)   59 6 138 139 295 124 497
879 160 16 18th Street Overpass (Potrero Hill)   59 6 138 139 295 124 497
884 163 22 St. Elizabeth Apartment House (901 Powell Street at Sacramento)   38 6 33 142 79 126 499
993 180 41 Belgravia Apartments (795 Sutter Street at Jones)   38 6 150 155 350 137 465
1086 204 25 Embarcadero Street   128 6 169 177 371 157  
1244 231 65 Near Point Lobos, El Camino Del Mar   38 6 113 71 295 176  
1246 231 65 McDonald's Restaurant (701 3rd Street, SOMA)   38 6 113 71 295 176 522
1248 231 65 Hall of Justice (850 Bryant Street)   38 6 113 71 295 176 522
1251 231 65 Civic Center Plaza   38 6 113 71 295 176 522
1253 231 65 Bowles Franklin Galleries (765 Beach Street, Fisherman's Wharf)   38 6 113 71 295 176 522
1254 231 65 Pier 38-40, The Embarcadero   38 6 113 71 295 176 522
1270 234 47 On Board the SS President Cleveland, docked at Pier 50   38 6 66 204 390 179 525
1271 235 33 Marquee Lofts (1000 Van Ness Avenue at Alice B. Toklas Place)   38 6 193 205 391 180  
1272 235 33 Hotel Majestic (1500 Sutter Street)   38 6 193 205 391 180  
1274 235 33 Farley's Café (1315 18th Street Near Missouri)   38 6 193 205 391 180  
1275 235 33 Citicorp Center (1 Sansome Street at Sutter)   38 6 193 205 391 180  
1276 235 33 Christopher's Books (1400 18th Street)   38 6 193 205 391 180  
1278 235 33 Blooms Saloon (18th Street between Missouri and Texas Streets)   38 6 193 205 391 180  
1313 242 23 Hall of Justice (850 Bryant Street)   38 6 199 71 295 186 527
1346 242 23 San Francisco Drydock (The Dogpatch)   38 6 199 71 295 186 527
1348 242 23 One Thousand Powell Apartments (1000 Powell Street)   38 6 199 71 295 186 527
1349 242 23 The Cannery (281 Leavenworth Street, Fisherman's Wharf)   38 6 199 71 295 186 527
1350 242 23 Portsmouth Square (Chinatown)   38 6 199 71 295 186 527
1351 242 23 Pierce St. & Golden Gate Avenue (Hayes Valley)   38 6 199 71 295 186 527
1352 242 23 Pierce & California Streets (Pacific Heights)   38 6 199 71 295 186 527
1353 242 23 Pier 3 (The Embarcadero)   38 6 199 71 295 186 527
1354 242 23 New Asia Restaurant (772 Pacific Avenue at Grant)   38 6 199 71 295 186 527
1355 242 23 Nam Yuen Restaurant (740 Washington Street, Chinatown)   38 6 199 71 295 186 527
1356 242 23 Mirant Energy, LLC (1301 Illinois Street, The Dogpatch)   38 6 199 71 295 186 527
1357 242 23 McAllister & Scott Streets (Hayes Valley)   38 6 199 71 295 186 527
1358 242 23 KGO-TV ABC7 TV Studios (900 Front Street, Waterfront Historic District)   38 6 199 71 295 186 527
1360 242 23 San Francisco National Military Cemetery (Lincoln Blvd., The Presidio, Golden Gate National Recreation Center)   38 6 199 71 295 186 527
1361 242 23 Silver Restaurant (737 Washington Street, Chinatown)   38 6 199 71 295 186 527
1362 242 23 Fremont Street Exit of Bay Bridge   38 6 199 71 295 186 527
1363 242 23 Folsom & Essex Streets   38 6 199 71 295 186 527
1364 242 23 Eber Electronics (2355 Market Street, Castro)   38 6 199 71 295 186 527
1365 242 23 Clementina & Sumner Streets   38 6 199 71 295 186 527
1366 242 23 Carl & Cole Streets (Cole Valley)   38 6 199 71 295 186 527
1367 242 23 710 Steiner Street (Hayes Valley)   38 6 199 71 295 186 527
1368 242 23 550 El Camino Del Mar (Seacliff)   38 6 199 71 295 186 527
1369 242 23 23rd & Iowa Streets (Dogpatch)   38 6 199 71 295 186 527
1370 242 23 22nd Bet. Carolina & Rhode Island Streets (Potrero Hill)   38 6 199 71 295 186 527
1371 242 23 22nd & Wisconsin Streets (Potrero Hill)   38 6 199 71 295 186 527
1372 242 23 20th & De Haro Streets (Potrero Hill)   38 6 199 71 295 186 527
1373 242 23 1954 Mason Street (North Beach)   38 6 199 71 295 186 527
1393 255 45 Sutter & Webster Streets   38 6 210 222 295 195 60
1394 255 45 Hall of Justice   38 6 210 222 295 195 60
1397 255 45 Balmy Street (Mission District)   38 6 210 222 295 195 60
1399 255 45 24th Street Mini Park (Mission District)   38 6 210 222 295 195 60
1400 255 45 23rd & Capp Streets (Mission District)   38 6 210 222 295 195 60
1428 262 71 Coffee Dan's (O'Farrell Street at Powell)   38 6 217 228 407 200 536
1445 267 63 Burritt Alley (Off Bush Street, between Powell and Stockton Streets)   38 6 220 231 289 204 541
1447 269 26 skyline/ exterior scenes   128 6 222 233 391 206  
1542 290 43     52 6 237 250 426 225  
1558 296 37 Tosca Café (242 Columbus Avenue, North Beach)   172 6 241 256 430    
1584 301 62 San Francisco Hilton (333 O'Farrell Street)   38 6 245 261 434 233  
1585 301 62 Lombard Street between Hyde and Leavenworth   38 6 245 261 434 233  
Powered by Datasette · Query took 1.688ms · Data source: data.sfgov.org