How to calculate nearest line from point using PostGIS? [closed]

Ask Question

Asked 6 years, 4 months ago

Modified 6 years, 4 months ago

Viewed 465 times

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Update the question so it focuses on one problem only by editing this post.

Closed 6 years ago.

I have point data, which store the "pharmacy_name" field

I also have street data (as linestring), which store the "street_name" field.

I want to know which pharmacy is located on which street. How can I calculate this with a SQL query in PostGIS?

Vince

19.7k14 gold badges41 silver badges64 bronze badges

asked Jan 13, 2017 at 10:35

Elvin Asgerov

111 bronze badge

Welcome to GIS SE. As a new user please take the Tour. We ask that all coding questions include code (in this case, your SQL so far). Unfortunately, the information you seek is not obvious from the data source, especially when you consider that pharmacies tend to be on corners.
– Vince
Jan 13, 2017 at 12:32
This question may be useful for you. gis.stackexchange.com/questions/42003/…
– Alexey Sidash
Jan 16, 2017 at 11:30
Possible duplicate of algorithm to get the nearest line segment (link) to a point
– raphael
May 2, 2017 at 15:05

Add a comment |

0