ES|QL ST_INTERSECTION function
Returns the geometric intersection of two geometries.
geomA- Expression of type
geo_point,geo_shape,cartesian_pointorcartesian_shape. Ifnull, the function returnsnull. geomB-
Expression of type
geo_point,geo_shape,cartesian_pointorcartesian_shape. Must share the same coordinate reference system as the first parameter. Ifnull, the function returnsnull.
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.