sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
12 4 4     4 3 4 3 19 3 440
20 8 8 75 California Street   4 3 8 7 243 7  
22 9 8 Hills Brothers Plaza (Embarcadero at Harrison Street)   4 3 8 7 243 7  
76 21 17     18 3 4 3 3 19  
523 99 7 Sutter & Buchannan Streets   4 3 90 91 306 79 477
524 99 7 Sutter & Baker Streets   4 3 90 91 306 79 477
525 99 7 Sokoji-Soto Zen Buddhist Temple (1691 Laguna Street)   4 3 90 91 306 79 477
526 99 7 Sacramento & Hyde Streets (Nob Hill)   4 3 90 91 306 79 477
528 99 7 Potrero Hill Bathhouse & Feed Co. (199 Mississippi Street)   4 3 90 91 306 79 477
529 99 7 Octavia & Hayes Streets (Hayes Valley)   4 3 90 91 306 79 477
530 99 7 Montgomery & Pine Streets (Financial District)   4 3 90 91 306 79 477
531 99 7 Laguna & Sacramento Streets (Pacific Heights)   4 3 90 91 306 79 477
532 99 7 Hayes Valley Care (601 Laguna Street, Hayes Valley)   4 3 90 91 306 79 477
533 99 7 Golden Gate & Steiner Streets (Hayes Valley)   4 3 90 91 306 79 477
536 99 7 Flood Building (870 Market Street)   4 3 90 91 306 79 477
537 99 7 Fiesta Laundromat (898 S. Van Ness Ave., Mission)   4 3 90 91 306 79 477
539 99 7 California & Larkin Streets (Nob Hill)   4 3 90 91 306 79 477
541 99 7 Andrew S. Hallidie Plaza (Market & Powell Streets)   4 3 90 91 306 79 477
542 99 7 430 Vallejo Street (Telegraph Hill)   4 3 90 91 306 79 477
543 99 7 24th and Castro Streets (Noe Valley)   4 3 90 91 306 79 477
631 115 42 Sutro Baths (Point Lobos Avenue)   79 3 107 91 318 92  
632 115 42 Golden Gate Park   79 3 107 91 318 92  
660 126 39 Lombard & Hyde Streets   4 3 117 24 223 102 487
685 126 39 Hall of Justice (850 Bryant Street)   4 3 117 24 223 102 487
707 126 39 Fior d' Italia (601 Union Street at Stockton)   4 3 117 24 223 102 487
1023 191 62 Balboa at 22nd Avenue   4 3 160 35 360 147 507
1025 191 62 Surf Theater (4520 Irving Street)   4 3 160 35 360 147 507
1026 191 62 Hyde Street Cable Car   4 3 160 35 360 147 507
1028 191 62 15-17 Fresno Street   4 3 160 35 360 147 507
1133 209 5 Pier 24   4 3 111 181 324 160  
1213 224 4 Golden Gate Park   4 3 186 195 383 171 518
1214 225 28 West Harbor, Marina District   4 3 187 196 383 171 518
1215 225 28 North Beach   4 3 187 196 383 171 518
1217 225 28 Kearny & Pacific Streets   4 3 187 196 383 171 518
1218 225 28 Intersection of Grant & Fresno Streets (North Beach)   4 3 187 196 383 171 518
1219 225 28 Intersection of Columbus & Mason Streets   4 3 187 196 383 171 518
1220 225 28 Intersection of Columbus & Kearney Streets   4 3 187 196 383 171 518
1221 225 28 Golden Gate Park   4 3 187 196 383 171 518
1223 225 28 Bessie Charmichael Elementary School (375 Seventh Street, SOMA)   4 3 187 196 383 171 518
1224 225 28 500 Block of Pacific Avenue (Chinatown)   4 3 187 196 383 171 518
1287 239 10 Van Ness between Fell and Lombard   145 3 196 208 334 183  
1288 239 10 California between Leavenworth and Powell   145 3 196 208 334 183  
1289 239 10 Mission at 1st and 2nd   145 3 196 208 334 183  
1290 239 10 Market at Mason   145 3 196 208 334 183  
1291 239 10 California at Larkin   145 3 196 208 334 183  
1292 239 10 California at Jones   145 3 196 208 334 183  
1293 239 10 Pine and Leavenworth   145 3 196 208 334 183  
1294 239 10 Howard St. from Embarcadero to 11 St.   145 3 196 208 334 183  
1295 239 10 Construction Site in front of 260 Stockton St. at Post St.   145 3 196 208 334 183  
1296 239 10 California St. between Drumm St. and Kearny St.   145 3 196 208 334 183  
1297 239 10 Market St. at Embarcadero area   145 3 196 208 334 183  
1298 239 10 Pine St. between Market and Kearny   145 3 196 208 334 183  
1299 239 10 Front St. between Market and Clay   145 3 196 208 334 183  
1300 239 10 Union Square   145 3 196 208 334 183  
1301 239 10 San Francisco - Oakland Bay Bridge   145 3 196 208 334 183  
1302 239 10 Mission St., Embarcadero, and Front between Clay and Market   145 3 196 208 334 183  
1303 239 10 Sutter Stockton Garage   145 3 196 208 334 183  
1304 239 10 Bush St. at Stockton St.   145 3 196 208 334 183  
1305 239 10 Powell St at Geary St   145 3 196 208 334 183  
1306 239 10 1 Market St. Landmark Building   145 3 196 208 334 183  
1307 239 10 Embarcadero between Pier 2 and Harrison   145 3 196 208 334 183  
1308 239 10 Pier 14   145 3 196 208 334 183  
1309 239 10 Pine St. between Market and Montgomery   145 3 196 208 334 183  
1334 249 49 American Roofing Co. Building (297 Kansas Street, Potrero Hill)   92 3 127 216 178 191 530
1337 249 49 Alamo Square (Hayes Valley)   92 3 127 216 178 191 530
1340 249 49 Saks Fifth Avenue (384 Post Street, Union Square)   92 3 127 216 178 191 530
1341 249 49 One Embarcadero Center (Financial District)   92 3 127 216 178 191 530
1343 249 49 Financial District   92 3 127 216 178 191 530
1344 249 49 Cathedral Hill Hotel (1101 Van Ness Avenue, Civic Center)   92 3 127 216 178 191 530
1456 275 23 Washington Street & Waverly Place (Chinatown)   4 3 226 238 107 211 46
1457 275 23 Sansome Street (The Embarcadero)   4 3 226 238 107 211 46
1459 275 23 Montgomery & Vallejo Streets (Telegraph Hill)   4 3 226 238 107 211 46
1460 275 23 Market & 2nd Streets   4 3 226 238 107 211 46
1461 275 23 Hayes & Polk Streets (Civic Center)   4 3 226 238 107 211 46
1466 275 23 Civic Center Plaza   4 3 226 238 107 211 46
1467 275 23 Battery Street (The Embarcadero)   4 3 226 238 107 211 46
1468 275 23 900 Block of Grant Avenue (Chinatown)   4 3 226 238 107 211 46
1469 275 23 700 Block of Jackson Street (Chinatown)   4 3 226 238 107 211 46
1470 275 23 200 Block of Sansome Street (Financial District)   4 3 226 238 107 211 46
1517 288 40     4 3 236 248 424 223 545
1547 209 5 Red's Java House (Pier 30-32, The Embarcadero)   4 3 111 181 324 160  
1548 209 5 Piers 30-32   4 3 111 181 324 160  
1549 209 5 Pier 39   4 3 111 181 324 160  
1550 209 5 Mojito (1337-1339 Grant Avenue)   4 3 111 181 324 160  
1551 209 5 McCovey Point, China Basin Park (24 Willy Mays Plaza)   4 3 111 181 324 160  
1552 209 5 Veterans' War Memorial Building (401 Van Ness Avenue)   4 3 111 181 324 160  
1553 209 5     4 3 111 181 324 160  
1554 209 5 La Bodega (1332 Grant Avenue at Vallejo)   4 3 111 181 324 160  
1556 209 5 The Saloon (1232 Grant Avenue)   4 3 111 181 324 160  
1566 298 72 York Hotel (940 Sutter Street)   174 3 81 258 432 231 106
1567 298 72 San Francisco Drydock (20th and Illinois Streets)   174 3 81 258 432 231 106
1569 298 72 Mission San Juan Bautista (2nd & Mariposa Streets)   174 3 81 258 432 231 106
1571 298 72 Gough & Eddy Streets (Western Addition)   174 3 81 258 432 231 106
1576 298 72 Claude Lane at Bush Street   174 3 81 258 432 231 106
1578 298 72 Brocklebank Apartments (1000 Mason Street)   174 3 81 258 432 231 106
1622 307 75 SF Chronicle Building (901 Mission St)   4 3 213 266 438 118  
1336 249 49 Alcoa Building (1 Maritime Plaza) A partially-above ground parking structure near the building made it necessary for architects to make the Alcoa Building's diagonal bracing visible, instead of placing it inside and drastically reducing the amount usable interior space. 92 3 127 216 178 191 530
459 87 44 Alcatraz Island Alcatraz Island was a military fort before it became a prison. 4 3 79 80 295 68 471
676 131 35 Administration Building (Treasure Island) An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. 4 3 122 121 12 107  
1216 225 28 Marina Green, Marina District Before the 1906 earthquake, the land on which Marina Green sits was a tidal marsh, and rubble from the earthquake was dumped on the site. However, the site was filled in to provide land for the 1915 Panama-Pacific Exhibition. 4 3 187 196 383 171 518
534 99 7 Fort Point, Presidio Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF. 4 3 90 91 306 79 477
Powered by Datasette · Query took 1.881ms · Data source: data.sfgov.org