Hi Even<div><br></div><div>Thanks for the hint! Of you really mean by "open mbtiles files directly as any other GDAL rasters" being able to access files with postfix ".mbtiles" (not by postfix .VRT) - that's what I mean.<div>
<div><br></div><div>Remains the issue for loading PostGIS Raster: When I try to load a "Add a Postgis Raster Layer (using "Load PostGIS Raster" (alias "WKT Raster Plugin"?) from Mauricio de Paulo) I get the error below (I tried it with QGIS 1.8 and 1.9 under Windows).</div>
<div><br></div><div>Yours, Stefan</div><div><br></div><div>---</div><div><div>ERROR: Column geo.out_db does not exist</div><div>LINE 7: geo.out_db,</div><div> ^</div><div>Query:</div><div>SELECT </div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>cla.relname, nsp.nspname, cla.relkind = 'v', pg_get_userbyid(relowner), cla.reltuples, cla.relpages, </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>CASE WHEN geo.r_raster_column IS NOT NULL THEN geo.r_raster_column ELSE att.attname END, </div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>geo.pixel_types,</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>geo.scale_x,</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>geo.scale_y,</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>geo.out_db,</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>geo.srid</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>FROM (select oid, pg_class.* from (select relname from pg_class except select relname from pg_class,raster_overviews where relname=o_table_name) as exclude,pg_class where exclude.relname=pg_class.relname) AS cla </div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>JOIN pg_namespace AS nsp ON </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>nsp.oid = cla.relnamespace</div><div><br></div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>JOIN pg_attribute AS att ON </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>att.attrelid = cla.oid AND </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>att.atttypid = 'raster'::regtype OR </div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>att.atttypid IN (SELECT oid FROM pg_type WHERE typbasetype='raster'::regtype ) </div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>LEFT OUTER JOIN raster_columns AS geo ON </div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>cla.relname = geo.r_table_name AND nsp.nspname = r_table_schema AND </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>lower(att.attname) = lower(r_raster_column) </div>
<div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>WHERE cla.relkind IN ('v', 'r') AND (nspname != 'information_schema' AND nspname !~ 'pg_') </div><div>
<span class="Apple-tab-span" style="white-space:pre"> </span>ORDER BY nsp.nspname, cla.relname, att.attname</div></div><div><br></div><div><<OK>></div><div>--</div><div><br></div><div><br></div><div><br><br>
<div class="gmail_quote">2013/4/7 Even Rouault <span dir="ltr"><<a href="mailto:even.rouault@mines-paris.org" target="_blank">even.rouault@mines-paris.org</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Le dimanche 07 avril 2013 21:26:00, Stefan Keller a écrit :<br>
<div class="im">> On 2013/4/7 I wrote<br>
><br>
> > What is the status of plugins<br>
> > 1. to load PostGIS Raster and<br>
> > 2. to load MBTiles<br>
> > directly into QGIS as (raster) layer?<br>
><br>
> To be more specific:<br>
> I really mean loading PostGIS Raster and MBTiles directly, w/o trick using<br>
> GDAL (GdalTools?) and configuring .VRT "by hand" before.<br>
> For PostGIS Raster specifically I'm aware of the plugin "Load PostGIS<br>
> Raster" (alias "WKT Raster Plugin"?) from Mauricio de Paulo (QGIS Official<br>
> Repo. 2).<br>
<br>
</div>Note that with GDAL 1.10, you'll be able to open mbtiles files directly as any<br>
other GDAL rasters.<br>
<div class="HOEnZb"><div class="h5"><br>
><br>
> Yours, Stefan<br>
><br>
><br>
> 2013/4/7 Stefan Keller <<a href="mailto:sfkeller@gmail.com">sfkeller@gmail.com</a>><br>
><br>
> > Hi,<br>
> ><br>
> > What is the status of plugins<br>
> > 1. to load PostGIS Raster and<br>
> > 2. to load MBTiles<br>
> ><br>
> > directly into QGIS as (raster) layer?<br>
> ><br>
> > Yours, Stefan<br>
</div></div></blockquote></div><br></div></div></div>