<html><head></head><body><div class="ydp198a0cf3yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div dir="ltr" data-setdir="false"><span><span style="color: rgb(0, 0, 0); font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">Yann, t</span></span>hank you for clarifying this for me. </div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">I am indeed able to add a raster in 3.12.2 using '<span><span style="color: rgb(0, 0, 0); font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">postgresraster' as the data provider</span></span>. But I am not able to get to 'gdal' provider to work in either 3.12.2 or 3.10.5.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">FYI, I believe that the raster mirroring problem that I am having in 3.12 is related to the State Plane CRS that I am using (EPSG 2893). Using UTM I do not have the same problem.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">-Thayer</div><div dir="ltr" data-setdir="false"><br></div><div><br></div><div>=============================================</div><div><br></div><div dir="ltr" data-setdir="false"><div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">Message: 2<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">Date: Thu, 30 Apr 2020 23:17:05 +0200<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">From: Yann Voté <<a href="mailto:ygversil@lilo.org" style="color: rgb(25, 106, 212); text-decoration-line: underline;" rel="nofollow" target="_blank">ygversil@lilo.org</a>><br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">To: <a href="mailto:qgis-user@lists.osgeo.org" style="color: rgb(25, 106, 212); text-decoration-line: underline;" rel="nofollow" target="_blank">qgis-user@lists.osgeo.org</a><br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">Subject: Re: [Qgis-user] PyQGIS to add PostGIS raster layer?<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">Message-ID: <<a href="mailto:a50da9d1-932d-ccb0-c26e-bd5b5f8792d2@lilo.org" style="color: rgb(25, 106, 212); text-decoration-line: underline;" rel="nofollow" target="_blank">a50da9d1-932d-ccb0-c26e-bd5b5f8792d2@lilo.org</a>><br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">Content-Type: text/plain; charset=utf-8; format=flowed<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">As Alessandro pointed out, with QGS 3.12, you can use 'postgresraster'<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">instead of 'postgres' as the providerType argument. That is:<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">iface.addRasterLayer(uri.uri(), 'my layer label', 'postgresraster')<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">You can find out these parameters (URI and provider type) with further<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">introspection: when you have loaded the layer manually, select it, open<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">a Python console, and you can get the layer Python object with:<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">>>> db_layer = iface.activeLayer()<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">Then you can get the source URI with:<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">>>> db_layer.source():<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">and the provider type with:<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">>>> db_layer.providerType()<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">With these parameters you can feed iface.addRasterLayer() method or<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">QgsRasterLayer() init method.<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">With QGIS 3.10 you can introspect this way too to find out the URI while<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">'gdal' is the provider.<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">Regards.<br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div dir="ltr" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">Yann</div></div><br></div></div></body></html>