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
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
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
1334 249 49 American Roofing Co. Building (297 Kansas Street, Potrero Hill)   92 3 127 216 178 191 530
1335 249 49 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. 92 3 127 216 178 191 530
1336 249 49 Alcoa Building (1 Maritime Plaza) A partially-above ground parking structure near the building made it necessary for architects to make the Alcoa Building's diagonal bracing visible, instead of placing it inside and drastically reducing the amount usable interior space. 92 3 127 216 178 191 530
1337 249 49 Alamo Square (Hayes Valley)   92 3 127 216 178 191 530
1338 249 49 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. 92 3 127 216 178 191 530
1339 249 49 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square". 92 3 127 216 178 191 530
1340 249 49 Saks Fifth Avenue (384 Post Street, Union Square)   92 3 127 216 178 191 530
1341 249 49 One Embarcadero Center (Financial District)   92 3 127 216 178 191 530
1342 249 49 Neiman Marcus (150 Stockton Street, Union Square) In the film the City of Paris Department Store is featured. That establishment was located where Neiman Marcus stands today 92 3 127 216 178 191 530
1343 249 49 Financial District   92 3 127 216 178 191 530
1344 249 49 Cathedral Hill Hotel (1101 Van Ness Avenue, Civic Center)   92 3 127 216 178 191 530
1328 245 69 The Embarcadero   113 4 201 212 289 188 529
1329 245 69 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. 113 4 201 212 289 188 529
1326 243 67 Powell and Geary Streets (Union Square) The pet shop featured in the film does not exist, but was based on the now-closed Robison's House of Pets formerly located on Maiden Lane. 15 41 81 211 116 187 528
1313 242 23 Hall of Justice (850 Bryant Street)   38 6 199 71 295 186 527
1346 242 23 San Francisco Drydock (The Dogpatch)   38 6 199 71 295 186 527
1347 242 23 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. 38 6 199 71 295 186 527
1348 242 23 One Thousand Powell Apartments (1000 Powell Street)   38 6 199 71 295 186 527
1349 242 23 The Cannery (281 Leavenworth Street, Fisherman's Wharf)   38 6 199 71 295 186 527
1350 242 23 Portsmouth Square (Chinatown)   38 6 199 71 295 186 527
1351 242 23 Pierce St. & Golden Gate Avenue (Hayes Valley)   38 6 199 71 295 186 527
1352 242 23 Pierce & California Streets (Pacific Heights)   38 6 199 71 295 186 527
1353 242 23 Pier 3 (The Embarcadero)   38 6 199 71 295 186 527
1354 242 23 New Asia Restaurant (772 Pacific Avenue at Grant)   38 6 199 71 295 186 527
1355 242 23 Nam Yuen Restaurant (740 Washington Street, Chinatown)   38 6 199 71 295 186 527
1356 242 23 Mirant Energy, LLC (1301 Illinois Street, The Dogpatch)   38 6 199 71 295 186 527
1357 242 23 McAllister & Scott Streets (Hayes Valley)   38 6 199 71 295 186 527
1358 242 23 KGO-TV ABC7 TV Studios (900 Front Street, Waterfront Historic District)   38 6 199 71 295 186 527
1360 242 23 San Francisco National Military Cemetery (Lincoln Blvd., The Presidio, Golden Gate National Recreation Center)   38 6 199 71 295 186 527
1361 242 23 Silver Restaurant (737 Washington Street, Chinatown)   38 6 199 71 295 186 527
1362 242 23 Fremont Street Exit of Bay Bridge   38 6 199 71 295 186 527
1363 242 23 Folsom & Essex Streets   38 6 199 71 295 186 527
1364 242 23 Eber Electronics (2355 Market Street, Castro)   38 6 199 71 295 186 527
1365 242 23 Clementina & Sumner Streets   38 6 199 71 295 186 527
1366 242 23 Carl & Cole Streets (Cole Valley)   38 6 199 71 295 186 527
1367 242 23 710 Steiner Street (Hayes Valley)   38 6 199 71 295 186 527
1368 242 23 550 El Camino Del Mar (Seacliff)   38 6 199 71 295 186 527
1369 242 23 23rd & Iowa Streets (Dogpatch)   38 6 199 71 295 186 527
1370 242 23 22nd Bet. Carolina & Rhode Island Streets (Potrero Hill)   38 6 199 71 295 186 527
1371 242 23 22nd & Wisconsin Streets (Potrero Hill)   38 6 199 71 295 186 527
1372 242 23 20th & De Haro Streets (Potrero Hill)   38 6 199 71 295 186 527
1373 242 23 1954 Mason Street (North Beach)   38 6 199 71 295 186 527
1374 242 23 San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. 38 6 199 71 295 186 527
1282 237 47 Powell Street   13 12 195 207 393 181 526
1270 234 47 On Board the SS President Cleveland, docked at Pier 50   38 6 66 204 390 179 525
1269 233 7 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. 142 6 192 203 389 178 524
1255 232 10 Fisherman's Wharf pier near Chapel (Port Walk #19)   141 88 191 202 388 177 523
1256 232 10 Oasis Nightclub (298 11th St)   141 89 191 202 388 177 523
1257 232 10 Broadway and Taylor St Intersection   141 90 191 202 388 177 523
1258 232 10 Turk St between Lyon and Baker St   141 91 191 202 388 177 523
1259 232 10 Buena Vista East & Duboce; Buena Vista East & Haight   141 92 191 202 388 177 523
1260 232 10 Love Street Vintage (1506 Haight & adjacent Haight sidewalk_   141 93 191 202 388 177 523
1261 232 10 Alamo Square   141 94 191 202 388 177 523
1262 232 10 Stanyan & Belgrave   141 95 191 202 388 177 523
1263 232 10 Sansome (Washington to Bush) Pine (Davis to Kearny) Bush: Kearny to Battery   141 96 191 202 388 177 523
1264 232 10 Chinatown (Stockton @ Jackson & Jackson toward Grant   141 97 191 202 388 177 523
1265 232 10 Montgomery between California and Pine   141 98 191 202 388 177 523
1266 232 10 20th St and Church (3885 20th St)   141 99 191 202 388 177 523
1267 232 10 Duboce Park   141 100 191 202 388 177 523
1268 232 10 53 Potomac St   141 101 191 202 388 177 523
1245 231 65 Mt. Davidson Mt. Davidson is highest point in San Francisco (938 feet). 38 6 113 71 295 176 522
1246 231 65 McDonald's Restaurant (701 3rd Street, SOMA)   38 6 113 71 295 176 522
1247 231 65 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. 38 6 113 71 295 176 522
1248 231 65 Hall of Justice (850 Bryant Street)   38 6 113 71 295 176 522
1249 231 65 Ferry Plaza Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 38 6 113 71 295 176 522
1250 231 65 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. 38 6 113 71 295 176 522
1251 231 65 Civic Center Plaza   38 6 113 71 295 176 522
1252 231 65 The Embarcadero/Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 38 6 113 71 295 176 522
1253 231 65 Bowles Franklin Galleries (765 Beach Street, Fisherman's Wharf)   38 6 113 71 295 176 522
1254 231 65 Pier 38-40, The Embarcadero   38 6 113 71 295 176 522
1240 230 64 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. 140 87 141 201 387 175 521
1241 230 64 The Tamalpais Building (1201 Greenwich Street at Hyde)   140 87 141 201 387 175 521
1242 230 64 Brocklebank Apartments (1000 Mason Street)   140 87 141 201 387 175 521
1243 230 64 2800 Scott Street   140 87 141 201 387 175 521
1239 229 36     139 86 190 200 386 174 520
1226 227 10 War Memorial Opera House (401 Van Ness Avenue)   138 41 188 198 384 172 519
Powered by Datasette · Query took 3.809ms · Data source: data.sfgov.org