[postgis-users] ST_MapAlgebraExpr() Function
Paragon Corporation
lr at pcorp.us
Wed Jan 25 14:43:37 PST 2012
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>
More information about the postgis-users
mailing list