Film_Locations_in_San_Francisco_fts

Data source: data.sfgov.org

1,622 rows sorted by rowid descending

View and edit SQL

Link rowid ▲ Title Production Company Director Writer Actor 1 Actor 2 Actor 3 Locations Fun Facts
1522 289 166 186 249 425 224 546 Justin Herman Plaza  
1521 289 166 186 249 425 224 546 Lombard & Broderick Streets (Marina District)  
1520 289 166 186 249 425 224 546 Lombard & Divisadero Streets (Marina District)  
1519 289 166 186 249 425 224 546 Lombard & Fillmore Streets (Marina District)  
1518 289 166 186 249 425 224 546 Lombard & Laguna Streets (Marina District)  
1517 288 4 236 248 424 223 545    
1516 287 168 235 39 90 222 209    
1515 286 167 234 247 423 44      
1514 285 166 233 246 422 221   Montgomery Street at Union Street  
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.
1512 285 166 233 246 422 221   Brocklebank Apartments (1000 Mason Street)  
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.
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.
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
1508 284 165 232 245 421 220   Lincoln Park The land on which the park stands was a cemetery until the late 1860s.
1507 284 165 232 245 421 220   Montgomery Street at Union Street  
1506 284 165 232 245 421 220   Pier 7 (The Embarcadero)  
1505 284 165 232 245 421 220   Pleasant Street at Taylor  
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.
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.
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.
1501 278 162 228 222 273 214 542 Firestation #38 (California & Laguna)  
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.
1499 278 162 228 222 273 214 542 Hyatt Regency Hotel (5 Embarcadero Center, Financial District)  
1498 278 162 228 222 273 214 542 San Francisco Fire Station 38 (2150 California Street, Pacific Heights)  
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.
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 282 4 231 243 419 218 15 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Exteriors of the church were used.
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.
1493 280 95 229 241 107 216   Alcatraz Island Alcatraz Island was a military fort before it became a prison.
1492 280 95 229 241 107 216   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.
1491 280 95 229 241 107 216   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.
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.
1489 280 95 229 241 107 216   New Russian Hill Market (1198 Pacific Avenue at Jones)  
1488 280 95 229 241 107 216   The San Francisco Bay  
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.
1486 279 163 111 240 417 215 543 Financial District  
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.
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".
1483 279 163 111 240 417 215 543 American Can Company (Between Illinois & Kentucky, 20th and 22nd Streets)  
1482 277 5 227 202 416 213   Golden Gate Park Children's Playground Golden Gate Park is similar in shape but 20% larger than New York's Central Park.
1481 278 162 228 222 273 214 542 2898 Vallejo Street  
1480 277 5 227 202 416 213   Candlestick Park (602 Jamestown Ave.) Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park.
1479 277 5 227 202 416 213   Glide Memorial Church (434 Ellis St)  
1478 277 5 227 202 416 213   Glen Park Subway Station  
1477 276 70 27 239 415 212   2601 Lyon Street  
1476 276 70 27 239 415 212   Baker Beach  
1475 276 70 27 239 415 212   Broadway Tunnel (Broadway between Powell and Larkin)  
1474 276 70 27 239 415 212   Cliff House (1090 Point Lobos Avenue) The Musee Mechanique, which Julie Andrews' character visits in the movie, was at the time housed under the Cliff House.
1473 276 70 27 239 415 212   Firestation #3 (Brazil Avenue and Athens Street)  
1472 276 70 27 239 415 212   Fisherman's Wharf Supposedly, Mikhail S. Gorbachev has said that his favorite part of visiting America was touring Fisherman's Wharf.
1471 276 70 27 239 415 212   724 Brazil Avenue  
1470 275 4 226 238 107 211 46 200 Block of Sansome Street (Financial District)  
1469 275 4 226 238 107 211 46 700 Block of Jackson Street (Chinatown)  
1468 275 4 226 238 107 211 46 900 Block of Grant Avenue (Chinatown)  
1467 275 4 226 238 107 211 46 Battery Street (The Embarcadero)  
1466 275 4 226 238 107 211 46 Civic Center Plaza  
1465 275 4 226 238 107 211 46 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.
1464 275 4 226 238 107 211 46 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.
1463 275 4 226 238 107 211 46 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.
1462 275 4 226 238 107 211 46 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.
1461 275 4 226 238 107 211 46 Hayes & Polk Streets (Civic Center)  
1460 275 4 226 238 107 211 46 Market & 2nd Streets  
1459 275 4 226 238 107 211 46 Montgomery & Vallejo Streets (Telegraph Hill)  
1458 275 4 226 238 107 211 46 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.
1457 275 4 226 238 107 211 46 Sansome Street (The Embarcadero)  
1456 275 4 226 238 107 211 46 Washington Street & Waverly Place (Chinatown)  
1455 274 70 225 237 414 210   Administration Building (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.
1454 273 161 27 236 413 147   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.
1453 273 161 27 236 413 147   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.
1452 273 161 27 236 413 147   Transbay Terminal (Mission Street at 1st Street) Built in 1939, the Terminal linked San Francisco, the East Bay, and Sacramento by rail for the first time.
1451 272 160 224 235 90 209      
1450 271 104 129 234 412 208      
1449 270 93 223 224 411 207   Montgomery & Market Streets  
1448 270 93 223 224 411 207   Moscone Convention Center  
1447 269 128 222 233 391 206   skyline/ exterior scenes  
1446 268 159 221 232 143 205   Pier 7/ Embarcadero  
1445 267 38 220 231 289 204 541 Burritt Alley (Off Bush Street, between Powell and Stockton Streets)  
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.
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.
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.
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.
1440 265 158 71 222 409 202 539 2090 Jackson Street  
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.
1438 265 158 71 222 409 202 539 Pier 41  
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.
1436 265 158 71 222 409 202 539 Sutro Baths (Point Lobos Avenue)  
1435 265 158 71 222 409 202 539 The Embarcadero  
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.
1433 264 13 219 230 408 70 538    
1432 263 93 218 229 354 201 537 Former Hall of Justice (750 Kearny Street at Washington)  
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.
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.
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.
1428 262 38 217 228 407 200 536 Coffee Dan's (O'Farrell Street at Powell)  
1427 261 13 216 227 406 199 535 Players Arcade at Pier 39  
1426 261 13 216 227 406 199 535 Epic Roasthouse  
1425 261 13 216 227 406 199 535 Montgomery and Union St.  
1424 261 14 216 227 406 199 535 Grant Ave from Sacramento to Clay  
1423 260 14 215 226 405 198 534 1227 Montgomery 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 9.103ms · Data source: data.sfgov.org