Help required for executing geospetial query
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-13-2025 11:08 AM
we have requirement to find a specific distance based on longitude and latitude. Can you please help me with the details step how we can achieve this using pyspark?
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-13-2025 02:06 PM
Hi @dholea ,
Databricks Runtime 17.1 Beta added native support for Spatial SQL. So for example it let's you calculate distance between coordinates.
I think you can try with ST_Distance() function.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-14-2025 05:41 AM
Hi,
Thank you very much. Our data bricks version is 15.4.x-scala2.12.
Can you please guide me how to upgrade 17.1, if there is any other way to execute geospatial query, please let me know.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-14-2025 06:03 AM - edited 08-14-2025 06:06 AM
Hi @dholea ,
To update your runtime version:
1) Go to Compute (1) and click on your cluster name (2)
Hi @dholea ,
To update your runtime version:
1) Go to Compute (1) and click on your cluster name (2)
2) Now, click Edit button
3) Now you can choose required Databricks runtime
Another possibility is to use H3 or Mosaic. You can read about it at below article:
GIS in Databricks — Advancing Analytics
High Scale Geospatial Processing Mosaic | Databricks Blog
2) Now, click Edit button
3) Now you can choose required Databricks runtime