Film_Locations_in_San_Francisco

38 rows where Distributor = 30

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
211	211	Bullitt 42	1968 31	Bayshore Blvd near Cesar Chavez (Bayview)		Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
212	212	Bullitt 42	1968 31	Taylor & Vallejo Streets (Russian Hill)		Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
214	214	Bullitt 42	1968 31	SF General Hospital 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 Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
215	215	Bullitt 42	1968 31	McLaren Park (Visitacion Valley)	McLaren Park is the 2nd largest park in San Francisco, after Golden Gate Park.	Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
216	216	Bullitt 42	1968 31	Mark Hopkins Hotel (999 California Street)	The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite.	Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
217	217	Bullitt 42	1968 31	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.	Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
218	218	Bullitt 42	1968 31	Mansell & University Streets (Visitacion Valley)		Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
219	219	Bullitt 42	1968 31	Larkin & Francisco Streets (Russian Hill)		Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
220	220	Bullitt 42	1968 31	Larkin & Chestnut Streets (Russian Hill)		Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
221	221	Bullitt 42	1968 31	Kennedy Hotel (226 Embarcadero at Howard Street)	Hotel was destroyed in the 1989 Loma Prieta earthquake. Corporate headquarters for the Gap reside at the location today.	Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
222	222	Bullitt 42	1968 31	John Muir Drive (Lake Merced)		Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
223	223	Bullitt 42	1968 31	Intersection of York & Peralta (Bernal Heights)		Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
224	224	Bullitt 42	1968 31	Filbert & Taylor Streets (Russian Hill)		Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
225	225	Bullitt 42	1968 31	Enrico's Café (504 Broadway)		Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
226	226	Bullitt 42	1968 31	Columbus & Lombard Streets (North Beach)		Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
227	227	Bullitt 42	1968 31	Cesar Chavez & Mission Street (Mission)		Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
228	228	Bullitt 42	1968 31	Candlestick Park Exit, Highway 101		Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
229	229	Bullitt 42	1968 31	Café Cantata (2040 Union Street)		Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
230	230	Bullitt 42	1968 31	Brocklebank Apartments (1000 Mason Street)		Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
231	231	Bullitt 42	1968 31	Bay Bridge	Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII.	Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
232	232	Bullitt 42	1968 31	2700 Vallejo Street (Pacific Heights)		Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
233	233	Bullitt 42	1968 31	20th & Vermont Streets (Potrero Hill)	The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St.	Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
234	234	Bullitt 42	1968 31	1153-57 Taylor Street	Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake)	Warner Brothers / Seven Arts Seven Arts 37	Warner Brothers 30	Peter Yates 40	Alan R. Trustman 39	Steve McQueen 273	Jacqueline Bisset 36	Robert Vaughn 459
414	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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

Advanced export

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");