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!

Creating local-tangent-plane Cartesian CS

697015Apr 19 2010 — edited Apr 22 2010
Good day, colleagues!

I need to write a procedure to preprocess my spatial data from Google Earth before loading. To do this I must convert data to local-tangent-plane Cartesian CS. As I can see from Spatial Developer's Guide, I must create a new coordinate system. As I can see, coordinate transformation method for local-tangent-plane is ESPG 9840.

The issue is there is no 9840 method in sdo_coord_op_methods. At the same time I see, that Oracle Spatial can built-in possibility to convert to local-tangent-plane CS. Oracle Spatial Developer's Guide: "When these functions are used on data with geodetic coordinates, they internally perform the operations in an +implicitly generated local-tangent-plane Cartesian coordinate system+ and then transform the results to the geodetic coordinate system."

So, how how can I convert my data to local-tangent-plane CS? Should I code conversion method by myself or I can do it with the help of Oracle?

Edited by: usamytch on 19.04.2010 13:43
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 20 2010
Added on Apr 19 2010
4 comments
2,013 views