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

[Tom Arnold (JIRA)]

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

Tom Arnold edited comment on TEIID-2384 at 1/22/15 12:54 AM:
-------------------------------------------------------------

{quote}
jts does not care if the srid matches when performing the various system functions. We may need to restrict to only matching srids to stay consistent with expected source behavior.
{quote}

Oracle and PostGIS will reproject (ST_Transform) in the case where the SRIDs do not match. For other sources I think we should error, with an eye towards implementing ST_Transform as a system function:
# Add ST_Transform as a CAN_PUSHDOWN with an implementation that just says "reprojection not currently supported". Add as supported function for Oracle & PostGIS.
# In mismatched-SRID situations, wrap geometry literal in ST_Transform to do conversion to target SRID. (Dependency on storing SRID in column metadata for this to work.)
# Change ST_Transform system function to actually do reprojection. I will spend some time in GeoTools trying to get a better understanding of how this works.


was (Author: tom9729):
> jts does not care if the srid matches when performing the various system functions. We may need to restrict to only matching srids to stay consistent with expected source behavior.

Oracle and PostGIS will reproject (ST_Transform) in the case where the SRIDs do not match (from docs). For other sources I think we should error, with an eye towards implementing ST_Transform as a system function:
# Add ST_Transform as a CAN_PUSHDOWN with an implementation that just says "reprojection not currently supported". Add as supported function for Oracle & PostGIS.
# In mismatched-SRID situations, wrap geometry literal in ST_Transform to do conversion to target SRID. (Dependency on storing SRID in column metadata for this to work.)
# Change ST_Transform system function to actually do reprojection. I will spend some time in GeoTools trying to get a better understanding of how this works.

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