sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
9 2 2     2 1 2   238    
10 3 3 The Walden House, Buena Vista Park Established in 1867, Buena Vista Park is the oldest official park in San Francisco. 3 2 3 2 239 2  
11 3 3 Café Trieste (609 Vallejo) Francis Ford Coppola allegedly wrote large portions of "The Godfather" trilogy in Café Trieste. 3 2 3 2 239 2  
13 5 5 Rainforest Café (145 Jefferson Street)   5 4 5 4 240 4  
14 6 6 20th and Folsom Streets   6 5 6 5 241 5  
15 6 6 Golden Gate Park During San Francisco's Gold Rush era, the Park was part of an area designated as the "Great Sand Waste". 6 5 6 5 241 5  
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  
20 8 8 75 California Street   4 3 8 7 243 7  
21 9 8 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 4 3 8 7 243 7  
22 9 8 Hills Brothers Plaza (Embarcadero at Harrison Street)   4 3 8 7 243 7  
23 9 8 San Francisco International Airport SFO has a museum dedicated to aviation history. 4 3 8 7 243 7  
26 11 10 420 Jones St. at Ellis St.   9 8 10 9 245 9  
36 12 11 Broderick from Fulton to McAlister   10 9 11 10 246 10  
37 12 11 Crissy Field   10 9 11 10 246 10  
38 12 11 Powell from Bush and Sutter   10 9 11 10 246 10  
45 15 13 Filbert St. from Jones to Mason   12 11 14 13 249 13  
46 15 13 Leavenworth from Filbert & Francisco St   12 11 14 13 249 13  
47 15 13 Chestnut St. from Larkin to Columbus   12 11 14 13 249 13  
48 15 13 Francisco St from Larkin to Polk   12 11 14 13 249 13  
49 15 13 Broadway from Mason to Taylor   12 11 14 13 249 13  
50 15 13 Taylor St. from Broadway to Filbert   12 11 14 13 249 13  
51 11 10 Broadway between Powell and Davis Driving shots 9 8 10 9 245 9  
58 19 5     16   18 17 253 17  
76 21 17     18 3 4 3 3 19  
77 11 10 Conzelman Rd at McCollough Rd and down Conzelman Rd. Aerial shots 9 8 10 9 245 9  
78 11 10 Lombard at Hyde   9 8 10 9 245 9  
79 11 10 601 Buena Vista Ave West at Java St.   9 8 10 9 245 9  
80 11 10 Columbus between Bay and Washington Driving shots 9 8 10 9 245 9  
81 11 10 California between Kearney and Davis Driving shots 9 8 10 9 245 9  
82 11 10 Pine between Kearney and Davis Driving shots 9 8 10 9 245 9  
83 11 10 Market between Stuart and Van Ness Driving shots 9 8 10 9 245 9  
84 11 10 Grant between Bush and Broadway Driving shots 9 8 10 9 245 9  
85 11 10 Intersection of Broadway at Kearney Driving shots 9 8 10 9 245 9  
86 11 10 Intersection of California at Polk Driving shots 9 8 10 9 245 9  
87 11 10 Treasure Island, Building #1, Ave of the Palms Aerial and exterior shots 9 8 10 9 245 9  
88 22 18 Ocean Beach On Jan. 25, 1878, the King Philip ship crashed in Ocean Beach. Occasionally, the ship's wreckage may be found on the beach-- most recently it was seen in 2007. 19 15 20 19 255    
89 23 7 Hyde Street Cable Car SF Cable Cars are the only moving National Historical Landmark. 20 16 21 20 256    
90 24 19     21 17 22 21 257 20  
121 31 25 1155 Filbert Street at Hyde   14 13 29 28 263 27  
122 31 25 Washington Square Park (Filbert, between Stockton and Powell)   14 13 29 28 263 27  
123 31 25 Vaillancourt Fountain (Justin Herman Plaza) Installed in 1975, the Vaillancourt Fountain is officially titled, "Québec Libre!". The night before the sculpture's inauguration, artist Armand Vaillancourt inscribed "Québec libre!" in red letters on the sculpture. The next day when he noticed that the note had been erased, Vaillancourt jumped on the statue to re-inscribe his message. 14 13 29 28 263 27  
124 31 25 Montgomery & Market Streets   14 13 29 28 263 27  
125 31 25 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. 14 13 29 28 263 27  
126 32 2     28 24 30 29 264 28  
127 33 26 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. 29 25 31 30 265    
128 33 26 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. 29 25 31 30 265    
129 33 26 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. 29 25 31 30 265    
130 33 26 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. 29 25 31 30 265    
131 33 26 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 29 25 31 30 265    
184 39 25 1122 Folsom Street   34 28 37 36 271 34  
185 39 25 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. 34 28 37 36 271 34  
186 39 25 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. 34 28 37 36 271 34  
187 39 25 Fisherman's Wharf Supposedly, Mikhail S. Gorbachev has said that his favorite part of visiting America was touring Fisherman's Wharf. 34 28 37 36 271 34  
188 39 25 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 34 28 37 36 271 34  
189 39 25 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. 34 28 37 36 271 34  
190 39 25 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. 34 28 37 36 271 34  
191 39 25 Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. 34 28 37 36 271 34  
192 39 25 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 34 28 37 36 271 34  
193 39 25 Aquatic Park (Jefferson Street) Located at one end of Fisherman's Wharf, Aquatic Park was built as part of FDR's Works Progress Administration Project. 34 28 37 36 271 34  
194 39 25 Alcatraz Island Alcatraz Island was a military fort before it became a prison. 34 28 37 36 271 34  
195 39 25 628 Cole Street   34 28 37 36 271 34  
196 40 19 Ina Coolbrith Park (1700 Taylor Street)   35   38 37      
197 40 19 0-100 block Halleck Street   35   38 37      
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  
238 44 33 The Lexington Club (3464 19th Street at Lexington)   39 31 42 41 275    
239 44 33 Royan Hotel (405 Valencia Street, Mission District)   39 31 42 41 275    
240 44 33 Department of Public Health (101 Grove Street at Polk, Civic Center)   39 31 42 41 275    
252 47 35 Mission Dolores Park (Mission District) via J-Church MUNI Train 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. 5 4 45 44 278 40  
324 58 7     44 35 53 54 281    
370 62 3 387 Fair Oaks at 25th Street   46 37 56 56 65 44  
371 63 36 Transbay Terminal (Mission Street at 1st Street) Built in 1939, the Terminal linked San Francisco, the East Bay, and Sacramento by rail for the first time. 47 38 57 57 282 45  
372 63 36 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. 47 38 57 57 282 45  
373 63 36 22nd and Carolina Streets (Potrero Hill)   47 38 57 57 282 45  
374 64 18 San Francisco Public Library Main Branch (100 Larkin Street)   48 6 58 58 216 46  
375 65 37 Mission Dolores (3321 16th Street, Mission District) Mission Dolores' official name is Mission San Francisco de Assis. It is the oldest building in San Francisco, built in 1791, and has survived two major earthquakes. 49 13 59 59 178 47  
376 65 37 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. 49 13 59 59 178 47  
377 65 37 Bix Restaurant (56 Gold Street)   49 13 59 59 178 47  
378 66 35 The Castro From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry. 50 39 60 60 283 48  
379 67 38     51 40 61   284 49  
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  
388 70 13 Palace of Fine Arts   53 22 64 63 287 52  
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  
415 78 42 Washington Square, North Beach   59 30 71 71 295 60  
416 78 42 The Embarcadero   59 30 71 71 295 60  
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  
418 78 42 San Francisco Drydock (20th and Illinois Streets)   59 30 71 71 295 60  
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  
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  
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  
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  
Powered by Datasette · Query took 1.447ms · Data source: data.sfgov.org