sabv
Joined: 10/11/2011 05:35:19
Messages: 4
Offline
|
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.
|