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
91 25 20 Fairmont Hotel (950 Mason Street, Nob Hill)   22 18 23 22 258 21 447
92 25 20 Embarcadero around Rincon Park   22 18 23 22 258 21 447
93 25 20 San Remo Hotel (2237 Mason)   22 18 23 22 258 21 447
94 25 20 Huntington Park (California & Taylor Streets, Nob Hill)   22 18 23 22 258 21 447
95 25 20 Driving around Taylor/Pacific/Leavenworth   22 18 23 22 258 21 447
96 25 20 California and Jones St.   22 18 23 22 258 21 447
97 25 20 Another Café, 1191 Pine St at Leavenworth   22 18 23 22 258 21 447
198 41 20 3050 24th Street   36 29 39 38 272 35 458
199 41 20 3033 24th Street   36 29 39 38 272 35 458
200 41 20 2937 24th Street   36 29 39 38 272 35 458
201 41 20 1167 Alabama Street   36 29 39 38 272 35 458
202 41 20 1641 York Street   36 29 39 38 272 35 458
203 41 20 Bernal Heights Boulevard   36 29 39 38 272 35 458
204 41 20 40 Prentiss Street   36 29 39 38 272 35 458
205 41 20 500 Cortland Avenue   36 29 39 38 272 35 458
206 41 20 Lucky Street   36 29 39 38 272 35 458
207 41 20 1125 Guerrero Street   36 29 39 38 272 35 458
208 41 20 Gough Street & Clay Street   36 29 39 38 272 35 458
209 41 20 2007 Franklin Street   36 29 39 38 272 35 458
210 41 20 951 Hudson Avenue   36 29 39 38 272 35 458
340 61 20 Marina Blvd between Baker and Fillmore St   45 36 55 55 280 43 463
341 61 20 Jefferson St at Taylor 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
343 61 20 Haight St at Ashbury 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
345 61 20 Waller St between Masonic and Del Mar St   45 36 55 55 280 43 463
346 61 20 Market St at Embarcadero   45 36 55 55 280 43 463
347 61 20 Embarcadero between Harrison and Folsom St   45 36 55 55 280 43 463
348 61 20 Embarcadero at Lombard St.   45 36 55 55 280 43 463
349 61 20 Union St at Leavenworth 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
351 61 20 Filbert St at Stockton 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
353 61 20 Scott St between Jackson and Clay 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
355 61 20 Lombard St between Hyde and Larkin St   45 36 55 55 280 43 463
356 61 20 Columbus between Filbert and Lombard St   45 36 55 55 280 43 463
357 61 20 Embarcadero at Vallejo St.   45 36 55 55 280 43 463
358 61 20 Embarcadero between Bay and Chestnut 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
360 61 20 Duboce between Buena Vista East and Alpine St   45 36 55 55 280 43 463
361 61 20 Haight between Central and Ashbury St   45 36 55 55 280 43 463
362 61 20 Mason between Sacramento and California St   45 36 55 55 280 43 463
363 61 20 Sacramento between Mason and Taylor St   45 36 55 55 280 43 463
364 61 20 California between Mason and Taylor St   45 36 55 55 280 43 463
365 61 20 Leavenworth at McAllister St   45 36 55 55 280 43 463
366 61 20 Embarcadero between Market to Fillmore St   45 36 55 55 280 43 463
367 61 20 Coit Tower   45 36 55 55 280 43 463
368 61 20 Palace of Fine Arts (3301 Lyon Street)   45 36 55 55 280 43 463
369 61 20 Presidio Heights Neighborhood   45 36 55 55 280 43 463
460 88 20 Treasure Island   65 43 80 81 300 69 472
461 88 20 Andronico's, 1200 Irving Street   65 43 80 81 300 69 472
462 88 20 Mudpie, 2185 Fillmore Street   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
464 88 20 Broadway @ Jones Streets   65 43 80 81 300 69 472
465 88 20 Outpost Studios, 69 Green Street   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
467 88 20 UCSF Mt Zion 1600 Divisadero   65 43 80 81 300 69 472
468 88 20 343 Union Street   65 43 80 81 300 69 472
469 88 20 Pier 39 San Francisco   65 43 80 81 300 69 472
470 88 20 Pier 14 San Francisco   65 43 80 81 300 69 472
471 88 20 Chaya / Perry's 132 Embarcadero   65 43 80 81 300 69 472
472 88 20 Castle Street @ Green Street   65 43 80 81 300 69 472
473 88 20 1227 Montgomery Street   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
475 88 20 San Francisco Airport   65 43 80 81 300 69 472
476 88 20 Benu Restaurant, 22 Hawthorne Street   65 43 80 81 300 69 472
477 88 20 California Street between Front and Davis   65 43 80 81 300 69 472
478 88 20 Jones @ Broadway   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
480 88 20 St Regis Hotel, 125 3rd Street   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
482 88 20 Laguna Honda Hospital, 375 Laguna Honda Blvd.   65 43 80 81 300 69 472
483 88 20 Turk Street between Mason & Leavenworth   65 43 80 81 300 69 472
484 88 20 California Street between Sansome & Davis   65 43 80 81 300 69 472
485 88 20 3rd Street between Market & Harrison   65 43 80 81 300 69 472
486 88 20 Mason Street @ Vallejo   65 43 80 81 300 69 472
487 88 20 225 California Street   65 43 80 81 300 69 472
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
574 104 20 Green and Divisadero   72 53 96 96 309 84 480
575 104 20 1375 Haight St.   72 53 96 96 309 84 480
576 104 20 Mission Thrift, 2330 Mission St.   72 53 96 96 309 84 480
577 104 20 The Castro Theater, 429 Castro St.   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
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
580 104 20 Fillmore and Waller   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
582 104 20 Various Haight St. Vintage Shops   72 53 96 96 309 84 480
583 104 20 Clayton Post Office, 554 Clayton St.   72 53 96 96 309 84 480
584 104 20 Taylor and Union   72 53 96 96 309 84 480
585 104 20 Filbert between Leavenworth and Hyde   72 53 96 96 309 84 480
586 104 20 Filbert between Grant and Kearny   72 53 96 96 309 84 480
587 104 20 Filbert and Kearny Steps   72 53 96 96 309 84 480
588 104 20 Boulevard Restaurant, 1 Mission St.   72 53 96 96 309 84 480
589 104 20 Grant between California and Washington   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
591 104 20 Mission between 19th and 25th St.   72 53 96 96 309 84 480
592 104 20 Underground SF, 424 Haight St.   72 53 96 96 309 84 480
593 104 20 Fillmore between Haight and Waller   72 53 96 96 309 84 480
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
1599 303 20 United Nations Plaza   176 119 142 145 435 234 550
Powered by Datasette · Query took 1.602ms · Data source: data.sfgov.org