GeoNames Forum

I downloaded the Cities1000 file to put in my database for lat/lon lookup, but alot records are like this:

2959927 Aalen 488.333.333 10.1 DE Europe/Berlin

Aalen in Berlin on a Lat of 488.333.333 ?

How should i read this? Isnt it easier to keep just 1 decimal dot in the notation?

Here the line looks like this :
Code:

 grep Aalen cities1000.txt
 2959927 Aalen   Aalen   Aalen,Alene,Älene       48.8333333      10.1    P       PPL     DE  01      67085           451   Europe/Berlin    2006-11-05

It must be a problem with the tool you are using to view the data. (Excel perhaps?)
In some locales the dot is not used as the decimal separator but as the grouping indicator. Your tool probably does not interpret the dot as decimal separator.

Cheers

Marc

Oh strange I see it now yeah, im sorry, i propably just checked it with Excel, deleted some colums and saved it as CSV, so thats why it was messed up! Thanks anyway!