When writing 3-point arcs to Oracle Spatial with a projected coordinate system, FME 2020 (64-bit) can maintain their geometries as arcs. When writing arcs to Oracle Spatial with a geographic coordinate system, however, FME strokes the arcs into lines. Is it possible to write the arcs to a geographic coordinate system without converting them to lines?
Solved
Writing arcs to Oracle Spatial
+7- Contributor
Best answer by crystalwang
Hi
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!
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, 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.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, 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.
+14- Safer
- Best Answer
Hi
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!
+7- Contributor
Hi
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.