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 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 <a href="http://mapeandoobrasil.blogspot.com">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, libpqxx, gdal-dev, and postgis 1.5 from ubuntu gis. (yes, mapserver also works with wktraster)<br>download the source for postgis 1.5.2 from postgis' site and download wktraster extension's source.<br>
Compile wktraster following the readme (you have to tell where the postgis source is as there is no postgis-dev package).<br>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.<br>
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.<br>Then you load the sql of wktraster to the database and translate to sql the 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 in blog posts around the net.<br>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.<br>
Good luck on your tests!<br><br>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.<br>
<br><br><br><div class="gmail_quote">2010/10/22 Tim Sutton <span dir="ltr"><<a href="mailto:lists@linfiniti.com">lists@linfiniti.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>
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>
<div><div></div><div class="h5">><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 with<br>
> vector data overlayed.<br>
> I've written a simple plugin to load wktraster tables into QGIS as gdal 1.7<br>
> already has a driver.<br>
> Sorry for the Windows users as I couldn't find a QGIS built with gdal 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 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>
</div></div>> _______________________________________________<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>
</blockquote></div><br><br clear="all"><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>