[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:all-tabpanel ]

Tom Arnold updated TEIID-3302:
------------------------------
    Description: 
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, but the project looks dead for about a year. Also there would be a little boilerplate to interface with JTS types.
* 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.

  was:
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.
* http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module.



> 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, but the project looks dead for about a year. Also there would be a little boilerplate to interface with JTS types.
> * 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)