Re: [mapguide-users] Does mapguide support rasters stored in Postgis
Thanks for all your help… I just give up by now… I don’t have a clue how it works and it was just a test. Perhaps in the future it will be better supported in Maestro Cheers. Diego From: mapguide-users On Behalf Of Jackie Ng Sent: August 16, 2021 10:36 AM To: mapguide-users@lists.osgeo.org Subject: Re: [mapguide-users] Does mapguide support rasters stored in Postgis Okay, I took a look at why the GDAL provider returned true (because this was easier than trying to figure out how to load some rasters into postgis) Turns out the GDAL provider automatically sets connection state to open regardless of the data source string you specify in the connection parameters. This has an effect on the MapGuide side of making every GDAL connection test be a successful result, hence explaining why even a gibberish string will return a TRUE result. That particular bug is being tracked here: https://trac.osgeo.org/fdo/ticket/995 All I can say at this point is try to proceed as though the PGSQL connection string you passed in is legit and see how things go. - Jackie You wrote: Thanks again Jackie, much appreciated your support. I’ve realized that regardless of what you write on the FILE path… the TEST result is always TRUE I wrote Gibberish (literally) and still TRUE -- Please Note: I no longer create new posts or post replies to any OSGeo mailing list through nabble. As a result, you most likely won't see this message appear on nabble's view of any OSGeo mailing list and may only see this message through mailing list archives or depending on your mailing list subscription settings, through daily message digests or automated notifications from the mailing lists. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Does mapguide support rasters stored in Postgis
Okay, I took a look at why the GDAL provider returned true (because this was easier than trying to figure out how to load some rasters into postgis) Turns out the GDAL provider automatically sets connection state to open regardless of the data source string you specify in the connection parameters. This has an effect on the MapGuide side of making every GDAL connection test be a successful result, hence explaining why even a gibberish string will return a TRUE result. That particular bug is being tracked here: https://trac.osgeo.org/fdo/ticket/995 All I can say at this point is try to proceed as though the PGSQL connection string you passed in is legit and see how things go. - Jackie You wrote: Thanks again Jackie, much appreciated your support. I’ve realized that regardless of what you write on the FILE path… the TEST result is always TRUE I wrote Gibberish (literally) and still TRUE -- *Please Note: I no longer create new posts or post replies to any OSGeo mailing list through nabble. As a result, you most likely won't see this message appear on nabble's view of any OSGeo mailing list and may only see this message through mailing list archives or depending on your mailing list subscription settings, through daily message digests or automated notifications from the mailing lists.* ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Does mapguide support rasters stored in Postgis
Thanks again Jackie, much appreciated your support. I’ve realized that regardless of what you write on the FILE path… the TEST result is always TRUE I wrote Gibberish (literally) and still TRUE [cid:image001.png@01D78EAF.AC60E050] From: mapguide-users mapguide-users-boun...@lists.osgeo.org<mailto:mapguide-users-boun...@lists.osgeo.org> On Behalf Of Jackie Ng Sent: August 11, 2021 5:05 AM To: mapguide-users@lists.osgeo.org Subject: Re: [mapguide-users] Does mapguide support rasters stored in Postgis [NOTE: Same reply but with proper email subject this time so it should display properly in mailing list archives] Postgis raster is a supported driver of the GDAL provider. It's not its own separate FDO provider. So not seeing Postgis raster on that list *is to be expected*. You should be selecting the GDAL provider. Now here is where you are venturing into uncharted territory. This is because I have assumed for the longest time that users would only be using the GDAL provider to connect to file-based raster data sources and not raster data in external web services or relational databases (such is the case for PostGIS raster) and thus the GDAL provider UI in Maestro is designed with this assumption in mind. Nevertheless, the file path parameter in that UI maps to the parameter that the GDAL provider uses to open the data source, so you should theoretically be able to use whatever parameter needed to connect to the raster data in that same file path field. In the case of PostGIS raster, you would use the a connection string whose structure is described here: https://gdal.org/drivers/raster/postgisraster.html#connecting-to-a-database Basically, put this connection string into that file path field and try to test the connection. If it's all good, save it and you should be able to then be able to make layers from it. - Jackie You wrote: Hi Jackie. I applied the new GDAL as you suggested. [cid:image001.png@01D78DE3.38E17030] I still don’t see anything called Postgis Raster in MapGuide Maestro… which one should I use instead ? Thanks for your help -- Please Note: I no longer create new posts or post replies to any OSGeo mailing list through nabble. As a result, you most likely won't see this message appear on nabble's view of any OSGeo mailing list and may only see this message through mailing list archives or depending on your mailing list subscription settings, through daily message digests or automated notifications from the mailing lists. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Does mapguide support rasters stored in Postgis
[NOTE: Same reply but with proper email subject this time so it should display properly in mailing list archives] Postgis raster is a supported driver of the GDAL provider. It's not its own separate FDO provider. So not seeing Postgis raster on that list *is to be expected*. You should be selecting the GDAL provider. Now here is where you are venturing into uncharted territory. This is because I have assumed for the longest time that users would only be using the GDAL provider to connect to *file-based* raster data sources and not raster data in external web services or relational databases (such is the case for PostGIS raster) and thus the GDAL provider UI in Maestro is designed with this assumption in mind. Nevertheless, the file path parameter in that UI maps to the parameter that the GDAL provider uses to open the data source, so you should theoretically be able to use whatever parameter needed to connect to the raster data in that same file path field. In the case of PostGIS raster, you would use the a connection string whose structure is described here: https://gdal.org/drivers/raster/postgisraster.html#connecting-to-a-database Basically, put this connection string into that file path field and try to test the connection. If it's all good, save it and you should be able to then be able to make layers from it. - Jackie You wrote: Hi Jackie. I applied the new GDAL as you suggested. [cid:image001.png@01D78DE3.38E17030] I still don’t see anything called Postgis Raster in MapGuide Maestro… which one should I use instead ? Thanks for your help -- *Please Note: I no longer create new posts or post replies to any OSGeo mailing list through nabble. As a result, you most likely won't see this message appear on nabble's view of any OSGeo mailing list and may only see this message through mailing list archives or depending on your mailing list subscription settings, through daily message digests or automated notifications from the mailing lists.* ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Does mapguide support rasters stored in Postgis
Hi Jackie. I applied the new GDAL as you suggested. [cid:image001.png@01D78DE3.38E17030] I still don’t see anything called Postgis Raster in MapGuide Maestro… which one should I use instead ? Thanks for your help Diego From: mapguide-users On Behalf Of Jackie Ng Sent: June 26, 2021 5:11 AM To: mapguide-users@lists.osgeo.org Subject: Re: [mapguide-users] Does mapguide support rasters stored in Postgis Refer to the updated GDAL provider notes for 4.0 in regards to swapping the GDAL dll for one from gisinternals which has postgis raster support. https://trac.osgeo.org/mapguide/wiki/MGOS40GdalProvider - Jackie You wrote: If I use MapGuide 4 Preview 3 Win10 x64, does it support the Postgis-Raster already ? Or do I still have to patch it with the new GDAL ? Could you share some instructions how to patch the MG 3.1.2 with the new GDAL? I’m not sure what exactly means replacing the DLL If I am going to access a Postgis Raster file, what source should I use, GDAL or Postgis? -- Please Note: I no longer create new posts or post replies to any OSGeo mailing list through nabble. As a result, you most likely won't see this message appear on nabble's view of any OSGeo mailing list and may only see this message through mailing list archives or depending on your mailing list subscription settings, through daily message digests or automated notifications from the mailing lists. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Does mapguide support rasters stored in Postgis
Refer to the updated GDAL provider notes for 4.0 in regards to swapping the GDAL dll for one from gisinternals which has postgis raster support. https://trac.osgeo.org/mapguide/wiki/MGOS40GdalProvider - Jackie You wrote: If I use MapGuide 4 Preview 3 Win10 x64, does it support the Postgis-Raster already ? Or do I still have to patch it with the new GDAL ? Could you share some instructions how to patch the MG 3.1.2 with the new GDAL? I’m not sure what exactly means replacing the DLL If I am going to access a Postgis Raster file, what source should I use, GDAL or Postgis? -- *Please Note: I no longer create new posts or post replies to any OSGeo mailing list through nabble. As a result, you most likely won't see this message appear on nabble's view of any OSGeo mailing list and may only see this message through mailing list archives or depending on your mailing list subscription settings, through daily message digests or automated notifications from the mailing lists.* ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Does mapguide support rasters stored in Postgis
If I use MapGuide 4 Preview 3 Win10 x64, does it support the Postgis-Raster already ? Or do I still have to patch it with the new GDAL ? Could you share some instructions how to patch the MG 3.1.2 with the new GDAL ? I’m not sure what exactly means replacing the DLL If I am going to access a Postgis Raster file, what source should I use, GDAL or Postgis? [cid:image001.png@01D769C6.69CC3270] Thanks a lot for your help Diego From: mapguide-users On Behalf Of Jackie Ng Sent: Thursday, June 24, 2021 2:18 AM To: mapguide-users@lists.osgeo.org Subject: Re: [mapguide-users] Does mapguide support rasters stored in Postgis For Windows: MGOS 4.0 Preview 3 - GDAL 2.4.4 / MSVC 2015 MGOS 3.1.2 - GDAL 2.2.3 / MSVC 2015 Older MGOS versions you can refer to GDAL provider notes on the MapGuide trac wiki (https://trac.osgeo.org/mapguide/wiki) For Ubuntu 16.04, we build FDO against the distro-provided GDAL version (1.11), which should be as fully-featured as possible in terms of driver support barring drivers/formats that require non-OSS libraries. I did an apt-get install gdal-bin on an Ubuntu 16.04 docker container and ran: gdalinfo --formats And I see PostGISRaster is on the driver list so on Linux you should be good to go. - Jackie You wrote: Thanks for your prompt reply Jackie What versions of MG will work with your suggested approach ? does it work also in LINUX Ubuntu 16.06 MG4 ? -- Please Note: I no longer create new posts or post replies to any OSGeo mailing list through nabble. As a result, you most likely won't see this message appear on nabble's view of any OSGeo mailing list and may only see this message through mailing list archives or depending on your mailing list subscription settings, through daily message digests or automated notifications from the mailing lists. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Does mapguide support rasters stored in Postgis
For Windows: MGOS 4.0 Preview 3 - GDAL 2.4.4 / MSVC 2015 MGOS 3.1.2 - GDAL 2.2.3 / MSVC 2015 Older MGOS versions you can refer to GDAL provider notes on the MapGuide trac wiki (https://trac.osgeo.org/mapguide/wiki) For Ubuntu 16.04, we build FDO against the distro-provided GDAL version (1.11), which should be as fully-featured as possible in terms of driver support barring drivers/formats that require non-OSS libraries. I did an apt-get install gdal-bin on an Ubuntu 16.04 docker container and ran: gdalinfo --formats And I see PostGISRaster is on the driver list so on Linux you should be good to go. - Jackie You wrote: Thanks for your prompt reply Jackie What versions of MG will work with your suggested approach ? does it work also in LINUX Ubuntu 16.06 MG4 ? -- *Please Note: I no longer create new posts or post replies to any OSGeo mailing list through nabble. As a result, you most likely won't see this message appear on nabble's view of any OSGeo mailing list and may only see this message through mailing list archives or depending on your mailing list subscription settings, through daily message digests or automated notifications from the mailing lists.* ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Does mapguide support rasters stored in Postgis
You just need to match the GDAL compatible with the current version of MGOS you are using. For example, with MGOS 4 - preview 3 it uses GDAL 2.4.4 On Wed, Jun 23, 2021 at 3:43 PM Diego Ordonez wrote: > Thanks for your prompt reply Jackie > > > > What versions of MG will work with your suggested approach ? does it work > also in LINUX Ubuntu 16.06 MG4 ? > > > > *From:* mapguide-users *On > Behalf Of *Jackie Ng > *Sent:* Wednesday, June 23, 2021 9:26 AM > *To:* mapguide-users@lists.osgeo.org > *Subject:* Re: [mapguide-users] Does mapguide support rasters stored in > Postgis > > > > Hi Diego, > > > > Your best bet is to use the PostGISRaster driver in GDAL ( > https://gdal.org/drivers/raster/postgisraster.html). > > > > This implies that you'll have to replace the GDAL dll that comes with the > MapGuide installation with one from gisinternals.com which is of the same > GDAL version and is built with the same MSVC compile that we use to build > MapGuide and FDO. > > > > Most raster format support questions can be boiled down to: Is there a > GDAL driver for it? Then just use the GDAL FDO provider (swapping out > MapGuide's GDAL dll with a fuller-featured copy elsewhere if necessary) > > > > - Jackie > > > > You wrote: > > Does mapguide support rasters stored in Postgis ? > > Any plans to implement it ? > > Thank you > > Diego > > > > -- > > *Please Note: I no longer create new posts or post replies to any OSGeo > mailing list through nabble. As a result, you most likely won't see this > message appear on nabble's view of any OSGeo mailing list and may only see > this message through mailing list archives or depending on your mailing > list subscription settings, through daily message digests or automated > notifications from the mailing lists.* > ___ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/mapguide-users > ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Does mapguide support rasters stored in Postgis
Thanks for your prompt reply Jackie What versions of MG will work with your suggested approach ? does it work also in LINUX Ubuntu 16.06 MG4 ? From: mapguide-users On Behalf Of Jackie Ng Sent: Wednesday, June 23, 2021 9:26 AM To: mapguide-users@lists.osgeo.org Subject: Re: [mapguide-users] Does mapguide support rasters stored in Postgis Hi Diego, Your best bet is to use the PostGISRaster driver in GDAL (https://gdal.org/drivers/raster/postgisraster.html). This implies that you'll have to replace the GDAL dll that comes with the MapGuide installation with one from gisinternals.com<http://gisinternals.com> which is of the same GDAL version and is built with the same MSVC compile that we use to build MapGuide and FDO. Most raster format support questions can be boiled down to: Is there a GDAL driver for it? Then just use the GDAL FDO provider (swapping out MapGuide's GDAL dll with a fuller-featured copy elsewhere if necessary) - Jackie You wrote: Does mapguide support rasters stored in Postgis ? Any plans to implement it ? Thank you Diego -- Please Note: I no longer create new posts or post replies to any OSGeo mailing list through nabble. As a result, you most likely won't see this message appear on nabble's view of any OSGeo mailing list and may only see this message through mailing list archives or depending on your mailing list subscription settings, through daily message digests or automated notifications from the mailing lists. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Does mapguide support rasters stored in Postgis
Hi Diego, Your best bet is to use the PostGISRaster driver in GDAL ( https://gdal.org/drivers/raster/postgisraster.html). This implies that you'll have to replace the GDAL dll that comes with the MapGuide installation with one from gisinternals.com which is of the same GDAL version and is built with the same MSVC compile that we use to build MapGuide and FDO. Most raster format support questions can be boiled down to: Is there a GDAL driver for it? Then just use the GDAL FDO provider (swapping out MapGuide's GDAL dll with a fuller-featured copy elsewhere if necessary) - Jackie You wrote: Does mapguide support rasters stored in Postgis ? Any plans to implement it ? Thank you Diego -- *Please Note: I no longer create new posts or post replies to any OSGeo mailing list through nabble. As a result, you most likely won't see this message appear on nabble's view of any OSGeo mailing list and may only see this message through mailing list archives or depending on your mailing list subscription settings, through daily message digests or automated notifications from the mailing lists.* ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Does mapguide support rasters stored in Postgis
From: Diego Ordonez Sent: Tuesday, June 22, 2021 10:20 AM To: mapguide-users@lists.osgeo.org Subject: Does mapguide support rasters stored in Postgis Does mapguide support rasters stored in Postgis ? Any plans to implement it ? Thank you Diego ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] Does mapguide support rasters stored in Postgis
Does mapguide support rasters stored in Postgis ? Any plans to implement it ? Thank you Diego ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
