New College, Teachers College, Columbia University (Q7006604)

  • matcher place: Manhattan Community Board 9 (relation 7339672), Manhattan (relation 8398124)
  • view on Wikidata
  • Wikipedia: English
  • English Wikipedia categories: Columbia University, Educational institutions established in 1932, Schools of education in New York (state)
  • Overpass query: show queryOverpass Turbo
    [timeout:300][out:json];
    (
        node(around:1000,40.81029,-73.96039)[location][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.81029,-73.96039)[location][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.81029,-73.96039)[location][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.81029,-73.96039)["man_made"][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.81029,-73.96039)["man_made"][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.81029,-73.96039)["man_made"][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.81029,-73.96039)[amenity=school][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.81029,-73.96039)[amenity=school][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.81029,-73.96039)[amenity=school][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.81029,-73.96039)[amenity=university][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.81029,-73.96039)[amenity=university][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.81029,-73.96039)[amenity=university][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.81029,-73.96039)[building=school][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.81029,-73.96039)[building=school][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.81029,-73.96039)[building=school][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.81029,-73.96039)[building=university][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.81029,-73.96039)[building=university][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.81029,-73.96039)[building=university][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.81029,-73.96039)[office=association][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.81029,-73.96039)[office=association][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.81029,-73.96039)[office=association][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.81029,-73.96039)["operator:type"="ngo"][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.81029,-73.96039)["operator:type"="ngo"][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.81029,-73.96039)["operator:type"="ngo"][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.81029,-73.96039)[site=school][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.81029,-73.96039)[site=university][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.81029,-73.96039)[type=site][~"^(addr:housenumber|.*name.*)$"~".",i];
    );
    out center tags;
Wikidata location: 40.8103, -73.9604 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

university (Q3918) amenity=university
voluntary association (Q48204) office=association
non-governmental organization (Q79913) operator:type=ngo

Search criteria from categories

Columbia University type=site, building=university, amenity=university, site=university
Schools of education in New York (state) amenity=school, building=college, amenity=college, building=school, type=site, site=school