Vertex closer to other - Postgis

Question

Vertex closer to other - Postgis

Navigation

#1 by (0 votes)

0

Is it possible to return the vertex closer to another? Being that one of the observed geometries is a linestring. As in the figure below:

I want to return the single vertex of the linestring (which is represented by the black dots) that is closest to the red dot (which does not belong to the linestring but is on it). Is there any function in postgis for this?

sql

asked by anonymous 18.11.2015 / 15:09

1 answer

List information from a database I can not display the modification date of a directory with powershell

score 0 · Accepted Answer

You can use the ST_ClosestPoint ()

SELECT 
    ST_AsText(ST_ClosestPoint(linha_qualquer, ponto_escolhido)) AS vertice_mais_proximo
FROM (
    SELECT
            l.geom AS linha_qualquer,
            p.geom AS ponto_escolhido
    FROM 
            linhas l, pontos p
    WHERE 
            p.gid = 1
) AS foo;