Film_Locations_in_San_Francisco_fts

Data source: data.sfgov.org

1,622 rows sorted by Director descending

View and edit SQL

Link rowid Title Production Company Director ▲ Writer Actor 1 Actor 2 Actor 3 Locations Fun Facts
1621 306 179 249 265 437 236 551    
1620 305 178 248 264 436     312 Fillmore Street  
1614 304 177 247 263 350 235 202 Former Hall of Justice (750 Kearny Street at Washington)  
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.
1616 304 177 247 263 350 235 202 819 Mason Street at Pine  
1617 304 177 247 263 350 235 202 772 Commercial Street at Kearney Called "Man Loh's Oriental Roof Garden" in the film.
1618 304 177 247 263 350 235 202 1801 Laguna at Bush  
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.
1590 302 104 246 262 58 46   Buena Vista Café (2765 Hyde Street)  
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.
1592 302 104 246 262 58 46   Spring Valley School (1451 Jackson Street)  
1593 302 104 246 262 58 46   International Studies Academy (993 Vermont Street, Potrero Hill)  
1594 302 104 246 262 58 46   Grant Street at Pacific Avenue  
1595 302 104 246 262 58 46   Cybelle's Pizza (1000 Bush Street)  
1596 302 104 246 262 58 46   766 Vallejo Street at Stockton Street (North Beach)  
1597 302 104 246 262 58 46   1521 Masonic Avenue at Piedmont Street  
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.
1584 301 38 245 261 434 233   San Francisco Hilton (333 O'Farrell Street)  
1585 301 38 245 261 434 233   Lombard Street between Hyde and Leavenworth  
1586 301 38 245 261 434 233   Hyde Street Pier  
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.
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.
1589 301 38 245 261 434 233   22nd Avenue & Balboa Street (Richmond District)  
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 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.
1559 297 173 242 257 431 230 549 Project Artaud (Florida Street)  
1560 297 173 242 257 431 230 549 Corona Heights Park  
1561 297 173 242 257 431 230 549 544 Natoma (SOMA)  
1562 297 173 242 257 431 230 549 422 Oak Street at Laguna  
1563 297 173 242 257 431 230 549 3567 18th Street  
1564 297 173 242 257 431 230 549 Under Highway 101 (near Potrero and Cesar Chavez Streets)  
1558 296 172 241 256 430     Tosca Café (242 Columbus Avenue, North Beach)  
1557 295 104 240 255 112 229   Mecca Restaurant (2029 Market Street)  
1546 294 171 239 254 429        
1544 292 5 238 252 428 227      
1542 290 52 237 250 426 225      
1517 288 4 236 248 424 223 545    
1516 287 168 235 39 90 222 209    
1515 286 167 234 247 423 44      
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.
1512 285 166 233 246 422 221   Brocklebank Apartments (1000 Mason 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.
1514 285 166 233 246 422 221   Montgomery Street at Union Street  
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.
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.
1505 284 165 232 245 421 220   Pleasant Street at Taylor  
1506 284 165 232 245 421 220   Pier 7 (The Embarcadero)  
1507 284 165 232 245 421 220   Montgomery Street at Union Street  
1508 284 165 232 245 421 220   Lincoln Park The land on which the park stands was a cemetery until the late 1860s.
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
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.
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.
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.
1488 280 95 229 241 107 216   The San Francisco Bay  
1489 280 95 229 241 107 216   New Russian Hill Market (1198 Pacific Avenue at Jones)  
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.
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.
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.
1493 280 95 229 241 107 216   Alcatraz Island Alcatraz Island was a military fort before it became a prison.
1481 278 162 228 222 273 214 542 2898 Vallejo Street  
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 278 162 228 222 273 214 542 San Francisco Fire Station 38 (2150 California Street, Pacific Heights)  
1499 278 162 228 222 273 214 542 Hyatt Regency Hotel (5 Embarcadero Center, Financial District)  
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 278 162 228 222 273 214 542 Firestation #38 (California & Laguna)  
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.
1478 277 5 227 202 416 213   Glen Park Subway Station  
1479 277 5 227 202 416 213   Glide Memorial Church (434 Ellis St)  
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.
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.
1456 275 4 226 238 107 211 46 Washington Street & Waverly Place (Chinatown)  
1457 275 4 226 238 107 211 46 Sansome Street (The Embarcadero)  
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.
1459 275 4 226 238 107 211 46 Montgomery & Vallejo Streets (Telegraph Hill)  
1460 275 4 226 238 107 211 46 Market & 2nd Streets  
1461 275 4 226 238 107 211 46 Hayes & Polk Streets (Civic Center)  
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.
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.
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.
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.
1466 275 4 226 238 107 211 46 Civic Center Plaza  
1467 275 4 226 238 107 211 46 Battery Street (The Embarcadero)  
1468 275 4 226 238 107 211 46 900 Block of Grant Avenue (Chinatown)  
1469 275 4 226 238 107 211 46 700 Block of Jackson Street (Chinatown)  
1470 275 4 226 238 107 211 46 200 Block of Sansome Street (Financial District)  
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.
1451 272 160 224 235 90 209      
1448 270 93 223 224 411 207   Moscone Convention Center  
1449 270 93 223 224 411 207   Montgomery & Market Streets  
1447 269 128 222 233 391 206   skyline/ exterior scenes  
1446 268 159 221 232 143 205   Pier 7/ Embarcadero  
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 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 267 38 220 231 289 204 541 Burritt Alley (Off Bush Street, between Powell and Stockton Streets)  
1433 264 13 219 230 408 70 538    
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 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 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 263 93 218 229 354 201 537 Former Hall of Justice (750 Kearny Street at Washington)  

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