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
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.