Thank you for your suggestion, I will try this!

On 16/07/2016 09:53, Bo Victor Thomsen wrote:
What about:

SELECT objectid FROM level_1_20151206 AS A, water_polygon AS Z WHERE ST_intersects (A.the_geom, Z.geom);

ST_intersects (and st_overlaps) automatically uses boundingbox calculations and spatial index

Regards
Bo Victor Thomsen
AestasGIS
Denmark


Den 15/07/16 kl. 15:15 skrev Richard McDonnell:
SELECT objectid
FROM
level_1_20151206 AS A, water_polygon AS Z
WHERE
(SELECT ST_Overlaps (A.the_geom, Z.geom));

_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

--
*_Richard McDonnell_*
*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543

OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past

***********************************************************
Email Disclaimer: http://www.opw.ie/en/disclaimer/

_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to