GeoNames Forum

Hello,

I recently imported the allcountries.txt and countryInfo.txt into my MsSQL database. What is the best way to have multiple chained dropdown lists to find out someone's city. For example:

Select Country -> State -> City

OR

Select Country -> City

Any help would be appreciated. Thanks

I would say it depends on how many cities you are using and which countries you are dealing with. If you use all 2 million populated places it will become a pretty large dropdown list for some countries.

Cheers

Marc

How is the database linked? For example, how might one link the following:

Country -> Region -> City

...where Region could be a province or state.

Thanks!

The first order administrative divisions have the feature class A and the feature code ADM1. Their code is referenced in the column admin1Code.

Marc

Is there documentation on this column admin1Code? I am having trouble figuring out how to related the columns.

For example how would I find the following in the database:

US -> California -> Los Angeles

I think the Fipscode for California is 06, but when i typed that into admin1Code column the countryCode was not 'US'. How can I find more information on how to relate the columns?

Thank you.

For US locations, the admin1_code is the two character state code. So for Los Angeles, California, use 'CA' for the admin1_code.

If you search the geonames database for name='Los Angeles' and admin1_code = '06', you'll get
Los Angeles, Columbia

Hi everybody,

Is there any way to retrieve country > state > cities informations to create dropdown lists with webservices (free or not) ?

With "children" we can't get all the cities of a state (we must pass through all subdivisions)

Thanks and sorry for my broken english