# Spatial Queries **URL:** \ **Category:** Uncategorized\ **Created:** [July 23, 2017, 12:19pm UTC](https://community.dremio.com/t/spatial-queries/105 "2017-07-23T12:19:52Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![pmnathan](https://avatars.discourse-cdn.com/v4/letter/p/b5ac83/32.png) [@pmnathan](https://community.dremio.com/u/pmnathan)\ **Post date:** [July 23, 2017, 12:19pm UTC](https://community.dremio.com/t/spatial-queries/105/1 "2017-07-23T12:19:52Z")
HI, Does Dremio support spatial queries, especially when dealing with heterogeneous data sources? if not are there any plans to support this. Thank you, Prakash ---
**Author:** ![ron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ron/32/12_2.png) [@ron](https://community.dremio.com/u/ron)\ **Post date:** [July 24, 2017, 4:26pm UTC](https://community.dremio.com/t/spatial-queries/105/2 "2017-07-24T16:26:07Z")
Prakash, We do not support spatial queries across heterogeneous data sources. It is something on our roadmap, but not yet scheduled. We’d love to hear about the data sets (and sources) that you’re looking to query together, operators you’d like to see (within radius? within a lat/long box?) for our future planning. thanks Ron ---
**Author:** ![pmnathan](https://avatars.discourse-cdn.com/v4/letter/p/b5ac83/32.png) [@pmnathan](https://community.dremio.com/u/pmnathan)\ **Post date:** [July 24, 2017, 4:36pm UTC](https://community.dremio.com/t/spatial-queries/105/3 "2017-07-24T16:36:06Z")
Hi Ron, Thanks for the reply. We make extensive use of PostGIs in Postgres (and sometimes spacial data in Oracle). We store data like lines, polygons, multi-polygons etc. The data we deal with is mostly Airport locations (points), Runway shapes(polygon), Airspace polygons, Flight Tracks(linestring) etc. So analytic queries will be how many flights crossed a certain airspace from 6am to 10am etc. We make extensive use of the different postgis functions … [https://postgis.net/docs/](https://postgis.net/docs/). Also sometimes we write our own functions…which is another question I have…does dremio let one create user defined functions? Please let me know if you need any additional information. Thank you, Prakash ---
**Author:** ![ron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ron/32/12_2.png) [@ron](https://community.dremio.com/u/ron)\ **Post date:** [July 24, 2017, 4:42pm UTC](https://community.dremio.com/t/spatial-queries/105/4 "2017-07-24T16:42:39Z")
Thank you, Parakash. We do not have explicit UDF support. We do have a function framework internally that provides foundation for UDF support in a future release. Ron ---
**Author:** ![pmnathan](https://avatars.discourse-cdn.com/v4/letter/p/b5ac83/32.png) [@pmnathan](https://community.dremio.com/u/pmnathan)\ **Post date:** [July 24, 2017, 5:00pm UTC](https://community.dremio.com/t/spatial-queries/105/5 "2017-07-24T17:00:09Z")
![](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/1X/bc8cf2143e33d8ad3765128b5f99d3c77c45a99f.png) Hi Ron, Thanks for the update on UDF. Quick clarification. you said We do not support spatial queries across heterogeneous data sources When I run a spatial query form a single db table I get an error (see attached picture)…just wanted to confirm that it is the expected behavior. Thank you, Prakash ---
**Author:** ![ron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ron/32/12_2.png) [@ron](https://community.dremio.com/u/ron)\ **Post date:** [July 24, 2017, 11:41pm UTC](https://community.dremio.com/t/spatial-queries/105/6 "2017-07-24T23:41:32Z")
You’re correct, this is expected behavior. A number of geo-specific functions haven’t yet been implemented. ---
**Author:** ![adilyoltay](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@adilyoltay](https://community.dremio.com/u/adilyoltay)\ **Post date:** [July 7, 2019, 4:47am UTC](https://community.dremio.com/t/spatial-queries/105/7 "2019-07-07T04:47:08Z")
Ron any update about supporting geoquery or geospatial function on dremio?.. ---
**Author:** ![Hashtagin](https://avatars.discourse-cdn.com/v4/letter/h/bcef8e/32.png) [@Hashtagin](https://community.dremio.com/u/Hashtagin)\ **Post date:** [April 30, 2020, 1:08pm UTC](https://community.dremio.com/t/spatial-queries/105/8 "2020-04-30T13:08:22Z")
Hi Ron, The same for us, spatial queries support, specially from postgis should be great. We use multiline, polygon, line ,point, multipoint, with many st\_function in the geological context. Is there any scheduled on spatial queries support now ? Thank you ---
**Author:** ![eellsworth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/eellsworth/32/2643_2.png) [@eellsworth](https://community.dremio.com/u/eellsworth)\ **Post date:** [June 23, 2020, 7:25pm UTC](https://community.dremio.com/t/spatial-queries/105/9 "2020-06-23T19:25:06Z")
Agreed - we would also like to see spatial functions in Dremio.