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