[CALCITE-1968] Support OpenGIS Simple Feature Access SQL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.14.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 25/Aug/17 17:41
• Updated: 02/Nov/17 17:22
• Resolved: 30/Aug/17 01:40

Description

Support OpenGIS Simple Feature Access SQL. This is standard core functionality for spatial/geographical/geometry data, implemented by PostGIS and others.

It basically consists of a GEOMETRY data type and about 150 functions whose names start with 'ST_', for example ST_GeomFromText and ST_Distance. H2 GIS has a good reference. (Look for the functions labeled 'OpenGIS 1.2.1'.)

Adds a SqlConformance.allowGeometry() method to allow people to enable/disable this functionality.

First commit will probably add a dozen or so functions, backed by a library such as ESRI Geometry API. I'd appreciate help implementing the rest.

Spatial indexes are covered by CALCITE-1861 and are out of scope of this case. So with this feature, spatial queries will work, but predicates will be applied row-by-row.

Issue Links

• is depended upon by: CALCITE-2031 Implement more OpenGIS functions
• relates to: CALCITE-1861 Spatial index, based on Hilbert space-filling curve