Oracle Spatial - How to identify if a line crosses itself

From: Eriovaldo Andrietta <>
Date: Sun, 13 Oct 2013 07:06:41 -0300
Message-ID: <>

Is there a way to identify if a line (gtype = 2002) crosses itself ?

I know that when the geometry is a polygon (gtype=2003) Oracle spatial generates the error: ORA-13349.

But it does not occurs when it is a line (2002), so I tought to generate a polygon, getting the first point of the line and to consider it as the last in order to generate a polygon...

It is not a good way.
Somebody has Any experience checking it ?


Received on Sun Oct 13 2013 - 12:06:41 CEST

Original text of this message