Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get lat/long from polygon geometry

user11219778Oct 30 2012 — edited Nov 8 2012
Hi,

I have an application where I need to get point(lat,long) values from polygon geometry. It has to be
in a seperate column. I have tried following but it is not working in my application. How I should
get lat, long column in a seperate column i.e. select a.LATITUDE, a.LONGITUDE, a.geometry from table1 a.
Please help!

select s.ID, t.x as LATITUDE, t.y as LONGITUDE
FROM table1 s, Table(sdo_util.GETVERTICES(s.geometry)) t

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2012
Added on Oct 30 2012
#database-key-features, #spatial
3 comments
1,818 views