Dorrian's Red Hand Restaurant (Q5298742)

  • matcher place: Manhattan (way 400014249), New York City (relation 175905), Manhattan (relation 2552485), Manhattan Community Board 8 (relation 7340018), Manhattan (relation 8186559), Manhattan (relation 8398124)
  • view on Wikidata
  • Wikipedia: English
  • English Wikipedia categories: Drinking establishments in Manhattan, Irish-American cuisine, Irish-American culture in New York City, Irish restaurants, Manhattan building and structure stubs, Restaurants established in 1960, Restaurants in Manhattan, Restaurants in New Jersey, Second Avenue (Manhattan), United States restaurant stubs, Upper East Side
  • Overpass query: show queryOverpass Turbo
    [timeout:300][out:json];
    (
        node(around:1000,40.77640,-73.95260)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.77640,-73.95260)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.77640,-73.95260)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.77640,-73.95260)[cuisine][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.77640,-73.95260)[cuisine][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.77640,-73.95260)[cuisine][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.77640,-73.95260)["man_made"][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.77640,-73.95260)["man_made"][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.77640,-73.95260)["man_made"][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.77640,-73.95260)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.77640,-73.95260)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.77640,-73.95260)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.77640,-73.95260)[amenity=cafe][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.77640,-73.95260)[amenity=cafe][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.77640,-73.95260)[amenity=cafe][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.77640,-73.95260)["amenity"="fast_food"][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.77640,-73.95260)["amenity"="fast_food"][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.77640,-73.95260)["amenity"="fast_food"][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.77640,-73.95260)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.77640,-73.95260)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.77640,-73.95260)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.77640,-73.95260)[amenity=pub][name];
        way(around:1000,40.77640,-73.95260)[amenity=pub][name];
        rel(around:1000,40.77640,-73.95260)[amenity=pub][name];
        node(around:1000,40.77640,-73.95260)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.77640,-73.95260)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.77640,-73.95260)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.77640,-73.95260)[shop=bakery][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.77640,-73.95260)[shop=bakery][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.77640,-73.95260)[shop=bakery][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.77640,-73.95260)[shop=deli][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.77640,-73.95260)[shop=deli][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.77640,-73.95260)[shop=deli][~"^(addr:housenumber|.*name.*)$"~".",i];
    );
    out center tags;
Wikidata location: 40.7764, -73.9526 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

node: Dorrian's Red Hand (OSM), 1 feet from Wikidata [show tags]
name: Dorrian's Red Hand
email: events@dorrians-nyc.com
phone: +1-212-772-6660
amenity: restaurant
cuisine: american
website: https://www.dorrians-nyc.com
cocktails: yes
drink:beer: yes
wheelchair: yes
addr:street: 2nd Avenue
addr:postcode: 10028
opening_hours: 11:00-03:45
contact:twitter: https://twitter.com/dorriansnyc
addr:housenumber: 1616
contact:facebook: https://www.facebook.com/dorrians.nyc
contact:instagram: http://instagram.com/dorriansnyc

Search criteria from Wikidata

view with query.wikidata.org

restaurant (Q11707) amenity=restaurant
building (Q41176) building=yes, building
commercial building (Q655686) building=commercial

Search criteria from categories

Drinking establishments in Manhattan building=pub, amenity=nightclub, amenity=restaurant, amenity=bar, amenity=pub
Irish restaurants amenity=cafe, cuisine, amenity=restaurant, amenity=fast_food, shop=bakery, shop=deli
Restaurants established in 1960 amenity=cafe, cuisine, amenity=restaurant, amenity=fast_food, shop=bakery, shop=deli
Restaurants in Manhattan amenity=cafe, cuisine, amenity=restaurant, amenity=fast_food, shop=bakery, shop=deli
Restaurants in New Jersey amenity=cafe, cuisine, amenity=restaurant, amenity=fast_food, shop=bakery, shop=deli