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
1622 307 75 SF Chronicle Building (901 Mission St)   4 3 213 266 438 118  
1621 306 31     179 19 249 265 437 236 551
1620 305 25 312 Fillmore Street   178 24 248 264 436    
1619 304 15 Cable Car Signal Box (California Street at Powell Street) SF Cable Cars are the only moving National Historical Landmark. 177 41 247 263 350 235 202
1618 304 15 1801 Laguna at Bush   177 41 247 263 350 235 202
1617 304 15 772 Commercial Street at Kearney Called "Man Loh's Oriental Roof Garden" in the film. 177 41 247 263 350 235 202
1616 304 15 819 Mason Street at Pine   177 41 247 263 350 235 202
1615 304 15 835-865 Market Street at 5th Street The Emporium, a department store, stood in this location. Bloomingdale's is now located here. 177 41 247 263 350 235 202
1614 304 15 Former Hall of Justice (750 Kearny Street at Washington)   177 41 247 263 350 235 202
1613 303 20 Powell St. at Market St.   176 119 142 145 435 234 550
1612 303 20 426 Castro St.   176 119 142 145 435 234 550
1611 303 20 Castro St. between 17th and 18th St.   176 119 142 145 435 234 550
1610 303 20 Eureka Arts Center, 4400 20th St.   176 119 142 145 435 234 550
1609 303 20 Haight St. at Central   176 119 142 145 435 234 550
1608 303 20 Buena Vista Park   176 119 142 145 435 234 550
1607 303 20 Women's Building, 3543 18th St. Roma Guy was one of the founders of the Women's Building 176 119 142 145 435 234 550
1606 303 20 Twin Peaks Bar, 401 Castro   176 119 142 145 435 234 550
1605 303 20 Harvey Milk Plaza, 17th and Castro   176 119 142 145 435 234 550
1604 303 20 24th St. between Florida and Alabama   176 119 142 145 435 234 550
1603 303 20 Bay Bridge   176 119 142 145 435 234 550
1602 303 20 440 Castro St.   176 119 142 145 435 234 550
1601 303 20 Castro Theatre, 429 Castro St.   176 119 142 145 435 234 550
1600 303 20 520 Castro St.   176 119 142 145 435 234 550
1599 303 20 United Nations Plaza   176 119 142 145 435 234 550
1598 303 20 City Hall Exterior scenes include re-creating the White Night Riots on May 21, 1979 and the Gay Freedom March. Interior scenes included the wedding ceremony for Roma and Diane which had a few Board of Supervisors in the ceremony. The current Clerk for the Board of Supervisors played herself in one of the scenes filmed in the Chambers. 176 119 142 145 435 234 550
1597 302 48 1521 Masonic Avenue at Piedmont Street   104 25 246 262 58 46  
1596 302 48 766 Vallejo Street at Stockton Street (North Beach)   104 25 246 262 58 46  
1595 302 48 Cybelle's Pizza (1000 Bush Street)   104 25 246 262 58 46  
1594 302 48 Grant Street at Pacific Avenue   104 25 246 262 58 46  
1593 302 48 International Studies Academy (993 Vermont Street, Potrero Hill)   104 25 246 262 58 46  
1592 302 48 Spring Valley School (1451 Jackson Street)   104 25 246 262 58 46  
1591 302 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. 104 25 246 262 58 46  
1590 302 48 Buena Vista Café (2765 Hyde Street)   104 25 246 262 58 46  
1589 301 62 22nd Avenue & Balboa Street (Richmond District)   38 6 245 261 434 233  
1588 301 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. 38 6 245 261 434 233  
1587 301 62 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 38 6 245 261 434 233  
1586 301 62 Hyde Street Pier   38 6 245 261 434 233  
1585 301 62 Lombard Street between Hyde and Leavenworth   38 6 245 261 434 233  
1584 301 62 San Francisco Hilton (333 O'Farrell Street)   38 6 245 261 434 233  
1583 301 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. 38 6 245 261 434 233  
1582 300 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. 175 118 244 260 433    
1581 299 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. 156 110 243 259 265 232  
1580 298 72 1007 Gough Street Tennis courts now sit on the site; in the movie the structure was Carlota Valdes' home. 174 3 81 258 432 231 106
1579 298 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. 174 3 81 258 432 231 106
1578 298 72 Brocklebank Apartments (1000 Mason Street)   174 3 81 258 432 231 106
1577 298 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. 174 3 81 258 432 231 106
1576 298 72 Claude Lane at Bush Street   174 3 81 258 432 231 106
1575 298 72 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. 174 3 81 258 432 231 106
1574 298 72 Ernie's Restaurant (847 Montgomery Street) Called the "Essex Club" in the film. 174 3 81 258 432 231 106
1573 298 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. 174 3 81 258 432 231 106
1572 298 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. 174 3 81 258 432 231 106
1571 298 72 Gough & Eddy Streets (Western Addition)   174 3 81 258 432 231 106
1570 298 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. 174 3 81 258 432 231 106
1569 298 72 Mission San Juan Bautista (2nd & Mariposa Streets)   174 3 81 258 432 231 106
1568 298 72 Park Hill Sanatorium (351 Buena Vista Avenue East) This location is now a condominium complex. 174 3 81 258 432 231 106
1567 298 72 San Francisco Drydock (20th and Illinois Streets)   174 3 81 258 432 231 106
1566 298 72 York Hotel (940 Sutter Street)   174 3 81 258 432 231 106
1565 298 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. 174 3 81 258 432 231 106
1564 297 22 Under Highway 101 (near Potrero and Cesar Chavez Streets)   173 117 242 257 431 230 549
1563 297 22 3567 18th Street   173 117 242 257 431 230 549
1562 297 22 422 Oak Street at Laguna   173 117 242 257 431 230 549
1561 297 22 544 Natoma (SOMA)   173 117 242 257 431 230 549
1560 297 22 Corona Heights Park   173 117 242 257 431 230 549
1559 297 22 Project Artaud (Florida Street)   173 117 242 257 431 230 549
1558 296 37 Tosca Café (242 Columbus Avenue, North Beach)   172 6 241 256 430    
1557 295 38 Mecca Restaurant (2029 Market Street)   104 25 240 255 112 229  
1556 209 5 The Saloon (1232 Grant Avenue)   4 3 111 181 324 160  
1555 209 5 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. 4 3 111 181 324 160  
1554 209 5 La Bodega (1332 Grant Avenue at Vallejo)   4 3 111 181 324 160  
1553 209 5     4 3 111 181 324 160  
1552 209 5 Veterans' War Memorial Building (401 Van Ness Avenue)   4 3 111 181 324 160  
1551 209 5 McCovey Point, China Basin Park (24 Willy Mays Plaza)   4 3 111 181 324 160  
1550 209 5 Mojito (1337-1339 Grant Avenue)   4 3 111 181 324 160  
1549 209 5 Pier 39   4 3 111 181 324 160  
1548 209 5 Piers 30-32   4 3 111 181 324 160  
1547 209 5 Red's Java House (Pier 30-32, The Embarcadero)   4 3 111 181 324 160  
1546 294 2     171 116 239 254 429    
1545 293 23 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. 170 3 127 253 113 228 548
1544 292 35     5 4 238 252 428 227  
1543 291 56     169 4 112 251 427 226 547
1542 290 43     52 6 237 250 426 225  
1541 289 44 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. 166 38 186 249 425 224 546
1540 289 44 Merchant Exchange (465 California Street at Leidesdorff)   166 38 186 249 425 224 546
1539 289 44 One Embarcadero Center (Financial District)   166 38 186 249 425 224 546
1538 289 44 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. 166 38 186 249 425 224 546
1537 289 44 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. 166 38 186 249 425 224 546
1536 289 44 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. 166 38 186 249 425 224 546
1535 289 44 Old St. Mary's Church (660 California Street at Grant)   166 38 186 249 425 224 546
1534 289 44 100 Block of Union Street (Cow Hollow)   166 38 186 249 425 224 546
1533 289 44 2340 Francisco Street   166 38 186 249 425 224 546
1532 289 44 Broadway at Osgood Street (North Beach)   166 38 186 249 425 224 546
1531 289 44 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. 166 38 186 249 425 224 546
1530 289 44 Chestnut & Divisadero Streets (Marina District)   166 38 186 249 425 224 546
1529 289 44 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. 166 38 186 249 425 224 546
1528 289 44 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. 166 38 186 249 425 224 546
1527 289 44 Golden Gate Park Golden Gate Park is similar in shape but 20% larger than New York's Central Park. 166 38 186 249 425 224 546
1526 289 44 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. 166 38 186 249 425 224 546
1525 289 44 Hyatt Regency Hotel (5 Embarcadero Center)   166 38 186 249 425 224 546
1524 289 44 Intersection of California & Grant Streets (Richmond District)   166 38 186 249 425 224 546
1523 289 44 Intersection of Fulton & 6th Streets (Chinatown)   166 38 186 249 425 224 546
1522 289 44 Justin Herman Plaza   166 38 186 249 425 224 546
Powered by Datasette · Query took 1.339ms · Data source: data.sfgov.org