GeoNames Forum

Hi again,

Does the allcountries file gather exactly all the separate country files ?

For example i notice that be.zip offers the adm2 and adm3 fields which are not fullfilled in the allcountries file for Belgium places ?

Would it be better for users to use each country file instead of working with the big allcountries file ?

If it's not a bug, do you need help to agregate all the last versions of the different countries files in one ?

Seb H, France

Can you check again and give us an example record? I can't believe this.

Marc

Shame on me

I did work probably with an old file. I have deleted them all then load once more the allcountries file, import it to access then from access to sql server and i now have the adm2,3 fields fullfilled for belgium... I'm very sorry Marc. Hope you did not waste your time on my thoughtlessness mistake

one question perhaps :
I'm trying to develop my own chidren / parent sql requests. I'm a little new with the geonames files structure and at certain moments lost with adm1,2,3,4 and fcode which can have different administrative level from a country to another.

In a portal of mine with cities and adm zones, i managed to be sure of the parent / children just adding a "ParentId" field.

Couldn't it be a solution to add a ParentId field in the allcountries file just to be able to have quick sql request instead of trying to see if it exists adm4, adm3, adm2 etc... ?

Hope this could help for future, and sorry again for my mistake about belgium adm fields.

Seb H, France