GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Is everything in the GeoName countries?  XML
Forum Index -> FAQ - frequently asked questions
Author Message
oyen



Joined: 27/09/2008 10:15:28
Messages: 5
Offline

The 'Name' column of the GeoName database refers to what?

If there is a reference table available online for what each column is, then I would appreciate a link (I tried looking for it but couldn't find anything).

I find it hard to believe that the 'Name' column refers to cities...because I don't think there are cities with 0 population...

If they're not cities, then what are they?
marc



Joined: 08/12/2005 07:39:47
Messages: 3993
Offline

Please read the readme:
http://download.geonames.org/export/dump/readme.txt

The 'name' field stands for the 'name' of the toponym. A toponym is not necesarily a city and even for cities the population may be empty (0=n/a).

Marc

[WWW]
oyen



Joined: 27/09/2008 10:15:28
Messages: 5
Offline

I checked that before but I didn't quite understand everything. Thank you for explaining it.

BTW is there an updated version of allcountries.txt?
the Philippines has a name 'Philippine Islands' when its official name is 'Republic of the Philippines'
marc



Joined: 08/12/2005 07:39:47
Messages: 3993
Offline

The file allcountries.txt is updated daily. please feel free to help us improve it: http://www.geonames.org/manual.html

Marc

[WWW]
bruce



Joined: 17/10/2008 16:14:53
Messages: 8
Location: South Africa
Offline

So if I read a line in the the geoname table
I should be able to index fields

1 name
4 latitude
5 longitude
8 country code
16 elevation
18 timezone

# python code to read line
s=f.read() # read text line
s.split(',') # split (I'm not sure comma or tab separated)
elev = s[16]

oyen



Joined: 27/09/2008 10:15:28
Messages: 5
Offline

I can see that the wiki has the right entry for the Philippines. Unfortunately, the allcountries.txt that I downloaded recently does not have the right entry in it. I'll download one right now to check if it only changed recently - like in the last couple of weeks (but I doubt it).
 
Forum Index -> FAQ - frequently asked questions
Go to:   
Powered by JForum 2.1.5 © JForum Team