Skip to Main Content

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!

lat/long to SDO_POINT (SDO_GEOMETRY)

720119Mar 9 2012 — edited Apr 23 2012
I have to convert lat/long pairs to convert into SDO_GEOMETRY points. But the problem is the lat/long pairs are having the data as follows where i was expecting to see +ve and -ve.

LAT LONG
422147.08 830443.35
422641.24 831201.85
422306.4 831503.48
422303.58 831017.41
422308.28 830953.06
422304.23 830916.46

1. What kind of Coordinate system are these ?
2. how to convert them into SDO_GEOMETRY point ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 21 2012
Added on Mar 9 2012
5 comments
1,272 views