GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Obtain cities1000 from allCountries dump  XML
Forum Index -> General
Author Message
collimarco



Joined: 19/05/2015 22:48:16
Messages: 2
Offline

I read that "cities1000.zip" contains "all cities with a population > 1000 or seats of adm div (ca 80.000)".

Is the dump cities1000 **exactly equivalent** to the following query?

SELECT *
FROM geoname
WHERE (feature_class = 'P' AND population > 1000)
OR feature_code = 'ADM'
OR feature_code = 'ADM2'
OR feature_code = 'ADM3'
OR feature_code = 'ADM4'

Or is there some **more advanced processing**? (to avoid duplicates for example)Code:

		
[code]
marc



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

Code:
         public boolean isCities1000() {
                 if ("P".equals(featureClass)) {
                         return population > 1000
                                         || (featureCode != null && featureCode.startsWith("PPLA"))
                                         || "PPLC".equals(featureCode) || "PPLG".equals(featureCode);
                 }
                 return false;
         }
 

[WWW]
collimarco



Joined: 19/05/2015 22:48:16
Messages: 2
Offline

Thank you! That was exactly what I was looking for
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team