I have two layers:
1 polygon layer where the depth of an area is written in the database (as DRVAL1) and and where the depth is exported as a Z-value to the geometry.
1 point layer that I use to plan Aids-to-Navigation.
In the screenshot to test objects are placed in the point layer. I want to write the depth from the polygonlayer (that is displayed under the pointlayer) that is true for the position of the point, to the poinlayer.
I've tried to make a virtual field in the pointlayer with:
CASE
(WHEN intersects($geometry,geometry(get_features('layer_id',"DRVAL1",
'50')))) = true THEN '50'
END
I've repeated the WHEN->THEN for all the values in the polygonlager. but I get a reply with (can't convert to double) or (can't find DRVAL1)
what do I need to change or are there better ways to tackle this issue?