Naming Known (at Least Turkish) Countries, Cities and Districts

[makiftutuncu]

One problem with the data Diyanet web page provides is that countries, cities and districts are not named properly. Almost all of them are named as they appear in Turkish, but without correct letters. They uppercased all names with an incorrect locale, apparently. I'm currently trying to clean names a bit by capitalizing each word but obviously it is not enough.

One possible solution is that I could get a list of correct names of some (if not all) counties, cities and districts and map the ids to correct names. If something does not match, then by default I could use whatever Diyanet gives.

Try to find an open source licensed list of names of counties, cities and districts.

[makiftutuncu]

Thanks to Wikipedia, I'm now preparing a list of countries and their names. :)

[makiftutuncu]

Here is the document I prepared and used in my code: https://docs.google.com/spreadsheets/d/1w0bNpkAzjY2GsDGTh3RlqShUVzmy3emgzXpgoElRFrU/edit?usp=sharing