[Qgis-user] PostGIS Queries

[Richard McDonnell]

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 at 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/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160718/d2cc944b/attachment.html>