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!
select ST_Value(rast, ST_Transform(ST_SetSRID(ST_Point(126.5, 37.5),
4326), ST_SRID(rast))) from srtm3 where ST_Intersects(rast, *1*,
ST_Transform(ST_SetSRID(ST_Point(126.5, 37.5), 4326), ST_SRID(rast)));
On 11/1/2011 2:20 PM, Bborie Park wrote:
On 11/01/2011 10:32 AM, elliott wrote:
No, I had not updated the sql functions. With that update, I am now
getting a different error:
select ST_Value(rast, ST_Transform(ST_SetSRID(ST_Point(126.5, 37.5),
4326), ST_SRID(rast))) from srtm3 where ST_Intersects(rast, 1,
ST_Transform(ST_SetSRID(ST_Point(126.5, 37.5), 4326), ST_SRID(rast)));
ERROR: function st_asraster(geometry, double precision, double
precision) is not unique at character 8
HINT: Could not choose a best candidate function. You might need to add
explicit type casts.
QUERY: SELECT ST_AsRaster(geom, scale, scale)
CONTEXT: PL/pgSQL function "_st_intersects" line 14 at assignment
SQL function "st_intersects" statement 1
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.
-bborie
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
