query-a17f2c300d2860b8ffd07ea498df5a64

rq turtle/ttl

:https://sophox.orgThere appears to be 236 nodes or ways that link to wikidata, which aren't linked from wikidata. I heard their triplestore lags 10 months behind the live data. Enter the following at

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX geof: <http://www.opengis.net/def/function/geosparql/>
select ?s ?wd
where {
  # items that are nodes or ways and link to wikidata
  ?s osmm:type ?type. FILTER(?type IN ('n', 'w'))
  ?s osmt:wikidata ?wd .

  # located in bounding box covering mainland iceland
  ?s osmm:loc ?coord .
  BIND(geof:latitude(?coord) AS ?lat)
  BIND(geof:longitude(?coord) AS ?long)
  FILTER(?lat < 67.13 && ?lat > 63.39402834 && ?long < -13.49596381 && ?long > -24.53338265)

  # minus items already linked from wikidata
  MINUS {
    SERVICE <https://query.wikidata.org/sparql> {
      SELECT ?item WHERE {
        ?item wdt:P17 wd:Q189 .
        ?item wdt:P10689 [] .
      }
    }
    ?s osmt:wikidata ?item .
  }
}
LIMIT 1000

Query found at