[jira] [Comment Edited] (CALCITE-4186) Add ST_Covers, ST_CoveredBy, ST_Relate spatial functions

["Bertil Chapuis (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-4186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17612420#comment-17612420 ] 

Bertil Chapuis edited comment on CALCITE-4186 at 10/3/22 7:50 PM:
------------------------------------------------------------------

The following [PR|https://github.com/apache/calcite/pull/2927] adds the ST_CoveredBy function.


was (Author: bchapuis):
The following PR adds the ST_CoveredBy function.

> 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
>            Assignee: Bertil Chapuis
>            Priority: Major
>
> 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.20.10#820010)