GeoNames Forum

Hi

Is there any way to Get Countries List?
Is there any ways to Get States List based on Selected Country?
Is there any way to Get Cities List Based on Selected State?

I'm trying to create a registration page in ASP.Net 2005, Where i need to place 3 combo boxes (Country, State, City).

On page Load function it should pull the Countries list and bind in combo box.

When user chosen a country, states combo box should be populated and
when State is chosen, Cities need to be populated..

How to do with geoname webservices?

Anybody Help me????

Thanks in Advance

check out the documentation of the search service and the hierarchy service.

Marc

I've been trying to do with by getting the database dump from the site. I have been able to load the main table, GeoNames, AlternateNames, Hierarchy, and CountryInfo.

I'm trying to see what Hierarchy table does? Can anyone comment on this table?

I understand from other posts that admin1 - 4 defines hierarchy. To make this efficient, are users indexing these fields? It looks like I may need to create a new table(s) to store this information for fast lookups. Anyone who has had success implementing this in a heavy production env? I'm using SQL 2008.

I'd like to bascially achieve what the following WS is doing.
http://www.geonames.org/export/place-hierarchy.html

Thanks

I see that there is the file hierarchy.zip on the download server. Is that a new file?
There is no description for it in the readme.txt
Can that be added?

it is a new file and documentation will be added in due time.

Best

Marc

Ok, thanks a lot.

Wow, thanks for the post.

I was also suffering from the same problem and got the solution as soon as I joined the forum.

My pleasure to join the community.

Regards,

Subject: Re:Getting Country, State, City List

http://du.somee.com/combo.asp

dzinerdu wrote:

Subject: Re:Getting Country, State, City List

http://du.somee.com/combo.asp

This script http://du.somee.com/combo.asp doesn't work properly. For example if you choose US, then state Californie it will populate you a list of counties and not the list of cities. I came across the same problem.

So the question would be: how to get a list of the cities from hierarchy based on region and skip counties?

a script only on region wouldn't make much sense as you would end up with drop down lists of 10000 and more records. Technically it can easily be implemented with just looking at the admincode1. Beware of cities that are missing admin codes.

Marc

Got it.

http://ws.geonames.org/search?q=California

And as far as I understand cities have fcode PPL or PPLA?

So friend, good day, a service check of all world cities that lists 100% efficiency will be hard to find, as I just said I took the geonames API to do this search via XMLHHTPS, did not download any file from the webservice only consume, as an example the state has not FRANCE, only cities, and some countries of Africa rsrsrsr my good, has no way to list it 100%, on CALIFORNIA packed there something, go back http://du.somee.com/combooo.asp?uf=5332921&pf=6252001&estado=6252001 more you can not put in alphabetical order.

Hi everyone,

I need to get a list of cities.

I do have a file that has weird characters.

I would appreciate any help.

Is there a place I can redownload this file.

Hmm, did you look at the download section of this website?

Marc

not sure where to find it in the download section.

I had been working with this for a while and i have created a snippet for myself. Here it is. You can copy the complete page and you can work it out for further usage. This applies to anybody who lands this page.

http://vikku.info/programming/geodata/geonames-get-country-state-city-hierarchy.htm

Just view source that page and download all the includes in script tag. Thats it. I am further expanding my description so in due course of time there will be more information.

hello,

i need all infos about:

Continents, Countrys, States/Regions, Cities, Currencys, latitude/longitude, Flags, Laguage, time zones, calling codes, Country Code

Any can help?

Thanks!

hello,

I need to save all Country, State, City List data in my local database.
Can any one help me on this I am not able to dump load data to mysql database.

HI,

I got success to import geoname data in geoname table and hierarchy table and able to get country state and counties information using below mentioned sql queries but still facing issue with city selection please help me on this.

/* Get Countries */
Select * FROM geoname WHERE fCode in ('PCLI') and country='US' and fclass='A'

/* Get all states for US {6252001 } */
Select * from geoname G inner join hierarchy H on H.childid=G.geonameid where G.fcode='ADM1' and h.parentid= 6252001 and G.fclass='A' order by G.name Asc

/* Get all counties for Alabama state {4829764 } */
Select * from geoname G inner join hierarchy H on H.childid=G.geonameid where G.fcode='ADM2' and h.parentid= 4829764 and G.fclass='A' order by G.name Asc

/* Get all City for Autauga County {4830868 } */
Select * from geoname G inner join hierarchy H on H.childid=G.geonameid where h.parentid= 4830868 and G.fclass='P' order by G.name Asc -- G.fcode='PPL' and