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
1621 306 31     179 19 249 265 437 236 551
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
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
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
1543 291 56     169 4 112 251 427 226 547
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
1521 289 44 Lombard & Broderick Streets (Marina District)   166 38 186 249 425 224 546
1520 289 44 Lombard & Divisadero Streets (Marina District)   166 38 186 249 425 224 546
1519 289 44 Lombard & Fillmore Streets (Marina District)   166 38 186 249 425 224 546
1518 289 44 Lombard & Laguna Streets (Marina District)   166 38 186 249 425 224 546
1517 288 40     4 3 236 248 424 223 545
1496 283 40 The Castro From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry. 164 114 60 244 420 219 544
1486 279 65 Financial District   163 113 111 240 417 215 543
1485 279 65 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. 163 113 111 240 417 215 543
1484 279 65 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". 163 113 111 240 417 215 543
1483 279 65 American Can Company (Between Illinois & Kentucky, 20th and 22nd Streets)   163 113 111 240 417 215 543
1502 278 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. 162 112 228 222 273 214 542
1501 278 49 Firestation #38 (California & Laguna)   162 112 228 222 273 214 542
1500 278 49 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 162 112 228 222 273 214 542
1499 278 49 Hyatt Regency Hotel (5 Embarcadero Center, Financial District)   162 112 228 222 273 214 542
1498 278 49 San Francisco Fire Station 38 (2150 California Street, Pacific Heights)   162 112 228 222 273 214 542
1497 278 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. 162 112 228 222 273 214 542
1481 278 49 2898 Vallejo Street   162 112 228 222 273 214 542
1445 267 63 Burritt Alley (Off Bush Street, between Powell and Stockton Streets)   38 6 220 231 289 204 541
1444 267 63 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 38 6 220 231 289 204 541
1443 267 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. 38 6 220 231 289 204 541
1442 266 31 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. 82 58 112 111 410 203 540
1441 266 31 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. 82 58 112 111 410 203 540
1440 265 72 2090 Jackson Street   158 4 71 222 409 202 539
1439 265 72 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. 158 4 71 222 409 202 539
1438 265 72 Pier 41   158 4 71 222 409 202 539
1437 265 72 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. 158 4 71 222 409 202 539
1436 265 72 Sutro Baths (Point Lobos Avenue)   158 4 71 222 409 202 539
1435 265 72 The Embarcadero   158 4 71 222 409 202 539
1434 265 72 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. 158 4 71 222 409 202 539
1433 264 16     13 51 219 230 408 70 538
1432 263 41 Former Hall of Justice (750 Kearny Street at Washington)   93 4 218 229 354 201 537
1431 263 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. 93 4 218 229 354 201 537
1430 263 41 Mandarin Theatre (1021 Grant Avenue) The Mandarin Theatre was renamed the Sun Sing Theatre in 1949. It closed 1986. 93 4 218 229 354 201 537
1429 263 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. 93 4 218 229 354 201 537
1428 262 71 Coffee Dan's (O'Farrell Street at Powell)   38 6 217 228 407 200 536
1427 261 27 Players Arcade at Pier 39   13 12 216 227 406 199 535
1426 261 27 Epic Roasthouse   13 12 216 227 406 199 535
1425 261 27 Montgomery and Union St.   13 12 216 227 406 199 535
1424 261 27 Grant Ave from Sacramento to Clay   14 12 216 227 406 199 535
1423 260 70 1227 Montgomery Street   14 13 215 226 405 198 534
1422 260 70 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. 14 13 215 226 405 198 534
1421 260 70 Market Street   14 13 215 226 405 198 534
1420 260 70 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city. 14 13 215 226 405 198 534
1419 259 53 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. 157 111 214 225 404 197 533
1418 259 53 San Francisco Zoo (2701 Sloat Blvd.)   157 111 214 225 404 197 533
1417 258 8 1 Bush Street   156 110 213 224 245 40 532
1416 258 8 301 Howard Street   156 110 213 224 245 40 532
1415 258 8 Bank of America Building (555 California Street) 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. 156 110 213 224 245 40 532
1414 258 8 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. 156 110 213 224 245 40 532
1413 258 8 City Club (155 Sansome Street)   156 110 213 224 245 40 532
1412 258 8 Harrison Street (The Embarcadero)   156 110 213 224 245 40 532
1411 258 8 Mason & California Streets (Nob Hill)   156 110 213 224 245 40 532
1410 258 8 Merchant Exchange Building   156 110 213 224 245 40 532
1409 258 8 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. 156 110 213 224 245 40 532
1408 258 8 Ritz-Carlton Hotel (600 Stockton Street)   156 110 213 224 245 40 532
1407 258 8 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. 156 110 213 224 245 40 532
Powered by Datasette · Query took 1.429ms · Data source: data.sfgov.org