Green Tree Tavern (Q5603342)

  • matcher place: Philadelphia (relation 188022), Philadelphia County (relation 417845)
  • view on Wikidata
  • Wikipedia: English
  • English Wikipedia categories: 1849 establishments in Pennsylvania, Bridesburg-Kensington-Richmond, Philadelphia, Commercial buildings completed in 1845, Commercial buildings on the National Register of Historic Places in Philadelphia, Drinking establishments on the National Register of Historic Places in Pennsylvania, History of Philadelphia, Hotel buildings on the National Register of Historic Places in Pennsylvania, Philadelphia County, Pennsylvania Registered Historic Place stubs, Taverns in Pennsylvania
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,39.96940,-75.13220)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,39.96940,-75.13220)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,39.96940,-75.13220)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,39.96940,-75.13220)["building:levels"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,39.96940,-75.13220)["building:levels"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,39.96940,-75.13220)["building:levels"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,39.96940,-75.13220)[historic][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,39.96940,-75.13220)[historic][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,39.96940,-75.13220)[historic][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,39.96940,-75.13220)[office][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,39.96940,-75.13220)[office][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,39.96940,-75.13220)[office][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,39.96940,-75.13220)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,39.96940,-75.13220)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,39.96940,-75.13220)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,39.96940,-75.13220)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,39.96940,-75.13220)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,39.96940,-75.13220)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,39.96940,-75.13220)[amenity=pub][name];
    way(around:1000,39.96940,-75.13220)[amenity=pub][name];
    rel(around:1000,39.96940,-75.13220)[amenity=pub][name];
    node(around:1000,39.96940,-75.13220)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,39.96940,-75.13220)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,39.96940,-75.13220)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,39.96940,-75.13220)["boundary"="protected_area"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,39.96940,-75.13220)["boundary"="protected_area"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,39.96940,-75.13220)["boundary"="protected_area"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,39.96940,-75.13220)["heritage:operator"="nrhp"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,39.96940,-75.13220)["heritage:operator"="nrhp"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,39.96940,-75.13220)["heritage:operator"="nrhp"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,39.96940,-75.13220)[landuse=commercial][name];
    way(around:1000,39.96940,-75.13220)[landuse=commercial][name];
    rel(around:1000,39.96940,-75.13220)[landuse=commercial][name];
    node(around:1000,39.96940,-75.13220)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,39.96940,-75.13220)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,39.96940,-75.13220)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,39.96940,-75.13220)[tourism=hostel][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,39.96940,-75.13220)[tourism=hostel][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,39.96940,-75.13220)[tourism=hostel][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,39.96940,-75.13220)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,39.96940,-75.13220)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,39.96940,-75.13220)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,39.96940,-75.13220)["ref:nrhp"=80003612];
    way(around:1000,39.96940,-75.13220)["ref:nrhp"=80003612];
    rel(around:1000,39.96940,-75.13220)["ref:nrhp"=80003612];
);
out center tags;
Summary from English Wikipedia (enwiki)

The Green Tree Tavern, also known as the Marlborough Inn, is a historic building in the Fishtown neighborhood of Philadelphia, Pennsylvania.

Wikidata location: 39.9694, -75.1322 view on OSM or edit on OSM

matches

login to upload wikidata tags

no matches found

Search criteria from Wikidata

view with query.wikidata.org

National Register of Historic Places listed place (Q19558910) heritage:operator=nrhp
building (Q41176) building=yes, building

Search criteria from categories

Commercial buildings completed in 1845 building=commercial, landuse=commercial, office, building=office
Commercial buildings on the National Register of Historic Places in Philadelphia building=commercial, landuse=commercial, building=office, boundary=protected_area, historic, office
Drinking establishments on the National Register of Historic Places in Pennsylvania amenity=bar, amenity=restaurant, building=pub, amenity=nightclub, boundary=protected_area, amenity=pub, historic
Hotel buildings on the National Register of Historic Places in Pennsylvania tourism=hostel, boundary=protected_area, building=hotel, tourism=hotel, tourism=guest_house, historic