well...doesn't seem too hard.
I've converted the data now in a civ suitable format, meaning I've now the cities here with coordinates from 0 - 360 /0 - 180, instead of -180 - +180 / -90 - +90.
Means London, which is .7 West (~-1), 51° North, is now 179 / 141 in civ termes.
But 1 problem are the multiple names.
Because apparently also London in Ontario, Canada, and London in Kiribati are in the list, as well as Paris in Texas and Berlin, New Hampshire (and probably some more).
Guess I'll first have to go over the list and select only the biggest names and kick the smaller ones out. Is probably not a problem for the better inhabited areas, but Kiribati...uh....
And in total there are 8828 city names. Considering that we have a theoretical map of 360 x 180, so in total 64800 tiles, where roughly 70% are water, this results in 19440 land plots...not really many names...
EDIT: Further problem might be the date line. At the moment I had assumed that most maps use the date line as the west border, but you cannot be sure. Might be necessary to go with something else as the west border, e.g. the end of Alaska, and let the names flow over the east border accordingly. But that will be ugly
.
I've converted the data now in a civ suitable format, meaning I've now the cities here with coordinates from 0 - 360 /0 - 180, instead of -180 - +180 / -90 - +90.
Means London, which is .7 West (~-1), 51° North, is now 179 / 141 in civ termes.
But 1 problem are the multiple names.
Because apparently also London in Ontario, Canada, and London in Kiribati are in the list, as well as Paris in Texas and Berlin, New Hampshire (and probably some more).
Guess I'll first have to go over the list and select only the biggest names and kick the smaller ones out. Is probably not a problem for the better inhabited areas, but Kiribati...uh....
And in total there are 8828 city names. Considering that we have a theoretical map of 360 x 180, so in total 64800 tiles, where roughly 70% are water, this results in 19440 land plots...not really many names...
EDIT: Further problem might be the date line. At the moment I had assumed that most maps use the date line as the west border, but you cannot be sure. Might be necessary to go with something else as the west border, e.g. the end of Alaska, and let the names flow over the east border accordingly. But that will be ugly
