sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 32 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
641 119 1 Muni Metro East (501 Cesar Chavez)   81 57 111 110 320 95  
684 134 7 Pier 33 (Embarcadero)   89 19 111 124 286 110 491
686 134 7 Department of Public Health (101 Grove Street at Polk, Civic Center)   89 19 111 124 286 110 491
687 134 7 United Nations Plaza (Civic Center) United Nations Plaza was built in 1975 and across its walkways are white lines into which the preamble to the preamble of the UN charter is carved. 89 19 111 124 286 110 491
688 134 7 Transamerica Building (600 Montgomery Street at Clay) The Pyramid was the tallest skyscraper west of the Mississippi from 1972-1974, until it was surpassed by Los Angeles' Aon Center. 89 19 111 124 286 110 491
689 134 7 San Francisco Drydock (20th and Illinois Streets)   89 19 111 124 286 110 491
690 134 7 Ramada Plaza Hotel Downtown (1231 Market Street, Civic Center)   89 19 111 124 286 110 491
691 134 7 Postcard Row (Alamo Square, Hayes Valley) The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. 89 19 111 124 286 110 491
692 134 7 Lafayette Park (Pacific Heights)   89 19 111 124 286 110 491
693 134 7 Hamlin Hotel (385 Eddy Street)   89 19 111 124 286 110 491
694 134 7 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. 89 19 111 124 286 110 491
695 134 7 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 89 19 111 124 286 110 491
696 134 7 Broadway Tunnel (Russian Hill)   89 19 111 124 286 110 491
697 134 7 Bimbo's 365 Club (1025 Columbus Avenue, North Beach)   89 19 111 124 286 110 491
698 134 7 720 Steiner Street (Hayes Valley)   89 19 111 124 286 110 491
699 134 7 32 Napier Lane   89 19 111 124 286 110 491
700 134 7 1227 Montgomery Street (Telegraph Hill)   89 19 111 124 286 110 491
1133 209 5 Pier 24   4 3 111 181 324 160  
1483 279 65 American Can Company (Between Illinois & Kentucky, 20th and 22nd Streets)   163 113 111 240 417 215 543
1484 279 65 Cow Palace Supposedly, the Cow Palace's name derives from a newspaper editorial in which the writer wonders whether the soon-to-be-built structure for livestock was a "palace for cows". 163 113 111 240 417 215 543
1485 279 65 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. 163 113 111 240 417 215 543
1486 279 65 Financial District   163 113 111 240 417 215 543
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  
1555 209 5 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. 4 3 111 181 324 160  
1556 209 5 The Saloon (1232 Grant Avenue)   4 3 111 181 324 160  
Powered by Datasette · Query took 1.308ms · Data source: data.sfgov.org