Name

ST_3DDFullyWithin — 如果两个3D几何完全在给定的3D距离内,则返回True

Synopsis

boolean ST_3DDFullyWithin(geometry g1, geometry g2, double precision distance);

描述

如果3D几何图形完全在彼此的指定距离内,则返回True。距离以几何图形的空间参考系定义的单位指定。要使此函数有意义,源几何图形必须具有相同的坐标投影,并且具有相同的SRID。

[Note]

This function automatically includes a bounding box comparison that makes use of any spatial indexes that are available on the geometries.

可用性:2.0.0

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

This function supports Polyhedral surfaces.

示例

-- This compares the difference between fully within and distance within as well
    -- as the distance fully within for the 2D footprint of the line/point vs. the 3d fully within
    SELECT ST_3DDFullyWithin(geom_a, geom_b, 10) as D3DFullyWithin10, ST_3DDWithin(geom_a, geom_b, 10) as D3DWithin10,
  ST_DFullyWithin(geom_a, geom_b, 20) as D2DFullyWithin20,
  ST_3DDFullyWithin(geom_a, geom_b, 20) as D3DFullyWithin20 from
    (select ST_GeomFromEWKT('POINT(1 1 2)') as geom_a,
    ST_GeomFromEWKT('LINESTRING(1 5 2, 2 7 20, 1 9 100, 14 12 3)') as geom_b) t1;
 d3dfullywithin10 | d3dwithin10 | d2dfullywithin20 | d3dfullywithin20
------------------+-------------+------------------+------------------
 f                | t           | t                | f 

另请参阅

ST_3DDWithin, ST_DWithin, ST_DFullyWithin, ST_3DMaxDistance