Would ST_ShortestLine help? https://postgis.net/docs/ST_ShortestLine.html
Gesendet: Donnerstag, 27. April 2017 um 11:24 Uhr Von: "Mickael MONSIEUR" <[email protected]> An: [email protected] Betreff: [postgis-users] Select closest line Hi, 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. Thanks, Mickael_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users[https://lists.osgeo.org/mailman/listinfo/postgis-users] _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
