I want to know how I can fill in a column of a layer based on a certain relation criteria to another layer. In my case I want the column
"straat" in my
"bomen" shapefile filled in with the value's of "Staatnaam" in the shapefile
"straat". However, the value that will be filled in is linked to a certain criteria relation. In this case, since
"Bomen" is a point shapefile, each point forms a circle of 36 meters in radius (so 36 meters in every direction). The name for the closest street that intersects/crosses the "circle", needs to be added into the
"Bomen" shapefile in the
How do I do this? If you guys can still not understand this what I am asking, here is an illustration. The
Straat shapefiles are the PostGIS layers, but this part is not important.