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?