<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Thanks a lot yes I did the same now it work..</span></div><div><br></div> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <div dir="ltr"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Paragon Corporation <lr@pcorp.us><br> <b><span style="font-weight: bold;">To:</span></b> 'PostGIS Users Discussion' <postgis-users@postgis.refractions.net> <br> <b><span style="font-weight: bold;">Sent:</span></b> Wednesday, 25 January 2012, 23:43<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] ST_MapAlgebraExpr() Function<br> </font> </div> <br><div id="yiv2028029768">
<div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768068044122-25012012">Deepak,</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768068044122-25012012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768068044122-25012012">Yes you can upgrage. If you are running
2011-10-06 I think you should be able to get the latest function
by</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768068044122-25012012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768068044122-25012012">1) download the latest experimental
build</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768068044122-25012012">2) overwrite your binaries</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768068044122-25012012">3) run the postgis_upgrade_20_minor.sql and the
rtpostgis_upgrade_20_minor.sql files located in the </span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768068044122-25012012">share/contrib/postgis-2.0 folder of the zip you
downloaded.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768068044122-25012012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768068044122-25012012">Hope that helps,</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768068044122-25012012">Regina</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768068044122-25012012"><a rel="nofollow" target="_blank" href="http://www.postgis.us">http://www.postgis.us</a></span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768068044122-25012012"></span></font> </div><br>
<blockquote style="BORDER-LEFT:#0000ff 2px solid;PADDING-LEFT:5px;MARGIN-LEFT:5px;MARGIN-RIGHT:0px;" dir="ltr">
<div dir="ltr" lang="en-us" class="yiv2028029768OutlookMessageHeader" align="left">
<hr tabindex="-1">
<font size="2" face="Tahoma"><b>From:</b>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b>On Behalf Of
</b>Deepak R aj Awasthi<br><b>Sent:</b> Monday, January 23, 2012 3:29
AM<br><b>To:</b> Deepak R aj Awasthi; PostGIS Users
Discussion<br><b>Subject:</b> Re: [postgis-users] ST_MapAlgebraExpr()
Function<br></font><br></div>
<div style="background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; ">
<div><span>It means the POSTGIS I installed is the older one and it does not
support this function. Can I upgrade it having no problem with the present
data. If yes where can I get this version, I have searched the latest one but
unable to get it. </span></div>
<div><span><br></span></div>
<div><span>Thanks </span></div>
<div><span>Regards </span></div>
<div>Deepak</div>
<div style="font-size: 12pt; font-family: times, serif; ">
<div style="font-size: 12pt; font-family: times, serif; ">
<div dir="ltr"><font size="2" face="Arial">
<hr size="1">
<b><span style="FONT-WEIGHT:bold;">From:</span></b> Deepak R aj Awasthi
<deepakrajawasthi@yahoo.com><br><b><span style="FONT-WEIGHT:bold;">To:</span></b> PostGIS Users Discussion
<postgis-users@postgis.refractions.net> <br><b><span style="FONT-WEIGHT:bold;">Sent:</span></b> Monday, 23 January 2012,
9:24<br><b><span style="FONT-WEIGHT:bold;">Subject:</span></b> Re:
[postgis-users] ST_MapAlgebraExpr() Function<br></font></div><br>
<div id="yiv2028029768">
<div>
<div style="background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); font-size: 12pt; font-family: times, serif; ">
<div><span><font size="3">Thanks for suggestion, I have checked the date and it
is</font><font color="#0000ff" size="2" face="Arial"> "2011-10-06 08:02:01".
What could be other problem can you please.. </font></span></div>
<div style="font-size: 12pt; font-family: times, serif; "><br></div>
<div style="font-size: 12pt; font-family: times, serif; ">
<div style="font-size: 12pt; font-family: times, serif; ">
<div dir="ltr"><font size="2" face="Arial">
<hr size="1">
<b><span style="FONT-WEIGHT:bold;">From:</span></b> Paragon Corporation
<lr@pcorp.us><br><b><span style="FONT-WEIGHT:bold;">To:</span></b>
'PostGIS Users Discussion' <postgis-users@postgis.refractions.net>
<br><b><span style="FONT-WEIGHT:bold;">Sent:</span></b> Monday, 23 January
2012, 4:57<br><b><span style="FONT-WEIGHT:bold;">Subject:</span></b> Re:
[postgis-users] ST_MapAlgebraExpr() Function<br></font></div><br>
<div id="yiv2028029768">
<div>
<div dir="ltr" align="left"><span class="yiv2028029768-23012012"><font color="#0000ff" size="2" face="Arial">Hmm I meant 2012-01-01</font></span></div><br>
<blockquote style="BORDER-LEFT:#0000ff 2px solid;PADDING-LEFT:5px;MARGIN-LEFT:5px;MARGIN-RIGHT:0px;" dir="ltr">
<div dir="ltr" lang="en-us" class="yiv2028029768OutlookMessageHeader" align="left">
<hr tabindex="-1">
<font size="2" face="Tahoma"><b>From:</b>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b>On Behalf Of
</b>Paragon Corporation<br><b>Sent:</b> Sunday, January 22, 2012 10:48
PM<br><b>To:</b> 'PostGIS Users Discussion'<br><b>Subject:</b> Re:
[postgis-users] ST_MapAlgebraExpr() Function<br></font><br></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768-23012012">Just tried it on my latest build which is about
a week old (a little newer than the windows build currently on site but much
older than when this doc section was written). Works fine for
me.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768-23012012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768-23012012">Which version of PostGIS are you
using?</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768-23012012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768-23012012">Run this command:</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768-23012012"> select postgis_scripts_build_date(),
postgis_raster_lib_build_date();</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768-23012012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768-23012012">Make sure both return a value later than
2011-01-01</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768-23012012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768-23012012">Hope that helps,</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv2028029768-23012012">Regina</span></font></div><br>
<blockquote style="BORDER-LEFT:#0000ff 2px solid;PADDING-LEFT:5px;MARGIN-LEFT:5px;MARGIN-RIGHT:0px;" dir="ltr">
<div dir="ltr" lang="en-us" class="yiv2028029768OutlookMessageHeader" align="left">
<hr tabindex="-1">
<font size="2" face="Tahoma"><b>From:</b>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b>On Behalf Of
</b>Deepak R aj Awasthi<br><b>Sent:</b> Sunday, January 22, 2012 12:13
PM<br><b>To:</b> postgis-users@postgis.refractions.net<br><b>Subject:</b>
[postgis-users] ST_MapAlgebraExpr() Function<br></font><br></div>
<div style="background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); font-size: 12pt; font-family: times, serif; ">
<div>
<div><span style="font-size: 12pt; font-family: times, serif; ">Hello,</span><br></div>
<div style="FONT-SIZE:12pt;" class="yiv2028029768yui_3_2_0_22_132725134565854">
<div style="FONT-SIZE:12pt;" class="yiv2028029768yui_3_2_0_22_132725134565861">
<div id="yiv2028029768">
<div>
<div style="FONT-SIZE:12pt;" class="yiv2028029768yui_3_2_0_22_132725134565869">
<div style="font-size: 12pt; font-family: times, serif; " class="yiv2028029768yui_3_2_0_22_132725134565879">
<div style="FONT-SIZE:12pt;" class="yiv2028029768yui_3_2_0_22_132725134565881"><br>I am a M.Sc. student
and currently working with postgreSQL/PostGIS to handle raster.
I have installed PostgreSQl 9.0 and PostGIS 2.0 in
windows 7 home premium OS. I had no problem on
handling raster so far but now I got problem while accessing
ST_MapAlgebraExpr () function which takes two rasters as
function arguments. I have followed the example provided in the link
below as follows.</div>
<div style="FONT-SIZE:12pt;" class="yiv2028029768yui_3_2_0_22_132725134565881"><br></div>
<div style="FONT-SIZE:12pt;" class="yiv2028029768yui_3_2_0_22_132725134565881">First, I create the table
as given,</div>
<div style="FONT-SIZE:12pt;" class="yiv2028029768yui_3_2_0_22_132725134565881"><br></div>
<div style="FONT-SIZE:12pt;" class="yiv2028029768yui_3_2_0_22_132725134565881"><pre style="border-bottom-color: rgb(247, 147, 30); border-bottom-width: 2px; border-bottom-style: solid; border-left-color: rgb(247, 147, 30); border-left-width: 0px; border-left-style: solid; padding-bottom: 10px; line-height: 16px; margin-top: 10px; padding-left: 10px; padding-right: 10px; margin-bottom: 10px; color: rgb(46, 46, 46); font-size: 11px; border-top-color: rgb(247, 147, 30); border-top-width: 2px; border-top-style: solid; border-right-color: rgb(247, 147, 30); border-right-width: 0px; border-right-style: solid; padding-top: 10px; font-family: Courier, Monaco, monospace; " class="yiv2028029768programlisting">CREATE TABLE fun_shapes(rid serial PRIMARY KEY, fun_name text, rast raster);</pre>Then,
the second syntax to insert raster and finally the use of the function
ST_MapAlgebraExpr() as.</div>
<div style="FONT-SIZE:12pt;" class="yiv2028029768yui_3_2_0_22_132725134565881"><pre style="border-bottom-color: rgb(247, 147, 30); border-bottom-width: 2px; border-bottom-style: solid; border-left-color: rgb(247, 147, 30); border-left-width: 0px; border-left-style: solid; padding-bottom: 10px; line-height: 16px; margin-top: 10px; padding-left: 10px; padding-right: 10px; margin-bottom: 10px; color: rgb(46, 46, 46); font-size: 11px; border-top-color: rgb(247, 147, 30); border-top-width: 2px; border-top-style: solid; border-right-color: rgb(247, 147, 30); border-right-width: 0px; border-right-style: solid; padding-top: 10px; font-family: Courier, Monaco, monospace; " class="yiv2028029768programlisting">SELECT ST_MapAlgebraExpr(
area.rast, bub.rast, 'rast2', '8BUI', 'INTERSECTION', 'rast2', 'rast1') As interrast,
ST_MapAlgebraExpr(
area.rast, bub.rast, 'rast2', '8BUI', 'UNION', 'rast2', 'rast1') As unionrast
FROM
(SELECT rast FROM fun_shapes WHERE
fun_name = 'area') As area
CROSS JOIN (SELECT rast
FROM fun_shapes WHERE
fun_name = 'rand bubbles') As bub</pre></div>
<div style="FONT-SIZE:12pt;" class="yiv2028029768yui_3_2_0_22_132725134565881"><span style="FONT-SIZE:12pt;"></span><br> </div>
<div style="FONT-SIZE:12pt;" class="yiv2028029768yui_3_2_0_22_132725134565881"> <a rel="nofollow" target="_blank" href="http://postgis.refractions.net/documentation/manual-svn/RT_ST_MapAlgebraExpr2.html">http://postgis.refractions.net/documentation/manual-svn/RT_ST_MapAlgebraExpr2.html</a><br><br></div>
<div style="FONT-SIZE:12pt;" class="yiv2028029768yui_3_2_0_22_132725134565881">But I got error on using
this syntax as:<br><br>ERROR: function st_mapalgebraexpr(raster,
raster, unknown, unknown, unknown, unknown, unknown) does not
exist<br> LINE 58: SELECT
ST_MapAlgebraExpr()<br> HINT: No function matches
the given name and argument types. You might need to add explicit
type casts.<br><span style="FONT-SIZE:12pt;"><br></span></div>
<div style="FONT-SIZE:12pt;" class="yiv2028029768yui_3_2_0_22_132725134565881"><span style="FONT-SIZE:12pt;"> Although I am new to this database, I think
that there is problem with </span><span style="FONT-SIZE:12pt;"> PostGIS 2.0 to support the function. If this
the case which version I have </span><span style="FONT-SIZE:12pt;"> to install to use this function. Can anyone
provide me solution for it.</span></div>
<div style="FONT-SIZE:12pt;" class="yiv2028029768yui_3_2_0_22_132725134565881"><br> Thanks<br><br> With
Best
Regards,<br> Deepak<br><br></div></div></div></div></div></div></div></div></div></blockquote></blockquote></div></div><br>_______________________________________________<br>postgis-users
mailing list<br><a rel="nofollow" ymailto="mailto:postgis-users@postgis.refractions.net" target="_blank" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a rel="nofollow" target="_blank" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br><br></div></div></div></div></div><br>_______________________________________________<br>postgis-users
mailing list<br><a rel="nofollow" ymailto="mailto:postgis-users@postgis.refractions.net" target="_blank" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a rel="nofollow" target="_blank" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br><br></div></div></div></blockquote></div>
</div><br>_______________________________________________<br>postgis-users mailing list<br><a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br><br> </div> </div> </div></body></html>