Forum Stats

  • 3,853,715 Users
  • 2,264,258 Discussions
  • 7,905,435 Comments

Discussions

SDO_AGGR_UNION of polygons result a geometry with a line segment inside?

Hi,

I am struggling with a problem, I cannot find the reason.
I have 3 polygons in Oracle Spatial 11g (Enterprise Edition Release 11.1.0.7.0 - 64bit Production):
All three are simple polygons: SDO_GEOMETRY(2003, null, null, (1,1003,1), (... coord array...) )
They are valid as the result of an SDO_MIGRATE.TO_CURRENT and a VALIDATE_GEOMETRY_WITH_CONTEXT

SELECT SDO_AGGR_UNION(SDOAGGRTYPE(GEOM, 5E-1)) FROM ....
result a collection geometry with elem_info_array (1,2,1, 5,1003,1)

I cannot understand, how can this happen. Unioning the three separate polygons should result a simple polygon (if they were touching/overlapping) or a multipolygon with 2 or 3 rings.
But the unionig how can result a line segment of two points??
I have double-checked the polygons and the tolerance values also.

Have you any idea?
Thanks is advance

Regards,
Tamas
Tagged:
This discussion has been closed.