Skip to content

ST_Crosses

Returns true if A crosses B.

Usage

boolean ST_Crosses(geomA: geometry, geomB: geometry)

Arguments

  • geomA (geometry): Input geometry
  • geomB (geometry): Input geometry

Description

Returns true if the two geometries have some (but not all) interior points in common and the dimension of the intersection is less than that of either input.

Examples

SELECT ST_Crosses(
    ST_GeomFromWKT('LINESTRING(0 0, 2 2)'),
    ST_GeomFromWKT('LINESTRING(0 2, 2 0)')
);
┌──────────────────────────────────────────────────────────────────────────────┐
│ st_crosses(st_geomfromwkt(Utf8("LINESTRING(0 0, 2 2)")),st_geomfromwkt(Utf8( │
│                          "LINESTRING(0 2, 2 0)")))…                          │
╞══════════════════════════════════════════════════════════════════════════════╡
│ true                                                                         │
└──────────────────────────────────────────────────────────────────────────────┘