[teiid-issues] [JBoss JIRA] (TEIID-3350) Add system functions for EWKT & KML

[Tom Arnold (JIRA)]

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

Tom Arnold commented on TEIID-3350:
-----------------------------------

Hmmm... I think unlike GML, the SRID for KML is assumed to be 4326 or something similar.

{quote}
KML geographic 2D coordinate reference system (adapted from EPSG-4326).
{quote}
https://portal.opengeospatial.org/files/?artifact_id=27810

The PostGIS docs show this working with 4326, and the function explicitly says that it will work only if geometry has SRID so I'm thinking they reproject if it isn't 4326. A little experimentation should be able to confirm if this is the case.
http://postgis.org/docs/ST_AsKML.html

In the short term we should probably just have an assertion in the code that SRID = 4326 when using ST_AsKML, and a note in the docs explaining why.

> Add system functions for EWKT & KML
> -----------------------------------
>
>                 Key: TEIID-3350
>                 URL: https://issues.jboss.org/browse/TEIID-3350
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Tom Arnold
>            Assignee: Steven Hawkins
>




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