Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | Title | Production Company | Director | Writer | Actor 1 | Actor 2 ▼ | Actor 3 | Locations | Fun Facts |
---|---|---|---|---|---|---|---|---|---|---|
9 | 9 | 2 | 2 | 2 | 238 | |||||
88 | 88 | 22 | 19 | 20 | 19 | 255 | Ocean Beach | On Jan. 25, 1878, the King Philip ship crashed in Ocean Beach. Occasionally, the ship's wreckage may be found on the beach-- most recently it was seen in 2007. | ||
89 | 89 | 23 | 20 | 21 | 20 | 256 | Hyde Street Cable Car | SF Cable Cars are the only moving National Historical Landmark. | ||
127 | 127 | 33 | 29 | 31 | 30 | 265 | 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. | ||
128 | 128 | 33 | 29 | 31 | 30 | 265 | 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. | ||
129 | 129 | 33 | 29 | 31 | 30 | 265 | 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. | ||
130 | 130 | 33 | 29 | 31 | 30 | 265 | 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. | ||
131 | 131 | 33 | 29 | 31 | 30 | 265 | Grace Cathedral Episcopal Church (1100 California Street) | Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. | ||
196 | 196 | 40 | 35 | 38 | 37 | Ina Coolbrith Park (1700 Taylor Street) | ||||
197 | 197 | 40 | 35 | 38 | 37 | 0-100 block Halleck Street | ||||
238 | 238 | 44 | 39 | 42 | 41 | 275 | The Lexington Club (3464 19th Street at Lexington) | |||
239 | 239 | 44 | 39 | 42 | 41 | 275 | Royan Hotel (405 Valencia Street, Mission District) | |||
240 | 240 | 44 | 39 | 42 | 41 | 275 | Department of Public Health (101 Grove Street at Polk, Civic Center) | |||
324 | 324 | 58 | 44 | 53 | 54 | 281 | ||||
594 | 594 | 105 | 73 | 97 | 97 | 310 | Sacramento & Washington Streets | |||
628 | 628 | 113 | 78 | 105 | 105 | 240 | ||||
629 | 629 | 114 | 15 | 106 | 106 | 317 | 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. | ||
633 | 633 | 116 | 15 | 108 | 107 | 319 | 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. | ||
634 | 634 | 116 | 15 | 108 | 107 | 319 | 2810 Pacific Avenue | |||
635 | 635 | 116 | 15 | 108 | 107 | 319 | War Memorial Opera House (401 Van Ness Avenue) | In 1945 the United Nations had its first conference at The War Memorial Opera House. | ||
636 | 636 | 116 | 15 | 108 | 107 | 319 | Conservatory of Flowers (Golden Gate Park) | The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. | ||
701 | 701 | 135 | 90 | 125 | 125 | 1 Post Street | ||||
736 | 736 | 147 | 100 | 135 | 136 | Lusty Lady Bar (North Beach) | ||||
862 | 862 | 159 | 102 | 137 | 138 | 340 | The Marsh Theatre (1062 Valencia Street) | |||
863 | 863 | 159 | 102 | 137 | 138 | 340 | 20 Hill Street | |||
864 | 864 | 159 | 102 | 137 | 138 | 340 | 198 Gough Street | |||
885 | 885 | 164 | 104 | 140 | 143 | 3 | Bush Street at Jones | |||
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. | |||
974 | 974 | 175 | 110 | 148 | 152 | 345 | 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. | ||
1006 | 1006 | 186 | 117 | 155 | 161 | 356 | Filbert from Hyde to Leavenworth | |||
1007 | 1007 | 186 | 117 | 155 | 161 | 356 | Columbus and Green | |||
1008 | 1008 | 186 | 117 | 155 | 161 | 356 | Larkin & Fulton | |||
1009 | 1009 | 186 | 117 | 155 | 161 | 356 | Embarcadero & Market | |||
1070 | 1070 | 199 | 125 | 45 | 172 | 367 | ||||
1071 | 1071 | 200 | 77 | 166 | 173 | 316 | Magic Theater (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. | ||
1087 | 1087 | 205 | 129 | 170 | 178 | 258 | 2nd St. at Townsend St. | |||
1088 | 1088 | 205 | 129 | 170 | 178 | 258 | Jefferson St. at Powell St. | |||
1089 | 1089 | 205 | 129 | 170 | 178 | 258 | Grant St. at Bush St. | Characters walk down street and it's totally wrecked from a massive earthquake | ||
1090 | 1090 | 205 | 129 | 170 | 178 | 258 | Vallejo Garage Roof (Vallejo at Powell) | |||
1091 | 1091 | 205 | 129 | 170 | 178 | 258 | Clay St. at Taylor | 3 characters walk down the street. An earthquake shakes the city and stuff starts breaking. One character gets a shard of glass stuck in his leg. | ||
1092 | 1092 | 205 | 129 | 170 | 178 | 258 | Bay St. at Polk | |||
1093 | 1093 | 205 | 129 | 170 | 178 | 258 | Intersection of Lombard and Hyde | |||
1094 | 1094 | 205 | 129 | 170 | 178 | 258 | Mission between 3rd and 4th St. | |||
1095 | 1095 | 205 | 129 | 170 | 178 | 258 | 555 California | Characters walk out of broken window of 555 California out to Kearny St. Splinter unit films a car driving into the garage at 555 California | ||
1096 | 1096 | 205 | 129 | 170 | 178 | 258 | Broadway and Kearney | |||
1097 | 1097 | 205 | 129 | 170 | 178 | 258 | Grant between Bush and Market | |||
1098 | 1098 | 205 | 129 | 170 | 178 | 258 | Coit Tower | |||
1099 | 1099 | 205 | 129 | 170 | 178 | 258 | TransAmerica Pyramid (600 Montgomery Street) | |||
1100 | 1100 | 205 | 129 | 170 | 178 | 258 | Washington Square | |||
1101 | 1101 | 205 | 129 | 170 | 178 | 258 | Battery Spencer | |||
1102 | 1102 | 205 | 129 | 170 | 178 | 258 | Pier 43 | Bystanders watch as a tsunami crashes over them | ||
1103 | 1103 | 205 | 129 | 170 | 178 | 258 | Vallejo St. Garage, 766 Vallejo St. | Characters watch from roof of garage as tsunami hits SF waterfront | ||
1104 | 1104 | 205 | 129 | 170 | 178 | 258 | Fort Baker | |||
1105 | 1105 | 205 | 129 | 170 | 178 | 258 | AT&T Stadium | 3 characters run out of stadium, there is a group of people on the sidewalk, an earthquake hits, and they duck for cover | ||
1106 | 1106 | 205 | 129 | 170 | 178 | 258 | AT&T Stadium | two paragliders land on the field of AT&T Park | ||
1107 | 1107 | 205 | 129 | 170 | 178 | 258 | Water work in SF Bay | Characters drive in a high speed picture boat to see different views of the city. | ||
1108 | 1108 | 205 | 129 | 170 | 178 | 258 | Stage Work, 47 Julian St. | |||
1109 | 1109 | 205 | 129 | 170 | 178 | 258 | Hyde St. at Greenwich and Hyde St. at Lombard | Characters walk to get a vantage point for Coit tower. 250 actors walking "fleeing" the city after earthquake | ||
1110 | 1110 | 205 | 129 | 170 | 178 | 258 | Asia Star Fantasy, 1126 Grant Ave. | Characters look for a form of communication with LA in a post-quake trashed city | ||
1114 | 1114 | 208 | 131 | 172 | 180 | 374 | 18th Street between Guerrero and Valencia Streets | Re-enactment of "Dyke's on Bikes" and "Dyke March" | ||
1115 | 1115 | 208 | 131 | 172 | 180 | 374 | Atlas Café, 3049 20th St. | Dialogue scene inside the café | ||
1116 | 1116 | 208 | 131 | 172 | 180 | 374 | Clarion Alley between Valencia & Mission St. | Ladies discuss their relationship in the mural alley | ||
1117 | 1117 | 208 | 131 | 172 | 180 | 374 | Harrison & 20th | Driving shots | ||
1118 | 1118 | 208 | 131 | 172 | 180 | 374 | Folsom | Driving shots | ||
1119 | 1119 | 208 | 131 | 172 | 180 | 374 | 16th St. | Driving shots | ||
1120 | 1120 | 208 | 131 | 172 | 180 | 374 | S. Van Ness | Driving shots | ||
1121 | 1121 | 208 | 131 | 172 | 180 | 374 | 22nd St. | Driving shots | ||
1122 | 1122 | 208 | 131 | 172 | 180 | 374 | Harrison | Driving shots | ||
1123 | 1123 | 208 | 131 | 172 | 180 | 374 | 20th | Driving shots | ||
1124 | 1124 | 208 | 131 | 172 | 180 | 374 | Z Space Studios; 450 Florida St. | Filming of the "Fresh Meat" Festival | ||
1125 | 1125 | 208 | 131 | 172 | 180 | 374 | 375 Castro St. and 17th between Castro and Diamond St. | Chase sequence on bicycles ends at gas station | ||
1126 | 1126 | 208 | 131 | 172 | 180 | 374 | Corbett St. | Bicycle chase scene, actors dressed as fake officers present | ||
1127 | 1127 | 208 | 131 | 172 | 180 | 374 | Romain St. | Bicycle chase scene | ||
1128 | 1128 | 208 | 131 | 172 | 180 | 374 | Market St. overpass | Bicycle chase scene | ||
1129 | 1129 | 208 | 131 | 172 | 180 | 374 | Grand View Ave. | Bicycle chase scene | ||
1130 | 1130 | 208 | 131 | 172 | 180 | 374 | Vallejo Street Garage; 766 Vallejo St. | dialogue scene on top of a garage roof | ||
1131 | 1131 | 208 | 131 | 172 | 180 | 374 | Laguna Honda Hospital; 375 Laguna Honda Blvd. | dialogue scene | ||
1132 | 1132 | 208 | 131 | 172 | 180 | 374 | Irving St. at 9th Ave. | continuous driving shots of a taxi going with the flow of existing traffic | ||
1134 | 1134 | 208 | 131 | 172 | 180 | 374 | Dolores Park, 20th St. between Church & Dolores St. | group of friends have a heated argument, then flashback of pre-argument | ||
1135 | 1135 | 208 | 131 | 172 | 180 | 374 | Palace of Fine Arts: 3306 Lyon St. | Filming of "Dyke's on Bikes" and "Dyke March" | ||
1136 | 1136 | 208 | 131 | 172 | 180 | 374 | Van Ness and 12th St. | A couple reminisces on the moment they first fell in love | ||
1137 | 1137 | 208 | 131 | 172 | 180 | 374 | "Metzger's Apt" 151 Alice B. Toklas Pl. | Overnight scene involving aggressive arguments between actors, spfx shoot out involved | ||
1280 | 1280 | 236 | 143 | 194 | 206 | 392 | Broadway Studios (435 Broadway at Montgomery Street) | |||
1281 | 1281 | 236 | 143 | 194 | 206 | 392 | Regency Building (1290 Sutter Street) | |||
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. | |||
1330 | 1330 | 246 | 149 | 202 | 213 | 396 | ||||
1359 | 1359 | 251 | 152 | 206 | 218 | 398 | ||||
1403 | 1403 | 257 | 155 | 212 | 403 | |||||
1546 | 1546 | 294 | 171 | 239 | 254 | 429 | ||||
1558 | 1558 | 296 | 172 | 241 | 256 | 430 | Tosca Café (242 Columbus Avenue, North Beach) | |||
1582 | 1582 | 300 | 175 | 244 | 260 | 433 | Golden Gate National Recreation Area | The size of the Recreation Area is over two and a half greater than that of the city and county of San Francisco. | ||
1620 | 1620 | 305 | 178 | 248 | 264 | 436 | 312 Fillmore Street | |||
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 |
JSON shape: default, array, newline-delimited
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");