http://forum.geonames.org/gforum/posts/list/4.page JForum - http://www.jforum.net get the full list of Countries: select * from allCountries where feature_code = 'PCLI' get the full list of states/provinces inside a country, for example USA: select * from allCountries where feature_code = 'ADM1' and country_code = 'US' i have tested this query for Canada and USA. Don't know if it will always work for the other countries get the full list of cities inside a state/province, for example New York / USA select * from allCountries where feature_code = 'PPL' and country_code = 'US' and admin1code = 'NY' this is where i don't know where to get only the cities inside a state. I get too much elements with that query. i get Abbotts, Abell Corners, Abenaki Mobile Home Park, etc... but if i compare it to the officiel list from Wikipedia http://en.wikipedia.org/wiki/List_of_cities_in_New_York, these cities doesnt exist. Also, i'm supposed to see Albany, Auburn but i dont get them with the query. So my question is, how can i select only the real official cities?]]> http://forum.geonames.org/gforum/posts/list/4144.page#12273 http://forum.geonames.org/gforum/posts/list/4144.page#12273 GMT http://forum.geonames.org/gforum/posts/list/4144.page#12284 http://forum.geonames.org/gforum/posts/list/4144.page#12284 GMT http://forum.geonames.org/gforum/posts/list/4144.page#12287 http://forum.geonames.org/gforum/posts/list/4144.page#12287 GMT http://forum.geonames.org/gforum/posts/list/4144.page#12364 http://forum.geonames.org/gforum/posts/list/4144.page#12364 GMT