Skip to main content
Geographic Information Systems

Return to Answer

deleted 4 characters in body
Source Link
Taras ♦
Taras ♦
  • 34k
  • 4
  • 73
  • 148

thisThis one also worked.:

if("diameter_valve" is NULL,
    aggregate(
        layer:= 'waterpipe_pipe'='waterpipe_pipe',
        aggregate:='concatenate',
        expression:=to_string("diameter"),
        concatenator:=', ',
        filter:= intersects=intersects($geometry, buffer( geometry(@parent), 0.0005))
 )       ),
    "diameter_valve"
    )

this one also worked.

if("diameter_valve" is NULL,aggregate(
 layer:= 'waterpipe_pipe',
 aggregate:='concatenate',
 expression:=to_string("diameter"),
 concatenator:=', ',
 filter:= intersects($geometry,buffer( geometry(@parent),0.0005)
 )),"diameter_valve")

This one also worked:

if("diameter_valve" is NULL,
    aggregate(
        layer:='waterpipe_pipe',
        aggregate:='concatenate',
        expression:=to_string("diameter"),
        concatenator:=', ',
        filter:=intersects($geometry, buffer(geometry(@parent), 0.0005))
        ),
    "diameter_valve"
    )
added 28 characters in body
Source Link
MrXsquared
MrXsquared
  • 35.6k
  • 22
  • 71
  • 121

this one also worked.

if("diameter_valve" is NULL,aggregate( layer:= 'waterpipe_pipe', aggregate:='concatenate', expression:=to_string("diameter"), concatenator:=', ', filter:= intersects($geometry,buffer( geometry(@parent),0.0005) )),"diameter_valve")

if("diameter_valve" is NULL,aggregate(
 layer:= 'waterpipe_pipe',
 aggregate:='concatenate',
 expression:=to_string("diameter"),
 concatenator:=', ',
 filter:= intersects($geometry,buffer( geometry(@parent),0.0005)
 )),"diameter_valve")

this one also worked.

if("diameter_valve" is NULL,aggregate( layer:= 'waterpipe_pipe', aggregate:='concatenate', expression:=to_string("diameter"), concatenator:=', ', filter:= intersects($geometry,buffer( geometry(@parent),0.0005) )),"diameter_valve")

this one also worked.

if("diameter_valve" is NULL,aggregate(
 layer:= 'waterpipe_pipe',
 aggregate:='concatenate',
 expression:=to_string("diameter"),
 concatenator:=', ',
 filter:= intersects($geometry,buffer( geometry(@parent),0.0005)
 )),"diameter_valve")
Source Link
Levon Batoyan
Levon Batoyan
  • 107
  • 6

this one also worked.

if("diameter_valve" is NULL,aggregate( layer:= 'waterpipe_pipe', aggregate:='concatenate', expression:=to_string("diameter"), concatenator:=', ', filter:= intersects($geometry,buffer( geometry(@parent),0.0005) )),"diameter_valve")