sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 31 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
52 16 14 Cliff House (1090 Point Lobos Avenue) In 1887, the Cliff House was severely damaged when the schooner Parallel, abandoned and loaded with dynamite, ran aground on the rocks below. 13 12 15 14 250 14 443
53 16 14 San Francisco Bay   13 12 15 14 250 14 443
54 16 14 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. 13 12 15 14 250 14 443
142 35 28     13 12 33 32 267 30 454
640 118 54     13 12 110 109 14 94 485
648 122 55 Hyatt Regency Hotel (5 Embarcadero Center)   13 12 114 113 323 98 486
649 122 55 Fort Point (Presidio, Golden Gate National Recreation Area) Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF. 13 12 114 113 323 98 486
650 122 55 Conservatory of Flowers, Golden Gate Park The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. 13 12 114 113 323 98 486
651 123 3 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. 13 12 114 113 323 98  
653 123 3 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. 13 12 114 113 323 98  
654 123 3 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square". 13 12 114 113 323 98  
655 123 3 Maiden Lane   13 12 114 113 323 98  
656 123 3 Condor Club (Columbus and Broadway)   13 12 114 113 323 98  
657 123 3 Chase H & Q (1 Bush Street at Sansome)   13 12 114 113 323 98  
661 127 18 Marriot Hotel (55 4th Street at Market)   13 12 118 117 325 103  
905 170 46 1200 Washington Street at Taylor Street   13 12 31 149 265 100 501
906 170 46 Hancock School (940 Filbert Street)   13 12 31 149 265 100 501
907 170 46 Danilo's Bakery (Green Street & Bannam Place)   13 12 31 149 265 100 501
908 170 46 Chrissy Field Chrissy Field was originally an airfield for the Presidio Army Base. 13 12 31 149 265 100 501
909 170 46 520-522A Green Street at Grant Street   13 12 31 149 265 100 501
910 170 46 516 Green Street   13 12 31 149 265 100 501
911 170 46 100 Embarcadero Street   13 12 31 149 265 100 501
992 179 34 Albert S. Samuels Clock (856 Market Street between Powell and Stockton)   13 12 90 91 349 136 504
999 183 17 Texas & 19th Streets (Potrero Hill)   115 12 152 158 353 140  
1000 183 17 Financial District   115 12 152 158 353 140  
1001 183 17 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 115 12 152 158 353 140  
1282 237 47 Powell Street   13 12 195 207 393 181 526
1424 261 27 Grant Ave from Sacramento to Clay   14 12 216 227 406 199 535
1425 261 27 Montgomery and Union St.   13 12 216 227 406 199 535
1426 261 27 Epic Roasthouse   13 12 216 227 406 199 535
1427 261 27 Players Arcade at Pier 39   13 12 216 227 406 199 535
Powered by Datasette · Query took 1.223ms · Data source: data.sfgov.org