Film_Locations_in_San_Francisco_fts

Data source: data.sfgov.org

1,622 rows sorted by Locations

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid Title Production Company Director Writer Actor 1 Actor 2 Actor 3 Locations ▼ Fun Facts
841 841 156 101 136 137 339 123 496 1246 Folsom Street  
846 846 157 101 136 137 339 123 496 1246 Folsom Street  
930 930 171 108 146 150 103 131 502 13 Lucky Street  
1181 1181 220 135 182 191 380 168 517 1328 Portola  
575 575 104 72 96 96 309 84 480 1375 Haight St.  
566 566 103 71 95 95 308 83   140 Maiden Lane  
805 805 150 101 136 137 339 123 496 1400 16th Street  
951 951 172 108 146 150 103 131 502 1400 16th Street  
237 237 43 38 41 40 274 37   1400 18th Street  
322 322 56 43 51 52 280 42 463 145 Barlett St.  
243 243 46 41 44 43 277 39 461 1458 33rd Ave.  
320 320 56 43 51 52 280 42 463 1461 Page St.  
1211 1211 222 136 184 193 382 170   1462 Grant Avenue, at Union Street  
246 246 46 41 44 43 277 39 461 1465 Revere Avenue between Keith and Jennings  
1028 1028 191 4 160 35 360 147 507 15-17 Fresno Street  
1597 1597 302 104 246 262 58 46   1521 Masonic Avenue at Piedmont Street  
1054 1054 198 124 165 171 366 153 512 1536 Noe St.  
931 931 171 108 146 150 103 131 502 1541 Grove Street  
245 245 46 41 44 43 277 39 461 1559 Underwood Avenue between Lane and Keith  
319 319 56 43 51 52 280 42 463 157 Commonwealth  
308 308 54 43 49 50 280 42 463 15th St. between Vermont and Kansas  
831 831 153 101 136 137 339 123 496 160 Church Street  
247 247 46 41 44 43 277 39 461 1601 Lane St.  
213 213 43 38 41 40 274 37   1627 Haight Street  
202 202 41 36 39 38 272 35 458 1641 York Street  
1119 1119 208 131 172 180 374     16th St. Driving shots
1286 1286 239 145 196 208 334 183   16th and Utah Helicopter flies over Utah St. from 16th, rises up before freeway
792 792 149 101 136 137 339 123 496 17th & Market Street  
298 298 53 43 3 49 280 42 463 17th and Arkansas  
337 337 60 43 51 52 280 42 463 18 Urbano  
721 721 140 95 46 129 332 115 493 180 Manchester Street  
1618 1618 304 177 247 263 350 235 202 1801 Laguna at Bush  
912 912 171 108 146 150 103 131 502 1821 Alabama Street  
767 767 148 101 136 137 339 122 496 1890 Clay St.  
816 816 152 101 136 137 339 123 496 1890 Clay Street  
834 834 154 101 136 137 339 123 496 1890 Clay Street  
849 849 157 101 136 137 339 123 496 1890 Clay Street  
119 119 30 27 28 27 262 26 452 18th St at San Bruno Ave.  
879 879 160 59 138 139 295 124 497 18th Street Overpass (Potrero Hill)  
1114 1114 208 131 172 180 374     18th Street between Guerrero and Valencia Streets Re-enactment of "Dyke's on Bikes" and "Dyke March"
456 456 86 64 78 79 220 67   19 Green Street (North Beach)  
335 335 60 43 51 52 280 42 463 1901 Ocean Ave. at Ashton Ave.  
1373 1373 242 38 199 71 295 186 527 1954 Mason Street (North Beach)  
321 321 56 43 51 52 280 42 463 1958 Valencia St.  
864 864 159 102 137 138 340     198 Gough Street  
1238 1238 228 8 189 199 385 173   19th and Kansas St.  
314 314 55 43 50 51 280 42 463 2 Rowland  
329 329 59 43 54 51 280 42 463 2 Rowland  
863 863 159 102 137 138 340     20 Hill Street  
1470 1470 275 4 226 238 107 211 46 200 Block of Sansome Street (Financial District)  
307 307 54 43 49 50 280 42 463 200 Kansas St.  
167 167 38 33 36 35 270 33 457 200 Post St.  
4 4 1 1 1 1 237 1 439 200 block Market Street  
768 768 148 101 136 137 339 122 496 2000 Folsom  
209 209 41 36 39 38 272 35 458 2007 Franklin Street  
997 997 182 114 151 157 352 139   2017 23rd Street  
1440 1440 265 158 71 222 409 202 539 2090 Jackson Street  
1123 1123 208 131 172 180 374     20th Driving shots
455 455 86 64 78 79 220 67   20th & Connecticut Streets (Potrero Hill)  
1372 1372 242 38 199 71 295 186 527 20th & De Haro Streets (Potrero Hill)  
233 233 42 37 40 39 273 36 459 20th & Vermont Streets (Potrero Hill) The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St.
1266 1266 232 141 191 202 388 177 523 20th St and Church (3885 20th St)  
75 75 20 17 19 18 254 18 446 20th St and Illinois/Faxon St. and Kenwood/Glenbrook at Mt. Springs  
352 352 61 45 55 55 280 43 463 20th St between Church and Dolores St  
14 14 6 6 6 5 241 5   20th and Folsom Streets  
435 435 79 60 72 72 3 61   2100 Green Street  
1195 1195 220 135 182 191 380 168 517 2100 Pacific Ave at Laguna St  
112 112 27 24 25 24 245 23 449 2104 Broadway  
434 434 79 60 72 72 3 61   2107 Union Street  
183 183 38 33 36 35 270 33 457 2178 Palou Ave.  
168 168 38 33 36 35 270 33 457 2179 48th Ave  
878 878 160 59 138 139 295 124 497 2190 Washington Street (Pacific Heights)  
1056 1056 198 124 165 171 366 153 512 21st St & Sanchez  
1235 1235 227 138 188 198 384 172 519 21st and Collingswood St.  
1237 1237 227 138 188 198 384 172 519 21st and Sanchez St  
737 737 148 101 136 137 339 122 496 222 Mason St.  
499 499 90 15 81 83 302 70 474 2230 Sacramento Street Called "1001 Franklin" in the film.
487 487 88 65 80 81 300 69 472 225 California Street  
1371 1371 242 38 199 71 295 186 527 22nd & Wisconsin Streets (Potrero Hill)  
1589 1589 301 38 245 261 434 233   22nd Avenue & Balboa Street (Richmond District)  
1370 1370 242 38 199 71 295 186 527 22nd Bet. Carolina & Rhode Island Streets (Potrero Hill)  
1121 1121 208 131 172 180 374     22nd St. Driving shots
373 373 63 47 57 57 282 45   22nd and Carolina Streets (Potrero Hill)  
1533 1533 289 166 186 249 425 224 546 2340 Francisco Street  
1400 1400 255 38 210 222 295 195 60 23rd & Capp Streets (Mission District)  
1369 1369 242 38 199 71 295 186 527 23rd & Iowa Streets (Dogpatch)  
1055 1055 198 124 165 171 366 153 512 24 Hill St.  
770 770 148 101 136 137 339 122 496 2413 Harrison St.  
1020 1020 189 120 158 163 358 145 506 2417 Franklin Street  
840 840 156 101 136 137 339 123 496 2450 Harrison Street  
828 828 153 101 136 137 339 123 496 24th Between Portrero & Alabama  
1604 1604 303 176 142 145 435 234 550 24th St. between Florida and Alabama  
1399 1399 255 38 210 222 295 195 60 24th Street Mini Park (Mission District)  
929 929 171 108 146 150 103 131 502 24th Street between Folsom and Harrison Streets  
386 386 69 15 63 62 286 51 40 24th Street between Mission Street and Potrero Avenue  
543 543 99 4 90 91 306 79 477 24th and Castro Streets (Noe Valley)  
747 747 148 101 136 137 339 122 496 24th and Church St.  
274 274 50 43 48 47 280 42 463 253 4th Ave.  
723 723 142 67 84 131 334 117 494 2552 Hyde Street  
1477 1477 276 70 27 239 415 212   2601 Lyon Street  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIRTUAL TABLE "Film_Locations_in_San_Francisco_fts" USING FTS4 ("Title", "Production Company", "Director", "Writer", "Actor 1", "Actor 2", "Actor 3", "Locations", "Fun Facts", content="Film_Locations_in_San_Francisco");
Powered by Datasette · Query took 7.708ms · Data source: data.sfgov.org