[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:55 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 ST_Transform 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):
{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.

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