sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 30 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
414 78 42 Marina Green, Marina District Before the 1906 earthquake, the land on which Marina Green sits was a tidal marsh, and rubble from the earthquake was dumped on the site. However, the site was filled in to provide land for the 1915 Panama-Pacific Exhibition. 59 30 71 71 295 60  
415 78 42 Washington Square, North Beach   59 30 71 71 295 60  
416 78 42 The Embarcadero   59 30 71 71 295 60  
417 78 42 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. 59 30 71 71 295 60  
418 78 42 San Francisco Drydock (20th and Illinois Streets)   59 30 71 71 295 60  
419 78 42 Portsmouth Square (Chinatown) In 1847 the first public school in California was erected on what would become Portsmouth Square. 59 30 71 71 295 60  
420 78 42 Mt. Davidson Cross, Mt. Davidson The cross sits at the highest point in San Francisco (938 feet). This version of the cross was erected in 1934.Though in Dirty Harry the cross is lit at night, the City stopped this practice in 1990. 59 30 71 71 295 60  
421 78 42 Mission Dolores Park (Mission District) The two land plots that comprise the Park were used as a Jewish cemetery until 1894 when San Francisco prohibited all burials within city limits. The graves were moved to Colma, CA. 59 30 71 71 295 60  
422 78 42 Kezar Stadium, Golden Gate Park The stadium was demolished and completely rebuilt after sustaining damages in the 1898 Loma Prieta earthquake. 59 30 71 71 295 60  
423 78 42 Holiday Inn Select Downtown Hotel (750 Kearney Street)   59 30 71 71 295 60  
424 78 42 Hall of Justice (850 Bryant Street)   59 30 71 71 295 60  
425 78 42 Forest Hill Station- MUNI   59 30 71 71 295 60  
426 78 42 Dante Building (1606 Stockton Street at Union)   59 30 71 71 295 60  
427 78 42 California Hall (625 Polk Street, Van Ness/Civic Center)   59 30 71 71 295 60  
428 78 42 Bank of America Building (555 California Street) The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast. 59 30 71 71 295 60  
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
Powered by Datasette · Query took 1.207ms · Data source: data.sfgov.org