GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register /  [Login] Login 
All cities without cities districts, etc.  XML
Forum Index -> General
Author Message
[Post New]09/03/2012 06:44:08
    Subject: All cities without cities districts, etc.
[Up]
jacek.francuz



Joined: 08/03/2012 11:27:22
Messages: 1
Offline
Hello,

We have the following problem: We need to assign certain objects to cities using Geonames database. Assignment is based on distance between object and city - the closest city is assigned to object. Recently we were using cities1000 - subset of Geonames. It worked perfectly but had one disadvantage - a lot of smaller cities/towns/villages were missing. To solve the problem we decided to copy all objects from Geonames matching the following condition (based on fclass and fcode taken from cities1000 database):
Code:
WHERE gn.fclass="P" AND gn.fcode IN ('PPL','PPLA','PPLA2','PPLA3','PPLA4','PPLC','PPLF','PPLG','PPLL','PPLQ','PPLR','PPLS','PPLW','PPLX')


Unfortunately it did not work well. There were a lot of duplicated locations (e.g. London as city, as capital, etc.). Additionally, it contained districts of cities. After assigning our objects to the cities we end up without London at all but we had 'City of Westminster' instead (small part of London) which is incorrect.

Is there any reliable compilation of all cities similar to cities1000? Or perhaps there is some other way to create such a subset?

Thanks!
Jacek
[Post New]20/03/2012 22:39:12
    Subject: Re:All cities without cities districts, etc.
[Up]
sabv



Joined: 10/11/2011 05:35:19
Messages: 4
Offline
We have exactly same issue. Trying to find a reliable way to finding all cities from geoname.
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team