sf-film-locations

This data as json, CSV

rowid	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
121	31	25	1155 Filbert Street at Hyde		14	13	29	28	263	27
122	31	25	Washington Square Park (Filbert, between Stockton and Powell)		14	13	29	28	263	27
123	31	25	Vaillancourt Fountain (Justin Herman Plaza)	Installed in 1975, the Vaillancourt Fountain is officially titled, "Québec Libre!". The night before the sculpture's inauguration, artist Armand Vaillancourt inscribed "Québec libre!" in red letters on the sculpture. The next day when he noticed that the note had been erased, Vaillancourt jumped on the statue to re-inscribe his message.	14	13	29	28	263	27
124	31	25	Montgomery & Market Streets		14	13	29	28	263	27
125	31	25	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.	14	13	29	28	263	27
184	39	25	1122 Folsom Street		34	28	37	36	271	34
185	39	25	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.	34	28	37	36	271	34
186	39	25	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.	34	28	37	36	271	34
187	39	25	Fisherman's Wharf	Supposedly, Mikhail S. Gorbachev has said that his favorite part of visiting America was touring Fisherman's Wharf.	34	28	37	36	271	34
188	39	25	Ferry Building	Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.	34	28	37	36	271	34
189	39	25	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.	34	28	37	36	271	34
190	39	25	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.	34	28	37	36	271	34
191	39	25	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.	34	28	37	36	271	34
192	39	25	Chinatown	First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US.	34	28	37	36	271	34
193	39	25	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.	34	28	37	36	271	34
194	39	25	Alcatraz Island	Alcatraz Island was a military fort before it became a prison.	34	28	37	36	271	34
195	39	25	628 Cole Street		34	28	37	36	271	34
620	110	25	435 23rd Street at Illinois		76	27	102	102	314	89
621	110	25	435 23rd Street at Illinois		76	27	102	102	314	89
622	110	25	435 23rd Street at Illinois		76	27	102	102	314	89
731	144	25	Ferry Building	Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.	97	65	132	133	336	119
736	147	25	Lusty Lady Bar (North Beach)		100	68	135	136
1029	192	25	Conservatory of Flowers (Golden Gate Park)	The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere.	121	25	161	165	361	148
1085	204	25	Chinatown	First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US.	128	6	169	177	371	157
1086	204	25	Embarcadero Street		128	6	169	177	371	157
1113	207	25	The Castro	From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry.	130		171		373	159
1620	305	25	312 Fillmore Street		178	24	248	264	436

sf-film-locations

Custom SQL query returning 27 rows (hide)

Query parameters