sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 32 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
98 26 21     23 19 24 23 259 22 448
143 36 29 Alcatraz Island Alcatraz Island was a military fort before it became a prison. 31 19 34 33 268 31 455
144 36 29 Pier 43 1/2   31 19 34 33 268 31 455
389 71 15 Powell & California Streets   54 19 65 64 288 53 464
390 71 15 Southern Pacific Memorial Hospital (1400 Fell Street)   54 19 65 64 288 53 464
391 71 15 The Embarcadero/ Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 54 19 65 64 288 53 464
392 71 15 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square". 54 19 65 64 288 53 464
393 71 15 Westin St. Francis Hotel (335 Powell Street) 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. 54 19 65 64 288 53 464
394 71 15 Chambord Apartments (1298 Sacramento Street at Jones)   54 19 65 64 288 53 464
395 71 15 Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. 54 19 65 64 288 53 464
396 71 15 Market & Steuart Streets (Financial District)   54 19 65 64 288 53 464
397 71 15 Market Street (from 6th- 4th Streets)   54 19 65 64 288 53 464
684 134 7 Pier 33 (Embarcadero)   89 19 111 124 286 110 491
686 134 7 Department of Public Health (101 Grove Street at Polk, Civic Center)   89 19 111 124 286 110 491
687 134 7 United Nations Plaza (Civic Center) United Nations Plaza was built in 1975 and across its walkways are white lines into which the preamble to the preamble of the UN charter is carved. 89 19 111 124 286 110 491
688 134 7 Transamerica Building (600 Montgomery Street at Clay) The Pyramid was the tallest skyscraper west of the Mississippi from 1972-1974, until it was surpassed by Los Angeles' Aon Center. 89 19 111 124 286 110 491
689 134 7 San Francisco Drydock (20th and Illinois Streets)   89 19 111 124 286 110 491
690 134 7 Ramada Plaza Hotel Downtown (1231 Market Street, Civic Center)   89 19 111 124 286 110 491
691 134 7 Postcard Row (Alamo Square, Hayes Valley) The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. 89 19 111 124 286 110 491
692 134 7 Lafayette Park (Pacific Heights)   89 19 111 124 286 110 491
693 134 7 Hamlin Hotel (385 Eddy Street)   89 19 111 124 286 110 491
694 134 7 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. 89 19 111 124 286 110 491
695 134 7 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 89 19 111 124 286 110 491
696 134 7 Broadway Tunnel (Russian Hill)   89 19 111 124 286 110 491
697 134 7 Bimbo's 365 Club (1025 Columbus Avenue, North Beach)   89 19 111 124 286 110 491
698 134 7 720 Steiner Street (Hayes Valley)   89 19 111 124 286 110 491
699 134 7 32 Napier Lane   89 19 111 124 286 110 491
700 134 7 1227 Montgomery Street (Telegraph Hill)   89 19 111 124 286 110 491
994 181 60     113 19 103 156 351 138 362
1451 272 42     160 19 224 235 90 209  
1516 287 74     168 19 235 39 90 222 209
1621 306 31     179 19 249 265 437 236 551
Powered by Datasette · Query took 1.346ms · Data source: data.sfgov.org