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.
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
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):
SELECT buildings.identificatie, .buildings.geom FROM buildings, road WHERE St_DWithin(buildings.geom, road.geom, 200)
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.