Film_Locations_in_San_Francisco_fts

Data source: data.sfgov.org

1,622 rows sorted by Actor 3 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
1621 1621 306 179 249 265 437 236 551    
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.
1599 1599 303 176 142 145 435 234 550 United Nations Plaza  
1600 1600 303 176 142 145 435 234 550 520 Castro St.  
1601 1601 303 176 142 145 435 234 550 Castro Theatre, 429 Castro St.  
1602 1602 303 176 142 145 435 234 550 440 Castro St.  
1603 1603 303 176 142 145 435 234 550 Bay Bridge  
1604 1604 303 176 142 145 435 234 550 24th St. between Florida and Alabama  
1605 1605 303 176 142 145 435 234 550 Harvey Milk Plaza, 17th and Castro  
1606 1606 303 176 142 145 435 234 550 Twin Peaks Bar, 401 Castro  
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
1608 1608 303 176 142 145 435 234 550 Buena Vista Park  
1609 1609 303 176 142 145 435 234 550 Haight St. at Central  
1610 1610 303 176 142 145 435 234 550 Eureka Arts Center, 4400 20th St.  
1611 1611 303 176 142 145 435 234 550 Castro St. between 17th and 18th St.  
1612 1612 303 176 142 145 435 234 550 426 Castro St.  
1613 1613 303 176 142 145 435 234 550 Powell St. at Market St.  
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)  
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.
1543 1543 291 169 112 251 427 226 547    
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    
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.
1483 1483 279 163 111 240 417 215 543 American Can Company (Between Illinois & Kentucky, 20th and 22nd Streets)  
1484 1484 279 163 111 240 417 215 543 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".
1485 1485 279 163 111 240 417 215 543 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.
1486 1486 279 163 111 240 417 215 543 Financial District  
1481 1481 278 162 228 222 273 214 542 2898 Vallejo Street  
1497 1497 278 162 228 222 273 214 542 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.
1498 1498 278 162 228 222 273 214 542 San Francisco Fire Station 38 (2150 California Street, Pacific Heights)  
1499 1499 278 162 228 222 273 214 542 Hyatt Regency Hotel (5 Embarcadero Center, Financial District)  
1500 1500 278 162 228 222 273 214 542 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral.
1501 1501 278 162 228 222 273 214 542 Firestation #38 (California & Laguna)  
1502 1502 278 162 228 222 273 214 542 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.
1443 1443 267 38 220 231 289 204 541 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.
1444 1444 267 38 220 231 289 204 541 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.
1445 1445 267 38 220 231 289 204 541 Burritt Alley (Off Bush Street, between Powell and Stockton Streets)  
1441 1441 266 82 112 111 410 203 540 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.
1442 1442 266 82 112 111 410 203 540 100 Block of 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.
1434 1434 265 158 71 222 409 202 539 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House.
1435 1435 265 158 71 222 409 202 539 The Embarcadero  
1436 1436 265 158 71 222 409 202 539 Sutro Baths (Point Lobos Avenue)  
1437 1437 265 158 71 222 409 202 539 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.
1438 1438 265 158 71 222 409 202 539 Pier 41  
1439 1439 265 158 71 222 409 202 539 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.
1440 1440 265 158 71 222 409 202 539 2090 Jackson Street  
1433 1433 264 13 219 230 408 70 538    
1429 1429 263 93 218 229 354 201 537 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.
1430 1430 263 93 218 229 354 201 537 Mandarin Theatre (1021 Grant Avenue) The Mandarin Theatre was renamed the Sun Sing Theatre in 1949. It closed 1986.
1431 1431 263 93 218 229 354 201 537 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.
1432 1432 263 93 218 229 354 201 537 Former Hall of Justice (750 Kearny Street at Washington)  
1428 1428 262 38 217 228 407 200 536 Coffee Dan's (O'Farrell Street at Powell)  
1424 1424 261 14 216 227 406 199 535 Grant Ave from Sacramento to Clay  
1425 1425 261 13 216 227 406 199 535 Montgomery and Union St.  
1426 1426 261 13 216 227 406 199 535 Epic Roasthouse  
1427 1427 261 13 216 227 406 199 535 Players Arcade at Pier 39  
1420 1420 260 14 215 226 405 198 534 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city.
1421 1421 260 14 215 226 405 198 534 Market Street  
1422 1422 260 14 215 226 405 198 534 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.
1423 1423 260 14 215 226 405 198 534 1227 Montgomery Street  
1418 1418 259 157 214 225 404 197 533 San Francisco Zoo (2701 Sloat Blvd.)  
1419 1419 259 157 214 225 404 197 533 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII.
1404 1404 258 156 213 224 245 40 532 Merchant Exchange Building (465 California Street)  
1405 1405 258 156 213 224 245 40 532 Washington Street & Waverly Place (Chinatown)  
1406 1406 258 156 213 224 245 40 532 Stockton Tunnel Southern Approach Overhang (Bush & Stockton Streets, Chinatown) Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area.
1407 1407 258 156 213 224 245 40 532 Sheraton Palace Hotel (639 Market Street) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909.
1408 1408 258 156 213 224 245 40 532 Ritz-Carlton Hotel (600 Stockton Street)  
1409 1409 258 156 213 224 245 40 532 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.
1410 1410 258 156 213 224 245 40 532 Merchant Exchange Building  
1411 1411 258 156 213 224 245 40 532 Mason & California Streets (Nob Hill)  
1412 1412 258 156 213 224 245 40 532 Harrison Street (The Embarcadero)  
1413 1413 258 156 213 224 245 40 532 City Club (155 Sansome Street)  

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 106.924ms · Data source: data.sfgov.org