<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I believe my query was incorrect with an "extra" parameter for the
ST_Intersects call. Without the extra parameter, the query works just
fine now. Thanks for your help!<br>
<br>
select ST_Value(rast, ST_Transform(ST_SetSRID(ST_Point(126.5, 37.5),
<br>
4326), ST_SRID(rast))) from srtm3 where ST_Intersects(rast, <b><big>1</big></b>,
<br>
ST_Transform(ST_SetSRID(ST_Point(126.5, 37.5), 4326), ST_SRID(rast)));
<br>
<br>
On 11/1/2011 2:20 PM, Bborie Park wrote:
<blockquote cite="mid:4EB0385C.8040803@ucdavis.edu" type="cite">On
11/01/2011 10:32 AM, elliott wrote:
<br>
<blockquote type="cite">No, I had not updated the sql functions. With
that update, I am now
<br>
getting a different error:
<br>
<br>
select ST_Value(rast, ST_Transform(ST_SetSRID(ST_Point(126.5, 37.5),
<br>
4326), ST_SRID(rast))) from srtm3 where ST_Intersects(rast, 1,
<br>
ST_Transform(ST_SetSRID(ST_Point(126.5, 37.5), 4326), ST_SRID(rast)));
<br>
ERROR: function st_asraster(geometry, double precision, double
<br>
precision) is not unique at character 8
<br>
HINT: Could not choose a best candidate function. You might need to add
<br>
explicit type casts.
<br>
QUERY: SELECT ST_AsRaster(geom, scale, scale)
<br>
CONTEXT: PL/pgSQL function "_st_intersects" line 14 at assignment
<br>
SQL function "st_intersects" statement 1
<br>
<br>
</blockquote>
<br>
Interesting. Can you try r8077? I've made a tweak that should
eliminate the error. What version of PostgreSQL are you running? I
haven't seen this error with 8.4, 9.0 or 9.1 in Linux.
<br>
<br>
-bborie
<br>
<br>
</blockquote>
<br>
</body>
</html>