How to calculate nearest line from point using PostGIS?

Asked Jan 13 '17 at 10:35

Active Jan 13 '17 at 12:33

Viewed 467 times

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?

edited Jan 13 '17 at 12:33

Vince

asked Jan 13 '17 at 10:35

Elvin Asgerov

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 '17 at 12:32
This question may be useful for you. http://gis.stackexchange.com/questions/42003/how-to-find-nearest-line-from-point-using-postgis – Alexey Sidash Jan 16 '17 at 11:30
Possible duplicate of algorithm to get the nearest line segment (link) to a point – raphael May 02 '17 at 15:05

0 Answers0