User:EmericusPetro/sandbox/List of Wikidata to OSM Name Suggestion Index identifier

From OpenStreetMap Wiki
Jump to navigation Jump to search

Uses https://www.wikidata.org/wiki/Property:P8253

Query 1 (no languages)

SELECT DISTINCT (?wikidata_p_value AS ?item__conceptum__codicem) (STRAFTER(STR(?item), "entity/") AS ?item__rem__i_qcc__is_zxxx__ix_wikiq) WHERE {
  {
    SELECT DISTINCT ?item WHERE {
      ?item p:P8253  ?statement0.
      ?statement0 (ps:P8253 ) _:anyValueP8253 .
    }
  }
  ?item wdt:P8253  ?wikidata_p_value .

}
GROUP BY ?wikidata_p_value ?item
ORDER BY ASC (?item__conceptum__codicem)

Run it (edit query)