Hello List,<br><br>I'm trying to intersect a raster with a polygon and running into an error message that I don't understand. <br><br> SELECT<br> ST_SummaryStats(r.rast) as stats<br> FROM<br> new_york_r as r <br>
WHERE<br> ST_Intersects(r.rast, 'SRID=900913;POLYGON((-8239995.68240392 4974479.31918724,-8230242.31759608 4974479.31918724,-8230242.31759608 4979684.68081276,-8239995.68240392 4979684.68081276,-8239995.68240392 4974479.31918724))')<br>
<br>The error message is:<br><br>"ERROR: function st_intersects(raster, unknown) is not unique<br>LINE 6: ST_Intersects(r.rast, 'SRID=900913;POLYGON((-8239995.68240...<br> ^<br>HINT: Could not choose a best candidate function. You might need to add explicit type casts."<br>
<br>I am able to run a very similar query with ST_Intersects(r.rast, geom), where geom is from another table, and it runs fine. ST_Intersects(geom, 'SRID=900913;POLYGON((-823999.....)') also runs without a problem when geom is a vector.<br>
<br>Is there a step that I am missing here to run this intersection on a raster?<br><br>
I'm using PostGIS 2.0.0 SVN / Postgresql 9.1 on Windows 7. <br><br>Thanks,<br>David<br><br><br><br>