Latest posts for the topic "Cities data authentication"

Cities data authentication

kadnan — GMT

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

Re:Cities data authentication

terryh — GMT

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.

Re:Cities data authentication

terryh — GMT

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 (utf8) 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

Re:Cities data authentication

kadnan — GMT

thanks a bunch !