Skip to main content
Geographic Information Systems

Return to Question

Tweeted twitter.com/StackGIS/status/1543157549188382720
edited question and tags
Source Link
Mapperz ♦
Mapperz ♦
  • 50.2k
  • 9
  • 75
  • 133

I need to import a huge number of polygons from a third party (as a csv file- array of x,ysy's). I have to check whether the polygon vertices are in clockwise or counter clockwise, finally i have to convert it into counter clockwise and store it in the oracle spatial table as sdo geometry.

I am not able to find any oracle spatial java apiAPI to check the array of vertices and convert it into counter clockwise. I tried the same question in oracle spatial forum, but they said no apiAPI for this.

do you have ever worked on this oracle spatial java apiAPI, any other thoughts. ( i have found some methods to validate the ring rotation "http://paulbourke.net/geometry/clockwise/index.html""http://paulbourke.net/geometry/clockwise/index.html", but if it is from oracle it will be good to implement).

I need to import a huge number of polygons from a third party (as a csv file- array of x,ys). I have to check whether the polygon vertices are in clockwise or counter clockwise, finally i have to convert it into counter clockwise and store it in the oracle spatial table as sdo geometry.

I am not able to find any oracle spatial java api to check the array of vertices and convert it into counter clockwise. I tried the same question in oracle spatial forum, but they said no api for this.

do you have ever worked on this oracle spatial java api, any other thoughts. ( i have found some methods to validate the ring rotation "http://paulbourke.net/geometry/clockwise/index.html", but if it is from oracle it will be good to implement).

I need to import a huge number of polygons from a third party (as a csv file- array of x,y's). I have to check whether the polygon vertices are in clockwise or counter clockwise, finally i have to convert it into counter clockwise and store it in the oracle spatial table as sdo geometry.

I am not able to find any oracle spatial java API to check the array of vertices and convert it into counter clockwise. I tried the same question in oracle spatial forum, but they said no API for this.

do you have ever worked on this oracle spatial java API, any other thoughts. ( i have found some methods to validate the ring rotation "http://paulbourke.net/geometry/clockwise/index.html", but if it is from oracle it will be good to implement).

Source Link
Vadivelan Palanichamy
Vadivelan Palanichamy
  • 43
  • 4

Oracle spatial - check polygon vertices counter clockwise

I need to import a huge number of polygons from a third party (as a csv file- array of x,ys). I have to check whether the polygon vertices are in clockwise or counter clockwise, finally i have to convert it into counter clockwise and store it in the oracle spatial table as sdo geometry.

I am not able to find any oracle spatial java api to check the array of vertices and convert it into counter clockwise. I tried the same question in oracle spatial forum, but they said no api for this.

do you have ever worked on this oracle spatial java api, any other thoughts. ( i have found some methods to validate the ring rotation "http://paulbourke.net/geometry/clockwise/index.html", but if it is from oracle it will be good to implement).