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