Loading

ES|QL ST_INTERSECTION function

Returns the geometric intersection of two geometries.

Embedded
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 geometric intersection of two geometries. The result is a geometry representing the portion that both input geometries have in common. Returns an empty geometry if the inputs do not intersect. Both geometries must share the same coordinate reference system.

geomA geomB result
cartesian_point cartesian_point cartesian_shape
cartesian_point cartesian_shape cartesian_shape
cartesian_shape cartesian_point cartesian_shape
cartesian_shape cartesian_shape cartesian_shape
geo_point geo_point geo_shape
geo_point geo_shape geo_shape
geo_shape geo_point geo_shape
geo_shape geo_shape geo_shape
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 intersected = ST_INTERSECTION(a, b)
| KEEP intersected
		
intersected:geo_shape
POLYGON ((1.0 3.0, 3.0 3.0, 3.0 1.0, 1.0 1.0, 1.0 3.0))

Intersection of two overlapping polygons

The intersection is the shared area of both polygons.

Intersection of two overlapping polygons