GeoNames Forum

i need this files, It's available?

becuse this query no give me correctly all results.

SELECT * FROM `admincodes1` t1 LEFT JOIN admincodes2 t2 ON (t1.code = LEFT(t2.code, 5) ) WHERE t1.code like "FR.%" ;

it's right?

thank's

Nei

Hi Nei

These files are not (yet?) available. You can create them from the full exort with

select countrycode || '.' || admincode1 || '.' || admincode2 || '.' || admincode3, name from geoname where featurecode = 'ADM3'

and

select countrycode || '.' || admincode1 || '.' || admincode2 || '.' || admincode3name || '.' || admincode4, name from geoname where featurecode = 'ADM4'

Cheers

Marc

but, in geoname table has many rows that hasn't codes of admin3 and admin4

This is true. For many places we lack the information to which administrative division they belong to.

Marc