sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 38 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
211 42 31 Bayshore Blvd near Cesar Chavez (Bayview)   37 30 40 39 273 36 459
212 42 31 Taylor & Vallejo Streets (Russian Hill)   37 30 40 39 273 36 459
214 42 31 SF General Hospital Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. 37 30 40 39 273 36 459
215 42 31 McLaren Park (Visitacion Valley) McLaren Park is the 2nd largest park in San Francisco, after Golden Gate Park. 37 30 40 39 273 36 459
216 42 31 Mark Hopkins Hotel (999 California Street) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. 37 30 40 39 273 36 459
217 42 31 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. 37 30 40 39 273 36 459
218 42 31 Mansell & University Streets (Visitacion Valley)   37 30 40 39 273 36 459
219 42 31 Larkin & Francisco Streets (Russian Hill)   37 30 40 39 273 36 459
220 42 31 Larkin & Chestnut Streets (Russian Hill)   37 30 40 39 273 36 459
221 42 31 Kennedy Hotel (226 Embarcadero at Howard Street) Hotel was destroyed in the 1989 Loma Prieta earthquake. Corporate headquarters for the Gap reside at the location today. 37 30 40 39 273 36 459
222 42 31 John Muir Drive (Lake Merced)   37 30 40 39 273 36 459
223 42 31 Intersection of York & Peralta (Bernal Heights)   37 30 40 39 273 36 459
224 42 31 Filbert & Taylor Streets (Russian Hill)   37 30 40 39 273 36 459
225 42 31 Enrico's Café (504 Broadway)   37 30 40 39 273 36 459
226 42 31 Columbus & Lombard Streets (North Beach)   37 30 40 39 273 36 459
227 42 31 Cesar Chavez & Mission Street (Mission)   37 30 40 39 273 36 459
228 42 31 Candlestick Park Exit, Highway 101   37 30 40 39 273 36 459
229 42 31 Café Cantata (2040 Union Street)   37 30 40 39 273 36 459
230 42 31 Brocklebank Apartments (1000 Mason Street)   37 30 40 39 273 36 459
231 42 31 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. 37 30 40 39 273 36 459
232 42 31 2700 Vallejo Street (Pacific Heights)   37 30 40 39 273 36 459
233 42 31 20th & Vermont Streets (Potrero Hill) The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St. 37 30 40 39 273 36 459
234 42 31 1153-57 Taylor Street Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake) 37 30 40 39 273 36 459
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  
Powered by Datasette · Query took 1.21ms · Data source: data.sfgov.org