[
https://issues.apache.org/jira/browse/CALCITE-1968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16146078#comment-16146078
]
Julian Hyde commented on CALCITE-1968:
--------------------------------------
ESRI have released 2.0, so I have committed. Fixed in
http://git-wip-us.apache.org/repos/asf/calcite/commit/cc20ca13.
I have implemented 35 of the 150 functions, so we can't say we implement
OpenGIS Simple Feature Access SQL yet.
We'd love to get contributions for the other functions. Many a straightforward
to implement, because the ESRI library provides the necessary support. I
suggest that you implement one at a time:
# Choose a function
# Look up the function in the PostGIS documentation, and use the test case on
that page.
# Paste the test case(s) into spatial.iq.
# Add a public static method to GeoFunctions.java.
# Run QuidemTest via junit (or QuidemTest.main with argument sql/spatial.iq).
# Modify GeoFunctions.java or spatial.iq until it passes.
# When you have implemented a few functions, submit a PR.
> 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)
