Rounding coordinates when reprojecting from and to Oracle Spatial Object tables

Question

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

Page 1 / 1

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

fmelizard · Accepted Answer

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

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded