sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 18 rows (hide)

Query parameters

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
56 18 16 Mel's Drive-In (Corner of Van Ness & Mission Street, Mission District) This restaurant location was demolished; however another Mel's was reopened in 1986 on 3355 Geary Blvd. 15 14 17 16 252 16 445
57 18 16 3355 Geary Blvd.   15 14 17 16 252 16 445
865 160 16 Cost Plus World Market (2552 Taylor Street)   59 6 138 139 295 124 497
866 160 16 Vermont Street between 20th and 22nd Streets   59 6 138 139 295 124 497
867 160 16 San Francisco International Airport SFO has a museum dedicated to aviation history. 59 6 138 139 295 124 497
868 160 16 San Francisco Drydock (20th and Illinois Streets)   59 6 138 139 295 124 497
869 160 16 Pacific Heights Towers (2200 Sacramento Street, Pacific Heights)   59 6 138 139 295 124 497
870 160 16 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. 59 6 138 139 295 124 497
871 160 16 Hall of Justice (850 Bryant Street)   59 6 138 139 295 124 497
872 160 16 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. 59 6 138 139 295 124 497
873 160 16 Fairmont Hotel (950 Mason Street, Nob Hill) In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room. 59 6 138 139 295 124 497
874 160 16 Embarcadero Freeway demolished 59 6 138 139 295 124 497
875 160 16 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. 59 6 138 139 295 124 497
876 160 16 Broadway Tunnel (Russian Hill)   59 6 138 139 295 124 497
877 160 16 280 Freeway at Pennsylvania and Mariposa Streets   59 6 138 139 295 124 497
878 160 16 2190 Washington Street (Pacific Heights)   59 6 138 139 295 124 497
879 160 16 18th Street Overpass (Potrero Hill)   59 6 138 139 295 124 497
1433 264 16     13 51 219 230 408 70 538
Powered by Datasette · Query took 1.044ms · Data source: data.sfgov.org