[postgis-users] geospatial functions on Databricks appear to lag behind PostGIS?

Regina Obe lr at pcorp.us
Thu Nov 10 09:16:34 PST 2022


I haven’t explored Azure much so I have no clue which libraries are available and if their capabilities lag or not.

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Shaozhong SHI
Sent: Sunday, November 6, 2022 2:00 PM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] geospatial functions on Databricks appear to lag behind PostGIS?

 

Hi, Regina,

 

There are a number of geospatial libraries available in Azure.  In terms of 3D capability, are they all lagging behind PostGIS?

 

Regards,

 

David

 

On Tue, 11 Oct 2022 at 04:37, Regina Obe <lr at pcorp.us <mailto:lr at pcorp.us> > wrote:

At a glance it sounds about right.

Much of the 3D PostGIS functionality is built in or implemented in SFCGAL.

 

It looks like Spark utilizes JTS (of which GEOS is a fork of, which is what PostGIS uses for almost all the 2D processing).

So I would expect the functionality to be limited to what you see in JTS/GEOS.  Both JTS and GEOS are picking up steam in the 3D arena, so I expect this story to change in the next year or so.

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org <mailto:postgis-users-bounces at lists.osgeo.org> ] On Behalf Of Shaozhong SHI
Sent: Monday, October 10, 2022 7:44 AM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> >
Subject: [postgis-users] geospatial functions on Databricks appear to lag behind PostGIS?

 

It appears that geospatial functions on databricks lag behind PostGIS.

 

It appears that there is no 3d geometric operations such as ST_3DIntersects.

 

11.6. SparkSQL Functions — GeoMesa 3.4.0 Manuals <https://www.geomesa.org/documentation/stable/user/spark/sparksql_functions.html> 

 

Is that right?

 

Regards,

 

David

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> 
https://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20221110/ada23847/attachment.htm>


More information about the postgis-users mailing list