Re: [postgis-users] PostGIS verse those in Azure Cloud
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 group of people than all of those Thanks, Regina From: postgis-users On Behalf Of Imre Samu Sent: Wednesday, August 30, 2023 10:02 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] PostGIS verse those in Azure Cloud > 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 related to GeoSpatial. One small part of this is "Azure Database for PostgreSQL (+ PostGIS)." However, migrating to Azure Cloud can mean different things. If someone specifically means MS SQL Server, then it's not ideal for PostGIS. :-( Regards, Imre Shaozhong SHI mailto:shishaozh...@gmail.com> > ezt írta (időpont: 2023. aug. 30., Sze, 14:31): 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 Cloud in terms of supporting further development. In my mind and from my experience, PostGIS has a lot of useful underlying functions that support development of other applications. My initial glance of what other systems offer in the Azure, the potential for this is not great. I would like to find information on this and confirm or reject this understanding. Secondary programming/development relies on what the underlying functionality of a system provides. Add-on development is based on the underlying technology offered. From my experience, PostGIS offers a versatile range of functions and capability. This is important to any other add-on development for forming robust and useful geospatial applications. Am I right? Regards, David On Wed, 30 Aug 2023 at 01:31, David Haynes mailto:hayne...@gmail.com> > wrote: Suprio Ray and Ahmed Eldway are two researchers that do a lot of spatial computation work on big data (Hadoop, Spark, and parallel computation frameworks). In my opinion, PostGIS is a more robust tool for spatial operations. However other tools and platforms can be very good for specific spatial operations. On Tue, Aug 29, 2023, 12:40 PM Shaozhong SHI mailto:shishaozh...@gmail.com> > wrote: Geospatial capability has varied maturity in different systems, particular of interest is those in Azure Cloud as compared to PostGIS. Is there any publication on this topic? Regards, David ___ postgis-users mailing list postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org> https://lists.osgeo.org/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org> https://lists.osgeo.org/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org> https://lists.osgeo.org/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS verse those in Azure Cloud
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 postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS verse those in Azure Cloud
> 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 related to GeoSpatial. One small part of this is* "Azure Database for PostgreSQL* (+ PostGIS)." However, migrating to Azure Cloud can mean different things. If someone specifically means MS SQL Server, then it's not ideal for PostGIS. :-( Regards, Imre Shaozhong SHI ezt írta (időpont: 2023. aug. 30., Sze, 14:31): > 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 Cloud in terms of supporting > further development. > > In my mind and from my experience, PostGIS has a lot of useful underlying > functions that support development of other applications. > > My initial glance of what other systems offer in the Azure, the potential > for this is not great. > > I would like to find information on this and confirm or reject this > understanding. > > Secondary programming/development relies on what the underlying > functionality of a system provides. Add-on development is based on the > underlying technology offered. From my experience, PostGIS offers a > versatile range of functions and capability. This is important to any > other add-on development for forming robust and useful geospatial > applications. > > Am I right? > > Regards, > > David > > On Wed, 30 Aug 2023 at 01:31, David Haynes wrote: > >> Suprio Ray and Ahmed Eldway are two researchers that do a lot of spatial >> computation work on big data (Hadoop, Spark, and parallel computation >> frameworks). In my opinion, PostGIS is a more robust tool for spatial >> operations. However other tools and platforms can be very good for specific >> spatial operations. >> >> On Tue, Aug 29, 2023, 12:40 PM Shaozhong SHI >> wrote: >> >>> Geospatial capability has varied maturity in different systems, >>> particular of interest is those in Azure Cloud as compared to PostGIS. >>> >>> Is there any publication on this topic? >>> >>> Regards, >>> >>> David >>> ___ >>> postgis-users mailing list >>> postgis-users@lists.osgeo.org >>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>> >> ___ >> postgis-users mailing list >> postgis-users@lists.osgeo.org >> https://lists.osgeo.org/mailman/listinfo/postgis-users >> > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS verse those in Azure Cloud
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 > 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 landscape. > > > > You need to pinpoint more what problem you are trying to solve and who is > tasked to solve them. > > You need to define exactly what set of Azure geospatial technologies you > are talking about. > > > > > > > > *From:* postgis-users *On Behalf > Of *Shaozhong SHI > *Sent:* Wednesday, August 30, 2023 8:31 AM > *To:* PostGIS Users Discussion > *Subject:* Re: [postgis-users] PostGIS verse those in Azure Cloud > > > > 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 Cloud in terms of supporting > further development. > > > > In my mind and from my experience, PostGIS has a lot of useful underlying > functions that support development of other applications. > > > > My initial glance of what other systems offer in the Azure, the potential > for this is not great. > > > > I would like to find information on this and confirm or reject this > understanding. > > > > Secondary programming/development relies on what the underlying > functionality of a system provides. Add-on development is based on the > underlying technology offered. From my experience, PostGIS offers a > versatile range of functions and capability. This is important to any > other add-on development for forming robust and useful geospatial > applications. > > > > Am I right? > > > > Regards, > > > > David > > > > On Wed, 30 Aug 2023 at 01:31, David Haynes wrote: > > Suprio Ray and Ahmed Eldway are two researchers that do a lot of spatial > computation work on big data (Hadoop, Spark, and parallel computation > frameworks). In my opinion, PostGIS is a more robust tool for spatial > operations. However other tools and platforms can be very good for specific > spatial operations. > > > > On Tue, Aug 29, 2023, 12:40 PM Shaozhong SHI > wrote: > > Geospatial capability has varied maturity in different systems, particular > of interest is those in Azure Cloud as compared to PostGIS. > > > > Is there any publication on this topic? > > > > Regards, > > > > David > > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS verse those in Azure Cloud
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 landscape. You need to pinpoint more what problem you are trying to solve and who is tasked to solve them. You need to define exactly what set of Azure geospatial technologies you are talking about. From: postgis-users On Behalf Of Shaozhong SHI Sent: Wednesday, August 30, 2023 8:31 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] PostGIS verse those in Azure Cloud 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 Cloud in terms of supporting further development. In my mind and from my experience, PostGIS has a lot of useful underlying functions that support development of other applications. My initial glance of what other systems offer in the Azure, the potential for this is not great. I would like to find information on this and confirm or reject this understanding. Secondary programming/development relies on what the underlying functionality of a system provides. Add-on development is based on the underlying technology offered. From my experience, PostGIS offers a versatile range of functions and capability. This is important to any other add-on development for forming robust and useful geospatial applications. Am I right? Regards, David On Wed, 30 Aug 2023 at 01:31, David Haynes mailto:hayne...@gmail.com> > wrote: Suprio Ray and Ahmed Eldway are two researchers that do a lot of spatial computation work on big data (Hadoop, Spark, and parallel computation frameworks). In my opinion, PostGIS is a more robust tool for spatial operations. However other tools and platforms can be very good for specific spatial operations. On Tue, Aug 29, 2023, 12:40 PM Shaozhong SHI mailto:shishaozh...@gmail.com> > wrote: Geospatial capability has varied maturity in different systems, particular of interest is those in Azure Cloud as compared to PostGIS. Is there any publication on this topic? Regards, David ___ postgis-users mailing list postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org> https://lists.osgeo.org/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org> https://lists.osgeo.org/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS verse those in Azure Cloud
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 Cloud in terms of supporting further development. In my mind and from my experience, PostGIS has a lot of useful underlying functions that support development of other applications. My initial glance of what other systems offer in the Azure, the potential for this is not great. I would like to find information on this and confirm or reject this understanding. Secondary programming/development relies on what the underlying functionality of a system provides. Add-on development is based on the underlying technology offered. From my experience, PostGIS offers a versatile range of functions and capability. This is important to any other add-on development for forming robust and useful geospatial applications. Am I right? Regards, David On Wed, 30 Aug 2023 at 01:31, David Haynes wrote: > Suprio Ray and Ahmed Eldway are two researchers that do a lot of spatial > computation work on big data (Hadoop, Spark, and parallel computation > frameworks). In my opinion, PostGIS is a more robust tool for spatial > operations. However other tools and platforms can be very good for specific > spatial operations. > > On Tue, Aug 29, 2023, 12:40 PM Shaozhong SHI > wrote: > >> Geospatial capability has varied maturity in different systems, >> particular of interest is those in Azure Cloud as compared to PostGIS. >> >> Is there any publication on this topic? >> >> Regards, >> >> David >> ___ >> postgis-users mailing list >> postgis-users@lists.osgeo.org >> https://lists.osgeo.org/mailman/listinfo/postgis-users >> > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS verse those in Azure Cloud
Suprio Ray and Ahmed Eldway are two researchers that do a lot of spatial computation work on big data (Hadoop, Spark, and parallel computation frameworks). In my opinion, PostGIS is a more robust tool for spatial operations. However other tools and platforms can be very good for specific spatial operations. On Tue, Aug 29, 2023, 12:40 PM Shaozhong SHI wrote: > Geospatial capability has varied maturity in different systems, particular > of interest is those in Azure Cloud as compared to PostGIS. > > Is there any publication on this topic? > > Regards, > > David > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS verse those in Azure Cloud
I'm not sure this is considered Azure Cloud, but one more interesting tidbit in the Microsoft Geospatial space and this I know because many people in OSGeo seem to be obsessed by it. This whole STAC and Earth Science wave dominating the market https://planetarycomputer.microsoft.com/docs/quickstarts/reading-stac/ Here you have the intersection of Microsoft, STAC, QGIS, Python, CloudNative (add another buzzword) as you can see they even have a whole section about QGIS and QGIS on the Hub https://planetarycomputer.microsoft.com/docs/overview/qgis-plugin/ Hope that helps, Regina ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS verse those in Azure Cloud
> Shaozhong SHI writes: > > > Geospatial capability has varied maturity in different systems, > > particular of interest is those in Azure Cloud as compared to PostGIS. > > > > Is there any publication on this topic? > > Postgis lives firmly in the open source world so I suspect you are getting a lot > of silent reactions like "huh, I never thought to use azure cloud - I wonder if > anyone knows." > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users Azure Cloud is a very vague thing. It's really no more informative than saying "Microsoft". You need to be more specific about what you are talking about and for what purpose. Azure Cloud is a whole suite of tools. They have cloud compute services. Most people I know using Azure, are running on Cloud compute using Ubuntu with their own installed PostgreSQL/PostGIS and they don't use any of the other Azure services aside from the blob storage. If you are looking at databases they have DbaaS for PostgreSQL, SQL Server, and MySQL. For example there is Azure Database for PostgreSQL And that I know does carry PostGIS and pgrouting Within that, they've got a thing they call Flexible Server https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/overview Which I think gives you more flexibility as to what you can install and still have a managed database. Then they have a thing called single server which was their flagship DbaaS. As far as single server goes, I'd probably stay clear of it, since the documentation they have lists near death versions of PostgreSQL and EOL'd versions of PostGIS and pgrouting Though it could be their documentation is just out of date. https://learn.microsoft.com/en-us/azure/postgresql/single-server/concepts-ex tensions Then there is their Azure Cosmos Db for PostgreSQL -- which is basically PostgreSQL Citus extension under the hood (folded in when they bought the CitusDb PostgreSQL company) https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/introduction -- I'm not sure what extensions besides Citus are offered in this. I'm pretty sure PostGIS is offered here (and at least 3.something version and PostgreSQL 13 or above) as I do recall one of my clients running this with PostGIS 3.0 or 3.1 installed. and then there is the whole Azure IOT Maps thing. I don't know anyone using this, but looks like a pay per call suite of api services. https://azure.microsoft.com/en-us/products/azure-maps Hope that helps, Regina ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS verse those in Azure Cloud
Shaozhong SHI writes: > Geospatial capability has varied maturity in different systems, particular > of interest is those in Azure Cloud as compared to PostGIS. > > Is there any publication on this topic? Postgis lives firmly in the open source world so I suspect you are getting a lot of silent reactions like "huh, I never thought to use azure cloud - I wonder if anyone knows." ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
