[postgis-users] ST_MapAlgebraExpr() Function

[Deepak R aj Awasthi]

Thanks a lot yes I did the same now it work..


________________________________
 From: Paragon Corporation <lr at pcorp.us>
To: 'PostGIS Users Discussion' <postgis-users at postgis.refractions.net> 
Sent: Wednesday, 25 January 2012, 23:43
Subject: Re: [postgis-users] ST_MapAlgebraExpr() Function
 

Deepak,
 
Yes you can upgrage.  If you are running 
2011-10-06 I think you should be able to get the latest function 
by
 
1) download the latest experimental 
build
2) overwrite your binaries
3) run the postgis_upgrade_20_minor.sql and the 
rtpostgis_upgrade_20_minor.sql files located in the 
share/contrib/postgis-2.0 folder of the zip you 
downloaded.
 
Hope that helps,
Regina
http://www.postgis.us
 


>________________________________
> From: postgis-users-bounces at postgis.refractions.net  [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Deepak R aj Awasthi
>Sent: Monday, January 23, 2012 3:29  AM
>To: Deepak R aj Awasthi; PostGIS Users  Discussion
>Subject: Re: [postgis-users] ST_MapAlgebraExpr()  Function
>
>
>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. 
>
>
>Thanks 
>Regards 
>Deepak
>
>________________________________
> From: Deepak R aj Awasthi  <deepakrajawasthi at yahoo.com>
>To: PostGIS Users Discussion  <postgis-users at postgis.refractions.net> 
>Sent: Monday, 23 January 2012,  9:24
>Subject: Re:  [postgis-users] ST_MapAlgebraExpr() Function
>
>
>Thanks for suggestion, I have checked the date and it  is "2011-10-06 08:02:01".   What could be other problem can you please.. 
>
>
>
>________________________________
> From: Paragon Corporation  <lr at pcorp.us>
>To: 'PostGIS Users Discussion' <postgis-users at postgis.refractions.net> 
>Sent: Monday, 23 January  2012, 4:57
>Subject: Re:  [postgis-users] ST_MapAlgebraExpr() Function
>
>
>Hmm I meant 2012-01-01
>
>
>>________________________________
>> From: postgis-users-bounces at postgis.refractions.net  [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paragon Corporation
>>Sent: Sunday, January 22, 2012 10:48  PM
>>To: 'PostGIS Users Discussion'
>>Subject: Re:  [postgis-users] ST_MapAlgebraExpr() Function
>>
>>
>>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.
>> 
>>Which version of PostGIS are you  using?
>> 
>>Run this command:
>> select postgis_scripts_build_date(),  postgis_raster_lib_build_date();
>> 
>>Make sure both return a value later than  2011-01-01
>> 
>>Hope that helps,
>>Regina
>>
>>
>>>________________________________
>>> From: postgis-users-bounces at postgis.refractions.net  [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Deepak R aj Awasthi
>>>Sent: Sunday, January 22, 2012 12:13  PM
>>>To: postgis-users at postgis.refractions.net
>>>Subject: [postgis-users] ST_MapAlgebraExpr() Function
>>>
>>>
>>>Hello,
>>>
>>>
>>>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.
>>>
>>>
>>>First, I create the table  as given,
>>>
>>>
>>>CREATE TABLE fun_shapes(rid serial PRIMARY KEY, fun_name text, rast raster);Then,  the second syntax to insert raster and finally the use of the function  ST_MapAlgebraExpr()  as.
>>>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
>>>
>>> 
>>> http://postgis.refractions.net/documentation/manual-svn/RT_ST_MapAlgebraExpr2.html
>>>
>>>
>>>But I got error on using  this syntax as:
>>>
>>>ERROR:  function st_mapalgebraexpr(raster, 
      raster, unknown, unknown,  unknown, unknown, unknown) does not 
      exist
>>> LINE 58: SELECT 
       ST_MapAlgebraExpr()
>>>  HINT:  No function matches 
      the given name and argument types. You might need to add explicit 
      type casts.
>>>
>>>
>>> Although I am new to this database, I think  that there is problem with  PostGIS 2.0 to support the function. If this  the case which version I have  to install to use this function. Can anyone  provide me solution for it.
>>>
>>> Thanks
>>>
>>> With 
      Best 
      Regards,
>>> Deepak
>>>
>>>
>_______________________________________________
>postgis-users 
  mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>_______________________________________________
>postgis-users 
  mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120125/d465278a/attachment.html>