[Qgis-user] Re: [Qgis-developer] Fwd: WKTRaster Plugin 0.1

Mon Nov 29 05:55:47 PST 2010

Hi Stefan,
WKTRaster Plugin just repasses the right information to the GDAL driver.
It's not a new qgis driver.
I'm planning on implementing the table listing using pyqt this week. I was a
little delayed by my master's application.

The idea in the plugin is simply find the QGIS's conections available, list
the raster tables inside postgis and pass the right arguments to the gdal
driver.

At the moment I haven't found any gdal 1.7 windows build with QGIS. GDAL 1.7
introduces wktraster. The driver conects to postgis raster and read it as a
binary. It's still VERY unstable and gdal version 1.8 seems to be greatly
improved.
So what a windows user need to get the plugin to work is a (still not found)
qgis compiled against gdal 1.7.
You can compile your's from source if needed.

So, as far as qgis to wktraster, with the plugin qgis reads the wktraster as
a regular raster. Just for show. If you did some kind of processing and
populated a new raster table, qgis is going to read that result too. The
plugin is not intended (at the moment at least) to raster processing inside
postgis. It just loads the table to the screen.

In the future, with a more stable wktraster probably someone (or me) is
going to write a set of wktraster's tools as a plugin, but for the moment it
should be run as sql. I advise postgis manager's to the task.

Best regards,

2010/11/29 Stefan Keller <sfkeller at gmail.com>

> Hi,
>
> There are new versions around of "PostGIS Raster"
> (renamed from formerly known "PostGIS WKT Raster").
>
> What's the status of your "WKTRaster Plugin 0.1"?
> I assume it's rendering the raster values (e.g. from ST_AsBinary) -
> not the polygons/geomvals (from ST_DumpAsPolygons), right?
> Is there a chance to get it running on Windows too?
> Are there other plugins?
>
> Yours, S.
>
> 2010/10/23 Maurício de Paulo <mauricio.dev at gmail.com>:
> > Hi Tim!
> > I've used ubuntu with ubuntugis' repository.
> > postgis version 1.5, gdal version 1.7 (this is a requirement) and I had
> to
> > install wkt raster from source.
> > I'm going to write a post in my blog with my friend.
> > And as he's going to contribute we're changing the location to
> > mapeandoobrasil.blogspot.com
> > As usual it's going to be in portuguese, but I'm thinking about
> translating.
> >
> > The main steps were: install qgis, mapserver, gdal-bin 1.7, postgresql
> 8.4,
> > libpqxx, gdal-dev, and postgis 1.5 from ubuntu gis. (yes, mapserver also
> > works with wktraster)
> > download the source for postgis 1.5.2 from postgis' site and download
> > wktraster extension's source.
> > Compile wktraster following the readme (you have to tell where the
> postgis
> > source is as there is no postgis-dev package).
> > Now this is a trick part: the raster must be reformatted. I've read
> > somewhere a guy teaching how to reformat (tiling, byte sequence, etc) it
> to
> > be able to import to wktraster.
> > I only tested with the raster available at the wktraster's page. My
> friend
> > is writing the "how to format the raster" part of our blog post.
> > Then you load the sql of wktraster to the database and translate to sql
> the
> > raster using gdal2wktraster.py from wktraster build.
> > Now it's available through the plugin.
> >
> > I think this is a good abstract of how it's done. More details can be
> found
> > in blog posts around the net.
> > I'm going to implement the table listing in the plugin these weekend for
> now
> > you have to know the table name and type it down.
> > Good luck on your tests!
> >
> > Ps.: We're also trying to compare performance of wktraster with
> terralib's
> > raster implementation as it's the only postgresql georaster library I've
> > heard of. But as preliminary results the performance of wktraster looks
> like
> > an issue at the momento.
> >
> >
> >
> > 2010/10/22 Tim Sutton <lists at linfiniti.com>
> >>
> >> Hi
> >>
> >> Woohoo...can't wait to try that out! What postgis version did you use?
> >> Anything available in apt for wktraster + postgis?
> >>
> >> Regards
> >>
> >> Tim
> >>
> >> 2010/10/21 Maurício de Paulo <mauricio.dev at gmail.com>:
> >> >
> >> >
> >> > ---------- Forwarded message ----------
> >> > From: Maurício de Paulo <mauricio.dev at gmail.com>
> >> > Date: 2010/10/21
> >> > Subject: WKTRaster Plugin 0.1
> >> > To: qgis-user at lists.osgeo.org, qgis-dev at lists.osgeo.org
> >> >
> >> >
> >> > Hi everyone,
> >> > A friend of mine recently told me that wktraster is already storing
> and
> >> > loading raster to postgres. And it's even doing some spatial analisys
> >> > with
> >> > vector data overlayed.
> >> > I've written a simple plugin to load wktraster tables into QGIS as
> gdal
> >> > 1.7
> >> > already has a driver.
> >> > Sorry for the Windows users as I couldn't find a QGIS built with gdal
> >> > 1.7
> >> > support so no wktraster for windows users.
> >> > I've tested with ubuntu-gis qgis' build.
> >> >
> >> > At the moment the plugin DOES NOT list the existing tables, so you
> have
> >> > to
> >> > TYPE THE TABLENAME in the editbox.
> >> >
> >> > The plugin is available at the contributed repository.
> >> > Hope it's usefull
> >> >
> >> > --
> >> > 1º Ten Mauricio - Engenheiro Cartógrafo
> >> > 1ª Divisão de Levantamento
> >> > Exército Brasileiro - Braço Forte, Mão Amiga.
> >> >
> >> >
> >> >
> >> > --
> >> > 1º Ten Mauricio - Engenheiro Cartógrafo
> >> > 1ª Divisão de Levantamento
> >> > Exército Brasileiro - Braço Forte, Mão Amiga.
> >> >
> >> > _______________________________________________
> >> > Qgis-developer mailing list
> >> > Qgis-developer at lists.osgeo.org
> >> > http://lists.osgeo.org/mailman/listinfo/qgis-developer
> >> >
> >> >
> >>
> >>
> >>
> >> --
> >> Tim Sutton - QGIS Project Steering Committee Member (Release  Manager)
> >> ==============================================
> >> Please do not email me off-list with technical
> >> support questions. Using the lists will gain
> >> more exposure for your issues and the knowledge
> >> surrounding your issue will be shared with all.
> >>
> >> Visit http://linfiniti.com to find out about:
> >>  * QGIS programming and support services
> >>  * Mapserver and PostGIS based hosting plans
> >>  * FOSS Consulting Services
> >> Skype: timlinux
> >> Irc: timlinux on #qgis at freenode.net
> >> ==============================================
> >
> >
> >
> > --
> > 1º Ten Mauricio - Engenheiro Cartógrafo
> > 1ª Divisão de Levantamento
> > Exército Brasileiro - Braço Forte, Mão Amiga.
> >
> > _______________________________________________
> > Qgis-developer mailing list
> > Qgis-developer at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/qgis-developer
> >
> >
>

-- 
Mauricio de Paulo
Engenheiro Cartografo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20101129/9e960512/attachment.html>