sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
16 7 7 Embarcadero Freeway Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake) 7 6 7 6 242 6  
17 7 7 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. 7 6 7 6 242 6  
18 7 7 San Francisco Chronicle (901 Mission Street at 15th Street) The San Francisco Zodiac Killer of the late 1960s sent his notes and letters to the Chronicle's offices. 7 6 7 6 242 6  
19 7 7 Broadway (North Beach)   7 6 7 6 242 6  
213 43 32 1627 Haight Street   38 6 41 40 274 37  
235 43 32 California Academy of Sciences (Golden Gate Park) Founded in 1853, 3 years after California joined the United States, the Academy was originally named the California Academy of Natural Sciences and was the first institution of its kind in the United States. 38 6 41 40 274 37  
236 43 32 Green Valley Restaurant (510 Green Street Near Grant)   38 6 41 40 274 37  
237 43 32 1400 18th Street   38 6 41 40 274 37  
374 64 18 San Francisco Public Library Main Branch (100 Larkin Street)   48 6 58 58 216 46  
380 68 39 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. 52 6 62 61 285 50  
381 68 39 Twin Peaks The 2nd highest point in SF after Mt. Davidson, Twin Peaks sit at the geographic center of SF. The native Ohlone people called the area “Los Pechos de la Chola” or "Breasts of the Indian Maiden," but in the 19th Century when America took over the area, it was renamed "Twin Peaks". 52 6 62 61 285 50  
382 68 39 Sound Factory (1st and Harrison Streets)   52 6 62 61 285 50  
383 68 39 Java House (Pier 40, Embarcadero)   52 6 62 61 285 50  
384 68 39 Alta Plaza Park The park was originally a rock quarry and served as a campground for many survivors of the 1906 earthquake. The site was converted to a park in 1910. 52 6 62 61 285 50  
385 68 39 82 & 67 Rico Way (Marina District)   52 6 62 61 285 50  
398 72 41 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. 38 6 66 65 289 54 465
399 72 41 The Malloch Apartment Building (1360 Montgomery Street)   38 6 66 65 289 54 465
400 72 41 Filbert Steps, Filbert Street   38 6 66 65 289 54 465
409 75 29     38 6 69 68 292 57 468
1244 231 65 Near Point Lobos, El Camino Del Mar   38 6 113 71 295 176  
1245 231 65 Mt. Davidson Mt. Davidson is highest point in San Francisco (938 feet). 38 6 113 71 295 176 522
1246 231 65 McDonald's Restaurant (701 3rd Street, SOMA)   38 6 113 71 295 176 522
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
1248 231 65 Hall of Justice (850 Bryant Street)   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
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
1251 231 65 Civic Center Plaza   38 6 113 71 295 176 522
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
1253 231 65 Bowles Franklin Galleries (765 Beach Street, Fisherman's Wharf)   38 6 113 71 295 176 522
1254 231 65 Pier 38-40, The Embarcadero   38 6 113 71 295 176 522
1313 242 23 Hall of Justice (850 Bryant Street)   38 6 199 71 295 186 527
1346 242 23 San Francisco Drydock (The Dogpatch)   38 6 199 71 295 186 527
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
1348 242 23 One Thousand Powell Apartments (1000 Powell Street)   38 6 199 71 295 186 527
1349 242 23 The Cannery (281 Leavenworth Street, Fisherman's Wharf)   38 6 199 71 295 186 527
1350 242 23 Portsmouth Square (Chinatown)   38 6 199 71 295 186 527
1351 242 23 Pierce St. & Golden Gate Avenue (Hayes Valley)   38 6 199 71 295 186 527
1352 242 23 Pierce & California Streets (Pacific Heights)   38 6 199 71 295 186 527
1353 242 23 Pier 3 (The Embarcadero)   38 6 199 71 295 186 527
1354 242 23 New Asia Restaurant (772 Pacific Avenue at Grant)   38 6 199 71 295 186 527
1355 242 23 Nam Yuen Restaurant (740 Washington Street, Chinatown)   38 6 199 71 295 186 527
1356 242 23 Mirant Energy, LLC (1301 Illinois Street, The Dogpatch)   38 6 199 71 295 186 527
1357 242 23 McAllister & Scott Streets (Hayes Valley)   38 6 199 71 295 186 527
1358 242 23 KGO-TV ABC7 TV Studios (900 Front Street, Waterfront Historic District)   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
1362 242 23 Fremont Street Exit of Bay Bridge   38 6 199 71 295 186 527
1363 242 23 Folsom & Essex Streets   38 6 199 71 295 186 527
1364 242 23 Eber Electronics (2355 Market Street, Castro)   38 6 199 71 295 186 527
1365 242 23 Clementina & Sumner Streets   38 6 199 71 295 186 527
1366 242 23 Carl & Cole Streets (Cole Valley)   38 6 199 71 295 186 527
1367 242 23 710 Steiner Street (Hayes Valley)   38 6 199 71 295 186 527
1368 242 23 550 El Camino Del Mar (Seacliff)   38 6 199 71 295 186 527
1369 242 23 23rd & Iowa Streets (Dogpatch)   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
1371 242 23 22nd & Wisconsin Streets (Potrero Hill)   38 6 199 71 295 186 527
1372 242 23 20th & De Haro Streets (Potrero Hill)   38 6 199 71 295 186 527
1373 242 23 1954 Mason Street (North Beach)   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
504 94 46 400 Montgomery Street   68 6 85 86 113 74 475
505 94 46 Folsom Street & Embarcadero   68 6 85 86 113 74 475
506 94 46 Varennes Alley between Filbert and Union   68 6 85 86 113 74 475
507 94 46 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. 68 6 85 86 113 74 475
508 94 46 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. 68 6 85 86 113 74 475
509 94 46 Kohl Building (400 Montgomery Street)   68 6 85 86 113 74 475
510 94 46 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. 68 6 85 86 113 74 475
511 94 46 90 Gold Street   68 6 85 86 113 74 475
512 94 46 5th and Beale Streets   68 6 85 86 113 74 475
513 95 22 Westin St. Francis Hotel (335 Powell Street, Union Square) The hotel was originally supposed to be named the Crocker Hotel, after Charles Founder the railroad magnate who founded it. However, the hotel took the name the St. Francis after one of the earliest Gold Rush hotels. 38 6 86 87 264 75  
514 95 22 Public Health Service Hospital (Presidio, Golden Gate National Recreation Area) In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. 38 6 86 87 264 75  
515 95 22 Presidio, Golden Gate National Recreation Area In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. 38 6 86 87 264 75  
516 95 22 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. 38 6 86 87 264 75  
517 95 22 Bix Restaurant (56 Gold Street)   38 6 86 87 264 75  
557 101 50 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. 38 6 92 93 307 81 479
595 106 11 Kearney & Pine St.   74 6 98 98 311 85 481
596 106 11 California & Davis St   74 6 98 98 311 85 481
597 106 11 Pine St. & Davis St   74 6 98 98 311 85 481
598 106 11 Sacramento & Front St.   74 6 98 98 311 85 481
599 106 11 Broadway & Sansome   74 6 98 98 311 85 481
600 106 11 Broadway & Columbus   74 6 98 98 311 85 481
601 106 11 Post & Jones St.   74 6 98 98 311 85 481
602 106 11 Stockton & Clay St   74 6 98 98 311 85 481
603 106 11 Bush & Kearny   74 6 98 98 311 85 481
604 106 11 Mission & Fremont St   74 6 98 98 311 85 481
605 106 11 Eddy & Taylor St.   74 6 98 98 311 85 481
606 106 11 Pier 7 (The Embarcadero)   74 6 98 98 311 85 481
607 106 11 Pier 1   74 6 98 98 311 85 481
608 106 11 Embarcadero & Washington   74 6 98 98 311 85 481
609 106 11 Mission & Beal   74 6 98 98 311 85 481
610 106 11 Potrero &San Bruno   74 6 98 98 311 85 481
645 121 19 Hobart Building (582 Market Street)   83 6 113 112 322 97  
646 121 19 The Final Final (2990 Baker Street)   83 6 113 112 322 97  
647 121 19 1160 Taylor Street   83 6 113 112 322 97  
677 132 32 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. 87 6 123 122 210 108 46
678 132 32 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city. 87 6 123 122 210 108 46
679 132 32 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. 87 6 123 122 210 108 46
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
Powered by Datasette · Query took 1.813ms · Data source: data.sfgov.org