ST_3DIntersects-PolarDB(PolarDB)-阿里云帮助中心

Determines whether 3D models and 3D geometries intersect.

Syntax

bool ST_3DIntersects(meshgeom geom1, meshgeom geom2);
bool ST_3DIntersects(meshgeom geom1,  box3d box);
bool ST_3DIntersects(sfmesh sfmeshObject1, sfmesh sfmeshObject2);

Parameters

Parameter name	Description
geom	Meshgeom object
box	Specifies the box3d object.
sfmeshObject	sfmesh object

Description

This function checks whether two sfmesh objects intersect.
This function checks whether the sfmesh object intersects with the box3d object.
This function checks whether two meshgeom objects intersect.
If this function fails, NULL is returned.

Examples

select ST_3DIntersects(
    'MESHGEOM(PATCH(TRIANGLESTRIP Z(0 0 0,0 10 0,0 0 10,0 10 10), POINT Z(0 0 0)))'::meshgeom,
    'MESHGEOM(PATCH(LINESTRING(-1 0 0, -1 -0.5 0)))'::meshgeom);

-----------------
 f