Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | Title | Release Year | Locations | Fun Facts | Production Company | Distributor | Director | Writer | Actor 1 ▼ | Actor 2 | Actor 3 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1304 | 1304 | Terminator - Genisys 239 | 2015 10 | Bush St. at Stockton St. | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
1305 | 1305 | Terminator - Genisys 239 | 2015 10 | Powell St at Geary St | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
1306 | 1306 | Terminator - Genisys 239 | 2015 10 | 1 Market St. Landmark Building | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
1307 | 1307 | Terminator - Genisys 239 | 2015 10 | Embarcadero between Pier 2 and Harrison | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
1308 | 1308 | Terminator - Genisys 239 | 2015 10 | Pier 14 | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
1309 | 1309 | Terminator - Genisys 239 | 2015 10 | Pine St. between Market and Montgomery | T5 Productions LLC 145 | Paramount Pictures 3 | Alan Taylor 196 | James Cameron 208 | Arnold Schwarzenegger 334 | Jason Clarke 183 | ||
903 | 903 | Mother 169 | 1996 43 | 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. | Paramount Pictures 4 | Paramount Pictures 3 | Albert Brooks 145 | Albert Brooks 148 | Albert Brooks 343 | Debbie Reynolds 130 | |
904 | 904 | Mother 169 | 1996 43 | 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. | Paramount Pictures 4 | Paramount Pictures 3 | Albert Brooks 145 | Albert Brooks 148 | Albert Brooks 343 | Debbie Reynolds 130 | |
1023 | 1023 | Play it Again, Sam 191 | 1972 62 | Balboa at 22nd Avenue | Paramount Pictures 4 | Paramount Pictures 3 | Herbert Ross 160 | Woody Allen 35 | Woody Allen 360 | Diane Keaton 147 | Tony Roberts 507 | |
1024 | 1024 | Play it Again, Sam 191 | 1972 62 | The Music Concourse (Martin Luther King, Jr. Drive, Golden Gate Park) | The theater closed in 1985. | Paramount Pictures 4 | Paramount Pictures 3 | Herbert Ross 160 | Woody Allen 35 | Woody Allen 360 | Diane Keaton 147 | Tony Roberts 507 |
1025 | 1025 | Play it Again, Sam 191 | 1972 62 | Surf Theater (4520 Irving Street) | Paramount Pictures 4 | Paramount Pictures 3 | Herbert Ross 160 | Woody Allen 35 | Woody Allen 360 | Diane Keaton 147 | Tony Roberts 507 | |
1026 | 1026 | Play it Again, Sam 191 | 1972 62 | Hyde Street Cable Car | Paramount Pictures 4 | Paramount Pictures 3 | Herbert Ross 160 | Woody Allen 35 | Woody Allen 360 | Diane Keaton 147 | Tony Roberts 507 | |
1027 | 1027 | Play it Again, Sam 191 | 1972 62 | 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. | Paramount Pictures 4 | Paramount Pictures 3 | Herbert Ross 160 | Woody Allen 35 | Woody Allen 360 | Diane Keaton 147 | Tony Roberts 507 |
1028 | 1028 | Play it Again, Sam 191 | 1972 62 | 15-17 Fresno Street | Paramount Pictures 4 | Paramount Pictures 3 | Herbert Ross 160 | Woody Allen 35 | Woody Allen 360 | Diane Keaton 147 | Tony Roberts 507 | |
1030 | 1030 | Pleasure of His Company 193 | 1961 47 | Grace Cathedral Episcopal Church (1100 California Street) | Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. | Perlsea Company 122 | Paramount Pictures 3 | George Seaton 162 | Samuel A. Taylor 166 | Fred Astaire 362 | Debbie Reynolds 130 | Lilli Palmer 508 |
1158 | 1158 | Serial 212 | 1980 34 | Ferry Building | Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. | Paramount Pictures 4 | Paramount Pictures 3 | Bill Persky 175 | Rich Eustis 184 | Martin Mull 375 | Tuesday Weld 162 | |
1213 | 1213 | Star Trek II : The Wrath of Khan 224 | 1982 4 | Golden Gate Park | Paramount Pictures 4 | Paramount Pictures 3 | Nicholas Meyer 186 | Jack B. Sowards 195 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
1214 | 1214 | Star Trek IV: The Voyage Home 225 | 1986 28 | West Harbor, Marina District | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
1215 | 1215 | Star Trek IV: The Voyage Home 225 | 1986 28 | North Beach | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
1216 | 1216 | Star Trek IV: The Voyage Home 225 | 1986 28 | 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. | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 |
1217 | 1217 | Star Trek IV: The Voyage Home 225 | 1986 28 | Kearny & Pacific Streets | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
1218 | 1218 | Star Trek IV: The Voyage Home 225 | 1986 28 | Intersection of Grant & Fresno Streets (North Beach) | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
1219 | 1219 | Star Trek IV: The Voyage Home 225 | 1986 28 | Intersection of Columbus & Mason Streets | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
1220 | 1220 | Star Trek IV: The Voyage Home 225 | 1986 28 | Intersection of Columbus & Kearney Streets | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
1221 | 1221 | Star Trek IV: The Voyage Home 225 | 1986 28 | Golden Gate Park | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
1222 | 1222 | Star Trek IV: The Voyage Home 225 | 1986 28 | 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. | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 |
1223 | 1223 | Star Trek IV: The Voyage Home 225 | 1986 28 | Bessie Charmichael Elementary School (375 Seventh Street, SOMA) | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
1224 | 1224 | Star Trek IV: The Voyage Home 225 | 1986 28 | 500 Block of Pacific Avenue (Chinatown) | Paramount Pictures 4 | Paramount Pictures 3 | Leonard Nimoy 187 | Steve Meerson 196 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 | |
1225 | 1225 | Star Trek VI: The Undiscovered Country 226 | 1991 37 | 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. | Paramount Pictures 4 | Paramount Pictures 3 | Nicholas Meyer 186 | Nimoy 197 | William Shatner 383 | Leonard Nimoy 171 | George Takei 518 |
1345 | 1345 | The Core 250 | 2003 38 | 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. | David Foster Productions 151 | Paramount Pictures 3 | John Amiel 205 | Cooper Lane 217 | Aaron Eckhart 397 | Hilary Swank 192 | |
1495 | 1495 | The Ten Commandments 282 | 1956 73 | St. Peter & Paul's Church (666 Filbert Street, Washington Square) | Exteriors of the church were used. | Paramount Pictures 4 | Paramount Pictures 3 | Cecil B. DeMille 231 | Jesse L. Lasky, Jr. 243 | Charlton Heston 419 | Yul Brynner 218 | Anne Baxter 15 |
1517 | 1517 | Thief of Hearts 288 | 1984 40 | Paramount Pictures 4 | Paramount Pictures 3 | Douglas Day Stewart 236 | Douglas Day Stewart 248 | Steven Bauer 424 | David Caruso 223 | Barbara Williams 545 | ||
1565 | 1565 | Vertigo 298 | 1958 72 | 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. | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 |
1566 | 1566 | Vertigo 298 | 1958 72 | York Hotel (940 Sutter Street) | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 | |
1567 | 1567 | Vertigo 298 | 1958 72 | San Francisco Drydock (20th and Illinois Streets) | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 | |
1568 | 1568 | Vertigo 298 | 1958 72 | Park Hill Sanatorium (351 Buena Vista Avenue East) | This location is now a condominium complex. | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 |
1569 | 1569 | Vertigo 298 | 1958 72 | Mission San Juan Bautista (2nd & Mariposa Streets) | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 | |
1570 | 1570 | Vertigo 298 | 1958 72 | Mission Dolores (3321 16th Street, Mission District) | Mission Dolores' official name is Mission San Francisco de Assis. It is the oldest building in San Francisco, built in 1791, and has survived two major earthquakes. | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 |
1571 | 1571 | Vertigo 298 | 1958 72 | Gough & Eddy Streets (Western Addition) | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 | |
1572 | 1572 | Vertigo 298 | 1958 72 | 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. | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 |
1573 | 1573 | Vertigo 298 | 1958 72 | 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. | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 |
1574 | 1574 | Vertigo 298 | 1958 72 | Ernie's Restaurant (847 Montgomery Street) | Called the "Essex Club" in the film. | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 |
1575 | 1575 | Vertigo 298 | 1958 72 | Conservatory of Flowers (Golden Gate Park) | The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 |
1576 | 1576 | Vertigo 298 | 1958 72 | Claude Lane at Bush Street | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 | |
1577 | 1577 | Vertigo 298 | 1958 72 | California Palace of the Legion of Honor (34th Avenue & Clement, Lincoln Park) | Built in 1924, the Legion of Honor is a 3/4 replica of the Parisian Palais de la Legion d'Honneur. | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 |
1578 | 1578 | Vertigo 298 | 1958 72 | Brocklebank Apartments (1000 Mason Street) | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 | |
1579 | 1579 | Vertigo 298 | 1958 72 | 900 Lombard Street | Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 |
1580 | 1580 | Vertigo 298 | 1958 72 | 1007 Gough Street | Tennis courts now sit on the site; in the movie the structure was Carlota Valdes' home. | Alfred J. Hitchcock Productions 174 | Paramount Pictures 3 | Alfred Hitchcock 81 | Alec Coppel 258 | James Stewart 432 | Kim Novak 231 | Barbara Bel Geddes 106 |
1622 | 1622 | Zodiac 307 | 2007 75 | SF Chronicle Building (901 Mission St) | Paramount Pictures 4 | Paramount Pictures 3 | David Fincher 213 | James Vanderbilt 266 | Jake Gyllenhaal 438 | Mark Ruffalo 118 |
JSON shape: default, array, newline-delimited
CREATE TABLE "Film_Locations_in_San_Francisco" ( "Title" INTEGER, "Release Year" INTEGER, "Locations" TEXT, "Fun Facts" REAL, "Production Company" INTEGER, "Distributor" INTEGER, "Director" INTEGER, "Writer" INTEGER, "Actor 1" INTEGER, "Actor 2" INTEGER, "Actor 3" INTEGER , FOREIGN KEY ("Title") REFERENCES [Title](id), FOREIGN KEY ("Director") REFERENCES [Director](id), FOREIGN KEY ("Actor 2") REFERENCES [Actors](id), FOREIGN KEY ("Actor 1") REFERENCES [Actors](id), FOREIGN KEY ("Writer") REFERENCES [Writer](id), FOREIGN KEY ("Release Year") REFERENCES [Release Year](id), FOREIGN KEY ("Actor 3") REFERENCES [Actors](id), FOREIGN KEY ("Production Company") REFERENCES [Production Company](id), FOREIGN KEY ("Distributor") REFERENCES [Distributor](id)); CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title"); CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director"); CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2"); CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1"); CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer"); CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year"); CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3"); CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company"); CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");