Hi,
I am working on Oracle 11g.
I want to calculate center of a polygon. I have thousands of points(latitude,longitude) as input.
To calculate I have tried using Sdo_geom.SDO_CENTROID oracle spacial function. The output of the function gives a point within the polygon but I do not know how do I feed thousands of points as input to SDO_ORDINATE_ARRAY?
The points are available in another oracle table whose desc looks like
desc poly_points;
TABLE poly_points
Name Null? Type
----------------------------------------- -------- ----------------------------
LINE_NO NUMBER
pt_SEQ_NO NUMBER
LONGITUDE NUMBER
LATITUDE NUMBER
I need to calculate center for thousands of polygons.
Please let me know if it is possible to add each latitude/longitude serially one after the other or any any other solution ?
Thanks,
Imran.