sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
1498 278 49 San Francisco Fire Station 38 (2150 California Street, Pacific Heights)   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
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
1501 278 49 Firestation #38 (California & Laguna)   162 112 228 222 273 214 542
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
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  
1451 272 42     160 19 224 235 90 209  
1446 268 13 Pier 7/ Embarcadero   159 21 221 232 143 205  
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
1435 265 72 The Embarcadero   158 4 71 222 409 202 539
1436 265 72 Sutro Baths (Point Lobos Avenue)   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
1438 265 72 Pier 41   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
1440 265 72 2090 Jackson Street   158 4 71 222 409 202 539
1418 259 53 San Francisco Zoo (2701 Sloat Blvd.)   157 111 214 225 404 197 533
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
1404 258 8 Merchant Exchange Building (465 California Street)   156 110 213 224 245 40 532
1405 258 8 Washington Street & Waverly Place (Chinatown)   156 110 213 224 245 40 532
1406 258 8 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. 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
1408 258 8 Ritz-Carlton Hotel (600 Stockton Street)   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
1410 258 8 Merchant Exchange Building   156 110 213 224 245 40 532
1411 258 8 Mason & California Streets (Nob Hill)   156 110 213 224 245 40 532
1412 258 8 Harrison Street (The Embarcadero)   156 110 213 224 245 40 532
1413 258 8 City Club (155 Sansome Street)   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
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
1416 258 8 301 Howard Street   156 110 213 224 245 40 532
1417 258 8 1 Bush Street   156 110 213 224 245 40 532
1581 299 18 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. 156 110 243 259 265 232  
1403 257 38     155 27 212   403    
1392 254 37     154 20 209 221 401 46  
1375 252 10 Victoria Theatre   153 27 207 219 399 193 531
1376 252 10 SPECS' Twelve Adler Museum Café   153 27 207 219 399 193 531
1377 252 10 Ocean Beach at Point Lobos   153 27 207 219 399 193 531
1378 252 10 700 Kansas St.   153 27 207 219 399 193 531
1379 252 10 Presidio Branch Library   153 27 207 219 399 193 531
1380 252 10 The Royal Oak   153 27 207 219 399 193 531
1381 252 10 Tonic   153 27 207 219 399 193 531
1382 252 10 Polk and Northpoint St.   153 27 207 219 399 193 531
1383 252 10 770 Haight St.   153 27 207 219 399 193 531
1384 252 10 Tank Hill Park   153 27 207 219 399 193 531
1385 252 10 Hamburger Haven   153 27 207 219 399 193 531
1386 252 10 Higher Grounds Coffee House   153 27 207 219 399 193 531
1387 252 10 304 Lily St.   153 27 207 219 399 193 531
1388 252 10 The Magazine at 920 Larkin   153 27 207 219 399 193 531
1389 252 10 Geary St. from Polk to Larkin   153 27 207 219 399 193 531
1390 252 10 Yerba Buena Island   153 27 207 219 399 193 531
1359 251 23     152 108 206 218 398    
1345 250 38 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. 151 3 205 217 397 192  
1331 247 62 Westin St. Francis Hotel (335 Powell Street, Union Square) 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. 150 6 203 214 169 189  
1330 246 2     149 107 202 213 396    
1327 244 68 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. 148 106 200   395    
1312 241 26 Merchant Exchange (465 California Street at Leidesdorff)   147 105 198 210 394 185  
1314 241 26 Washington Square Park (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. The statue in the Park is Ben Franklin, not George Washington. 147 105 198 210 394 185  
1315 241 26 Sutter-Stockton Garage (330 Sutter Street at Stockton) Garage roof serves as a heliport in the movie 147 105 198 210 394 185  
1316 241 26 Stockton Tunnel (Stockton Street at Sutter Street) Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area. 147 105 198 210 394 185  
1317 241 26 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. 147 105 198 210 394 185  
1318 241 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. 147 105 198 210 394 185  
1319 241 26 Roof of Cable Car (California at Front Street) SF Cable Cars are the only moving National Historical Landmark. 147 105 198 210 394 185  
1320 241 26 Pacific Stock Exchange (301 Pine Street at Sansome)   147 105 198 210 394 185  
1321 241 26 Nina M. Designs (52 2nd Street at Jessie)   147 105 198 210 394 185  
1322 241 26 Moose's Restaurant (1652 Stockton)   147 105 198 210 394 185  
1323 241 26 Mama's Restaurant (1701 Stockton)   147 105 198 210 394 185  
1324 241 26 Danilo's Bakery (Green Street & Bannam Place)   147 105 198 210 394 185  
1325 241 26 Columbus Avenue at Green & Stockton   147 105 198 210 394 185  
1310 240 5 Tosca Café (242 Columbus Avenue, North Beach)   146 104 197 209 40 184  
1311 240 5 766 Sutter Street   146 104 197 209 40 184  
1286 239 10 16th and Utah Helicopter flies over Utah St. from 16th, rises up before freeway 145 3 196 208 334 183  
1287 239 10 Van Ness between Fell and Lombard   145 3 196 208 334 183  
1288 239 10 California between Leavenworth and Powell   145 3 196 208 334 183  
1289 239 10 Mission at 1st and 2nd   145 3 196 208 334 183  
1290 239 10 Market at Mason   145 3 196 208 334 183  
1291 239 10 California at Larkin   145 3 196 208 334 183  
1292 239 10 California at Jones   145 3 196 208 334 183  
1293 239 10 Pine and Leavenworth   145 3 196 208 334 183  
1294 239 10 Howard St. from Embarcadero to 11 St.   145 3 196 208 334 183  
1295 239 10 Construction Site in front of 260 Stockton St. at Post St.   145 3 196 208 334 183  
1296 239 10 California St. between Drumm St. and Kearny St.   145 3 196 208 334 183  
1297 239 10 Market St. at Embarcadero area   145 3 196 208 334 183  
1298 239 10 Pine St. between Market and Kearny   145 3 196 208 334 183  
1299 239 10 Front St. between Market and Clay   145 3 196 208 334 183  
1300 239 10 Union Square   145 3 196 208 334 183  
1301 239 10 San Francisco - Oakland Bay Bridge   145 3 196 208 334 183  
1302 239 10 Mission St., Embarcadero, and Front between Clay and Market   145 3 196 208 334 183  
1303 239 10 Sutter Stockton Garage   145 3 196 208 334 183  
1304 239 10 Bush St. at Stockton St.   145 3 196 208 334 183  
1305 239 10 Powell St at Geary St   145 3 196 208 334 183  
1306 239 10 1 Market St. Landmark Building   145 3 196 208 334 183  
1307 239 10 Embarcadero between Pier 2 and Harrison   145 3 196 208 334 183  
1308 239 10 Pier 14   145 3 196 208 334 183  
1309 239 10 Pine St. between Market and Montgomery   145 3 196 208 334 183  
1283 238 66 Mission Street   144 103 36 35 360 182  
1284 238 66 Golden Gate Park   144 103 36 35 360 182  
1285 238 66 Bank of America (1455 Stockton Street)   144 103 36 35 360 182  
1280 236 38 Broadway Studios (435 Broadway at Montgomery Street)   143 102 194 206 392    
1281 236 38 Regency Building (1290 Sutter Street)   143 102 194 206 392    
Powered by Datasette · Query took 5.182ms · Data source: data.sfgov.org