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: [email protected] [mailto:[email protected]] 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 <[email protected]> To: PostGIS Users Discussion <[email protected]> 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 <[email protected]> To: 'PostGIS Users Discussion' <[email protected]> Sent: Monday, 23 January 2012, 4:57 Subject: Re: [postgis-users] ST_MapAlgebraExpr() Function Hmm I meant 2012-01-01 _____ From: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] On Behalf Of Deepak R aj Awasthi Sent: Sunday, January 22, 2012 12:13 PM To: [email protected] 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
