Computes a Geometry representing the point-set which is common to both in two geometries column. The intersection of two geometries of different dimension produces a result geometry of dimension less than or equal to the minimum 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 lowest input dimension. Intersection of GeometryCollections is supported only for homogeneous collection types.

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 intersection of geometries. The geometry column name is prefixed with “the_geom.

Further Details


Type

Processing

Related functions

See related functions in JTS ST_Intersection.