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
1589 301 62 22nd Avenue & Balboa Street (Richmond District)   38 6 245 261 434 233  
1588 301 62 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. 38 6 245 261 434 233  
1587 301 62 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 38 6 245 261 434 233  
1586 301 62 Hyde Street Pier   38 6 245 261 434 233  
1585 301 62 Lombard Street between Hyde and Leavenworth   38 6 245 261 434 233  
1584 301 62 San Francisco Hilton (333 O'Farrell Street)   38 6 245 261 434 233  
1583 301 62 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. 38 6 245 261 434 233  
1558 296 37 Tosca Café (242 Columbus Avenue, North Beach)   172 6 241 256 430    
1542 290 43     52 6 237 250 426 225  
1447 269 26 skyline/ exterior scenes   128 6 222 233 391 206  
1445 267 63 Burritt Alley (Off Bush Street, between Powell and Stockton Streets)   38 6 220 231 289 204 541
1444 267 63 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 38 6 220 231 289 204 541
1443 267 63 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. 38 6 220 231 289 204 541
1428 262 71 Coffee Dan's (O'Farrell Street at Powell)   38 6 217 228 407 200 536
1401 255 45 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. 38 6 210 222 295 195 60
1400 255 45 23rd & Capp Streets (Mission District)   38 6 210 222 295 195 60
1399 255 45 24th Street Mini Park (Mission District)   38 6 210 222 295 195 60
1398 255 45 Alcatraz Island Alcatraz Island was a military fort before it became a prison. 38 6 210 222 295 195 60
1397 255 45 Balmy Street (Mission District)   38 6 210 222 295 195 60
1396 255 45 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. 38 6 210 222 295 195 60
1395 255 45 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. 38 6 210 222 295 195 60
1394 255 45 Hall of Justice   38 6 210 222 295 195 60
1393 255 45 Sutter & Webster Streets   38 6 210 222 295 195 60
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
1373 242 23 1954 Mason Street (North Beach)   38 6 199 71 295 186 527
1372 242 23 20th & De Haro 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
1370 242 23 22nd Bet. Carolina & Rhode Island Streets (Potrero Hill)   38 6 199 71 295 186 527
1369 242 23 23rd & Iowa Streets (Dogpatch)   38 6 199 71 295 186 527
1368 242 23 550 El Camino Del Mar (Seacliff)   38 6 199 71 295 186 527
1367 242 23 710 Steiner Street (Hayes Valley)   38 6 199 71 295 186 527
1366 242 23 Carl & Cole Streets (Cole Valley)   38 6 199 71 295 186 527
1365 242 23 Clementina & Sumner Streets   38 6 199 71 295 186 527
1364 242 23 Eber Electronics (2355 Market Street, Castro)   38 6 199 71 295 186 527
1363 242 23 Folsom & Essex Streets   38 6 199 71 295 186 527
1362 242 23 Fremont Street Exit of Bay Bridge   38 6 199 71 295 186 527
1361 242 23 Silver Restaurant (737 Washington Street, Chinatown)   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
1358 242 23 KGO-TV ABC7 TV Studios (900 Front Street, Waterfront Historic District)   38 6 199 71 295 186 527
1357 242 23 McAllister & Scott Streets (Hayes Valley)   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
1355 242 23 Nam Yuen Restaurant (740 Washington Street, Chinatown)   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
1353 242 23 Pier 3 (The Embarcadero)   38 6 199 71 295 186 527
1352 242 23 Pierce & California Streets (Pacific Heights)   38 6 199 71 295 186 527
1351 242 23 Pierce St. & Golden Gate Avenue (Hayes Valley)   38 6 199 71 295 186 527
1350 242 23 Portsmouth Square (Chinatown)   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
1348 242 23 One Thousand Powell Apartments (1000 Powell Street)   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
1346 242 23 San Francisco Drydock (The Dogpatch)   38 6 199 71 295 186 527
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  
1313 242 23 Hall of Justice (850 Bryant Street)   38 6 199 71 295 186 527
1279 235 33 Mission Dolores Park (Mission District) The two land plots that comprise the Park were used as a Jewish cemetery until 1894 when San Francisco prohibited all burials within city limits. The graves were moved to Colma, CA. 38 6 193 205 391 180  
1278 235 33 Blooms Saloon (18th Street between Missouri and Texas Streets)   38 6 193 205 391 180  
1277 235 33 Chrissy Field Chrissy Field was originally an airfield for the Presidio Army Base. 38 6 193 205 391 180  
1276 235 33 Christopher's Books (1400 18th Street)   38 6 193 205 391 180  
1275 235 33 Citicorp Center (1 Sansome Street at Sutter)   38 6 193 205 391 180  
1274 235 33 Farley's Café (1315 18th Street Near Missouri)   38 6 193 205 391 180  
1273 235 33 Foote, Cone & Belding (733 Front Street at Pacific) The building is called "Jabe & Dunne Advertising Agency" in the movie. 38 6 193 205 391 180  
1272 235 33 Hotel Majestic (1500 Sutter Street)   38 6 193 205 391 180  
1271 235 33 Marquee Lofts (1000 Van Ness Avenue at Alice B. Toklas Place)   38 6 193 205 391 180  
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
1254 231 65 Pier 38-40, The Embarcadero   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
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
1251 231 65 Civic Center Plaza   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
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
1248 231 65 Hall of Justice (850 Bryant Street)   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
1246 231 65 McDonald's Restaurant (701 3rd Street, SOMA)   38 6 113 71 295 176 522
1245 231 65 Mt. Davidson Mt. Davidson is highest point in San Francisco (938 feet). 38 6 113 71 295 176 522
1244 231 65 Near Point Lobos, El Camino Del Mar   38 6 113 71 295 176  
1086 204 25 Embarcadero Street   128 6 169 177 371 157  
1085 204 25 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 128 6 169 177 371 157  
993 180 41 Belgravia Apartments (795 Sutter Street at Jones)   38 6 150 155 350 137 465
884 163 22 St. Elizabeth Apartment House (901 Powell Street at Sacramento)   38 6 33 142 79 126 499
879 160 16 18th Street Overpass (Potrero Hill)   59 6 138 139 295 124 497
878 160 16 2190 Washington Street (Pacific Heights)   59 6 138 139 295 124 497
877 160 16 280 Freeway at Pennsylvania and Mariposa Streets   59 6 138 139 295 124 497
876 160 16 Broadway Tunnel (Russian Hill)   59 6 138 139 295 124 497
875 160 16 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. 59 6 138 139 295 124 497
874 160 16 Embarcadero Freeway demolished 59 6 138 139 295 124 497
873 160 16 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. 59 6 138 139 295 124 497
872 160 16 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. 59 6 138 139 295 124 497
871 160 16 Hall of Justice (850 Bryant Street)   59 6 138 139 295 124 497
870 160 16 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. 59 6 138 139 295 124 497
869 160 16 Pacific Heights Towers (2200 Sacramento Street, Pacific Heights)   59 6 138 139 295 124 497
868 160 16 San Francisco Drydock (20th and Illinois Streets)   59 6 138 139 295 124 497
867 160 16 San Francisco International Airport SFO has a museum dedicated to aviation history. 59 6 138 139 295 124 497
866 160 16 Vermont Street between 20th and 22nd Streets   59 6 138 139 295 124 497
865 160 16 Cost Plus World Market (2552 Taylor Street)   59 6 138 139 295 124 497
679 132 32 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. 87 6 123 122 210 108 46
678 132 32 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city. 87 6 123 122 210 108 46
677 132 32 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. 87 6 123 122 210 108 46
647 121 19 1160 Taylor Street   83 6 113 112 322 97  
646 121 19 The Final Final (2990 Baker Street)   83 6 113 112 322 97  
645 121 19 Hobart Building (582 Market Street)   83 6 113 112 322 97  
610 106 11 Potrero &San Bruno   74 6 98 98 311 85 481
Powered by Datasette · Query took 9.566ms · Data source: data.sfgov.org