The Little Shamrock (Q20968932)

  • matcher place: San Francisco (relation 111968)
  • view on Wikidata
  • Wikipedia: English
  • Wikimedia Commons
  • English Wikipedia categories: 1893 establishments in California, California building and structure stubs, Drinking establishments in California, History of San Francisco
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,37.76572,-122.46672)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.76572,-122.46672)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.76572,-122.46672)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.76572,-122.46672)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.76572,-122.46672)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.76572,-122.46672)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.76572,-122.46672)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.76572,-122.46672)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.76572,-122.46672)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.76572,-122.46672)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.76572,-122.46672)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.76572,-122.46672)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.76572,-122.46672)[amenity=pub][name];
    way(around:1000,37.76572,-122.46672)[amenity=pub][name];
    rel(around:1000,37.76572,-122.46672)[amenity=pub][name];
    node(around:1000,37.76572,-122.46672)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.76572,-122.46672)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.76572,-122.46672)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.76572,-122.46672)[building=commercial][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.76572,-122.46672)[building=commercial][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.76572,-122.46672)[building=commercial][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.76572,-122.46672)[building=pub][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.76572,-122.46672)[building=pub][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.76572,-122.46672)[building=pub][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.76572,-122.46672)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.76572,-122.46672)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.76572,-122.46672)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.76572,-122.46672)[tourism=artwork][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.76572,-122.46672)[tourism=artwork][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.76572,-122.46672)[tourism=artwork][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from English Wikipedia (enwiki)

The Little Shamrock is a historic bar in the Inner Sunset district in San Francisco, California. Established in 1893, it is considered the city's second-oldest bar after The Saloon in North Beach, which opened in 1861.

Wikidata location: 37.7657, -122.4667 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

node: The Little Shamrock (OSM), 32 feet from Wikidata [show tags]
name: The Little Shamrock
amenity: pub
wikidata: Q20968932
addr:city: San Francisco
addr:state: CA
check_date: 2023-04-16
addr:street: Lincoln Way
addr:country: US
addr:postcode: 94122
addr:housenumber: 807

wikidata match: Q20968932

Search criteria from Wikidata

view with query.wikidata.org

bar (Q187456) amenity=bar
pub (Q212198) amenity=pub
shop (Q213441) shop=yes
building (Q41176) building=yes
commercial building (Q655686) building=commercial

Search criteria from categories

Drinking establishments in California amenity=nightclub, building=pub, amenity=restaurant, amenity=bar, amenity=pub