<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Thank you for your suggestion, I will try this!<br>
<br>
<br>
<div class="moz-cite-prefix">On 16/07/2016 09:53, Bo Victor Thomsen
wrote:<br>
</div>
<blockquote
cite="mid:2a4a93ba-9c48-ff60-d220-7d0a267f470a@gmail.com"
type="cite">What about:
<br>
<br>
SELECT objectid FROM level_1_20151206 AS A, water_polygon AS Z
WHERE ST_intersects (A.the_geom, Z.geom);
<br>
<br>
ST_intersects (and st_overlaps) automatically uses boundingbox
calculations and spatial index
<br>
<br>
Regards
<br>
Bo Victor Thomsen
<br>
AestasGIS
<br>
Denmark
<br>
<br>
<br>
Den 15/07/16 kl. 15:15 skrev Richard McDonnell:
<br>
<blockquote type="cite">SELECT objectid
<br>
FROM
<br>
level_1_20151206 AS A, water_polygon AS Z
<br>
WHERE
<br>
(SELECT ST_Overlaps (A.the_geom, Z.geom));
<br>
</blockquote>
<br>
_______________________________________________
<br>
Qgis-user mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<br>
List info: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br>
Unsubscribe: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<b><u>Richard McDonnell</u></b><br>
<b><small><small><small>GIS Specialist PgD GIS AssocSCSI</small></small></small></b><br>
<b><small>OPW FRM Data Management</small></b><br>
<b><small>52 Stephens Green, Dublin 2.</small></b><br>
<small><small>TEL: 01 6476543</small></small></div>
<!-- http://www.unicodetools.com/unicode/convert-to-html.php -->
<div style="font-family: Arial; font-size: 8pt;">
OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart<br/>
OPW - Looking to the future - Caring for the past<br/>
<a href="http://www.opw.ie/"><img height="76" width="494" src="http://www.opw.ie/en/media/opw-email-banner.png"/></a><br/>
Email Disclaimer: <a href="http://www.opw.ie/en/disclaimer/">http://www.opw.ie/en/disclaimer/</a>
</div>
</body>
</html>