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
1613 303 20 Powell St. at Market St.   176 119 142 145 435 234 550
1612 303 20 426 Castro St.   176 119 142 145 435 234 550
1611 303 20 Castro St. between 17th and 18th St.   176 119 142 145 435 234 550
1610 303 20 Eureka Arts Center, 4400 20th St.   176 119 142 145 435 234 550
1609 303 20 Haight St. at Central   176 119 142 145 435 234 550
1608 303 20 Buena Vista Park   176 119 142 145 435 234 550
1607 303 20 Women's Building, 3543 18th St. Roma Guy was one of the founders of the Women's Building 176 119 142 145 435 234 550
1606 303 20 Twin Peaks Bar, 401 Castro   176 119 142 145 435 234 550
1605 303 20 Harvey Milk Plaza, 17th and Castro   176 119 142 145 435 234 550
1604 303 20 24th St. between Florida and Alabama   176 119 142 145 435 234 550
1603 303 20 Bay Bridge   176 119 142 145 435 234 550
1602 303 20 440 Castro St.   176 119 142 145 435 234 550
1601 303 20 Castro Theatre, 429 Castro St.   176 119 142 145 435 234 550
1600 303 20 520 Castro St.   176 119 142 145 435 234 550
1599 303 20 United Nations Plaza   176 119 142 145 435 234 550
1598 303 20 City Hall Exterior scenes include re-creating the White Night Riots on May 21, 1979 and the Gay Freedom March. Interior scenes included the wedding ceremony for Roma and Diane which had a few Board of Supervisors in the ceremony. The current Clerk for the Board of Supervisors played herself in one of the scenes filmed in the Chambers. 176 119 142 145 435 234 550
1164 217 20 Howard St between 3rd and 4th St.   134 18 179 189 379 166 516
1163 217 20 Moscone Center Parking Garage/3rd St.   134 18 179 189 379 166 516
593 104 20 Fillmore between Haight and Waller   72 53 96 96 309 84 480
592 104 20 Underground SF, 424 Haight St.   72 53 96 96 309 84 480
591 104 20 Mission between 19th and 25th St.   72 53 96 96 309 84 480
590 104 20 Musee Mecanique, Fisherman's Wharf An interactive museum consisting of 20th century penny arcade games and artifacts. 72 53 96 96 309 84 480
589 104 20 Grant between California and Washington   72 53 96 96 309 84 480
588 104 20 Boulevard Restaurant, 1 Mission St.   72 53 96 96 309 84 480
587 104 20 Filbert and Kearny Steps   72 53 96 96 309 84 480
586 104 20 Filbert between Grant and Kearny   72 53 96 96 309 84 480
585 104 20 Filbert between Leavenworth and Hyde   72 53 96 96 309 84 480
584 104 20 Taylor and Union   72 53 96 96 309 84 480
583 104 20 Clayton Post Office, 554 Clayton St.   72 53 96 96 309 84 480
582 104 20 Various Haight St. Vintage Shops   72 53 96 96 309 84 480
581 104 20 La Taqueria, 2889 Mission St. The restaurant was given the honor of "America's Best Burrito" in 2014 by ESPN's FiveThirtyEight. 72 53 96 96 309 84 480
580 104 20 Fillmore and Waller   72 53 96 96 309 84 480
579 104 20 Macchiarini Steps, Kearny between Vallejo and Broadway The namesake for the steps was an Italian-American California-based modernist jeweler and sculptor who pioneered avant-garde jewelry. 72 53 96 96 309 84 480
578 104 20 Clarion Alley between Valencia and Mission The murals that make up this famous alley were first painted in 1992 and still looked after by the Clarion Alley Mural Project. 72 53 96 96 309 84 480
577 104 20 The Castro Theater, 429 Castro St.   72 53 96 96 309 84 480
576 104 20 Mission Thrift, 2330 Mission St.   72 53 96 96 309 84 480
575 104 20 1375 Haight St.   72 53 96 96 309 84 480
574 104 20 Green and Divisadero   72 53 96 96 309 84 480
573 104 20 Mission Dolores Park, 19th St. & Dolores St. After the devastating earthquake of 1906, the park served as a refugee camp for more than 1600 families who lost their home in the disaster. 72 53 96 96 309 84 480
487 88 20 225 California Street   65 43 80 81 300 69 472
486 88 20 Mason Street @ Vallejo   65 43 80 81 300 69 472
485 88 20 3rd Street between Market & Harrison   65 43 80 81 300 69 472
484 88 20 California Street between Sansome & Davis   65 43 80 81 300 69 472
483 88 20 Turk Street between Mason & Leavenworth   65 43 80 81 300 69 472
482 88 20 Laguna Honda Hospital, 375 Laguna Honda Blvd.   65 43 80 81 300 69 472
481 88 20 Marriott Marquis, 780 Mission Street The Marriott Marquis opened on October 17, 1989, the day of the Loma Prieta earthquake.[7] With better earthquake proofing than several nearby hotels, the building only lost a single window.[7] 65 43 80 81 300 69 472
480 88 20 St Regis Hotel, 125 3rd Street   65 43 80 81 300 69 472
479 88 20 Bentley Reserve, 301 Battery Street The Bentley Reserve is the former San Francisco Federal Reserve. Designed by architect George W. Kelham and completed in 1924, the building has been a prominent landmark of the Financial District for 89 years. 65 43 80 81 300 69 472
478 88 20 Jones @ Broadway   65 43 80 81 300 69 472
477 88 20 California Street between Front and Davis   65 43 80 81 300 69 472
476 88 20 Benu Restaurant, 22 Hawthorne Street   65 43 80 81 300 69 472
475 88 20 San Francisco Airport   65 43 80 81 300 69 472
474 88 20 San Francisco City Hall The museum party interiors were shot in the Historic San Francisco City Hall. 65 43 80 81 300 69 472
473 88 20 1227 Montgomery Street   65 43 80 81 300 69 472
472 88 20 Castle Street @ Green Street   65 43 80 81 300 69 472
471 88 20 Chaya / Perry's 132 Embarcadero   65 43 80 81 300 69 472
470 88 20 Pier 14 San Francisco   65 43 80 81 300 69 472
469 88 20 Pier 39 San Francisco   65 43 80 81 300 69 472
468 88 20 343 Union Street   65 43 80 81 300 69 472
467 88 20 UCSF Mt Zion 1600 Divisadero   65 43 80 81 300 69 472
466 88 20 Legion of Honor, 100 34th Ave California Palace of the Legion of Honor was completed in 1924, and on Armistice Day of that year the doors opened to the public. In keeping with the wishes of the donors, to “honor the dead while serving the living,” it was accepted by the city of San Francisco as a museum of fine arts dedicated to the memory of the 3,600 California men who had lost their lives on the battlefields of France during World War I. 65 43 80 81 300 69 472
465 88 20 Outpost Studios, 69 Green Street   65 43 80 81 300 69 472
464 88 20 Broadway @ Jones Streets   65 43 80 81 300 69 472
463 88 20 Hooker Alley Garden on Mason between Bush & Pine   65 43 80 81 300 69 472
462 88 20 Mudpie, 2185 Fillmore Street   65 43 80 81 300 69 472
461 88 20 Andronico's, 1200 Irving Street   65 43 80 81 300 69 472
460 88 20 Treasure Island   65 43 80 81 300 69 472
369 61 20 Presidio Heights Neighborhood   45 36 55 55 280 43 463
368 61 20 Palace of Fine Arts (3301 Lyon Street)   45 36 55 55 280 43 463
367 61 20 Coit Tower   45 36 55 55 280 43 463
366 61 20 Embarcadero between Market to Fillmore St   45 36 55 55 280 43 463
365 61 20 Leavenworth at McAllister St   45 36 55 55 280 43 463
364 61 20 California between Mason and Taylor St   45 36 55 55 280 43 463
363 61 20 Sacramento between Mason and Taylor St   45 36 55 55 280 43 463
362 61 20 Mason between Sacramento and California St   45 36 55 55 280 43 463
361 61 20 Haight between Central and Ashbury St   45 36 55 55 280 43 463
360 61 20 Duboce between Buena Vista East and Alpine St   45 36 55 55 280 43 463
359 61 20 Heron @ Berwick (off 8th and Harrison St)   45 36 55 55 280 43 463
358 61 20 Embarcadero between Bay and Chestnut St   45 36 55 55 280 43 463
357 61 20 Embarcadero at Vallejo St.   45 36 55 55 280 43 463
356 61 20 Columbus between Filbert and Lombard St   45 36 55 55 280 43 463
355 61 20 Lombard St between Hyde and Larkin St   45 36 55 55 280 43 463
354 61 20 Steiner St between Jackson and Clay St   45 36 55 55 280 43 463
353 61 20 Scott St between Jackson and Clay St   45 36 55 55 280 43 463
352 61 20 20th St between Church and Dolores St   45 36 55 55 280 43 463
351 61 20 Filbert St at Stockton St   45 36 55 55 280 43 463
350 61 20 Lombard St between Leavenworth and Hyde St   45 36 55 55 280 43 463
349 61 20 Union St at Leavenworth St   45 36 55 55 280 43 463
348 61 20 Embarcadero at Lombard St.   45 36 55 55 280 43 463
347 61 20 Embarcadero between Harrison and Folsom St   45 36 55 55 280 43 463
346 61 20 Market St at Embarcadero   45 36 55 55 280 43 463
345 61 20 Waller St between Masonic and Del Mar St   45 36 55 55 280 43 463
344 61 20 Central St between Haight and Page St   45 36 55 55 280 43 463
343 61 20 Haight St at Ashbury St   45 36 55 55 280 43 463
342 61 20 Taylor St, north of Jefferson St to end   45 36 55 55 280 43 463
341 61 20 Jefferson St at Taylor St   45 36 55 55 280 43 463
340 61 20 Marina Blvd between Baker and Fillmore St   45 36 55 55 280 43 463
210 41 20 951 Hudson Avenue   36 29 39 38 272 35 458
209 41 20 2007 Franklin Street   36 29 39 38 272 35 458
208 41 20 Gough Street & Clay Street   36 29 39 38 272 35 458
207 41 20 1125 Guerrero Street   36 29 39 38 272 35 458
Powered by Datasette · Query took 1.538ms · Data source: data.sfgov.org