GeoNames Forum

Hello,

(I'm from France and I don't know a lot about Belgium)

I've just noticed that the code ADM1 = 02 was not present in the geonames database... I've checked a bit on Wikipedia and apparently it's an old region that was splitted in 2 parts in 1995.
(http://en.wikipedia.org/wiki/Province_of_Brabant).

Everything seems ok so far... except that the geonames entries are not moved accordingly.
So basically, we've lost the code 02, but there are thousand of entries pointing to the old code ADM1=02.

SELECT * FROM `geoname` WHERE `geoname`.country = 'BE' and `geoname`.admin1 = '02'

returns 2,758 rows

Anyone with data from Belgium, could fix this ?
Or is this a normal behavior ?

Thanks a lot,

Ugo PARSI

Hi Ugo
you are right : administratives divisions for Belgium have to be fixed in GeoNames.

There should be 3 ADM1 :
BRU Brussels Capital Region
VLG Flemish Region
WAL Wallonia

Then 10 ADM2 (provinces),
43 ADM3 (districts)
and ADM4 (municipalities).

This will be done before end of june.

Thanks for your quick answer.

But actually the problem is deeper... maybe the administrative regions are broken, but actually we've got thousands of cities that are orphans (since they are still referenced as ADM1 = 02 and 02 no longer exists).

Is this planned to be fixed too ?

Ugo PARSI

Yes. Cities and sections of cities will be fixed too.

Administrative divisions (ADM1/2/3/4) have been updated :
http://geotree.geonames.org/?id=BE

Still in progress :
- sections de commune (PPL)
- postal codes as alternane names

Hi

I am using some dump data and noticed that in the table for the geonames the admin1 column is "WAL" and "VLG" while in the admin1codesascii table the admin1 codes are referenced as "BE.WA" and "BE.VL". I have no example for "BE.BR" but I expect that to be the same.

Maybe this was updated already as there is some work going on in the Belgium data as my dump is already a week old. However, I felt like telling you.

Sorry, I was using the mysql import solution posted on this board and in the 2 admin table a char(5) was used so the codes got truncated. Here the thread:

http://forum.geonames.org/gforum/posts/list/15/732.page#4483

Sorry to resurrect an old thread, but it seems the belgian database is still somewhat lacking:

Code:

 select admin1, count(*) from geonames where country='BE' group by admin1;
 +--------+----------+
 | admin1 | count(*) |
 +--------+----------+
 |        |      367 |
 | 00     |       90 |
 | 01     |       32 |
 | 02     |       23 |
 | 03     |        9 |
 | 04     |       10 |
 | 05     |        4 |
 | 06     |        8 |
 | 07     |       12 |
 | 08     |       23 |
 | 09     |        3 |
 | 11     |       76 |
 | 13     |     8642 |
 | 14     |     7652 |
 | BRU    |       65 |
 | VLG    |     1653 |
 | WAL    |     2567 |
 +--------+----------+

A lot of PPLs (and other features) are still lacking the correct admin1 value (and probably admin2-4 as well).

Is there any chance this will/can be fixed?