Film_Locations_in_San_Francisco_fts

Data source: data.sfgov.org

1,622 rows sorted by rowid descending

✎ View and edit SQL

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  
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.
1618 1618 304 177 247 263 350 235 202 1801 Laguna at Bush  
1617 1617 304 177 247 263 350 235 202 772 Commercial Street at Kearney Called "Man Loh's Oriental Roof Garden" in the film.
1616 1616 304 177 247 263 350 235 202 819 Mason Street at Pine  
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.
1614 1614 304 177 247 263 350 235 202 Former Hall of Justice (750 Kearny Street at Washington)  
1613 1613 303 176 142 145 435 234 550 Powell St. at Market St.  
1612 1612 303 176 142 145 435 234 550 426 Castro St.  
1611 1611 303 176 142 145 435 234 550 Castro St. between 17th and 18th St.  
1610 1610 303 176 142 145 435 234 550 Eureka Arts Center, 4400 20th St.  
1609 1609 303 176 142 145 435 234 550 Haight St. at Central  
1608 1608 303 176 142 145 435 234 550 Buena Vista Park  
1607 1607 303 176 142 145 435 234 550 Women's Building, 3543 18th St. Roma Guy was one of the founders of the Women's Building
1606 1606 303 176 142 145 435 234 550 Twin Peaks Bar, 401 Castro  
1605 1605 303 176 142 145 435 234 550 Harvey Milk Plaza, 17th and Castro  
1604 1604 303 176 142 145 435 234 550 24th St. between Florida and Alabama  
1603 1603 303 176 142 145 435 234 550 Bay Bridge  
1602 1602 303 176 142 145 435 234 550 440 Castro St.  
1601 1601 303 176 142 145 435 234 550 Castro Theatre, 429 Castro St.  
1600 1600 303 176 142 145 435 234 550 520 Castro St.  
1599 1599 303 176 142 145 435 234 550 United Nations Plaza  
1598 1598 303 176 142 145 435 234 550 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.
1597 1597 302 104 246 262 58 46   1521 Masonic Avenue at Piedmont Street  
1596 1596 302 104 246 262 58 46   766 Vallejo Street at Stockton Street (North Beach)  
1595 1595 302 104 246 262 58 46   Cybelle's Pizza (1000 Bush Street)  
1594 1594 302 104 246 262 58 46   Grant Street at Pacific Avenue  
1593 1593 302 104 246 262 58 46   International Studies Academy (993 Vermont Street, Potrero Hill)  
1592 1592 302 104 246 262 58 46   Spring Valley School (1451 Jackson 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.
1590 1590 302 104 246 262 58 46   Buena Vista Café (2765 Hyde Street)  
1589 1589 301 38 245 261 434 233   22nd Avenue & Balboa Street (Richmond District)  
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.
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.
1586 1586 301 38 245 261 434 233   Hyde Street Pier  
1585 1585 301 38 245 261 434 233   Lombard Street between Hyde and Leavenworth  
1584 1584 301 38 245 261 434 233   San Francisco Hilton (333 O'Farrell 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.
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.
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.
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.
1578 1578 298 174 81 258 432 231 106 Brocklebank Apartments (1000 Mason 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.
1576 1576 298 174 81 258 432 231 106 Claude Lane at Bush Street  
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.
1574 1574 298 174 81 258 432 231 106 Ernie's Restaurant (847 Montgomery Street) Called the "Essex Club" in the film.
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.
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.
1571 1571 298 174 81 258 432 231 106 Gough & Eddy Streets (Western Addition)  
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.
1569 1569 298 174 81 258 432 231 106 Mission San Juan Bautista (2nd & Mariposa 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.
1567 1567 298 174 81 258 432 231 106 San Francisco Drydock (20th and Illinois Streets)  
1566 1566 298 174 81 258 432 231 106 York Hotel (940 Sutter Street)  
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.
1564 1564 297 173 242 257 431 230 549 Under Highway 101 (near Potrero and Cesar Chavez Streets)  
1563 1563 297 173 242 257 431 230 549 3567 18th Street  
1562 1562 297 173 242 257 431 230 549 422 Oak Street at Laguna  
1561 1561 297 173 242 257 431 230 549 544 Natoma (SOMA)  
1560 1560 297 173 242 257 431 230 549 Corona Heights Park  
1559 1559 297 173 242 257 431 230 549 Project Artaud (Florida Street)  
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)  
1556 1556 209 4 111 181 324 160   The Saloon (1232 Grant Avenue)  
1555 1555 209 4 111 181 324 160   Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café.
1554 1554 209 4 111 181 324 160   La Bodega (1332 Grant Avenue at Vallejo)  
1553 1553 209 4 111 181 324 160      
1552 1552 209 4 111 181 324 160   Veterans' War Memorial Building (401 Van Ness Avenue)  
1551 1551 209 4 111 181 324 160   McCovey Point, China Basin Park (24 Willy Mays Plaza)  
1550 1550 209 4 111 181 324 160   Mojito (1337-1339 Grant Avenue)  
1549 1549 209 4 111 181 324 160   Pier 39  
1548 1548 209 4 111 181 324 160   Piers 30-32  
1547 1547 209 4 111 181 324 160   Red's Java House (Pier 30-32, The Embarcadero)  
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      
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.
1540 1540 289 166 186 249 425 224 546 Merchant Exchange (465 California Street at Leidesdorff)  
1539 1539 289 166 186 249 425 224 546 One Embarcadero Center (Financial District)  
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.
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.
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.
1535 1535 289 166 186 249 425 224 546 Old St. Mary's Church (660 California Street at Grant)  
1534 1534 289 166 186 249 425 224 546 100 Block of Union Street (Cow Hollow)  
1533 1533 289 166 186 249 425 224 546 2340 Francisco Street  
1532 1532 289 166 186 249 425 224 546 Broadway at Osgood Street (North Beach)  
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.
1530 1530 289 166 186 249 425 224 546 Chestnut & Divisadero Streets (Marina District)  
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.
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.
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.
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.
1525 1525 289 166 186 249 425 224 546 Hyatt Regency Hotel (5 Embarcadero Center)  
1524 1524 289 166 186 249 425 224 546 Intersection of California & Grant Streets (Richmond District)  
1523 1523 289 166 186 249 425 224 546 Intersection of Fulton & 6th Streets (Chinatown)  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 79.03ms · Data source: data.sfgov.org