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 sdo_elem_info_array
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 sdo_elem_info_array
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?