GeoNames Forum

Hi Marc,

How can I query all places within the ADM1 category... (and forget adm2 (counties etc..)

Example.. Give me all the places of the state OHIO...

There is also an adm2 but i am not interested in that..(except the places of course)

Thanks,
Ron Sahertian

select * from geoname where admincode1='OH';

If you only want populate places:

select * from geoname where admincode1='OH' and featureClass='P';

Thanks for your answer Marc!

But, this is sql... can I do that also with xml from geonames.org?

Thanks,
Ron

Ron

You are writing 'all' places. The xml interface is not meant to get the entire database or huge numbers of records. There are nearly 60000 toponyms in Ohio.
You can get the first of them with the web service:
http://ws.geonames.org/search?q=&maxRows=10&country=US&adminCode1=OH

Documentation:
http://www.geonames.org/export/geonames-search.html

Best

Marc

thanks Marc!