Julian Hyde created CALCITE-1968:
------------------------------------
Summary: Support OpenGIS Simple Feature Access SQL
Key: CALCITE-1968
URL: https://issues.apache.org/jira/browse/CALCITE-1968
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
Assignee: Julian Hyde
Support [OpenGIS Simple Feature Access
SQL|http://www.opengeospatial.org/standards/sfs]. 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|http://www.h2gis.org/docs/dev/functions/] 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|https://github.com/Esri/geometry-api-java]. 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.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
