<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><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 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> 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="yiv312878869"><div><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "><div style=""><span><font size="3">Thanks for suggestion, I have checked the date and it is</font><font color="#0000ff" face="Arial" size="2"> "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="yiv312878869">
<div>
<div dir="ltr" align="left"><span class="yiv312878869-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="yiv312878869OutlookMessageHeader" 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="yiv312878869-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="yiv312878869-23012012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv312878869-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="yiv312878869-23012012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv312878869-23012012">Run this command:</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv312878869-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="yiv312878869-23012012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv312878869-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="yiv312878869-23012012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv312878869-23012012">Hope that helps,</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="yiv312878869-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="yiv312878869OutlookMessageHeader" 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="yiv312878869yui_3_2_0_22_132725134565854">
<div style="FONT-SIZE:12pt;" class="yiv312878869yui_3_2_0_22_132725134565861">
<div id="yiv312878869">
<div>
<div style="FONT-SIZE:12pt;" class="yiv312878869yui_3_2_0_22_132725134565869">
<div style="font-size: 12pt; font-family: times, serif; " class="yiv312878869yui_3_2_0_22_132725134565879">
<div style="FONT-SIZE:12pt;" class="yiv312878869yui_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="yiv312878869yui_3_2_0_22_132725134565881"><br></div>
<div style="FONT-SIZE:12pt;" class="yiv312878869yui_3_2_0_22_132725134565881">First, I
create the table as given,</div>
<div style="FONT-SIZE:12pt;" class="yiv312878869yui_3_2_0_22_132725134565881"><br></div>
<div style="FONT-SIZE:12pt;" class="yiv312878869yui_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="yiv312878869programlisting">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="yiv312878869yui_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="yiv312878869programlisting">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="yiv312878869yui_3_2_0_22_132725134565881"><span style="FONT-SIZE:12pt;"></span><br> </div>
<div style="FONT-SIZE:12pt;" class="yiv312878869yui_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="yiv312878869yui_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="yiv312878869yui_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="yiv312878869yui_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 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>