[Qgis-user] PostGIS Queries

[Bo Victor Thomsen]

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));