[
https://issues.apache.org/jira/browse/CALCITE-1968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16141961#comment-16141961
]
Julian Hyde commented on CALCITE-1968:
--------------------------------------
Work in progress: https://github.com/julianhyde/calcite/tree/1861-spatial
> 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)
