Attention: it's Oracle 11 Spatial!
Hi
I have the following situation:
- I have Geometries as closed linestrings (usually straight lines, but arcs are possible)
- no holes
- I have to “merge / union / aggregate / group” some of them to a new polygon-geometry like this
- New Poly A made by linestrings where name = John
- New Poly B made by linestrings where name = Jim
Sounds like a very trivial standard task, but I'm lost in all the union / aggregate / concat / hull …. functions. One is only for straight lines, the other is limited to another thing and so. I also tried to update the SDO_GTYPE and SDO_ELEM_INFO_ARRAY, but that's also a risky workaround and no solution.
So what's the right way for this task here? I think it will be rather simple, but at the moment I'm confused.
Thanks ins advance!