Nome

Intersects — Retorna verdade se algum par de primitivos das duas topologias se intersectar.

Sinopse

boolean Intersects(topogeometry tg1, topogeometry tg2);

Description

Retorna verdade se algum par de primitivos das duas topologias se intersectar.

[Nota]

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).

Disponibilidade: 1.1.0

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

Exemplos

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

Code
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;
Raster Outputs
t

Veja também

ST_Intersects