Re: [postgis-users] PostGIS verse those in Azure Cloud

2023-08-30 Thread Shaozhong SHI
I am trying to review the underlying geospatial capability of these systems as the geospatial capability maturity have been developed unevenly. I am interested in the following: As compared with PostGIS spatial operations, what are the advantages and disadvantages of various systems in Azure

Re: [postgis-users] Stuck with upgrade from postgresql 9.6 to postgresql 14 due to postgis2.3

2023-08-30 Thread atanga MARCELIUS via postgis-users
Hello Sandro, Thanks for your support.  Please here are the out put to the queries you suggested. I have also attached the output in text document in a clearer format. My main concern here is how to  manage the upgrade path from postgis 2.3 in postgresql 9.6  to  a compactible version of

Re: [postgis-users] Stuck with upgrade from postgresql 9.6 to postgresql 14 due to postgis2.3

2023-08-30 Thread atanga MARCELIUS via postgis-users
Hello Sandro, Thanks for your support.  Please here are the out put to the queries you suggested. I have also attached the output in text document in a clearer format. My main concern here is how to  manage the upgrade path from postgis 2.3 in postgresql 9.6  to  a compactible version of

Re: [postgis-users] PostGIS verse those in Azure Cloud

2023-08-30 Thread Regina Obe
Are you right about what? I still think you need to focus on what exactly you are trying to compare and for who. You are trying to compare apples and oranges is all I see. I don’t think you will find any single review about Azure cloud geospatial offerings, cause it’s a huge

Re: [postgis-users] PostGIS verse those in Azure Cloud

2023-08-30 Thread Shaozhong SHI
Is there an outline of the underlying technology each system of Azure Cloud offers? Perhaps, we can compare that way? Regards, David On Wed, 30 Aug 2023 at 14:17, Regina Obe wrote: > Are you right about what? > > > > I still think you need to focus on what exactly you are trying to compare >

Re: [postgis-users] Stuck with upgrade from postgresql 9.6 to postgresql 14 due to postgis2.3

2023-08-30 Thread Regina Obe
Marcelius, So you installed PostGIS from scripts right? I think your best bet is to upgrade your PostgreSQL 9.6 using scripts 1) Get a PostGIS 3.0 or higher for PostgreSQL 9.6 (it can be from a yum repo or compiled yourself). Preferable a PostGIS 3.1 (I think 3.1 is the last version

Re: [postgis-users] PostGIS verse those in Azure Cloud

2023-08-30 Thread Imre Samu
> As compared with PostGIS spatial operations, what are the advantages and disadvantages > of various systems in Azure Cloud in terms of supporting further development. see: https://learn.microsoft.com/en-us/azure/orbital/geospatial-reference-architecture The Azure Cloud has many features

Re: [postgis-users] PostGIS verse those in Azure Cloud

2023-08-30 Thread Regina Obe
Imre, Wow that’s a great summary covers Azure whole Geospatial space  David, I think Imre has provided you with a good starting point to ask your questions and to Greg’s point, many of these questions you’ll want to ask on Azure social systems. We just happened to be a much nicer

[postgis-users] Complex Overlays

2023-08-30 Thread Eloi Ribeiro
Hi all, Did anyone successfully executed the following procedure http://blog.cleverelephant.ca/2019/07/postgis-overlays.html with complex geometries (polygons with holes)? Below the SQL code I am using (read failing). I still get duplicated (overlapped) polygons and some others are just

Re: [postgis-users] PostGIS verse those in Azure Cloud

2023-08-30 Thread Greg Troxel
Shaozhong SHI writes: > Is there an outline of the underlying technology each system of Azure Cloud > offers? This is the postgis list. That question should be directed to an Azure Cloud forum. ___ postgis-users mailing list