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.
View original<strong>This post is closed to further activity.</strong><br />
It may be a question with a best answer, an implemented idea, or just a post needing no comment.<br />
If you have a follow-up or related question, please <a href="https://community.safe.com/topic/new">post a new question or idea</a>.<br />
If there is a genuine update to be made, please contact us and request that the post is reopened.
+21- 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.
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.