sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 55 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
1373 242 23 1954 Mason Street (North Beach)   38 6 199 71 295 186 527
1372 242 23 20th & De Haro Streets (Potrero Hill)   38 6 199 71 295 186 527
1371 242 23 22nd & Wisconsin Streets (Potrero Hill)   38 6 199 71 295 186 527
1370 242 23 22nd Bet. Carolina & Rhode Island Streets (Potrero Hill)   38 6 199 71 295 186 527
1369 242 23 23rd & Iowa Streets (Dogpatch)   38 6 199 71 295 186 527
1368 242 23 550 El Camino Del Mar (Seacliff)   38 6 199 71 295 186 527
1367 242 23 710 Steiner Street (Hayes Valley)   38 6 199 71 295 186 527
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  
1253 231 65 Bowles Franklin Galleries (765 Beach Street, Fisherman's Wharf)   38 6 113 71 295 176 522
427 78 42 California Hall (625 Polk Street, Van Ness/Civic Center)   59 30 71 71 295 60  
1366 242 23 Carl & Cole Streets (Cole Valley)   38 6 199 71 295 186 527
1251 231 65 Civic Center Plaza   38 6 113 71 295 176 522
1365 242 23 Clementina & Sumner Streets   38 6 199 71 295 186 527
426 78 42 Dante Building (1606 Stockton Street at Union)   59 30 71 71 295 60  
1364 242 23 Eber Electronics (2355 Market Street, Castro)   38 6 199 71 295 186 527
1250 231 65 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. 38 6 113 71 295 176 522
1249 231 65 Ferry Plaza Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 38 6 113 71 295 176 522
1363 242 23 Folsom & Essex Streets   38 6 199 71 295 186 527
425 78 42 Forest Hill Station- MUNI   59 30 71 71 295 60  
1362 242 23 Fremont Street Exit of Bay Bridge   38 6 199 71 295 186 527
424 78 42 Hall of Justice (850 Bryant Street)   59 30 71 71 295 60  
1248 231 65 Hall of Justice (850 Bryant Street)   38 6 113 71 295 176 522
1313 242 23 Hall of Justice (850 Bryant Street)   38 6 199 71 295 186 527
423 78 42 Holiday Inn Select Downtown Hotel (750 Kearney Street)   59 30 71 71 295 60  
1358 242 23 KGO-TV ABC7 TV Studios (900 Front Street, Waterfront Historic District)   38 6 199 71 295 186 527
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  
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  
1247 231 65 Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle, Nob Hill) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. 38 6 113 71 295 176 522
1357 242 23 McAllister & Scott Streets (Hayes Valley)   38 6 199 71 295 186 527
1246 231 65 McDonald's Restaurant (701 3rd Street, SOMA)   38 6 113 71 295 176 522
1356 242 23 Mirant Energy, LLC (1301 Illinois Street, The Dogpatch)   38 6 199 71 295 186 527
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  
1245 231 65 Mt. Davidson Mt. Davidson is highest point in San Francisco (938 feet). 38 6 113 71 295 176 522
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  
1355 242 23 Nam Yuen Restaurant (740 Washington Street, Chinatown)   38 6 199 71 295 186 527
1244 231 65 Near Point Lobos, El Camino Del Mar   38 6 113 71 295 176  
1354 242 23 New Asia Restaurant (772 Pacific Avenue at Grant)   38 6 199 71 295 186 527
1348 242 23 One Thousand Powell Apartments (1000 Powell Street)   38 6 199 71 295 186 527
1353 242 23 Pier 3 (The Embarcadero)   38 6 199 71 295 186 527
1254 231 65 Pier 38-40, The Embarcadero   38 6 113 71 295 176 522
1352 242 23 Pierce & California Streets (Pacific Heights)   38 6 199 71 295 186 527
1351 242 23 Pierce St. & Golden Gate Avenue (Hayes Valley)   38 6 199 71 295 186 527
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  
1350 242 23 Portsmouth Square (Chinatown)   38 6 199 71 295 186 527
418 78 42 San Francisco Drydock (20th and Illinois Streets)   59 30 71 71 295 60  
1346 242 23 San Francisco Drydock (The Dogpatch)   38 6 199 71 295 186 527
1374 242 23 San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. 38 6 199 71 295 186 527
1360 242 23 San Francisco National Military Cemetery (Lincoln Blvd., The Presidio, Golden Gate National Recreation Center)   38 6 199 71 295 186 527
1361 242 23 Silver Restaurant (737 Washington Street, Chinatown)   38 6 199 71 295 186 527
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  
1349 242 23 The Cannery (281 Leavenworth Street, Fisherman's Wharf)   38 6 199 71 295 186 527
416 78 42 The Embarcadero   59 30 71 71 295 60  
1252 231 65 The Embarcadero/Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 38 6 113 71 295 176 522
1347 242 23 Washington Square Park (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. The statue in the Park is Ben Franklin, not George Washington. 38 6 199 71 295 186 527
415 78 42 Washington Square, North Beach   59 30 71 71 295 60  
Powered by Datasette · Query took 1.345ms · Data source: data.sfgov.org