[CALCITE-4186] Add ST_CoveredBy spatial function

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.33.0
• Component/s: spatial
• Labels: pull-request-available
• Assignee: Bertil Chapuis
• Reporter: Julian Hyde
• Created: 20/Aug/20 21:11
• Updated: 07/Feb/23 22:33
• Resolved: 05/Oct/22 21:45

Description

Add ST_Covers, ST_CoveredBy, ST_Relate spatial functions.

There are subtle differences between ST_Contains and ST_Covers; 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.

Issue Links

• is related to: CALCITE-5262 Add functions to support WKB (well-known binary) and GeoJSON
• relates to: CALCITE-1861 Spatial index, based on Hilbert space-filling curve
• links to: GitHub Pull Request #2927