Oracle 18c; 10.7.1 Enterprise Geodatabase
What's the difference between ST_IsClosed vs. ST_IsRing in SDE.ST_Geometry?
For example, I want to query for lines that are near-circles like this:
(in other words, I want to select roundabouts)
I don't want to select lines that close in on themselves midway like this:
I tested ST_IsClosed and ST_IsRing. Both of the lines in the screenshots above were identified as closed and as rings. So it's not clear to me what the difference between the two functions is.
objectid in (
select
objectid
from
roads
where
sde.st_isClosed(sde.st_geometryn(shape,1)) = 1
) objectid in (
select
objectid
from
roads
where
sde.st_isRing(sde.st_geometryn(shape,1)) = 1
) Reason for wrapping the WHERE clause in a subquery:
