Re: Oracle Spatial - How to identify if a line crosses itself

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Sun, 13 Oct 2013 11:25:59 -0600
Message-ID: <525AD7A7.4080905_at_gmail.com>

Missed that 'line' part. You are correct that lines may legitimately self-cross.
The usual way to handle this is to validate the geometry, use the error messages to find the crossing vertexes, and create sub-polygons.

An interesting related discussion in the forums at http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_objgeom.htm#sthref1912

/Hans

On 13/10/2013 10:18 AM, Eriovaldo Andrietta wrote:
> Hi Hans,
> Tks for you attention...
>
> Yes,I had validated the geometry.
> When the geometry is a line (2002), Oracle spatial does not consider
> as error.
>
> Regards
> Eriovaldo
>
>
>
> On Sun, Oct 13, 2013 at 10:55 AM, Hans Forbrich
> <fuzzy.graybeard_at_gmail.com <mailto:fuzzy.graybeard_at_gmail.com>> wrote:
>
> Have you validated the layer or the geometry and looked at the
> resulting
> error?
>
> http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_objgeom.htm#sthref1912
>
> On 13/10/2013 4:06 AM, Eriovaldo Andrietta wrote:
> > Hello,
> > Is there a way to identify if a line (gtype = 2002) crosses itself ?
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Oct 13 2013 - 19:25:59 CEST