ES|QL ST_UNION function
Returns the geometric union 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 union of two geometries. The result is a geometry that covers all points covered by either input geometry. 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, 2 0, 2 2, 0 2, 0 0))"),
b = TO_GEOSHAPE("POLYGON ((2 0, 4 0, 4 2, 2 2, 2 0))")
| EVAL unioned = ST_UNION(a, b)
| KEEP unioned
| unioned:geo_shape |
|---|
| POLYGON ((2.0 0.0, 0.0 0.0, 0.0 2.0, 2.0 2.0, 4.0 2.0, 4.0 0.0, 2.0 0.0)) |
Union of two overlapping polygons
The union of two overlapping squares covers the area of both.