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

[Maurício de Paulo]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20101022/07fd93dc/attachment.html>