ST_Overlaps¶

Returns true if A overlaps B.

Usage¶

boolean ST_Overlaps(geomA: geometry, geomB: geometry)

Arguments¶

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

Description¶

Returns true if the two geometries share space and have the same dimension, but are not completely contained by each other.

Examples¶

SELECT ST_Overlaps(
    ST_GeomFromWKT('POLYGON((2.5 2.5, 2.5 4.5, 4.5 4.5, 4.5 2.5, 2.5 2.5))'),
    ST_GeomFromWKT('POLYGON((4 4, 4 6, 6 6, 6 4, 4 4))')
);

┌──────────────────────────────────────────────────────────────────────────────┐
│ st_overlaps(st_geomfromwkt(Utf8("POLYGON((2.5 2.5, 2.5 4.5, 4.5 4.5, 4.5 2.5 │
│  , 2.5 2.5))")),st_geomfromwkt(Utf8("POLYGON((4 4, 4 6, 6 6, 6 4, 4 4))")))… │
╞══════════════════════════════════════════════════════════════════════════════╡
│ true                                                                         │
└──────────────────────────────────────────────────────────────────────────────┘