https://community.databricks.com/t5/data-engineering/help-required-for-executing-geospetial-query/m-p/128392#M48224 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/179378">@dholea</a>&nbsp;,</P><P>Databricks Runtime 17.1 Beta added native support for Spatial SQL. So for example it let's you calculate distance between coordinates.<BR />I think you can try with&nbsp;<STRONG>ST_Distance()&nbsp;</STRONG>function.</P> Wed, 13 Aug 2025 21:06:49 GMT szymon_dybczak 2025-08-13T21:06:49Z https://community.databricks.com/t5/data-engineering/help-required-for-executing-geospetial-query/m-p/128363#M48222 <P>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?</P><P>&nbsp;</P><P>Thank you.</P> Wed, 13 Aug 2025 18:08:46 GMT https://community.databricks.com/t5/data-engineering/help-required-for-executing-geospetial-query/m-p/128363#M48222 dholea 2025-08-13T18:08:46Z https://community.databricks.com/t5/data-engineering/help-required-for-executing-geospetial-query/m-p/128392#M48224 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/179378">@dholea</a>&nbsp;,</P><P>Databricks Runtime 17.1 Beta added native support for Spatial SQL. So for example it let's you calculate distance between coordinates.<BR />I think you can try with&nbsp;<STRONG>ST_Distance()&nbsp;</STRONG>function.</P> Wed, 13 Aug 2025 21:06:49 GMT https://community.databricks.com/t5/data-engineering/help-required-for-executing-geospetial-query/m-p/128392#M48224 szymon_dybczak 2025-08-13T21:06:49Z https://community.databricks.com/t5/data-engineering/help-required-for-executing-geospetial-query/m-p/128453#M48247 <P>Hi,</P><P>Thank you very much. Our data bricks version is&nbsp;<SPAN>15.4.x-scala2.12.</SPAN></P><P><SPAN>Can you please guide me how to upgrade 17.1, if there is any other way to execute geospatial query, please let me know.</SPAN></P><P>&nbsp;</P> Thu, 14 Aug 2025 12:41:50 GMT https://community.databricks.com/t5/data-engineering/help-required-for-executing-geospetial-query/m-p/128453#M48247 dholea 2025-08-14T12:41:50Z https://community.databricks.com/t5/data-engineering/help-required-for-executing-geospetial-query/m-p/128463#M48248 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/179378">@dholea</a>&nbsp;,</P><P>To update your runtime version:</P><P>1) Go to Compute (1) and click on your cluster name&nbsp; (2)<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="szymon_dybczak_0-1755176498524.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/19095i1CCC333400EAFA6E/image-size/medium?v=v2&amp;px=400" role="button" title="szymon_dybczak_0-1755176498524.png" alt="szymon_dybczak_0-1755176498524.png" /></span></P><P>&nbsp;</P><P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/179378">@dholea</a>&nbsp;,</P><P>To update your runtime version:</P><P>1) Go to Compute (1) and click on your cluster name&nbsp; (2)<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="szymon_dybczak_0-1755176498524.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/19095i1CCC333400EAFA6E/image-size/medium?v=v2&amp;px=400" role="button" title="szymon_dybczak_0-1755176498524.png" alt="szymon_dybczak_0-1755176498524.png" /></span></P><P>&nbsp;</P><P>2)&nbsp; Now, click Edit button<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="szymon_dybczak_1-1755176531590.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/19096i2F5E131704EAC7DF/image-size/medium?v=v2&amp;px=400" role="button" title="szymon_dybczak_1-1755176531590.png" alt="szymon_dybczak_1-1755176531590.png" /></span></P><P>3) Now you can choose required Databricks runtime<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="szymon_dybczak_2-1755176581008.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/19097i231A228DABEF225D/image-size/medium?v=v2&amp;px=400" role="button" title="szymon_dybczak_2-1755176581008.png" alt="szymon_dybczak_2-1755176581008.png" /></span></P><P><BR />Another possibility is to use H3 or Mosaic. You can read about it at below article:</P><P><BR /><A href="https://www.advancinganalytics.co.uk/blog/2023/1/3/gis-in-databricks#mosaic" target="_blank">GIS in Databricks — Advancing Analytics</A><BR /><BR /></P><P><A href="https://www.databricks.com/blog/2022/05/02/high-scale-geospatial-processing-with-mosaic.html" target="_blank">High Scale Geospatial Processing Mosaic | Databricks Blog</A></P><P>2)&nbsp; Now, click Edit button<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="szymon_dybczak_1-1755176531590.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/19096i2F5E131704EAC7DF/image-size/medium?v=v2&amp;px=400" role="button" title="szymon_dybczak_1-1755176531590.png" alt="szymon_dybczak_1-1755176531590.png" /></span></P><P>3) Now you can choose required Databricks runtime<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="szymon_dybczak_2-1755176581008.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/19097i231A228DABEF225D/image-size/medium?v=v2&amp;px=400" role="button" title="szymon_dybczak_2-1755176581008.png" alt="szymon_dybczak_2-1755176581008.png" /></span></P><P>&nbsp;</P><P><BR /><BR /><BR /></P> Thu, 14 Aug 2025 13:06:21 GMT https://community.databricks.com/t5/data-engineering/help-required-for-executing-geospetial-query/m-p/128463#M48248 szymon_dybczak 2025-08-14T13:06:21Z