Columbia Airport (Q1656920)

  • matcher place: Tuolumne County (relation 396471)
  • view on Wikidata
  • Wikipedia: English, Navajo, Persian, Romanian, Russian, Tajik, Urdu
  • Wikimedia Commons
  • English Wikipedia categories: Airports in Tuolumne County, California, California airport stubs, Sierra Nevada (United States)
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,38.03060,-120.41400)[aeroway][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,38.03060,-120.41400)[aeroway][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,38.03060,-120.41400)[aeroway][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,38.03060,-120.41400)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,38.03060,-120.41400)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,38.03060,-120.41400)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,38.03060,-120.41400)[aeroway=aerodrome][name];
    way(around:1000,38.03060,-120.41400)[aeroway=aerodrome][name];
    rel(around:1000,38.03060,-120.41400)[aeroway=aerodrome][name];
    node(around:1000,38.03060,-120.41400)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,38.03060,-120.41400)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,38.03060,-120.41400)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,38.03060,-120.41400)["public_transport"="platform"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,38.03060,-120.41400)["public_transport"="platform"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,38.03060,-120.41400)["public_transport"="platform"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,38.03060,-120.41400)["public_transport"="station"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,38.03060,-120.41400)["public_transport"="station"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,38.03060,-120.41400)["public_transport"="station"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,38.03060,-120.41400)["public_transport"="stop_position"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,38.03060,-120.41400)["public_transport"="stop_position"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,38.03060,-120.41400)["public_transport"="stop_position"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,38.03060,-120.41400)[site=airport][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from English Wikipedia (enwiki)

Columbia Airport (IATA: COA, FAA LID: O22) is located a mile southwest of Columbia, in Tuolumne County, California, United States. It is owned by the County of Tuolumne.

Wikidata location: 38.0306, -120.4140 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

way: Columbia Airport (OSM)exact location match [show tags]
ele: 637
iata: COA
name: Columbia Airport
source: Tiger2009
aeroway: aerodrome
wikidata: Q1656920
wikipedia: en:Columbia Airport (California)
addr:state: CA
source_ref: geonames.usgs.gov
Tiger:MTFCC: K2451
tiger:ALAND: 51530
tiger:AREAID: 110750345200
tiger:AWATER: 0
tiger:STATEFP: 06
tiger:COUNTYFP: 109
tiger:reviewed: no
gnis:feature_id: 1653358

wikidata match: Q1656920

Search criteria from Wikidata

view with query.wikidata.org

station (Q12819564) public_transport=station
building (Q41176) building=yes
public transport stop (Q548662) public_transport=stop_position, public_transport=platform
aerodrome (Q62447) aeroway=aerodrome

Search criteria from categories

Airports in Tuolumne County, California aeroway=aerodrome, site=airport