Data source: data.sfgov.org
| rowid | Title | Release Year | Locations | Fun Facts | Production Company | Distributor | Director | Writer | Actor 1 | Actor 2 | Actor 3 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 12 | 4 | 4 | 4 | 3 | 4 | 3 | 19 | 3 | 440 | ||
| 76 | 21 | 17 | 18 | 3 | 4 | 3 | 3 | 19 | |||
| 1517 | 288 | 40 | 4 | 3 | 236 | 248 | 424 | 223 | 545 | ||
| 1553 | 209 | 5 | 4 | 3 | 111 | 181 | 324 | 160 | |||
| 1306 | 239 | 10 | 1 Market St. Landmark Building | 145 | 3 | 196 | 208 | 334 | 183 | ||
| 1580 | 298 | 72 | 1007 Gough Street | Tennis courts now sit on the site; in the movie the structure was Carlota Valdes' home. | 174 | 3 | 81 | 258 | 432 | 231 | 106 |
| 1028 | 191 | 62 | 15-17 Fresno Street | 4 | 3 | 160 | 35 | 360 | 147 | 507 | |
| 1286 | 239 | 10 | 16th and Utah | Helicopter flies over Utah St. from 16th, rises up before freeway | 145 | 3 | 196 | 208 | 334 | 183 | |
| 1470 | 275 | 23 | 200 Block of Sansome Street (Financial District) | 4 | 3 | 226 | 238 | 107 | 211 | 46 | |
| 543 | 99 | 7 | 24th and Castro Streets (Noe Valley) | 4 | 3 | 90 | 91 | 306 | 79 | 477 | |
| 542 | 99 | 7 | 430 Vallejo Street (Telegraph Hill) | 4 | 3 | 90 | 91 | 306 | 79 | 477 | |
| 1224 | 225 | 28 | 500 Block of Pacific Avenue (Chinatown) | 4 | 3 | 187 | 196 | 383 | 171 | 518 | |
| 1469 | 275 | 23 | 700 Block of Jackson Street (Chinatown) | 4 | 3 | 226 | 238 | 107 | 211 | 46 | |
| 20 | 8 | 8 | 75 California Street | 4 | 3 | 8 | 7 | 243 | 7 | ||
| 1468 | 275 | 23 | 900 Block of Grant Avenue (Chinatown) | 4 | 3 | 226 | 238 | 107 | 211 | 46 | |
| 1579 | 298 | 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. | 174 | 3 | 81 | 258 | 432 | 231 | 106 |
| 676 | 131 | 35 | 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. | 4 | 3 | 122 | 121 | 12 | 107 | |
| 1337 | 249 | 49 | Alamo Square (Hayes Valley) | 92 | 3 | 127 | 216 | 178 | 191 | 530 | |
| 459 | 87 | 44 | Alcatraz Island | Alcatraz Island was a military fort before it became a prison. | 4 | 3 | 79 | 80 | 295 | 68 | 471 |
| 1336 | 249 | 49 | Alcoa Building (1 Maritime Plaza) | A partially-above ground parking structure near the building made it necessary for architects to make the Alcoa Building's diagonal bracing visible, instead of placing it inside and drastically reducing the amount usable interior space. | 92 | 3 | 127 | 216 | 178 | 191 | 530 |
| 1335 | 249 | 49 | 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. | 92 | 3 | 127 | 216 | 178 | 191 | 530 |
| 1334 | 249 | 49 | American Roofing Co. Building (297 Kansas Street, Potrero Hill) | 92 | 3 | 127 | 216 | 178 | 191 | 530 | |
| 541 | 99 | 7 | Andrew S. Hallidie Plaza (Market & Powell Streets) | 4 | 3 | 90 | 91 | 306 | 79 | 477 | |
| 1027 | 191 | 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. | 4 | 3 | 160 | 35 | 360 | 147 | 507 |
| 540 | 99 | 7 | Asian Art Museum (200 Larkin Street, Civic Center) | The Dalai Lama opened an exhibition on Wisdom and Compassion at the museum in 1991. | 4 | 3 | 90 | 91 | 306 | 79 | 477 |
| 1023 | 191 | 62 | Balboa at 22nd Avenue | 4 | 3 | 160 | 35 | 360 | 147 | 507 | |
| 1467 | 275 | 23 | Battery Street (The Embarcadero) | 4 | 3 | 226 | 238 | 107 | 211 | 46 | |
| 1223 | 225 | 28 | Bessie Charmichael Elementary School (375 Seventh Street, SOMA) | 4 | 3 | 187 | 196 | 383 | 171 | 518 | |
| 1578 | 298 | 72 | Brocklebank Apartments (1000 Mason Street) | 174 | 3 | 81 | 258 | 432 | 231 | 106 | |
| 1304 | 239 | 10 | Bush St. at Stockton St. | 145 | 3 | 196 | 208 | 334 | 183 | ||
| 539 | 99 | 7 | California & Larkin Streets (Nob Hill) | 4 | 3 | 90 | 91 | 306 | 79 | 477 | |
| 1577 | 298 | 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. | 174 | 3 | 81 | 258 | 432 | 231 | 106 |
| 1296 | 239 | 10 | California St. between Drumm St. and Kearny St. | 145 | 3 | 196 | 208 | 334 | 183 | ||
| 1292 | 239 | 10 | California at Jones | 145 | 3 | 196 | 208 | 334 | 183 | ||
| 1291 | 239 | 10 | California at Larkin | 145 | 3 | 196 | 208 | 334 | 183 | ||
| 1288 | 239 | 10 | California between Leavenworth and Powell | 145 | 3 | 196 | 208 | 334 | 183 | ||
| 1344 | 249 | 49 | Cathedral Hill Hotel (1101 Van Ness Avenue, Civic Center) | 92 | 3 | 127 | 216 | 178 | 191 | 530 | |
| 538 | 99 | 7 | 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. | 4 | 3 | 90 | 91 | 306 | 79 | 477 |
| 1545 | 293 | 23 | 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. | 170 | 3 | 127 | 253 | 113 | 228 | 548 |
| 1466 | 275 | 23 | Civic Center Plaza | 4 | 3 | 226 | 238 | 107 | 211 | 46 | |
| 1576 | 298 | 72 | Claude Lane at Bush Street | 174 | 3 | 81 | 258 | 432 | 231 | 106 | |
| 1465 | 275 | 23 | 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. | 4 | 3 | 226 | 238 | 107 | 211 | 46 |
| 630 | 115 | 42 | Conservatory of Flowers (Golden Gate Park) | The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. | 79 | 3 | 107 | 91 | 318 | 92 | |
| 1575 | 298 | 72 | Conservatory of Flowers (Golden Gate Park) | The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. | 174 | 3 | 81 | 258 | 432 | 231 | 106 |
| 1295 | 239 | 10 | Construction Site in front of 260 Stockton St. at Post St. | 145 | 3 | 196 | 208 | 334 | 183 | ||
| 1307 | 239 | 10 | Embarcadero between Pier 2 and Harrison | 145 | 3 | 196 | 208 | 334 | 183 | ||
| 1574 | 298 | 72 | Ernie's Restaurant (847 Montgomery Street) | Called the "Essex Club" in the film. | 174 | 3 | 81 | 258 | 432 | 231 | 106 |
| 708 | 126 | 39 | 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. | 4 | 3 | 117 | 24 | 223 | 102 | 487 |
| 904 | 169 | 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. | 4 | 3 | 145 | 148 | 343 | 130 | |
| 1573 | 298 | 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. | 174 | 3 | 81 | 258 | 432 | 231 | 106 |
| 1158 | 212 | 34 | Ferry Building | Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. | 4 | 3 | 175 | 184 | 375 | 162 | |
| 1464 | 275 | 23 | Ferry Building | Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. | 4 | 3 | 226 | 238 | 107 | 211 | 46 |
| 537 | 99 | 7 | Fiesta Laundromat (898 S. Van Ness Ave., Mission) | 4 | 3 | 90 | 91 | 306 | 79 | 477 | |
| 1343 | 249 | 49 | Financial District | 92 | 3 | 127 | 216 | 178 | 191 | 530 | |
| 707 | 126 | 39 | Fior d' Italia (601 Union Street at Stockton) | 4 | 3 | 117 | 24 | 223 | 102 | 487 | |
| 536 | 99 | 7 | Flood Building (870 Market Street) | 4 | 3 | 90 | 91 | 306 | 79 | 477 | |
| 535 | 99 | 7 | 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. | 4 | 3 | 90 | 91 | 306 | 79 | 477 |
| 1463 | 275 | 23 | 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. | 4 | 3 | 226 | 238 | 107 | 211 | 46 |
| 1572 | 298 | 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. | 174 | 3 | 81 | 258 | 432 | 231 | 106 |
| 534 | 99 | 7 | 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. | 4 | 3 | 90 | 91 | 306 | 79 | 477 |
| 1299 | 239 | 10 | Front St. between Market and Clay | 145 | 3 | 196 | 208 | 334 | 183 | ||
| 533 | 99 | 7 | Golden Gate & Steiner Streets (Hayes Valley) | 4 | 3 | 90 | 91 | 306 | 79 | 477 | |
| 903 | 169 | 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. | 4 | 3 | 145 | 148 | 343 | 130 | |
| 1222 | 225 | 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. | 4 | 3 | 187 | 196 | 383 | 171 | 518 |
| 1225 | 226 | 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. | 4 | 3 | 186 | 197 | 383 | 171 | 518 |
| 1345 | 250 | 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. | 151 | 3 | 205 | 217 | 397 | 192 | |
| 1462 | 275 | 23 | 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. | 4 | 3 | 226 | 238 | 107 | 211 | 46 |
| 632 | 115 | 42 | Golden Gate Park | 79 | 3 | 107 | 91 | 318 | 92 | ||
| 1213 | 224 | 4 | Golden Gate Park | 4 | 3 | 186 | 195 | 383 | 171 | 518 | |
| 1221 | 225 | 28 | Golden Gate Park | 4 | 3 | 187 | 196 | 383 | 171 | 518 | |
| 1571 | 298 | 72 | Gough & Eddy Streets (Western Addition) | 174 | 3 | 81 | 258 | 432 | 231 | 106 | |
| 21 | 9 | 8 | Grace Cathedral Episcopal Church (1100 California Street) | Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. | 4 | 3 | 8 | 7 | 243 | 7 | |
| 1030 | 193 | 47 | Grace Cathedral Episcopal Church (1100 California Street) | Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. | 122 | 3 | 162 | 166 | 362 | 130 | 508 |
| 685 | 126 | 39 | Hall of Justice (850 Bryant Street) | 4 | 3 | 117 | 24 | 223 | 102 | 487 | |
| 1461 | 275 | 23 | Hayes & Polk Streets (Civic Center) | 4 | 3 | 226 | 238 | 107 | 211 | 46 | |
| 532 | 99 | 7 | Hayes Valley Care (601 Laguna Street, Hayes Valley) | 4 | 3 | 90 | 91 | 306 | 79 | 477 | |
| 22 | 9 | 8 | Hills Brothers Plaza (Embarcadero at Harrison Street) | 4 | 3 | 8 | 7 | 243 | 7 | ||
| 1294 | 239 | 10 | Howard St. from Embarcadero to 11 St. | 145 | 3 | 196 | 208 | 334 | 183 | ||
| 1026 | 191 | 62 | Hyde Street Cable Car | 4 | 3 | 160 | 35 | 360 | 147 | 507 | |
| 1220 | 225 | 28 | Intersection of Columbus & Kearney Streets | 4 | 3 | 187 | 196 | 383 | 171 | 518 | |
| 1219 | 225 | 28 | Intersection of Columbus & Mason Streets | 4 | 3 | 187 | 196 | 383 | 171 | 518 | |
| 1218 | 225 | 28 | Intersection of Grant & Fresno Streets (North Beach) | 4 | 3 | 187 | 196 | 383 | 171 | 518 | |
| 706 | 126 | 39 | Japanese Tea Garden (Hagiwara Tea Garden Drive, Golden Gate Park) | The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden | 4 | 3 | 117 | 24 | 223 | 102 | 487 |
| 1217 | 225 | 28 | Kearny & Pacific Streets | 4 | 3 | 187 | 196 | 383 | 171 | 518 | |
| 1554 | 209 | 5 | La Bodega (1332 Grant Avenue at Vallejo) | 4 | 3 | 111 | 181 | 324 | 160 | ||
| 531 | 99 | 7 | Laguna & Sacramento Streets (Pacific Heights) | 4 | 3 | 90 | 91 | 306 | 79 | 477 | |
| 660 | 126 | 39 | Lombard & Hyde Streets | 4 | 3 | 117 | 24 | 223 | 102 | 487 | |
| 1216 | 225 | 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. | 4 | 3 | 187 | 196 | 383 | 171 | 518 |
| 1460 | 275 | 23 | Market & 2nd Streets | 4 | 3 | 226 | 238 | 107 | 211 | 46 | |
| 1297 | 239 | 10 | Market St. at Embarcadero area | 145 | 3 | 196 | 208 | 334 | 183 | ||
| 1290 | 239 | 10 | Market at Mason | 145 | 3 | 196 | 208 | 334 | 183 | ||
| 1551 | 209 | 5 | McCovey Point, China Basin Park (24 Willy Mays Plaza) | 4 | 3 | 111 | 181 | 324 | 160 | ||
| 1570 | 298 | 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. | 174 | 3 | 81 | 258 | 432 | 231 | 106 |
| 1569 | 298 | 72 | Mission San Juan Bautista (2nd & Mariposa Streets) | 174 | 3 | 81 | 258 | 432 | 231 | 106 | |
| 1302 | 239 | 10 | Mission St., Embarcadero, and Front between Clay and Market | 145 | 3 | 196 | 208 | 334 | 183 | ||
| 1289 | 239 | 10 | Mission at 1st and 2nd | 145 | 3 | 196 | 208 | 334 | 183 | ||
| 1550 | 209 | 5 | Mojito (1337-1339 Grant Avenue) | 4 | 3 | 111 | 181 | 324 | 160 | ||
| 530 | 99 | 7 | Montgomery & Pine Streets (Financial District) | 4 | 3 | 90 | 91 | 306 | 79 | 477 | |
| 1459 | 275 | 23 | Montgomery & Vallejo Streets (Telegraph Hill) | 4 | 3 | 226 | 238 | 107 | 211 | 46 | |
| 1342 | 249 | 49 | Neiman Marcus (150 Stockton Street, Union Square) | In the film the City of Paris Department Store is featured. That establishment was located where Neiman Marcus stands today | 92 | 3 | 127 | 216 | 178 | 191 | 530 |
| 1215 | 225 | 28 | North Beach | 4 | 3 | 187 | 196 | 383 | 171 | 518 |