Hi Bertil, This is awesome. However, although Flink depends on Calcite, the SpatialType does not seem to be supported by Flink (based on my test last year). Not sure if this works for Drill. Please correct me if I'm wrong.
On a side note, why don't we implement all geometric computation logics in Sedona and Calcite simply wraps around Sedona-common (of course JTS too)? Sedona implements many more functions in addition to JTS: https://github.com/apache/sedona/tree/master/common/src/main/java/org/apache/sedona/common This way, we don't reinvent the wheel. Moreover, Sedona is a spatial-as-the-first-class-citizen project. We can receive way more contributions and make a huge impact. Thanks, Jia On Thu, Feb 1, 2024 at 10:25 PM Bertil Chapuis <bchap...@gmail.com> wrote: > > Hello Jia and Charles, > > I'm really interested in this topic as well. Apache Calcite transitionned > from ESRI Geometry to JTS, and many ST functions have been implemented there > as well [1, 2, 3]. Sharing experiences and code could benefit all projects. > > I haven’t looked into the details of each project, but from what I > understand, Sedona depends on Calcite through Flink, and Drill depends > directly on Calcite. Is that correct? Since these functions are available in > Calcite’s core, it means they may already be available in the respective > class paths. > > Best regards, > > Bertil > > [1] > https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/runtime/SpatialTypeFunctions.java > [2] > https://github.com/apache/calcite/blob/main/core/src/test/resources/sql/spatial.iq > [3] > https://calcite.apache.org/docs/reference.html#geometry-conversion-functions-2d > > > > On 2 Feb 2024, at 06:47, Jia Yu <ji...@apache.org> wrote: > > > > Hi Charles, > > > > This is Jia Yu from Apache Sedona. I think what you did is fantastic. > > As a project of this Joint codespring, I am proposing to implement a > > comprehensive set of spatial functions to Apache Drill using Apache > > Sedona. > > > > Apache Sedona has implemented over 130 ST functions and a > > high-performance geometry serializer in pure Java. All these functions > > have been ported to Apache Spark, Apache Flink and Snowflake. They are > > being downloaded over 1.5 million times per month. > > > > This porting process is fairly simple. Let's take Sedona on Apache > > Flink as an example: > > > > 1. Call a Sedona java function in a UDF template: > > https://github.com/apache/sedona/blob/master/flink/src/main/java/org/apache/sedona/flink/expressions/Functions.java > > 2. Register this function in a catalog file: > > https://github.com/apache/sedona/blob/master/flink/src/main/java/org/apache/sedona/flink/Catalog.java > > > > What do you think? > > > > Thanks, > > Jia > > > > On Thu, Feb 1, 2024 at 2:44 PM Charles Givre <cgi...@gmail.com> wrote: > >> > >> Hi Martin, > >> Thanks for sending. I'd love for Drill to be included in this. I have a > >> question for you. A while ago, I started work on a collection of UDFs for > >> interacting with H3 Geo Indexes. I'm not an expert on this but would this > >> be useful? Here's the repo: https://github.com/datadistillr/drill-h3-udf > >> If someone would like to collaborate to complete this and get it > >> integrated, I'm all for that. > >> Best, > >> -- C > >> > >> > >> > >>> On Jan 31, 2024, at 10:20, Martin Desruisseaux > >>> <martin.desruisse...@geomatys.com> wrote: > >>> > >>> Hello all > >>> > >>> The Open Geospatial Consortium (OGC), The Apache Software Foundation > >>> (ASF) and The Open Source Geospatial Foundation (OSGeo) hold a join code > >>> sprint on February 26 to 28 [1]. The main goals are to support the > >>> development of open standards for geospatial information and to support > >>> the development of free and open source software which implements those > >>> standards, as well as creating awareness about the standards and software > >>> projects. This is the fourth year that this joint code sprint is > >>> organized, and this year will be physically located in Évora (Portugal). > >>> The event can also be attended on-line. Registration is free [2]. > >>> > >>> Apache SIS, Sedona, Baremaps, Parquet, Drill and Camel projects > >>> participated in the past. It would be great if participation was possible > >>> this year too. Some ideas could be: > >>> > >>> * Experiment the use of Apache SIS in Sedona for referencing and grid > >>> coverage services (could be a join effort between Sedona and SIS > >>> developers). > >>> * Any work related to Geoparquet [3] (an incubating OGC standard based > >>> on Apache Parquet). > >>> * Any work related to Drill GIS functions [4]. > >>> * Any work related to Camel Geocoder [5]. For example, exploring the > >>> pertinence of using the ISO 19112 standard (could be a join effort > >>> between Camel and GeoAPI developers). > >>> > >>> If anyone is interested, the wiki page [1] can be edited directly. If > >>> particular you can add your project in the "Which Apache projects are > >>> going to participate?" section. If an introduction to a project can be > >>> presented as a tutorial, it can also be added in the "Mentor streams" > >>> section of [1]. > >>> > >>> Martin > >>> > >>> [1]https://github.com/opengeospatial/developer-events/wiki/2024-Joint-OGC-%E2%80%93-OSGeo-%E2%80%93-ASF-Code-Sprint > >>> [2]https://developer.ogc.org/sprints/23/ > >>> [3]https://geoparquet.org/ > >>> [4]https://drill.apache.org/docs/gis-functions/ > >>> [5]https://camel.apache.org/components/4.0.x/geocoder-component.html > >> > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: dev-unsubscr...@baremaps.apache.org > > For additional commands, e-mail: dev-h...@baremaps.apache.org > > >
