sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
1 1 1 Epic Roasthouse (399 Embarcadero)   1   1 1 237 1 439
2 1 1 Mason & California Streets (Nob Hill)   1   1 1 237 1 439
3 1 1 Justin Herman Plaza   1   1 1 237 1 439
4 1 1 200 block Market Street   1   1 1 237 1 439
5 1 1 City Hall   1   1 1 237 1 439
6 1 1 Polk & Larkin Streets   1   1 1 237 1 439
7 1 1 Randall Museum   1   1 1 237 1 439
8 1 1 555 Market St.   1   1 1 237 1 439
40 14 10 Pier 50- end of the pier   11   13 12 248 12 442
41 14 10 California @ Montgomery   11   13 12 248 12 442
42 14 10 Montgomery/Green   11   13 12 248 12 442
43 14 10 Driving various SF Streets   11   13 12 248 12 442
44 14 10 Plate Shots SF streets various   11   13 12 248 12 442
58 19 5     16   18 17 253 17  
59 20 10 St. Francis Episcopal Church (399 San Fernando Way)   17   19 18 254 18 446
60 20 10 Romolo Place @ Fresno St.   17   19 18 254 18 446
61 20 10 Palace of Fine Arts   17   19 18 254 18 446
62 20 10 John Shelley Drive John McLaren Park   17   19 18 254 18 446
63 20 10 Treasure Island   17   19 18 254 18 446
64 20 10 The San Francisco School (300 Gavin St.)   17   19 18 254 18 446
65 20 10 33 Spruce St   17   19 18 254 18 446
66 20 10 Coi Restaurant (373 Broadway)   17   19 18 254 18 446
67 20 10 Foreign Cinema (2534 Mission)   17   19 18 254 18 446
68 20 10 Bernal Heights Park   17   19 18 254 18 446
69 20 10 Jackson St. at Spruce   17   19 18 254 18 446
70 20 10 679 Madrid St   17   19 18 254 18 446
71 20 10 Roxie Theater (3117 16th St.)   17   19 18 254 18 446
72 20 10 Variety Preview Room (582 Market St.)   17   19 18 254 18 446
73 20 10 Laguna Honda Hospital; 375 Laguna Honda Blvd.   17   19 18 254 18 446
74 20 10 3232 Jackson Ave.   17   19 18 254 18 446
75 20 10 20th St and Illinois/Faxon St. and Kenwood/Glenbrook at Mt. Springs   17   19 18 254 18 446
141 34 27 Tosca Café (242 Columbus Avenue, North Beach)   30   32 31 266 29 453
196 40 19 Ina Coolbrith Park (1700 Taylor Street)   35   38 37      
197 40 19 0-100 block Halleck Street   35   38 37      
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
594 105 19 Sacramento & Washington Streets   73   97 97 310    
666 129 10 Flint & 16th (Castro)   85   120 119 327 105 488
667 129 10 Grove & Polk, thru Fulton & 6th, Masonic, 28th & 47th   85   120 119 327 105 488
668 129 10 Ocean Beach @ Balboa   85   120 119 327 105 488
669 129 10 4100 20th St   85   120 119 327 105 488
670 129 10 Harvey Milk Plaza   85   120 119 327 105 488
671 129 10 F Train   85   120 119 327 105 488
672 129 10 Sanchez/Cumberland steps and sidewalks   85   120 119 327 105 488
701 135 1 1 Post Street   90   125 125      
862 159 11 The Marsh Theatre (1062 Valencia Street)   102   137 138 340    
863 159 11 20 Hill Street   102   137 138 340    
864 159 11 198 Gough Street   102   137 138 340    
900 167 33 The 500 Club (500 Guerrero Street, Mission District)       143 146 342    
901 167 33 Mission Dolores Park (Mission District) 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.     143 146 342    
974 175 33 Postcard Row (Alamo Square, Hayes Valley) The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. 110   148 152 345    
1054 198 10 1536 Noe St.   124   165 171 366 153 512
1055 198 10 24 Hill St.   124   165 171 366 153 512
1056 198 10 21st St & Sanchez   124   165 171 366 153 512
1057 198 10 4015 21st St   124   165 171 366 153 512
1058 198 10 Tank Hill Park   124   165 171 366 153 512
1059 198 10 Clement St. from 6th to 7th Ave.   124   165 171 366 153 512
1060 198 10 Wine Impression   124   165 171 366 153 512
1061 198 10 Clement St. from 5th and 7th Ave.   124   165 171 366 153 512
1062 198 10 Claire Lilienthal Elementary School   124   165 171 366 153 512
1063 198 10 Yerba Buena Gardens   124   165 171 366 153 512
1064 198 10 Tonga Room   124   165 171 366 153 512
1065 198 10 Cal-Mart Supermarket   124   165 171 366 153 512
1066 198 10 McLaren Lodge   124   165 171 366 153 512
1067 198 10 Bechelli's Flower Market Café   124   165 171 366 153 512
1068 198 10 923 Vermont St.   124   165 171 366 153 512
1069 198 10 Geary from 22nd Ave to Arguello   124   165 171 366 153 512
1113 207 25 The Castro From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry. 130   171   373 159  
1171 220 10 Manor West (750 Harrison St.)   135   182 191 380 168 517
1172 220 10 475 Diamond St.   135   182 191 380 168 517
1173 220 10 Hyatt Hotel (555 North Point St.)   135   182 191 380 168 517
1174 220 10 Fairmont Hotel (950 Mason Street, Nob Hill)   135   182 191 380 168 517
1175 220 10 411 Shrader St.   135   182 191 380 168 517
1176 220 10 883 42nd Ave.   135   182 191 380 168 517
1177 220 10 Mason & Sacramento St   135   182 191 380 168 517
1178 220 10 Unitarian Church (1187 Franklin St.)   135   182 191 380 168 517
1179 220 10 Huntington Park (California & Taylor Streets, Nob Hill)   135   182 191 380 168 517
1180 220 10 E Tutto Qua Restaurant (270 Columbus St.)   135   182 191 380 168 517
1181 220 10 1328 Portola   135   182 191 380 168 517
1182 220 10 Clay St. at Sansome   135   182 191 380 168 517
1183 220 10 Montgomery Street at Post Street   135   182 191 380 168 517
1184 220 10 333 Pacheco St at Lopez Ave.   135   182 191 380 168 517
1185 220 10 Mission Inn (5630 Mission St)   135   182 191 380 168 517
1186 220 10 87 Cervantes Blvd (beach)   135   182 191 380 168 517
1187 220 10 Gaspare's Pizza House (5546 Geary Blvd.)   135   182 191 380 168 517
1188 220 10 510 Noe Street & 18th St.   135   182 191 380 168 517
1189 220 10 Europa Café (4318 California St. and 5th Ave.)   135   182 191 380 168 517
1190 220 10 New Taraval Café (1054 Taraval St.)   135   182 191 380 168 517
1191 220 10 Kansas St at 17th St.   135   182 191 380 168 517
1192 220 10 City Hall   135   182 191 380 168 517
1193 220 10 Ocean Beach Motel (2690 46th Ave.)   135   182 191 380 168 517
1194 220 10 Greenwich St at Battery St   135   182 191 380 168 517
1195 220 10 2100 Pacific Ave at Laguna St   135   182 191 380 168 517
Powered by Datasette · Query took 1.643ms · Data source: data.sfgov.org