[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=13034245#comment-13034245 ] 

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

> oracle and others seem to use null rather than 0 for an unknown srid. So we may want to use an Integer field on the GeometryType and update the FROM Text/Binary methods appropriately.

Checked with postgis and they mark the functions as strict/null on null, so we'll keep the current behavior.  It is a minor TODO to make the pushdown for mysql/oracle match this.

Added st_geomfromwkb as the dominant function as it matches the spec with an alias to st_geomfrombinary (why they have the inconsistency isn't clear).

> add get/set srid functions

This has also been added.  The set srid function will create a new geometry type value and reuse the existing blob reference.

> 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)