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?

closed as too broad by whyzar, mgri, Mapperz May 2 '17 at 15:46

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

Browse other questions tagged or ask your own question.