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

Reply via email to