Film_Locations_in_San_Francisco_fts

Data source: data.sfgov.org

1,622 rows sorted by Production Company

✎ 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
900 900 167   143 146 342     The 500 Club (500 Guerrero Street, Mission District)  
901 901 167   143 146 342     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.
1 1 1 1 1 1 237 1 439 Epic Roasthouse (399 Embarcadero)  
2 2 1 1 1 1 237 1 439 Mason & California Streets (Nob Hill)  
3 3 1 1 1 1 237 1 439 Justin Herman Plaza  
4 4 1 1 1 1 237 1 439 200 block Market Street  
5 5 1 1 1 1 237 1 439 City Hall  
6 6 1 1 1 1 237 1 439 Polk & Larkin Streets  
7 7 1 1 1 1 237 1 439 Randall Museum  
8 8 1 1 1 1 237 1 439 555 Market St.  
9 9 2 2 2   238        
10 10 3 3 3 2 239 2   The Walden House, Buena Vista Park Established in 1867, Buena Vista Park is the oldest official park in San Francisco.
11 11 3 3 3 2 239 2   Café Trieste (609 Vallejo) Francis Ford Coppola allegedly wrote large portions of "The Godfather" trilogy in Café Trieste.
1157 1157 211 3 174 183 72 161      
12 12 4 4 4 3 19 3 440    
20 20 8 4 8 7 243 7   75 California Street  
21 21 9 4 8 7 243 7   Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral.
22 22 9 4 8 7 243 7   Hills Brothers Plaza (Embarcadero at Harrison Street)  
23 23 9 4 8 7 243 7   San Francisco International Airport SFO has a museum dedicated to aviation history.
459 459 87 4 79 80 295 68 471 Alcatraz Island Alcatraz Island was a military fort before it became a prison.
502 502 92 4 83 85 214 72   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.
521 521 98 4 89 90 305 78   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.
522 522 99 4 90 91 306 79 477 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House.
523 523 99 4 90 91 306 79 477 Sutter & Buchannan Streets  
524 524 99 4 90 91 306 79 477 Sutter & Baker Streets  
525 525 99 4 90 91 306 79 477 Sokoji-Soto Zen Buddhist Temple (1691 Laguna Street)  
526 526 99 4 90 91 306 79 477 Sacramento & Hyde Streets (Nob Hill)  
527 527 99 4 90 91 306 79 477 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.
528 528 99 4 90 91 306 79 477 Potrero Hill Bathhouse & Feed Co. (199 Mississippi Street)  
529 529 99 4 90 91 306 79 477 Octavia & Hayes Streets (Hayes Valley)  
530 530 99 4 90 91 306 79 477 Montgomery & Pine Streets (Financial District)  
531 531 99 4 90 91 306 79 477 Laguna & Sacramento Streets (Pacific Heights)  
532 532 99 4 90 91 306 79 477 Hayes Valley Care (601 Laguna Street, Hayes Valley)  
533 533 99 4 90 91 306 79 477 Golden Gate & Steiner Streets (Hayes Valley)  
534 534 99 4 90 91 306 79 477 Fort Point, Presidio Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF.
535 535 99 4 90 91 306 79 477 Fort Mason (Golden Gate National Recreation Area) Constructed in 1864 as a coastal defense site, Fort Mason went on to serve as an army post for more than 100 years.
536 536 99 4 90 91 306 79 477 Flood Building (870 Market Street)  
537 537 99 4 90 91 306 79 477 Fiesta Laundromat (898 S. Van Ness Ave., Mission)  
538 538 99 4 90 91 306 79 477 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.
539 539 99 4 90 91 306 79 477 California & Larkin Streets (Nob Hill)  
540 540 99 4 90 91 306 79 477 Asian Art Museum (200 Larkin Street, Civic Center) The Dalai Lama opened an exhibition on Wisdom and Compassion at the museum in 1991.
541 541 99 4 90 91 306 79 477 Andrew S. Hallidie Plaza (Market & Powell Streets)  
542 542 99 4 90 91 306 79 477 430 Vallejo Street (Telegraph Hill)  
543 543 99 4 90 91 306 79 477 24th and Castro Streets (Noe Valley)  
660 660 126 4 117 24 223 102 487 Lombard & Hyde Streets  
676 676 131 4 122 121 12 107   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.
685 685 126 4 117 24 223 102 487 Hall of Justice (850 Bryant Street)  
706 706 126 4 117 24 223 102 487 Japanese Tea Garden (Hagiwara Tea Garden Drive, Golden Gate Park) The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden
707 707 126 4 117 24 223 102 487 Fior d' Italia (601 Union Street at Stockton)  
708 708 126 4 117 24 223 102 487 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.
709 709 126 4 117 24 223 102 487 Washington Square (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach.
710 710 126 4 117 24 223 102 487 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House.
711 711 126 4 117 24 223 102 487 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.
712 712 126 4 117 24 223 102 487 Palace of Fine Arts The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965.
903 903 169 4 145 148 343 130   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.
904 904 169 4 145 148 343 130   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.
1023 1023 191 4 160 35 360 147 507 Balboa at 22nd Avenue  
1024 1024 191 4 160 35 360 147 507 The Music Concourse (Martin Luther King, Jr. Drive, Golden Gate Park) The theater closed in 1985.
1025 1025 191 4 160 35 360 147 507 Surf Theater (4520 Irving Street)  
1026 1026 191 4 160 35 360 147 507 Hyde Street Cable Car  
1027 1027 191 4 160 35 360 147 507 Aquatic Park (Jefferson Street) Located at one end of Fisherman's Wharf, Aquatic Park was built as part of FDR's Works Progress Administration Project.
1028 1028 191 4 160 35 360 147 507 15-17 Fresno Street  
1133 1133 209 4 111 181 324 160   Pier 24  
1158 1158 212 4 175 184 375 162   Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.
1213 1213 224 4 186 195 383 171 518 Golden Gate Park  
1214 1214 225 4 187 196 383 171 518 West Harbor, Marina District  
1215 1215 225 4 187 196 383 171 518 North Beach  
1216 1216 225 4 187 196 383 171 518 Marina Green, Marina District Before the 1906 earthquake, the land on which Marina Green sits was a tidal marsh, and rubble from the earthquake was dumped on the site. However, the site was filled in to provide land for the 1915 Panama-Pacific Exhibition.
1217 1217 225 4 187 196 383 171 518 Kearny & Pacific Streets  
1218 1218 225 4 187 196 383 171 518 Intersection of Grant & Fresno Streets (North Beach)  
1219 1219 225 4 187 196 383 171 518 Intersection of Columbus & Mason Streets  
1220 1220 225 4 187 196 383 171 518 Intersection of Columbus & Kearney Streets  
1221 1221 225 4 187 196 383 171 518 Golden Gate Park  
1222 1222 225 4 187 196 383 171 518 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.
1223 1223 225 4 187 196 383 171 518 Bessie Charmichael Elementary School (375 Seventh Street, SOMA)  
1224 1224 225 4 187 196 383 171 518 500 Block of Pacific Avenue (Chinatown)  
1225 1225 226 4 186 197 383 171 518 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.
1456 1456 275 4 226 238 107 211 46 Washington Street & Waverly Place (Chinatown)  
1457 1457 275 4 226 238 107 211 46 Sansome Street (The Embarcadero)  
1458 1458 275 4 226 238 107 211 46 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.
1459 1459 275 4 226 238 107 211 46 Montgomery & Vallejo Streets (Telegraph Hill)  
1460 1460 275 4 226 238 107 211 46 Market & 2nd Streets  
1461 1461 275 4 226 238 107 211 46 Hayes & Polk Streets (Civic Center)  
1462 1462 275 4 226 238 107 211 46 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.
1463 1463 275 4 226 238 107 211 46 Fort Point (Presidio, Golden Gate National Recreation Area) Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF.
1464 1464 275 4 226 238 107 211 46 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.
1465 1465 275 4 226 238 107 211 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.
1466 1466 275 4 226 238 107 211 46 Civic Center Plaza  
1467 1467 275 4 226 238 107 211 46 Battery Street (The Embarcadero)  
1468 1468 275 4 226 238 107 211 46 900 Block of Grant Avenue (Chinatown)  
1469 1469 275 4 226 238 107 211 46 700 Block of Jackson Street (Chinatown)  
1470 1470 275 4 226 238 107 211 46 200 Block of Sansome Street (Financial District)  
1495 1495 282 4 231 243 419 218 15 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Exteriors of the church were used.
1517 1517 288 4 236 248 424 223 545    
1547 1547 209 4 111 181 324 160   Red's Java House (Pier 30-32, The Embarcadero)  
1548 1548 209 4 111 181 324 160   Piers 30-32  
1549 1549 209 4 111 181 324 160   Pier 39  
1550 1550 209 4 111 181 324 160   Mojito (1337-1339 Grant Avenue)  
1551 1551 209 4 111 181 324 160   McCovey Point, China Basin Park (24 Willy Mays Plaza)  
1552 1552 209 4 111 181 324 160   Veterans' War Memorial Building (401 Van Ness Avenue)  

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