<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Courier;
panose-1:2 7 4 9 2 2 5 2 4 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
mso-fareast-language:EN-CA;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-CA" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Thanks again Jackie, much appreciated your support.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">I’ve realized that regardless of what you write on the FILE path… the TEST result is always TRUE<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">I wrote Gibberish (literally) and still TRUE<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><img width="613" height="445" style="width:6.3854in;height:4.6354in" id="Picture_x0020_2" src="cid:image001.png@01D78EAF.AC60E050"></span><span style="mso-fareast-language:EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> mapguide-users
<a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>
<b>On Behalf Of </b>Jackie Ng<br>
<b>Sent:</b> August 11, 2021 5:05 AM<br>
<b>To:</b> mapguide-users@lists.osgeo.org<br>
<b>Subject:</b> Re: [mapguide-users] Does mapguide support rasters stored in Postgis<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">[NOTE: Same reply but with proper email subject this time so it should display properly in mailing list archives]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Postgis raster is a supported driver of the GDAL provider. It's not its own separate FDO provider.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">So not seeing Postgis raster on that list *is to be expected*. You should be selecting the GDAL provider.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">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 <b>file-based</b> 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.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">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.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">In the case of PostGIS raster, you would use the a connection string whose structure is described here:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="https://gdal.org/drivers/raster/postgisraster.html#connecting-to-a-database" target="_blank">https://gdal.org/drivers/raster/postgisraster.html#connecting-to-a-database</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">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.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">- Jackie<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">You wrote:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<blockquote style="margin-left:30.0pt;margin-right:0cm">
<pre style="white-space:pre-wrap"><span style="font-size:10.5pt;font-family:Courier;color:black">Hi Jackie.<o:p></o:p></span></pre>
<pre style="white-space:pre-wrap"><span style="font-size:10.5pt;font-family:Courier;color:black">I applied the new GDAL as you suggested.<o:p></o:p></span></pre>
<pre style="white-space:pre-wrap"><span style="font-size:10.5pt;font-family:Courier;color:black">[<a href="cid:image001.png@01D78DE3.38E17030">cid:image001.png@01D78DE3.38E17030</a>]<o:p></o:p></span></pre>
<pre style="white-space:pre-wrap"><span style="font-size:10.5pt;font-family:Courier;color:black">I still don’t see anything called Postgis Raster in MapGuide Maestro… which one <o:p></o:p></span></pre>
<pre style="white-space:pre-wrap"><span style="font-size:10.5pt;font-family:Courier;color:black">should I use instead ?<o:p></o:p></span></pre>
<pre style="white-space:pre-wrap"><span style="font-size:10.5pt;font-family:Courier;color:black">Thanks for your help<o:p></o:p></span></pre>
</blockquote>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal"><i><span style="font-size:7.5pt">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.</span></i><o:p></o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>