GeoNames Forum

I was viewing the content of cities15000.txt and I found some strange entries which are fake. For instance entries of Pakistan are quite weird. For instance. check the following array dump for a single record:

Code:

 Array
 (
     [0] => 1162004
     [1] => Khairpur
     [2] => Khairpur
     [3] => Khaipur,Khairpur Mirs,Khairpur MÄ«rs
     [4] => 27.5333333
     [5] => 68.7666667
     [6] => P
     [7] => PPL
     [8] => PK
     [9] => 
     [10] => 05
     [11] => 
     [12] => 
     [13] => 
     [14] => 124602
     [15] => 
     [16] => 50
     [17] => Asia/Karachi
     [18] => 2006-01-17
 )

OK Index "1" seems ot tel city name but then I find long and lat not correct(no minus sign) plus entry # 17 that is "Asia/Karachi", Karachi itself is a separate city and has no relation with "Khairpur"

Can you please tell me what's the issue

Hi. I'm new at this, but the data looks correct to me.
The Lat / Lon information shows the correct location on Google maps. See attached screen shot.

Entry 17 is the timezone. I'm assuming Karachi is the capitol city, or at least a major city in the zone where Khairpur is located, hence the reference to it in relation to the "zone".

I hope that's of some help.

The layout of the geonames table from the documentation is as follows:

The main 'geoname' table has the following fields :
---------------------------------------------------
geonameid : integer id of record in geonames database
name : name of geographical point (utf

varchar(200)
asciiname : name of geographical point in plain ascii characters, varchar(200)
alternatenames : alternatenames, comma separated varchar(4000) (varchar(5000) for SQL Server)
latitude : latitude in decimal degrees (wgs84)
longitude : longitude in decimal degrees (wgs84)
feature class : see http://www.geonames.org/export/codes.html, char(1)
feature code : see http://www.geonames.org/export/codes.html, varchar(10)
country code : ISO-3166 2-letter country code, 2 characters
cc2 : alternate country codes, comma separated, ISO-3166 2-letter country code, 60 characters
admin1 code : fipscode (subject to change to iso code), isocode for the us and ch, see file admin1Codes.txt for display names of this code; varchar(20)
admin2 code : code for the second administrative division, a county in the US, see file admin2Codes.txt; varchar(80)
admin3 code : code for third level administrative division, varchar(20)
admin4 code : code for fourth level administrative division, varchar(20)
population : integer
elevation : in meters, integer
gtopo30 : average elevation of 30'x30' (ca 900mx900m) area in meters, integer
timezone : the timezone id (see file timeZone.txt)
modification date : date of last modification in yyyy-MM-dd format

So you would be looking at:

Name > field 1
LAT > field 4
LON > field 5
Timezone > field 17

thanks a bunch !