Get state / province data from geonames data?

Question

I downloaded these databases for US and CA from GeoNames . The date is as follows:

5881639 100 Mile House 100 Mile House 51.64982 -121.28594 P PPL CA 02 0 917 America/Vancouver 2006-01-18 5881640 101 Mile Lake 101 Mile Lake 51.66652 -121.30264 H LK CA 02 0 917 America/Vancouver 2006-01-18 5881641 101 Ponds 101 Ponds 47.811 -53.97733 H PNDS CA 05 0 18 America/St_Johns 2006-01-18 

I want to use this data for a city collector, but I want to display it in a province or state. This data does not seem to contain this information. Is there any way to get this? Or is there a better database that includes this?

Answer 1

You use the data in the columns for admin codes, which are actually identifiers that refer to the admin code table (there are separate data sets available for admin codes), this is very straightforward.

Visit the geonames forums for more information.

http://forum.geonames.org/

Answer 2

Use these data sets here: geocoder.ca , which include the name of the city and the name of the state / province in the same file.

If you want to stick to your data, you can use the Google geocoding API, as in the first answer here:

Google Maps: how to get country, state / province / region, city, lat / long value?

to get information based on latitude and longitude. It will be a lot of work, however, especially for the collector.