sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 34 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
544 100 49 Alco Plaza   38 51 91 92 282 80 478
545 100 49 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 "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". 38 51 91 92 282 80 478
546 100 49 TransAmerica Pyramid (600 Montgomery Street) The Pyramid was the tallest skyscraper west of the Mississippi from 1972-1974, until it was surpassed by Los Angeles' Aon Center. 38 51 91 92 282 80 478
547 100 49 Stockton Tunnel (Stockton Street at Sutter Street) Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area. 38 51 91 92 282 80 478
548 100 49 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. 38 51 91 92 282 80 478
549 100 49 Potrero Hill The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St. 38 51 91 92 282 80 478
550 100 49 Nob Hill Railroad tycoons like Leland Stanford (founder of Stanford University) lived in Nob Hill at the turn of the 20th Century. The 1906 earthquake completely destroyed Nob Hill, with the exception of the wall that surrounded the mansions of Stanford and his neighbor Mark Hopkins. 38 51 91 92 282 80 478
551 100 49 Hyatt Regency Hotel (5 Embarcadero Center)   38 51 91 92 282 80 478
552 100 49 Folsom Street (SOMA)   38 51 91 92 282 80 478
553 100 49 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 51 91 92 282 80 478
554 100 49 Embarcadero Freeway   38 51 91 92 282 80 478
555 100 49 Candlestick Park (602 Jamestown Ave.) Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park. 38 51 91 92 282 80 478
556 100 49 Broadway and Columbus Avenue (North Beach)   38 51 91 92 282 80 478
642 120 49 Castagnola's Restaurant (Fisherman's Wharf)   82 58 112 111 321 96 473
643 120 49 Sheraton Palace Hotel (639 Market Street) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. 82 58 112 111 321 96 473
644 120 49 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. 82 58 112 111 321 96 473
1334 249 49 American Roofing Co. Building (297 Kansas Street, Potrero Hill)   92 3 127 216 178 191 530
1335 249 49 Alta Plaza Park (Steiner Street) 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. 92 3 127 216 178 191 530
1336 249 49 Alcoa Building (1 Maritime Plaza) A partially-above ground parking structure near the building made it necessary for architects to make the Alcoa Building's diagonal bracing visible, instead of placing it inside and drastically reducing the amount usable interior space. 92 3 127 216 178 191 530
1337 249 49 Alamo Square (Hayes Valley)   92 3 127 216 178 191 530
1338 249 49 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. 92 3 127 216 178 191 530
1339 249 49 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square". 92 3 127 216 178 191 530
1340 249 49 Saks Fifth Avenue (384 Post Street, Union Square)   92 3 127 216 178 191 530
1341 249 49 One Embarcadero Center (Financial District)   92 3 127 216 178 191 530
1342 249 49 Neiman Marcus (150 Stockton Street, Union Square) In the film the City of Paris Department Store is featured. That establishment was located where Neiman Marcus stands today 92 3 127 216 178 191 530
1343 249 49 Financial District   92 3 127 216 178 191 530
1344 249 49 Cathedral Hill Hotel (1101 Van Ness Avenue, Civic Center)   92 3 127 216 178 191 530
1481 278 49 2898 Vallejo Street   162 112 228 222 273 214 542
1497 278 49 Bank of America Building (555 California Street, Financial District) 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. 162 112 228 222 273 214 542
1498 278 49 San Francisco Fire Station 38 (2150 California Street, Pacific Heights)   162 112 228 222 273 214 542
1499 278 49 Hyatt Regency Hotel (5 Embarcadero Center, Financial District)   162 112 228 222 273 214 542
1500 278 49 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 162 112 228 222 273 214 542
1501 278 49 Firestation #38 (California & Laguna)   162 112 228 222 273 214 542
1502 278 49 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. 162 112 228 222 273 214 542
Powered by Datasette · Query took 1.126ms · Data source: data.sfgov.org