[teiid-issues] [JBoss JIRA] (TEIID-3302) Implement ST_Transform

[Tom Arnold (JIRA)]

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

Tom Arnold commented on TEIID-3302:
-----------------------------------

After emailing with the maintainer I think proj4j is the way to go. Hopefully I'll have some time later this week to take a shot at this.

Proj4j is not in Maven central. It seems like there's a couple of options:
* Upload it to central. Is this something the "official" upstream has to do, or can anyone do it?
* Submit JIRA to proxy into JBoss repos.

Any advice?

> Implement ST_Transform
> ----------------------
>
>                 Key: TEIID-3302
>                 URL: https://issues.jboss.org/browse/TEIID-3302
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Tom Arnold
>            Assignee: Steven Hawkins
>              Labels: spatial
>
> Implement [ST_Transform|http://postgis.org/docs/ST_Transform.html] system function. This would be used to transform geometry between different coordinate systems. This needs SPATIAL_REF_SYS table and a supporting library.
> There are a couple of options for implementing this:
> * http://trac.osgeo.org/proj4j/ - Port of the C library used by PostGIS. Fewest dependencies and should keep us close to PostGIS in capabilities. There will be a little boilerplate to interface with JTS.
> * http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module. I think we would need to develop a simple plugin to interface with our SPATIAL_REF_SYS table. GeoTools is active and has good docs, but brings in a lot of dependencies.



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