<div dir="ltr"><div><div><p class="MsoNormal" style="background:none repeat scroll 0% 0% white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">Something like this?<br></span></p><p class="MsoNormal" style="background:none repeat scroll 0% 0% white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><br></span></p><p class="MsoNormal" style="background:none repeat scroll 0% 0% white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">SELECT  zone,gid,state,name,ST_Asgeojson( geom ) <br></span></p><p class="MsoNormal" style="background:none repeat scroll 0% 0% white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">FROM polys <br></span></p><p class="MsoNormal" style="background:none repeat scroll 0% 0% white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">WHERE ST_Overlaps(ST_GeomFromText('POLYGON((-109 42,-108 42, -108 43; -109 43, -109 42))', 4269), geom)=TRUE;</span></p></div><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><br><br></span></div><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">Cheers,<br>Rémi-C<br></span></div><div class="gmail_extra"><br><div class="gmail_quote">2014-11-18 9:00 GMT+01:00 Hugues François <span dir="ltr"><<a href="mailto:hugues.francois@irstea.fr" target="_blank">hugues.francois@irstea.fr</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div link="blue" vlink="purple" lang="FR"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hello,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-GB">Maybe I don’t understand your problem very well but I think your query for points should work with a polygon using ST_GeomFromText (<a href="http://www.postgis.org/docs/ST_GeomFromText.html" target="_blank">http://www.postgis.org/docs/ST_GeomFromText.html</a>) for your input polygon or a subquery if it stored into your DB.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-GB"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-GB">Hugues.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><div><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">De :</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>De la part de</b> Joseph Spenner<br><b>Envoyé :</b> lundi 17 novembre 2014 22:35<br><b>À :</b> PostGIS Users Discussion<br><b>Objet :</b> [postgis-users] Returning polygons if any of a polygon input points lie in the polygons<u></u><u></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">Hello, I'm trying to perform a query which will return any polygons which have any points in common with an input polygon.<u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><u></u> <u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">So, if I have Polygon A.<u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">In my database, I have several other polygons stored.<u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><u></u> <u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">I want to submit a query with Polygon A as the input, which will return all of the polygons in my database which have any points in common with Polygon A.<u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><u></u> <u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">Can this be done?<u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><br>I found this:<u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><a href="http://postgis.net/docs/ST_Overlaps.html" target="_blank">http://postgis.net/docs/ST_Overlaps.html</a><u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><u></u> <u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">But from what I can tell, it only returns a T or F.   I need to fetch the actual polygons if T.<u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><u></u> <u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">I'm currently able to query with points as input:<u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><u></u> <u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">select zone,gid,state,name,ST_Asgeojson( geom ) from polys where ST_Intersects(ST_PointFromText('POINT(-109 42)', 4269), geom);<u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><br><br><u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">But now I have a need to use polygons as input.<u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><br><br><u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">Any help would be great.<u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><br><br><u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">Thanks!<u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><u></u> <u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">Regards,<u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black">Joseph Spenner<u></u><u></u></span></p></div><div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><u></u> <u></u></span></p></div><p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"Garamond","serif";color:black"><u></u> <u></u></span></p></div></div></div><br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>