Predicate

ST_Contains

Introduction: Return true if A fully contains B

Format: ST_Contains (A:geometry, B:geometry)

Since: v1.2.0

SQL example:

SELECT * 
FROM pointdf 
WHERE ST_Contains(ST_PolygonFromEnvelope(1.0,100.0,1000.0,1100.0), pointdf.arealandmark)

ST_Intersects

Introduction: Return true if A intersects B

Format: ST_Intersects (A:geometry, B:geometry)

Since: v1.2.0

SQL example:

SELECT * 
FROM pointdf 
WHERE ST_Intersects(ST_PolygonFromEnvelope(1.0,100.0,1000.0,1100.0), pointdf.arealandmark)

---

Last update: March 6, 2022 09:51:33