[teiid-issues] [JBoss JIRA] (TEIID-2384) Managing Spatial Data Types

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13030687#comment-13030687 ] 

Steven Hawkins commented on TEIID-2384:
---------------------------------------

Added the initial support based upon the work started by Tom Arnold.  The approach uses a new geometrytype that is effectively a blob.  Then all manipulation is handled through functions (the conversion logic was removed as it's more explicit to use named functions):

ST_ASTEXT
ST_ASBINARY
ST_GEOMFROMTEXT
ST_GEOMFROMBINARY
ST_INTERSECTS
ST_CONTAINS

All of which have implementations in Teiid.  Sources are expected to at least support ST_ASBINARY and ST_GEOMFROMBINARY to support conversion into and out of the well known binary format.

Only limited oracle and mysql support was addressed with this commit.  We should add as many function methods as supported jts and commonly used by sources.  The translators primarily oracle, postgresql, and mysql similarly need updated to add function aliases and functions into the supported list.

We should also look at what could be done to reconcile this approach with the older oracle geospatial support.

> Managing Spatial Data Types
> ---------------------------
>
>                 Key: TEIID-2384
>                 URL: https://issues.jboss.org/browse/TEIID-2384
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 8.2
>            Reporter: luca gioppo
>            Assignee: Steven Hawkins
>              Labels: spatial, types
>             Fix For: 8.10
>
>
> It would be useful to be able to consume data from spatial database exposing the VDB as a spatial database to other application (imagine geoserver).
> TEIID could be strategic for merging georeferenced data and make it available to those systems.



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)