Columbia University Medical Center (Q2415975)

  • matcher place: Manhattan (way 400014249), New York City (relation 175905), Manhattan (relation 2552485), Manhattan Community Board 9 (relation 7339672), Manhattan (relation 8186559), Manhattan (relation 8398124)
  • view on Wikidata
  • Wikipedia: English, French, Persian, Portuguese
  • Wikimedia Commons
  • English Wikipedia categories: American medical research, Columbia University, Columbia University research institutes, Hospitals in Manhattan, NewYork–Presbyterian Healthcare System, Pages with maps, Teaching hospitals in New York City, Washington Heights, Manhattan
  • Overpass query: show queryOverpass Turbo
    [timeout:300][out:json];
    (
        node(around:1000,40.80756,-73.96408)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.80756,-73.96408)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.80756,-73.96408)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.80756,-73.96408)[location][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.80756,-73.96408)[location][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.80756,-73.96408)[location][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.80756,-73.96408)["man_made"][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.80756,-73.96408)["man_made"][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.80756,-73.96408)["man_made"][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.80756,-73.96408)[amenity=clinic][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.80756,-73.96408)[amenity=clinic][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.80756,-73.96408)[amenity=clinic][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.80756,-73.96408)[amenity=hospital][name];
        way(around:1000,40.80756,-73.96408)[amenity=hospital][name];
        rel(around:1000,40.80756,-73.96408)[amenity=hospital][name];
        node(around:1000,40.80756,-73.96408)["amenity"="public_building"][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.80756,-73.96408)["amenity"="public_building"][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.80756,-73.96408)["amenity"="public_building"][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.80756,-73.96408)[amenity=university][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.80756,-73.96408)[amenity=university][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.80756,-73.96408)[amenity=university][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,40.80756,-73.96408)[healthcare=hospital][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,40.80756,-73.96408)[healthcare=hospital][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.80756,-73.96408)[healthcare=hospital][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.80756,-73.96408)[site=university][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,40.80756,-73.96408)[type=site][~"^(addr:housenumber|.*name.*)$"~".",i];
    );
    out center tags;
Wikidata location: 40.8076, -73.9641 view on OSM or edit on OSM

matches

login to upload wikidata tags

found 2 match candidates

relation: Columbia University (OSM)exact location match [show tags]
name: Columbia University
amenity: university
name:es: Universidad de Columbia
name:ja: コロンビア大学
website: https://www.columbia.edu
alt_name: Columbia University in The City of New York
wikidata: Q49088
addr:city: New York
wikipedia: en:Columbia University
addr:state: NY

wikidata mismatch: Q49088
way: Columbia University In The City Of New York (OSM)exact location match [show tags]
name: Columbia University In The City Of New York
amenity: university
name:es: Universidad de Columbia
name:ja: コロンビア大学
website: https://www.columbia.edu
wikidata: Q49088
addr:city: New York
wikipedia: en:Columbia University
addr:state: NY

wikidata mismatch: Q49088

Search criteria from Wikidata

view with query.wikidata.org

hospital (Q16917) building=hospital, healthcare=hospital, amenity=hospital
public building (Q294422) building=public, amenity=public_building
building (Q41176) building=yes, building

Search criteria from categories

Columbia University amenity=university, site=university, building=university, type=site
Columbia University research institutes amenity=university, site=university, building=university, type=site
Hospitals in Manhattan building=hospital, amenity=hospital
Teaching hospitals in New York City building=hospital, amenity=hospital