[Qgis-developer] Status of Plugins to load PostGIS Raster and MBTiles directly?

[Stefan Keller]

Hi Even

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.

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).

Yours, Stefan

---
ERROR:  Column geo.out_db does not exist
LINE 7:       geo.out_db,
              ^
Query:
SELECT
cla.relname, nsp.nspname, cla.relkind = 'v', pg_get_userbyid(relowner),
cla.reltuples, cla.relpages,
CASE WHEN geo.r_raster_column IS NOT NULL THEN geo.r_raster_column ELSE
att.attname END,
geo.pixel_types,
geo.scale_x,
geo.scale_y,
geo.out_db,
geo.srid

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
JOIN pg_namespace AS nsp ON
nsp.oid = cla.relnamespace

JOIN pg_attribute AS att ON
att.attrelid = cla.oid AND
att.atttypid = 'raster'::regtype OR
att.atttypid IN (SELECT oid FROM pg_type WHERE
typbasetype='raster'::regtype )

LEFT OUTER JOIN raster_columns AS geo ON
cla.relname = geo.r_table_name AND nsp.nspname = r_table_schema AND
lower(att.attname) = lower(r_raster_column)

WHERE cla.relkind IN ('v', 'r')  AND (nspname != 'information_schema' AND
nspname !~ 'pg_')
ORDER BY nsp.nspname, cla.relname, att.attname

<<OK>>
--




2013/4/7 Even Rouault <even.rouault at mines-paris.org>

> Le dimanche 07 avril 2013 21:26:00, Stefan Keller a écrit :
> > On 2013/4/7 I wrote
> >
> > > What is the status of plugins
> > > 1. to load PostGIS Raster and
> > > 2. to load MBTiles
> > > directly into QGIS as (raster) layer?
> >
> > To be more specific:
> > I really mean loading PostGIS Raster and MBTiles directly, w/o trick
> using
> > GDAL (GdalTools?) and configuring .VRT "by hand" before.
> > For PostGIS Raster specifically I'm aware of the plugin "Load PostGIS
> > Raster" (alias "WKT Raster Plugin"?) from Mauricio de Paulo (QGIS
> Official
> > Repo. 2).
>
> Note that with GDAL 1.10, you'll be able to open mbtiles files directly as
> any
> other GDAL rasters.
>
> >
> > Yours, Stefan
> >
> >
> > 2013/4/7 Stefan Keller <sfkeller at gmail.com>
> >
> > > Hi,
> > >
> > > What is the status of plugins
> > > 1. to load PostGIS Raster and
> > > 2. to load MBTiles
> > >
> > > directly into QGIS as (raster) layer?
> > >
> > > Yours, Stefan
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20130407/1954d441/attachment.html>