<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16671"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT color=#0000ff
size=2 face=Arial>Just a tutorial similar to what Jorge and Pierre's did with
screen shots. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT color=#0000ff
size=2 face=Arial><A
href="http://trac.osgeo.org/postgis/wiki/WKTRasterTutorial01">http://trac.osgeo.org/postgis/wiki/WKTRasterTutorial01</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT size=2
face=Arial><A
href="http://gis4free.wordpress.com/category/postgis-raster/">http://gis4free.wordpress.com/category/postgis-raster/</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT color=#0000ff
size=2 face=Arial>We were planning two -- one displaying PostGIS layers in
MapServer </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT color=#0000ff
size=2 face=Arial>and one displaying in QGIS </FONT></SPAN><SPAN
class=781004502-01122010><FONT color=#0000ff size=2 face=Arial>similar to what
we did a while back for OpenJump:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT size=2
face=Arial><A
href="http://www.postgresonline.com/journal/archives/72-OpenJump-for-PostGIS-Spatial-Ad-Hoc-Queries.html">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 class=781004502-01122010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT color=#0000ff
size=2 face=Arial>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 dir=ltr align=left><SPAN class=781004502-01122010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT color=#0000ff
size=2 face=Arial>Regina and Leo</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=781004502-01122010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> Maurício de Paulo
[mailto:mauricio.dev@gmail.com] <BR><B>Sent:</B> Tuesday, November 30, 2010 9:24
PM<BR><B>To:</B> Paragon Corporation<BR><B>Cc:</B> PostGIS Users Discussion;
qgis-user@lists.osgeo.org; Qgis-developer@lists.osgeo.org<BR><B>Subject:</B> Re:
[postgis-users] [Qgis-developer] Fwd: WKTRaster Plugin 0.1<BR></FONT><BR></DIV>
<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">lr@pcorp.us</A>></SPAN><BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV class=im><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></BODY></HTML>