I want to get information of buildings by the road side only. Assuming that the building table has multi-polygon geometry and the road table has multi-linestring geometry, what would be a pgSQL Query to achieve the goal?
Thanks a bunch.
Do you know at what distance the buildings are from the roads side?
You could use the st_dwithin function (selecting everthing within a certain distance):
This way you select the buildings within 200 m from the road. I am not sure how it works with multi-polygons and multi-linstrings.