H2GIS

Fork me on GitHub

ST_Covers

Signature

BOOLEAN ST_Covers(GEOMETRY geomA, GEOMETRY geomB);

Description

Returns true if no point in geomB is outside geomA.

This predicate does not yet support spatial indices, but it will in a future release. Use it in conjunction with && operator. See here for more details.

Examples

smallc POLYGON bigc POLYGON
POLYGON((1 1, 5 1, 5 4, 1 4, 1 1)) POLYGON((0 0, 10 0, 10 5, 0 5, 0 0)) 

SELECT ST_Covers(smallc, smallc) FROM input_table;
-- Answer:    TRUE

SELECT ST_Covers(smallc, bigc) FROM input_table;
-- Answer:    FALSE

SELECT ST_Covers(bigc, smallc) FROM input_table;
-- Answer:    TRUE

SELECT ST_Covers(bigc, ST_ExteriorRing(bigc)) FROM input_table;
-- Answer:    TRUE

SELECT ST_Contains(bigc, ST_ExteriorRing(bigc)) FROM input_table;
-- Answer:    FALSE
See also