[Qgis-developer] Fwd: WKTRaster Plugin 0.1

[Stefan Keller]

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