[
https://issues.apache.org/jira/browse/CALCITE-4186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jess Balint closed CALCITE-4186.
--------------------------------
Resolved in release 1.33.0 (2023-02-06)
> Add ST_CoveredBy spatial function
> ---------------------------------
>
> 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
> Labels: pull-request-available
> Fix For: 1.33.0
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)
