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 >
signature.asc
Description: Message signed with OpenPGP
