Data source: data.sfgov.org
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1621 | 1621 | Yours, Mine and Ours 306 | 1968 31 | Desilu Productions 179 | United Artists 19 | Melville Shavelson 249 | Bob Carroll, Jr. 265 | Lucille Ball 437 | Henry Fonda 236 | Van Johnson 551 | ||
1620 | 1620 | Woman on Top 305 | 2000 25 | 312 Fillmore Street | Fox Searchlight Pictures 178 | Fox Searchlight Pictures 24 | Fina Torres 248 | Vera Blasi 264 | Penelope Cruz 436 | |||
1619 | 1619 | Woman on the Run 304 | 1950 15 | Cable Car Signal Box (California Street at Powell Street) | SF Cable Cars are the only moving National Historical Landmark. | Fidelity Pictures Corporation 177 | Universal Pictures 41 | Norman Foster 247 | Norman Foster 263 | Ann Sheridan 350 | Dennis O'Keefe 235 | Robert Keith 202 |
1618 | 1618 | Woman on the Run 304 | 1950 15 | 1801 Laguna at Bush | Fidelity Pictures Corporation 177 | Universal Pictures 41 | Norman Foster 247 | Norman Foster 263 | Ann Sheridan 350 | Dennis O'Keefe 235 | Robert Keith 202 | |
1617 | 1617 | Woman on the Run 304 | 1950 15 | 772 Commercial Street at Kearney | Called "Man Loh's Oriental Roof Garden" in the film. | Fidelity Pictures Corporation 177 | Universal Pictures 41 | Norman Foster 247 | Norman Foster 263 | Ann Sheridan 350 | Dennis O'Keefe 235 | Robert Keith 202 |
1616 | 1616 | Woman on the Run 304 | 1950 15 | 819 Mason Street at Pine | Fidelity Pictures Corporation 177 | Universal Pictures 41 | Norman Foster 247 | Norman Foster 263 | Ann Sheridan 350 | Dennis O'Keefe 235 | Robert Keith 202 | |
1615 | 1615 | Woman on the Run 304 | 1950 15 | 835-865 Market Street at 5th Street | The Emporium, a department store, stood in this location. Bloomingdale's is now located here. | Fidelity Pictures Corporation 177 | Universal Pictures 41 | Norman Foster 247 | Norman Foster 263 | Ann Sheridan 350 | Dennis O'Keefe 235 | Robert Keith 202 |
1614 | 1614 | Woman on the Run 304 | 1950 15 | Former Hall of Justice (750 Kearny Street at Washington) | Fidelity Pictures Corporation 177 | Universal Pictures 41 | Norman Foster 247 | Norman Foster 263 | Ann Sheridan 350 | Dennis O'Keefe 235 | Robert Keith 202 | |
1597 | 1597 | When a Man Loves a Woman 302 | 1994 48 | 1521 Masonic Avenue at Piedmont Street | Touchstone Pictures 104 | Buena Vista Pictures 25 | Luis Mandoki 246 | Ronald Bass 262 | Andy Garcia 58 | Meg Ryan 46 | ||
1596 | 1596 | When a Man Loves a Woman 302 | 1994 48 | 766 Vallejo Street at Stockton Street (North Beach) | Touchstone Pictures 104 | Buena Vista Pictures 25 | Luis Mandoki 246 | Ronald Bass 262 | Andy Garcia 58 | Meg Ryan 46 | ||
1595 | 1595 | When a Man Loves a Woman 302 | 1994 48 | Cybelle's Pizza (1000 Bush Street) | Touchstone Pictures 104 | Buena Vista Pictures 25 | Luis Mandoki 246 | Ronald Bass 262 | Andy Garcia 58 | Meg Ryan 46 | ||
1594 | 1594 | When a Man Loves a Woman 302 | 1994 48 | Grant Street at Pacific Avenue | Touchstone Pictures 104 | Buena Vista Pictures 25 | Luis Mandoki 246 | Ronald Bass 262 | Andy Garcia 58 | Meg Ryan 46 | ||
1593 | 1593 | When a Man Loves a Woman 302 | 1994 48 | International Studies Academy (993 Vermont Street, Potrero Hill) | Touchstone Pictures 104 | Buena Vista Pictures 25 | Luis Mandoki 246 | Ronald Bass 262 | Andy Garcia 58 | Meg Ryan 46 | ||
1592 | 1592 | When a Man Loves a Woman 302 | 1994 48 | Spring Valley School (1451 Jackson Street) | Touchstone Pictures 104 | Buena Vista Pictures 25 | Luis Mandoki 246 | Ronald Bass 262 | Andy Garcia 58 | Meg Ryan 46 | ||
1591 | 1591 | When a Man Loves a Woman 302 | 1994 48 | Victor's Restaurant, The 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. | Touchstone Pictures 104 | Buena Vista Pictures 25 | Luis Mandoki 246 | Ronald Bass 262 | Andy Garcia 58 | Meg Ryan 46 | |
1590 | 1590 | When a Man Loves a Woman 302 | 1994 48 | Buena Vista Café (2765 Hyde Street) | Touchstone Pictures 104 | Buena Vista Pictures 25 | Luis Mandoki 246 | Ronald Bass 262 | Andy Garcia 58 | Meg Ryan 46 | ||
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 | |
1582 | 1582 | What the Bleep Do We Know 300 | 2004 5 | Golden Gate National Recreation Area | The size of the Recreation Area is over two and a half greater than that of the city and county of San Francisco. | Captured Light 175 | Samuel Goldwyn Films 118 | William Arntz 244 | William Arntz & Betsy Chasse 260 | Marlee Matlin 433 | ||
1581 | 1581 | What Dreams May Come 299 | 1998 18 | 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. | Polygram Filmed Entertainment 156 | Polygram Filmed Entertainment 110 | Vincent Ward 243 | Ron Bass 259 | Robin Williams 265 | Cuba Gooding, Jr. 232 | |
1564 | 1564 | Vegas in Space 297 | 1992 22 | Under Highway 101 (near Potrero and Cesar Chavez Streets) | Troma Entertainment 173 | MCA/Universal Home Video 117 | Phillip R. Ford 242 | Doris Fish 257 | Doris Fish 431 | Miss X 230 | Ginger Quest 549 | |
1563 | 1563 | Vegas in Space 297 | 1992 22 | 3567 18th Street | Troma Entertainment 173 | MCA/Universal Home Video 117 | Phillip R. Ford 242 | Doris Fish 257 | Doris Fish 431 | Miss X 230 | Ginger Quest 549 | |
1562 | 1562 | Vegas in Space 297 | 1992 22 | 422 Oak Street at Laguna | Troma Entertainment 173 | MCA/Universal Home Video 117 | Phillip R. Ford 242 | Doris Fish 257 | Doris Fish 431 | Miss X 230 | Ginger Quest 549 | |
1561 | 1561 | Vegas in Space 297 | 1992 22 | 544 Natoma (SOMA) | Troma Entertainment 173 | MCA/Universal Home Video 117 | Phillip R. Ford 242 | Doris Fish 257 | Doris Fish 431 | Miss X 230 | Ginger Quest 549 | |
1560 | 1560 | Vegas in Space 297 | 1992 22 | Corona Heights Park | Troma Entertainment 173 | MCA/Universal Home Video 117 | Phillip R. Ford 242 | Doris Fish 257 | Doris Fish 431 | Miss X 230 | Ginger Quest 549 | |
1559 | 1559 | Vegas in Space 297 | 1992 22 | Project Artaud (Florida Street) | Troma Entertainment 173 | MCA/Universal Home Video 117 | Phillip R. Ford 242 | Doris Fish 257 | Doris Fish 431 | Miss X 230 | Ginger Quest 549 | |
1558 | 1558 | Until the End of the World 296 | 1991 37 | Tosca Café (242 Columbus Avenue, North Beach) | Village Roadshow Pictures 172 | Warner Bros. Pictures 6 | Wim Wenders 241 | Wim Wenders 256 | Solveig Dommartin 430 | |||
1557 | 1557 | Under the Tuscan Sun 295 | 2003 38 | Mecca Restaurant (2029 Market Street) | Touchstone Pictures 104 | Buena Vista Pictures 25 | Audrey Wells 240 | Audrey Wells 255 | Diane Lane 112 | Sandra Oh 229 | ||
1546 | 1546 | Tweek City 294 | 2005 2 | Tweek City LLC 171 | Maverick Entertainment Group 116 | Eric G. Johnson 239 | Eric G. Johnson 254 | Giuseppe Andrews 429 | ||||
1544 | 1544 | True Believer 292 | 1989 35 | Columbia Pictures Corporation 5 | Columbia Pictures 4 | Joseph Ruben 238 | Wesley Strick 252 | James Woods 428 | Robert Downey, Jr. 227 | |||
1542 | 1542 | Tin Cup 290 | 1996 43 | Regency Enterprises 52 | Warner Bros. Pictures 6 | Ron Shelton 237 | John Norville 250 | Kevin Costner 426 | Rene Russo 225 | |||
1517 | 1517 | Thief of Hearts 288 | 1984 40 | Paramount Pictures 4 | Paramount Pictures 3 | Douglas Day Stewart 236 | Douglas Day Stewart 248 | Steven Bauer 424 | David Caruso 223 | Barbara Williams 545 | ||
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 | ||
1515 | 1515 | The Zodiac 286 | 2005 2 | Blackwater Films 167 | THINKFilm 104 | Alexander Bulkley 234 | Alexander Bulkley & Kelley Bulkeley 247 | Justin Chambers 423 | Robin Tunney 44 | |||
1514 | 1514 | The Woman In Red 285 | 1984 40 | Montgomery Street at Union Street | Orion Pictures Corp. 166 | MGM Home Entertainment 79 | Gene Wilder 233 | Jean Loup Dabadie & Yves Robert 246 | Gene Wilder 422 | Charles Grodin 221 | ||
1513 | 1513 | The Woman In Red 285 | 1984 40 | 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. | Orion Pictures Corp. 166 | MGM Home Entertainment 79 | Gene Wilder 233 | Jean Loup Dabadie & Yves Robert 246 | Gene Wilder 422 | Charles Grodin 221 | |
1512 | 1512 | The Woman In Red 285 | 1984 40 | Brocklebank Apartments (1000 Mason Street) | Orion Pictures Corp. 166 | MGM Home Entertainment 79 | Gene Wilder 233 | Jean Loup Dabadie & Yves Robert 246 | Gene Wilder 422 | Charles Grodin 221 | ||
1511 | 1511 | The Woman In Red 285 | 1984 40 | 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. | Orion Pictures Corp. 166 | MGM Home Entertainment 79 | Gene Wilder 233 | Jean Loup Dabadie & Yves Robert 246 | Gene Wilder 422 | Charles Grodin 221 | |
1510 | 1510 | The Wedding Planner 284 | 2001 33 | 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. | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 | |
1509 | 1509 | The Wedding Planner 284 | 2001 33 | Japanese Tea Garden (Hagiwara Tea Garden Drive, Golden Gate Park) | The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 | |
1508 | 1508 | The Wedding Planner 284 | 2001 33 | Lincoln Park | The land on which the park stands was a cemetery until the late 1860s. | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 | |
1507 | 1507 | The Wedding Planner 284 | 2001 33 | Montgomery Street at Union Street | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 | ||
1506 | 1506 | The Wedding Planner 284 | 2001 33 | Pier 7 (The Embarcadero) | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 | ||
1505 | 1505 | The Wedding Planner 284 | 2001 33 | Pleasant Street at Taylor | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 | ||
1504 | 1504 | The Wedding Planner 284 | 2001 33 | The Music Concourse (Martin Luther King, Jr. Drive, Golden Gate Park) | Golden Gate Park is similar in shape but 20% larger than New York's Central Park. | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 | |
1503 | 1503 | The Wedding Planner 284 | 2001 33 | Grace Cathedral Episcopal Church (1100 California Street) | Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 | |
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 |
1494 | 1494 | The Sweetest Thing 281 | 2002 3 | Golden Gate National Recreation Area | The size of the Recreation Area is over two and a half greater than that of the city and county of San Francisco. | Columbia Pictures Corp. 93 | Columbia Pictures 4 | Roger Kumble 230 | Nancy M. Pimental 242 | Cameron Diaz 418 | Christina Applegate 217 | |
1493 | 1493 | The Rock 280 | 1996 43 | Alcatraz Island | Alcatraz Island was a military fort before it became a prison. | Hollywood Pictures 95 | Buena Vista Pictures 25 | Michael Bay 229 | David Weisberg 241 | Sean Connery 107 | Nicolas Cage 216 | |
1492 | 1492 | The Rock 280 | 1996 43 | 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. | Hollywood Pictures 95 | Buena Vista Pictures 25 | Michael Bay 229 | David Weisberg 241 | Sean Connery 107 | Nicolas Cage 216 | |
1491 | 1491 | The Rock 280 | 1996 43 | 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. | Hollywood Pictures 95 | Buena Vista Pictures 25 | Michael Bay 229 | David Weisberg 241 | Sean Connery 107 | Nicolas Cage 216 | |
1490 | 1490 | The Rock 280 | 1996 43 | 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. | Hollywood Pictures 95 | Buena Vista Pictures 25 | Michael Bay 229 | David Weisberg 241 | Sean Connery 107 | Nicolas Cage 216 | |
1489 | 1489 | The Rock 280 | 1996 43 | New Russian Hill Market (1198 Pacific Avenue at Jones) | Hollywood Pictures 95 | Buena Vista Pictures 25 | Michael Bay 229 | David Weisberg 241 | Sean Connery 107 | Nicolas Cage 216 | ||
1488 | 1488 | The Rock 280 | 1996 43 | The San Francisco Bay | Hollywood Pictures 95 | Buena Vista Pictures 25 | Michael Bay 229 | David Weisberg 241 | Sean Connery 107 | Nicolas Cage 216 | ||
1487 | 1487 | The Rock 280 | 1996 43 | 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. | Hollywood Pictures 95 | Buena Vista Pictures 25 | Michael Bay 229 | David Weisberg 241 | Sean Connery 107 | Nicolas Cage 216 | |
1502 | 1502 | The Towering Inferno 278 | 1974 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. | Irwin Allen Productions 162 | Twentieth Century - Fox 112 | John Guillermin 228 | Stirling Silliphant 222 | Steve McQueen 273 | Paul Newman 214 | William Holden 542 |
1501 | 1501 | The Towering Inferno 278 | 1974 49 | Firestation #38 (California & Laguna) | Irwin Allen Productions 162 | Twentieth Century - Fox 112 | John Guillermin 228 | Stirling Silliphant 222 | Steve McQueen 273 | Paul Newman 214 | William Holden 542 | |
1500 | 1500 | The Towering Inferno 278 | 1974 49 | Grace Cathedral Episcopal Church (1100 California Street) | Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. | Irwin Allen Productions 162 | Twentieth Century - Fox 112 | John Guillermin 228 | Stirling Silliphant 222 | Steve McQueen 273 | Paul Newman 214 | William Holden 542 |
1499 | 1499 | The Towering Inferno 278 | 1974 49 | Hyatt Regency Hotel (5 Embarcadero Center, Financial District) | Irwin Allen Productions 162 | Twentieth Century - Fox 112 | John Guillermin 228 | Stirling Silliphant 222 | Steve McQueen 273 | Paul Newman 214 | William Holden 542 | |
1498 | 1498 | The Towering Inferno 278 | 1974 49 | San Francisco Fire Station 38 (2150 California Street, Pacific Heights) | Irwin Allen Productions 162 | Twentieth Century - Fox 112 | John Guillermin 228 | Stirling Silliphant 222 | Steve McQueen 273 | Paul Newman 214 | William Holden 542 | |
1497 | 1497 | The Towering Inferno 278 | 1974 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. | Irwin Allen Productions 162 | Twentieth Century - Fox 112 | John Guillermin 228 | Stirling Silliphant 222 | Steve McQueen 273 | Paul Newman 214 | William Holden 542 |
1481 | 1481 | The Towering Inferno 278 | 1974 49 | 2898 Vallejo Street | Irwin Allen Productions 162 | Twentieth Century - Fox 112 | John Guillermin 228 | Stirling Silliphant 222 | Steve McQueen 273 | Paul Newman 214 | William Holden 542 | |
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 | ||
1470 | 1470 | The Presidio 275 | 1988 23 | 200 Block of Sansome Street (Financial District) | Paramount Pictures 4 | Paramount Pictures 3 | Peter Hyams 226 | Larry Ferguson 238 | Sean Connery 107 | Mark Harmon 211 | Meg Ryan 46 | |
1469 | 1469 | The Presidio 275 | 1988 23 | 700 Block of Jackson Street (Chinatown) | Paramount Pictures 4 | Paramount Pictures 3 | Peter Hyams 226 | Larry Ferguson 238 | Sean Connery 107 | Mark Harmon 211 | Meg Ryan 46 | |
1468 | 1468 | The Presidio 275 | 1988 23 | 900 Block of Grant Avenue (Chinatown) | Paramount Pictures 4 | Paramount Pictures 3 | Peter Hyams 226 | Larry Ferguson 238 | Sean Connery 107 | Mark Harmon 211 | Meg Ryan 46 | |
1467 | 1467 | The Presidio 275 | 1988 23 | Battery Street (The Embarcadero) | Paramount Pictures 4 | Paramount Pictures 3 | Peter Hyams 226 | Larry Ferguson 238 | Sean Connery 107 | Mark Harmon 211 | Meg Ryan 46 | |
1466 | 1466 | The Presidio 275 | 1988 23 | Civic Center Plaza | Paramount Pictures 4 | Paramount Pictures 3 | Peter Hyams 226 | Larry Ferguson 238 | Sean Connery 107 | Mark Harmon 211 | Meg Ryan 46 | |
1465 | 1465 | The Presidio 275 | 1988 23 | 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. | Paramount Pictures 4 | Paramount Pictures 3 | Peter Hyams 226 | Larry Ferguson 238 | Sean Connery 107 | Mark Harmon 211 | Meg Ryan 46 |
1464 | 1464 | The Presidio 275 | 1988 23 | Ferry Building | Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. | Paramount Pictures 4 | Paramount Pictures 3 | Peter Hyams 226 | Larry Ferguson 238 | Sean Connery 107 | Mark Harmon 211 | Meg Ryan 46 |
1463 | 1463 | The Presidio 275 | 1988 23 | 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. | Paramount Pictures 4 | Paramount Pictures 3 | Peter Hyams 226 | Larry Ferguson 238 | Sean Connery 107 | Mark Harmon 211 | Meg Ryan 46 |
1462 | 1462 | The Presidio 275 | 1988 23 | 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. | Paramount Pictures 4 | Paramount Pictures 3 | Peter Hyams 226 | Larry Ferguson 238 | Sean Connery 107 | Mark Harmon 211 | Meg Ryan 46 |
1461 | 1461 | The Presidio 275 | 1988 23 | Hayes & Polk Streets (Civic Center) | Paramount Pictures 4 | Paramount Pictures 3 | Peter Hyams 226 | Larry Ferguson 238 | Sean Connery 107 | Mark Harmon 211 | Meg Ryan 46 | |
1460 | 1460 | The Presidio 275 | 1988 23 | Market & 2nd Streets | Paramount Pictures 4 | Paramount Pictures 3 | Peter Hyams 226 | Larry Ferguson 238 | Sean Connery 107 | Mark Harmon 211 | Meg Ryan 46 | |
1459 | 1459 | The Presidio 275 | 1988 23 | Montgomery & Vallejo Streets (Telegraph Hill) | Paramount Pictures 4 | Paramount Pictures 3 | Peter Hyams 226 | Larry Ferguson 238 | Sean Connery 107 | Mark Harmon 211 | Meg Ryan 46 | |
1458 | 1458 | The Presidio 275 | 1988 23 | Presidio (Golden Gate National Recreation Area) | In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. | Paramount Pictures 4 | Paramount Pictures 3 | Peter Hyams 226 | Larry Ferguson 238 | Sean Connery 107 | Mark Harmon 211 | Meg Ryan 46 |
1457 | 1457 | The Presidio 275 | 1988 23 | Sansome Street (The Embarcadero) | Paramount Pictures 4 | Paramount Pictures 3 | Peter Hyams 226 | Larry Ferguson 238 | Sean Connery 107 | Mark Harmon 211 | Meg Ryan 46 | |
1456 | 1456 | The Presidio 275 | 1988 23 | Washington Street & Waverly Place (Chinatown) | Paramount Pictures 4 | Paramount Pictures 3 | Peter Hyams 226 | Larry Ferguson 238 | Sean Connery 107 | Mark Harmon 211 | Meg Ryan 46 | |
1455 | 1455 | The Parent Trap 274 | 1998 18 | Administration Building (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. | Walt Disney Pictures 70 | Buena Vista Pictures 25 | Nancy Meyers 225 | Nancy Meyers 237 | Lindsay Lohan 414 | Dennis Quaid 210 | |
1451 | 1451 | The Organization 272 | 1971 42 | The Mirisch Corporation 160 | United Artists 19 | Don Medford 224 | James R. Webb 235 | Sidney Poitier 90 | Barbara McNair 209 | |||
1449 | 1449 | The Net 270 | 1995 39 | Montgomery & Market Streets | Columbia Pictures Corp. 93 | Columbia Pictures 4 | Irwin Winkler 223 | John Brancato 224 | Sandra Bullock 411 | Jeremy Northam 207 | ||
1448 | 1448 | The Net 270 | 1995 39 | Moscone Convention Center | Columbia Pictures Corp. 93 | Columbia Pictures 4 | Irwin Winkler 223 | John Brancato 224 | Sandra Bullock 411 | Jeremy Northam 207 | ||
1447 | 1447 | The Matrix 269 | 1999 26 | skyline/ exterior scenes | Silver Pictures 128 | Warner Bros. Pictures 6 | The Wachowski Brothers 222 | The Wachowski Brothers 233 | Keanu Reeves 391 | Laurence Fishburne 206 | ||
1446 | 1446 | The Master 268 | 2012 13 | Pier 7/ Embarcadero | H.H. Project 159 | Weinstein Company 21 | Paul Thomas Anderson 221 | Paul Thomas Anderson 232 | Philip Seymour Hoffman 143 | Joaquin Phoenix 205 | ||
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 |
1433 | 1433 | The Laughing Policeman 264 | 1973 16 | Twentieth Century Fox Film Corporation 13 | American Broadcasting Company (ABC) 51 | Stuart Rosenberg 219 | Thomas Rickman 230 | Walter Matthau 408 | Bruce Dern 70 | Louis Gossett Jr. 538 | ||
1432 | 1432 | The Lady from Shanghai 263 | 1947 41 | Former Hall of Justice (750 Kearny Street at Washington) | Columbia Pictures Corp. 93 | Columbia Pictures 4 | Orson Welles 218 | Orson Welles 229 | Rita Hayworth 354 | Orson Welles 201 | Everett Sloane 537 | |
1431 | 1431 | The Lady from Shanghai 263 | 1947 41 | Golden Gate Park | The Playland amusement park where "Hall of Mirrors" sequence at the end of the movie was filmed has since been destroyed. However, relics from the park are now housed at the nearby Cliff House. | Columbia Pictures Corp. 93 | Columbia Pictures 4 | Orson Welles 218 | Orson Welles 229 | Rita Hayworth 354 | Orson Welles 201 | Everett Sloane 537 |
1430 | 1430 | The Lady from Shanghai 263 | 1947 41 | Mandarin Theatre (1021 Grant Avenue) | The Mandarin Theatre was renamed the Sun Sing Theatre in 1949. It closed 1986. | Columbia Pictures Corp. 93 | Columbia Pictures 4 | Orson Welles 218 | Orson Welles 229 | Rita Hayworth 354 | Orson Welles 201 | Everett Sloane 537 |
1429 | 1429 | The Lady from Shanghai 263 | 1947 41 | 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. | Columbia Pictures Corp. 93 | Columbia Pictures 4 | Orson Welles 218 | Orson Welles 229 | Rita Hayworth 354 | Orson Welles 201 | Everett Sloane 537 |
JSON shape: default, array, newline-delimited
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");