Name

GetFaceByPoint — Finds face intersecting a given point.

Synopsis

bigint GetFaceByPoint(varchar atopology, geometry apoint, float8 tol1);

설명

Finds a face referenced by a Point, with given tolerance.

The function will effectively look for a face intersecting a circle having the point as center and the tolerance as radius.

If no face intersects the given query location, 0 is returned (universal face).

If more than one face intersect the query location an exception is thrown.

2.0.0 버전부터 사용할 수 있습니다.

Enhanced: 3.2.0 more efficient implementation and clearer contract, stops working with invalid topologies.

예시

SELECT topology.GetFaceByPoint('ma_topo', geom, 10) As with1mtol, topology.GetFaceByPoint('ma_topo', geom, 0) As withnotol
FROM ST_GeomFromEWKT('POINT(234604.6 899382.0)') As geom;
with1mtol | withnotol
-----------+-----------
         1 |         0

This query errors because two or more faces are found.

SELECT topology.GetFaceByPoint('ma_topo', geom, 1) As nearnode
FROM ST_GeomFromEWKT('POINT(227591.9 893900.4)') As geom;
ERROR:  Two or more faces found