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
