sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 18 rows (hide)

Query parameters

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
24 10 9 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. 8 7 9 8 244 8 441
25 10 9 Port of San Francisco   8 7 9 8 244 8 441
27 10 9 Lefty O' Doul Drawbridge/ 3rd Street Bridge (3rd Street, China Basin) This is SF's only drawbridge, and was named after Francis Joseph "Lefty" O'Doul, a local baseball hero. 8 7 9 8 244 8 441
28 10 9 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. 8 7 9 8 244 8 441
29 10 9 Embarcadero Freeway Embarcadero Freeway, which was featured in the film, was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake) 8 7 9 8 244 8 441
30 10 9 Potrero Hill The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St. 8 7 9 8 244 8 441
31 10 9 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. 8 7 9 8 244 8 441
32 10 9 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 8 7 9 8 244 8 441
33 10 9 Burger Island (901 3rd Street, China Basin)   8 7 9 8 244 8 441
34 10 9 Van Ness Avenue   8 7 9 8 244 8 441
35 10 9 Taylor and Jefferson Streets (Fisherman's Wharf)   8 7 9 8 244 8 441
39 13 12 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. 8 10 12 11 247 11 432
1032 194 53 Fort Point (Presidio, Golden Gate National Recreation Area) Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF. 8 10 163 167 363 149 509
1033 194 53 Alcatraz Island Alcatraz Island was a military fort before it became a prison. 8 10 163 167 363 149 509
1111 206 12 The Barbary Coast The Barbary Coast was a red-light district that was largely destroyed in the 1906 earthquake. Though some of the establishments were rebuilt after the earthquake, an anti-vice campaign put the establishments out of business. 8 10 12 179 372 158 315
1112 206 12 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. 8 10 12 179 372 158 315
1160 214 63 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. 8 10 12 186 247 11 515
1238 228 26 19th and Kansas St.   8 85 189 199 385 173  
Powered by Datasette · Query took 1.584ms · Data source: data.sfgov.org