sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 33 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
127 33 26 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. 29 25 31 30 265    
128 33 26 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. 29 25 31 30 265    
129 33 26 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. 29 25 31 30 265    
130 33 26 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. 29 25 31 30 265    
131 33 26 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 29 25 31 30 265    
449 86 26 Palace of Fine Arts (3301 Lyon Street) The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. 64 49 78 79 220 67  
450 86 26 Moose's Restaurant (1652 Stockton)   64 49 78 79 220 67  
451 86 26 Mario's Bohemian Cigar Store (Washington Square)   64 49 78 79 220 67  
453 86 26 Center for the Arts, Yerba Buena Gardens (701 Mission Street)   64 49 78 79 220 67  
454 86 26 Castro Theatre (429 Castro Street, The Castro) The original Castro Theatre was built in 1910, a few doors down from the current theatre. The original theatre was converted into retail space, and the current theatre was built in the 1920s. 64 49 78 79 220 67  
455 86 26 20th & Connecticut Streets (Potrero Hill)   64 49 78 79 220 67  
456 86 26 19 Green Street (North Beach)   64 49 78 79 220 67  
457 86 26 1138 Filbert Street   64 49 78 79 220 67  
458 86 26 North Beach Video (1398 Grant Avenue at Green) The video store has since moved to an adjacent location. 64 49 78 79 220 67  
1159 213 26 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. 132 82 176 185 376 163  
1238 228 26 19th and Kansas St.   8 85 189 199 385 173  
1312 241 26 Merchant Exchange (465 California Street at Leidesdorff)   147 105 198 210 394 185  
1314 241 26 Washington Square Park (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. The statue in the Park is Ben Franklin, not George Washington. 147 105 198 210 394 185  
1315 241 26 Sutter-Stockton Garage (330 Sutter Street at Stockton) Garage roof serves as a heliport in the movie 147 105 198 210 394 185  
1316 241 26 Stockton Tunnel (Stockton Street at Sutter Street) Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area. 147 105 198 210 394 185  
1317 241 26 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. 147 105 198 210 394 185  
1318 241 26 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. 147 105 198 210 394 185  
1319 241 26 Roof of Cable Car (California at Front Street) SF Cable Cars are the only moving National Historical Landmark. 147 105 198 210 394 185  
1320 241 26 Pacific Stock Exchange (301 Pine Street at Sansome)   147 105 198 210 394 185  
1321 241 26 Nina M. Designs (52 2nd Street at Jessie)   147 105 198 210 394 185  
1322 241 26 Moose's Restaurant (1652 Stockton)   147 105 198 210 394 185  
1323 241 26 Mama's Restaurant (1701 Stockton)   147 105 198 210 394 185  
1324 241 26 Danilo's Bakery (Green Street & Bannam Place)   147 105 198 210 394 185  
1325 241 26 Columbus Avenue at Green & Stockton   147 105 198 210 394 185  
1447 269 26 skyline/ exterior scenes   128 6 222 233 391 206  
1452 273 26 Transbay Terminal (Mission Street at 1st Street) Built in 1939, the Terminal linked San Francisco, the East Bay, and Sacramento by rail for the first time. 161 25 27 236 413 147  
1453 273 26 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. 161 25 27 236 413 147  
1454 273 26 Palace of Fine Arts (3301 Lyon Street) The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. 161 25 27 236 413 147  
Powered by Datasette · Query took 1.096ms · Data source: data.sfgov.org