Solved
setting up the sdo_geometry
i have a string with coordinate pairs forming a polygon. the missing parameters are created using sql. I was wondering if there is an easier method setting up a default polygon in the desired geographical area. just the sdo_ordinates vary for each inserted line in the table.
Best answer by davideagle
You could read the text file or location of the strings defining each polygon and then build either the SQL to insert the polygons to the database or perhaps more usefully reformat the polygon stings themselves into something like Well Known Text (WKT) and then form the geometry with the GeometryReplacer and finally write to the database. Theres probably a few options if you can supply a little more detail.
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.
+22- Contributor
- Best Answer
You could read the text file or location of the strings defining each polygon and then build either the SQL to insert the polygons to the database or perhaps more usefully reformat the polygon stings themselves into something like Well Known Text (WKT) and then form the geometry with the GeometryReplacer and finally write to the database. Theres probably a few options if you can supply a little more detail.