sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 29 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
99 27 22 Yerba Buena Center for the Arts   24 20 25 24 245 23 449
100 27 22 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. 24 20 25 24 245 23 449
101 27 22 Tosca CafĂ© (242 Columbus Avenue)   24 20 25 24 245 23 449
102 27 22 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. 24 20 25 24 245 23 449
103 27 22 Raw Hide II (280 Seventh Street)   24 20 25 24 245 23 449
104 27 22 Pier 7 (The Embarcadero)   24 20 25 24 245 23 449
105 27 22 Kearney Street (Telegraph Hill)   24 20 25 24 245 23 449
107 27 22 Hall of Justice (850 Bryant Street)   24 20 25 24 245 23 449
108 27 22 2930 Vallejo Street   24 20 25 24 245 23 449
109 27 22 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 24 20 25 24 245 23 449
110 27 22 Gibb Street (Chinatown)   24 20 25 24 245 23 449
111 27 22 1158-70 Montgomery Street   24 20 25 24 245 23 449
112 27 22 2104 Broadway   24 20 25 24 245 23 449
513 95 22 Westin St. Francis Hotel (335 Powell Street, Union Square) The hotel was originally supposed to be named the Crocker Hotel, after Charles Founder the railroad magnate who founded it. However, the hotel took the name the St. Francis after one of the earliest Gold Rush hotels. 38 6 86 87 264 75  
514 95 22 Public Health Service Hospital (Presidio, Golden Gate National Recreation Area) In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. 38 6 86 87 264 75  
515 95 22 Presidio, Golden Gate National Recreation Area In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. 38 6 86 87 264 75  
516 95 22 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. 38 6 86 87 264 75  
517 95 22 Bix Restaurant (56 Gold Street)   38 6 86 87 264 75  
884 163 22 St. Elizabeth Apartment House (901 Powell Street at Sacramento)   38 6 33 142 79 126 499
1070 199 22     125 41 45 172 367    
1165 218 22 St. Paul's Church (Church Street, Noe Valley)   104 25 180 190 274 167  
1196 221 22 The Embarcadero   15 41 183 192 381 169  
1197 221 22 Hills Brothers Plaza (The Embarcadero at Harrison)   15 41 183 192 381 169  
1559 297 22 Project Artaud (Florida Street)   173 117 242 257 431 230 549
1560 297 22 Corona Heights Park   173 117 242 257 431 230 549
1561 297 22 544 Natoma (SOMA)   173 117 242 257 431 230 549
1562 297 22 422 Oak Street at Laguna   173 117 242 257 431 230 549
1563 297 22 3567 18th Street   173 117 242 257 431 230 549
1564 297 22 Under Highway 101 (near Potrero and Cesar Chavez Streets)   173 117 242 257 431 230 549
Powered by Datasette · Query took 1.127ms · Data source: data.sfgov.org