[postgis-users] [Qgis-developer] Fwd: WKTRaster Plugin 0.1

[Stefan Keller]

Hi Maurício
Ok; in order to get a nice plugin (probably better renamed to "PostGIS
Raster Plugin") it seems that we need a decision as well as some quick
attention from different "players".

What we want out of QGIS is (1.) displaying PostGIS tables with raster
data and (2.) adding a query before hand.
QGIS supports already GDAL as raster Layer source as well as PostGIS
(as vector source).
PostGIS Raster well be supported through GDAL but that seems to me
more complicated than supporting PostGIS raster directly.
How to best merge requirement 2 (query) into these two raster sources
from a user interaction (and plugin) point of view seems to be
discussed now.

> Actually the plugin was born in really speedy fashion. I think that at the
> moment it speaks for itself as it's actually very simple.
> I could test the UI on windows, if that's what you need, but to actually
> read the raster you need gdal recognizing postgis rasters so only for 1.7
> builds.

I like simple plugins (aka doing only one thing but right :->).

> That's why i was able to alter it on windows. I can test the plugin part. I
> can't test GDAL part.

For the GDAL and PostGIS Raster driver part, I think there's Frank
Warmerdam and Jorge Arevalo (Bcc'd).
For the QGIS release (incl. GDAL and new PostGIS raster driver?) it's
Tim Sutton.

> For the next request (a tool to process the queries), QGIS does have a
> really nice tool called RT_Sql to execute PostGIS SQL queries.
> I don't really know if I should bring a new tool to the application doing
> almost the same thing with just different datasources.

Right. So merge it with RT SQL Layer plugin?
Paolo and Guiseppe from Faunalia have published RT SQL Layer plugin (Bcc'd).

Yours, S.


2010/12/1 Maurício de Paulo <mauricio.dev at gmail.com>:
> Actually the plugin was born in really speedy fashion. I think that at the
> moment it speaks for itself as it's actually very simple.
> I could test the UI on windows, if that's what you need, but to actually
> read the raster you need gdal recognizing postgis rasters so only for 1.7
> builds.
> That's why i was able to alter it on windows. I can test the plugin part. I
> can't test GDAL part.
> QGIS is releasing a new version these weeks. I'm going to ask if is anyone
> going to compile a windows build with gdal 1.7 or (with luck) 1.8.
> What kind of demo do you need? I don't have a hosting for the plugin at the
> moment but I can produce some ubuntu's screenshots (or even a video).
> The plugin's fairly simple, though.
> For the next request (a tool to process the queries), QGIS does have a
> really nice tool called RT_Sql to execute PostGIS SQL queries.
> I don't really know if I should bring a new tool to the application doing
> almost the same thing with just different datasources.
> What can be done is to talk with the guys who developped RT_Sql and check if
> they don't want a little improvement to cope with raster layers too.
>
> Anyway, there is still a mystic point for me: some processing returns vector
> and some return rasters (and I don'nt think that's all). That's... odd to
> cope with. I'm still giving some thought to it. I still need to read how
> postgis raster processing works and gives results.
> Best regards,
> Mauricio de Paulo
>
>
> 2010/11/30 Paragon Corporation <lr at pcorp.us>
>>
>> > Great team work that you and Jorge are doing!
>> > Any other sugestions on what a "Load postgis raster" plugin should do?
>> Your wrote yesterday:
>> > "Stefan asked about the processing. This is something the plugin doesn't
>> do."
>> > Is this feature request already solved?
>> > If not, I would be happy with a free text input window for entering SQL
>> queries as an alternative for "power users".
>>
>> > Yours, S.
>> Yes that would definitely be a great feature as well as having it in a
>> pre-compiled windows build.
>>
>> Mauricio,
>>
>> Do you have a link for more information about this plugin.  I'd like to
>> include it as part of the PostGIS manual and PostGIS raster wiki.
>> Unfortunately we don't have a build environment for QGIS, but if there is
>> a
>> windows build,Leo and I would  be happy to write up a demo on using the
>> tool
>> And at the very least we'll be mentioning it in the PostGIS in Action book
>> if not including snapshots as well.
>>
>> Thanks,
>> Regina and Leo,
>> http://www.postgis.us
>>
>>
>
>
>
> --
> Mauricio de Paulo
> Engenheiro Cartografo
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>