ST_Union

ST_Union takes two or more geometry columns and returns a geometry column. The output column contains the geometries that represent the spatial union of the geometries in each row of the input columns. The geometry types of the input columns must be the same. To find the union of all geometries in a group or column use ST_Aggr_Union.

Function	Syntax
Python	`union(*geometries)`
SQL	`ST_Union(*geometries)`

For more details, go to the GeoAnalytics Engine API reference for union.

This function implements the OpenGIS Simple Features Implementation Specification for SQL 1.2.1.

Examples

Python

SQL

Use dark colors for code blocksCopy
from geoanalytics.sql import functions as ST, Point, Polygon

df = spark.createDataFrame([(Point(8,8), Polygon([[[0,0],[10,0],[10,10],[0,10]]]),)], ["point", "polygon"])

df.select(ST.union(ST.buffer("point", 5), "polygon")).st.plot()

Plotting example for ST_Union — Plotted result for ST_Union.

Version table

Release	Notes
1.0.0	Function introduced

SQL functions
Data sources
Coordinate systems and transformations

ST_Union

Examples

Version table

Related topics