# Official Geospatial Support

**URL:** <https://community.dremio.com/t/official-geospatial-support/12447>\
**Category:** Uncategorized\
**Created:** [October 29, 2024, 12:03pm UTC](https://community.dremio.com/t/official-geospatial-support/12447 "2024-10-29T12:03:06Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Makdak26](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/makdak26/32/6685_2.png) [@Makdak26](https://community.dremio.com/u/Makdak26)\
**Post date:** [October 29, 2024, 12:03pm UTC](https://community.dremio.com/t/official-geospatial-support/12447/1 "2024-10-29T12:03:06Z")

</div>

Hey everyone! In the company that I am working on, we use a lot of geospatial data. As we were are currently in the process of implementing a data lakehouse, I saw that as of the version 25.1, Dremio only supports a limited number of geospatial commands.  
On the contrary, tools such as Presto and Trino currently support the full list of of commands from Apache Sedona.  
While we can work with Apache Sedona in our notebooks, it would make it easier if those commands could also be run directly in Dremio.  
Is it in the devs plans to also add official support for those commands in Dremio?

Thanks in advance for any answer!

P.S. I saw that in the community that there was an unofficial implementation for adding the full list of geospatial commands, but I see that its latest version supports up to Dremio 25.0, and following its instructions gave me a whole bunch of errors.

---

<div class="post-metadata">

**Author:** ![cclairmont](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/cclairmont/32/4730_2.png) [@cclairmont](https://community.dremio.com/u/cclairmont)\
**Post date:** [October 31, 2024, 5:22pm UTC](https://community.dremio.com/t/official-geospatial-support/12447/2 "2024-10-31T17:22:18Z")

</div>

Hi @Makdak26

Take a look of that project : [GitHub - sheinbergon/dremio-udf-gis: OGC/GIS functions and extensions for Dremio](https://github.com/sheinbergon/dremio-udf-gis)

Cheers

---

<div class="post-metadata">

**Author:** ![Makdak26](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/makdak26/32/6685_2.png) [@Makdak26](https://community.dremio.com/u/Makdak26)\
**Post date:** [November 1, 2024, 8:14am UTC](https://community.dremio.com/t/official-geospatial-support/12447/3 "2024-11-01T08:14:31Z")

</div>

Thank you for the reply! I’ve already seen it, however when I tried to work with it having Dremio version 25.1, it gave me errors and thus it did not work.  
According to github, it was last updated for version 25.0.5, so my guess is that its hardcoded for that version? I will look into it more, as we do not want to downgrade to an older version.

---

<div class="post-metadata">

**Author:** ![sheinbergon](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/sheinbergon/32/2408_2.png) [@sheinbergon](https://community.dremio.com/u/sheinbergon)\
**Post date:** [November 2, 2024, 9:09pm UTC](https://community.dremio.com/t/official-geospatial-support/12447/4 "2024-11-02T21:09:55Z")

</div>

@Makdak26 I’m the author of the spatial exetnsions library linked above. Please report your exact errors (text excerpts/screenshots) in the [Github Issues Page](https://github.com/sheinbergon/dremio-udf-gis/issues), as well as how you installed the extension. It should support the newer versions OTB for new versions as well, and it’s as simple as dropping a JAR inside the installation directory

---

<div class="post-metadata">

**Author:** ![sheinbergon](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/sheinbergon/32/2408_2.png) [@sheinbergon](https://community.dremio.com/u/sheinbergon)\
**Post date:** [November 2, 2024, 9:25pm UTC](https://community.dremio.com/t/official-geospatial-support/12447/5 "2024-11-02T21:25:19Z")

</div>

@Makdak26 I’ve just manually tested the latest version (`0.16.0`) with Dremio 25.1.1 and it’s working as expected. You probably installed it incorrectly. As requested earlier, please open a github issue and include your errors.

---

<div class="post-metadata">

**Author:** ![sheinbergon](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/sheinbergon/32/2408_2.png) [@sheinbergon](https://community.dremio.com/u/sheinbergon)\
**Post date:** [November 2, 2024, 10:18pm UTC](https://community.dremio.com/t/official-geospatial-support/12447/6 "2024-11-02T22:18:01Z")

</div>

@Makdak26 In any case, version `0.18.0` built against Dremio 25.1.1 is ready. You can get it from [here](https://github.com/sheinbergon/dremio-udf-gis/releases/tag/0.18.0)

---

<div class="post-metadata">

**Author:** ![Makdak26](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/makdak26/32/6685_2.png) [@Makdak26](https://community.dremio.com/u/Makdak26)\
**Post date:** [November 4, 2024, 6:33am UTC](https://community.dremio.com/t/official-geospatial-support/12447/7 "2024-11-04T06:33:11Z")

</div>

@sheinbergon Thank you for going through the trouble of testing it and also releasing a newer version ! I’m sure I must have done something wrong from my side at that time. I will try it again and will let you know of the results.

---

<div class="post-metadata">

**Author:** ![Makdak26](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/makdak26/32/6685_2.png) [@Makdak26](https://community.dremio.com/u/Makdak26)\
**Post date:** [November 4, 2024, 10:55am UTC](https://community.dremio.com/t/official-geospatial-support/12447/8 "2024-11-04T10:55:23Z")

</div>

I managed to find a solution for the errors that I was getting. Indeed the issues were from how I was using the jar files.  
I fixed the errors, by creating a custom docker file to build the dremio image and copy the jar to the jars/3rdparty directory

```auto
FROM dremio/dremio-oss:25.2
COPY "dremio-udf-gis-0.18.0.jar" /opt/dremio/jars/3rdparty/

```

and based on that created my service for dremio, on the docker-compose file

```auto
geodremio:
    image: gis-dremio:latest
    container_name: geodremio
    build: ./dremio/
    depends_on:
      - geonessie
    networks:
      iceberg_net:
    ports:
      - 7008:9047
      - 7009:31010
      - 7010:32010
    volumes:
      - ./dremio/data:/opt/dremio/data

```
