Skip to main content
Solved

setting up the sdo_geometry

  • January 4, 2013
  • 1 reply
  • 19 views

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
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

1 reply

davideagle
Contributor
Forum|alt.badge.img+21
  • Contributor
  • Best Answer
  • January 4, 2013
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.

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings