Film_Locations_in_San_Francisco_fts

Data source: data.sfgov.org

1,622 rows sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▲ Title Production Company Director Writer Actor 1 Actor 2 Actor 3 Locations Fun Facts
1422 1422 260 14 215 226 405 198 534 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.
1421 1421 260 14 215 226 405 198 534 Market Street  
1420 1420 260 14 215 226 405 198 534 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city.
1419 1419 259 157 214 225 404 197 533 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII.
1418 1418 259 157 214 225 404 197 533 San Francisco Zoo (2701 Sloat Blvd.)  
1417 1417 258 156 213 224 245 40 532 1 Bush Street  
1416 1416 258 156 213 224 245 40 532 301 Howard Street  
1415 1415 258 156 213 224 245 40 532 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.
1414 1414 258 156 213 224 245 40 532 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII.
1413 1413 258 156 213 224 245 40 532 City Club (155 Sansome Street)  
1412 1412 258 156 213 224 245 40 532 Harrison Street (The Embarcadero)  
1411 1411 258 156 213 224 245 40 532 Mason & California Streets (Nob Hill)  
1410 1410 258 156 213 224 245 40 532 Merchant Exchange Building  
1409 1409 258 156 213 224 245 40 532 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.
1408 1408 258 156 213 224 245 40 532 Ritz-Carlton Hotel (600 Stockton Street)  
1407 1407 258 156 213 224 245 40 532 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.
1406 1406 258 156 213 224 245 40 532 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.
1405 1405 258 156 213 224 245 40 532 Washington Street & Waverly Place (Chinatown)  
1404 1404 258 156 213 224 245 40 532 Merchant Exchange Building (465 California Street)  
1403 1403 257 155 212   403        
1402 1402 256 57 211 223 402 196   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.
1401 1401 255 38 210 222 295 195 60 Lefty O' Doul Drawbridge/ 3rd Street Bridge (3rd Street, China Basin) This is SF's only drawbridge, and was named after Francis Joseph "Lefty" O'Doul, a local baseball hero.
1400 1400 255 38 210 222 295 195 60 23rd & Capp Streets (Mission District)  
1399 1399 255 38 210 222 295 195 60 24th Street Mini Park (Mission District)  
1398 1398 255 38 210 222 295 195 60 Alcatraz Island Alcatraz Island was a military fort before it became a prison.
1397 1397 255 38 210 222 295 195 60 Balmy Street (Mission District)  
1396 1396 255 38 210 222 295 195 60 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.
1395 1395 255 38 210 222 295 195 60 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.
1394 1394 255 38 210 222 295 195 60 Hall of Justice  
1393 1393 255 38 210 222 295 195 60 Sutter & Webster Streets  
1392 1392 254 154 209 221 401 46      
1391 1391 253 26 208 220 400 194      
1390 1390 252 153 207 219 399 193 531 Yerba Buena Island  
1389 1389 252 153 207 219 399 193 531 Geary St. from Polk to Larkin  
1388 1388 252 153 207 219 399 193 531 The Magazine at 920 Larkin  
1387 1387 252 153 207 219 399 193 531 304 Lily St.  
1386 1386 252 153 207 219 399 193 531 Higher Grounds Coffee House  
1385 1385 252 153 207 219 399 193 531 Hamburger Haven  
1384 1384 252 153 207 219 399 193 531 Tank Hill Park  
1383 1383 252 153 207 219 399 193 531 770 Haight St.  
1382 1382 252 153 207 219 399 193 531 Polk and Northpoint St.  
1381 1381 252 153 207 219 399 193 531 Tonic  
1380 1380 252 153 207 219 399 193 531 The Royal Oak  
1379 1379 252 153 207 219 399 193 531 Presidio Branch Library  
1378 1378 252 153 207 219 399 193 531 700 Kansas St.  
1377 1377 252 153 207 219 399 193 531 Ocean Beach at Point Lobos  
1376 1376 252 153 207 219 399 193 531 SPECS' Twelve Adler Museum Café  
1375 1375 252 153 207 219 399 193 531 Victoria Theatre  
1374 1374 242 38 199 71 295 186 527 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.
1373 1373 242 38 199 71 295 186 527 1954 Mason Street (North Beach)  
1372 1372 242 38 199 71 295 186 527 20th & De Haro Streets (Potrero Hill)  
1371 1371 242 38 199 71 295 186 527 22nd & Wisconsin Streets (Potrero Hill)  
1370 1370 242 38 199 71 295 186 527 22nd Bet. Carolina & Rhode Island Streets (Potrero Hill)  
1369 1369 242 38 199 71 295 186 527 23rd & Iowa Streets (Dogpatch)  
1368 1368 242 38 199 71 295 186 527 550 El Camino Del Mar (Seacliff)  
1367 1367 242 38 199 71 295 186 527 710 Steiner Street (Hayes Valley)  
1366 1366 242 38 199 71 295 186 527 Carl & Cole Streets (Cole Valley)  
1365 1365 242 38 199 71 295 186 527 Clementina & Sumner Streets  
1364 1364 242 38 199 71 295 186 527 Eber Electronics (2355 Market Street, Castro)  
1363 1363 242 38 199 71 295 186 527 Folsom & Essex Streets  
1362 1362 242 38 199 71 295 186 527 Fremont Street Exit of Bay Bridge  
1361 1361 242 38 199 71 295 186 527 Silver Restaurant (737 Washington Street, Chinatown)  
1360 1360 242 38 199 71 295 186 527 San Francisco National Military Cemetery (Lincoln Blvd., The Presidio, Golden Gate National Recreation Center)  
1359 1359 251 152 206 218 398        
1358 1358 242 38 199 71 295 186 527 KGO-TV ABC7 TV Studios (900 Front Street, Waterfront Historic District)  
1357 1357 242 38 199 71 295 186 527 McAllister & Scott Streets (Hayes Valley)  
1356 1356 242 38 199 71 295 186 527 Mirant Energy, LLC (1301 Illinois Street, The Dogpatch)  
1355 1355 242 38 199 71 295 186 527 Nam Yuen Restaurant (740 Washington Street, Chinatown)  
1354 1354 242 38 199 71 295 186 527 New Asia Restaurant (772 Pacific Avenue at Grant)  
1353 1353 242 38 199 71 295 186 527 Pier 3 (The Embarcadero)  
1352 1352 242 38 199 71 295 186 527 Pierce & California Streets (Pacific Heights)  
1351 1351 242 38 199 71 295 186 527 Pierce St. & Golden Gate Avenue (Hayes Valley)  
1350 1350 242 38 199 71 295 186 527 Portsmouth Square (Chinatown)  
1349 1349 242 38 199 71 295 186 527 The Cannery (281 Leavenworth Street, Fisherman's Wharf)  
1348 1348 242 38 199 71 295 186 527 One Thousand Powell Apartments (1000 Powell Street)  
1347 1347 242 38 199 71 295 186 527 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.
1346 1346 242 38 199 71 295 186 527 San Francisco Drydock (The Dogpatch)  
1345 1345 250 151 205 217 397 192   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.
1344 1344 249 92 127 216 178 191 530 Cathedral Hill Hotel (1101 Van Ness Avenue, Civic Center)  
1343 1343 249 92 127 216 178 191 530 Financial District  
1342 1342 249 92 127 216 178 191 530 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
1341 1341 249 92 127 216 178 191 530 One Embarcadero Center (Financial District)  
1340 1340 249 92 127 216 178 191 530 Saks Fifth Avenue (384 Post Street, Union Square)  
1339 1339 249 92 127 216 178 191 530 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square".
1338 1338 249 92 127 216 178 191 530 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.
1337 1337 249 92 127 216 178 191 530 Alamo Square (Hayes Valley)  
1336 1336 249 92 127 216 178 191 530 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.
1335 1335 249 92 127 216 178 191 530 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.
1334 1334 249 92 127 216 178 191 530 American Roofing Co. Building (297 Kansas Street, Potrero Hill)  
1333 1333 248 5 204 215 252 190 57 California Academy of Sciences (Golden Gate Park) Founded in 1853, 3 years after California joined the United States, the Academy was originally named the California Academy of Natural Sciences and was the first institution of its kind in the United States.
1332 1332 248 5 204 215 252 190 57 Pier 39  
1331 1331 247 150 203 214 169 189   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.
1330 1330 246 149 202 213 396        
1329 1329 245 113 201 212 289 188 529 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.
1328 1328 245 113 201 212 289 188 529 The Embarcadero  
1327 1327 244 148 200   395     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.
1326 1326 243 15 81 211 116 187 528 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.
1325 1325 241 147 198 210 394 185   Columbus Avenue at Green & Stockton  
1324 1324 241 147 198 210 394 185   Danilo's Bakery (Green Street & Bannam Place)  
1323 1323 241 147 198 210 394 185   Mama's Restaurant (1701 Stockton)  

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