[postgis-users] ST_MapAlgebraExpr() Function

[Paragon Corporation]

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_MapAlgebraExpr
2.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




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120125/1503914f/attachment.html>