ES|QL ST_DIFFERENCE function

Returns the part of geomA that does not intersect with geomB.

×

geomA

Expression of type geo_point, geo_shape, cartesian_point or cartesian_shape. If null, the function returns null.

geomB

Expression of type geo_point, geo_shape, cartesian_point or cartesian_shape. Must share the same coordinate reference system as the first parameter. If null, the function returns null.

Returns the part of geomA that does not intersect with geomB. This is equivalent to subtracting geomB from geomA. Both geometries must share the same coordinate reference system.

ROW a = TO_GEOSHAPE("POLYGON ((0 0, 3 0, 3 3, 0 3, 0 0))"),
    b = TO_GEOSHAPE("POLYGON ((1 1, 4 1, 4 4, 1 4, 1 1))")
| EVAL diff = ST_DIFFERENCE(a, b)
| KEEP diff
		

Difference of two overlapping polygons

The difference is the part of the first polygon that does not overlap with the second.

×