GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
ask for help-create tables with sql  XML
Forum Index -> FAQ - frequently asked questions
Author Message
gallida



Joined: 20/11/2009 15:34:38
Messages: 3
Offline

Hello there!
As I don't have many abilities in programming I would like to aks how can I take the results of each conutry into a table.
Only through SQL?Is it a programme?Do I have to download it?
marc



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

If you don't know sql then why do you want to load it into a table?

Marc

[WWW]
gallida



Joined: 20/11/2009 15:34:38
Messages: 3
Offline

Because I have to use the results of geonames in my master thesis and I can't just copy-paste them
marc



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

it is difficult to help you when you don't clearly say what you need. if you speak about the dump files then you can open them with excel (it will only import the first n rows) or with access.

If you are speaking of an interactive result then I suggest you copy the html result into word/excel or even take a screenshot.

Best

Marc

[WWW]
gallida



Joined: 20/11/2009 15:34:38
Messages: 3
Offline

I just want to extract from the whole file the original name of the city,country etc and the ascii name.
My supervison told me to make a perl script but i'm also looking for the sql solution.
Is there an idea?
marc



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

use whatever tool you are familiar with.

SQL seems an overkill, even more so as you don't really seem to know it well and don't know how to load the data into a table. Unless you want to learn it and don't care how long it takes to accomplish the task.

Best

Marc

[WWW]
 
Forum Index -> FAQ - frequently asked questions
Go to:   
Powered by JForum 2.1.5 © JForum Team