Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | Title | Production Company | Director | Writer ▲ | Actor 1 | Actor 2 | Actor 3 | Locations | Fun Facts |
---|---|---|---|---|---|---|---|---|---|---|
1622 | 1622 | 307 | 4 | 213 | 266 | 438 | 118 | SF Chronicle Building (901 Mission St) | ||
1621 | 1621 | 306 | 179 | 249 | 265 | 437 | 236 | 551 | ||
1620 | 1620 | 305 | 178 | 248 | 264 | 436 | 312 Fillmore Street | |||
1614 | 1614 | 304 | 177 | 247 | 263 | 350 | 235 | 202 | Former Hall of Justice (750 Kearny Street at Washington) | |
1615 | 1615 | 304 | 177 | 247 | 263 | 350 | 235 | 202 | 835-865 Market Street at 5th Street | The Emporium, a department store, stood in this location. Bloomingdale's is now located here. |
1616 | 1616 | 304 | 177 | 247 | 263 | 350 | 235 | 202 | 819 Mason Street at Pine | |
1617 | 1617 | 304 | 177 | 247 | 263 | 350 | 235 | 202 | 772 Commercial Street at Kearney | Called "Man Loh's Oriental Roof Garden" in the film. |
1618 | 1618 | 304 | 177 | 247 | 263 | 350 | 235 | 202 | 1801 Laguna at Bush | |
1619 | 1619 | 304 | 177 | 247 | 263 | 350 | 235 | 202 | Cable Car Signal Box (California Street at Powell Street) | SF Cable Cars are the only moving National Historical Landmark. |
1590 | 1590 | 302 | 104 | 246 | 262 | 58 | 46 | Buena Vista Café (2765 Hyde Street) | ||
1591 | 1591 | 302 | 104 | 246 | 262 | 58 | 46 | 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. | |
1592 | 1592 | 302 | 104 | 246 | 262 | 58 | 46 | Spring Valley School (1451 Jackson Street) | ||
1593 | 1593 | 302 | 104 | 246 | 262 | 58 | 46 | International Studies Academy (993 Vermont Street, Potrero Hill) | ||
1594 | 1594 | 302 | 104 | 246 | 262 | 58 | 46 | Grant Street at Pacific Avenue | ||
1595 | 1595 | 302 | 104 | 246 | 262 | 58 | 46 | Cybelle's Pizza (1000 Bush Street) | ||
1596 | 1596 | 302 | 104 | 246 | 262 | 58 | 46 | 766 Vallejo Street at Stockton Street (North Beach) | ||
1597 | 1597 | 302 | 104 | 246 | 262 | 58 | 46 | 1521 Masonic Avenue at Piedmont Street | ||
1583 | 1583 | 301 | 38 | 245 | 261 | 434 | 233 | 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. | |
1584 | 1584 | 301 | 38 | 245 | 261 | 434 | 233 | San Francisco Hilton (333 O'Farrell Street) | ||
1585 | 1585 | 301 | 38 | 245 | 261 | 434 | 233 | Lombard Street between Hyde and Leavenworth | ||
1586 | 1586 | 301 | 38 | 245 | 261 | 434 | 233 | Hyde Street Pier | ||
1587 | 1587 | 301 | 38 | 245 | 261 | 434 | 233 | Chinatown | First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. | |
1588 | 1588 | 301 | 38 | 245 | 261 | 434 | 233 | 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. | |
1589 | 1589 | 301 | 38 | 245 | 261 | 434 | 233 | 22nd Avenue & Balboa Street (Richmond District) | ||
1582 | 1582 | 300 | 175 | 244 | 260 | 433 | 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. | ||
1581 | 1581 | 299 | 156 | 243 | 259 | 265 | 232 | 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. | |
1565 | 1565 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | 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. |
1566 | 1566 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | York Hotel (940 Sutter Street) | |
1567 | 1567 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | San Francisco Drydock (20th and Illinois Streets) | |
1568 | 1568 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | Park Hill Sanatorium (351 Buena Vista Avenue East) | This location is now a condominium complex. |
1569 | 1569 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | Mission San Juan Bautista (2nd & Mariposa Streets) | |
1570 | 1570 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | 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. |
1571 | 1571 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | Gough & Eddy Streets (Western Addition) | |
1572 | 1572 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | 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. |
1573 | 1573 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | 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. |
1574 | 1574 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | Ernie's Restaurant (847 Montgomery Street) | Called the "Essex Club" in the film. |
1575 | 1575 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | Conservatory of Flowers (Golden Gate Park) | The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. |
1576 | 1576 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | Claude Lane at Bush Street | |
1577 | 1577 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | 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. |
1578 | 1578 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | Brocklebank Apartments (1000 Mason Street) | |
1579 | 1579 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | 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. |
1580 | 1580 | 298 | 174 | 81 | 258 | 432 | 231 | 106 | 1007 Gough Street | Tennis courts now sit on the site; in the movie the structure was Carlota Valdes' home. |
1559 | 1559 | 297 | 173 | 242 | 257 | 431 | 230 | 549 | Project Artaud (Florida Street) | |
1560 | 1560 | 297 | 173 | 242 | 257 | 431 | 230 | 549 | Corona Heights Park | |
1561 | 1561 | 297 | 173 | 242 | 257 | 431 | 230 | 549 | 544 Natoma (SOMA) | |
1562 | 1562 | 297 | 173 | 242 | 257 | 431 | 230 | 549 | 422 Oak Street at Laguna | |
1563 | 1563 | 297 | 173 | 242 | 257 | 431 | 230 | 549 | 3567 18th Street | |
1564 | 1564 | 297 | 173 | 242 | 257 | 431 | 230 | 549 | Under Highway 101 (near Potrero and Cesar Chavez Streets) | |
1558 | 1558 | 296 | 172 | 241 | 256 | 430 | Tosca Café (242 Columbus Avenue, North Beach) | |||
1557 | 1557 | 295 | 104 | 240 | 255 | 112 | 229 | Mecca Restaurant (2029 Market Street) | ||
1546 | 1546 | 294 | 171 | 239 | 254 | 429 | ||||
1545 | 1545 | 293 | 170 | 127 | 253 | 113 | 228 | 548 | 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. |
1544 | 1544 | 292 | 5 | 238 | 252 | 428 | 227 | |||
1543 | 1543 | 291 | 169 | 112 | 251 | 427 | 226 | 547 | ||
1542 | 1542 | 290 | 52 | 237 | 250 | 426 | 225 | |||
1518 | 1518 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | Lombard & Laguna Streets (Marina District) | |
1519 | 1519 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | Lombard & Fillmore Streets (Marina District) | |
1520 | 1520 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | Lombard & Divisadero Streets (Marina District) | |
1521 | 1521 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | Lombard & Broderick Streets (Marina District) | |
1522 | 1522 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | Justin Herman Plaza | |
1523 | 1523 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | Intersection of Fulton & 6th Streets (Chinatown) | |
1524 | 1524 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | Intersection of California & Grant Streets (Richmond District) | |
1525 | 1525 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | Hyatt Regency Hotel (5 Embarcadero Center) | |
1526 | 1526 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | Huntington Park (California & Taylor Streets, Nob Hill) | The mansion of Arabella Huntington, widow of railroad magnate Collis P. Huntington, was destroyed in the 1906 earthquake and fire. Mrs. Huntington the donated the land on which the park now stands to the city. |
1527 | 1527 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | Golden Gate Park | Golden Gate Park is similar in shape but 20% larger than New York's Central Park. |
1528 | 1528 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | 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. |
1529 | 1529 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | Ghirardelli Square (900 North Point Street, Fisherman's Wharf) | In 1893, chocolatier Domingo Ghirardelli bought an entire city block to house the headquarters of Ghirardelli Chocolates. |
1530 | 1530 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | Chestnut & Divisadero Streets (Marina District) | |
1531 | 1531 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | 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. |
1532 | 1532 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | Broadway at Osgood Street (North Beach) | |
1533 | 1533 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | 2340 Francisco Street | |
1534 | 1534 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | 100 Block of Union Street (Cow Hollow) | |
1535 | 1535 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | Old St. Mary's Church (660 California Street at Grant) | |
1536 | 1536 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | 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. |
1537 | 1537 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | SF General Hospital Center (1001 Potrero Avenue, Potrero Hill) | SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. |
1538 | 1538 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | 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. |
1539 | 1539 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | One Embarcadero Center (Financial District) | |
1540 | 1540 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | Merchant Exchange (465 California Street at Leidesdorff) | |
1541 | 1541 | 289 | 166 | 186 | 249 | 425 | 224 | 546 | 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. |
1517 | 1517 | 288 | 4 | 236 | 248 | 424 | 223 | 545 | ||
1515 | 1515 | 286 | 167 | 234 | 247 | 423 | 44 | |||
1511 | 1511 | 285 | 166 | 233 | 246 | 422 | 221 | 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. | |
1512 | 1512 | 285 | 166 | 233 | 246 | 422 | 221 | Brocklebank Apartments (1000 Mason Street) | ||
1513 | 1513 | 285 | 166 | 233 | 246 | 422 | 221 | 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. | |
1514 | 1514 | 285 | 166 | 233 | 246 | 422 | 221 | Montgomery Street at Union Street | ||
1503 | 1503 | 284 | 165 | 232 | 245 | 421 | 220 | Grace Cathedral Episcopal Church (1100 California Street) | Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. | |
1504 | 1504 | 284 | 165 | 232 | 245 | 421 | 220 | 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. | |
1505 | 1505 | 284 | 165 | 232 | 245 | 421 | 220 | Pleasant Street at Taylor | ||
1506 | 1506 | 284 | 165 | 232 | 245 | 421 | 220 | Pier 7 (The Embarcadero) | ||
1507 | 1507 | 284 | 165 | 232 | 245 | 421 | 220 | Montgomery Street at Union Street | ||
1508 | 1508 | 284 | 165 | 232 | 245 | 421 | 220 | Lincoln Park | The land on which the park stands was a cemetery until the late 1860s. | |
1509 | 1509 | 284 | 165 | 232 | 245 | 421 | 220 | Japanese Tea Garden (Hagiwara Tea Garden Drive, Golden Gate Park) | The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden | |
1510 | 1510 | 284 | 165 | 232 | 245 | 421 | 220 | 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. | |
1496 | 1496 | 283 | 164 | 60 | 244 | 420 | 219 | 544 | The Castro | From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry. |
1495 | 1495 | 282 | 4 | 231 | 243 | 419 | 218 | 15 | St. Peter & Paul's Church (666 Filbert Street, Washington Square) | Exteriors of the church were used. |
1494 | 1494 | 281 | 93 | 230 | 242 | 418 | 217 | 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. | |
1487 | 1487 | 280 | 95 | 229 | 241 | 107 | 216 | 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. | |
1488 | 1488 | 280 | 95 | 229 | 241 | 107 | 216 | The San Francisco Bay | ||
1489 | 1489 | 280 | 95 | 229 | 241 | 107 | 216 | New Russian Hill Market (1198 Pacific Avenue at Jones) | ||
1490 | 1490 | 280 | 95 | 229 | 241 | 107 | 216 | 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. |
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "Film_Locations_in_San_Francisco_fts" USING FTS4 ("Title", "Production Company", "Director", "Writer", "Actor 1", "Actor 2", "Actor 3", "Locations", "Fun Facts", content="Film_Locations_in_San_Francisco");