Feature request #3227

Load PostGIS layer only for current canvas extent

Added by Ivan Mincik over 6 years ago. Updated over 4 years ago.

Status:Open Start Date:
Priority:Low Due date:
Assigned to:J├╝rgen Fischer % Done:


Target version:Future Release - Nice to have
Platform:All Resolution:
Platform version: Pull Request or Patch supplied:No
Status info:0 Tag:


It would be nice to add spatial query to 'Add PostGIS Table Build query' dialog to limit loading layer features only to features intersected/contained by current map canvas extent (or possibly also extent of some other already loaded layer).

This feature is very useful when You have huge table and You want to work only with its small part. In case of huge table it will speed up dramatically loading time and You can profit also from some other benefits.

Currently I am doing this by using CopyPasta plugin > Map Extent SQL and placing it to 'Build query' dialog. This will limit loaded layer to my custom extent.

Thanks a lot

Related issues

duplicated by QGIS Application - Feature request #4006: Filter (on load) Postgis layers by canvas Bounding Box Closed 06/20/2011


Updated by Giovanni Manghi over 5 years ago

  • Target version changed from Version 1.7.0 to Version 1.7.4

Updated by Giovanni Manghi about 5 years ago

  • Pull Request or Patch supplied set to No

see also #4006

Updated by Giovanni Manghi almost 5 years ago

  • Target version changed from Version 1.7.4 to Version 2.0.0

Updated by Pirmin Kalberer over 4 years ago

  • Target version changed from Version 2.0.0 to Future Release - Nice to have

Also available in: Atom