polygons - array clockwise
813263Feb 14 2012 — edited Feb 14 2012Hi,
In Oracle spatial 10g, we are having few millions of circular arc polygons (simply polygon, no interior polygon) "sdo_geometry (2003, null, null, sdo_elem_info_array (1, 1003, *2*)," and are finding the whether the user gps locations falling in any of these polygons (POI in polygon) . We are storing the vertices array in counter clockwise direction.
Now, we are going to buy POIs (sdo_geometry (2003, null, null, sdo_elem_info_array (1, 1003, *1*)) just straight line connected polygons, no interior poygons.
The problem here is, the third party poi may have vertices in clockwise or counter clockwise directions.
Whether loading the third party's poi will impact my current table having circular poly in counter clockwise directions and calculating the Point in polygon?
Is there any best practice to be followed here.