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
