GeoNames Forum

Hi, first of all I would like to thank the Geonames team for the good data provided.

The last couple of days I was trying to query the administrative regions of some countries and their capitals.

If I understood this right I use a query like the following to get the capital of England for instance:

SELECT * FROM geoname
WHERE country_code LIKE 'GB'
AND admin1_code LIKE 'ENG'
AND fcode LIKE 'PPLA';

Result: West Ilsley (geonameid: 11747336)

Obviously this is wrong! The correct result should be 'London'.

Am I doing anything wrong? Is there another way to query the regional capitals?

Any help would be much appreciated. Thanks.

Hi Andre

London is not only a PPLA but also the capital and thus PPLC.
The more relevant feature code prevails.
Search for PPLA and PPLC and PPLG , sort in this order and use the first result.

Best Regards

Marc