GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register /  [Login] Login 
DB dump of cities only  XML
Forum Index -> General
Author Message
[Post New]23/01/2007 20:46:41
    Subject: DB dump of cities only
[Up]
brakai295



Joined: 23/01/2007 20:41:40
Messages: 4
Offline
Hi,

is it possible or does anyone know where to get a database dump of the cities, villages etc of ALL countries only (only P.PPL)?

I'm running a travel blog site and would like o be able to offer my users a localization tool with Google Maps, to show near what city they are currently located in the world.

I'm not very familiar with databases and programming in general. I'm just trying to figure out if what I'd like to do is actually possible.

Thanks!!!

Kai
http://www.ausmag.de
http://www.globalzoo.de
[Post New]25/01/2007 20:44:40
    Subject: Re:DB dump of cities only
[Up]
marc



Joined: 08/12/2005 07:39:47
Messages: 4416
Offline
Hi Kai

I think the cities files are what you are looking for :

cities1000.zip : all cities with a population > 1000 (ca 80.000)
cities5000.zip : all cities with a population > 5000 (ca 40.000)
cities15000.zip : all cities with a population > 15000 (ca 20.000)

http://download.geonames.org/export/dump/

Cheers

Marc
[WWW]
[Post New]06/02/2007 06:41:13
    Subject: Re:DB dump of cities only
[Up]
mayuri



Joined: 05/02/2007 13:28:12
Messages: 4
Offline
hi...
I was looking for a similar db dump with lat and long of the cities...
Any idea where i can get them from?
[Post New]06/02/2007 07:38:34
    Subject: Re:DB dump of cities only
[Up]
marc



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

mayuri wrote:
I was looking for a similar db dump with lat and long of the cities...
Any idea where i can get them from? 

Well, this is exactly the topic of this project. Why don't you use the abovementioned files

Marc
[WWW]
[Post New]08/02/2007 01:33:05
    Subject: Re:DB dump of cities only
[Up]
wtranmer



Joined: 08/02/2007 01:16:37
Messages: 1
Offline
Simply astounding.

The phrase I think you need here is "rtfm"
[Post New]08/02/2007 05:45:47
    Subject: Re:DB dump of cities only
[Up]
mayuri



Joined: 05/02/2007 13:28:12
Messages: 4
Offline



cities1000.zip : all cities with a population > 1000 (ca 80.000)
cities5000.zip : all cities with a population > 5000 (ca 40.000)
cities15000.zip : all cities with a population > 15000 (ca 20.000)
 


hey u knw wat ... this discription didnt say anything about lat/long.... hence the confusion...... Thanx anyways...
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team