Include column for Wikidata identifier, suggestion

[ppKrauss]

Wikipedia have stable pages for all cities, and Wikidata supply an ID for it.
Today Wikidata IDs are playing important role as "concept identifier", for Web Semantic in general and for open projects like OpenStreetMaps, etc.

Example: the instances of municipalities of Brazil have a simple query at Wikidata,

SELECT ?item ?itemLabel
WHERE { 
  ?item wdt:P31 wd:Q3184121 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }    
} LIMIT 500

[valerio-bozzolan]

This Wikidata query may be a starting point to get cities with GeoName IDs and Wikidata ID:

SELECT DISTINCT ?wikidataIDLabel ?geonameID ?wikidataID
WHERE 
{
  ?wikidataID wdt:P31/wdt:P279 wd:Q7930989. # must be city/town
  ?wikidataID wdt:P131  ?region.
  ?wikidataID wdt:P1566 ?geonameID.
  ?wikidataID wdt:P1082 ?population.

  FILTER (?population > 15000)

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY ASC(?wikidataIDLabel)

The results can be downloaded as a simple CSV file from here:

https://w.wiki/56bG