Computes a Geometry representing the point-set which is contained in both Geometry columns. The union of two geometries of different dimension produces a result geometry of dimension equal to the maximum dimension of the input geometries. The result geometry may be a heterogenous GeometryCollection. If the result is empty, it is an atomic geometry with the dimension of the highest input dimension.

 

 

Ports

Input Port

0   Table containing two geometry columns in GeoJSON format with other attributes. The geometry column name should be prefixed with “the_geom”.

Output Port

0   Table containing a single geometry column after computing row-wise union of geometries. The geometry column name is prefixed with “the_geom”.

Further Details


Type

Processing

Related functions

See related functions in JTS ST_Union.