Skip to main content
Solved

Rounding coordinates when reprojecting from and to Oracle Spatial Object tables

  • January 28, 2014
  • 1 reply
  • 19 views
esko
Forum|alt.badge.img+2
Hello,

 

I'm doing a straigth-forward conversion of Oracle SDO_GEOMETRY from srid 294914 (old national coord.base) to srid 3067 (new national coord.base) using just Oracle reader and writer.  Is there any way to reduce the number decimals in the output, at the moment converting from  

 

3385034.91; 6678837.36  (east; north)

 

produces  

 

384911.612948413; 6676033.80278682

 

 

Best solution would be to have some parameter in the writer to round or cut  to a desired number of decimals .  I assume that using some transformer (like CoordinateRounder) between reader and writer would substantially increase the execution time ?

 

 

Esko

 

 

Best answer by fmelizard

Hi,

 

 

The transformer will not necessarly increase the execution time, from my experience usually the reading & writting takes longer than mid-transformation.

 

 

An optional manner would be to use a database function to reduce the decimal accuracy.

 

 

Itay
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

fmelizard
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • Best Answer
  • January 28, 2014
Hi,

 

 

The transformer will not necessarly increase the execution time, from my experience usually the reading & writting takes longer than mid-transformation.

 

 

An optional manner would be to use a database function to reduce the decimal accuracy.

 

 

Itay

Most helpful members this week

Community Stats

30,846
Posts
116,937
Replies
38,670
Members
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.