[ https://issues.apache.org/jira/browse/CALCITE-5262?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17599996#comment-17599996 ]
Bertil Chapuis edited comment on CALCITE-5262 at 9/3/22 9:28 PM: ----------------------------------------------------------------- [~julianhyde] I added support for WKB, EWKT, GEOJSON and GML in the following [draft PR|https://github.com/apache/calcite/pull/2893]. I also improved the documentation and implemented some of the unsupported functions. As some the functions are aliases to others, to which extent should we add tests for these in the spatial.iq file (e.g. ST_asText, ST_asWKT)? Also, in terms of organization, should we order the functions in alphabetical order, or group them by type (e.g. WKB, WKT, etc.). The [list of function|https://postgis.net/docs/PostGIS_Special_Functions_Index.html] in Postgis is rather long and I guess some conventions to keep things clear may help as more of them get implemented. was (Author: bchapuis): [~julianhyde] I added support for WKB, EWKT, GEOJSON and GeoJSON in the following [draft PR|https://github.com/apache/calcite/pull/2893]. I also improved the documentation and implemented some of the unsupported functions. As some the are aliases to others, to which extent should we add tests for these in the spatial.iq file (e.g. ST_asText, ST_asWKT)? Also, in terms of organization, should we order the functions in alphabetical order, or group them by type (e.g. WKB, WKT, etc.). The [list of function|https://postgis.net/docs/PostGIS_Special_Functions_Index.html] in Postgis is rather long and I guess we should set some conventions to keep things clear as more of them get implemented. > Add functions to support WKB (well-known binary) and GeoJSON > ------------------------------------------------------------ > > Key: CALCITE-5262 > URL: https://issues.apache.org/jira/browse/CALCITE-5262 > Project: Calcite > Issue Type: Bug > Components: spatial > Reporter: Julian Hyde > Assignee: Bertil Chapuis > Priority: Major > > Add functions to support WKB (well-known binary) and GeoJSON. This is made > possible by the switch to JTS in CALCITE-4294. The functions are: > * ST_AsEWKT > * ST_AsGeoJSON > * ST_AsWKB > * ST_GeomFromGeoJSON > * ST_GeomFromWKB -- This message was sent by Atlassian Jira (v8.20.10#820010)