Hi ​@vertiroy,

As far as I know, I don't believe Oracle Spatial allows the preservation of arcs for a geographic coordinate system. Unfortunately, it seems like the only way is to reproject to a projected coordinate system. 

Perhaps you could also consider extracting/storing properties of the arc such as center point, radius, etc. of the arc as attributes when using a geographic coordinate system to not lose that geometry information. This can be done with the ArcPropertyExtractor transformer. With this method, you'll retain the geometry information to be able to rebuild the arc if needed, using the 2DArcReplacer transformer.

Hope this helps!

Hi ​@crystalwang,

Thanks for your reply. I finally stumbled on some documentation yesterday that stated exactly what you said. Unfortunately, I don’t think we can use a projected coordinate system for the project. Additionally, the arcs were read as a different kind of arc, and I read somewhere that Oracle Spatial only accepts circular arcs. We also tried various transformations with no luck.

The source of the issue actually lies with the application that relies on the spatial data. The densified arcs appear as ghastly representations in the mapping software, and we were hoping that true arcs would resolve their jagged appearance (some arcs don’t even come close to the original). We found that using ArcStroker and specifying the number of interpolations based on sweep angle and/or size may be the best solution.