GeoNames Forum

marc wrote:

For Spain we are using the following administrative divisions :

ADM1 = comunidades autónomas (17)
ADM2 = provincias (50+2)
ADM3 = comarcas / municipios (*)
ADM4 = municipios

* : In Catalunya we have four administrative divisions with comarcas as ADM3 and Municipios as ADM4. In all other comunidades we have only three levels.

Hi marc !

First of all, I'd like to thank you (and the community) for the incredible work done on geonames.

About this municipios, wouldn't it make sense that all municipior in Spain have an ADM4 entry, with an empty ADM3 in case they are not in Catalunya ?
Maybe 'having ADM4 without ADM3' breaks your data model, but I find it quite difficult to work on this dataset where the same data (i.e. administrative code) is spread over two columns.
(I have a temp table with both columns merged, but it would still be a lot easier for updates & all if the data was in the same column)

Regards