[teiid-issues] [JBoss JIRA] (TEIID-3305) Add system functions for GeoJSON

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3305:
---------------------------------------

> I don't believe these are part of the OGC spec, but it would probably be best to implement them similar to PostGIS.

Yes, the more format support the better.  The postgis function matrix is quite helpful for quickly seeing the standard functions http://postgis.net/docs/manual-2.0/PostGIS_Special_Functions_Index.html#PostGIS_TypeFunctionMatrix

Tom, I don't recall if you have a contributor agreement in place yet - https://cla.jboss.org/index.seam  If not can you click through for approval.

> Add system functions for GeoJSON
> --------------------------------
>
>                 Key: TEIID-3305
>                 URL: https://issues.jboss.org/browse/TEIID-3305
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Tom Arnold
>            Assignee: Steven Hawkins
>              Labels: spatial
>
> Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB).
> Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON.
> * https://github.com/bjornharrtell/jts2geojson
> * http://geojson.org/geojson-spec.html
> * http://wiki.geojson.org/GeoJSON_draft_version_5
> I don't believe these are part of the OGC spec, but it would probably be best to implement them similar to PostGIS.
> * http://postgis.org/docs/ST_AsGeoJSON.html
> * http://postgis.org/docs/ST_GeomFromGeoJSON.html



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