yes, that fixed it. Thank you!<br>-David<br><br><div class="gmail_quote">On Sat, Feb 4, 2012 at 9:05 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Your polygon is untyped so could cast to raster or geometry
thus ambiguous which function to use.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Try casting it first by changing your code
to:</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><font color="#000000" face="Times New Roman" size="3"><div class="im"> SELECT<br>ST_SummaryStats(r.rast) as
stats<br>FROM<br>new_york_r as r <br>WHERE<br></div>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))'::geometry)</font><br></font></span></div>
<div><span></span><font face="Arial"><font color="#0000ff"><font>Hope that helps,</font></font></font></div>
<div><span></span><span></span><font face="Arial"><font color="#0000ff"><font>R<span>egina</span></font></font></font></div>
<div><span></span><span></span><font face="Arial"><font color="#0000ff"><font><a href="http://www.postgis.us" target="_blank">h<span>ttp://www.postgis.us</span></a></font></font></font></div>
<div><font face="Arial"><font color="#0000ff"><font><span></span></font></font></font><br> </div>
<blockquote style="BORDER-LEFT:#0000ff 2px solid;PADDING-LEFT:5px;MARGIN-LEFT:5px;MARGIN-RIGHT:0px">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma"><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of
</b>David Quinn<br><b>Sent:</b> Saturday, February 04, 2012 7:51
PM<br><b>To:</b> <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br><b>Subject:</b>
[postgis-users] Problem with raster/polygon intersection<br></font><br></div><div><div class="h5">
<div></div>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></div></div></blockquote></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br>