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

[ https://issues.jboss.org/browse/TEIID-2384?page=com.atlassian.jira.plugin... ] 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): 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. -- This message was sent by Atlassian JIRA (v6.3.11#6341)