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
9 9 2 2 2   238        
12 12 4 4 4 3 19 3 440    
58 58 19 16 18 17 253 17      
76 76 21 18 4 3 3 19      
90 90 24 21 22 21 257 20      
98 98 26 23 24 23 259 22 448    
113 113 29 26 27 26 261 25 451    
126 126 32 28 30 29 264 28      
142 142 35 13 33 32 267 30 454    
324 324 58 44 53 54 281        
379 379 67 51 61   284 49      
409 409 75 38 69 68 292 57 468    
410 410 76 57 70 69 293 58 469    
438 438 81 14 74 74 297 7      
448 448 85 63 77 78 150 66      
501 501 91 66 82 84 303 71      
503 503 93 67 84 79 265 73      
627 627 112 77 104 104 316 91      
628 628 113 78 105 105 240        
640 640 118 13 110 109 14 94 485    
659 659 125 84 116 116 104 101      
705 705 137 92 127 127 265 112      
715 715 139 94 129 128 252 114      
722 722 141 96 130 130 333 116      
730 730 143 84 131 132 335 118      
902 902 168 107 144 147 150 129      
975 975 176 111 149 153 346 133      
976 976 177 112 132 133 347 134      
994 994 181 113 103 156 351 138 362    
1005 1005 185 116 154 160 355 142      
1034 1034 195 104 27 168 264 150      
1035 1035 196 123 91 169 364 151 510    
1070 1070 199 125 45 172 367        
1084 1084 203 48 168 176 370 156      
1157 1157 211 3 174 183 72 161      
1161 1161 215 133 177 187 377 164      
1239 1239 229 139 190 200 386 174 520    
1330 1330 246 149 202 213 396        
1359 1359 251 152 206 218 398        
1391 1391 253 26 208 220 400 194      
1392 1392 254 154 209 221 401 46      
1403 1403 257 155 212   403        
1433 1433 264 13 219 230 408 70 538    
1450 1450 271 104 129 234 412 208      
1451 1451 272 160 224 235 90 209      
1515 1515 286 167 234 247 423 44      
1516 1516 287 168 235 39 90 222 209    
1517 1517 288 4 236 248 424 223 545    
1542 1542 290 52 237 250 426 225      
1543 1543 291 169 112 251 427 226 547    
1544 1544 292 5 238 252 428 227      
1546 1546 294 171 239 254 429        
1553 1553 209 4 111 181 324 160      
1621 1621 306 179 249 265 437 236 551    
1137 1137 208 131 172 180 374     "Metzger's Apt" 151 Alice B. Toklas Pl. Overnight scene involving aggressive arguments between actors, spfx shoot out involved
197 197 40 35 38 37       0-100 block Halleck Street  
1417 1417 258 156 213 224 245 40 532 1 Bush Street  
1306 1306 239 145 196 208 334 183   1 Market St. Landmark Building  
496 496 89 5 69 82 301 57 473 1 Montgomery Street at Post  
701 701 135 90 125 125       1 Post Street  
336 336 60 43 51 52 280 42 463 1 Urbano  
250 250 46 41 44 43 277 39 461 100 Alemany Blvd.  
1442 1442 266 82 112 111 410 203 540 100 Block of Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd.
1534 1534 289 166 186 249 425 224 546 100 Block of Union Street (Cow Hollow)  
802 802 150 101 136 137 339 123 496 100 Church Street Jake Shears, lead singer of the band Scissor Sisters, auditioned for the role of Dom.
911 911 170 13 31 149 265 100 501 100 Embarcadero Street  
682 682 133 88 124 123 329 109 490 100 Market Street at 6th Street  
495 495 89 5 69 82 301 57 473 100 St. Germain Avenue  
326 326 57 43 52 53 280 42 463 1000 Mason St.  
1580 1580 298 174 81 258 432 231 106 1007 Gough Street Tennis courts now sit on the site; in the movie the structure was Carlota Valdes' home.
241 241 45 40 43 42 276 38 460 101 Henry Adams Place  
991 991 178 29 31 154 348 135 265 101 Henry Adams Place, 4th Floor  
302 302 54 43 49 50 280 42 463 1018 Tennessee St.  
264 264 50 43 48 47 280 42 463 1055 Montgomery St.  
943 943 172 108 146 150 103 131 502 1059 Texas Street  
897 897 74 56 68 67 291 56 467 1069 Tennessee Street  
779 779 149 101 136 137 339 123 496 1080 Natoma Street  
786 786 149 101 136 137 339 123 496 10th Street between Market & Mission  
304 304 54 43 49 50 280 42 463 11 San Jacinto Ave.  
134 134 28 25 26 25 260 24 450 1101 Filbert St.  
843 843 156 101 136 137 339 123 496 1111 California Street  
832 832 153 101 136 137 339 123 496 1119 Alabama Street  
184 184 39 34 37 36 271 34   1122 Folsom Street  
207 207 41 36 39 38 272 35 458 1125 Guerrero Street  
175 175 38 33 36 35 270 33 457 1138 Alabama St  
457 457 86 64 78 79 220 67   1138 Filbert Street  
234 234 42 37 40 39 273 36 459 1153-57 Taylor Street Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake)
121 121 31 14 29 28 263 27   1155 Filbert Street at Hyde  
111 111 27 24 25 24 245 23 449 1158-70 Montgomery Street  
647 647 121 83 113 112 322 97   1160 Taylor Street  
201 201 41 36 39 38 272 35 458 1167 Alabama Street  
249 249 46 41 44 43 277 39 461 119 Utah  
905 905 170 13 31 149 265 100 501 1200 Washington Street at Taylor Street  
925 925 171 108 146 150 103 131 502 1201 Columbus Avenue  
473 473 88 65 80 81 300 69 472 1227 Montgomery Street  
1423 1423 260 14 215 226 405 198 534 1227 Montgomery Street  
700 700 134 89 111 124 286 110 491 1227 Montgomery Street (Telegraph Hill)  
938 938 172 108 146 150 103 131 502 1243 19th Street  
780 780 149 101 136 137 339 123 496 1246 Folsom Street  
799 799 150 101 136 137 339 123 496 1246 Folsom 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 131.366ms · Data source: data.sfgov.org