School of International and Public Affairs, Columbia University (Q7432485)

  • matcher place: New York (relation 175905), New York County (relation 2552485)
  • view on Wikidata
  • Wikipedia: Chinese, English, French, Japanese, Korean, Swedish
  • English Wikipedia categories: 1946 establishments in New York City, Columbia University colleges and schools, Public administration schools in the United States, Public policy schools, Schools of international relations in the United States, Universities and colleges established in 1946
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,40.80753,-73.95968)[department][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.80753,-73.95968)[department][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.80753,-73.95968)[department][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.80753,-73.95968)[amenity=college][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.80753,-73.95968)[amenity=college][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.80753,-73.95968)[amenity=college][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.80753,-73.95968)["amenity"="research_institute"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.80753,-73.95968)["amenity"="research_institute"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.80753,-73.95968)["amenity"="research_institute"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.80753,-73.95968)[amenity=school][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.80753,-73.95968)[amenity=school][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.80753,-73.95968)[amenity=school][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.80753,-73.95968)[amenity=university][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.80753,-73.95968)[amenity=university][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.80753,-73.95968)[amenity=university][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.80753,-73.95968)[building=college][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.80753,-73.95968)[building=college][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.80753,-73.95968)[building=college][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.80753,-73.95968)[building=school][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.80753,-73.95968)[building=school][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.80753,-73.95968)[building=school][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.80753,-73.95968)[building=university][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.80753,-73.95968)[building=university][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.80753,-73.95968)[building=university][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.80753,-73.95968)[site=college][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.80753,-73.95968)[site=school][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.80753,-73.95968)[site=university][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.80753,-73.95968)[type=site][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from English Wikipedia (enwiki)

The School of International and Public Affairs (SIPA) is the international affairs and public policy school of Columbia University, a private Ivy League university located in Morningside Heights, Manhattan, New York City. SIPA offers Master of International Affairs (MIA) and Master of Public Administration (MPA) degrees in a range of fields, as well as the Executive MPA and PhD program in Sustainable Development.

Wikidata location: 40.8075, -73.9597 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

relation: Columbia School of International and Public Affairs (OSM)exact location match [show tags]
name: Columbia School of International and Public Affairs
height: 54.7
website: https://new.sipa.columbia.edu/
building: university
wikidata: Q7432485
addr:city: New York
addr:street: West 118th Street
nycdoitt:bin: 1059497
addr:postcode: 10027
addr:housenumber: 420

wikidata match: Q7432485

Search criteria from Wikidata

view with query.wikidata.org

research institute (Q31855) amenity=research_institute
school (Q3914) amenity=school, education=school
university (Q3918) amenity=university, education=university

Search criteria from categories

Columbia University colleges and schools site=school, building=college, amenity=college, type=site, site=university, amenity=university, site=college, amenity=school, building=university, building=school
Public administration schools in the United States site=school, amenity=school, building=school, building=college, amenity=college, type=site
Public policy schools site=school, amenity=school, building=school, building=college, amenity=college, type=site
Schools of international relations in the United States site=school, amenity=school, building=school, building=college, amenity=college, type=site
Universities and colleges established in 1946 building=college, site=university, type=site, amenity=college, site=college, amenity=university, building=university