Solved
Writing compound polygon to Oracle
Hello, is there any way how to write compound polygon (lines + arcs) to Oracle with FME? When i try to write this kind of geometry i always get "ORA-13347 Description:the coordinates defining an arc are not distinct". But arcs seems fine to me (no redundant points, distance between them is larger than oracle tolerance). FME 2013 (Build 13261 - WIN64) WIN 7 64bit Oracle 11gR2 Thanks for any advice, David
Best answer by kim
The problem is with the top 2 polygons, both of which contain a tiny arc. These 2 tiny arcs have a start and end point which is pretty much the same, and I'm not sure Oracle will be able to make a distinction between them. I'd try to get rid of them if I were you.
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.
Hi,
could you send such a feature to the Logger and post it here so we can take a look?
If the arcs aren't too important to you, consider using the ArcStroker to make your life easier.
David
Hi,
unfortunately it is important to retain arcs.
Log FFS is placed here: http://sdrv.ms/18yjYI6, thank you for help.
David
Hi,
I think Takashi might be on to something as I ran your FFS through the GeometryValidator and caught 2 self intersections, one of them on the polygon with two boundary arcs.
Let us know if it still doesn't work.
David
+5The problem is with the top 2 polygons, both of which contain a tiny arc. These 2 tiny arcs have a start and end point which is pretty much the same, and I'm not sure Oracle will be able to make a distinction between them. I'd try to get rid of them if I were you.
+5You could also try lowering the tolerance value in user_sdo_geom_metadata, but I'm pretty sure such tiny arcs have no meaning and could be left out/removed.
Sorry for late response, i was busy. I have solved this issue by removing small arcs from polygons (thanks Kim). But, I had to do it using AutoCAD Map 3D (mapclean command). Is there any solution to do this with FME?. I tried to use GeometryValidator, but without succes (small arcs are still there).
David