Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert linestring (2002, 2006) to polygon (2003, 2007)?

Peter2_1Nov 13 2024

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!

Comments
Post Details
Added on Nov 13 2024
9 comments
399 views