Film_Locations_in_San_Francisco

Data source: data.sfgov.org

1,622 rows sorted by Release Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid Title Release Year ▲ Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1622 1622 Zodiac 307 2007 75 SF Chronicle Building (901 Mission St)   Paramount Pictures 4 Paramount Pictures 3 David Fincher 213 James Vanderbilt 266 Jake Gyllenhaal 438 Mark Ruffalo 118  
1516 1516 They Call Me MISTER Tibbs 287 1970 74     Mirisch Corporation 168 United Artists 19 Gordon Douglas 235 Alan R. Trustman 39 Sidney Poitier 90 Martin Landau 222 Barbara McNair 209
1495 1495 The Ten Commandments 282 1956 73 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Exteriors of the church were used. Paramount Pictures 4 Paramount Pictures 3 Cecil B. DeMille 231 Jesse L. Lasky, Jr. 243 Charlton Heston 419 Yul Brynner 218 Anne Baxter 15
1580 1580 Vertigo 298 1958 72 1007 Gough Street Tennis courts now sit on the site; in the movie the structure was Carlota Valdes' home. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1579 1579 Vertigo 298 1958 72 900 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. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1578 1578 Vertigo 298 1958 72 Brocklebank Apartments (1000 Mason Street)   Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1577 1577 Vertigo 298 1958 72 California Palace of the Legion of Honor (34th Avenue & Clement, Lincoln Park) Built in 1924, the Legion of Honor is a 3/4 replica of the Parisian Palais de la Legion d'Honneur. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1576 1576 Vertigo 298 1958 72 Claude Lane at Bush Street   Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1575 1575 Vertigo 298 1958 72 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1574 1574 Vertigo 298 1958 72 Ernie's Restaurant (847 Montgomery Street) Called the "Essex Club" in the film. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1573 1573 Vertigo 298 1958 72 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. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1572 1572 Vertigo 298 1958 72 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. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1571 1571 Vertigo 298 1958 72 Gough & Eddy Streets (Western Addition)   Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1570 1570 Vertigo 298 1958 72 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. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1569 1569 Vertigo 298 1958 72 Mission San Juan Bautista (2nd & Mariposa Streets)   Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1568 1568 Vertigo 298 1958 72 Park Hill Sanatorium (351 Buena Vista Avenue East) This location is now a condominium complex. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1567 1567 Vertigo 298 1958 72 San Francisco Drydock (20th and Illinois Streets)   Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1566 1566 Vertigo 298 1958 72 York Hotel (940 Sutter Street)   Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1565 1565 Vertigo 298 1958 72 Palace of Fine Arts (3301 Lyon Street) The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1440 1440 The Lineup 265 1958 72 2090 Jackson Street   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1439 1439 The Lineup 265 1958 72 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. Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1438 1438 The Lineup 265 1958 72 Pier 41   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1437 1437 The Lineup 265 1958 72 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. Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1436 1436 The Lineup 265 1958 72 Sutro Baths (Point Lobos Avenue)   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1435 1435 The Lineup 265 1958 72 The Embarcadero   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1434 1434 The Lineup 265 1958 72 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1428 1428 The Jazz Singer 262 1927 71 Coffee Dan's (O'Farrell Street at Powell)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Alan Crosland 217 Alfred A. Cohn 228 Al Jolson 407 May McAvoy 200 Warner Oland 536
1423 1423 The House on Telegraph Hill 260 1951 70 1227 Montgomery Street   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534
1422 1422 The House on Telegraph Hill 260 1951 70 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. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534
1421 1421 The House on Telegraph Hill 260 1951 70 Market Street   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534
1420 1420 The House on Telegraph Hill 260 1951 70 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534
1329 1329 The Caine Mutiny 245 1954 69 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. Stanley Kramer Productions 113 Columbia Pictures 4 Edward Dmytryk 201 Stanley Roberts 212 Humphrey Bogart 289 Fred MacMurray 188 Jose Ferrer 529
1328 1328 The Caine Mutiny 245 1954 69 The Embarcadero   Stanley Kramer Productions 113 Columbia Pictures 4 Edward Dmytryk 201 Stanley Roberts 212 Humphrey Bogart 289 Fred MacMurray 188 Jose Ferrer 529
1482 1482 The Pursuit of Happyness 277 2006 68 Golden Gate Park Children's Playground Golden Gate Park is similar in shape but 20% larger than New York's Central Park. Columbia Pictures Corporation 5 Columbia Pictures 4 Steven Conrad 227 Gabriele Muccino 202 Will Smith 416 Jayden C. Smith 213  
1480 1480 The Pursuit of Happyness 277 2006 68 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. Columbia Pictures Corporation 5 Columbia Pictures 4 Steven Conrad 227 Gabriele Muccino 202 Will Smith 416 Jayden C. Smith 213  
1479 1479 The Pursuit of Happyness 277 2006 68 Glide Memorial Church (434 Ellis St)   Columbia Pictures Corporation 5 Columbia Pictures 4 Steven Conrad 227 Gabriele Muccino 202 Will Smith 416 Jayden C. Smith 213  
1478 1478 The Pursuit of Happyness 277 2006 68 Glen Park Subway Station   Columbia Pictures Corporation 5 Columbia Pictures 4 Steven Conrad 227 Gabriele Muccino 202 Will Smith 416 Jayden C. Smith 213  
1327 1327 The Bridge 244 2006 68 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. Easy There Tiger Productions 148 IFC Films 106 Eric Steel 200   John Snowden 395    
1326 1326 The Birds 243 1963 67 Powell and Geary Streets (Union Square) The pet shop featured in the film does not exist, but was based on the now-closed Robison's House of Pets formerly located on Maiden Lane. Universal Pictures 15 Universal Pictures 41 Alfred Hitchcock 81 Evan Hunter 211 Tippi Hedren 116 Suzanne Pleshette 187 Rod Taylor 528
1285 1285 Take the Money and Run 238 1969 66 Bank of America (1455 Stockton Street)   American Broadcasting Company (ABC) 144 Cinerama Releasing Corporation 103 Woody Allen 36 Woody Allen 35 Woody Allen 360 Janet Margolin 182  
1284 1284 Take the Money and Run 238 1969 66 Golden Gate Park   American Broadcasting Company (ABC) 144 Cinerama Releasing Corporation 103 Woody Allen 36 Woody Allen 35 Woody Allen 360 Janet Margolin 182  
1283 1283 Take the Money and Run 238 1969 66 Mission Street   American Broadcasting Company (ABC) 144 Cinerama Releasing Corporation 103 Woody Allen 36 Woody Allen 35 Woody Allen 360 Janet Margolin 182  
1486 1486 The Right Stuff 279 1983 65 Financial District   The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1485 1485 The Right Stuff 279 1983 65 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. The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1484 1484 The Right Stuff 279 1983 65 Cow Palace Supposedly, the Cow Palace's name derives from a newspaper editorial in which the writer wonders whether the soon-to-be-built structure for livestock was a "palace for cows". The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1483 1483 The Right Stuff 279 1983 65 American Can Company (Between Illinois & Kentucky, 20th and 22nd Streets)   The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1254 1254 Sudden Impact 231 1983 65 Pier 38-40, The Embarcadero   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1253 1253 Sudden Impact 231 1983 65 Bowles Franklin Galleries (765 Beach Street, Fisherman's Wharf)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1252 1252 Sudden Impact 231 1983 65 The Embarcadero/Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1251 1251 Sudden Impact 231 1983 65 Civic Center Plaza   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1250 1250 Sudden Impact 231 1983 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1249 1249 Sudden Impact 231 1983 65 Ferry Plaza Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1248 1248 Sudden Impact 231 1983 65 Hall of Justice (850 Bryant Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1247 1247 Sudden Impact 231 1983 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1246 1246 Sudden Impact 231 1983 65 McDonald's Restaurant (701 3rd Street, SOMA)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1245 1245 Sudden Impact 231 1983 65 Mt. Davidson Mt. Davidson is highest point in San Francisco (938 feet). Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1244 1244 Sudden Impact 231 1983 65 Near Point Lobos, El Camino Del Mar   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176  
1243 1243 Sudden Fear 230 1952 64 2800 Scott Street   Joseph Kaufmann Pictures 140 RKO Pictures 87 David Miller 141 Lenore J. Coffee 201 Joan Crawford 387 Jack Palance 175 Gloria Grahame 521
1242 1242 Sudden Fear 230 1952 64 Brocklebank Apartments (1000 Mason Street)   Joseph Kaufmann Pictures 140 RKO Pictures 87 David Miller 141 Lenore J. Coffee 201 Joan Crawford 387 Jack Palance 175 Gloria Grahame 521
1241 1241 Sudden Fear 230 1952 64 The Tamalpais Building (1201 Greenwich Street at Hyde)   Joseph Kaufmann Pictures 140 RKO Pictures 87 David Miller 141 Lenore J. Coffee 201 Joan Crawford 387 Jack Palance 175 Gloria Grahame 521
1240 1240 Sudden Fear 230 1952 64 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. Joseph Kaufmann Pictures 140 RKO Pictures 87 David Miller 141 Lenore J. Coffee 201 Joan Crawford 387 Jack Palance 175 Gloria Grahame 521
1445 1445 The Maltese Falcon 267 1941 63 Burritt Alley (Off Bush Street, between Powell and Stockton Streets)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 John Huston 220 John Huston 231 Humphrey Bogart 289 Mary Astor 204 Gladys George 541
1444 1444 The Maltese Falcon 267 1941 63 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Warner Bros. Pictures 38 Warner Bros. Pictures 6 John Huston 220 John Huston 231 Humphrey Bogart 289 Mary Astor 204 Gladys George 541
1443 1443 The Maltese Falcon 267 1941 63 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 John Huston 220 John Huston 231 Humphrey Bogart 289 Mary Astor 204 Gladys George 541
1160 1160 Shadow of the Thin Man 214 1941 63 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. Metro-Goldwyn Mayer 8 Metro-Goldwyn Mayer 10 W.S. Van Dyke 12 Harry Kurnitz 186 William Powell 247 Myrna Loy 11 Barry Nelson 515
1589 1589 What's Up Doc? 301 1972 62 22nd Avenue & Balboa Street (Richmond District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1588 1588 What's Up Doc? 301 1972 62 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1587 1587 What's Up Doc? 301 1972 62 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1586 1586 What's Up Doc? 301 1972 62 Hyde Street Pier   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1585 1585 What's Up Doc? 301 1972 62 Lombard Street between Hyde and Leavenworth   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1584 1584 What's Up Doc? 301 1972 62 San Francisco Hilton (333 O'Farrell Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1583 1583 What's Up Doc? 301 1972 62 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1331 1331 The Candidate 247 1972 62 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. Redford-Ritchie Productions 150 Warner Bros. Pictures 6 Michael Ritchie 203 Jeremy Larner 214 Robert Redford 169 Peter Boyle 189  
1028 1028 Play it Again, Sam 191 1972 62 15-17 Fresno Street   Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
1027 1027 Play it Again, Sam 191 1972 62 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. Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
1026 1026 Play it Again, Sam 191 1972 62 Hyde Street Cable Car   Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
1025 1025 Play it Again, Sam 191 1972 62 Surf Theater (4520 Irving Street)   Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
1024 1024 Play it Again, Sam 191 1972 62 The Music Concourse (Martin Luther King, Jr. Drive, Golden Gate Park) The theater closed in 1985. Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
1023 1023 Play it Again, Sam 191 1972 62 Balboa at 22nd Avenue   Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
1004 1004 Pal Joey 184 1957 61 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. Columbia Pictures Corporation 5 Columbia Pictures 4 George Sidney 153 Dorothy Kingsley 159 Rita Hayworth 354 Frank Sinatra 141 Kim Novak 231
1003 1003 Pal Joey 184 1957 61 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. Columbia Pictures Corporation 5 Columbia Pictures 4 George Sidney 153 Dorothy Kingsley 159 Rita Hayworth 354 Frank Sinatra 141 Kim Novak 231
1002 1002 Pal Joey 184 1957 61 Spreckels Mansion (2080 Washington Street, Pacific Heights)   Columbia Pictures Corporation 5 Columbia Pictures 4 George Sidney 153 Dorothy Kingsley 159 Rita Hayworth 354 Frank Sinatra 141 Kim Novak 231
994 994 On the Beach 181 1959 60     Stanley Kramer Productions 113 United Artists 19 Stanley Kramer 103 John Paxton 156 Gregory Peck 351 Ava Gardner 138 Fred Astaire 362
899 899 Milk 166 2008 59 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. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
898 898 Milk 166 2008 59 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
896 896 Milk 166 2008 59 Lower Haight Street   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
895 895 Milk 166 2008 59 Marine Fireman's Union Headquarters   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
894 894 Milk 166 2008 59 Market & Castro Street From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
893 893 Milk 166 2008 59 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. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
892 892 Milk 166 2008 59 El Camino Del Mar   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
891 891 Milk 166 2008 59 29th and Dolores Street   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
890 890 Milk 166 2008 59 424 Sansome Street   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
889 889 Milk 166 2008 59 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
888 888 Milk 166 2008 59 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. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
887 887 Milk 166 2008 59 Duboce Park   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
886 886 Midnight Lace 165 1960 58 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. Arwin Productions 105 Universal Pictures 41 David Miller 141 Ivan Goff 144 Doris Day 341 Rex Harrison 127 John Gavin 500
704 704 It Came From Beneath the Sea 136 1955 57 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. Clover Productions 91 Columbia Pictures 4 Robert Gordon 126 George Worthing Yates 126 Kenneth Tobey 330 Faith Domergue 111 Donald Curtis 492
703 703 It Came From Beneath the Sea 136 1955 57 Chrissy Field 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. Clover Productions 91 Columbia Pictures 4 Robert Gordon 126 George Worthing Yates 126 Kenneth Tobey 330 Faith Domergue 111 Donald Curtis 492
702 702 It Came From Beneath the Sea 136 1955 57 Hunters Point 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. Clover Productions 91 Columbia Pictures 4 Robert Gordon 126 George Worthing Yates 126 Kenneth Tobey 330 Faith Domergue 111 Donald Curtis 492
1543 1543 To the Ends of the Earth 291 1948 56     Kennedy-Buckman Pictures 169 Columbia Pictures 4 Robert Stevenson 112 Jay Richard Kennedy 251 Dick Powell 427 Signe Hasso 226 Maylia 547

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");
Powered by Datasette · Query took 93.863ms · Data source: data.sfgov.org