As asked, I've added a simple screenshot of the plugin working on my blog. It's a fast presentation for my Brazilian friends. <br><br><a href="http://mapeandoobrasil.blogspot.com/2010/12/postgis-raster-plugin-para-qgis.html">http://mapeandoobrasil.blogspot.com/2010/12/postgis-raster-plugin-para-qgis.html</a><br>
<br>Best regards,<br>Mauricio de Paulo<br><br><div class="gmail_quote">2010/12/1 Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</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;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Just a tutorial similar to what Jorge and Pierre's did with
screen shots. </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"><a href="http://trac.osgeo.org/postgis/wiki/WKTRasterTutorial01" target="_blank">http://trac.osgeo.org/postgis/wiki/WKTRasterTutorial01</a></font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" size="2"><a href="http://gis4free.wordpress.com/category/postgis-raster/" target="_blank">http://gis4free.wordpress.com/category/postgis-raster/</a></font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">We were planning two -- one displaying PostGIS layers in
MapServer </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">and one displaying in QGIS </font></span><span><font color="#0000ff" face="Arial" size="2">similar to what
we did a while back for OpenJump:</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" size="2"><a href="http://www.postgresonline.com/journal/archives/72-OpenJump-for-PostGIS-Spatial-Ad-Hoc-Queries.html" target="_blank">http://www.postgresonline.com/journal/archives/72-OpenJump-for-PostGIS-Spatial-Ad-Hoc-Queries.html</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">We haven't tested MapServer since GDAL 1.7, but will be good
to see how Jorge's GDAL 1.8 improvements work with MapServer
now. We were able to load back then with some issues but wasn't
really testing for speed. We were too ecstatic when our layers
actually showed up in MapServer and that we were able to do both band and
attribute filters on top of it that we weren't even thinking about
speed.</font></span></div><div class="im">
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Thanks,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Regina and Leo</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div><br>
</div><div dir="ltr" lang="en-us" align="left">
<hr>
<font face="Tahoma" size="2"><b>From:</b> Maurício de Paulo
[mailto:<a href="mailto:mauricio.dev@gmail.com" target="_blank">mauricio.dev@gmail.com</a>] <br><b>Sent:</b> Tuesday, November 30, 2010 9:24
PM<br><b>To:</b> Paragon Corporation<br><b>Cc:</b> PostGIS Users Discussion;
<a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a>; <a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br><b>Subject:</b> Re:
[postgis-users] [Qgis-developer] Fwd: WKTRaster Plugin 0.1<br></font><br></div><div><div></div><div class="h5">
<div></div>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.<br>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.<br>That's why i
was able to alter it on windows. I can test the plugin part. I can't test GDAL
part.<br>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.<br>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).<br>The
plugin's fairly simple, though.<br>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.<br>I don't really know if I should bring a new tool to the application
doing almost the same thing with just different datasources.<br>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.<br><br>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.<br>Best regards,<br>Mauricio de Paulo<br><br><br>
<div class="gmail_quote">2010/11/30 Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span><br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
<div><br>> Great team work that you and Jorge are doing!<br>>
Any other sugestions on what a "Load postgis raster" plugin should do?<br>Your
wrote yesterday:<br>> "Stefan asked about the processing. This is something
the plugin doesn't<br>do."<br>> Is this feature request already
solved?<br>> If not, I would be happy with a free text input window for
entering SQL<br>queries as an alternative for "power users".<br><br>>
Yours, S.<br></div>Yes that would definitely be a great feature as well as
having it in a<br>pre-compiled windows build.<br><br>Mauricio,<br><br>Do you
have a link for more information about this plugin. I'd like
to<br>include it as part of the PostGIS manual and PostGIS raster
wiki.<br>Unfortunately we don't have a build environment for QGIS, but if
there is a<br>windows build,Leo and I would be happy to write up a demo
on using the tool<br>And at the very least we'll be mentioning it in the
PostGIS in Action book<br>if not including snapshots as
well.<br><br>Thanks,<br>Regina and Leo,<br><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a><br><br><br></blockquote></div><br><br clear="all"><br>-- <br>Mauricio de Paulo<br>Engenheiro
Cartografo<br><br></div></div></div>
</blockquote></div><br><br clear="all"><br>-- <br>Mauricio de Paulo<br>Engenheiro Cartografo<br><br>