GeoNames Forum

hi,

I have loaded the hierarchy.zip into an Oracle table and am trying to get all the children of US. I am using following query
select childid, level
from tr_geo_hierarchy
where type='ADM'
connect by prior childid=parentid
start with parentid=6252001

The query returns only two levels which is State and County for US. How do we get the cities that are part of county? I was hoping to get a tree at least upto the city level.

Has anybody done this before and can share his/her knowledge.

Thanks.