sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 52 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
127 33 26 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. 29 25 31 30 265    
128 33 26 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. 29 25 31 30 265    
129 33 26 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. 29 25 31 30 265    
130 33 26 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. 29 25 31 30 265    
131 33 26 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 29 25 31 30 265    
520 97 8 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. 70 25 88 89 265 77  
558 102 8 755 Vallejo Street   70 25 93 94 263 82  
559 102 8 The Tamalpais Building (1201 Greenwich Street at Hyde)   70 25 93 94 263 82  
560 102 8 Neiman Marcus (150 Stockton Street, Union Square) The City of Paris department store previously occupied the space that now houses Neiman Marcus. City of Paris' original rotunda and glass dome were incorporated into Neiman Marcus' design. 70 25 93 94 263 82  
561 102 8 First Bank (550 Montgomery Street at Commercial) Called "Stanhope Bank" in the film. 70 25 93 94 263 82  
562 102 8 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. 70 25 93 94 263 82  
658 124 43 Pier 39 (Fisherman's Wharf)   70 25 115 115 278 100  
705 137 43     92 25 127 127 265 112  
885 164 8 Bush Street at Jones   104 25 140 143 3    
1022 190 43 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. 104 25 159 164 359 146  
1029 192 25 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. 121 25 161 165 361 148  
1034 195 17     104 25 27 168 264 150  
1165 218 22 St. Paul's Church (Church Street, Noe Valley)   104 25 180 190 274 167  
1166 219 46 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. 104 25 181 190 274 167  
1167 219 46 Maritime Museum, Building 201 (Fort Mason)   104 25 181 190 274 167  
1168 219 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. 104 25 181 190 274 167  
1169 219 46 CCSF Alemany Campus   104 25 181 190 274 167  
1170 219 46 Carnelian Room, Bank of America Building (555 California Street, 53rd Floor) 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. 104 25 181 190 274 167  
1391 253 37     26 25 208 220 400 194  
1450 271 46     104 25 129 234 412 208  
1452 273 26 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. 161 25 27 236 413 147  
1453 273 26 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. 161 25 27 236 413 147  
1454 273 26 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. 161 25 27 236 413 147  
1455 274 18 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. 70 25 225 237 414 210  
1471 276 33 724 Brazil Avenue   70 25 27 239 415 212  
1472 276 33 Fisherman's Wharf Supposedly, Mikhail S. Gorbachev has said that his favorite part of visiting America was touring Fisherman's Wharf. 70 25 27 239 415 212  
1473 276 33 Firestation #3 (Brazil Avenue and Athens Street)   70 25 27 239 415 212  
1474 276 33 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. 70 25 27 239 415 212  
1475 276 33 Broadway Tunnel (Broadway between Powell and Larkin)   70 25 27 239 415 212  
1476 276 33 Baker Beach   70 25 27 239 415 212  
1477 276 33 2601 Lyon Street   70 25 27 239 415 212  
1487 280 43 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. 95 25 229 241 107 216  
1488 280 43 The San Francisco Bay   95 25 229 241 107 216  
1489 280 43 New Russian Hill Market (1198 Pacific Avenue at Jones)   95 25 229 241 107 216  
1490 280 43 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. 95 25 229 241 107 216  
1491 280 43 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. 95 25 229 241 107 216  
1492 280 43 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. 95 25 229 241 107 216  
1493 280 43 Alcatraz Island Alcatraz Island was a military fort before it became a prison. 95 25 229 241 107 216  
1557 295 38 Mecca Restaurant (2029 Market Street)   104 25 240 255 112 229  
1590 302 48 Buena Vista CafĂ© (2765 Hyde Street)   104 25 246 262 58 46  
1591 302 48 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. 104 25 246 262 58 46  
1592 302 48 Spring Valley School (1451 Jackson Street)   104 25 246 262 58 46  
1593 302 48 International Studies Academy (993 Vermont Street, Potrero Hill)   104 25 246 262 58 46  
1594 302 48 Grant Street at Pacific Avenue   104 25 246 262 58 46  
1595 302 48 Cybelle's Pizza (1000 Bush Street)   104 25 246 262 58 46  
1596 302 48 766 Vallejo Street at Stockton Street (North Beach)   104 25 246 262 58 46  
1597 302 48 1521 Masonic Avenue at Piedmont Street   104 25 246 262 58 46  
Powered by Datasette · Query took 1.353ms · Data source: data.sfgov.org