You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Julian Hyde (Jira)" <ji...@apache.org> on 2020/08/20 21:12:00 UTC
[jira] [Created] (CALCITE-4186) Add ST_Covers, ST_CoveredBy,
ST_Relate spatial functions
Julian Hyde created CALCITE-4186:
------------------------------------
Summary: Add ST_Covers, ST_CoveredBy, ST_Relate spatial functions
Key: CALCITE-4186
URL: https://issues.apache.org/jira/browse/CALCITE-4186
Project: Calcite
Issue Type: Bug
Components: spatial
Reporter: Julian Hyde
Add {{ST_Covers}}, {{ST_CoveredBy}}, {{ST_Relate}} spatial functions.
There are [subtle differences between ST_Contains and ST_Covers|http://lin-ear-th-inking.blogspot.com/2007/06/subtleties-of-ogc-covers-spatial.html]; {{ST_Covers}} is usually what you want, and is easier to compute.
Extend the Hilbert spatial index (added in CALCITE-1861) to handle {{ST_Covers}}, {{ST_CoveredBy}}, {{ST_ContainsPropertly}} as it does {{ST_DWithin}} and {{ST_Contains}}.
It might make sense to also implement {{ST_ExteriorRing}} so that we can implement the [PostGIS example|https://postgis.net/docs/ST_Covers.html].
--
This message was sent by Atlassian Jira
(v8.3.4#803005)