Friday, 3 November 2017

postgresql - How to find nearest line from point using PostGIS?



I have a table of Roads in PostGIS which geometry is "geometry(MultiLineString,4326)".


Its attribute are



gid osm_id name ref type oneway bridge maxspeed geom



Now i want to know the closest Road from latitude and longitude.


Also I want to set some distance from that Line/Road like 20m both side and if the point is within that distance then it should give the name of that line else not.




No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...