Best answer by davideagle
View original
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.
+14
- Contributor
- 577 replies
-
4 January 2013
- 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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.