I'm reading Oracle's documentation and i can't see the difference between
Point cluster and
MultiPoint element type.
The following example code is from the documentation
INSERT INTO t1 (i, d, g) VALUES ( 16, 'Point cluster', sdo_geometry (2005, null, null, sdo_elem_info_array (1,1,3), sdo_ordinate_array (50,5, 55,7, 60,5)) ); INSERT INTO t1 (i, d, g) VALUES ( 17, 'Multipoint', sdo_geometry (2005, null, null, sdo_elem_info_array (1,1,1, 3,1,1, 5,1,1), sdo_ordinate_array (65,5, 70,7, 75,5)) );
It seems that:
Point cluster is one element (of many points -in that example 3 points: 50,5, 55,7, 60,5) as it needs one triplet in
MultiPoint is many elements ( and each element is a
Point -in that example 3 points: 65,5, 70,7, 75,5) as it needs three triplets in
And further down documentation refers to them as the same thing(?):
2.5.8 Several Geometry Types Example 2-13 creates a table and inserts various geometries, including multipoints (point clusters), multipolygons, and collections...
What is this mess? What's the difference? The
sdo_geometry requires different
sdo_elem_info_array parameters so there must be a difference between those types?