geometric functions in databricks

[koantek_user]

Hi All,

We are working on a migration project from snowflake to databricks and there are some scripts that utilize
geometric functions like st_makepoint, st_geohash from snowflake scripts which we need to convert to databricks

Has some encountered this in their projects?

[szymon_dybczak]

Hi @koantek_user ,

Look at below example notebook: 

https://www.databricks.com/notebooks/geomesa-h3-notebook.html

And more info on processing geospatial data in databricks you can find below: 

https://www.advancinganalytics.co.uk/blog/2023/1/3/gis-in-databricks

https://docs.databricks.com/en/sql/language-manual/sql-ref-h3-geospatial-functions.html

https://www.databricks.com/blog/2019/12/05/processing-geospatial-data-at-scale-with-databricks.html

[Retired_mod]

Hi @koantek_user, Thanks for reaching out! Please review the response and let us know if it answers your question. Your feedback is valuable to us and the community.

If the response resolves your issue, kindly mark it as the accepted solution. This will help close the thread and assist others with similar queries.

We appreciate your participation and are here if you need further assistance!