Introduction: Return the intersection geometry of A and B
Format: ST_Intersection (A: Geometry, B: Geometry)
Return type: Geometry
Since: v1.5.0
!!!note If you encounter a TopologyException with the message “found non-noded intersection”, try enabling the OverlayNG algorithm by adding the following JVM flag:
``` -Djts.overlay=ng ``` The OverlayNG algorithm is more robust than the legacy overlay implementation in JTS and handles many edge cases that would otherwise cause errors.
Example:
SELECT ST_Intersection( ST_GeomFromWKT("POLYGON((1 1, 8 1, 8 8, 1 8, 1 1))"), ST_GeomFromWKT("POLYGON((2 2, 9 2, 9 9, 2 9, 2 2))") )
Output:
POLYGON ((2 8, 8 8, 8 2, 2 2, 2 8))