Trocadero, San Francisco (Q7844809)

  • matcher place: San Francisco (relation 111968)
  • view on Wikidata
  • Wikipedia: English
  • Wikimedia Commons
  • English Wikipedia categories: 1892 establishments in California, 1930s disestablishments in California, Defunct restaurants in San Francisco, Drinking establishments in the San Francisco Bay Area, Restaurants established in 1892, Restaurants in San Francisco, San Francisco Designated Landmarks, Sunset District, San Francisco
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,37.73621,-122.47801)[cuisine][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73621,-122.47801)[cuisine][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73621,-122.47801)[cuisine][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73621,-122.47801)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73621,-122.47801)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73621,-122.47801)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73621,-122.47801)[amenity=cafe][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73621,-122.47801)[amenity=cafe][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73621,-122.47801)[amenity=cafe][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73621,-122.47801)["amenity"="fast_food"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73621,-122.47801)["amenity"="fast_food"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73621,-122.47801)["amenity"="fast_food"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73621,-122.47801)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73621,-122.47801)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73621,-122.47801)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73621,-122.47801)[amenity=pub][name];
    way(around:1000,37.73621,-122.47801)[amenity=pub][name];
    rel(around:1000,37.73621,-122.47801)[amenity=pub][name];
    node(around:1000,37.73621,-122.47801)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73621,-122.47801)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73621,-122.47801)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73621,-122.47801)[building=pub][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73621,-122.47801)[building=pub][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73621,-122.47801)[building=pub][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73621,-122.47801)[shop=bakery][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73621,-122.47801)[shop=bakery][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73621,-122.47801)[shop=bakery][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73621,-122.47801)[shop=deli][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73621,-122.47801)[shop=deli][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73621,-122.47801)[shop=deli][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from English Wikipedia (enwiki)

The Trocadero is a historic building located in San Francisco. Formally it was a lively roadhouse at the turn of the 20th century it had offered gambling at roulette tables and dancing, as well as the best trout pond in California.

Wikidata location: 37.7362, -122.4780 view on OSM or edit on OSM

matches

login to upload wikidata tags

no matches found

Search criteria from categories

Defunct restaurants in San Francisco amenity=restaurant, amenity=fast_food, shop=deli, cuisine, shop=bakery, amenity=cafe
Drinking establishments in the San Francisco Bay Area amenity=nightclub, building=pub, amenity=restaurant, amenity=bar, amenity=pub
Restaurants established in 1892 amenity=restaurant, amenity=fast_food, shop=deli, cuisine, shop=bakery, amenity=cafe
Restaurants in San Francisco amenity=restaurant, amenity=fast_food, shop=deli, cuisine, shop=bakery, amenity=cafe