[postgis-users] Select closest line

Felix Kunde felix-kunde at gmx.de
Thu Apr 27 06:28:44 PDT 2017

Would ST_ShortestLine help?


Gesendet: Donnerstag, 27. April 2017 um 11:24 Uhr
Von: "Mickael MONSIEUR" <mickael.monsieur at gmail.com>
An: postgis-users at lists.osgeo.org
Betreff: [postgis-users] Select closest line


I imported a kml file with ogr2ogr and I have a well-filled database, including a "waypoints" table and hexadecimal coordinates in the "wkb_geometry" column.

I would like with a GPS coordinate, select the closest lines.

I found this function: https://postgis.net/docs/ST_ClosestPoint.html but I can not put it into practice.

In my result, I would like to have the GPS positions of the nearest line, as well as the distance in kilometers between the line and my GPS coordinates.

Someone would have an idea how to do it?

I admit to not being comfortable with the spacial search and the different types of coordinates (mercator, google, degrees, gps ..) I get lost completely.
Mickael_______________________________________________ postgis-users mailing list postgis-users at lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users[https://lists.osgeo.org/mailman/listinfo/postgis-users]

More information about the postgis-users mailing list