http://forum.geonames.org/gforum/posts/list/4.page JForum - http://www.jforum.net Québec(adm1)->Monteregie(adm2)->Saint-Hyacinthe(PPL) but We have in the current database Canada->Québec(adm1)->Monteregie(adm2)->Saint-Hyacinthe(PPL) Canada->Québec(adm1)->Monteregie(adm2)->Saint-Hyacinthe(ADM3)->NOTHING And this is the case for almost all cities in Quebec 6251999 | CA | Canada | A | PCLI | 00 6115047 | CA | Québec | A | ADM1 | 10 6076966 | CA | Montérégie | A | ADM2 | 10 | 16 8673729 | CA | Saint-Hyacinthe | A | ADM3 | 10 | 16 | 54048 to fetch the PPLs I would do SELECT geonameid,name,featureclass,featurecode,admin1code,admin2code,admin3code,admin4code FROM geoname WHERE countrycode = 'CA' AND featurecode="PPL" AND admin1code = "10" AND admin2code = "16" AND admin3code = "54048"; So I will get no result. but if I fetch SELECT geonameid,name,featureclass,featurecode,admin1code,admin2code,admin3code,admin4code FROM geoname WHERE countrycode = 'CA' AND featurecode="PPL" AND admin1code = "10" AND admin2code = "16"; I get the correct result 6138374 | CA | Saint-Hyacinthe | PPL | 10 | 16 To get the correct result I would need to Add 54048(georeference) I beleive into the admin3code of Saint-Hyacinthe (6138374) So then I would get Canada->Québec(adm1)->Monteregie(adm2)->Saint-Hyacinthe(ADM3)->Saint-Hyacinthe(PPL) But I dont think Saint-Hyacinthe->Saint-Hyacinthe is right And it is like that for almost all Cities in Quebec. but if I am wrong, I really wish I to know what I am doing wrong in my hierarchy look up but then if I am right, if I could help someone fixing it I would be glad. thank you ]]> http://forum.geonames.org/gforum/posts/list/7695.page#16240 http://forum.geonames.org/gforum/posts/list/7695.page#16240 GMT