Name

Intersects — Returns true if any pair of primitives from the two topogeometries intersect.

Synopsis

boolean Intersects(topogeometry tg1, topogeometry tg2);

Description

Returns true if any pair of primitives from the two topogeometries intersect.

[Note]

This function not supported for topogeometries that are geometry collections. It also can not compare topogeometries from different topologies. Also not currently supported for hierarchical topogeometries (topogeometries composed of other topogeometries).

Availability: 1.1.0

This function supports 3d and will not drop the z-index.

Examples

The following example uses the nei_topo table created in the toTopoGeom examples.

SELECT topology.Intersects(a.topo, b.topo)
FROM nei_topo AS a
JOIN nei_topo AS b ON b.gid = a.gid
WHERE a.gid = 1;
t

See Also

ST_Intersects