I'm trying to implement geonames in all my portals now.
For France, it's ok, i manage to make my own sql requests to list the administrative region, then departements, then cities.
But i'm facing problems for Germany and Belgium and i'm wondering if there is not a bug or a personal miscomprehension in the allcountries database :
For Germany, for example i can display :
Allemagne > Baden-Württemberg > Regierungsbezirk Freiburg
but after... nothing..
If i give a look to the children webservice for the geoid 2925180 (Regierungsbezirk Freiburg), the xml answers me children that i have no idea how to find them within the allcountries database.
Is there something i did not see or the file allCountries.zip does not permit to find children cities for some countries ? (while it is possible via the children webservice)
Sorry i can answer myself... i only put "PPL like" codes for in my children sql request... Adding a search for ADM3 or ADM4 in the fcode field : it works better...
I'll be back to post again and participate to that great project.