GeoNames Forum

United States State Capitals are encoded with feature code PPL. It seems to me that they should be marked as PPLG, or perhaps some other distinguishing code.

The same would apply to the administrative seats of ADM1 level entities in other countries as well, assuming such exist.

I would be happy to provide you with the names and GEONAME IDs of the US Capitals.

Hi Carey

You are right. The Capitals of US states should have the featureCode PPLA for seat of a first-order administrative division.
I will update the datebase if you can send me the geonameId.

Thanks

Marc

Interesting question arises....

When you update the database, do you ever provide the set of queries or documentation or the change?

Would be pretty easy to modify (50 or so queries in this case ) for a MySQL database from a Postgre.

I try to run most updates through the normal modification chain to add a history and include it in the daily modification dump. Sometimes however the database is directly updated without including the modification in the history and the daily modification dump.
I can start a forum thread with these updates, so you can repeat it on your geonames copy.

Cheers

Marc

Marc,

I emailed you a list of Geoname IDs, State Capital names and State names today.

If you need anything else to set the state capitals to type PPLA, let me know.

Carey

The US state capitals have yesterday been updated to PPLA. The changes are in todays dump and in the daily modification file.

Thanks Carey.

Marc