Film_Locations_in_San_Francisco

Data source: data.sfgov.org

80 rows where Actor 1 = 295

View and edit SQL

Suggested facets: Title, Release Year, Fun Facts, Production Company, Distributor, Director, Actor 2, Actor 3

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
414 Dirty Harry 78 1971 42 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. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
415 Dirty Harry 78 1971 42 Washington Square, North Beach   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
416 Dirty Harry 78 1971 42 The Embarcadero   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
417 Dirty Harry 78 1971 42 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
418 Dirty Harry 78 1971 42 San Francisco Drydock (20th and Illinois Streets)   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
419 Dirty Harry 78 1971 42 Portsmouth Square (Chinatown) In 1847 the first public school in California was erected on what would become Portsmouth Square. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
420 Dirty Harry 78 1971 42 Mt. Davidson Cross, Mt. Davidson The cross sits at the highest point in San Francisco (938 feet). This version of the cross was erected in 1934.Though in Dirty Harry the cross is lit at night, the City stopped this practice in 1990. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
421 Dirty Harry 78 1971 42 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. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
422 Dirty Harry 78 1971 42 Kezar Stadium, Golden Gate Park The stadium was demolished and completely rebuilt after sustaining damages in the 1898 Loma Prieta earthquake. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
423 Dirty Harry 78 1971 42 Holiday Inn Select Downtown Hotel (750 Kearney Street)   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
424 Dirty Harry 78 1971 42 Hall of Justice (850 Bryant Street)   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
425 Dirty Harry 78 1971 42 Forest Hill Station- MUNI   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
426 Dirty Harry 78 1971 42 Dante Building (1606 Stockton Street at Union)   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
427 Dirty Harry 78 1971 42 California Hall (625 Polk Street, Van Ness/Civic Center)   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
428 Dirty Harry 78 1971 42 Bank of America Building (555 California Street) The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
459 Escape From Alcatraz 87 1979 44 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Paramount Pictures 4 Paramount Pictures 3 Donald Siegel 79 Richard Tuggle 80 Clint Eastwood 295 Patrick McGoohan 68 Robert Blossom 471
865 Magnum Force 160 1973 16 Cost Plus World Market (2552 Taylor Street)   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
866 Magnum Force 160 1973 16 Vermont Street between 20th and 22nd Streets   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
867 Magnum Force 160 1973 16 San Francisco International Airport SFO has a museum dedicated to aviation history. The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
868 Magnum Force 160 1973 16 San Francisco Drydock (20th and Illinois Streets)   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
869 Magnum Force 160 1973 16 Pacific Heights Towers (2200 Sacramento Street, Pacific Heights)   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
870 Magnum Force 160 1973 16 Lefty O' Doul Drawbridge/ 3rd Street Bridge (3rd Street, China Basin) This is SF's only drawbridge, and was named after Francis Joseph "Lefty" O'Doul, a local baseball hero. The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
871 Magnum Force 160 1973 16 Hall of Justice (850 Bryant Street)   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
872 Magnum Force 160 1973 16 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. The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
873 Magnum Force 160 1973 16 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. The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
874 Magnum Force 160 1973 16 Embarcadero Freeway demolished The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
875 Magnum Force 160 1973 16 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. The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
876 Magnum Force 160 1973 16 Broadway Tunnel (Russian Hill)   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
877 Magnum Force 160 1973 16 280 Freeway at Pennsylvania and Mariposa Streets   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
878 Magnum Force 160 1973 16 2190 Washington Street (Pacific Heights)   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
879 Magnum Force 160 1973 16 18th Street Overpass (Potrero Hill)   The Malpaso Company 59 Warner Bros. Pictures 6 Ted Post 138 John Milius 139 Clint Eastwood 295 Hal Holbrook 124 Mitchell Ryan 497
1244 Sudden Impact 231 1983 65 Near Point Lobos, El Camino Del Mar   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176  
1245 Sudden Impact 231 1983 65 Mt. Davidson Mt. Davidson is highest point in San Francisco (938 feet). Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1246 Sudden Impact 231 1983 65 McDonald's Restaurant (701 3rd Street, SOMA)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1247 Sudden Impact 231 1983 65 Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle, Nob Hill) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1248 Sudden Impact 231 1983 65 Hall of Justice (850 Bryant Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1249 Sudden Impact 231 1983 65 Ferry Plaza Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1250 Sudden Impact 231 1983 65 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1251 Sudden Impact 231 1983 65 Civic Center Plaza   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1252 Sudden Impact 231 1983 65 The Embarcadero/Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1253 Sudden Impact 231 1983 65 Bowles Franklin Galleries (765 Beach Street, Fisherman's Wharf)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1254 Sudden Impact 231 1983 65 Pier 38-40, The Embarcadero   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1313 The Dead Pool 242 1988 23 Hall of Justice (850 Bryant Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1346 The Dead Pool 242 1988 23 San Francisco Drydock (The Dogpatch)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1347 The Dead Pool 242 1988 23 Washington Square Park (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. The statue in the Park is Ben Franklin, not George Washington. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1348 The Dead Pool 242 1988 23 One Thousand Powell Apartments (1000 Powell Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1349 The Dead Pool 242 1988 23 The Cannery (281 Leavenworth Street, Fisherman's Wharf)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1350 The Dead Pool 242 1988 23 Portsmouth Square (Chinatown)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1351 The Dead Pool 242 1988 23 Pierce St. & Golden Gate Avenue (Hayes Valley)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1352 The Dead Pool 242 1988 23 Pierce & California Streets (Pacific Heights)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1353 The Dead Pool 242 1988 23 Pier 3 (The Embarcadero)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1354 The Dead Pool 242 1988 23 New Asia Restaurant (772 Pacific Avenue at Grant)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1355 The Dead Pool 242 1988 23 Nam Yuen Restaurant (740 Washington Street, Chinatown)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1356 The Dead Pool 242 1988 23 Mirant Energy, LLC (1301 Illinois Street, The Dogpatch)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1357 The Dead Pool 242 1988 23 McAllister & Scott Streets (Hayes Valley)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1358 The Dead Pool 242 1988 23 KGO-TV ABC7 TV Studios (900 Front Street, Waterfront Historic District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1360 The Dead Pool 242 1988 23 San Francisco National Military Cemetery (Lincoln Blvd., The Presidio, Golden Gate National Recreation Center)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1361 The Dead Pool 242 1988 23 Silver Restaurant (737 Washington Street, Chinatown)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1362 The Dead Pool 242 1988 23 Fremont Street Exit of Bay Bridge   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1363 The Dead Pool 242 1988 23 Folsom & Essex Streets   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1364 The Dead Pool 242 1988 23 Eber Electronics (2355 Market Street, Castro)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1365 The Dead Pool 242 1988 23 Clementina & Sumner Streets   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1366 The Dead Pool 242 1988 23 Carl & Cole Streets (Cole Valley)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1367 The Dead Pool 242 1988 23 710 Steiner Street (Hayes Valley)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1368 The Dead Pool 242 1988 23 550 El Camino Del Mar (Seacliff)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1369 The Dead Pool 242 1988 23 23rd & Iowa Streets (Dogpatch)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1370 The Dead Pool 242 1988 23 22nd Bet. Carolina & Rhode Island Streets (Potrero Hill)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1371 The Dead Pool 242 1988 23 22nd & Wisconsin Streets (Potrero Hill)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1372 The Dead Pool 242 1988 23 20th & De Haro Streets (Potrero Hill)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1373 The Dead Pool 242 1988 23 1954 Mason Street (North Beach)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1374 The Dead Pool 242 1988 23 San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1393 The Enforcer 255 1976 45 Sutter & Webster Streets   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1394 The Enforcer 255 1976 45 Hall of Justice   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1395 The Enforcer 255 1976 45 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1396 The Enforcer 255 1976 45 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1397 The Enforcer 255 1976 45 Balmy Street (Mission District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1398 The Enforcer 255 1976 45 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1399 The Enforcer 255 1976 45 24th Street Mini Park (Mission District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1400 The Enforcer 255 1976 45 23rd & Capp Streets (Mission District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1401 The Enforcer 255 1976 45 Lefty O' Doul Drawbridge/ 3rd Street Bridge (3rd Street, China Basin) This is SF's only drawbridge, and was named after Francis Joseph "Lefty" O'Doul, a local baseball hero. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 39.676ms · Data source: data.sfgov.org