How to get the distance between a point and a line with specific values

by santamariense   Last Updated October 10, 2019 16:22 PM

I have a table named "housenumbers" that contains points with addresses fields, and one of them is "street_name". And I also have another table named "streets", that contains lines that are the geometries of roads, and a field that contains its "name".

I need to get the distance from each point to the nearest street that has the same street name.

Any suggestion?


Tags : postgis

Related Questions

Updated February 20, 2017 03:22 AM

Updated October 04, 2018 22:22 PM

Updated October 05, 2018 22:22 PM

Updated December 11, 2018 13:22 PM

Updated February 01, 2019 21:22 PM