I am attempting to establish what spatial relationship exists (if any) between two layers.
I have two layers - one is a road network with a buffer of 500m, and the other is a collection of polygons relating to environmental features.
The road network buffer layer comprises of multiple roads and I would like to know what envrironmental features intersect what roads. Or more specifically I would like a column in the environmental layer attribute table which describes what road it interacts with?
Apart from using the 'select by location' spatial tool and then manually populating an empty column in the environmental layer, is there another spatial tool or method that I haven't considered?
The data itself is being stored in PostGIS and used in QGIS, but it would be possible to use ArcGIS if necessary.
Thanks for your time.