Film_Locations_in_San_Francisco_fts

Data source: data.sfgov.org

1,622 rows sorted by Actor 2

View and edit SQL

Link rowid Title Production Company Director Writer Actor 1 Actor 2 ▼ Actor 3 Locations Fun Facts
9 2 2 2   238        
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 23 20 21 20 256     Hyde Street Cable Car SF Cable Cars are the only moving National Historical Landmark.
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 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 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 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 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 40 35 38 37       Ina Coolbrith Park (1700 Taylor Street)  
197 40 35 38 37       0-100 block Halleck Street  
238 44 39 42 41 275     The Lexington Club (3464 19th Street at Lexington)  
239 44 39 42 41 275     Royan Hotel (405 Valencia Street, Mission District)  
240 44 39 42 41 275     Department of Public Health (101 Grove Street at Polk, Civic Center)  
324 58 44 53 54 281        
594 105 73 97 97 310     Sacramento & Washington Streets  
628 113 78 105 105 240        
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 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 116 15 108 107 319     2810 Pacific Avenue  
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 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 135 90 125 125       1 Post Street  
736 147 100 135 136       Lusty Lady Bar (North Beach)  
862 159 102 137 138 340     The Marsh Theatre (1062 Valencia Street)  
863 159 102 137 138 340     20 Hill Street  
864 159 102 137 138 340     198 Gough Street  
885 164 104 140 143 3     Bush Street at Jones  
900 167   143 146 342     The 500 Club (500 Guerrero Street, Mission District)  
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 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 186 117 155 161 356     Filbert from Hyde to Leavenworth  
1007 186 117 155 161 356     Columbus and Green  
1008 186 117 155 161 356     Larkin & Fulton  
1009 186 117 155 161 356     Embarcadero & Market  
1070 199 125 45 172 367        
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 205 129 170 178 258     2nd St. at Townsend St.  
1088 205 129 170 178 258     Jefferson St. at Powell St.  
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 205 129 170 178 258     Vallejo Garage Roof (Vallejo at Powell)  
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 205 129 170 178 258     Bay St. at Polk  
1093 205 129 170 178 258     Intersection of Lombard and Hyde  
1094 205 129 170 178 258     Mission between 3rd and 4th St.  
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 205 129 170 178 258     Broadway and Kearney  
1097 205 129 170 178 258     Grant between Bush and Market  
1098 205 129 170 178 258     Coit Tower  
1099 205 129 170 178 258     TransAmerica Pyramid (600 Montgomery Street)  
1100 205 129 170 178 258     Washington Square  
1101 205 129 170 178 258     Battery Spencer  
1102 205 129 170 178 258     Pier 43 Bystanders watch as a tsunami crashes over them
1103 205 129 170 178 258     Vallejo St. Garage, 766 Vallejo St. Characters watch from roof of garage as tsunami hits SF waterfront
1104 205 129 170 178 258     Fort Baker  
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 205 129 170 178 258     AT&T Stadium two paragliders land on the field of AT&T Park
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 205 129 170 178 258     Stage Work, 47 Julian St.  
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 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 208 131 172 180 374     18th Street between Guerrero and Valencia Streets Re-enactment of "Dyke's on Bikes" and "Dyke March"
1115 208 131 172 180 374     Atlas Café, 3049 20th St. Dialogue scene inside the café
1116 208 131 172 180 374     Clarion Alley between Valencia & Mission St. Ladies discuss their relationship in the mural alley
1117 208 131 172 180 374     Harrison & 20th Driving shots
1118 208 131 172 180 374     Folsom Driving shots
1119 208 131 172 180 374     16th St. Driving shots
1120 208 131 172 180 374     S. Van Ness Driving shots
1121 208 131 172 180 374     22nd St. Driving shots
1122 208 131 172 180 374     Harrison Driving shots
1123 208 131 172 180 374     20th Driving shots
1124 208 131 172 180 374     Z Space Studios; 450 Florida St. Filming of the "Fresh Meat" Festival
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 208 131 172 180 374     Corbett St. Bicycle chase scene, actors dressed as fake officers present
1127 208 131 172 180 374     Romain St. Bicycle chase scene
1128 208 131 172 180 374     Market St. overpass Bicycle chase scene
1129 208 131 172 180 374     Grand View Ave. Bicycle chase scene
1130 208 131 172 180 374     Vallejo Street Garage; 766 Vallejo St. dialogue scene on top of a garage roof
1131 208 131 172 180 374     Laguna Honda Hospital; 375 Laguna Honda Blvd. dialogue scene
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 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 208 131 172 180 374     Palace of Fine Arts: 3306 Lyon St. Filming of "Dyke's on Bikes" and "Dyke March"
1136 208 131 172 180 374     Van Ness and 12th St. A couple reminisces on the moment they first fell in love
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 236 143 194 206 392     Broadway Studios (435 Broadway at Montgomery Street)  
1281 236 143 194 206 392     Regency Building (1290 Sutter Street)  
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 246 149 202 213 396        
1359 251 152 206 218 398        
1403 257 155 212   403        
1546 294 171 239 254 429        
1558 296 172 241 256 430     Tosca Café (242 Columbus Avenue, North Beach)  
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 305 178 248 264 436     312 Fillmore Street  
1 1 1 1 1 237 1 439 Epic Roasthouse (399 Embarcadero)  
2 1 1 1 1 237 1 439 Mason & California Streets (Nob Hill)  
3 1 1 1 1 237 1 439 Justin Herman Plaza  
4 1 1 1 1 237 1 439 200 block Market Street  
5 1 1 1 1 237 1 439 City Hall  
6 1 1 1 1 237 1 439 Polk & Larkin Streets  
7 1 1 1 1 237 1 439 Randall Museum  

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