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

[Tom Arnold (JIRA)]

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

Tom Arnold commented on TEIID-3305:
-----------------------------------

Haven't written ticket for this yet but I believe another low-hanging format is KML. Need to double-check but I believe it's basically just GML2 without the GML namespace (which can be configured in the JTS writer).

Some additional areas to consider:
* PostGIS has option to configure precision for floating point.
* Current implementation of these functions does not support specifying the CRS. GMLWriter has support for this but the GeoJSON module would need a minor enhancement. Also it looks like the latest GeoJSON is phasing out support for this and is just telling people to use WGS84 or reproject on server. Finally, I think we need SPATIAL_REF_SYS before we can tackle this because SRID is really only useful as PK into that table; CRS needs authority name and possibly other info.

> 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)