Skip to main content
  • EN
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

 

 

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

Reply


Community Stats

30,108
Posts
114,280
Replies
37,742
Members
Terms & ConditionsCookie 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.